查出系统中使用到全局临时表的SQL

查出系统中使用到全局临时表的SQL

select b.object_owner, b.object_name, a.temporary, sql_text 
from dba_tables a, v$sql_plan b, v$sql c 
where a.owner = b.object_owner 
and a.temporary = 'Y' 
and a.table_name = b.object_name 
and b.sql_id = c.sql_id;