1
describes Oracle utility called oradebug.pdf
免费下载
ORADEBUG - UNDOCUMENTED ORACLE UTILITY
By
Miladin Modrakovic
rankoni@hotmail.com
Introduction
This document describes Oracle utility called oradebug. This tool is primarily used by Oracle
worldwide customer support .With oradebug utility you can literally see the database engine. The
oradebug is especially useful when things go very bad - e.g. the database just stops, hangs, or the
database keeps crashing with the ORA-0600 error! To run this tool you must have administrator
privileges.
Among the many useful things that can be done with oradebug are:
- enabling/disabling the SQL tracing for another user's session.
- suspending intensive processes
- finding information about shared memory and semaphores
- closing the trace file so that new one can be generated
- manipulating and dumping internal structures
- wake up processes etc.
Oradebug Commands
The oradebug utility consists of the following commands:
HELP [command] Describe one or all commands
SETMYPID Debug current process
SETOSPID <ospid> Set OS pid of process to debug
SETORAPID <orapid> ['force'] Set Oracle pid of process to debug
DUMP <dump_name> <lvl> [addr] Invoke named dump
DUMPSGA [bytes] Dump fixed SGA
DUMPLIST Print a list of available dumps
EVENT <text> Set trace event in process
SESSION_EVENT <text> Set trace event in session
DUMPVAR <p|s|uga> <name> [level] Print/dump a fixed PGA/SGA/UGA variable
SETVAR <p|s|uga> <name> <value> Modify a fixed PGA/SGA/UGA variable
PEEK <addr> <len> [level] Print/Dump memory
POKE <addr> <len> <value> Modify memory
WAKEUP <orapid> Wake up Oracle process
SUSPEND Suspend execution
RESUME Resume execution
FLUSH Flush pending writes to trace file
CLOSE_TRACE Close trace file
TRACEFILE_NAME Get name of trace file
LKDEBUG Invoke global enqueue service debugger
NSDBX Invoke CGS name-service debugger
-G <Inst-List | def | all> Parallel oradebug command prefix
-R <Inst-List | def | all> Parallel oradebug prefix (return output
SETINST <instance# .. | all> Set instance list in double quotes
SGATOFILE <SGA dump dir> Dump SGA to file; dirname in double quotes
DMPCOWSGA <SGA dump dir> Dump & map SGA as COW; dirname in double quotes
MAPCOWSGA <SGA dump dir> Map SGA as COW; dirname in double quotes
HANGANALYZE [level] Analyze system hang
FFBEGIN Flash Freeze the Instance
FFDEREGISTER FF deregister instance from cluster
FFTERMINST Call exit and terminate instance
FFRESUMEINST Resume the flash frozen instance
FFSTATUS Flash freeze status of instance
SKDSTTPCS <ifname> <ofname> Helps translate PCs to names
WATCH <address> <len> <self|exist|all|target> Watch a region of memory
DELETE <local|global|target> watchpoint <id> Delete a watchpoint
SHOW <local|global|target> watchpoints Show watchpoints
CORE Dump core without crashing process
IPC Dump ipc information
UNLIMIT Unlimit the size of the trace file
PROCSTAT Dump process statistics
CALL <func> [arg1] ... [argn] Invoke function with arguments
oradebug help
Describe one or all debug commands available for use.
Syntax Parameter
oradebug help < command name >
<command name > name of the debug command
If left alone oradebug help will list all debug commands.
Example
SQL> oradebug help show
SHOW <local|global|target> watchpoints Show watchpoints
oradebug setmypid
Debug current process.
Syntax Parameter
oradebug setmypid None
of 26
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论