|  Worldwide Secure Search All Blogs CRM On Demand Discussion Forums Documentation Education Oracle.com PartnerNetwork (Public Only) Technology Network Video and Multimedia PRODUCTS AND SERVICESINDUSTRIESSUPPORTPARTNERSCOMMUNITIESABOUT

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 Cluster Host VIS 118468335 VIS 1 10.1.0.4.0 NO oasb-db.oasb.hp Snap Id Snap Time Sessions Cursors/Session Begin Snap: 959 31-Jul-07 08:26:07 1989 180.4 End Snap: 960 31-Jul-07 09:26:09 2000 215.7 Elapsed:   60.03 (mins)     DB Time:   126.74 (mins)     Report Summary Cache Sizes (end) Buffer Cache: 5,024M Std Block Size: 8K Shared Pool Size: 3,104M Log Buffer: 2,048K Load Profile Per Second Per Transaction Redo size: 2,332,287.57 22,086.95 Logical reads: 117,401.45 1,111.80 Block changes: 14,513.81 137.45 Physical reads: 81.20 0.77 Physical writes: 222.13 2.10 User calls: 4,538.64 42.98 Parses: 1,900.89 18.00 Hard parses: 2.01 0.02 Sorts: 1,230.05 11.65 Logons: 1.00 0.01 Executes: 9,038.10 85.59 Transactions: 105.60   % Blocks changed per Read: 12.36 Recursive Call %: 77.66 Rollback per transaction %: 23.59 Rows per Sort: 14.47 Instance Efficiency Percentages (Target 100%) Buffer Nowait %: 99.99 Redo NoWait %: 100.00 Buffer Hit %: 99.94 In-memory Sort %: 100.00 Library Hit %: 99.99 Soft Parse %: 99.89 Execute to Parse %: 78.97 Latch Hit %: 99.81 Parse CPU to Parse Elapsd %: 98.30 % Non-Parse CPU: 95.15 Shared Pool Statistics Begin End Memory Usage %: 47.60 62.09 % SQL with executions>1: 85.28 83.13 % Memory for SQL w/exec>1: 82.26 65.40 Top 5 Timed Events Event Waits Time(s) Percent Total DB Time Wait Class CPU time   6,744 88.68   db file sequential read 153,350 570 7.50 User I/O log file parallel write 603,016 132 1.74 System I/O SQL*Net more data from client 851,747 110 1.45 Network enq: TX - row lock contention 226 84 1.10 Application 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 SGA Statistics Resource Limit Statistics init.ora Parameters Back to Top Wait Events Statistics Wait Events Background Wait Events Time Model Statistics Operating System Statistics Service Statistics Service Wait Class Stats 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 Timeouts Total Wait Time (s) Avg wait (ms) Waits /txn db file sequential read 153,350 0 570 4 0.40 log file parallel write 603,016 0 132 0 1.59 SQL*Net more data from client 851,747 0 110 0 2.24 enq: TX - row lock contention 226 0 84 370 0.00 log file sync 164,917 0 82 0 0.43 db file scattered read 14,265 0 54 4 0.04 db file parallel write 78,124 0 39 0 0.21 buffer busy waits 35,400 2 31 1 0.09 read by other session 9,961 0 22 2 0.03 enq: TX - index contention 4,241 0 21 5 0.01 SQL*Net message to client 17,055,227 0 16 0 44.84 enq: UL - contention 482 3 15 31 0.00 library cache pin 1,492 0 14 9 0.00 enq: TM - contention 5 0 11 2,200 0.00 rdbms ipc reply 2,963 3 9 3 0.01 SQL*Net more data to client 689,372 0 8 0 1.81 PX Deq Credit: send blkd 1,830 0 6 3 0.00 latch: library cache 14,205 0 6 0 0.04 PX Deq: Signal ACK 214 84 4 19 0.00 SQL*Net break/reset to client 26,902 0 4 0 0.07 direct path read temp 1,652 0 3 2 0.00 enq: DV - contention 89 0 1 17 0.00 library cache load lock 153 0 1 9 0.00 control file parallel write 1,574 0 1 1 0.00 local write wait 1,336 0 1 0 0.00 latch: library cache pin 1,428 0 1 0 0.00 direct path write temp 1,966 0 1 0 0.01 control file sequential read 1,139 0 1 0 0.00 enq: RO - fast object reuse 228 0 0 2 0.00 latch: shared pool 2,286 0 0 0 0.01 process startup 19 0 0 16 0.00 PX qref latch 57 22 0 5 0.00 enq: SQ - contention 1,720 0 0 0 0.00 latch: cache buffers chains 1,166 0 0 0 0.00 LGWR wait for redo copy 5,475 1 0 0 0.01 latch: session allocation 713 0 0 0 0.00 latch: undo global data 1,613 0 0 0 0.00 direct path read 200 0 0 1 0.00 enq: CU - contention 25 0 0 6 0.00 latch: In memory undo latch 1,082 0 0 0 0.00 enq: HW - contention 46 0 0 2 0.00 latch free 326 0 0 0 0.00 enq: TX - contention 77 0 0 1 0.00 kksfbc child completion 1 1 0 50 0.00 control file single write 124 0 0 0 0.00 latch: cache buffers lru chain 73 0 0 0 0.00 latch: library cache lock 43 0 0 0 0.00 enq: TX - allocate ITL entry 11 0 0 2 0.00 latch: object queue header operation 51 0 0 0 0.00 latch: redo allocation 62 0 0 0 0.00 latch: row cache objects 23 0 0 0 0.00 latch: enqueue hash chains 29 0 0 0 0.00 latch: cache buffer handles 23 0 0 0 0.00 direct path write 1,412 0 0 0 0.00 enq: FB - contention 26 0 0 0 0.00 enq: PS - contention 29 0 0 0 0.00 latch: messages 5 0 0 0 0.00 PX Deq: Table Q qref 22 0 0 0 0.00 undo segment extension 1,353 1,341 0 0 0.00 row cache lock 11 0 0 0 0.00 buffer deadlock 628 625 0 0 0.00 SQL*Net message from client 17,055,214 0 3,963,880 232 44.84 pipe get 13,308 6,695 17,575 1,321 0.03 queue messages 1,260 971 10,189 8,086 0.00 PX Idle Wait 2,736 2,400 4,710 1,722 0.01 Queue Monitor Wait 120 120 3,504 29,196 0.00 wakeup time manager 1,464 706 3,142 2,146 0.00 PL/SQL lock timer 58 55 1,367 23,573 0.00 PX Deq: Execution Msg 7,040 47 220 31 0.02 jobq slave wait 20 20 59 2,931 0.00 PX Deq: Execute Reply 4,890 2 30 6 0.01 PX Deq: Table Q Normal 1,830 1 18 10 0.00 class slave wait 1 1 5 4,883 0.00 PX Deq: Msg Fragment 2,014 0 1 0 0.01 PX Deq Credit: need buffer 793 0 0 0 0.00 PX Deq: Parse Reply 139 0 0 0 0.00 PX Deq: Join ACK 176 0 0 0 0.00 PX Deq: Table Q Sample 68 0 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 Timeouts Total Wait Time (s) Avg wait (ms) Waits /txn log file parallel write 603,018 0 132 0 1.59 db file parallel write 78,124 0 39 0 0.21 db file scattered read 2,843 0 6 2 0.01 db file sequential read 800 0 1 1 0.00 control file parallel write 1,574 0 1 1 0.00 control file sequential read 632 0 0 0 0.00 buffer busy waits 573 0 0 0 0.00 rdbms ipc reply 2,514 0 0 0 0.01 LGWR wait for redo copy 5,475 1 0 0 0.01 latch: library cache 1,032 0 0 0 0.00 direct path read 200 0 0 1 0.00 process startup 3 0 0 19 0.00 control file single write 124 0 0 0 0.00 latch: shared pool 366 0 0 0 0.00 latch free 109 0 0 0 0.00 latch: redo allocation 57 0 0 0 0.00 latch: session allocation 130 0 0 0 0.00 latch: library cache pin 79 0 0 0 0.00 latch: library cache lock 24 0 0 0 0.00 latch: undo global data 23 0 0 0 0.00 latch: cache buffers chains 33 0 0 0 0.00 latch: cache buffers lru chain 24 0 0 0 0.00 direct path write 150 0 0 0 0.00 latch: enqueue hash chains 17 0 0 0 0.00 latch: messages 5 0 0 0 0.00 latch: object queue header operation 16 0 0 0 0.00 latch: In memory undo latch 14 0 0 0 0.00 buffer deadlock 1 1 0 0 0.00 rdbms ipc message 356,475 9,848 27,909 78 0.94 Queue Monitor Wait 120 120 3,504 29,196 0.00 smon timer 12,426 0 3,439 277 0.03 wakeup time manager 1,464 706 3,142 2,146 0.00 Back to Wait Events Statistics Back to Top Time Model Statistics ordered by Time (seconds) desc Statistic Name Time (seconds) % Total DB Time DB time 7,604.59 100.00 DB CPU 6,743.70 88.68 sql execute elapsed time 6,079.62 79.95 inbound PL/SQL rpc elapsed time 1,968.03 25.88 PL/SQL execution elapsed time 1,917.30 25.21 background elapsed time 745.36 9.80 background cpu time 529.87 6.97 parse time elapsed 287.89 3.79 hard parse elapsed time 184.99 2.43 Java execution elapsed time 157.10 2.07 connection management call elapsed time 6.64 0.09 sequence load elapsed time 6.09 0.08 PL/SQL compilation elapsed time 2.86 0.04 failed parse elapsed time 1.49 0.02 hard parse (sharing criteria) elapsed time 0.57 0.01 hard parse (bind mismatch) elapsed time 0.53 0.01 failed parse (out of shared memory) elapsed t 0.00 0.00 Back to Wait Events Statistics Back to Top Operating System Statistics No data exists for this section of the report. 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 6,277.10 5,597.50 155,243 341,902,283 SYS$USERS 1,326.20 1,144.80 67,793 40,104,866 SYS$BACKGROUND 0.00 0.00 51,904 40,563,893 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 118,022 42,346 54,739 7,269 0 0 12,991,478 12,754 SYS$USERS 39,728 17,782 2,723 111 0 0 5,599,538 626 SYS$BACKGROUND 26,514 4,942 1,758 51 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 308 308 2 154.15 4.05 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA... 251 251 4 62.66 3.30 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 192 191 37,275 0.01 2.53 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V... 178 177 64 2.77 2.33 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 166 154 4 41.57 2.19 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit... 154 85 5,000 0.03 2.02 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS... 141 140 480 0.29 1.85 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 132 48 212 0.62 1.73 g0g2sj2by3p75 JDBC Thin Client BEGIN WF_EVENT.LISTEN ( p_ag... 115 114 26,374 0.00 1.51 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA... 100 74 7,199 0.01 1.32 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce... 95 89 3 31.74 1.25 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 94 81 1,000 0.09 1.24 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G... 94 11 8,401 0.01 1.24 gmrwcu0hdcp8b JDBC Thin Client begin :v1 := CS_SR_CHILD_AUDIT... 87 87 1,379,263 0.00 1.15 cgb6kp2umq52a   select t.schema, t.name, t.f... 85 2 8,403 0.01 1.12 2spgk3k0f7quz CSCCCCRC SELECT * FROM CS_INCIDENTS_ALL... 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 308 308 2 154.15 4.05 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA... 251 251 4 62.66 3.30 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 191 192 37,275 0.01 2.53 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V... 177 178 64 2.77 2.33 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 154 166 4 38.43 2.19 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit... 140 141 480 0.29 1.85 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 114 115 26,374 0.00 1.51 3prk3vg9u0abb JDBC Thin Client BEGIN FND_GLOBAL.APPS_INITIA... 89 95 3 29.52 1.25 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 87 87 1,379,263 0.00 1.15 cgb6kp2umq52a   select t.schema, t.name, t.f... 85 154 5,000 0.02 2.02 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS... 81 94 1,000 0.08 1.24 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G... 74 100 7,199 0.01 1.32 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce... 48 132 212 0.23 1.73 g0g2sj2by3p75 JDBC Thin Client BEGIN WF_EVENT.LISTEN ( p_ag... 11 94 8,401 0.00 1.24 gmrwcu0hdcp8b JDBC Thin Client begin :v1 := CS_SR_CHILD_AUDIT... 2 85 8,403 0.00 1.12 2spgk3k0f7quz CSCCCCRC SELECT * FROM CS_INCIDENTS_ALL... 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: 422,839,177 Captured SQL accounts for 17.3% of Total Buffer Gets Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 25,878,632 4 6,469,658.00 6.12 250.63 250.63 bkxrrs52m7d8p WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 21,989,268 4 5,497,317.00 5.20 153.73 166.27 7g05xfvc5vp74 ARTERRPW BEGIN arp_run.revenue_recognit... 21,704,522 2 10,852,261.00 5.13 308.30 308.30 ghw9svn8x4vzu WSHPSRS BEGIN WSH_PICK_LIST.RELEASE_BA... 12,660,749 1 12,660,749.00 2.99 28.73 70.26 05s9358mm6vrr   begin dbms_feature_usage_inter... 11,858,816 5,000 2,371.76 2.80 84.63 153.63 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS... 11,224,113 1 11,224,113.00 2.65 22.80 57.23 2vpmsug2fa9rf MMON_SLAVE select atc + ix, NULL, NULL ... 11,034,100 1,379,263 8.00 2.61 87.15 87.15 cgb6kp2umq52a   select t.schema, t.name, t.f... 9,763,242 480 20,340.09 2.31 139.73 140.93 bt0w082dfrm8v WSHINTERFACE BEGIN WSH_SHIP_CONFIRM_ACTIONS... 9,283,634 1,000 9,283.63 2.20 81.02 94.49 2fjd6cndjby9p ARTERRPW INSERT INTO RA_CUST_TRX_LINE_G... 8,950,798 64 139,856.22 2.12 177.30 177.52 0z318y6g3uagc INCTCW declare l_retstat varchar2 ( 3... 8,565,408 3 2,855,136.00 2.03 88.57 95.21 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 6,230,296 12,395 502.65 1.47 72.07 72.17 4yak7x2zqz0dh WSHFRREL BEGIN inv_transfer_order_pvt.f... 5,182,107 1,554,227 3.33 1.23 42.64 42.64 c4y7jp0q2awbf   SELECT PROFILE_OPTION_VALUE FR... 5,000,305 37,275 134.15 1.18 191.49 192.22 6h2tpcxpymqu7 JDBC Thin Client BEGIN :1 := FND_AOLJ_UTIL.is_V... Back to SQL Statistics Back to Top SQL ordered by Reads Total Disk Reads: 292,471 Captured SQL accounts for 33.1% of Total Disk Reads Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text 27,615 5,000 5.52 9.44 84.63 153.63 64qc329wgjv39 PYUSLV select /*+ ORDERED INDEX(ASS... 23,524 1 23,524.00 8.04 28.73 70.26 05s9358mm6vrr   begin dbms_feature_usage_inter... 17,164 16,946 1.01 5.87 31.80 70.14 3vy5h9xkfv1s5 OEXOETEL INSERT INTO WF_ITEM_ATTRIBUTE_... 16,089 1 16,089.00 5.50 22.80 57.23 2vpmsug2fa9rf MMON_SLAVE select atc + ix, NULL, NULL ... 14,651 801 18.29 5.01 4.59 65.14 3dssuqfjsynrk asn.lead.server.LeadUwqAM SELECT count(1) FROM (SELECT *... 10,125 801 12.64 3.46 36.19 49.85 8c8cf4vtv4tx2 asn.lead.server.LeadUwqAM SELECT * FROM ( SELECT LeadEO.... 9,504 1 9,504.00 3.25 15.21 17.87 bb995vqx5y1zd SQL*Plus select /*+ cursor_sharing_exa... 8,433 7,199 1.17 2.88 74.24 100.43 1q78dwnrrkf6c asn.lead.server.LeadUwqAM BEGIN ASN_SALES_PVT.Lead_Proce... 6,922 3 2,307.33 2.37 88.57 95.21 8c30hkqv9n7cr OEHVIMP BEGIN OE_BULK_ORDER_IMPORT_PVT... 3,067 401 7.65 1.05 39.30 49.46 1kjhvys1sd1sg ap.oie.server.WebExpensesAM BEGIN fnd_msg_pub.initialize;A... Back to SQL Statistics Back to Top SQL ordered by Executions Total Executions: 32,552,079 Captured SQL accounts for 22.6% of Total Executions Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text 1,554,227 513,717 0.33 0.00 0.00 c4y7jp0q2awbf   SELECT PROFILE_OPTION_VALUE FR... 1,404,081 1,255,022 0.89 0.00 0.00 6cjfxb1c4kx16   SELECT PROFILE_OPTION_ID, APP... 1,379,263 1,379,263 1.00 0.00 0.00 cgb6kp2umq52a   select t.schema, t.name, t.f... 1,379,070 1,379,070 1.00 0.00 0.00 8bsm049u7thjd   select min(next_date) from "AP... 201,532 201,532 1.00 0.00 0.00 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL 111,665 84,115 0.75 0.00 0.00 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F... 107,708 106,507 0.99 0.00 0.00 91hakq9n36htp ap.oie.server.WebExpensesAM SELECT TEXT_VALUE FROM WF_ITEM... 97,071 1,650,197 17.00 0.00 0.00 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ... 76,744 75,505 0.98 0.00 0.00 0b85w9vv0hbt1 hxc.selfservice.timecard.server.TimecardAM UPDATE WF_ITEM_ATTRIBUTE_VALUE... 52,413 52,413 1.00 0.00 0.00 2rg930brttdn3 ap.oie.server.WebExpensesAM INSERT INTO WF_NOTIFICATION_AT... Back to SQL Statistics Back to Top SQL ordered by Parse Calls Total Parse Calls: 6,846,345 Captured SQL accounts for 74.4% of Total Parse Calls Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text 1,379,263 1,379,263 20.15 cgb6kp2umq52a   select t.schema, t.name, t.f... 1,379,070 700 20.14 20rc3cmapyvnz   select q_name, state, delay,... 1,379,070 1,379,070 20.14 8bsm049u7thjd   select min(next_date) from "AP... 201,532 201,532 2.94 avc1jqzz04wpr JDBC Thin Client SELECT 'x' FROM DUAL 111,665 111,665 1.63 fmfdkztk8vx23   SELECT CATEGORY, SEVERITY, F... 97,069 97,071 1.42 cwyx16zn1hpfb JDBC Thin Client select parameter, value from ... 40,118 40,118 0.59 162ttnv4ubqun OEXOETEL begin OE_DS_PVT.Check_PO_Appr... 38,000 38,000 0.56 6gnth2mfbs2nq INVTTMTX declare v_ret number := 0... 37,119 37,119 0.54 8camsgjsr9zya OEXOETEL begin OE_TRANSACTION_TYPES_PK... 35,000 35,000 0.51 97mt0g20bcfc3 PYUSLV begin ... Back to SQL Statistics Back to Top SQL ordered by Sharable Memory Only Statements with Sharable Memory greater than 1048576 are displayed Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text 2,274,771 2,400 0.07 8ay7m8qubw98j POXBWVRP select * from PO_TAX_LINES_SUM... 2,054,329 138 0.06 azfadzhfxbxj3 ARXTWMAI SELECT ROW_ID, APBA_INACTIVE_D... 1,999,864 84 0.06 2fr5f5xzmffd8 POXPRPOP SELECT decode ( : P_sortby , ... 1,845,716 17 0.06 9trqpr8qyg7xm POXPRPOP SELECT distinct pol . line_num... 1,753,326 6,964 0.05 8q8zmrwmrccz4 OEXOETEL SELECT /*+ ORDERED USE_NL(adj ... 1,667,129 2,401 0.05 bf4kcv5v66czb ibuSRDetails.jsp SELECT 'NOTE', '2', b.creat... 1,565,325 2,405 0.05 bk9zgysk994av OEXOETEL SELECT /*+ ORDERED USE_NL(qpq ... 1,399,245 1 0.04 0tdy0gjxn6wrb RAXMTR select /*+ cursor_sharing_exa... 1,366,690 1 0.04 dkvvgc7c1wksu RAXTRX select CONTRACT_ID||'~'||L.AGR... 1,366,025 1 0.04 bb995vqx5y1zd SQL*Plus select /*+ cursor_sharing_exa... 1,313,557 4,805 0.04 fc74w8q18dtdu OEXOETEL SELECT /*+ ORDERED USE_NL(QPQ ... 1,274,880 400 0.04 2nfc4vng01c8t POXPOVPO SELECT END_DATE, START_DATE, R... 1,239,102 79 0.04 3c086a4sm741b ARXAGE select decode ( UPPER ( : p_or... 1,234,417 1 0.04 496za9aq6dd71 RAXMTR select /*+ cursor_sharing_exa... 1,217,967 400 0.04 0nr5vc1336tr9 APXINWKB SELECT DESTINATION_TYPE_CODE, ... 1,164,610 400 0.04 c1j60ttadh9jj ap.oie.history.server.ExpenseReportsPageAM SELECT * FROM (SELECT TO_CHAR(... 1,131,593 1 0.03 879tscdjdfycd RAXMTR select /*+ cursor_sharing_exa... 1,060,444 38,000 0.03 25bkagv1j2xf7 INVTTMTX INSERT INTO MTL_MATERIAL_TRAN... 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
05s9358mm6vrr	begin dbms_feature_usage_internal.exec_db_usage_sampling(:bind1); end;
0b85w9vv0hbt1	UPDATE WF_ITEM_ATTRIBUTE_VALUES SET TEXT_VALUE = :B4 WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND NAME = :B1
0nr5vc1336tr9	SELECT DESTINATION_TYPE_CODE, DISTRIBUTION_LINE_NUMBER, LINE_TYPE, AMOUNT, VAT_CODE, TAX_CODE_ID, TAX_CODE_OVERRIDE_FLAG, TAX_RECOVERY_RATE, TAX_RECOVERABLE_FLAG, TAX_RECOVERY_OVERRIDE_FLAG, ACCOUNTING_DATE, AMOUNT_INCLUDES_TAX_FLAG, ASSETS_TRACKING_FLAG, DESCRIPTION, TYPE_1099, INCOME_TAX_REGION, QUANTITY_INVOICED, UNIT_PRICE, PO_NUMBER, PO_LINE_NUMBER, PO_LINE_LOCATION_NUMBER, PO_DISTRIBUTION_NUMBER, RECEIPT_NUMBER, PROJECT, TASK, AWARD_ID, EXPENDITURE_TYPE, EXPENDITURE_ORGANIZATION_NAME, EXPE NDITURE_ITEM_DATE, PA_QUANTITY, UNIT_OF_MEASURE, PREPAY_DISTRIBUTION_ID, PREPAY_NUMBER, PREPAY_DIST_NUMBER, PREPAY_AMOUNT_REMAINING, PREPAY_TAX_PARENT_ID, INVOICE_INCLUDES_PREPAY_FLAG, STAT_AMOUNT, AWT_GROUP_NAME, AWT_CREATION_METHOD, POSTED_STATUS_DISP, START_EXPENSE_DATE, MERCHANT_DOCUMENT_NUMBER, MERCHANT_NAME, MERCHANT_TAX_REG_NUMBER, MERCHANT_TAXPAYER_ID, MERCHANT_REFERENCE, COUNTRY_OF_SUPPLY, USSGL_TRANSACTION_CODE, LAST_UPDATE_DATE, CREATION_DATE, ROW_ID, ACCRUAL_POSTED_FLAG, ACCTS_PAY_CO DE_COMBINATION_ID, ASSETS_ADDITION_FLAG, INVOICE_DISTRIBUTION_ID, ATTRIBUTE14, ATTRIBUTE1, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE15, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE_CATEGORY, AWT_FLAG, AWT_GROSS_AMOUNT, AWT_GROUP_ID, AWT_INVOICE_ID, AWT_ORIGIN_GROUP_ID, AWT_TAX_RATE_ID, BASE_AMOUNT, BASE_INVOICE_PRICE_VARIANCE, BASE_QUANTITY_VARIANCE, BATCH_ID, CASH_JE_BATCH_ID, CASH_POSTED_FLAG, CREATED_BY, DIST_COD E_COMBINATION_ID, ENCUMBERED_FLAG, EXCHANGE_DATE, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_RATE_VARIANCE, EXPENDITURE_ORGANIZATION_ID, INVOICE_ID, INVOICE_PRICE_VARIANCE, JE_BATCH_ID, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, LINE_TYPE_LOOKUP_CODE, MATCH_STATUS_FLAG, ORG_ID, OTHER_INVOICE_ID, PACKET_ID, PARENT_INVOICE_ID, PA_ADDITION_FLAG, PERIOD_NAME, POSTED_AMOUNT, POSTED_BASE_AMOUNT, POSTED_FLAG, PO_ACCRUE_ON_RECEIPT_FLAG, PO_CODE_COMBINATION_ID, PO_DISTRIBUTION_ID, PRICE_VAR_CODE_COMBINATION_ID , PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, PROJECT_ACCOUNTING_CONTEXT, PROJECT_ID, QUANTITY_VARIANCE, AMOUNT_VARIANCE, BASE_AMOUNT_VARIANCE, RATE_VAR_CODE_COMBINATION_ID, REFERENCE_1, REFERENCE_2, REQUEST_ID, REVERSAL_FLAG, SET_OF_BOOKS_ID, SET_OF_BOOKS_SHORT_NAME, TASK_ID, TAX_CALCULATED_FLAG, USSGL_TRX_CODE_CONTEXT, INVOICE_NUM, PARENT_INVOICE_NUM, BATCH_NAME, INCOME_TAX_REGION_NAME, POSTED_STATUS, JE_BATCH_NAME, CASH_JE_BATCH_NAME, CHART_OF_ACCOUNTS_ID, SET_OF_BOOKS_NAME, PO_H EADER_ID, PO_LINE_ID, LINE_LOCATION_ID, RCV_TRANSACTION_ID, UNIT_MEAS_LOOKUP_CODE, TAX_TYPE, MATCHED_UOM_LOOKUP_CODE, PARENT_REVERSAL_ID, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GL