Howard J. Rogers wrote:
> DA Morgan wrote:
>
>
>>Connor McDonald wrote:
>>
>>
>>>Charles wrote:
>>>
>>>
>>>>All,
>>>>
>>>>I have a 1.8TB database with all Dictionary Managed Tablespaces.
>>>>
>>>>It's a very active SAP Business Warehouse application.
>>>>
>>>>We've sort of reached 'critical mass' with the fragmentation of it,
>>>>and now SMON coalescing is so slow that "Disk Space Transaction" locks
>>>>are hanging up the entire db.
>>>>
>>>>I've added events to disable SMON coalescing while we deal with this.
>>>>
>>>>Oracle is telling me I must run tablespace coalescing at 'quiet' times
>>>>prior to migrating the tablespace to Locally Managed Tablespaces.
>>>>
>>>>I want to migrate them now to eliminate the contention on the fet$ and
>>>>uet$ tables in the SYSTEM tablespace.
>>>>
>>>>I await Oracle's technical reasons why I cannot migrate now.
>>>>
>>>>I have done the migration in all non-production instances of this
>>>>warehouse application; they ran seemingly ok and those databases are
>>>>performing well, according to the warehouse users.
>>>>
>>>>What is your experience with this? What's the problem or the bad
>>>>results in the LMT if I migrate these tablespaces now?
>>>>
>>>>Am looking for the quick fix now, to be following to reorgs later.
>>>>
>>>>Thank you.
>>>>
>>>>Charles
>>>
>>>
>>>Basically you're damned if you do, damned if you don't.
>>>
>>>Whilst migrating to LMT as is will leave you with a soup of extent
>>>sizes, it should still be better than where you are now.
>>>
>>>You may want to consider
>>>
>>>a) move to LMT
>>>b) piecemeal moving to "nice" LMT's as HJR suggests.
>>>
>>>Convincing management to do (b) once (a) is done might be a challenge...
>>>
>>>C
>>
>>Why can't he just build a new LMT and use ALTER TABLE MOVE ... moving
>>the tables one at a time?
>
>
> What do you think (a) I suggested? and (b) Connor is referring to in his
> point (b)??
>
> Regards
> HJR
Sorry ... missed it. Presumed it had never been said as it should have
ended the discussion.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Oct 23 2004 - 18:11:53 CDT
