Hello Geeks, I have been a part of quite a few WhatsApp and Social platforms like Facebook and Twitter and have seen people asking many doubts. Keeping this in mind, I have created this forum and here is how you can make the most use of it. How to work with the forum page in …
An Oracle DBA use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery. In this post, we will discuss the skills that one must attain to become a Database Administrator. How to become an Oracle …
How to become an Oracle DBA – step by step guide Read More »
In this post, we are going to learn everything about OSWatcher. we are going to learn about how to install OSWatcher, how to start OSWatcher, how to stop OSWatcher and How to analyze OSWatcher logs. What is OSWatcher and what does it do? OSWatcher (oswbb) is a collection of UNIX shell scripts intended to collect …
All you need to know about OSWatcher Black Box (OSWbb) Read More »
In this multipart dba scripts post , we are going to learn the important scripts that a DBA should know in order to do the day to day database administration. This post in entirely dedicated to aud$. 7. what is AUD$ in Oracle Database 11g The data dictionary of every Oracle database has a table named …
In this multipart dba scripts post , we are going to learn the important scripts that a DBA should know in order to do the day to day database administration. I have not ordered these scripts based on the practicality or priority, so some of the scripts may be too basic to know. 1. How to …
Job Description Senior Principal Consultant – Senior Database Administrator-1800094W No Visa Sponsorship is available for this position. Preferred Qualifications Minimum requirement: US Citizen with an active TS clearance with Full Scope About the role: The Oracle National Security Group is seeking consultants, passionate about software development, who can support a number of exciting internal Oracle …
General Background Processes. Acronym Process Name Description SMON System Monitor Process Performs recovery after instance failure and monitors temporary segments and extents. PMON Process Monitor Recovers failed process resources. If Shared Server architecture is used, PMON monitors and restarts any failed dispatcher or server processes. LGWR Log Writer Process Writes the log buffer out to …
Oracle Database Background Processes Cheat Sheet Read More »
In this post we are going to learn Oracle RAC interview questions, This post will be updated constantly, so please do check this post often. Explain the steps involved in RAC Software and Database creation? Install the same version of operating system in all the nodes. Create required no.of groups and oracle user accounts. Create required …
Important Oracle DBA interview questions 1. Explain the steps involved in executing a data manipulation language (DML) statements? The server process receives the statement and checks the library cache for any shared SQL area that contains a similar SQL statement. If a shared SQL area is found, the server process checks the user’s access privileges …
We got the below error in one of our physical standby databases today. ORA-10567: Redo is inconsistent with data block [adrotate banner=”1″] Problem Description : ORA-00600: internal error code, arguments: [3020], [4], [2], [16777218], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset …