RE: Tablespace reorganisation

Message

I think generally as a matter of convenience to you. I have noted that everytime a new DBA comes in he wishes to either increase the number of tablespaces from 5 to 40 or reduce them from 40 to 5. Management is impressed and it keeps him busy for a day or so. We also did it to change some dictionary managed tablespaces to locally managed. If your disks are managed properly you should haven't any performance reason to do so.

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Yadavalli Aditya
Sent: Wednesday, May 31, 2006 9:02 AM
To: oracle-l@freelists.org
Subject: Tablespace reorganisation

Hi Everyone,

How can we know that a tablespace needs to be reorganised....?

I appreciate your responce.

Regards,

Yadavalli.

RE: Tablespace reorganisation

Freeman, Donald

2006-05-31