Skip to Main Content

DevOps, CI/CD and Automation

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
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
606 views