Re: dba_col_comments

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 - 16:01:39 CST