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...
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...
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?...
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...
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...