[ORACLE] 커서 공유 테스트
alter system flush shared_pool; -- 1회 실행 select /* cursor_test */ empno, ename, job, sal, deptno from EMP where empno = 7788; select sql_id, parse_calls, loads, executions, invalidations, decode(sign(invalidations), 1, (loads-invalidations), 0) reloads from v$sql where sql_text like '%cursor_test%' and sql_text not like '%v$sql%'; -- 2회 실행 select /* cursor_test */ empno, ename, job, sal, deptno ..