eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ENABLED_TRACES

Object Details

Object Name:	DBA_ENABLED_TRACES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Information about enabled SQL traces

[View Source]

Columns

Name	Datatype	Length	Comments
TRACE_TYPE	VARCHAR2	(21)	Type of the trace (CLIENT_ID, SERVICE, etc.)
PRIMARY_ID	VARCHAR2	(64)	Primary qualifier (specific Client Identifier or Service name)
QUALIFIER_ID1	VARCHAR2	(64)	Secondary qualifier (specific MODULE name)
QUALIFIER_ID2	VARCHAR2	(64)	Additional qualifier (specific ACTION name)
WAITS	VARCHAR2	(5)	TRUE of waits are traced
BINDS	VARCHAR2	(5)	TRUE of binds are traced
PLAN_STATS	VARCHAR2	(10)
INSTANCE_NAME	VARCHAR2	(16)	Instance name for tracing restricted to named instances

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRACE_TYPE
,      PRIMARY_ID
,      QUALIFIER_ID1
,      QUALIFIER_ID2
,      WAITS
,      BINDS
,      PLAN_STATS
,      INSTANCE_NAME
FROM SYS.DBA_ENABLED_TRACES;

Dependencies

[top of page]

SYS.DBA_ENABLED_TRACES references the following:

SYS: WRI$_TRACING_ENABLED

SYS.DBA_ENABLED_TRACES is referenced by following:

PUBLIC: DBA_ENABLED_TRACES