| system tablespace had been used more. [message #553379] |
Fri, 04 May 2012 01:18  |
 |
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 #553536 is a reply to message #553379] |
Sun, 06 May 2012 10:14  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
