Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> More questions on tablespaces

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US