Shulou(Shulou.com)05/31 Report--

This article shows you the system tablespace sysaux alarm how to do, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

Test test library sysaux tablespace alarm (insufficient space), log on to see the next sysaux default is 5 gigabytes, there is still 500m left, the utilization rate is 90%.

In fact, sysaux is automatically extended, this matter does not care, but it is troublesome to call the police all the time.

Two methods:

I. the most popular plus data file (abbreviated)

Second, query the segment that takes up the most space in this table space

Select owner, segment_name, segment_type, bytes/1024/1024 from (select * from dba_segments where tablespace_name='SYSAUX' order by bytes desc) where rownum select dbid, retention from dba_hist_wr_control

DBID RETENTION

-

1179054930 + 00008 00VOV 00VOO 00.0

2. View the minimum and maximum snap_id

SQL > select max (snap_id), min (snap_id) from WRM$_SNAPSHOT_DETAILS

151288 1

3. Clear the awr report

Exec dbms_workload_repository.drop_snapshot_range (1150789)

After execution, query the tablespace and find that it did not go down. Finally, it was found that it was a bug,bug and the number was 9797851.

Finally, we found a way to delete some of them on a small scale.

Steps:

1. Query storage for several days (10g is retained for 7 days, 11g is retained for 8 days)

SQL > select dbid, retention from dba_hist_wr_control

DBID RETENTION

-

1179054930 + 00008 00VOV 00VOO 00.0

2. View the minimum and maximum snap_id

SQL > select min (snap_id), max (snap_id) from dba_hist_snapshot where dbid = 1179054930

MIN (SNAP_ID) MAX (SNAP_ID)

--

149970 150789

3. Clear the awr report

SQL > exec dbms_workload_repository.drop_snapshot_range (149970, 150789, 1179054930)

The above content is the system tablespace sysaux alarm how to do, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.