\u00a0oradebug iutility s especially useful when\u00a0 things go very bad for example Database hangs,Due to ORA-00600 error your database is crashing frequently, Database just not responding (stop). With oradebug you can\u00a0see very close view database engine. Oracle Customer support use the utility mainly to debug these issues. You should have sysdba privilege to run this utility.<\/p>\n
\u00a0Main usage of this utility’s are :<\/p>\n
– Suspension of intensive processes<\/p>\n
– To find out information of shared memory and semaphores<\/p>\n
– Wake up\u00a0processeses<\/p>\n
– enable or disable the SQL traces for another user’s session<\/p>\n
–\u00a0 closing of trace file to allow new one can be genrated<\/p>\n
– Interanal structure manipulation and dumping<\/p>\n
\u00a0oradebug commands:<\/p>\n
\u00a01) oradebug help<\/p>\n
oradebug help <command name><\/p>\n
without command name argument all commands will be displayed<\/p>\n
2)\u00a0 Debug current process<\/p>\n
oradebug setmypid<\/p>\n
\u00a03) Set OS process id of process\u00a0 to debug<\/p>\n
oradebug setospid <ospid><\/p>\n
4)\u00a0 Set Oracle pid of process to debug:<\/p>\n
\u00a0oradebug setorapid <orapid> [‘force’]<\/p>\n
Force :Force process<\/p>\n
5) For Various Dumps<\/p>\n
\u00a0oradebug dump<\/p>\n
\u00a06) Set trace event in process<\/p>\n
oradebug event <text><\/p>\n
text => event name<\/p>\n
7) Set trace\u00a0event in session<\/p>\n
\u00a0oradebug session_event <text><\/p>\n
text => event_name<\/p>\n
8)\u00a0Print\/Dump a fixed PGA\/SGA\/UGA variable<\/p>\n
oradebug dumpvar <pls|uga> <name>\u00a0[level]<\/p>\n
plsuga => PGA\/SGA\/UGA<\/p>\n
name=>\u00a0variable name<\/p>\n
level=> Level<\/p>\n
9) Modify a fixed PGA\/SGA\/UGA\u00a0variable<\/p>\n
\u00a0oradebug setvar\u00a0<pls|uga> <name> <value><\/p>\n
\u00a0pls|uga\u00a0=> PGA\/SGA\/UGA<\/p>\n
name=> variable name<\/p>\n
value => Variable’s new value<\/p>\n
\u00a010) Memory address to a trace file\u00a0 will be dump by this command which can be found in user dump destination.<\/p>\n
oradebug peek <addr> <len> [level]<\/p>\n
addr=>memory address<\/p>\n
len=> length<\/p>\n
level=>level<\/p>\n
11) Modify memory<\/p>\n
oradebug poke <addr> <len> <value><\/p>\n
addr=> memory address<\/p>\n
len=> length<\/p>\n
value=> value<\/p>\n
12) Wake up Process<\/p>\n
oradebug wakeup <orapid><\/p>\n
orapid=>oracle PID<\/p>\n
13) oradebug command allows you to suspend a process. first you need to identify\u00a0 the shadow process that you want to suspend. Then set your debugs session to point\u00a0 to that process.<\/p>\n
oradebug suspend<\/p>\n
14) Resume Suspended process..<\/p>\n
oradebug resume<\/p>\n
15) Flush pending writes to trace file.<\/p>\n
oradebug flush<\/p>\n
16) Close the Trace file<\/p>\n
oradebug close_trace<\/p>\n
17) Get name of the Trace file<\/p>\n
oradebug tracefile-name<\/p>\n
18) The lkdebug and nsdbx are utilities within the oradebug utlity. They are intented for OPS\/RAC.<\/p>\n
SQL>oradebug lkdebug help<\/p>\n
SQL>oradebug nsdbx help<\/p>\n
19) Parallel oradebug command prefix<\/p>\n
a)\u00a0oradebug -G <inst-List|def |all><\/p>\n
Inst-List=> Instance List<\/p>\n
def=> Default<\/p>\n
all=> All instances<\/p>\n
b) oradebug -R <inst-List | def|all><\/p>\n
Parameters discussed above are same in this command too.<\/p>\n
20) Set Instance\/instances<\/p>\n
oradebug setinst<\/p>\n
21) Dump SGA to file<\/p>\n
oradebug\u00a0 sgatofile <SGA dump dir><\/p>\n
SGA dump dir=>SGA Directory name in double quotes<\/p>\n
22) Dump and map SGA as COW (Copy On Write)<\/p>\n
oradebug dmpcowsga <SGA dump dir><\/p>\n
SGA dump dir=>SGA Directory name in double quotes<\/p>\n
23) Dump and map SGA as COW (Copy On Write). Shared (cow) where cow stand for ‘Copy On Write’ is memory that will<\/p>\n
write through\u00a0 the cache into real memory.<\/p>\n
oradebug mappcowsga <SGA dump dir><\/p>\n
SGA dump dir=>SGA Directory name in double quotes<\/p>\n
24) Analyze System hang<\/p>\n
oradebug hanganalyze <level><\/p>\n
25) Flash Freeze\u00a0 the Instance<\/p>\n
oradebug ffbegin<\/p>\n
26) Flash Freeze deregister instance from cluster<\/p>\n
oradebug ffderegister<\/p>\n
27) Call exit and terminate instance<\/p>\n
oradebug ffterminst<\/p>\n
28) Resume the flash frozen instance<\/p>\n
oradebug ffresumeinst<\/p>\n
\u00a029)\u00a0 Flash Freeze\u00a0 status of instance<\/p>\n
oradebug ffstatus<\/p>\n
30) Help translate PCs to names<\/p>\n
oradebug skdsttpcs <ifname>\u00a0 <ofname><\/p>\n
ifname=> File name<\/p>\n
31) Watch a region of memory<\/p>\n
oradebug watch <address> <len> <self|exist|all|target><\/p>\n
32) Delete a watchpoint<\/p>\n
oradebug delete <local|global|target> watchpoint <id><\/p>\n
33) Show watchpoints<\/p>\n
oradebug show <local| global|target> watchpoints<\/p>\n
34) Dump core without crashing process<\/p>\n
oradebug core<\/p>\n
35)\u00a0 List semaphores and shared memory segments in use. Set process id\u00a0 before using it. Also this option shows which network is oracle using for RAC traffic.<\/p>\n
oradebug ipc<\/p>\n
36)Remove the file size limit. Useful when need\u00a0 trace file larger\u00a0 then size specified by max_dump_size parameter.<\/p>\n
oradebug unlimit<\/p>\n
37) Dump process statistics<\/p>\n
oradebug procstat<\/p>\n
38) Invoke function with arguments<\/p>\n
\u00a0ordebug call <func> [arg1]…[argn]<\/p>\n
func=> function name<\/p>\n
[arg1]…[argn]=> Function Arugment[s]<\/p>\n
39) Invoke named dump<\/p>\n
oradebug dump <dump_name> <level> <addr><\/p>\n
40) Dump of all state objects\u00a0 for all processes\u00a0 on the system<\/p>\n
oradebug dump systemstate<\/p>\n
41) Dump of all state objects for process<\/p>\n
\u00a0oradebug\u00a0 dump processstate<\/p>\n
42) Dump of the process call stack and other information<\/p>\n
oradebug dump errorstack\u00a0 <level><\/p>\n
43) The contents\u00a0 of the current controlfile\u00a0 can be dumped\u00a0 in text\u00a0 form to a process trace file\u00a0 in the usre_dump_dest directory using the CONTROLF dump<\/p>\n
oradebug dump controlf <level><\/p>\n
44) Dump datafile headers<\/p>\n
oradebug dump file_hdrs\u00a0 <level><\/p>\n
\u00a045)\u00a0 To dump one block<\/p>\n
alter system dump datafile\u00a0 <file_number> block <block_id>;<\/p>\n
To dump one or more data blocks<\/p>\n
alter system dump datafile<file_number>\u00a0 block min<first block> block max <last block>;<\/p>\n
46) Dump redo headers<\/p>\n
oradebug dump redohdr <level><\/p>\n
47) Dump of buffer cache<\/p>\n
oradebug dump buffers <level><\/p>\n
48) Dump library cache statistics<\/p>\n
\u00a0oradebug dump\u00a0 library_cache <level><\/p>\n
49)\u00a0 Dump strucutre of memory heap<\/p>\n
oradebug dump headdump_addr<level> <address><\/p>\n
address=> Descriptor address<\/p>\n
50) Dump the strucutre of index tree. The dump file contains one line for each block in the tree, indented\u00a0 to show its level,<\/p>\n
together with a count of the number of index entries in the block.<\/p>\n
oradebug dump treedump <object_id><\/p>\n
or<\/p>\n
alter sesion set events ‘immediate\u00a0 trace name treedump level n’;<\/p>\n
This utlitiy is mainly use for resolving the database issues and give more information to a DBA.<\/p>\n
Note: Please do not use these command without knowledge or consultationation with oracle support.<\/p>\n
51)<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0oradebug iutility s especially useful when\u00a0 things go very bad for example Database hangs,Due to ORA-00600 error your database is […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-299","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n