RE: SYSTEM TABLESPACE IS SO HUGE ?

I did not see any performance issues , except some space issues on the box..

-----Original Message-----
Sent: Thursday, August 15, 2002 5:54 PM
To: Multiple recipients of list ORACLE-L

Other than the SYSTEM tablespace consuming 10Gb of storage, are there any indications at all that there a performance problem of any kind related to the purported fragmentation?

Upshot: if it's not causing any problems, then just live with it; what's not hurting you isn't hurting you. Otherwise, if you can see problems related to data dictionary or if someone desperately wants that tablespace shrunk from 10Gb to 1Gb or less, then recreate the database...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 15, 2002 1:18 PM

> Yes Steve, System tablespace was fragmented heavily and that's why its
> taking 10 Gig .
> The database size is 75 gig , and would you suggest me to take Full
database
> EXPORT and import it back after creating a new database with same
structure
> ??
>
> or is there any best or simple way ??
>
> Thanks
> Madhu
>
> -----Original Message-----
> Sent: Thursday, August 15, 2002 1:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 10G? Must have a lot of objects not belonging to sys/system in there.
> (Unless someone turned auditing on and forgot about it.) I'd say the
system
> tablespace must be so fragmented that it's best to create another database
> and recreate the users and import their data with default and quota set to
> locally managed tablespace(s).
>
>
> -----Original Message-----
> Sent: Thursday, August 15, 2002 12:07 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello Listers,
> We have a database for which the SYSTEM tablespace size is nearly 10 gig ,
> Now I have a plan to reduce the size of it . And database is running on
> 8.1.7.2.
> What would be the best and faster way to do it. Your ideas will be very
much
> appreciated !!
>
> Thank in advance,
> Madhu
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Reddy, Madhusudana
> INET: Madhusudana.Reddy_at_bestbuy.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: Orr, Steve
> INET: sorr_at_rightnow.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: Reddy, Madhusudana
> INET: Madhusudana.Reddy_at_bestbuy.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: Tim Gorman
  INET: Tim_at_SageLogix.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: Reddy, Madhusudana
  INET: Madhusudana.Reddy_at_bestbuy.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).