OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » slowness (10.2.0.1,Windows 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

slowness [message #384937]

Thu, 05 February 2009 16:06

sant_new
Messages: 165
Registered: June 2008

Senior Member

Hi everyone,

I need some suggestions from you experts on troubleshooting this performance issue, not sure if it on the database side.

The program is run from the front end, basically there are about 140000 records in the risg table. The program does a select from risg table with a where condition and it returns about 80000 records and then updates a column in risg for those 80000 records.

I've tried to attach the portion of trace file from 10046 and portion of the tkprof output.

*** 2009-02-05 16:16:38.028	
*** SERVICE NAME:(SYS$USERS) 2009-02-05 16:16:38.013
*** SESSION ID:(138.9050) 2009-02-05 16:16:38.013
WAIT #32: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037895475
WAIT #32: nam='SQL*Net message from client' ela= 527 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037897135
=====================
PARSING IN CURSOR #32 len=45 dep=0 uid=75 oct=3 lid=75 tim=4037897259 hv=537115338 ad='ef6ee8b0'
SELECT t_dt from cde where co = 1
END OF STMT
PARSE #32:c=0,e=46,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=4037897255
WAIT #32: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037897464
WAIT #32: nam='SQL*Net message from client' ela= 346 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037897850
WAIT #32: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037897931
WAIT #32: nam='SQL*Net message from client' ela= 336 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037898329
WAIT #32: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037898396
WAIT #32: nam='SQL*Net message from client' ela= 254 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037898706
EXEC #32:c=0,e=29,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=4037898806
WAIT #32: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037898888
FETCH #32:c=0,e=86,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,tim=4037898951
WAIT #32: nam='SQL*Net message from client' ela= 709 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037899740
WAIT #33: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037899807
WAIT #33: nam='SQL*Net message from client' ela= 352 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037900216
=====================
PARSING IN CURSOR #33 len=247 dep=0 uid=75 oct=3 lid=75 tim=4037907026 hv=211060363 ad='e2a7f3e0'
SELECT oitm,co from risg where cls <>'Y' and  co >= :v1 and co <= :v2 order by co ASC
END OF STMT
PARSE #33:c=0,e=6743,p=0,cr=29,cu=0,mis=1,r=0,dep=0,og=1,tim=4037907023
WAIT #33: nam='SQL*Net message to client' ela= 3 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037907077
WAIT #33: nam='SQL*Net message from client' ela= 408 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037907504
WAIT #33: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037907553
WAIT #33: nam='SQL*Net message from client' ela= 277 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037907846
WAIT #33: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037907895
WAIT #33: nam='SQL*Net message from client' ela= 302 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037908218
WAIT #33: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037908235
WAIT #33: nam='SQL*Net message from client' ela= 806 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037909050
EXEC #33:c=0,e=59,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=4037909138
WAIT #33: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037909202
WAIT #33: nam='SQL*Net more data to client' ela= 25 driver id=1413697536 #bytes=2002 p3=0 obj#=-1 tim=4037909837
FETCH #33:c=0,e=765,p=0,cr=101,cu=0,mis=0,r=100,dep=0,og=1,tim=4037909918
WAIT #33: nam='SQL*Net message from client' ela= 580 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037910518
WAIT #48: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037910543
WAIT #48: nam='SQL*Net message from client' ela= 379 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037910935
=====================
PARSING IN CURSOR #48 len=54 dep=0 uid=75 oct=3 lid=75 tim=4037940142 hv=2391183551 ad='ef2569e0'
SELECT clsupp from cde where co = :v1
END OF STMT
PARSE #48:c=15625,e=29184,p=0,cr=250,cu=0,mis=1,r=0,dep=0,og=1,tim=4037940140
WAIT #48: nam='SQL*Net message to client' ela= 3 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037940192
WAIT #48: nam='SQL*Net message from client' ela= 691 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037940903
WAIT #48: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037940952
WAIT #48: nam='SQL*Net message from client' ela= 249 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037941218
WAIT #48: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037941266
WAIT #48: nam='SQL*Net message from client' ela= 2163 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037943448
WAIT #48: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037943469
WAIT #48: nam='SQL*Net message from client' ela= 505 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037943986
EXEC #48:c=0,e=40,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=4037944053
WAIT #48: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037944092
FETCH #48:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,tim=4037944110
WAIT #48: nam='SQL*Net message from client' ela= 340 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037944484
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037944505
WAIT #173: nam='SQL*Net message from client' ela= 266 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037944784
=====================
PARSING IN CURSOR #173 len=70 dep=0 uid=75 oct=6 lid=75 tim=4037949881 hv=3341992444 ad='e2a8e240'
update risg set cls = :v1 , cls_dt = :v2 where oitm = :v3
END OF STMT
PARSE #173:c=0,e=5067,p=0,cr=58,cu=0,mis=1,r=0,dep=0,og=1,tim=4037949878
WAIT #173: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037949918
WAIT #173: nam='SQL*Net message from client' ela= 310 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037950246
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037950271
WAIT #173: nam='SQL*Net message from client' ela= 291 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037950575
EXEC #173:c=0,e=373,p=0,cr=4,cu=6,mis=0,r=1,dep=0,og=1,tim=4037950985
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037951009
WAIT #173: nam='SQL*Net message from client' ela= 835 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037951856
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037951877
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037952159
EXEC #173:c=0,e=127,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037952304
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037952330
WAIT #173: nam='SQL*Net message from client' ela= 358 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037952703
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037952723
WAIT #173: nam='SQL*Net message from client' ela= 248 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037952983
EXEC #173:c=0,e=86,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037953080
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037953098
WAIT #173: nam='SQL*Net message from client' ela= 285 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037953394
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037953414
WAIT #173: nam='SQL*Net message from client' ela= 275 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037953701
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037953839
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037953865
WAIT #173: nam='SQL*Net message from client' ela= 264 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037954145
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037954171
WAIT #173: nam='SQL*Net message from client' ela= 230 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037954414
EXEC #173:c=0,e=118,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037954549
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037954575
WAIT #173: nam='SQL*Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037954895
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037954915
WAIT #173: nam='SQL*Net message from client' ela= 238 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037955166
EXEC #173:c=0,e=113,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037955296
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037955322
WAIT #173: nam='SQL*Net message from client' ela= 326 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037955663
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037955683
WAIT #173: nam='SQL*Net message from client' ela= 190 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037955885
EXEC #173:c=0,e=113,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037956016
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037956042
WAIT #173: nam='SQL*Net message from client' ela= 296 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037956353
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037956373
WAIT #173: nam='SQL*Net message from client' ela= 267 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037956653
EXEC #173:c=0,e=113,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037956783
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037956809
WAIT #173: nam='SQL*Net message from client' ela= 289 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037957124
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037957144
WAIT #173: nam='SQL*Net message from client' ela= 185 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037957342
EXEC #173:c=0,e=213,p=0,cr=4,cu=5,mis=0,r=1,dep=0,og=1,tim=4037957572
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037957591
WAIT #173: nam='SQL*Net message from client' ela= 384 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037957986
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037958006
WAIT #173: nam='SQL*Net message from client' ela= 683 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037958702
EXEC #173:c=0,e=137,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037958856
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037958892
WAIT #173: nam='SQL*Net message from client' ela= 342 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037959249
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037959270
WAIT #173: nam='SQL*Net message from client' ela= 317 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037959599
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037959737
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037959763
WAIT #173: nam='SQL*Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037960085
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037960106
WAIT #173: nam='SQL*Net message from client' ela= 233 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037960351
EXEC #173:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037960492
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037960518
WAIT #173: nam='SQL*Net message from client' ela= 296 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037960830
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037960854
WAIT #173: nam='SQL*Net message from client' ela= 268 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037961134
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037961273
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037961299
WAIT #173: nam='SQL*Net message from client' ela= 299 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037961614
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037961634
WAIT #173: nam='SQL*Net message from client' ela= 334 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037961980
EXEC #173:c=0,e=116,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037962114
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037962132
WAIT #173: nam='SQL*Net message from client' ela= 335 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037962478
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037962498
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037962780
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037962919
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037962945
WAIT #173: nam='SQL*Net message from client' ela= 285 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037963246
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037963266
WAIT #173: nam='SQL*Net message from client' ela= 254 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037963532
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037963670
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037963696
WAIT #173: nam='SQL*Net message from client' ela= 271 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037963982
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037964009
WAIT #173: nam='SQL*Net message from client' ela= 230 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037964252
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037964390
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037964417
WAIT #173: nam='SQL*Net message from client' ela= 285 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037964717
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037964737
WAIT #173: nam='SQL*Net message from client' ela= 254 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037965004
EXEC #173:c=0,e=302,p=0,cr=4,cu=6,mis=0,r=1,dep=0,og=1,tim=4037965323
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037965343
WAIT #173: nam='SQL*Net message from client' ela= 307 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037965661
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037965682
WAIT #173: nam='SQL*Net message from client' ela= 260 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037965961
EXEC #173:c=0,e=385,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037966409
WAIT #173: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037966452
WAIT #173: nam='SQL*Net message from client' ela= 553 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037967025
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037967059
WAIT #173: nam='SQL*Net message from client' ela= 331 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037967403
EXEC #173:c=0,e=226,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037967649
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037967690
WAIT #173: nam='SQL*Net message from client' ela= 327 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037968030
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037968134
WAIT #173: nam='SQL*Net message from client' ela= 264 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037968410
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037968558
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037968584
WAIT #173: nam='SQL*Net message from client' ela= 292 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037968891
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037968912
WAIT #173: nam='SQL*Net message from client' ela= 273 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037969197
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037969336
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037969362
WAIT #173: nam='SQL*Net message from client' ela= 282 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037969660
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037969681
WAIT #173: nam='SQL*Net message from client' ela= 242 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037969936
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037970082
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037970108
WAIT #173: nam='SQL*Net message from client' ela= 340 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037970463
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037970484
WAIT #173: nam='SQL*Net message from client' ela= 251 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037970747
EXEC #173:c=0,e=119,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037970884
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037970910
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037971195
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037971216
WAIT #173: nam='SQL*Net message from client' ela= 350 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037971578
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037971717
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037971743
WAIT #173: nam='SQL*Net message from client' ela= 539 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037972298
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037972318
WAIT #173: nam='SQL*Net message from client' ela= 256 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037972587
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037972725
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037972750
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037973052
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037973072
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037973355
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037973493
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037973518
WAIT #173: nam='SQL*Net message from client' ela= 302 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037973836
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037973856
WAIT #173: nam='SQL*Net message from client' ela= 228 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037974096
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037974233
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037974259
WAIT #173: nam='SQL*Net message from client' ela= 281 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037974559
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037974583
WAIT #173: nam='SQL*Net message from client' ela= 221 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037974816
EXEC #173:c=0,e=119,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037974953
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037974979
WAIT #173: nam='SQL*Net message from client' ela= 343 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037975337
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037975358
WAIT #173: nam='SQL*Net message from client' ela= 249 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037975620
EXEC #173:c=0,e=226,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037975882
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037975927
WAIT #173: nam='SQL*Net message from client' ela= 309 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037976251
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037976284
WAIT #173: nam='SQL*Net message from client' ela= 283 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037976581
EXEC #173:c=0,e=137,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037976746
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037976784
WAIT #173: nam='SQL*Net message from client' ela= 282 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037977083
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037977116
WAIT #173: nam='SQL*Net message from client' ela= 306 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037977434
EXEC #173:c=0,e=191,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037977643
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037977696
WAIT #173: nam='SQL*Net message from client' ela= 280 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037977992
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037978008
WAIT #173: nam='SQL*Net message from client' ela= 250 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037978266
EXEC #173:c=0,e=134,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037978418
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037978445
WAIT #173: nam='SQL*Net message from client' ela= 299 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037978761
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037978781
WAIT #173: nam='SQL*Net message from client' ela= 384 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037979177
EXEC #173:c=0,e=119,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037979314
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037979340
WAIT #173: nam='SQL*Net message from client' ela= 313 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037979674
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037979694
WAIT #173: nam='SQL*Net message from client' ela= 271 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037979978
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037980117
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037980143
WAIT #173: nam='SQL*Net message from client' ela= 319 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037980477
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037980498
WAIT #173: nam='SQL*Net message from client' ela= 238 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037980748
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037980886
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037980912
WAIT #173: nam='SQL*Net message from client' ela= 329 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037981257
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037981282
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037981563
EXEC #173:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037981704
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037981730
WAIT #173: nam='SQL*Net message from client' ela= 299 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037982044
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037982064
WAIT #173: nam='SQL*Net message from client' ela= 237 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037982313
EXEC #173:c=0,e=125,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037982456
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037982482
WAIT #173: nam='SQL*Net message from client' ela= 297 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037982794
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037982815
WAIT #173: nam='SQL*Net message from client' ela= 239 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037983065
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037983208
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037983234
WAIT #173: nam='SQL*Net message from client' ela= 282 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037983532
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037983553
WAIT #173: nam='SQL*Net message from client' ela= 236 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037983801
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037983941
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037983967
WAIT #173: nam='SQL*Net message from client' ela= 313 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037984296
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037984317
WAIT #173: nam='SQL*Net message from client' ela= 272 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037984601
EXEC #173:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037984742
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037984768
WAIT #173: nam='SQL*Net message from client' ela= 440 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037985223
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037985243
WAIT #173: nam='SQL*Net message from client' ela= 306 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037985561
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037985699
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037985725
WAIT #173: nam='SQL*Net message from client' ela= 314 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037986056
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037986076
WAIT #173: nam='SQL*Net message from client' ela= 263 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037986350
EXEC #173:c=0,e=128,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037986496
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037986513
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037986810
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037986831
WAIT #173: nam='SQL*Net message from client' ela= 463 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037987305
EXEC #173:c=0,e=130,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037987452
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037987477
WAIT #173: nam='SQL*Net message from client' ela= 707 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037988204
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037988225
WAIT #173: nam='SQL*Net message from client' ela= 235 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037988472
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037988611
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037988637
WAIT #173: nam='SQL*Net message from client' ela= 380 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037989033
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037989053
WAIT #173: nam='SQL*Net message from client' ela= 238 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037989303
EXEC #173:c=0,e=146,p=0,cr=4,cu=6,mis=0,r=1,dep=0,og=1,tim=4037989467
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037989485
WAIT #173: nam='SQL*Net message from client' ela= 304 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037989800
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037989821
WAIT #173: nam='SQL*Net message from client' ela= 257 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037990090
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037990228
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037990254
WAIT #173: nam='SQL*Net message from client' ela= 301 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037990572
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037990592
WAIT #173: nam='SQL*Net message from client' ela= 275 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037990879
EXEC #173:c=0,e=125,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037991021
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037991047
WAIT #173: nam='SQL*Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037991367
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037991388
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037991671
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037991808
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037991834
WAIT #173: nam='SQL*Net message from client' ela= 318 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037992169
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037992190
WAIT #173: nam='SQL*Net message from client' ela= 236 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037992439
EXEC #173:c=0,e=127,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037992583
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037992609
WAIT #173: nam='SQL*Net message from client' ela= 314 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037992939
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037992959
WAIT #173: nam='SQL*Net message from client' ela= 235 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037993206
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037993345
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037993371
WAIT #173: nam='SQL*Net message from client' ela= 258 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037993644
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037993664
WAIT #173: nam='SQL*Net message from client' ela= 282 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037993958
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037994095
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037994121
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037994426
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037994446
WAIT #173: nam='SQL*Net message from client' ela= 260 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037994718
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037994856
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037994882
WAIT #173: nam='SQL*Net message from client' ela= 293 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037995191
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037995212
WAIT #173: nam='SQL*Net message from client' ela= 269 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037995494
EXEC #173:c=0,e=127,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037995638
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037995664
WAIT #173: nam='SQL*Net message from client' ela= 550 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037996230
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037996256
WAIT #173: nam='SQL*Net message from client' ela= 236 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037996501
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037996649
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037996675
WAIT #173: nam='SQL*Net message from client' ela= 330 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037997020
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037997041
WAIT #173: nam='SQL*Net message from client' ela= 251 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037997305
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037997443
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037997469
WAIT #173: nam='SQL*Net message from client' ela= 362 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037997847
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037997867
WAIT #173: nam='SQL*Net message from client' ela= 271 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037998150
EXEC #173:c=0,e=100,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037998268
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037998285
WAIT #173: nam='SQL*Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037998601
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037998621
WAIT #173: nam='SQL*Net message from client' ela= 282 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037998915
EXEC #173:c=0,e=138,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4037999071
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037999097
WAIT #173: nam='SQL*Net message from client' ela= 288 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037999400
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4037999421
WAIT #173: nam='SQL*Net message from client' ela= 1390 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038000823
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038000971
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038001004
WAIT #173: nam='SQL*Net message from client' ela= 297 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038001320
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038001340
WAIT #173: nam='SQL*Net message from client' ela= 268 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038001620
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038001759
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038001785
WAIT #173: nam='SQL*Net message from client' ela= 306 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038002110
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038002131
WAIT #173: nam='SQL*Net message from client' ela= 266 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038002408
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038002547
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038002573
WAIT #173: nam='SQL*Net message from client' ela= 318 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038002906
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038002926
WAIT #173: nam='SQL*Net message from client' ela= 252 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038003191
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038003330
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038003357
WAIT #173: nam='SQL*Net message from client' ela= 298 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038003671
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038003691
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038003990
EXEC #173:c=0,e=118,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038004125
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038004142
WAIT #173: nam='SQL*Net message from client' ela= 283 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038004437
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038004457
WAIT #173: nam='SQL*Net message from client' ela= 287 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038004757
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038004895
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038004921
WAIT #173: nam='SQL*Net message from client' ela= 291 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038005227
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038005247
WAIT #173: nam='SQL*Net message from client' ela= 249 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038005509
EXEC #173:c=0,e=118,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038005644
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038005670
WAIT #173: nam='SQL*Net message from client' ela= 298 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038005990
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038006010
WAIT #173: nam='SQL*Net message from client' ela= 233 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038006255
EXEC #173:c=0,e=133,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038006405
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038006431
WAIT #173: nam='SQL*Net message from client' ela= 358 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038006804
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038006824
WAIT #173: nam='SQL*Net message from client' ela= 240 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038007077
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038007215
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038007241
WAIT #173: nam='SQL*Net message from client' ela= 441 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038007700
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038007720
WAIT #173: nam='SQL*Net message from client' ela= 811 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038008543
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038008682
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038008708
WAIT #173: nam='SQL*Net message from client' ela= 358 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038009087
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038009112
WAIT #173: nam='SQL*Net message from client' ela= 374 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038009497
EXEC #173:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038009638
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038009664
WAIT #173: nam='SQL*Net message from client' ela= 327 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038010020
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038010080
WAIT #173: nam='SQL*Net message from client' ela= 277 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038010371
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038010527
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038010555
WAIT #173: nam='SQL*Net message from client' ela= 319 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038010891
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038010924
WAIT #173: nam='SQL*Net message from client' ela= 246 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038011182
EXEC #173:c=0,e=355,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038011557
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038011592
WAIT #173: nam='SQL*Net message from client' ela= 284 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038011889
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038011910
WAIT #173: nam='SQL*Net message from client' ela= 267 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038012190
EXEC #173:c=0,e=127,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038012334
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038012361
WAIT #173: nam='SQL*Net message from client' ela= 264 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038012641
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038012662
WAIT #173: nam='SQL*Net message from client' ela= 251 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038012926
EXEC #173:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038013066
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038013093
WAIT #173: nam='SQL*Net message from client' ela= 347 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038013456
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038013476
WAIT #173: nam='SQL*Net message from client' ela= 210 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038013703
EXEC #173:c=0,e=347,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038014111
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038014161
WAIT #173: nam='SQL*Net message from client' ela= 378 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038014559
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038014617
WAIT #173: nam='SQL*Net message from client' ela= 236 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038014868
EXEC #173:c=0,e=214,p=0,cr=4,cu=6,mis=0,r=1,dep=0,og=1,tim=4038015114
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038015137
WAIT #173: nam='SQL*Net message from client' ela= 278 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038015428
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038015450
WAIT #173: nam='SQL*Net message from client' ela= 244 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038015706
EXEC #173:c=0,e=102,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038015822
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038015853
WAIT #173: nam='SQL*Net message from client' ela= 284 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038016148
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038016164
WAIT #173: nam='SQL*Net message from client' ela= 295 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038016468
EXEC #173:c=0,e=225,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038016706
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038016729
WAIT #173: nam='SQL*Net message from client' ela= 272 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038017012
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038017029
WAIT #173: nam='SQL*Net message from client' ela= 247 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038017284
EXEC #173:c=0,e=136,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038017433
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038017455
WAIT #173: nam='SQL*Net message from client' ela= 279 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038017745
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038017759
WAIT #173: nam='SQL*Net message from client' ela= 233 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038018001
EXEC #173:c=0,e=108,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038018122
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038018143
WAIT #173: nam='SQL*Net message from client' ela= 278 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038018431
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038018446
WAIT #173: nam='SQL*Net message from client' ela= 252 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038018706
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038018853
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038018880
WAIT #173: nam='SQL*Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038019200
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038019221
WAIT #173: nam='SQL*Net message from client' ela= 202 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038019434
EXEC #173:c=0,e=90,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038019536
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038019555
WAIT #173: nam='SQL*Net message from client' ela= 283 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038019849
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038019870
WAIT #173: nam='SQL*Net message from client' ela= 754 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038020636
EXEC #173:c=0,e=84,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038020747
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038020765
WAIT #173: nam='SQL*Net message from client' ela= 299 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038021075
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038021095
WAIT #173: nam='SQL*Net message from client' ela= 285 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038021393
EXEC #173:c=0,e=133,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038021544
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038021570
WAIT #173: nam='SQL*Net message from client' ela= 273 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038021858
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038021879
WAIT #173: nam='SQL*Net message from client' ela= 190 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038022081
EXEC #173:c=0,e=128,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038022226
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038022278
WAIT #173: nam='SQL*Net message from client' ela= 261 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038022564
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038022584
WAIT #173: nam='SQL*Net message from client' ela= 268 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038022865
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038023004
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038023030
WAIT #173: nam='SQL*Net message from client' ela= 284 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038023330
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038023350
WAIT #173: nam='SQL*Net message from client' ela= 265 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038023627
EXEC #173:c=0,e=116,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038023761
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038023778
WAIT #173: nam='SQL*Net message from client' ela= 295 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038024085
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038024105
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038024403
EXEC #173:c=0,e=125,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038024546
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038024572
WAIT #173: nam='SQL*Net message from client' ela= 276 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038024864
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038024884
WAIT #173: nam='SQL*Net message from client' ela= 272 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038025168
EXEC #173:c=0,e=116,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038025302
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038025329
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038025635
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038025655
WAIT #173: nam='SQL*Net message from client' ela= 284 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038025951
EXEC #173:c=0,e=127,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038026096
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038026122
WAIT #173: nam='SQL*Net message from client' ela= 295 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038026432
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038026451
WAIT #173: nam='SQL*Net message from client' ela= 259 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038026726
EXEC #173:c=0,e=400,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038027194
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038027235
WAIT #173: nam='SQL*Net message from client' ela= 10329 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038037582
WAIT #173: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038037623
WAIT #173: nam='SQL*Net message from client' ela= 3661 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038041297
EXEC #173:c=0,e=236,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038041554
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038041590
WAIT #173: nam='SQL*Net message from client' ela= 4663 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038046270
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038046291
WAIT #173: nam='SQL*Net message from client' ela= 364 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038046668
EXEC #173:c=0,e=130,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038046815
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038046863
WAIT #173: nam='SQL*Net message from client' ela= 302 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038047181
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038047202
WAIT #173: nam='SQL*Net message from client' ela= 301 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038047515
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038047654
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038047680
WAIT #173: nam='SQL*Net message from client' ela= 301 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038047997
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038048017
WAIT #173: nam='SQL*Net message from client' ela= 254 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038048284
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038048421
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038048447
WAIT #173: nam='SQL*Net message from client' ela= 327 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038048797
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038048854
WAIT #173: nam='SQL*Net message from client' ela= 249 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038049118
EXEC #173:c=0,e=94,p=0,cr=4,cu=5,mis=0,r=1,dep=0,og=1,tim=4038049234
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038049254
WAIT #173: nam='SQL*Net message from client' ela= 493 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038049758
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038049779
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038050061
EXEC #173:c=0,e=126,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038050205
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038050231
WAIT #173: nam='SQL*Net message from client' ela= 406 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038050653
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038050673
WAIT #173: nam='SQL*Net message from client' ela= 256 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038050941
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038051079
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038051105
WAIT #173: nam='SQL*Net message from client' ela= 348 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038051469
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038051489
WAIT #173: nam='SQL*Net message from client' ela= 238 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038051739
EXEC #173:c=0,e=151,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038051908
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038051926
WAIT #173: nam='SQL*Net message from client' ela= 283 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038052220
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038052240
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038052523
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038052662
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038052690
WAIT #173: nam='SQL*Net message from client' ela= 300 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038053006
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038053026
WAIT #173: nam='SQL*Net message from client' ela= 252 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038053291
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038053432
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038053467
WAIT #173: nam='SQL*Net message from client' ela= 299 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038053791
WAIT #33: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=4038053853
WAIT #33: nam='db file sequential read' ela= 6904 file#=7 block#=679959 blocks=1 obj#=65187 tim=4038061082
WAIT #33: nam='SQL*Net more data to client' ela= 28 driver id=1413697536 #bytes=2002 p3=0 obj#=65187 tim=4038061532
FETCH #33:c=0,e=7807,p=1,cr=94,cu=0,mis=0,r=100,dep=0,og=1,tim=4038061619
WAIT #33: nam='SQL*Net message from client' ela= 699 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038062362
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038062385
WAIT #173: nam='SQL*Net message from client' ela= 252 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038062650
EXEC #173:c=0,e=193,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038062862
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038062892
WAIT #173: nam='SQL*Net message from client' ela= 364 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038063273
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038063293
WAIT #173: nam='SQL*Net message from client' ela= 944 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038064250
EXEC #173:c=0,e=131,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038064399
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038064428
WAIT #173: nam='SQL*Net message from client' ela= 366 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038064811
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038064831
WAIT #173: nam='SQL*Net message from client' ela= 302 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038065145
EXEC #173:c=0,e=151,p=0,cr=4,cu=6,mis=0,r=1,dep=0,og=1,tim=4038065314
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038065341
WAIT #173: nam='SQL*Net message from client' ela= 316 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038065673
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038065693
WAIT #173: nam='SQL*Net message from client' ela= 304 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038066009
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038066149
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038066175
WAIT #173: nam='SQL*Net message from client' ela= 325 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038066519
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038066571
WAIT #173: nam='SQL*Net message from client' ela= 267 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038066853
EXEC #173:c=0,e=150,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038067034
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038067065
WAIT #173: nam='SQL*Net message from client' ela= 305 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038067387
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038067408
WAIT #173: nam='SQL*Net message from client' ela= 253 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038067673
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038067812
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038067839
WAIT #173: nam='SQL*Net message from client' ela= 879 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038068734
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038068755
WAIT #173: nam='SQL*Net message from client' ela= 1127 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038069900
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038070047
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038070074
WAIT #173: nam='SQL*Net message from client' ela= 303 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038070392
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038070413
WAIT #173: nam='SQL*Net message from client' ela= 275 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038070701
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038070839
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038070865
WAIT #173: nam='SQL*Net message from client' ela= 279 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038071159
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038071180
WAIT #173: nam='SQL*Net message from client' ela= 259 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038071452
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038071591
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038071617
WAIT #173: nam='SQL*Net message from client' ela= 298 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038071930
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038071951
WAIT #173: nam='SQL*Net message from client' ela= 253 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038072217
EXEC #173:c=0,e=121,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038072355
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038072381
WAIT #173: nam='SQL*Net message from client' ela= 277 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038072679
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038072700
WAIT #173: nam='SQL*Net message from client' ela= 287 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038073000
EXEC #173:c=0,e=118,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038073135
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038073162
WAIT #173: nam='SQL*Net message from client' ela= 304 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038073481
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038073502
WAIT #173: nam='SQL*Net message from client' ela= 227 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038073741
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038073879
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038073906
WAIT #173: nam='SQL*Net message from client' ela= 311 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038074235
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038074255
WAIT #173: nam='SQL*Net message from client' ela= 222 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038074490
EXEC #173:c=0,e=128,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038074635
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038074661
WAIT #173: nam='SQL*Net message from client' ela= 274 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038074950
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038074971
WAIT #173: nam='SQL*Net message from client' ela= 355 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038075338
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038075478
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038075504
WAIT #173: nam='SQL*Net message from client' ela= 311 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038075830
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038075855
WAIT #173: nam='SQL*Net message from client' ela= 188 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038076056
EXEC #173:c=0,e=99,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038076172
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038076189
WAIT #173: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038076486
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038076507
WAIT #173: nam='SQL*Net message from client' ela= 256 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038076775
EXEC #173:c=0,e=140,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038076933
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038076960
WAIT #173: nam='SQL*Net message from client' ela= 274 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038077253
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038077300
WAIT #173: nam='SQL*Net message from client' ela= 276 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038077594
EXEC #173:c=0,e=126,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038077747
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038077775
WAIT #173: nam='SQL*Net message from client' ela= 273 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038078074
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038078101
WAIT #173: nam='SQL*Net message from client' ela= 280 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038078394
EXEC #173:c=0,e=122,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038078533
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038078559
WAIT #173: nam='SQL*Net message from client' ela= 427 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038079002
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038079023
WAIT #173: nam='SQL*Net message from client' ela= 268 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038079303
EXEC #173:c=0,e=127,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038079448
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038079474
WAIT #173: nam='SQL*Net message from client' ela= 371 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038079861
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038079882
WAIT #173: nam='SQL*Net message from client' ela= 307 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038080203
EXEC #173:c=0,e=351,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038080580
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038080620
WAIT #173: nam='SQL*Net message from client' ela= 702 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038081339
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038081373
WAIT #173: nam='SQL*Net message from client' ela= 363 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038081749
EXEC #173:c=0,e=215,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038081984
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038082017
WAIT #173: nam='SQL*Net message from client' ela= 326 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038082361
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038082381
WAIT #173: nam='SQL*Net message from client' ela= 267 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038082661
EXEC #173:c=0,e=129,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038082807
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038082834
WAIT #173: nam='SQL*Net message from client' ela= 288 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038083142
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038083163
WAIT #173: nam='SQL*Net message from client' ela= 222 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038083397
EXEC #173:c=0,e=119,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038083534
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038083560
WAIT #173: nam='SQL*Net message from client' ela= 315 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038083894
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038083915
WAIT #173: nam='SQL*Net message from client' ela= 239 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038084167
EXEC #173:c=0,e=130,p=0,cr=4,cu=5,mis=0,r=1,dep=0,og=1,tim=4038084316
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038084343
WAIT #173: nam='SQL*Net message from client' ela= 288 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038084646
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038084667
WAIT #173: nam='SQL*Net message from client' ela= 253 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038084933
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038085071
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038085110
WAIT #173: nam='SQL*Net message from client' ela= 294 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038085414
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038085434
WAIT #173: nam='SQL*Net message from client' ela= 212 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038085658
EXEC #173:c=0,e=120,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038085796
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038085822
WAIT #173: nam='SQL*Net message from client' ela= 296 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038086133
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038086154
WAIT #173: nam='SQL*Net message from client' ela= 244 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038086409
EXEC #173:c=0,e=117,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038086544
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038086570
WAIT #173: nam='SQL*Net message from client' ela= 288 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038086874
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038086898
WAIT #173: nam='SQL*Net message from client' ela= 273 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038087183
EXEC #173:c=0,e=124,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038087326
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038087352
WAIT #173: nam='SQL*Net message from client' ela= 381 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038087749
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038087770
WAIT #173: nam='SQL*Net message from client' ela= 270 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038088052
EXEC #173:c=0,e=119,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038088189
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038088215
WAIT #173: nam='SQL*Net message from client' ela= 287 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038088518
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038088538
WAIT #173: nam='SQL*Net message from client' ela= 403 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038088954
EXEC #173:c=0,e=98,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038089069
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038089089
WAIT #173: nam='SQL*Net message from client' ela= 315 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038089416
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038089436
WAIT #173: nam='SQL*Net message from client' ela= 284 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038089732
EXEC #173:c=0,e=145,p=0,cr=4,cu=6,mis=0,r=1,dep=0,og=1,tim=4038089895
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038089922
WAIT #173: nam='SQL*Net message from client' ela= 276 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038090213
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038090234
WAIT #173: nam='SQL*Net message from client' ela= 221 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038090467
EXEC #173:c=0,e=119,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038090604
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038090630
WAIT #173: nam='SQL*Net message from client' ela= 304 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038090949
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038090971
WAIT #173: nam='SQL*Net message from client' ela= 323 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038091307
EXEC #173:c=0,e=125,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038091450
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038091477
WAIT #173: nam='SQL*Net message from client' ela= 380 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038091877
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038091942
WAIT #173: nam='SQL*Net message from client' ela= 256 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038092210
EXEC #173:c=0,e=291,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038092522
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038092555
WAIT #173: nam='SQL*Net message from client' ela= 316 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038092886
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038092923
WAIT #173: nam='SQL*Net message from client' ela= 268 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038093204
EXEC #173:c=0,e=201,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038093424
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038093450
WAIT #173: nam='SQL*Net message from client' ela= 289 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038093751
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038093772
WAIT #173: nam='SQL*Net message from client' ela= 212 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038093996
EXEC #173:c=0,e=130,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038094144
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038094170
WAIT #173: nam='SQL*Net message from client' ela= 463 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038094650
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038094670
WAIT #173: nam='SQL*Net message from client' ela= 284 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038094967
EXEC #173:c=0,e=126,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038095110
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038095136
WAIT #173: nam='SQL*Net message from client' ela= 356 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038095508
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038095528
WAIT #173: nam='SQL*Net message from client' ela= 559 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038096100
EXEC #173:c=0,e=133,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038096256
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038096290
WAIT #173: nam='SQL*Net message from client' ela= 358 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038096665
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038096685
WAIT #173: nam='SQL*Net message from client' ela= 251 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038096948
EXEC #173:c=0,e=133,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038097099
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038097125
WAIT #173: nam='SQL*Net message from client' ela= 353 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038097494
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038097514
WAIT #173: nam='SQL*Net message from client' ela= 279 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038097805
EXEC #173:c=0,e=126,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038097949
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038097975
WAIT #173: nam='SQL*Net message from client' ela= 301 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038098292
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038098312
WAIT #173: nam='SQL*Net message from client' ela= 190 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038098514
EXEC #173:c=0,e=124,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038098656
WAIT #173: nam='SQL*Net message to client' ela= 8 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038098690
WAIT #173: nam='SQL*Net message from client' ela= 268 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038098980
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038099001
WAIT #173: nam='SQL*Net message from client' ela= 227 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038099239
EXEC #173:c=0,e=126,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038099383
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038099409
WAIT #173: nam='SQL*Net message from client' ela= 279 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038099703
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038099723
WAIT #173: nam='SQL*Net message from client' ela= 224 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038099955
EXEC #173:c=0,e=128,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038100102
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038100128
WAIT #173: nam='SQL*Net message from client' ela= 262 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038100406
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038100426
WAIT #173: nam='SQL*Net message from client' ela= 255 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038100693
EXEC #173:c=0,e=96,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038100801
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038100819
WAIT #173: nam='SQL*Net message from client' ela= 297 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038101127
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038101149
WAIT #173: nam='SQL*Net message from client' ela= 297 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038101458
EXEC #173:c=0,e=132,p=0,cr=4,cu=5,mis=0,r=1,dep=0,og=1,tim=4038101609
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038101636
WAIT #173: nam='SQL*Net message from client' ela= 256 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038101907
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038101928
WAIT #173: nam='SQL*Net message from client' ela= 201 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4038102146
EXEC #173:c=0,e=126,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4038102289
..
...
EXEC #173:c=0,e=150,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4151620671
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151620699
WAIT #173: nam='SQL*Net message from client' ela= 363 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151621083
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151621143
WAIT #173: nam='SQL*Net message from client' ela= 261 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151621420
EXEC #173:c=0,e=135,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4151621583
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151621612
WAIT #173: nam='SQL*Net message from client' ela= 272 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151621901
WAIT #173: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151621922
WAIT #173: nam='SQL*Net message from client' ela= 236 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151622170
EXEC #173:c=0,e=132,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4151622320
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151622346
WAIT #173: nam='SQL*Net message from client' ela= 287 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151622648
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151622668
WAIT #173: nam='SQL*Net message from client' ela= 259 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151622940
EXEC #173:c=0,e=134,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=4151623091
WAIT #173: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151623117
WAIT #173: nam='SQL*Net message from client' ela= 323 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151623466
XCTEND rlbk=0, rd_only=0
WAIT #0: nam='log file sync' ela= 2366 buffer#=23380 p2=0 p3=0 obj#=65187 tim=4151625963
WAIT #0: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=65187 tim=4151626027


OUTPUT:


SELECT t_dt 
from
 cde where co = 1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: 75  

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       5        0.00          0.00
  SQL*Net message from client                     5        0.00          0.00
********************************************************************************

SELECT oitm,co 
from
 risg where cls <>'Y'  and co >= :v1 and co <= :v2 order by co ASC


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch      821      3.26      14.76       2060     697054          0       82041
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      823      3.26      14.77       2060     697054          0       82041

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75  

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                     826        0.00          0.00
  SQL*Net message from client                   826        0.11          0.95
  SQL*Net more data to client                   820        0.00          0.03
  db file sequential read                      2060        0.34         11.50
********************************************************************************

SELECT clsupp 
from
 cde where co = :v1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.02          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.01       0.02          0          2          0           1

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75  

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       6        0.00          0.00
  SQL*Net message from client                     6        0.00          0.00
********************************************************************************

update risg set cls = :v1 , cls_dt = :v2 
where
 oitm = :v3


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute  82041     10.76      11.60         25     328255     337350       82041
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    82042     10.76      11.60         25     328255     337350       82041

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75  

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                  164084        0.00          0.10
  SQL*Net message from client                164084        1.91         76.47
  latch: library cache                            3        0.00          0.00
  log file switch completion                      2        0.09          0.17
  db file sequential read                        25        0.02          0.10
********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.01       0.03          0          0          0           0
Execute  82044     10.76      11.60         25     328255     337350       82041
Fetch      823      3.26      14.76       2060     697058          0       82043
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    82871     14.04      26.41       2085    1025313     337350      164084

Misses in library cache during parse: 3

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                  165004        0.00          0.10
  SQL*Net message from client                165003        1.91         77.53
  SQL*Net more data to client                   820        0.00          0.03
  db file sequential read                      2085        0.34         11.61
  log file sync                                  84        0.16          1.56
  latch: library cache                            3        0.00          0.00
  log file switch completion                      2        0.09          0.17


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      200      0.00       0.00          0          0          4           0
Execute    200      0.00       0.00          0          0          0           0
Fetch      233      0.00       0.00          0        439          0         200
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      633      0.00       0.01          0        439          4         200

Misses in library cache during parse: 2
Misses in library cache during execute: 2

    4  user  SQL statements in session.
  200  internal SQL statements in session.
  204  SQL statements in session.
********************************************************************************
Trace file: test_ora_598.trc
Trace file compatibility: 10.01.00
Sort options: default

       1  session in tracefile.
       4  user  SQL statements in trace file.
     200  internal SQL statements in trace file.
     204  SQL statements in trace file.
       7  unique SQL statements in trace file.
  417670  lines in trace file.
     113  elapsed seconds in trace file.

The program took about a little over 10 minutes to run. But it took about 3 minutes to run last week. We are still not sure if is database issue or something else. Please give me your suggestions/thoughts.

Thank you very much for all your help.

Report message to a moderator

Re: slowness [message #384941 is a reply to message #384937]

Thu, 05 February 2009 16:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

From my perspective the data presented makes no sense in total.

>The program took about a little over 10 minutes to run.
So you claim.

SQLTrace summary reports 113 elapsed seconds in trace file;
or less than 2 minutes!

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.01       0.03          0          0          0           0
Execute  82044     10.76      11.60         25     328255     337350       82041
Fetch      823      3.26      14.76       2060     697058          0       82043
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    82871     14.04      26.41       2085    1025313     337350      164084

Elapsed total time from above is ONLY 26.41 seconds.

So my conclusion is that run time under 2 minutes meets your requirements & therefore no problem exists.

[Updated on: Thu, 05 February 2009 16:54]

Report message to a moderator

Re: slowness [message #384945 is a reply to message #384937]

Thu, 05 February 2009 19:55

sant_new
Messages: 165
Registered: June 2008

Senior Member

I apologize for the wrong number..

The program took about 10 minutes when I updated 1358000 records. It took about 3 minutes to update about 1350000 records last week. There are 1400000 records in total in risg table..

Thanks a lot for your help.

Report message to a moderator

Re: slowness [message #384948 is a reply to message #384937]

Thu, 05 February 2009 20:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/84315/74940/
which have you tried & what were the results

>update about 1350000 records last week.
>updates a column in risg for those 80000 records

I won't waste any more of my time working on unreliable & unsupported claims about was is or is not reality.

Simply put, find what changed & changed it back to they way it was last week.

Report message to a moderator

Re: slowness [message #385063 is a reply to message #384948]

Fri, 06 February 2009 05:44

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

@BlackSwan - "I Don't Know" is a perfectly acceptable answer - youdon't have to get aggressive.

@Sant_new: Do you have a Tkprof output for the run that took longer.
Can you post an explain plan of the query?

Do you know if anything changed -
Were indexes created or dropped from the tables?
Did a significant amount of data get added or deleted from the table?
Were the stats regenerated for the table?

Report message to a moderator

Re: slowness [message #385170 is a reply to message #385063]

Fri, 06 February 2009 16:57

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Looks like you are updating the rows one-by-one. I cannot tell what is causing it to run slower than before, but you could rewrite it using the techniques described in this article to have it running FASTER than before.

Ross Leishman

Report message to a moderator

Re: slowness [message #385451 is a reply to message #384937]

Mon, 09 February 2009 13:41

sant_new
Messages: 165
Registered: June 2008

Senior Member

@JRowbottom: I managed to run the process to update 173157 records this time. Below is the portion of the trace file and output.


*** 2009-02-09 13:54:23.068
*** SERVICE NAME:(SYS$USERS) 2009-02-09 13:54:23.068
*** SESSION ID:(141.20291) 2009-02-09 13:54:23.068
WAIT #77: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057505460
WAIT #77: nam='SQL*Net message from client' ela= 469 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057513842
=====================
=====================
PARSING IN CURSOR #77 len=45 dep=0 uid=75 oct=3 lid=75 tim=2057555484 hv=537115338 ad='ef6ee8b0'
SELECT t_dt from cde where co = 1
END OF STMT
PARSE #77:c=31250,e=41563,p=0,cr=250,cu=0,mis=1,r=0,dep=0,og=1,tim=2057555480
WAIT #77: nam='SQL*Net message to client' ela= 3 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057555541
WAIT #77: nam='SQL*Net message from client' ela= 490 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556054
WAIT #77: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556099
WAIT #77: nam='SQL*Net message from client' ela= 474 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556595
WAIT #77: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556619
WAIT #77: nam='SQL*Net message from client' ela= 311 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556942
EXEC #77:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=2057557007
WAIT #77: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557047
FETCH #77:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,tim=2057557064
WAIT #77: nam='SQL*Net message from client' ela= 388 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557487
WAIT #209: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557509
WAIT #209: nam='SQL*Net message from client' ela= 332 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557853
=====================
PARSING IN CURSOR #209 len=247 dep=0 uid=75 oct=3 lid=75 tim=2057558910 hv=211060363 ad='e2f49e88'
SELECT oitm,co from risg where  cls <>'Y' and item_type <> 'O' and co >= :v1 and co <= :v2 order by co ASC
END OF STMT
PARSE #209:c=0,e=1035,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=2057558909
WAIT #209: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057558945
WAIT #209: nam='SQL*Net message from client' ela= 499 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057559458
WAIT #209: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057559496
WAIT #209: nam='SQL*Net message from client' ela= 293 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057559805
=====================
..
..
PARSING IN CURSOR #223 len=54 dep=0 uid=75 oct=3 lid=75 tim=2057566480 hv=2391183551 ad='ef3a4e98'
SELECT clsupp from cde where co = :v1
END OF STMT
PARSE #223:c=0,e=941,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=2057566478
WAIT #223: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057566515
WAIT #223: nam='SQL*Net message from client' ela= 1262 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057567790
WAIT #223: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057567827
WAIT #223: nam='SQL*Net message from client' ela= 267 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057568111
=====================
..
..
PARSING IN CURSOR #60 len=70 dep=0 uid=75 oct=6 lid=75 tim=2057588225 hv=3341992444 ad='ef11c6d0'
update risg set cls = :v1 , cls_dt = :v2 where oitm = :v3
END OF STMT
PARSE #60:c=0,e=2578,p=0,cr=29,cu=0,mis=1,r=0,dep=0,og=1,tim=2057588223
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588255
WAIT #60: nam='SQL*Net message from client' ela= 333 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588604
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588629
WAIT #60: nam='SQL*Net message from client' ela= 280 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588922
=====================
..
..

PARSING IN CURSOR #107 len=42 dep=1 uid=0 oct=3 lid=0 tim=2057592519 hv=844002283 ad='ef6edce8'
select condition from cdef$ where rowid=:1
END OF STMT
PARSE #107:c=0,e=5,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=2057592518
EXEC #107:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=2057592558
FETCH #107:c=0,e=6,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=2057592575
STAT #107 id=1 cnt=1 pid=0 pos=1 obj=31 op='TABLE ACCESS BY USER ROWID CDEF$ (cr=1 pr=0 pw=0 time=5 us)'
EXEC #60:c=0,e=20994,p=0,cr=62,cu=6,mis=1,r=1,dep=0,og=1,tim=2057609952
WAIT #60: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057609998
WAIT #60: nam='SQL*Net message from client' ela= 3762 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057613782
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057613808
WAIT #60: nam='SQL*Net message from client' ela= 2680 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057616501
EXEC #60:c=0,e=4985,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2057621506
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057621540
WAIT #60: nam='SQL*Net message from client' ela= 2864 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057624421
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057624445
WAIT #60: nam='SQL*Net message from client' ela= 1209 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057625667
EXEC #60:c=0,e=155,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2057625841
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057625862
WAIT #60: nam='SQL*Net message from client' ela= 1554 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057627426
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057627447
WAIT #60: nam='SQL*Net message from client' ela= 1023 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057628481
EXEC #60:c=0,e=9142,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2057637641
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057637670
WAIT #60: nam='SQL*Net message from client' ela= 462 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057638147
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057638168
WAIT #60: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057638466
..
..
EXEC #60:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138996410
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138996436
WAIT #60: nam='SQL*Net message from client' ela= 298 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138996750
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138996771
WAIT #60: nam='SQL*Net message from client' ela= 413 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997197
EXEC #60:c=0,e=124,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138997338
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997364
WAIT #60: nam='SQL*Net message from client' ela= 313 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997692
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997713
WAIT #60: nam='SQL*Net message from client' ela= 271 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997996
EXEC #60:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138998137
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998164
WAIT #60: nam='SQL*Net message from client' ela= 290 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998469
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998491
WAIT #60: nam='SQL*Net message from client' ela= 263 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998766
EXEC #60:c=0,e=128,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138998912
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998938
WAIT #60: nam='SQL*Net message from client' ela= 311 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138999264
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138999285

OUTPUT:

SELECT t_dt 
from
 cde where co = 1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.03       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.03       0.01          0          2          0           1

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'cde' 
              (TABLE)
      0    INDEX   MODE: ANALYZED (UNIQUE SCAN) OF 'cde_PK' (INDEX 
               (UNIQUE))


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       5        0.00          0.00
  SQL*Net message from client                     5        0.00          0.00
********************************************************************************

SELECT oitm,co 
from
 risg where cls <>'Y' and co >= :v1 and co <= :v2 order by co ASC


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch     1732      3.84       4.57         47     734193          0      173157
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1734      3.84       4.57         47     734193          0      173157

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   FILTER
      0    TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'risg' (TABLE)

      0     INDEX   MODE: ANALYZED (RANGE SCAN) OF 
                'FK_MET__co__CUTC__risg' (INDEX)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                    1737        0.00          0.00
  SQL*Net message from client                  1737        0.12          1.40
  SQL*Net more data to client                  1731        0.00          0.05
  db file sequential read                        47        0.00          0.08
********************************************************************************

SELECT clsupp 
from
 cde where co = :v1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'cde' 
              (TABLE)
      0    INDEX   MODE: ANALYZED (UNIQUE SCAN) OF 'cde_PK' (INDEX 
               (UNIQUE))


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       6        0.00          0.00
  SQL*Net message from client                     6        0.00          0.00
********************************************************************************

update risg set cls = :v1 , cls_dt = :v2 
where
 oitm = :v3


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0         29          0           0
Execute 173157     20.84      56.12        103     692753     706832      173157
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   173158     20.84      56.13        103     692782     706832      173157

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   MODE: ALL_ROWS
      0   UPDATE OF 'risg'
      0    TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'risg' (TABLE)

      0     INDEX   MODE: ANALYZED (UNIQUE SCAN) OF 'risg_PK' (INDEX 
                (UNIQUE))


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                  346316        0.00          0.22
  SQL*Net message from client                346316        3.47        178.40
  db file sequential read                       103        0.05          0.80
  latch: library cache                           25        0.01          0.07
  log file switch completion                      4        0.13          0.34

********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.03       0.02          0         29          0           0
Execute 173160     20.84      56.12        103     692753     706832      173157
Fetch     1734      3.84       4.57         47     734197          0      173159
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   174898     24.71      60.73        150    1426979     706832      346316

Misses in library cache during parse: 4
Misses in library cache during execute: 1

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                  348238        0.00          0.22
  SQL*Net message from client                348237        3.47        180.02
  SQL*Net more data to client                  1731        0.00          0.05
  db file sequential read                       150        0.05          0.89
  log file sync                                 177        0.99          5.36
  latch: library cache                           25        0.01          0.07
  log file switch completion                      4        0.13          0.34


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      376      0.01       0.00          0          0          0           0
Execute    376      0.00       0.02          0          0          0           0
Fetch      448      0.00       0.00          0        832          0         376
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1200      0.01       0.03          0        832          0         376

Misses in library cache during parse: 2
Misses in library cache during execute: 2

    4  user  SQL statements in session.
  376  internal SQL statements in session.
  380  SQL statements in session.
    4  statements EXPLAINed in this session.
********************************************************************************
Trace file: test_ora_490.trc
Trace file compatibility: 10.01.00
Sort options: default

       1  session in tracefile.
       4  user  SQL statements in trace file.
     376  internal SQL statements in trace file.
     380  SQL statements in trace file.
       6  unique SQL statements in trace file.
       4  SQL statements EXPLAINed using schema:
           PUBS.prof$plan_table
             Default table was used.
             Table was created.
             Table was dropped.
  876849  lines in trace file.
     263  elapsed seconds in trace file.

THe application team claims there were no changes made since the last week. THe indexes were not re-created and the stats are updated recently for the table/index. There was no significant inserts or deletes in this table, but there were frequent updates happening in this table.

Based on the tkprof output, it looks like the SQL*Net message to/from client is the highest wait time, about 70% of the over-all time? Please give me your suggestions/thoughts, I really appreciate it.

Thanks a lot.

Report message to a moderator

Re: slowness [message #385452 is a reply to message #384937]

Mon, 09 February 2009 13:56

sant_new
Messages: 165
Registered: June 2008

Senior Member

@JRowbottom: I managed to run the process to update 173157 records this time. Below is the portion of the trace file and output.


*** 2009-02-09 13:54:23.068
*** SERVICE NAME:(SYS$USERS) 2009-02-09 13:54:23.068
*** SESSION ID:(141.20291) 2009-02-09 13:54:23.068
WAIT #77: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057505460
WAIT #77: nam='SQL*Net message from client' ela= 469 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057513842
=====================
=====================
PARSING IN CURSOR #77 len=45 dep=0 uid=75 oct=3 lid=75 tim=2057555484 hv=537115338 ad='ef6ee8b0'
SELECT t_dt from cde where co = 1
END OF STMT
PARSE #77:c=31250,e=41563,p=0,cr=250,cu=0,mis=1,r=0,dep=0,og=1,tim=2057555480
WAIT #77: nam='SQL*Net message to client' ela= 3 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057555541
WAIT #77: nam='SQL*Net message from client' ela= 490 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556054
WAIT #77: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556099
WAIT #77: nam='SQL*Net message from client' ela= 474 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556595
WAIT #77: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556619
WAIT #77: nam='SQL*Net message from client' ela= 311 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057556942
EXEC #77:c=0,e=32,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=2057557007
WAIT #77: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557047
FETCH #77:c=0,e=43,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=1,tim=2057557064
WAIT #77: nam='SQL*Net message from client' ela= 388 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557487
WAIT #209: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557509
WAIT #209: nam='SQL*Net message from client' ela= 332 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057557853
=====================
PARSING IN CURSOR #209 len=247 dep=0 uid=75 oct=3 lid=75 tim=2057558910 hv=211060363 ad='e2f49e88'
SELECT oitm,co from risg where  cls <>'Y' and item_type <> 'O' and co >= :v1 and co <= :v2 order by co ASC
END OF STMT
PARSE #209:c=0,e=1035,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=2057558909
WAIT #209: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057558945
WAIT #209: nam='SQL*Net message from client' ela= 499 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057559458
WAIT #209: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057559496
WAIT #209: nam='SQL*Net message from client' ela= 293 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057559805
=====================
..
..
PARSING IN CURSOR #223 len=54 dep=0 uid=75 oct=3 lid=75 tim=2057566480 hv=2391183551 ad='ef3a4e98'
SELECT clsupp from cde where co = :v1
END OF STMT
PARSE #223:c=0,e=941,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=2057566478
WAIT #223: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057566515
WAIT #223: nam='SQL*Net message from client' ela= 1262 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057567790
WAIT #223: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057567827
WAIT #223: nam='SQL*Net message from client' ela= 267 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057568111
=====================
..
..
PARSING IN CURSOR #60 len=70 dep=0 uid=75 oct=6 lid=75 tim=2057588225 hv=3341992444 ad='ef11c6d0'
update risg set cls = :v1 , cls_dt = :v2 where oitm = :v3
END OF STMT
PARSE #60:c=0,e=2578,p=0,cr=29,cu=0,mis=1,r=0,dep=0,og=1,tim=2057588223
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588255
WAIT #60: nam='SQL*Net message from client' ela= 333 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588604
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588629
WAIT #60: nam='SQL*Net message from client' ela= 280 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057588922
=====================
..
..

PARSING IN CURSOR #107 len=42 dep=1 uid=0 oct=3 lid=0 tim=2057592519 hv=844002283 ad='ef6edce8'
select condition from cdef$ where rowid=:1
END OF STMT
PARSE #107:c=0,e=5,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=2057592518
EXEC #107:c=0,e=7,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=2057592558
FETCH #107:c=0,e=6,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=2057592575
STAT #107 id=1 cnt=1 pid=0 pos=1 obj=31 op='TABLE ACCESS BY USER ROWID CDEF$ (cr=1 pr=0 pw=0 time=5 us)'
EXEC #60:c=0,e=20994,p=0,cr=62,cu=6,mis=1,r=1,dep=0,og=1,tim=2057609952
WAIT #60: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057609998
WAIT #60: nam='SQL*Net message from client' ela= 3762 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057613782
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057613808
WAIT #60: nam='SQL*Net message from client' ela= 2680 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057616501
EXEC #60:c=0,e=4985,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2057621506
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057621540
WAIT #60: nam='SQL*Net message from client' ela= 2864 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057624421
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057624445
WAIT #60: nam='SQL*Net message from client' ela= 1209 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057625667
EXEC #60:c=0,e=155,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2057625841
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057625862
WAIT #60: nam='SQL*Net message from client' ela= 1554 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057627426
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057627447
WAIT #60: nam='SQL*Net message from client' ela= 1023 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057628481
EXEC #60:c=0,e=9142,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2057637641
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057637670
WAIT #60: nam='SQL*Net message from client' ela= 462 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057638147
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057638168
WAIT #60: nam='SQL*Net message from client' ela= 286 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=2057638466
..
..
EXEC #60:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138996410
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138996436
WAIT #60: nam='SQL*Net message from client' ela= 298 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138996750
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138996771
WAIT #60: nam='SQL*Net message from client' ela= 413 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997197
EXEC #60:c=0,e=124,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138997338
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997364
WAIT #60: nam='SQL*Net message from client' ela= 313 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997692
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997713
WAIT #60: nam='SQL*Net message from client' ela= 271 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138997996
EXEC #60:c=0,e=123,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138998137
WAIT #60: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998164
WAIT #60: nam='SQL*Net message from client' ela= 290 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998469
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998491
WAIT #60: nam='SQL*Net message from client' ela= 263 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998766
EXEC #60:c=0,e=128,p=0,cr=4,cu=4,mis=0,r=1,dep=0,og=1,tim=2138998912
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138998938
WAIT #60: nam='SQL*Net message from client' ela= 311 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138999264
WAIT #60: nam='SQL*Net message to client' ela= 0 driver id=1413697536 #bytes=1 p3=0 obj#=65194 tim=2138999285

OUTPUT:

SELECT t_dt 
from
 cde where co = 1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.03       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.03       0.01          0          2          0           1

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'cde' 
              (TABLE)
      0    INDEX   MODE: ANALYZED (UNIQUE SCAN) OF 'cde_PK' (INDEX 
               (UNIQUE))


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       5        0.00          0.00
  SQL*Net message from client                     5        0.00          0.00
********************************************************************************

SELECT oitm,co 
from
 risg where cls <>'Y' and co >= :v1 and co <= :v2 order by co ASC


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch     1732      3.84       4.57         47     734193          0      173157
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1734      3.84       4.57         47     734193          0      173157

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   FILTER
      0    TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'risg' (TABLE)

      0     INDEX   MODE: ANALYZED (RANGE SCAN) OF 
                'FK_MET__co__CUTC__risg' (INDEX)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                    1737        0.00          0.00
  SQL*Net message from client                  1737        0.12          1.40
  SQL*Net more data to client                  1731        0.00          0.05
  db file sequential read                        47        0.00          0.08
********************************************************************************

SELECT clsupp 
from
 cde where co = :v1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'cde' 
              (TABLE)
      0    INDEX   MODE: ANALYZED (UNIQUE SCAN) OF 'cde_PK' (INDEX 
               (UNIQUE))


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                       6        0.00          0.00
  SQL*Net message from client                     6        0.00          0.00
********************************************************************************

update risg set cls = :v1 , cls_dt = :v2 
where
 oitm = :v3


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0         29          0           0
Execute 173157     20.84      56.12        103     692753     706832      173157
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   173158     20.84      56.13        103     692782     706832      173157

Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 75 

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   MODE: ALL_ROWS
      0   UPDATE OF 'risg'
      0    TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'risg' (TABLE)

      0     INDEX   MODE: ANALYZED (UNIQUE SCAN) OF 'risg_PK' (INDEX 
                (UNIQUE))


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                  346316        0.00          0.22
  SQL*Net message from client                346316        3.47        178.40
  db file sequential read                       103        0.05          0.80
  latch: library cache                           25        0.01          0.07
  log file switch completion                      4        0.13          0.34

********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        4      0.03       0.02          0         29          0           0
Execute 173160     20.84      56.12        103     692753     706832      173157
Fetch     1734      3.84       4.57         47     734197          0      173159
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   174898     24.71      60.73        150    1426979     706832      346316

Misses in library cache during parse: 4
Misses in library cache during execute: 1

Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                  348238        0.00          0.22
  SQL*Net message from client                348237        3.47        180.02
  SQL*Net more data to client                  1731        0.00          0.05
  db file sequential read                       150        0.05          0.89
  log file sync                                 177        0.99          5.36
  latch: library cache                           25        0.01          0.07
  log file switch completion                      4        0.13          0.34


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      376      0.01       0.00          0          0          0           0
Execute    376      0.00       0.02          0          0          0           0
Fetch      448      0.00       0.00          0        832          0         376
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1200      0.01       0.03          0        832          0         376

Misses in library cache during parse: 2
Misses in library cache during execute: 2

    4  user  SQL statements in session.
  376  internal SQL statements in session.
  380  SQL statements in session.
    4  statements EXPLAINed in this session.
********************************************************************************
Trace file: test_ora_490.trc
Trace file compatibility: 10.01.00
Sort options: default

       1  session in tracefile.
       4  user  SQL statements in trace file.
     376  internal SQL statements in trace file.
     380  SQL statements in trace file.
       6  unique SQL statements in trace file.
       4  SQL statements EXPLAINed using schema:
           PUBS.prof$plan_table
             Default table was used.
             Table was created.
             Table was dropped.
  876849  lines in trace file.
     263  elapsed seconds in trace file.

Report message to a moderator

Re: slowness [message #385453 is a reply to message #384937]

Mon, 09 February 2009 14:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>263 elapsed seconds in trace file.
Whole procedure completed in just over 4 minutes which is kind of close to the 3 minutes previously reported & no where close to 10 minutes in original posting.

>total 174898 24.71 60.73 150 1426979
The 60.73 is SQL elapsed time consumed; or about 25% of total

>SQL*Net message from client 348237 3.47 180.02
The 180.02 are seconds waited for response from client or 75%
Why does procedure make 2 round trips to client between every row updated?
If these get eliminated, run time declines to around 1 minute.

[Updated on: Mon, 09 February 2009 14:22]

Report message to a moderator

Re: slowness [message #385455 is a reply to message #384937]

Mon, 09 February 2009 14:46

sant_new
Messages: 165
Registered: June 2008

Senior Member

BlackSwan, the program took 10minutes to update 1350000 records in that table. The trace file I posted is for updating just 173157 records..

>SQL*Net message from client 348237 3.47 180.02
The 180.02 are seconds waited for response from client or 75%
Why does procedure make 2 round trips to client between every row updated?

I'm not sure, what this means...Could it be like a loop??

Thanks for your reply.

[Updated on: Mon, 09 February 2009 14:47]

Report message to a moderator

Re: slowness [message #385458 is a reply to message #384937]

Mon, 09 February 2009 15:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>the program took 10minutes to update 1350000 records in that table. The trace file I posted is for updating just 173157 records..

You claim 1,350,000 records in 10 minutes.
I see 173,157 records in (about) 4 minutes.
I would have expected linear extrapolation [records/time].
I won't speculate about facts not in evidence.

Report message to a moderator

Re: slowness [message #385603 is a reply to message #385455]

Tue, 10 February 2009 04:05

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Your code definitely looks to be processing rows in a loop - you execute that update statement once per row processed.

Looking at the timings, I don't believe the problem is in the database.
The two TkProf outputs you posted show that each row processed has a comparable amount of Cpu time and blocks read.
The big difference is in the elapsed time, where the slower query has a figure roughly twice the size of the faster.

There are no noticable differences in the wait events, so I'm tempted to think that the server might have had a higher load on it during the later run.

Report message to a moderator

Previous Topic:	Perfomence Tuning
Next Topic:	increase Cache size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 18:03:14 CST 2024