segment statistics

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 19 Jul 2007 11:15:51 +0700
Message-ID: <3edcb66e0707182115y5e4eb6f9g56347fd26e4be048@mail.gmail.com>

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

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 18 2007 - 23:15:51 CDT