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 »
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 …
What are the components of the physical database structure of Oracle database? Three fundamental types of physical files make up an Oracle database: Control files. Datafiles. Redo log files. What are the components of the logical database structure of Oracle database? The logical structure of Oracle database consists of tablespaces and schema objects. What is …
10 Oracle DBA interview questions you should know Read More »