dump_system


alter session set max_dump_file_size = unlimited;

-- Dump the system state
-- NOTE: Take 3 successive SYSTEMSTATE dumps, with 10 minute intervals
alter session set events 'immediate trace name SYSTEMSTATE level 10'
/

-- Dump control file contents
alter session set events 'immediate trace name CONTROLF level 10'
/
-- Dump file headers
alter session set events 'immediate trace name FILE_HDRS level 10'
/
-- Dump redo log headers
alter session set events 'immediate trace name REDOHDR level 10'
/
-- Dump the process state
alter session set events 'immediate trace name PROCESSSTATE level 10'
/
-- Dump Library Cache details
alter session set events 'immediate trace name library_cache level 10'
/
-- Dump optimizer statistics whenever a SQL statement is parsed (hint: change statement or flush pool)
alter session set events '10053 trace name context forever, level 1'
/
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: