WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
PROD251243860530PROD25110.2.0.2.0NObecsys64 4 CPU cores

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1161223-Jun-08 18:00:47175 51.5
End Snap:1161323-Jun-08 19:00:05195 49.9
Elapsed:  59.31 (mins)  
DB Time:  67.20 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 512M 512MStd Block Size: 8K
Shared Pool Size: 512M 512MLog Buffer: 14,364K

Load Profile

Per SecondPer Transaction
Redo size: 24,615.18 3,685.98
Logical reads: 24,669.87 3,694.17
Block changes: 178.98 26.80
Physical reads: 504.78 75.59
Physical writes: 11.63 1.74
User calls: 3,514.02 526.20
Parses: 119.35 17.87
Hard parses: 7.97 1.19
Sorts: 88.17 13.20
Logons: 0.55 0.08
Executes: 2,505.85 375.24
Transactions: 6.68 

% Blocks changed per Read: 0.73Recursive Call %: 18.62
Rollback per transaction %: 4.94Rows per Sort: 10.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 97.97In-memory Sort %: 100.00
Library Hit %: 99.12Soft Parse %: 93.32
Execute to Parse %: 95.24Latch Hit %: 99.92
Parse CPU to Parse Elapsd %: 66.97% Non-Parse CPU: 91.38

Shared Pool Statistics

BeginEnd
Memory Usage %: 88.69 87.53
% SQL with executions>1: 57.68 70.71
% Memory for SQL w/exec>1: 70.66 80.07

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
CPU time  2,066  51.2 
db file scattered read 54,654 1,116 20 27.7User I/O
db file sequential read 92,356 602 7 14.9User I/O
db file parallel write 10,723 76 7 1.9System I/O
log file parallel write 25,096 73 3 1.8System 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 3,820.25 94.75
DB CPU 2,065.87 51.24
PL/SQL execution elapsed time 549.90 13.64
parse time elapsed 391.42 9.71
hard parse elapsed time 265.91 6.59
inbound PL/SQL rpc elapsed time 135.44 3.36
hard parse (sharing criteria) elapsed time 50.40 1.25
PL/SQL compilation elapsed time 49.70 1.23
connection management call elapsed time 13.11 0.33
sequence load elapsed time 3.69 0.09
repeated bind elapsed time 1.11 0.03
hard parse (bind mismatch) elapsed time 1.07 0.03
failed parse elapsed time 0.44 0.01
DB time 4,032.03  
background elapsed time 240.84  
background cpu time 25.95  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 151,084 0.00 1,722 11 6.36
System I/O 47,831 0.00 193 4 2.01
Network 12,627,132 0.00 70 0 531.36
Commit 15,603 0.00 52 3 0.66
Concurrency 2,153 8.04 24 11 0.09
Other 9,220 0.27 9 1 0.39
Administrative 4 0.00 0 76 0.00
Application 507 0.00 0 0 0.02
Configuration 5 0.00 0 25 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file scattered read 54,654 0.00 1,116 20 2.30
db file sequential read 92,356 0.00 602 7 3.89
db file parallel write 10,723 0.00 76 7 0.45
log file parallel write 25,096 0.00 73 3 1.06
TCP Socket (KGAS) 252 0.00 61 240 0.01
log file sync 15,603 0.00 52 3 0.66
control file sequential read 8,289 0.00 18 2 0.35
control file parallel write 3,473 0.00 13 4 0.15
os thread startup 83 0.00 8 99 0.00
Log archive I/O 128 0.00 8 60 0.01
library cache load lock 120 0.00 7 62 0.01
log file sequential read 120 0.00 6 49 0.01
SQL*Net message to client 12,496,713 0.00 6 0 525.87
latch free 4,079 0.00 4 1 0.17
SQL*Net more data to client 129,838 0.00 4 0 5.46
read by other session 372 0.00 3 9 0.02
cursor: pin S wait on X 176 98.30 3 17 0.01
inactive session 3 100.00 3 987 0.00
latch: library cache 353 0.00 2 6 0.01
latch: session allocation 84 0.00 1 13 0.00
latch: shared pool 578 0.00 1 2 0.02
latch: cache buffers chains 670 0.00 1 1 0.03
latch: In memory undo latch 19 0.00 1 37 0.00
latch: row cache objects 44 0.00 1 16 0.00
switch logfile command 4 0.00 0 76 0.00
latch: enqueue hash chains 1,017 0.00 0 0 0.04
LGWR wait for redo copy 358 2.79 0 1 0.02
buffer busy waits 62 0.00 0 3 0.00
latch: object queue header operation 1 0.00 0 178 0.00
latch: cache buffers lru chain 17 0.00 0 9 0.00
SQL*Net break/reset to client 502 0.00 0 0 0.02
enq: TX - row lock contention 5 0.00 0 24 0.00
latch: library cache lock 19 0.00 0 4 0.00
log file switch (private strand flush incomplete) 1 0.00 0 74 0.00
latch: redo allocation 8 0.00 0 9 0.00
kksfbc child completion 1 100.00 0 58 0.00
enq: SQ - contention 2 0.00 0 26 0.00
row cache lock 7 0.00 0 4 0.00
SQL*Net more data from client 329 0.00 0 0 0.01
enq: CF - contention 2 0.00 0 3 0.00
direct path read temp 1,144 0.00 0 0 0.05
direct path write temp 2,545 0.00 0 0 0.11
db file single write 7 0.00 0 1 0.00
rdbms ipc reply 12 0.00 0 0 0.00
latch: library cache pin 22 0.00 0 0 0.00
cursor: pin S 3,622 0.00 0 0 0.15
log file single write 2 0.00 0 1 0.00
latch: undo global data 2 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
latch: messages 2 0.00 0 0 0.00
ksdxexeotherwait 11 90.91 0 0 0.00
direct path write 6 0.00 0 0 0.00
buffer deadlock 1 100.00 0 0 0.00
SQL*Net message from client 12,496,694 0.00 270,515 22 525.87
pipe get 56,174 79.12 212,757 3787 2.36
jobq slave wait 6,368 95.35 18,352 2882 0.27
wait for unread message on broadcast channel 3,526 99.83 3,475 986 0.15
Streams AQ: waiting for messages in the queue 710 100.00 3,473 4891 0.03
Streams AQ: qmn slave idle wait 126 0.00 3,457 27439 0.01
Streams AQ: qmn coordinator idle wait 245 53.47 3,457 14111 0.01
virtual circuit status 118 100.00 3,457 29297 0.00
Streams AQ: waiting for time management or cleanup tasks 14 57.14 3,449 246375 0.00
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
db file parallel write 10,723 0.00 76 7 0.45
log file parallel write 25,096 0.00 73 3 1.06
control file parallel write 3,473 0.00 13 4 0.15
db file sequential read 1,686 0.00 12 7 0.07
os thread startup 83 0.00 8 99 0.00
control file sequential read 3,789 0.00 8 2 0.16
Log archive I/O 128 0.00 8 60 0.01
log file sequential read 120 0.00 6 49 0.01
db file scattered read 85 0.00 2 22 0.00
events in waitclass Other 423 2.36 0 1 0.02
buffer busy waits 3 0.00 0 4 0.00
log file sync 2 0.00 0 3 0.00
db file single write 7 0.00 0 1 0.00
log file single write 2 0.00 0 1 0.00
latch: shared pool 3 0.00 0 0 0.00
latch: redo writing 2 0.00 0 0 0.00
latch: library cache 1 0.00 0 0 0.00
rdbms ipc message 35,800 31.57 36,849 1029 1.51
pmon timer 1,199 98.92 3,476 2899 0.05
smon timer 767 0.00 3,467 4520 0.03
Streams AQ: qmn slave idle wait 126 0.00 3,457 27439 0.01
Streams AQ: qmn coordinator idle wait 245 53.47 3,457 14111 0.01
Streams AQ: waiting for time management or cleanup tasks 14 57.14 3,449 246375 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

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 4,029.60 2,064.30 1,790,827 87,678,148
PROD25.cub.com.au 0.00 0.00 0 0
PROD25XDB 0.00 0.00 0 0
SYS$BACKGROUND 0.00 0.00 4,192 73,909

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
SYS$USERS 147726 169548 2041 1613 4 31 12625922 7013
SYS$BACKGROUND 3344 2573 102 827 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
471 381 42 11.22 11.69 ayjfm1u0vz557 MARC_RFP301 begin marc_audit . event_notic...
282 61 14 20.15 7.00 0s1j2g88y0t5v oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
235 37 6 39.12 5.82 6nh04mb790ktf MARC_RFP603 begin :dbNextCiStep := rfCheck...
219 55 14 15.67 5.44 1p1gxdmmhjh5h oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
172 41 7 24.54 4.26 9twu0950an77m oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
147 106 20 7.33 3.63 au0jt09zajahn MARC_RFP127 begin marc_audit . event_notic...
143 9 6 23.88 3.55 4v049wgkn53jy MARC_RFP603 declare lContNo number ; lLoad...
128 37 7 18.23 3.17 8hkrptsvsdm2u oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
84 77 3,793,224 0.00 2.08 fdgd07c7n96gu oracle@becsys52 (TNS V1-V3) SELECT "DEVICE_ID", "DEVICE_TY...
77 71 24 3.21 1.91 2nm6avdrq1abt MARC_RFP151 select /*+ ORDERED */ lo.loc ...
75 50 11 6.80 1.85 46znwhdvv57zg MARC_RFP301 begin marc_audit . event_notic...
57 14 7 8.16 1.42 bmun55mrzz6jc oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
55 35 13 4.24 1.37 0pnbft2b4gf2n oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
55 23 14 3.91 1.36 a7t3t2unhb339 oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
51 8 14 3.65 1.27 d1c485c7c02cj oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
47 24 7 6.70 1.16 462xh3aajn39j oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
45 6 8 5.65 1.12 dbnt0x8bsxqjr oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
43 35 254 0.17 1.06 8rjhpqy3rj9p1 JDBC Thin Client BEGIN vcpicking.Picked(:1, :2,...

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
381 471 42 9.08 11.69 ayjfm1u0vz557 MARC_RFP301 begin marc_audit . event_notic...
106 147 20 5.28 3.63 au0jt09zajahn MARC_RFP127 begin marc_audit . event_notic...
77 84 3,793,224 0.00 2.08 fdgd07c7n96gu oracle@becsys52 (TNS V1-V3) SELECT "DEVICE_ID", "DEVICE_TY...
71 77 24 2.97 1.91 2nm6avdrq1abt MARC_RFP151 select /*+ ORDERED */ lo.loc ...
61 282 14 4.36 7.00 0s1j2g88y0t5v oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
55 219 14 3.96 5.44 1p1gxdmmhjh5h oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
50 75 11 4.53 1.85 46znwhdvv57zg MARC_RFP301 begin marc_audit . event_notic...
41 172 7 5.84 4.26 9twu0950an77m oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
39 40 1,340,339 0.00 1.00 9ysdsr808fx19 oracle@becsys52 (TNS V1-V3) SELECT "PROD_NO", "SKU" FROM "...
37 235 6 6.24 5.82 6nh04mb790ktf MARC_RFP603 begin :dbNextCiStep := rfCheck...
37 128 7 5.21 3.17 8hkrptsvsdm2u oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
35 43 254 0.14 1.06 8rjhpqy3rj9p1 JDBC Thin Client BEGIN vcpicking.Picked(:1, :2,...
35 55 13 2.67 1.37 0pnbft2b4gf2n oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
24 47 7 3.38 1.16 462xh3aajn39j oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
23 55 14 1.61 1.36 a7t3t2unhb339 oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
14 57 7 2.05 1.42 bmun55mrzz6jc oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
9 143 6 1.55 3.55 4v049wgkn53jy MARC_RFP603 declare lContNo number ; lLoad...
8 51 14 0.56 1.27 d1c485c7c02cj oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
6 45 8 0.79 1.12 dbnt0x8bsxqjr oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....

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
36,228,927 42 862,593.50 41.27 381.25 471.39 ayjfm1u0vz557 MARC_RFP301 begin marc_audit . event_notic...
20,112,334 24 838,013.92 22.91 71.40 77.14 2nm6avdrq1abt MARC_RFP151 select /*+ ORDERED */ lo.loc ...
4,307,261 13 331,327.77 4.91 34.70 55.16 0pnbft2b4gf2n oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
3,910,207 1,340,339 2.92 4.45 38.80 40.19 9ysdsr808fx19 oracle@becsys52 (TNS V1-V3) SELECT "PROD_NO", "SKU" FROM "...
3,618,571 11 328,961.00 4.12 27.16 36.98 83c36nqj32bt3 MARC pickclusid begin PickAssign . AssignPicks...
2,939,822 7 419,974.57 3.35 23.67 46.91 462xh3aajn39j oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
2,446,365 3,793,224 0.64 2.79 77.20 83.69 fdgd07c7n96gu oracle@becsys52 (TNS V1-V3) SELECT "DEVICE_ID", "DEVICE_TY...
2,342,207 6 390,367.83 2.67 37.46 234.69 6nh04mb790ktf MARC_RFP603 begin :dbNextCiStep := rfCheck...
2,332,043 1,205 1,935.31 2.66 9.85 27.74 99um56nfgdg3t MARC_RFP103 SELECT COUNT(DISTINCT LD.PKG_N...
1,912,272 14 136,590.86 2.18 22.59 54.79 a7t3t2unhb339 oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
1,442,117 20 72,105.85 1.64 105.66 146.51 au0jt09zajahn MARC_RFP127 begin marc_audit . event_notic...
1,370,638 7 195,805.43 1.56 36.50 127.62 8hkrptsvsdm2u oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
1,205,298 7 172,185.43 1.37 14.37 57.11 bmun55mrzz6jc oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
1,151,620 7 164,517.14 1.31 40.85 171.79 9twu0950an77m oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
1,143,274 1,479,845 0.77 1.30 30.92 32.57 cdzjjpuxz78b8 oracle@becsys52 (TNS V1-V3) SELECT "PICKQTY_CNTRL_NO", "PI...
1,003,212 935,848 1.07 1.14 19.68 21.32 3dzz05y8qc5zf oracle@becsys52 (TNS V1-V3) SELECT "PICKQTY_CNTRL_NO", "PI...
987,930 2,760 357.95 1.13 17.70 30.98 6uuzkqzu89vnw MARC_RFD612 declare lfkey number ; rfmerge...

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
570,943 6 95,157.17 31.78 37.46 234.69 6nh04mb790ktf MARC_RFP603 begin :dbNextCiStep := rfCheck...
266,603 14 19,043.07 14.84 60.98 282.06 0s1j2g88y0t5v oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
251,928 14 17,994.86 14.03 55.47 219.33 1p1gxdmmhjh5h oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
145,042 7 20,720.29 8.07 40.85 171.79 9twu0950an77m oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
130,014 6 21,669.00 7.24 9.28 143.27 4v049wgkn53jy MARC_RFP603 declare lContNo number ; lLoad...
129,741 7 18,534.43 7.22 36.50 127.62 8hkrptsvsdm2u oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
36,682 14 2,620.14 2.04 22.59 54.79 a7t3t2unhb339 oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
27,329 7 3,904.14 1.52 14.37 57.11 bmun55mrzz6jc oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
25,487 14 1,820.50 1.42 7.86 51.16 d1c485c7c02cj oracle@becsys52 (TNS V1-V3) SELECT "A1"."ACT_BEGIN", "A1"....
15,386 222 69.31 0.86 9.22 32.22 0ratcsq6bxh0h MARC_RFP601 SELECT * FROM LOAD LD WHERE LD...

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
3,793,224 2,446,378 0.64 0.00 0.00 fdgd07c7n96gu oracle@becsys52 (TNS V1-V3) SELECT "DEVICE_ID", "DEVICE_TY...
1,479,845 380,990 0.26 0.00 0.00 cdzjjpuxz78b8 oracle@becsys52 (TNS V1-V3) SELECT "PICKQTY_CNTRL_NO", "PI...
1,340,339 1,303,405 0.97 0.00 0.00 9ysdsr808fx19 oracle@becsys52 (TNS V1-V3) SELECT "PROD_NO", "SKU" FROM "...
935,848 250,803 0.27 0.00 0.00 3dzz05y8qc5zf oracle@becsys52 (TNS V1-V3) SELECT "PICKQTY_CNTRL_NO", "PI...
68,987 68,987 1.00 0.00 0.00 70jncu9thc0j9 SQL*Plus SELECT DECODE(L.ORD_CNTRL_NO, ...
40,329 40,329 1.00 0.00 0.00 gy7a21gjmth95 SQL*Plus SELECT DECODE(H.AREA_TYPE, '1...
33,779 33,779 1.00 0.00 0.00 c031rjn1ctuzb SQL*Plus SELECT BL_NO FROM SHP_CONTAINE...
26,423 26,423 1.00 0.00 0.00 fjs3znakfxaq1 f90runm@becsys64 (TNS V1-V3) SELECT * FROM LOAD WHERE ROWID...
17,690 17,690 1.00 0.00 0.00 19up8xkdk52w4 SQL*Plus SELECT CONT_NO, PARENT_CONT_N...
16,688 16,688 1.00 0.00 0.00 a2wa2uchk97xh MARC_RFD127 begin EXECUTE IMMEDIATE 'BEGIN...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
6,717 6,717 1.58 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
4,916 4,916 1.16 0h6b2sajwb74n   select privilege#, level from ...
2,536 2,536 0.60 2ym6hhaq30r73   select type#, blocks, extents,...
2,372 5,708 0.56 ggqja9xh97qwg MARC_RFP601 SELECT * FROM TASK_DETAIL WHER...
2,326 26,423 0.55 fjs3znakfxaq1 f90runm@becsys64 (TNS V1-V3) SELECT * FROM LOAD WHERE ROWID...
2,216 2,935 0.52 a8d9j19j5q8w5 f90runm@becsys64 (TNS V1-V3) SELECT * FROM bigbox WHERE ...
2,110 4,890 0.50 bacrq4t4vzt12 MARC_RFP601 SELECT * FROM LOAD WHERE LOAD_...
2,041 3,935 0.48 dmmvhf9pvgdxz f90runm@becsys64 (TNS V1-V3) SELECT * FROM ASSIGN WHERE ROW...
1,929 1,929 0.45 4pgzj7dspfm8r f90runm@becsys64 (TNS V1-V3) SELECT ASSIGN_TYPE_DESC FROM...
1,792 1,792 0.42 0k8522rmdzg4k   select privilege# from sysauth...

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

Version Count Executions SQL IdSQL ModuleSQL Text
55 1,208 7xm2tjfw3g2du   INSERT INTO MARCAUDT (APP, CO...
47 1,026 dqvk6rp28acw5 ? @becsys64 (TNS V1-V3) SELECT POLICY_DEF_NUM, POLICY...
44 1,995 fm53dnspz6f7z MARC_RFP335 SELECT COALESCE(:B7 , LD.PROD_...
26 4,980 a589ukxtx0dv7 MARC_RFD612 begin tp_rfaudit . sysResponse...
21 195 b875u4tn63cbg f90runm@becsys64 (TNS V1-V3) SELECT FLD.* FROM ( SELECT DEC...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0pnbft2b4gf2nSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_TYPE", "A3"."TASK_NO", "A3"."ASSIGN_NO", "A4"."TO_LOC", "A4"."TO_LOC", "A4"."ACT_QTY", "A4"."TO_LOC", "A4"."PICKQTY_CNTRL_NO", "A4"."PICK_ZONE_NO", "A4"."ACT_PROD_NO", "A4"."TASK_NO", "A5"."LINE_ID", "A5"."PICK_ZONE_NO", "A6"."DEVICE_ID", "A6"."LINE_ID", "A7"."SKU", "A7"."PROD_NO", "A8"."PICK_STRATEGY", "A8"."PICKQTY_CNTRL_NO" FROM "CLSD_ASSIGN" "A1", "ASSIGNTYPE" "A2", "CLSD_TASK" "A3", "CLSD_TASK_DETAIL" "A4", "PICKZONE" "A5", "PICKLINE" "A6", "SKU" "A7", "PICKQTY" "A8" WHERE "A4"."PICKQTY_CNTRL_NO"="A8"."PICKQTY_CNTRL_NO"(+) AND "A7"."PROD_NO"="A4"."ACT_PROD_NO" AND "A5"."LINE_ID"="A6"."LINE_ID"(+) AND "A4"."PICK_ZONE_NO"="A5"."PICK_ZONE_NO"(+) AND NVL("A4"."TO_LOC", U'XX! XXX')<>U'LOST_FOUND' AND "A4"."TASK_NO"="A3"."TASK_NO" AND "A3"."ASSIGN_NO"="A1"."ASSIGN_NO" AND "A2"."ASSIGN_TYPE"="A1"."ASSIGN_TYPE" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-7 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
0ratcsq6bxh0hSELECT * FROM LOAD LD WHERE LD.CONT_NO IN ( SELECT CN.CONT_NO FROM bigbox CN START WITH CN.CONT_NO = :B2 CONNECT BY PRIOR CN.CONT_NO = CN.PARENT_CONT_NO ) AND LD.LOAD_NO = NVL(:B1 , LD.LOAD_NO)
0s1j2g88y0t5vSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."TASK_NO", "A2"."ASSIGN_NO", "A3"."TO_LOC", "A3"."TO_LOC", "A3"."ACT_QTY", "A3"."TO_LOC", "A3"."PICKQTY_CNTRL_NO", "A3"."PICK_ZONE_NO", "A3"."ACT_PROD_NO", "A3"."TASK_NO", "A4"."SKU", "A4"."PROD_NO" FROM "ACLSD_ASSIGN" "A1", "ACLSD_TASK" "A2", "ACLSD_TASK_DETAIL" "A3", "SKU" "A4" WHERE "A4"."PROD_NO"="A3"."ACT_PROD_NO" AND NVL("A3"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A3"."TASK_NO"="A2"."TASK_NO" AND "A2"."ASSIGN_NO"="A1"."ASSIGN_NO" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-7 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
19up8xkdk52w4SELECT CONT_NO, PARENT_CONT_NO FROM bigbox WHERE ROWID = :B1
1p1gxdmmhjh5hSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."TASK_NO", "A2"."ASSIGN_NO", "A3"."TO_LOC", "A3"."TO_LOC", "A3"."ACT_QTY", "A3"."TO_LOC", "A3"."PICKQTY_CNTRL_NO", "A3"."PICK_ZONE_NO", "A3"."ACT_PROD_NO", "A3"."TASK_NO" FROM "ACLSD_ASSIGN" "A1", "ACLSD_TASK" "A2", "ACLSD_TASK_DETAIL" "A3" WHERE NVL("A3"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A3"."TASK_NO"="A2"."TASK_NO" AND "A2"."ASSIGN_NO"="A1"."ASSIGN_NO" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-7 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
2nm6avdrq1abt select /*+ ORDERED */ lo.loc as caLoc, lo.qty_planned as caQtyPlanned, lo.cube_remain as caCubeRemain, lo.hght_remain as caHeightRemain, nvl(lo.put_seq_no, lo.travel_seq_no) as caPutSeqNo, nvl(lo.travel_seq_no, lo.put_seq_no) as caTravelSeqNo, lo.home_zone as caHomeZone, lo.topmost_remaining as caTopmostRemaining , 1 as caDistance from hzgzones h, loc lo where h.hz_group_name = 'HZ-SHP' and lo.home_zone = h.home_zone and lo.put_avail_flg = 'Y' and rownum < 99999 and lo.qty_planned = 0 union select /*+ ORDERED */ lo.loc as caLoc, lo.qty_planned as caQtyPlanned, lo.cube_remain as caCubeRemain, lo.hght_remain as caHeightRemain, nvl(lo.put_seq_no, lo.travel_seq_no) as caPutSeqNo, nvl(lo.travel_seq_no, lo.put_seq_no) as caTravelSeqNo, lo.home_zone as caHomeZone, lo.topmost_remaining as caTopmostRemaining , 1 as caDistance from hzgzones h, loc lo where h.hz_group_name = 'HZ-SHP' and lo.home_zone = h.home_zone and lo.put_avail_flg = 'Y' and rownum < 99999 and lo.qty_planned > 0 and lo.put_avail_flg = 'Y' and lo.loc in (select c.loc from shipdest s, ordhead o, load l, bigbox c, loc t, homezone z, hzgzones n where n.hz_group_name = 'HZ-SHP' and n.home_zone = z.home_zone and t.home_zone = n.home_zone and t.loc = c.loc and c.cont_no = l.cont_no and l.ord_cntrl_no = o.ord_cntrl_no and o.assgn_ship_date = s.ship_date and o.dest_id = s.dest_id and (decode('N', 'Y', o.shipment_no, -1), decode('Y', 'Y', s.route_id, '-1'), decode('', 'Y', s.dest_id, '-1'), decode('', 'Y', o.consol_cntrl_no, -1), decode('', 'Y', o.po_no, '-1'), decode('' , 'Y', o.ord_cntrl_no, -1)) in (select decode('N', 'Y', o1.shipment_no, -1), decode('Y', 'Y', s1.route_id, '-1'), decode('', 'Y', s1.dest_id, '-1'), decode('', 'Y', o1.consol_cntrl_no, -1), decode('', 'Y', o1.po_no, '-1'), decode('', 'Y', o1.ord_cntrl_no, -1) from shipdest s1, ordhead o1, prodlist p1 where p1.ord_cntrl_no = o1.ord_cntrl_no and o1.assgn_ship_date = s1.ship_date and o1.dest_id = s1.dest_id)) order by caQtyPlanned desc, caQtyPlanned, caLoc, caLoc
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
3dzz05y8qc5zfSELECT "PICKQTY_CNTRL_NO", "PICK_STRATEGY" FROM "APICKQTY" "PKQ" WHERE :1="PICKQTY_CNTRL_NO"
462xh3aajn39jSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_TYPE", "A3"."TASK_NO", "A3"."ASSIGN_NO", "A4"."TO_LOC", "A4"."TO_LOC", "A4"."ACT_QTY", "A4"."TO_LOC", "A4"."PICKQTY_CNTRL_NO", "A4"."PICK_ZONE_NO", "A4"."ACT_PROD_NO", "A4"."TASK_NO", "A5"."LINE_ID", "A5"."PICK_ZONE_NO", "A6"."DEVICE_ID", "A6"."LINE_ID", "A7"."SKU", "A7"."PROD_NO", "A8"."PICK_STRATEGY", "A8"."PICKQTY_CNTRL_NO" FROM "CLSD_ASSIGN" "A1", "ASSIGNTYPE" "A2", "CLSD_TASK" "A3", "CLSD_TASK_DETAIL" "A4", "PICKZONE" "A5", "PICKLINE" "A6", "SKU" "A7", "PICKQTY" "A8" WHERE "A4"."PICKQTY_CNTRL_NO"="A8"."PICKQTY_CNTRL_NO"(+) AND "A7"."PROD_NO"="A4"."ACT_PROD_NO" AND "A5"."LINE_ID"="A6"."LINE_ID"(+) AND "A4"."PICK_ZONE_NO"="A5"."PICK_ZONE_NO"(+) AND NVL("A4"."TO_LOC", U'XX! XXX')<>U'LOST_FOUND' AND "A4"."TASK_NO"="A3"."TASK_NO" AND "A3"."ASSIGN_NO"="A1"."ASSIGN_NO" AND "A2"."ASSIGN_TYPE"="A1"."ASSIGN_TYPE" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-14 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
46znwhdvv57zgbegin marc_audit . event_notice ( marc_audit . cEVNT_ENTER_TRANS , null , 'RFRPLMOVOP' , null , null ) ; rf_move . move_rfmenu ; marc_audit . event_notice ( marc_audit . cEVNT_EXIT_TRANS , null , 'RFRPLMOVOP' , null , null ) ; END ;
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4pgzj7dspfm8rSELECT ASSIGN_TYPE_DESC FROM ASSIGNTYPE WHERE ASSIGN_TYPE = :b1
4v049wgkn53jy declare lContNo number ; lLoadNo number ; lRowid rowid ; nLoadType defput . load_type_flg % TYPE ; FUNCTION NextSupPoLine RETURN recline . p_line_no % TYPE IS nLineNo recline . p_line_no % TYPE ; BEGIN nLineNo := tp_sysdef . GetPolicyDefNum ( p_comp_code => tp_sku . GetCompCode ( p_prod_no => :db_prod_no ) , p_policy_code => 354 ) ; begin select Greatest ( Nvl ( Max ( rl . p_line_no ) , 0 ) , nLineNo ) + 1 into nLineNo from recline rl where rl . rec_cntrl_no = :db_rec_cntrl_no ; exception when others then null ; end ; return ( nLineNo ) ; END NextSupPoLine ; BEGIN marclog . filelog ( 'Entering PL/SQL block for RECLINE insert' ) ; nLoadType := :db_load_type_flg ; BEGIN if :db_load_type_flg = 2 and tp_bigbox . cont_is_cart ( tp_bigbox . get_cont_no ( :db_lp ) ) = glbmarc . false then nLoadType := 3 ; end if ; EXCEPTION WHEN OTHERS THEN marclog . filelog ( 'Error in cont_is_cart call: ' || SQLCODE ) ; END ; if :db_po_line_no = 0 then :db_po_line_no := NextSupP! oLine ; end if ; BEGIN insert into recline ( active_flg , cart_lp , case_count , conf_date , date_time_created , editpass_flg , emp_no , line_no , load_type_flg , lot , lot_vflg , lp , lp_vflg , orig_lp , pkg_no , pkg_no_vflg , po_no , po_no_vflg , prod_no , prod_stat , prod_stat_vflg , puta_deter_flg , puta_conf_flg , loc , slot_id , put_type , p_cntrl_no , p_line_no , qty_checked_in , qty_conf_flg , qty_expe , qty_expe_vflg , record_date , record_time , rec_cntrl_no , s tag_loc , uom , uom_abbrev , uom_abbrev_vflg , uom_qty , dmd_cntrl_no , putaway_strategy , hz_group_name , qty_orig , cont_size_id , cont_size_id_vflg , line_id , rcic_conf_date , parent_lp , cont_position ) values ( 'Y' , decode ( :db_load_type_flg , 3 , :db_lp , null ) , 0 , null , sysdate , '0' , glbmarc . emp_no , :db_rec_line_no , nLoadType , :db_lot , 'Y' , decode ( :db_load_type_flg , 2 , decode ( :db_unit_lp , '' , null , :db_unit_lp ) , 3 , decode ( :db_unit_lp , '' , null , :db_unit_lp ) , :db_lp ) , 'Y' , decode ( :db_rcv_option , 1 , :db_lp , :db_orig_lp ) , :db_pkg_no , 'Y' , decode ( :db_po_cntrl_no , 0 , :db_po_no , null ) , decode ( :db_po_cntrl_no , 0 , 'Y' , null ) , :db_prod_no , decode ( :db_load_stat , :db_lot_stat , null , :db_load_stat ) , 'Y' , 'N' , 'N' , :db_loc , :db_slot_id , nvl ( :db_put_type , 'PUT' ) , decode ( :db_po_cntrl_no , 0 , null , :db_po_cntrl_no ) , :db_po_line_no! , null , 'N' , :db_load_qty , 'Y' , sysdate , to_number ( to_char ( sysdate , 'sssss' ) ) , :db_rec_cntrl_no , :db_stag_loc , :db_each_uom , :db_each_uom_abbrev , 'Y' , :db_load_qty , decode ( :db_dmd_cntrl_no , 0 , null , :db_dmd_cntrl_no ) , :db_put_strat , :db_hzg , decode ( :db_qty_orig , -1 , :db_load_qty , least ( :db_qty_orig , :db_load_qty ) ) , decode ( :db_cont_size_id , 0 , null , :db_cont_size_id ) , 'Y' , :db_line_id , decode ( :db_rcic_conf_date , 'X' , null , to_date ( :db_rcic_conf_date ) ) , decode ( :db_load_type_flg , 2 , decode ( :db_lp , '' , null , :db_lp ) , 3 , decode ( :db_lp , '' , null , :db_lp ) , null ) , :db_shelf_loc ) ; EXCEPTION WHEN OTHERS THEN marclog . filelog ( 'Error in RECLINE insert: ' || SQLCODE ) ; END ; BEGIN convtocont . ConvertReclines ( :db_rec_cntrl_no , :db_rec_line_no ) ; RfCheckIn . CallClientRcvLpGen ; EXCEPTION WHEN OTHERS THEN marclog . filelog ( 'Error in ConvertReclines call: ' || SQLCODE ) ; END ; BEGIN for rLOD in ( select load_no from load where rec_cntrl_no = :db_rec_cntrl_no and rec_line_no = :db_rec_line_no ) loop marclog . filelog ( 'loadattr load - ' || rLOD . load_no ) ; BEGIN rfLoadAttr . CreateLoadAttributes ( rLOD . load_no ) ; EXCEPTION WHEN OTHERS THEN marclog . filelog ( 'Error in CreateLoadAttributes call: ' || SQLCODE ) ; END ; end loop ; EXCEPTION WHEN OTHERS THEN marclog . filelog ( 'Error in rLOD loop: ' || SQLCODE ) ; END ; COMMIT ; EXCEPTION WHEN OTHER! S THEN marclog . filelog ( 'Error in PL/SQL block: ' || SQLCODE ) ; END ;
6nh04mb790ktfbegin :dbNextCiStep := rfCheckin . NextCIStep ; END ;
6uuzkqzu89vnwdeclare lfkey number ; rfmerge RFDFLD_ARRAY := RFDFLD_ARRAY ( :rfm ( 1 ) , :rfm ( 2 ) , :rfm ( 3 ) , :rfm ( 4 ) , :rfm ( 5 ) , :rfm ( 6 ) , :rfm ( 7 ) , :rfm ( 8 ) ) ; rfdntry RFDFLD_ARRAY := RFDFLD_ARRAY ( :rfd ( 1 ) , :rfd ( 2 ) , :rfd ( 3 ) , :rfd ( 4 ) , :rfd ( 5 ) , :rfd ( 6 ) , :rfd ( 7 ) , :rfd ( 8 ) ) ; BEGIN lfkey := :fkey:ifkey ; EXECUTE IMMEDIATE 'BEGIN :bfld := ' || :sqlcmd || '; END;' USING OUT :sqlfld:isqlfld , IN rfmerge , IN rfdntry , IN OUT lfkey ; :fkey:ifkey := lfkey ; END ;
70jncu9thc0j9SELECT DECODE(L.ORD_CNTRL_NO, 0, NULL, L.ORD_CNTRL_NO), DECODE(L.REC_CNTRL_NO, 0, NULL, L.REC_CNTRL_NO), DECODE(L.REC_LINE_NO, 0, NULL, L.REC_LINE_NO), C.CONT_NO, Z.AREA_TYPE FROM LOAD L, bigbox C, LOC T, HOMEZONE Z WHERE L.ROWID = :B1 AND L.CONT_NO = C.CONT_NO (+) AND C.LOC = T.LOC (+) AND T.HOME_ZONE = Z.HOME_ZONE (+)
7xm2tjfw3g2duINSERT INTO MARCAUDT (APP, COMMENTS, EMP_NO, EVENT, EVENT_TIME, REASON_CODE, SERIAL#, SID) VALUES (:B8 , :B7 , NVL(:B6 , :B5 ), :B4 , SYSDATE, :B3 , :B2 , :B1 )
83c36nqj32bt3begin PickAssign . AssignPicks ( :nReqType , :nSetNo , :nEmpNo , :nPackWaveNo , :nPickZoneNo , :nMaxRejects ) ; END ;
8hkrptsvsdm2uSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."TASK_NO", "A2"."ASSIGN_NO", "A3"."TO_LOC", "A3"."TO_LOC", "A3"."ACT_QTY", "A3"."TO_LOC", "A3"."PICKQTY_CNTRL_NO", "A3"."PICK_ZONE_NO", "A3"."ACT_PROD_NO", "A3"."TASK_NO" FROM "ACLSD_ASSIGN" "A1", "ACLSD_TASK" "A2", "ACLSD_TASK_DETAIL" "A3" WHERE NVL("A3"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A3"."TASK_NO"="A2"."TASK_NO" AND "A2"."ASSIGN_NO"="A1"."ASSIGN_NO" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-14 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
8rjhpqy3rj9p1BEGIN vcpicking.Picked(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11) ; END;
99um56nfgdg3tSELECT COUNT(DISTINCT LD.PKG_NO) FROM LOAD LD, LOT LT WHERE LD.CONT_NO IN (SELECT CONT_NO FROM bigbox START WITH CONT_NO = :B5 CONNECT BY PARENT_CONT_NO = PRIOR CONT_NO) AND LD.PROD_NO = :B4 AND LD.PKG_NO = NVL(:B3 , LD.PKG_NO) AND LD.LOT = NVL(:B2 , LD.LOT) AND LT.LOT = LD.LOT AND LT.PROD_NO = LD.PROD_NO AND NVL(LD.PROD_STAT, LT.PROD_STAT) = COALESCE(:B1 , LD.PROD_STAT, LT.PROD_STAT)
9twu0950an77mSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."TASK_NO", "A2"."ASSIGN_NO", "A3"."TO_LOC", "A3"."TO_LOC", "A3"."ACT_QTY", "A3"."TO_LOC", "A3"."PICKQTY_CNTRL_NO", "A3"."PICK_ZONE_NO", "A3"."ACT_PROD_NO", "A3"."TASK_NO", "A4"."SKU", "A4"."PROD_NO" FROM "ACLSD_ASSIGN" "A1", "ACLSD_TASK" "A2", "ACLSD_TASK_DETAIL" "A3", "SKU" "A4" WHERE "A4"."PROD_NO"="A3"."ACT_PROD_NO" AND NVL("A3"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A3"."TASK_NO"="A2"."TASK_NO" AND "A2"."ASSIGN_NO"="A1"."ASSIGN_NO" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-14 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
9ysdsr808fx19SELECT "PROD_NO", "SKU" FROM "SKU" "S" WHERE "PROD_NO"=:1
a2wa2uchk97xhbegin EXECUTE IMMEDIATE 'BEGIN :bfld := ' || :sqlcmd || '; END;' USING OUT :sqlfld:isqlfld , IN :rfdntry ; END ;
a589ukxtx0dv7begin tp_rfaudit . sysResponse ; if :fn_stat = 0 then rfdisman . OnNewMessage ( :pdbszResponse ) ; end if ; END ;
a7t3t2unhb339SELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_TYPE", "A3"."TASK_NO", "A3"."ASSIGN_NO", "A4"."TO_LOC", "A4"."TO_LOC", "A4"."ACT_QTY", "A4"."TO_LOC", "A4"."PICKQTY_CNTRL_NO", "A4"."PICK_ZONE_NO", "A4"."ACT_PROD_NO", "A4"."TASK_NO", "A5"."LINE_ID", "A5"."PICK_ZONE_NO", "A6"."DEVICE_ID", "A6"."LINE_ID" FROM "CLSD_ASSIGN" "A1", "ASSIGNTYPE" "A2", "CLSD_TASK" "A3", "CLSD_TASK_DETAIL" "A4", "PICKZONE" "A5", "PICKLINE" "A6" WHERE "A5"."LINE_ID"="A6"."LINE_ID"(+) AND "A4"."PICK_ZONE_NO"="A5"."PICK_ZONE_NO"(+) AND NVL("A4"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A4"."TASK_NO"="A3"."TASK_NO" AND "A3"."ASSIGN_NO"="A1"."ASSIGN_NO" AND "A2"."ASSIGN_TYPE"="A1"."ASSIGN_TYPE" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-7 AND TRUNC! ("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
a8d9j19j5q8w5SELECT * FROM bigbox WHERE ROWID = :B1
au0jt09zajahnbegin marc_audit . event_notice ( marc_audit . cEVNT_ENTER_TRANS , null , 'INTERLEAVE' , null , null ) ; rf_move . scheduled_move ; marc_audit . event_notice ( marc_audit . cEVNT_EXIT_TRANS , null , 'INTERLEAVE' , null , null ) ; end ;
ayjfm1u0vz557begin marc_audit . event_notice ( marc_audit . cEVNT_ENTER_TRANS , null , 'RFPICK' , null , null ) ; rf_pick . pick_rfmenu ; marc_audit . event_notice ( marc_audit . cEVNT_EXIT_TRANS , null , 'RFPICK' , null , null ) ; end ;
b875u4tn63cbg SELECT FLD.* FROM ( SELECT DECODE(NVL(FF.VISIBLE_CNTRL, 'N'), 'N', 'N' , NVL(FA.VISIBLE , NVL(FF.VISIBLE_CNTRL, 'N'))) VIS_FLG , DECODE(NVL(FF.UPDATE_CNTRL , 'N'), 'N', 'N' , NVL(FA.UPDATEABLE, NVL(FF.UPDATE_CNTRL, 'N'))) UPD_FLG , DECODE(NVL(FF.VISIBLE_CNTRL, 'N'), 'R', 'Y', NVL(FA.REQ_ITEM_FLG , 'N')) REQ_FLG , FF.APP_NO , FF.FLDNAME , NVL(FA.MATCH_VALUE, 0) MATCH_VALUE FROM FORMFLDS FF , ( SELECT FA.VISIBLE, FA.UPDATEABLE, FA.REQ_ITEM_FLG, FA.APP_NO, FA.FLDNAME , DECODE(FA.EMP_NO , EM.EMP_NO , 10, 0 ) + DECODE(FA.SECURITY_LEVEL, EM.SECURITY_LEVEL , 5 , 0 ) + DECODE(FA.LANGUAGE , EM.LANGUAGE , 1 , 0 ) MATCH_VALUE FROM FORMACC FA , EMP EM WHERE EM.EMP_NO = GLBMARC.GETEMPNO AND DECODE(FA.EMP_NO , EM.EMP_NO , 1, NULL, 1, 0 ) = 1 AND DECODE(FA.SECURITY_LEVEL, EM.SECURITY_LEVEL , 1, NULL, 1, 0 ) = 1 AND DECODE(FA.LANGUAGE , EM.LANGUAGE , 1, NULL, 1, 0 ) = 1 ) FA WHERE FF.APP_NO = :B2 AND FF.FLDNAME = :B1 AND FA.APP_NO(+) = FF.APP_NO AND F! A.FLDNAME(+) = FF.FLDNAME ) FLD WHERE FLD.MATCH_VALUE = ( SELECT NVL( MAX( DECODE(MFA.EMP_NO , EM.EMP_NO , 10, 0 ) + DECODE(MFA.SECURITY_LEVEL, EM.SECURITY_LEVEL , 5 , 0 ) + DECODE(MFA.LANGUAGE , EM.LANGUAGE , 1 , 0 ) ), 0) FROM FORMACC MFA , EMP EM WHERE MFA.APP_NO = FLD.APP_NO AND MFA.FLDNAME = FLD.FLDNAME AND EM.EMP_NO = GLBMARC.GETEMPNO AND DECODE(MFA.EMP_NO(+) , EM.EMP_NO , 1, NULL, 1, 0 ) = 1 AND DECODE(MFA.SECURITY_LEVEL(+), EM.SECURITY_LEVEL , 1, NULL, 1, 0 ) = 1 AND DECODE(MFA. LANGUAGE(+) , EM.LANGUAGE , 1, NULL, 1, 0 ) = 1 )
bacrq4t4vzt12SELECT * FROM LOAD WHERE LOAD_NO = :B1
bmun55mrzz6jcSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_TYPE", "A3"."TASK_NO", "A3"."ASSIGN_NO", "A4"."TO_LOC", "A4"."TO_LOC", "A4"."ACT_QTY", "A4"."TO_LOC", "A4"."PICKQTY_CNTRL_NO", "A4"."PICK_ZONE_NO", "A4"."ACT_PROD_NO", "A4"."TASK_NO", "A5"."LINE_ID", "A5"."PICK_ZONE_NO", "A6"."DEVICE_ID", "A6"."LINE_ID" FROM "CLSD_ASSIGN" "A1", "ASSIGNTYPE" "A2", "CLSD_TASK" "A3", "CLSD_TASK_DETAIL" "A4", "PICKZONE" "A5", "PICKLINE" "A6" WHERE "A5"."LINE_ID"="A6"."LINE_ID"(+) AND "A4"."PICK_ZONE_NO"="A5"."PICK_ZONE_NO"(+) AND NVL("A4"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A4"."TASK_NO"="A3"."TASK_NO" AND "A3"."ASSIGN_NO"="A1"."ASSIGN_NO" AND "A2"."ASSIGN_TYPE"="A1"."ASSIGN_TYPE" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-14 AND TRUN! C("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
c031rjn1ctuzbSELECT BL_NO FROM SHP_bigbox WHERE CONT_NO = :B1
cdzjjpuxz78b8SELECT "PICKQTY_CNTRL_NO", "PICK_STRATEGY" FROM "PICKQTY" "PKQ" WHERE :1="PICKQTY_CNTRL_NO"
d1c485c7c02cjSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_TYPE", "A3"."TASK_NO", "A3"."ASSIGN_NO", "A4"."TO_LOC", "A4"."TO_LOC", "A4"."ACT_QTY", "A4"."TO_LOC", "A4"."PICKQTY_CNTRL_NO", "A4"."PICK_ZONE_NO", "A4"."ACT_PROD_NO", "A4"."TASK_NO", "A5"."PICK_STRATEGY", "A5"."PICKQTY_CNTRL_NO", "A6"."SKU", "A6"."PROD_NO" FROM "ACLSD_ASSIGN" "A1", "ASSIGNTYPE" "A2", "ACLSD_TASK" "A3", "ACLSD_TASK_DETAIL" "A4", "APICKQTY" "A5", "SKU" "A6" WHERE "A6"."PROD_NO"="A4"."ACT_PROD_NO" AND "A4"."PICKQTY_CNTRL_NO"="A5"."PICKQTY_CNTRL_NO"(+) AND NVL("A4"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A4"."TASK_NO"="A3"."TASK_NO" AND "A3"."ASSIGN_NO"="A1"."ASSIGN_NO" AND "A2"."ASSIGN_TYPE"="A1"."ASSIGN_TYPE" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-7 ! AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
dbnt0x8bsxqjrSELECT "A1"."ACT_BEGIN", "A1"."ACT_END", "A1"."ACT_BEGIN", "A1"."ASSIGN_TYPE", "A1"."ASSIGN_TYPE", "A1"."ACT_BEGIN", "A1"."ASSIGN_NO", "A1"."ASSIGN_TYPE", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_CLASS", "A2"."ASSIGN_TYPE", "A3"."TASK_NO", "A3"."ASSIGN_NO", "A4"."TO_LOC", "A4"."TO_LOC", "A4"."ACT_QTY", "A4"."TO_LOC", "A4"."PICKQTY_CNTRL_NO", "A4"."PICK_ZONE_NO", "A4"."ACT_PROD_NO", "A4"."TASK_NO", "A5"."PICK_STRATEGY", "A5"."PICKQTY_CNTRL_NO", "A6"."SKU", "A6"."PROD_NO" FROM "ACLSD_ASSIGN" "A1", "ASSIGNTYPE" "A2", "ACLSD_TASK" "A3", "ACLSD_TASK_DETAIL" "A4", "APICKQTY" "A5", "SKU" "A6" WHERE "A6"."PROD_NO"="A4"."ACT_PROD_NO" AND "A4"."PICKQTY_CNTRL_NO"="A5"."PICKQTY_CNTRL_NO"(+) AND NVL("A4"."TO_LOC", U'XXXXX')<>U'LOST_FOUND' AND "A4"."TASK_NO"="A3"."TASK_NO" AND "A3"."ASSIGN_NO"="A1"."ASSIGN_NO" AND "A2"."ASSIGN_TYPE"="A1"."ASSIGN_TYPE" AND TRUNC("A1"."ACT_BEGIN")>=SYSDATE@!-! 14 AND TRUNC("A1"."ACT_BEGIN")<=SYSDATE@!-1 AND TRUNC("A1"."ACT_END")<=SYSDATE@!-1
dmmvhf9pvgdxzSELECT * FROM ASSIGN WHERE ROWID = :B1
dqvk6rp28acw5SELECT POLICY_DEF_NUM, POLICY_DEF_CHAR FROM SYSDEF WHERE COMP_CODE = :B2 AND POLICY_CODE = :B1
fdgd07c7n96guSELECT "DEVICE_ID", "DEVICE_TYPE" FROM "DEVCOM" "DC" WHERE "DEVICE_TYPE"=U'STOR' AND "DEVICE_ID"=:1
fjs3znakfxaq1SELECT * FROM LOAD WHERE ROWID = :B1
fm53dnspz6f7zSELECT COALESCE(:B7 , LD.PROD_NO, TD.ACT_PROD_NO, TD.EXP_PROD_NO) PROD_NO, COALESCE(:B6 , LD.PKG_NO, TD.ACT_PKG_NO, TD.EXP_PKG_NO) PKG_NO, COALESCE(:B5 , LD.LOT, TD.ACT_LOT, TD.EXP_LOT) LOT, COALESCE(:B4 , LD.PROD_STAT, TD.ACT_STATUS, TD.EXP_STATUS) STATUS, COALESCE(:B3 , TD.ACT_LP, TD.EXP_LP) LP, COALESCE(:B2 , TD.ACT_QTY, TD.EXP_QTY) QTY, TD.TO_LOC LOC FROM TASK_DETAIL TD, LOAD LD WHERE TD.ROWID = :B1 AND TD.TO_LOAD_NO = LD.LOAD_NO(+)
ggqja9xh97qwgSELECT * FROM TASK_DETAIL WHERE ROWID = :B1
gy7a21gjmth95SELECT DECODE(H.AREA_TYPE, '160', :B6 , '150', :B5 , '110', :B4 , '811', :B3 , NVL(C.STATUS, :B2 )), H.AREA_TYPE FROM HOMEZONE H, LOC L, bigbox C WHERE H.HOME_ZONE(+) = L.HOME_ZONE AND L.LOC(+) = C.LOC AND C.ROWID = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 217,217 61.04 9.14
CPU used when call started 231,157 64.96 9.73
CR blocks created 57,428 16.14 2.42
Cached Commit SCN referenced 600 0.17 0.03
Commit SCN cached 1 0.00 0.00
DB time 47,315,000 13,296.27 1,991.04
DBWR checkpoint buffers written 14,107 3.96 0.59
DBWR checkpoints 1 0.00 0.00
DBWR object drop buffers written 0 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 261 0.07 0.01
DBWR undo block writes 4,686 1.32 0.20
IMU CR rollbacks 101,265 28.46 4.26
IMU Flushes 3,105 0.87 0.13
IMU Redo allocation size 17,848,080 5,015.59 751.06
IMU commits 20,498 5.76 0.86
IMU contention 380 0.11 0.02
IMU ktichg flush 35 0.01 0.00
IMU pool not allocated 0 0.00 0.00
IMU recursive-transaction flush 5 0.00 0.00
IMU undo allocation size 99,387,536 27,929.47 4,182.27
IMU- failed to get a private strand 0 0.00 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 6 0.00 0.00
SQL*Net roundtrips to/from client 12,494,872 3,511.26 525.79
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 70,311 19.76 2.96
application wait time 24 0.01 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 11,391 3.20 0.48
branch node splits 0 0.00 0.00
buffer is not pinned count 43,505,245 12,225.66 1,830.72
buffer is pinned count 107,317,473 30,157.91 4,515.97
bytes received via SQL*Net from client 1,769,499,268 497,257.36 74,461.34
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 2,741,016,074 770,268.99 115,343.21
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 9,255,974 2,601.08 389.50
calls to kcmgas 95,368 26.80 4.01
calls to kcmgcs 1,313 0.37 0.06
change write time 592 0.17 0.02
cleanout - number of ktugct calls 58,596 16.47 2.47
cleanouts and rollbacks - consistent read gets 56,382 15.84 2.37
cleanouts only - consistent read gets 606 0.17 0.03
cluster key scan block gets 83,693 23.52 3.52
cluster key scans 25,007 7.03 1.05
commit batch performed 3 0.00 0.00
commit batch requested 3 0.00 0.00
commit batch/immediate performed 134 0.04 0.01
commit batch/immediate requested 134 0.04 0.01
commit cleanout failures: block lost 938 0.26 0.04
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 22 0.01 0.00
commit cleanout failures: cannot pin 81 0.02 0.00
commit cleanouts 86,773 24.38 3.65
commit cleanouts successfully completed 85,732 24.09 3.61
commit immediate performed 131 0.04 0.01
commit immediate requested 131 0.04 0.01
commit txn count during cleanout 2,455 0.69 0.10
concurrency wait time 2,437 0.68 0.10
consistent changes 214,255 60.21 9.02
consistent gets 87,223,242 24,511.11 3,670.39
consistent gets - examination 40,242,964 11,308.91 1,693.44
consistent gets direct 1 0.00 0.00
consistent gets from cache 87,223,241 24,511.11 3,670.39
current blocks converted for CR 1 0.00 0.00
cursor authentications 6,674 1.88 0.28
data blocks consistent reads - undo records applied 154,812 43.50 6.51
db block changes 636,903 178.98 26.80
db block gets 564,951 158.76 23.77
db block gets direct 942 0.26 0.04
db block gets from cache 564,009 158.50 23.73
deferred (CURRENT) block cleanout applications 41,846 11.76 1.76
dirty buffers inspected 5,955 1.67 0.25
enqueue conversions 12,225,518 3,435.56 514.46
enqueue deadlocks 0 0.00 0.00
enqueue releases 12,383,618 3,479.99 521.11
enqueue requests 12,383,658 3,480.00 521.11
enqueue timeouts 46 0.01 0.00
enqueue waits 9 0.00 0.00
exchange deadlocks 1 0.00 0.00
execute count 8,917,102 2,505.85 375.24
failed probes on index block reclamation 0 0.00 0.00
frame signature mismatch 1 0.00 0.00
free buffer inspected 1,803,616 506.84 75.90
free buffer requested 1,843,747 518.12 77.59
heap block compress 10,804 3.04 0.45
hot buffers moved to head of LRU 244,132 68.60 10.27
immediate (CR) block cleanout applications 56,988 16.01 2.40
immediate (CURRENT) block cleanout applications 9,770 2.75 0.41
index fast full scans (full) 5,944 1.67 0.25
index fetch by key 19,936,344 5,602.43 838.93
index scans kdiixs1 5,683,067 1,597.03 239.15
leaf node 90-10 splits 28 0.01 0.00
leaf node splits 148 0.04 0.01
lob reads 388 0.11 0.02
lob writes 165 0.05 0.01
lob writes unaligned 165 0.05 0.01
logons cumulative 1,973 0.55 0.08
messages received 35,945 10.10 1.51
messages sent 35,945 10.10 1.51
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 40,806,594 11,467.30 1,717.16
opened cursors cumulative 312,619 87.85 13.16
parse count (failures) 109 0.03 0.00
parse count (hard) 28,366 7.97 1.19
parse count (total) 424,718 119.35 17.87
parse time cpu 17,802 5.00 0.75
parse time elapsed 26,582 7.47 1.12
physical read IO requests 148,439 41.71 6.25
physical read bytes 14,715,101,184 4,135,176.83 619,218.19
physical read total IO requests 156,894 44.09 6.60
physical read total bytes 14,972,781,568 4,207,589.11 630,061.50
physical read total multi block requests 55,928 15.72 2.35
physical reads 1,796,277 504.78 75.59
physical reads cache 1,779,164 499.97 74.87
physical reads cache prefetch 1,631,870 458.58 68.67
physical reads direct 17,113 4.81 0.72
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 17,112 4.81 0.72
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 17,284 4.86 0.73
physical write bytes 338,960,384 95,253.24 14,263.61
physical write total IO requests 49,409 13.88 2.08
physical write total bytes 672,831,488 189,076.32 28,313.06
physical write total multi block requests 14,577 4.10 0.61
physical writes 41,377 11.63 1.74
physical writes direct 18,309 5.15 0.77
physical writes direct (lob) 1 0.00 0.00
physical writes direct temporary tablespace 18,296 5.14 0.77
physical writes from cache 23,068 6.48 0.97
physical writes non checkpoint 30,847 8.67 1.30
pinned buffers inspected 42 0.01 0.00
prefetch clients - default 1 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 36 0.01 0.00
process last non-idle time 3,556 1.00 0.15
recovery blocks read 0 0.00 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 2,861,957 804.26 120.43
recursive cpu usage 89,269 25.09 3.76
redo blocks read for recovery 0 0.00 0.00
redo blocks written 96,223 27.04 4.05
redo buffer allocation retries 1 0.00 0.00
redo entries 272,907 76.69 11.48
redo log space requests 1 0.00 0.00
redo log space wait time 7 0.00 0.00
redo ordering marks 3,117 0.88 0.13
redo size 87,593,544 24,615.18 3,685.98
redo synch time 5,387 1.51 0.23
redo synch writes 38,647 10.86 1.63
redo wastage 9,326,088 2,620.78 392.45
redo write time 7,409 2.08 0.31
redo writer latching time 24 0.01 0.00
redo writes 25,105 7.05 1.06
rollback changes - undo records applied 450 0.13 0.02
rollbacks only - consistent read gets 1,043 0.29 0.04
rows fetched via callback 11,637,900 3,270.43 489.73
session connect time 0 0.00 0.00
session cursor cache hits 192,008 53.96 8.08
session logical reads 87,788,193 24,669.87 3,694.17
session pga memory 414,004,192 116,341.74 17,421.49
session pga memory max 1,681,667,040 472,575.11 70,765.32
session uga memory ############### 357,276,230.74 53,499,995.71
session uga memory max 2,263,358,112 636,039.53 95,243.15
shared hash latch upgrades - no wait 5,751,756 1,616.33 242.04
sorts (disk) 0 0.00 0.00
sorts (memory) 313,771 88.17 13.20
sorts (rows) 3,182,260 894.27 133.91
sql area evicted 6,312 1.77 0.27
sql area purged 139 0.04 0.01
summed dirty queue length 7,634 2.15 0.32
switch current to new buffer 1,663 0.47 0.07
table fetch by rowid 43,991,293 12,362.25 1,851.17
table fetch continued row 38,938 10.94 1.64
table scan blocks gotten 26,552,336 7,461.63 1,117.33
table scan rows gotten 726,607,927 204,188.35 30,575.99
table scans (cache partitions) 0 0.00 0.00
table scans (long tables) 139 0.04 0.01
table scans (short tables) 163,676 46.00 6.89
total number of times SMON posted 768 0.22 0.03
transaction rollbacks 134 0.04 0.01
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 34,020,608 9,560.33 1,431.60
user I/O wait time 172,553 48.49 7.26
user calls 12,504,712 3,514.02 526.20
user commits 22,591 6.35 0.95
user rollbacks 1,173 0.33 0.05
workarea executions - onepass 16 0.00 0.00
workarea executions - optimal 291,427 81.90 12.26
write clones created in background 0 0.00 0.00
write clones created in foreground 12 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
opened cursors current 9,020 9,738
workarea memory allocated 25,005 8,290
logons current 175 195
session cursor cache count 24,174,180 24,195,241

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 1.01

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)
QD54USERS 79,286 22 11.42 15.33 4,848 1 47 20.43
P333USERS 39,285 11 12.43 12.67 5,937 2 324 7.31
SYSTEM 15,483 4 10.01 1.06 213 0 39 2.56
P234USERS 7,614 2 17.08 6.00 1,597 0 12 6.67
SYSAUX 4,299 1 7.36 1.11 1,562 0 0 0.00
TEMP 2,112 1 3.66 8.68 2,095 1 0 0.00
UNDOTBS1 272 0 8.97 1.00 1,021 0 12 2.50
DEFAULT_TS 3 0 10.00 1.00 0 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)
DEFAULT_TS /u6412/oradata/PROD25/default_ts01.dbf 3 0 10.00 1.00 0 0 0 0.00
P234USERS /u6412/oradata/PROD25/p234users01.dbf 7,614 2 17.08 6.00 1,597 0 12 6.67
P333USERS /u6409/oradata/PROD25/p333users01.dbf 39,285 11 12.43 12.67 5,937 2 324 7.31
QD54USERS /u6411/oradata/PROD25/p661users01.dbf 79,286 22 11.42 15.33 4,848 1 47 20.43
SYSAUX /u6410/oradata/PROD25/sysaux01.dbf 4,299 1 7.36 1.11 1,562 0 0 0.00
SYSTEM /u6408/oradata/PROD25/system01.dbf 15,483 4 10.01 1.06 213 0 39 2.56
TEMP /u6409/oradata/PROD25/temp01.dbf 2,112 1 3.66 8.68 2,095 1 0  
UNDOTBS1 /u6410/oradata/PROD25/undotbs01.dbf 272 0 8.97 1.00 1,021 0 12 2.50

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 63,456 98 87,788,970 1,778,457 23,068 0 0 434


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 283 21 1346 6308 52996 921600 52996  
E 286 22 1800 7852 44243 921600 44243  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.13 8,633 165

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 500 41 696.68 24.42 3.51 100.00 0.00 102,400
E 500 31 718.88 9.24 1.29 100.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 281,422 281,422 0 0
64K 128K 212 212 0 0
128K 256K 263 263 0 0
256K 512K 1,414 1,414 0 0
512K 1024K 6,986 6,986 0 0
1M 2M 1,040 1,040 0 0
2M 4M 22 22 0 0
4M 8M 35 34 1 0
8M 16M 55 40 15 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
63 0.13 16,627,214.04 694,519.45 96.00 88,182
125 0.25 16,627,214.04 692,818.19 96.00 87,834
250 0.50 16,627,214.04 655,519.48 96.00 81,072
375 0.75 16,627,214.04 429,676.14 97.00 52,688
500 1.00 16,627,214.04 5,687.11 100.00 1,911
600 1.20 16,627,214.04 1,751.46 100.00 19
700 1.40 16,627,214.04 985.74 100.00 0
800 1.60 16,627,214.04 911.33 100.00 0
900 1.80 16,627,214.04 911.33 100.00 0
1,000 2.00 16,627,214.04 911.33 100.00 0
1,500 3.00 16,627,214.04 911.33 100.00 0
2,000 4.00 16,627,214.04 911.33 100.00 0
3,000 6.00 16,627,214.04 911.33 100.00 0
4,000 8.00 16,627,214.04 911.33 100.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
320 0.63 75 6,395 28,374,686 0.95 1,623,046 7.91 1,512,215,769
384 0.75 131 9,701 28,910,882 0.97 1,086,850 5.29 1,527,958,347
448 0.88 194 13,979 29,214,460 0.98 783,272 3.82 1,531,444,711
512 1.00 257 18,038 29,792,450 1.00 205,282 1.00 1,533,022,329
576 1.13 320 22,064 30,593,595 1.03 1 0.00 1,534,095,514
640 1.25 383 26,275 31,757,463 1.07 1 0.00 1,534,978,196
704 1.38 446 30,223 33,114,445 1.11 1 0.00 1,535,738,009
768 1.50 509 34,451 34,322,466 1.15 1 0.00 1,536,397,878
832 1.63 572 38,500 35,509,836 1.19 1 0.00 1,536,978,448
896 1.75 633 42,769 36,686,022 1.23 1 0.00 1,537,483,919
960 1.88 696 47,368 37,468,317 1.26 1 0.00 1,537,916,387
1,024 2.00 759 51,361 37,961,783 1.27 1 0.00 1,538,284,094

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)Size FactorEst Spill CountEst Spill Time (s)Est Unspill CountEst Unspill Time (s)
16 0.33 0 0 0 0
32 0.67 0 0 0 0
48 1.00 0 0 0 0
64 1.33 0 0 0 0
80 1.67 0 0 0 0
96 2.00 0 0 0 0
112 2.33 0 0 0 0
128 2.67 0 0 0 0
144 3.00 0 0 0 0
160 3.33 0 0 0 0
176 3.67 0 0 0 0
192 4.00 0 0 0 0
208 4.33 0 0 0 0
224 4.67 0 0 0 0
240 5.00 0 0 0 0
256 5.33 0 0 0 0
272 5.67 0 0 0 0
288 6.00 0 0 0 0
304 6.33 0 0 0 0
320 6.67 0 0 0 0

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 422 4 8
undo header 10 0 3
undo block 2 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) 49 5 44 5 0 24.40
SQ-Sequence Cache 95 95 0 2 0 26.50
CF-Controlfile Transaction 4,038 4,036 2 2 0 3.50

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 5.91 38,155 2,890 30 30/60.1833333333333333333333333333333333333 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
23-Jun 19:09 1,392 5,710 1,621 30 39 0/0 0/0/0/0/0/0
23-Jun 18:59 689 5,362 1,685 25 40 0/0 0/0/0/0/0/0
23-Jun 18:49 459 3,844 2,890 23 60 0/0 0/0/0/0/0/0
23-Jun 18:39 809 6,948 2,367 22 51 0/0 0/0/0/0/0/0
23-Jun 18:29 565 4,842 1,615 24 39 0/0 0/0/0/0/0/0
23-Jun 18:19 421 4,367 1,009 25 30 0/0 0/0/0/0/0/0
23-Jun 18:09 1,579 7,082 1,245 28 34 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
AWR Alerted Metric Element list 28,942 0.00   0 0  
Consistent RBA 25,098 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 6 0.00   0 0  
FOB s.o list latch 1,784 0.00   0 0  
In memory undo latch 312,075 0.01 0.58 1 25,057 0.00
JS queue state obj latch 25,524 0.00   0 0  
JS slv state obj latch 245 0.00   0 0  
KMG MMAN ready and startup request latch 1,183 0.00   0 0  
KTF sga latch 11 0.00   0 1,111 0.00
KWQMN job cache list latch 28 0.00   0 0  
KWQP Prop Status 2 0.00   0 0  
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 0     0 1,183 0.00
Mutex 0     0 19,678,404 2.14
OS process 5,187 0.00   0 0  
OS process allocation 4,661 0.00   0 0  
OS process: request allocation 3,146 0.03 1.00 0 0  
PL/SQL warning settings 143,030 0.00 0.00 0 0  
SGA IO buffer pool latch 54,685 0.01 0.00 0 54,685 0.01
SQL memory manager latch 1,332 0.30 0.75 0 1,177 0.00
SQL memory manager workarea list latch 270,433 0.00 0.00 0 0  
Shared B-Tree 135 0.00   0 0  
active checkpoint queue latch 11,907 0.00   0 0  
active service list 17,872 0.00   0 1,199 0.00
archive control 137 0.00   0 0  
archive process latch 1,251 0.08 1.00 0 0  
begin backup scn array 4 0.00   0 0  
cache buffer handles 301,604 0.01 0.00 0 0  
cache buffers chains 139,116,824 0.02 0.03 1 6,865,298 0.01
cache buffers lru chain 78,091 0.25 0.09 0 7,034,726 0.15
cache table scan latch 0     0 54,619 0.05
cas latch 49,401 0.17 0.00 0 0  
channel handle pool latch 4,626 0.02 0.00 0 0  
channel operations parent latch 32,625 0.05 0.00 0 0  
checkpoint queue latch 137,315 0.00   0 21,341 0.00
client/application info 107,494 0.00 1.00 0 0  
commit callback allocation 40 0.00   0 0  
compile environment latch 59,482 0.00   0 0  
constraint object allocation 6 0.00   0 0  
dml lock allocation 99,456 0.01 0.64 0 0  
dummy allocation 3,926 0.10 0.00 0 0  
enqueue hash chains 36,995,179 0.14 0.02 0 185 0.54
enqueues 24,661,155 0.47 0.03 1 0  
event group latch 1,583 0.00   0 0  
file cache latch 178 0.00   0 0  
global KZLD latch for mem in SGA 223 0.00   0 0  
global tx hash mapping 12,227,856 0.00   0 0  
hash table column usage latch 1,921 0.00   0 1,136,259 0.03
hash table modification latch 123 0.00   0 0  
internal temp table object number allocation latc 4,447 0.00   0 0  
job workq parent latch 0     0 637 0.00
job_queue_processes parameter latch 191 0.00   0 0  
kks stats 99,499 0.01 0.43 0 0  
ksuosstats global area 239 0.00   0 0  
ktm global data 779 0.00   0 0  
kwqbsn:qsga 134 0.00   0 0  
lgwr LWN SCN 25,121 0.00 0.00 0 0  
library cache 4,556,587 0.07 0.11 2 113,455 0.14
library cache load lock 17,038 0.02 0.00 0 11 0.00
library cache lock 2,567,568 0.01 0.06 0 0  
library cache lock allocation 41,158 0.01 1.00 0 0  
library cache pin 1,826,513 0.02 0.08 0 1 0.00
library cache pin allocation 14,509 0.00   0 0  
list of block allocation 4,329 0.02 0.00 0 0  
loader state object freelist 1,442 0.00   0 0  
logminer context allocation 1 0.00   0 0  
longop free list parent 71 0.00   0 71 0.00
message pool operations parent latch 1,576 0.00   0 0  
messages 122,319 0.01 0.22 0 0  
mostly latch-free SCN 7,855,201 0.00 0.17 0 0  
multiblock read objects 167,348 0.01 0.09 0 0  
ncodef allocation latch 69 0.00   0 0  
object queue header heap 3,406 0.00   0 3,337 0.00
object queue header operation 3,668,223 0.00 0.05 0 0  
object stats modification 1,510 0.00   0 0  
parallel query alloc buffer 472 0.00   0 0  
parameter table allocation management 2,122 0.33 0.86 1 0  
post/wait queue 25,810 0.00   0 15,617 0.00
process allocation 3,146 0.51 5.00 2 1,580 0.19
process group creation 3,146 0.00   0 0  
qmn task queue latch 504 3.17 0.81 0 0  
redo allocation 125,690 0.02 0.31 0 272,798 0.02
redo copy 0     0 272,816 0.16
redo on-disk SCN 79,312 0.00   0 0  
redo writing 90,207 0.00 0.67 0 0  
resmgr group change latch 33,369 0.03 0.09 0 0  
resmgr:actses active list 3,928 0.00   0 0  
resmgr:actses change group 1,797 0.00   0 0  
resmgr:actses change state 3 0.00   0 0  
resmgr:free threads list 3,922 0.00   0 0  
resmgr:resource group CPU method 3 0.00   0 0  
rm cas latch 14,606 0.00   0 0  
row cache objects 6,966,630 0.05 0.01 1 15,479 0.03
rules engine rule set statistics 100 0.00   0 0  
sequence cache 18,358 0.00   0 0  
session allocation 1,218,200 0.22 0.03 1 0  
session idle bit 25,067,821 0.01 0.04 0 0  
session state list latch 5,094 0.27 0.64 0 0  
session switching 73 0.00   0 0  
session timer 1,199 0.00   0 0  
shared pool 1,880,717 0.17 0.18 1 0  
shared pool simulator 1,621,541 0.00 0.00 0 0  
sim partition latch 1 0.00   0 281 0.00
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 5,654 0.02 0.00 0 0  
state object free list 12 0.00   0 0  
statistics aggregation 140 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 55 0.00   0 0  
threshold alerts latch 287 0.00   0 0  
transaction allocation 1,704,169 0.60 0.01 0 0  
transaction branch allocation 12,227,916 0.01 0.09 0 0  
undo global data 459,790 0.00 0.15 0 0  
user lock 4,988 0.08 0.50 0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
enqueues 24,661,155 116,195 3,577 112,663 0 0 0
enqueue hash chains 36,995,179 50,752 1,015 49,757 0 0 0
cache buffers chains 139,116,824 25,767 670 25,104 0 0 0
transaction allocation 1,704,169 10,217 104 10,114 0 0 0
row cache objects 6,966,630 3,569 44 3,525 0 0 0
shared pool 1,880,717 3,177 579 2,618 0 0 0
library cache 4,556,587 3,086 353 2,751 0 0 0
session allocation 1,218,200 2,706 84 2,623 0 0 0
session idle bit 25,067,821 1,804 80 1,727 0 0 0
transaction branch allocation 12,227,916 1,390 120 1,272 0 0 0
mostly latch-free SCN 7,855,201 390 66 324 0 0 0
library cache lock 2,567,568 342 19 323 0 0 0
library cache pin 1,826,513 282 22 260 0 0 0
cache buffers lru chain 78,091 193 17 176 0 0 0
In memory undo latch 312,075 33 19 15 0 0 0
redo allocation 125,690 26 8 18 0 0 0
object queue header operation 3,668,223 21 1 20 0 0 0
process allocation 3,146 16 80 2 0 0 0
qmn task queue latch 504 16 13 3 0 0 0
session state list latch 5,094 14 9 6 0 0 0
undo global data 459,790 13 2 11 0 0 0
dml lock allocation 99,456 11 7 4 0 0 0
multiblock read objects 167,348 11 1 10 0 0 0
resmgr group change latch 33,369 11 1 10 0 0 0
messages 122,319 9 2 7 0 0 0
kks stats 99,499 7 3 4 0 0 0
parameter table allocation management 2,122 7 6 1 0 0 0
SQL memory manager latch 1,332 4 3 1 0 0 0
user lock 4,988 4 2 2 0 0 0
library cache lock allocation 41,158 3 3 0 0 0 0
redo writing 90,207 3 2 1 0 0 0
OS process: request allocation 3,146 1 1 0 0 0 0
archive process latch 1,251 1 1 0 0 0 0
client/application info 107,494 1 1 0 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
In memory undo latch ktiFlush: child 0 8 14
In memory undo latch ktichg: child 0 4 0
In memory undo latch kticmt: child 0 4 2
In memory undo latch ktiTxnPoolFree 0 3 0
OS process: request allocation ksoreqholder_delete 0 1 1
SQL memory manager latch qesmmIQueryRefreshBound 0 3 3
archive process latch kcrrgpll 0 1 0
cache buffers chains kcbgtcr: fast path 0 453 420
cache buffers chains kcbgtcr: kslbegin excl 0 88 207
cache buffers chains kcbrls: kslbegin 0 73 28
cache buffers chains kcbzib: multi-block read: nowait 0 29 0
cache buffers chains kcbzgb: scan from tail. nowait 0 9 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 7 4
cache buffers chains kcbchg: kslbegin: call CR func 0 4 3
cache buffers chains kcbbxsv 0 2 0
cache buffers chains kcbgtcr: kslbegin shared 0 2 0
cache buffers chains kcbcge 0 1 1
cache buffers chains kcbget: pin buffer 0 1 0
cache buffers chains kcbzib: finish free bufs 0 1 2
cache buffers lru chain kcbzgws 0 15 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 1 0
cache buffers lru chain kcbzar: KSLNBEGIN 0 1 0
client/application info kskirefrattrmap 0 1 0
cost function kzulgt: find user res 0 2 2
dml lock allocation ktaiam 0 7 7
enqueue hash chains ksqcnl 0 432 104
enqueue hash chains ksqgtl3 0 328 793
enqueue hash chains ksqrcl 0 255 118
enqueues ksqgel: create enqueue 0 2,554 2,668
enqueues ksqdel 0 994 815
enqueues ksqies 0 29 94
event range base latch No latch 0 13 13
kks stats kks stats alloc/free 0 3 3
library cache kglpndl: child: after processing 0 50 4
library cache kglobpn: child: 0 29 40
library cache kglScanDependency 0 27 0
library cache kglLockCursor 0 26 40
library cache kgldti: 2child 0 24 8
library cache kglhdgn: child: 0 21 55
library cache kglpndl: child: before processing 0 20 62
library cache kglpin 0 14 10
library cache kglpnp: child 0 13 55
library cache kgldte: child 0 0 4 21
library cache kglic 0 3 0
library cache kglati 0 2 0
library cache kglrtl 0 2 0
library cache kgldtld: 2child 0 1 1
library cache kglhdgc: child: 0 1 0
library cache kglnti 0 1 0
library cache kglobld 0 1 1
library cache kglukp: child 0 1 10
library cache lock kgllkdl: child: no lock handle 0 48 33
library cache lock kgllkdl: child: cleanup 0 12 8
library cache lock kgllkal: child: multiinstance 0 7 11
library cache lock allocation kgllkget 0 2 2
library cache lock allocation kgllkrel 0 1 1
library cache pin kglpnp: child 0 8 16
library cache pin kglpnal: child: alloc space 0 7 3
library cache pin kglpndl 0 7 3
messages ksarcv: after wait 0 2 2
mostly latch-free SCN kcs03 0 39 57
mostly latch-free SCN kcs02 0 26 4
mostly latch-free SCN kcs01 0 1 5
multiblock read objects kcbzib: mbr get 0 1 0
object queue header operation kcbw_link_q 0 1 0
parameter table allocation management ksp_param_table_free 0 6 6
process allocation ksuapc 0 68 65
process allocation ksucrp 0 8 0
process allocation ksudlp 0 4 15
redo allocation kcrfw_redo_gen: redo allocation 1 0 8 0
redo writing kcrfsr: rba scn pair 0 1 0
redo writing kcrfwcr 0 1 0
resmgr group change latch kskthrun 0 1 0
row cache objects kqrpre: find obj 0 20 33
row cache objects kqreqd: reget 0 19 3
row cache objects kqreqd 0 2 6
row cache objects kqrso 0 2 2
session allocation ksuprc 0 19 12
session allocation ksuxds: KSUSFCLC not set 0 19 12
session allocation ksucri 0 18 20
session allocation ksudlc 0 14 17
session allocation ksucrp 0 7 11
session allocation ksuxds: not user session 0 3 10
session allocation ksusroll 0 2 0
session allocation ksudlp 0 1 2
session allocation ksufap: active sessions 0 1 0
session idle bit ksupuc: set busy 0 65 61
session idle bit ksupuc: clear busy 0 13 14
session idle bit ksuxds 0 2 5
session state list latch kpscad 0 5 0
session state list latch kpseqd 0 2 0
session state list latch kpscdl 0 1 2
session state list latch kpseqa 0 1 7
shared pool kghalo 0 409 174
shared pool kghupr1 0 80 243
shared pool kghfrunp: clatch: nowait 0 57 0
shared pool kghfrunp: alloc: wait 0 44 0
shared pool kghfre 0 27 92
shared pool kghalp 0 19 61
shared pool kghfrunp: clatch: wait 0 9 13
slave class create ksvcreate 0 1 0
transaction allocation ktcxbr 0 104 104
transaction branch allocation ksupuc 0 120 120
undo global data ktudba: KSLBEGIN 0 1 1
undo global data kturimugur: child 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
P234 P234USERS ORDHEAD   TABLE 19,832,576 22.59
QD54 QD54USERS LOT_PRIM   INDEX 4,026,176 4.59
QD54 QD54USERS TASK   TABLE 3,519,984 4.01
QD54 QD54USERS TASK_PRIM   INDEX 3,501,488 3.99
QD54 QD54USERS bigbox_PRIM   INDEX 3,123,584 3.56

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
QD54 QD54USERS CLSD_TASK_DETAIL   TABLE 712,810 39.68
P333 P333USERS CLSD_TASK_DETAIL   TABLE 100,695 5.61
QD54 QD54USERS CLSD_ASSIGN   TABLE 55,581 3.09
QD54 QD54USERS LOAD   TABLE 15,035 0.84
QD54 QD54USERS ORDHEAD   TABLE 7,372 0.41

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
P333 P333USERS ASSIGN   TABLE 68 69.39
P234 P234USERS ASSIGN   TABLE 14 14.29
QD54 QD54USERS ASSIGN   TABLE 6 6.12
P333 P333USERS LOC   TABLE 6 6.12
P333 P333USERS EMP   TABLE 2 2.04

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYS SYSTEM JOB$   TABLE 17 34.00
SYS SYSTEM I_JOB_NEXT   INDEX 13 26.00
QD54 QD54USERS TASK   TABLE 6 12.00
SYS SYSTEM SEQ$   TABLE 4 8.00
P333 P333USERS MARCAUDTIX1   INDEX 2 4.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 63 0.00 0   2 1
dc_files 7 100.00 0   0 0
dc_global_oids 19,934 0.58 0   0 38
dc_histogram_data 253,842 4.05 0   0 3,042
dc_histogram_defs 191,265 7.80 0   0 2,123
dc_object_grants 11,533 5.39 0   0 226
dc_object_ids 451,986 0.45 0   30 763
dc_objects 289,140 1.09 0   60 783
dc_profiles 1,791 0.00 0   0 1
dc_rollback_segments 4,190 0.00 0   0 72
dc_segments 141,994 1.78 0   8 761
dc_sequences 6,725 0.62 0   6,725 23
dc_table_scns 9 33.33 0   0 1
dc_tablespaces 247,996 0.01 0   0 7
dc_usernames 12,508 0.17 0   0 18
dc_users 862,696 0.00 0   0 103
global database name 6 33.33 0   0 0
outstanding_alerts 109 88.99 0   0 0


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 5,185 1.76 301,424 0.14 292 0
CLUSTER 112 8.04 197 5.58 2 0
INDEX 36 52.78 111 17.12 0 0
PIPE 21,726 0.84 33,434 0.54 0 0
SQL AREA 26,559 84.34 9,404,244 0.88 6,313 562
TABLE/PROCEDURE 83,664 1.07 552,093 1.45 4,054 0
TRIGGER 4,715 0.28 64,007 0.10 42 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 528.21   2.98 3.38 22 22 177 177
  Freeable 88.69 0.00 1.09 1.66 9   81 81
  SQL 52.14 37.44 0.32 1.45 18 22 165 162
  PL/SQL 22.39 8.99 0.13 0.09 0 0 175 175
E Other 568.32   2.87 3.25 22 22 198 198
  Freeable 89.69 0.00 0.96 1.61 9   93 93
  SQL 36.89 21.43 0.20 0.57 8 28 188 184
  PL/SQL 23.45 9.91 0.12 0.09 0 0 196 196

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 536,870,912  
Fixed Size 2,066,448  
Redo Buffers 14,708,736  
Variable Size 5,888,804,848  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 16.00 16.00 0.00
large free memory 16.00 16.00 0.00
shared ASH buffers 8.00 8.00 0.00
shared CCursor 65.22 68.43 4.92
shared FileOpenBlock 8.71 8.71 0.00
shared Heap0: KGL 6.82 7.57 10.97
shared KTI-UNDO 8.24 8.24 0.00
shared PCursor 36.83 36.23 -1.65
shared PL/SQL MPCODE 17.73 18.05 1.82
shared XDB Schema Cac 8.08 8.08 0.00
shared event statistics per sess 9.64 9.64 0.00
shared free memory 57.92 63.82 10.18
shared kglsim heap 7.70 7.70 0.00
shared kglsim object batch 13.99 13.99 0.00
shared library cache 34.83 34.67 -0.46
shared private strands 15.36 15.36 0.00
shared row cache 7.13 7.13 0.00
shared sessions 5.51 5.51 0.00
shared sql area 98.64 90.41 -8.34
shared sql area:PLSQL 19.31 20.65 6.96
streams free memory 48.00 48.00 0.00
  buffer_cache 512.00 512.00 0.00
  fixed_sga 1.97 1.97 0.00
  log_buffer 14.03 14.03 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeCPU TimeUser I/O TimeSys I/O Time
QMON Slaves 557,725 2,174,655 0
QMON Coordinator 53,299 0 0

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

Ruleset NameEvalsFast EvalsSQL ExecsCPU TimeElapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

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 /u6401/app/oracle/admin/PROD25/audit   
audit_trail TRUE   
background_dump_dest /u6401/app/oracle/admin/PROD25/bdump   
compatible 10.2.0.2.0   
control_files /u6408/oradata/PROD25/control01.ctl, /u6409/oradata/PROD25/control02.ctl   
core_dump_dest /u6401/app/oracle/admin/PROD25/cdump   
cursor_sharing EXACT   
db_block_size 8192   
db_cache_advice ready   
db_cache_size 536870912   
db_domain cub.com.au   
db_file_multiblock_read_count 64   
db_name PROD25   
db_recovery_file_dest /u6401/app/oracle/admin/PROD25/flash_recovery_area   
db_recovery_file_dest_size 4294967296   
disk_asynch_io FALSE   
dispatchers (PROTOCOL=TCP) (SERVICE=PROD25XDB)   
fast_start_mttr_target 300   
filesystemio_options SETALL   
java_pool_size 16777216   
job_queue_processes 10   
large_pool_size 16777216   
log_archive_dest_1 LOCATION=/altwms1arch/app/oracle/admin/PROD25/arch   
log_archive_format %S_%T_%r.log   
max_dump_file_size 1073741824   
nls_date_format DD-MON-RR   
open_cursors 500   
optimizer_mode CHOOSE   
parallel_max_servers 8   
pga_aggregate_target 524288000   
processes 1000   
query_rewrite_enabled TRUE   
remote_dependencies_mode SIGNATURE   
remote_login_passwordfile SHARED   
remote_os_authent TRUE   
service_names PROD25.cub.com.au   
session_max_open_files 20   
sessions 1105   
sga_max_size 6442450944   
shared_pool_reserved_size 53687000   
shared_pool_size 536870912   
sort_area_size 1048576   
star_transformation_enabled TRUE   
streams_pool_size 50331648   
timed_statistics TRUE   
undo_management AUTO   
undo_retention 1800   
undo_tablespace UNDOTBS1   
user_dump_dest /u6401/app/oracle/admin/PROD25/udump   
utl_file_dir *   


Back to Top

End of Report