When CURSOR OPEN is not going to get the data is not fetch, it will only get the data. Please see the experiment SQL> conn test / testconnected.sql> ALTER session set events '10046 Trace Name Context Forever, Level 12'; session altered.sql > DECLE 2 CURSOR C Is Select * from test1; 3 Begin 4 Open C; 5 Close C; 6 end; 7 / pl / sql procedure successfully completed.sql> ALTER session set events '10046 trace name context off'; session altered. [oracle @ jumper udump] $ cat * .trc / opt / oracle / admin / hsjf / udump / hsjf_ora_26966.trcOracle9i Enterprise Edition Release 9.2.0.3.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.3.0 - ProductionORACLE_HOME = /opt/oracle/product/9.2.0System name: LinuxNode name: jumper.hurray.com.cnRelease: 2.4.18-14Version: # 1 Wed Sep 4 13:35:50 EDT 2002Machine: i686Instance name: hsjfRedo thread MOUNTED by this instance: 11Unix Process Pid: 26966, Image: Oracle@jumper.hurray.com.cn (TNS V1-V3) *** 2004-02-22 23: 51: 41.363 *** session ID20 .3141) 2004-02-22 23: 51: 41.363Appname mod = 'sql * Plus' MH = 3669949024 ACT = '' AH = 4029777240 ===================== Parsing in Cursor # 1 LEN = 68 Dep = 0 UID = 41 OCT = 42 LID = 41 TIM = 1052268263050484 HV = 1346161232 ad = '54d7e004'alter session set events' 10046 trace name context forever, level 12'end of stmtexec # 1: c = 0, E = 211, p = 0, Cr = 0 , Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1052268263049839Wait # 1: Nam = 'sql * net message to client' ELA = 8 p1 = 1650815232 P2 = 1 p3 = 0 * ** 2004-02-22 23: 52: 06.023Wait # 1: Nam = 'SQL * NET Message from Client' ELA =
24081533 P1 = 1650815232 P2 = 1 p3 = 0 ===================== Parsing in Cursor # 1 LEN = 71 dep = 0 uid = 41 OCT = 47 LID = 41 TIM = 1052268287142522 HV = 190018789 ad = '54d87df0'declarecursor c is select * from test1; beginopen C; Close C; end; end of stmtparse # 1: c = 9765, E = 9616, P = 0, Cr = 0, Cu = 0, MIS = 1, R = 0, DEP = 0, OG = 4, TIM = 1052268287142473BINDS # 1: ===================== Parsing in Cursor # 3 LEN = 48 Dep = 2 uid = 0 Oct = 3 LID = 0 TIM = 10522268287143761 HV = 3997906522 ad = '53696c28'select user # from sys.user $ where name =' Outln'end of Stmtparse # 3: c = 0, E = 232, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 2, OG = 4, TIM = 1052268287143735BINDS # 3: EXEC # 3: C = 0, E = 190, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 2, Og = 4, TIM = 1052268287144166FETCH # 3: C = 0, E = 180, P = 0, Cr = 2, Cu = 0, MIS = 0, R = 1, DEP = 2, g = 4, TIM = 1052268287144402STAT # 3 ID = 1 CNT = 1 PID = 0 POS = 1 Obj = 22 OP = 'Table Access by Index RowID Obj # (22) (Cr = 2 r = 0 w = 0 TIME = 145 US) 'stat # 3 id = 2 CNT = 1 PID = 1 POS = 1 Obj = 44 op =' index unique scan obj # (44) (Cr = 1 r = 0 w = 0 TIME = 81 US) '===================== Parsing in Cursor # 2 LEN = 19 dep = 1 UID = 41 OCT = 3 LID = 4 1 TIM = 1052268287145054 hv = 1259978721 ad = '54d7b05c'select * from test1end of stmtparse # 2: c =
1953, E = 1802, P = 0, Cr = 2, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 1052268287145039BINDS # 2: EXEC # 2: c = 0, E = 134, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, Og = 4, TIM = 1052268287145318EXEC # 1: C = 3907, E = 2694, P = 0, Cr = 2, Cu = 0, MIS = 0, R = 1, DEP = 0, OG = 4, TIM = 1052268287145505Wait # 1: Nam = 'SQL * Net Message to Client' ELA = 9 P1 = 1 P3 = 0wait # 1: nam = 'sql * net message from client' ELA = 4961677 P1 = 1650815232 P2 = 1 p3 = 0stat # 2 id = 1 CNT = 0 PID = 0 POS = 1 obj = 14498 op = 'Table Access Full Test1 ( Cr = 0 r = 0 w = 0 TIME = 0 US) '===================== Parsing in Cursor # 1 g= 56 dep = 0 uid = 41 Oct = 42 LID = 41 TIM = 1052268292109059 HV = 527042363 AD = '54d8b9c4'alter session set events' 10046 trace name context off'end of stmtpival # 1: c = 0, E = 811, P = 0, Cr = 0, Cu = 0, MIS = 1, R = 0, DEP = 0, OG = 4, TIM = 1052268292109029BINDS # 1: EXEC # 1: C = 0, E = 197, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1052268292109432SQL> ALTER session set events '10046 Trace Name Context Forever, Level 12'; session altered.sql> Declare 2 v varcha2 (30); 3 Cursor C Is Select a from test1; 4 begin5 open c; 6 fetch c INTO v; 7 Close C; 8 end; 9 / pl / sql procedure successful company completed.sql> ALTER session set event off '; session altered. =============== ====== PARSING IN CURSOR # 1 LEN = 68 Dep = 0 UID =
41 OCT = 42 LID = 41 TIM = 1052268348282083 HV = 1346161232 ad = '54d7e004'alter session set events' 10046 Trace Name Context Forever, Level 12'End Of Stmtexec # 1: C = 0, E = 190, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1052268348282051Wait # 1: Nam = 'sql * net message to client' ELA = 9 p1 = 1650815232 P2 = 1 P3 = 0 *** 2004-02-22 23: 54: 15.491Wait # 1: nam = 'sql * net message from client' ELA = 65283612 P1 = 1 p3 = 0 ========= ============ PARSING IN CURSOR # 1 LEN = 100 dep = 0 uid = 41 OCT = 47 LID = 41 TIM = 1052268413585464 HV = 416332771 ad = '54d76b58'declarev varcha2 (30); cursor C is SELECT A from test1; beginopen C; Fetch C INTO V; Close C; End; End of StmtParse # 1: C = 9765, E = 18819, P = 0, Cr = 0, Cu = 0, MIS = 1, R = 0, DEP = 0, g = 4, TIM = 1052268413585420BINDS # 1: ===================== Parsing in Cursor # 2 LEN = 19 Dep = 1 UID = 41 OCT = 3 LID = 41 TIM = 1052268413587757 HV = 3226909281 ad = '54d7af2c'select a from test1end of stmtpival # 2: c = 1954, E = 1601, p = 0, Cr = 0, Cu = 0, MIS = 1, R = 0, DEP = 1, og = 4, TIM = 1052268413587721BINDS # 2: EXEC # 2: C = 0, E = 151, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 1052268413588187Wait # 2: Nam = 'DB file scattered read' ELA = 221 p1 = 11 p2 = 770 p3 = 2FETCH # 2: c = 1953, E = 1194, P = 2, Cr = 6, Cu = 1, MIS = 0, R = 1, DEP = 1, OG = 4, TIM = 1052268413589563exec # 1: c =
3907, E = 4119, P = 2, Cr = 6, Cu = 1, MIS = 0, R = 1, DEP = 0, o = 4, TIM = 1052268413589885Wait # 1: Nam = 'sql * net message to client' ELA = 8 p1 = 1650815232 p2 = 1 p3 = 0wait # 1: nam = 'sql * net message from client' ELA = 6374702 P1 = 1650815232 P2 = 1 p3 = 0stock = 1 cnt = 1 PID = 0 POS = 1 Obj = 14498 op = 'Table Access Full Test1 (Cr = 6 r = 2 w = 0 TIME = 1158 US)' ===================== Parsing in CURSOR # 1 LEN = 56 Dep = 0 UID = 41 OCT = 42 LID = 41 TIM = 1052268419965801 HV = 527042363 AD = '54d8b9c4'alter session set events' 10046 Trace Name Context Off'end of Stmtparse # 1: c = 0, E = 182, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1052268419965781BINDS # 1: EXEC # 1: C = 0, E = 203, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1052268419966144 [Oracle @ Jumper Udump] $
We can see that in the process of Open Cursor, we have not gotten data for data for data files to obtain data for data for data files. Wait # 2: nam = 'db file scattered read' ELA = 221 P1 = 11 P2 = 770 p3 = 2
Oracle Document has a description
SG: Introduction to oracle: on and on sql pl / sql 21-6 on CURSOR passage: THE OPEN statement executes the query associated with the cursor, identifies the active set, and positions the cursor (pointer) bifore the first row. the FETCH statement retrieves the current row and advances the cursor to the next row also 21-9 in the original version of the OPEN STATEMENT:. Open the cursor to execute the query and identify the active set, which consists of all rows that meet the Query search criteria.the Cursor Now Points to the first rowin the Active set.
When the cursor is not executed, this is not obtained by any data query SCN is determined when Open Cursor is OK, but the IO or the true query is that the IO has already proved about Query SCN when Fetch. Determine the following demo first to perform a PL / SQL SQL> Set ServerOut OnSql> Declare 2 v varcha2 (30); Cursor C Is Select D from test1 where a = 1; 3 4 Beginopen C; dbms_lock.sleep (60); sleep this Updating the line Fetch C INTO V. 5 6 7 8 dbms_output.put_Line ('the value:' || v); Close C; End; 9 10 11 / The value: 2PL / SQL Procedure SuccessFully Completed. SQL> Select * from test1 where a = 1; ABC D ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------ ---------------------------- 1 bbbbbbbbbbbbbbbbbb ccccccccccccccccccccccccccccccccccccc 2sql> Update Test1 Set D = 0 WHERE A = 1; 1 row updated.sql> commit; commit completion.cursor output is still updated before data Close C; END; 9 10 11 / The value: 2PL / SQL Procedure SuccessFully Completed. Because Query Results Establishing, just getting the system SCN is OK, this is the first line of the set of Cursor virtual points in Open, but does not really acquire data because the collection itself is not generated.
Below is the trace file ===================== Parsing in Cursor # 1 g= 185 dep = 0 uid = 41 oct = 47 LID = 41 TIM = 1052309975752642 HV = 2103278157 AD = '54d236cc'declarev varcha2 (30); Cursor C Is Select D from test1 where a = 1; beginopen C; DBMS_LOCK.SLEP (60); Fetch C INTO V; DBMS_OUTPUT.PUT_LINE (' the value: '|| v); Close C; end; end of stmtparse # 1: c = 0, E = 557, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1052309975752624BINDS # 1: ===================== Parsing in Cursor # 2 LEN = 31 Dep = 1 UID = 41 OCT = 3 LID = 41 Tim = 1052309975753431 HV = 2424123046 ad = '54d0d49c'select d from test1 where a = 1nd of stmtparse # 2: c = 0, E = 175, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, o = 4, TIM = 1052309975753416BINDS # 2: EXEC # 2: C = 0, E = 129, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 1052309975753684 *** 2004-02-23 11: 44: 36.612Wait # 1: nam = 'pl / sql lock timer' ELA = 60000938 P1 = 6000 p2 = 0 p3 = 0 Open Cursor starts SleepFetch # 2: C = 0, E = 291, P = 0, Cr = 3, Cu = 0, MIS = 0, R = 1, DEP = 1, OG = 4, TIM = 1052310035755394 Fetch really produced Cr = 3, r = 1 Represents logic read 3, ROWS 1EXEC # 1: C = 1953, E = 60003409, P = 0, Cr = 3, Cu = 0, MIS = 0, R = 1, DEP = 0, og = 4, TIM = 1052310035756319Wait # 1: Nam = 'sql * net message to client' ELA = 8 p1 = 1650815232 P2 = 1 P3 = 0 Synthesis discussion, and SG description is not contradictory. We have to look at the Active Set here to a virtual collection. Even in a large number of sorting or even Join in the query of the cursor, you will not read the data when Open is Open.
SQL> CREATE TABLE TT AS SELECT * from T; Table Created.SQL> Desc TTNAME NULL? TYPE ----------------------------- ------------ --------------------------------- Owner varchar2 (30) OBJECT_NAME VARCHAR2 (128) SUBOBJECT_NAME VARCHAR2 (30) OBJECT_ID NUMBERDATA_OBJECT_ID NUMBEROBJECT_TYPE VARCHAR2 (18) CREATED DATELAST_DDL_TIME DATETIMESTAMP VARCHAR2 (19) STATUS VARCHAR2 (7) TEMPORARY VARCHAR2 (1) GENERATED VARCHAR2 (1) SECONDARY VARCHAR2 (1) SQL> select Count (*) ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2 v varchar2 (30); 3 Cursor C is select Object_name from tt order by data_object_id; beginopen C; 4 5 6 DBMS_LOCK.SLEP (5); 7 Fetch C INTO V; DBMS_OUTPUT.PUT_LINE ('the value 1:' || v); 8 9 FETCH C INTO V; DBMS_OUTPUT.PUT_LINE ('The value 2:' || v); 10 11 Close C; 12 13 end; 14 15 / The value 1: CLU $ THE VALUE 2: COL $ PL / SQL Procedure SuccessFully Completed.SQL> ALTER Session Set Events' 10046 Trace N ame context off '; Session altered.SQL> exitDisconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.3.0 - Production [oracle @ jumper udump] $ cat * / opt / oracle / admin / hsjf / udump / hsjf_ora_3613.trcOracle9i Enterprise Edition Release 9.2.0.3.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.3.0 - ProductionORACLE_HOME =
/opt/oracle/product/9.2.0System name: LinuxNode name: jumper.hurray.com.cnRelease: 2.4.18-14Version: # 1 Wed Sep 4 13:35:50 EDT 2002Machine: i686Instance name: hsjfRedo thread mounted by this Instance: 1Oracle Process Number: 15Unix Process Pid: 3613, Image: Oracle@jumper.hurray.com.cn (TNS V1-V3) *** 2004-03-12 12: 47: 53.987 *** session ID16.353) 2004-03-12 12: 47: 53.986Appname mod = 'sql * plus' MH = 3669949024 ACT =' AH = 4029777240 ====================== Parsing IN CURSOR # 1 len = 68 dep = 0 uid = 41 oct = 42 lid = 41 tim = 1053832494128016 hv = 1346161232 ad = '53dd510c'alter session set events' 10046 trace name context forever, level 12'END OF STMTEXEC # 1: C = 0, E = 201, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1053832494127359Wait # 1: Nam = 'sql * net message to Client 'ELA = 8 p1 = 1650815232 P2 = 1 p3 = 0 *** 2004-03-12 12: 48: 04.817Wait # 1: nam =' sql * net message from client 'ELA = 10576349 P1 = 1650815232 P2 = 1 P3 = 0 ===================== PARSING IN CURSOR # 1 LEN = 261 Dep = 0 UID = 41 OCT = 47 LID = 41 TIM = 1053832504706787 HV = 1653057355 AD = '53D6 8e9c'declarev varchar2 (30); cursor c is select object_name from tt order by DATA_OBJECT_ID; beginopen c; dbms_lock.sleep (5); fetch c into v; dbms_output.put_line ( 'the value 1:' || v); fetch C INTO V; DBMS_OUTPUT.PUT_LINE ('the value 2:' || v); Close C; end; end of stmtpival # 1: c = 1953, E = 1535, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP =
0, g = 4, TIM = 1053832504706759BINDS # 1: ===================== Parsing in Cursor # 3 LEN = 48 Dep = 2 UID = 0 OCT = 3 LID = 0 TIM = 1053832504707818 HV = 3997906522 ad = '5367278822 ad =' 5367278822 ad = '53672788822 ad =' 5367278822ELECT user # from sys.user $ where name = 'Outln'end of stmtparse # 3: c = 0, E = 158, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 2, OG = 4, TIM = 1053832504707790BINDS # 3: EXEC # 3: C = 0, E = 188, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 2, OG = 4, TIM = 1053832504708208Fetch # 3: C = 0, E = 148, P = 0, Cr = 2, Cu = 0, MIS = 0, R = 1, DEP = 2, o = 4, TIM = 1053832504708421stat # 3 id = 1 cnt = 1 pid = 0 POS = 1 Obj = 22 op = 'table access by index rowid obj # (22) (Cr = 2 r = 0 w = 0 TIME = 118 US) 'Stat # 3 id = 2 CNT = 1 PID = 1 POS = 1 obj = 44 op =' index unique scan obj # (44) (Cr = 1 r = 0 w = 0 TIME = 62 US ) '===================== Parsing in Cursor # 2 g= 51 dep = 1 uid = 41 oct = 3 LID = 41 TIM = 1053832504709113 HV = 1161579795 AD = '53d5bd50'select Object_name from TT ORDER BY DATA_OBJECT_ID End Of Stmtparse # 2: C = 1953, E = 1671, P = 0, Cr = 2, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 1053832504709096BINDS # 2: EXEC # 2: C = 0, E = 171, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 1053832504709413wait # 1: Nam = 'PL / SQL LOCK TIMER' ELA = 5000254 P1 = 500 p2 = 0 P3 = 0 Wait # 2: Nam = 'DB File Scattered Read' ELA = 412 P1 = 11 P2 = 2194 P3 =
7Wait # 2: Nam = 'DB File Scattered Read' ELA = 349 P1 = 11 P2 = 2201 P3 = 8Wait # 2: Nam = 'DB File Scattered Read' ELA = 371 P1 = 11 P2 = 2209 P3 = 8Wait # 2: Nam = 'DB File Scattered Read' ELA = 385 P1 = 11 P2 = 2217 P3 = 8Wait # 2: Nam = 'DB File Scattered Read' ELA = 425 P1 = 11 P2 = 2225 P3 = 8Wait # 2: NAM = 'DB File scattered read 'ELA = 390 P1 = 11 p2 = 2233 P3 = 8Wait # 2: Nam =' DB File Scattered Read 'ELA = 384 P1 = 11 P2 = 2241 P3 = 8Wait # 2: Nam =' DB File Scattered Read ' ELA = 374 p1 = 11 p2 = 2249 p3 = 8Wait # 2: nam = 'db file scattered read' ELA = 380 p1 = 11 p2 = 2257 p3 = 8wait # 2: nam = 'db file scattered read' ELA = 407 P1 = 11 p2 = 2265 p3 = 8Wait # 2: nam = 'DB file scattered read' ELA = 418 p1 = 11 p2 = 2273 p3 = 8wait # 2: nam = 'db file scattered read' ELA = 360 P1 = 11 p2 = 2281 P3 = 8Wait # 2: Nam = 'DB File Scattered Read' ELA = 375 P1 = 11 P2 = 2289 P3 = 8Wait # 2: Nam = 'DB File Scattered Read' ELA = 361 P1 = 11 P2 = 2297 P3 = 8wait # 2: nam = 'db file scattered read' ELA = 383 P1 = 11 p2 = 2305 p3 = 8Wait # 2: Nam = 'DB File Scattered Read' ELA = 370 P1 = 11 P2 = 3081 P3 = 8Wait # 2: NAM = 'DB File SC Attered Read 'ELA = 3892 P1 = 11 P2 = 3209 P3 = 32WAIT # 2: Nam =' DB File Scattered Read 'ELA = 3675 P1 = 11 P2 = 3241 P3 = 32Wait # 2: Nam =' DB File Scattered Read 'ELA = 3595 p1 = 11 p2 = 3273 P3 = 32wait # 2: Nam = 'DB File Scattered Read' ELA =
3506 p1 = 11 p2 = 3305 p3 = 32WAIT # 2: Nam = 'db file scattered read' ELA = 3525 p1 = 11 p2 = 3337 p3 = 32wait # 2: nam = 'db file scattered read' ELA = 3603 p1 = 11 P2 = 3369 p3 = 32WAIT # 2: Nam = 'DB File Scattered Read' ELA = 3618 P1 = 11 P2 = 3401 P3 = 32Wait # 2: Nam = 'DB File Scattered Read' ELA = 3578 P1 = 11 P2 = 3433 P3 = 32WAIT # 2: Nam = 'DB File Scattered Read' ELA = 3845 P1 = 11 P2 = 3465 P3 = 32Wait # 2: Nam = 'DB File Scattered Read' ELA = 3397 P1 = 11 P2 = 3497 P3 = 32Wait # 2 : nam = 'DB file scattered read' ELA = 3499 P1 = 11 p2 = 3529 p3 = 32WAIT # 2: Nam = 'DB File Scattered Read' ELA = 3523 P1 = 11 P2 = 3561 P3 = 32Wait # 2: Nam = ' DB File Scattered Read 'ELA = 3339 P1 = 11 P2 = 3593 P3 = 32Wait # 2: Nam =' DB File Scattered Read 'ELA = 4179 P1 = 11 P2 = 3625 P3 = 32Wait # 2: Nam =' DB File Scattered Read 'ELA = 3512 p1 = 11 p2 = 3657 P3 = 32WAIT # 2: Nam =' DB File Scattered Read 'ELA = 3580 P1 = 11 P2 = 3689 P3 = 32Wait # 2: Nam =' DB File Scattered Read 'ELA = 3342 P1 = 11 p2 = 3721 p3 = 32wait # 2: nam = 'DB file scattered read' ELA = 3436 P1 = 11 p2 = 3753 P3 = 32Wait # 2: Nam = 'DB File Scattered Read' ELA = 3573 p1 = 11 p2 = 3785 P3 = 32WAIT # 2: Nam = 'db file scattered read' ELA = 3443 p1 = 11 p2 = 3817 p3 = 32wait # 2: nam = 'DB file scattered read' ELA = 3512 P1 = 11 p2 = 3849 p3 = 32wait # 2: nam = 'db file scattered read' ELA = 4157 P1 = 11 p2 = 3881 P3 =
32wait # 2: Nam = 'DB File Scattered Read' ELA = 3400 P1 = 11 P2 = 3913 P3 = 32Wait # 2: Nam = 'DB File Scattered Read' ELA = 3515 P1 = 11 P2 = 3945 P3 = 32Wait # 2: Nam = 'db file scattered read' ELA = 3485 P1 = 11 p2 = 3977 P3 = 32Wait # 2: Nam = 'DB file scattered read' ELA = 3519 p1 = 11 p2 = 4009 p3 = 32wait # 2: Nam = 'DB File scattered read 'ELA = 3577 p1 = 11 p2 = 4041 P3 = 32wait # 2: nam =' db file scattered read 'ELA = 3342 P1 = 11 p2 = 4073 p3 = 31wait # 2: Nam =' Direct Path Write 'ELA = 11 p1 = 201 p2 = 764 p3 = 7Wait # 2: nam = 'Direct Path Write' ELA = 22 p1 = 201 p2 = 771 p3 = 7Wait # 2: Nam = 'Direct Path Write' ELA = 1 p1 = 201 P2 = 778 p3 = 7Wait # 2: nam = 'Direct Path Write' ELA = 2 P1 = 201 P2 = 785 P3 = 5Wait # 2: Nam = 'Direct Path Read' ELA = 79 P1 = 201 P2 = 769 P3 = 7Wait # 2: nam = 'Direct Path Read' ELA = 35 P1 = 201 P2 = 521 P3 = 7Wait # 2: Nam = 'Direct Path Read' ELA = 35 P1 = 201 P2 = 645 P3 = 4Wait # 2: Nam = 'Direct Path Read 'ELA = 33 P1 = 201 P2 = 726 P3 = 7Wait # 2: Nam =' Direct Path Read 'ELA = 34 P1 = 201 P2 = 678 P3 = 7FETCH # 2: C = 523437, E = 592460, P = 1076, Cr = 1027, Cu = 6, MIS = 0, R = 1, DEP = 1, OG = 4, TIM = 1053832510302853FETCH # 2: c = 0, E = 70, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 1, DEP = 1, OG = 4, TIM = 1053832510304332Unmap # 2: c = 1953, E = 478, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 1, OG = 4, TIM = 1053832510305241Wait # 2: Nam = 'Direct Path Read'
ELA = 19 p1 = 201 p2 = 776 p3 = 1Wait # 2: nam = 'Direct Path Read' ELA = 4 P1 = 201 P2 = 528 P3 = 7Wait # 2: Nam = 'Direct Path Read' ELA = 2 P1 = 201 P2 = 733 p3 = 7Wait # 2: nam = 'Direct path read' ELA = 25 p1 = 201 p2 = 685 p3 = 7exec # 1: c = 529296, E = 5599226, P = 1076, Cr = 1029, Cu = 6 , MIS = 0, R = 1, DEP = 0, o = 4, TIM = 1053832510306313Wait # 1: Nam = 'sql * net message to client' ELA = 7 p1 = 1650815232 P2 = 1 p3 = 0Wait # 1: NAM = 'SQL * NET Message from Client' ELA = 829 P1 = 1650815232 P2 = 1 P3 = 0 ===================== Parsing In Cursor # 3 LEN = 52 Dep = 0 uid = 41 oct = 47 LID = 41 TIM = 1053832510308690 HV = 1307714173 ad = '53dd2cb0'begin dbms_output.get_Lines (: lines,: numline); end; end of stmtpival # 3: c = 1953, e = 677, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1053832510308675BINDS # 3: BIND 0: DTY = 1 MXL = 2000 (255) MAL = 25 SCL = 00 pre = 00 oacflg = 43 oacfl2 = 10 size = 2000 offset = 0BFP = 404edeb8 bln = 255 avl = 00 flg = 05bind 1: DTY = 2 mxl = 22 (02) mAL = 00 SCL = 00 pre = 00 oacflg = 01 oacfl2 = 0 size = 24 offset = 0BFP = 404EFB80 BLN = 22 avl = 02 flg = 05VALUE = 25wait # 3: nam = 'sql * net message to client' ELA = 8 p1 = 1 650815232 P2 = 1 p3 = 0exec # 3: c = 0, E = 1006, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 1, DEP = 0, OG = 4, TIM = 1053832510309876Wait # 3: Nam = 'SQL * Net Message from Client' ELA = 8459860 P1 = 1650815232 P2 = 1 P3 =
0stat # 2 id = 1 CNT = 2 pid = 0 POS = 1 Obj = 0 op = 'sort order by (cr = 1027 r = 1076 w = 268 TIME = 592412 US)' stat # 2 id = 2 cnt = 81920 PID = 1 POS = 1 Obj = 14568 op = 'Table Access Full Tt (Cr = 1027 r = 1022 W = 0 TIME = 257994 US)' =================== == PARSING IN CURSOR # 1 len = 55 dep = 0 uid = 41 oct = 42 lid = 41 tim = 1053832518771069 hv = 4110456808 ad = '53d84de8'alter session set events' 10046 trace name context off'END OF STMTPARSE # 1: C = 0, E = 183, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1053832518771046BINDS # 1: EXEC # 1: c = 0, E = 216, P = 0, Cr = 0, Cu = 0, MIS = 0, R = 0, DEP = 0, OG = 4, TIM = 1053832518771440 [Oracle @ Jumper Udump] $ Original Reference: http: // WWW .tpub.net / showthread.php? threadid = 197416
