How the query optimizer chooses the a specific plan to execute SQL? A SQL Statement executes in multiple ways,such as […]
In-Place Upgrade This feature enables you to upgrade an existing installation of Oracle database to Oracle Database 11g Release 2 (11.2.0.4) […]
An RMAN channel represents one stream of data to a device type and corresponds to one server session. Allocation of one or […]
Understanding RMAN Level 0 and Level 1 Backups in Database Administration – Learn what happens when you skip RMAN Level 0 and move to Level 1. Get insights for your DBA interview.
Learn how to rollback patching
Will configure rman , ..
A very large database may divide the DBA duties among several specialists..
The view V$RMAN_BACKUP_JOB_DETAILS contains information about backup jobs run by RMAN. This view contains information such as the time taken […]
Use the PURGE statement to remove a table or index from your recycle bin and release all of the space associated with the object, or to remove the entire recycle bin, or to remove part of all of a dropped tablespace from the recycle bin.
Oracle Exadata Cloud service Hybrid Cloud,multi cloud with private cloud Oracle Exadata Cloud Service delivers the world’s most advanced database […]