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