DBA Data[Home] [Help]

VIEW: SYS.V_$SEGMENT_STATISTICS

Source

View Text - Preformatted

select "OWNER","OBJECT_NAME","SUBOBJECT_NAME","TABLESPACE_NAME","TS#","OBJ#","DATAOBJ#","OBJECT_TYPE","STATISTIC_NAME","STATISTIC#","VALUE","CON_ID" from v$segment_statistics
View Text - HTML Formatted

SELECT "OWNER"
, "OBJECT_NAME"
, "SUBOBJECT_NAME"
, "TABLESPACE_NAME"
, "TS#"
, "OBJ#"
, "DATAOBJ#"
, "OBJECT_TYPE"
, "STATISTIC_NAME"
, "STATISTIC#"
, "VALUE"
, "CON_ID"
FROM V$SEGMENT_STATISTICS