| 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 ?
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, --
 |
 |