9i 에서 테스트
SQL> select * from aux_stats$ ;
no rows selected
SQL> exec dbms_stats.create_stat_table('sys','orgstat','users') ;
PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_system_stats(gathering_mode=>'interval',interval=>2,stattab=>'orgstat',statid=>'orgstat') ;
PL/SQL procedure successfully completed.
SQL> select statid,c1,c2 from orgstat ;
STATID C1 C2
------------------------------ ------------------------------ ------------------------------
ORGSTAT AUTOGATHERING 03-11-2009 14:27
ORGSTAT
SQL> /
STATID C1 C2
------------------------------ ------------------------------ ------------------------------
ORGSTAT COMPLETED 03-11-2009 14:27
ORGSTAT
SQL> exec dbms_stats.import_system_stats(stattab=>'orgstat',statid=>'orgstat',statown=>'sys') ;
PL/SQL procedure successfully completed.
SQL> select * from aux_stats$ ;
SNAME PNAME PVAL1 PVAL2
------------------------------ ------------------------------ ---------- -----------------------
SYSSTATS_INFO STATUS COMPLETED
SYSSTATS_INFO DSTART 03-11-2009 14:27
SYSSTATS_INFO DSTOP 03-11-2009 14:29
SYSSTATS_INFO FLAGS 0
SYSSTATS_MAIN SREADTIM 4.286
SYSSTATS_MAIN MREADTIM -1
SYSSTATS_MAIN CPUSPEED 694
SYSSTATS_MAIN MBRC -1
SYSSTATS_MAIN MAXTHR 311296
SYSSTATS_MAIN SLAVETHR -1
SQL> exec dbms_stats.delete_system_stats ;
PL/SQL procedure successfully completed.
SQL> select * from aux_stats$ ;
no rows selected
=============================================================================================
SQL> exec dbms_stats.gather_system_stats ;
PL/SQL procedure successfully completed.
SQL> select * from aux_stats$ ;
SNAME PNAME PVAL1 PVAL2
------------------------------ ------------------------------ ---------- -------------------
SYSSTATS_INFO STATUS NOWORKLOAD
SYSSTATS_INFO DSTART 03-11-2009 14:21
SYSSTATS_INFO DSTOP 03-11-2009 14:21
SYSSTATS_INFO FLAGS 1
=============================================================================================