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_USTATS

Object Details

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

All statistics on tables or indexes owned by the user

[View Source]

Columns

Name	Datatype	Length	Comments
OBJECT_OWNER	VARCHAR2	(128)	Owner of the table or index for which the statistics have been collected
OBJECT_NAME	VARCHAR2	(128)	Name of the table or index for which the statistics have been collected
PARTITION_NAME	VARCHAR2	(128)	Name of the partition (if applicable) for which the stats have been collected
OBJECT_TYPE	VARCHAR2	(6)	Type of the object - Column or Index
ASSOCIATION	VARCHAR2	(8)	If the statistics type association is direct or implicit
COLUMN_NAME	VARCHAR2	(128)	Column name, if property is column for which statistics have been collected
STATSTYPE_SCHEMA	VARCHAR2	(128)	Schema of statistics type which was used to collect the statistics
STATSTYPE_NAME	VARCHAR2	(128)	Name of statistics type which was used to collect statistics
STATISTICS	RAW	(2000)	User collected statistics for the object

Query Text

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


SELECT OBJECT_OWNER
,      OBJECT_NAME
,      PARTITION_NAME
,      OBJECT_TYPE
,      ASSOCIATION
,      COLUMN_NAME
,      STATSTYPE_SCHEMA
,      STATSTYPE_NAME
,      STATISTICS
FROM SYS.USER_USTATS;

Dependencies

[top of page]

SYS.USER_USTATS references the following:

SYS: COL$; INDPART$; OBJ$; TABPART$; USER$; USTATS$

SYS.USER_USTATS is referenced by following:

PUBLIC: USER_USTATS