Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Autonomous DB Error: cannot fetch last explain plan from PLAN_TABLE

Karine KonstantinyanApr 9 2024 — edited Apr 9 2024

Hello to everyone!
I've created Oracle Autonomous DB on OCI Always Free
When I try to run following command, I receive the error “Error: cannot fetch last explain plan from PLAN_TABLE”

select * from table(dbms_xplan.display)

Error: cannot fetch last explain plan from PLAN_TABLE

I've checked the existance of Plan_table by following query, and got results as below:

SELECT
    OWNER,
    OBJECT_NAME,
    OBJECT_TYPE,
    CREATED
FROM
    ALL_OBJECTS
WHERE
    OBJECT_NAME LIKE 'PLAN_TABLE%'
    AND OWNER IN ( SYS_CONTEXT('userenv', 'current_schema'), 'PUBLIC', 'SYS' );

Thanks in advance for any help!

Comments
Post Details
Added on Apr 9 2024
2 comments
1,934 views