SQL Plan Management 12.2 Whitepaper

This whitepaper explains in detail why SQL plan management should be an integral part of the database equation. With many applications upgrading from previous versions of the database, this technology gets more enhanced with each release. This is accomplished through a series of auto task jobs that are detailed. SQL Plan Management Oracle 12c 12.2 […]

Using SQL Plan Management to Control SQL Execution Plans

Great article explaining this Using SQL Plan Management to Control SQL Execution Plans SPM Part 1 of 4 SQL Tuning SQL SPM Ask Tom SQL Tuning Guide Tools Internal To The Database ADDM SQL Tuning Advisor SQL Access Advisor SQL Plan Management SQL Performance Analyzer In Oracle 12.2 you can filter the capture dbms_spm also […]