********************************************************************************
select (select fn_c1_codenm(c4) from dual), c4
from function_table
Call Count CPU Time Elapsed Time Disk Query Current Rows
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Parse 1 0.001 0.001 0 0 0 0
Execute 1 0.000 0.000 0 0 0 0
Fetch 1001 0.069 0.081 0 1249 0 100000
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Total 1003 0.070 0.082 0 1249 0 100000
Misses in library cache during parse : 1
Optimizer Goal : FIRST_ROWS
Parsing user : SCOTT (ID=32)
Rows Row Source Operation
------- -----------------------------------------------------------------------
3 FAST DUAL (cr=0 pr=0 pw=0 time=0 us cost=2 size=0 card=1)
100000 TABLE ACCESS FULL FUNCTION_TABLE (cr=1240 pr=0 pw=0 time=457485 us cost=68 size=300000 card=100000)
Wait Event Name Count Wait(sec) Max Wait
-------------------------------------------------- ------- ---------- ----------
SQL*Net message to client 1001 0.005 0.000
SQL*Net message from client 1001 0.228 0.001
-------------------------------------------------- ------- ---------- ----------
Total 2002 0.233
********************************************************************************
SELECT C2 FROM C1_CODE_NM WHERE C1=:B1
Call Count CPU Time Elapsed Time Disk Query Current Rows
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Parse 0 0.000 0.000 0 0 0 0
Execute 1 0.001 0.001 0 0 0 0
Fetch 1 0.000 0.000 0 3 0 1
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Total 2 0.001 0.001 0 3 0 1
Misses in library cache during parse : 0
Optimizer Goal : ALL_ROWS
Parsing user : SCOTT (ID=32)
Recursive Depth : 1
********************************************************************************
SELECT C2 FROM C1_CODE_NM WHERE C1=:B1
Call Count CPU Time Elapsed Time Disk Query Current Rows
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Parse 0 0.000 0.000 0 0 0 0
Execute 1 0.000 0.000 0 0 0 0
Fetch 1 0.000 0.000 0 3 0 1
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Total 2 0.000 0.000 0 3 0 1
Misses in library cache during parse : 0
Optimizer Goal : ALL_ROWS
Parsing user : SCOTT (ID=32)
Recursive Depth : 1
********************************************************************************
SELECT C2 FROM C1_CODE_NM WHERE C1=:B1
Call Count CPU Time Elapsed Time Disk Query Current Rows
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Parse 0 0.000 0.000 0 0 0 0
Execute 1 0.000 0.000 0 0 0 0
Fetch 1 0.000 0.000 0 3 0 1
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Total 2 0.000 0.000 0 3 0 1
Misses in library cache during parse : 0
Optimizer Goal : ALL_ROWS
Parsing user : SCOTT (ID=32)
Recursive Depth : 1
********************************************************************************
환경은
os는 window 10 사용중이며, virtual box 를 통해서 레드햇 5.5 오라클 11g 사용중이고
orange for oracle 32bit 이용해서 작업중입니다.
위의 쿼리를 날렸을 때 위와 같은 트레이스가 출력되는데
이런 결과의 트레이스가 출력되는데
Call Count CPU Time Elapsed Time Disk Query Current Rows
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Parse 0 0.000 0.000 0 0 0 0
Execute 1 0.000 0.000 0 0 0 0
Fetch 1 0.000 0.000 0 9 0 3
------- ------ -------- ------------ ---------- ---------- ---------- ----------
Total 2 0.000 0.000 0 9 0 3
이런식으로 사용자 정의 함수에 대한 부분의 트레이스 결과를 합친것을 보고싶습니다.
도움 바랍니다!