FAW| FDIP : How To Run Oracle SQL Monitor for FDIP (Doc ID 3013800.1)

Last updated on AUGUST 01, 2024

Applies to:

Goal

Please note: Following steps are to be used only if you are working with Oracle Support team and is being requested by support for further analysis. 

How to run Oracle SQL Monitor for FDIP?

A SQL monitor report or querying v$sql_plan are the best methods for obtaining the actual execution plan of a SQL statement since sometimes the executed plan can be different from the plan shown in the EXPLAIN PLAN command.  The usage of bind variables, cursor sharing and adaptive execution plans are some of the reasons for this difference.  For a more detailed explanation see this blog. 

SQL monitoring requires the Oracle Tuning pack license (enabled by STATISTICS_LEVEL initialization parameter is either set to TYPICAL (the default value) or ALL.  How it works is documented here.

FDIP / FAW customers are licensed for SQL Monitor and they can access it through the console.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.