ADDM Report for Task 'ADDM:2476075353_1_1364' --------------------------------------------- Analysis Period --------------- AWR snapshot range from 1363 to 1364. Time period starts at 07-JAN-20 05.20.49 AM Time period ends at 07-JAN-20 07.00.18 AM Analysis Target --------------- Database 'ZABBIXDB' with DB ID 2476075353. Database version 12.2.0.1.0. ADDM performed an analysis of instance zabbixdb1, numbered 1 and hosted at gmizdba037. Activity During the Analysis Period ----------------------------------- Total database time was 14744 seconds. The average number of active sessions was 2.47. Summary of Findings ------------------- Description Active Sessions Recommendations Percent of Activity ------------------ ------------------- --------------- 1 Top SQL Statements .41 | 16.42 5 2 Hard Parse .05 | 2.1 0 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Findings and Recommendations ---------------------------- Finding 1: Top SQL Statements Impact is .67 active sessions, 16.42% of total activity. -------------------------------------------------------- SQL statements consuming significant database time were found. These statements offer a good opportunity for performance improvement. Recommendation 1: SQL Tuning Estimated benefit is .12 active sessions, 4.85% of total activity. ------------------------------------------------------------------ Action Run SQL Tuning Advisor on the SELECT statement with SQL_ID "agzusq81651uu". Related Object SQL statement with SQL_ID agzusq81651uu. select t.item_preprocid,t.itemid,t.step,t.type,t.params,t.error_handl er,t.error_handler_params from item_preproc t where (t.itemid between 802321 and 802340 or t.itemid between 802436 and 802479 or t.itemid between 803056 and 803077 or t.itemid between 803184 and 803242 or t.itemid between 803250 and 803256 or t.itemid between 803259 and 803264 or t.itemid between 803266 and 803381 or t.itemid between 804023 and 804088 or t.itemid between 804272 and 804390 or t.itemid between 804398 and 804405 or t.itemid between 804505 and 804587 or t.itemid between 805082 and 805086 or t.itemid between 805209 and 805264 or t.itemid between 805267 and 805279 or t.itemid between 805289 and 805376 or t.itemid between 805383 and 805426 or t.itemid between 806427 and 806437 or t.itemid between 806445 and 806536 or t.itemid between 806623 and 806715 or t.itemid between 806986 and 807073 or t.itemid between 808186 and 808301 or t.itemid between 808437 and 808442 or t.itemid between 808535 and 808611 or t.itemid between 808975 and 809073 or t.itemid between 809395 and 809465 or t.itemid between 809563 and 809573 or t.itemid between 809575 and 809590 or t.itemid between 809600 and 809676 or t.itemid between 810251 and 810255 or t.itemid between 810365 and 810441 or t.itemid between 810472 and 810477 or t.itemid between 810485 and 810490 or t.itemid between 810498 and 810514 or t.itemid between 810517 and 810593 or t.itemid between 810916 and 810981 or t.itemid between 811076 and 811087 or t.itemid between 811091 and 811102 or t.itemid between 811137 and 811250 or t.itemid between 811306 and 811311 or t.itemid between 811446 and 811451 or t.itemid between 811455 and 811466 or t.itemid between 811629 and 811760 or t.itemid between 812081 and 812086 or t.itemid between 812090 and 812101 or t.itemid between 812209 and 812285 or t.itemid between 812667 and 812673 or t.itemid between 812677 and 812688 or t.itemid between 813003 and 813008 or t.itemid between 813012 and 813023 or t.itemid between 813488 and 813493 or t.itemid between 813497 and 813508 or t.itemid between 813776 and 813797 or t.itemid between 813875 and 813880 or t.itemid between 813884 and 813895 or t.itemid between 814316 and 814321 or t.itemid between 814325 and 814336 or t.itemid between 814492 and 814499 or t.itemid between 814754 and 814761 or t.itemid between 814765 and 814776 or t.itemid between 814813 and 814818 or t.itemid between 815056 and 815073 or t.itemid between 815133 and 815215 or t.itemid between 815219 and 815230 or t.itemid between 815584 and 815589 or t.itemid between 815593 and 815604 or t.itemid between 815931 and 815936 or t.itemid between 815940 and 815951 or t.itemid between 815985 and 816094 or t.itemid between 816506 and 816511 or t.itemid between 816515 and 816526 or t.itemid between 816758 and 816765 or t.itemid between 816769 and 816780 or t.itemid between 817111 and 817187 or t.itemid between 817190 and 817195 or t.itemid between 817251 and 817262 or t.itemid between 817266 and 817277 or t.itemid between 817316 and 817392 or t.itemid between 817678 and 817684 or t.itemid between 817688 and 817699 or t.itemid between 817818 and 817905 or t.itemid between 817970 and 818041 or t.itemid between 818180 and 818185 or t.itemid between 818189 and 818200 or t.itemid between 818452 and 818457 or t.itemid between 818461 and 818472 or t.itemid between 819207 and 819212 or t.itemid between 819216 and 819227 or t.itemid between 819391 and 819398 or t.itemid between 819405 and 819410 or t.itemid between 819602 and 819607 or t.itemid between 819611 and 819622 or t.itemid between 819910 and 820008 or t.itemid between 820196 and 820201 or t.itemid between 820205 and 820216 or t.itemid between 820269 and 820290 or t.itemid between 820421 and 820432 or t.itemid between 820510 and 820515 or t.itemid between 820593 and 820598 or t.itemid between 820602 and 820613 or t.itemid between 820889 and 820901 or t.itemid between 821014 and 821068 or t.itemid between 821279 and 821284 or t.itemid between 821288 and 821299 or t.itemid between 821587 and 821592 or t.itemid between 821596 and 821607 or t.itemid between 821829 and 821836 or t.itemid between 821892 and 821899 or t.itemid between 822153 and 822162 or t.itemid between 822166 and 822177 or t.itemid between 822264 and 822318 or t.itemid between 822589 and 822594 or t.itemid between 822598 and 822609 or t.itemid between 822875 and 822880 or t.itemid between 822884 and 822895 or t.itemid between 823393 and 823398 or t.itemid between 823402 and 823413 or t.itemid between 823721 and 823726 or t.itemid between 823730 and 823741 or t.itemid between 823839 and 823845 or t.itemid between 823998 and 824003 or t.itemid between 824007 and 824018 or t.itemid between 824334 and 824340 or t.itemid between 824344 and 824355 or t.itemid between 824696 and 824701 or t.itemid between 824705 and 824716 or t.itemid between 825168 and 825173 or t.itemid between 825177 and 825188 or t.itemid between 825463 and 825572 or t.itemid between 825663 and 825668 or t.itemid between 825672 and 825683 or t.itemid between 826101 and 826132 or t.itemid between 826136 and 826147 or t.itemid between 826182 and 826187 or t.itemid between 826316 and 826392 or t.itemid between 826516 and 826521 or t.itemid between 826525 and 826536 or t.itemid between 826993 and 827002 or t.itemid between 827006 and 827017 or t.itemid between 827214 and 827323 or t.itemid between 827391 and 827402 or t.itemid between 827405 and 827414 or t.itemid between 827469 and 827521 or t.itemid between 827525 and 827536 or t.itemid between 827573 and 827578 or t.itemid between 827778 and 827783 or t.itemid between 827787 and 827798 or t.itemid between 827853 and 827918 or t.itemid between 828220 and 828247 or t.itemid between 828251 and 828262 or t.itemid between 828720 and 828725 or t.itemid between 828729 and 828740 or t.itemid between 829637 and 829642 or t.itemid between 829646 and 829657 or t.itemid between 830072 and 830077 or t.itemid between 830081 and 830092 or t.itemid between 830398 and 830404 or t.itemid between 830408 and 830419 or t.itemid between 830768 and 830774 or t.itemid between 830778 and 830789 or t.itemid between 831186 and 831191 or t.itemid between 831195 and 831206 or t.itemid between 831626 and 831631 or t.itemid between 831635 and 831646 or t.itemid between 831738 and 831751 or t.itemid between 831811 and 831819 or t.itemid between 831969 and 831984 or t.itemid between 831988 and 831999 or t.itemid between 832034 and 832044 or t.itemid between 832102 and 832207 or t.itemid between 832369 and 832423 or t.itemid between 832426 and 832433 or t.itemid between 832437 and 832448 or t.itemid between 832481 and 832485 or t.itemid between 832751 and 832757 or t.itemid between 832761 and 832772 or t.itemid between 833099 and 833104 or t.itemid between 833108 and 833119 or t.itemid between 834033 and 834038 or t.itemid between 834042 and 834053 or t.itemid between 834289 and 834296 or t.itemid between 834301 and 834313 or t.itemid between 834317 and 834328 or t.itemid between 834820 and 834915 or t.itemid between 834971 and 834984 or t.itemid between 834988 and 834999 or t.itemid between 835254 and 835319 or t.itemid between 835666 and 835742 or t.itemid between 835757 and 835762 or t.itemid between 835766 and 835777 or t.itemid between 836124 and 836130 or t.itemid between 836134 and 836145 or t.itemid between 836684 and 836689 or t.itemid between 836693 and 836704 or t.itemid between 836985 and 837078 or t.itemid between 837082 and 837093 or t.itemid between 837451 and 837457 or t.itemid between 837461 and 837472 or t.itemid between 837903 and 837908 or t.itemid between 837912 and 837923 or t.itemid between 838141 and 838163 or t.itemid between 838167 and 838178 or t.itemid between 838347 and 838413 or t.itemid between 838471 and 838482 or t.itemid between 838538 and 838547 or t.itemid between 838551 and 838562 or t.itemid between 838681 and 838768 or t.itemid between 838945 and 839017 or t.itemid between 839021 and 839032 or t.itemid between 839216 and 839221 or t.itemid between 839225 and 839236 or t.itemid between 839420 and 839425 or t.itemid between 839429 and 839440 or t.itemid between 839628 and 839633 or t.itemid between 839637 and 839648 or t.itemid between 839832 and 839837 or t.itemid between 839841 and 839852 or t.itemid between 840036 and 840041 or t.itemid between 840045 and 840056 or t.itemid between 840240 and 840245 or t.itemid between 840249 and 840260 or t.itemid between 840599 and 840604 or t.itemid between 840608 and 840619 or t.itemid between 840803 and 840808 or t.itemid between 840812 and 840823 or t.itemid between 841323 and 841328 or t.itemid between 841332 and 841343 or t.itemid between 841383 and 841387 or t.itemid between 841440 and 841510 or t.itemid between 841571 and 841575 or t.itemid between 841628 and 841744 or t.itemid between 841748 and 841759 or t.itemid between 841861 and 841872 or t.itemid between 841942 and 841947 or t.itemid between 842015 and 842023 or t.itemid between 842027 and 842038 or t.itemid between 842144 and 842187 or t.itemid between 842489 and 842494 or t.itemid between 842498 and 842509 or t.itemid between 843134 and 843140 or t.itemid between 843144 and 843155 or t.itemid between 844777 and 844782 or t.itemid between 844786 and 844797 or t.itemid between 845166 and 845171 or t.itemid between 845175 and 845186 or t.itemid between 845671 and 845676 or t.itemid between 845680 and 845691 or t.itemid between 846107 and 846112 or t.itemid between 846116 and 846127 or t.itemid between 846510 and 846515 or t.itemid between 846519 and 846530 or t.itemid between 846812 and 846817 or t.itemid between 846821 and 846832 or t.itemid between 847043 and 847163 or t.itemid between 847297 and 847307 or t.itemid between 847311 and 847322 or t.itemid between 847365 and 847377 or t.itemid between 847380 and 847389 or t.itemid between 847551 and 847663 or t.itemid between 847920 and 848029 or t.itemid between 848032 and 848039 or t.itemid between 848043 and 848054 or t.itemid between 848238 and 848243 or t.itemid between 848300 and 848312 or t.itemid between 848316 and 848327 or t.itemid between 848736 and 848812 or t.itemid between 848870 and 848877 or t.itemid between 848881 and 848892 or t.itemid between 849356 and 849361 or t.itemid between 849365 and 849376 or t.itemid between 849659 and 849665 or t.itemid between 849669 and 849680 or t.itemid between 850000 and 850013 or t.itemid between 850077 and 850098 or t.itemid between 850102 and 850113 or t.itemid between 850279 and 850289 or t.itemid between 850365 and 850474 or t.itemid between 850478 and 850489 or t.itemid between 850597 and 850673 or t.itemid between 850952 and 850957 or t.itemid between 850961 and 850972 or t.itemid between 851502 and 851507 or t.itemid between 851511 and 851522 or t.itemid between 851663 and 851772 or t.itemid between 852039 and 852044 or t.itemid between 852048 and 852059 or t.itemid between 852253 and 852262 or t.itemid between 852328 and 852335 or t.itemid between 852794 and 853200 or t.itemid between 853206 and 853211 or t.itemid between 853215 and 853226 or t.itemid between 853267 and 853278 or t.itemid between 853338 and 853392 or t.itemid between 853507 and 853516 or t.itemid between 853520 and 853531 or t.itemid between 853566 and 853571 or t.itemid between 853678 and 853732 or t.itemid between 853855 and 853860 or t.itemid between 853864 and 853875 or t.itemid between 854249 and 854254 or t.itemid between 854258 and 854269 or t.itemid between 854782 and 854787 or t.itemid between 854791 and 854802 or t.itemid between 855557 and 855562 or t.itemid between 855566 and 855577 or t.itemid between 855850 and 856036 or t.itemid between 856229 and 856235 or t.itemid between 856239 and 856250 or t.itemid between 856805 and 856814 or t.itemid between 856818 and 856829 or t.itemid between 857222 and 857331 or t.itemid between 857448 and 857453 or t.itemid between 857457 and 857468 or t.itemid between 857654 and 857659 or t.itemid between 857663 and 857674 or t.itemid between 857824 and 857834 or t.itemid between 858255 and 858260 or t.itemid between 858497 and 858607 or t.itemid between 858613 and 858626 or t.itemid between 858630 and 858641 or t.itemid between 858673 and 858740 or t.itemid between 859298 and 859303 or t.itemid between 859307 and 859318 or t.itemid between 860032 and 860037 or t.itemid between 860041 and 860052 or t.itemid between 860542 and 860547 or t.itemid between 860551 and 860562 or t.itemid between 861183 and 861188 or t.itemid between 861192 and 861203 or t.itemid between 861794 and 861799 or t.itemid between 861803 and 861814 or t.itemid between 862276 and 862363 or t.itemid between 862423 and 862428 or t.itemid between 862432 and 862443 or t.itemid between 862905 and 862910 or t.itemid between 862914 and 862925 or t.itemid between 863084 and 863089 or t.itemid between 863144 and 863150 or t.itemid between 863393 and 863491 or t.itemid between 863494 and 863501 or t.itemid between 863505 and 863516 or t.itemid between 864419 and 864424 or t.itemid between 864428 and 864439 or t.itemid between 865119 and 865123 or t.itemid between 865187 and 865241 or t.itemid between 865299 and 865305 or t.itemid between 865309 and 865320 or t.itemid between 865862 and 865868 or t.itemid between 865872 and 865883 or t.itemid between 866449 and 866454 or t.itemid between 866458 and 866469 or t.itemid between 866704 and 866813 or t.itemid between 867549 and 867962 or t.itemid between 867966 and 867977 or t.itemid between 868977 and 868983 or t.itemid between 868987 and 868998 or t.itemid between 869793 and 869798 or t.itemid between 869802 and 869813 or t.itemid between 870315 and 870320 or t.itemid between 870324 and 870335 or t.itemid between 870557 and 870655 or t.itemid between 870665 and 870747 or t.itemid between 871496 and 871526 or t.itemid in (802343,802344,803083,803084,803085,803086,803089,803090,803091,80309 2,803094,803095,803244,803245,803246,803247,803384,803385,804002,8040 03,804004,804005,804007,804008,804009,804010,804015,804021,804092,804 093,804175,804176,804177,804178,804180,804181,804182,804183,804392,80 4393,804394,804395,804408,804409,804500,804501,804502,804503,805062,8 05063,805064,805065,805067,805068,805069,805070,805073,805074,805093, 805094,805379,805380,806416,806417,806418,806419,806421,806422,806423 ,806424,806439,806440,806441,806442,806614,806615,806616,806617,80671 8,806719,806938,806939,806940,806941,806957,806958,806973,806974,8069 75,806977,807076,807077,808111,808112,808113,808114,808425,808426,808 427,808428,808751,808752,808753,808754,808780,808781,808783,808784,80 8786,808787,809227,809228,809229,809230,809232,809233,809235,809236,8 09250,809468,809469,809552,809553,809554,809555,809557,809558,809559, 809560,809593,809594,809595,810246,810247,810248,810249,810265,810492 ,810596,810597,810847,810848,810849,810850,810860,810861,810862,81086 3,810869,810870,810999,811000,811071,811072,811073,811074,811825,8118 26,811827,811828,811831,811832,811886,811887,811888,811948,812343,812 344,814940,815712,815713,815714,815715,815717,815718,815719,815720,81 5773,815928,816699,816700,816701,816702,816813,816814,816815,816872,8 17453,817454,817455,817456,817511,817512,817513,817514,817567,817908, 817909,817965,817966,817967,817968,818101,818102,819400,819401,819463 ,819852,819853,819854,820449,820450,820451,820452,821072,821073,82377 4,823775,823776,823777,823833,823834,823835,823836,823907,823908,8252 23,825224,825225,825226,825228,825229,825230,825231,825284,825285,825 646,825647,826395,826396,826933,826934,826935,826936,826938,826939,82 7050,827326,827327,827640,827641,827642,827643,827650,827776,827984,8 27985,831754,831755,831756,831757,832261,832262,832541,832542,832547, 832548,832551,832552,832608,834298,834299,834678,834679,834680,835250 ,835251,835252,835568,835569,835570,835571,835574,835575,835576,83557 7,835659,835745,835746,836859,836860,836861,836862,836864,836865,8368 66,836867,836920,836921,838080,838081,838082,838083,838086,838087,838 210,838771,838772,838830,838831,838832,838833,838835,838836,838890,83 8891,838892,841378,841379,841380,841381,841568,841569,841796,841797,8 41881,841882,841883,841884,842192,842193,846581,846582,846583,846584, 846640,846641,846642,846643,846703,846756,847292,847293,847294,847295 ,848418,848419,848420,850154,850155,850212,850213,850217,850838,85083 9,853450,853451,853735,853736,856746,856747,856748,856749,856861,8568 62,857389,857390,858262,858263,858276,858277,858284,858285,858286,858 287,858610,858611,858743,858744,861908,861909,861910,861911,861922,86 1923,861928,861929,861989,863142,863204,863205,864546,864547,864548,8 64549,864560,864561,864574,864575,864628,864629,865244,865245,866364, 866365,866366,866367,866502,866503,866520,866521,866535,866536,870421 ,870422,870423,870424,870426,870427,870442,870443,870451,870480,87066 0,870661,870662,870663)) Rationale The SQL spent 100% of its database time on CPU, I/O and Cluster waits. This part of database time may be improved by the SQL Tuning Advisor. Rationale Database time for this SQL was divided as follows: 100% for SQL execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java execution. Rationale At least one execution of the statement ran in parallel. Recommendation 2: SQL Tuning Estimated benefit is .07 active sessions, 2.91% of total activity. ------------------------------------------------------------------ Action Run SQL Tuning Advisor on the SELECT statement with SQL_ID "34yyhyswhktnr". Related Object SQL statement with SQL_ID 34yyhyswhktnr. select t.item_preprocid,t.itemid,t.step,t.type,t.params,t.error_handl er,t.error_handler_params from item_preproc t where (t.itemid between 344840 and 344845 or t.itemid between 345029 and 345034 or t.itemid between 345038 and 345049 or t.itemid between 345182 and 345188 or t.itemid between 345192 and 345203 or t.itemid between 345390 and 345395 or t.itemid between 345399 and 345410 or t.itemid between 345735 and 345855 or t.itemid between 346163 and 346168 or t.itemid between 346172 and 346183 or t.itemid between 346369 and 346374 or t.itemid between 346378 and 346389 or t.itemid between 346575 and 346580 or t.itemid between 346584 and 346595 or t.itemid between 346781 and 346786 or t.itemid between 346790 and 346801 or t.itemid between 346985 and 346990 or t.itemid between 346994 and 347005 or t.itemid between 347193 and 347199 or t.itemid between 347203 and 347214 or t.itemid between 347427 and 347432 or t.itemid between 347436 and 347447 or t.itemid between 347637 and 347643 or t.itemid between 347647 and 347658 or t.itemid between 347843 and 347848 or t.itemid between 347852 and 347863 or t.itemid between 348280 and 348285 or t.itemid between 348289 and 348300 or t.itemid between 348484 and 348489 or t.itemid between 348493 and 348504 or t.itemid between 348688 and 348693 or t.itemid between 348697 and 348708 or t.itemid between 348892 and 348897 or t.itemid between 348901 and 348912 or t.itemid between 349096 and 349101 or t.itemid between 349105 and 349116 or t.itemid between 349300 and 349305 or t.itemid between 349309 and 349320 or t.itemid between 349504 and 349509 or t.itemid between 349513 and 349524 or t.itemid between 349708 and 349713 or t.itemid between 349717 and 349728 or t.itemid between 349912 and 349917 or t.itemid between 349921 and 349932 or t.itemid between 350116 and 350121 or t.itemid between 350125 and 350136 or t.itemid between 350320 and 350325 or t.itemid between 350329 and 350340 or t.itemid between 350526 and 350531 or t.itemid between 350535 and 350546 or t.itemid between 350732 and 350737 or t.itemid between 350741 and 350752 or t.itemid between 350938 and 350943 or t.itemid between 350947 and 350958 or t.itemid between 351142 and 351147 or t.itemid between 351151 and 351162 or t.itemid between 351346 and 351351 or t.itemid between 351355 and 351366 or t.itemid between 352210 and 352215 or t.itemid between 352219 and 352230 or t.itemid between 352414 and 352419 or t.itemid between 352423 and 352434 or t.itemid between 352618 and 352623 or t.itemid between 352627 and 352638 or t.itemid between 352822 and 352827 or t.itemid between 352831 and 352842 or t.itemid between 353026 and 353031 or t.itemid between 353035 and 353046 or t.itemid between 353274 and 353279 or t.itemid between 353283 and 353294 or t.itemid between 353478 and 353483 or t.itemid between 353487 and 353498 or t.itemid between 353682 and 353688 or t.itemid between 353692 and 353703 or t.itemid between 353890 and 353895 or t.itemid between 353899 and 353910 or t.itemid between 354161 and 354248 or t.itemid between 354876 and 354952 or t.itemid between 355442 and 355523 or t.itemid between 355605 and 355934 or t.itemid between 356434 and 356438 or t.itemid between 356446 and 356569 or t.itemid between 356723 and 356728 or t.itemid between 356732 and 356743 or t.itemid between 356929 and 356934 or t.itemid between 356938 and 356949 or t.itemid between 357133 and 357138 or t.itemid between 357142 and 357153 or t.itemid between 357341 and 357346 or t.itemid between 357350 and 357361 or t.itemid between 357547 and 357552 or t.itemid between 357556 and 357567 or t.itemid between 357751 and 357756 or t.itemid between 357760 and 357771 or t.itemid between 357965 and 357970 or t.itemid between 357974 and 357985 or t.itemid between 358311 and 358316 or t.itemid between 358320 and 358331 or t.itemid between 358515 and 358520 or t.itemid between 358524 and 358535 or t.itemid between 358719 and 358724 or t.itemid between 358728 and 358739 or t.itemid between 358923 and 358928 or t.itemid between 358932 and 358943 or t.itemid between 359151 and 359156 or t.itemid between 359160 and 359171 or t.itemid between 359359 and 359364 or t.itemid between 359368 and 359379 or t.itemid between 359705 and 359710 or t.itemid between 359714 and 359725 or t.itemid between 359911 and 359916 or t.itemid between 359920 and 359931 or t.itemid between 360074 and 360085 or t.itemid between 360140 and 360147 or t.itemid between 360151 and 360162 or t.itemid between 360481 and 360486 or t.itemid between 360490 and 360501 or t.itemid between 360685 and 360690 or t.itemid between 360694 and 360705 or t.itemid between 360801 and 360814 or t.itemid between 360917 and 360922 or t.itemid between 360926 and 360937 or t.itemid between 361145 and 361150 or t.itemid between 361154 and 361165 or t.itemid between 361505 and 361510 or t.itemid between 361514 and 361525 or t.itemid between 361709 and 361714 or t.itemid between 361718 and 361729 or t.itemid between 361760 and 361803 or t.itemid between 361957 and 361962 or t.itemid between 361966 and 361977 or t.itemid between 362161 and 362167 or t.itemid between 362171 and 362182 or t.itemid between 362391 and 362396 or t.itemid between 362400 and 362411 or t.itemid between 362597 and 362602 or t.itemid between 362606 and 362617 or t.itemid between 362801 and 362806 or t.itemid between 362810 and 362821 or t.itemid between 363005 and 363010 or t.itemid between 363014 and 363025 or t.itemid between 363240 and 363245 or t.itemid between 363249 and 363260 or t.itemid between 363670 and 363675 or t.itemid between 363679 and 363690 or t.itemid between 363874 and 363879 or t.itemid between 363883 and 363894 or t.itemid between 364078 and 364083 or t.itemid between 364087 and 364098 or t.itemid between 364282 and 364287 or t.itemid between 364291 and 364302 or t.itemid between 364505 and 364510 or t.itemid between 364514 and 364525 or t.itemid between 364644 and 364731 or t.itemid between 364885 and 364890 or t.itemid between 364894 and 364905 or t.itemid between 365089 and 365094 or t.itemid between 365098 and 365109 or t.itemid between 365293 and 365298 or t.itemid between 365302 and 365313 or t.itemid between 365539 and 365544 or t.itemid between 365548 and 365559 or t.itemid between 365937 and 365942 or t.itemid between 365946 and 365957 or t.itemid between 366141 and 366146 or t.itemid between 366150 and 366161 or t.itemid between 366345 and 366350 or t.itemid between 366354 and 366365 or t.itemid between 366579 and 366584 or t.itemid between 366588 and 366599 or t.itemid between 366909 and 366914 or t.itemid between 366918 and 366929 or t.itemid between 367113 and 367118 or t.itemid between 367122 and 367133 or t.itemid between 367319 and 367324 or t.itemid between 367328 and 367339 or t.itemid between 367527 and 367532 or t.itemid between 367536 and 367547 or t.itemid between 367737 and 367742 or t.itemid between 367746 and 367757 or t.itemid between 368190 and 368195 or t.itemid between 368199 and 368210 or t.itemid between 368394 and 368399 or t.itemid between 368403 and 368414 or t.itemid between 368598 and 368603 or t.itemid between 368607 and 368618 or t.itemid between 368802 and 368807 or t.itemid between 368811 and 368822 or t.itemid between 369010 and 369016 or t.itemid between 369020 and 369031 or t.itemid between 369222 and 369227 or t.itemid between 369231 and 369242 or t.itemid between 369426 and 369431 or t.itemid between 369435 and 369446 or t.itemid between 369630 and 369636 or t.itemid between 369640 and 369651 or t.itemid between 369854 and 369859 or t.itemid between 369863 and 369874 or t.itemid between 370258 and 370263 or t.itemid between 370267 and 370278 or t.itemid between 370464 and 370469 or t.itemid between 370473 and 370484 or t.itemid between 370670 and 370676 or t.itemid between 370680 and 370691 or t.itemid between 370953 and 370958 or t.itemid between 370962 and 370973 or t.itemid between 371327 and 371332 or t.itemid between 371336 and 371347 or t.itemid between 371531 and 371536 or t.itemid between 371540 and 371551 or t.itemid between 371735 and 371740 or t.itemid between 371744 and 371755 or t.itemid between 371941 and 371946 or t.itemid between 371950 and 371961 or t.itemid between 372167 and 372173 or t.itemid between 372177 and 372188 or t.itemid between 372372 and 372377 or t.itemid between 372381 and 372392 or t.itemid between 372818 and 372823 or t.itemid between 372827 and 372838 or t.itemid between 373022 and 373027 or t.itemid between 373031 and 373042 or t.itemid between 373226 and 373231 or t.itemid between 373235 and 373246 or t.itemid between 373445 and 373450 or t.itemid between 373454 and 373465 or t.itemid between 373739 and 373744 or t.itemid between 373748 and 373759 or t.itemid between 373943 and 373948 or t.itemid between 373952 and 373963 or t.itemid between 374281 and 374287 or t.itemid between 374291 and 374302 or t.itemid between 374489 and 374495 or t.itemid between 374499 and 374510 or t.itemid between 374695 and 374700 or t.itemid between 374704 and 374715 or t.itemid between 374901 and 374906 or t.itemid between 374910 and 374921 or t.itemid between 375107 and 375113 or t.itemid between 375117 and 375128 or t.itemid between 375315 and 375321 or t.itemid between 375325 and 375336 or t.itemid between 375521 and 375527 or t.itemid between 375531 and 375542 or t.itemid between 375744 and 375749 or t.itemid between 375753 and 375764 or t.itemid between 376170 and 376176 or t.itemid between 376180 and 376191 or t.itemid between 376479 and 376485 or t.itemid between 376489 and 376500 or t.itemid between 377081 and 377086 or t.itemid between 377090 and 377101 or t.itemid between 377285 and 377290 or t.itemid between 377294 and 377305 or t.itemid between 377502 and 377511 or t.itemid between 377515 and 377526 or t.itemid between 377645 and 377732 or t.itemid between 377886 and 377892 or t.itemid between 377896 and 377907 or t.itemid between 378092 and 378097 or t.itemid between 378101 and 378112 or t.itemid between 378298 and 378303 or t.itemid between 378307 and 378318 or t.itemid between 378747 and 378752 or t.itemid between 378756 and 378767 or t.itemid between 378965 and 378971 or t.itemid between 378975 and 378986 or t.itemid between 379171 and 379176 or t.itemid between 379180 and 379191 or t.itemid between 379588 and 379853 or t.itemid between 379913 and 379919 or t.itemid between 379923 and 379934 or t.itemid between 380009 and 380052 or t.itemid between 380222 and 380227 or t.itemid between 380231 and 380242 or t.itemid between 380442 and 380447 or t.itemid between 380451 and 380462 or t.itemid between 380674 and 380679 or t.itemid between 380683 and 380694 or t.itemid between 380878 and 380883 or t.itemid between 380887 and 380898 or t.itemid between 381099 and 381104 or t.itemid between 381108 and 381119 or t.itemid between 381507 and 381512 or t.itemid between 381516 and 381527 or t.itemid between 381723 and 381734 or t.itemid between 381738 and 381749 or t.itemid between 382000 and 382005 or t.itemid between 382009 and 382020 or t.itemid between 382222 and 382227 or t.itemid between 382231 and 382242 or t.itemid between 382536 and 382542 or t.itemid between 382546 and 382557 or t.itemid between 382742 and 382747 or t.itemid between 382751 and 382762 or t.itemid between 383265 and 383270 or t.itemid between 383274 and 383285 or t.itemid between 383507 and 383512 or t.itemid between 383516 and 383527 or t.itemid between 383744 and 383749 or t.itemid between 383753 and 383764 or t.itemid between 384113 and 384118 or t.itemid between 384122 and 384133 or t.itemid between 384317 and 384322 or t.itemid between 384326 and 384337 or t.itemid between 384524 and 384607 or t.itemid between 384623 and 384710 or t.itemid between 385207 and 385306 or t.itemid between 385310 and 385321 or t.itemid between 385505 and 385510 or t.itemid between 385514 and 385525 or t.itemid between 385709 and 385714 or t.itemid between 385718 and 385729 or t.itemid between 385930 and 385935 or t.itemid between 385939 and 385950 or t.itemid between 386332 and 386337 or t.itemid between 386341 and 386352 or t.itemid between 386536 and 386541 or t.itemid between 386545 and 386556 or t.itemid between 386744 and 386749 or t.itemid between 386753 and 386764 or t.itemid between 386981 and 386986 or t.itemid between 386990 and 387001 or t.itemid between 387368 and 387373 or t.itemid between 387377 and 387388 or t.itemid between 387862 and 387867 or t.itemid between 387871 and 387882 or t.itemid between 388539 and 388544 or t.itemid between 388548 and 388559 or t.itemid between 388747 and 388753 or t.itemid between 388757 and 388768 or t.itemid between 388978 and 388984 or t.itemid between 388988 and 388999 or t.itemid between 389293 and 389298 or t.itemid between 389302 and 389313 or t.itemid between 389499 and 389504 or t.itemid between 389508 and 389519 or t.itemid between 389705 and 389710 or t.itemid between 389714 and 389725 or t.itemid between 389913 and 389922 or t.itemid between 389926 and 389937 or t.itemid between 389972 and 389976 or t.itemid between 390083 and 390181 or t.itemid between 390243 and 390248 or t.itemid between 390252 and 390263 or t.itemid between 390765 and 390770 or t.itemid between 390774 and 390785 or t.itemid between 390971 and 390976 or t.itemid between 390980 and 390991 or t.itemid between 391183 and 391188 or t.itemid between 391192 and 391203 or t.itemid between 391530 and 391540 or t.itemid between 391544 and 391555 or t.itemid between 391591 and 391595 or t.itemid between 391885 and 392022 or t.itemid between 392026 and 392037 or t.itemid between 392221 and 392226 or t.itemid between 392230 and 392241 or t.itemid between 392425 and 392430 or t.itemid between 392434 and 392445 or t.itemid between 392645 and 392650 or t.itemid between 392654 and 392665 or t.itemid between 392926 and 392932 or t.itemid between 392936 and 392947 or t.itemid between 393135 and 393140 or t.itemid between 393144 and 393155 or t.itemid between 393554 and 393559 or t.itemid between 393563 and 393574 or t.itemid between 393764 and 393769 or t.itemid between 393773 and 393784 or t.itemid between 393888 and 393893 or t.itemid between 393897 and 393908 or t.itemid between 394567 and 394573 or t.itemid between 394577 and 394588 or t.itemid between 394879 and 394885 or t.itemid between 394889 and 394900 or t.itemid between 395104 and 395110 or t.itemid between 395114 and 395125 or t.itemid between 395387 and 395392 or t.itemid between 395396 and 395407 or t.itemid between 395542 and 395547 or t.itemid between 395551 and 395562 or t.itemid between 395695 and 395701 or t.itemid between 395705 and 395716 or t.itemid between 395952 and 395957 or t.itemid between 395961 and 395972 or t.itemid between 396272 and 396277 or t.itemid between 396281 and 396292 or t.itemid between 396578 and 396583 or t.itemid between 396587 and 396598 or t.itemid between 397227 and 397232 or t.itemid between 397236 and 397247 or t.itemid between 397514 and 397519 or t.itemid between 397523 and 397534 or t.itemid between 397565 and 397571 or t.itemid between 397575 and 397586 or t.itemid between 398195 and 398200 or t.itemid between 398204 and 398215 or t.itemid between 398555 and 398560 or t.itemid between 398564 and 398575 or t.itemid between 398973 and 398977 or t.itemid between 399033 and 399219 or t.itemid between 399301 and 399355 or t.itemid between 399673 and 399678 or t.itemid between 399682 and 399693 or t.itemid between 399729 and 399915 or t.itemid between 399922 and 399926 or t.itemid between 400037 and 400114 or t.itemid between 400126 and 400131 or t.itemid between 400135 and 400146 or t.itemid between 400330 and 400335 or t.itemid between 400339 and 400350 or t.itemid between 400732 and 400737 or t.itemid between 400741 and 400752 or t.itemid between 401048 and 401053 or t.itemid between 401057 and 401068 or t.itemid between 401203 and 401208 or t.itemid between 401212 and 401223 or t.itemid between 401429 and 401434 or t.itemid between 401438 and 401449 or t.itemid between 401973 and 401978 or t.itemid between 401982 and 401993 or t.itemid between 402507 and 402513 or t.itemid between 402517 and 402528 or t.itemid between 402823 and 402828 or t.itemid between 402832 and 402843 or t.itemid between 402978 and 402984 or t.itemid between 403046 and 403053 or t.itemid between 403057 and 403068 or t.itemid between 403105 and 403187 or t.itemid between 403362 and 403367 or t.itemid between 403371 and 403382 or t.itemid between 403643 and 403648 or t.itemid between 403652 and 403663 or t.itemid between 403847 and 403852 or t.itemid between 403856 and 403867 or t.itemid between 404051 and 404056 or t.itemid between 404060 and 404071 or t.itemid between 404218 and 404231 or t.itemid between 404297 and 404310 or t.itemid between 404314 and 404325 or t.itemid between 404555 and 404631 or t.itemid between 404863 and 404868 or t.itemid between 404872 and 404883 or t.itemid between 405069 and 405074 or t.itemid between 405078 and 405089 or t.itemid between 405273 and 405278 or t.itemid between 405282 and 405293 or t.itemid between 405477 and 405482 or t.itemid between 405486 and 405497 or t.itemid between 406090 and 406095 or t.itemid between 406099 and 406110 or t.itemid between 406508 and 406513 or t.itemid between 406517 and 406528 or t.itemid between 406888 and 406893 or t.itemid between 406897 and 406908 or t.itemid between 407094 and 407099 or t.itemid between 407103 and 407114 or t.itemid between 407298 and 407303 or t.itemid between 407307 and 407318 or t.itemid between 407519 and 407524 or t.itemid between 407528 and 407539 or t.itemid between 407847 and 407853 or t.itemid between 407857 and 407868 or t.itemid between 408061 and 408066 or t.itemid between 408070 and 408081 or t.itemid between 408485 and 408490 or t.itemid between 408494 and 408505 or t.itemid between 409074 and 409080 or t.itemid between 409084 and 409095 or t.itemid between 409371 and 409376 or t.itemid between 409381 and 409387 or t.itemid between 409391 and 409402 or t.itemid between 409438 and 409444 or t.itemid between 409604 and 409609 or t.itemid between 409613 and 409624 or t.itemid between 410381 and 410512 or t.itemid between 410723 and 410728 or t.itemid between 410732 and 410743 or t.itemid between 410935 and 410942 or t.itemid between 410944 and 410952 or t.itemid between 411142 and 411147 or t.itemid between 411151 and 411162 or t.itemid between 411310 and 411375 or t.itemid between 411478 and 411483 or t.itemid between 411487 and 411498 or t.itemid between 411682 and 411688 or t.itemid between 411692 and 411703 or t.itemid between 411888 and 411893 or t.itemid between 411897 and 411908 or t.itemid between 412100 and 412105 or t.itemid between 412109 and 412120 or t.itemid between 412315 and 412320 or t.itemid between 412324 and 412335 or t.itemid between 413007 and 413012 or t.itemid between 413016 and 413027 or t.itemid between 413160 and 413165 or t.itemid between 413169 and 413180 or t.itemid between 413262 and 413267 or t.itemid between 413271 and 413282 or t.itemid between 413425 and 413430 or t.itemid between 413434 and 413445 or t.itemid between 413761 and 413766 or t.itemid between 413770 and 413781 or t.itemid between 413916 and 413921 or t.itemid between 413925 and 413936 or t.itemid between 414071 and 414076 or t.itemid between 414080 and 414091 or t.itemid between 414277 and 414282 or t.itemid between 414286 and 414297 or t.itemid between 414481 and 414486 or t.itemid between 414490 and 414501 or t.itemid between 414687 and 414692 or t.itemid between 414696 and 414707 or t.itemid between 414870 and 414998 or t.itemid between 415006 and 415014 or t.itemid between 415325 and 415390 or t.itemid between 415826 and 415830 or t.itemid between 415840 and 416015 or t.itemid between 416033 and 416219 or t.itemid between 416330 and 416334 or t.itemid between 416406 and 416488 or t.itemid between 416490 and 416495 or t.itemid between 416688 and 416775 or t.itemid between 417797 and 417803 or t.itemid between 417806 and 417811 or t.itemid between 417813 and 417822 or t.itemid between 417830 and 417913 or t.itemid between 417916 and 418060 or t.itemid between 418688 and 418764 or t.itemid between 418769 and 418856 or t.itemid between 419225 and 419307 or t.itemid between 419513 and 419560 or t.itemid between 420314 and 420511 or t.itemid between 420578 and 420654 or t.itemid between 421292 and 421299 or t.itemid between 421304 and 421500 or t.itemid between 421963 and 422127 or t.itemid between 422612 and 422623 or t.itemid between 422628 and 422644 or t.itemid between 422646 and 422885 or t.itemid between 422888 and 423010 or t.itemid between 423699 and 423807 or t.itemid between 423809 and 423902 or t.itemid between 424644 and 424730 or t.itemid in (355437,355438,355439,355440,355526,355527,356440,356441,356442,35644 3,361074,361075,361076,361077,361084,361085,364337,364338,364339,3643 40,364396,364397,364398,364399,364452,364453,372045,372046,372101,372 102,372103,372105,372106,372107,372108,372111,372112,377442,377443,37 7444,377445,377447,377448,379909,379910,379911,380055,380056,381152,3 81153,381154,384494,384495,384500,384501,384518,384519,384520,384521, 384610,384611,385202,385203,385204,385205,390029,391648,398763,398764 ,398765,398766,398822,398823,398824,398825,398828,398829,399228,39922 9,399917,399918,399919,399920,403040,403041,403042,403043,403245,4032 46,404234,404235,404236,404237,404367,404368,404369,404370,404634,404 635,409550,409551,409552,410515,410516,411007,411008,411009,415000,41 5001,415002,415003,415105,415106,415131,415132,415133,415134,415301,4 15302,415303,415304,415313,415323,415393,415394,415809,415810,415811, 415812,415814,415815,415816,415817,415820,415821,416018,416019,416236 ,416237,416238,416239,416401,416661,416664,416665,416778,416779,41778 6,417787,417788,417789,417791,417792,417793,417794,417824,417825,4178 26,417827,419220,419221,419222,419223,419396,419397,419398,419399,419 401,419402,419563,419564,421301,421302,422625,422626,423694,423695,42 3696,423697,424639,424640,424641,424642)) Rationale The SQL spent 100% of its database time on CPU, I/O and Cluster waits. This part of database time may be improved by the SQL Tuning Advisor. Rationale Database time for this SQL was divided as follows: 100% for SQL execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java execution. Rationale SQL statement with SQL_ID "34yyhyswhktnr" was executed 6 times and had an average elapsed time of 29 seconds. Rationale At least one execution of the statement ran in parallel. Recommendation 3: SQL Tuning Estimated benefit is .07 active sessions, 2.91% of total activity. ------------------------------------------------------------------ Action Run SQL Tuning Advisor on the SELECT statement with SQL_ID "6pf1t0yvczfsf". Related Object SQL statement with SQL_ID 6pf1t0yvczfsf. select t.item_preprocid,t.itemid,t.step,t.type,t.params,t.error_handl er,t.error_handler_params from item_preproc t where (t.itemid between 516740 and 516751 or t.itemid between 516935 and 516941 or t.itemid between 516945 and 516956 or t.itemid between 517143 and 517149 or t.itemid between 517153 and 517164 or t.itemid between 517349 and 517354 or t.itemid between 517358 and 517369 or t.itemid between 517555 and 517560 or t.itemid between 517564 and 517575 or t.itemid between 517759 and 517764 or t.itemid between 517768 and 517779 or t.itemid between 517963 and 517968 or t.itemid between 517972 and 517983 or t.itemid between 518167 and 518172 or t.itemid between 518176 and 518187 or t.itemid between 518371 and 518376 or t.itemid between 518380 and 518391 or t.itemid between 518575 and 518580 or t.itemid between 518584 and 518595 or t.itemid between 518779 and 518784 or t.itemid between 518788 and 518799 or t.itemid between 519097 and 519261 or t.itemid between 519313 and 519318 or t.itemid between 519322 and 519333 or t.itemid between 519517 and 519522 or t.itemid between 519526 and 519537 or t.itemid between 519811 and 519816 or t.itemid between 519820 and 519831 or t.itemid between 520015 and 520020 or t.itemid between 520024 and 520035 or t.itemid between 520219 and 520224 or t.itemid between 520228 and 520239 or t.itemid between 520423 and 520432 or t.itemid between 520436 and 520447 or t.itemid between 520594 and 520659 or t.itemid between 520891 and 521011 or t.itemid between 521063 and 521068 or t.itemid between 521072 and 521083 or t.itemid between 521267 and 521272 or t.itemid between 521276 and 521287 or t.itemid between 521471 and 521476 or t.itemid between 521480 and 521491 or t.itemid between 521847 and 521852 or t.itemid between 521856 and 521867 or t.itemid between 522051 and 522057 or t.itemid between 522061 and 522072 or t.itemid between 522263 and 522268 or t.itemid between 522272 and 522283 or t.itemid between 522482 and 522488 or t.itemid between 522492 and 522503 or t.itemid between 522903 and 522908 or t.itemid between 522912 and 522923 or t.itemid between 523107 and 523112 or t.itemid between 523116 and 523127 or t.itemid between 523311 and 523316 or t.itemid between 523320 and 523331 or t.itemid between 523616 and 523731 or t.itemid between 523948 and 523953 or t.itemid between 523957 and 523968 or t.itemid between 524154 and 524159 or t.itemid between 524163 and 524174 or t.itemid between 524578 and 524583 or t.itemid between 524587 and 524598 or t.itemid between 524920 and 524925 or t.itemid between 524929 and 524940 or t.itemid between 525124 and 525129 or t.itemid between 525133 and 525144 or t.itemid between 525328 and 525333 or t.itemid between 525337 and 525348 or t.itemid between 525577 and 525774 or t.itemid between 525928 and 525933 or t.itemid between 525937 and 525948 or t.itemid between 526342 and 526347 or t.itemid between 526351 and 526362 or t.itemid between 526546 and 526551 or t.itemid between 526555 and 526566 or t.itemid between 526750 and 526755 or t.itemid between 526759 and 526770 or t.itemid between 526954 and 526959 or t.itemid between 526963 and 526974 or t.itemid between 527158 and 527163 or t.itemid between 527167 and 527178 or t.itemid between 527364 and 527369 or t.itemid between 527373 and 527384 or t.itemid between 527570 and 527575 or t.itemid between 527579 and 527590 or t.itemid between 527776 and 527782 or t.itemid between 527786 and 527797 or t.itemid between 527982 and 527987 or t.itemid between 527991 and 528002 or t.itemid between 528186 and 528191 or t.itemid between 528195 and 528206 or t.itemid between 528394 and 528399 or t.itemid between 528403 and 528414 or t.itemid between 528598 and 528603 or t.itemid between 528607 and 528618 or t.itemid between 528802 and 528807 or t.itemid between 528811 and 528822 or t.itemid between 529006 and 529011 or t.itemid between 529015 and 529026 or t.itemid between 529212 and 529217 or t.itemid between 529221 and 529232 or t.itemid between 529416 and 529421 or t.itemid between 529425 and 529436 or t.itemid between 529664 and 529670 or t.itemid between 529674 and 529685 or t.itemid between 529872 and 529877 or t.itemid between 529881 and 529892 or t.itemid between 530076 and 530081 or t.itemid between 530085 and 530096 or t.itemid between 530282 and 530288 or t.itemid between 530292 and 530303 or t.itemid between 530490 and 530495 or t.itemid between 530499 and 530510 or t.itemid between 530696 and 530701 or t.itemid between 530705 and 530716 or t.itemid between 531056 and 531061 or t.itemid between 531065 and 531076 or t.itemid between 531255 and 531298 or t.itemid between 532076 and 532081 or t.itemid between 532085 and 532096 or t.itemid between 532282 and 532288 or t.itemid between 532292 and 532303 or t.itemid between 532492 and 532498 or t.itemid between 532502 and 532513 or t.itemid between 533263 and 533268 or t.itemid between 533272 and 533283 or t.itemid between 533695 and 533700 or t.itemid between 533704 and 533715 or t.itemid between 533899 and 533904 or t.itemid between 533908 and 533919 or t.itemid between 534112 and 534119 or t.itemid between 534123 and 534134 or t.itemid between 534373 and 534471 or t.itemid between 534523 and 534528 or t.itemid between 534532 and 534543 or t.itemid between 534727 and 534732 or t.itemid between 534736 and 534747 or t.itemid between 534939 and 534944 or t.itemid between 534948 and 534959 or t.itemid between 535417 and 535422 or t.itemid between 535426 and 535437 or t.itemid between 535623 and 535628 or t.itemid between 535632 and 535643 or t.itemid between 535984 and 535989 or t.itemid between 535993 and 536004 or t.itemid between 536408 and 536413 or t.itemid between 536417 and 536428 or t.itemid between 536781 and 536786 or t.itemid between 536790 and 536801 or t.itemid between 536989 and 536994 or t.itemid between 536998 and 537009 or t.itemid between 537203 and 537209 or t.itemid between 537213 and 537224 or t.itemid between 537369 and 537378 or t.itemid between 537382 and 537393 or t.itemid between 537823 and 537829 or t.itemid between 537833 and 537844 or t.itemid between 537876 and 538238 or t.itemid between 538394 and 538399 or t.itemid between 538403 and 538414 or t.itemid between 538725 and 538852 or t.itemid between 538856 and 538867 or t.itemid between 539141 and 539261 or t.itemid between 539313 and 539319 or t.itemid between 539323 and 539334 or t.itemid between 539519 and 539525 or t.itemid between 539529 and 539540 or t.itemid between 539729 and 539734 or t.itemid between 539738 and 539749 or t.itemid between 539965 and 539970 or t.itemid between 539974 and 539985 or t.itemid between 540307 and 540312 or t.itemid between 540316 and 540327 or t.itemid between 540511 and 540517 or t.itemid between 540521 and 540532 or t.itemid between 540719 and 540724 or t.itemid between 540728 and 540739 or t.itemid between 541270 and 541275 or t.itemid between 541279 and 541290 or t.itemid between 541744 and 541750 or t.itemid between 541754 and 541765 or t.itemid between 541952 and 541957 or t.itemid between 541961 and 541972 or t.itemid between 543036 and 543041 or t.itemid between 543045 and 543056 or t.itemid between 543242 and 543247 or t.itemid between 543251 and 543262 or t.itemid between 543448 and 543454 or t.itemid between 543458 and 543469 or t.itemid between 543654 and 543659 or t.itemid between 543663 and 543674 or t.itemid between 544324 and 544329 or t.itemid between 544333 and 544344 or t.itemid between 544528 and 544533 or t.itemid between 544537 and 544548 or t.itemid between 544732 and 544737 or t.itemid between 544741 and 544752 or t.itemid between 545127 and 545133 or t.itemid between 545137 and 545148 or t.itemid between 545707 and 545712 or t.itemid between 545716 and 545727 or t.itemid between 545911 and 545916 or t.itemid between 545920 and 545931 or t.itemid between 546115 and 546120 or t.itemid between 546124 and 546135 or t.itemid between 546449 and 546564 or t.itemid between 546568 and 546579 or t.itemid between 547350 and 547569 or t.itemid between 547621 and 547626 or t.itemid between 547630 and 547641 or t.itemid between 547937 and 547942 or t.itemid between 547946 and 547957 or t.itemid between 548171 and 548176 or t.itemid between 548180 and 548191 or t.itemid between 548503 and 548509 or t.itemid between 548513 and 548524 or t.itemid between 548709 and 548714 or t.itemid between 548718 and 548729 or t.itemid between 548913 and 548918 or t.itemid between 548922 and 548933 or t.itemid between 549399 and 549404 or t.itemid between 549408 and 549419 or t.itemid between 549911 and 550004 or t.itemid between 550008 and 550019 or t.itemid between 550203 and 550208 or t.itemid between 550212 and 550223 or t.itemid between 550413 and 550418 or t.itemid between 550422 and 550433 or t.itemid between 550766 and 550772 or t.itemid between 550776 and 550787 or t.itemid between 551009 and 551014 or t.itemid between 551018 and 551029 or t.itemid between 551213 and 551218 or t.itemid between 551222 and 551233 or t.itemid between 551417 and 551422 or t.itemid between 551426 and 551437 or t.itemid between 551510 and 551517 or t.itemid between 551573 and 551580 or t.itemid between 551741 and 551746 or t.itemid between 551750 and 551761 or t.itemid between 551970 and 552090 or t.itemid between 552195 and 552200 or t.itemid between 552204 and 552215 or t.itemid between 552447 and 552452 or t.itemid between 552456 and 552467 or t.itemid between 552798 and 552803 or t.itemid between 552807 and 552818 or t.itemid between 553008 and 553013 or t.itemid between 553017 and 553028 or t.itemid between 553421 and 553426 or t.itemid between 553430 and 553441 or t.itemid between 553578 and 553586 or t.itemid between 553751 and 553756 or t.itemid between 553760 and 553771 or t.itemid between 553873 and 553971 or t.itemid between 554232 and 554237 or t.itemid between 554241 and 554252 or t.itemid between 554436 and 554441 or t.itemid between 554445 and 554456 or t.itemid between 554487 and 554684 or t.itemid between 554787 and 554792 or t.itemid between 554796 and 554807 or t.itemid between 554917 and 555015 or t.itemid between 555146 and 555151 or t.itemid between 555155 and 555166 or t.itemid between 555598 and 555604 or t.itemid between 555608 and 555619 or t.itemid between 556244 and 556250 or t.itemid between 556254 and 556265 or t.itemid between 556585 and 556598 or t.itemid between 556601 and 556610 or t.itemid between 556614 and 556625 or t.itemid between 556664 and 556671 or t.itemid between 556790 and 556844 or t.itemid between 556910 and 556915 or t.itemid between 556919 and 556930 or t.itemid between 557644 and 557649 or t.itemid between 557653 and 557664 or t.itemid between 557912 and 557917 or t.itemid between 557921 and 557932 or t.itemid between 558246 and 558251 or t.itemid between 558255 and 558266 or t.itemid between 558403 and 558408 or t.itemid between 558412 and 558423 or t.itemid between 558695 and 558700 or t.itemid between 558704 and 558715 or t.itemid between 559005 and 559010 or t.itemid between 559014 and 559025 or t.itemid between 559363 and 559368 or t.itemid between 559372 and 559383 or t.itemid between 559567 and 559572 or t.itemid between 559576 and 559587 or t.itemid between 559739 and 559752 or t.itemid between 559755 and 559914 or t.itemid between 559937 and 560244 or t.itemid between 561551 and 561633 or t.itemid between 562103 and 562300 or t.itemid between 562352 and 562357 or t.itemid between 562361 and 562372 or t.itemid between 562556 and 562561 or t.itemid between 562565 and 562576 or t.itemid between 562760 and 562765 or t.itemid between 562769 and 562780 or t.itemid between 563342 and 563440 or t.itemid between 563494 and 563499 or t.itemid between 563503 and 563514 or t.itemid between 563711 and 563716 or t.itemid between 563720 and 563731 or t.itemid between 564184 and 564189 or t.itemid between 564193 and 564204 or t.itemid between 564610 and 564615 or t.itemid between 564619 and 564630 or t.itemid between 564816 and 564821 or t.itemid between 564825 and 564836 or t.itemid between 565215 and 565221 or t.itemid between 565225 and 565236 or t.itemid between 565425 and 565430 or t.itemid between 565434 and 565445 or t.itemid between 565629 and 565634 or t.itemid between 565638 and 565649 or t.itemid between 565833 and 565838 or t.itemid between 565842 and 565853 or t.itemid between 566451 and 566456 or t.itemid between 566460 and 566471 or t.itemid between 566657 and 566662 or t.itemid between 566666 and 566677 or t.itemid between 567401 and 567406 or t.itemid between 567410 and 567421 or t.itemid between 567657 and 567662 or t.itemid between 567666 and 567677 or t.itemid between 568043 and 568049 or t.itemid between 568053 and 568064 or t.itemid between 568249 and 568254 or t.itemid between 568258 and 568269 or t.itemid between 568418 and 568433 or t.itemid between 568493 and 568502 or t.itemid between 568506 and 568517 or t.itemid between 568558 and 568567 or t.itemid between 568624 and 568727 or t.itemid between 568785 and 568792 or t.itemid between 568796 and 568807 or t.itemid between 569277 and 569283 or t.itemid between 569287 and 569298 or t.itemid between 569483 and 569488 or t.itemid between 569492 and 569503 or t.itemid between 570036 and 570041 or t.itemid between 570045 and 570056 or t.itemid between 570438 and 570443 or t.itemid between 570447 and 570458 or t.itemid between 570642 and 570647 or t.itemid between 570651 and 570662 or t.itemid between 571616 and 571621 or t.itemid between 571625 and 571636 or t.itemid between 571836 and 571841 or t.itemid between 571845 and 571856 or t.itemid between 572306 and 572311 or t.itemid between 572315 and 572326 or t.itemid between 572730 and 572735 or t.itemid between 572739 and 572750 or t.itemid between 573052 and 573150 or t.itemid between 573153 and 573160 or t.itemid between 573164 and 573175 or t.itemid between 573573 and 573578 or t.itemid between 573582 and 573593 or t.itemid between 573777 and 573782 or t.itemid between 573786 and 573797 or t.itemid between 574115 and 574246 or t.itemid between 574256 and 574261 or t.itemid between 574265 and 574276 or t.itemid between 574653 and 574664 or t.itemid between 574668 and 574679 or t.itemid between 574909 and 575051 or t.itemid between 575156 and 575161 or t.itemid between 575165 and 575176 or t.itemid between 575549 and 575554 or t.itemid between 575558 and 575569 or t.itemid between 575982 and 575987 or t.itemid between 575991 and 576002 or t.itemid between 576156 and 576551 or t.itemid between 576867 and 576872 or t.itemid between 576876 and 576887 or t.itemid between 577073 and 577166 or t.itemid between 577170 and 577181 or t.itemid between 577602 and 577607 or t.itemid between 577611 and 577622 or t.itemid between 577824 and 577829 or t.itemid between 577833 and 577844 or t.itemid between 578272 and 578277 or t.itemid between 578281 and 578292 or t.itemid between 578570 and 578646 or t.itemid between 578651 and 578656 or t.itemid between 578660 and 578671 or t.itemid between 579064 and 579069 or t.itemid between 579073 and 579084 or t.itemid between 579268 and 579274 or t.itemid between 579278 and 579289 or t.itemid between 579535 and 579540 or t.itemid between 579544 and 579555 or t.itemid between 579868 and 579875 or t.itemid between 579879 and 579890 or t.itemid between 580104 and 580235 or t.itemid between 580778 and 580981 or t.itemid between 580985 and 580996 or t.itemid between 581664 and 581670 or t.itemid between 581674 and 581685 or t.itemid between 581903 and 581908 or t.itemid between 581912 and 581923 or t.itemid between 582221 and 582226 or t.itemid between 582230 and 582241 or t.itemid between 582613 and 582953 or t.itemid between 583304 and 583309 or t.itemid between 583313 and 583324 or t.itemid between 583918 and 583923 or t.itemid between 583927 and 583938 or t.itemid between 584687 and 584692 or t.itemid between 584696 and 584707 or t.itemid between 585011 and 585016 or t.itemid between 585020 and 585031 or t.itemid between 585864 and 585869 or t.itemid between 585873 and 585884 or t.itemid between 585924 and 585928 or t.itemid between 586074 and 586161 or t.itemid between 586213 and 586218 or t.itemid between 586222 and 586233 or t.itemid between 586801 and 586806 or t.itemid between 586810 and 586821 or t.itemid between 587068 and 587074 or t.itemid between 587078 and 587089 or t.itemid between 587674 and 587685 or t.itemid between 587689 and 587700 or t.itemid between 587741 and 587795 or t.itemid between 588902 and 588907 or t.itemid between 588911 and 588922 or t.itemid between 589055 and 589274 or t.itemid between 589326 and 589331 or t.itemid between 589335 and 589346 or t.itemid between 589794 and 589799 or t.itemid between 589803 and 589814 or t.itemid between 590036 and 590041 or t.itemid between 590045 and 590056 or t.itemid between 590281 and 590286 or t.itemid between 590290 and 590301 or t.itemid between 591258 and 591263 or t.itemid between 591267 and 591278 or t.itemid between 591668 and 591673 or t.itemid between 591677 and 591688 or t.itemid between 592114 and 592119 or t.itemid between 592123 and 592134 or t.itemid between 592562 and 592567 or t.itemid between 592571 and 592582 or t.itemid between 592905 and 592910 or t.itemid between 592914 and 592925 or t.itemid between 593637 and 593642 or t.itemid between 593646 and 593657 or t.itemid between 594341 and 594347 or t.itemid between 594351 and 594362 or t.itemid between 594633 and 594918 or t.itemid between 595023 and 595028 or t.itemid between 595032 and 595043 or t.itemid between 595273 and 595279 or t.itemid between 595283 and 595294 or t.itemid between 595487 and 595493 or t.itemid between 595497 and 595508 or t.itemid between 595904 and 595909 or t.itemid between 595913 and 595924 or t.itemid between 596284 and 596289 or t.itemid between 596293 and 596304 or t.itemid between 596544 and 596553 or t.itemid between 596557 and 596568 or t.itemid between 596653 and 596740 or t.itemid between 596859 and 596864 or t.itemid between 596868 and 596879 or t.itemid between 597228 and 597233 or t.itemid between 597237 and 597248 or t.itemid between 597338 and 597343 or t.itemid between 597459 and 597473 or t.itemid between 597477 and 597488 or t.itemid between 597629 and 597697 or t.itemid in (516735,516736,520482,520483,520539,520540,520541,520542,520717,52071 8,523611,523612,523613,523614,534107,534108,534109,534110,534167,5341 68,534169,534222,536044,536045,536046,538498,538499,538552,538903,538 904,538905,538906,538908,538909,538963,538964,538965,538966,546170,54 6171,546172,546173,546175,546176,546232,546233,546234,546287,551633,5 51795,551796,551797,553813,553814,553815,556727,556728,556729,556730, 556902,556903,561546,561547,561548,561549,572785,572786,572787,572788 ,572844,572845,572846,572847,572900,572901,574594,574595,574596,57459 7,574712,578327,578328,578329,578330,578332,578333,578387,578388,5783 89,578390,579751,579752,579753,579754,579812,579813,579814,579815,585 919,585920,585921,585922,586008,587352,587353,587409,587410,587666,58 7667,587670,587671,587801,587802,593919,593920,593921,593922,593978,5 93979,593980,593981,594394,596485,596486,596487,596488,596600,596601, 596798,596799,597279,597280,597345,597346,597455,597456)) Rationale The SQL spent 100% of its database time on CPU, I/O and Cluster waits. This part of database time may be improved by the SQL Tuning Advisor. Rationale Database time for this SQL was divided as follows: 100% for SQL execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java execution. Rationale SQL statement with SQL_ID "6pf1t0yvczfsf" was executed 13 times and had an average elapsed time of 13 seconds. Rationale At least one execution of the statement ran in parallel. Recommendation 4: SQL Tuning Estimated benefit is .07 active sessions, 2.91% of total activity. ------------------------------------------------------------------ Action Run SQL Tuning Advisor on the SELECT statement with SQL_ID "cwa23z2djqymt". Related Object SQL statement with SQL_ID cwa23z2djqymt. select t.item_preprocid,t.itemid,t.step,t.type,t.params,t.error_handl er,t.error_handler_params from item_preproc t where (t.itemid between 348034 and 348175 or t.itemid between 348227 and 348233 or t.itemid between 348237 and 348248 or t.itemid between 348433 and 348438 or t.itemid between 348442 and 348453 or t.itemid between 348637 and 348642 or t.itemid between 348646 and 348657 or t.itemid between 348841 and 348846 or t.itemid between 348850 and 348861 or t.itemid between 349045 and 349050 or t.itemid between 349054 and 349065 or t.itemid between 349249 and 349254 or t.itemid between 349258 and 349269 or t.itemid between 349453 and 349458 or t.itemid between 349462 and 349473 or t.itemid between 349657 and 349662 or t.itemid between 349666 and 349677 or t.itemid between 349861 and 349866 or t.itemid between 349870 and 349881 or t.itemid between 350065 and 350070 or t.itemid between 350074 and 350085 or t.itemid between 350269 and 350274 or t.itemid between 350278 and 350289 or t.itemid between 350473 and 350479 or t.itemid between 350483 and 350494 or t.itemid between 350679 and 350685 or t.itemid between 350689 and 350700 or t.itemid between 350887 and 350892 or t.itemid between 350896 and 350907 or t.itemid between 351091 and 351096 or t.itemid between 351100 and 351111 or t.itemid between 351295 and 351300 or t.itemid between 351304 and 351315 or t.itemid between 351829 and 352164 or t.itemid between 352168 and 352179 or t.itemid between 352363 and 352368 or t.itemid between 352372 and 352383 or t.itemid between 352567 and 352572 or t.itemid between 352576 and 352587 or t.itemid between 352771 and 352776 or t.itemid between 352780 and 352791 or t.itemid between 352975 and 352980 or t.itemid between 352984 and 352995 or t.itemid between 353223 and 353228 or t.itemid between 353232 and 353243 or t.itemid between 353427 and 353432 or t.itemid between 353436 and 353447 or t.itemid between 353631 and 353636 or t.itemid between 353640 and 353651 or t.itemid between 353839 and 353844 or t.itemid between 353848 and 353859 or t.itemid between 354051 and 354160 or t.itemid between 354249 and 354325 or t.itemid between 354403 and 354721 or t.itemid between 355030 and 355216 or t.itemid between 355528 and 355604 or t.itemid between 356672 and 356677 or t.itemid between 356681 and 356692 or t.itemid between 356878 and 356883 or t.itemid between 356887 and 356898 or t.itemid between 357082 and 357087 or t.itemid between 357091 and 357102 or t.itemid between 357288 and 357294 or t.itemid between 357298 and 357309 or t.itemid between 357496 and 357501 or t.itemid between 357505 and 357516 or t.itemid between 357700 and 357705 or t.itemid between 357709 and 357720 or t.itemid between 357906 and 357911 or t.itemid between 357915 and 357926 or t.itemid between 358128 and 358133 or t.itemid between 358137 and 358148 or t.itemid between 358464 and 358469 or t.itemid between 358473 and 358484 or t.itemid between 358668 and 358673 or t.itemid between 358677 and 358688 or t.itemid between 358872 and 358877 or t.itemid between 358881 and 358892 or t.itemid between 358980 and 358985 or t.itemid between 359041 and 359046 or t.itemid between 359099 and 359105 or t.itemid between 359109 and 359120 or t.itemid between 359304 and 359309 or t.itemid between 359313 and 359324 or t.itemid between 359476 and 359541 or t.itemid between 359652 and 359658 or t.itemid between 359662 and 359673 or t.itemid between 359860 and 359865 or t.itemid between 359869 and 359880 or t.itemid between 360086 and 360092 or t.itemid between 360096 and 360107 or t.itemid between 360296 and 360434 or t.itemid between 360438 and 360449 or t.itemid between 360634 and 360639 or t.itemid between 360643 and 360654 or t.itemid between 360866 and 360871 or t.itemid between 360875 and 360886 or t.itemid between 361089 and 361094 or t.itemid between 361098 and 361109 or t.itemid between 361454 and 361459 or t.itemid between 361463 and 361474 or t.itemid between 361658 and 361663 or t.itemid between 361667 and 361678 or t.itemid between 361906 and 361911 or t.itemid between 361915 and 361926 or t.itemid between 362110 and 362115 or t.itemid between 362119 and 362130 or t.itemid between 362328 and 362333 or t.itemid between 362337 and 362348 or t.itemid between 362546 and 362551 or t.itemid between 362555 and 362566 or t.itemid between 362750 and 362755 or t.itemid between 362759 and 362770 or t.itemid between 362954 and 362959 or t.itemid between 362963 and 362974 or t.itemid between 363115 and 363122 or t.itemid between 363180 and 363194 or t.itemid between 363198 and 363209 or t.itemid between 363399 and 363404 or t.itemid between 363408 and 363419 or t.itemid between 363560 and 363669 or t.itemid between 363823 and 363828 or t.itemid between 363832 and 363843 or t.itemid between 364027 and 364032 or t.itemid between 364036 and 364047 or t.itemid between 364231 and 364236 or t.itemid between 364240 and 364251 or t.itemid between 364454 and 364459 or t.itemid between 364463 and 364474 or t.itemid between 364834 and 364839 or t.itemid between 364843 and 364854 or t.itemid between 365038 and 365043 or t.itemid between 365047 and 365058 or t.itemid between 365242 and 365247 or t.itemid between 365251 and 365262 or t.itemid between 365446 and 365451 or t.itemid between 365455 and 365466 or t.itemid between 365710 and 365715 or t.itemid between 365719 and 365730 or t.itemid between 366090 and 366095 or t.itemid between 366099 and 366110 or t.itemid between 366294 and 366299 or t.itemid between 366303 and 366314 or t.itemid between 366525 and 366530 or t.itemid between 366534 and 366545 or t.itemid between 366856 and 366862 or t.itemid between 366866 and 366877 or t.itemid between 367062 and 367067 or t.itemid between 367071 and 367082 or t.itemid between 367268 and 367273 or t.itemid between 367277 and 367288 or t.itemid between 367472 and 367477 or t.itemid between 367481 and 367492 or t.itemid between 367686 and 367691 or t.itemid between 367695 and 367706 or t.itemid between 368018 and 368144 or t.itemid between 368148 and 368159 or t.itemid between 368343 and 368348 or t.itemid between 368352 and 368363 or t.itemid between 368547 and 368552 or t.itemid between 368556 and 368567 or t.itemid between 368751 and 368756 or t.itemid between 368760 and 368771 or t.itemid between 368957 and 368963 or t.itemid between 368967 and 368978 or t.itemid between 369169 and 369175 or t.itemid between 369179 and 369190 or t.itemid between 369375 and 369380 or t.itemid between 369384 and 369395 or t.itemid between 369579 and 369584 or t.itemid between 369588 and 369599 or t.itemid between 369801 and 369806 or t.itemid between 369810 and 369821 or t.itemid between 370207 and 370212 or t.itemid between 370216 and 370227 or t.itemid between 370413 and 370418 or t.itemid between 370422 and 370433 or t.itemid between 370619 and 370624 or t.itemid between 370628 and 370639 or t.itemid between 370825 and 370830 or t.itemid between 370834 and 370845 or t.itemid between 371276 and 371281 or t.itemid between 371285 and 371296 or t.itemid between 371480 and 371485 or t.itemid between 371489 and 371500 or t.itemid between 371684 and 371689 or t.itemid between 371693 and 371704 or t.itemid between 371888 and 371894 or t.itemid between 371898 and 371909 or t.itemid between 372113 and 372119 or t.itemid between 372123 and 372134 or t.itemid between 372321 and 372326 or t.itemid between 372330 and 372341 or t.itemid between 372525 and 372530 or t.itemid between 372534 and 372545 or t.itemid between 372971 and 372976 or t.itemid between 372980 and 372991 or t.itemid between 373175 and 373180 or t.itemid between 373184 and 373195 or t.itemid between 373389 and 373394 or t.itemid between 373398 and 373409 or t.itemid between 373688 and 373693 or t.itemid between 373697 and 373708 or t.itemid between 373892 and 373897 or t.itemid between 373901 and 373912 or t.itemid between 374111 and 374176 or t.itemid between 374228 and 374234 or t.itemid between 374238 and 374249 or t.itemid between 374436 and 374442 or t.itemid between 374446 and 374457 or t.itemid between 374644 and 374649 or t.itemid between 374653 and 374664 or t.itemid between 374850 and 374855 or t.itemid between 374859 and 374870 or t.itemid between 375054 and 375060 or t.itemid between 375064 and 375075 or t.itemid between 375264 and 375269 or t.itemid between 375273 and 375284 or t.itemid between 375470 and 375475 or t.itemid between 375479 and 375490 or t.itemid between 375692 and 375698 or t.itemid between 375702 and 375713 or t.itemid between 375905 and 376014 or t.itemid between 376117 and 376123 or t.itemid between 376127 and 376138 or t.itemid between 376426 and 376432 or t.itemid between 376436 and 376447 or t.itemid between 377030 and 377035 or t.itemid between 377039 and 377050 or t.itemid between 377234 and 377239 or t.itemid between 377243 and 377254 or t.itemid between 377449 and 377454 or t.itemid between 377458 and 377469 or t.itemid between 377835 and 377840 or t.itemid between 377844 and 377855 or t.itemid between 378041 and 378046 or t.itemid between 378050 and 378061 or t.itemid between 378247 and 378252 or t.itemid between 378256 and 378267 or t.itemid between 378476 and 378481 or t.itemid between 378485 and 378496 or t.itemid between 378912 and 378918 or t.itemid between 378922 and 378933 or t.itemid between 379120 and 379125 or t.itemid between 379129 and 379140 or t.itemid between 379854 and 379859 or t.itemid between 379863 and 379874 or t.itemid between 380171 and 380176 or t.itemid between 380180 and 380191 or t.itemid between 380391 and 380396 or t.itemid between 380400 and 380411 or t.itemid between 380623 and 380628 or t.itemid between 380632 and 380643 or t.itemid between 380827 and 380832 or t.itemid between 380836 and 380847 or t.itemid between 381039 and 381044 or t.itemid between 381048 and 381059 or t.itemid between 381456 and 381461 or t.itemid between 381465 and 381476 or t.itemid between 381668 and 381673 or t.itemid between 381677 and 381688 or t.itemid between 381941 and 381946 or t.itemid between 381950 and 381961 or t.itemid between 382169 and 382174 or t.itemid between 382178 and 382189 or t.itemid between 382485 and 382490 or t.itemid between 382494 and 382505 or t.itemid between 382691 and 382696 or t.itemid between 382700 and 382711 or t.itemid between 382895 and 382900 or t.itemid between 382904 and 382915 or t.itemid between 383418 and 383423 or t.itemid between 383427 and 383438 or t.itemid between 383693 and 383698 or t.itemid between 383702 and 383713 or t.itemid between 384062 and 384067 or t.itemid between 384071 and 384082 or t.itemid between 384266 and 384271 or t.itemid between 384275 and 384286 or t.itemid between 385090 and 385187 or t.itemid between 385195 and 385201 or t.itemid between 385454 and 385459 or t.itemid between 385463 and 385474 or t.itemid between 385658 and 385663 or t.itemid between 385667 and 385678 or t.itemid between 385873 and 385878 or t.itemid between 385882 and 385893 or t.itemid between 386281 and 386286 or t.itemid between 386290 and 386301 or t.itemid between 386485 and 386490 or t.itemid between 386494 and 386505 or t.itemid between 386693 and 386698 or t.itemid between 386702 and 386713 or t.itemid between 386912 and 386917 or t.itemid between 386921 and 386932 or t.itemid between 387312 and 387317 or t.itemid between 387321 and 387332 or t.itemid between 387809 and 387815 or t.itemid between 387819 and 387830 or t.itemid between 388015 and 388020 or t.itemid between 388024 and 388035 or t.itemid between 388484 and 388538 or t.itemid between 388696 and 388701 or t.itemid between 388705 and 388716 or t.itemid between 388918 and 388928 or t.itemid between 388932 and 388943 or t.itemid between 389084 and 389176 or t.itemid between 389238 and 389245 or t.itemid between 389249 and 389260 or t.itemid between 389448 and 389453 or t.itemid between 389457 and 389468 or t.itemid between 389654 and 389659 or t.itemid between 389663 and 389674 or t.itemid between 389858 and 389863 or t.itemid between 389867 and 389878 or t.itemid between 390182 and 390188 or t.itemid between 390192 and 390203 or t.itemid between 390298 and 390303 or t.itemid between 390406 and 390411 or t.itemid between 390415 and 390426 or t.itemid between 390611 and 390764 or t.itemid between 390918 and 390924 or t.itemid between 390928 and 390939 or t.itemid between 391124 and 391129 or t.itemid between 391133 and 391144 or t.itemid between 391347 and 391352 or t.itemid between 391356 and 391367 or t.itemid between 391702 and 391707 or t.itemid between 391711 and 391722 or t.itemid between 392170 and 392175 or t.itemid between 392179 and 392190 or t.itemid between 392374 and 392379 or t.itemid between 392383 and 392394 or t.itemid between 392584 and 392589 or t.itemid between 392593 and 392604 or t.itemid between 392867 and 392872 or t.itemid between 392876 and 392887 or t.itemid between 393084 and 393089 or t.itemid between 393093 and 393104 or t.itemid between 393348 and 393353 or t.itemid between 393357 and 393368 or t.itemid between 393501 and 393507 or t.itemid between 393511 and 393522 or t.itemid between 393707 and 393712 or t.itemid between 393716 and 393727 or t.itemid between 393883 and 393887 or t.itemid between 394027 and 394114 or t.itemid between 394243 and 394248 or t.itemid between 394252 and 394263 or t.itemid between 394516 and 394521 or t.itemid between 394525 and 394536 or t.itemid between 394724 and 394729 or t.itemid between 394733 and 394744 or t.itemid between 394775 and 394781 or t.itemid between 394785 and 394796 or t.itemid between 395036 and 395044 or t.itemid between 395048 and 395059 or t.itemid between 395096 and 395100 or t.itemid between 395167 and 395174 or t.itemid between 395336 and 395341 or t.itemid between 395345 and 395356 or t.itemid between 395644 and 395649 or t.itemid between 395653 and 395664 or t.itemid between 395748 and 395753 or t.itemid between 395757 and 395768 or t.itemid between 395901 and 395906 or t.itemid between 395910 and 395921 or t.itemid between 396221 and 396226 or t.itemid between 396230 and 396241 or t.itemid between 396527 and 396532 or t.itemid between 396536 and 396547 or t.itemid between 396629 and 396634 or t.itemid between 396638 and 396649 or t.itemid between 397463 and 397468 or t.itemid between 397472 and 397483 or t.itemid between 397618 and 397623 or t.itemid between 397627 and 397638 or t.itemid between 397815 and 397869 or t.itemid between 398144 and 398149 or t.itemid between 398153 and 398164 or t.itemid between 398401 and 398554 or t.itemid between 398710 and 398716 or t.itemid between 398720 and 398731 or t.itemid between 398830 and 398972 or t.itemid between 399220 and 399225 or t.itemid between 399237 and 399245 or t.itemid between 399458 and 399463 or t.itemid between 399467 and 399478 or t.itemid between 399560 and 399565 or t.itemid between 399569 and 399580 or t.itemid between 400279 and 400284 or t.itemid between 400288 and 400299 or t.itemid between 400681 and 400686 or t.itemid between 400690 and 400701 or t.itemid between 400997 and 401002 or t.itemid between 401006 and 401017 or t.itemid between 401372 and 401379 or t.itemid between 401383 and 401394 or t.itemid between 401568 and 401655 or t.itemid between 401768 and 401773 or t.itemid between 401777 and 401788 or t.itemid between 402291 and 402461 or t.itemid between 402465 and 402476 or t.itemid between 402717 and 402777 or t.itemid between 402781 and 402792 or t.itemid between 402985 and 402990 or t.itemid between 402994 and 403005 or t.itemid between 403307 and 403316 or t.itemid between 403320 and 403331 or t.itemid between 403413 and 403489 or t.itemid between 403592 and 403597 or t.itemid between 403601 and 403612 or t.itemid between 403796 and 403801 or t.itemid between 403805 and 403816 or t.itemid between 404000 and 404005 or t.itemid between 404009 and 404020 or t.itemid between 404238 and 404243 or t.itemid between 404247 and 404258 or t.itemid between 404636 and 404641 or t.itemid between 404645 and 404656 or t.itemid between 405018 and 405023 or t.itemid between 405027 and 405038 or t.itemid between 405222 and 405227 or t.itemid between 405231 and 405242 or t.itemid between 405426 and 405431 or t.itemid between 405435 and 405446 or t.itemid between 405642 and 405647 or t.itemid between 405651 and 405662 or t.itemid between 406457 and 406462 or t.itemid between 406466 and 406477 or t.itemid between 406837 and 406842 or t.itemid between 406846 and 406857 or t.itemid between 407043 and 407048 or t.itemid between 407052 and 407063 or t.itemid between 407247 and 407252 or t.itemid between 407256 and 407267 or t.itemid between 407466 and 407471 or t.itemid between 407475 and 407486 or t.itemid between 407717 and 407724 or t.itemid between 407787 and 407800 or t.itemid between 407804 and 407815 or t.itemid between 408010 and 408015 or t.itemid between 408019 and 408030 or t.itemid between 408324 and 408439 or t.itemid between 408443 and 408454 or t.itemid between 408723 and 408909 or t.itemid between 409012 and 409017 or t.itemid between 409021 and 409032 or t.itemid between 409237 and 409319 or t.itemid between 409323 and 409334 or t.itemid between 409553 and 409558 or t.itemid between 409562 and 409573 or t.itemid between 410672 and 410677 or t.itemid between 410681 and 410692 or t.itemid between 410876 and 410881 or t.itemid between 410885 and 410896 or t.itemid between 410953 and 410958 or t.itemid between 410962 and 410973 or t.itemid between 411427 and 411432 or t.itemid between 411436 and 411447 or t.itemid between 411631 and 411636 or t.itemid between 411640 and 411651 or t.itemid between 411837 and 411842 or t.itemid between 411846 and 411857 or t.itemid between 412041 and 412046 or t.itemid between 412050 and 412061 or t.itemid between 412264 and 412269 or t.itemid between 412273 and 412284 or t.itemid between 412648 and 412653 or t.itemid between 412657 and 412668 or t.itemid between 413109 and 413114 or t.itemid between 413118 and 413129 or t.itemid between 413211 and 413216 or t.itemid between 413220 and 413231 or t.itemid between 413364 and 413369 or t.itemid between 413373 and 413384 or t.itemid between 413710 and 413715 or t.itemid between 413719 and 413730 or t.itemid between 413865 and 413870 or t.itemid between 413874 and 413885 or t.itemid between 414226 and 414231 or t.itemid between 414235 and 414246 or t.itemid between 414430 and 414435 or t.itemid between 414439 and 414450 or t.itemid between 414634 and 414640 or t.itemid between 414644 and 414655 or t.itemid between 415556 and 415639 or t.itemid between 415642 and 415808 or t.itemid between 416020 and 416024 or t.itemid between 416027 and 416032 or t.itemid between 416221 and 416225 or t.itemid between 416241 and 416328 or t.itemid between 417107 and 417271 or t.itemid between 417545 and 417552 or t.itemid between 417560 and 417568 or t.itemid between 417575 and 417580 or t.itemid between 417582 and 417591 or t.itemid between 417599 and 417781 or t.itemid between 418171 and 418258 or t.itemid between 418974 and 418987 or t.itemid between 418990 and 419102 or t.itemid between 419104 and 419219 or t.itemid between 420119 and 420239 or t.itemid between 420513 and 420573 or t.itemid between 420921 and 420927 or t.itemid between 420929 and 420936 or t.itemid between 420942 and 420953 or t.itemid between 420956 and 421034 or t.itemid between 421037 and 421115 or t.itemid between 421666 and 421742 or t.itemid between 422304 and 422311 or t.itemid between 422318 and 422501 or t.itemid between 423479 and 423587 or t.itemid between 423589 and 423693 or t.itemid between 424421 and 424513 or t.itemid between 424516 and 424521 or t.itemid between 424523 and 424638 or t.itemid between 425930 and 425965 or t.itemid in (359357,359358,359544,359545,363345,363346,363347,367523,367524,36752 5,367526,367582,367583,367790,367791,367844,367845,375578,375579,3755 80,375581,375583,375584,375585,375586,375639,385085,385086,385087,385 088,385189,385190,385191,385192,388857,388858,388859,388860,388976,38 8977,389232,389233,389234,389235,389292,390239,390240,390241,390242,3 93760,393761,393762,393763,393819,393820,393821,393822,393825,393826, 394117,394118,395102,395103,395163,395164,395232,395233,397677,397678 ,397679,397680,397682,397683,397684,397685,397807,397808,397875,39787 6,399031,399032,399231,399232,399233,399234,399248,399249,401258,4012 59,401260,401261,401263,401264,401318,401319,403247,403248,403249,403 250,403252,403253,407726,407727,407903,407904,407905,409067,409068,40 9069,409070,409072,409073,409129,409130,409185,409379,409380,415545,4 15546,415547,415548,415550,415551,415552,415553,415822,415823,415824, 415825,415832,415833,415834,415835,415838,415839,416230,417554,417555 ,417556,417557,417593,417594,417595,417596,417784,417785,420310,42031 1,420312,420313,420576,420577,420939,420940,422313,422314,422315,4223 16,423474,423475,423476,423477,424416,424417,424418,424419)) Rationale The SQL spent 100% of its database time on CPU, I/O and Cluster waits. This part of database time may be improved by the SQL Tuning Advisor. Rationale Database time for this SQL was divided as follows: 100% for SQL execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java execution. Rationale SQL statement with SQL_ID "cwa23z2djqymt" was executed 10 times and had an average elapsed time of 16 seconds. Rationale At least one execution of the statement ran in parallel. Recommendation 5: SQL Tuning Estimated benefit is .07 active sessions, 2.85% of total activity. ------------------------------------------------------------------ Action Run SQL Tuning Advisor on the SELECT statement with SQL_ID "1tv34b559thby". Related Object SQL statement with SQL_ID 1tv34b559thby. select t.item_preprocid,t.itemid,t.step,t.type,t.params,t.error_handl er,t.error_handler_params from item_preproc t where (t.itemid between 511547 and 511551 or t.itemid between 511737 and 511742 or t.itemid between 511746 and 511757 or t.itemid between 511941 and 511946 or t.itemid between 511950 and 511961 or t.itemid between 512043 and 512048 or t.itemid between 512052 and 512063 or t.itemid between 512247 and 512252 or t.itemid between 512256 and 512267 or t.itemid between 512451 and 512456 or t.itemid between 512460 and 512471 or t.itemid between 512655 and 512660 or t.itemid between 512664 and 512675 or t.itemid between 512861 and 512866 or t.itemid between 512870 and 512881 or t.itemid between 513067 and 513072 or t.itemid between 513076 and 513087 or t.itemid between 513220 and 513225 or t.itemid between 513229 and 513240 or t.itemid between 513424 and 513429 or t.itemid between 513433 and 513444 or t.itemid between 513630 and 513635 or t.itemid between 513639 and 513650 or t.itemid between 513834 and 513839 or t.itemid between 513843 and 513854 or t.itemid between 514040 and 514045 or t.itemid between 514049 and 514060 or t.itemid between 514380 and 514386 or t.itemid between 514390 and 514401 or t.itemid between 514588 and 514594 or t.itemid between 514598 and 514609 or t.itemid between 514794 and 514799 or t.itemid between 514803 and 514814 or t.itemid between 514949 and 514954 or t.itemid between 514958 and 514969 or t.itemid between 515153 and 515158 or t.itemid between 515162 and 515173 or t.itemid between 515361 and 515366 or t.itemid between 515370 and 515381 or t.itemid between 515565 and 515570 or t.itemid between 515574 and 515585 or t.itemid between 515771 and 515776 or t.itemid between 515780 and 515791 or t.itemid between 516629 and 516634 or t.itemid between 516638 and 516649 or t.itemid between 516833 and 516838 or t.itemid between 516842 and 516853 or t.itemid between 517041 and 517046 or t.itemid between 517050 and 517061 or t.itemid between 517247 and 517252 or t.itemid between 517256 and 517267 or t.itemid between 517451 and 517456 or t.itemid between 517460 and 517471 or t.itemid between 517657 and 517662 or t.itemid between 517666 and 517677 or t.itemid between 517861 and 517866 or t.itemid between 517870 and 517881 or t.itemid between 518065 and 518070 or t.itemid between 518074 and 518085 or t.itemid between 518269 and 518274 or t.itemid between 518278 and 518289 or t.itemid between 518473 and 518478 or t.itemid between 518482 and 518493 or t.itemid between 518677 and 518682 or t.itemid between 518686 and 518697 or t.itemid between 518881 and 518886 or t.itemid between 518890 and 518901 or t.itemid between 519415 and 519420 or t.itemid between 519424 and 519435 or t.itemid between 519619 and 519625 or t.itemid between 519629 and 519640 or t.itemid between 519716 and 519759 or t.itemid between 519913 and 519918 or t.itemid between 519922 and 519933 or t.itemid between 520117 and 520122 or t.itemid between 520126 and 520137 or t.itemid between 520321 and 520326 or t.itemid between 520330 and 520341 or t.itemid between 520484 and 520490 or t.itemid between 520494 and 520505 or t.itemid between 520719 and 520724 or t.itemid between 520728 and 520739 or t.itemid between 521165 and 521170 or t.itemid between 521174 and 521185 or t.itemid between 521369 and 521374 or t.itemid between 521378 and 521389 or t.itemid between 521589 and 521594 or t.itemid between 521598 and 521609 or t.itemid between 521949 and 521954 or t.itemid between 521958 and 521969 or t.itemid between 522157 and 522163 or t.itemid between 522167 and 522178 or t.itemid between 522365 and 522370 or t.itemid between 522374 and 522385 or t.itemid between 522476 and 522481 or t.itemid between 522667 and 522798 or t.itemid between 523005 and 523010 or t.itemid between 523014 and 523025 or t.itemid between 523209 and 523214 or t.itemid between 523218 and 523229 or t.itemid between 523413 and 523418 or t.itemid between 523422 and 523433 or t.itemid between 524050 and 524055 or t.itemid between 524059 and 524070 or t.itemid between 524476 and 524481 or t.itemid between 524485 and 524496 or t.itemid between 524684 and 524689 or t.itemid between 524693 and 524704 or t.itemid between 525022 and 525027 or t.itemid between 525031 and 525042 or t.itemid between 525226 and 525231 or t.itemid between 525235 and 525246 or t.itemid between 525826 and 525831 or t.itemid between 525835 and 525846 or t.itemid between 526040 and 526047 or t.itemid between 526051 and 526062 or t.itemid between 526243 and 526341 or t.itemid between 526444 and 526449 or t.itemid between 526453 and 526464 or t.itemid between 526648 and 526653 or t.itemid between 526657 and 526668 or t.itemid between 526852 and 526857 or t.itemid between 526861 and 526872 or t.itemid between 527056 and 527061 or t.itemid between 527065 and 527076 or t.itemid between 527260 and 527265 or t.itemid between 527269 and 527280 or t.itemid between 527466 and 527471 or t.itemid between 527475 and 527486 or t.itemid between 527672 and 527678 or t.itemid between 527682 and 527693 or t.itemid between 527880 and 527885 or t.itemid between 527889 and 527900 or t.itemid between 528084 and 528089 or t.itemid between 528093 and 528104 or t.itemid between 528288 and 528294 or t.itemid between 528298 and 528309 or t.itemid between 528496 and 528501 or t.itemid between 528505 and 528516 or t.itemid between 528700 and 528705 or t.itemid between 528709 and 528720 or t.itemid between 528904 and 528909 or t.itemid between 528913 and 528924 or t.itemid between 529108 and 529114 or t.itemid between 529118 and 529129 or t.itemid between 529314 and 529319 or t.itemid between 529323 and 529334 or t.itemid between 529540 and 529567 or t.itemid between 529571 and 529582 or t.itemid between 529768 and 529774 or t.itemid between 529778 and 529789 or t.itemid between 529974 and 529979 or t.itemid between 529983 and 529994 or t.itemid between 530178 and 530183 or t.itemid between 530187 and 530198 or t.itemid between 530386 and 530391 or t.itemid between 530395 and 530406 or t.itemid between 530592 and 530597 or t.itemid between 530601 and 530612 or t.itemid between 530952 and 530958 or t.itemid between 530962 and 530973 or t.itemid between 531158 and 531164 or t.itemid between 531168 and 531179 or t.itemid between 532178 and 532184 or t.itemid between 532188 and 532199 or t.itemid between 532388 and 532394 or t.itemid between 532398 and 532409 or t.itemid between 533158 and 533163 or t.itemid between 533167 and 533178 or t.itemid between 533593 and 533598 or t.itemid between 533602 and 533613 or t.itemid between 533797 and 533802 or t.itemid between 533806 and 533817 or t.itemid between 534001 and 534006 or t.itemid between 534010 and 534021 or t.itemid between 534223 and 534228 or t.itemid between 534232 and 534243 or t.itemid between 534625 and 534630 or t.itemid between 534634 and 534645 or t.itemid between 534829 and 534834 or t.itemid between 534838 and 534849 or t.itemid between 535051 and 535056 or t.itemid between 535060 and 535071 or t.itemid between 535521 and 535526 or t.itemid between 535530 and 535541 or t.itemid between 535725 and 535730 or t.itemid between 535734 and 535745 or t.itemid between 535878 and 535884 or t.itemid between 535888 and 535899 or t.itemid between 536103 and 536111 or t.itemid between 536115 and 536126 or t.itemid between 536309 and 536407 or t.itemid between 536883 and 536889 or t.itemid between 536893 and 536904 or t.itemid between 537091 and 537097 or t.itemid between 537101 and 537112 or t.itemid between 537265 and 537270 or t.itemid between 537274 and 537285 or t.itemid between 537719 and 537724 or t.itemid between 537728 and 537739 or t.itemid between 538292 and 538297 or t.itemid between 538301 and 538312 or t.itemid between 538500 and 538505 or t.itemid between 538509 and 538520 or t.itemid between 538967 and 538973 or t.itemid between 538977 and 538988 or t.itemid between 539417 and 539422 or t.itemid between 539426 and 539437 or t.itemid between 539623 and 539629 or t.itemid between 539633 and 539644 or t.itemid between 539833 and 539839 or t.itemid between 539843 and 539854 or t.itemid between 540073 and 540078 or t.itemid between 540082 and 540093 or t.itemid between 540409 and 540414 or t.itemid between 540418 and 540429 or t.itemid between 540617 and 540622 or t.itemid between 540626 and 540637 or t.itemid between 540821 and 540826 or t.itemid between 540830 and 540841 or t.itemid between 540885 and 541210 or t.itemid between 541418 and 541424 or t.itemid between 541428 and 541439 or t.itemid between 541848 and 541853 or t.itemid between 541857 and 541868 or t.itemid between 542054 and 542059 or t.itemid between 542063 and 542074 or t.itemid between 543140 and 543145 or t.itemid between 543149 and 543160 or t.itemid between 543344 and 543350 or t.itemid between 543354 and 543365 or t.itemid between 543552 and 543557 or t.itemid between 543561 and 543572 or t.itemid between 544220 and 544225 or t.itemid between 544229 and 544240 or t.itemid between 544426 and 544431 or t.itemid between 544435 and 544446 or t.itemid between 544630 and 544635 or t.itemid between 544639 and 544650 or t.itemid between 544846 and 544851 or t.itemid between 544855 and 544866 or t.itemid between 545605 and 545610 or t.itemid between 545614 and 545625 or t.itemid between 545809 and 545814 or t.itemid between 545818 and 545829 or t.itemid between 546013 and 546018 or t.itemid between 546022 and 546033 or t.itemid between 546235 and 546240 or t.itemid between 546244 and 546255 or t.itemid between 546870 and 547084 or t.itemid between 547088 and 547099 or t.itemid between 547723 and 547729 or t.itemid between 547733 and 547744 or t.itemid between 548039 and 548044 or t.itemid between 548048 and 548059 or t.itemid between 548307 and 548313 or t.itemid between 548317 and 548328 or t.itemid between 548607 and 548612 or t.itemid between 548616 and 548627 or t.itemid between 548811 and 548816 or t.itemid between 548820 and 548831 or t.itemid between 549027 and 549037 or t.itemid between 549041 and 549052 or t.itemid between 549560 and 549669 or t.itemid between 549721 and 549726 or t.itemid between 549730 and 549741 or t.itemid between 550101 and 550106 or t.itemid between 550110 and 550121 or t.itemid between 550305 and 550310 or t.itemid between 550314 and 550325 or t.itemid between 550528 and 550533 or t.itemid between 550537 and 550548 or t.itemid between 550958 and 550963 or t.itemid between 550967 and 550978 or t.itemid between 551111 and 551116 or t.itemid between 551120 and 551131 or t.itemid between 551315 and 551320 or t.itemid between 551324 and 551335 or t.itemid between 551482 and 551495 or t.itemid between 551498 and 551509 or t.itemid between 551581 and 551586 or t.itemid between 551590 and 551601 or t.itemid between 551689 and 551736 or t.itemid between 552091 and 552096 or t.itemid between 552100 and 552111 or t.itemid between 552297 and 552302 or t.itemid between 552306 and 552317 or t.itemid between 552570 and 552576 or t.itemid between 552580 and 552591 or t.itemid between 552902 and 552908 or t.itemid between 552912 and 552923 or t.itemid between 553319 and 553324 or t.itemid between 553328 and 553339 or t.itemid between 553523 and 553528 or t.itemid between 553532 and 553543 or t.itemid between 553646 and 553651 or t.itemid between 553806 and 553812 or t.itemid between 553972 and 553977 or t.itemid between 553981 and 553992 or t.itemid between 554100 and 554176 or t.itemid between 554334 and 554339 or t.itemid between 554343 and 554354 or t.itemid between 554685 and 554690 or t.itemid between 554694 and 554705 or t.itemid between 555022 and 555028 or t.itemid between 555032 and 555043 or t.itemid between 555257 and 555262 or t.itemid between 555266 and 555277 or t.itemid between 555871 and 556090 or t.itemid between 556142 and 556147 or t.itemid between 556151 and 556162 or t.itemid between 556458 and 556463 or t.itemid between 556467 and 556478 or t.itemid between 556731 and 556736 or t.itemid between 556740 and 556751 or t.itemid between 556905 and 556909 or t.itemid between 557146 and 557277 or t.itemid between 557542 and 557547 or t.itemid between 557551 and 557562 or t.itemid between 557748 and 557753 or t.itemid between 557757 and 557768 or t.itemid between 558032 and 558037 or t.itemid between 558041 and 558052 or t.itemid between 558350 and 558356 or t.itemid between 558360 and 558371 or t.itemid between 558505 and 558510 or t.itemid between 558514 and 558525 or t.itemid between 558806 and 558813 or t.itemid between 558817 and 558828 or t.itemid between 559133 and 559209 or t.itemid between 559261 and 559266 or t.itemid between 559270 and 559281 or t.itemid between 559465 and 559470 or t.itemid between 559474 and 559485 or t.itemid between 560366 and 560370 or t.itemid between 560378 and 560710 or t.itemid between 560821 and 560996 or t.itemid between 561634 and 561941 or t.itemid between 562027 and 562038 or t.itemid between 562041 and 562098 or t.itemid between 562454 and 562459 or t.itemid between 562463 and 562474 or t.itemid between 562658 and 562663 or t.itemid between 562667 and 562678 or t.itemid between 562976 and 563140 or t.itemid between 563192 and 563197 or t.itemid between 563201 and 563212 or t.itemid between 563596 and 563601 or t.itemid between 563605 and 563616 or t.itemid between 563816 and 563822 or t.itemid between 563826 and 563837 or t.itemid between 564286 and 564291 or t.itemid between 564295 and 564306 or t.itemid between 564714 and 564719 or t.itemid between 564723 and 564734 or t.itemid between 564933 and 564942 or t.itemid between 564946 and 564957 or t.itemid between 565127 and 565214 or t.itemid between 565319 and 565325 or t.itemid between 565329 and 565340 or t.itemid between 565527 and 565532 or t.itemid between 565536 and 565547 or t.itemid between 565731 and 565736 or t.itemid between 565740 and 565751 or t.itemid between 565950 and 566043 or t.itemid between 566047 and 566058 or t.itemid between 566553 and 566559 or t.itemid between 566563 and 566574 or t.itemid between 566979 and 566984 or t.itemid between 566988 and 566999 or t.itemid between 567511 and 567516 or t.itemid between 567520 and 567531 or t.itemid between 567635 and 567656 or t.itemid between 567939 and 567945 or t.itemid between 567949 and 567960 or t.itemid between 568147 and 568152 or t.itemid between 568156 and 568167 or t.itemid between 568351 and 568356 or t.itemid between 568360 and 568371 or t.itemid between 568728 and 568733 or t.itemid between 568737 and 568748 or t.itemid between 568889 and 568894 or t.itemid between 568898 and 568909 or t.itemid between 569381 and 569386 or t.itemid between 569390 and 569401 or t.itemid between 569923 and 569928 or t.itemid between 569932 and 569943 or t.itemid between 570336 and 570341 or t.itemid between 570345 and 570356 or t.itemid between 570540 and 570545 or t.itemid between 570549 and 570560 or t.itemid between 571118 and 571211 or t.itemid between 571215 and 571226 or t.itemid between 571718 and 571723 or t.itemid between 571727 and 571738 or t.itemid between 571940 and 571945 or t.itemid between 571949 and 571960 or t.itemid between 572123 and 572254 or t.itemid between 572408 and 572413 or t.itemid between 572417 and 572428 or t.itemid between 572848 and 572853 or t.itemid between 572857 and 572868 or t.itemid between 573273 and 573278 or t.itemid between 573282 and 573293 or t.itemid between 573675 and 573680 or t.itemid between 573684 and 573695 or t.itemid between 573879 and 573884 or t.itemid between 573888 and 573899 or t.itemid between 574537 and 574543 or t.itemid between 574547 and 574558 or t.itemid between 575052 and 575058 or t.itemid between 575062 and 575073 or t.itemid between 575434 and 575439 or t.itemid between 575443 and 575454 or t.itemid between 575654 and 575659 or t.itemid between 575663 and 575674 or t.itemid between 575815 and 575924 or t.itemid between 576103 and 576109 or t.itemid between 576113 and 576124 or t.itemid between 576971 and 576976 or t.itemid between 576980 and 576991 or t.itemid between 577278 and 577283 or t.itemid between 577287 and 577298 or t.itemid between 577713 and 577720 or t.itemid between 577724 and 577735 or t.itemid between 577996 and 578116 or t.itemid between 578168 and 578174 or t.itemid between 578178 and 578189 or t.itemid between 578391 and 578396 or t.itemid between 578400 and 578411 or t.itemid between 578764 and 578769 or t.itemid between 578773 and 578784 or t.itemid between 579166 and 579171 or t.itemid between 579175 and 579186 or t.itemid between 579416 and 579422 or t.itemid between 579426 and 579437 or t.itemid between 579755 and 579761 or t.itemid between 579765 and 579776 or t.itemid between 580236 and 580241 or t.itemid between 580245 and 580256 or t.itemid between 580507 and 580726 or t.itemid between 581078 and 581083 or t.itemid between 581087 and 581098 or t.itemid between 581717 and 581728 or t.itemid between 581788 and 581803 or t.itemid between 581807 and 581818 or t.itemid between 582009 and 582063 or t.itemid between 582119 and 582124 or t.itemid between 582128 and 582139 or t.itemid between 583018 and 583024 or t.itemid between 583028 and 583039 or t.itemid between 583793 and 583798 or t.itemid between 583802 and 583813 or t.itemid between 584424 and 584433 or t.itemid between 584437 and 584448 or t.itemid between 584610 and 584686 or t.itemid between 584789 and 584795 or t.itemid between 584799 and 584810 or t.itemid between 584842 and 584951 or t.itemid between 585122 and 585129 or t.itemid between 585133 and 585144 or t.itemid between 585351 and 585526 or t.itemid between 585721 and 585863 or t.itemid between 586023 and 586028 or t.itemid between 586032 and 586043 or t.itemid between 586468 and 586610 or t.itemid between 586699 and 586704 or t.itemid between 586708 and 586719 or t.itemid between 586920 and 586925 or t.itemid between 586929 and 586940 or t.itemid between 587354 and 587359 or t.itemid between 587363 and 587374 or t.itemid between 587411 and 587608 or t.itemid between 587872 and 587877 or t.itemid between 587881 and 587892 or t.itemid between 589004 and 589009 or t.itemid between 589013 and 589024 or t.itemid between 589692 and 589697 or t.itemid between 589701 and 589712 or t.itemid between 589896 and 589902 or t.itemid between 589906 and 589917 or t.itemid between 590016 and 590029 or t.itemid between 590095 and 590103 or t.itemid between 590155 and 590160 or t.itemid between 590164 and 590175 or t.itemid between 590216 and 590229 or t.itemid between 590442 and 590551 or t.itemid between 590841 and 590846 or t.itemid between 590850 and 590861 or t.itemid between 591071 and 591257 or t.itemid between 591566 and 591571 or t.itemid between 591575 and 591586 or t.itemid between 591770 and 591775 or t.itemid between 591779 and 591790 or t.itemid between 592337 and 592464 or t.itemid between 592468 and 592479 or t.itemid between 592681 and 592694 or t.itemid between 592698 and 592709 or t.itemid between 592795 and 592849 or t.itemid between 593271 and 593540 or t.itemid between 593544 and 593555 or t.itemid between 593776 and 593863 or t.itemid between 593923 and 593928 or t.itemid between 593932 and 593943 or t.itemid between 594919 and 594925 or t.itemid between 594929 and 594940 or t.itemid between 595125 and 595130 or t.itemid between 595134 and 595145 or t.itemid between 595377 and 595382 or t.itemid between 595386 and 595397 or t.itemid between 595602 and 595608 or t.itemid between 595612 and 595623 or t.itemid between 596043 and 596130 or t.itemid between 596182 and 596187 or t.itemid between 596191 and 596202 or t.itemid between 596430 and 596435 or t.itemid between 596439 and 596450 or t.itemid between 596741 and 596746 or t.itemid between 596750 and 596761 or t.itemid between 596914 and 596918 or t.itemid between 596971 and 596977 or t.itemid between 596981 and 596992 or t.itemid between 597100 and 597172 or t.itemid in (522471,522472,522473,522474,525979,525980,525981,525982,525984,52598 5,525986,525987,536039,536040,536041,536042,536048,536049,536158,5408 74,540875,540876,540877,540879,540880,540881,540882,541268,541269,548 968,548969,548970,548971,549347,551739,551740,553871,553872,554179,55 4180,556786,556787,556788,556789,556962,558801,558802,558803,558804,5 58861,558862,558863,559004,560372,560373,560374,560375,562101,562102, 564871,564872,564873,564874,564876,564877,571773,571774,571775,571776 ,571778,571779,571833,571834,571835,571888,575540,575541,575542,57554 3,575545,575546,575547,575548,575601,575602,575927,575928,577708,5777 09,577710,577711,577768,577769,577770,577823,581849,581850,581851,582 066,582067,584365,584366,584367,584368,584480,584481,585007,585008,58 5009,585010,585066,585067,585068,585069,590032,590033,590034,590035,5 92615,592616,592618,592619,592677,592678,592852,592853,596855,596856, 596857,596858)) Rationale The SQL spent 100% of its database time on CPU, I/O and Cluster waits. This part of database time may be improved by the SQL Tuning Advisor. Rationale Database time for this SQL was divided as follows: 100% for SQL execution, 0% for parsing, 0% for PL/SQL execution and 0% for Java execution. Rationale SQL statement with SQL_ID "1tv34b559thby" was executed 10 times and had an average elapsed time of 16 seconds. Rationale At least one execution of the statement ran in parallel. Finding 2: Hard Parse Impact is .09 active sessions, 2.1% of total activity. ------------------------------------------------------ Hard parsing of SQL statements was consuming significant database time. Hard parses due to cursor environment mismatch were not consuming significant database time. Hard parsing SQL statements that encountered parse errors was not consuming significant database time. Hard parses due to literal usage and cursor invalidation were not consuming significant database time. The SGA was adequately sized. No recommendations are available. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Additional Information ---------------------- Miscellaneous Information ------------------------- Wait class "Application" was not consuming significant database time. Wait class "Cluster" was not consuming significant database time. Wait class "Commit" was not consuming significant database time. Wait class "Concurrency" was not consuming significant database time. Wait class "Configuration" was not consuming significant database time. CPU was not a bottleneck for the instance. Wait class "Network" was not consuming significant database time. Wait class "User I/O" was not consuming significant database time. The network latency of the cluster interconnect was within acceptable limits of 1 milliseconds. Session connect and disconnect calls were not consuming significant database time.