Home » RDBMS Server » Server Administration » system tablespace had been used more.
system tablespace had been used more. [message #553379] Fri, 04 May 2012 01:18 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
In my database ,the size of the system tablespace is 1024M.now i found its free space is 477.875M.

SQL> SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024 M  FROM DBA_FREE_SPACE where tablespace_name = 'SYSTEM' GROUP BY TABLESPACE_NAME ;
TABLESPACE_NAME    M
---------------   -------
SYSTEM            477.875


In system tablespace ,the max size segment is IDL_UB1$,it is 167M

SQL> SELECT SEGMENT_NAME, SX || 'M' "Size" FROM (SELECT SEGMENT_NAME,SUM(BYTES)/1024/1024 SX FROM DBA_SEGMENTS   WHERE TABLESPACE_NAME = 'SYSTEM' GROUP BY SEGMENT_NAME) WHERE SX > 100 ORDER BY SX DESC;
SEGMENT_NAME     Size
-------------    -----
IDL_UB1$         167M


QUESTION: what's the table IDL_UB1$ used for ?
Re: system tablespace had been used more. [message #553380 is a reply to message #553379] Fri, 04 May 2012 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 67810
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL binary stored code.

Regards
Michel
Re: system tablespace had been used more. [message #553381 is a reply to message #553380] Fri, 04 May 2012 02:00 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
what's the size of system tablespace will be used normally?
Re: system tablespace had been used more. [message #553509 is a reply to message #553381] Sat, 05 May 2012 20:59 Go to previous messageGo to next message
SSharma
Messages: 17
Registered: July 2011
Location: INDIA
Junior Member
It depends on the features installed and used like auditing ,JVM ,XML etc .
Re: system tablespace had been used more. [message #553536 is a reply to message #553379] Sun, 06 May 2012 10:14 Go to previous message
martijn
Messages: 286
Registered: December 2006
Location: Netherlands
Senior Member
1024M is a nice round number. I _guess_ that the tablespace is made of 1 data file which was created with a size of 1G=1024M.
That there is a lot of free space in it, is not worrysome I would say.
Previous Topic: how to get process information.
Next Topic: monitoring unusable objects
Goto Forum:
  


Current Time: Wed Apr 14 19:06:50 CDT 2021