Database Administration (MOSC)

MOSC Banner

sysaux is 90% full

edited Mar 10, 2016 4:06AM in Database Administration (MOSC) 2 commentsAnswered

Hi,

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

"CORE 11.2.0.2.0 Production"

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

Linux 2.6.18-128.el5 x86_64 x86_64 x86_64 GNU/Linux

------------------------------------------------------------------------------------------------

Hi,

When i first saw the rentention was 30 days. I made it to 10 days. i try to purge the sysdate -10. i dont see any affect on these occupants. Please suggest

Server Manageability - Optimizer Statistics History          is holding around 29GB

Server Manageability - Automatic Workload Repository    is holding around 28GB...

Server Manageability - Optimizer Statistics HistorySYS29.0748291015625
Server Manageability - Automatic Workload Repository

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center