| Sysaux tablespace full [message #648713] |
Tue, 01 March 2016 10:38  |
 |
manishdba007
Messages: 27
Registered: September 2014
Location: India
|
Junior Member |
|
|
Hello All,
We are having our Sysaux tablespace full. Please find below details
For now i have added a datafile in this to keep going.
Tablespace Size (MB) Free (MB) % Free % Used
------------------------------ ---------- ---------- ---------- ----------
SYSAUX 32320 1582.4375 5 95
OCCUPANT_DESC SPACE_USAGE_KBYTES
---------------------------------------------------------------- ------------------
Server Manageability - Automatic Workload Repository 30462464
Server Manageability - Optimizer Statistics History 448320
XDB 129984
Server Manageability - Advisor Framework 101952
Oracle Spatial 67712
Enterprise Manager Repository 46528
Analytical Workspace Object Table 39104
OLAP API History Tables 39104
Oracle Multimedia ORDDATA Components 13888
LogMiner 13696
Server Manageability - Other Components 11200
Unified Job Scheduler 10432
OLAP Catalog 5248
Expression Filter System 3712
Oracle Text 3712
Workspace Manager 3584
Transaction Layer - SCN to TIME mapping 3328
SQL Management Base Schema 1728
PL/SQL Identifier Collection 1728
Logical Standby 1408
Oracle Streams 1024
Enterprise Manager Monitoring User 832
Oracle Multimedia ORDSYS Components 448
Automated Maintenance Tasks 320
Now i told my client that this is because of AWR info gatherd in Sysaux and we have to purge it. Once i got confirmation from customer i executed below package -
BEGIN
dbms_workload_repository.drop_snapshot_range(low_snap_id => ****, high_snap_id=>*****);
END;
/
But it was hanged for long so i canceled it then i checked again view dba_hist_snapshot and nothing was there but when i checked the actual size of tablespace , space was still occupied and not released.
Please let me know whatever info required on this.
Please help me out in this. This is a prod system and client is killing me.
Rgds
Manish
*BlackSwan added {code} tags. Please do so yourself in the future.
How to use {code} tags and make your code easier to read
[Updated on: Tue, 01 March 2016 10:43] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
