Skip to Main Content

DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Why I cannot use in v$sql for sqlid?

3018678Aug 24 2015 — edited Aug 24 2015

I collect sql_ids for some queries and insert into a table. However, when I try to get these sql_text's from v$sqlarea it is running very long time. Does anyone know why?

For example, lets consider the following query. Normally, the sub sqlect query should be like select sql_id form my_table. And suppose this table has 40 unique sql_id.

select * from v$sqltext

where sql_id in (select sql_id from v$sqlarea);

Thanks in advance.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 21 2015
Added on Aug 24 2015
1 comment
678 views