Why I cannot use in v$sql for sqlid?

3018678

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.

Unknown

95dd379a-3504-4cc6-8697-0e5a4f510cb5 wrote:

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?

How do I ask a question on the forums?

https://community.oracle.com/message/1814597#1814597

how can we reproduce what you report?

What problem are you really trying to solve?