| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SYSTEM TABLESPACE IS SO HUGE ?
Rogers thanks for the mail,
I am trying to resize the datafile associated to SYSTEM and getting the ORA-03297 error , can , what should I do to resize the datafile, I do not want to see SYSTEM tablespace taking that much space
Thanks,
Madhu
-----Original Message-----
Sent: Thursday, August 15, 2002 3:21 PM
To: Madhusudana.Reddy_at_bestbuy.com
Madhu,
From all that I understand about the system tablespace, There is no
easy way to defragment the system tablespace. An Export, rebuild, Import
( under the direction of Oracle Support according to the metalink notes)
is a way to defragment the system tablespace.
#What was the initial size of the system tablespace when created? Can
you explain the increase in size? Is your performance suffering and the
users complaining?
Be sure that you do a backup of everything before you attempt to work
on defraging the system tablespace.
Good luck,
Ron
ROR mª¿ªm
>>> "Reddy, Madhusudana" <Madhusudana.Reddy_at_bestbuy.com> 08/15/02
03:22PM >>>
Rogers ,
If you mean to say Writing is Creating the segments , I did not see
any
other user except SYS and SYSTEM users in the SYSTEM tablespace. But
some
user IDs which were created for replication purpose have the
Default_tablespace as SYSTEM , but they do not have any segments in
SYSTEM
tablespace . And there wont be any chance of creating a new
object/segment
under those users.
I believe the SYSTEM tablespace was fragmented and now I would like to resize it , would like to know best and fastest way
Thanks
Madhu
-----Original Message-----
Sent: Thursday, August 15, 2002 1:51 PM
To: Multiple recipients of list ORACLE-L
Madhu
some one or something is writing into your system tablespace. I
would
check to see if anyone has the system tablespace as their default
tablespace.
SELECT username from dba_users where default_tablespace ='SYSTEM';
or SELECT username from dba_users where temporary_tablespace
='SYSTEM';
Ron
ROR mô¿ôm
>>> Madhusudana.Reddy_at_bestbuy.com 08/15/02 02:06PM >>>
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).
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). Received on Thu Aug 15 2002 - 16:48:33 CDT
 |
 |