Home » RDBMS Server » Server Administration » System TableSpace is so big (Oracle 10g R2, Linux)
System TableSpace is so big [message #524710] Mon, 26 September 2011 05:05 Go to next message
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.
Re: System TableSpace is so big [message #524714 is a reply to message #524710] Mon, 26 September 2011 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: System TableSpace is so big [message #524717 is a reply to message #524710] Mon, 26 September 2011 05:24 Go to previous messageGo to next message
halim
Messages: 99
Registered: September 2008
Location: Bangladesh
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 Go to previous messageGo to next message
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 166 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 Go to previous messageGo to next message
halim
Messages: 99
Registered: September 2008
Location: Bangladesh
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 Go to previous message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Mview is not refreshing
Next Topic: table can not shrink
Goto Forum:
  


Current Time: Tue Jul 29 21:04:16 CDT 2014

Total time taken to generate the page: 0.08901 seconds