Steps to kill Database Process from Unix OS

1.       Identify the sid of the session using v$session view and where clause like user_name, program and machine etc. Sql> selec...

OS versions and minimum levels Supported by Oracle 11.2 RDBMS

Asianux 3 SP2 and higher Oracle Linux 4 Update 7 and higher Oracle Linux 5 Update 2 and higher Red Hat compatible Kernel Update...

Rebuild Index Online Hang after CTRL-C Many time was hit

We have 3 node Oracle 11.2.0.2 RAC setup on SUSE Linux Enterprise Server 10 SP4 (x86_64).  While executing index rebuild script &qu...

'enq: RO - fast object reuse' contention Slow Truncate

I have Database Management Software Oracle 10.2.0.4 installed on RHEL 4 Server. In one of Database  " Truncate Table"  is use...