SQL> l 1 select LOAD_TYPE,SQL_SCRIPT,LOAD,SAMPLE_SET_NO, 2 vd_execs_total, 3 vd_elapsed_s_TOTAL, 4 vd_cpu_systime_s_total, vd_cpu_sql_s_total, 5 os_cpu_s_total, 6 vd_elapsed_s_total/vd_execs_total avg_el_time, 7 sp_begin_id, sp_end_id, 8 (get_cpu_time_snap_id(sp_end_id)-get_cpu_time_snap_id(sp_begin_id))/1000000 sp_cpu_s 9 from op_final_results 10* order by 1,2,3,4 SQL> / LOAD_TYPE SQL_SCRIPT LOAD SAMPLE_SET_NO VD_EXECS_TOTAL VD_ELAPSED_S_TOTAL VD_CPU_SYSTIME_S_TOTAL VD_CPU_SQL_S_TOTAL OS_CPU_S_TOTAL AVG_EL_TIME SP_BEGIN_ID SP_END_ID SP_CPU_S ---------- ---------- ---------- ------------- -------------- ------------------ ---------------------- ------------------ -------------- ----------- ----------- ---------- ---------- cpu quick 2 1 200 80.526974 80.38078 80.00283 80.39 .40263487 367 368 80.00 cpu quick 2 2 200 79.698072 79.481917 79.48191 79.48 .39849036 369 370 79.48 cpu quick 2 3 200 80.052047 79.811866 79.81286 79.82 .400260235 371 372 79.81 cpu quick 2 4 200 79.618503 79.351937 79.35293 79.36 .398092515 373 374 79.35 cpu quick 2 5 200 79.567736 79.381932 79.38293 79.39 .39783868 375 376 79.38 cpu quick 2 6 200 79.765368 79.53291 79.53391 79.55 .39882684 377 378 79.53 cpu quick 2 7 200 80.459899 80.175812 80.17681 80.18 .402299495 379 380 80.18 cpu quick 2 8 200 79.799021 79.563904 79.5649 79.57 .398995105 381 382 79.56 cpu quick 2 9 200 79.584352 79.359936 79.36093 79.37 .39792176 383 384 79.36 cpu quick 2 10 200 79.455098 79.294945 79.29594 79.31 .39727549 385 386 79.30 cpu quick 2 11 200 79.210374 79.020988 79.02198 79.03 .39605187 387 388 79.02 cpu quick 2 12 200 80.5091 80.31379 80.31479 80.32 .4025455 389 390 80.31 cpu quick 2 13 200 79.532388 79.357936 79.35893 79.36 .39766194 391 392 79.36 cpu quick 2 14 200 78.905807 78.756027 78.75702 78.76 .394529035 393 394 78.76 cpu quick 2 15 200 80.699244 80.546756 80.54775 80.56 .40349622 395 396 80.55 cpu quick 2 16 200 79.609287 79.457921 79.45892 79.47 .398046435 397 398 79.46 cpu quick 2 17 200 79.742811 79.590901 79.5919 79.6 .398714055 399 400 79.59 cpu quick 2 18 200 79.037155 78.86901 78.87 78.87 .395185775 401 402 78.87 cpu quick 2 19 200 79.655242 79.477918 79.47891 79.49 .39827621 403 404 79.48 cpu quick 2 20 200 79.942154 79.789869 79.79086 79.78 .39971077 405 406 79.79 cpu quick 2 21 200 78.842831 78.680039 78.68103 78.69 .394214155 407 408 78.68 cpu quick 2 22 200 79.732631 79.580902 79.5819 79.59 .398663155 409 410 79.58 cpu quick 2 23 200 79.52261 79.295946 79.29694 79.3 .39761305 411 412 79.30 cpu quick 2 24 200 79.865633 79.641892 79.64289 79.64 .399328165 413 414 79.64 cpu quick 2 25 200 79.634116 79.45792 79.45892 79.46 .39817058 415 416 79.46 cpu quick 2 26 200 79.650778 79.415926 79.41492 79.42 .39825389 417 418 79.41 cpu quick 2 27 200 81.342635 81.04368 81.04468 81.05 .406713175 419 420 81.04 cpu quick 2 28 200 79.949714 79.720882 79.72188 79.73 .39974857 421 422 79.72 cpu quick 2 29 200 79.389468 79.190961 79.19196 79.2 .39694734 423 424 79.19 cpu quick 2 30 200 78.88749 78.731031 78.73203 78.74 .39443745 424 426 78.73 cpu quick 2 31 200 79.676006 79.52491 79.5259 79.53 .39838003 427 428 79.53 cpu quick 3 1 200 83.546726 82.517455 82.51845 82.51 .41773363 429 430 82.52 cpu quick 3 2 200 83.709649 82.842406 82.8434 82.85 .418548245 431 432 82.84 cpu quick 3 3 200 83.762497 83.369326 83.37132 83.37 .418812485 433 434 83.37 cpu quick 3 4 200 84.99505 84.410167 84.41116 84.41 .42497525 435 436 84.41 cpu quick 3 5 200 83.518113 82.947391 82.94839 82.96 .417590565 437 438 82.95 cpu quick 3 6 200 83.526334 82.642437 82.64343 82.65 .41763167 439 440 82.64 cpu quick 3 7 200 83.343489 82.847404 82.8484 82.84 .416717445 441 442 82.85 cpu quick 3 8 200 84.44817 84.26619 84.26719 84.27 .42224085 443 444 84.27 cpu quick 3 9 200 83.631442 83.156359 83.15735 83.17 .41815721 445 446 83.16 cpu quick 3 10 200 83.493985 83.110365 83.11136 83.12 .417469925 447 448 83.11 cpu quick 3 11 200 83.005365 82.535454 82.53645 82.54 .415026825 449 450 82.54 cpu quick 3 12 200 83.551404 83.240346 83.24134 83.25 .41775702 451 452 83.24 cpu quick 3 13 200 83.205078 82.94739 82.94839 82.96 .41602539 453 454 82.95 cpu quick 3 14 200 82.967991 82.438468 82.43946 82.44 .414839955 455 456 82.44 cpu quick 3 15 200 83.287402 82.94139 82.94239 82.93 .41643701 456 458 82.94 cpu quick 3 16 200 85.140548 84.217197 84.21819 84.23 .42570274 459 460 84.22 LOAD_TYPE SQL_SCRIPT LOAD SAMPLE_SET_NO VD_EXECS_TOTAL VD_ELAPSED_S_TOTAL VD_CPU_SYSTIME_S_TOTAL VD_CPU_SQL_S_TOTAL OS_CPU_S_TOTAL AVG_EL_TIME SP_BEGIN_ID SP_END_ID SP_CPU_S ---------- ---------- ---------- ------------- -------------- ------------------ ---------------------- ------------------ -------------- ----------- ----------- ---------- ---------- cpu quick 3 17 200 84.315472 82.120515 82.12151 82.11 .42157736 461 462 82.12 cpu quick 3 18 200 83.477736 83.095368 83.09736 83.1 .41738868 463 464 83.10 cpu quick 3 19 200 83.466315 82.675432 82.67643 82.69 .417331575 465 466 82.68 cpu quick 3 20 200 84.543887 83.763267 83.76426 83.78 .422719435 467 468 83.76 cpu quick 3 21 200 84.52087 83.626288 83.62828 83.63 .42260435 469 470 83.63 cpu quick 3 22 200 83.541795 82.898397 82.89839 82.89 .417708975 471 472 82.90 cpu quick 3 23 200 83.283092 83.097368 83.09836 83.1 .41641546 473 474 83.10 cpu quick 3 24 200 86.000922 85.486004 85.486 85.48 .43000461 475 476 85.49 cpu quick 3 25 200 84.505143 84.019228 84.02022 84.03 .422525715 477 478 84.02 cpu quick 3 26 200 83.382648 82.946391 82.94739 82.96 .41691324 479 480 82.95 cpu quick 3 27 200 83.51241 83.054373 83.05537 83.05 .41756205 481 482 83.06 cpu quick 3 28 200 84.370082 83.455313 83.45631 83.46 .42185041 483 484 83.46 cpu quick 3 29 200 84.077552 82.502457 82.50345 82.5 .42038776 485 486 82.50 cpu quick 3 30 200 84.630901 83.498306 83.5003 83.49 .423154505 487 488 83.50 cpu quick 3 31 200 83.498652 82.718424 82.71942 82.73 .41749326 489 490 82.72 cpu quick 4 1 200 96.242425 84.800109 84.8021 84.81 .481212125 491 492 84.80 cpu quick 4 2 200 94.287073 85.657978 85.65897 85.67 .471435365 493 494 85.66 cpu quick 4 3 200 99.000006 84.772113 84.77311 84.78 .49500003 495 496 84.77 cpu quick 4 4 200 94.034256 85.042071 85.04307 85.05 .47017128 497 498 85.04 cpu quick 4 5 200 92.787905 86.683822 86.68482 86.7 .463939525 499 500 86.68 cpu quick 4 6 200 97.535624 86.04192 86.04292 86.05 .48767812 501 502 86.04 cpu quick 4 7 200 95.282572 84.921091 84.92209 84.93 .47641286 503 504 84.92 cpu quick 4 8 200 93.526324 85.160053 85.16205 85.16 .46763162 505 506 85.16 cpu quick 4 9 200 88.86153 85.78296 85.78495 85.8 .44430765 507 508 85.78 cpu quick 4 10 200 95.591708 84.961085 84.96208 84.97 .47795854 509 510 84.96 cpu quick 4 11 200 98.590599 85.708971 85.71097 85.71 .492952995 511 512 85.71 cpu quick 4 12 200 98.841627 84.579143 84.58114 84.59 .494208135 513 514 84.58 cpu quick 4 13 200 102.299757 88.058614 88.05961 88.07 .511498785 515 516 88.06 cpu quick 4 14 200 95.171772 84.750115 84.75211 84.75 .47585886 517 518 84.75 cpu quick 4 15 200 98.166075 85.072066 85.07306 85.08 .490830375 519 520 85.07 cpu quick 4 16 200 98.328291 85.075066 85.07606 85.07 .491641455 521 522 85.08 cpu quick 4 17 200 94.699789 85.11106 85.11306 85.11 .473498945 523 524 85.11 cpu quick 4 18 200 94.743602 84.92309 84.92509 84.93 .47371801 525 526 84.93 cpu quick 4 19 200 95.699575 85.016076 85.01807 85.03 .478497875 527 528 85.02 cpu quick 4 20 200 97.779578 85.108061 85.10906 85.11 .48889789 529 530 85.11 cpu quick 4 21 200 94.059746 85.350025 85.35102 85.36 .47029873 531 532 85.35 cpu quick 4 22 200 92.971778 84.962084 84.96308 84.97 .46485889 533 534 84.96 cpu quick 4 23 200 98.359644 89.25343 89.25543 89.25 .49179822 535 536 89.26 cpu quick 4 24 200 95.568935 84.823105 84.8241 84.83 .477844675 537 538 84.82 cpu quick 4 25 200 96.911222 84.478157 84.48015 84.49 .48455611 539 540 84.48 cpu quick 4 26 200 97.057936 84.931089 84.93308 84.94 .48528968 541 542 84.93 cpu quick 4 27 200 94.02704 85.364023 85.36602 85.37 .4701352 543 544 85.37 cpu quick 4 28 200 97.346225 85.249041 85.25104 85.26 .486731125 545 546 85.25 cpu quick 4 29 200 95.805327 86.472853 86.47285 86.48 .479026635 547 548 86.47 cpu quick 4 30 200 97.526425 84.823104 84.8241 84.83 .487632125 549 550 84.82 cpu quick 4 31 200 99.388596 84.808107 84.8101 84.8 .49694298 551 552 84.81 cpu quick 5 1 200 124.255549 85.969931 85.97093 85.98 .621277745 553 554 85.97 LOAD_TYPE SQL_SCRIPT LOAD SAMPLE_SET_NO VD_EXECS_TOTAL VD_ELAPSED_S_TOTAL VD_CPU_SYSTIME_S_TOTAL VD_CPU_SQL_S_TOTAL OS_CPU_S_TOTAL AVG_EL_TIME SP_BEGIN_ID SP_END_ID SP_CPU_S ---------- ---------- ---------- ------------- -------------- ------------------ ---------------------- ------------------ -------------- ----------- ----------- ---------- ---------- cpu quick 5 2 200 129.043459 86.211893 86.21389 86.21 .645217295 555 556 86.21 cpu quick 5 3 200 134.569359 86.430861 86.43086 86.43 .672846795 557 558 86.43 cpu quick 5 4 200 137.486904 86.119907 86.1219 86.12 .68743452 559 560 86.12 cpu quick 5 5 200 135.259206 85.960932 85.96293 85.96 .67629603 561 562 85.96 cpu quick 5 6 200 132.920641 86.1669 86.16889 86.16 .664603205 563 564 86.17 cpu quick 5 7 200 134.78687 85.630983 85.63298 85.64 .67393435 565 566 85.63 cpu quick 5 8 200 130.957742 85.630981 85.63198 85.63 .65478871 567 568 85.63 cpu quick 5 9 200 132.95786 86.207895 86.20989 86.22 .6647893 569 570 86.21 cpu quick 5 10 200 134.805266 85.692973 85.69497 85.7 .67402633 571 572 85.69 cpu quick 5 11 200 134.976917 85.673976 85.67597 85.69 .674884585 573 574 85.68 cpu quick 5 12 200 134.438052 85.692973 85.69397 85.7 .67219026 575 576 85.69 cpu quick 5 13 200 137.543902 85.765963 85.76696 85.78 .68771951 577 578 85.77 cpu quick 5 14 200 138.450024 88.512543 88.51454 88.52 .69225012 579 580 88.51 cpu quick 5 15 200 133.659038 85.721968 85.72396 85.72 .66829519 581 582 85.72 cpu quick 5 16 200 132.239931 86.250889 86.25288 86.26 .661199655 583 584 86.25 cpu quick 5 17 200 134.801458 86.053918 86.05591 86.06 .67400729 585 586 86.06 cpu quick 5 18 200 137.782712 85.705972 85.70797 85.72 .68891356 587 588 85.71 cpu quick 5 19 200 137.08326 85.45201 85.45401 85.46 .6854163 589 590 85.45 cpu quick 5 20 200 130.783891 86.085913 86.08791 86.09 .653919455 591 592 86.09 cpu quick 5 21 200 132.91323 85.866947 85.86894 85.87 .66456615 593 594 85.87 cpu quick 5 22 200 134.612577 85.604987 85.60698 85.61 .673062885 595 596 85.61 cpu quick 5 23 200 134.405678 85.177051 85.17905 85.17 .67202839 597 598 85.18 cpu quick 5 24 200 133.424234 85.678975 85.68097 85.68 .66712117 599 600 85.68 cpu quick 5 25 200 130.947736 86.144904 86.1469 86.14 .65473868 601 602 86.15 cpu quick 5 26 200 139.744586 88.650524 88.65252 88.65 .69872293 603 604 88.65 cpu quick 5 27 200 131.174499 85.958932 85.96093 85.97 .655872495 605 606 85.96 cpu quick 5 28 200 134.382355 86.281884 86.28188 86.29 .671911775 607 608 86.28 cpu quick 5 29 200 127.98592 86.376869 86.37886 86.39 .6399296 609 610 86.38 cpu quick 5 30 200 134.476198 85.812953 85.81495 85.81 .67238099 611 612 85.81 cpu quick 5 31 200 130.711107 85.949934 85.95193 85.96 .653555535 613 614 85.95 cpu quick 6 1 200 188.201056 86.56384 86.56583 86.56 .94100528 615 616 86.57 cpu quick 6 2 200 190.386085 86.516848 86.51784 86.52 .951930425 617 618 86.52 cpu quick 6 3 200 188.906076 87.448706 87.4507 87.45 .94453038 619 620 87.45 cpu quick 6 4 200 188.932849 86.542843 86.54484 86.54 .944664245 621 622 86.54 cpu quick 6 5 200 177.709406 86.259886 86.26288 86.26 .88854703 623 624 86.26 cpu quick 6 6 200 184.006057 86.588837 86.58983 86.6 .920030285 625 626 86.59 cpu quick 6 7 200 188.829468 86.454856 86.45685 86.46 .94414734 627 628 86.46 cpu quick 6 8 200 180.435953 86.316877 86.31887 86.32 .902179765 629 630 86.32 cpu quick 6 9 200 176.244068 86.149903 86.1519 86.16 .88122034 631 632 86.15 cpu quick 6 10 200 180.460978 86.946782 86.94878 86.94 .90230489 633 634 86.95 cpu quick 6 11 200 180.212717 86.427861 86.42986 86.43 .901063585 635 636 86.43 cpu quick 6 12 200 180.101715 86.802805 86.8048 86.81 .900508575 637 638 86.80 cpu quick 6 13 200 184.664478 86.072914 86.07491 86.07 .92332239 639 640 86.07 cpu quick 6 14 200 176.96 85.90694 85.90893 85.9 .8848 641 642 85.91 cpu quick 6 15 200 195.429044 86.565841 86.56784 86.57 .97714522 643 644 86.57 cpu quick 6 16 200 191.211976 86.667824 86.66982 86.66 .95605988 645 646 86.67 cpu quick 6 17 200 170.686059 85.716969 85.71796 85.73 .853430295 647 648 85.72 LOAD_TYPE SQL_SCRIPT LOAD SAMPLE_SET_NO VD_EXECS_TOTAL VD_ELAPSED_S_TOTAL VD_CPU_SYSTIME_S_TOTAL VD_CPU_SQL_S_TOTAL OS_CPU_S_TOTAL AVG_EL_TIME SP_BEGIN_ID SP_END_ID SP_CPU_S ---------- ---------- ---------- ------------- -------------- ------------------ ---------------------- ------------------ -------------- ----------- ----------- ---------- ---------- cpu quick 6 18 200 183.641606 86.947783 86.94978 86.96 .91820803 649 650 86.95 cpu quick 6 19 200 194.462233 86.904789 86.90678 86.92 .972311165 651 652 86.91 cpu quick 6 20 200 189.628475 86.714818 86.71681 86.72 .948142375 653 654 86.72 cpu quick 6 21 200 187.366829 86.289882 86.29188 86.3 .936834145 655 656 86.29 cpu quick 6 22 200 178.955043 86.925785 86.92778 86.93 .894775215 657 658 86.93 cpu quick 6 23 200 184.158519 86.710818 86.71281 86.72 .920792595 659 660 86.71 cpu quick 6 24 200 189.976785 86.553841 86.55484 86.56 .949883925 661 662 86.55 cpu quick 6 25 200 180.223786 86.350872 86.35287 86.35 .90111893 663 664 86.35 cpu quick 6 26 200 176.018467 86.123907 86.1259 86.12 .880092335 665 666 86.13 cpu quick 6 27 200 184.524992 86.076913 86.07891 86.08 .92262496 667 668 86.08 cpu quick 6 28 200 182.337973 86.456857 86.45885 86.47 .911689865 669 670 86.46 cpu quick 6 29 200 188.059077 86.439859 86.44185 86.45 .940295385 671 672 86.44 cpu quick 6 30 200 191.138072 86.446858 86.44885 86.45 .95569036 673 674 86.45 cpu quick 6 31 200 185.491611 86.11191 86.1129 86.11 .927458055 675 676 86.11 155 rows selected. SQL>