| SYSAUX is running out of space [message #166431] |
Thu, 06 April 2006 05:05  |
aidi-h
Messages: 45
Registered: November 2005
|
Member |
|
|
I am currently reviewing a customers machine and found that the tablespace SYSAUX is steadily running out of available space.
It is filling up with various item owned by numerous owners including SYS,SYSTEM,EXFSYS,ORDSYS,MDSYS,WKSYS amongst others. Objects that are being created here include TABLE,LOB INDEXES,INDEX,INDEX PARTITIONS and others.
Can anyone advise why this may be gradually increasing and the best method to clear this down?
I can always increase the tablespace however I would like to see if this can be tidied up instead.
|
|
|
|
|
|
|
|
| Re: SYSAUX is running out of space [message #166438 is a reply to message #166437] |
Thu, 06 April 2006 05:24  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
For some reason, SYSAUX is been used default tablespace for all the optional schemas.
As said before, If you are not using those options, lock the accounts or remove them.
If you are using them, move those objects gracefully to another regular tablesepace.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
