Friday, August 29, 2014

Login storm against database caused exhausted library cache

›
One of our databases experienced massive contention in the shared pool, in form of wait events alerted as "library cache locks". ...
1 comment:
Thursday, August 28, 2014

How to use the case statement in a shell script, with case-insensitive input

›
Use the pipe (|) character for each possible case: echo "TABLESPACE REPORT FOR $ORACLE_SID" stty echo echo "All tablesp...
Tuesday, August 26, 2014

How to find the SID, serial# and their operating system process ID from the database

›
A simple statement to find the SID, serial# and their operating system process ID from the database: SET LINES 300 PAGES 300 SET TRIMSPOOL...

What is the meaning of the "10G 11G" value in DBA_USERS.PASSWORD_VERSIONS?

›
When the value of DBA_USERS.PASSWORD_VERSIONS is shown as "10G 11G", it means that both old and new-style hash values are availabl...
Monday, August 25, 2014

How to use trace event 10046

›
ALTER SESSION SET max_dump_file_size = unlimited; ALTER SESSION SET tracefile_identifier = 'normal_run_with_trace_10046'; ALTER SES...
Friday, August 1, 2014

Why are there multiple rows in V$SESSION_LONGOPS when running an RMAN backup?

›
Answer: When performing an RMAN backup, V$SESSION_LONGOPS will be populated with two types of rows: Detailed rows : Captures the progress...
Tuesday, July 15, 2014

What is the difference between the columns PID and SPID in v$process?

›
The PID column is an internal counter that oracle uses for its own processes. It is incremented by one for every new process. Consequently, ...