sysaux tablespace growing after database upgrade to 12.2

From: Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
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-l
Received on Wed Feb 13 2019 - 14:53:16 CET

Original text of this message