 |
|
Oracle
Tips by Burleson |
Using DUMP
The DUMP command allows various structures of a process to be dumped
to trace file for examination. The types of dump available for a
process are listed in Figure 5. These can be listed at anytime by
using the oradebug dumplist command.
EVENTS
TRACE_BUFFER_ON
TRACE_BUFFER_OFF
HANGANALYZE
LATCHES
PROCESSSTATE
SYSTEMSTATE
INSTANTIATIONSTATE
REFRESH_OS_STATS
CROSSIC *
CONTEXTAREA
HEAPDUMP
HEAPDUMP_ADDR
POKE_ADDRESS *
POKE_LENGTH *
POKE_VALUE *
POKE_VALUE0 *
GLOBAL_AREA
MEMORY_LOG
REALFREEDUMP
ERRORSTACK
HANGANALYZE_PROC
TEST_STACK_DUMP
BG_MESSAGES
ENQUEUES
SIMULATE_EOV
KSFQP_LIMIT
KSKDUMPTRACE
DBSCHEDULER
GRANULELIST
GRANULELISTCHK
SCOREBOARD
GES_STATE
ADJUST_SCN
NEXT_SCN_WRAP
CONTROLF
FULL_DUMPS
BUFFERS
RECOVERY *
SET_TSN_P1 *
BUFFER
PIN_BLOCKS *
BC_SANITY_CHECK
FLUSH_CACHE *
LOGHIST *
ARCHIVE_ERROR
REDOHDR
LOGERROR
OPEN_FILES *
DATA_ERR_ON *
DATA_ERR_OFF *
TR_SET_BLOCK *
TR_SET_ALL_BLOCKS *
TR_SET_SIDE *
TR_CRASH_AFTER_WRITE *
TR_READ_ONE_SIDE *
TR_CORRUPT_ONE_SIDE *
TR_RESET_NORMAL *
TEST_DB_ROBUSTNESS
LOCKS
GC_ELEMENTS
FILE_HDRS
KRB_CORRUPT_INTERVAL
KRB_CORRUPT_SIZE
KRB_PIECE_FAIL
KRB_OPTIONS
KRB_SIMULATE_NODE_AFFINITY
KRB_TRACE
KRB_BSET_DAYS
DROP_SEGMENTS *
TREEDUMP <OBJ_ID>
LONGF_CREATE
ROW_CACHE
LIBRARY_CACHE
SHARED_SERVER_STATE
KXFPCLEARSTATS
KXFPDUMPTRACE
KXFPBLATCHTEST
KXFXSLAVESTATE
KXFXCURSORSTATE <cursor_id>
WORKAREATAB_DUMP
OBJECT_CACHE *
SAVEPOINTS *
(* Indicates special arguments required)
All dump options take the standard LEVEL arguments 2, 4, 6, 8, 10,
12 except as noted.
This is a book excerpt from:
Using the
Oracle oradebug Utility
Debugging Oracle Applications
Mike Ault
ISBN: 0-9740716-7-6
http://www.rampant-books.com/ebook_oradebug.htm
|
