Re: Where are these table stats coming from?
- From: Barbara Baker <barb.baker@xxxxxxxxx>
- To: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- Date: Wed, 8 Jun 2005 09:22:45 -0600
Wolfgang: Interesting! I should have looked
Yes, both are filled in. But the value for avg row length is WAY off.=20
Should be about 900.
TABLE_NAME : WO
TABLESPACE_NAME : U05LMT
CLUSTER_NAME :
IOT_NAME :
PCT_FREE : 1
PCT_USED :
INI_TRANS : 1
MAX_TRANS : 255
INITIAL_EXTENT : 1048559616
NEXT_EXTENT : 1048578048
MIN_EXTENTS : 1
MAX_EXTENTS : 2147483645
PCT_INCREASE : 0
FREELISTS :
FREELIST_GROUPS :
LOGGING : YES
BACKED_UP : N
NUM_ROWS : 16233354
BLOCKS : 3250702
EMPTY_BLOCKS : 0
AVG_SPACE : 0
CHAIN_CNT : 0
AVG_ROW_LEN : 100
AVG_SPACE_FREELIST_BLOCKS : 0
NUM_FREELIST_BLOCKS : 0
DEGREE : 1
INSTANCES : 1
CACHE : N
TABLE_LOCK : ENABLED
SAMPLE_SIZE : 0
LAST_ANALYZED : 08-jun-2005 04:47:05
PARTITIONED : NO
IOT_TYPE :
TEMPORARY : N
SECONDARY : N
NESTED : NO
BUFFER_POOL : DEFAULT
ROW_MOVEMENT : DISABLED
GLOBAL_STATS : YES
USER_STATS : NO
DURATION :
SKIP_CORRUPT : DISABLED
MONITORING : NO
CLUSTER_OWNER :
DEPENDENCIES : DISABLED
COMPRESSION : DISABLED
-----------------
=20
On 6/8/05, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> What about the other table statistics - blocks and avg_rowlen? Are those
> filled in by the "compute statistics" of the alter index rebuild?
>=20
> Barbara Baker wrote:
> > OpenVMS 7.3-1 Oracle 9.2.0.4
> >
> > Seems like a dumb question, but . . . . I don't understand what's
> > generating the stats on my table.
> >
> > At the end of the index rebuild command, the table DOES have
> > statistics. And the time of the statistics is identical to the
> > creation of the last index.
> >
> > TABLE_NAME NUM_ROWS LAST_ANALYZED
> > ------------------------------ ---------- ---------------=
----=3D
> > -
> > WO 16233354 08-JUN-2005 04:47:05
> >
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
