| local vs dictionary tablespaces [message #64812] |
Mon, 09 February 2004 19:32  |
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 #64814 is a reply to message #64812] |
Wed, 11 February 2004 06:46  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
