Tag Archives: events

Dump interesting information about Oracle files

Posted on May 16, 2011 by marcel

Here are some useful statements for generating trace files in your udump directory about various important Oracle files: Get a dump of your controlfiles: ALTER SESSION SET EVENTS ‘IMMEDIATE TRACE NAME CONTROLF LEVEL 10’; Dump the headers for all your … Continue reading →

Posted in Database | Tagged , , , , , , , , | Leave a comment