Worldwide Secure Search All Blogs CRM On Demand Discussion Forums Documentation Education Oracle.com PartnerNetwork Technology Network Video and Multimedia Home Products and Services Industries Support Store Partners Communities About

TECHNOLOGY PRODUCTS APPLICATION PRODUCTS FUSION APPLICATIONS ORACLE SERVICES CUSTOMERS | PARTNERS ORACLE CORPORATION Legal | Privacy Worldwide Sites Africa Operation Argentina Australia Austria Bahrain Bangladesh Belgium & Luxembourg Belize Bhutan Bolivia Bosnia & Herzegovina Brasil Brunei Bulgaria Cambodia Canada - English Canada - French Chile China Colombia Costa Rica Croatia Czech Republic Denmark Ecuador Egypt Estonia Finland France Germany Greece Guatemala Honduras Hong Kong Hungary India Indonesia Iraq Ireland Israel Italy Japan Jordan Kazakhstan Korea Kuwait Laos Latvia Lebanon Lithuania Malaysia Maldives Malta Mexico Moldova Nepal Netherlands New Zealand Nicaragua Norway Oman Pakistan Panama Paraguay Peru Philippines Poland Portugal Puerto Rico Qatar Romania Russia Saudi Arabia Serbia & Montenegro Singapore Slovakia Slovenia South Africa Spain Sri Lanka Sweden Switzerland -- French Switzerland -- German Taiwan Thailand Turkey Ukraine United Arab Emirates United Kingdom United States Uraguay Venezuela Vietnam Yemen

WORKLOAD REPOSITORY report for DB Name DB Id Instance Inst num Release RAC Host VIS 193532335 VIS 1 10.2.0.3.0 NO db Snap Id Snap Time Sessions Cursors/Session Begin Snap: 2570 02-Sep-08 15:57:01 60 29.1 End Snap: 2571 02-Sep-08 16:02:57 60 29.4 Elapsed:   5.94 (mins)     DB Time:   25.50 (mins)     Report Summary Cache Sizes Begin End Buffer Cache: 4,096M 4,096M Std Block Size: 8K Shared Pool Size: 2,048M 2,048M Log Buffer: 14,348K Load Profile Per Second Per Transaction Redo size: 1,962,688.86 47,548.14 Logical reads: 364,799.42 8,837.64 Block changes: 13,796.73 334.24 Physical reads: 1.58 0.04 Physical writes: 0.07 0.00 User calls: 2,660.56 64.45 Parses: 2,101.68 50.92 Hard parses: 0.36 0.01 Sorts: 1,982.43 48.03 Logons: 0.20 0.00 Executes: 25,458.60 616.76 Transactions: 41.28   % Blocks changed per Read: 3.78 Recursive Call %: 95.20 Rollback per transaction %: 0.00 Rows per Sort: 1.94 Instance Efficiency Percentages (Target 100%) Buffer Nowait %: 99.95 Redo NoWait %: 100.00 Buffer Hit %: 100.00 In-memory Sort %: 100.00 Library Hit %: 99.90 Soft Parse %: 99.98 Execute to Parse %: 91.74 Latch Hit %: 96.43 Parse CPU to Parse Elapsd %: 37.87 % Non-Parse CPU: 99.52 Shared Pool Statistics Begin End Memory Usage %: 19.71 20.00 % SQL with executions>1: 92.30 91.16 % Memory for SQL w/exec>1: 92.21 87.80 Top 5 Timed Events Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class CPU time   949   62.0   enq: UL - contention 653 23 36 1.5 Application log file parallel write 13,417 8 1 .5 System I/O log file sync 5,881 7 1 .5 Commit buffer busy waits 69,348 2 0 .1 Concurrency Main Report Report Summary Wait Events Statistics SQL Statistics Instance Activity Statistics IO Stats Buffer Pool Statistics Advisory Statistics Wait Statistics Undo Statistics Latch Statistics Segment Statistics Dictionary Cache Statistics Library Cache Statistics Memory Statistics Streams Statistics Resource Limit Statistics init.ora Parameters Back to Top Wait Events Statistics Time Model Statistics Wait Class Wait Events Background Wait Events Operating System Statistics Service Statistics Service Wait Class Stats Back to Top Time Model Statistics Total time in database user-calls (DB Time): 1530s Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic Ordered by % or DB time desc, Statistic name Statistic Name Time (s) % of DB Time sql execute elapsed time 1,506.37 98.46 DB CPU 949.31 62.05 PL/SQL execution elapsed time 476.96 31.17 parse time elapsed 14.31 0.94 hard parse elapsed time 0.73 0.05 repeated bind elapsed time 0.68 0.04 inbound PL/SQL rpc elapsed time 0.44 0.03 sequence load elapsed time 0.18 0.01 PL/SQL compilation elapsed time 0.14 0.01 connection management call elapsed time 0.13 0.01 hard parse (sharing criteria) elapsed time 0.13 0.01 hard parse (bind mismatch) elapsed time 0.00 0.00 DB time 1,529.98   background elapsed time 12.84   background cpu time 3.38   Back to Wait Events Statistics Back to Top Wait Class s - second cs - centisecond - 100th of a second ms - millisecond - 1000th of a second us - microsecond - 1000000th of a second ordered by wait time desc, waits desc Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn Application 1,051 0.67 24 23 0.07 System I/O 15,301 0.00 8 1 1.04 Commit 5,881 0.00 7 1 0.40 Concurrency 92,668 0.09 4 0 6.30 User I/O 611 0.00 1 2 0.04 Network 919,266 0.00 1 0 62.49 Other 7,237 79.88 0 0 0.49 Configuration 353 0.00 0 0 0.02 Back to Wait Events Statistics Back to Top Wait Events s - second cs - centisecond - 100th of a second ms - millisecond - 1000th of a second us - microsecond - 1000000th of a second ordered by wait time desc, waits desc (idle events last) Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn enq: UL - contention 653 1.07 23 36 0.04 log file parallel write 13,417 0.00 8 1 0.91 log file sync 5,881 0.00 7 1 0.40 buffer busy waits 69,348 0.00 2 0 4.71 db file sequential read 501 0.00 1 2 0.03 cursor: pin S wait on X 129 64.34 1 6 0.01 SQL*Net message to client 889,320 0.00 1 0 60.45 enq: TX - index contention 2,898 0.00 1 0 0.20 latch: cache buffers chains 18,931 0.00 0 0 1.29 SQL*Net more data from client 29,187 0.00 0 0 1.98 db file scattered read 69 0.00 0 4 0.00 control file sequential read 1,717 0.00 0 0 0.12 enq: TX - row lock contention 324 0.00 0 1 0.02 control file parallel write 167 0.00 0 1 0.01 latch: In memory undo latch 1,325 0.00 0 0 0.09 read by other session 17 0.00 0 4 0.00 enq: SQ - contention 340 0.00 0 0 0.02 rdbms ipc reply 84 0.00 0 0 0.01 os thread startup 1 0.00 0 17 0.00 SQL*Net more data to client 759 0.00 0 0 0.05 SQL*Net break/reset to client 74 0.00 0 0 0.01 buffer deadlock 5,835 99.07 0 0 0.40 latch: undo global data 16 0.00 0 0 0.00 enq: US - contention 1 0.00 0 5 0.00 latch: library cache 27 0.00 0 0 0.00 direct path write 23 0.00 0 0 0.00 latch free 32 0.00 0 0 0.00 enq: HW - contention 11 0.00 0 0 0.00 latch: redo allocation 5 0.00 0 1 0.00 LGWR wait for redo copy 284 0.00 0 0 0.02 cursor: pin S 971 0.00 0 0 0.07 latch: library cache lock 5 0.00 0 0 0.00 latch: enqueue hash chains 3 0.00 0 0 0.00 latch: cache buffer handles 3 0.00 0 0 0.00 latch: library cache pin 4 0.00 0 0 0.00 direct path read 1 0.00 0 0 0.00 latch: session allocation 3 0.00 0 0 0.00 enq: TX - allocate ITL entry 2 0.00 0 0 0.00 SQL*Net message from client 889,320 0.00 9,186 10 60.45 pipe get 143 100.00 350 2445 0.01 Streams AQ: qmn slave idle wait 52 0.00 347 6667 0.00 Streams AQ: qmn coordinator idle wait 122 48.36 347 2842 0.01 PL/SQL lock timer 88 100.00 344 3906 0.01 jobq slave wait 20 100.00 59 2930 0.00 Back to Wait Events Statistics Back to Top Background Wait Events ordered by wait time desc, waits desc (idle events last) Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn log file parallel write 13,417 0.00 8 1 0.91 control file parallel write 166 0.00 0 1 0.01 os thread startup 1 0.00 0 17 0.00 control file sequential read 72 0.00 0 0 0.00 events in waitclass Other 290 0.00 0 0 0.02 rdbms ipc message 12,009 9.43 2,768 231 0.82 smon timer 131 0.00 403 3080 0.01 pmon timer 141 100.00 349 2473 0.01 Streams AQ: qmn slave idle wait 52 0.00 347 6667 0.00 Streams AQ: qmn coordinator idle wait 122 48.36 347 2842 0.01 Back to Wait Events Statistics Back to Top Operating System Statistics Statistic Total NUM_LCPUS 0 NUM_VCPUS 0 AVG_BUSY_TIME 19,976 AVG_IDLE_TIME 15,709 AVG_IOWAIT_TIME 13 AVG_SYS_TIME 1,714 AVG_USER_TIME 18,249 BUSY_TIME 159,898 IDLE_TIME 125,765 IOWAIT_TIME 126 SYS_TIME 13,809 USER_TIME 146,089 LOAD 0 OS_CPU_WAIT_TIME 146,200 RSRC_MGR_CPU_WAIT_TIME 0 PHYSICAL_MEMORY_BYTES 33,420,214,272 NUM_CPUS 8 NUM_CPU_CORES 4 Back to Wait Events Statistics Back to Top Service Statistics ordered by DB Time Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads VIS 1,527.30 947.80 143 129,968,322 SYS$USERS 2.70 1.50 481 40,878 SYS$BACKGROUND 0.00 0.00 0 1,304 Back to Wait Events Statistics Back to Top Service Wait Class Stats Wait Class info for services in the Service Statistics section. Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network Time Waited (Wt Time) in centisecond (100th of a second) Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time VIS 72 44 92666 360 0 0 919040 98 SYS$USERS 539 79 0 0 0 0 19 0 SYS$BACKGROUND 0 0 1 1 0 0 0 0 Back to Wait Events Statistics Back to Top SQL Statistics SQL ordered by Elapsed Time SQL ordered by CPU Time SQL ordered by Gets SQL ordered by Reads SQL ordered by Executions SQL ordered by Parse Calls SQL ordered by Sharable Memory SQL ordered by Version Count Complete List of SQL Text Back to Top SQL ordered by Elapsed Time Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text 1,050 522 9,993 0.11 68.60 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 1,049 521 9,987 0.11 68.58 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 88 79 9,638 0.01 5.74 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro... 80 80 278,963 0.00 5.24 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 79 75 9,993 0.01 5.19 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 66 66 9,898 0.01 4.30 80wvw6gatjvb2 PYUSLV SELECT PTP_TD.START_DATE FROM ... 51 51 59,695 0.00 3.36 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 46 24 40 1.14 2.97 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 38 38 169,830 0.00 2.49 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 37 37 149,566 0.00 2.41 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 31 31 44,555 0.00 2.05 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 22 22 477,247 0.00 1.45 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 20 20 109,969 0.00 1.34 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 20 20 477,086 0.00 1.33 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 19 19 10,000 0.00 1.27 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r... 19 19 9,979 0.00 1.27 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL... 19 19 429,056 0.00 1.22 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 18 19 477,334 0.00 1.21 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 18 18 699,161 0.00 1.17 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 18 18 9,956 0.00 1.15 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ... 16 16 9,947 0.00 1.06 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA... Back to SQL Statistics Back to Top SQL ordered by CPU Time Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100 CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total DB Time SQL Id SQL Module SQL Text 522 1,050 9,993 0.05 68.60 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 521 1,049 9,987 0.05 68.58 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 80 80 278,963 0.00 5.24 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 79 88 9,638 0.01 5.74 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro... 75 79 9,993 0.01 5.19 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 66 66 9,898 0.01 4.30 80wvw6gatjvb2 PYUSLV SELECT PTP_TD.START_DATE FROM ... 51 51 59,695 0.00 3.36 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 38 38 169,830 0.00 2.49 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 37 37 149,566 0.00 2.41 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 31 31 44,555 0.00 2.05 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 24 46 40 0.60 2.97 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 22 22 477,247 0.00 1.45 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 20 20 109,969 0.00 1.34 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 20 20 477,086 0.00 1.33 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 19 19 10,000 0.00 1.27 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r... 19 19 9,979 0.00 1.27 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL... 19 19 429,056 0.00 1.22 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 19 18 477,334 0.00 1.21 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 18 18 699,161 0.00 1.17 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 18 18 9,956 0.00 1.15 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ... 16 16 9,947 0.00 1.06 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA... Back to SQL Statistics Back to Top SQL ordered by Gets Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code. Total Buffer Gets: 130,010,501 Captured SQL account for 70.8% of Total Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 87,591,250 9,993 8,765.26 67.37 521.53 1049.55 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 87,416,258 9,987 8,753.00 67.24 521.42 1049.24 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 15,921,220 278,963 57.07 12.25 80.22 80.22 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 9,501,117 9,638 985.80 7.31 79.09 87.81 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro... 8,449,232 59,695 141.54 6.50 51.44 51.43 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 7,718,761 9,898 779.83 5.94 65.74 65.86 80wvw6gatjvb2 PYUSLV SELECT PTP_TD.START_DATE FROM ... 6,429,425 149,566 42.99 4.95 36.92 36.91 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 5,376,001 9,993 537.98 4.14 74.94 79.33 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 5,269,088 477,247 11.04 4.05 22.26 22.25 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 4,938,019 44,555 110.83 3.80 31.32 31.30 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 4,841,927 40 121,048.18 3.72 24.10 45.52 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 4,727,746 429,056 11.02 3.64 18.73 18.73 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 4,040,063 477,334 8.46 3.11 18.51 18.48 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 3,918,958 477,086 8.21 3.01 20.37 20.30 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 3,483,174 583,159 5.97 2.68 13.65 13.64 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '... 2,778,575 10,000 277.86 2.14 19.45 19.45 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r... 2,224,841 9,982 222.89 1.71 11.08 11.08 02dvcwb36048p PYUSLV UPDATE PAY_ACTION_INFORMATION ... 2,146,136 9,991 214.81 1.65 10.24 10.24 cj64zg9gg7780 PYUSLV SELECT ACTION_INFORMATION_ID ,... 2,096,082 699,161 3.00 1.61 17.85 17.85 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 1,998,775 109,969 18.18 1.54 20.45 20.48 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 1,840,232 9,962 184.73 1.42 13.41 13.40 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS... 1,805,038 9,947 181.47 1.39 16.22 16.22 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA... 1,722,982 123,340 13.97 1.33 10.54 10.54 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ... 1,645,054 9,979 164.85 1.27 19.42 19.44 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL... 1,643,481 169,830 9.68 1.26 38.08 38.08 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 1,486,620 124,488 11.94 1.14 11.60 11.60 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR... Back to SQL Statistics Back to Top SQL ordered by Reads Total Disk Reads: 563 Captured SQL account for 10.1% of Total Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 75 40 1.88 13.32 24.10 45.52 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 30 500 0.06 5.33 4.73 4.91 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio... 29 9,987 0.00 5.15 521.42 1049.24 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 29 9,993 0.00 5.15 521.53 1049.55 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 29 109,969 0.00 5.15 20.45 20.48 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 13 1 13.00 2.31 0.01 0.07 31a13pnjps7j3   SELECT source, (case w... 7 1 7.00 1.24 0.02 0.03 cf621qmts91wf   SELECT /*+ ordered use_nl(stat... 6 10,000 0.00 1.07 2.14 2.14 dqd80d97sjck0 PYUSLV update pay_latest_balances se... 1 1 1.00 0.18 0.04 0.05 0dwr2vd6vbqzs   SELECT count(*) over () as tot... 1 1 1.00 0.18 0.03 0.04 dgyj6z7xacxjm   SELECT /*+ ordered use_nl(stat... Back to SQL Statistics Back to Top SQL ordered by Executions Total Executions: 9,073,164 Captured SQL account for 52.8% of Total Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text 699,161 1,163,723 1.66 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 583,159 577,832 0.99 0.00 0.00 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '... 477,334 478,600 1.00 0.00 0.00 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 477,247 956,074 2.00 0.00 0.00 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 477,086 475,255 1.00 0.00 0.00 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 429,056 429,357 1.00 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 278,963 274,490 0.98 0.00 0.00 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 169,830 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 149,566 149,065 1.00 0.00 0.00 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 124,488 123,437 0.99 0.00 0.00 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR... 123,340 0 0.00 0.00 0.00 bm8gwn43tn8hd PYUSLV SELECT PLB.LATEST_BALANCE_ID, ... 109,969 109,943 1.00 0.00 0.00 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... Back to SQL Statistics Back to Top SQL ordered by Parse Calls Total Parse Calls: 749,014 Captured SQL account for 91.5% of Total Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text 279,301 278,963 37.29 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 149,806 149,566 20.00 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 59,700 59,695 7.97 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 44,788 44,555 5.98 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 29,899 29,933 3.99 264qzrka8fsps PYUSLV SELECT NVL(SUM(prb.balance_val... 19,975 19,953 2.67 83kbt99vg4svq PYUSLV begin ... 19,569 19,892 2.61 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val... 9,997 9,993 1.33 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 9,993 9,987 1.33 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 9,991 9,993 1.33 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 9,964 9,934 1.33 97mt0g20bcfc3 PYUSLV begin ... 9,931 9,934 1.33 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim... 9,917 9,933 1.32 36z3h9rgkd8aa PYUSLV begin ... 9,779 9,765 1.31 d7shgtk3p7s4u PYUSLV SELECT /*+ ordered index(BAL... 8,901 8,901 1.19 cr74qtm56vcq6 NACHA BEGIN PAY_US_NACHA_TAPE.RUN_FO... Back to SQL Statistics Back to Top SQL ordered by Sharable Memory No data exists for this section of the report. Back to SQL Statistics Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01pkua627ktjk	SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y')
02dvcwb36048p	UPDATE PAY_ACTION_INFORMATION SET ACTION_INFORMATION_ID = :B1 , OBJECT_VERSION_NUMBER = :B32 , ACTION_INFORMATION1 = :B31 , ACTION_INFORMATION2 = :B30 , ACTION_INFORMATION3 = :B29 , ACTION_INFORMATION4 = :B28 , ACTION_INFORMATION5 = :B27 , ACTION_INFORMATION6 = :B26 , ACTION_INFORMATION7 = :B25 , ACTION_INFORMATION8 = :B24 , ACTION_INFORMATION9 = :B23 , ACTION_INFORMATION10 = :B22 , ACTION_INFORMATION11 = :B21 , ACTION_INFORMATION12 = :B20 , ACTION_INFORMATION13 = :B19 , ACTION_INFORMATION14 = :B18 , ACTION_INFORMATION15 = :B17 , ACTION_INFORMATION16 = :B16 , ACTION_INFORMATION17 = :B15 , ACTION_INFORMATION18 = :B14 , ACTION_INFORMATION19 = :B13 , ACTION_INFORMATION20 = :B12 , ACTION_INFORMATION21 = :B11 , ACTION_INFORMATION22 = :B10 , ACTION_INFORMATION23 = :B9 , ACTION_INFORMATION24 = :B8 , ACTION_INFORMATION25 = :B7 , ACTION_INFORMATION26 = :B6 , ACTION_INFORMATION27 = :B5 , ACTION_INFORMATION28 = :B4 , ACTION_INFORMATION29 = :B3 , ACTION_INFORMATION30 = :B2 WHERE ACTION_INFORMATION_ID = :B1
02k10jzw8c495	SELECT INTLK.LOCKING_ACTION_ID FROM PAY_ACTION_INTERLOCKS INTLK, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA WHERE INTLK.LOCKED_ACTION_ID = :B1 AND INTLK.LOCKING_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.ACTION_TYPE IN ('P', 'U') AND PAA.SOURCE_ACTION_ID IS NULL
0dwr2vd6vbqzs	SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
165d2bgc2b9hr	SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment within a Government Reporting Entity for YTD based on run balances */ pay_run_balances prb, pay_defined_balances pdb, pay_payroll_actions ppa, pay_assignment_actions paa where paa.assignment_action_id = :ASSIGNMENT_ACTION_ID and prb.tax_unit_id = :TAX_UNIT_ID and ppa.payroll_action_id = paa.payroll_action_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id and paa.assignment_id = prb.assignment_id and prb.action_sequence <= paa.action_sequence and prb.effective_date >= trunc(ppa.effective_date, 'Y')
264qzrka8fsps	SELECT NVL(SUM(prb.balance_value), 0) FROM /* US Assignment for Run based on run balances */ pay_run_balances prb, pay_defined_balances pdb where prb.assignment_action_id = :ASSIGNMENT_ACTION_ID and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2 and pdb.defined_balance_id = prb.defined_balance_id
2z261p0p82p32	BEGIN FFP51704_01010001.FORMULA( :N3, :I7, :N2, :T1, :I1, :T5, :I5, :T4, :I4, :N8, :I12, :T3, :I3, :T8, :I14, :N6, :I10, :T7, :I13, :N4, :I8, :D1, :N12, :I18, :N10, :I16, :N7, :I11, :N11, :I17, :T6, :I6, :N1, :T2, :I2, :N5, :I9, :N9, :I15, :FFERLN, :FFERCD, :FFERMT); END;
31a13pnjps7j3	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < (SELECT cast(s1.end_interval_time as date) FROM WRM$_SNAPSHOT s1 WHERE s1.dbid = :dbid AND s1.instance_number = :inst_num AND s1.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation , l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= (SELECT cast(s2.end_interval_time as date) FROM WRM$_SNAPSHOT s2 WHERE s2.dbid = :dbid AND s2.instance_number = :inst_num AND s2.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= (SELECT cast(s3.end_interval_time as date) FROM WRM$_SNAPSHOT s3 WHERE s3.dbid = :dbid AND s3.instance_number = :inst_num AND s3.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - cast(s4.end_interval_time as date)) * 86400) as time_secs, decode(s4.snap_id, :bid, 2 , 3 ) as operation, 0 as log_id FROM WRM$_SNAPSHOT s4 WHERE s4.dbid = :dbid AND s4.instance_number = :inst_num AND s4.snap_id in (:bid, :eid) ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC
36z3h9rgkd8aa	begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3n5uwzsh3y8gr	SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N'), 'S ', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_type_id = :U1 and pdb.balance_dimension_id = :U2
3rg5fyfgd5uwc	begin pay_US_rules.get_time_def_for_entry( :element_entry_id, :assignment_id, :assignment_action_id, :business_group_id, :time_def_id); end;
4ds53shhfcynn	declare begin hr_pre_pay.do_prepayment(:p1, :p2, :p3, :p4, :5, :p6:p6ind, :p7); end;
4f5mjr4hnaz3u	declare begin pay_archive.process_employee(:asg_action); end;
4gz4b2bh1fs14	SELECT CONTEXT_ID, SEQUENCE_NO FROM FF_ROUTE_CONTEXT_USAGES WHERE ROUTE_ID = :B1 ORDER BY SEQUENCE_NO
5sfm6rppc4y8x	BEGIN pay_us_action_arch.action_archive_data(:aactid, :l_effective_date); END;
5w5up6vdp2qyp	SELECT RP.SEQUENCE_NO, RPV.VALUE FROM FF_ROUTE_PARAMETER_VALUES RPV , FF_ROUTE_PARAMETERS RP WHERE RPV.USER_ENTITY_ID = :B2 AND RP.ROUTE_ID = :B1 AND RPV.ROUTE_PARAMETER_ID = RP.ROUTE_PARAMETER_ID ORDER BY RP.SEQUENCE_NO
6500rnmy4f88w	SELECT PAP.ACCRUAL_PLAN_ID, PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID FROM PAY_ACCRUAL_PLANS PAP, PAY_ELEMENT_LINKS_F PEL, PAY_ELEMENT_ENTRIES_F PEE WHERE PAP.ACCRUAL_CATEGORY = :B3 AND PEL.ELEMENT_TYPE_ID= PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID AND :B1 BETWEEN PEL.EFFECTIVE_START_DATE AND PEL.EFFECTIVE_END_DATE AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID AND PEE.ASSIGNMENT_ID = :B2 AND :B1 BETWEEN PEE.EFFECTIVE_START_DATE AND PEE.EFFECTIVE_END_DATE
6v07302134wyf	INSERT INTO PAY_ACTION_INFORMATION (ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 ) VALUES (:B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
7d66dw0vz7yaa	begin pay_cc_process_utils . reset_dates_for_run ( p_asg_id => :v_asg_id , p_sysdate => to_date ( :v_sysdate , :date_format ) , p_assact_id => :v_assact_id ) ; end ;
7mmdd7sypzu9x	BEGIN FFP1893_01010001.FORMULA( :N1, :N2, :T1, :I1, :D1, :T2, :I2, :T7, :I7, :T8, :I8, :T5, :I5, :N5, :T4, :I4, :N4, :N3, :T3, :I3, :T6, :I6, :FFERLN, :FFERCD, :FFERMT); END;
7y9t68kb4mc6q	BEGIN pay_us_action_arch.action_action_creation(:pactid, :stperson, :endperson, :chunk); END;
80wvw6gatjvb2	SELECT PTP_TD.START_DATE FROM PER_TIME_PERIODS PTP_TD, PAY_ASSIGNMENT_ACTIONS PAA, PAY_PAYROLL_ACTIONS PPA, PER_TIME_PERIODS PTP_PPA WHERE PTP_TD.TIME_DEFINITION_ID = :B2 AND PAA.ASSIGNMENT_ACTION_ID = :B1 AND PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID AND PPA.PAYROLL_ID = PTP_PPA.PAYROLL_ID AND PPA.DATE_EARNED BETWEEN PTP_PPA.START_DATE AND PTP_PPA.END_DATE AND PTP_TD.START_DATE > PTP_PPA.START_DATE AND PTP_TD.START_DATE <= PTP_PPA.END_DATE
83kbt99vg4svq	begin hr_nonrun_asact.reinterlock (:assactid, :pactype); end;
8v2cvg5zhw9ua	SELECT fnd_number.number_to_canonical(nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)) FROM /* Assignment within Government Reporting Entity */ pay_run_result_values TARGET , pay_balance_feeds_f FEED , pay_run_results RR , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + decode(TARGET.INPUT_VALUE_ID, null, 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and ASSACT.action_sequence <= BAL_ASSACT.action_sequence and ASSACT.assignment_id = BAL_ASSACT.assignment_id and ASSACT.tax_unit_id = :TAX_UNIT_ID /* Year To Date */ and PACT.effective_date >= trunc(BACT.effective_date, 'Y') /* Within Jurisdiction */ and :JURISDICTION_LEVEL != 0 and substr (RR.jurisdiction_code, 1, :JURISDICTION_LEVEL) = substr (:JURISDICTION_CODE, 1, :JURISDICTION_LEVEL)
97mt0g20bcfc3	begin pay_US_rules.get_default_jurisdiction (:asgact, :eeid, :defval:defvalind); end;
9jv68n0ctas75	begin pay_core_utils . get_prorated_dates ( :ee_id , :asg_act_id , :time_def_type , :time_def_id:time_def_ind , :pro_dates:prod_ind , :pro_types:prot_ind ) ; END ;
bm8gwn43tn8hd	SELECT PLB.LATEST_BALANCE_ID, PLB.ASSIGNMENT_ACTION_ID, PLB.VALUE, PLB.EXPIRY_DATE, ACT.ACTION_SEQUENCE CURRENT_ACTION_SEQ, OWN_ACT.ACTION_SEQUENCE OWNER_ACTION_SEQ, PACT.EFFECTIVE_DATE CURRENT_EFFECTIVE_DATE, PLB.EXPIRED_ASSIGNMENT_ACTION_ID, PLB.EXPIRED_VALUE, PLB.EXPIRED_DATE, PLB.PREV_ASSIGNMENT_ACTION_ID, PLB.PREV_BALANCE_VALUE, PLB.PREV_EXPIRY_DATE, PLB.TAX_UNIT_ID, PLB.JURISDICTION_CODE, PLB.ORIGINAL_ENTRY_ID, PLB.SOURCE_ID, PLB.SOURCE_TEXT, PLB.SOURCE_TEXT2, PLB.SOURCE_NUMBER, PLB.TAX_GROUP, PLB.PAYROLL_ID, PLB.LOCAL_UNIT_ID, PLB.ORGANIZATION_ID, PLB.SOURCE_NUMBER2 FROM PAY_LATEST_BALANCES PLB , PER_ALL_ASSIGNMENTS_F ASSIGN , PAY_ASSIGNMENT_ACTIONS ACT , PAY_PAYROLL_ACTIONS PACT , PAY_ASSIGNMENT_ACTIONS OWN_ACT WHERE PLB.DEFINED_BALANCE_ID = :B15 AND ACT.ASSIGNMENT_ACTION_ID = :B14 AND ASSIGN.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND EXISTS (SELECT '' FROM PAY_OBJECT_GROUPS POG WHERE POG.SOURCE_ID (+) = ACT.ASSIGNMENT_ID AND POG.SOURCE_TYPE (+) = 'PAF' AND NVL(PLB.PROCESS_GROUP_ID, NVL(POG.PARENT_OBJECT_GROUP_ID, -1)) = NVL(POG.PARENT_OBJECT_GROUP_ID, -1) ) AND PLB.PERSON_ID = ASSIGN.PERSON_ID AND NVL(PLB.ASSIGNMENT_ID, ACT.ASSIGNMENT_ID) = ACT.ASSIGNMENT_ID AND PACT.PAYROLL_ACTION_ID = ACT.PAYROLL_ACTION_ID AND PACT.EFFECTIVE_DATE BETWEEN ASSIGN.EFFECTIVE_START_DATE AND ASSIGN.EFFECTIVE_END_DATE AND OWN_ACT.ASSIGNMENT_ACTION_ID = PLB.ASSIGNMENT_ACTION_ID AND NVL(PLB.TAX_UNIT_ID, NVL(:B13 , -1)) = NVL(:B13 , -1) AND NVL(SUBSTR(NVL(PLB.JUR ISDICTION_CODE, NVL(:B12 , -1)), 1, :B11 ), -1) = NVL( SUBSTR(NVL(:B12 , -1), 1, :B11 ), -1) AND NVL(PLB.ORIGINAL_ENTRY_ID, NVL(:B10 , -1)) = NVL(:B10 , -1) AND NVL(PLB.SOURCE_ID, NVL(:B9 , -1)) = NVL(:B9 , -1) AND NVL(PLB.SOURCE_TEXT, NVL(:B8 , -1)) = NVL(:B8 , -1) AND NVL(PLB.SOURCE_TEXT2, NVL(:B7 , -1)) = NVL(:B7 , -1) AND NVL(PLB.SOURCE_NUMBER, NVL(:B6 , -1)) = NVL(:B6 , -1) AND NVL(PLB.TAX_GROUP, NVL(:B5 , -1)) = NVL(:B5 , -1) AND NVL(PLB.PAYROLL_ID, NVL(:B4 , -1)) = NVL(:B4 , -1) AND NVL(PLB.LOCAL_UNIT_ID, NVL(:B3 , -1)) = NVL(:B3 , -1) AND NVL(PLB.ORGANIZATION_ID, NVL(:B2 , -1)) = NVL(:B2 , -1) AND NVL(PLB.SOURCE_NUMBER2, NVL(:B1 , -1)) = NVL(:B1 , -1) ORDER BY PLB.LATEST_BALANCE_ID
cf621qmts91wf	SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time = 0 and a.session_type = 1 and a.event_id in ( select en.event_id from WRH$_EVENT_NAME en where a.dbid = en.dbid and en.wait_class = 'User I/O') GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.iowait_delta) >= :cutoff ORDER BY sum(s.iowait_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.io_wait DESC
cj64zg9gg7780	SELECT ACTION_INFORMATION_ID , ACTION_CONTEXT_ID , ACTION_CONTEXT_TYPE , TAX_UNIT_ID , JURISDICTION_CODE , SOURCE_ID , SOURCE_TEXT , TAX_GROUP , OBJECT_VERSION_NUMBER , EFFECTIVE_DATE , ASSIGNMENT_ID , ACTION_INFORMATION_CATEGORY , ACTION_INFORMATION1 , ACTION_INFORMATION2 , ACTION_INFORMATION3 , ACTION_INFORMATION4 , ACTION_INFORMATION5 , ACTION_INFORMATION6 , ACTION_INFORMATION7 , ACTION_INFORMATION8 , ACTION_INFORMATION9 , ACTION_INFORMATION10 , ACTION_INFORMATION11 , ACTION_INFORMATION12 , ACTION_INFORMATION13 , ACTION_INFORMATION14 , ACTION_INFORMATION15 , ACTION_INFORMATION16 , ACTION_INFORMATION17 , ACTION_INFORMATION18 , ACTION_INFORMATION19 , ACTION_INFORMATION20 , ACTION_INFORMATION21 , ACTION_INFORMATION22 , ACTION_INFORMATION23 , ACTION_INFORMATION24 , ACTION_INFORMATION25 , ACTION_INFORMATION26 , ACTION_INFORMATION27 , ACTION_INFORMATION28 , ACTION_INFORMATION29 , ACTION_INFORMATION30 FROM PAY_ACTION_INFORMATION WHERE ACTION_INFORMATION_ID = :B1 FOR UPDATE NOWAIT
cn5un9cxnah8w	SELECT NVL(PBD.PERIOD_TYPE, 'NULL'), PBD.START_DATE_CODE FROM PAY_BALANCE_DIMENSIONS PBD, PAY_DEFINED_BALANCES PDB WHERE PDB.DEFINED_BALANCE_ID = :B1 AND PDB.BALANCE_DIMENSION_ID = PBD.BALANCE_DIMENSION_ID
cr74qtm56vcq6	BEGIN PAY_US_NACHA_TAPE.RUN_FORMULA; END;
d7shgtk3p7s4u	SELECT /*+ ordered index(BAL_ASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(BACT PAY_PAYROLL_ACTIONS_PK) index(ASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(PACT PAY_PAYROLL_ACTIONS_PK) index(INTLCK2 PAY_ACTION_INTERLOCKS_FK1) index(PPASSACT PAY_ASSIGNMENT_ACTIONS_PK) index(PPACT PAY_PAYROLL_ACTIONS_PK) index(RR PAY_RUN_RESULTS_N50) index(TARGET PAY_RUN_RESULT_VALUES_N50) index(FEED PAY_BALANCE_FEEDS_F_N50) */ fnd_number.number_to_canonical(/*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0) ) FROM pay_assignment_actions BAL_ASSACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_assignment_actions ASSACT , pay_payroll_actions PACT , pay_run_results RR , pay_run_result_values TARGET , pay_balance_feeds_f FEED where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and FEED.balance_type_id = :U1 + DECODE(TARGET.INPUT_VALUE_ID, NULL , 0, 0) and FEED.input_value_id = TARGET.input_value_id and nvl(TARGET.result_value, '0') != '0' and TARGET.run_result_id = RR.run_result_id and RR.assignment_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action _id = PACT.payroll_action_id and PACT.effective_date between FEED.effective_start_date and FEED.effective_end_date and RR.status in ('P', 'PA') and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and nvl(PACT.future_process_mode, 'Y') = 'Y' and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and pay_core_utils.include_action_in_payment(BACT.action_type, BAL_ASSACT.assignment_action_id, ASSACT.assignment_action_id) = 'Y' and NOT EXISTS (SELECT /*+ NO_PUSH_SUBQ */ NULL FROM pay_payroll_actions RPACT , pay_assignment_actions RASSACT , pay_action_interlocks RINTLK where ASSACT.assignment_action_id = RINTLK.locked_action_id and RINTLK.locking_action_id = RASSACT.assignment_action_id and RPACT.payroll_action_id = RASSACT.payroll_action_id and RPACT.action_type = 'V')
dab1prc9qyv3v	begin hr_nonrun_asact.asact(:pactid, :atype, :itpflg, :ptype, :lub, :lul, :use_pop_person); end;
dgyj6z7xacxjm	SELECT /*+ ordered use_nl(stat text) */ text.sql_text, text.command_type, stat.* FROM (SELECT * FROM (SELECT s.sql_id, max(s.plan_hash_value) as planhash, sum(s.cpu_time_delta) as cpu_time, sum(s.elapsed_time_delta) as elapsed_time, sum(s.elapsed_time_delta - s.plsexec_time_delta - s.javexec_time_delta) as sqlx_time, sum(s.plsexec_time_delta) as plsqlx_time, sum(s.javexec_time_delta) as javax_time, sum(s.disk_reads_delta + s.direct_writes_delta) as io_blocks, sum(s.iowait_delta) as io_wait, sum(s.clwait_delta) as cl_wait, sum(s.rows_processed_delta) as rows_processed, sum(s.fetches_delta) as fetches, sum(s.end_of_fetch_count_delta) as eofs, sum(s.executions_delta) as execs, sum(s.px_servers_execs_delta) as px FROM (SELECT t1.* FROM WRH$_SQLSTAT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SQLSTAT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) s WHERE s.snap_id > :startsn and s.snap_id <= :endsn and s.dbid = :dbid and s.instance_number = :inst_id and s.sql_id in ( SELECT ash.sql_id FROM ( SELECT a.sql_id as sql_id , coun t(*) as occur_count FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.snap_id > :startsn and a.snap_id <= :endsn and a.dbid = :db_id and a.instance_number = :instance_number and a.sql_id is not null and a.wait_time <> 0 GROUP BY a.sql_id HAVING count(*) >= :cutoff ORDER BY occur_count DESC ) ash WHERE rownum <= :topsql_from_ash ) GROUP BY s.sql_id HAVING sum(s.cpu_time_delta) >= :cutoff ORDER BY sum(s.cpu_time_delta) DESC ) WHERE ROWNUM <= :topsql) stat , WRH$_SQLTEXT text WHERE text.dbid = :db_id AND text.sql_id = stat.sql_id ORDER BY stat.cpu_time DESC
dqd80d97sjck0	update pay_latest_balances set assignment_action_id=:b1, value=:b2, expiry_date=to_date(:b3:b4, :b5), expired_assignment_action_id=:b6, expired_value=:b7, expired_date=to_date(:b8:b9, :b5), prev_assignment_action_id=:b11, prev_balance_value=:b12, prev_expiry_date=to_date(:b13:b14, :b5) where rowid=:b16
fdv98jawj03hg	SELECT FUE.USER_ENTITY_NAME , NVL(FUE.BUSINESS_GROUP_ID, -1) , NVL(FUE.LEGISLATION_CODE, ' ') FROM FF_USER_ENTITIES FUE , FF_USER_ENTITIES FUE_B WHERE FUE.CREATOR_ID = :B2 AND FUE_B.CREATOR_TYPE = 'B' AND FUE.CREATOR_ID = FUE_B.CREATOR_ID AND FUE.CREATOR_TYPE = 'RB' AND FUE.USER_ENTITY_NAME = FUE_B.USER_ENTITY_NAME||'_'||TO_CHAR(:B1 )
fnnymj5r1f0n8	SELECT PBG.LEGISLATION_CODE FROM PER_BUSINESS_GROUPS PBG WHERE PBG.BUSINESS_GROUP_ID = :B1
g3835fnqtvy06	SELECT NVL(SUM(prb.balance_value), 0) FROM /* Assignment Payments on run balances */ pay_balance_types pbt , pay_run_balances prb , pay_defined_balances pdb , pay_assignment_actions ASSACT , pay_assignment_actions BAL_ASSACT , pay_payroll_actions PACT , pay_payroll_actions BACT , pay_assignment_actions PPASSACT , pay_payroll_actions PPACT , pay_action_interlocks INTLCK2 , pay_run_types_f BAL_PRT , pay_run_types_f PRT where BAL_ASSACT.assignment_action_id = :ASSIGNMENT_ACTION_ID and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id and BACT.action_type in ('P', 'U', 'R', 'Q') and PPASSACT.assignment_action_id = pay_core_utils.get_pp_action_id(BACT.action_type, BAL_ASSACT.assignment_action_id) and PPASSACT.payroll_action_id = PPACT.payroll_action_id and PPACT.action_type in ('P', 'U') and PPASSACT.assignment_action_id = INTLCK2.locking_action_id and INTLCK2.locked_action_id = ASSACT.assignment_action_id and ASSACT.payroll_action_id = PACT.payroll_action_id and nvl(BAL_ASSACT.run_type_id, -999) = BAL_PRT.run_type_id (+) and nvl(ASSACT.run_type_id, -999) = PRT.run_type_id (+) and ASSACT.assignment_action_id = decode(BACT.action_type, 'P', ASSACT.assignment_action_id, 'U', ASSACT.assignment_action_id, 'R', decode(nvl(BAL_PRT.run_method, 'N' ), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)), 'Q', decode(nvl(BAL_PRT.run_method, 'N'), 'S', BAL_ASSACT.ASSIGNMENT_ACTION_ID, decode (nvl(PRT.run_method, 'N'), 'S', -999, ASSACT.assignment_action_id)) ) and ASSACT.tax_unit_id = decode(BACT.action_type, 'P', ASSACT.tax_unit_id, 'U', ASSACT.tax_unit_id, 'R', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id), 'Q', decode(BAL_ASSACT.SOURCE_ACTION_ID, NULL, ASSACT.TAX_UNIT_ID, BAL_ASSACT.tax_unit_id) ) and ASSACT.assignment_id = BAL_ASSACT.assignment_id and nvl(PACT.future_process_mode, 'Y') = 'Y' and PACT.action_type <> 'V' and prb.assignment_action_id = ASSACT.assignment_action_id and prb.defined_balance_id = pdb.defined_balance_id and pdb.balance_dimension_id = :U2 and pbt.balance_type_id = :U1 and pdb.balance_type_id = pbt.balance_type_id and substr(prb.jurisdiction_code, 1, pbt.jurisdiction_level) = substr(:JURISDICTION_CODE, 1, pbt.jurisdiction_level)
g6tx1p7d69dxg	SELECT ENT.USER_ENTITY_ID, ENT.CREATOR_TYPE, ENT.NOTFOUND_ALLOWED_FLAG, RO.ROUTE_ID, RO.TEXT, RO.OPTIMIZER_HINT FROM FF_USER_ENTITIES ENT , FF_ROUTES RO WHERE ENT.USER_ENTITY_NAME = :B3 AND ( (ENT.LEGISLATION_CODE IS NULL AND ENT.BUSINESS_GROUP_ID IS NULL) OR (ENT.BUSINESS_GROUP_ID IS NULL AND :B2 = ENT.LEGISLATION_CODE ) OR ENT.BUSINESS_GROUP_ID + 0 = :B1 ) AND ENT.ROUTE_ID = RO.ROUTE_ID
gq04p7vgjcmkg	SELECT PPT.CATEGORY CATEGORY, PPM.PERSONAL_PAYMENT_METHOD_ID PERSONAL_METHOD, PEA.PRENOTE_DATE PRENOTE_DATE, PPT.VALIDATION_DAYS VALID_DAYS, PPM.PERCENTAGE PERCENTAGE, PPM.AMOUNT AMOUNT, OPM.ORG_PAYMENT_METHOD_ID ORG_METHOD, HR_PRE_PAY.SET_CASH_RULE(PPT.CATEGORY, OPM.PMETH_INFORMATION1) CASH_RULE, OPM.CURRENCY_CODE PAYMENT_CURRENCY, PPT.PRE_VALIDATION_REQUIRED VALIDATION_REQUIRED, PPT.VALIDATION_VALUE VALIDATION_VALUE, OPM.EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID FROM PAY_EXTERNAL_ACCOUNTS PEA, PAY_PAYMENT_TYPES PPT, PAY_ORG_PAYMENT_METHODS_F OPM, PAY_PERSONAL_PAYMENT_METHODS_F PPM, PAY_ASSIGNMENT_ACTIONS ACT WHERE ACT.ASSIGNMENT_ACTION_ID=:B4 AND PPM.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PPM.RUN_TYPE_ID = :B3 AND PPM.ORG_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID AND OPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID AND OPM.DEFINED_BALANCE_ID = :B2 AND PPM.EXTERNAL_ACCOUNT_ID = PEA.EXTERNAL_ACCOUNT_ID (+) AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN PPM.EFFECTIVE_START_DATE AND PPM.EFFECTIVE_END_DATE AND FND_DATE.CANONICAL_TO_DATE(:B1 ) BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE ORDER BY PPM.PERSON_ID, PPM.PRIORITY
gxa19cf01sb0c	SELECT PTS.TIME_IN_STATE, PTS.STATE_NAME, PTS.JURISDICTION_CODE, PTS.FILING_STATUS_CODE, PTS.MEANING, PTS.WITHHOLDING_ALLOWANCES, PTS.SIT_ADDITIONAL_TAX, PTS.SIT_OVERRIDE_AMOUNT, PTS.SIT_OVERRIDE_RATE FROM PAY_US_EMP_TIME_IN_STATE_V PTS WHERE PTS.ASSIGNMENT_ID = :B2 AND PTS.JURISDICTION_CODE LIKE :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Instance Activity Stats
• Instance Activity Stats - Absolute Values
• Instance Activity Stats - Thread Activity

Instance Activity Stats

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

• Statistics identified by '(derived)' come from sources other than SYSSTAT

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

• Standard block size Pools D: default, K: keep, R: recycle
• Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

Back to Top

Advisory Statistics

• Instance Recovery Stats
• Buffer Pool Advisory
• PGA Aggr Summary
• PGA Aggr Target Stats
• PGA Aggr Target Histogram
• PGA Memory Advisory
• Shared Pool Advisory
• SGA Target Advisory
• Streams Pool Advisory
• Java Pool Advisory

Instance Recovery Stats

• B: Begin snapshot, E: End snapshot

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

• Only rows with estimated physical reads >0 are displayed
• ordered by Block Size, Buffers For Estimate

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

• PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

• B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
• Auto PGA Target - actual workarea memory target
• W/A PGA Used - amount of memory used for all Workareas (manual + auto)
• %PGA W/A Mem - percentage of PGA memory allocated to workareas
• %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
• %Man W/A Mem - percentage of workarea memory under manual control

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

• Optimal Executions are purely in-memory operations

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

• When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

• SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
• Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

• Buffer Wait Statistics
• Enqueue Activity

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Wait Statistics
Back to Top

Enqueue Activity

• only enqueues with waits are shown
• Enqueue stats gathered prior to 10g should not be compared with 10g data
• ordered by Wait Time desc, Waits desc

Back to Wait Statistics
Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

• Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
• STO - Snapshot Too Old count, OOS - Out of Space count
• Undo segment block stats:
• uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
• eS - expired Stolen, eR - expired Released, eU - expired reUsed

Back to Undo Statistics
Back to Top

Undo Segment Stats

• Most recent 35 Undostat rows, ordered by Time desc

Back to Undo Statistics
Back to Top

Latch Statistics

• Latch Activity
• Latch Sleep Breakdown
• Latch Miss Sources
• Parent Latch Statistics
• Child Latch Statistics

Latch Activity

• "Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
• "NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
• "Pct Misses" for both should be very close to 0.0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

• ordered by misses desc

Back to Latch Statistics
Back to Top

Latch Miss Sources

• only latches with sleeps are shown
• ordered by name, sleeps desc

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by Row Lock Waits
• Segments by ITL Waits
• Segments by Buffer Busy Waits

Segments by Logical Reads

• Total Logical Reads: 130,010,501
• Captured Segments account for 69.8% of Total

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 563
• Captured Segments account for 27.7% of Total

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

• % of Capture shows % of row lock waits for each top segment compared
• with total row lock waits for all segments captured by the Snapshot

Back to Segment Statistics
Back to Top

Segments by ITL Waits

• % of Capture shows % of ITL waits for each top segment compared
• with total ITL waits for all segments captured by the Snapshot

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

• % of Capture shows % of Buffer Busy Waits for each top segment compared
• with total Buffer Busy Waits for all segments captured by the Snapshot

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

• "Pct Misses" should be very low (< 2% in most cases)
• "Final Usage" is the number of cache entries being used

Back to Top

Library Cache Activity

• "Pct Misses" should be very low

Back to Top

Memory Statistics

• Process Memory Summary
• SGA Memory Summary
• SGA breakdown difference

Process Memory Summary

• B: Begin snap E: End snap
• All rows below contain absolute values (i.e. not diffed over the interval)
• Max Alloc is Maximum PGA Allocation size at snapshot time
• Hist Max Alloc is the Historical Max Allocation for still-connected processes
• ordered by Begin/End snapshot, Alloc (MB) desc

Back to Memory Statistics
Back to Top

SGA Memory Summary

Back to Memory Statistics
Back to Top

SGA breakdown difference

• ordered by Pool, Name
• N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Back to Memory Statistics
Back to Top

Streams Statistics

• Streams CPU/IO Usage
• Streams Capture
• Streams Apply
• Buffered Queues
• Buffered Subscribers
• Rule Set

Streams CPU/IO Usage

• Streams processes ordered by CPU usage
• CPU and I/O Time in micro seconds

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

• The Spill Rate should be very close to zero
• The Diff in Percentage Spilled should be very close to zero or negative

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

• Rule Sets ordered by Evaluations

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Back to Top

init.ora Parameters

Back to Top

End of Report

E-mail this page Printer View About Oracle | | Subscribe | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights