UNIX Commands for DBAs Basic File Navigation The “pwd” command displays the current directory: root> pwd /u01/app/oracle/product/9.2.0.1.0 The “ls” command…
Database Architecture In Oracle, a database refers to the entire Oracle RDBMS environment and includes the following components: • Oracle…
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…