Get the App
SLTechnology News&Howtos  ›  Database  › 

Solution to the problem of very high utilization of oracle 11g sysaux tablespace

Shulou Source: shulou.com Published: 2022-06-01 06:15:31 11月16日 Update

Today, I found that the sysaux tablespace of a database is soaring to nearly 100%, as shown in the figure:

Take a look at what takes up space:

Is the relevant content of awr, need to rebuild awr to free space, specific reconstruction steps, please refer to my other blog post: http://blog.itpub.net/20893244/viewspace-2146541/

~ method of temporary deletion ~

Truncate table WRH$_ACTIVE_SESSION_HISTORY

Truncate table WRH$_EVENT_HISTOGRAM

Truncate table WRH$_SQLSTAT

Truncate table WRH$_LATCH_MISSES_SUMMARY

Truncate table WRH$_LATCH

Truncate table WRH$_SYSSTAT

Truncate table WRH$_SEG_STAT

Truncate table WRH$_PARAMETER

Truncate table WRH$_SYSTEM_EVENT

Truncate table WRH$_SQL_PLAN

Truncate table WRH$_DLM_MISC

Truncate table WRH$_SERVICE_STAT

Truncate table WRH$_TABLESPACE_STAT

Truncate table WRH$_ROWCACHE_SUMMARY

Truncate table WRH$_MVPARAMETER

~ ~

Select distinct 'truncate table' | | segment_name | |';', s.bytes/1024/1024

From dba_segments s

Where s.segment_name like 'WRH$%'

And segment_type in ('TABLE PARTITION',' TABLE')

And s.bytes/1024/1024 > 100

Order by s.bytes/1024/1024/1024 desc

Tags: Space content method data database steps Tianfa such as figure reference utilization problem Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS OPPO Reno MariaDB Xiaomi NVidia