SQL> select /* 我在shared_pool中吗*/ 1 from dual;
1
----------
1
SQL> select sql_text from v$sqlarea where sqL_text like '%shared_pool%' and sql_text not like '%v$sqlarea%'
2 ;
SQL_TEXT
--------------------------------------------------------------------------------------------------------------------------------------------
select /* 我在shared_pool中吗*/ 1 from dual
在v$sqlarea中 用sql_text 匹配到你的SQL,说明你的SQL有父游标parent cursor 在shared pool中
SQL> select sql_text from v$sql where sqL_text like '%shared_pool%' and sql_text not like '%v$sqlarea%'
2 ;
SQL_TEXT
--------------------------------------------------------------------------------------------------------------------------------------------
select /* 我在shared_pool中吗*/ 1 from dual
在V$SQL中用sql_text 匹配到你的SQL,说明你的SQL有子游标在shared pool中
1
----------
1
SQL> select sql_text from v$sqlarea where sqL_text like '%shared_pool%' and sql_text not like '%v$sqlarea%'
2 ;
SQL_TEXT
--------------------------------------------------------------------------------------------------------------------------------------------
select /* 我在shared_pool中吗*/ 1 from dual
在v$sqlarea中 用sql_text 匹配到你的SQL,说明你的SQL有父游标parent cursor 在shared pool中
SQL> select sql_text from v$sql where sqL_text like '%shared_pool%' and sql_text not like '%v$sqlarea%'
2 ;
SQL_TEXT
--------------------------------------------------------------------------------------------------------------------------------------------
select /* 我在shared_pool中吗*/ 1 from dual
在V$SQL中用sql_text 匹配到你的SQL,说明你的SQL有子游标在shared pool中
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25462274/viewspace-2123429/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25462274/viewspace-2123429/