RE: huge datafiles/need help

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 such option to expedite such operation...
Regards

MOHAMMAD RAFIQ Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Fri, 03 Aug 2001 09:10:44 -0800

I am doing unrecoverable(of course) but not parallel clause. I don't think the system can handle it and to be honest w/you I don't know much about it..I am looking for a reference to doc's to learn more about it. I scrambled for space and extended temp tablespace today again and it looks like it is doing much better..thanks for your concern Mohammad.

-----Original Message-----
Sent: Friday, August 03, 2001 12:40 PM
To: Multiple recipients of list ORACLE-L

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 options....500/600MB indexes may take around 30/35 minutes depending of your parallel clause and cpu availability...

MOHAMMAD RAFIQ Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Thu, 02 Aug 2001 20:32:35 -0800

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" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 02, 2001 3:51 PM

> 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)
> 2. Rebuild the indexes over into the new tablespace. Make sure your
> initial paramater fits in the initial size of the data files.
> 3. Drop your old Index Tablespace.
>
> As for your ALTER DATABASE DATAFILE .... RESIZE ... goes; thats what
happens
> when you use all your space. I would suggest at some point to take an
> outage and reorg that tablespace containing the table as well to get its
> files down in to a resonably managed size.
>
>
>
> -----Original Message-----
> Sent: Thursday, August 02, 2001 2:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi List,
> I have a monster tablespace 36 G with two datafiles 32 G and 4 G. Don't
ask
> me who created such a file because I don't know. I am trying to rescue
the
> database that has multiple problems. Something you've never seen
before.
> Bye the way, did anyone ever run a test how much stuff you can put on
your
> disc before it dyes? Well, yesterday I found a disc which was 99.07 %
full.
> Anyway...
> The tablespace is ~ 50 % free. The bad news is it doesn't let me to
reduce
> the size of the datafiles by using 'alter database datafile ...
resize...';.
> That tablespace contains 32 indexes. Some of them are as large as
600 -800
> M. I need to develop a plan of attack.
> My options are:
> 1) drop and recreate the indexes;
> 2) rebuild the indexes in different tablespace/tablespaces;
> 3) export/import indexes or may be even tablespace all at once.
>
> Is there anyone who has done something similar before?
> All suggestions are greatly appreciated. That database is screaming for
> help!!
> It running Oracle 8.1.6 on NT.
>
> Lyuda Hoska
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: lhoska_at_calibresys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: lyudah
    INET: lyudah_at_home.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
   INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
   INET: lhoska_at_calibresys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).