O'Reilly logo

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Dumps from SQL

Many of the oradebug commands to dump structures are also available from SQL*Plus, sometimes with options to refine or restrict the content of the dump. Many of the dumps shown in the previous section can be done with a call to alter session, or to the package dbms_system. Then there are further dumps that you can get through alter system calls.

oradebug Alternatives

If you don't want to use oradebug, the following, as a representative sample, is how you can dump the buffer cache from an ordinary SQL*Plus session:

alter session set tracefile_identifier = 'alter_session'; execute dbms_system.ksdwrt(1,'Example using alter session') alter session set events 'immediate trace name buffers level 1';

I usually try to dump some text ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required