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: 2576 24-Sep-08 14:16:00 62 28.4 End Snap: 2577 24-Sep-08 14:21:40 64 28.3 Elapsed:   5.67 (mins)     DB Time:   24.65 (mins)     Report Summary Cache Sizes Begin End Buffer Cache: 8,192M 8,192M Std Block Size: 8K Shared Pool Size: 2,048M 2,048M Log Buffer: 14,340K Load Profile Per Second Per Transaction Redo size: 2,084,043.41 48,220.82 Logical reads: 375,226.45 8,682.03 Block changes: 14,864.55 343.94 Physical reads: 27.46 0.64 Physical writes: 0.03 0.00 User calls: 2,785.86 64.46 Parses: 2,202.95 50.97 Hard parses: 0.28 0.01 Sorts: 2,367.25 54.77 Logons: 0.22 0.01 Executes: 26,666.96 617.02 Transactions: 43.22   % Blocks changed per Read: 3.96 Recursive Call %: 95.20 Rollback per transaction %: 0.00 Rows per Sort: 2.35 Instance Efficiency Percentages (Target 100%) Buffer Nowait %: 99.94 Redo NoWait %: 100.00 Buffer Hit %: 99.99 In-memory Sort %: 100.00 Library Hit %: 99.86 Soft Parse %: 99.99 Execute to Parse %: 91.74 Latch Hit %: 96.91 Parse CPU to Parse Elapsd %: 32.12 % Non-Parse CPU: 99.59 Shared Pool Statistics Begin End Memory Usage %: 23.02 23.19 % SQL with executions>1: 94.24 92.99 % Memory for SQL w/exec>1: 95.10 91.86 Top 5 Timed Events Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class CPU time   924   62.5   enq: UL - contention 405 26 65 1.8 Application log file parallel write 13,524 8 1 .5 System I/O log file sync 5,738 7 1 .5 Commit db file scattered read 1,686 2 1 .1 User I/O 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): 1478.8s 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,455.13 98.40 DB CPU 924.04 62.48 PL/SQL execution elapsed time 480.82 32.51 parse time elapsed 14.11 0.95 repeated bind elapsed time 0.65 0.04 inbound PL/SQL rpc elapsed time 0.62 0.04 sequence load elapsed time 0.16 0.01 connection management call elapsed time 0.14 0.01 hard parse elapsed time 0.14 0.01 PL/SQL compilation elapsed time 0.12 0.01 hard parse (sharing criteria) elapsed time 0.00 0.00 hard parse (bind mismatch) elapsed time 0.00 0.00 DB time 1,478.83   background elapsed time 17.09   background cpu time 3.69   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 721 0.97 27 37 0.05 System I/O 15,382 0.00 8 1 1.05 Commit 5,738 0.00 7 1 0.39 User I/O 3,231 0.00 4 1 0.22 Concurrency 80,607 0.05 3 0 5.48 Network 919,050 0.00 1 0 62.49 Other 6,883 80.28 0 0 0.47 Configuration 270 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 405 1.73 26 65 0.03 log file parallel write 13,524 0.00 8 1 0.92 log file sync 5,738 0.00 7 1 0.39 db file scattered read 1,686 0.00 2 1 0.11 db file sequential read 1,535 0.00 2 1 0.10 buffer busy waits 74,930 0.00 1 0 5.10 SQL*Net message to client 889,110 0.00 1 0 60.46 SQL*Net more data from client 29,187 0.00 1 0 1.98 enq: TX - index contention 2,535 0.00 1 0 0.17 cursor: pin S wait on X 62 70.97 0 7 0.00 enq: TX - row lock contention 240 0.00 0 2 0.02 control file sequential read 1,701 0.00 0 0 0.12 control file parallel write 157 0.00 0 1 0.01 latch: cache buffers chains 1,801 0.00 0 0 0.12 os thread startup 3 0.00 0 26 0.00 latch: In memory undo latch 1,204 0.00 0 0 0.08 enq: SQ - contention 266 0.00 0 0 0.02 rdbms ipc reply 61 0.00 0 0 0.00 SQL*Net more data to client 753 0.00 0 0 0.05 buffer deadlock 5,576 99.10 0 0 0.38 latch: undo global data 26 0.00 0 0 0.00 latch free 48 0.00 0 0 0.00 latch: library cache 41 0.00 0 0 0.00 latch: library cache lock 26 0.00 0 0 0.00 LGWR wait for redo copy 349 0.00 0 0 0.02 SQL*Net break/reset to client 76 0.00 0 0 0.01 direct path write 9 0.00 0 0 0.00 cursor: pin S 813 0.00 0 0 0.06 enq: HW - contention 4 0.00 0 0 0.00 latch: cache buffer handles 6 0.00 0 0 0.00 read by other session 1 0.00 0 1 0.00 latch: session allocation 2 0.00 0 0 0.00 latch: library cache pin 4 0.00 0 0 0.00 latch: redo allocation 2 0.00 0 0 0.00 latch: row cache objects 1 0.00 0 0 0.00 SQL*Net message from client 889,110 0.00 8,539 10 60.46 Streams AQ: qmn slave idle wait 107 0.00 670 6262 0.01 pipe get 137 100.00 334 2438 0.01 Streams AQ: qmn coordinator idle wait 133 39.10 327 2460 0.01 PL/SQL lock timer 83 100.00 324 3906 0.01 jobq slave wait 28 100.00 82 2930 0.00 class slave wait 1 0.00 0 0 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,524 0.00 8 1 0.92 control file parallel write 157 0.00 0 1 0.01 os thread startup 3 0.00 0 26 0.00 control file sequential read 66 0.00 0 0 0.00 db file sequential read 2 0.00 0 4 0.00 events in waitclass Other 360 0.00 0 0 0.02 rdbms ipc message 12,396 8.69 2,640 213 0.84 Streams AQ: qmn slave idle wait 107 0.00 670 6262 0.01 smon timer 125 0.00 462 3693 0.01 pmon timer 141 100.00 331 2348 0.01 Streams AQ: qmn coordinator idle wait 133 39.10 327 2460 0.01 Back to Wait Events Statistics Back to Top Operating System Statistics Statistic Total NUM_LCPUS 0 NUM_VCPUS 0 AVG_BUSY_TIME 21,221 AVG_IDLE_TIME 12,834 AVG_IOWAIT_TIME 24 AVG_SYS_TIME 1,710 AVG_USER_TIME 19,503 BUSY_TIME 169,858 IDLE_TIME 102,774 IOWAIT_TIME 217 SYS_TIME 13,762 USER_TIME 156,096 LOAD 0 OS_CPU_WAIT_TIME 169,800 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,477.10 922.80 228 127,598,401 SYS$USERS 1.80 1.20 171 36,996 SYS$BACKGROUND 0.00 0.00 8,941 42,544 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 63 32 80604 264 0 0 918826 113 SYS$USERS 347 31 0 0 0 0 19 0 SYS$BACKGROUND 2821 330 3 8 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,019 506 9,981 0.10 68.89 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 1,015 506 9,988 0.10 68.63 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 80 80 278,855 0.00 5.38 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 69 68 9,992 0.01 4.64 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 51 50 9,990 0.01 3.43 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro... 46 46 59,639 0.00 3.09 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 45 24 40 1.12 3.03 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 37 37 149,678 0.00 2.50 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 29 29 169,725 0.00 1.96 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 27 27 44,628 0.00 1.84 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 22 22 477,050 0.00 1.50 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 21 21 109,967 0.00 1.39 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 20 20 9,968 0.00 1.37 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL... 20 20 474,388 0.00 1.35 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 20 20 9,999 0.00 1.32 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r... 19 19 9,999 0.00 1.29 36z3h9rgkd8aa PYUSLV begin ... 19 19 426,986 0.00 1.27 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 18 18 477,045 0.00 1.24 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 18 18 698,453 0.00 1.19 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 17 17 9,875 0.00 1.15 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ... 17 17 9,991 0.00 1.13 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA... 15 15 9,990 0.00 1.04 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC... 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 506 1,015 9,988 0.05 68.63 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 506 1,019 9,981 0.05 68.89 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 80 80 278,855 0.00 5.38 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 68 69 9,992 0.01 4.64 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 50 51 9,990 0.00 3.43 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro... 46 46 59,639 0.00 3.09 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 37 37 149,678 0.00 2.50 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 29 29 169,725 0.00 1.96 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 27 27 44,628 0.00 1.84 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 24 45 40 0.59 3.03 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 22 22 477,050 0.00 1.50 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 21 21 109,967 0.00 1.39 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 20 20 9,968 0.00 1.37 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL... 20 20 474,388 0.00 1.35 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 20 20 9,999 0.00 1.32 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r... 19 19 9,999 0.00 1.29 36z3h9rgkd8aa PYUSLV begin ... 19 19 426,986 0.00 1.27 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 18 18 477,045 0.00 1.24 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 18 18 698,453 0.00 1.19 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 17 17 9,875 0.00 1.15 gq04p7vgjcmkg PYUSLV SELECT PPT.CATEGORY CATEGORY, ... 17 17 9,991 0.00 1.13 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA... 15 15 9,990 0.00 1.04 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC... 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: 127,677,929 Captured SQL account for 65.1% of Total Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 86,940,025 9,988 8,704.45 68.09 505.76 1014.96 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 86,693,818 9,981 8,685.88 67.90 505.57 1018.69 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 15,920,980 278,855 57.09 12.47 79.55 79.55 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 8,021,034 59,639 134.49 6.28 45.77 45.75 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 6,437,947 149,678 43.01 5.04 37.02 37.02 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 5,495,647 9,990 550.11 4.30 49.52 50.70 9jv68n0ctas75 PYUSLV begin pay_core_utils . get_pro... 5,260,387 477,050 11.03 4.12 22.12 22.12 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 4,947,152 40 123,678.80 3.87 23.72 44.74 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 4,709,838 426,986 11.03 3.69 18.86 18.85 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 4,627,695 9,992 463.14 3.62 68.48 68.61 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 4,618,132 44,628 103.48 3.62 27.23 27.23 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 4,034,598 477,045 8.46 3.16 18.41 18.41 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 3,903,122 474,388 8.23 3.06 20.02 20.02 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 3,486,426 581,551 6.00 2.73 13.85 13.82 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '... 2,690,997 9,999 269.13 2.11 19.56 19.56 7d66dw0vz7yaa PYUSLV begin pay_cc_process_utils . r... 2,236,900 9,984 224.05 1.75 11.16 11.16 02dvcwb36048p PYUSLV UPDATE PAY_ACTION_INFORMATION ... 2,160,230 9,988 216.28 1.69 10.27 10.26 cj64zg9gg7780 PYUSLV SELECT ACTION_INFORMATION_ID ,... 2,147,020 9,999 214.72 1.68 19.02 19.01 36z3h9rgkd8aa PYUSLV begin ... 2,095,350 698,453 3.00 1.64 17.62 17.62 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 2,002,899 109,967 18.21 1.57 20.58 20.59 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 1,832,117 9,980 183.58 1.43 11.60 11.59 gxa19cf01sb0c PYUSLV SELECT PTS.TIME_IN_STATE, PTS... 1,791,345 9,991 179.30 1.40 16.70 16.71 7mmdd7sypzu9x PYUSLV BEGIN FFP1893_01010001.FORMULA... 1,643,479 169,725 9.68 1.29 28.93 28.93 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 1,607,445 9,968 161.26 1.26 20.34 20.32 2z261p0p82p32 PYUSLV BEGIN FFP51704_01010001.FORMUL... 1,490,544 123,658 12.05 1.17 11.42 11.41 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR... 1,460,533 9,997 146.10 1.14 12.23 12.22 a9pf25b5p69c6 PYUSLV declare cursor dp ( p_act in n... 1,457,722 39,959 36.48 1.14 12.86 12.84 f78ff26qcfjan PYUSLV update PAY_ASSIGNMENT_ACTIONS ... 1,427,114 9,998 142.74 1.12 12.07 12.07 gj45bp5w5anrf PYUSLV SELECT DISTINCT PEE.ASSIGNMENT... 1,309,046 9,990 131.04 1.03 15.35 15.34 g4jp561h1bs98 PYUSLV select /*+ ORDERED USE_NL(AC... 1,296,746 19,996 64.85 1.02 8.36 8.36 9665ycstch5r4 PYUSLV select /*+ ORDERED USE_NL(AA... Back to SQL Statistics Back to Top SQL ordered by Reads Total Disk Reads: 9,344 Captured SQL account for 0.3% of Total Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 60 40 1.50 0.64 23.72 44.74 dab1prc9qyv3v PYUSLV begin hr_nonrun_asact... 20 500 0.04 0.21 4.67 6.11 7y9t68kb4mc6q PYUSLV BEGIN pay_us_action_arch.actio... 18 9,988 0.00 0.19 505.76 1014.96 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 18 109,967 0.00 0.19 20.58 20.59 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 17 9,981 0.00 0.18 505.57 1018.69 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 7 5 1.40 0.07 0.01 0.08 19ay9yuhtbvkc FNDCPVCM INSERT INTO FND_CONCURRENT_REQ... 3 9,992 0.00 0.03 68.48 68.61 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 2 498 0.00 0.02 0.06 0.06 3c1kubcdjnppq   update sys.col_usage$ set eq... 0 500 0.00 0.00 1.93 1.93 0095dq943c6t3 PYUSLV SELECT /*+ ORDERED ... 0 59,639 0.00 0.00 45.77 45.75 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... Back to SQL Statistics Back to Top SQL ordered by Executions Total Executions: 9,073,941 Captured SQL account for 51.7% of Total Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text 698,453 1,165,131 1.67 0.00 0.00 4gz4b2bh1fs14 PYUSLV SELECT CONTEXT_ID, SEQUENCE_N... 581,551 580,945 1.00 0.00 0.00 cn5un9cxnah8w PYUSLV SELECT NVL(PBD.PERIOD_TYPE, '... 477,050 953,416 2.00 0.00 0.00 5w5up6vdp2qyp PYUSLV SELECT RP.SEQUENCE_NO, RPV.VA... 477,045 477,865 1.00 0.00 0.00 g6tx1p7d69dxg PYUSLV SELECT ENT.USER_ENTITY_ID, EN... 474,388 472,191 1.00 0.00 0.00 fdv98jawj03hg PYUSLV SELECT FUE.USER_ENTITY_NAME , ... 426,986 426,774 1.00 0.00 0.00 02k10jzw8c495 PYUSLV SELECT INTLK.LOCKING_ACTION_ID... 278,855 274,299 0.98 0.00 0.00 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 169,725 0 0.00 0.00 0.00 6500rnmy4f88w PYUSLV SELECT PAP.ACCRUAL_PLAN_ID, P... 149,678 149,195 1.00 0.00 0.00 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 123,658 123,987 1.00 0.00 0.00 fnnymj5r1f0n8 RUNGEN SELECT PBG.LEGISLATION_CODE FR... 109,967 109,918 1.00 0.00 0.00 6v07302134wyf PYUSLV INSERT INTO PAY_ACTION_INFORMA... 109,851 109,676 1.00 0.00 0.00 g9fa98tmdyg0y PYUSLV SELECT 'X' FROM PAY_ASSIGNMENT... Back to SQL Statistics Back to Top SQL ordered by Parse Calls Total Parse Calls: 749,595 Captured SQL account for 91.3% of Total Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text 279,109 278,855 37.23 3n5uwzsh3y8gr PYUSLV SELECT NVL(SUM(prb.balance_val... 149,661 149,678 19.97 g3835fnqtvy06 PYUSLV SELECT NVL(SUM(prb.balance_val... 59,154 59,639 7.89 01pkua627ktjk PYUSLV SELECT fnd_number.number_to_ca... 44,692 44,628 5.96 8v2cvg5zhw9ua PYUSLV SELECT fnd_number.number_to_ca... 29,895 29,949 3.99 264qzrka8fsps PYUSLV SELECT NVL(SUM(prb.balance_val... 19,772 19,964 2.64 83kbt99vg4svq PYUSLV begin ... 19,678 19,769 2.63 165d2bgc2b9hr PYUSLV SELECT NVL(SUM(prb.balance_val... 9,986 9,981 1.33 4f5mjr4hnaz3u PYUSLV declare begin pay_archive... 9,969 9,943 1.33 97mt0g20bcfc3 PYUSLV begin ... 9,961 9,992 1.33 4ds53shhfcynn PYUSLV declare begin hr_pre_pay.... 9,919 9,999 1.32 36z3h9rgkd8aa PYUSLV begin ... 9,910 9,982 1.32 3rg5fyfgd5uwc PYUSLV begin pay_US_rules.get_tim... 9,902 9,988 1.32 5sfm6rppc4y8x PYUSLV BEGIN pay_us_action_arch.actio... 9,312 9,346 1.24 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
0095dq943c6t3	SELECT /*+ ORDERED index(pa2 PAY_PAYROLL_ACTIONS_PK) index(pos PER_PERIODS_OF_SERVICE_N3) index(as1 PER_ASSIGNMENTS_F_N4) index(act PAY_ASSIGNMENT_ACTIONS_N51) index(as2 PER_ASSIGNMENTS_F_PK) index(opm PAY_ORG_PAYMENT_METHODS_F_PK) USE_NL(pos pop act pa2 as1 as2) */ ACT.ASSIGNMENT_ACTION_ID, ACT.ASSIGNMENT_ID, ACT.TAX_UNIT_ID, PPP.PRE_PAYMENT_ID, PA1.ASSIGNMENT_SET_ID, AS1.PAYROLL_ID FROM PAY_PAYROLL_ACTIONS PA1, PAY_POPULATION_RANGES POP, PER_PERIODS_OF_SERVICE POS, PER_ALL_ASSIGNMENTS_F AS1, PAY_ASSIGNMENT_ACTIONS ACT, PAY_PAYROLL_ACTIONS PA2, PAY_ACTION_CLASSIFICATIONS PCL, PAY_PRE_PAYMENTS PPP, PER_ALL_ASSIGNMENTS_F AS2, PAY_ORG_PAYMENT_METHODS_F OPM WHERE PA1.PAYROLL_ACTION_ID = :B3 AND PA2.CONSOLIDATION_SET_ID +0 = PA1.CONSOLIDATION_SET_ID AND PA2.EFFECTIVE_DATE BETWEEN PA1.START_DATE AND PA1.EFFECTIVE_DATE AND ACT.PAYROLL_ACTION_ID = PA2.PAYROLL_ACTION_ID AND ACT.ACTION_STATUS = 'C' AND PCL.CLASSIFICATION_NAME = :B4 AND PA2.ACTION_TYPE = PCL.ACTION_TYPE AND AS1.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PA1.EFFECTIVE_DATE BETWEEN AS1.EFFECTIVE_START_DATE AND AS1.EFFECTIVE_END_DATE AND AS2.ASSIGNMENT_ID = ACT.ASSIGNMENT_ID AND PA2.EFFECTIVE_DATE BETWEEN AS2.EFFECTIVE_START_DATE AND AS2.EFFECTIVE_END_DATE AND AS2.PAYROLL_ID + 0 = AS1.PAYROLL_ID + 0 AND POS.PERIOD_OF_SERVICE_ID = AS1.PERIOD_OF_SERVICE_ID AND POP.PAYROLL_ACTION_ID = :B3 AND POP.CHUNK_NUMBER = :B2 AND POS.PER SON_ID = POP.PERSON_ID AND (AS1.PAYROLL_ID = PA1.PAYROLL_ID OR PA1.PAYROLL_ID IS NULL) AND PPP.ASSIGNMENT_ACTION_ID = ACT.ASSIGNMENT_ACTION_ID AND OPM.ORG_PAYMENT_METHOD_ID = PPP.ORG_PAYMENT_METHOD_ID AND PA1.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE AND OPM.EFFECTIVE_END_DATE AND OPM.PAYMENT_TYPE_ID +0 = :B1 AND PPP.ORGANIZATION_ID IS NULL AND (OPM.ORG_PAYMENT_METHOD_ID = PA1.ORG_PAYMENT_METHOD_ID OR PA1.ORG_PAYMENT_METHOD_ID IS NULL) AND NOT EXISTS ( SELECT /*+ ORDERED*/ NULL FROM PAY_ACTION_INTERLOCKS INT, PAY_ASSIGNMENT_ACTIONS AC2 WHERE INT.LOCKED_ACTION_ID = ACT.ASSIGNMENT_ACTION_ID AND AC2.ASSIGNMENT_ACTION_ID = INT.LOCKING_ACTION_ID AND AC2.PRE_PAYMENT_ID = PPP.PRE_PAYMENT_ID AND NOT EXISTS ( SELECT NULL FROM PAY_ASSIGNMENT_ACTIONS PAA_VOID, PAY_ACTION_INTERLOCKS PAI_VOID, PAY_PAYROLL_ACTIONS PPA_VOID WHERE PAI_VOID.LOCKED_ACTION_ID = AC2.ASSIGNMENT_ACTION_ID AND PAI_VOID.LOCKING_ACTION_ID = PAA_VOID.ASSIGNMENT_ACTION_ID AND PAA_VOID.PAYROLL_ACTION_ID = PPA_VOID.PAYROLL_ACTION_ID AND PPA_VOID.ACTION_TYPE = 'D') ) AND NOT EXISTS ( SELECT /*+ ORDERED*/ NULL FROM PER_ALL_ASSIGNMENTS_F AS3, PAY_ASSIGNMENT_ACTIONS AC3 WHERE :B5 = 'N' AND AC3.PAYROLL_ACTION_ID = PA2.PAYROLL_ACTION_ID AND AC3.ACTION_STATUS NOT IN ('C', 'S') AND AS3.ASSIGNMENT_ID = AC3.ASSIGNMENT_ID AND PA2.EFFECTIVE_DATE BETWEEN AS3.EFFECTIVE_START_DATE AND AS3.EFFECTIVE_END_DATE AND AS3.PERSON_ID = AS2.PERSON_ID) ORDER BY ACT.ASSIGNMENT_ID FOR UPDATE OF AS1.ASSIGNMENT_ID, POS.PERIOD_OF_SERVICE_I D
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
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')
19ay9yuhtbvkc	INSERT INTO FND_CONCURRENT_REQUESTS ( REQUEST_ID, SECURITY_GROUP_ID, PHASE_CODE, STATUS_CODE, PRIORITY, PARENT_REQUEST_ID, PRIORITY_REQUEST_ID, DESCRIPTION, REQ_INFORMATION, IS_SUB_REQUEST, HAS_SUB_REQUEST, UPDATE_PROTECTED, HOLD_FLAG, ENFORCE_SERIALITY_FLAG, SINGLE_THREAD_FLAG, ARGUMENT_INPUT_METHOD_CODE, IMPLICIT_CODE, REQUEST_DATE, REQUESTED_START_DATE, REQUESTED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, ORACLE_ID, CONC_LOGIN_ID, RESPONSIBILITY_ID, RESPONSIBILITY_APPLICATION_ID, NLS_LANGUAGE, NLS_TERRITORY, NLS_NUMERIC_CHARACTERS, PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID, QUEUE_METHOD_CODE, REQUEST_CLASS_APPLICATION_ID, CONCURRENT_REQUEST_CLASS_ID, PRINT_GROUP, PRINTER, PRINT_STYLE, NUMBER_OF_COPIES, SAVE_OUTPUT_FLAG, CRM_THRSHLD, RESUBMIT_TIME, RESUBMIT_INTERVAL, RESUBMIT_INTERVAL_UNIT_CODE, RESUBMIT_INTERVAL_TYPE_CODE, RESUBMIT_END_DATE, RESUBMITTED, CRITICAL, REQUEST_TYPE, RELEASE_CLASS_APP_ID, RELEASE_CLASS_ID, STALE_DATE, CANCEL_OR_HOLD, OUTPUT_FILE_TYPE, NLS_COMPLIANT, CD_ID, REQUEST_LIMIT, INCREMENT_DATES, ENABLE_TRACE, OPS_INSTANCE, ORG_ID, ARGUMENT_TEXT, NUMBER_OF_ARGUMENTS, ARGUMENT1, ARGUMENT2, ARGUMENT3, ARGUMENT4, ARGUMENT5, ARGUMENT6, ARGUMENT7, ARGUMENT8, ARGUMENT9, ARGUMENT10, ARGUMENT11, ARGUMENT12, ARGUMENT13, ARGUMENT14, ARGUMENT15, ARGUMENT16, ARGUMENT17, ARGUMENT18, ARGUMENT19, ARGUMENT20, ARGUMENT21, ARGUMENT22, ARGUMENT23, ARGUMENT24, ARGUMENT2 5) SELECT :B75 , :B74 , :B73 , DECODE (:B72 , 'A', 'A', 'Z', 'Z', DECODE(FCP.QUEUE_METHOD_CODE, 'B', 'Q', DECODE (:B54 , 'Y', 'Q', DECODE(:B35 , 'Y', 'Q', 'I')))), DECODE (FCP.QUEUE_CONTROL_FLAG, 'Y', NVL(FCP.REQUEST_PRIORITY, 0), DECODE (:B71 , NULL, 50, :B71 )), DECODE (:B63 , 0, NULL, :B63 ), :B70 , :B69 , NULL, :B68 , 'N', :B67 , :B66 , 'Y', :B54 , 'S', :B65 , SYSDATE, DECODE (:B64 , '', (SYSDATE - :B62 ), GREATEST (:B64 , DECODE (:B63 , 0, (SYSDATE - :B62 ), FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001')))), :B61 , SYSDATE, :B61 , :B60 , ORACLE_ID, :B60 , :B59 , :B58 , :B57 , :B56 , :B55 , FA.APPLICATION_ID, FCP.CONCURRENT_PROGRAM_ID, DECODE(:B35 , 'Y', 'B', DECODE(:B54 , 'N', FCP.QUEUE_METHOD_CODE, 'B')), FCP.CLASS_APPLICATION_ID, FCP.CONCURRENT_CLASS_ID, :B53 , :B52 , :B51 , :B50 , :B49 , :B48 , DECODE (:B47 , '', NULL, TO_CHAR (FND_CONC_DATE.STRING_TO_DATE ( '01-01-0001' || :B47 ), 'HH24:MI:SS')), DECODE (:B46 , '', NULL, :B46 ), :B45 , :B44 , :B43 , 'N', :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , FCP.OUTPUT_FILE_TYPE, FCP.NLS_COMPLIANT, :B36 , :B35 , :B34 , DECODE(:B33 , 'Y', 'Y', FCP.ENABLE_TRACE), :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 FROM FND_APPLICATION FA, FND_CONCURRENT_PROGRAM S FCP, FND_ORACLE_USERID WHERE ORACLE_USERNAME = :B3 AND FCP.ENABLED_FLAG = 'Y' AND (FCP.APPLICATION_ID = FA.APPLICATION_ID AND CONCURRENT_PROGRAM_NAME = UPPER (:B2 )) AND FA.APPLICATION_SHORT_NAME = UPPER (:B1 )
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;
36z3h9rgkd8aa	begin hrassact.update_action_sequence (:aa_id, :itpflg); end;
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
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;
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)
9665ycstch5r4	select /*+ ORDERED USE_NL(AA PA RR RRV LIV IV PERA ET FC EC EL) INDEX(AA PAY_ASSIGNMENT_ACTIONS_PK, PA PAY_PAYROLL_ACTIONS_PK, RR PAY_RUN_RESULTS_N50, ET PAY_ELEMENT_TYPES_F_PK, EL PAY_ELEMENT_LINKS_F_PK, EE PAY_ELEMENT_ENTRIES_F_PK, IV PAY_INPUT_VALUES_F_N1, PERA +*/ EL2.element_link_id , EL2.costable_type , EL2.cost_allocation_keyflex_id , EL2.balancing_keyflex_id , EL2.element_set_id , decode(IV.uom, 'M', nvl(FC.precision, 3), 3) , nvl(EC.costing_debit_or_credit, 'D') , to_char(RR.run_result_id) , decode(:b0, 'A', decode(EE.entry_type, 'A', EE.target_entry_id, 'R', EE.target_entry_id, RR.source_id), RR.source_id) , decode(:b0, 'A', nvl(EE.entry_type, 'N'), 'N') , nvl(EE.creator_type, 'X') , EE.cost_allocation_keyflex_id , RR.element_type_id , RRV.input_value_id , RRV.result_value , IV.uom , decode(EL2.costable_type, 'D', decode(decode(RR.source_type, 'E', EE.creator_type, 'N'), 'RR', 2, 'EE', 2, 'NR', 2, 'PR', 2, 3), 1) , RR.jurisdiction_code , decode(IV.uom, 'M', decode(IV.name, 'Pay Value', 1, 0), 0) , to_char(decode(:b2, 0, PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned))), 'YYYY/MM/DD') , EL2.transfer_to_gl_flag , decode(:b3, null , null , hr_cost.get_context_value(:b3, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b5, null , null , hr_cost.get_context_value(:b5, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b7, null , null , hr_cost. get_context_value(:b7, RR.run_result_id, RR.element_type_id, PA.date_earned)) , decode(:b9, null , null , hr_cost.get_context_value(:b9, RR.run_result_id, RR.element_type_id, PA.date_earned)) from pay_assignment_actions AA , pay_payroll_actions PA , per_all_assignments_f PERA , pay_run_results RR , pay_element_entries_f EE , pay_element_types_f ET , pay_element_classifications EC , fnd_currencies FC , pay_input_values_f IV , pay_run_result_values RRV , pay_link_input_values_f LIV , pay_element_links_f EL , pay_element_links_f EL2 where ((((((((((((((((((((((((((((((AA.assignment_action_id=:b11 and AA.payroll_action_id=PA.payroll_action_id) and RR.assignment_action_id=:b11) and RR.status like 'P%') and RR.element_type_id=ET.element_type_id) and RRV.run_result_id=RR.run_result_id) and IV.input_value_id=RRV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between IV.effective_start_date and IV.effective_end_date) and IV.element_type_id=ET.element_type_id) and RRV.result_value is not null ) and (decode(:b13, 'Y', 1, fnd_number.canonical_to_number(RRV.result_value))+decode(LIV.DEFAULT_VALUE, 'M', 0, 0))<>0) and RRV.input_value_id=LIV.input_value_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between LIV.effective_start_date and LIV.effective_end_date) and LIV.costed_flag='Y') and LIV.element_link_i d=EL.element_link_id) and decode(RR.entry_type, 'B', nvl(RR.element_entry_id, RR.source_id), RR.source_id)=EE.element_entry_id(+)) and decode(RR.end_date, null , to_date(:b14, 'YYYY/MM/DD'), hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, to_date(:b14, 'YYYY/MM/DD'))) between EE.effective_start_date(+) and EE.effective_end_date(+)) and RR.element_type_id=ET.element_type_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between ET.effective_start_date and ET.effective_end_date) and ET.classification_id=EC.classification_id) and ET.output_currency_code=FC.currency_code) and (ET.element_type_id+0)=(EL.element_type_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between EL.effective_start_date and EL.effective_end_date) and EL.costable_type<>'N') and ((PA.action_type='B' and hr_cost.cost_bal_adj(nvl(RR.element_entry_id, RR.source_id), PA.date_earned)='Y') or PA.action_type<>'B')) and PERA.assignment_id=:b16) and (PERA.business_group_id+0)=(EL.business_group_id+0)) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PERA.effective_start_date and PERA.effective_end_date) and (((EE.element_entry_id is not null and RR.source_type='E') and EL.element_link_id=EE.element_link_id) or ((((((((((EE.element_entry_id is null or (EE.element_entry_id is not null and RR.source_type<>'E')) and (((EL.payroll_id is not null and EL.payroll_id=PERA.payroll_id) or (EL.link_to_all_payrolls_flag='Y' and PERA.payroll_id is not null )) or EL.payroll_id is null )) and (EL.organization_id=PERA.organization_id or EL.organization_id is null )) and (EL.position_id=PERA.position_id or EL.position_id is null )) and (EL.job_id=PERA.job_id or EL.job_id is null )) and (EL.grade_id=PERA.grade_id or EL.grade_id is null )) and (EL.location_id=PERA.location_id or EL.location_id is null )) and (EL.pay_basis_id=PERA.pay_basis_id or EL.pay_basis_id is null )) and (EL.employment_category=PERA.employment_category or EL.employment_category is null )) and (EL.people_group_id is null or exists (select 1 from pay_assignment_link_usages_f PAL where ((PAL.assignment_id=:b16 and PAL.element_link_id=EL.element_link_id) and decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)) between PAL.effective_start_date and PAL.effective_end_date)))))) and EL2.element_link_id=EL.element_link_id) and decode(:b2, 0, PA.date_earned, decode(EL.costable_type, 'D', PA.date_earned, decode(RR.end_date, null , PA.date_earned, hr_cost.get_rr_date(RR.source_id, RR.source_type, RR.end_date, PA.date_earned)))) between EL2.effective_start_date and EL2.effective_end_date) order by 17, 8, 14
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 ;
a9pf25b5p69c6	declare cursor dp ( p_act in number ) is select distinct paf2 . assignment_id , paa . action_sequence from pay_assignment_actions paa , pay_payroll_actions ppa , per_all_assignments_f paf , per_periods_of_service pos , per_all_assignments_f paf2 where paa . assignment_action_id = p_act and paa . payroll_action_id = ppa . payroll_action_id and paf . assignment_id = paa . assignment_id and ppa . effective_date between paf . effective_start_date and paf . effective_end_date and paf . person_id = pos . person_id and pos . period_of_service_id = paf2 . period_of_service_id ; BEGIN for dprec in dp ( :assactid ) loop begin select 1 into :act_exists from sys . dual where exists ( select null from pay_assignment_actions paa , pay_payroll_actions ppa , pay_action_classifications pcl where paa . assignment_id = dprec . assignment_id and paa . payroll_action_id = ppa . payroll_action_id and ppa . action_type = pcl . action_type and pcl . classification_name = 'SEQUENCED' and paa . action_status not in ( 'C' , 'S' , 'B' ) and paa . action_sequence < dprec . action_sequence ) ; exception when no_data_found then null ; end ; end loop ; END ;
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;
f78ff26qcfjan	update PAY_ASSIGNMENT_ACTIONS set ACTION_STATUS='C' where (rowid=:b0 and ACTION_STATUS<>'S')
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)
g4jp561h1bs98	select /*+ ORDERED USE_NL(ACT EE ET EEV) INDEX(ACT PAY_ASSIGNMENT_ACTIONS_PK, EE PAY_ELEMENT_ENTRIES_F_N50, ET PAY_ELEMENT_TYPES_F_PK, EEV PAY_ELEMENT_ENTRY_VALUES_F_N50) +*/ EE.entry_type , to_char(EE.element_entry_id) , decode(:b0, 'T', decode(EE.entry_type, 'R', to_char(EE.target_entry_id), 'A', to_char(EE.target_entry_id), to_char(EE.original_entry_id)), to_char(EE.original_entry_id)) , EE.element_link_id , to_char(EE.target_entry_id) , EE.subpriority , ET.element_type_id , ET.processing_priority , ET.processing_type , EEV.input_value_id , EEV.screen_entry_value , to_char(null ) , to_char(null ) , 0 , to_char(null ) , to_char(null ) , decode(EE.entry_type, 'S', 1, 'E', 2, 'R', 2, 'A', 2, 'D', 3) , nvl(EE.target_entry_id, EE.element_entry_id) , decode(EE.entry_type, 'E', 2, 1) , to_char(EE.effective_start_date, :b1) , to_char(EE.effective_end_date, :b1) , ET.proration_group_id , pay_retro_pkg.is_retro_entry(EE.creator_type) , to_char(null ) , 'RECALC_NON_RETRO' , 'E' , PEPD.tax_unit_id , to_char(null ) , PEPD.time_definition_id , nvl(ET.time_definition_type, 'N') , to_char(decode(ET.processing_type, 'R', to_date(null , :b1), EE.date_earned), :b1) , decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ) , decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ) , EE.label_identifier , decode(ACT.action_status, 'B', decode(EE.creator_type, 'EE', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b10, :b11:b12, EE.creator_id, ACT.act ion_sequence), 'RR', pay_retro_pkg.process_retro_entry(EE.element_entry_id, EE.element_type_id, :b9:b14, :b11:b16, EE.creator_id, ACT.action_sequence), 1), 1) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_start_date, :b1), null ), 'AE', to_char(EE.source_start_date, :b1), 'AD', to_char(EE.source_start_date, :b1), null ) , decode(EE.creator_type, 'EE', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'RR', decode(:b5, 'N', to_char(EE.source_end_date, :b1), null ), 'AE', to_char(EE.source_end_date, :b1), 'AD', to_char(EE.source_end_date, :b1), null ) from pay_assignment_actions ACT , pay_element_entries_f EE , pay_element_types_f ET , pay_element_entry_values_f EEV , pay_entry_process_details PEPD where (((((((((((((((ACT.assignment_action_id=:b29 and EE.assignment_id=:b30) and ((:b31='N' and to_date(:b32, :b1) between EE.effective_start_date and EE.effective_end_date) or ((:b31='Y' and EE.effective_start_date<=to_date(:b32, :b1)) and EE.effective_end_date>=decode(ET.proration_group_id, null , decode(nvl(ET.time_definition_type, 'N'), 'N', to_date(:b32, :b1), pay_core_utils.get_time_period_start(ACT.payroll_action_id)), pay_interpreter_pkg.prorate_start_date(:b29, ET.proration_group_id))))) and EE.element_type_id=ET.element_type_id) and EE.element_entry_id=PEPD.element_entry_id(+)) and to_date(:b32, :b1) between ET.effective_start_date and ET.effective_end_date) and EEV.elem ent_entry_id(+)=EE.element_entry_id) and EEV.screen_entry_value(+) is not null ) and EE.effective_start_date=EEV.effective_start_date(+)) and EE.effective_end_date=EEV.effective_end_date(+)) and EE.entry_type<>'B') and ET.process_in_run_flag<>'N') and ((:b31='N' or ET.proration_group_id is null ) or (:b31='Y' and exists (select '' from pay_payroll_actions ppa , per_time_periods ptp , pay_element_entries_f pee where (((((pee.element_entry_id=EE.element_entry_id and ppa.payroll_action_id=ACT.payroll_action_id) and ppa.payroll_id=ptp.payroll_id) and to_date(:b32, :b1) between ptp.start_date and ptp.end_date) and pee.effective_start_date<=ptp.end_date) and pee.effective_end_date>=ptp.start_date))))) and not (ACT.action_status='B' and EE.creator_type='P')) and not (ACT.action_status='B' and EE.creator_type='R')) and ((((ET.processing_type='N' or EE.entry_type='D') and nvl(EE.date_earned, to_date('01/01/0001', 'DD/MM/YYYY'))<=to_date(:b32, :b1)) and not exists (select '' from pay_run_results prr where (((prr.source_id=EE.element_entry_id and prr.source_type='E') and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or ((ET.processing_type<>'N' and EE.entry_type<>'D') and ((nvl(ET.once_each_period_flag, 'N')='Y' and not exists (select '' from pay_run_results prr , pay_assignment_actions paa , pay_payroll_actions ppa , per_time_periods ptp , per_time_periods ptp1 , pay_payroll_actions ppa1 where (((((((((((prr.source_id=EE.element_entry_id and prr.source_type='E') and paa.assignment_action_id=prr.assignment_action_id) and ppa.payroll_action_id=paa.payroll_action_id) and ptp.payroll_id=ppa.payroll_id) and ppa.date_earned between ptp.start_date and ptp.end_date) and ppa1.payroll_action_id=ACT.payroll_action_id) and ptp1.payroll_id=ppa1.payroll_id) and ppa1.date_earned between ptp1.start_date and ptp1.end_date) and ptp.time_period_id=ptp1.time_period_id) and nvl(prr.status, 'U') not in ('B', 'U')) and not exists (select '' from pay_run_results prr2 where (source_id=prr.run_result_id and source_type='R'))))) or nvl(ET.once_each_period_flag, 'N')='N')))) order by 8 asc , 6 asc , 7 asc , 17 asc , 18 asc , 19 asc , 20 asc
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
g9fa98tmdyg0y	SELECT 'X' FROM PAY_ASSIGNMENT_ACTIONS WHERE ASSIGNMENT_ACTION_ID = :B1
gj45bp5w5anrf	SELECT DISTINCT PEE.ASSIGNMENT_ID , PET.PRORATION_GROUP_ID FROM PAY_ELEMENT_ENTRIES_F PEE, PAY_ELEMENT_TYPES_F PET WHERE PEE.ELEMENT_ENTRY_ID = :B2 AND PEE.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID AND PEE.EFFECTIVE_START_DATE <= :B1 AND PEE.EFFECTIVE_END_DATE >= PAY_INTERPRETER_PKG.TIME_FN(:B3 , PET.PRORATION_GROUP_ID , :B2 ) AND :B1 BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE
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: 127,677,929
• Captured Segments account for 65.0% of Total

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 9,344
• Captured Segments account for 1.2% 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

No data exists for this section of the report.

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