Shulou(Shulou.com)05/31 Report--

Editor to share with you how to use oradebug, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Oradebug is a sql*plus command line tool that can log in with sysdba permission to track the details of the process and generate trace files

Sqlplus / as sysdba

SQL > oradebug help

Expdp is very slow, there is still no problem in adding metrics and trace parameters. Get wait events through 10046 level 8, use oradebug to grab these details of the expdp process and write them to the trace file

1. Timed_statistics must be true,11.2.0.0. The default is true.

ALTER SYSTEM SET timed_statistics = TRUE SCOPE = memory

2. Execute an expdp export and add trace to generate a trace file by default

Expdp system/123456 directory=DATA_PUMP_DIR dumpfile=dump123 logfile=dump123.log schemas=hr METRICS=Y TRACE=480300

3. Check the process number spid of the dw process of expdp

CONNECT / as sysdba

Select to_char (sysdate,'YYYY-MM-DD HH24:MI:SS') "DATE", s.program, s.sid

S.status, s.username, d.job_name, p.spid, s.serial#, p.pid

From v$session s, v$process p, dba_datapump_sessions d

Where p.addr=s.paddr and s.saddr=d.saddr and s.program like'% DW%'

4. If the above query result p.spid is 123 trace level 10046, 8 of which means tracking waiting events.

Oradebug setospid 123

Oradebug unlimit

Oradebug event 10046 trace name context forever, level 8

Oradebug tracefile_name

Oradebug event 10046 trace name context off

Information about the dump process for oradebug files

Alter system dump logfile: you want dump's log: it can be redolog or archivelog'

Oradebug setmypid

Oradebug tracefile_name

Analysis on the causes of hang residence in oradebug system

Oradebug setmypid

Oradebug unlimit

Oradebug hanganalyze 3

Oradebug tracefile_name

Get the status information of a process

Oradebug setospid 22180

Oradebug dump processstate 10

Oradebug tracefile_name

-Information on oradebug dump options

DUMP

-View dump_name

SQL > oradebug dumplist

Lvl, if you want to get more comprehensive information, you can use Level 10

The above is all the contents of this article "how to use oradebug". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.