| Is it OK to coalease tblsp every hour [message #138282] |
Wed, 21 September 2005 03:15  |
ivanlvwong
Messages: 1
Registered: September 2005
Location: Malaysia
|
Junior Member |
|
|
Hi all,
I have a dev env that the free space is very fragmented. The previous DBA has written a nice script to coalease all the tblsp every hour. Is there any "bad" effect of doing this?
|
|
|
|
|
|
| Re: Is it OK to coalesce tblsp every hour [message #138312 is a reply to message #138286] |
Wed, 21 September 2005 05:16  |
alliejane
Messages: 59
Registered: July 2005
Location: Glasgow
|
Member |
|
|
In LTM's coalesce is not required or performed by SMON or otherwise, if you use DMT's then the benefit of coalesce is limited to only bringing together adjacent extents therefor not really that useful..
As Jay says as of 8i Locally Managed Tablespaces became available and there is NO good reason not to use them, even if you have migrated from previous versions there are utilities to convert DMT's to LTM's, or you can use the alter table move tablespace; command to move DMT's segments to LMT's tablespaces..
Allie
[Updated on: Wed, 21 September 2005 05:17] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
