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]

TABLE: SYS.PLSQL_TRACE_EVENTS

Object Details

Object Name:	PLSQL_TRACE_EVENTS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Accumulated data from all trace runs

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00225451

RUNID
EVENT_SEQ

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00225451	NORMAL	UNIQUE	SYSTEM	RUNID EVENT_SEQ
SYS_IL0000450491C00030$$	LOB	UNIQUE	SYSTEM
SYS_IL0000450491C00031$$	LOB	UNIQUE	SYSTEM

Foreign Keys

Table		Foreign Table	Foreign Key Column
PLSQL_TRACE_EVENTS		PLSQL_TRACE_RUNS	PLSQL_TRACE_EVENTS RUNID

Columns

Name	Datatype	Length	Mandatory
RUNID	NUMBER		Yes
EVENT_SEQ	NUMBER		Yes
EVENT_TIME	DATE
RELATED_EVENT	NUMBER
EVENT_KIND	NUMBER
EVENT_UNIT_DBLINK	VARCHAR2	(4000)
EVENT_UNIT_OWNER	VARCHAR2	(31)
EVENT_UNIT	VARCHAR2	(31)
EVENT_UNIT_KIND	VARCHAR2	(31)
EVENT_LINE	NUMBER
EVENT_PROC_NAME	VARCHAR2	(31)
STACK_DEPTH	NUMBER
PROC_NAME	VARCHAR2	(31)
PROC_DBLINK	VARCHAR2	(4000)
PROC_OWNER	VARCHAR2	(31)
PROC_UNIT	VARCHAR2	(31)
PROC_UNIT_KIND	VARCHAR2	(31)
PROC_LINE	NUMBER
PROC_PARAMS	VARCHAR2	(2047)
ICD_INDEX	NUMBER
USER_EXCP	NUMBER
EXCP	NUMBER
EVENT_COMMENT	VARCHAR2	(2047)
MODULE	VARCHAR2	(4000)
ACTION	VARCHAR2	(4000)
CLIENT_INFO	VARCHAR2	(4000)
CLIENT_ID	VARCHAR2	(4000)
ECID_ID	VARCHAR2	(4000)
ECID_SEQ	NUMBER
CALLSTACK	CLOB	(4000)
ERRORSTACK	CLOB	(4000)

Query Text

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


SELECT RUNID
,      EVENT_SEQ
,      EVENT_TIME
,      RELATED_EVENT
,      EVENT_KIND
,      EVENT_UNIT_DBLINK
,      EVENT_UNIT_OWNER
,      EVENT_UNIT
,      EVENT_UNIT_KIND
,      EVENT_LINE
,      EVENT_PROC_NAME
,      STACK_DEPTH
,      PROC_NAME
,      PROC_DBLINK
,      PROC_OWNER
,      PROC_UNIT
,      PROC_UNIT_KIND
,      PROC_LINE
,      PROC_PARAMS
,      ICD_INDEX
,      USER_EXCP
,      EXCP
,      EVENT_COMMENT
,      MODULE
,      ACTION
,      CLIENT_INFO
,      CLIENT_ID
,      ECID_ID
,      ECID_SEQ
,      CALLSTACK
,      ERRORSTACK
FROM SYS.PLSQL_TRACE_EVENTS;

Dependencies

[top of page]

SYS.PLSQL_TRACE_EVENTS does not reference any database object

SYS.PLSQL_TRACE_EVENTS is not referenced by any database object