FAW| FDIP : How To Run Oracle SQL Monitor for FDIP
(Doc ID 3013800.1)
Last updated on AUGUST 01, 2024
Applies to:
Fusion Data Intelligence - Version N/A and laterNetsuite Analytics Warehouse
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |