How to drop all indexes in a SCHEMA –Login as the schema user whose indexes you want to drop SQL>set…
The final answer to the age old debate of count(*) vs count(1).Absolute proof that count(*) is faster than count(1). sql->alter…
Before creating a Dataguard setup, one of the prerequisite is to calculate the additional network bandwidth required for shipping the…
By Uwe Hesse Link to original post: http://uhesse.wordpress.com/oracle-database-ha-architecture/ A very popular topic in many of my courses is Oracle Database…
Transportable Tablespace across Different Platforms ___________________________________________________ In our example we will transport a tablespace called TEST. The tablespace should be…
1. Start session trace To start a SQL trace for the current session, execute: ALTER SESSION SET sql_trace = true;…
Index Re-building is a debatable concept amongst DBA’s. Experts like Ask Tom think rebuilding indexes doesn’t create any considerable performance…
1. Copy the backup of the dumpfile to the target server. 2. Create a tablespace in our eg: called TEST.…
Well, most of the oracle DBAs are very much interested in learning Oracle Applications 11i or R12. For that, we…