Data mining option is enabled by default during installation of Oracle database. However you can verify the settings, enable and…
Kill the hung RMAN session if stuck in Oracle
It is very easy to monitor RMAN backup status and see the log file if you have redirected RMAN output…
Frequently accessed tables should be kept in Oracle Keep cache buffer pool. Keep buffer pool is the part of SGA…
Sometime SQL queries takes long time to complete. You can check long running sessions using v$session_longops script which will show…
Remotely you can access any Linux server using putty but to open gui tools like DBCA you need to configure…
In this article you will learn how delete statement works in oracle architecture. To understand execution of delete query internally,…
LsInventorySession failed: OPatch failed to locate Central Inventory. The Central Inventory is corrupted or oraInst.loc file specified is not valid…
Tuning slow running query in Oracle is one of the most challenging tasks for the DBA. When you run SQL…
Most of the time you will get CheckActiveFilesAndExecutables failed error while applying the PSU Patch in Oracle. It is because…