Home » RDBMS Server » Server Administration » How do I read the collection statistic generated by DBMS_STATS?
How do I read the collection statistic generated by DBMS_STATS? [message #277859] Wed, 31 October 2007 23:19 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear!

I run some script to create a table which gather statistic like:

BEGIN
   DBMS_STATS.create_stat_table (ownname       => 'sys',
                                 stattab       => 'ibmstats',
                                 tblspace      => 'users'
                                );
END;

BEGIN
   DBMS_STATS.gather_system_stats (INTERVAL      => 720,
                                   stattab       => 'ibmstats',
                                   statid        => 'DSS'
                                  );
END;

BEGIN
   DBMS_STATS.gather_system_stats (INTERVAL      => 720,
                                   stattab       => 'ibmstats',
                                   statid        => 'BATCH'
                                  );
END;

EXECUTE Dbms_Stats.Import_System_Stats('ibmstats','DSS');
EXECUTE Dbms_Stats.Import_System_Stats('ibmstats','BATCH');


However, the ibmstats table contains some stranger columns, and I did not understand what they said.

SQL> desc ibmstats
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 STATID                                             VARCHAR2(30)
 TYPE                                               CHAR(1)
 VERSION                                            NUMBER
 FLAGS                                              NUMBER
 C1                                                 VARCHAR2(30)
 C2                                                 VARCHAR2(30)
 C3                                                 VARCHAR2(30)
 C4                                                 VARCHAR2(30)
 C5                                                 VARCHAR2(30)
 N1                                                 NUMBER
 N2                                                 NUMBER
 N3                                                 NUMBER
 N4                                                 NUMBER
 N5                                                 NUMBER
 N6                                                 NUMBER
 N7                                                 NUMBER
 N8                                                 NUMBER
 N9                                                 NUMBER
 N10                                                NUMBER
 N11                                                NUMBER
 N12                                                NUMBER
 D1                                                 DATE
 R1                                                 RAW(32)
 R2                                                 RAW(32)
 CH1                                                VARCHAR2(1000)

They said..
SQL> select c1,c2,c3 from ibmstats;

C1                        C2                        C3
------------------------- ------------------------- -------------------------
COMPLETED                 10-31-2007 10:57          10-31-2007 10:57

COMPLETED                 10-31-2007 11:00          10-31-2007 11:00



Have you ever done these operations like me? Which table do you read the collected statistic?

Thank you!
Re: How do I read the collection statistic generated by DBMS_STATS? [message #277883 is a reply to message #277859] Thu, 01 November 2007 01:48 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is internal stuff only use to export and import statistics.
If you want current statistics query the %STATISTICS and %HISTOGRAMS views.

Regards
Michel
Previous Topic: Before 11g install complet, power failed
Next Topic: how to solve shared memory realm problem (merged)
Goto Forum:
  


Current Time: Sat Dec 10 08:50:30 CST 2016

Total time taken to generate the page: 0.08400 seconds