WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
DMSDB3780482274dmsdb110.2.0.4.0NOdmsdb.sinotrans.com

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:839826-Jun-12 16:00:4135 35.8
End Snap:839926-Jun-12 17:00:4344 31.0
Elapsed:  60.02 (mins)  
DB Time:  71.55 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 7,552M 7,552MStd Block Size: 8K
Shared Pool Size: 592M 592MLog Buffer: 14,332K

Load Profile

Per SecondPer Transaction
Redo size: 55,628.05 194,130.53
Logical reads: 86,200.54 300,822.25
Block changes: 212.98 743.25
Physical reads: 11,250.84 39,263.13
Physical writes: 12.16 42.43
User calls: 30.81 107.53
Parses: 5.44 18.99
Hard parses: 0.58 2.03
Sorts: 2.67 9.30
Logons: 0.01 0.02
Executes: 67.29 234.81
Transactions: 0.29 

% Blocks changed per Read: 0.25Recursive Call %: 84.42
Rollback per transaction %: 0.48Rows per Sort: 26.50

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.90Redo NoWait %: 100.00
Buffer Hit %: 86.95In-memory Sort %: 100.00
Library Hit %: 96.91Soft Parse %: 89.32
Execute to Parse %: 91.91Latch Hit %: 99.89
Parse CPU to Parse Elapsd %: 88.62% Non-Parse CPU: 99.76

Shared Pool Statistics

BeginEnd
Memory Usage %: 45.16 44.91
% SQL with executions>1: 79.51 72.18
% Memory for SQL w/exec>1: 76.33 72.65

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  3,204  74.6 
enq: TX - row lock contention 331 952 2,876 22.2Application
db file scattered read 3,650,992 278 0 6.5User I/O
read by other session 305,108 45 0 1.0User I/O
db file sequential read 443,824 20 0 .5User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 4,280.84 99.71
DB CPU 3,204.47 74.64
parse time elapsed 14.87 0.35
hard parse elapsed time 13.96 0.33
PL/SQL execution elapsed time 6.43 0.15
PL/SQL compilation elapsed time 2.79 0.07
hard parse (sharing criteria) elapsed time 0.27 0.01
connection management call elapsed time 0.26 0.01
hard parse (bind mismatch) elapsed time 0.23 0.01
sequence load elapsed time 0.14 0.00
repeated bind elapsed time 0.06 0.00
failed parse elapsed time 0.04 0.00
DB time 4,293.12  
background elapsed time 62.42  
background cpu time 16.80  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Application 643 50.23 952 1481 0.62
User I/O 4,400,353 0.00 342 0 4,263.91
System I/O 9,743 0.00 33 3 9.44
Commit 690 0.00 4 6 0.67
Concurrency 7,187 0.08 4 1 6.96
Network 115,454 0.00 3 0 111.87
Other 371 0.00 3 7 0.36
Configuration 2 0.00 0 46 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: TX - row lock contention 331 97.58 952 2876 0.32
db file scattered read 3,650,992 0.00 278 0 3,537.78
read by other session 305,108 0.00 45 0 295.65
db file sequential read 443,824 0.00 20 0 430.06
log file parallel write 2,365 0.00 14 6 2.29
control file parallel write 1,560 0.00 10 7 1.51
log file sequential read 494 0.00 8 15 0.48
log file sync 690 0.00 4 6 0.67
latch: cache buffers chains 7,164 0.00 4 1 6.94
latch free 220 0.00 3 12 0.21
SQL*Net more data from client 6,688 0.00 2 0 6.48
Log archive I/O 491 0.00 1 3 0.48
SQL*Net message to client 103,884 0.00 0 0 100.66
control file sequential read 4,831 0.00 0 0 4.68
SQL*Net break/reset to client 312 0.00 0 1 0.30
SQL*Net more data to client 4,882 0.00 0 0 4.73
os thread startup 4 0.00 0 27 0.00
log file switch completion 2 0.00 0 46 0.00
cursor: pin S wait on X 7 85.71 0 9 0.01
log file single write 2 0.00 0 5 0.00
latch: shared pool 3 0.00 0 1 0.00
latch: cache buffers lru chain 56 0.00 0 0 0.05
LGWR wait for redo copy 59 0.00 0 0 0.06
direct path read 403 0.00 0 0 0.39
latch: object queue header operation 32 0.00 0 0 0.03
buffer busy waits 8 0.00 0 0 0.01
cursor: pin S 4 0.00 0 0 0.00
direct path write 26 0.00 0 0 0.03
latch: library cache 1 0.00 0 0 0.00
SQL*Net message from client 103,875 0.00 48,245 464 100.65
Streams AQ: waiting for time management or cleanup tasks 21 61.90 3,721 177196 0.02
wait for unread message on broadcast channel 3,599 99.89 3,516 977 3.49
Streams AQ: waiting for messages in the queue 724 99.45 3,516 4856 0.70
virtual circuit status 120 100.00 3,508 29234 0.12
Streams AQ: qmn slave idle wait 128 0.00 3,493 27288 0.12
Streams AQ: qmn coordinator idle wait 263 51.33 3,493 13281 0.25
jobq slave wait 40 100.00 117 2930 0.04
class slave wait 2 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 2,365 0.00 14 6 2.29
control file parallel write 1,560 0.00 10 7 1.51
log file sequential read 494 0.00 8 15 0.48
Log archive I/O 491 0.00 1 3 0.48
events in waitclass Other 175 0.00 0 1 0.17
os thread startup 4 0.00 0 27 0.00
control file sequential read 3,237 0.00 0 0 3.14
log file single write 2 0.00 0 5 0.00
latch: shared pool 1 0.00 0 0 0.00
latch: cache buffers chains 2 0.00 0 0 0.00
direct path read 11 0.00 0 0 0.01
direct path write 12 0.00 0 0 0.01
rdbms ipc message 13,383 86.52 37,122 2774 12.97
Streams AQ: waiting for time management or cleanup tasks 21 61.90 3,721 177196 0.02
pmon timer 1,215 100.00 3,513 2891 1.18
Streams AQ: qmn slave idle wait 128 0.00 3,493 27288 0.12
Streams AQ: qmn coordinator idle wait 263 51.33 3,493 13281 0.25
smon timer 13 84.62 3,363 258727 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 333,296
IDLE_TIME 2,535,083
IOWAIT_TIME 10,880
NICE_TIME 67
SYS_TIME 31,614
USER_TIME 300,536
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 16,831,463,424
NUM_CPUS 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
dmsdb 4,285.80 3,198.10 40,518,934 310,092,190
SYS$USERS 7.30 6.30 577 306,774
SYS$BACKGROUND 0.00 0.00 38 48,801
dmsdbXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
dmsdb 4399705 34184 7179 412 0 0 114214 278
SYS$USERS 573 33 1 0 0 0 1192 1
SYS$BACKGROUND 75 8 7 11 0 0 0 0

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)CPU Time (s)Executions Elap per Exec (s) % Total DB Time SQL IdSQL ModuleSQL Text
1,205 1,202 17,374 0.07 28.07 3p3sp04ynzub2   SELECT LOC.INV_ITEM_LOC_STOR_I...
775 3 16 48.44 18.05 1md6gz42bf2fj   BEGIN sp_rf_inbound_rec_hub(:1...
772 0 376 2.05 17.99 b7y2n3xwj7ab5   UPDATE INV_ITEM T SET T.STOR_Q...
220 216 34 6.46 5.12 9dbncmqtzbssa   BEGIN sp_rf_pick_check_hub(:1,...
195 190 56 3.49 4.55 6dy0n540kjb7p   select baselmline0_.BASE_LM_LI...
183 4 17,374 0.01 4.27 4hcbvgyg6dh65   DELETE FROM INV_ITEM_LOC_STOR ...
180 170 58 3.11 4.20 cyq9mdbhzsfxu   select outboundor0_.OUTBOUND_O...
179 177 75 2.39 4.18 716k8qytzxrzt   SELECT T.BASE_LM_ID FROM BASE_...
162 153 45 3.60 3.78 51xmb5swg37vm   SELECT COUNT(1) FROM BASE_LM_L...
133 132 54 2.46 3.09 3027yph8jytgj   select baselmline0_.BASE_LM_LI...
129 88 12 10.73 3.00 51n5qdjvnrd16   select count(vwinboundo0_.VW_I...
111 102 25 4.46 2.60 35grauy4kpw1w   BEGIN sp_rf_pick_view_hub(:1, ...
111 102 25 4.44 2.59 5xrnu1x47xak2   SELECT T.ITEM_CODE, T.QTY AS Q...
108 106 45 2.41 2.53 5ak02sq9z8dnq   SELECT COUNT(1) FROM OUTBOUND_...
107 90 12 8.89 2.48 4v97annmzfk69   select * from ( select vwinbou...
104 100 45 2.32 2.43 4u2r6axbk44nb   SELECT T.BASE_LM_ID FROM BASE_...
94 86 8 11.75 2.19 c1q1kddqxp6ty   BEGIN sp_rf_out_spus_check(:1,...
87 86 34 2.57 2.03 az9zbgqchjm1w   SELECT COUNT(1) FROM PICKING_O...
85 83 45 1.90 1.99 66p2f72ksuw9s   SELECT T.AUX4, TT.STATUS, T.AU...
75 75 7 10.75 1.75 dkxhxw7swam8f   BEGIN SP_OUT_PICKING_EXECUTE_H...
66 64 34 1.95 1.54 6g94kx8u85889   SELECT NVL(SUM(PLINES.PICKING_...
60 59 34 1.75 1.39 c458kp1y7mcut   SELECT NVL(SUM(PLINE.PICKING_Q...
46 40 21 2.20 1.07 2ss1hwcz3f430   BEGIN sp_rf_check_sn_exist(:1,...
43 37 10 4.33 1.01 2r1svyhycp66w   SELECT POLS.PROCESS_ORDER_LINE...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
1,202 1,205 17,374 0.07 28.07 3p3sp04ynzub2   SELECT LOC.INV_ITEM_LOC_STOR_I...
216 220 34 6.34 5.12 9dbncmqtzbssa   BEGIN sp_rf_pick_check_hub(:1,...
190 195 56 3.39 4.55 6dy0n540kjb7p   select baselmline0_.BASE_LM_LI...
177 179 75 2.36 4.18 716k8qytzxrzt   SELECT T.BASE_LM_ID FROM BASE_...
170 180 58 2.94 4.20 cyq9mdbhzsfxu   select outboundor0_.OUTBOUND_O...
153 162 45 3.39 3.78 51xmb5swg37vm   SELECT COUNT(1) FROM BASE_LM_L...
132 133 54 2.45 3.09 3027yph8jytgj   select baselmline0_.BASE_LM_LI...
106 108 45 2.35 2.53 5ak02sq9z8dnq   SELECT COUNT(1) FROM OUTBOUND_...
102 111 25 4.09 2.60 35grauy4kpw1w   BEGIN sp_rf_pick_view_hub(:1, ...
102 111 25 4.08 2.59 5xrnu1x47xak2   SELECT T.ITEM_CODE, T.QTY AS Q...
100 104 45 2.22 2.43 4u2r6axbk44nb   SELECT T.BASE_LM_ID FROM BASE_...
90 107 12 7.50 2.48 4v97annmzfk69   select * from ( select vwinbou...
88 129 12 7.35 3.00 51n5qdjvnrd16   select count(vwinboundo0_.VW_I...
86 87 34 2.53 2.03 az9zbgqchjm1w   SELECT COUNT(1) FROM PICKING_O...
86 94 8 10.70 2.19 c1q1kddqxp6ty   BEGIN sp_rf_out_spus_check(:1,...
83 85 45 1.83 1.99 66p2f72ksuw9s   SELECT T.AUX4, TT.STATUS, T.AU...
75 75 7 10.75 1.75 dkxhxw7swam8f   BEGIN SP_OUT_PICKING_EXECUTE_H...
64 66 34 1.89 1.54 6g94kx8u85889   SELECT NVL(SUM(PLINES.PICKING_...
59 60 34 1.72 1.39 c458kp1y7mcut   SELECT NVL(SUM(PLINE.PICKING_Q...
40 46 21 1.90 1.07 2ss1hwcz3f430   BEGIN sp_rf_check_sn_exist(:1,...
37 43 10 3.71 1.01 2r1svyhycp66w   SELECT POLS.PROCESS_ORDER_LINE...
4 183 17,374 0.00 4.27 4hcbvgyg6dh65   DELETE FROM INV_ITEM_LOC_STOR ...
3 775 16 0.17 18.05 1md6gz42bf2fj   BEGIN sp_rf_inbound_rec_hub(:1...
0 772 376 0.00 17.99 b7y2n3xwj7ab5   UPDATE INV_ITEM T SET T.STOR_Q...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
175,473,237 17,374 10,099.76 56.52 1201.93 1204.90 3p3sp04ynzub2   SELECT LOC.INV_ITEM_LOC_STOR_I...
22,489,657 34 661,460.50 7.24 215.62 219.63 9dbncmqtzbssa   BEGIN sp_rf_pick_check_hub(:1,...
14,123,410 75 188,312.13 4.55 176.90 179.35 716k8qytzxrzt   SELECT T.BASE_LM_ID FROM BASE_...
10,746,522 56 191,902.18 3.46 189.89 195.49 6dy0n540kjb7p   select baselmline0_.BASE_LM_LI...
10,654,975 25 426,199.00 3.43 102.26 111.41 35grauy4kpw1w   BEGIN sp_rf_pick_view_hub(:1, ...
10,597,912 25 423,916.48 3.41 101.90 111.05 5xrnu1x47xak2   SELECT T.ITEM_CODE, T.QTY AS Q...
10,363,545 54 191,917.50 3.34 132.36 132.69 3027yph8jytgj   select baselmline0_.BASE_LM_LI...
8,634,778 45 191,883.96 2.78 152.54 162.20 51xmb5swg37vm   SELECT COUNT(1) FROM BASE_LM_L...
8,516,690 45 189,259.78 2.74 99.84 104.20 4u2r6axbk44nb   SELECT T.BASE_LM_ID FROM BASE_...
7,404,978 7 1,057,854.00 2.39 75.26 75.27 dkxhxw7swam8f   BEGIN SP_OUT_PICKING_EXECUTE_H...
7,212,429 34 212,130.26 2.32 58.65 59.53 c458kp1y7mcut   SELECT NVL(SUM(PLINE.PICKING_Q...
7,212,203 34 212,123.62 2.32 64.12 66.21 6g94kx8u85889   SELECT NVL(SUM(PLINES.PICKING_...
7,211,958 34 212,116.41 2.32 86.12 87.29 az9zbgqchjm1w   SELECT COUNT(1) FROM PICKING_O...
6,565,379 58 113,196.19 2.11 170.45 180.12 cyq9mdbhzsfxu   select outboundor0_.OUTBOUND_O...
5,183,595 45 115,191.00 1.67 105.82 108.44 5ak02sq9z8dnq   SELECT COUNT(1) FROM OUTBOUND_...
5,183,585 45 115,190.78 1.67 82.51 85.35 66p2f72ksuw9s   SELECT T.AUX4, TT.STATUS, T.AU...
4,959,514 8 619,939.25 1.60 85.62 93.98 c1q1kddqxp6ty   BEGIN sp_rf_out_spus_check(:1,...
4,459,315 8 557,414.38 1.44 39.27 39.30 44hkj0ys4acqb   BEGIN sp_box_putaway_hub(:1, ...
4,089,675 12 340,806.25 1.32 88.25 128.70 51n5qdjvnrd16   select count(vwinboundo0_.VW_I...
3,987,473 12 332,289.42 1.28 89.95 106.67 4v97annmzfk69   select * from ( select vwinbou...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
7,248,431 34 213,189.15 17.89 215.62 219.63 9dbncmqtzbssa   BEGIN sp_rf_pick_check_hub(:1,...
5,637,446 56 100,668.68 13.91 189.89 195.49 6dy0n540kjb7p   select baselmline0_.BASE_LM_LI...
4,938,517 45 109,744.82 12.19 152.54 162.20 51xmb5swg37vm   SELECT COUNT(1) FROM BASE_LM_L...
3,808,559 75 50,780.79 9.40 176.90 179.35 716k8qytzxrzt   SELECT T.BASE_LM_ID FROM BASE_...
3,683,656 34 108,342.82 9.09 86.12 87.29 az9zbgqchjm1w   SELECT COUNT(1) FROM PICKING_O...
3,317,504 45 73,722.31 8.19 105.82 108.44 5ak02sq9z8dnq   SELECT COUNT(1) FROM OUTBOUND_...
3,096,208 58 53,382.90 7.64 170.45 180.12 cyq9mdbhzsfxu   select outboundor0_.OUTBOUND_O...
2,953,179 25 118,127.16 7.29 102.26 111.41 35grauy4kpw1w   BEGIN sp_rf_pick_view_hub(:1, ...
2,953,179 25 118,127.16 7.29 101.90 111.05 5xrnu1x47xak2   SELECT T.ITEM_CODE, T.QTY AS Q...
2,038,778 8 254,847.25 5.03 85.62 93.98 c1q1kddqxp6ty   BEGIN sp_rf_out_spus_check(:1,...
1,792,279 34 52,714.09 4.42 64.12 66.21 6g94kx8u85889   SELECT NVL(SUM(PLINES.PICKING_...
1,772,496 34 52,132.24 4.37 58.65 59.53 c458kp1y7mcut   SELECT NVL(SUM(PLINE.PICKING_Q...
1,577,903 10 157,790.30 3.89 37.12 43.28 2r1svyhycp66w   SELECT POLS.PROCESS_ORDER_LINE...
1,577,903 21 75,138.24 3.89 39.96 46.12 2ss1hwcz3f430   BEGIN sp_rf_check_sn_exist(:1,...
1,439,308 5 287,861.60 3.55 31.59 31.59 0h9m34syhy4p9   SELECT PO.* FROM PROCESS_ORDER...
1,439,308 5 287,861.60 3.55 31.69 31.69 c7xt81q572pvb   BEGIN sp_outbound_order_confir...
1,201,822 7 171,688.86 2.97 75.26 75.27 dkxhxw7swam8f   BEGIN SP_OUT_PICKING_EXECUTE_H...
1,185,587 45 26,346.38 2.93 99.84 104.20 4u2r6axbk44nb   SELECT T.BASE_LM_ID FROM BASE_...
635,203 54 11,763.02 1.57 132.36 132.69 3027yph8jytgj   select baselmline0_.BASE_LM_LI...
489,603 45 10,880.07 1.21 82.51 85.35 66p2f72ksuw9s   SELECT T.AUX4, TT.STATUS, T.AU...
426,685 2 213,342.50 1.05 7.59 7.85 5atbz4fgg9j2q   select pol.Process_Order_Line_...
411,966 2 205,983.00 1.02 7.75 7.75 3f4vxcd4hfsyx   SELECT L.ITEM_CODE, SUM(L.PRO...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
17,374 17,374 1.00 0.00 0.00 2n3g5qy6rwz2z   INSERT INTO PICKING_ORDER_LIST...
17,374 17,359 1.00 0.07 0.07 3p3sp04ynzub2   SELECT LOC.INV_ITEM_LOC_STOR_I...
17,374 17,358 1.00 0.00 0.01 4hcbvgyg6dh65   DELETE FROM INV_ITEM_LOC_STOR ...
17,374 17,374 1.00 0.00 0.00 9qpn2p6ghgc00   INSERT INTO PICKING_ORDER_LINE...
6,241 5,300 0.85 0.00 0.00 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
2,794 44,431 15.90 0.00 0.00 db78fxqxwxt7r   select /*+ rule */ bucket, en...
1,520 1,469 0.97 0.00 0.00 3c1kubcdjnppq   update sys.col_usage$ set eq...
1,263 1,505 1.19 0.00 0.00 53saa2zkr6wc3   select intcol#, nvl(pos#, 0), ...
1,162 1,162 1.00 0.00 0.00 2ym6hhaq30r73   select type#, blocks, extents,...
853 830 0.97 0.00 0.00 04xtrk7uyhknh   select obj#, type#, ctime, mti...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1,162 1,162 5.93 2ym6hhaq30r73   select type#, blocks, extents,...
789 789 4.03 grwydz59pu6mc   select text from view$ where r...
592 592 3.02 2syvqzbxp4k9z   select u.name, o.name, a.int...
582 582 2.97 0wbs3rrqa51w1   select processord0_.PROCESS_OR...
521 521 2.66 64g0b5a8rmb2b   select processord0_.PROCESS_OR...
475 51 2.42 0v3dvmc22qnam   insert into sys.col_usage$ (ob...
475 1,520 2.42 3c1kubcdjnppq   update sys.col_usage$ set eq...
475 475 2.42 b2gnxm5z6r51n   lock table sys.col_usage$ in e...
360 360 1.84 fh3vrdk99j0c4   update PROCESS_ORDER_LIST set ...
341 341 1.74 8swypbbr0m372   select order#, columns, types ...
341 341 1.74 cqgv56fmuj63x   select owner#, name, namespace...
231 231 1.18 asvzxj61dc5vs   select timestamp, flags from ...
212 212 1.08 39m4sx9k63ba2   select /*+ index(idl_ub2$ i_id...
212 212 1.08 c6awqs517jpj0   select /*+ index(idl_char$ i_i...
212 212 1.08 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
212 212 1.08 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_id...

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 IdSQL Text
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0h9m34syhy4p9SELECT PO.* FROM PROCESS_ORDER PO INNER JOIN (SELECT POL.PROCESS_ORDER_ID FROM PROCESS_ORDER_LINE POL INNER JOIN (SELECT BL.LM_BARCODE FROM BASE_LM BL INNER JOIN (SELECT BLL.BASE_LM_ID FROM BASE_LM_LINE BLL INNER JOIN (SELECT CO.TASK_ORDER, CO.BOX_NO FROM CONTRAST_ORDER CO INNER JOIN (SELECT OL.LM_CODE FROM OUTBOUND_ORDER_LINE OL WHERE OL.OUTBOUND_CODE = :B1 AND DEL_FLAG = 0 AND ROWNUM =1) OL ON OL.LM_CODE = CO.BOX_NAME AND DEL_FLAG = 0 AND ROWNUM = 1) CO ON CO.TASK_ORDER = BLL.AUX1 AND DEL_FLAG = 0 AND CO.BOX_NO = BLL.AUX3 AND ROWNUM = 1) BLL ON BLL.BASE_LM_ID = BL.BASE_LM_ID AND DEL_FLAG = 0 AND ROWNUM =1) BL ON BL.LM_BARCODE = POL.LM_BARCODE AND DEL_FLAG = 0 AND ROWNUM = 1) POL ON POL.PROCESS_ORDER_ID = PO.PROCESS_ORDER_ID AND PO.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B2 , '''')))) AND PO.DEL_FLAG = 0 AND ROWNUM = 1
0v3dvmc22qnaminsert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0wbs3rrqa51w1 select processord0_.PROCESS_ORDER_LIST_ID as PROCESS1_134_, processord0_.RECORD_VERSION as RECORD2_134_, processord0_.EXP_DATE as EXP3_134_, processord0_.ORI_SUP as ORI4_134_, processord0_.ORI_DATE as ORI5_134_, processord0_.BASE_UOM_ID as BASE6_134_, processord0_.ITEM_PRO as ITEM7_134_, processord0_.COLOR as COLOR134_, processord0_.GRADE as GRADE134_, processord0_.LOT as LOT134_, processord0_.SERIAL as SERIAL134_, processord0_.SIZE_KEY as SIZE12_134_, processord0_.SPEC as SPEC134_, processord0_.VERSION as VERSION134_, processord0_.YIELD_DATE as YIELD15_134_, processord0_.BASE_ITEM_ID as BASE16_134_, processord0_.AUX1 as AUX17_134_, processord0_.AUX2 as AUX18_134_, processord0_.AUX3 as AUX19_134_, processord0_.AUX4 as AUX20_134_, processord0_.AUX5 as AUX21_134_, processord0_.AUX6 as AUX22_134_, processord0_.NOTES as NOTES134_, processord0_.AUX7 as AUX24_134_, processord0_.AUX8 as AUX25_134_, processord0_.AUX9 as AUX26_134_, processord0_.AUX10 as AUX27_134_, processord0_.BATCH as BATCH134_, processord0_.DEFAULT_BARCODE as DEFAULT29_134_, processord0_.PICKING_CODE as PICKING30_134_, processord0_.PROCESS_ORDER_CODE as PROCESS31_134_, processord0_.WH_CODE as WH32_134_, processord0_.BASE_WH_ID as BASE33_134_, processord0_.BASE_BP_ID as BASE34_134_, processord0_.BP_CODE as BP35_134_, processord0_.LM_CODE as LM36_134_, processord0_.LM_ID as LM37_134_, processord0_.PROCESS_QTY as PROCESS38_134_, processord0_.STATUS as STATUS134_, processord0_.DE L_FLAG as DEL40_134_, processord0_.WH_NAME as WH41_134_, processord0_.BP_NAME as BP42_134_, processord0_.LM_NAME as LM43_134_, processord0_.ITEM_CODE as ITEM44_134_, processord0_.ITEM_NAME as ITEM45_134_, processord0_.BASE_UOM_CODE as BASE46_134_, processord0_.BASE_UOM_NAME as BASE47_134_, processord0_.RF_PROCESS_QTY as RF48_134_, processord0_.ITEM_SN as ITEM49_134_, processord0_.CREATED_BY_USER as CREATED50_134_, processord0_.CREATED_OFFICE as CREATED51_134_, processord0_.CREATED_DTM_LOC as CREATED52_134_, processord0_.CREATED_TIME_ZONE as CREATED53_134_, processord0_.UPDATED_BY_USER as UPDATED54_134_, processord0_.UPDATED_OFFICE as UPDATED55_134_, processord0_.UPDATED_DTM_LOC as UPDATED56_134_, processord0_.UPDATED_TIME_ZONE as UPDATED57_134_, processord0_.PRINCIPAL_GROUP_CODE as PRINCIPAL58_134_, processord0_.OFFICE_CODE as OFFICE59_134_, processord0_.PROCESS_PERSON as PROCESS60_134_, processord0_.PROCESS_DATE as PROCESS61_134_, processord0_.CHECK_PERSON as CHECK62_134_, processord0_.CHECK_DATE as CHECK63_134_, processord0_.PROCESS_ORDER_LINE_ID as PROCESS64_134_ from PROCESS_ORDER_LIST processord0_ where 1=1 and processord0_.PROCESS_ORDER_LINE_ID=:1 and processord0_.DEL_FLAG=:2
1md6gz42bf2fjBEGIN sp_rf_inbound_rec_hub(:1, :2, :3, :4); END;
2n3g5qy6rwz2zINSERT INTO PICKING_ORDER_LIST ( PICKING_ORDER_LIST_ID, STATUS, PICKING_LINE, PICKING_LIST, PICKING_CODE, OUTBOUND_ORDER_ID, OUTBOUND_CODE, OUTBOUND_LINE, OFFICE_CODE, OFFICE_NAME, SYS_OFFICE_ID, BASE_WH_ID, WH_CODE, WH_NAME, SOURCE_LM_ID, SOURCE_LM_CODE, SOURCE_LM_NAME, BASE_ITEM_ID, ITEM_CODE, ITEM_NAME, PICKING_QTY, PICKING_ODD_QTY, BASE_UOM_ID, UOM_CODE, UOM_NAME, DEL_FLAG, PICKING_ORDER_LINE_ID, PICKING_ORDER_ID, CREATED_BY_USER, CREATED_OFFICE, CREATED_DTM_LOC, CREATED_TIME_ZONE, UPDATED_BY_USER, UPDATED_OFFICE, UPDATED_DTM_LOC, UPDATED_TIME_ZONE, RECORD_VERSION, PRINCIPAL_GROUP_CODE ) VALUES ( SYS_GUID(), 'PICKEDCOMPLETE', :B24 , :B24 , :B23 , :B22 , :B21 , TO_NUMBER(:B20 ), :B13 , :B13 , NULL, :B19 , :B18 , :B17 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , '0', :B16 , :B15 , :B14 , :B13 , SYSDATE, SYSDATE, :B14 , :B13 , SYSDATE, SYSDATE, 0, :B12 )
2r1svyhycp66wSELECT POLS.PROCESS_ORDER_LINE_ID, MAX(POLS.ITEM_SN) AS ITEM_SN, COUNT(1) AS RECOUNT FROM PROCESS_ORDER_LIST POLS INNER JOIN PROCESS_ORDER_LINE POL ON POLS.PROCESS_ORDER_LINE_ID = POL.PROCESS_ORDER_LINE_ID WHERE POLS.PROCESS_ORDER_CODE = :B3 AND (POL.LM_BARCODE <> :B2 OR ('process'=:B1 AND POLS.STATUS = 'PROCESSCOMPLETE')) AND (POLS.ITEM_SN LIKE '21%' OR POLS.ITEM_SN LIKE '02%' OR POLS.ITEM_SN LIKE '03%') AND POLS.ITEM_SN IN (SELECT STR FROM TABLE(STR3LIST(:B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 ))) AND POLS.DEL_FLAG='0' GROUP BY POLS.PROCESS_ORDER_LINE_ID
2ss1hwcz3f430BEGIN sp_rf_check_sn_exist(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21); END;
2syvqzbxp4k9zselect u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
2ym6hhaq30r73select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3027yph8jytgj select baselmline0_.BASE_LM_LINE_ID as BASE1_30_, baselmline0_.RECORD_VERSION as RECORD2_30_, baselmline0_.NOTES as NOTES30_, baselmline0_.STATUS as STATUS30_, baselmline0_.AUX1 as AUX5_30_, baselmline0_.AUX2 as AUX6_30_, baselmline0_.AUX3 as AUX7_30_, baselmline0_.LM_LINE as LM8_30_, baselmline0_.AUX4 as AUX9_30_, baselmline0_.AUX5 as AUX10_30_, baselmline0_.AUX6 as AUX11_30_, baselmline0_.BASE_WH_ID as BASE12_30_, baselmline0_.BASE_BP_ID as BASE13_30_, baselmline0_.BASE_BPP_ID as BASE14_30_, baselmline0_.BASE_ITEM_ID as BASE15_30_, baselmline0_.ITEM_PRO as ITEM16_30_, baselmline0_.COLOR as COLOR30_, baselmline0_.GRADE as GRADE30_, baselmline0_.LOT as LOT30_, baselmline0_.SERIAL as SERIAL30_, baselmline0_.SIZE_KEY as SIZE21_30_, baselmline0_.SPEC as SPEC30_, baselmline0_.VERSION as VERSION30_, baselmline0_.YIELD_DATE as YIELD24_30_, baselmline0_.EXP_DATE as EXP25_30_, baselmline0_.ORI_SUP as ORI26_30_, baselmline0_.ORI_DATE as ORI27_30_, baselmline0_.CASE_QTY as CASE28_30_, baselmline0_.CASE_UOM_ID as CASE29_30_, baselmline0_.CASE_CONV_RATE as CASE30_30_, baselmline0_.ODD_QTY as ODD31_30_, baselmline0_.ODD_UOM_ID as ODD32_30_, baselmline0_.ODD_CONV_RATE as ODD33_30_, baselmline0_.QTY as QTY30_, baselmline0_.BASE_UOM_ID as BASE35_30_, baselmline0_.BATCH as BATCH30_, baselmline0_.DEL_FLAG as DEL37_30_, baselmline0_.WH_NAME as WH38_30_, baselmline0_.BASE_BP_NAME as BASE39_30_, baselmline0_.BPP_NAME as BPP40_30_, baselmline0_.ITEM_NAME as ITEM41_30_, baselmline0_.UOM_CODE as UOM42_30_, baselmline0_.CREATED_BY_USER as CREATED43_30_, baselmline0_.CREATED_OFFICE as CREATED44_30_, baselmline0_.CREATED_DTM_LOC as CREATED45_30_, baselmline0_.CREATED_TIME_ZONE as CREATED46_30_, baselmline0_.UPDATED_BY_USER as UPDATED47_30_, baselmline0_.UPDATED_OFFICE as UPDATED48_30_, baselmline0_.UPDATED_DTM_LOC as UPDATED49_30_, baselmline0_.UPDATED_TIME_ZONE as UPDATED50_30_, baselmline0_.PRINCIPAL_GROUP_CODE as PRINCIPAL51_30_, baselmline0_.OFFICE_CODE as OFFICE52_30_, baselmline0_.UOM_NAME as UOM53_30_, baselmline0_.CASE_UOM_NAME as CASE54_30_, baselmline0_.CASE_UOM_CODE as CASE55_30_, baselmline0_.ODD_UOM_NAME as ODD56_30_, baselmline0_.ODD_UOM_CODE as ODD57_30_, baselmline0_.BASE_LM_ID as BASE58_30_ from BASE_LM_LINE baselmline0_ where 1=1 and baselmline0_.AUX3=:1 and baselmline0_.DEL_FLAG=:2 and baselmline0_.AUX1=:3 and (baselmline0_.OFFICE_CODE=:4 or baselmline0_.OFFICE_CODE=:5 or baselmline0_.OFFICE_CODE=:6 or baselmline0_.OFFICE_CODE=:7)
35grauy4kpw1wBEGIN sp_rf_pick_view_hub(:1, :2, :3); END;
39m4sx9k63ba2select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
3c1kubcdjnppqupdate 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
3f4vxcd4hfsyxSELECT L.ITEM_CODE, SUM(L.PROCESS_QTY) AS PROCESS_QTY FROM PROCESS_ORDER_LIST L WHERE L.DEL_FLAG = 0 AND L.PROCESS_ORDER_CODE = :B1 AND L.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B2 , '''')))) GROUP BY L.ITEM_CODE
3p3sp04ynzub2SELECT LOC.INV_ITEM_LOC_STOR_ID FROM INV_ITEM_LOC_STOR LOC WHERE LOC.INV_STOR_ID = :B1 AND ROWNUM <= 1
44hkj0ys4acqbBEGIN sp_box_putaway_hub(:1, :2, :3, :4, :5, :6); END;
4hcbvgyg6dh65DELETE FROM INV_ITEM_LOC_STOR WHERE INV_ITEM_LOC_STOR_ID = :B1
4u2r6axbk44nbSELECT T.BASE_LM_ID FROM BASE_LM_LINE T WHERE T.AUX1 = :B2 AND T.AUX3 = :B1 AND T.DEL_FLAG = '0' AND T.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B3 , '''')))) AND ROWNUM = 1
4v97annmzfk69 select * from ( select vwinboundo0_.VW_INBOUND_ORDER_BOX_ID as VW1_69_, vwinboundo0_.RECORD_VERSION as RECORD2_69_, vwinboundo0_.EXT_INBOUND as EXT3_69_, vwinboundo0_.EXT_INBOUND_LINE as EXT4_69_, vwinboundo0_.INBOUND_ORDER_LINE_ID as INBOUND5_69_, vwinboundo0_.INBOUND_LINE as INBOUND6_69_, vwinboundo0_.EXP_DATE as EXP7_69_, vwinboundo0_.ORI_SUP as ORI8_69_, vwinboundo0_.ORI_DATE as ORI9_69_, vwinboundo0_.PRE_CASE_QTY as PRE10_69_, vwinboundo0_.CASE_UOM_ID as CASE11_69_, vwinboundo0_.CASE_CONV_RATE as CASE12_69_, vwinboundo0_.PRE_ODD_QTY as PRE13_69_, vwinboundo0_.ODD_UOM_ID as ODD14_69_, vwinboundo0_.ODD_CONV_RATE as ODD15_69_, vwinboundo0_.PRE_QTY as PRE16_69_, vwinboundo0_.BASE_UOM_ID as BASE17_69_, vwinboundo0_.ITEM_PRO as ITEM18_69_, vwinboundo0_.COLOR as COLOR69_, vwinboundo0_.GRADE as GRADE69_, vwinboundo0_.LOT as LOT69_, vwinboundo0_.SERIAL as SERIAL69_, vwinboundo0_.SIZE_KEY as SIZE23_69_, vwinboundo0_.SPEC as SPEC69_, vwinboundo0_.VERSION as VERSION69_, vwinboundo0_.YIELD_DATE as YIELD26_69_, vwinboundo0_.BASE_ITEM_ID as BASE27_69_, vwinboundo0_.AUX1 as AUX28_69_, vwinboundo0_.AUX2 as AUX29_69_, vwinboundo0_.AUX3 as AUX30_69_, vwinboundo0_.AUX4 as AUX31_69_, vwinboundo0_.AUX5 as AUX32_69_, vwinboundo0_.AUX6 as AUX33_69_, vwinboundo0_.NOTES as NOTES69_, vwinboundo0_.AUX7 as AUX35_69_, vwinboundo0_.AUX8 as AUX36_69_, vwinboundo0_.AUX9 as AUX37_69_, vwinboundo0_.AUX10 as AUX38_69_, vwinboundo0_.PRE_PRESENT_QTY as PRE39_69_, vwinbo undo0_.PRESENT_UOM_ID as PRESENT40_69_, vwinboundo0_.PRESENT_CONV_RATE as PRESENT41_69_, vwinboundo0_.CASE_STRICT_FLAG as CASE42_69_, vwinboundo0_.ODD_STRICT_FLAG as ODD43_69_, vwinboundo0_.PRESENT_STRICT_FLAG as PRESENT44_69_, vwinboundo0_.STRICT_FLAG as STRICT45_69_, vwinboundo0_.OVER_RATE as OVER46_69_, vwinboundo0_.RCV_QTY as RCV47_69_, vwinboundo0_.RCV_CASE_QTY as RCV48_69_, vwinboundo0_.RCV_ODD_QTY as RCV49_69_, vwinboundo0_.RCV_PRESENT_QTY as RCV50_69_, vwinboundo0_.NETPRICE as NETPRICE69_, vwinboundo0_.PRICE as PRICE69_, vwinboundo0_.NETAMT as NETAMT69_, vwinboundo0_.AMT as AMT69_, vwinboundo0_.CASE_NETPRICE as CASE55_69_, vwinboundo0_.CASE_PRICE as CASE56_69_, vwinboundo0_.TAX as TAX69_, vwinboundo0_.PO_LINE as PO58_69_, vwinboundo0_.PO_ORDER_ID as PO59_69_, vwinboundo0_.LINE_TYPE as LINE60_69_, vwinboundo0_.SUP_ID as SUP61_69_, vwinboundo0_.SUP_NAME as SUP62_69_, vwinboundo0_.SUP_INF as SUP63_69_, vwinboundo0_.CNF_CASE_QTY as CNF64_69_, vwinboundo0_.CNF_ODD_QTY as CNF65_69_, vwinboundo0_.CNF_PRESENT_QTY as CNF66_69_, vwinboundo0_.CNF_QTY as CNF67_69_, vwinboundo0_.QA_STATUS as QA68_69_, vwinboundo0_.PRE_ADV_DATE as PRE69_69_, vwinboundo0_.EFF_DATE as EFF70_69_, vwinboundo0_.LAST_ADV_DATE as LAST71_69_, vwinboundo0_.LM_QTY as LM72_69_, vwinboundo0_.CONFIRM_USER as CONFIRM73_69_, vwinboundo0_.CONFIRM_DATE as CONFIRM74_69_, vwinboundo0_.CLOSE_DATE as CLOSE75_69_, vwinboundo0_.TRANS_METHOD as TRANS76_69_, vwinboundo0_.SIG_INF as SIG7 7_69_, vwinboundo0_.FIRST_ADV_DATE as FIRST78_69_, vwinboundo0_.STATUS as STATUS69_, vwinboundo0_.BATCH as BATCH69_, vwinboundo0_.DEFAULT_BARCODE as DEFAULT81_69_, vwinboundo0_.DEL_FLAG as DEL82_69_, vwinboundo0_.ITEM_CODE as ITEM83_69_, vwinboundo0_.ITEM_NAME as ITEM84_69_, vwinboundo0_.CASE_UOM_CODE as CASE85_69_, vwinboundo0_.CASE_UOM_NAME as CASE86_69_, vwinboundo0_.ODD_UOM_CODE as ODD87_69_, vwinboundo0_.ODD_UOM_NAME as ODD88_69_, vwinboundo0_.PRESENT_UOM_CODE as PRESENT89_69_, vwinboundo0_.PRESENT_UOM_NAME as PRESENT90_69_, vwinboundo0_.BASE_UOM_CODE as BASE91_69_, vwinboundo0_.BASE_UOM_NAME as BASE92_69_, vwinboundo0_.INBOUND_ORDER_ID as INBOUND93_69_, vwinboundo0_.CREATED_BY_USER as CREATED94_69_, vwinboundo0_.CREATED_OFFICE as CREATED95_69_, vwinboundo0_.CREATED_DTM_LOC as CREATED96_69_, vwinboundo0_.CREATED_TIME_ZONE as CREATED97_69_, vwinboundo0_.UPDATED_BY_USER as UPDATED98_69_, vwinboundo0_.UPDATED_OFFICE as UPDATED99_69_, vwinboundo0_.UPDATED_DTM_LOC as UPDATED100_69_, vwinboundo0_.UPDATED_TIME_ZONE as UPDATED101_69_, vwinboundo0_.PRINCIPAL_GROUP_CODE as PRINCIPAL102_69_, vwinboundo0_.OFFICE_CODE as OFFICE103_69_, vwinboundo0_.SUP_CODE as SUP104_69_, vwinboundo0_.INBOUND_ORDER_LINE_GROUP as INBOUND105_69_, vwinboundo0_.LM_ID as LM106_69_, vwinboundo0_.LM_CODE as LM107_69_, vwinboundo0_.LM_NAME as LM108_69_, vwinboundo0_.BOX_STATUS as BOX109_69_, vwinboundo0_.GROSS_WEIGHT as GROSS110_69_, vwinboundo0_.NET_WEIGHT as NET111_69_, v winboundo0_.VOLUME as VOLUME69_, vwinboundo0_.WH_CODE as WH113_69_, vwinboundo0_.WH_NAME as WH114_69_, vwinboundo0_.BASE_WH_ID as BASE115_69_, vwinboundo0_.BP_CODE as BP116_69_, vwinboundo0_.BP_NAME as BP117_69_, vwinboundo0_.BASE_BP_ID as BASE118_69_, vwinboundo0_.INBOUND_TYPE as INBOUND119_69_, vwinboundo0_.INBOUND_CODE as INBOUND120_69_, vwinboundo0_.BOX_TOTAL_QTY as BOX121_69_ from VW_INBOUND_ORDER_BOX vwinboundo0_ where 1=1 and vwinboundo0_.DEL_FLAG=:1 and (vwinboundo0_.STATUS in (:2)) and vwinboundo0_.INBOUND_TYPE=:3 order by vwinboundo0_.INBOUND_CODE desc ) where rownum <= :4
51n5qdjvnrd16select count(vwinboundo0_.VW_INBOUND_ORDER_BOX_ID) as col_0_0_ from VW_INBOUND_ORDER_BOX vwinboundo0_ where 1=1 and vwinboundo0_.DEL_FLAG=:1 and (vwinboundo0_.STATUS in (:2)) and vwinboundo0_.INBOUND_TYPE=:3
51xmb5swg37vmSELECT COUNT(1) FROM BASE_LM_LINE T WHERE T.AUX1 = :B2 AND T.AUX3 = :B1 AND T.DEL_FLAG = '0' AND T.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B3 , ''''))))
53saa2zkr6wc3select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5ak02sq9z8dnqSELECT COUNT(1) FROM OUTBOUND_ORDER_LINE T, OUTBOUND_ORDER TT WHERE T.LM_CODE = :B1 AND T.OUTBOUND_ORDER_ID = TT.OUTBOUND_ORDER_ID AND TT.OUTBOUND_TYPE = 'DELIVERYOUTBOUND' AND T.DEL_FLAG = '0' AND TT.DEL_FLAG = '0' AND T.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B2 , ''''))))
5atbz4fgg9j2qselect pol.Process_Order_Line_Id, pol.Item_Code, pol.sum_Process_Qty, pol.base_uom_code, line.lm_barcode, line.lm_type_id, line.lm_type_name, line.aux1 from process_order_line line join (select poList.Process_Order_Line_Id, poList.Item_Code, sum(nvl(poList.Process_Qty, 0)) sum_Process_Qty, polist.base_uom_code from process_order_list poList where poList.Process_Order_Code = 'PRLF2012062600000021' and poList.Del_Flag = 0 and poList.Item_Code is not null group by poList.Process_Order_Line_Id, poList.Item_Code, polist.base_uom_code order by poList.Process_Order_Line_Id, poList.Item_Code) pol on line.process_order_line_id = pol.Process_Order_Line_Id and line.del_flag = 0 group by pol.Process_Order_Line_Id, pol.Item_Code, pol.sum_Process_Qty, pol.base_uom_code, line.lm_barcode, line.lm_type_id, line.lm_type_name, line.aux1 order by line.aux1, pol.Process_Order_Line_Id, pol.Item_Code
5xrnu1x47xak2SELECT T.ITEM_CODE, T.QTY AS QTY, NVL(TT.QTY, 0) AS QTYED, (T.QTY-NVL(TT.QTY, 0)) AS QTYING FROM (SELECT PLINES.ITEM_CODE, MAX(:B1 ) AS PICKING_CODE, SUM(PLINES.PICKING_QTY) AS QTY FROM PICKING_ORDER_LINE PLINES WHERE PLINES.PICKING_CODE = :B1 AND PLINES.DEL_FLAG = '0' AND PLINES.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B2 , '''')))) GROUP BY PLINES.ITEM_CODE) T LEFT JOIN (SELECT PLINE.ITEM_CODE, MAX(:B1 ) AS PICKING_CODE, SUM(PLINE.PICKING_QTY) AS QTY FROM PICKING_ORDER_LINE PLINE WHERE PLINE.PICKING_CODE = :B1 AND PLINE.AUX10 = 'RF' AND PLINE.DEL_FLAG = '0' AND PLINE.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B2 , '''')))) GROUP BY PLINE.ITEM_CODE) TT ON T.ITEM_CODE = TT.ITEM_CODE
64g0b5a8rmb2b select processord0_.PROCESS_ORDER_LINE_ID as PROCESS1_133_0_, processord0_.RECORD_VERSION as RECORD2_133_0_, processord0_.PACKAGE_END_TIME as PACKAGE3_133_0_, processord0_.STATUS as STATUS133_0_, processord0_.AUX1 as AUX5_133_0_, processord0_.AUX2 as AUX6_133_0_, processord0_.AUX3 as AUX7_133_0_, processord0_.PROCESS_ORDER_DSC as PROCESS8_133_0_, processord0_.PROCESS_ORDER_CODE as PROCESS9_133_0_, processord0_.PROCESS_ORDER_BARCODE as PROCESS10_133_0_, processord0_.PROCESS_ORDER_NAME as PROCESS11_133_0_, processord0_.AUX4 as AUX12_133_0_, processord0_.AUX5 as AUX13_133_0_, processord0_.AUX6 as AUX14_133_0_, processord0_.BASE_WH_ID as BASE15_133_0_, processord0_.NOTES as NOTES133_0_, processord0_.EFF_DATE as EFF17_133_0_, processord0_.CLOSE_DATE as CLOSE18_133_0_, processord0_.AUX7 as AUX19_133_0_, processord0_.AUX8 as AUX20_133_0_, processord0_.AUX9 as AUX21_133_0_, processord0_.AUX10 as AUX22_133_0_, processord0_.TOTA_VOLUME as TOTA23_133_0_, processord0_.TOTA_WEIGHT as TOTA24_133_0_, processord0_.TOTA_QTY as TOTA25_133_0_, processord0_.TOTA_NETAMT as TOTA26_133_0_, processord0_.TOTA_AMT as TOTA27_133_0_, processord0_.CANCEL_DATE as CANCEL28_133_0_, processord0_.PACKAGE_BEGIN_TIME as PACKAGE29_133_0_, processord0_.LM_CODE as LM30_133_0_, processord0_.LM_ID as LM31_133_0_, processord0_.WH_CODE as WH32_133_0_, processord0_.BASE_BP_ID as BASE33_133_0_, processord0_.BP_CODE as BP34_133_0_, processord0_.PROCESS_ORDER_CN_NAME as PROCESS35_133_0_, processord0_.DEL_FLAG as DEL36_133_0_, processord0_.LM_NAME as LM37_133_0_, processord0_.WH_NAME as WH38_133_0_, processord0_.BP_NAME as BP39_133_0_, processord0_.LM_TYPE_ID as LM40_133_0_, processord0_.LM_TYPE_NAME as LM41_133_0_, processord0_.LM_BARCODE as LM42_133_0_, processord0_.PROCESS_DEMAND_ID as PROCESS43_133_0_, processord0_.LM_WEIGHT as LM44_133_0_, processord0_.LM_VOLUME as LM45_133_0_, processord0_.LM_LENGTH as LM46_133_0_, processord0_.LM_WIDTH as LM47_133_0_, processord0_.LM_HEIGHT as LM48_133_0_, processord0_.UP_LM_ID as UP49_133_0_, processord0_.UP_LM_NAME as UP50_133_0_, processord0_.LEVEL_KEY as LEVEL51_133_0_, processord0_.IM_TYPE_FLAG as IM52_133_0_, processord0_.CREATED_BY_USER as CREATED53_133_0_, processord0_.CREATED_OFFICE as CREATED54_133_0_, processord0_.CREATED_DTM_LOC as CREATED55_133_0_, processord0_.CREATED_TIME_ZONE as CREATED56_133_0_, processord0_.UPDATED_BY_USER as UPDATED57_133_0_, processord0_.UPDATED_OFFICE as UPDATED58_133_0_, processord0_.UPDATED_DTM_LOC as UPDATED59_133_0_, processord0_.UPDATED_TIME_ZONE as UPDATED60_133_0_, processord0_.PRINCIPAL_GROUP_CODE as PRINCIPAL61_133_0_, processord0_.OFFICE_CODE as OFFICE62_133_0_, processord0_.LM_TYPE_DSC as LM63_133_0_, processord0_.PROCESS_PERSON as PROCESS64_133_0_, processord0_.PROCESS_DATE as PROCESS65_133_0_, processord0_.CHECK_PERSON as CHECK66_133_0_, processord0_.CHECK_DATE as CHECK67_133_0_, processord0_.PROCESS_ORDER_ID as PROCESS68_133_0_ from PRO CESS_ORDER_LINE processord0_ where processord0_.PROCESS_ORDER_LINE_ID=:1
66p2f72ksuw9sSELECT T.AUX4, TT.STATUS, T.AUX9, T.AUX10, T.OUTBOUND_ORDER_LINE_ID FROM OUTBOUND_ORDER_LINE T, OUTBOUND_ORDER TT WHERE T.LM_CODE = :B1 AND T.OUTBOUND_ORDER_ID = TT.OUTBOUND_ORDER_ID AND TT.OUTBOUND_TYPE = 'DELIVERYOUTBOUND' AND T.DEL_FLAG = '0' AND TT.DEL_FLAG = '0' AND T.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B2 , '''')))) AND ROWNUM = 1
6dy0n540kjb7p select baselmline0_.BASE_LM_LINE_ID as BASE1_30_, baselmline0_.RECORD_VERSION as RECORD2_30_, baselmline0_.NOTES as NOTES30_, baselmline0_.STATUS as STATUS30_, baselmline0_.AUX1 as AUX5_30_, baselmline0_.AUX2 as AUX6_30_, baselmline0_.AUX3 as AUX7_30_, baselmline0_.LM_LINE as LM8_30_, baselmline0_.AUX4 as AUX9_30_, baselmline0_.AUX5 as AUX10_30_, baselmline0_.AUX6 as AUX11_30_, baselmline0_.BASE_WH_ID as BASE12_30_, baselmline0_.BASE_BP_ID as BASE13_30_, baselmline0_.BASE_BPP_ID as BASE14_30_, baselmline0_.BASE_ITEM_ID as BASE15_30_, baselmline0_.ITEM_PRO as ITEM16_30_, baselmline0_.COLOR as COLOR30_, baselmline0_.GRADE as GRADE30_, baselmline0_.LOT as LOT30_, baselmline0_.SERIAL as SERIAL30_, baselmline0_.SIZE_KEY as SIZE21_30_, baselmline0_.SPEC as SPEC30_, baselmline0_.VERSION as VERSION30_, baselmline0_.YIELD_DATE as YIELD24_30_, baselmline0_.EXP_DATE as EXP25_30_, baselmline0_.ORI_SUP as ORI26_30_, baselmline0_.ORI_DATE as ORI27_30_, baselmline0_.CASE_QTY as CASE28_30_, baselmline0_.CASE_UOM_ID as CASE29_30_, baselmline0_.CASE_CONV_RATE as CASE30_30_, baselmline0_.ODD_QTY as ODD31_30_, baselmline0_.ODD_UOM_ID as ODD32_30_, baselmline0_.ODD_CONV_RATE as ODD33_30_, baselmline0_.QTY as QTY30_, baselmline0_.BASE_UOM_ID as BASE35_30_, baselmline0_.BATCH as BATCH30_, baselmline0_.DEL_FLAG as DEL37_30_, baselmline0_.WH_NAME as WH38_30_, baselmline0_.BASE_BP_NAME as BASE39_30_, baselmline0_.BPP_NAME as BPP40_30_, baselmline0_.ITEM_NAME as ITEM41_30_, baselmline0_.UOM_CODE as UOM42_30_, baselmline0_.CREATED_BY_USER as CREATED43_30_, baselmline0_.CREATED_OFFICE as CREATED44_30_, baselmline0_.CREATED_DTM_LOC as CREATED45_30_, baselmline0_.CREATED_TIME_ZONE as CREATED46_30_, baselmline0_.UPDATED_BY_USER as UPDATED47_30_, baselmline0_.UPDATED_OFFICE as UPDATED48_30_, baselmline0_.UPDATED_DTM_LOC as UPDATED49_30_, baselmline0_.UPDATED_TIME_ZONE as UPDATED50_30_, baselmline0_.PRINCIPAL_GROUP_CODE as PRINCIPAL51_30_, baselmline0_.OFFICE_CODE as OFFICE52_30_, baselmline0_.UOM_NAME as UOM53_30_, baselmline0_.CASE_UOM_NAME as CASE54_30_, baselmline0_.CASE_UOM_CODE as CASE55_30_, baselmline0_.ODD_UOM_NAME as ODD56_30_, baselmline0_.ODD_UOM_CODE as ODD57_30_, baselmline0_.BASE_LM_ID as BASE58_30_ from BASE_LM_LINE baselmline0_ where 1=1 and baselmline0_.AUX3=:1 and baselmline0_.DEL_FLAG=:2 and baselmline0_.AUX1=:3
6g94kx8u85889SELECT NVL(SUM(PLINES.PICKING_QTY), 0) FROM PICKING_ORDER_LINE PLINES WHERE PLINES.PICKING_CODE = :B2 AND PLINES.ITEM_CODE = :B1 AND PLINES.DEL_FLAG = '0' AND PLINES.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B3 , ''''))))
716k8qytzxrztSELECT T.BASE_LM_ID FROM BASE_LM_LINE T WHERE T.AUX1 = :B2 AND T.AUX3 = :B1 AND T.DEL_FLAG = '0' AND T.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B3 , '''')))) AND ROWNUM <= 1
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtrselect /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9dbncmqtzbssaBEGIN sp_rf_pick_check_hub(:1, :2, :3, :4, :5); END;
9qpn2p6ghgc00INSERT INTO PICKING_ORDER_LINE ( PICKING_ORDER_LINE_ID, STATUS, PICKING_TYPE, PICKING_LINE, PICKING_ORDER_LINE_GROUP, AUX1, PICKING_CODE, OUTBOUND_ORDER_ID, OUTBOUND_CODE, SYS_OFFICE_CODE, OUTBOUND_LINE, OFFICE_CODE, OFFICE_NAME, SYS_OFFICE_ID, BASE_WH_ID, WH_CODE, WH_NAME, SOURCE_LM_ID, SOURCE_LM_CODE, SOURCE_LM_NAME, BASE_ITEM_ID, ITEM_CODE, ITEM_NAME, PICKING_QTY, PICKING_ODD_QTY, BASE_UOM_ID, BASE_UOM_CODE, BASE_UOM_NAME, DEL_FLAG, ODD_CONV_RATE, PICKING_ORDER_ID, CREATED_BY_USER, CREATED_OFFICE, CREATED_DTM_LOC, CREATED_TIME_ZONE, UPDATED_BY_USER, UPDATED_OFFICE, UPDATED_DTM_LOC, UPDATED_TIME_ZONE, RECORD_VERSION, PRINCIPAL_GROUP_CODE ) VALUES ( :B27 , 'PICKEDCOMPLETE', 'DELIVERYPICKING', :B26 , :B1 , :B25 , :B24 , :B23 , :B22 , :B15 , TO_NUMBER(:B21 ), :B15 , :B15 , NULL, :B20 , :B19 , :B18 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , '0', :B13 , :B17 , :B16 , :B15 , SYSDATE, SYSDATE, :B16 , :B15 , SYSDATE, SYSDATE, 0, :B14 )
asvzxj61dc5vsselect timestamp, flags from fixed_obj$ where obj#=:1
az9zbgqchjm1wSELECT COUNT(1) FROM PICKING_ORDER_LINE T WHERE T.PICKING_CODE = :B2 AND T.ITEM_CODE = :B1 AND T.DEL_FLAG = '0' AND T.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B3 , ''''))))
b2gnxm5z6r51nlock table sys.col_usage$ in exclusive mode nowait
b7y2n3xwj7ab5UPDATE INV_ITEM T SET T.STOR_QTY = T.STOR_QTY + :B5 WHERE T.BASE_WH_ID = :B4 AND T.BASE_BP_ID = :B3 AND T.SYS_OFFICE_ID = :B2 AND T.BASE_ITEM_ID = :B1 AND ROWNUM = 1
c1q1kddqxp6tyBEGIN sp_rf_out_spus_check(:1, :2, :3, :4); END;
c458kp1y7mcutSELECT NVL(SUM(PLINE.PICKING_QTY), 0) FROM PICKING_ORDER_LINE PLINE WHERE PLINE.PICKING_CODE = :B2 AND PLINE.ITEM_CODE = :B1 AND PLINE.STATUS = 'AUDITED' AND PLINE.AUX10 = 'RF' AND PLINE.DEL_FLAG = '0' AND PLINE.OFFICE_CODE IN (SELECT STR FROM TABLE(STR2LIST(REPLACE(:B3 , ''''))))
c6awqs517jpj0select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece#
c7xt81q572pvbBEGIN sp_outbound_order_confirm(:1, :2, :3); END;
cqgv56fmuj63xselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cyq9mdbhzsfxu select outboundor0_.OUTBOUND_ORDER_LINE_ID as OUTBOUND1_119_, outboundor0_.RECORD_VERSION as RECORD2_119_, outboundor0_.OUTBOUND_LINE as OUTBOUND3_119_, outboundor0_.EXP_DATE as EXP4_119_, outboundor0_.ORI_SUP as ORI5_119_, outboundor0_.ORI_DATE as ORI6_119_, outboundor0_.DEMAND_CASE_QTY as DEMAND7_119_, outboundor0_.CASE_UOM_ID as CASE8_119_, outboundor0_.CASE_CONV_RATE as CASE9_119_, outboundor0_.DEMAND_ODD_QTY as DEMAND10_119_, outboundor0_.ODD_UOM_ID as ODD11_119_, outboundor0_.ODD_CONV_RATE as ODD12_119_, outboundor0_.DEMAND_QTY as DEMAND13_119_, outboundor0_.BASE_UOM_ID as BASE14_119_, outboundor0_.ITEM_PRO as ITEM15_119_, outboundor0_.COLOR as COLOR119_, outboundor0_.GRADE as GRADE119_, outboundor0_.LOT as LOT119_, outboundor0_.SERIAL as SERIAL119_, outboundor0_.SIZE_KEY as SIZE20_119_, outboundor0_.SPEC as SPEC119_, outboundor0_.VERSION as VERSION119_, outboundor0_.YIELD_DATE as YIELD23_119_, outboundor0_.BASE_ITEM_ID as BASE24_119_, outboundor0_.AUX1 as AUX25_119_, outboundor0_.AUX2 as AUX26_119_, outboundor0_.AUX3 as AUX27_119_, outboundor0_.AUX4 as AUX28_119_, outboundor0_.AUX5 as AUX29_119_, outboundor0_.AUX6 as AUX30_119_, outboundor0_.NOTES as NOTES119_, outboundor0_.AUX7 as AUX32_119_, outboundor0_.AUX8 as AUX33_119_, outboundor0_.AUX9 as AUX34_119_, outboundor0_.AUX10 as AUX35_119_, outboundor0_.CASE_STRICT_FLAG as CASE36_119_, outboundor0_.ODD_STRICT_FLAG as ODD37_119_, outboundor0_.STRICT_FLAG as STRICT38_119_, outboundo r0_.OVER_RATE as OVER39_119_, outboundor0_.WAVE_QTY as WAVE40_119_, outboundor0_.WAVE_ODD_QTY as WAVE41_119_, outboundor0_.NETPRICE as NETPRICE119_, outboundor0_.PRICE as PRICE119_, outboundor0_.NETAMT as NETAMT119_, outboundor0_.AMT as AMT119_, outboundor0_.CASE_NETPRICE as CASE46_119_, outboundor0_.CASE_PRICE as CASE47_119_, outboundor0_.TAX as TAX119_, outboundor0_.BATCH as BATCH119_, outboundor0_.DEFAULT_BARCODE as DEFAULT50_119_, outboundor0_.DEMAND_CODE as DEMAND51_119_, outboundor0_.WAVE_CASE_QTY as WAVE52_119_, outboundor0_.DEMAND_ORDER_ID as DEMAND53_119_, outboundor0_.DEMAND_LINE as DEMAND54_119_, outboundor0_.OUTBOUND_CASE_QTY as OUTBOUND55_119_, outboundor0_.OUTBOUND_ODD_QTY as OUTBOUND56_119_, outboundor0_.OUTBOUND_QTY as OUTBOUND57_119_, outboundor0_.PRESENT_FLAG as PRESENT58_119_, outboundor0_.OUTBOUND_CODE as OUTBOUND59_119_, outboundor0_.SYS_OFFICE_ID as SYS60_119_, outboundor0_.WH_CODE as WH61_119_, outboundor0_.BASE_WH_ID as BASE62_119_, outboundor0_.BASE_BP_ID as BASE63_119_, outboundor0_.BP_CODE as BP64_119_, outboundor0_.BPP_CODE as BPP65_119_, outboundor0_.BASE_BPP_ID as BASE66_119_, outboundor0_.SUP_CODE as SUP67_119_, outboundor0_.BASE_SUP_ID as BASE68_119_, outboundor0_.OFFICE_CODE as OFFICE69_119_, outboundor0_.OFFICE_NAME as OFFICE70_119_, outboundor0_.WH_NAME as WH71_119_, outboundor0_.BP_NAME as BP72_119_, outboundor0_.BPP_NAME as BPP73_119_, outboundor0_.SUP_NAME as SUP74_119_, outboundor0_.ITEM_CODE as ITEM75 _119_, outboundor0_.ITEM_NAME as ITEM76_119_, outboundor0_.UOM_CODE as UOM77_119_, outboundor0_.UOM_NAME as UOM78_119_, outboundor0_.STATUS as STATUS119_, outboundor0_.DEL_FLAG as DEL80_119_, outboundor0_.ODD_UOM_CODE as ODD81_119_, outboundor0_.ODD_UOM_NAME as ODD82_119_, outboundor0_.CASE_UOM_CODE as CASE83_119_, outboundor0_.CASE_UOM_NAME as CASE84_119_, outboundor0_.CREATED_BY_USER as CREATED85_119_, outboundor0_.CREATED_OFFICE as CREATED86_119_, outboundor0_.CREATED_DTM_LOC as CREATED87_119_, outboundor0_.CREATED_TIME_ZONE as CREATED88_119_, outboundor0_.UPDATED_BY_USER as UPDATED89_119_, outboundor0_.UPDATED_OFFICE as UPDATED90_119_, outboundor0_.UPDATED_DTM_LOC as UPDATED91_119_, outboundor0_.UPDATED_TIME_ZONE as UPDATED92_119_, outboundor0_.PRINCIPAL_GROUP_CODE as PRINCIPAL93_119_, outboundor0_.OUTBOUND_ORDER_LINE_GROUP as OUTBOUND94_119_, outboundor0_.LM_ID as LM95_119_, outboundor0_.LM_CODE as LM96_119_, outboundor0_.LM_NAME as LM97_119_, outboundor0_.BOX_STATUS as BOX98_119_, outboundor0_.NET_WEIGHT as NET99_119_, outboundor0_.VOLUME as VOLUME119_, outboundor0_.GROSS_WEIGHT as GROSS101_119_, outboundor0_.OUTBOUND_ORDER_ID as OUTBOUND102_119_ from OUTBOUND_ORDER_LINE outboundor0_ where 1=1 and outboundor0_.LM_CODE=:1 and outboundor0_.DEL_FLAG=:2
db78fxqxwxt7rselect /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
dkxhxw7swam8fBEGIN SP_OUT_PICKING_EXECUTE_HUB (:1, :2, :3, :4); END;
fh3vrdk99j0c4update PROCESS_ORDER_LIST set RECORD_VERSION=:1, STATUS=:2, UPDATED_DTM_LOC=:3, UPDATED_TIME_ZONE=:4 where PROCESS_ORDER_LIST_ID=:5 and RECORD_VERSION=:6
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 325,152 90.28 315.07
CPU used when call started 324,923 90.22 314.85
CR blocks created 17,851 4.96 17.30
Cached Commit SCN referenced 112 0.03 0.11
Commit SCN cached 1 0.00 0.00
DB time 1,171,962 325.41 1,135.62
DBWR checkpoint buffers written 42,724 11.86 41.40
DBWR checkpoints 1 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 115 0.03 0.11
DBWR undo block writes 10,799 3.00 10.46
IMU CR rollbacks 8 0.00 0.01
IMU Flushes 1,171 0.33 1.13
IMU Redo allocation size 1,827,504 507.43 1,770.84
IMU commits 680 0.19 0.66
IMU contention 6 0.00 0.01
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 39 0.01 0.04
IMU recursive-transaction flush 0 0.00 0.00
IMU undo allocation size 5,761,968 1,599.89 5,583.30
IMU- failed to get a private strand 39 0.01 0.04
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 103,842 28.83 100.62
active txn count during cleanout 25,344 7.04 24.56
application wait time 95,219 26.44 92.27
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 11,585 3.22 11.23
branch node splits 8 0.00 0.01
buffer is not pinned count 738,737 205.12 715.83
buffer is pinned count 2,479,300 688.41 2,402.42
bytes received via SQL*Net from client 21,390,590 5,939.41 20,727.32
bytes sent via SQL*Net to client 124,939,730 34,691.32 121,065.63
calls to get snapshot scn: kcmgss 539,388 149.77 522.66
calls to kcmgas 33,284 9.24 32.25
calls to kcmgcs 6,541 1.82 6.34
change write time 511 0.14 0.50
cleanout - number of ktugct calls 25,777 7.16 24.98
cleanouts and rollbacks - consistent read gets 16,985 4.72 16.46
cleanouts only - consistent read gets 497 0.14 0.48
cluster key scan block gets 14,173 3.94 13.73
cluster key scans 7,046 1.96 6.83
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 2 0.00 0.00
commit batch/immediate requested 2 0.00 0.00
commit cleanout failures: block lost 57 0.02 0.06
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 93 0.03 0.09
commit cleanout failures: cannot pin 2 0.00 0.00
commit cleanouts 34,619 9.61 33.55
commit cleanouts successfully completed 34,467 9.57 33.40
commit immediate performed 2 0.00 0.00
commit immediate requested 2 0.00 0.00
commit txn count during cleanout 5,851 1.62 5.67
concurrency wait time 423 0.12 0.41
consistent changes 293,860 81.59 284.75
consistent gets 309,464,091 85,927.18 299,868.31
consistent gets - examination 770,182 213.85 746.30
consistent gets direct 401 0.11 0.39
consistent gets from cache 309,463,690 85,927.07 299,867.92
current blocks converted for CR 34 0.01 0.03
cursor authentications 759 0.21 0.74
data blocks consistent reads - undo records applied 259,684 72.11 251.63
db block changes 767,034 212.98 743.25
db block gets 984,468 273.35 953.94
db block gets direct 29 0.01 0.03
db block gets from cache 984,439 273.34 953.91
deferred (CURRENT) block cleanout applications 11,653 3.24 11.29
dirty buffers inspected 261 0.07 0.25
doubling up with imu segment 0 0.00 0.00
enqueue conversions 794 0.22 0.77
enqueue deadlocks 0 0.00 0.00
enqueue releases 46,937 13.03 45.48
enqueue requests 46,938 13.03 45.48
enqueue timeouts 0 0.00 0.00
enqueue waits 8 0.00 0.01
exchange deadlocks 0 0.00 0.00
execute count 242,326 67.29 234.81
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 40,781,058 11,323.45 39,516.53
free buffer requested 40,558,789 11,261.73 39,301.15
heap block compress 24,439 6.79 23.68
hot buffers moved to head of LRU 35,116 9.75 34.03
immediate (CR) block cleanout applications 17,482 4.85 16.94
immediate (CURRENT) block cleanout applications 5,350 1.49 5.18
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 7,807 2.17 7.56
index fast full scans (full) 19 0.01 0.02
index fetch by key 204,571 56.80 198.23
index scans kdiixs1 100,635 27.94 97.51
leaf node 90-10 splits 14 0.00 0.01
leaf node splits 1,628 0.45 1.58
lob reads 11,388 3.16 11.03
lob writes 11,032 3.06 10.69
lob writes unaligned 11,032 3.06 10.69
logons cumulative 24 0.01 0.02
messages received 13,050 3.62 12.65
messages sent 13,050 3.62 12.65
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 308,396,781 85,630.83 298,834.09
opened cursors cumulative 32,838 9.12 31.82
parse count (failures) 19 0.01 0.02
parse count (hard) 2,093 0.58 2.03
parse count (total) 19,595 5.44 18.99
parse time cpu 763 0.21 0.74
parse time elapsed 861 0.24 0.83
physical read IO requests 4,095,208 1,137.09 3,968.22
physical read bytes ############### 92,166,875.63 321,643,551.75
physical read total IO requests 4,100,548 1,138.58 3,973.40
physical read total bytes ############### 92,331,528.94 322,218,158.14
physical read total multi block requests 3,651,484 1,013.89 3,538.26
physical reads 40,519,549 11,250.84 39,263.13
physical reads cache 40,519,137 11,250.72 39,262.73
physical reads cache prefetch 36,424,341 10,113.75 35,294.90
physical reads direct 412 0.11 0.40
physical reads direct (lob) 392 0.11 0.38
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 11,319 3.14 10.97
physical write bytes 358,703,104 99,599.11 347,580.53
physical write total IO requests 18,917 5.25 18.33
physical write total bytes 1,156,881,920 321,225.01 1,121,009.61
physical write total multi block requests 8,656 2.40 8.39
physical writes 43,787 12.16 42.43
physical writes direct 40 0.01 0.04
physical writes direct (lob) 18 0.00 0.02
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 43,747 12.15 42.39
physical writes non checkpoint 15,765 4.38 15.28
pinned buffers inspected 7,241 2.01 7.02
prefetch clients - default 120 0.03 0.12
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetch warmup blocks flushed out before use 0 0.00 0.00
prefetched blocks aged out before use 9,462 2.63 9.17
process last non-idle time 6,411 1.78 6.21
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 601,380 166.98 582.73
recursive cpu usage 238,926 66.34 231.52
redo blocks read for recovery 0 0.00 0.00
redo blocks written 405,821 112.68 393.24
redo buffer allocation retries 2 0.00 0.00
redo entries 400,259 111.14 387.85
redo log space requests 2 0.00 0.00
redo log space wait time 10 0.00 0.01
redo ordering marks 11,053 3.07 10.71
redo size 200,342,704 55,628.05 194,130.53
redo subscn max counts 19,726 5.48 19.11
redo synch time 444 0.12 0.43
redo synch writes 648 0.18 0.63
redo wastage 656,272 182.22 635.92
redo write time 1,428 0.40 1.38
redo writer latching time 1 0.00 0.00
redo writes 2,366 0.66 2.29
rollback changes - undo records applied 132 0.04 0.13
rollbacks only - consistent read gets 898 0.25 0.87
rows fetched via callback 131,433 36.49 127.36
session connect time 0 0.00 0.00
session cursor cache hits 27,595 7.66 26.74
session logical reads 310,448,559 86,200.54 300,822.25
session pga memory 19,406,280 5,388.43 18,804.53
session pga memory max 136,698,664 37,956.36 132,459.95
session uga memory 8,600,273,560 2,387,990.45 8,333,598.41
session uga memory max 166,856,720 46,330.18 161,682.87
shared hash latch upgrades - no wait 110,274 30.62 106.85
shared hash latch upgrades - wait 0 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 9,598 2.67 9.30
sorts (rows) 254,342 70.62 246.46
sql area evicted 1,957 0.54 1.90
sql area purged 19 0.01 0.02
summed dirty queue length 854 0.24 0.83
switch current to new buffer 547 0.15 0.53
table fetch by rowid 1,450,533 402.76 1,405.56
table fetch continued row 6,008 1.67 5.82
table scan blocks gotten 307,728,329 85,445.22 298,186.37
table scan rows gotten 3,976,592,900 1,104,158.58 3,853,287.69
table scans (long tables) 659 0.18 0.64
table scans (short tables) 40,761 11.32 39.50
total number of times SMON posted 2 0.00 0.00
transaction rollbacks 2 0.00 0.00
transaction tables consistent read rollbacks 1 0.00 0.00
transaction tables consistent reads - undo records applied 36 0.01 0.03
undo change vector size 72,533,652 20,140.02 70,284.55
user I/O wait time 34,226 9.50 33.16
user calls 110,971 30.81 107.53
user commits 1,027 0.29 1.00
user rollbacks 5 0.00 0.00
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 6,985 1.94 6.77
write clones created in background 0 0.00 0.00
write clones created in foreground 1 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 308,741 309,828
opened cursors current 1,252 1,365
logons current 35 44

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 1.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TRANSGD_DATA 4,094,340 1,137 0.07 9.90 10,068 3 305,103 0.16
UNDOTBS1 2 0 5.00 1.00 853 0 5 0.00
SYSAUX 441 0 1.13 1.05 321 0 0 0.00
SYSTEM 393 0 3.26 1.00 76 0 0 0.00
USERS 2 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX /app/oracle/oradata/dmsdb/sysaux01.dbf 440 0 1.14 1.05 319 0 0 0.00
SYSAUX /bakdata/oradata/dmsdb/sysaux02.dbf 1 0 0.00 1.00 2 0 0 0.00
SYSTEM /app/oracle/oradata/dmsdb/system01.dbf 393 0 3.26 1.00 76 0 0 0.00
TRANSGD_DATA /app/oracle/oradata/dmsdb/transgd01.dbf 1,665,031 462 0.07 10.29 1,568 0 98,972 0.28
TRANSGD_DATA /app/oracle/oradata/dmsdb/transgd02.dbf 640,799 178 0.07 10.64 639 0 49,857 0.10
TRANSGD_DATA /bakdata/oradata/dmsdb/transgd03.dbf 660,724 183 0.07 10.27 906 0 49,507 0.09
TRANSGD_DATA /bakdata/oradata/dmsdb/transgd04.dbf 493,877 137 0.07 8.87 2,418 1 46,862 0.13
TRANSGD_DATA /bakdata/oradata/dmsdb/transgd05.dbf 413,209 115 0.08 8.63 2,282 1 34,803 0.09
TRANSGD_DATA /bakdata/oradata/dmsdb/transgd06.dbf 220,700 61 0.08 8.29 2,255 1 25,102 0.08
UNDOTBS1 /app/oracle/oradata/dmsdb/undotbs01.dbf 2 0 5.00 1.00 853 0 5 0.00
USERS /app/oracle/oradata/dmsdb/users01.dbf 2 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 932,953 87 310,302,875 40,513,859 43,747 0 0 305,116


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 12 743 9482 90036 1887390 90036  
E 0 11 373 1956 132349 1887390 132349  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 752 0.10 93,013 1.03 5,372,658,726
D 1,504 0.20 186,026 1.00 5,259,178,952
D 2,256 0.30 279,039 1.00 5,239,220,044
D 3,008 0.40 372,052 1.00 5,236,516,821
D 3,760 0.50 465,065 1.00 5,235,980,429
D 4,512 0.60 558,078 1.00 5,235,762,503
D 5,264 0.70 651,091 1.00 5,235,697,170
D 6,016 0.79 744,104 1.00 5,235,686,170
D 6,768 0.89 837,117 1.00 5,235,671,523
D 7,520 0.99 930,130 1.00 5,235,656,973
D 7,568 1.00 936,067 1.00 5,235,656,277
D 8,272 1.09 1,023,143 1.00 5,235,646,050
D 9,024 1.19 1,116,156 1.00 5,235,641,492
D 9,776 1.29 1,209,169 1.00 5,235,635,085
D 10,528 1.39 1,302,182 1.00 5,235,627,716
D 11,280 1.49 1,395,195 1.00 5,235,554,799
D 12,032 1.59 1,488,208 1.00 5,234,762,982
D 12,784 1.69 1,581,221 1.00 5,230,411,864
D 13,536 1.79 1,674,234 1.00 5,215,050,869
D 14,288 1.89 1,767,247 0.99 5,176,398,947
D 15,040 1.99 1,860,260 0.95 4,994,127,294

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 1,736 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 2,048 1,759 178.02 0.00 0.00 0.00 0.00 209,710
E 2,048 1,749 199.22 0.00 0.00 0.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 6,062 6,062 0 0
64K 128K 25 25 0 0
128K 256K 4 4 0 0
256K 512K 22 22 0 0
512K 1024K 578 578 0 0
1M 2M 244 244 0 0
2M 4M 18 18 0 0
16M 32M 32 32 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
256 0.13 745,147.05 105,877.56 88.00 0
512 0.25 745,147.05 12,846.00 98.00 0
1,024 0.50 745,147.05 6,816.08 99.00 0
1,536 0.75 745,147.05 6,816.08 99.00 0
2,048 1.00 745,147.05 6,816.08 99.00 0
2,458 1.20 745,147.05 4,733.61 99.00 0
2,867 1.40 745,147.05 4,733.61 99.00 0
3,277 1.60 745,147.05 4,733.61 99.00 0
3,686 1.80 745,147.05 4,733.61 99.00 0
4,096 2.00 745,147.05 4,733.61 99.00 0
6,144 3.00 745,147.05 4,733.61 99.00 0
8,192 4.00 745,147.05 4,733.61 99.00 0
12,288 6.00 745,147.05 4,733.61 99.00 0
16,384 8.00 745,147.05 4,733.61 99.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
272 0.46 69 3,941 2,051,722 0.71 857,052 170.63 41,472,454
336 0.57 131 6,762 2,295,351 0.79 613,423 122.12 41,514,674
400 0.68 194 10,047 2,501,702 0.86 407,072 81.04 41,550,663
464 0.78 257 13,375 2,665,818 0.92 242,956 48.37 41,579,606
528 0.89 320 16,517 2,799,374 0.96 109,400 21.78 41,603,118
592 1.00 383 19,707 2,903,751 1.00 5,023 1.00 41,622,127
656 1.11 446 22,705 2,976,529 1.03 1 0.00 41,636,946
720 1.22 509 25,780 3,030,121 1.04 1 0.00 41,648,458
784 1.32 572 28,499 3,062,451 1.05 1 0.00 41,657,947
848 1.43 635 31,499 3,085,499 1.06 1 0.00 41,665,961
912 1.54 698 34,496 3,103,440 1.07 1 0.00 41,672,663
976 1.65 761 37,730 3,118,696 1.07 1 0.00 41,678,226
1,040 1.76 824 40,825 3,131,264 1.08 1 0.00 41,683,091
1,104 1.86 887 43,868 3,140,740 1.08 1 0.00 41,687,166
1,168 1.97 950 46,870 3,147,942 1.08 1 0.00 41,690,815
1,232 2.08 1,013 50,013 3,153,645 1.09 1 0.00 41,694,195

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,048 0.25 571,693 5,372,830,471
4,096 0.50 551,565 5,236,703,408
6,144 0.75 551,455 5,235,656,277
8,192 1.00 551,455 5,235,656,277
10,240 1.25 551,455 5,235,656,277
12,288 1.50 551,345 5,234,609,146
14,336 1.75 542,687 5,176,493,361
16,384 2.00 540,591 4,994,292,523

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

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

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 305,104 49 0
undo header 4 0 0
undo block 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 8 8 0 8 975 121,860.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 10.91 4,007 381 7 5760/5760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
26-Jun 16:54 356 190 153 3 5,760 0/0 0/0/0/0/0/0
26-Jun 16:44 1,763 346 381 7 5,760 0/0 0/0/0/0/0/0
26-Jun 16:34 3,339 757 170 4 5,760 0/0 0/0/0/0/0/0
26-Jun 16:24 3,853 642 6 3 5,760 0/0 0/0/0/0/0/0
26-Jun 16:14 846 785 103 3 5,760 0/0 0/0/0/0/0/0
26-Jun 16:04 756 1,287 0 3 5,760 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM db client latch 2,394 0.00   0 0  
AWR Alerted Metric Element list 20,604 0.00   0 0  
Consistent RBA 2,367 0.00   0 0  
FAL request queue 74 0.00   0 0  
FAL subheap alocation 74 0.00   0 0  
FIB s.o chain latch 12 0.00   0 0  
FOB s.o list latch 102 0.00   0 0  
In memory undo latch 29,552 0.00   0 2,713 0.00
JS mem alloc latch 5 0.00   0 0  
JS queue access latch 5 0.00   0 0  
JS queue state obj latch 26,026 0.00   0 0  
JS slv state obj latch 16 0.00   0 0  
KMG MMAN ready and startup request latch 1,200 0.00   0 0  
KTF sga latch 8 0.00   0 977 0.00
KWQMN job cache list latch 38 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 0     0 1,200 0.00
OS process 63 0.00   0 0  
OS process allocation 1,251 0.00   0 0  
OS process: request allocation 35 0.00   0 0  
PL/SQL warning settings 1,034 0.00   0 0  
Reserved Space Latch 3 0.00   0 0  
SGA IO buffer pool latch 4,565 0.00   0 4,565 0.00
SQL memory manager latch 1 0.00   0 1,196 0.00
SQL memory manager workarea list latch 92,599 0.00 0.00 0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 12,323 0.00   0 0  
active service list 7,333 0.00   0 1,215 0.00
archive control 159 0.00   0 0  
archive process latch 1,346 0.00   0 0  
begin backup scn array 20 0.00   0 0  
cache buffer handles 8,994 0.00   0 0  
cache buffers chains 663,323,391 0.13 0.01 4 101,884,480 0.00
cache buffers lru chain 96,455 0.87 0.07 0 169,966,948 1.30
cache table scan latch 0     0 3,604,328 1.29
channel handle pool latch 41 0.00   0 0  
channel operations parent latch 21,240 0.00   0 0  
checkpoint queue latch 272,976 0.00 0.00 0 46,069 0.00
client/application info 295 0.00   0 0  
commit callback allocation 16 0.00   0 0  
compile environment latch 24 0.00   0 0  
dml lock allocation 20,464 0.00 0.00 0 0  
dummy allocation 39 0.00   0 0  
enqueue hash chains 95,108 0.00   0 1,021 0.00
enqueues 69,950 0.00   0 0  
event group latch 22 0.00   0 0  
file cache latch 88 0.00   0 0  
global KZLD latch for mem in SGA 13 0.00   0 0  
hash table column usage latch 780 0.00   0 140,054 0.00
hash table modification latch 80 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 62 0.00   0 0  
kks stats 11,255 0.00   0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 1,094 0.00   0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 14 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 2,639 0.04 0.00 0 0  
library cache 240,771 0.00 0.08 0 9,906 0.00
library cache load lock 5,084 0.00   0 0  
library cache lock 68,246 0.00   0 0  
library cache lock allocation 947 0.00   0 0  
library cache pin 84,150 0.00 0.00 0 0  
library cache pin allocation 779 0.00   0 0  
list of block allocation 2,318 0.00   0 0  
loader state object freelist 598 0.00   0 0  
longop free list parent 30 0.00   0 24 0.00
message pool operations parent latch 15 0.00   0 0  
messages 51,247 0.00 0.00 0 0  
mostly latch-free SCN 2,638 0.00   0 0  
multiblock read objects 8,173,230 0.13 0.01 0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 49,621 0.00   0 524 0.00
object queue header operation 81,270,741 0.00 0.05 0 0  
object stats modification 5 0.00   0 0  
parallel query alloc buffer 476 0.00   0 0  
parameter list 124 0.00   0 0  
parameter table allocation management 55 0.00   0 0  
post/wait queue 1,053 0.00   0 692 0.00
process allocation 35 0.00   0 22 0.00
process group creation 35 0.00   0 0  
qmn task queue latch 512 0.20 0.00 0 0  
redo allocation 13,678 0.01 0.00 0 400,225 0.01
redo copy 0     0 400,233 0.01
redo writing 22,050 0.00   0 0  
reservation so alloc latch 2 0.00   0 0  
resmgr group change latch 91 0.00   0 0  
resmgr:active threads 64 0.00   0 0  
resmgr:actses change group 75 0.00   0 0  
resmgr:free threads list 35 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 597,028 0.01 0.00 0 2,812 0.00
rules engine aggregate statistics 4 0.00   0 0  
rules engine rule set statistics 8 0.00   0 0  
sequence cache 1,019 0.00   0 0  
session allocation 494,045 0.00 0.00 0 0  
session idle bit 226,066 0.00   0 0  
session state list latch 97 0.00   0 0  
session switching 58 0.00   0 0  
session timer 1,215 0.00   0 0  
shared pool 199,906 0.00 0.38 0 0  
shared pool simulator 256,631 0.00 0.20 0 0  
simulator hash latch 41,030,506 0.01 0.01 2 0  
simulator lru latch 43,747 0.58 0.15 0 28,368,841 0.70
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 118 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 4 0.00   0 0  
temporary table state object allocation 1 0.00   0 0  
threshold alerts latch 249 0.00   0 0  
transaction allocation 42 0.00   0 0  
transaction branch allocation 1,215 0.00   0 0  
undo global data 61,911 0.00   0 12 0.00
user lock 38 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 663,323,391 833,505 7,164 826,879 0 0 0
multiblock read objects 8,173,230 10,246 144 10,111 0 0 0
simulator hash latch 41,030,506 2,507 37 2,472 0 0 0
cache buffers lru chain 96,455 840 56 785 0 0 0
object queue header operation 81,270,741 589 32 557 0 0 0
simulator lru latch 43,747 254 37 217 0 0 0
library cache 240,771 12 1 11 0 0 0
shared pool 199,906 8 3 5 0 0 0
shared pool simulator 256,631 5 1 4 0 0 0
slave class create 8 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
cache buffers chains kcbgtcr: kslbegin excl 0 11,984 11,549
cache buffers chains kcbrls: kslbegin 0 5,427 5,780
cache buffers chains kcbzwb 0 179 206
cache buffers chains kcbzib: finish free bufs 0 64 195
cache buffers chains kcbzib: multi-block read: nowait 0 52 0
cache buffers chains kcbzgb: scan from tail. nowait 0 27 0
cache buffers chains kcbgtcr: fast path 0 1 0
cache buffers lru chain kcbzgws 0 43 6
cache buffers lru chain kcbzar: KSLNBEGIN 0 13 0
multiblock read objects kcbzib: mbr get 0 75 64
multiblock read objects kcbzib: normal mbr free 0 69 80
object queue header operation kcbw_unlink_q 0 25 3
object queue header operation kcbw_link_q 0 6 0
object queue header operation kcbo_switch_cq 0 3 2
object queue header operation kcbo_switch_mq_bg 0 1 12
shared pool kghupr1 0 2 1
shared pool kgh_next_free 0 1 0
shared pool kghfrunp: clatch: nowait 0 1 0
shared pool simulator kglsim_unpin_simhp 0 1 0
simulator hash latch kcbsacc: lookup dba 0 19 29
simulator hash latch kcbs_lookup_setid: lookup dba 0 10 3
simulator hash latch kcbsacc: insert dba 0 5 0
simulator hash latch kcbsacc: remove dba 0 3 5
simulator lru latch kcbs_simulate: simulate set 0 37 0
slave class create ksvcreate 0 1 0

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

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
HUB TRANSGD_DATA INV_ITEM_LOC_STOR   TABLE 180,383,408 58.10
HUB TRANSGD_DATA BASE_LM_LINE   TABLE 53,302,480 17.17
HUB TRANSGD_DATA PICKING_ORDER_LINE   TABLE 32,188,576 10.37
HUB TRANSGD_DATA OUTBOUND_ORDER_LINE   TABLE 17,971,488 5.79
HUB TRANSGD_DATA INBOUND_ORDER_LINE   TABLE 8,158,160 2.63

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
HUB TRANSGD_DATA BASE_LM_LINE   TABLE 17,081,509 42.16
HUB TRANSGD_DATA PICKING_ORDER_LINE   TABLE 10,201,759 25.18
HUB TRANSGD_DATA OUTBOUND_ORDER_LINE   TABLE 7,860,851 19.40
HUB TRANSGD_DATA PROCESS_ORDER_LIST   TABLE 5,114,075 12.62
HUB TRANSGD_DATA INBOUND_ORDER_LINE   TABLE 234,945 0.58

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
HUB TRANSGD_DATA PK_PICKING_ORDER_LINE   INDEX 53 16.72
HUB TRANSGD_DATA IXU_P_ORDER_1   INDEX 49 15.46
HUB TRANSGD_DATA PK_INV_STOR_HIS   INDEX 48 15.14
HUB TRANSGD_DATA PK_PROCESS_ORDER_LINE   INDEX 33 10.41
HUB TRANSGD_DATA IXU_P_ORDER_LIST_1   INDEX 24 7.57

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
HUB TRANSGD_DATA PICKING_ORDER_LINE_INDEX   INDEX 1 50.00
HUB TRANSGD_DATA PK_INBOUND_LINE_STATUS_HIS   INDEX 1 50.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
HUB TRANSGD_DATA INBOUND_ORDER_LINE   TABLE 1 33.33
HUB TRANSGD_DATA INV_ITEM   TABLE 1 33.33
HUB TRANSGD_DATA RI_INBOUND_ORDER_LIST_1   INDEX 1 33.33

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 66 0.00 0   2 1
dc_database_links 34 0.00 0   0 1
dc_files 11 100.00 0   0 11
dc_global_oids 6,520 0.69 0   0 22
dc_histogram_data 37,264 7.51 0   0 1,478
dc_histogram_defs 45,493 13.78 0   0 2,377
dc_object_grants 682 21.55 0   0 109
dc_object_ids 26,233 2.91 0   0 456
dc_objects 16,298 5.42 0   5 528
dc_profiles 17 5.88 0   0 1
dc_rollback_segments 584 0.00 0   0 26
dc_segments 8,514 13.67 0   7 560
dc_sequences 388 2.06 0   388 1
dc_tablespaces 30,889 0.01 0   0 6
dc_usernames 9,834 0.63 0   0 6
dc_users 37,878 0.17 0   2 44
outstanding_alerts 93 4.30 0   4 12


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 58 39.66 5,454 0.81 20 0
CLUSTER 80 0.00 165 2.42 4 0
INDEX 90 25.56 248 18.55 23 0
SQL AREA 8,799 38.44 257,584 2.62 766 279
TABLE/PROCEDURE 3,837 21.19 35,915 6.70 756 0


Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 127.98   3.46 5.71 22 80 37 37
  Freeable 36.63 0.00 1.41 2.20 12   26 26
  SQL 12.81 7.38 0.47 0.28 1 69 27 26
  PL/SQL 0.63 0.47 0.02 0.02 0 0 35 35
E Other 141.91   3.08 5.19 22 79 46 46
  Freeable 42.25 0.00 1.32 1.99 12   32 32
  SQL 14.02 7.81 0.39 0.27 1 69 36 35
  PL/SQL 1.06 0.71 0.02 0.02 0 0 44 44

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 7,918,845,952  
Fixed Size 2,097,696  
Redo Buffers 14,675,968  
Variable Size 654,314,976  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor 9.59 8.50 -11.42
shared Cursor Stats 10.07 10.07 0.00
shared FileOpenBlock 8.71 8.71 0.00
shared KGH: NO ACCESS 199.31 199.31 0.00
shared KTI-UNDO 8.13 8.13 0.00
shared db_block_hash_buckets 45.00 45.00 0.00
shared event statistics per sess 9.78 9.78 0.00
shared free memory 324.66 326.16 0.46
shared kglsim heap 9.23 9.23 0.00
shared kglsim object batch 17.18 17.18 0.00
shared library cache 11.06 10.91 -1.41
shared private strands 15.24 15.24 0.00
shared sql area 25.40 23.12 -9.00
  buffer_cache 7,552.00 7,552.00 0.00
  fixed_sga 2.00 2.00 0.00
  log_buffer 14.00 14.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

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

No data exists for this section of the report.

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

No data exists for this section of the report.

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

Parameter NameBegin valueEnd value (if different)
audit_file_dest /app/oracle/admin/dmsdb/adump   
background_dump_dest /app/oracle/admin/dmsdb/bdump   
compatible 10.2.0.3.0   
control_files /app/oracle/oradata/dmsdb/control01.ctl, /app/oracle/oradata/dmsdb/control02.ctl, /app/oracle/oradata/dmsdb/control03.ctl   
core_dump_dest /app/oracle/admin/dmsdb/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16 32
db_name dmsdb   
db_recovery_file_dest /bakdata/flash   
db_recovery_file_dest_size 10737418240   
dispatchers (PROTOCOL=TCP) (SERVICE=dmsdbXDB)   
job_queue_processes 10   
open_cursors 300   
optimizer_index_caching 90   
optimizer_index_cost_adj 25   
pga_aggregate_target 2147483648   
processes 1000   
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 100   
sessions 1105   
sga_max_size 8589934592   
sga_target 8589934592   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /app/oracle/admin/dmsdb/udump   


Back to Top

End of Report