OEM Is Not Displaying the Execution Plan From Top Acitivity
(Doc ID 2439415.1)
Last updated on MAY 19, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 13.1.0.0.0 and later Information in this document applies to any platform.
Symptoms
In 13c EM, execution plan is not available from top activity page of EM:
Login to EM console Navigate to the DB home page (12.1.0.2) Click on Performance > Top Activity Logged in to the database as a user: C##U264195 Selected SQLID Click on "Plan" tab. It shows: Execution Plan is not available
When logged in as SYS user, able to see the plan at container level
For the DB user, these are the roles:
SQL> select * from dba_role_privs where grantee='username'; GRANTEE GRANTED_ROLE ADM DEL DEF COM ------------------------------ ------------------------------ --- --- --- --- username OEM_MONITOR NO NO YES NO username SELECT_CATALOG_ROLE NO NO YES YES username OEM_ADVISOR NO NO YES YES SQL> select * from dba_sys_privs where grantee='username'; GRANTEE PRIVILEGE ADM COM ------------------------------ ---------------------------------------- --- --- username ADVISOR NO YES username CREATE SESSION NO YES username SELECT ANY DICTIONARY NO YES
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!