Patch install and SYSAUX tablespace fixes
RDBMS 11.2.0.2, Linux 64-bit.
I just applied patch 14373728 and all went well despite nagging errors in the postinstall.script ("SET PAGESIZE 0", and the role "gather_system_statistics" conflicts with another user or role name).
Probably shot myself in the foot dropping the "gather_system_statistics" role and re-running postinstall.sql, but that is yet to be seen.
So, I have 40 million rows to clear out of WRI$_OPSTAT_HISTGRM_HISTORY, and I'd like a "best practice". Here's what I think will work:
1) take a metadata only datapump export of the SYSAUX tablespace
2) shutdown the database and bring it up restricted
3) offline the tablespace, and move the datafiles out of the way