Hi,
Is it a good Idea to schedule a job to automatically coalesce free space in each tablespace irrespective of adjacent free space exists or not.
Just a thought of of automating a regular DBA process.
Printable View
Hi,
Is it a good Idea to schedule a job to automatically coalesce free space in each tablespace irrespective of adjacent free space exists or not.
Just a thought of of automating a regular DBA process.
its a grate idea to duplicate what smon is already doing.
why you dont use LMT instead?
whats LMT Pando??
ocpwannabe smon will coalesce free space automatically if pctincrease is set to 0 (if i remember correctly) otherwise it wont.
The DBA has to do it manually then.
Hi:
I agree with Pando. LMT is the way to go. There is an automatic mapping feature in LMT that will automatically coalesce any fragment w/in the tablespace. Also, LMT is managed locally (as its name implied)-without the exessive recursive call to the dictionary, and thus saving you lots of resource overhead.
By the way, SMON won't automatically coalesce the tablespace if PCTINCREASE is set = 0. It must be set to !=0 for this to kick in.
Hope this helps. Good luck.
John
I see.....
LMT is Locally managed tablespaces.
The reason i did not understand the abbreviation was because i have never used LMT.
Also thanks for correcting me on the pctincrease value.
Can somebody throw more light on the LMT's (see I am learning the language now) .
Also till the time I learn about LMT's and be comfortable enough to implement them is automatic scheduling a good idea or not...
[Edited by ronnie on 03-14-2002 at 03:01 PM]
This topic has been discussed several hundred times in this forum. Use http://www.dbasupport.com/forums/search.php and search for LMT or Locally Managed Tablespaces
I personally haven't coalesced a tablespace in about 2 years, but if you're doing it every day, automate it.Quote:
Originally posted by ronnie
Also till the time I learn about LMT's and be comfortable enough to implement them is automatic scheduling a good idea or not...
[Edited by ronnie on 03-14-2002 at 03:01 PM]