Database Administration (MOSC)

MOSC Banner

How to disable trace from JDBC program.

edited Apr 19, 2016 11:05AM in Database Administration (MOSC) 18 commentsAnswered

For some reason excessive trace files are getting generated at a high rate on all wait events at db.  How this can be stopped.


SQL> alter system set events '10046 trace name context off';

System altered.

SQL>  SELECT TRACE_TYPE, PRIMARY_ID, QUALIFIER_ID1, WAITS, BINDS

FROM DBA_ENABLED_TRACES;   2

TRACE_TYPE

---------------------

PRIMARY_ID

----------------------------------------------------------------

QUALIFIER_ID1                                    WAITS BINDS

------------------------------------------------ ----- -----

SERVICE_MODULE_ACTION

BISAMP

JDBC Thin Client                                 TRUE  FALSE

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