sysaux tablespace growing after database upgrade to 12.2

  • From: "Jeffrey Beckstrom" <jbeckstrom@xxxxxxxxx>
  • To: "oracle-l-freelist" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Feb 2019 08:53:16 -0500

Our SYSAUX tablespace is growing following a database upgrade from 11.2.0.4 to 
12.2.0.1 in mid-December. We matched MOS notes 2305512.1 and 2305512.1. We 
followed instructions in 2439129.1. 

However, below query still showed an increase in objects for the 
AUTO_STATS_ADVISOR_TASK task from yesterday's values.
/* 
from note 2305512.1

https://support.oracle.com/epmos/faces/DocumentDisplay?parent=SrDetailText&sourceId=3-19410576981&id=2305512.1)
  
*/ 

COL TASK_NAME FORMAT A35 
SELECT TASK_NAME, COUNT(*) CNT 
FROM DBA_ADVISOR_OBJECTS 
GROUP BY TASK_NAME 
ORDER BY CNT DESC; 

Does something else need to be done?

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113


Other related posts: