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._user_stat

Object Details

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

[View Source]

Columns

Name	Datatype	Length
TYPE	CHAR	(1)
VERSION	NUMBER
FLAGS	NUMBER
C1	VARCHAR2	(128)
C2	VARCHAR2	(128)
C3	VARCHAR2	(128)
C4	VARCHAR2	(128)
C5	VARCHAR2	(128)
C6	VARCHAR2	(128)
N1	NUMBER
N2	NUMBER
N3	NUMBER
N4	NUMBER
N5	NUMBER
N6	NUMBER
N7	NUMBER
N8	NUMBER
N9	NUMBER
N10	NUMBER
N11	NUMBER
N12	NUMBER
N13	NUMBER
D1	TIMESTAMP(6) WITH TIME ZONE	(13)
T1	TIMESTAMP(6) WITH TIME ZONE	(13)
R1	RAW	(1000)
R2	RAW	(1000)
R3	RAW	(2000)
CH1	VARCHAR2	(0)
CL1	CLOB	(4000)

Query Text

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


SELECT TYPE
,      VERSION
,      FLAGS
,      C1
,      C2
,      C3
,      C4
,      C5
,      C6
,      N1
,      N2
,      N3
,      N4
,      N5
,      N6
,      N7
,      N8
,      N9
,      N10
,      N11
,      N12
,      N13
,      D1
,      T1
,      R1
,      R2
,      R3
,      CH1
,      CL1
FROM SYS._user_stat;

Dependencies

[top of page]

SYS._user_stat references the following:

SYS: COL$; COL_GROUP_USAGE$; COL_USAGE$; DBMS_SPD_INTERNAL - show dependent code; DBMS_STATS - show dependent code; DBMS_STATS_INTERNAL - show dependent code; FIXED_OBJ$; HISTGRM$; HIST_HEAD$; IND$; INDCOMPART$; INDCOMPARTV$; INDPARTV$; INDSUBPART$; INDSUBPARTV$; IND_STATS$; MON_MODS_ALL$; OBJ$; OPTSTAT_HIST_CONTROL$; OPTSTAT_USER_PREFS$; OPT_DIRECTIVE$; OPT_FINDING$; OPT_FINDING_OBJ$; SYS_PLSQL_15AD49DF_1984_1; SYS_PLSQL_6A517DAE_9_1; TAB$; TABCOMPART$; TABCOMPARTV$; TABPART$; TABPARTV$; TABSUBPART$; TABSUBPARTV$; TAB_STATS$; USER$; UTL_RAW - show dependent code; WRI$_OPTSTAT_HISTGRM_HISTORY; WRI$_OPTSTAT_HISTHEAD_HISTORY; WRI$_OPTSTAT_IND_HISTORY; WRI$_OPTSTAT_SYNOPSIS_HEAD$; WRI$_OPTSTAT_TAB_HISTORY; XMLTYPE; _BASE_OPT_FINDING_OBJ_COL

SYS._user_stat is referenced by following:

SYS: _user_stat_varray