7782 CLARK 2450
SQL> select * from t where empno=7782;
EMPNO ENAME SAL
---------- ---------- ----------
7782 CLARK 2450
/*********************由下面的查询(v$sqlarea)可知产生了3个父游标，其中一个父游标(2r6rbdp92kyh9)执行了2次************/
/**************************************************/
/* Author: Robinson Cheng */
/* Blog: http://blog.csdn.net/robinson_0612 */
/* MSN: robinson_0612@hotmail.com */
/* QQ: 645746311 */
/**************************************************/
SQL> col sql_text format a40
SQL> select sql_id,sql_text,executions from v$sqlarea
2 where sql_text like '%empno=7782%' and sql_text not like '%from v$sqlarea%';
SQL_ID SQL_TEXT EXECUTIONS
------------- ---------------------------------------- ----------
4rs2136z084y1 SELECT * from t where empno=7782 1
84w067b4n91h5 SELECT * FROM t WHERE empno=7782 1
2r6rbdp92kyh9 select * from t where empno=7782 2 |