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

What this article shares with you is about the common commands and usage of oradebug. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

1 > what commands are available for oradebug?

Log in to the database as sysdba, and you can see the common oradebug commands through oradebug help.

Sqlplus / as sysdba

Oradebug help

2 > track current session information

Oradebug setmypid-tracks the current session

Oradebug setospid-tracking system progress

Oradebug setorapid-tracking the ORACLE process

Oradebug unlimit-remove the trace file size limit

Oradebug tracefile_name-View the trace file name and location

3 > use oradebug to do session level 10046 or 10053

Oradebug setmypid

Oradebug unlimit

Oradebug session_event 10046 trace name context forever, level 4-enable session level 10046

Oradebug event 10046 trace name context off-close the 10046 event

Oradebug tracefile_name-View the tracefile file location and file name

4 > use oradebug to do oracle process level 10046

Oradebug setorapid

Oradebug unlimit

Oradebug event 10046 trace name context forever, level 4

Oradebug event 10046 trace name context off

Oradebug tracefile_name

Analysis on the causes of hang residence in 5 > oradebug system

If the system HANG resides, as long as sys users can log in, then it is very useful to use oradebug for cause analysis.

Oradebug setmypid

Oradebug unlimit

Oradebug setinst all-RAC environment

Oradebug hanganalyze 3-A level of 3 is generally sufficient

Oradebug-g def dump systemstate 10-RAC environment

Oradebug tracefile_name

6 > get the status information of a process

Oradebug setospid 22180

Oradebug dump processstate 10

Oradebug tracefile_name

7 > get process error message status

Oradebug setospid 22180

Oradebug dump errorstack 3

8 > track the cause of the error message, such as ORA-04031

Oradebug event 4031 trace name errorstack level 3

9 > sample tracking oracle process:

Oradebug setorapid 120

Oradebug unlimit

Oradebug event 10046 trace name context forever, level 4

Oradebug event 10046 trace name context off

Oradebug tracefile_name

These are the common commands and uses of oradebug. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please 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.