Database Administration (MOSC)

MOSC Banner

How to stop the oradebug command?

edited Aug 9, 2018 1:57PM in Database Administration (MOSC) 2 commentsAnswered ✓

Hello guys,

I executed in the production environment the oradebug commands ("oradebug dump systemstate 258", "oradebug hanganalyze 3") , but the trace logs are increasing so fast.

The filesystem is warning that no free disk space.

Please, I must stop this trace.

Which command do I use in order to stop this trace?

Below the following the commands that I executed.

1) Collect the hang analyze during the issue period.

sqlplus / as sysdba

oradebug setmypid

oradebug unlimit <<<<<<<<<<<< This will show the trace file name.

oradebug tracefile_name

oradebug hanganalyze 3

wait 90 seconds

oradebug hanganalyze 3

wait 90 seconds

oradebug hanganalyze 3

exit;

2) Collect the system state dump during the issue period.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center