Tests' data. ============================================================================= G-SIM_10 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5767 1.79 1.52 0 0 0 0 Execute 5768 0.95 0.90 0 0 0 0 Fetch 11531 5.81 44.09 16922 432540 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23066 8.56 46.51 16922 432540 0 57658 Misses in library cache during parse: 2 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 28833 0.00 0.06 SQL*Net message from client 28833 0.04 18.99 SQL*Net more data to client 3879 0.00 0.21 db file sequential read 16922 0.05 38.71 Total clean time 46.51 - 38.71 = 7.80 ============================================================================= G-SIM_20 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2884 0.67 0.83 0 0 0 0 Execute 2885 0.68 0.51 0 0 0 0 Fetch 8648 5.65 42.95 16853 426774 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14417 7.01 44.29 16853 426774 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 17301 0.00 0.03 SQL*Net message from client 17301 0.05 13.72 SQL*Net more data to client 3879 0.00 0.28 db file sequential read 16853 0.04 37.64 Total clean time 44.29 - 37.64 = 6.65 ============================================================================= G-SIM_40 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1443 0.53 0.49 0 0 0 0 Execute 1444 0.29 0.32 0 0 0 0 Fetch 7207 5.34 42.99 16890 423892 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10094 6.17 43.82 16890 423892 0 57658 Misses in library cache during parse: 2 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 11537 0.00 0.02 SQL*Net message from client 11537 0.04 10.77 SQL*Net more data to client 3879 0.00 0.28 db file sequential read 16890 0.07 37.84 Total clean time 43.82 - 37.84 = 5.98 ============================================================================= G-SIM_60 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 962 0.29 0.37 0 0 0 0 Execute 963 0.23 0.27 0 0 0 0 Fetch 6726 5.37 43.68 16850 422930 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8651 5.90 44.33 16850 422930 0 57658 Misses in library cache during parse: 2 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 9613 0.00 0.01 SQL*Net message from client 9613 0.04 9.24 SQL*Net more data to client 3879 0.00 0.27 db file sequential read 16850 0.12 38.64 Total clean time 44.33 - 38.64 = 5.69 ============================================================================= G-SIM_80 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 722 0.29 0.30 0 0 0 0 Execute 723 0.20 0.24 0 0 0 0 Fetch 6486 5.54 44.11 16928 422450 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7931 6.04 44.66 16928 422450 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 8653 0.00 0.01 SQL*Net message from client 8653 0.04 9.56 SQL*Net more data to client 3879 0.00 0.26 db file sequential read 16928 0.19 38.98 Total clean time 44.66 - 38.98 = 5.68 ============================================================================= G-SIM_100 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 578 0.29 0.27 0 0 0 0 Execute 579 0.28 0.23 0 0 0 0 Fetch 6342 5.06 41.18 16870 422162 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7499 5.64 41.69 16870 422162 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 8077 0.00 0.01 SQL*Net message from client 8077 0.06 9.18 SQL*Net more data to client 3879 0.00 0.25 db file sequential read 16870 0.09 36.16 Total clean time 41.69 - 36.16 = 5.53 ============================================================================= G-SIM_200 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 290 0.21 0.20 0 0 0 0 Execute 291 0.25 0.31 0 0 0 0 Fetch 6054 5.87 41.25 16872 421586 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6635 6.34 41.76 16872 421586 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6925 0.00 0.01 SQL*Net message from client 6925 0.06 8.24 SQL*Net more data from client 288 0.00 0.00 SQL*Net more data to client 3879 0.00 0.28 db file sequential read 16872 0.09 36.12 Total clean time 41.76 - 36.12 = 5.64 ============================================================================= G-SIM_400 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 146 0.17 0.24 0 0 0 0 Execute 147 0.98 0.78 0 0 0 0 Fetch 5910 8.39 472.80 16984 421298 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6203 9.54 473.82 16984 421298 0 57658 Misses in library cache during parse: 3 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 6349 0.00 0.02 SQL*Net message from client 6349 0.60 9.84 SQL*Net more data from client 144 0.00 0.00 db file sequential read 16984 0.32 464.36 SQL*Net more data to client 3881 0.00 0.43 Total clean time 473.82 - 464.36 = 9.46 ============================================================================= G-SIM_800 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 74 0.18 0.18 0 0 0 0 Execute 75 3.56 3.49 0 0 0 0 Fetch 5838 6.54 88.59 16919 421154 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5987 10.29 92.27 16919 421154 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6061 0.00 0.01 SQL*Net message from client 6061 0.10 9.28 SQL*Net more data from client 72 0.00 0.00 SQL*Net more data to client 3885 0.00 0.30 db file sequential read 16919 0.11 81.97 latch free 1 0.00 0.00 Total clean time 92.27 - 81.97 = 9.46 ============================================================================= G-SIM_900 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 66 0.26 0.21 0 0 0 0 Execute 67 4.65 4.79 0 0 0 0 Fetch 5830 5.79 39.72 16916 421138 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5963 10.71 44.72 16916 421138 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6029 0.00 0.01 SQL*Net message from client 6029 0.11 8.44 SQL*Net more data from client 64 0.00 0.00 SQL*Net more data to client 3884 0.00 0.33 db file sequential read 16916 0.04 34.03 Total clean time 44.72 - 34.03 = 9.46 ============================================================================= G-SIM_950 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 62 0.20 0.22 0 0 0 0 Execute 63 7.18 7.12 0 0 0 0 Fetch 5826 6.17 39.94 16889 421130 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5951 13.56 47.29 16889 421130 0 57658 Misses in library cache during parse: 2 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6013 0.00 0.01 SQL*Net message from client 6013 0.11 9.35 SQL*Net more data from client 61 0.00 0.00 SQL*Net more data to client 3883 0.00 0.30 db file sequential read 16889 0.13 34.08 Total clean time 47.29 - 34.08 = 9.46 ============================================================================= G-SIM_1000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 59 0.32 0.22 0 0 0 0 Execute 60 7.76 7.91 0 0 0 0 Fetch 5823 5.37 39.30 16920 421124 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5942 13.46 47.45 16920 421124 0 57658 Misses in library cache during parse: 2 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6001 0.00 0.01 SQL*Net message from client 6001 0.11 7.49 SQL*Net more data from client 58 0.00 0.00 SQL*Net more data to client 3884 0.00 0.22 db file sequential read 16920 0.06 34.17 Total clean time 47.45 - 34.17 = 13.28 ============================================================================= G-SIM_1500 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 40 0.43 0.39 0 451 0 0 Execute 41 22.45 22.66 0 0 0 0 Fetch 5804 6.32 43.41 16883 421086 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5885 29.21 66.47 16883 421537 0 57658 Misses in library cache during parse: 3 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 5925 0.00 0.01 SQL*Net message from client 5925 0.17 9.56 SQL*Net more data from client 39 0.00 0.00 db file sequential read 16886 0.05 37.57 SQL*Net more data to client 3885 0.00 0.64 latch free 1 0.00 0.00 Total clean time 66.47 - 37.57 = 28.90 ============================================================================= G-SIM_2000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 30 0.67 0.65 0 451 0 0 Execute 31 75.14 78.24 0 0 0 0 Fetch 5794 6.34 47.91 16992 421066 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5855 82.15 126.80 16992 421517 0 57658 Misses in library cache during parse: 3 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 5885 0.00 0.01 SQL*Net message from client 5885 0.25 11.67 SQL*Net more data from client 29 0.00 0.00 db file sequential read 16995 0.53 41.68 SQL*Net more data to client 3885 0.00 0.55 Total clean time 126.80 - 41.68 = 41.68 ============================================================================= G-SIM_4000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 16 1.37 1.55 0 0 0 0 Execute 17 373.29 378.10 0 0 0 0 Fetch 5780 6.28 44.33 16979 421038 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5813 380.95 423.99 16979 421038 0 57658 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5829 0.00 0.01 SQL*Net message from client 5829 1.90 25.57 SQL*Net more data from client 15 0.00 0.01 SQL*Net more data to client 3885 0.00 0.35 db file sequential read 16979 0.07 38.15 Total clean time 423.99 - 38.15 = 347.69 ============================================================================= T-SIM_10 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 11535 0.57 0.80 0 0 0 0 Execute 17301 6.01 6.58 8 17 0 11533 Fetch 11531 5.93 39.77 17001 380544 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 40367 12.53 47.17 17009 380561 0 69191 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 46137 0.00 0.11 SQL*Net message from client 46137 0.05 22.13 db file sequential read 17001 0.08 34.60 SQL*Net more data to client 3879 0.00 0.27 Total clean time 47.17 - 34.60 = 12.57 ============================================================================= T-SIM_20 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5769 0.37 0.42 0 0 0 0 Execute 8652 3.28 3.60 8 17 0 5767 Fetch 8648 5.46 38.50 16909 371895 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23069 9.12 42.53 16917 371912 0 63425 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 25956 0.00 0.06 SQL*Net message from client 25956 0.06 15.36 db file sequential read 16909 0.09 33.48 SQL*Net more data to client 3879 0.00 0.31 Total clean time 42.53 - 33.48 = 9.05 ============================================================================= T-SIM_40 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2887 0.26 0.21 0 0 0 0 Execute 4329 1.82 1.95 8 17 0 2885 Fetch 7207 5.20 37.89 16856 367572 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14423 7.29 40.06 16864 367589 0 60543 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 15869 0.00 0.03 SQL*Net message from client 15869 0.04 11.32 db file sequential read 16856 0.10 33.22 SQL*Net more data to client 3879 0.00 0.26 Total clean time 40.06 - 33.22 = 6.84 ============================================================================= T-SIM_60 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1925 0.17 0.13 0 0 0 0 Execute 2886 1.25 1.35 8 17 0 1923 Fetch 6726 4.67 38.89 16855 366129 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11537 6.09 40.38 16863 366146 0 59581 Misses in library cache during parse: 1 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 12502 0.00 0.02 SQL*Net message from client 12502 0.06 9.89 db file sequential read 16855 0.10 34.41 SQL*Net more data to client 3879 0.00 0.28 Total clean time 40.38 - 34.41 = 5.97 ============================================================================= T-SIM_80 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1445 0.09 0.10 0 0 0 0 Execute 2166 0.85 1.09 8 17 0 1443 Fetch 6486 4.85 37.62 16859 365409 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10097 5.81 38.82 16867 365426 0 59101 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 10822 0.00 0.02 SQL*Net message from client 10822 0.04 9.17 db file sequential read 16859 0.10 33.08 SQL*Net more data to client 3879 0.00 0.33 Total clean time 38.82 - 33.08 = 5.74 ============================================================================= T-SIM_100 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1157 0.12 0.08 0 0 0 0 Execute 1734 0.73 0.91 8 17 0 1155 Fetch 6342 5.17 37.61 16842 364977 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9233 6.03 38.61 16850 364994 0 58813 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 9814 0.00 0.02 SQL*Net message from client 9814 0.04 8.78 db file sequential read 16842 0.07 33.08 SQL*Net more data to client 3879 0.00 0.26 Total clean time 38.61 - 33.08 = 5.53 ============================================================================= T-SIM_400 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 293 0.04 0.04 0 0 0 0 Execute 438 0.42 0.43 6 17 0 291 Fetch 5910 5.17 38.88 16956 363681 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6641 5.64 39.36 16962 363698 0 57949 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6790 0.00 0.01 SQL*Net message from client 6790 0.09 6.88 db file sequential read 16957 0.08 34.16 SQL*Net more data from client 144 0.00 0.00 SQL*Net more data to client 3881 0.00 0.26 Total clean time 39.36 - 34.16 = 5.2 ============================================================================= T-SIM_1000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 119 0.01 0.02 0 0 0 0 Execute 177 0.43 0.87 139 771 0 117 Fetch 5772 4.46 41.03 16871 363438 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6068 4.92 41.92 17010 364209 0 57775 Misses in library cache during parse: 1 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 6130 0.00 0.01 SQL*Net message from client 6130 0.06 6.10 SQL*Net more data from client 116 0.00 0.00 db file sequential read 16872 0.08 36.51 SQL*Net more data to client 3839 0.00 0.20 Total clean time 41.92 - 36.51 = 5.41 ============================================================================= T-SIM_2000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 61 0.00 0.00 0 0 0 0 Execute 90 0.29 0.33 8 17 0 59 Fetch 5794 4.64 38.40 16892 363333 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5945 4.93 38.74 16900 363350 0 57717 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5978 0.00 0.01 SQL*Net message from client 5978 0.07 5.76 db file sequential read 16892 0.07 33.95 SQL*Net more data from client 144 0.00 0.00 SQL*Net more data to client 3885 0.00 0.26 Total clean time 38.74 - 33.95 = 4.79 ============================================================================= T-SIM_4000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 0.00 0 0 0 0 Execute 9 0.23 0.31 8 17 0 5 Fetch 5767 5.04 38.76 16920 363252 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5783 5.28 39.07 16928 363269 0 57663 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5789 0.00 0.01 SQL*Net message from client 5789 0.28 5.65 db file sequential read 16920 0.10 34.29 SQL*Net more data from client 171 0.00 0.00 SQL*Net more data to client 3885 0.00 0.34 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 33 0.00 0.00 0 0 0 0 Execute 48 0.20 0.28 6 17 0 31 Fetch 5780 4.62 48.45 16893 363291 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5861 4.82 48.75 16899 363308 0 57689 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5880 0.00 0.01 SQL*Net message from client 5880 0.08 5.93 db file sequential read 16894 0.09 43.78 SQL*Net more data from client 158 0.00 0.00 SQL*Net more data to client 3885 0.00 0.24 Total clean time 39.07 - 34.29 = 4.78 ============================================================================= T-SIM_40000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 0.00 0 0 0 0 Execute 9 0.28 0.30 6 17 0 5 Fetch 5767 5.14 38.99 16831 363252 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5783 5.42 39.29 16837 363269 0 57663 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5789 0.00 0.01 SQL*Net message from client 5789 0.30 5.88 db file sequential read 16832 0.07 34.19 SQL*Net more data from client 171 0.00 0.00 SQL*Net more data to client 3885 0.00 0.26 Total clean time 39.29 - 34.19 = 4.78 ============================================================================= T-EX_10 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 11535 0.96 0.94 7 42 0 0 Execute 17301 6.37 7.31 82 481 0 11533 Fetch 11531 5.79 39.05 16878 380544 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 40367 13.14 47.31 16967 381067 0 69191 Misses in library cache during parse: 4 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 46136 0.00 0.11 SQL*Net message from client 46136 0.04 22.45 db file sequential read 16881 0.09 33.62 SQL*Net more data to client 3879 0.00 0.32 Total clean time 47.31 - 33.62 = 13.69 ============================================================================= T-EX_20 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5769 0.51 0.42 0 0 0 0 Execute 8652 3.29 3.60 8 17 0 5767 Fetch 8648 5.01 38.18 16947 371895 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23069 8.82 42.21 16955 371912 0 63425 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 25956 0.00 0.06 SQL*Net message from client 25956 0.07 15.22 db file sequential read 16947 0.08 33.25 SQL*Net more data to client 3879 0.00 0.27 Total clean time 42.21 - 33.25 = 8.96 ============================================================================= T-EX_40 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2887 0.18 0.20 0 0 0 0 Execute 4329 1.62 1.88 8 17 0 2885 Fetch 7207 5.12 38.56 16895 367572 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14423 6.93 40.65 16903 367589 0 60543 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 15869 0.00 0.03 SQL*Net message from client 15869 0.04 11.18 db file sequential read 16895 0.09 33.93 SQL*Net more data to client 3879 0.00 0.27 Total clean time 40.65 - 33.93 = 6.72 ============================================================================= T-EX_80 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1445 0.14 0.10 0 0 0 0 Execute 2166 0.79 1.08 8 17 0 1443 Fetch 6486 5.23 38.21 16836 365409 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10097 6.17 39.40 16844 365426 0 59101 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 10822 0.00 0.02 SQL*Net message from client 10822 0.04 9.18 db file sequential read 16836 0.07 33.60 SQL*Net more data to client 3879 0.00 0.25 Total clean time 39.40 - 33.60 = 5.80 ============================================================================= T-EX_100 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1157 0.06 0.08 0 0 0 0 Execute 1734 0.70 0.93 8 17 0 1155 Fetch 6342 4.75 37.16 16903 364977 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 9233 5.51 38.17 16911 364994 0 58813 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 9814 0.00 0.02 SQL*Net message from client 9814 0.06 9.10 db file sequential read 16903 0.11 32.90 SQL*Net more data to client 3879 0.00 0.24 latch free 1 0.00 0.00 Total clean time 38.17 - 32.90 = 5.27 ============================================================================= T-EX_200 t200-ex call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 581 0.00 0.04 0 0 0 0 Execute 870 0.48 0.60 8 17 0 579 Fetch 6054 5.20 37.89 16854 364113 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7505 5.68 38.53 16862 364130 0 58237 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 7798 0.00 0.01 SQL*Net message from client 7798 0.05 7.65 db file sequential read 16854 0.07 33.45 SQL*Net more data to client 3879 0.00 0.27 Total clean time 38.53 - 33.45 = 5.08 ============================================================================= T-EX_400 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 293 0.06 0.02 0 0 0 0 Execute 438 0.28 0.45 8 17 0 291 Fetch 5910 4.89 37.97 16832 363681 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6641 5.23 38.44 16840 363698 0 57949 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6790 0.00 0.01 SQL*Net message from client 6790 0.06 6.89 db file sequential read 16832 0.10 33.48 SQL*Net more data from client 144 0.00 0.00 SQL*Net more data to client 3881 0.00 0.26 latch free 1 0.00 0.00 Total clean time 38.44 - 33.48 = 4.96 ============================================================================= T-EX_800 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 149 0.03 0.01 0 0 0 0 Execute 222 0.18 0.38 8 17 0 147 Fetch 5838 4.81 37.82 16895 363465 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6209 5.03 38.22 16903 363482 0 57805 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6286 0.00 0.01 SQL*Net message from client 6286 0.08 6.26 db file sequential read 16895 0.08 33.27 SQL*Net more data from client 144 0.00 0.00 SQL*Net more data to client 3885 0.00 0.29 Total clean time 38.22 - 33.27 = 4.95 ============================================================================= T-EX_1000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 119 0.03 0.02 0 0 0 0 Execute 177 0.20 0.35 6 17 0 117 Fetch 5823 5.04 39.71 16901 363420 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6119 5.28 40.09 16907 363437 0 57775 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6181 0.00 0.01 SQL*Net message from client 6181 0.07 6.25 db file sequential read 16902 0.10 34.88 SQL*Net more data from client 120 0.00 0.00 SQL*Net more data to client 3884 0.00 0.27 Total clean time 40.09 - 34.88 = 5.21 ============================================================================= T-EX_2000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 61 0.00 0.00 0 0 0 0 Execute 90 0.26 0.34 8 17 0 59 Fetch 5794 4.78 37.64 16867 363333 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5945 5.04 37.98 16875 363350 0 57717 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5978 0.00 0.01 SQL*Net message from client 5978 0.07 5.90 db file sequential read 16867 0.08 33.15 SQL*Net more data from client 144 0.00 0.00 SQL*Net more data to client 3885 0.00 0.26 Total clean time 37.98 - 33.15 = 4.83 ============================================================================= T-EX_4000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 7 0.00 0.00 0 0 0 0 Execute 9 0.23 0.32 8 17 0 5 Fetch 5767 4.39 38.69 16888 363252 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5783 4.62 39.01 16896 363269 0 57663 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5789 0.00 0.01 SQL*Net message from client 5789 0.28 5.62 db file sequential read 16888 0.10 34.36 SQL*Net more data from client 171 0.00 0.00 SQL*Net more data to client 3885 0.00 0.26 Total clean time 39.01 - 34.36 = 4.65 ============================================================================= T-EX_20000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 9 0.00 0.00 0 0 0 0 Execute 12 0.18 0.28 8 17 0 7 Fetch 5768 5.04 38.47 16831 363255 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5789 5.23 38.76 16839 363272 0 57665 Misses in library cache during parse: 0 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5796 0.00 0.01 SQL*Net message from client 5796 0.18 5.77 db file sequential read 16831 0.08 34.00 SQL*Net more data from client 170 0.00 0.00 SQL*Net more data to client 3885 0.00 0.28 Total clean time 38.76 - 34.00 = 4.76 ============================================================================= G-EX_10 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 5767 15.76 16.67 0 0 0 0 Execute 5768 0.95 0.81 0 0 0 0 Fetch 11531 5.68 39.96 16909 432540 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 23066 22.40 57.45 16909 432540 0 57658 Misses in library cache during parse: 5766 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 28833 0.00 0.06 SQL*Net message from client 28833 0.06 19.83 db file sequential read 16909 0.08 34.80 SQL*Net more data to client 3879 0.00 0.28 Total clean time 57.45 - 34.80 = 22.65 ============================================================================= G-EX_20 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 2884 9.42 9.14 0 0 0 0 Execute 2885 0.39 0.42 0 0 0 0 Fetch 8648 5.10 39.88 16845 426774 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14417 14.92 49.45 16845 426774 0 57658 Misses in library cache during parse: 2884 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 17301 0.00 0.04 SQL*Net message from client 17301 0.04 14.17 db file sequential read 16845 0.06 34.87 SQL*Net more data to client 3879 0.00 0.29 Total clean time 49.45 - 34.87 = 14.58 ============================================================================= G-EX_40 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1443 5.50 5.26 0 0 0 0 Execute 1444 0.20 0.20 0 0 0 0 Fetch 7207 5.76 37.93 16918 423892 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10094 11.46 43.40 16918 423892 0 57658 Misses in library cache during parse: 1441 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 11537 0.00 0.02 SQL*Net message from client 11537 0.05 10.70 db file sequential read 16918 0.10 33.12 SQL*Net more data to client 3879 0.00 0.31 latch free 1 0.00 0.00 Total clean time 43.40 - 33.12 = 10.28 ============================================================================= G-EX_60 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 962 4.01 4.14 0 0 0 0 Execute 963 0.18 0.14 0 0 0 0 Fetch 6726 4.59 38.64 16891 422930 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 8651 8.79 42.93 16891 422930 0 57658 Misses in library cache during parse: 961 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 9613 0.00 0.02 SQL*Net message from client 9613 0.06 9.88 db file sequential read 16891 0.11 33.97 SQL*Net more data to client 3879 0.00 0.26 Total clean time 42.93 - 33.97 = 8.96 ============================================================================= G-EX_100 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 578 3.23 4.11 0 0 0 0 Execute 579 0.12 0.09 0 0 0 0 Fetch 6342 5.03 39.40 16851 422162 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7499 8.39 43.60 16851 422162 0 57658 Misses in library cache during parse: 578 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 8077 0.00 0.01 SQL*Net message from client 8077 0.05 9.36 db file sequential read 16851 0.09 34.88 SQL*Net more data to client 3879 0.00 0.24 Total clean time 43.60 - 34.88 = 8.72 ============================================================================= G-EX_200 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 290 3.18 3.21 0 0 0 0 Execute 291 0.07 0.05 0 0 0 0 Fetch 6054 5.23 38.43 16840 421586 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6635 8.50 41.70 16840 421586 0 57658 Misses in library cache during parse: 288 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6925 0.00 0.01 SQL*Net message from client 6925 0.06 8.37 SQL*Net more data from client 288 0.00 0.00 db file sequential read 16840 0.05 33.94 SQL*Net more data to client 3879 0.00 0.25 Total clean time 41.70 - 33.94 = 7.76 ============================================================================= G-EX_400 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 146 3.84 3.98 0 0 0 0 Execute 147 0.04 0.04 0 0 0 0 Fetch 5910 5.01 37.89 16940 421298 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6203 8.90 41.91 16940 421298 0 57658 Misses in library cache during parse: 144 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6349 0.00 0.01 SQL*Net message from client 6349 0.07 7.39 SQL*Net more data from client 144 0.00 0.00 db file sequential read 16940 0.07 33.19 SQL*Net more data to client 3881 0.00 0.27 Total clean time 41.91 - 33.19 = 8.72 ============================================================================= G-EX_800 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 74 6.07 6.10 0 0 0 0 Execute 75 0.01 0.02 0 0 0 0 Fetch 5838 5.65 37.66 16916 421154 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5987 11.75 43.79 16916 421154 0 57658 Misses in library cache during parse: 72 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6061 0.00 0.01 SQL*Net message from client 6061 0.09 7.47 SQL*Net more data from client 72 0.00 0.00 db file sequential read 16916 0.10 32.90 SQL*Net more data to client 3885 0.00 0.28 Total clean time 43.79 - 32.90 = 10.89 ============================================================================= G-EX_1000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 59 7.12 7.18 0 0 0 0 Execute 60 0.03 0.02 0 0 0 0 Fetch 5823 4.85 37.44 16885 421124 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5942 12.01 44.65 16885 421124 0 57658 Misses in library cache during parse: 58 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 6001 0.00 0.01 SQL*Net message from client 6001 0.10 7.68 SQL*Net more data from client 58 0.00 0.00 db file sequential read 16885 0.04 32.87 SQL*Net more data to client 3884 0.00 0.26 Total clean time 44.65 - 32.87 = 11.78 ============================================================================= G-EX_2000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 30 13.06 13.16 0 0 0 0 Execute 31 0.01 0.02 0 0 0 0 Fetch 5794 5.00 39.39 16843 421066 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5855 18.07 52.58 16843 421066 0 57658 Misses in library cache during parse: 29 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5885 0.00 0.01 SQL*Net message from client 5885 0.19 9.02 SQL*Net more data from client 29 0.00 0.00 db file sequential read 16843 0.08 34.68 SQL*Net more data to client 3885 0.00 0.26 Total clean time 52.58 - 34.68 = 17.9 ============================================================================= G-EX_4000 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 16 25.95 26.10 0 0 0 0 Execute 17 0.03 0.02 0 0 0 0 Fetch 5780 5.45 39.35 16896 421038 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5813 31.43 65.48 16896 421038 0 57658 Misses in library cache during parse: 14 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 5829 0.00 0.01 SQL*Net message from client 5829 1.34 19.07 SQL*Net more data from client 15 0.00 0.00 db file sequential read 16896 0.09 34.58 SQL*Net more data to client 3885 0.00 0.26 Total clean time 65.48 - 34.58 = 30.90 ============================================================================= G-EX_80 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 722 3.51 3.60 0 0 0 0 Execute 723 0.03 0.11 0 0 0 0 Fetch 6486 5.43 38.85 16870 422450 0 57658 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7931 8.98 42.57 16870 422450 0 57658 Misses in library cache during parse: 720 Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 8653 0.00 0.01 SQL*Net message from client 8653 0.04 9.57 db file sequential read 16870 0.08 34.01 SQL*Net more data to client 3879 0.00 0.27 Total clean time 42.57 - 34.01 = 8.56 =============================================================================