segment statistics
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 19 Jul 2007 11:15:51 +0700
all,
I want to create report based on statspack, about most top table.
for 9i onward, we can set statspack level 7 or greater to do that, but
not find in oracle 8i (8174). does anyone has the same task? please
share......
according to 9i, i try to look for the v$segment_statistics coming
from....but it seem view and synonym recursive.....
any explanation, greatly appreciate.....
SQL> select dbms_metadata.get_ddl('SYNONYM','V$SEGMENT_STATISTICS','PUBLIC')
from dual;
DBMS_METADATA.GET_DDL('SYNONYM','V$SEGMENT_STATISTICS','PUBLIC')
--------------------------------------------------------------------------------
CREATE PUBLIC SYNONYM "V$SEGMENT_STATISTICS" FOR "SYS"."V_$SEGMENT_STATISTICS"
SQL> select dbms_metadata.get_ddl('VIEW','V_$SEGMENT_STATISTICS','SYS')
from dual;
DBMS_METADATA.GET_DDL('VIEW','V_$SEGMENT_STATISTICS','SYS')
--------------------------------------------------------------------------------
CREATE OR REPLACE FORCE VIEW "SYS"."V_$SEGMENT_STATISTICS" ("OWNER", "OBJECT_N
AME", "SUBOBJECT_NAME", "TABLESPACE_NAME", "TS#", "OBJ#", "DATAOBJ#", "OBJECT_TY
PE", "STATISTIC_NAME", "STATISTIC#", "VALUE") AS
select "OWNER","OBJECT_NAME","SUBOBJECT_NAME","TABLESPACE_NAME","TS#","OBJ#","
DATAOBJ#","OBJECT_TYPE","STATISTIC_NAME","STATISTIC#","VALUE" from v$segment_sta
tistics
--
regards
ujang
--
//www.freelists.org/webpage/oracle-l
Other related posts:
