Home » RDBMS Server » Performance Tuning » local vs dictionary tablespaces
local vs dictionary tablespaces [message #64812] Mon, 09 February 2004 19:32 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
hi all, can anyone pls explain  autoallocate,uniform size, space management auto,manual and i'd also like to know when smon coalesec the free space keeping percent increase in view.

thanx in advance
Re: local vs dictionary tablespaces [message #64813 is a reply to message #64812] Wed, 11 February 2004 02:15 Go to previous messageGo to next message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

Some of your questions are answered here - http://www.orafaq.com/articles/archives/000011.htm

Best regards.

Frank
Re: local vs dictionary tablespaces [message #64814 is a reply to message #64812] Wed, 11 February 2004 06:46 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Regarding smon coalescing free space, it does automatically periodically when PCTINCREASE is non-zero , which is not recommended anyway as it causes fragmentation. It is recommended to have PCTINCREASE always to Zero.
Using Locally managed tablespaces with UNIFORM extent sizes eliminates tablespace fragmentation totally.

-Thiru
Previous Topic: size of the tables
Next Topic: Sample database for tuning tests
Goto Forum:
  


Current Time: Thu Oct 01 03:44:51 CDT 2020