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 -> Locally managed tablespaces

Locally managed tablespaces

From: Madhavan Amruthur <mad5698_at_my-Deja.com>
Date: 2000/06/19
Message-ID: <JEDIOKIOMDNAIBAA@my-deja.com>#1/1

Hi all,
We created our tablespaces as locally managed and we have about 4 tablespaces that are 40G. According to note 111666.1 on Metalink one extent from each datafile is used for storage management and we have 200M uniform extent size which means we lose 4G over a 40G tablespace with 20 data files. We have 4 tablespaces with 40G and that means 16G. We also have other tablespaces 20G.

Is there a better way to do it other than converting it into a dict managed tbs with uniform extent size?

Thanks for your help in advance.
Regards,

---
Madhavan
IBM Corporation
Integrated Technology Services


--== Sent via Deja.com http://www.deja.com/ ==--
Before you buy.


 Sent via Deja.com http://www.deja.com/
 Before you buy.
Received on Mon Jun 19 2000 - 00:00:00 CDT

Original text of this message

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