Query sys.aux_stats$ : sys.aux_stats « System Tables Views « Oracle PL / SQL






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  /

   
  








Related examples in the same category