sysaux tablespace growing after database upgrade to 12.2
Date: Wed, 13 Feb 2019 08:53:16 -0500
Message-Id: <5C64214C0200000B00051E09_at_groupwise2014.gcrta.org>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 13 2019 - 14:53:16 CET