/opt/oracle/ora91/admin/ORCL6/udump/orcl6_ora_27431.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: 27431, image: oracle@kakadu (TNS V1-V3)

*** 2003-08-22 15:36:23.529
*** SESSION ID:(45.271) 2003-08-22 15:36:23.511
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=1061577383511096 hv=287842151 ad='84bf6700'
alter session set events '10046 trace name context forever, level 8'
END OF STMT
EXEC #1:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061577383511054
WAIT #1: nam='SQL*Net message to client' ela= 86 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3179 p1=1650815232 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=76 dep=0 uid=0 oct=3 lid=0 tim=1061577383535156 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=1650,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1061577383535145
EXEC #1:c=0,e=88,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061577383535446
WAIT #1: nam='SQL*Net message to client' ela= 83 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file scattered read' ela= 4925 p1=12 p2=10 p3=64
WAIT #1: nam='db file scattered read' ela= 4594 p1=12 p2=74 p3=64
WAIT #1: nam='db file scattered read' ela= 3810 p1=12 p2=138 p3=64
WAIT #1: nam='db file scattered read' ela= 4365 p1=12 p2=202 p3=64
WAIT #1: nam='db file scattered read' ela= 3681 p1=12 p2=266 p3=64
WAIT #1: nam='db file scattered read' ela= 4277 p1=12 p2=330 p3=64
WAIT #1: nam='db file scattered read' ela= 4406 p1=12 p2=394 p3=64
WAIT #1: nam='db file scattered read' ela= 3681 p1=12 p2=458 p3=64
WAIT #1: nam='db file scattered read' ela= 4343 p1=12 p2=522 p3=64
WAIT #1: nam='db file scattered read' ela= 3583 p1=12 p2=586 p3=64
WAIT #1: nam='db file scattered read' ela= 4247 p1=12 p2=650 p3=64
WAIT #1: nam='db file scattered read' ela= 4404 p1=12 p2=714 p3=64
WAIT #1: nam='db file scattered read' ela= 3708 p1=12 p2=778 p3=64
WAIT #1: nam='db file scattered read' ela= 4188 p1=12 p2=842 p3=64
WAIT #1: nam='db file scattered read' ela= 3626 p1=12 p2=906 p3=64
WAIT #1: nam='db file scattered read' ela= 4131 p1=12 p2=970 p3=63
WAIT #1: nam='db file scattered read' ela= 4263 p1=12 p2=1033 p3=64
WAIT #1: nam='db file scattered read' ela= 3642 p1=12 p2=1097 p3=64
WAIT #1: nam='db file scattered read' ela= 4305 p1=12 p2=1161 p3=64
WAIT #1: nam='db file scattered read' ela= 3948 p1=12 p2=1225 p3=64
WAIT #1: nam='db file scattered read' ela= 4379 p1=12 p2=1289 p3=64
WAIT #1: nam='db file scattered read' ela= 4288 p1=12 p2=1353 p3=64
WAIT #1: nam='db file scattered read' ela= 3712 p1=12 p2=1417 p3=64
WAIT #1: nam='db file scattered read' ela= 4256 p1=12 p2=1481 p3=64
WAIT #1: nam='db file scattered read' ela= 3712 p1=12 p2=1545 p3=64
WAIT #1: nam='db file scattered read' ela= 4244 p1=12 p2=1609 p3=64
WAIT #1: nam='db file scattered read' ela= 4380 p1=12 p2=1673 p3=64
WAIT #1: nam='db file scattered read' ela= 3701 p1=12 p2=1737 p3=64
WAIT #1: nam='db file scattered read' ela= 4302 p1=12 p2=1801 p3=64
WAIT #1: nam='db file scattered read' ela= 3737 p1=12 p2=1865 p3=64
WAIT #1: nam='db file scattered read' ela= 4249 p1=12 p2=1929 p3=64
WAIT #1: nam='db file scattered read' ela= 4231 p1=12 p2=1993 p3=64
WAIT #1: nam='db file scattered read' ela= 3734 p1=12 p2=2057 p3=64
WAIT #1: nam='db file scattered read' ela= 4319 p1=12 p2=2121 p3=64
WAIT #1: nam='db file scattered read' ela= 3665 p1=12 p2=2185 p3=64
WAIT #1: nam='db file scattered read' ela= 4257 p1=12 p2=2249 p3=64
WAIT #1: nam='db file scattered read' ela= 4176 p1=12 p2=2313 p3=64
WAIT #1: nam='db file scattered read' ela= 3591 p1=12 p2=2377 p3=64
WAIT #1: nam='db file scattered read' ela= 4284 p1=12 p2=2441 p3=64
WAIT #1: nam='db file scattered read' ela= 3681 p1=12 p2=2505 p3=64
WAIT #1: nam='db file scattered read' ela= 4272 p1=12 p2=2569 p3=64
WAIT #1: nam='db file scattered read' ela= 4222 p1=12 p2=2633 p3=64
WAIT #1: nam='db file scattered read' ela= 3618 p1=12 p2=2697 p3=64
WAIT #1: nam='db file scattered read' ela= 4186 p1=12 p2=2761 p3=64
WAIT #1: nam='db file scattered read' ela= 3736 p1=12 p2=2825 p3=64
WAIT #1: nam='db file scattered read' ela= 4204 p1=12 p2=2889 p3=64
WAIT #1: nam='db file scattered read' ela= 4183 p1=12 p2=2953 p3=64
WAIT #1: nam='db file scattered read' ela= 3696 p1=12 p2=3017 p3=64
WAIT #1: nam='db file scattered read' ela= 4131 p1=12 p2=3081 p3=64
WAIT #1: nam='db file scattered read' ela= 3635 p1=12 p2=3145 p3=64
WAIT #1: nam='db file scattered read' ela= 4147 p1=12 p2=3209 p3=64
WAIT #1: nam='db file scattered read' ela= 3109 p1=12 p2=3273 p3=64
WAIT #1: nam='db file scattered read' ela= 2918 p1=12 p2=3337 p3=64
WAIT #1: nam='db file scattered read' ela= 2839 p1=12 p2=3401 p3=64
WAIT #1: nam='db file scattered read' ela= 2832 p1=12 p2=3465 p3=64
WAIT #1: nam='db file scattered read' ela= 2839 p1=12 p2=3529 p3=64
WAIT #1: nam='db file scattered read' ela= 2927 p1=12 p2=3593 p3=64
WAIT #1: nam='db file scattered read' ela= 2946 p1=12 p2=3657 p3=64
WAIT #1: nam='db file scattered read' ela= 2811 p1=12 p2=3721 p3=64
WAIT #1: nam='db file scattered read' ela= 2792 p1=12 p2=3785 p3=64
WAIT #1: nam='db file scattered read' ela= 2930 p1=12 p2=3849 p3=64
WAIT #1: nam='db file scattered read' ela= 3004 p1=12 p2=3913 p3=64
WAIT #1: nam='db file scattered read' ela= 2946 p1=12 p2=3977 p3=64
WAIT #1: nam='db file scattered read' ela= 2825 p1=12 p2=4041 p3=64
WAIT #1: nam='db file scattered read' ela= 2806 p1=12 p2=4105 p3=64
WAIT #1: nam='db file scattered read' ela= 2971 p1=12 p2=4169 p3=64
WAIT #1: nam='db file scattered read' ela= 2983 p1=12 p2=4233 p3=64
WAIT #1: nam='db file scattered read' ela= 2856 p1=12 p2=4297 p3=64
WAIT #1: nam='db file scattered read' ela= 2923 p1=12 p2=4361 p3=64
WAIT #1: nam='db file scattered read' ela= 2943 p1=12 p2=4425 p3=64
WAIT #1: nam='db file scattered read' ela= 2918 p1=12 p2=4489 p3=64
WAIT #1: nam='db file scattered read' ela= 2898 p1=12 p2=4553 p3=64
WAIT #1: nam='db file scattered read' ela= 2942 p1=12 p2=4617 p3=64
WAIT #1: nam='db file scattered read' ela= 2802 p1=12 p2=4681 p3=64
WAIT #1: nam='db file scattered read' ela= 2921 p1=12 p2=4745 p3=64
WAIT #1: nam='db file scattered read' ela= 2800 p1=12 p2=4809 p3=64
WAIT #1: nam='db file scattered read' ela= 2887 p1=12 p2=4873 p3=64
WAIT #1: nam='db file scattered read' ela= 2901 p1=12 p2=4937 p3=64
WAIT #1: nam='db file scattered read' ela= 2885 p1=12 p2=5001 p3=64
WAIT #1: nam='db file scattered read' ela= 2799 p1=12 p2=5065 p3=64
WAIT #1: nam='db file scattered read' ela= 2830 p1=12 p2=5129 p3=64
WAIT #1: nam='db file scattered read' ela= 2865 p1=12 p2=5193 p3=64
WAIT #1: nam='db file scattered read' ela= 2834 p1=12 p2=5257 p3=64
WAIT #1: nam='db file scattered read' ela= 3024 p1=12 p2=5321 p3=64
WAIT #1: nam='db file scattered read' ela= 2863 p1=12 p2=5385 p3=64
WAIT #1: nam='db file scattered read' ela= 2820 p1=12 p2=5449 p3=64
WAIT #1: nam='db file scattered read' ela= 2863 p1=12 p2=5513 p3=64
WAIT #1: nam='db file scattered read' ela= 2828 p1=12 p2=5577 p3=64
WAIT #1: nam='db file scattered read' ela= 2865 p1=12 p2=5641 p3=64
WAIT #1: nam='db file scattered read' ela= 2808 p1=12 p2=5705 p3=64
WAIT #1: nam='db file scattered read' ela= 2783 p1=12 p2=5769 p3=64
WAIT #1: nam='db file scattered read' ela= 2897 p1=12 p2=5833 p3=64
WAIT #1: nam='db file scattered read' ela= 2807 p1=12 p2=5897 p3=64
WAIT #1: nam='db file scattered read' ela= 2808 p1=12 p2=5961 p3=64
WAIT #1: nam='db file scattered read' ela= 2902 p1=12 p2=6025 p3=64
WAIT #1: nam='db file scattered read' ela= 2899 p1=12 p2=6089 p3=64
WAIT #1: nam='db file scattered read' ela= 2951 p1=12 p2=6153 p3=64
WAIT #1: nam='db file scattered read' ela= 2986 p1=12 p2=6217 p3=64
WAIT #1: nam='db file scattered read' ela= 2877 p1=12 p2=6281 p3=64
WAIT #1: nam='db file scattered read' ela= 2860 p1=12 p2=6345 p3=64
WAIT #1: nam='db file scattered read' ela= 2905 p1=12 p2=6409 p3=64
WAIT #1: nam='db file scattered read' ela= 2851 p1=12 p2=6473 p3=64
WAIT #1: nam='db file scattered read' ela= 2797 p1=12 p2=6537 p3=64
WAIT #1: nam='db file scattered read' ela= 2836 p1=12 p2=6601 p3=64
WAIT #1: nam='db file scattered read' ela= 2930 p1=12 p2=6665 p3=64
WAIT #1: nam='db file scattered read' ela= 2949 p1=12 p2=6729 p3=64
WAIT #1: nam='db file scattered read' ela= 2968 p1=12 p2=6793 p3=64
WAIT #1: nam='db file scattered read' ela= 2812 p1=12 p2=6857 p3=64
WAIT #1: nam='db file scattered read' ela= 2874 p1=12 p2=6921 p3=64
WAIT #1: nam='db file scattered read' ela= 2878 p1=12 p2=6985 p3=64
WAIT #1: nam='db file scattered read' ela= 2881 p1=12 p2=7049 p3=64
WAIT #1: nam='db file scattered read' ela= 2772 p1=12 p2=7113 p3=64
WAIT #1: nam='db file scattered read' ela= 2874 p1=12 p2=7177 p3=64
WAIT #1: nam='db file scattered read' ela= 2867 p1=12 p2=7241 p3=64
WAIT #1: nam='db file scattered read' ela= 3063 p1=12 p2=7305 p3=64
WAIT #1: nam='db file scattered read' ela= 3008 p1=12 p2=7369 p3=64
WAIT #1: nam='db file scattered read' ela= 2912 p1=12 p2=7433 p3=64
WAIT #1: nam='db file scattered read' ela= 2804 p1=12 p2=7497 p3=64
WAIT #1: nam='db file scattered read' ela= 2772 p1=12 p2=7561 p3=64
WAIT #1: nam='db file scattered read' ela= 2812 p1=12 p2=7625 p3=64
WAIT #1: nam='db file scattered read' ela= 2828 p1=12 p2=7689 p3=64
WAIT #1: nam='db file scattered read' ela= 2851 p1=12 p2=7753 p3=64
WAIT #1: nam='db file scattered read' ela= 2742 p1=12 p2=7817 p3=64
WAIT #1: nam='db file scattered read' ela= 2748 p1=12 p2=7881 p3=64
WAIT #1: nam='db file scattered read' ela= 2827 p1=12 p2=7945 p3=64
WAIT #1: nam='db file scattered read' ela= 2786 p1=12 p2=8009 p3=64
WAIT #1: nam='db file scattered read' ela= 2934 p1=12 p2=8073 p3=64
WAIT #1: nam='db file scattered read' ela= 2730 p1=12 p2=8137 p3=64
WAIT #1: nam='db file scattered read' ela= 2800 p1=12 p2=8201 p3=64
WAIT #1: nam='db file scattered read' ela= 2769 p1=12 p2=8265 p3=64
WAIT #1: nam='db file scattered read' ela= 2809 p1=12 p2=8329 p3=64
WAIT #1: nam='db file scattered read' ela= 2824 p1=12 p2=8393 p3=64
WAIT #1: nam='db file scattered read' ela= 2926 p1=12 p2=8457 p3=64
WAIT #1: nam='db file scattered read' ela= 2832 p1=12 p2=8521 p3=64
WAIT #1: nam='db file scattered read' ela= 2896 p1=12 p2=8585 p3=64
WAIT #1: nam='db file scattered read' ela= 2787 p1=12 p2=8649 p3=64
WAIT #1: nam='db file scattered read' ela= 2932 p1=12 p2=8713 p3=64
WAIT #1: nam='db file scattered read' ela= 2912 p1=12 p2=8777 p3=64
WAIT #1: nam='db file scattered read' ela= 2839 p1=12 p2=8841 p3=64
WAIT #1: nam='db file scattered read' ela= 1071 p1=12 p2=8905 p3=24
FETCH #1:c=1780000,e=1776506,p=8919,cr=8927,cu=24,mis=0,r=1,dep=0,og=4,tim=1061577385312164
WAIT #1: nam='SQL*Net message from client' ela= 3357 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=1061577385315931
WAIT #1: nam='SQL*Net message to client' ela= 73 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3196 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=33416 op='TABLE ACCESS FULL MY_SOURCE '
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=0 oct=42 lid=0 tim=1061577385319904 hv=3381932903 ad='84be0ef0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=118,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061577385319893
EXEC #1:c=0,e=124,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061577385320214
*** 2003-08-22 15:54:32.594
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=1061578472594563 hv=287842151 ad='84bf6700'
alter session set events '10046 trace name context forever, level 8'
END OF STMT
EXEC #1:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061578472594549
WAIT #1: nam='SQL*Net message to client' ela= 85 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3136 p1=1650815232 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=76 dep=0 uid=0 oct=3 lid=0 tim=1061578472606455 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=1491,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1061578472606443
EXEC #1:c=0,e=85,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061578472606751
WAIT #1: nam='SQL*Net message to client' ela= 85 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file scattered read' ela= 6947 p1=12 p2=10 p3=64
WAIT #1: nam='db file scattered read' ela= 4879 p1=12 p2=74 p3=64
WAIT #1: nam='db file scattered read' ela= 4199 p1=12 p2=138 p3=64
WAIT #1: nam='db file scattered read' ela= 4786 p1=12 p2=202 p3=64
WAIT #1: nam='db file scattered read' ela= 7838 p1=12 p2=266 p3=64
WAIT #1: nam='db file scattered read' ela= 5199 p1=12 p2=330 p3=64
WAIT #1: nam='db file scattered read' ela= 4639 p1=12 p2=394 p3=64
WAIT #1: nam='db file scattered read' ela= 3931 p1=12 p2=458 p3=64
WAIT #1: nam='db file scattered read' ela= 4974 p1=12 p2=522 p3=64
WAIT #1: nam='db file scattered read' ela= 3820 p1=12 p2=586 p3=64
WAIT #1: nam='db file scattered read' ela= 4695 p1=12 p2=650 p3=64
WAIT #1: nam='db file scattered read' ela= 4812 p1=12 p2=714 p3=64
WAIT #1: nam='db file scattered read' ela= 4312 p1=12 p2=778 p3=64
WAIT #1: nam='db file scattered read' ela= 4876 p1=12 p2=842 p3=64
WAIT #1: nam='db file scattered read' ela= 4151 p1=12 p2=906 p3=64
WAIT #1: nam='db file scattered read' ela= 4959 p1=12 p2=970 p3=64
WAIT #1: nam='db file scattered read' ela= 4934 p1=12 p2=1034 p3=64
WAIT #1: nam='db file scattered read' ela= 4205 p1=12 p2=1098 p3=64
WAIT #1: nam='db file scattered read' ela= 4813 p1=12 p2=1162 p3=64
WAIT #1: nam='db file scattered read' ela= 3998 p1=12 p2=1226 p3=63
WAIT #1: nam='db file scattered read' ela= 4627 p1=12 p2=1289 p3=64
WAIT #1: nam='db file scattered read' ela= 4788 p1=12 p2=1353 p3=64
WAIT #1: nam='db file scattered read' ela= 3823 p1=12 p2=1417 p3=64
WAIT #1: nam='db file scattered read' ela= 4564 p1=12 p2=1481 p3=64
WAIT #1: nam='db file scattered read' ela= 3999 p1=12 p2=1545 p3=64
WAIT #1: nam='db file scattered read' ela= 4800 p1=12 p2=1609 p3=64
WAIT #1: nam='db file scattered read' ela= 4611 p1=12 p2=1673 p3=64
WAIT #1: nam='db file scattered read' ela= 4080 p1=12 p2=1737 p3=64
WAIT #1: nam='db file scattered read' ela= 4989 p1=12 p2=1801 p3=64
WAIT #1: nam='db file scattered read' ela= 4228 p1=12 p2=1865 p3=64
WAIT #1: nam='db file scattered read' ela= 4782 p1=12 p2=1929 p3=64
WAIT #1: nam='db file scattered read' ela= 4790 p1=12 p2=1993 p3=64
WAIT #1: nam='db file scattered read' ela= 4215 p1=12 p2=2057 p3=64
WAIT #1: nam='db file scattered read' ela= 5026 p1=12 p2=2121 p3=64
WAIT #1: nam='db file scattered read' ela= 4159 p1=12 p2=2185 p3=64
WAIT #1: nam='db file scattered read' ela= 4674 p1=12 p2=2249 p3=64
WAIT #1: nam='db file scattered read' ela= 4614 p1=12 p2=2313 p3=64
WAIT #1: nam='db file scattered read' ela= 3986 p1=12 p2=2377 p3=64
WAIT #1: nam='db file scattered read' ela= 4522 p1=12 p2=2441 p3=64
WAIT #1: nam='db file scattered read' ela= 3899 p1=12 p2=2505 p3=64
WAIT #1: nam='db file scattered read' ela= 4614 p1=12 p2=2569 p3=64
WAIT #1: nam='db file scattered read' ela= 4607 p1=12 p2=2633 p3=64
WAIT #1: nam='db file scattered read' ela= 3980 p1=12 p2=2697 p3=64
WAIT #1: nam='db file scattered read' ela= 4711 p1=12 p2=2761 p3=64
WAIT #1: nam='db file scattered read' ela= 4106 p1=12 p2=2825 p3=64
WAIT #1: nam='db file scattered read' ela= 5248 p1=12 p2=2889 p3=64
WAIT #1: nam='db file scattered read' ela= 5224 p1=12 p2=2953 p3=64
WAIT #1: nam='db file scattered read' ela= 4416 p1=12 p2=3017 p3=64
WAIT #1: nam='db file scattered read' ela= 5233 p1=12 p2=3081 p3=64
WAIT #1: nam='db file scattered read' ela= 5183 p1=12 p2=3145 p3=64
WAIT #1: nam='db file scattered read' ela= 4138 p1=12 p2=3209 p3=64
WAIT #1: nam='db file scattered read' ela= 3305 p1=12 p2=3273 p3=64
WAIT #1: nam='db file scattered read' ela= 3480 p1=12 p2=3337 p3=64
WAIT #1: nam='db file scattered read' ela= 3041 p1=12 p2=3401 p3=64
WAIT #1: nam='db file scattered read' ela= 2975 p1=12 p2=3465 p3=64
WAIT #1: nam='db file scattered read' ela= 2894 p1=12 p2=3529 p3=64
WAIT #1: nam='db file scattered read' ela= 3114 p1=12 p2=3593 p3=64
WAIT #1: nam='db file scattered read' ela= 3189 p1=12 p2=3657 p3=64
WAIT #1: nam='db file scattered read' ela= 3245 p1=12 p2=3721 p3=64
WAIT #1: nam='db file scattered read' ela= 3242 p1=12 p2=3785 p3=64
WAIT #1: nam='db file scattered read' ela= 3146 p1=12 p2=3849 p3=64
WAIT #1: nam='db file scattered read' ela= 3400 p1=12 p2=3913 p3=64
WAIT #1: nam='db file scattered read' ela= 3361 p1=12 p2=3977 p3=64
WAIT #1: nam='db file scattered read' ela= 3269 p1=12 p2=4041 p3=64
WAIT #1: nam='db file scattered read' ela= 3327 p1=12 p2=4105 p3=64
WAIT #1: nam='db file scattered read' ela= 3434 p1=12 p2=4169 p3=64
WAIT #1: nam='db file scattered read' ela= 3630 p1=12 p2=4233 p3=64
WAIT #1: nam='db file scattered read' ela= 3138 p1=12 p2=4297 p3=64
WAIT #1: nam='db file scattered read' ela= 3143 p1=12 p2=4361 p3=64
WAIT #1: nam='db file scattered read' ela= 3049 p1=12 p2=4425 p3=64
WAIT #1: nam='db file scattered read' ela= 2954 p1=12 p2=4489 p3=64
WAIT #1: nam='db file scattered read' ela= 3093 p1=12 p2=4553 p3=64
WAIT #1: nam='db file scattered read' ela= 3110 p1=12 p2=4617 p3=64
WAIT #1: nam='db file scattered read' ela= 3034 p1=12 p2=4681 p3=64
WAIT #1: nam='db file scattered read' ela= 3164 p1=12 p2=4745 p3=64
WAIT #1: nam='db file scattered read' ela= 3123 p1=12 p2=4809 p3=64
WAIT #1: nam='db file scattered read' ela= 3185 p1=12 p2=4873 p3=64
WAIT #1: nam='db file scattered read' ela= 3645 p1=12 p2=4937 p3=64
WAIT #1: nam='db file scattered read' ela= 4892 p1=12 p2=5001 p3=64
WAIT #1: nam='db file scattered read' ela= 5771 p1=12 p2=5065 p3=64
WAIT #1: nam='db file scattered read' ela= 2967 p1=12 p2=5129 p3=64
WAIT #1: nam='db file scattered read' ela= 3042 p1=12 p2=5193 p3=64
WAIT #1: nam='db file scattered read' ela= 2943 p1=12 p2=5257 p3=64
WAIT #1: nam='db file scattered read' ela= 2872 p1=12 p2=5321 p3=64
WAIT #1: nam='db file scattered read' ela= 2967 p1=12 p2=5385 p3=64
WAIT #1: nam='db file scattered read' ela= 3101 p1=12 p2=5449 p3=64
WAIT #1: nam='db file scattered read' ela= 3132 p1=12 p2=5513 p3=64
WAIT #1: nam='db file scattered read' ela= 3169 p1=12 p2=5577 p3=64
WAIT #1: nam='db file scattered read' ela= 3114 p1=12 p2=5641 p3=64
WAIT #1: nam='db file scattered read' ela= 3160 p1=12 p2=5705 p3=64
WAIT #1: nam='db file scattered read' ela= 3265 p1=12 p2=5769 p3=64
WAIT #1: nam='db file scattered read' ela= 3117 p1=12 p2=5833 p3=64
WAIT #1: nam='db file scattered read' ela= 3171 p1=12 p2=5897 p3=64
WAIT #1: nam='db file scattered read' ela= 2972 p1=12 p2=5961 p3=64
WAIT #1: nam='db file scattered read' ela= 2875 p1=12 p2=6025 p3=64
WAIT #1: nam='db file scattered read' ela= 2994 p1=12 p2=6089 p3=64
WAIT #1: nam='db file scattered read' ela= 2957 p1=12 p2=6153 p3=64
WAIT #1: nam='db file scattered read' ela= 2899 p1=12 p2=6217 p3=64
WAIT #1: nam='db file scattered read' ela= 2903 p1=12 p2=6281 p3=64
WAIT #1: nam='db file scattered read' ela= 3005 p1=12 p2=6345 p3=64
WAIT #1: nam='db file scattered read' ela= 3028 p1=12 p2=6409 p3=64
WAIT #1: nam='db file scattered read' ela= 3045 p1=12 p2=6473 p3=64
WAIT #1: nam='db file scattered read' ela= 3179 p1=12 p2=6537 p3=64
WAIT #1: nam='db file scattered read' ela= 3232 p1=12 p2=6601 p3=64
WAIT #1: nam='db file scattered read' ela= 3137 p1=12 p2=6665 p3=64
WAIT #1: nam='db file scattered read' ela= 3106 p1=12 p2=6729 p3=64
WAIT #1: nam='db file scattered read' ela= 3150 p1=12 p2=6793 p3=64
WAIT #1: nam='db file scattered read' ela= 3061 p1=12 p2=6857 p3=64
WAIT #1: nam='db file scattered read' ela= 3096 p1=12 p2=6921 p3=64
WAIT #1: nam='db file scattered read' ela= 2954 p1=12 p2=6985 p3=64
WAIT #1: nam='db file scattered read' ela= 2974 p1=12 p2=7049 p3=64
WAIT #1: nam='db file scattered read' ela= 2989 p1=12 p2=7113 p3=64
WAIT #1: nam='db file scattered read' ela= 2801 p1=12 p2=7177 p3=64
WAIT #1: nam='db file scattered read' ela= 3020 p1=12 p2=7241 p3=64
WAIT #1: nam='db file scattered read' ela= 2811 p1=12 p2=7305 p3=64
WAIT #1: nam='db file scattered read' ela= 2820 p1=12 p2=7369 p3=64
WAIT #1: nam='db file scattered read' ela= 3007 p1=12 p2=7433 p3=64
WAIT #1: nam='db file scattered read' ela= 3029 p1=12 p2=7497 p3=64
WAIT #1: nam='db file scattered read' ela= 3079 p1=12 p2=7561 p3=64
WAIT #1: nam='db file scattered read' ela= 3161 p1=12 p2=7625 p3=64
WAIT #1: nam='db file scattered read' ela= 3093 p1=12 p2=7689 p3=64
WAIT #1: nam='db file scattered read' ela= 3206 p1=12 p2=7753 p3=64
WAIT #1: nam='db file scattered read' ela= 3162 p1=12 p2=7817 p3=64
WAIT #1: nam='db file scattered read' ela= 3103 p1=12 p2=7881 p3=64
WAIT #1: nam='db file scattered read' ela= 3182 p1=12 p2=7945 p3=64
WAIT #1: nam='db file scattered read' ela= 2998 p1=12 p2=8009 p3=64
WAIT #1: nam='db file scattered read' ela= 3006 p1=12 p2=8073 p3=64
WAIT #1: nam='db file scattered read' ela= 3073 p1=12 p2=8137 p3=64
WAIT #1: nam='db file scattered read' ela= 2899 p1=12 p2=8201 p3=64
WAIT #1: nam='db file scattered read' ela= 2842 p1=12 p2=8265 p3=64
WAIT #1: nam='db file scattered read' ela= 2921 p1=12 p2=8329 p3=64
WAIT #1: nam='db file scattered read' ela= 2912 p1=12 p2=8393 p3=64
WAIT #1: nam='db file scattered read' ela= 2851 p1=12 p2=8457 p3=64
WAIT #1: nam='db file scattered read' ela= 3012 p1=12 p2=8521 p3=64
WAIT #1: nam='db file scattered read' ela= 2941 p1=12 p2=8585 p3=64
WAIT #1: nam='db file scattered read' ela= 3195 p1=12 p2=8649 p3=64
WAIT #1: nam='db file scattered read' ela= 3032 p1=12 p2=8713 p3=64
WAIT #1: nam='db file scattered read' ela= 3135 p1=12 p2=8777 p3=64
WAIT #1: nam='db file scattered read' ela= 3160 p1=12 p2=8841 p3=64
WAIT #1: nam='db file scattered read' ela= 1028 p1=12 p2=8905 p3=24
FETCH #1:c=1800000,e=1867559,p=8919,cr=8922,cu=9,mis=0,r=1,dep=0,og=4,tim=1061578474474524
WAIT #1: nam='SQL*Net message from client' ela= 3405 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=1061578474478407
WAIT #1: nam='SQL*Net message to client' ela= 76 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3326 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=33417 op='TABLE ACCESS FULL MY_SOURCE '
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=0 oct=42 lid=0 tim=1061578474482503 hv=3381932903 ad='84be0ef0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=144,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061578474482491
EXEC #1:c=0,e=151,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061578474482797
*** 2003-08-22 16:34:50.553
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=1061580890553012 hv=287842151 ad='84bf6700'
alter session set events '10046 trace name context forever, level 8'
END OF STMT
EXEC #1:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580890552999
WAIT #1: nam='SQL*Net message to client' ela= 79 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3129 p1=1650815232 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=76 dep=0 uid=0 oct=3 lid=0 tim=1061580890556833 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=65,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580890556823
EXEC #1:c=0,e=95,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580890557115
WAIT #1: nam='SQL*Net message to client' ela= 77 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file scattered read' ela= 32601 p1=12 p2=10 p3=64
WAIT #1: nam='db file scattered read' ela= 36155 p1=12 p2=74 p3=64
WAIT #1: nam='db file scattered read' ela= 14294 p1=12 p2=138 p3=64
WAIT #1: nam='db file scattered read' ela= 19962 p1=12 p2=202 p3=64
WAIT #1: nam='db file scattered read' ela= 15122 p1=12 p2=266 p3=64
WAIT #1: nam='db file scattered read' ela= 29294 p1=12 p2=330 p3=64
WAIT #1: nam='db file scattered read' ela= 12588 p1=12 p2=394 p3=64
WAIT #1: nam='db file scattered read' ela= 21092 p1=12 p2=458 p3=64
WAIT #1: nam='db file scattered read' ela= 10670 p1=12 p2=522 p3=64
WAIT #1: nam='db file scattered read' ela= 14617 p1=12 p2=586 p3=64
WAIT #1: nam='db file scattered read' ela= 12780 p1=12 p2=650 p3=64
WAIT #1: nam='db file scattered read' ela= 10382 p1=12 p2=714 p3=64
WAIT #1: nam='db file scattered read' ela= 17525 p1=12 p2=778 p3=64
WAIT #1: nam='db file scattered read' ela= 15041 p1=12 p2=842 p3=64
WAIT #1: nam='db file scattered read' ela= 15375 p1=12 p2=906 p3=64
WAIT #1: nam='db file scattered read' ela= 13188 p1=12 p2=970 p3=64
WAIT #1: nam='db file scattered read' ela= 23828 p1=12 p2=1034 p3=64
WAIT #1: nam='db file scattered read' ela= 12217 p1=12 p2=1098 p3=64
WAIT #1: nam='db file scattered read' ela= 16885 p1=12 p2=1162 p3=64
WAIT #1: nam='db file scattered read' ela= 9104 p1=12 p2=1226 p3=63
WAIT #1: nam='db file scattered read' ela= 10241 p1=12 p2=1289 p3=64
WAIT #1: nam='db file scattered read' ela= 17421 p1=12 p2=1353 p3=64
WAIT #1: nam='db file scattered read' ela= 4939 p1=12 p2=1417 p3=64
WAIT #1: nam='db file scattered read' ela= 11408 p1=12 p2=1481 p3=64
WAIT #1: nam='db file scattered read' ela= 27922 p1=12 p2=1545 p3=64
WAIT #1: nam='db file scattered read' ela= 9198 p1=12 p2=1609 p3=64
WAIT #1: nam='db file scattered read' ela= 9503 p1=12 p2=1673 p3=64
WAIT #1: nam='db file scattered read' ela= 27240 p1=12 p2=1737 p3=64
WAIT #1: nam='db file scattered read' ela= 11083 p1=12 p2=1801 p3=64
WAIT #1: nam='db file scattered read' ela= 16850 p1=12 p2=1865 p3=64
WAIT #1: nam='db file scattered read' ela= 14680 p1=12 p2=1929 p3=64
WAIT #1: nam='db file scattered read' ela= 8912 p1=12 p2=1993 p3=64
WAIT #1: nam='db file scattered read' ela= 25312 p1=12 p2=2057 p3=64
WAIT #1: nam='db file scattered read' ela= 24891 p1=12 p2=2121 p3=64
WAIT #1: nam='db file scattered read' ela= 30492 p1=12 p2=2185 p3=64
WAIT #1: nam='db file scattered read' ela= 5285 p1=12 p2=2249 p3=64
WAIT #1: nam='db file scattered read' ela= 5586 p1=12 p2=2313 p3=64
WAIT #1: nam='db file scattered read' ela= 14460 p1=12 p2=2377 p3=64
WAIT #1: nam='db file scattered read' ela= 5002 p1=12 p2=2441 p3=64
WAIT #1: nam='db file scattered read' ela= 5320 p1=12 p2=2505 p3=64
WAIT #1: nam='db file scattered read' ela= 5583 p1=12 p2=2569 p3=64
WAIT #1: nam='db file scattered read' ela= 31995 p1=12 p2=2633 p3=64
WAIT #1: nam='db file scattered read' ela= 4756 p1=12 p2=2697 p3=64
WAIT #1: nam='db file scattered read' ela= 5813 p1=12 p2=2761 p3=64
WAIT #1: nam='db file scattered read' ela= 5022 p1=12 p2=2825 p3=64
WAIT #1: nam='db file scattered read' ela= 9296 p1=12 p2=2889 p3=64
WAIT #1: nam='db file scattered read' ela= 31048 p1=12 p2=2953 p3=64
WAIT #1: nam='db file scattered read' ela= 5106 p1=12 p2=3017 p3=64
WAIT #1: nam='db file scattered read' ela= 5394 p1=12 p2=3081 p3=64
WAIT #1: nam='db file scattered read' ela= 17151 p1=12 p2=3145 p3=64
WAIT #1: nam='db file scattered read' ela= 16414 p1=12 p2=3209 p3=64
WAIT #1: nam='db file scattered read' ela= 5238 p1=12 p2=3273 p3=64
WAIT #1: nam='db file scattered read' ela= 4167 p1=12 p2=3337 p3=64
WAIT #1: nam='db file scattered read' ela= 4151 p1=12 p2=3401 p3=64
WAIT #1: nam='db file scattered read' ela= 4166 p1=12 p2=3465 p3=64
WAIT #1: nam='db file scattered read' ela= 4262 p1=12 p2=3529 p3=64
WAIT #1: nam='db file scattered read' ela= 4090 p1=12 p2=3593 p3=64
WAIT #1: nam='db file scattered read' ela= 4108 p1=12 p2=3657 p3=64
WAIT #1: nam='db file scattered read' ela= 4223 p1=12 p2=3721 p3=64
WAIT #1: nam='db file scattered read' ela= 4176 p1=12 p2=3785 p3=64
WAIT #1: nam='db file scattered read' ela= 4225 p1=12 p2=3849 p3=64
WAIT #1: nam='db file scattered read' ela= 4126 p1=12 p2=3913 p3=64
WAIT #1: nam='db file scattered read' ela= 6868 p1=12 p2=3977 p3=64
WAIT #1: nam='db file scattered read' ela= 4608 p1=12 p2=4041 p3=64
WAIT #1: nam='db file scattered read' ela= 4550 p1=12 p2=4105 p3=64
WAIT #1: nam='db file scattered read' ela= 4550 p1=12 p2=4169 p3=64
WAIT #1: nam='db file scattered read' ela= 4594 p1=12 p2=4233 p3=64
WAIT #1: nam='db file scattered read' ela= 4662 p1=12 p2=4297 p3=64
WAIT #1: nam='db file scattered read' ela= 4559 p1=12 p2=4361 p3=64
WAIT #1: nam='db file scattered read' ela= 4595 p1=12 p2=4425 p3=64
WAIT #1: nam='db file scattered read' ela= 4684 p1=12 p2=4489 p3=64
WAIT #1: nam='db file scattered read' ela= 4708 p1=12 p2=4553 p3=64
WAIT #1: nam='db file scattered read' ela= 4770 p1=12 p2=4617 p3=64
WAIT #1: nam='db file scattered read' ela= 4641 p1=12 p2=4681 p3=64
WAIT #1: nam='db file scattered read' ela= 4541 p1=12 p2=4745 p3=64
WAIT #1: nam='db file scattered read' ela= 4577 p1=12 p2=4809 p3=64
WAIT #1: nam='db file scattered read' ela= 4751 p1=12 p2=4873 p3=64
WAIT #1: nam='db file scattered read' ela= 4495 p1=12 p2=4937 p3=64
WAIT #1: nam='db file scattered read' ela= 4623 p1=12 p2=5001 p3=64
WAIT #1: nam='db file scattered read' ela= 4654 p1=12 p2=5065 p3=64
WAIT #1: nam='db file scattered read' ela= 4597 p1=12 p2=5129 p3=64
WAIT #1: nam='db file scattered read' ela= 4659 p1=12 p2=5193 p3=64
WAIT #1: nam='db file scattered read' ela= 4557 p1=12 p2=5257 p3=64
WAIT #1: nam='db file scattered read' ela= 4564 p1=12 p2=5321 p3=64
WAIT #1: nam='db file scattered read' ela= 4487 p1=12 p2=5385 p3=64
WAIT #1: nam='db file scattered read' ela= 4511 p1=12 p2=5449 p3=64
WAIT #1: nam='db file scattered read' ela= 4572 p1=12 p2=5513 p3=64
WAIT #1: nam='db file scattered read' ela= 4450 p1=12 p2=5577 p3=64
WAIT #1: nam='db file scattered read' ela= 4675 p1=12 p2=5641 p3=64
WAIT #1: nam='db file scattered read' ela= 4675 p1=12 p2=5705 p3=64
WAIT #1: nam='db file scattered read' ela= 4610 p1=12 p2=5769 p3=64
WAIT #1: nam='db file scattered read' ela= 4470 p1=12 p2=5833 p3=64
WAIT #1: nam='db file scattered read' ela= 4477 p1=12 p2=5897 p3=64
WAIT #1: nam='db file scattered read' ela= 4569 p1=12 p2=5961 p3=64
WAIT #1: nam='db file scattered read' ela= 4456 p1=12 p2=6025 p3=64
WAIT #1: nam='db file scattered read' ela= 4486 p1=12 p2=6089 p3=64
WAIT #1: nam='db file scattered read' ela= 4623 p1=12 p2=6153 p3=64
WAIT #1: nam='db file scattered read' ela= 4619 p1=12 p2=6217 p3=64
WAIT #1: nam='db file scattered read' ela= 4584 p1=12 p2=6281 p3=64
WAIT #1: nam='db file scattered read' ela= 4572 p1=12 p2=6345 p3=64
WAIT #1: nam='db file scattered read' ela= 4568 p1=12 p2=6409 p3=64
WAIT #1: nam='db file scattered read' ela= 4757 p1=12 p2=6473 p3=64
WAIT #1: nam='db file scattered read' ela= 4571 p1=12 p2=6537 p3=64
WAIT #1: nam='db file scattered read' ela= 4547 p1=12 p2=6601 p3=64
WAIT #1: nam='db file scattered read' ela= 4654 p1=12 p2=6665 p3=64
WAIT #1: nam='db file scattered read' ela= 4706 p1=12 p2=6729 p3=64
WAIT #1: nam='db file scattered read' ela= 4669 p1=12 p2=6793 p3=64
WAIT #1: nam='db file scattered read' ela= 4664 p1=12 p2=6857 p3=64
WAIT #1: nam='db file scattered read' ela= 4505 p1=12 p2=6921 p3=64
WAIT #1: nam='db file scattered read' ela= 4786 p1=12 p2=6985 p3=64
WAIT #1: nam='db file scattered read' ela= 4552 p1=12 p2=7049 p3=64
WAIT #1: nam='db file scattered read' ela= 4527 p1=12 p2=7113 p3=64
WAIT #1: nam='db file scattered read' ela= 4565 p1=12 p2=7177 p3=64
WAIT #1: nam='db file scattered read' ela= 4528 p1=12 p2=7241 p3=64
WAIT #1: nam='db file scattered read' ela= 4563 p1=12 p2=7305 p3=64
WAIT #1: nam='db file scattered read' ela= 4693 p1=12 p2=7369 p3=64
WAIT #1: nam='db file scattered read' ela= 4576 p1=12 p2=7433 p3=64
WAIT #1: nam='db file scattered read' ela= 4703 p1=12 p2=7497 p3=64
WAIT #1: nam='db file scattered read' ela= 4502 p1=12 p2=7561 p3=64
WAIT #1: nam='db file scattered read' ela= 4506 p1=12 p2=7625 p3=64
WAIT #1: nam='db file scattered read' ela= 4635 p1=12 p2=7689 p3=64
WAIT #1: nam='db file scattered read' ela= 4505 p1=12 p2=7753 p3=64
WAIT #1: nam='db file scattered read' ela= 4564 p1=12 p2=7817 p3=64
WAIT #1: nam='db file scattered read' ela= 4524 p1=12 p2=7881 p3=64
WAIT #1: nam='db file scattered read' ela= 4565 p1=12 p2=7945 p3=64
WAIT #1: nam='db file scattered read' ela= 4484 p1=12 p2=8009 p3=64
WAIT #1: nam='db file scattered read' ela= 4534 p1=12 p2=8073 p3=64
WAIT #1: nam='db file scattered read' ela= 4514 p1=12 p2=8137 p3=64
WAIT #1: nam='db file scattered read' ela= 4654 p1=12 p2=8201 p3=64
WAIT #1: nam='db file scattered read' ela= 4447 p1=12 p2=8265 p3=64
WAIT #1: nam='db file scattered read' ela= 4694 p1=12 p2=8329 p3=64
WAIT #1: nam='db file scattered read' ela= 4709 p1=12 p2=8393 p3=64
WAIT #1: nam='db file scattered read' ela= 4555 p1=12 p2=8457 p3=64
WAIT #1: nam='db file scattered read' ela= 4789 p1=12 p2=8521 p3=64
WAIT #1: nam='db file scattered read' ela= 4781 p1=12 p2=8585 p3=64
WAIT #1: nam='db file scattered read' ela= 4716 p1=12 p2=8649 p3=64
WAIT #1: nam='db file scattered read' ela= 4745 p1=12 p2=8713 p3=64
WAIT #1: nam='db file scattered read' ela= 2349 p1=12 p2=8857 p3=24
WAIT #1: nam='db file sequential read' ela= 113 p1=12 p2=8928 p3=1
FETCH #1:c=2090000,e=2601222,p=8792,cr=8922,cu=9,mis=0,r=1,dep=0,og=4,tim=1061580893158535
WAIT #1: nam='SQL*Net message from client' ela= 3379 p1=1650815232 p2=1 p3=0
FETCH #1:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1061580893162319
WAIT #1: nam='SQL*Net message to client' ela= 76 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 2918 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=33417 op='TABLE ACCESS FULL MY_SOURCE '
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=0 oct=42 lid=0 tim=1061580893165953 hv=3381932903 ad='84be0ef0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=121,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580893165942
EXEC #1:c=0,e=126,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580893166220
*** 2003-08-22 16:36:07.259
=====================
PARSING IN CURSOR #1 len=68 dep=0 uid=0 oct=42 lid=0 tim=1061580967259152 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=1061580967259137
WAIT #1: nam='SQL*Net message to client' ela= 79 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3928 p1=1650815232 p2=1 p3=0
=====================
PARSING IN CURSOR #1 len=76 dep=0 uid=0 oct=3 lid=0 tim=1061580967263774 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=71,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580967263762
EXEC #1:c=0,e=90,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580967264066
WAIT #1: nam='SQL*Net message to client' ela= 79 p1=1650815232 p2=1 p3=0
WAIT #1: nam='db file scattered read' ela= 30250 p1=12 p2=10 p3=64
WAIT #1: nam='db file scattered read' ela= 35620 p1=12 p2=74 p3=64
WAIT #1: nam='db file scattered read' ela= 12535 p1=12 p2=138 p3=64
WAIT #1: nam='db file scattered read' ela= 23599 p1=12 p2=202 p3=64
WAIT #1: nam='db file scattered read' ela= 11630 p1=12 p2=266 p3=64
WAIT #1: nam='db file scattered read' ela= 19093 p1=12 p2=330 p3=64
WAIT #1: nam='db file scattered read' ela= 13474 p1=12 p2=394 p3=64
WAIT #1: nam='db file scattered read' ela= 24566 p1=12 p2=458 p3=64
WAIT #1: nam='db file scattered read' ela= 10878 p1=12 p2=522 p3=64
WAIT #1: nam='db file scattered read' ela= 16103 p1=12 p2=586 p3=64
WAIT #1: nam='db file scattered read' ela= 14662 p1=12 p2=650 p3=64
WAIT #1: nam='db file scattered read' ela= 13983 p1=12 p2=714 p3=64
WAIT #1: nam='db file scattered read' ela= 25129 p1=12 p2=778 p3=64
WAIT #1: nam='db file scattered read' ela= 5874 p1=12 p2=842 p3=64
WAIT #1: nam='db file scattered read' ela= 11026 p1=12 p2=906 p3=64
WAIT #1: nam='db file scattered read' ela= 20706 p1=12 p2=970 p3=64
WAIT #1: nam='db file scattered read' ela= 29809 p1=12 p2=1034 p3=64
WAIT #1: nam='db file scattered read' ela= 11419 p1=12 p2=1098 p3=64
WAIT #1: nam='db file scattered read' ela= 29873 p1=12 p2=1162 p3=64
WAIT #1: nam='db file scattered read' ela= 7572 p1=12 p2=1226 p3=63
WAIT #1: nam='db file scattered read' ela= 16365 p1=12 p2=1289 p3=64
WAIT #1: nam='db file scattered read' ela= 12656 p1=12 p2=1353 p3=64
WAIT #1: nam='db file scattered read' ela= 20297 p1=12 p2=1417 p3=64
WAIT #1: nam='db file scattered read' ela= 21296 p1=12 p2=1481 p3=64
WAIT #1: nam='db file scattered read' ela= 11735 p1=12 p2=1545 p3=64
WAIT #1: nam='db file scattered read' ela= 21221 p1=12 p2=1609 p3=64
WAIT #1: nam='db file scattered read' ela= 23070 p1=12 p2=1673 p3=64
WAIT #1: nam='db file scattered read' ela= 10883 p1=12 p2=1737 p3=64
WAIT #1: nam='db file scattered read' ela= 17880 p1=12 p2=1801 p3=64
WAIT #1: nam='db file scattered read' ela= 24066 p1=12 p2=1865 p3=64
WAIT #1: nam='db file scattered read' ela= 35236 p1=12 p2=1929 p3=64
WAIT #1: nam='db file scattered read' ela= 21487 p1=12 p2=1993 p3=64
WAIT #1: nam='db file scattered read' ela= 23383 p1=12 p2=2057 p3=64
WAIT #1: nam='db file scattered read' ela= 34690 p1=12 p2=2121 p3=64
WAIT #1: nam='db file scattered read' ela= 21347 p1=12 p2=2185 p3=64
WAIT #1: nam='db file scattered read' ela= 11630 p1=12 p2=2249 p3=64
WAIT #1: nam='db file scattered read' ela= 20722 p1=12 p2=2313 p3=64
WAIT #1: nam='db file scattered read' ela= 12839 p1=12 p2=2377 p3=64
WAIT #1: nam='db file scattered read' ela= 7486 p1=12 p2=2441 p3=64
WAIT #1: nam='db file scattered read' ela= 10823 p1=12 p2=2505 p3=64
WAIT #1: nam='db file scattered read' ela= 20034 p1=12 p2=2569 p3=64
WAIT #1: nam='db file scattered read' ela= 15542 p1=12 p2=2633 p3=64
WAIT #1: nam='db file scattered read' ela= 8152 p1=12 p2=2697 p3=64
WAIT #1: nam='db file scattered read' ela= 16642 p1=12 p2=2761 p3=64
WAIT #1: nam='db file scattered read' ela= 9595 p1=12 p2=2825 p3=64
WAIT #1: nam='db file scattered read' ela= 14368 p1=12 p2=2889 p3=64
WAIT #1: nam='db file scattered read' ela= 13523 p1=12 p2=2953 p3=64
WAIT #1: nam='db file scattered read' ela= 25612 p1=12 p2=3017 p3=64
WAIT #1: nam='db file scattered read' ela= 5254 p1=12 p2=3081 p3=64
WAIT #1: nam='db file scattered read' ela= 33625 p1=12 p2=3145 p3=64
WAIT #1: nam='db file scattered read' ela= 30054 p1=12 p2=3209 p3=64
WAIT #1: nam='db file scattered read' ela= 5934 p1=12 p2=3273 p3=64
WAIT #1: nam='db file scattered read' ela= 3228 p1=12 p2=3337 p3=64
WAIT #1: nam='db file scattered read' ela= 3304 p1=12 p2=3401 p3=64
WAIT #1: nam='db file scattered read' ela= 3365 p1=12 p2=3465 p3=64
WAIT #1: nam='db file scattered read' ela= 3320 p1=12 p2=3529 p3=64
WAIT #1: nam='db file scattered read' ela= 3173 p1=12 p2=3593 p3=64
WAIT #1: nam='db file scattered read' ela= 3147 p1=12 p2=3657 p3=64
WAIT #1: nam='db file scattered read' ela= 3182 p1=12 p2=3721 p3=64
WAIT #1: nam='db file scattered read' ela= 3225 p1=12 p2=3785 p3=64
WAIT #1: nam='db file scattered read' ela= 3119 p1=12 p2=3849 p3=64
WAIT #1: nam='db file scattered read' ela= 3088 p1=12 p2=3913 p3=64
WAIT #1: nam='db file scattered read' ela= 3132 p1=12 p2=3977 p3=64
WAIT #1: nam='db file scattered read' ela= 3198 p1=12 p2=4041 p3=64
WAIT #1: nam='db file scattered read' ela= 3170 p1=12 p2=4105 p3=64
WAIT #1: nam='db file scattered read' ela= 3182 p1=12 p2=4169 p3=64
WAIT #1: nam='db file scattered read' ela= 3204 p1=12 p2=4233 p3=64
WAIT #1: nam='db file scattered read' ela= 3251 p1=12 p2=4297 p3=64
WAIT #1: nam='db file scattered read' ela= 3217 p1=12 p2=4361 p3=64
WAIT #1: nam='db file scattered read' ela= 3168 p1=12 p2=4425 p3=64
WAIT #1: nam='db file scattered read' ela= 3267 p1=12 p2=4489 p3=64
WAIT #1: nam='db file scattered read' ela= 3282 p1=12 p2=4553 p3=64
WAIT #1: nam='db file scattered read' ela= 3413 p1=12 p2=4617 p3=64
WAIT #1: nam='db file scattered read' ela= 3290 p1=12 p2=4681 p3=64
WAIT #1: nam='db file scattered read' ela= 3212 p1=12 p2=4745 p3=64
WAIT #1: nam='db file scattered read' ela= 3203 p1=12 p2=4809 p3=64
WAIT #1: nam='db file scattered read' ela= 3347 p1=12 p2=4873 p3=64
WAIT #1: nam='db file scattered read' ela= 3138 p1=12 p2=4937 p3=64
WAIT #1: nam='db file scattered read' ela= 3326 p1=12 p2=5001 p3=64
WAIT #1: nam='db file scattered read' ela= 3313 p1=12 p2=5065 p3=64
WAIT #1: nam='db file scattered read' ela= 3194 p1=12 p2=5129 p3=64
WAIT #1: nam='db file scattered read' ela= 3256 p1=12 p2=5193 p3=64
WAIT #1: nam='db file scattered read' ela= 3320 p1=12 p2=5257 p3=64
WAIT #1: nam='db file scattered read' ela= 3182 p1=12 p2=5321 p3=64
WAIT #1: nam='db file scattered read' ela= 3143 p1=12 p2=5385 p3=64
WAIT #1: nam='db file scattered read' ela= 3138 p1=12 p2=5449 p3=64
WAIT #1: nam='db file scattered read' ela= 3412 p1=12 p2=5513 p3=64
WAIT #1: nam='db file scattered read' ela= 3148 p1=12 p2=5577 p3=64
WAIT #1: nam='db file scattered read' ela= 3388 p1=12 p2=5641 p3=64
WAIT #1: nam='db file scattered read' ela= 3166 p1=12 p2=5705 p3=64
WAIT #1: nam='db file scattered read' ela= 3256 p1=12 p2=5769 p3=64
WAIT #1: nam='db file scattered read' ela= 3125 p1=12 p2=5833 p3=64
WAIT #1: nam='db file scattered read' ela= 3159 p1=12 p2=5897 p3=64
WAIT #1: nam='db file scattered read' ela= 3176 p1=12 p2=5961 p3=64
WAIT #1: nam='db file scattered read' ela= 3089 p1=12 p2=6025 p3=64
WAIT #1: nam='db file scattered read' ela= 3287 p1=12 p2=6089 p3=64
WAIT #1: nam='db file scattered read' ela= 3246 p1=12 p2=6153 p3=64
WAIT #1: nam='db file scattered read' ela= 3360 p1=12 p2=6217 p3=64
WAIT #1: nam='db file scattered read' ela= 3200 p1=12 p2=6281 p3=64
WAIT #1: nam='db file scattered read' ela= 3128 p1=12 p2=6345 p3=64
WAIT #1: nam='db file scattered read' ela= 3215 p1=12 p2=6409 p3=64
WAIT #1: nam='db file scattered read' ela= 3354 p1=12 p2=6473 p3=64
WAIT #1: nam='db file scattered read' ela= 3264 p1=12 p2=6537 p3=64
WAIT #1: nam='db file scattered read' ela= 3216 p1=12 p2=6601 p3=64
WAIT #1: nam='db file scattered read' ela= 3224 p1=12 p2=6665 p3=64
WAIT #1: nam='db file scattered read' ela= 3273 p1=12 p2=6729 p3=64
WAIT #1: nam='db file scattered read' ela= 3335 p1=12 p2=6793 p3=64
WAIT #1: nam='db file scattered read' ela= 3288 p1=12 p2=6857 p3=64
WAIT #1: nam='db file scattered read' ela= 3125 p1=12 p2=6921 p3=64
WAIT #1: nam='db file scattered read' ela= 3263 p1=12 p2=6985 p3=64
WAIT #1: nam='db file scattered read' ela= 3294 p1=12 p2=7049 p3=64
WAIT #1: nam='db file scattered read' ela= 3288 p1=12 p2=7113 p3=64
WAIT #1: nam='db file scattered read' ela= 3317 p1=12 p2=7177 p3=64
WAIT #1: nam='db file scattered read' ela= 3259 p1=12 p2=7241 p3=64
WAIT #1: nam='db file scattered read' ela= 3417 p1=12 p2=7305 p3=64
WAIT #1: nam='db file scattered read' ela= 3408 p1=12 p2=7369 p3=64
WAIT #1: nam='db file scattered read' ela= 3161 p1=12 p2=7433 p3=64
WAIT #1: nam='db file scattered read' ela= 3332 p1=12 p2=7497 p3=64
WAIT #1: nam='db file scattered read' ela= 3128 p1=12 p2=7561 p3=64
WAIT #1: nam='db file scattered read' ela= 3281 p1=12 p2=7625 p3=64
WAIT #1: nam='db file scattered read' ela= 3328 p1=12 p2=7689 p3=64
WAIT #1: nam='db file scattered read' ela= 3116 p1=12 p2=7753 p3=64
WAIT #1: nam='db file scattered read' ela= 3220 p1=12 p2=7817 p3=64
WAIT #1: nam='db file scattered read' ela= 3234 p1=12 p2=7881 p3=64
WAIT #1: nam='db file scattered read' ela= 3220 p1=12 p2=7945 p3=64
WAIT #1: nam='db file scattered read' ela= 3147 p1=12 p2=8009 p3=64
WAIT #1: nam='db file scattered read' ela= 3175 p1=12 p2=8073 p3=64
WAIT #1: nam='db file scattered read' ela= 3312 p1=12 p2=8137 p3=64
WAIT #1: nam='db file scattered read' ela= 3222 p1=12 p2=8201 p3=64
WAIT #1: nam='db file scattered read' ela= 3052 p1=12 p2=8265 p3=64
WAIT #1: nam='db file scattered read' ela= 3292 p1=12 p2=8329 p3=64
WAIT #1: nam='db file scattered read' ela= 3374 p1=12 p2=8393 p3=64
WAIT #1: nam='db file scattered read' ela= 3206 p1=12 p2=8457 p3=64
WAIT #1: nam='db file scattered read' ela= 3377 p1=12 p2=8521 p3=64
WAIT #1: nam='db file scattered read' ela= 3468 p1=12 p2=8585 p3=64
WAIT #1: nam='db file scattered read' ela= 3391 p1=12 p2=8649 p3=64
WAIT #1: nam='db file scattered read' ela= 2048 p1=12 p2=8833 p3=24
WAIT #1: nam='db file scattered read' ela= 4861 p1=12 p2=8864 p3=64
WAIT #1: nam='db file sequential read' ela= 70 p1=12 p2=8928 p3=1
FETCH #1:c=1820000,e=2516182,p=8792,cr=8922,cu=9,mis=0,r=1,dep=0,og=4,tim=1061580969780458
WAIT #1: nam='SQL*Net message from client' ela= 3212 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=1061580969784066
WAIT #1: nam='SQL*Net message to client' ela= 74 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 3358 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=33417 op='TABLE ACCESS FULL MY_SOURCE '
=====================
PARSING IN CURSOR #1 len=55 dep=0 uid=0 oct=42 lid=0 tim=1061580969788127 hv=3381932903 ad='84be0ef0'
alter session set events '10046 trace name context off'
END OF STMT
PARSE #1:c=0,e=115,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580969788116
EXEC #1:c=0,e=120,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=1061580969788387