Automating Coalesce on Tablespaces

[ronnie]

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.

[ocpwannabe]

its a grate idea to duplicate what smon is already doing.

[pando]

why you dont use LMT instead?

[ronnie]

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.

[vndba]

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

[ronnie]

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]

[marist89]

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

[marist89]

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]

I personally haven't coalesced a tablespace in about 2 years, but if you're doing it every day, automate it.