Dedicated to Gwen Shapira It’s a tale of woe and malice, a tale of a DBA That the users learned…
Category Database
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…
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.…
A database link creates a connection between a local database and a remote database. You might want to create a…
The database does not startup, and gives errors like: ORA-38737: Expected sequence number 2483 doesn’t match 2304 ORA-38701: Flashback database…
The Complex Oracle Data Guard in less than 15 easy steps. Create a physical standby database in less than an…
Sometimes when your running an Oracle database, it becomes necessary to automate some tasks like cleaning your archivelogs. Since in…
How to change the Size of the Redo Log files to improve the log switch frequency in Oracle database. select…
Purpose of this parameter found in sqlnet.ora file: Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If…
—– Procedure to import table from production system to test system —— 1. Copy the backup(dump) of schema onto /backup_restor_only…
####PSU patching, interim patches ##### Sometimes before moving to a new 10.2.0.* version there are CPU patches released on a…
How to backup the Oracle Control File? There are two approaches: you either generate a binary image of the Control…