The following INIT.ORA/SPFILE parameter can be used if your current redologs are corrupted or blown away. It may also be…
UPGRADE ORACLE 10.2.0.1 TO 10.2.0.4 WINDOWS SERVER 2003 32-BIT ————————————————————— 1. CHECK FOR TIMZEZONE INFORMATION USING FOLLOWING SQL QUERY SELECT…
*** I would like to update this post since this is one of the most frequently accessed pages on my blog.…
Directions :: First do gunzip then cpio of the file you downloaded from oracle.com 1. Run “gunzip <filename>” on all…
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…