Latest Answer : Locally Managed Tablespaces Include the following Benefits:1.Free extents are managed in the Tablespace.2.Bitmap is used to record free extents.3.Each bit corresponds to a block or a group of block.4.Bit value indicates free or used. ...
What is the command used for monitoring a index on a table to find out whether it has been used by an execution plan?
What is the command issued by the DBA to protect the primary database against data loss and data divergence?
What are the sequences of steps performed to process a request for a server process in the Oracle Shared Server architecture?
Where does the script written using RMAN command gets stored and how to display the commands used in the script?
How can one check whether the RMAN repository information is synchronized with the actual files that exist on disk?
What is the type of recover used to recover an archived log that is lost or corrupted in the process of performing media recovery?
Latest Answer : 1. shutdown (server waits until all transaction commit + wait until all sessions close)2. shutdown transaction (servers commit transaction + disconnect the users sessions)3. shutdown immediate (servers uncommit all transaction + rollback ...
Latest Answer : pmon is process monitor and its one of the oracle backgroup process1. Cleans up failed database connections. 2. Dynamic registering database services name to listener ...
