Re: query to find all traces in an instance?

From: Stefan Koehler <contact_at_soocs.de>
Date: Thu, 21 Apr 2016 16:45:46 +0200 (CEST)
Message-ID: <2047336424.802298.1461249946788.JavaMail.open-xchange_at_app01.ox.hosteurope.de>

Hi Patrice,
depends on how the tracing was enabled. You have to check 2/3 locations.

• e.g. "oradebug eventdump session" (includes session and system events) for kernel diagnostics & tracing infrastructure +
• View DBA_ENABLED_TRACES for package DBMS_MONITOR +
• X$TRACE_EVENTS

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> Patrice sur GMail <patrice.boivin_at_gmail.com> hat am 21. April 2016 um 16:29 geschrieben:
>
> Is there a data dictionary view which shows every trace which is currently active in the database?
>
> We had a user who turned session tracing on but never turned it off, for example.
>
> I read through the documentation and searched on Google but didn't find a simple way of doing an inventory of all active traces in an instance.
>
> ​Since the instance knows about the traces which have been set, maybe there is a view_name$ or X$ query we could use to list them all?​
>
>
> -- Patrice
>
> My profiles: [Facebook] http://www.facebook.com/home.php?#!/profile.php?id=100000206805521 [LinkedIn]
> http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9 [Twitter] http://www.twitter.com/PatriceBoivin
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 21 2016 - 16:45:46 CEST