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!