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