Extract system stats from your user table or data dictionary (sys.aux_Stats$). : dbms_stats « System Packages « Oracle PL / SQL






Extract system stats from your user table or data dictionary (sys.aux_Stats$).

    

SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2   STATUS VARCHAR2(20);
  3   DSTART DATE;
  4   DSTOP DATE;
  5   PVALUE NUMBER;
  6   PNAME VARCHAR2(30);
  7  BEGIN
  8   PNAME := 'cpuspeed';
  9   DBMS_STATS.GET_SYSTEM_STATS(status, dstart, dstop, pname, pvalue);
 10   DBMS_OUTPUT.PUT_LINE('status                      : '||status);
 11   DBMS_OUTPUT.PUT_LINE('cpu in mhz                  : '||pvalue);
 12
 13  END;
 14  /
status                      : MANUALGATHERING
cpu in mhz                  :

PL/SQL procedure successfully completed.

   
    
    
    
  








Related examples in the same category

1.dbms_stats.drop_stat_table, dbms_stats.create_stat_table,dbms_stats.delete_system_stats
2.dbms_stats.gather_schema_stats
3.dbms_stats.gather_table_stats
4.DBMS_STATS.GET_SYSTEM_STATS
5.dbms_stats.import_system_stats
6.dbms_stats.objectTab
7.dbms_stats.set_table_stats( user, 'EMP', numrows => 100000 )
8.dbms_stats.set_table_stats( user, 'myTable1', numrows => 10000000, numblks => 1000000 )
9.Delete all table and index statistics in your schema:
10.multiblock readtime in ms
11.Run DBMS_STATS.GATHER_SCHEMA_STATS to collect stats for all of your tables and indexes.