Are you rebuilding indexes with unrecoverable/nologging and parallel clause
or simple 'alter index index_name rebuild tablespace tbs_name', which is
definately slow then using above options500/600MB indexes may take
around 30/35 minutes depending of your parallel clause and cpu
Thank you everyone who replied. All suggestions were very helpful. I am
bebuilding my indexes in a different tablespace. It runs very very slow..
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 3:51 PM
Lyuda;
1.
Lyuda;
1. Create a new tablespace for the indexes on a seperate drive. Make sure
you do this with a much more reasonable datafile size. (Watch it here
maybe they did the big size because they were running out of possible files
-- see the max_datafiles parm on the Create Database command)
Hi Lyuda
This is not a nice situation to bee in, but the god new is that oracle can help
you since you are using version 8.1.6 !
You can use the ALTER INDEX index-name REBUILD TABLESPACE
new-tablespace_name; to move the index to a new tablespace and this can even
be don online with ALTER INDEX
Lyuda,
You didn't say if you have other disk space available or not. If you do I would create
the index/indexes tablespace/s on different drives then drop them from the original
location. After you get breathing room you can reorg the database to a more
comfortable setup. When you have removed
You can check alter index clause and you will find parallel option. You may
use parallel 5 safely being default in initSID.ora. However it will start
building 5 times extent in temp tablespace before completion of rebuilding.
With rebuilding large indexes on regular basis we have to use all