(John Hallas) I like the memory advisors that are available from the OEM GUI or the direct database tables themselves. If I want a quick overview of whether a memory area (shared_pool, cache or the overall memory target itself) needs reviewing look there first.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help