| Oracle - Coalesce [message #58782] |
Tue, 30 September 2003 08:42  |
arun.gohil
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
Hi,
Just wanted to know what coalesce actually means ??
Is it just to get all the extents (free space) together so to stop further fragmentation ??
Appreciate your help .
regards
Arun.
|
|
|
|
| Re: Oracle - Coalesce [message #58787 is a reply to message #58782] |
Tue, 30 September 2003 10:57  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
you mean tablespace coalesce ? it basically coalesces(joins) ADJACENT free space chunks to make a larger 'CONTIGOUS' chunk , thereby increasing the chances of being used by extent allocation.
When you make use of Locally Managed tablespaces with uniform extent allocation, you virutally eliminate any tablespace fragmentation.
It does NOT get all the extents (free space) to stop fragmentation.
-Thiru
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
