EM 13c : SQL Details Page Historical View Does Not Show ALL Plans Under Plan Tab (Doc ID 2964270.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Symptoms

SQL details page for historical SQL does not show all plans under plan tab.


In this example, <SQL ID> has 6 PLAN_HASH_VALUE

1. From PDB Home page, peformance -> SQL -> Serach SQL.
   Search SQL page, select AWR Snapshots Last 7days.
   enter SQL ID, And search.

2. From search result, select SQL ID, and it shows SQL Details Page.

3. Select Historical from "View Data"

4. Check each tab.
   Statistics Tab show 6 Plan Hash values.
   But Plan tab does not show 6 Plan Hash values,
   show only 1 Plan Hash vaule.

Changes

Cause

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