Top 10 non-AWR objects consuming high SYSAUX space
edited Sep 9, 2020 2:12PM in AHF - Autonomous Health Framework (TFA - ORACHK) (MOSC) 3 commentsAnswered ✓
Hi and thank you for orachk, I really appreciate this tool.
Almost exactly the same as my last post, I would ask you also in this case to add a Minimum Limit to the size that the non-AWR objects Need to reach before it becomes a warning. Otherwise I always get this warning on every freshly installed database.
SQL> REM Top 10 non-AWR objects consuming high SYSAUX space
SQL> SQL> set lines 200
SQL> set pages 100
SQL> col segment_name format a40;
SQL> col mb format 99,990.0;
SQL> col segment_type format a20;
SQL>
SQL> select 'NON_AWR ' as component, s.size_m as mb,
0