OraFAQ Forum: Server Administration » System TableSpace is so big

Home » RDBMS Server » Server Administration » System TableSpace is so big (Oracle 10g R2, Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

System TableSpace is so big [message #524710]

Mon, 26 September 2011 05:05

ntt85
Messages: 34
Registered: July 2011
Location: vietnam

Member

Hi all,

Today I see my system tablespace is 98%, 480 MB used. Why the system tablespace is so big? What should I do at this situation?

Thanks for helps.

Report message to a moderator

Re: System TableSpace is so big [message #524714 is a reply to message #524710]

Mon, 26 September 2011 05:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Why the system tablespace is so big?

Query DBA_SEGMENTS to know which take the space.

Quote:

What should I do at this situation?

First check there is no user objects in it.
Then check SYS.AUD$ table maybe you have an audit activated and never purge the audit trail.

Regards
Michel

Report message to a moderator

Re: System TableSpace is so big [message #524717 is a reply to message #524710]

Mon, 26 September 2011 05:24

halim
Messages: 100
Registered: September 2008

Senior Member

first see what objects (and what size) are there ....

SELECT   segment_name, segment_type, owner, BYTES
    FROM dba_segments
   WHERE tablespace_name = 'SYSTEM'
ORDER BY BYTES DESC;

sorry for duplicate answer. my link is slow.
regards
Halim

[Updated on: Mon, 26 September 2011 05:25]

Report message to a moderator

Re: System TableSpace is so big [message #524722 is a reply to message #524717]

Mon, 26 September 2011 05:38

ntt85
Messages: 34
Registered: July 2011
Location: vietnam

Member

I attached my results from dba_segments table. And have no data in SYS.AUD$ table. how can I do next?

Attachment: segment.txt
(Size: 44.18KB, Downloaded 1894 times)

[Updated on: Mon, 26 September 2011 05:42]

Report message to a moderator

Re: System TableSpace is so big [message #524726 is a reply to message #524722]

Mon, 26 September 2011 05:53

halim
Messages: 100
Registered: September 2008

Senior Member

I think you should increase your system tablespace size .
and
just make sure that non sys or system user objects are not here.

regards
Halim

[Updated on: Mon, 26 September 2011 06:00]

Report message to a moderator

Re: System TableSpace is so big [message #524728 is a reply to message #524722]

Mon, 26 September 2011 06:06

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You have many procedure/package codes.
The only thing you can do is increased the size of your SYSTEM tablespace (which seems very low, it should be at least 500M for a test database).

Regards
Michel

Report message to a moderator

Previous Topic:	Mview is not refreshing
Next Topic:	table can not shrink

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 04:41:31 CST 2024