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 Jan 2017

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 in 12.2 you can load directly from AWR

COE SQL Profile comes with SQLT

Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram