More questions on tablespaces

From: <argosy22_at_my-deja.com>
Date: 2000/04/20
Message-ID: <8dni25$1nj$1@nnrp1.deja.com>#1/1

HI everyone,

Some more questions on tablespaces.

I'm reverse engineering a database on our production server, for use on a new staging server. I queried the data dictionary and found:

  1  Select     ts.TABLESPACE_NAME                 ,
  2             df.file_name                    ,
  3             ts.INITIAL_EXTENT                 ,
  4             ts.NEXT_EXTENT                    ,
  5             ts.MIN_EXTENTS                    ,
  6             ts.MAX_EXTENTS                    ,
  7             ts.PCT_INCREASE                    ,
  8             vdf.BYTES,
  9             vdf.CREATE_BYTES
 10  from       dba_tablespaces         ts,
 11     dba_data_files          df,
 12     v$datafile              vdf
 13  where      ts.TABLESPACE_NAME = df.TABLESPACE_NAME
 14  and        vdf.name        = df.FILE_NAME
 15* order by           1, 2

TABLESPACE_NAME

FILE_NAME

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE BYTES
-------------- ----------- ----------- ----------- ------------

CREATE_BYTES

INDEX_TBS
/index/???.dbf

16384 16384 1 121 10 209715200

209715200

RBS
/rollback/???.dbf

26214400 1048576 1 505 0 209715200

209715200

ROLLBACK_TBS
/rollback/???.dbf

16384 16384 1 121 10 209715200

209715200

...

TEMP
/index/???.dbf

10485760 1048576 1 505 0 209715200

209715200

...

What strikes me as odd is for some tablespaces (ROLLBACK_TBS, and INDEX_TBS):
- some extents are only 16K (1024*16=16384)

(Yet I think the default is 160K)
- the max extents are only 121
(indicating max 1982464 bytes that will be used, or 1.89M) - but the file is given a whole 200M for storage

Is only 1.89M being used in some of these tables of 200M? Or, is 16384, not in fact 16K, but something else?

Or, am I missing something here?

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 20 2000 - 00:00:00 CDT