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

Query sys.aux_stats$

   <source lang="sql">

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  /
  
 </source>