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…
You can use Linux Nohup command to run any sqlplus command or shell script in background. Usually when a shell…
In this article we will discuss about avoiding index maintenance and insert data faster into the table. Index maintenance is…
SQL*Loader-700: Out of memory while performing essential allocations [7] and unable To Load Using Direct Sqlldr Path Option SQL*Loader-700 are…
Temporary tablespaces often referred as Temp tablespace in Oracle are used for sorting operations and can grow huge in size.…
In this article you will learn how to set, change , recover and reset forgotten MySQL root passwords. Many times…
In order to drill down database performance issue like top memory, I/O and CPU consumers, you need to check SID…