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…
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…