Tag Archives: dump

Dump interesting information about Oracle files

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