| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> [Q] How can I tell RDBMS engine to start the coalescent
process ? - Reply
Content-Length: 1747
salutations;
i gather you can alter session set events 'immediate trace name coalesce
level tablespace#';
where ts# is value in sys.ts$.
best of luck let us know if it works for U.
peter
>>> ~{VwHN~} Wang <eleeb0p_at_MENUDO.UH.EDU> 01/16 7:32 am >>>
Hi everyone,
Is there a way to force ORACLE to coalesce the free space?
I know in the 7.0 you can set event to do that. How about the 7.1 or 7.2?
I experienced some weired problem. When I droped an index I can not recreate that index using same creating scripts. ( Off cause the data itself only has little change ). But after a while let's say 30 minutes I can create the index again using the same scripts.
I report that to ORACLE, guess what? What they tell me is I should not drop the index and recreate it normally if I really want to do that I have to leave at least 50% indexes tablespace free.
Unbelievable!!
There are Two problem involved here, one is the RDBMS does not coalesce
free space in time, the other is sometimes RDBMS will leave a temporary
segment in the index tablespace( NOT the temp tablespace, sitting there
until next coalesce event happens)!
Off cause the representative I talked with did not admit that is a
Oracle Bug. We have some batch job running every night need to reload some
tables I drop the index recreate it after loaded. Now I have to get up
every night to rerun the scripts.
Any people here please give me a help. How can I tell RDBMS please start the damned coalescing process right now?
TIA, --
 |
 |