Useful Diagnostics Commands

WARNING 1 - SOME OF THESE COMMANDS SHOULD ONLY BE RUN WITH AGREEMENT FROM ORACLE SUPPORT
WARNING 2 - SOME OF THESE COMMANDS WIL IMPACT THE PERFORMANCE OF YOUR DATABASE

Please pay attention to the warnings above.

Dumping the Library Cache

alter system set events 'immediate trace name library_cache level 10'

This will produce a dump file in UDUMP.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License