Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What's the meaning of Stats Tables?

732607Nov 25 2009 — edited Nov 25 2009
Hi,
I'm trying to use the DBMS_STATS for gathering statistics.
I've launched the following:

BEGIN
dbms_stats.create_stat_table (ownname=>'MYOWNER',stattab=>'STAT_TAB');
dbms_stats.gather_table_stats(ownname=>'MYOWNER',tabname=>'MYTABLE',stattab=>'STAT_TAB');
END;
*/*

and when I go and watch the STAT_TAB table I find it's been created with this description:

SQL> desc STAT_TAB
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)

How can I undestand the meaning of the columns? I can't get the meaning of the names Oracle has assigned by default, I suppose. My version is Oracle 8.1.7.
Thanks
This post has been answered by 591186 on Nov 25 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2009
Added on Nov 25 2009
8 comments
1,275 views