/opt/oracle/ora91/admin/ORCL6/udump/orcl6_ora_1549.trc
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
JServer Release 9.0.1.0.0 - Production
ORACLE_HOME = /opt/oracle/ora91
System name:	SunOS
Node name:	kakadu
Release:	5.8
Version:	Generic_108528-17
Machine:	sun4u
Instance name: ORCL6
Redo thread mounted by this instance: 1
Oracle process number: 16
Unix process pid: 1549, image: oracle@kakadu (TNS V1-V3)

*** 2003-08-22 16:42:30.156
*** SESSION ID:(45.275) 2003-08-22 16:42:30.143
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=1061581350143853 hv=287842151 ad='84bf6700'
alter session set events '10046 trace name context forever, level 8'
END OF STMT
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061581350143838
WAIT #1: nam='SQL*Net message to client' ela= 89 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3008 p1=1650815232 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=76 dep=0 uid=0 oct=3 lid=0 tim=1061581350162052 hv=3764318964 ad='84bfc4a4'
select /*+ full(t) noparallel(t) nocache(t) */ count(*) from sys.my_source t
END OF STMT
PARSE #1:c=0,e=1495,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1061581350162040
EXEC #1:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061581350162338
WAIT #1: nam='SQL*Net message to client' ela= 88 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file scattered read' ela= 29874 p1=11 p2=10 p3=64
WAIT #1: nam='db file scattered read' ela= 7640 p1=11 p2=74 p3=64
WAIT #1: nam='db file scattered read' ela= 7630 p1=11 p2=138 p3=64
WAIT #1: nam='db file scattered read' ela= 7589 p1=11 p2=202 p3=64
WAIT #1: nam='db file scattered read' ela= 7595 p1=11 p2=266 p3=64
WAIT #1: nam='db file scattered read' ela= 7580 p1=11 p2=330 p3=64
WAIT #1: nam='db file scattered read' ela= 7588 p1=11 p2=394 p3=64
WAIT #1: nam='db file scattered read' ela= 7589 p1=11 p2=458 p3=64
WAIT #1: nam='db file scattered read' ela= 7615 p1=11 p2=522 p3=64
WAIT #1: nam='db file scattered read' ela= 7582 p1=11 p2=586 p3=64
WAIT #1: nam='db file scattered read' ela= 7604 p1=11 p2=650 p3=64
WAIT #1: nam='db file scattered read' ela= 7845 p1=11 p2=714 p3=64
WAIT #1: nam='db file scattered read' ela= 7769 p1=11 p2=778 p3=64
WAIT #1: nam='db file scattered read' ela= 7588 p1=11 p2=842 p3=64
WAIT #1: nam='db file scattered read' ela= 7587 p1=11 p2=906 p3=64
WAIT #1: nam='db file scattered read' ela= 7587 p1=11 p2=970 p3=64
WAIT #1: nam='db file scattered read' ela= 7597 p1=11 p2=1034 p3=64
WAIT #1: nam='db file scattered read' ela= 7596 p1=11 p2=1098 p3=64
WAIT #1: nam='db file scattered read' ela= 7587 p1=11 p2=1162 p3=64
WAIT #1: nam='db file scattered read' ela= 7523 p1=11 p2=1226 p3=63
WAIT #1: nam='db file scattered read' ela= 7600 p1=11 p2=1289 p3=64
WAIT #1: nam='db file scattered read' ela= 7500 p1=11 p2=1353 p3=64
WAIT #1: nam='db file scattered read' ela= 7439 p1=11 p2=1417 p3=64
WAIT #1: nam='db file scattered read' ela= 7419 p1=11 p2=1481 p3=64
WAIT #1: nam='db file scattered read' ela= 7520 p1=11 p2=1545 p3=64
WAIT #1: nam='db file scattered read' ela= 7480 p1=11 p2=1609 p3=64
WAIT #1: nam='db file scattered read' ela= 7420 p1=11 p2=1673 p3=64
WAIT #1: nam='db file scattered read' ela= 7419 p1=11 p2=1737 p3=64
WAIT #1: nam='db file scattered read' ela= 7415 p1=11 p2=1801 p3=64
WAIT #1: nam='db file scattered read' ela= 7457 p1=11 p2=1865 p3=64
WAIT #1: nam='db file scattered read' ela= 7412 p1=11 p2=1929 p3=64
WAIT #1: nam='db file scattered read' ela= 7425 p1=11 p2=1993 p3=64
WAIT #1: nam='db file scattered read' ela= 7459 p1=11 p2=2057 p3=64
WAIT #1: nam='db file scattered read' ela= 7429 p1=11 p2=2121 p3=64
WAIT #1: nam='db file scattered read' ela= 7424 p1=11 p2=2185 p3=64
WAIT #1: nam='db file scattered read' ela= 7522 p1=11 p2=2249 p3=64
WAIT #1: nam='db file scattered read' ela= 7414 p1=11 p2=2313 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=2377 p3=64
WAIT #1: nam='db file scattered read' ela= 7417 p1=11 p2=2441 p3=64
WAIT #1: nam='db file scattered read' ela= 7474 p1=11 p2=2505 p3=64
WAIT #1: nam='db file scattered read' ela= 7483 p1=11 p2=2569 p3=64
WAIT #1: nam='db file scattered read' ela= 7427 p1=11 p2=2633 p3=64
WAIT #1: nam='db file scattered read' ela= 7470 p1=11 p2=2697 p3=64
WAIT #1: nam='db file scattered read' ela= 7432 p1=11 p2=2761 p3=64
WAIT #1: nam='db file scattered read' ela= 7429 p1=11 p2=2825 p3=64
WAIT #1: nam='db file scattered read' ela= 7414 p1=11 p2=2889 p3=64
WAIT #1: nam='db file scattered read' ela= 7419 p1=11 p2=2953 p3=64
WAIT #1: nam='db file scattered read' ela= 7800 p1=11 p2=3017 p3=64
WAIT #1: nam='db file scattered read' ela= 7437 p1=11 p2=3081 p3=64
WAIT #1: nam='db file scattered read' ela= 7426 p1=11 p2=3145 p3=64
WAIT #1: nam='db file scattered read' ela= 7425 p1=11 p2=3209 p3=64
WAIT #1: nam='db file scattered read' ela= 7417 p1=11 p2=3273 p3=64
WAIT #1: nam='db file scattered read' ela= 7411 p1=11 p2=3337 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=3401 p3=64
WAIT #1: nam='db file scattered read' ela= 7475 p1=11 p2=3465 p3=64
WAIT #1: nam='db file scattered read' ela= 7427 p1=11 p2=3529 p3=64
WAIT #1: nam='db file scattered read' ela= 7417 p1=11 p2=3593 p3=64
WAIT #1: nam='db file scattered read' ela= 7463 p1=11 p2=3657 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=3721 p3=64
WAIT #1: nam='db file scattered read' ela= 7415 p1=11 p2=3785 p3=64
WAIT #1: nam='db file scattered read' ela= 7465 p1=11 p2=3849 p3=64
WAIT #1: nam='db file scattered read' ela= 7415 p1=11 p2=3913 p3=64
WAIT #1: nam='db file scattered read' ela= 7434 p1=11 p2=3977 p3=64
WAIT #1: nam='db file scattered read' ela= 7473 p1=11 p2=4041 p3=64
WAIT #1: nam='db file scattered read' ela= 7431 p1=11 p2=4105 p3=64
WAIT #1: nam='db file scattered read' ela= 7426 p1=11 p2=4169 p3=64
WAIT #1: nam='db file scattered read' ela= 7430 p1=11 p2=4233 p3=64
WAIT #1: nam='db file scattered read' ela= 7412 p1=11 p2=4297 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=4361 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=4425 p3=64
WAIT #1: nam='db file scattered read' ela= 7448 p1=11 p2=4489 p3=64
WAIT #1: nam='db file scattered read' ela= 7444 p1=11 p2=4553 p3=64
WAIT #1: nam='db file scattered read' ela= 8167 p1=11 p2=4617 p3=64
WAIT #1: nam='db file scattered read' ela= 7440 p1=11 p2=4681 p3=64
WAIT #1: nam='db file scattered read' ela= 7429 p1=11 p2=4745 p3=64
WAIT #1: nam='db file scattered read' ela= 7421 p1=11 p2=4809 p3=64
WAIT #1: nam='db file scattered read' ela= 7437 p1=11 p2=4873 p3=64
WAIT #1: nam='db file scattered read' ela= 7417 p1=11 p2=4937 p3=64
WAIT #1: nam='db file scattered read' ela= 7468 p1=11 p2=5001 p3=64
WAIT #1: nam='db file scattered read' ela= 7428 p1=11 p2=5065 p3=64
WAIT #1: nam='db file scattered read' ela= 7430 p1=11 p2=5129 p3=64
WAIT #1: nam='db file scattered read' ela= 7453 p1=11 p2=5193 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=5257 p3=64
WAIT #1: nam='db file scattered read' ela= 7427 p1=11 p2=5321 p3=64
WAIT #1: nam='db file scattered read' ela= 7432 p1=11 p2=5385 p3=64
WAIT #1: nam='db file scattered read' ela= 7462 p1=11 p2=5449 p3=64
WAIT #1: nam='db file scattered read' ela= 7419 p1=11 p2=5513 p3=64
WAIT #1: nam='db file scattered read' ela= 7414 p1=11 p2=5577 p3=64
WAIT #1: nam='db file scattered read' ela= 7415 p1=11 p2=5641 p3=64
WAIT #1: nam='db file scattered read' ela= 7417 p1=11 p2=5705 p3=64
WAIT #1: nam='db file scattered read' ela= 7414 p1=11 p2=5769 p3=64
WAIT #1: nam='db file scattered read' ela= 7431 p1=11 p2=5833 p3=64
WAIT #1: nam='db file scattered read' ela= 7410 p1=11 p2=5897 p3=64
WAIT #1: nam='db file scattered read' ela= 7416 p1=11 p2=5961 p3=64
WAIT #1: nam='db file scattered read' ela= 7421 p1=11 p2=6025 p3=64
WAIT #1: nam='db file scattered read' ela= 7463 p1=11 p2=6089 p3=64
WAIT #1: nam='db file scattered read' ela= 7684 p1=11 p2=6153 p3=64
WAIT #1: nam='db file scattered read' ela= 9000 p1=11 p2=6217 p3=64
WAIT #1: nam='db file scattered read' ela= 7449 p1=11 p2=6281 p3=64
WAIT #1: nam='db file scattered read' ela= 7458 p1=11 p2=6345 p3=64
WAIT #1: nam='db file scattered read' ela= 7429 p1=11 p2=6409 p3=64
WAIT #1: nam='db file scattered read' ela= 7424 p1=11 p2=6473 p3=64
WAIT #1: nam='db file scattered read' ela= 7453 p1=11 p2=6537 p3=64
WAIT #1: nam='db file scattered read' ela= 7417 p1=11 p2=6601 p3=64
WAIT #1: nam='db file scattered read' ela= 7429 p1=11 p2=6665 p3=64
WAIT #1: nam='db file scattered read' ela= 7415 p1=11 p2=6729 p3=64
WAIT #1: nam='db file scattered read' ela= 7468 p1=11 p2=6793 p3=64
WAIT #1: nam='db file scattered read' ela= 7432 p1=11 p2=6857 p3=64
WAIT #1: nam='db file scattered read' ela= 7431 p1=11 p2=6921 p3=64
WAIT #1: nam='db file scattered read' ela= 43861 p1=11 p2=6985 p3=64
WAIT #1: nam='db file scattered read' ela= 7418 p1=11 p2=7049 p3=64
WAIT #1: nam='db file scattered read' ela= 7740 p1=11 p2=7113 p3=64
WAIT #1: nam='db file scattered read' ela= 7592 p1=11 p2=7177 p3=64
WAIT #1: nam='db file scattered read' ela= 7593 p1=11 p2=7241 p3=64
WAIT #1: nam='db file scattered read' ela= 7598 p1=11 p2=7305 p3=64
WAIT #1: nam='db file scattered read' ela= 7606 p1=11 p2=7369 p3=64
WAIT #1: nam='db file scattered read' ela= 7584 p1=11 p2=7433 p3=64
WAIT #1: nam='db file scattered read' ela= 7583 p1=11 p2=7497 p3=64
WAIT #1: nam='db file scattered read' ela= 7599 p1=11 p2=7561 p3=64
WAIT #1: nam='db file scattered read' ela= 7646 p1=11 p2=7625 p3=64
WAIT #1: nam='db file scattered read' ela= 7680 p1=11 p2=7689 p3=64
WAIT #1: nam='db file scattered read' ela= 7589 p1=11 p2=7753 p3=64
WAIT #1: nam='db file scattered read' ela= 7617 p1=11 p2=7817 p3=64
WAIT #1: nam='db file scattered read' ela= 7583 p1=11 p2=7881 p3=64
WAIT #1: nam='db file scattered read' ela= 7585 p1=11 p2=7945 p3=64
WAIT #1: nam='db file scattered read' ela= 7600 p1=11 p2=8009 p3=64
WAIT #1: nam='db file scattered read' ela= 7589 p1=11 p2=8073 p3=64
WAIT #1: nam='db file scattered read' ela= 7581 p1=11 p2=8137 p3=64
WAIT #1: nam='db file scattered read' ela= 7582 p1=11 p2=8201 p3=64
WAIT #1: nam='db file scattered read' ela= 7630 p1=11 p2=8265 p3=64
WAIT #1: nam='db file scattered read' ela= 7601 p1=11 p2=8329 p3=64
WAIT #1: nam='db file scattered read' ela= 7583 p1=11 p2=8393 p3=64
WAIT #1: nam='db file scattered read' ela= 7671 p1=11 p2=8457 p3=64
WAIT #1: nam='db file scattered read' ela= 7614 p1=11 p2=8521 p3=64
WAIT #1: nam='db file scattered read' ela= 7597 p1=11 p2=8585 p3=64
WAIT #1: nam='db file scattered read' ela= 7593 p1=11 p2=8649 p3=64
WAIT #1: nam='db file scattered read' ela= 7620 p1=11 p2=8713 p3=64
WAIT #1: nam='db file scattered read' ela= 7583 p1=11 p2=8777 p3=64
WAIT #1: nam='db file scattered read' ela= 7613 p1=11 p2=8841 p3=64
WAIT #1: nam='db file scattered read' ela= 3134 p1=11 p2=8905 p3=24
FETCH #1:c=1660000,e=2453906,p=8919,cr=8922,cu=9,mis=0,r=1,dep=0,og=4,tim=1061581352616458
WAIT #1: nam='SQL*Net message from client' ela= 3332 p1=1650815232 p2=1 p3=0
FETCH #1:c=0,e=3,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1061581352620208
WAIT #1: nam='SQL*Net message to client' ela= 75 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 2935 p1=1650815232 p2=1 p3=0
STAT #1 id=1 cnt=1 pid=0 pos=0 obj=0 op='SORT AGGREGATE '
STAT #1 id=2 cnt=1829640 pid=1 pos=1 obj=33419 op='TABLE ACCESS FULL MY_SOURCE '
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=0 oct=42 lid=0 tim=1061581352623819 hv=3381932903 ad='84be0ef0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=108,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061581352623808
EXEC #1:c=0,e=112,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061581352624071