.

SQLNoteUser Callsexecute countrecursive callscommits

.

32soft; 1 insert33333533

.

67soft; i select696820

.

61soft; selecrt; call resultset.getString(n) in a loop1286230

.

.

63soft; selecrt; call resultset.getString(2) and getInt(1) in a loop1336670

.

ResetSet.getXXX will double User Calls regardless how of time it is called

.

79soft select; call procedure1601602240

.

includs function call and sql call by the function

.

expect(actual)80soft selelct; call function240(160)160(160)240(275)0

.

.

65soft ; 10 select , 1 insert656586

.

63soft ; 10 select; 1 delete; 1 insert6464169

.

61hard; 1 select18462200

.

triple(??)sameless,maybe cache

.

61hard; 1 select ; less repeat19062620

.

.

expect(true)32(31)hard ; 1 delete90(61)32(31)60 (63)10(21)

.

2X , not 3Xsame2X

.

32hard; 1 insert64326432

.

.

28soft ; 1 insert ; with primary key and unique constraint violated284011215

.

why this largeoracle internal

.

.

.

.

.

ObservationExeucte countexecute count includs select; for easier understanding, it does not include recursive callalso inclue all sql in function

.

recursiveinsert/update/delete -> 1 .select -> 0hard parse -> less than 1 recuseive callone fuction call -> 1 recusive callunique constrain violation -> 1+ RC

.

.

Hard parseselect with hard parse tripple user calls; no effect on execute account; and generate 1 recursive calls. the recursive calls may be dropped as cached,but user calls remain same

.

Fuctionall sqls in function are included in Execute Count and User Calls