Re: dba_col_comments

From: spencer <spencerp_at_swbell.net>
Date: Tue, 1 Feb 2000 22:30:34 -0600
Message-ID: <KpOl4.628$ko2.7733@news.swbell.net>

the INITIAL and NEXT values on the TABLESPACE are default storage parameter values that are used when a table or index is created in the tablespace, and INITIAL and/or NEXT is not specified in the storage clause of the CREATE TABLE or CREATE INDEX.

also, if the tables were exported compress=y, the tables were dropped, and then imported again (compress=y), oracle will "compress" multiple small extents into a larger one.

btw... for convencience, the INITIAL and NEXT values can be specified in K bytes or M bytes.. that is ' INITIAL 10240 ' is the same as ' INITIAL 10K '

good luck.

"Ray Stell" <stellr_at_stell.cns.vt.edu> wrote in message news:877l43$c7g$1_at_solaris.cc.vt.edu...
>
> Well, wouldn't it be nice if I didn't have to ask. I'm in the
bitter part
> of the learning curve, sorry.
>
> It is reporting this to me about some tablespace:
>
> SQL> select tablespace_name, initial_extent, next_extent,
max_extents, min_extents, pct_increase from DBA_TABLESPACES;
>
> TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS
MIN_EXTENTS PCT_INCREASE
> ---------------- -------------- ----------- ----------- ------
----- ------------
> TACPLUS_BDATA 10240 10240 121
1 50
>
>
>
> an another view of the tablespace seems to be in bytes, and is
much larger:
>
> 1 select tablespace_name, segment_name
,blocks,bytes,extents,initial_extent,next_extent
> 2* from dba_segments where TABLESPACE_NAME like
'%TACPLUS_BD%'
>
> TABLESPACE_NAME SEGMENT_NAME BLOCKS BYTES
EXTENTS INITIAL_EXTENT NEXT_EXTENT
> --------------- -------------------- --------- --------- -----
---- -------------- -----------
> TACPLUS_BDATA TAC_ACCT_ATTRIBUTE 1441809 2.953E+09

9      536870912   268435456


> TACPLUS_BDATA   TAC_AUTHEN_EXCEPTION     98310 201338880


2      100663296   100663296


> TACPLUS_BDATA   TAC_AUTHOR_EXCEPTION     49155 100669440


1      100663296   100663296


> TACPLUS_BDATA   TAC_CALL_LOG            393217 805308416


2      536870912   268435456


> TACPLUS_BDATA   TAC_ACCT_JOURNAL        393217 805308416


2      536870912   268435456


> TACPLUS_BDATA   TAC_AUDIT_USER             130    266240


1         262144      262144


> TACPLUS_BDATA   TAC_AUDIT_GROUP_USER       150    307200


1         307200      307200


> TACPLUS_BDATA   TAC_AUDIT_IP_USER          100    204800


2         102400      102400

>
> SQL> select table_name, column_name, comments from
dba_col_comments where
> 2 table_name = 'DBA_SEGMENTS';
>
>
> INITIAL_EXTENT
> Size, in bytes, of the initial extent of the segment
>
> of course, they could be lying here, I guess....am I sounding
bitter?
>
>
>
>
>
> Sybrand Bakker (postmaster_at_sybrandb.demon.nl) wrote:
> : Not THAT far fetched! What do you think ... BYTES!
>
> : Hth,
>
> : --
> : Sybrand Bakker, Oracle DBA
> : Ray Stell <stelle_at_stell.cns.vt.edu> wrote in message
> : news:877e2t$8aj$1_at_solaris.cc.vt.edu...
> : > SQL> select column_name, comments
> : > 2 from dba_col_comments
> : > 3 where table_name = 'DBA_TABLESPACES';
> : >
> : > COLUMN_NAME COMMENTS
> :
> --------------- ---------------------------------------------
> : > TABLESPACE_NAME Tablespace name
> : > INITIAL_EXTENT Default initial extent size
> : > NEXT_EXTENT Default incremental extent size
> : > MIN_EXTENTS Default minimum number of extents
> : > MAX_EXTENTS Default maximum number of extents
> : > PCT_INCREASE Default percent increase for extent size
> : >
> : > Just out of curiosity, INITIAL_EXTENT and NEXT_EXTENT,
> : > what is the unit of measure for the size? Joules,
> : > newtons, electronvolts, maybe?
> : >
> : >
>
>
Received on Tue Feb 01 2000 - 22:30:34 CST