ReliDB

ReliDB

Oracle tips and tricks.

ReliDB RSS Feed
 
 
 
 

Posts tagged startup

Oracle - Determining the top session wait events since instance startup

The Oracle RDBMS provides the use of the following view to determine most costly wait events since instance startup: V$SESSION_WAIT_HISTORY. This view can be used to determine possible problem areas in the database. This article covers how to determine the top wait events in the Oracle database since system startup. This procedure [...]

Posted on January 26th, 2010 under 11g, Oracle, Oracle 10g, oracle 9i. Tags: , , , , , , , . Comments: None

Taking an Oracle database out of a multi-Node RAC

I have found during some administrative tasks it is easier to have your system in single NODE configuration. An example of this, would be physical changes the database structure that due not include binary upgrades such as a CPU patch. It is easier to startup, shutdown, and restrict access thorough single stand alone [...]

Posted on September 3rd, 2009 under Oracle 10g, RAC, SQL. Tags: , , , , , , , . Comments: 2