Oracle PL/SQL/System Tables Views/sys.aux stats

Материал из 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  /