Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.