Database Tuning (MOSC)

MOSC Banner

Oracle traces still running in background?

edited Aug 23, 2016 4:27PM in Database Tuning (MOSC) 8 commentsAnswered ✓
Hi all
I see bigger TRC Files in my diag folder (RDBMS/SID/TRACE).
Yesterday i captured some SQL_ID's, like
-- > alter system set events 'sql_trace [sql:9b0xpr1296bwu] wait=true, bind=true,plan_stat=first_execution,level=12';

After the capturing I stop them with alter system set events 'sql_trace [sql:9b0xpr1296bwu] off';

How it's possible to check whether is other traces are still running and how the can be stopped?

BR
Daniel


SQL> show parameter trace

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_trace                    integer     0
sec_protocol_error_trace_action      string      TRACE

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