'No Object Found' When Describing v$SQL in SQL*Developer (Doc ID 3024937.1)

Last updated on MAY 30, 2024

Applies to:

Goal

When using SQL*Developer logged into a 19c Oracle EBS (Oracle E-Business Suite) database with a single PDB (pluggable database) as the user SYSTEM, v$sql can be queried with a statement like 'select * from v$sql'.
However. when doing a describe (desc v$sql), the error "No Object Found: v$sql" shows up.
Running the same command when connected to a 12c database, the describe works as intended.
What is difference and what can be done to make the describe functionality of SQL*Developer work on a 19c database the same as a 12c database?
 

Solution

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