Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query sys aux_stats$

SQL> select * from sys.aux_stats$;                                                                SNAME                           PNAME                                PVAL1 ------------------------------  ------------------------------  ---------- PVAL2 ------------------------------------------------------------------------------------------------------------------------ SYSSTATS_INFO                   STATUS COMPLETED SYSSTATS_INFO                   DSTART 10-26-2009 08:42 SYSSTATS_INFO                   DSTOP 10-26-2009 08:42 SYSSTATS_INFO                   FLAGS                                    0 SYSSTATS_MAIN                   CPUSPEEDNW                        1661.912 SYSSTATS_MAIN                   IOSEEKTIM                               10 SYSSTATS_MAIN                   IOTFRSPEED                            4096 SYSSTATS_MAIN                   SREADTIM SYSSTATS_MAIN                   MREADTIM SYSSTATS_MAIN                   CPUSPEED SYSSTATS_MAIN                   MBRC SYSSTATS_MAIN                   MAXTHR SYSSTATS_MAIN                   SLAVETHR SQL> begin   2     dbms_stats.import_system_stats( stattab => 'SYSTEM_STATS', statid => 'DW', statown => user );   3  end;   4  /