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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yadavalli Aditya
Sent: Wednesday, May 31, 2006 9:02 AM
To: oracle-l_at_freelists.org
Subject: Tablespace reorganisation
Hi Everyone,
How can we know that a tablespace needs to be reorganised....?
I appreciate your responce.
Regards,
Yadavalli.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 31 2006 - 08:25:26 CDT
