Locallly Managed Tablespaces

[scohan]

We're using Oracle 9.2 and would like to use Oracle Managed Tablespaces. LMT is new to me so I have a few questions.

1. Should we make the SYSTEM tablespace locally managed?

2. Should we make our LMT tablespaces UNIFORM or AUTOALLOCATED?

3. If UNIFORM, what size should we specify for the extents or how should we determine what size to give?

4. Should we out any initial and/or next extent sizing info in our create table statements?

Thanks.

 

[cliousa]

1. Should we make the SYSTEM tablespace locally managed?

No. I doubt you can do that in 9.2.0. AT least in 9.0.1 was still LMT. There's no benefit of doing it.


2. Should we make our LMT tablespaces UNIFORM or AUTOALLOCATED?

UNIFORM is better, since you have control over the extent's size.


3. If UNIFORM, what size should we specify for the extents or how should we determine what size to give?

That depends on your db block size. It has to be multiple of the block size.


4. Should we out any initial and/or next extent sizing info in our create table statements?

No. You still can use the table storage parameters. It's first the objects, then the tablespace.





Hope that helps,
clio_usa - OCP DBA
------------------

http://www.dbaclick.com