Mark D Powell wrote:
>
> On Oct 14, 7:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> aman.oracle.dba wrote:
>>> Hi all,
>>> I know that we have to reorganise dictionary tablespace but pls inform
>>> does reorganisation of local tablespace also require.
>>> If yes then how to check which one.
>>> Thanks in advanceI've never heard of HAVING to reorganize anything without metrics.
>> What makes you think a reorg. is required?
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> The need to reorganize a tablespace to reclaim and consolidate free
> extents is pretty much associated with dictionary managed tablespaces.
I agree but that wasn't my point. It appeared to me that the OP had some
bit of mythology tucked into their belt that generically said you must
frequently reorg. I was asking for what metric led them to the
conclusion that any specific point-in-time was the time to do it.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Oct 15 2006 - 12:06:40 CDT
