本视图实时监控段级(segment-level)统计项,支持oracle9ir2及更高版本
V$SEGSTAT中的常用列
TS#:表空间标识
OBJ#:字典对象标识
DATAOBJ#:数据对象标识
STATISTIC_NAME:统计项名称
STATISTIC#:统计项标识
VALUE:统计项值
V$SEGSTAT中的连接列
Column View Joined Column(s)
-------------- ----------------------- ------------------------
TS# V$TABLESPACE TS#
OBJ# ALL_OBJECTS OBJECT_ID
示例:
查询指定对象的统计
select * from v$segstat where ts# = 11
and obj# = (select object_id from user_objects
where object_name = 'TMPTABLE1' and owner = 'JSS')