WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
KLASH1701927951klash106-Jan-15 15:0111.2.0.4.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
oradb11Linux x86 64-bit 48 24 2 126.13

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:318507-Jan-15 16:00:36920 6.3
End Snap:318607-Jan-15 17:00:50968 6.0
Elapsed:  60.23 (mins)  
DB Time:  244.92 (mins)  

Report Summary

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 4.1 0.3 0.00 0.00
DB CPU(s): 3.8 0.3 0.00 0.00
Redo size (bytes): 8,732,104.3 620,051.5  
Logical read (blocks): 414,613.1 29,441.0  
Block changes: 74,698.2 5,304.2  
Physical read (blocks): 282.4 20.1  
Physical write (blocks): 719.4 51.1  
Read IO requests: 26.9 1.9  
Write IO requests: 61.3 4.4  
Read IO (MB): 2.2 0.2  
Write IO (MB): 5.6 0.4  
User calls: 1,029.7 73.1  
Parses (SQL): 171.3 12.2  
Hard parses (SQL): 1.1 0.1  
SQL Work Area (MB): 204.1 14.5  
Logons: 0.4 0.0  
Executes (SQL): 12,224.7 868.1  
Rollbacks: 1.4 0.1  
Transactions: 14.1   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.93In-memory Sort %: 100.00
Library Hit %: 99.97Soft Parse %: 99.37
Execute to Parse %: 98.60Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 94.08% Non-Parse CPU: 99.48

Top 10 Foreground Events by Total Wait Time

EventWaitsTotal Wait Time (sec)Wait Avg(ms)% DB timeWait Class
DB CPU 13.6K 92.8 
enq: TX - row lock contention247482.119523.3Application
log file sync7,488163.3221.1Commit
db file sequential read63,622152.321.0User I/O
db file scattered read12,58585.47.6User I/O
SQL*Net more data to client475,01643.70.3Network
db file parallel read3,41320.46.1User I/O
SQL*Net more data from client6,70217.23.1Network
TCP Socket (KGAS)7,22213.42.1Network
SQL*Net break/reset to client1,7323.22.0Application

Wait Classes by Total Wait Time

Wait ClassWaitsTotal Wait Time (sec)Avg Wait (ms)% DB timeAvg Active Sessions
DB CPU 13,638 92.83.8
System I/O271,81311,7424379.93.2
Application2,0194852403.30.1
User I/O84,09327331.90.1
Commit7,492163221.10.0
Network4,192,499770.50.0
Other3,50641.00.0
Configuration58465.00.0
Concurrency1,50521.00.0

Host CPU

CPUsCoresSocketsLoad Average BeginLoad Average End%User%System%WIO%Idle
48 24 2 6.95 11.00 7.8 0.4 1.3 91.8

Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
7.9 96.2 0.0

IO Profile

Read+Write Per SecondRead per SecondWrite Per Second
Total Requests: 112.2 29.5 82.8
Database Requests: 88.2 26.9 61.3
Optimized Requests: 0.0 0.0 0.0
Redo Requests: 20.3 0.0 20.3
Total (MB): 16.5 2.3 14.3
Database (MB): 7.8 2.2 5.6
Optimized Total (MB): 0.0 0.0 0.0
Redo (MB): 8.6 0.0 8.6
Database (blocks): 1,001.7 282.4 719.4
Via Buffer Cache (blocks): 1,001.6 282.4 719.3
Direct (blocks): 0.1 0.0 0.1

Memory Statistics

BeginEnd
Host Mem (MB): 129,156.5 129,156.5
SGA use (MB): 43,008.0 43,008.0
PGA use (MB): 2,668.4 2,852.7
% Host Mem used for SGA+PGA: 35.37 35.51

Cache Sizes

BeginEnd
Buffer Cache: 25,600M 25,600MStd Block Size: 8K
Shared Pool Size: 12,336M 12,329MLog Buffer: 147,576K

Shared Pool Statistics

BeginEnd
Memory Usage %: 73.79 74.29
% SQL with executions>1: 98.99 98.52
% Memory for SQL w/exec>1: 97.90 94.96

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time14,191.8096.58
DB CPU13,637.5592.80
inbound PL/SQL rpc elapsed time814.645.54
PL/SQL execution elapsed time611.284.16
parse time elapsed105.300.72
hard parse elapsed time92.660.63
connection management call elapsed time15.870.11
hard parse (sharing criteria) elapsed time1.750.01
PL/SQL compilation elapsed time1.140.01
repeated bind elapsed time0.350.00
failed parse elapsed time0.280.00
sequence load elapsed time0.250.00
hard parse (bind mismatch) elapsed time0.000.00
DB time14,695.02 
background elapsed time11,852.08 
background cpu time97.56 


Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME1,427,237 
IDLE_TIME15,945,265 
IOWAIT_TIME221,994 
NICE_TIME252 
SYS_TIME70,153 
USER_TIME1,354,629 
LOAD711
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES2,842,624 
VM_OUT_BYTES0 
PHYSICAL_MEMORY_BYTES135,430,369,280 
NUM_CPUS48 
NUM_CPU_CORES24 
NUM_CPU_SOCKETS2 
GLOBAL_RECEIVE_SIZE_MAX4,194,304 
GLOBAL_SEND_SIZE_MAX1,048,576 
TCP_RECEIVE_SIZE_DEFAULT87,380 
TCP_RECEIVE_SIZE_MAX4,194,304 
TCP_RECEIVE_SIZE_MIN4,096 
TCP_SEND_SIZE_DEFAULT16,384 
TCP_SEND_SIZE_MAX4,194,304 
TCP_SEND_SIZE_MIN4,096 


Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
07-Jan 16:00:366.95     
07-Jan 17:00:5011.008.227.800.4091.781.28


Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  13,638 92.80
Application1,97904852453.30
User I/O81,706025831.76
Commit7,4880163221.11
Network4,189,66207700.52
Configuration58534650.03
Other9703330.02
System I/O9380110.01
Concurrency1,0260000.00


Back to Wait Events Statistics
Back to Top

Foreground Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% DB time
enq: TX - row lock contention247048219520.003.28
log file sync7,4880163220.151.11
db file sequential read63,622015221.251.04
db file scattered read12,58508570.250.58
SQL*Net more data to client475,01604409.330.30
db file parallel read3,41302060.070.14
SQL*Net more data from client6,70201730.130.12
TCP Socket (KGAS)7,222241320.140.09
SQL*Net break/reset to client1,7320320.030.02
enq: MS - contention4037690.000.02
log file switch (private strand flush incomplete)23031240.000.02
SQL*Net message to client3,700,72202072.720.02
control file sequential read9380110.020.01
undo segment extension33941240.000.01
log file switch completion1001500.000.00
direct path write temp900120.000.00
Disk file operations I/O2,0660000.040.00
ADR block file read360030.000.00
ADR block file write50080.000.00
direct path read70060.000.00
direct path read temp40040.000.00
cursor: pin S730000.000.00
enq: JS - queue lock100100.000.00
buffer busy waits1770000.000.00
library cache: mutex X6130000.010.00
latch: shared pool320000.000.00
latch: cache buffers chains1170000.000.00
latch: row cache objects120000.000.00
latch: cache buffers lru chain160000.000.00
SQL*Net message from client3,700,67403,012,12581472.72 
jobq slave wait17,691958,6904910.35 
Streams AQ: waiting for messages in the queue7231003,61550000.01 
wait for unread message on broadcast channel3,662983,6139860.07 
pipe get1,4400210.03 


Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
db file parallel write219,821010,958504.3292.46
log file parallel write41,2300678160.815.72
control file parallel write1,872078410.040.65
control file sequential read7,89602630.160.22
db file sequential read1,4030850.030.06
db file single write4500480.010.03
db file parallel read2902730.000.02
os thread startup8802190.000.01
db file scattered read10801100.000.01
enq: JS - queue lock3280010.010.00
reliable message1,3800000.030.00
direct path write180080.000.00
SQL*Net break/reset to client400030.000.00
log file single write200060.000.00
ADR block file read160070.000.00
enq: CR - block range reuse ckpt200430.000.00
log file sync400160.000.00
log file sequential read200030.000.00
ADR block file write50080.000.00
library cache: mutex X3880000.010.00
LGWR wait for redo copy1,6410000.030.00
Disk file operations I/O3730000.010.00
SQL*Net message to client2,8370000.060.00
latch: cache buffers lru chain230000.000.00
rdbms ipc message85,6184789,35710441.68 
Streams AQ: qmn slave idle wait1,03207,23270080.02 
DIAG idle wait7,2081007,21510010.14 
Streams AQ: waiting for time management or cleanup tasks12673,9193265850.00 
Streams AQ: qmn coordinator idle wait1,200433,61630130.02 
Space Manager: slave idle wait7241003,61649940.01 
Streams AQ: waiting for messages in the queue1,2041003,61330010.02 
pmon timer1,2031003,61330030.02 
shared server idle wait1201003,601300100.00 
dispatcher timer601003,601600110.00 
smon timer19323,5961892450.00 
SQL*Net message from client3,8280122320.08 
class slave wait200000.00 


Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read5246.2 26.919.25.8 1.9 
ADR block file write10  30.030.040.0   
ADR file lock12100.0       
Disk file operations I/O2439100.0       
LGWR wait for redo copy1641100.0       
SQL*Net break/reset to client177268.5.815.010.15.0.6  
SQL*Net message to client3702.9K100.0       
SQL*Net more data from client670271.26.911.36.82.7.6.5.0
SQL*Net more data to client475K99.6.0.1.1.1.1.1 
TCP Socket (KGAS)722277.715.22.44.2.4.0.0.0
buffer busy waits179100.0       
control file parallel write1872  .38.530.022.938.4 
control file sequential read883464.74.210.313.54.31.31.6 
cursor: pin S7398.6   1.4   
db file parallel read344251.76.612.015.47.73.43.2 
db file parallel write219.8K.0.12.418.519.711.248.1.0
db file scattered read12.7K34.14.24.928.320.46.21.9 
db file sequential read65K59.96.913.814.43.31.0.7 
db file single write450 .439.140.212.46.01.8 
direct path read728.6 14.314.342.9   
direct path read temp425.0 50.0 25.0   
direct path write18  16.744.433.35.6  
direct path write temp9  11.155.622.2 11.1 
enq: CR - block range reuse ckpt2   50.0  50.0 
enq: JS - queue lock32975.722.5 .3.9.3.3 
enq: MS - contention425.0     50.025.0
enq: SQ - contention1100.0       
enq: TX - index contention1100.0       
enq: TX - row lock contention24710.9 .4.4.4.444.542.9
latch free23100.0       
latch: In memory undo latch1100.0       
latch: cache buffers chains118100.0       
latch: cache buffers lru chain39100.0       
latch: call allocation1100.0       
latch: checkpoint queue latch1100.0       
latch: object queue header operation2100.0       
latch: redo allocation10100.0       
latch: row cache objects1283.316.7      
latch: shared pool32100.0       
latch: undo global data1100.0       
library cache: mutex X100199.8.1  .1   
log file parallel write41.2K.2.811.728.034.216.38.8 
log file sequential read2045.05.030.015.05.0   
log file single write20 5.010.075.05.05.0  
log file switch (private strand flush incomplete)23   4.3  95.7 
log file switch completion1      100.0 
log file sync7487.42.011.832.525.015.113.2 
os thread startup88     100.0  
reliable message138095.11.71.6.7.8   
undo segment extension3345.5   30.312.112.1 
DIAG idle wait7208      100.0 
SQL*Net message from client3703.5K40.99.819.118.09.11.01.11.0
Space Manager: slave idle wait723       100.0
Streams AQ: qmn coordinator idle wait120056.9   .1  43.0
Streams AQ: qmn slave idle wait1032       100.0
Streams AQ: waiting for messages in the queue1926       100.0
Streams AQ: waiting for time management or cleanup tasks1233.3     33.333.3
class slave wait20100.0       
dispatcher timer60       100.0
jobq slave wait17.7K.0.0.0.1.2.299.5 
pipe get144067.6.130.71.2.3 .1 
pmon timer1202       100.0
rdbms ipc message85.6K14.9.4.71.67.817.530.726.3
shared server idle wait120       100.0
smon timer19       100.0
wait for unread message on broadcast channel3662  .3.8.2.098.6 


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

  % of Total Waits
EventWaits 64ms to 2s<32ms<64ms<1/8s<1/4s<1/2s <1s <2s>=2s
ADR block file read198.1 1.9     
SQL*Net more data from client3399.5.2.1.1.0.1.0 
SQL*Net more data to client30399.9.0.0.0.0.0  
TCP Socket (KGAS)2100.0.0.0    .0
control file parallel write71961.68.226.04.2    
control file sequential read14598.4.8.8     
db file parallel read10996.81.4.9.6.2   
db file parallel write105.8K51.912.728.86.4.3.0.0 
db file scattered read24098.11.2.7     
db file sequential read47299.3.4.4.0    
db file single write898.21.1.4 .2   
direct path write temp188.911.1      
enq: CR - block range reuse ckpt150.0 50.0     
enq: JS - queue lock199.7 .3     
enq: MS - contention325.0    50.025.0 
enq: TX - row lock contention18512.62.03.26.911.321.130.412.6
log file parallel write362591.24.13.7.9.1   
log file switch (private strand flush incomplete)224.38.730.456.5    
log file switch completion1   100.0    
log file sync98586.85.74.52.2.7.1  
undo segment extension487.93.03.03.03.0   


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

  % of Total Waits
EventWaits 4s to 2m<2s <4s <8s<16s<32s< 1m< 2m>=2m
TCP Socket (KGAS)1100.0  .0    
enq: TX - row lock contention3087.410.9.4.4  .4.4


Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

  % of Total Waits
EventWaits 4m to 1h <2m <4m <8m<1/4h<1/2h< 1h>=1h
enq: TX - row lock contention199.6.4     


Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
SYS$USERS14,68113,6281,0101,497,742
klash82040
SYS$BACKGROUND001061
klashXDB0000


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 816992581025000418137377
klash 70100081120
SYS$BACKGROUND 23811547920000


Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s)Executions Elapsed Time per Exec (s) %Total%CPU%IO SQL IdSQL ModuleSQL Text
2,657.99497,8140.0118.0999.820.02c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
2,642.014660.5017.9899.780.03cdy4c52fdcanv   SELECT DISTINCT D.PO_NO, D.ITE...
1,347.974336.999.1799.600.1138vxaybzk778b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
743.014185.755.0699.570.188r6x06b59nuyt DBMS_SCHEDULER /* MV_REFRESH (INS) */INSERT /...
599.104149.774.0899.620.0395hp4vzj95d6b DBMS_SCHEDULER /* MV_REFRESH (DEL) */ delete ...
554.832277.413.7899.600.000qjt2sznvf0r9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
552.842276.423.7699.780.005n4u7kgq4hwgm DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
538.973017.973.6799.800.00ab21w6xh2m3r2 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
538.183017.943.6699.800.00620nmfq8upvsb DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
522.011,0200.513.5599.710.0014n50dm1hxqad   SELECT DISTINCT C.SR# FROM PRO...
509.8368,5490.013.4799.830.0073mzjsxgt8kdb   SELECT NVL(SUM(H.QTY), 0) QTY ...
508.7567,9540.013.4699.810.0042w5jvwyztq0h   SELECT NVL(GET_PLAN_PO_QTY(:B2...
469.261469.263.1998.801.005z5jy8x016mc5   select distinct plan_no, ccode...
443.433413.043.0299.770.000cju83fh33y95   SELECT COUNT(*) FROM (SELECT D...
402.173351.202.7499.180.622zwn3h2hr377k   SELECT SUM(VALUE)/ SUM(STKKG) ...
369.301,4810.252.5199.520.292q4xbuu7qhbd9   SELECT CASE WHEN :B7 =0 THEN N...
343.483610.952.3499.580.012jzkmzmzxza9p DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
324.55812,4890.002.2199.720.014uw118z2skgz1 DBMS_SCHEDULER SELECT WM_CONCAT(PROCESS_NAME)...
269.461262.141.8383.660.01ch0thvp9q6y1w   SELECT DISTINCT T.PLAN_NO, T.P...
249.471220.791.7099.390.0017x173b8v53p7 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
238.116320.381.6299.630.007grsf923r1m4g   select distinct Z.ACT_SIZE S, ...
237.97613.901.620.010.028mq98wyhh24ru   INSERT INTO cut_suply_bundl_m(...
235.921219.661.6199.800.00axqbs2kdrnra7 DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
233.421,0130.231.590.120.078v883pux05qk6   INSERT INTO OPR_WAGES_EMP_MAST...
228.8311,4260.021.5697.990.03869nxpw7xhbyq   SELECT DISTINCT DOC_ID FROM WA...
204.961712.061.3999.780.026nq3t1uk8bkry   SELECT IGPNO, CONTRACT_NO, VEN...
191.15295.581.3099.300.51932827s2cyx97 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
191.151,0800.181.3099.800.0036jw96jy2mrt3   SELECT AVG(RATE) FROM( SELECT ...
185.764,3480.041.2699.670.13c9tu6v6ynpzgs DBMS_SCHEDULER SELECT TO_NUMBER(O.PLAN_NO) PL...
178.45359.481.2152.1847.67fn6836hwdwhwh DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...


Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
2,653.10497,8140.0119.452,657.9999.820.02c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
2,636.164659.0419.332,642.0199.780.03cdy4c52fdcanv   SELECT DISTINCT D.PO_NO, D.ITE...
1,342.514335.639.841,347.9799.600.1138vxaybzk778b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
739.834184.965.42743.0199.570.188r6x06b59nuyt DBMS_SCHEDULER /* MV_REFRESH (INS) */INSERT /...
596.844149.214.38599.1099.620.0395hp4vzj95d6b DBMS_SCHEDULER /* MV_REFRESH (DEL) */ delete ...
552.632276.314.05554.8399.600.000qjt2sznvf0r9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
551.622275.814.04552.8499.780.005n4u7kgq4hwgm DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
537.913017.933.94538.9799.800.00ab21w6xh2m3r2 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
537.133017.903.94538.1899.800.00620nmfq8upvsb DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
520.471,0200.513.82522.0199.710.0014n50dm1hxqad   SELECT DISTINCT C.SR# FROM PRO...
508.9668,5490.013.73509.8399.830.0073mzjsxgt8kdb   SELECT NVL(SUM(H.QTY), 0) QTY ...
507.7867,9540.013.72508.7599.810.0042w5jvwyztq0h   SELECT NVL(GET_PLAN_PO_QTY(:B2...
463.651463.653.40469.2698.801.005z5jy8x016mc5   select distinct plan_no, ccode...
442.423413.013.24443.4399.770.000cju83fh33y95   SELECT COUNT(*) FROM (SELECT D...
398.853351.192.92402.1799.180.622zwn3h2hr377k   SELECT SUM(VALUE)/ SUM(STKKG) ...
367.511,4810.252.69369.3099.520.292q4xbuu7qhbd9   SELECT CASE WHEN :B7 =0 THEN N...
342.053610.952.51343.4899.580.012jzkmzmzxza9p DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
323.63812,4890.002.37324.5599.720.014uw118z2skgz1 DBMS_SCHEDULER SELECT WM_CONCAT(PROCESS_NAME)...
247.961220.661.82249.4799.390.0017x173b8v53p7 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
237.236320.381.74238.1199.630.007grsf923r1m4g   select distinct Z.ACT_SIZE S, ...
235.441219.621.73235.9299.800.00axqbs2kdrnra7 DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
225.431261.791.65269.4683.660.01ch0thvp9q6y1w   SELECT DISTINCT T.PLAN_NO, T.P...
224.2211,4260.021.64228.8397.990.03869nxpw7xhbyq   SELECT DISTINCT DOC_ID FROM WA...
204.511712.031.50204.9699.780.026nq3t1uk8bkry   SELECT IGPNO, CONTRACT_NO, VEN...
190.761,0800.181.40191.1599.800.0036jw96jy2mrt3   SELECT AVG(RATE) FROM( SELECT ...
189.81294.911.39191.1599.300.51932827s2cyx97 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
185.154,3480.041.36185.7699.670.13c9tu6v6ynpzgs DBMS_SCHEDULER SELECT TO_NUMBER(O.PLAN_NO) PL...
136.70527.341.00137.0599.750.06d119jxynhx8ba   SELECT PONO, DTL_DESC, DEMANDN...


Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

User I/O Time (s)Executions UIO per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
85.07328.3631.15178.4552.1847.67fn6836hwdwhwh DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
4.7014.701.72469.2698.801.005z5jy8x016mc5   select distinct plan_no, ccode...
2.503350.010.92402.1799.180.622zwn3h2hr377k   SELECT SUM(VALUE)/ SUM(STKKG) ...
1.5340.380.561,347.9799.600.1138vxaybzk778b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
1.3640.340.50743.0199.570.188r6x06b59nuyt DBMS_SCHEDULER /* MV_REFRESH (INS) */INSERT /...
1.061,4810.000.39369.3099.520.292q4xbuu7qhbd9   SELECT CASE WHEN :B7 =0 THEN N...
0.9720.480.35191.1599.300.51932827s2cyx97 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
0.6640.170.242,642.0199.780.03cdy4c52fdcanv   SELECT DISTINCT D.PO_NO, D.ITE...
0.46497,8140.000.172,657.9999.820.02c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
0.283,5870.000.100.4832.2058.8339m4sx9k63ba2   獥汥捴 ⨫⁩湤數⡩摬彵戲␠楟楤江畢㈱⤠⬪⼠灩散攣ⱬ敮杴栬灩散...


Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets ExecutionsGets per Exec %TotalElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
200,478,126450,119,531.5013.38599.1099.6095hp4vzj95d6b DBMS_SCHEDULER /* MV_REFRESH (DEL) */ delete ...
177,004,559497,814355.5611.812,657.9999.80c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
175,144,589443,786,147.2511.692,642.0199.80cdy4c52fdcanv   SELECT DISTINCT D.PO_NO, D.ITE...
144,168,085436,042,021.259.62743.0199.6.28r6x06b59nuyt DBMS_SCHEDULER /* MV_REFRESH (INS) */INSERT /...
73,519,907361203,656.254.91343.4899.602jzkmzmzxza9p DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
57,673,191228,836,595.503.85554.8399.600qjt2sznvf0r9 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
57,579,459228,789,729.503.84552.8499.805n4u7kgq4hwgm DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
54,529,72168,549795.493.64509.8399.8073mzjsxgt8kdb   SELECT NVL(SUM(H.QTY), 0) QTY ...
54,055,73267,954795.483.61508.7599.8042w5jvwyztq0h   SELECT NVL(GET_PLAN_PO_QTY(:B2...
48,992,6891,02048,032.053.27522.0199.7014n50dm1hxqad   SELECT DISTINCT C.SR# FROM PRO...
47,912,81511,4264,193.313.20228.83980869nxpw7xhbyq   SELECT DISTINCT DOC_ID FROM WA...
41,289,807141,289,807.002.76469.2698.815z5jy8x016mc5   select distinct plan_no, ccode...
40,210,994301,340,366.472.68538.9799.80ab21w6xh2m3r2 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
40,195,104301,339,836.802.68538.1899.80620nmfq8upvsb DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
35,908,382335107,189.202.40402.1799.2.62zwn3h2hr377k   SELECT SUM(VALUE)/ SUM(STKKG) ...
33,477,2041,48122,604.462.23369.3099.5.32q4xbuu7qhbd9   SELECT CASE WHEN :B7 =0 THEN N...
33,132,451216,566,225.502.21191.1599.3.5932827s2cyx97 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
32,996,6324,3487,588.922.20185.7699.7.1c9tu6v6ynpzgs DBMS_SCHEDULER SELECT TO_NUMBER(O.PLAN_NO) PL...
24,299,282126192,851.441.62269.4683.70ch0thvp9q6y1w   SELECT DISTINCT T.PLAN_NO, T.P...
22,450,45211,4231,965.371.50107.2997.50gzqjxjwwthgq5   SELECT COUNT(M.DOC_ID) FROM ST...
20,329,367812,48925.021.36324.5599.704uw118z2skgz1 DBMS_SCHEDULER SELECT WM_CONCAT(PROCESS_NAME)...
18,357,4401,08016,997.631.23191.1599.8036jw96jy2mrt3   SELECT AVG(RATE) FROM( SELECT ...
17,366,811171,021,577.121.16204.9699.806nq3t1uk8bkry   SELECT IGPNO, CONTRACT_NO, VEN...


Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
918,1403306,046.6789.99178.4552.1847.67fn6836hwdwhwh DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
1,47811,478.000.14469.2698.801.005z5jy8x016mc5   select distinct plan_no, ccode...
8613352.570.08402.1799.180.622zwn3h2hr377k   SELECT SUM(VALUE)/ SUM(STKKG) ...
2671,4810.180.03369.3099.520.292q4xbuu7qhbd9   SELECT CASE WHEN :B7 =0 THEN N...
204451.000.022,642.0199.780.03cdy4c52fdcanv   SELECT DISTINCT D.PO_NO, D.ITE...
164497,8140.000.022,657.9999.820.02c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
131432.750.011,347.9799.600.1138vxaybzk778b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
114257.000.01191.1599.300.51932827s2cyx97 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
113428.250.01743.0199.570.188r6x06b59nuyt DBMS_SCHEDULER /* MV_REFRESH (INS) */INSERT /...
553,5870.020.010.4832.2058.8339m4sx9k63ba2   獥汥捴 ⨫⁩湤數⡩摬彵戲␠楟楤江畢㈱⤠⬪⼠灩散攣ⱬ敮杴栬灩散...


Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read ReqsPhysical Read ReqsExecutionsUnOptimized Reqs per Exec%Opt%Total SQL IdSQL ModuleSQL Text
12,95112,95134,317.000.0013.34fn6836hwdwhwh DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
1,4761,47611,476.000.001.525z5jy8x016mc5   select distinct plan_no, ccode...
8598593352.560.000.882zwn3h2hr377k   SELECT SUM(VALUE)/ SUM(STKKG) ...
2652651,4810.180.000.272q4xbuu7qhbd9   SELECT CASE WHEN :B7 =0 THEN N...
203203450.750.000.21cdy4c52fdcanv   SELECT DISTINCT D.PO_NO, D.ITE...
164164497,8140.000.000.17c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
131131432.750.000.1338vxaybzk778b DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
114114257.000.000.12932827s2cyx97 DBMS_SCHEDULER DECLARE job BINARY_INTEGER := ...
55553,5870.020.000.0639m4sx9k63ba2   獥汥捴 ⨫⁩湤數⡩摬彵戲␠楟楤江畢㈱⤠⬪⼠灩散攣ⱬ敮杴栬灩散...
5353262.040.000.05ghkjhqaftqt0m   SELECT PLANNO, STYLENO, ORDERN...


Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
812,489812,4891.00324.5599.704uw118z2skgz1 DBMS_SCHEDULER SELECT WM_CONCAT(PROCESS_NAME)...
497,814497,7901.002,657.9999.80c6rkc2anypq67   SELECT SUM(NVL(QTY_IN, 0)-NVL(...
68,54968,5491.00509.8399.8073mzjsxgt8kdb   SELECT NVL(SUM(H.QTY), 0) QTY ...
67,95467,9541.00508.7599.8042w5jvwyztq0h   SELECT NVL(GET_PLAN_PO_QTY(:B2...
63,084233,1183.7056.5499.40cm5vu20fhtnq1   獥汥捴 ⨫⁣潮湥捴形祟晩汴敲楮朠⨯⁰物癩汥来⌬汥癥氠晲潭⁳祳...
48,154658,38313.673.5789.41.30k8522rmdzg4k   獥汥捴⁰物癩汥来⌠晲潭⁳祳慵瑨␠睨敲攠⡧牡湴敥⌽㨱爠杲慮瑥...
30,06630,0661.001.328.108k4xz9kr1brkt   SELECT NVL(MAX(OPR_DTL_ID), 0)...
11,4267,8550.69228.83980869nxpw7xhbyq   SELECT DISTINCT DOC_ID FROM WA...
11,42311,4251.00107.2997.50gzqjxjwwthgq5   SELECT COUNT(M.DOC_ID) FROM ST...
10,83610,8361.0059.3599.702xbwahn0u2umy   select max(bitand(nvl(option$,...


Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
63,08463,08410.19cm5vu20fhtnq1   獥汥捴 ⨫⁣潮湥捴形祟晩汴敲楮朠⨯⁰物癩汥来⌬汥癥氠晲潭⁳祳...
48,15448,1547.780k8522rmdzg4k   獥汥捴⁰物癩汥来⌠晲潭⁳祳慵瑨␠睨敲攠⡧牡湴敥⌽㨱爠杲慮瑥...
30,06630,0664.868k4xz9kr1brkt   SELECT NVL(MAX(OPR_DTL_ID), 0)...
11,42411,4231.85gzqjxjwwthgq5   SELECT COUNT(M.DOC_ID) FROM ST...
10,83610,8361.752xbwahn0u2umy   select max(bitand(nvl(option$,...
8,3988,3981.361w12wdb3vzc9h   select /*+ index(idl_sb4$ i_id...
7,6557,6551.24cjaa80k1hvpc1   select 1 from sys.cdc_change_t...
6,6786,6781.085p06akzdb4y5s   select log, oldest, oldest_pk,...
6,0496,0490.985pjx5pj5xsmn7 BOOK_STATUS SELECT SYSDATE FROM SYS.DUAL ...
5,8925,8920.95751yt8f5vvzss   SELECT NVL(SUM(M.STITCHED_QTY)...


Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
6,066,036260.057cc7frahtmgnx java@oradb (TNS V1-V3) SELECT DECODE ( SIGN ( SUBSTR ...
4,763,75780.046ch3ddxmt1kkx java@oradb (TNS V1-V3) SELECT DECODE ( SIGN ( SUBSTR ...
2,812,77140.023ss16xn9jc3by   select /*+ NO_CPU_COSTING */ m...
2,559,24930.02fabnkbu3vk8rp   卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂...
1,757,874300.01620nmfq8upvsb DBMS_SCHEDULER INSERT /*+ BYPASS_RECURSIVE_CH...
1,424,12760.019pc5hdmqdgx9j   UPDATE tblhrmemployee SET EMPC...
1,392,1061030.01cd6srfubmwu53 java@oradb (TNS V1-V3) SELECT U.COL , U.PLAN_NO , U.G...


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
0cju83fh33y95SELECT COUNT(*) FROM (SELECT DISTINCT DATED FROM OPR_WAGES_EMP_MASTER WHERE TO_DATE(DATED, 'DD-MM-RR') BETWEEN :b1 AND :b2 )
0k8522rmdzg4k獥汥捴⁰物癩汥来⌠晲潭⁳祳慵瑨␠睨敲攠⡧牡湴敥⌽㨱爠杲慮瑥攣㴱⤠慮搠灲楶楬敧攣㸰
0qjt2sznvf0r9DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.MV_SHIPPING'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
14n50dm1hxqadSELECT DISTINCT C.SR# FROM PRODUCTION.CUT_SUPLY_BUNDL C, CUT_SUPLY_BUNDL_M M WHERE C.DOC_ID=M.DOC_ID AND C.CARD_NO=:B2 AND M.PLANNO=:B1 AND C.STATUS=0 AND C.SR# IN (SELECT NVL(A.SR#, 0) FROM STIT_REC_ISSUE_D A )
17x173b8v53p7DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.MV_STITCHING'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
1w12wdb3vzc9hselect /*+ index(idl_sb4$ i_idl_sb41) +*/ max(version) from idl_sb4$ where obj#=:1 and version > 0 and version<=:2 and (part=0 or part=2) and piece#=0
2jzkmzmzxza9pDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.yarn_bag_stk_loc'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
2q4xbuu7qhbd9 SELECT CASE WHEN :B7 =0 THEN NVL((((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_WASTE(:B5 , :B3 , :B2 ))*100)* KNT_YARN_RATE(:B5 , :B3 , :B2 )), 0) ELSE NVL(((((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_WASTE(:B5 , :B3 , :B2 ))*100)/KNT_YDY_WASTE(:B5 , :B3 , :B2 )*100)) * KNT_YARN_RATE(:B5 , :B3 , :B2 ), 0) END + NVL((((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_WASTE(:B5 , :B3 , :B2 ))*100)* KNT_YDY_RATE(:B5 , :B3 , :B2 )), 0)+ CASE WHEN :B6 =22 THEN NVL((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)/KNT_KNT_CONSUMPTION(:B5 , :B3 , :B2 )*KNT_KNT_RATE(:B5 , :B3 , :B2 ) ), 0) WHEN :B6 =2 THEN DECODE(KNT_KNT_OPR_VAL(:B2 , 'OPR'), 'D', (STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 )*100)*(KNT_KNT_OPR_VAL(:B2 , 'CON')/KNT_KNT_OPR_VAL(:B2 , 'VAL'))*KNT_KNT_RATE(:B5 , :B3 , :B2 ), 'M', (STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 )*100)*KNT_KNT_OPR_VAL(:B2 , 'CON')*KNT_KNT_RATE(:B5 , :B3 , :B2 )) ELSE NVL((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)*KNT_KNT_RATE(:B5 , :B3 , :B2 ) ), 0) END + NVL((((STK/DYE_DYEING_WASTE(:B5 , :B3 , :B2 , :B1 ))*100)*DYE_DYEING_RATE(:B5 , :B3 , :B2 , :B1 )), 0)+ NVL((STK*PRT_PRINT_RATE(:B5 , :B3 , :B2 , :B1 )), 0) + NVL(STK*FIN_FINISH_RATE(:B5 , :B3 , :B2 , :B1 ), 0) FROM ( SELECT NVL(SUM(B.NW_IN), 0) STK FROM FAB_SR_MAST A , FAB_SR_DTL B WHERE A.SUP_REC_NO = B.SUP_REC_NO AND A.STOCK_TYPE IN ('FFB', 'FFA') AND A.CCODE = :B5 AND A.SUP_TARGET='RECEIVED' AND TO_DATE(A.ENTRY_DATE, 'DD-MM-YY')<= TO_DATE(:B4 , 'DD-MM-YY') AND PLANNO=:B3 AND FABRIC_CODE=:B2 AND COLOR=:B1 )
2xbwahn0u2umyselect max(bitand(nvl(option$, 0), 17)) from sysauth$ auth where privilege#=:1 connect by grantee#=prior privilege# and privilege#>0 start with (grantee#=:2 and privilege#>0 and privilege# in ( 2, 774, 778, 781, 783, 787, 789, 790, 794, 798, 801, 804, 808, 810, 816, 827, 828, 833, 834, 837 )) or (grantee#=1 and privilege#>0) group by privilege#
2zwn3h2hr377kSELECT SUM(VALUE)/ SUM(STKKG) FROM ( SELECT A.CCODE, B.PLANNO, B.FABRIC_CODE, GET_FABRIC(B.FABRIC_CODE) FABRUC, B.COLOR, NVL(SUM(B.NW_IN), 0) STK , PRODUCTION.FINISH_FABRIC_REC(A.CCODE, B.PLANNO, B.FABRIC_CODE, B.COLOR, SYSDATE) VALUE, PRODUCTION.FINISH_FABRIC_REC(A.CCODE, B.PLANNO, B.FABRIC_CODE, B.COLOR, SYSDATE) /NVL(SUM(B.NW_IN), 0) PKGRATE , P.UNIT_CODE, DECODE(P.UNIT_CODE, 1, NVL(SUM(B.NW_IN), 0), 0) STKKG FROM FAB_SR_MAST A , FAB_SR_DTL B, TBLPLAN_CUT_DYE_KNT P WHERE A.SUP_REC_NO = B.SUP_REC_NO AND A.STOCK_TYPE IN ('FFB', 'FFA') AND A.CCODE = 9 AND A.SUP_TARGET='RECEIVED' AND TO_DATE(A.ENTRY_DATE, 'DD-MM-YY')<= SYSDATE AND B.PLANNO=:B1 AND B.PLANNO=P.PLAN_NO AND B.FABRIC_CODE=P.FABRIC_CODE AND B.COLOR=P.COLOR GROUP BY A.CCODE, B.PLANNO, B.FABRIC_CODE, B.COLOR, P.UNIT_CODE )
36jw96jy2mrt3SELECT AVG(RATE) FROM( SELECT DISTINCT M.PLAN_NO, D.FABRIC_CODE, D.ITEM_SUB_CODE, KNT_WST, RATE, ECRU_YARN_RATE(M.PLAN_NO, D.ITEM_SUB_CODE) ERATE FROM TBLCONTRACTMAST M, TBLKNTCONTRACTDTL D WHERE M.CONTRACT_NO=D.CONTRACT_NO AND M.PLAN_NO=:B3 AND D.FABRIC_CODE=:B2 AND M.CCODE=:B1 AND D.KNT_QTY>0 AND EXISTS (SELECT 1 FROM FAB_SR_MAST A, FAB_SR_DTL B WHERE A.SUP_REC_NO=B.SUP_REC_NO AND A.CCODE=:B1 AND A.STOCK_TYPE='GFB' AND A.ENTRYTYPE IN('FRE', 'FRD') AND B.FABRIC_CODE=:B2 AND B.PLANNO=:B3 AND A.CONTRACT_ISUNO=M.CONTRACT_NO) )
38vxaybzk778bDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.wages_sheet_mv'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
39m4sx9k63ba2獥汥捴 ⨫⁩湤數⡩摬彵戲␠楟楤江畢㈱⤠⬪⼠灩散攣ⱬ敮杴栬灩散攠晲潭⁩摬彵戲␠睨敲攠潢樣㴺ㄠ慮搠灡牴㴺㈠慮搠癥牳楯渽㨳牤敲⁢礠灩散攣
3ss16xn9jc3by select /*+ NO_CPU_COSTING */ mm.col, mm.ACT_SIZE, mm.REQ_QTY, MM.TO_CUT_PCS TO_CUT_PC , ab.qty1, nvl(S.S_QTY, 0) S_QTY, round(mm.REQ_QTY + (mm.REQ_QTY*tp.waste/100), 0) req_2, Z.REJ_QTY, ST_QTY, s.cut_status, s.ind_status, s.stit_status, s.plan_status, WR.WHQTY, SR.WRQTY from ACT_CUT_PCS_VIEW MM, tblplanorder tp, plan_status s, ( SELECT m.planno, d.g_SIZe, SUM(nvl(D.QTY, 0)) QTY1 FROM CUT_SUPLY_BUNDL D, CUT_SUPLY_BUNDL_M M WHERE (M.ENTRY_TYPE = 'IITS') AND (M.DOC_ID = D.DOC_ID) and m.planno=:plan GROUP BY M.PLANNO, M.ENTRY_TYPE, D.G_SIZE ) ab , ( select v.planno, v.g_size, nvl(sum(v.rej_qty), 0) rej_qty from cut_stch_iss_bal_v v where v.planno=:plan group by v.planno, v.g_size ) z , ( select t.ACT_SIZE COL, v.s1 S_QTY from SHIP_SIZE_VIEW v, act_cut_pcs_view t where t.PLAN_NO=v.plan_no and t.plan_no= :PLAN and t.COL=v.S order by v.S ) S, (SELECT T.ACT_SIZE COL, SUM(V.QTY) WHQTY FROM STITCH_RECIVE_WHAREHOUSE V, ACT_CUT_PCS_VIEW T WHERE T.PLAN_NO=V.PLANNO AND T.PLAN_NO= :PLAN AND T.COL=V.COL_SIZE GROUP BY T.ACT_SIZE, V.COL_SIZE HAVING SUM(V.QTY)>0 ORDER BY V.COL_SIZE) WR, (SELECT T.ACT_SIZE COL, SUM(R.QTY)WRQTY FROM STITCH_RETURN_WHAREHOUSE R, ACT_CUT_PCS_VIEW T WHERE T.PLAN_NO=R.PLANNO AND T.PLAN_NO=:PLAN AND T.COL=R.COL_SIZE GROUP BY T.ACT_SIZE, R.COL_SIZE HAVING SUM(R.QTY)>0 ORDER BY R.COL_SIZE)SR, (select d.g_size, sum(d.stitched_qty) ST_QTY from cut_suply_bundl_m m, cut_suply_bundl d where d.doc_id=m.doc_id and d.ent_type='IITS' and m.planno=:PLAN and d.stitched_qty is not null group by m.planno, d.g_size order by d.col_size ) h where tp.plan_no =MM.plan_no AND MM.PLAN_NO = :PLAN and ab.g_size(+)=mm.ACT_SIZE and z.g_size(+)=mm.ACT_SIZE and S.COL(+)=mM.act_size and h.g_size(+)=mM.act_size and wr.col(+)=mM.act_size and sr.col(+)=mM.act_size AND MM.REQ_QTY>0 and tp.waste is not null and mm.plan_no=s.plan_no(+) group by mm.col, MM.PLAN_NO, mm.ACT_SIZE, mm.REQ_QTY, ab.qty1, rej_qty, tp.waste, S.S_QTY, MM.TO_CUT_PCS, ST_QTY , s.cut_status, s.ind_ status, s.stit_status, s.plan_status, WR.WHQTY, SR.WRQTY Order by 1
42w5jvwyztq0hSELECT NVL(GET_PLAN_PO_QTY(:B2 , :B1 ), 0) FROM DUAL
4uw118z2skgz1SELECT WM_CONCAT(PROCESS_NAME) FROM ( SELECT DISTINCT P.PROCESS_NAME, FR.ORD FROM RND_SR_DTL D, PRODUCTION.SD_FINISH_ROUT FR, PRODUCTION.FINISH_ROUT P WHERE D.SUP_REC_NO=:B2 AND D.PK=FR.PK AND D.PK=:B1 AND FR.PROCESS_ID=P.PROCESS_ID ORDER BY ORD )
5n4u7kgq4hwgm INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."MV_SHIPPING" select t.ccode, c.c_name, s.plan_no, 'BY- ' || e.ship_mode ship_mode, e.inv_date ship_date, t.pono, t.pl_no, trunc(t.pl_date) PL_DATE, m.style, nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) CMT_RATE, e.inv_no, e.inv_no_m, GetPL_Qty_PCS(t.pl_no) PCS, GetPL_Qty_PCS(t.pl_no)*nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) AMOUNT, get_cmt_contract_no(t.ccode, s.plan_no, g.garment_id)contract_no , g.garment_id , t.po_close from wpl_mst t, tblplanorder s, kcl_po_main m, expinv_mst e, dye.cdtl c, expinv_dtl_pl ed, tblplanpics g where t.pack_type = 'WP' and s.order_no = t.pono and e.inv_no = ed.inv_no and ed.pl_no = t.pl_no and m.pono = s.order_no AND E.CANCEL_STATUS='N' and e.approved=1 and g.plan_no=s.plan_no and t.ccode=c.c_code --and s.plan_no LIKE NVL(:planno, '%') --and t.pl_no not in (select r.pl_no from expsal_inv r) -- and trunc(e.inv_date) between nvl(:FDATE , to_date(sysdate-10000, 'DD-MM-RRRR')) AND nvl(:TDATE , to_date(sysdate, 'DD-MM-RRRR')) --and t.ccode=decode(:P_cCODE, 4, 15, NULL, T.CCODE, :P_CCODE) union all select t.ccode, c.c_name, s.plan_no, 'BY- ' || e.ship_mode ship_mode, e.inv_date ship_date, t.pono, t.pl_no, trunc(t.pl_date) PL_DATE, m.style, nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) CMT_RATE, e.inv_no, e.inv_no_m, PL.TOTAL_QTY PCS , PL.TOTAL_QTY*nvl(get_cmt_rate(t.ccode, s.plan_no, g.garment_id), 0) AMOUNT, get_cmt_contract_no(t.ccode, s.plan_no, g.garment_id)contract_no , g.garment_id, t.po_close from wpl_mst t, wpl_dtl_aeopo pl, tblplanorder s, kcl_po_main m, expinv_mst e, dye.cdtl c, expinv_dtl_pl ed, tblplanpics g where t.pack_type = 'WP' and s.order_no = pl.pono and e.inv_no = ed.inv_no and ed.pl_no = t.pl_no and m.pono = s.order_no AND E.CANCEL_STATUS='N' -- and t.unit_12 LIKE NVL(:unit_12, '%') --and c.c_code = e.ccode and e.approved=1 and t.ccode=c.c_code --and s.plan_no LIKE NVL( :planno, '%') and pl.pl_no=t.pl_no and g.plan_no=s.plan_no --and t.pl_no not in (select r.pl_no from expsal_inv r) -- and trunc(e.inv_date) between nvl(:FDATE , to_date(sysdate-10000, 'DD-MM-RRRR')) AND nvl(:TDATE , to_date(sysdate, 'DD-MM-RRRR')) --and t.ccode=decode(:P_CCODE, 4, 15, NULL, T.CCODE, :P_CCODE) union all select m.ccode, c.c_name, m.plan_no, 'LOCAL' ship_mode, m.cdate ship_date, ' ' pono, ' ' pl_no, m.cdate PL_DATE, ' ' style, nvl(get_cmt_rate(m.ccode, m.plan_no, m.gmt_id), 0) CMT_RATE, 0 inv_no, ' ' inv_no_m, m.plan_qty PCS , m.plan_qty*nvl(get_cmt_rate(m.ccode, m.plan_no, m.gmt_id), 0) AMOUNT, get_cmt_contract_no(m.ccode, m.plan_no, m.gmt_id)contract_no , m.gmt_id garment_id, ' 'po_close from tblcontractmast m, dye.cdtl c where m.ccode=c.c_code and m.remarks='LOCALCMT' and m.sam_pcs is not null --and t.pl_no not in (select r.pl_no from expsal_inv r) -- and trunc(m.cdate) between nvl(:FDATE , to_date(sysdate-10000, 'DD-MM-RRRR')) AND nvl(:TDATE , to_d ate(sysdate, 'DD-MM-RRRR')) -- and m.ccode=decode(:P_CCODE, 4, 15, NULL, m.CCODE, :P_CCODE)
5p06akzdb4y5sselect log, oldest, oldest_pk, oldest_oid, oldest_new, youngest+1/86400, flag, yscn, oldest_seq, oscn, oscn_pk, oscn_oid, oscn_new, oscn_seq from sys.mlog$ where mowner = :1 and master = :2
5pjx5pj5xsmn7SELECT SYSDATE FROM SYS.DUAL
5z5jy8x016mc5 select distinct plan_no, ccode, u.fabric_code, f.fabric_type, u.des, u.color, sum(stock) stock_pcs, sum(total_pcs_wght) wt_kg_Pcs_fab, sum(fab_stock) stock_fab_wt, round(NVL(FINISH_FABRIC_CUT_VALUE_NEW12(9, Plan_no, u.fabric_code, u.color, :P_CCODE, :EDATE, u.des), 0), 0) fab_Valuess, netw_plan, RATE_PKG, round((sum(total_pcs_wght)) * production.GET_FAB_VAL(plan_no, 'KG'), 0) /* GET_PLAN_PKG_FF_RATE(plan_no)*/ PCS_Value from tblyarnfabrictype f, ( select a.plan_no, a.ccode, 'NA' fabric_code, 'N/A' des, 'N/A' color, nvl(sum(b.bdl_qty), 0) -cut_resize_qty(a.plan_no, a.ccode, :EDATE) - (nvl(z.issu, 0) - nvl(INDUCTION_RET_QTY(a.plan_no, :EDATE, a.ccode), 0))- cut_dead_plan_pcs(a.plan_no, a.ccode, :EDATE, :EDATE) stock, round((nvl(sum(b.bdl_qty), 0) - (nvl(z.issu, 0) - nvl(INDUCTION_RET_QTY(a.plan_no, :EDATE, a.ccode), 0))- nvl(cut_dead_plan_pcs(a.plan_no, a.ccode, :EDATE, :EDATE), 0)) * (production.get_plan_nw(a.plan_no) / 12), 2) total_pcs_wght, 0 Fab_ stock, production.get_plan_nw(plan_no) netw_plan, production.GET_FAB_VAL(plan_no, 'KG') RATE_PKG from cut_jbcard_m a, cut_jbcard_ddd b, (select a.planno, a.ccode, nvl(sum(b.qty), 0) issu from stit_rec_issue_m a, stit_rec_issue_d b where b.doc_id = a.doc_id and a.document_type = 'STR' and a.ccode = :P_CCODE -- and a.planno = '3870' and trunc(a.doc_date) <= :EDATE and trunc(a.doc_date) > '01-JAN-2012' group by a.planno, a.ccode) z where b.doc_id = a.doc_id and a.ccode = :P_CCODE --and a.plan_no = '3870' and trunc(b.timestmp) <= :EDATE and trunc(b.timestmp) > '01-JAN-2012' and a.plan_no = z.planno(+) and a.ccode = z.ccode(+) group by a.plan_no, a.ccode, z.issu having nvl(sum(b.bdl_qty), 0)-cut_resize_qty(a.plan_no, a.ccode, :EDATE) - (nvl(z.issu, 0) - nvl(INDUCTION_RET_QTY(a.plan_no, :EDATE, a.ccode), 0))-cut_dead_plan_pcs(a.plan_no, a.ccode, :EDATE, :EDATE) > 0 --order by plan_no desc union all ---- fabric Stock select distinct t.plan_no, t.ccode, t.fabr ic_code, t.des, t.color, /*sum(t.nw_in) Recv_fab, nvl(z.used_fab, 0) used_fab, y.Ret_fab, */ 0 stock, 0 total_pcs_wght, (sum(t.nw_in) - nvl(y.Ret_fab, 0) - nvl(z.used_fab, 0)) Fab_stock, 0 netw_plan, 0 RATE_PKG from cut_fabric_recv t, ( select t.plan_no, to_number(t.ccode) ccode, t.fabric_code, t.descrption, t.color, 0 Recv_fab, nvl(sum(t.used_fab), 0) used_fab, 0 ret_fab from cut_fabric_used_new t where t.DATED <= :EDATE -- and t.plan_no = '3870' and t.DATED > '01-JAN-2012' and t.ccode = :P_CCODE group by t.plan_no, t.ccode, t.fabric_code, t.descrption, t.color) z, (select t.plan_no, t.ccode, t.fabric_code, t.des descrption, t.color, 0 Recv_fab, 0 Used_fab, sum(t.gw_out) Ret_fab from cut_fabric_recv t where t.DATED <= :EDATE and t.DATED > '01-JAN-2012' -- and t.plan_no = '3870' and t.ccode = :P_CCODE group by t.plan_no, t.ccode, t.fabric_code, t.des, t.color) y where t.DATED <= :EDATE --and t.plan_no = '3870' and t.DATED > '01-JAN -2012' and t.ccode = :P_CCODE and t.plan_no = z.plan_no(+) and t.ccode = z.ccode(+) and t.fabric_code = z.fabric_code(+) and t.des = z.descrption(+) and t.color = z.color(+) and t.plan_no = y.plan_no(+) and t.ccode = y.ccode(+) and t.fabric_code = y.fabric_code(+) and t.des = y.descrption(+) and t.color = y.color(+) group by t.plan_no, t.ccode, t.fabric_code, t.des, t.color, z.used_fab, y.ret_fab having(sum(t.nw_in) - nvl(y.Ret_fab, 0) - nvl(z.used_fab, 0)) > 0 ) u where plan_no not in ( select t.plan_no from cut_plan_close_stk t ) and f.fabric_code (+) = u.fabric_code and plan_no = nvl ( : p_plan_no , plan_no ) group by plan_no , u.ccode , u.fabric_code , u.des , u.color , f.fabric_type , netw_plan , RATE_PKG ORDER BY 1 ASC, 8 ASC, 7 ASC, 12 ASC, 13 ASC, 11 ASC , plan_no
620nmfq8upvsbINSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PROCESSING"."MV_GSTK" SELECT DISTINCT A.PLANNO , ENTRYTYPE, NARRATION, B.COLOR, CORPORATE_SUP_NO , A.REC_DATE FROM ( /* QUERY FOR RND*/ SELECT DISTINCT A.PLAN_NO PLANNO, DECODE(A.ENTRY_TYPE, 'DHR', 'GLOT', 'DIR', 'RLOT', 'DFR', 'FLOT') ENTRYTYPE, E.NARRATION, NULL PLAN_NO, CORPORATE_SUP_NO , A.REC_DATE FROM PROCESSING.DYE_SR_DTL B, PROCESSING.DYE_SR_MST A, ENTRYTYPE E WHERE A.ENTRY_NO = B.ENTRY_NO AND A.ENTRY_TYPE IN ('DHR', 'DIR', 'DFR') AND E.STOCKTYPE='DYE' AND A.DEPT_CODE=3502 AND E.ENTRYTYPE=DECODE(A.ENTRY_TYPE, 'DHR', 'GLOT', 'DIR', 'RLOT', 'DFR', 'FLOT') ) A , ( select distinct sup_rec_no, color from rnd_sr_dtl ) b, ( select plan_no from PROCESSING.GSTK WHERE SUBSTR(PLAN_NO, 1, 1)='S' ) S where A.CORPORATE_SUP_NO = b.sup_rec_no AND S.PLAN_NO=A.PLANNO
6ch3ddxmt1kkx SELECT DECODE ( SIGN ( SUBSTR ( A . F_COL , 2 , 2 ) - SUBSTR ( B . F_COL , 2 , 2 ) ) , - 1 , NVL ( B . F , A . F ) , NVL ( A . F , B . F ) ) F , DECODE ( SIGN ( SUBSTR ( A . T_COL , 2 , 2 ) - SUBSTR ( B . T_COL , 2 , 2 ) ) , - 1 , NVL ( A . T , B . T ) , NVL ( B . T , A . T ) ) T , DECODE ( A . CURRENCY , 'PKR' , '?' , 'USD' , '$' , 'GBP' , '£' , 'EURO' , '¿' , 'HUF' , 'Ft' , 'TLY' , 'TL' , 'PLN' , 'z?' , 'CZK' , 'K?' , A . CURRENCY ) C_CUR , DECODE ( B . CURRENCY , 'PKR' , '?' , 'USD' , '$' , 'GBP' , '£' , 'EURO' , '¿' , 'HUF' , 'Ft' , 'TLY' , 'TL' , 'PLN' , 'z?' , 'CZK' , 'K?' , A . CURRENCY ) R_CUR , A . AIRPRICE , A . COST - NVL ( A . AIRPRICE , 0 ) COST , B . RETAIL , A . ORDERID , A . HITID , SUBSTR ( A . TRADETERM , 1 , 1 ) C_TR , SUBSTR ( B . TRADETERM , 1 , 1 ) R_TR , DECODE ( A . INT , 1 , 'INT' , 'MAIN' ) P_INT FROM ( SELECT INT , F , T , AIRPRICE , P COST , CURRENCY , ORDERID , HITID , TRADETERM , F_COL , T_COL FROM UKPRICE_V V WHERE INV = 1 ) A , ( SELECT INT , F , T , AIRPRICE , P RETAIL , CURRENCY , ORDERID , HITID , TRADETERM , F_COL , T_COL FROM UKPRICE_V WHERE ENTRYTYPE = 'RETAIL' ) B WHERE ( A.ORDERID = B.ORDERID (+) AND NVL ( A.HITID , 0 ) = NVL ( B.HITID (+) , 0 ) AND NVL ( A.TRADETERM , 0 ) = NVL ( B.TRADETERM (+) , 0 ) AND ( A.F_COL BETWEEN NVL ( B.F_COL , A.F_COL ) AND NVL ( B.T_COL , A.F_COL ) OR B.F_COL BETWEEN NVL ( A.F_COL , B.F_COL ) AND NVL ( A.T_COL , B.F_COL ) ) AND A.ORDERID IN ( SELECT ORDERID FROM UKORDER WHERE ACC_ID IN ( 301 , 300 ) AND PHASE_ID IN ( 118 ) ) AND A.ORDERID IN ( 18916 , 19006 , 18920 , 18917 , 19255 , 19007 , 18918 , 19256 , 18921 , 18919 , 19257 , 19008 , 19301 , 19302 , 19303 , 18671 , 18977 , 18976 , 18771 , 19304 , 18609 , 18618 , 18616 , 19264 , 19263 , 19022 , 19021 , 19020 , 19019 , 19266 , 19018 , 18614 , 18610 , 18613 , 18621 , 18620 , 18619 , 19272 , 19017 , 19270 , 19015 , 19269 , 19014 , 19268 , 19013 , 19267 , 19012 , 19016 , 18612 , 18617 , 19189 , 19243 , 19191 , 19265 , 19011 , 18615 , 18611 , 18653 , 19300 , 19299 , 19298 , 19297 , 18915 , 18975 , 18973 , 18974 , 18669 , 18768 , 19190 , 19196 , 19262 , 19261 , 19034 , 19033 , 19032 , 19031 , 19027 , 19030 , 19028 , 19026 , 19025 , 19024 , 19192 , 19023 , 18601 , 18655 , 19029 , 18600 , 18599 , 18597 , 18598 , 18603 , 18595 , 18594 , 18602 , 18593 , 18608 , 18518 , 18517 , 18596 , 19254 , 19253 , 19252 , 18853 , 19004 , 19003 , 18852 , 18851 , 18850 , 19002 , 19005 , 18849 , 18847 , 18856 , 18854 ) ) AND ( :ORDERID = A.ORDERID) ORDER BY 12 DESC , A.F_COL , B.F_COL
6nq3t1uk8bkry SELECT IGPNO, CONTRACT_NO, VEND_CODE, DTL_DESC, PLANNO, IGP_REM, VEHNO, DRIVER FROM ( SELECT IGPNO, processing.get_lot_party(PLANNO, LOTNO, 'CONTRACT') CONTRACT_NO, processing.get_lot_party(PLANNO, LOTNO, 'VEND_CODE') VEND_CODE, processing.get_lot_party(PLANNO, LOTNO, 'PARTY') DTL_DESC, 3501 DEPT_CODE, PLANNO, IGP_REM, VEHNO, DRIVER FROM PROCESSING.PROD_MST D WHERE STATUS='A' AND IGPNO IS NOT NULL AND ENTRY_TYPE='DIS' AND NOT EXISTS (SELECT 1 FROM FAB_SR_MAST WHERE NVL(IGP_OGP_NO, 0)=D.IGPNO ) AND D.FIN_STORE=DECODE(:1, 'FAB_USMAN', 1, 'FAB_TARIQ', 2, 'FAB_ZAIN', 5, 'FAB_ALI', 15, 'FAB_MALI', 20, 'FAB_SAFDAL', 21, 'FAB_AHSAN', 14, '') union all SELECT D.DOC_NO, processing.get_lot_party(PLANNO, LOTNO, 'CONTRACT') CONTRACT_NO, processing.get_lot_party(PLANNO, LOTNO, 'VEND_CODE') VEND_CODE, processing.get_lot_party(PLANNO, LOTNO, 'PARTY') DTL_DESC, 3501 DEPT_CODE, PLANNO, '' IGP_REM, '' VEHNO, '' DRIVER FROM PROCESSING.PROD_MST D WHERE STATUS='A' AND ENTRY_TYPE='DI S' AND NOT EXISTS (SELECT 1 FROM FAB_SR_MAST WHERE NVL(IGP_OGP_NO, 0)=D.DOC_NO ) /*AND OGPNO IS NULL */ AND (PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:2, 'FAB_ALI5', 23, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:3, 'FAB_ALI5', 25, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:4, 'FAB_NADEEM5', 25, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:5, 'FAB_NADEEM5', 23, '') OR PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:6, 'FAB_K5A', 25, '')) AND D.DOC_DATE>='22-APR-2013' UNION ALL SELECT D.DOC_NO, processing.get_lot_party(PLANNO, LOTNO, 'CONTRACT') CONTRACT_NO, processing.get_lot_party(PLANNO, LOTNO, 'VEND_CODE') VEND_CODE, processing.get_lot_party(PLANNO, LOTNO, 'PARTY') DTL_DESC, 3501 DEPT_CODE, PLANNO, '' IGP_REM, '' VEHNO, '' DRIVER FROM PROCESSING.PROD_MST D WHERE STATUS='A' AND ENTRY_TYPE='DIS' AND NOT EXISTS (SELECT 1 FROM FAB_SR_MAST WHERE NVL(IGP_OGP_NO, 0)=D.DOC_NO ) /*AND OGPNO IS NULL */ AND (PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:7, 'FAB_NAVEED', 10, '' ) or PRODUCTION.GET_PLAN_CCODE(PLANNO)=DECODE(:8, 'FAB_NAVEED', 22, '') ) ) ORDER BY IGPNO DESC
73mzjsxgt8kdbSELECT NVL(SUM(H.QTY), 0) QTY FROM TBLPLANORDER O, KCL_PO_HITS H WHERE O.ORDER_NO=H.PONO AND O.PLAN_NO=:B2 AND H.GARID=:B1
751yt8f5vvzssSELECT NVL(SUM(M.STITCHED_QTY), 0) FROM OPR_WAGES_EMP_MASTER M, CUT_SUPLY_BUNDL_M MI, CUT_SUPLY_BUNDL DI WHERE MI.DOC_ID = DI.DOC_ID AND M.CUT_BUNDLE_ID = DI.SR# AND MI.ENTRY_TYPE = 'IITS' AND M.UNIT_NUM = :b1 AND MI.FLOW_ID = :b2 AND M.CCODE = :b3 AND M.DATED = :b4 GROUP BY M.CCODE, M.UNIT_NUM, MI.FLOW_ID, TRUNC(M.DATED)
7cc7frahtmgnx SELECT DECODE ( SIGN ( SUBSTR ( A . F_COL , 2 , 2 ) - SUBSTR ( B . F_COL , 2 , 2 ) ) , - 1 , NVL ( B . F , A . F ) , NVL ( A . F , B . F ) ) F , DECODE ( SIGN ( SUBSTR ( A . T_COL , 2 , 2 ) - SUBSTR ( B . T_COL , 2 , 2 ) ) , - 1 , NVL ( A . T , B . T ) , NVL ( B . T , A . T ) ) T , DECODE ( A . CURRENCY , 'PKR' , '?' , 'USD' , '$' , 'GBP' , '£' , 'EURO' , '¿' , 'HUF' , 'Ft' , 'TLY' , 'TL' , 'PLN' , 'z?' , 'CZK' , 'K?' , A . CURRENCY ) C_CUR , DECODE ( B . CURRENCY , 'PKR' , '?' , 'USD' , '$' , 'GBP' , '£' , 'EURO' , '¿' , 'HUF' , 'Ft' , 'TLY' , 'TL' , 'PLN' , 'z?' , 'CZK' , 'K?' , A . CURRENCY ) R_CUR , A . AIRPRICE , A . COST - NVL ( A . AIRPRICE , 0 ) COST , B . RETAIL , A . ORDERID , A . HITID , SUBSTR ( A . TRADETERM , 1 , 1 ) C_TR , SUBSTR ( B . TRADETERM , 1 , 1 ) R_TR , DECODE ( A . INT , 1 , 'INT' , 'MAIN' ) P_INT FROM ( SELECT INT , F , T , AIRPRICE , P COST , CURRENCY , ORDERID , HITID , TRADETERM , F_COL , T_COL FROM UKPRICE_V V WHERE INV = 1 ) A , ( SELECT INT , F , T , AIRPRICE , P RETAIL , CURRENCY , ORDERID , HITID , TRADETERM , F_COL , T_COL FROM UKPRICE_V WHERE ENTRYTYPE = 'RETAIL' ) B WHERE ( A.ORDERID = B.ORDERID (+) AND NVL ( A.HITID , 0 ) = NVL ( B.HITID (+) , 0 ) AND NVL ( A.TRADETERM , 0 ) = NVL ( B.TRADETERM (+) , 0 ) AND ( A.F_COL BETWEEN NVL ( B.F_COL , A.F_COL ) AND NVL ( B.T_COL , A.F_COL ) OR B.F_COL BETWEEN NVL ( A.F_COL , B.F_COL ) AND NVL ( A.T_COL , B.F_COL ) ) AND A.ORDERID IN ( SELECT ORDERID FROM UKORDER WHERE ACC_ID IN ( 114 , 11 ) AND PHASE_ID IN ( 112 ) ) AND A.ORDERID IN ( 18916 , 19006 , 18920 , 18530 , 18917 , 18433 , 19255 , 18434 , 19007 , 18918 , 19256 , 18921 , 18919 , 19257 , 19008 , 18654 , 18435 , 19301 , 19302 , 19303 , 18671 , 18977 , 18976 , 18488 , 18487 , 18771 , 18484 , 18483 , 19304 , 18485 , 18609 , 18618 , 18616 , 18084 , 19264 , 19263 , 19022 , 19021 , 19020 , 19019 , 1 9266 , 19018 , 18614 , 18610 , 18613 , 18621 , 18620 , 18619 , 19272 , 19017 , 19270 , 19015 , 19269 , 19014 , 19268 , 19013 , 19267 , 19012 , 19016 , 18612 , 18167 , 18617 , 18083 , 18081 , 19189 , 19243 , 19191 , 19265 , 19011 , 18615 , 18611 , 18653 , 18088 , 18091 , 18087 , 19300 , 19299 , 19298 , 19297 , 18915 , 18975 , 18973 , 18974 , 18669 , 18768 , 18482 , 18481 , 18479 , 18480 , 18478 , 19190 , 19196 , 19262 , 19261 , 19034 , 19033 , 19032 , 19031 , 19027 , 19030 , 19306 , 19028 , 19026 , 19025 , 19024 , 19192 , 19023 , 18601 , 18655 , 19029 , 18600 , 18599 , 18597 , 18598 , 18603 , 18595 , 18594 , 18602 , 18593 , 18608 , 18085 , 18089 , 18090 , 18086 , 18168 , 18082 , 18080 , 18518 , 18517 , 18596 , 19254 , 19253 , 19252 , 18853 , 19004 , 19003 , 18852 , 18851 , 18529 , 18850 , 19002 , 19005 , 18849 , 18847 , 18422 , 18493 , 18856 , 18591 , 18854 , 18590 , 18420 , 18 421 , 18146 ) ) AND ( :ORDERID = A.ORDERID) ORDER BY 12 DESC , A.F_COL , B.F_COL
7grsf923r1m4gselect distinct Z.ACT_SIZE S, Z.COL SIZ, ORD from planno_size_qty_view Z where plan_no = :1 and z.req_qty>0 ORDER BY ORD
869nxpw7xhbyqSELECT DISTINCT DOC_ID FROM WAREHOUSE_REC WHERE TRAN_REF = :b1 AND DOC_ID IS NOT NULL UNION ALL SELECT DISTINCT DOCNO FROM STIT_REC_ISSUE_M WHERE DOC_ID = :b1 AND DOCNO IS NOT NULL UNION ALL SELECT DISTINCT DOC_ID FROM WAREHOUSE_REC_SUB WHERE TRAN_REF = :b1 AND DOC_ID IS NOT NULL
8k4xz9kr1brktSELECT NVL(MAX(OPR_DTL_ID), 0) + 1 FROM OPR_WAGES_EMP_DTL
8mq98wyhh24ruINSERT INTO cut_suply_bundl_m(ENTRY_TYPE, PLANNO, ORDER#, UNIT#, CCODE, STATUS, DOC_ID, timestamp_id, USER_ID, TERMINAL_ID, ISSUE#, RET_NORET, DOC_SR, P_CCODE, garment_id, FLOW_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
8r6x06b59nuyt /* MV_REFRESH (INS) */INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."WAGES_SHEET_MV"("PLANNO", "OPRATION_ID", "DATED", "CCODE", "FLOW_ID", "UNIT_NUM", "EMPCODE", "EARN_AMT") SELECT "M"."PLANNO", "D"."OPRATION_ID", TRUNC("M"."DATED"), "M"."CCODE", "SMT"."FLOW_ID", "M"."UNIT_NUM", "D"."EMP_CODE", SUM(ROUND("M"."STITCHED_QTY"/12, 2)) FROM "OPR_WAGES_EMP_MASTER" "M", "OPR_WAGES_EMP_DTL" "D", "STIT_REC_ISSUE_M" "SMT", "STIT_REC_ISSUE_D" "SDT" WHERE "M"."OPR_MAIN_ID"="D"."OPR_MAIN_ID" AND "D"."EMP_CODE" IS NOT NULL AND "SMT"."DOC_ID"="SDT"."DOC_ID" AN D "SMT"."DOCUMENT_TYPE"='STR' AND "SDT"."SR#"="M"."CUT_BUNDLE_ID" AND TRUNC("M"."DATED")>'01-JUL-2013' GROUP BY "D"."EMP_CODE", "M"."UNIT_NUM", "SMT"."FLOW_ID", TRUNC("M"."DATED"), "M"."CCODE", "M"."PLANNO", "D"."OPRATION_ID"
8v883pux05qk6INSERT INTO OPR_WAGES_EMP_MASTER(OPR_MAIN_ID, PLANNO, DATED, CARD_NUM, STITCHED_QTY, CUT_BUNDLE_ID, CCODE, CARD_QTY, unit_NUM, GARMENT_ID, AUTHORIZED_EMP_CODE, PAID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12)
932827s2cyx97DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin PRODUCTION.ACTIVITY_TABLE_DATA; end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
95hp4vzj95d6b/* MV_REFRESH (DEL) */ delete from "PRODUCTION"."WAGES_SHEET_MV"
9pc5hdmqdgx9jUPDATE tblhrmemployee SET EMPCODE=:1, EMPNAME=:2, FNAME=:3, CCODE=:4, NIC=:5, OLDNIC=:6, EXM=:7, LATE_EXM=:8, GM_ATT=:9, DOB=:10, DEPTCODE=:11, DESIGCODE=:12, HOMEADDRESS=:13, CITY=:14, PERMANENTADDRESS=:15, REFRENCE=:16, CELLNO=:17, MOB_CARD_WEFDATE=:18, PERSONALEMAIL=:19, STATUS=:20, EMPTYPE=:21, PHONE=:22, NTNNO=:23, PROBOTIONPERIOD=:24, ENDPRODATE=:25, REASON=:26, LEAVINGDATE=:27, BGROUP=:28, RPLC_CODE=:29, RELIGION=:30, GENDER=:31, SSNO=:32, EOBINO=:33, OTALLOW=:34, RESTDAY=:35, SHIFT=:36, EMPCODE_OLD=:37, TEMPBLOCK=:38, NIGHTSHIFT=:39, HANDITYPE=:40, HANDICAP=:41, IM_BOSS=:42, INDEXDIS=:43, TOTALSALARY=:44, FORNIGHT=:45, SALMODE=:46, BANKID=:47, BRANCHID=:48, ACCOUNTNO=:49, MODIFYDATE=:50, MODIFYBY=:51, TEMPCODE=:52, MOB_CARD=:53, FUEL=:54, GUN_ALLOUNCE=:55, VEHICLE_MAIN=:56, CNIC_EXPIRY_DATE=:57, JOINIGDATE=:58, MOTHER_NAME=:59 WHERE ROWID=:60
ab21w6xh2m3r2DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PROCESSING.mv_gstk'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
axqbs2kdrnra7INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "PRODUCTION"."MV_STITCHING" select distinct trunc(t.dated) dated, TO_CHAR(t.DATED, 'MON-RRRR') MTH, TO_CHAR(t.DATED, 'RRRR') YR, to_number(TO_CHAR(t.DATED, 'MM'))mt, C.CUS_NAME, P.PHASE_DESC, V.c_Name, t.planno, dept_code_validation(t.unit_num) unit, g.GARMANT_DESCRIPTION PRODUCT, nvl(GET_SAM(t.planno, t.garment_id), 0) SAM, sum(t.stitched_qty) Sth_qty from opr_wages_emp_master t, tblplanorder o, kcl_po_main m, GARMENT_TYPE g, CUSTOMER C, PHASE P, cdtl v where o.plan_no=t.planno and m.pono=o.order_no and t.garment_id=g.garment_id and c.cus_id=m.cus_id and p.phase_id=m.phase_id and v.c_code=t.ccode group by TO_CHAR(t.DATED, 'MON-RRRR'), TO_CHAR(t.DATED, 'RRRR') , to_number(TO_CHAR(t.DATED, 'MM')), C.CUS_NAME, P.PHASE_DESC, v.c_name, g.GARMANT_DESCRIPTION , t.planno, t.unit_num, t.garment_id, trunc(t.dated)
c6rkc2anypq67SELECT SUM(NVL(QTY_IN, 0)-NVL(QTY_OUT, 0)) FROM ST_MST A, ST_DTL B WHERE A.ENTRY_NO=B.ENTRY_NO AND TRUNC(A.DATED) BETWEEN '13-DEC-12' AND :B3 AND B.PO_NO=:B2 AND B.ITEM_CODE=:B1 AND A.ENTRY_TYPE IN ('RST', 'IFD')
c9tu6v6ynpzgs SELECT TO_NUMBER(O.PLAN_NO) PLAN_NO, A.COL, A.SIZ, Z.ORD, SUM(Z.S1) PO_QTY, SUM(Z.S1) + ROUND(SUM(Z.S1) * MAX(O.WASTE) / 100, 0) PLAN_QTY, NVL(CT.CUT_QTY, 0) CUT_QTY, NVL(IND.IND_QTY, 0) IND_QTY, NVL(CT.CUT_QTY, 0) - NVL(IND.IND_QTY, 0) REJ_AUDT, NVL(ST.ST_QTY, 0) ST_QTY, NVL(MIS.MI_QTY, 0) MIS_QTY, NVL(ST.ST_QTY, 0)-NVL(WH.WH_QTY, 0)BAL_UNIT, NVL(WH.WH_QTY, 0) WH_QTY, NVL(TR_WH.TR_QTY, 0) TR_QTY, NVL(SH.SH_QTY, 0) SH_QTY, NVL((NVL(WH.WH_QTY, 0)+NVL(TR_WH.TR_QTY, 0))-SH.SH_QTY, 0) BAL_WH, S.CUT_STATUS, S.IND_STATUS, S.STIT_STATUS, S.PLAN_STATUS FROM KCL_PO_MAIN M, ACC_SIZE_VIEW A, TBLPLANORDER O, PLAN_STATUS S, ( SELECT PONO, GARID, COL, NVL(SUM(SIZ), 0) S1, RN ORD FROM ( SELECT T.PONO, T.GARID, DECODE(RN, 1, 'S1', 2, 'S2', 3, 'S3', 4, 'S4', 5, 'S5', 6, 'S6', 7, 'S7', 8, 'S8', 9, 'S9', 10, 'S10', 11, 'S11', 12, 'S12', 13, 'S13', 14, 'S14', 15, 'S15', 16, 'S16', 17, 'S17', 18, 'S18', 19, 'S19', 20, 'S20' ) COL, DECODE(RN, 1, S1, 2, S2, 3, S3, 4, S4, 5, S5, 6, S6, 7, S7, 8, S8, 9, S9, 10, S10, 11, S11, 12, S12, 13, S13, 14, S14, 15, S15, 16, S16, 17, S17, 18, S18, 19, S19, 20, S20 ) SIZ, RN FROM KCL_PO_HITS T, TBLPLANORDER O, (SELECT LEVEL RN FROM DUAL CONNECT BY LEVEL <= 20) WHERE O.PLAN_NO=:B1 AND O.ORDER_NO=T.PONO ) GROUP BY PONO, GARID, COL, RN ) Z, (SELECT CD.COL_SIZE, CD.CUT_SIZE, NVL(SUM(CD.BDL_QTY), 0)- SUM( (SELECT NVL(SUM(DD.REP_QTY), 0) FROM CUT_JBCARD_M MM, CUT_JBCARD_DDD DD WHERE DD.DOC_ID=MM.DOC_ID AND MM.PLAN_NO=:B1 AND DD.PKEY_REF=CD.PKEY AND DD.CUT_SIZE IS NOT NULL )) CUT_QTY FROM CUT_JBCARD_M CM, CUT_JBCARD_DDD CD WHERE CD.DOC_ID=CM.DOC_ID AND CM.PLAN_NO=:B1 AND CD.CUT_SIZE IS NOT NULL GROUP BY CD.COL_SIZE, CD.CUT_SIZE )CT, ( SELECT SD.COL_SIZE, SD.G_SIZE, SUM(SD.QTY) IND_QTY FROM STIT_REC_ISSUE_D SD, STIT_REC_ISSUE_M MD WHERE MD.DOC_ID=SD.DOC_ID AND MD.DOCUMENT_TYPE='STR' AND SD.STATUS=0 AND MD.PLANNO=:B1 GROUP BY SD.COL_SIZE, SD.G_SIZE )IND, (SELECT BD.COL_SIZE, BD.G_SIZE, NVL(SUM(BD.STITCHED_QTY), 0) ST_QTY FR OM CUT_SUPLY_BUNDL BD, CUT_SUPLY_BUNDL_M MS WHERE MS.DOC_ID=BD.DOC_ID AND MS.ENTRY_TYPE='IITS' AND MS.PLANNO=:B1 GROUP BY BD.COL_SIZE, BD.G_SIZE ) ST, (SELECT COL, NVL(SUM(SIZ), 0) WH_QTY FROM ( SELECT DECODE(RN, 1, 'S1', 2, 'S2', 3, 'S3', 4, 'S4', 5, 'S5', 6, 'S6', 7, 'S7', 8, 'S8', 9, 'S9', 10, 'S10', 11, 'S11', 12, 'S12', 13, 'S13', 14, 'S14', 15, 'S15', 16, 'S16', 17, 'S17', 18, 'S18', 19, 'S19', 20, 'S20' ) COL, DECODE(RN, 1, S1, 2, S2, 3, S3, 4, S4, 5, S5, 6, S6, 7, S7, 8, S8, 9, S9, 10, S10, 11, S11, 12, S12, 13, S13, 14, S14, 15, S15, 16, S16, 17, S17, 18, S18, 19, S19, 20, S20 ) SIZ FROM WAREHOUSE_REC_D T, WAREHOUSE_REC O, (SELECT LEVEL RN FROM DUAL CONNECT BY LEVEL <= 20) WHERE O.PLANNO=:B1 AND O.DOC_ID=T.DOC_ID AND O.DOCUMENT_TYPE='WRS' UNION ALL SELECT DECODE(RN, 1, 'S1', 2, 'S2', 3, 'S3', 4, 'S4', 5, 'S5', 6, 'S6', 7, 'S7', 8, 'S8', 9, 'S9', 10, 'S10', 11, 'S11', 12, 'S12', 13, 'S13', 14, 'S14', 15, 'S15', 16, 'S16', 17, 'S17', 18, 'S18', 19, 'S19', 20, 'S2 0' ) COL, DECODE(RN, 1, -S1, 2, -S2, 3, -S3, 4, -S4, 5, -S5, 6, -S6, 7, -S7, 8, -S8, 9, -S9, 10, -S10, 11, -S11, 12, -S12, 13, -S13, 14, -S14, 15, -S15, 16, -S16, 17, -S17, 18, -S18, 19, -S19, 20, -S20 ) SIZ FROM WAREHOUSE_REC_D T, WAREHOUSE_REC O, (SELECT LEVEL RN FROM DUAL CONNECT BY LEVEL <= 20) WHERE O.PLANNO=:B1 AND O.DOC_ID=T.DOC_ID AND O.DOCUMENT_TYPE='WHS' ) GROUP BY COL )WH , (SELECT DECODE(RN, 1, 'S1', 2, 'S2', 3, 'S3', 4, 'S4', 5, 'S5', 6, 'S6', 7, 'S7', 8, 'S8', 9, 'S9', 10, 'S10', 11, 'S11', 12, 'S12', 13, 'S13', 14, 'S14', 15, 'S15', 16, 'S16', 17, 'S17', 18, 'S18', 19, 'S19', 20, 'S20' ) COL, DECODE(RN, 1, SUM(S1), 2, SUM(S2), 3, SUM(S3), 4, SUM(S4), 5, SUM(S5), 6, SUM(S6), 7, SUM(S7), 8, SUM(S8), 9, SUM(S9), 10, SUM(S10), 11, SUM(S11), 12 , SUM(S12), 13, SUM(S13), 14, SUM(S14), 15, SUM(S15), 16, SUM(S16), 17, SUM(S17), 18, SUM(S18), 19, SUM(S19), 20, SUM(S20) ) SH_QTY FROM (SELECT M.PL_NO, M.PONO, M.CCODE, NVL (SUM (D.S1 * (D.TCTN - D.FCTN + 1)), 0) S1, NVL (SUM (D.S2 * (D.TCTN - D.FCTN + 1)), 0) S2, NVL (SUM (D.S3 * (D.TCTN - D.FCTN + 1)), 0) S3, NVL (SUM (D.S4 * (D.TCTN - D.FCTN + 1)), 0) S4, NVL (SUM (D.S5 * (D.TCTN - D.FCTN + 1)), 0) S5, NVL (SUM (D.S6 * (D.TCTN - D.FCTN + 1)), 0) S6, NVL (SUM (D.S7 * (D.TCTN - D.FCTN + 1)), 0) S7, NVL (SUM (D.S8 * (D.TCTN - D.FCTN + 1)), 0) S8, NVL (SUM (D.S9 * (D.TCTN - D.FCTN + 1)), 0) S9, NVL (SUM (D.S10 * (D.TCTN - D.FCTN + 1)), 0) S10, NVL (SUM (D.S11 * (D.TCTN - D.FCTN + 1)), 0) S11, NVL (SUM (D.S12 * (D.TCTN - D.FCTN + 1)), 0) S12, NVL (SUM (D.S13 * (D.TCTN - D.FCTN + 1)), 0) S13, NVL (SUM (D.S14 * (D.TCTN - D.FCTN + 1)), 0) S14, NVL (SUM (D.S15 * (D.TCTN - D.FCTN + 1)), 0) S15, NVL (SUM (D.S16 * (D.TCTN - D.FCTN + 1)), 0) S16, NVL (SUM (D.S17 * (D.TCTN - D.FCTN + 1)), 0) S17, NVL (SUM (D.S18 * (D.TCTN - D.FCTN + 1)), 0) S18, NVL (SUM (D.S19 * (D.TCTN - D.FCTN + 1)), 0) S19, NVL (SUM (D.S20 * (D.TCTN - D.FCTN + 1)), 0) S20 FROM EXPIMP.WPL_MST M, E XPIMP.WPL_DTL D, PRODUCTION.TBLPLANORDER PS, EXPIMP.EXPINV_MST E, EXPIMP.EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PACK_TYPE = 'WP' AND M.PONO = PS.ORDER_NO AND P.INV_NO = E.INV_NO AND E.CANCEL_STATUS = 'N' AND M.PACK_TYPE = 'WP' AND E.APPROVED = 1 AND M.PL_NO=P.PL_NO AND PS.PLAN_NO =:B1 GROUP BY M.PL_NO, M.PONO, M.CCODE UNION ALL SELECT M.PL_NO, D.PONO, M.CCODE, NVL(SUM(D.SI), 0) S1, NVL(SUM(D.S2), 0) S2, NVL(SUM(D.S3), 0) S3, NVL(SUM(D.S4), 0) S4, NVL(SUM(D.S5), 0) S5, NVL(SUM(D.S6), 0) S6, NVL(SUM(D.S7), 0) S7, NVL(SUM(D.S8), 0) S8, NVL(SUM(D.S9), 0) S9, NVL(SUM(D.S10), 0) S10, NVL(SUM(D.S11), 0) S11, NVL(SUM(D.S12), 0) S12, NVL(SUM(D.S13), 0) S13, NVL(SUM(D.S14), 0) S14, NVL(SUM(D.S15), 0) S15, NVL(SUM(D.S16), 0) S16, NVL(SUM(D.S17), 0) S17, NVL(SUM(D.S18), 0) S18, NVL(SUM(D.S19), 0) S19, NVL(SUM(D.S20), 0) S20 FROM EXPIMP.WPL_MST M, WPL_DTL_AEOPO D, PRODUCTION.TBLPLANORDER PS, EXPIMP.EXPINV_MST E, EXPIMP.EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PACK_TYPE = 'WP' AND D.PONO = PS.ORDER_NO AND P.INV_NO = E.INV_NO AND E.CANCEL_STATUS = 'N' AND M.PACK_TYPE = 'WP' AND E.APPROVED = 1 AND PS.PLAN_NO = :B1 AND P.PL_NO=M.PL_NO GROUP BY M.PL_NO, D.PONO, M.CCODE UNION ALL SELECT M.PL_NO, M.PONO, M.CCODE, NVL(SUM(D.S1), 0) S1, NVL(SUM(D.S2), 0) S2, NVL(SUM(D.S3), 0) S3, NVL(SUM(D.S4), 0) S4, NVL(SUM(D.S5), 0) S5, NVL(SUM(D.S6), 0) S6, NVL(SUM(D.S7), 0) S7, NVL(SUM(D.S8), 0) S8, NVL(SUM(D.S9), 0) S9, NVL(SUM(D.S10), 0) S10, NVL(SUM(D.S11), 0) S11, NVL(SUM(D.S12), 0) S12, NVL(SUM(D.S13), 0) S13, NVL(SUM(D.S14), 0) S14, NVL(SUM(D.S15), 0) S15, NVL(SUM(D.S16), 0) S16, NVL(SUM(D.S17), 0) S17, NVL(SUM(D.S18), 0) S18, NVL(SUM(D.S19), 0) S19, NVL(SUM(D.S20), 0) S20 FROM EXPIMP.WPL_MST M, EXPIMP.WPL_DTL D, PRODUCTION.TBLPLANORDER PS, EXPIMP.EXPINV_MST E, EXPIMP.EXPINV_DTL_PL P WHERE M.PL_NO = D.PL_NO AND M.PACK_TYPE = 'WP' AND NVL(D.NET_WGT, 0) > 0 AND NVL(D.GROSS_WGT, 0) > 0 AND M.PONO = PS.ORDER_NO AND P.INV_NO = E.INV_NO AND E.CANCEL_STATUS = 'N' AND M.PACK_TYPE = 'WP' AND E.APPROVED = 1 AND PS.ORDER_NO = M.PONO AND P.PL_NO = M.PL_NO AND PS.PLAN_NO = :B1 GROUP BY M.PL_NO, M.PONO, M.CCODE ), (SELECT LEVEL RN FROM DUAL CONNECT BY LEVEL <= 20) GROUP BY RN )SH, (SELECT DECODE(RN, 1, 'S1', 2, 'S2', 3, 'S3', 4, 'S4', 5, 'S5', 6, 'S6', 7, 'S7', 8, 'S8', 9, 'S9', 10, 'S10', 11, 'S11', 12, 'S12', 13, 'S13', 14, 'S14', 15, 'S15', 16, 'S16', 17, 'S17', 18, 'S18', 19, 'S19', 20, 'S20' ) COL, DECODE(RN, 1, SUM(S1), 2, SUM(S2), 3, SUM(S3), 4, SUM(S4), 5, SUM(S5), 6, SUM(S6), 7, SUM(S7), 8, SUM(S8), 9, SUM(S9), 10, SUM(S10), 11, SUM(S11), 12 , SUM(S12), 13, SUM(S13), 14, SUM(S14), 15, SUM(S15), 16, SUM(S16), 17, SUM(S17), 18, SUM(S18), 19, SUM(S19), 20, SUM(S20) ) TR_QTY FROM ( SELECT NVL(T.S1, 0)S1, NVL(T.S2, 0)S2, NVL(T.S3, 0)S3, NVL(T.S4, 0)S4, NVL(T.S5, 0)S5 , NVL(T.S6, 0)S6, NVL(T.S7, 0)S7, NVL(T.S8, 0)S8, NVL(T.S9, 0)S9, NVL(T.S10, 0)S10 , NV L(T.S11, 0)S11, NVL(T.S12, 0)S12, NVL(T.S13, 0)S13, NVL(T.S14, 0)S14 , NVL(T.S15, 0)S15, NVL(T.S16, 0)S16, NVL(T.S17, 0)S17, NVL(T.S18, 0)S18, NVL(T.S19, 0)S19, NVL(T.S20, 0)S20 FROM WPL_DTL_NEW T WHERE T.TIN_PLANNO=:B1 UNION ALL SELECT -NVL(T.S1, 0)S1, -NVL(T.S2, 0)S2, -NVL(T.S3, 0)S3, -NVL(T.S4, 0)S4, -NVL(T.S5, 0)S5 , -NVL(T.S6, 0)S6, -NVL(T.S7, 0)S7, -NVL(T.S8, 0)S8, -NVL(T.S9, 0)S9, -NVL(T.S10, 0)S10 , -NVL(T.S11, 0)S11, -NVL(T.S12, 0)S12, -NVL(T.S13, 0)S13, -NVL(T.S14, 0)S14 , -NVL(T.S15, 0)S15, -NVL(T.S16, 0)S16, -NVL(T.S17, 0)S17, -NVL(T.S18, 0)S18, -NVL(T.S19, 0)S19, -NVL(T.S20, 0)S20 FROM WPL_DTL_NEW T WHERE T.TOUT_PLANNO=:B1 ), (SELECT LEVEL RN FROM DUAL CONNECT BY LEVEL <= 20) GROUP BY RN ) TR_WH , (SELECT T.G_SIZE SI, COUNT(T.G_SIZE) MI_QTY FROM MISSED_GMT_ID T WHERE T.PLAN_NO = :B1 GROUP BY T.G_SIZE )MIS WHERE A.ACC_ID=M.ACC_ID AND Z.PONO=M.PONO AND O.ORDER_NO=M.PONO AND O.ORDER_NO=Z.PONO AND O.PLAN_NO=:B1 AND Z.COL=A.COL AND A.COL=CT.COL_SIZE(+) AND A.COL=IND.COL_SIZ E(+) AND A.COL=ST.COL_SIZE(+) AND A.COL=WH.COL(+) AND A.COL=SH.COL(+) AND A.COL=TR_WH.COL(+) AND A.SIZ=MIS.SI(+) AND S.PLAN_NO=O.PLAN_NO AND A.SIZ IS NOT NULL GROUP BY O.PLAN_NO, A.COL, A.SIZ, Z.ORD, CT.CUT_QTY, IND.IND_QTY, ST.ST_QTY, WH.WH_QTY, SH.SH_QTY, TR_WH.TR_QTY, MIS.MI_QTY, S.CUT_STATUS, S.IND_STATUS, S.STIT_STATUS, S.PLAN_STATUS HAVING SUM(Z.S1) >0 ORDER BY Z.ORD
cd6srfubmwu53 SELECT U.COL , U.PLAN_NO , U.G_SZ , U.RQ_QT , U.CT_PCS , U.ID_QTY , U.ST_QTY , U.QTY PAK_QTY FROM ( SELECT T.PLAN_NO PLAN_NO , T.ACT_SIZE G_SZ , T.REQ_QTY RQ_QT , T.TO_CUT_PCS CT_PCS , Z.ID_QTY , Y.ST_QTY , W.QTY , T.COL FROM ACT_CUT_PCS_VIEW T , ( SELECT M.PLANNO , D.G_SIZE , SUM ( D.QTY ) ID_QTY FROM STIT_REC_ISSUE_M M , STIT_REC_ISSUE_D D WHERE D.DOC_ID = M.DOC_ID AND M.DOCUMENT_TYPE = 'STR' AND D.STATUS = 0 GROUP BY M.PLANNO , D.G_SIZE ) Z , ( SELECT V.PLAN_NO , V.CCODE , T.ACT_SIZE , V.S1 QTY FROM SHIP_SIZE_VIEW V , ACT_CUT_PCS_VIEW T WHERE T.PLAN_NO = V.PLAN_NO AND T.COL = V.S ) W , ( SELECT M.PLANNO , D.G_SIZE , SUM ( D.STITCHED_QTY ) ST_QTY FROM CUT_SUPLY_BUNDL_M M , CUT_SUPLY_BUNDL D WHERE D.DOC_ID = M.DOC_ID AND D.ENT_TYPE = 'IITS' AND D.STITCHED_QTY IS NOT NULL GROUP BY M.PLANNO , D.G_SIZE ) Y , TBLPLANSHEET PS WHERE T.REQ_QTY > 0 AND T.PLAN_NO = Z.PLANNO (+) AND T.ACT_SIZE = Z.G_SIZE (+) AND T.PLAN_NO = Y.PLANNO (+) AND T.ACT_SIZE = Y.G_SIZE (+) AND T.PLAN_NO = W.PLAN_NO (+) AND T.ACT_SIZE = W.ACT_SIZE (+) AND T.PLAN_NO = PS.PLAN_NO AND PS.C_CODE = 9 ) U WHERE ( :PLAN_NO = U.PLAN_NO) ORDER BY U.COL
cdy4c52fdcanvSELECT DISTINCT D.PO_NO, D.ITEM_CODE, SUBSTR(PRODUCTION.GET_YARN(D.ITEM_CODE), 1, 100)ITEM_DESC , PROCESSING.ST_YARN_STK(:P_TO, D.PO_NO, D.ITEM_CODE, :P_STK)STK FROM PROCESSING.ST_MST M, PROCESSING.ST_DTL D WHERE M.ENTRY_NO=D.ENTRY_NO AND TRUNC(M.DATED)<=:P_TO AND TO_NUMBER(SUBSTR(D.ENTRY_NO, 4, 2))=:P_CCODE AND D.ITEM_CODE=NVL(:P_ITEM, D.ITEM_CODE) AND PROCESSING.ST_YARN_STK(:P_TO, D.PO_NO, D.ITEM_CODE, :P_STK)<>0
ch0thvp9q6y1wSELECT DISTINCT T.PLAN_NO, T.PLAN_DATE, to_char(WM_CONCAT(DISTINCT ORDER_NO))PAKPO FROM TBLPLANSHEET T, tblplanorder o WHERE T.PLAN_DATE >='01-JAN-2011' and T.PLAN_NO=O.PLAN_NO GROUP BY T.PLAN_NO, T.PLAN_DATE /*AND UNIT=decode(:GLOBAL.COMPANY_CODE, 13, unit, :GLOBAL.COMPANY_CODE)*/ ORDER BY T.PLAN_DATE DESC
cjaa80k1hvpc1select 1 from sys.cdc_change_tables$ where source_schema_name = :1 and source_table_name = :2 and bitand(mvl_flag, 128)=128
cm5vu20fhtnq1獥汥捴 ⨫⁣潮湥捴形祟晩汴敲楮朠⨯⁰物癩汥来⌬汥癥氠晲潭⁳祳慵瑨␠捯湮散琠批⁧牡湴敥⌽灲楯爠灲楶楬敧攣⁡湤⁰物癩汥来⌾〠獴慲琠睩瑨⁧牡湴敥⌽㨱⁡湤⁰物癩汥来⌾
d119jxynhx8ba SELECT PONO, DTL_DESC, DEMANDNO, ITEMCODE, ITEM_DESC, PLANNO, SUM(QTY), SUM(REC), SUM(RET) FROM ( SELECT M.PONO, V.DTL_DESC, D.DEMANDNO, D.ITEMCODE, I.ITEM_DESC, D.PLANNO, SUM(D.POQTY) QTY, 0 REC, 0 RET FROM PO_MST M, PO_DTL D, ITEM I, DYE.DETAILACC V, DEM_MST DM WHERE D.PONO = M.PONO AND D.CCODE = M.CCODE AND D.DEMANDNO=DM.DEMANDNO AND D.ITEMCODE = I.ITEM_CODE AND M.VENDCODE = V.DTL_CODE AND M.CCODE = V.CCODE AND decode(Fack_company_plan_po(D.planno), 0, m.ccode, Fack_company_plan_po(D.planno)) =:P_CCODE AND M.APPROVED = 1 AND M.PODATE BETWEEN :P_FROM AND :P_TO AND M.VENDCODE = NVL(:P_VEND, M.VENDCODE) AND D.PLANNO = NVL(:P_PLANNO, D.PLANNO) AND NVL(M.PURCODE, 0) = NVL(:P_PURCHASE, NVL(M.PURCODE, 0)) AND D.ITEMCODE LIKE DECODE(:P_CAT, '', '%', :P_CAT) AND NVL(DM.UNIT, 0) =NVL(:P_UNIT, NVL(DM.UNIT, 0)) GROUP BY M.PONO, V.DTL_DESC, D.DEMANDNO, D.ITEMCODE, I.ITEM_DESC, PLANNO UNION ALL SELECT M.PONO, V.DTL_DESC, D.DEMANDNO, D.ITEM_CODE, I.ITEM_DESC, D.PLAN_NO, 0 QTY, NVL(SUM(D.IGPQTY) , 0) REC, 0 RET FROM IGP_MST M, IGP_DTL D, ITEM I, DYE.DETAILACC V, DEM_MST DM WHERE M.IGPNO = D.IGPNO AND M.CCODE = D.CCODE AND D.DEMANDNO=DM.DEMANDNO AND decode(Fack_company_plan_po(D.plan_no), 0, m.ccode, Fack_company_plan_po(D.plan_no)) =:P_CCODE AND D.ITEM_CODE=I.ITEM_CODE AND M.VEND_CODE=V.DTL_CODE AND M.CCODE=V.CCODE AND M.VEND_CODE = NVL(:P_VEND, M.VEND_CODE) AND D.PLAN_NO = NVL(:P_PLANNO, D.PLAN_NO) AND D.ITEM_CODE LIKE DECODE(:P_CAT, '', '%', :P_CAT) AND NVL(DM.UNIT, 0) =NVL(:P_UNIT, NVL(DM.UNIT, 0)) GROUP BY M.PONO, V.DTL_DESC, D.DEMANDNO, D.ITEM_CODE, I.ITEM_DESC, PLAN_NO UNION ALL SELECT D.PODEMNO, V.DTL_DESC, P.DEMANDNO, D.ITEMCODE, I.ITEM_DESC, D.PLANNO, 0 QTY, 0 REC, SUM(D.QTY) RET FROM STORE_MASTER M, STORE_DETAIL D, PO_DTL P, ITEM I, DYE.DETAILACC V, DEM_MST DM WHERE M.SRNO = D.SRNO AND decode(Fack_company_plan_po(D.planno), 0, m.ccode, Fack_company_plan_po(D.planno)) =:P_CCODE AND D.PODEMNO=P.PONO AND P.DEMANDNO=DM.DEMANDNO AND D.ITEMCODE=P.ITEMCODE AND D.PLANNO=P.PL ANNO AND D.ITEMCODE=I.ITEM_CODE AND M.VENDCODE=V.DTL_CODE AND M.CCODE=V.CCODE AND M.ENTRYTYPE='RR' AND M.VENDCODE = NVL(:P_VEND, M.VENDCODE) AND D.PLANNO = NVL(:P_PLANNO, D.PLANNO) AND D.ITEMCODE LIKE DECODE(:P_CAT, '', '%', :P_CAT) AND NVL(DM.UNIT, 0) =NVL(:P_UNIT, NVL(DM.UNIT, 0)) GROUP BY D.PODEMNO, V.DTL_DESC, P.DEMANDNO, D.ITEMCODE, I.ITEM_DESC, D.PLANNO ) GROUP BY PONO , DTL_DESC , DEMANDNO , ITEMCODE , ITEM_DESC , PLANNO HAVING SUM ( QTY ) - SUM ( REC ) + SUM ( RET ) > 0 ORDER BY 2 ASC, 1 ASC
fabnkbu3vk8rp 卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺ㄠ䅎䐠❆䑉✽㨲⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⤽㨳⁁乄‧䑙䔧㴺㐠䅎䐠❍䄧㴺㔠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䴧Ⱗ䄧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐠䥎⠳ⰷ⤠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁇䕔彆䥎䥓䡟剏啔⡃⹃䑋彉䐩⁆䥎䥓䡟剏啔䔬⁖⹄䥁ⱖ⹇啁䝅ⱖ⹇卍ⱖ⹆䥎彇卍ⱖ⹆䥎彗䥄ⱖ⹄奅彁噇彗䅓呅Ⱐ䌮䍄䭟䥄⁆剏䴠呂䱄奅䍏乔剁䍔䑔䰠䌠ⱖ彃啔剅儠嘬䍄䭟䙉义午归何吠䘠坈䕒䔠䌮䍏乔剁䍔彎伽㨶⁁乄‧䙄䤧㴺㜠䅎䐠䌮䍄䭟䥄㵖⹓剎传䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩㴺㠠䅎䐠❄奅✽㨹⁁乄‧䴧㴺㄰⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䵁䥎彁䍃✩㴧䴧⁁乄⁃⹃䑋彉䐽䘮䍄䭟䥄⁁乄⁆⹏剄㴨卅䱅䍔⁍䥎⡏剄⤠䙒位⁐剏䑕䍔䥏丮䍄䭟䙉义午归何吠堠坈䕒䔠堮䍄䭟䥄㵃⹃䑋彉䐠⤠䅎䐠䘮偒佃䕓卟䥄⁉丨㌬㜩⁕义低⁁䱌⁓䕌䕃吠䑉協䥎䍔⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䙁䉒䥃彃佄䔧⤠䙁䉒䥃彃佄䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䙁䉒䥃✩⁆䅂剉䍟呙偅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⤠偌䅎彃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❄䕓䍒䥐呉低 ✩⁄䕓䍒䥐呉低Ⱐ䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺ㄱ⁁乄‧䙄䤧㴺ㄲ⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⤽㨱㌠䅎䐠❄奅✽㨱㐠䅎䐠❁✽㨱㔠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤽❁✠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐠䥎⠳ⰷ⤠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁇䕔彆䥎䥓䡟剏啔⡃⹃䑋彉䐩⁆䥎䥓䡟剏啔䔬⁖⹄䥁ⱖ⹇啁䝅ⱖ⹇卍ⱖ⹆䥎彇卍ⱖ⹆䥎彗䥄ⱖ⹄奅彁噇彗䅓呅Ⱐ䌮䍄䭟䥄⁆剏䴠呂䱄奅䍏乔剁䍔䑔䰠䌠ⱖ彃啔剅儠嘬䍄䭟䙉义午归何吠䘠坈䕒䔠䌮䍏乔剁䍔彎伽㨱㘠䅎䐠❆䑉✽㨱㜠䅎䐠䌮䍄䭟䥄㵖⹓剎传䅎䐠❗䅓䠧㴺ㄸ⁁乄‧䵁✽㨱㤠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䴧Ⱗ䄧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐽㈠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺㈰⁁乄‧䙄䤧㴺㈱⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄‧坁午✽㨲㈠䅎䐠❍✽㨲㌠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䴧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉 丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐽㈠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺㈴⁁乄‧䙄䤧㴺㈵⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄‧坁午✽㨲㘠䅎䐠❁✽㨲㜠䅎䐠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❍䅉也䅃䌧⤠䥎⠧䄧⤠䅎䐠䌮䍄䭟䥄㵆⹃䑋彉䐠䅎䐠䘮佒䐽⡓䕌䕃吠䵉丨佒䐩⁆剏䴠偒佄啃呉低⹃䑋彆䥎䥓䡟剏啔⁘⁗䡅剅⁘⹃䑋彉䐽䌮䍄䭟䥄 ⁁乄⁆⹐剏䍅卓彉䐽㈠啎䥏丠䅌䰠卅䱅䍔⁄䥓呉乃吠灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䍟䍏䑅✩⁆䅂剉䍟䍏䑅Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❆䅂剉䌧⤠䙁䉒䥃彔奐䔬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䍏䱏刧⥃佌佒Ⱐ灲潤畣瑩潮⹇䕔彔䉌彃啔䑙䕟䭎䥔⡃⹃䑋彉䐬❃佌佒✩⁐䱁也䍏䱏刬⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䑅千剉偔䥏丧⤠䑅千剉偔䥏丬⁰牯摵捴楯渮䝅呟䙉义午归何吨䌮䍄䭟䥄⤠䙉义午归何呅Ⱐ嘮䑉䄬嘮䝕䅇䔬嘮䝓䴬嘮䙉也䝓䴬嘮䙉也坉䐬嘮䑙䕟䅖䝟坁協䔬⁃⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑⁖ⱃ䑋彆䥎䥓䡟剏啔⁆⁗䡅剅⁃⹃低呒䅃呟乏㴺㈸⁁乄‧䙄䤧㴺㈹⁁乄⁃⹃䑋彉䐽嘮卒乏⁁乄‧佔䡅刧㴺㌰⁁乄⁰牯摵捴楯渮䝅呟呂䱟䍕呄奅彋义吨䌮䍄䭟䥄Ⱗ䵁䥎彁䍃✩⁉丨❍✬❁✩⁁乄⁃⹃䑋彉䐽䘮䍄䭟䥄⁁乄⁆⹏剄㴨卅䱅䍔⁍䥎⡏剄⤠䙒位⁐剏䑕䍔䥏丮䍄䭟䙉义午归何吠堠坈䕒䔠堮䍄䭟䥄㵃⹃䑋彉䐠⤠䅎䐠䘮偒佃䕓卟䥄⁎佔⁉丨㌬㈩⁕义低⁁䱌⁓䕌䕃吠䑉協䥎䍔⁖⹆䅂剉䍟䍏䑅Ⱐ䝅呟䙁䉒䥃⡖⹆䅂剉䍟䍏䑅⤠䙁䉒䥃彔奐䔬 ⩄䕃佄䔨㩆䅂当剟䵁協⹅乔剙呙偅Ⱗ䙆䘧ⱃ⹓呋彃佌佒ⱖ⹃佌佒⤠䍏䱏刬⨯⁖⹃佌佒Ⱐ嘮䍏䱏删偌䅎彃佌佒Ⱐ嘮䑅千剉偔䥏丬⁇䕔彆䥎䥓䡟剏啔⡃⹃䑋彉䐩⁆䥎䥓䡟剏啔䔠ⱖ⹄䥁ⱖ⹇啁䝅ⱖ⹇卍ⱖ⹆䥎彇卍ⱖ⹆䥎彗䥄ⱖ⹄奅彁噇彗䅓呅ⱃ⹃䑋彉䐠䙒位⁔䉌䑙䕃低呒䅃呄呌⁃‬噟䍕呒䕑 ⁖⁗䡅剅⁃⹃低呒䅃呟乏㴺㌱⁁乄‧䉆䘧㴺㌲⁁乄⁃⹃低呟呙偅㵄䕃佄䔨㨳㌬❆䥒✬❄奅✬❆䙆✬❆䥎✩⁁乄⁃⹃䑋彉䐽嘮卒乏
fn6836hwdwhwhDECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(30) := :job_name; job_subname VARCHAR2(30) := :job_subname; job_owner VARCHAR2(30) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner varchar2(30) := :credown; credential_name varchar2(30) := :crednam; destination_owner varchar2(30) := :destown; destination_name varchar2(30) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN begin DBMS_SNAPSHOT.REFRESH( 'PRODUCTION.wages_unit_counter'); end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
ghkjhqaftqt0m SELECT PLANNO, STYLENO, ORDERNO, CCODE, DEPTCODE, DEPT_NAME , EMPCODE, OPRCODE, QTY , RATE, EMPNAME, FNAME , OPRNAME, SUM(AMT) AMT FROM ( SELECT M.PLANNO, GET_PLAN_STYLE(M.PLANNO) STYLENO, GET_PLAN_PO(M.PLANNO) ORDERNO, M.CCODE, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM ) DEPTCODE, DEPT_CODE_VALIDATION(DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM )) DEPT_NAME , D.EMP_CODE EMPCODE, to_char(D.OPRATION_ID) OPRCODE, SUM(M.STITCHED_QTY) QTY , GET_PLANE_OPRATION_RATE(m.PLANNO, D.OPRATION_ID) RATE, emp_code_validation(D.EMP_CODE) EMPNAME, PRODUCTION.GET_EMP_FNAME(D.EMP_CODE) as FNAME , OPERATION_ID_VALIDATION(D.OPRATION_ID) OPRNAME, SUM (round(((M.STITCHED_QTY)/12), 2)*GET_PLANE_OPRATION_RATE(m.PLANNO, D.OPRATION_ID)) as AMT FROM OPR_WAGES_EMP_MASTER M, OPR_WAGES_EMP_DTL D WHERE M.OPR_MAIN_ID=D.OPR_MAIN_ID And D.EMP_CODE is not null AND dateD BETWEEN :P_FROM AND :P_TO AND PRODUCTION.GET_EMPTYPE(D.EMP_CODE)= nvl(:EMPTYPE , PRODUCTION.GET_EMPTYPE(D.EMP_CODE)) AND M.CCODE=NVL(:P_CCODE, M.CCODE) and m.PLANNO =NVL(:p_planno, m.PLANNO) and DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM )=nvl(:P_DEPT, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM )) AND D.OPRATION_ID =NVL(:P_OPR, D.OPRATION_ID) group by M.CCODE, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM ) , M.PLANNO, D.OPRATION_ID, EMP_CODE UNION ALL SELECT M.PLANNO, GET_PLAN_STYLE(M.PLANNO) STYLENO, GET_PLAN_PO(M.PLANNO) ORDERNO, M.CCODE, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM ) DEPTCODE, DEPT_CODE_VALIDATION(DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM )) DEPT_NAME , EMPCODE, to_char(OPRATION) OPRCODE, SUM(M.STITCHED_QTY) QTY , GET_PLANE_OPRATION_RATE(m.PLANNO, OPRATION) RATE, emp_code_validation(EMPCODE) EMPNAME, PRODUCTION.GET_EMP_FNAME(EMPCODE) as FNAME , OPERATION_ID_VALIDATION(OPRATION) OPRNAME, SUM (round(((M.STITCHED_QTY)/12), 2)*GET_PLANE_OPRATION_RATE(m.PLANNO, OPRATION)) as AMT FROM OPR_WAGES_EMP_MASTER M, OPR_WAGES_EMP_M MD WHERE M.OPR_MAIN_ID=MD.OPR_MAIN_ID AND Ddate BETWEEN :P_FROM AND :P_TO AND PRODUCTION.GET_EMPTYPE(EMPCODE)= nvl(:EMPTYPE , PRODUCTION.GET_EMPTYPE(EMPCODE)) AND M.CCODE=NVL(:P_CCODE, M.CCODE) and m.PLANNO =NVL(:p_planno, m.PLANNO) and DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM)=nvl(:P_DEPT, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM )) AND OPRATION =NVL(:P_OPR, OPRATION) group by M.CCODE, DECODE(UNIT_NUM, 2547, 2514, UNIT_NUM ), M.PLANNO, OPRATION, EMPCODE ) GROUP BY PLANNO , STYLENO , ORDERNO , CCODE , DEPTCODE , DEPT_NAME , EMPCODE , OPRCODE , QTY , RATE , EMPNAME , FNAME , OPRNAME ORDER BY 1 ASC, 2 ASC, 3 ASC, 5 ASC, 6 ASC, 13 ASC, 8 ASC
gzqjxjwwthgq5SELECT COUNT(M.DOC_ID) FROM STIT_REC_ISSUE_M M WHERE M.DOCUMENT_TYPE = 'SSW' AND M.DOC_ID = :b1 AND NOT EXISTS (SELECT * FROM EXPIMP.WAREHOUSE_REC R WHERE R.TRAN_REF = M.DOC_ID ) UNION ALL SELECT COUNT(M.DOC_ID) FROM STIT_REC_ISSUE_M M WHERE M.DOCUMENT_TYPE = 'SSW' AND M.DOC_ID = :b1 AND NOT EXISTS (SELECT * FROM EXPIMP.WAREHOUSE_REC_SUB R WHERE R.TRAN_REF = M.DOC_ID )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Key Instance Activity Stats

StatisticTotalper Secondper Trans
db block changes269,924,80274,698.185,304.19
execute count44,174,39812,224.69868.05
logons cumulative1,5970.440.03
opened cursors cumulative43,816,74712,125.72861.03
parse count (total)619,124171.3312.17
parse time elapsed7,5712.100.15
physical reads1,020,323282.3620.05
physical writes2,599,456719.3751.08
redo size31,553,799,3448,732,104.27620,051.47
session cursor cache hits5,128,1561,419.15100.77
session logical reads1,498,220,496414,613.0729,440.95
user calls3,720,6881,029.6573.11
user commits45,93712.710.90
user rollbacks4,9521.370.10
workarea executions - onepass00.000.00
workarea executions - optimal2,917,573807.4057.33


Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count7,7222.140.15
Batched IO (full) vector count320.010.00
Batched IO block miss count52,38914.501.03
Batched IO buffer defrag count1570.040.00
Batched IO double miss count3730.100.01
Batched IO same unit count27,8167.700.55
Batched IO single block count4,1521.150.08
Batched IO slow jump count00.000.00
Batched IO vector block count20,4335.650.40
Batched IO vector read count3,6981.020.07
Block Cleanout Optim referenced3300.090.01
CCursor + sql area evicted1,1570.320.02
CPU used by this session1,333,342368.9926.20
CPU used when call started943,526261.1118.54
CR blocks created105,07029.082.06
Cached Commit SCN referenced14,327,8723,965.05281.55
Commit SCN cached1,7360.480.03
DBWR checkpoint buffers written2,597,213718.7451.04
DBWR checkpoints100.000.00
DBWR object drop buffers written00.000.00
DBWR revisited being-written buffer160.000.00
DBWR tablespace checkpoint buffers written00.000.00
DBWR transaction table writes5180.140.01
DBWR undo block writes1,696,563469.5033.34
Effective IO time00.000.00
HSC Heap Segment Block Changes18,026,5714,988.62354.23
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts194,41653.803.82
Heap Segment Array Updates5010.140.01
IMU CR rollbacks5,0101.390.10
IMU Flushes7,9652.200.16
IMU Redo allocation size28,956,5368,013.35569.01
IMU commits22,0126.090.43
IMU contention3600.100.01
IMU ktichg flush940.030.00
IMU pool not allocated17,5314.850.34
IMU recursive-transaction flush510.010.00
IMU undo allocation size116,618,36832,272.622,291.62
IMU- failed to get a private strand1160.030.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued110.000.00
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Requests to/from client3,700,8331,024.1672.72
RowCR - row contention240.010.00
RowCR attempts393,080108.787.72
RowCR hits393,049108.777.72
SMON posted for undo segment shrink130.000.00
SQL*Net roundtrips to/from client3,701,0251,024.2172.73
TBS Extension: bytes extended00.000.00
TBS Extension: files extended00.000.00
TBS Extension: tasks created00.000.00
TBS Extension: tasks executed00.000.00
active txn count during cleanout327,67090.686.44
background checkpoints completed90.000.00
background checkpoints started100.000.00
background timeouts31,1198.610.61
branch node splits20.000.00
buffer is not pinned count381,338,936105,530.607,493.54
buffer is pinned count2,657,204,587735,346.8752,215.70
bytes received via SQL*Net from client341,191,25394,420.256,704.62
bytes sent via SQL*Net to client2,522,049,079697,944.3449,559.81
calls to get snapshot scn: kcmgss56,664,63715,681.201,113.49
calls to kcmgas217,10660.084.27
calls to kcmgcs3,672,3181,016.2772.16
cell physical IO interconnect bytes62,530,601,98417,304,532.201,228,764.61
change write time32,1988.910.63
cleanout - number of ktugct calls328,22790.836.45
cleanouts and rollbacks - consistent read gets103,86228.742.04
cleanouts only - consistent read gets4240.120.01
cluster key scan block gets57,91416.031.14
cluster key scans39,96211.060.79
commit batch performed110.000.00
commit batch requested110.000.00
commit batch/immediate performed1210.030.00
commit batch/immediate requested1210.030.00
commit cleanout failures: block lost550.020.00
commit cleanout failures: buffer being written3020.080.01
commit cleanout failures: callback failure3070.080.01
commit cleanout failures: cannot pin930.030.00
commit cleanouts883,484244.4917.36
commit cleanouts successfully completed882,727244.2817.35
commit immediate performed1100.030.00
commit immediate requested1100.030.00
commit txn count during cleanout7,8582.170.15
consistent changes12,790,6833,539.66251.34
consistent gets1,120,400,142310,056.1922,016.55
consistent gets - examination290,181,71080,304.025,702.25
consistent gets direct190.010.00
consistent gets from cache1,120,400,200310,056.2122,016.55
consistent gets from cache (fastpath)782,496,466216,545.7415,376.53
cursor authentications3,7201.030.07
data blocks consistent reads - undo records applied299,88082.995.89
db block gets377,824,974104,558.167,424.49
db block gets direct2910.080.01
db block gets from cache377,824,689104,558.087,424.49
db block gets from cache (fastpath)107,595,29629,775.602,114.31
deferred (CURRENT) block cleanout applications224,97762.264.42
dirty buffers inspected2120.060.00
enqueue conversions7,1371.980.14
enqueue releases273,33175.645.37
enqueue requests273,44175.675.37
enqueue timeouts360.010.00
enqueue waits5840.160.01
failed probes on index block reclamation11,1893.100.22
file io service time00.000.00
free buffer inspected2,696,880746.3353.00
free buffer requested6,041,3811,671.87118.72
global undo segment hints helped00.000.00
global undo segment hints were stale00.000.00
heap block compress107,82729.842.12
hot buffers moved to head of LRU1,243,205344.0424.43
immediate (CR) block cleanout applications104,28628.862.05
immediate (CURRENT) block cleanout applications609,542168.6811.98
index crx upgrade (positioned)5,7931.600.11
index crx upgrade (prefetch)1,6580.460.03
index fast full scans (full)4,1461.150.08
index fetch by key309,322,07385,600.876,078.37
index scans kdiixs147,700,43313,200.48937.34
java call heap collected bytes00.000.00
java call heap collected count00.000.00
java call heap gc count00.000.00
java call heap object count00.000.00
java call heap object count max00.000.00
java call heap total size00.000.00
java call heap total size max00.000.00
java call heap used size00.000.00
java call heap used size max00.000.00
java session heap live size00.000.00
java session heap live size max00.000.00
java session heap used size00.000.00
java session heap used size max00.000.00
leaf node 90-10 splits2800.080.01
leaf node splits2,5440.700.05
lob reads3,120,902863.6761.33
lob writes3,122,058863.9961.35
lob writes unaligned3,122,055863.9961.35
logical read bytes from cache12,273,461,207,0403,396,521,030.23241,181,025.51
max cf enq hold time7300.200.01
messages received267,87274.135.26
messages sent267,87274.135.26
min active SCN optimization applied on CR1,9120.530.04
no buffer to keep pinned count5,9061.630.12
no work - consistent read gets817,676,771226,281.4316,067.85
non-idle wait count4,572,4551,265.3789.85
parse count (describe)00.000.00
parse count (failures)2460.070.00
parse count (hard)3,9221.090.08
parse time cpu7,1231.970.14
physical read IO requests97,09726.871.91
physical read bytes8,358,486,0162,313,102.48164,249.37
physical read total IO requests106,45129.462.09
physical read total bytes8,507,328,5122,354,292.71167,174.21
physical read total multi block requests9,8482.730.19
physical reads cache1,020,304282.3620.05
physical reads cache prefetch939,646260.0318.46
physical reads direct190.010.00
physical reads direct (lob)110.000.00
physical reads direct temporary tablespace40.000.00
physical reads prefetch warmup00.000.00
physical write IO requests221,46261.294.35
physical write bytes21,294,743,5525,893,043.79418,454.75
physical write total IO requests299,06182.765.88
physical write total bytes54,023,273,47214,950,239.491,061,590.39
physical write total multi block requests171,16347.373.36
physical writes direct2910.080.01
physical writes direct (lob)1970.050.00
physical writes direct temporary tablespace1840.050.00
physical writes from cache2,599,165719.2951.08
physical writes non checkpoint1,679,745464.8533.01
pinned buffers inspected7880.220.02
pinned cursors current410.010.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use1,0410.290.02
process last non-idle time3,6141.000.07
recovery blocks read00.000.00
recursive calls50,450,77713,961.60991.39
recursive cpu usage893,366247.2317.56
redo KB read00.000.00
redo blocks checksummed by FG (exclusive)1,771,167490.1534.80
redo blocks read for recovery00.000.00
redo blocks written63,795,72217,654.641,253.62
redo buffer allocation retries840.020.00
redo entries128,956,86035,687.142,534.08
redo k-bytes read for recovery00.000.00
redo log space requests1170.030.00
redo ordering marks11,1403.080.22
redo size for direct writes1,1120.310.02
redo subscn max counts515,160142.5610.12
redo synch long waits310.010.00
redo synch time16,3594.530.32
redo synch time (usec)163,332,58245,200.173,209.59
redo synch time overhead (usec)44,572,75012,334.93875.88
redo synch time overhead count (<128 msec)00.000.00
redo synch time overhead count (<2 msec)7,4882.070.15
redo synch time overhead count (<32 msec)20.000.00
redo synch time overhead count (<8 msec)50.000.00
redo synch time overhead count (>=128 msec)210.010.00
redo synch writes7,5262.080.15
redo wastage15,411,1964,264.85302.84
redo write info find7,5172.080.15
redo write info find fail10.000.00
redo write time67,84118.771.33
redo writes41,22511.410.81
rollback changes - undo records applied1,5540.430.03
rollbacks only - consistent read gets1,3510.370.03
root node splits00.000.00
rows fetched via callback74,939,12820,738.431,472.60
securefile direct read bytes00.000.00
securefile direct read ops00.000.00
session connect time00.000.00
shared hash latch upgrades - no wait5,893,4691,630.94115.81
shared hash latch upgrades - wait20.000.00
shared io pool buffer get success00.000.00
sorts (disk)00.000.00
sorts (memory)4,023,4711,113.4479.06
sorts (rows)1,250,927,784346,178.0224,581.50
sql area evicted6,1891.710.12
sql area purged4320.120.01
summed dirty queue length2480.070.00
switch current to new buffer124,55234.472.45
table fetch by rowid1,427,627,746395,077.4428,053.76
table fetch continued row928,428256.9318.24
table scan blocks gotten581,782,842161,000.8511,432.39
table scan rows gotten39,978,353,66611,063,490.30785,599.12
table scans (direct read)00.000.00
table scans (long tables)310.010.00
table scans (rowid ranges)00.000.00
table scans (short tables)1,694,520468.9433.30
temp space allocated (bytes)54,525,95215,089.351,071.47
total cf enq hold time24,0106.640.47
total number of cf enq holders2010.060.00
total number of times SMON posted130.000.00
transaction rollbacks1210.030.00
transaction tables consistent read rollbacks10.000.00
transaction tables consistent reads - undo records applied570.020.00
undo change vector size13,286,991,8003,677,002.46261,097.52
user logons cumulative9910.270.02
user logouts cumulative9410.260.02
write clones created in background10.000.00
write clones created in foreground14,9424.140.29


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current920968
opened cursors current5,8135,810
session cursor cache count1,401,3761,475,072
session pga memory45,542,446,44047,563,958,680
session pga memory max2,989,184,910,6643,094,271,664,472
session uga memory19,143,346,38420,039,448,648
session uga memory max475,927,944,704498,997,583,560
workarea memory allocated7,08751,629


Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)109.96


Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

IOStat by Function summary

Function NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR3M0.06.001M30.4G20.378.62M82.9K15.92
DBWR0M0.000M19.8G61.305.621M219.8K49.35
Buffer Cache Reads7.8G26.852.206M0M0.000M84K3.10
Others139M2.53.038M58M1.11.016M13.1K13.78
Direct Writes0M0.000M3M0.01.001M278.56
Direct Reads0M0.000M0M0.000M114.36
TOTAL:7.9G29.452.245M50.3G82.7814.258M400K31.53


Back to IO Stats
Back to Top

IOStat by Filetype summary

Filetype NameReads: DataReqs per secData per secWrites: DataReqs per secData per secSmall ReadLarge Read
Log File0M0.010M30.4G20.318.619M2.35 
Data File7.8G26.982.209M19.8G61.425.623M2.047.68
Control File138M2.45.038M59M1.04.016M2.76 
Temp File0M0.020M3M0.01.001M3.98 
TOTAL:7.9G29.452.247M50.3G82.7814.26M2.117.68


Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

Function/File NameReads: DataReqs per secData per secWrites: DataReqs per secData per secWaits: CountAvg Tm(ms)
LGWR 3M0.06.001M30.4G20.378.62M2432.23
LGWR (Log File) 0M0.010M30.4G20.318.619M403.80
LGWR (Control File) 3M0.06.001M4M0.06.001M2031.92
DBWR 0M0.000M19.8G61.305.622M0 
DBWR (Data File) 0M0.000M19.8G61.305.622M0 
Buffer Cache Reads 7.8G26.852.206M0M0.000M77.2K2.83
Buffer Cache Reads (Data File) 7.8G26.852.206M0M0.000M77.2K2.83
Others 139M2.53.038M58M1.11.016M95933.17
Others (Control File) 135M2.39.037M55M0.98.015M86352.78
Others (Data File) 4M0.14.001M3M0.12.001M9586.72
Direct Writes 0M0.000M3M0.01.001M0 
Direct Writes (Data File) 0M0.000M3M0.01.001M0 
Direct Reads 0M0.000M0M0.000M0 
Direct Reads (Data File) 0M0.000M0M0.000M0 
TOTAL: 7.9G29.442.245M50.3G82.7814.259M87K2.87


Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Rds/sAv Rd(ms)Av Blks/Rd 1-bk Rds/sAv 1-bk Rd(ms)WritesWrites avg/sBuffer WaitsAv Buf Wt(ms)
UNDOTBS1 3026.671.00124,5900.002734150.00
WAGES_REORG0 61105.991.0572,2870.1762000.00
WAGES 29,80184.1731.4511,9824.902300.00
PRODUCTION 25,40971.391.234,0396.9911350.57
HRM 17,91752.261.161,4984.922000.00
DYE 7,11020.651.035671.931000.00
PICTURES 7,01121.841.00211.942000.00
SYSTEM 3,47311.301.001,1880.96101980.00
SYSAUX 1,46705.115.212,7040.385100.00
PROCESSING 2,04811.671.047390.552000.00
ACC 84500.971.007550.231000.00
USERS 61604.841.412000.165000.00
ERP 51002.021.002510.142000.00
EXPIMP 18206.591.255120.057000.00
EXAMPLE 2404.581.461640.015000.00
TEMP1 4904.291.00320.014000.00
TEMP 1703.531.00130.004000.00


Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Rds/sAv Rd(ms)Av Blks/Rd 1-bk Rds/sAv 1-bk Rd(ms)WritesWrites avg/sBuffer WaitsAv Buf Wt(ms)
ACC/u01/app/oracle/oradata/klash/acc 84500.971.0000.98755000.00
DYE/u01/app/oracle/oradata/klash/dye.dbf 3,36410.601.0310.60226000.00
DYE/u01/app/oracle/oradata/klash/dye02.dbf 402.502.0006.6716000.00
DYE/u01/app/oracle/oradata/klash/dye03.dbf 3,59010.531.0310.53132000.00
DYE/u01/app/oracle/oradata/klash/dye04.dbf 15204.801.0004.80193000.00
ERP/u01/app/oracle/oradata/klash/erp.dbf 25101.911.0001.91158000.00
ERP/u01/app/oracle/oradata/klash/erp1 25902.121.0002.1693000.00
EXAMPLE/u01/app/oracle/oradata/klash/example01.dbf 2404.581.4604.55164000.00
EXPIMP/u01/app/oracle/oradata/klash/expimp.dbf 18206.591.2506.72512000.00
HRM/u01/app/oracle/oradata/klash/hrm.dbf 8,62022.341.1722.34488000.00
HRM/u01/app/oracle/oradata/klash/hrm1.dbf 8,93022.081.1422.07148000.00
HRM/u01/app/oracle/oradata/klash/hrm2.dbf 36704.601.3804.59862000.00
PICTURES/u01/app/oracle/oradata/klash/PICTURES 3,04411.541.0011.5413000.00
PICTURES/u01/app/oracle/oradata/klash/PICTURES02.DBF 1,89611.661.0011.663000.00
PICTURES/u01/app/oracle/oradata/klash/PICTURES03.DBF 2,07112.451.0012.445000.00
PROCESSING/u01/app/oracle/oradata/klash/PROCESSING 2,04811.671.0411.67739000.00
PRODUCTION/u01/app/oracle/oradata/klash/production.dbf 4,86111.231.1711.22919000.00
PRODUCTION/u01/app/oracle/oradata/klash/production02.dbf 3,70510.681.2210.67228000.00
PRODUCTION/u01/app/oracle/oradata/klash/production03.dbf 4,15311.151.3811.14458000.00
PRODUCTION/u01/app/oracle/oradata/klash/production05.dbf 4,26811.231.4211.20764010.00
PRODUCTION/u01/app/oracle/oradata/klash/production06.dbf 4,85312.481.0012.488170300.67
PRODUCTION/u01/app/oracle/oradata/klash/production07.dbf 3605.561.0005.56233000.00
PRODUCTION/u01/app/oracle/oradata/klash/production4.dbf 3,53311.301.2611.29620040.00
SYSAUX/u01/app/oracle/oradata/klash/sysaux01.dbf 1,46705.115.2104.682,704100.00
SYSTEM/u01/app/oracle/oradata/klash/system01.dbf 3,47311.301.0011.301,18801980.00
TEMP/u01/app/oracle/oradata/klash/temp01.dbf 1703.531.0003.531300 
TEMP1/u01/app/oracle/oradata/klash/temp01 4904.291.0004.293200 
UNDOTBS1/u01/app/oracle/oradata/klash/undotbs01.dbf 3026.671.00026.67124,59034150.00
USERS/u01/app/oracle/oradata/klash/users01.dbf 61604.841.4104.87200000.00
WAGES/u01/app/oracle/oradata/klash/WAGES 3,00913.7534.2811.30357000.00
WAGES/u01/app/oracle/oradata/klash/WAGES03.DBF 3,60113.9332.2411.471,041000.00
WAGES/u01/app/oracle/oradata/klash/WAGES04.DBF 3,49313.8634.7711.59620000.00
WAGES/u01/app/oracle/oradata/klash/WAGES05.DBF 3,55814.0134.1011.69890000.00
WAGES/u01/app/oracle/oradata/klash/wages02.dbf 2,64013.9738.8401.44599000.00
WAGES/u01/app/oracle/oradata/klash/wages06.dbf 2,81815.3342.6702.621,135000.00
WAGES/u01/app/oracle/oradata/klash/wages07.dbf 2,88714.8642.5602.021,221000.00
WAGES/u01/app/oracle/oradata/klash/wages08 4,59513.6427.5312.131,248000.00
WAGES/u01/app/oracle/oradata/klash/wages09.dbf 83104.241.0004.231,360000.00
WAGES/u01/app/oracle/oradata/klash/wages10.dbf 1,63103.511.0003.512,065100.00
WAGES/u01/app/oracle/oradata/klash/wages11 73807.521.0507.661,446000.00
WAGES_REORG0/u01/app/oracle/oradata/klash/WAGES03_reorg0.DBF 7406.221.0006.085,963200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/WAGES04_reorg0.DBF 4603.261.0003.267,303200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/WAGES05_reorg0.DBF 34012.651.00012.947,631200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/WAGES_reorg0 9603.541.0003.545,732200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages02_reorg0.dbf 8405.361.0805.426,754200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages06_reorg0.dbf 1809.441.94010.676,235200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages07_reorg0.dbf 7603.031.0903.116,370200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages08_reorg0 2506.401.0006.807,276200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages09_reorg0.dbf 6708.961.0008.966,615200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages10_reorg0.dbf 5906.441.0006.615,959200.00
WAGES_REORG0/u01/app/oracle/oradata/klash/wages11_reorg0 3209.061.0009.066,449200.00


Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D3,153,7001001,497,681,0951,020,2972,599,83200248


Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
00002,597,4820


Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual RedoBlksTarget RedoBlksLog Sz RedoBlksLog Ckpt Timeout RedoBlksLog Ckpt Interval RedoBlksOpt Log Sz(M)Estd RAC Avail Time
B042948548714262245237816812378168136205208   
E040144462014154499237816812378168134127224   


Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers (thousands)Est Phys Read FactorEstimated Phys Reads (thousands)Est Phys Read TimeEst %DBtime for Rds
D2,5600.1031512.53352,2011652014.00
D5,1200.206316.01168,9061287223.00
D7,6800.309464.09115,0741180088.00
D10,2400.401,2612.9583,0591116371.00
D12,8000.501,5772.0958,755168002.00
D15,3600.601,8921.5744,223139080.00
D17,9200.702,2081.1732,911116568.00
D20,4800.802,5231.0930,556111880.00
D23,0400.902,8381.0228,77518336.00
D25,6001.003,1541.0028,10917011.00
D28,1601.103,4690.9827,62416045.00
D30,7201.203,7840.9727,23815278.00
D33,2801.304,1000.9627,03914881.00
D35,8401.404,4150.9626,93814679.00
D38,4001.504,7310.9526,83314471.00
D40,9601.605,0460.9526,64714101.00
D43,5201.705,3610.9426,49413796.00
D46,0801.805,6770.9426,30813427.00
D48,6401.905,9920.9326,12513063.00
D51,2002.006,3070.7420,89712696.00


Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00757,1790


Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K2,496,8442,496,84400
64K128K1,2441,24400
128K256K82582500
256K512K1,7801,78000
512K1024K150,064150,06400
1M2M203,516203,51600
2M4M56,83256,83200
4M8M1,4651,46500
8M16M1,9141,91400
16M32M59159100
32M64M2,0742,07400
64M128M555500
128M256M303000
512M1024M242400
1G2G141400


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 CountEstd Time
3,5840.137,336,739.83115,443.3798.00017,658,667,359
7,1680.257,336,739.83115,443.3798.00017,658,667,359
14,3360.507,336,739.83115,443.3798.00017,658,667,359
21,5040.757,336,739.83115,443.3798.00017,658,667,359
28,6721.007,336,739.831,408.86100.00017,388,451,593
34,4061.207,336,739.831,403.02100.00017,388,437,744
40,1411.407,336,739.831,403.02100.00017,388,437,744
45,8751.607,336,739.831,403.02100.00017,388,437,744
51,6101.807,336,739.831,403.02100.00017,388,437,744
57,3442.007,336,739.831,403.02100.00017,388,437,744
86,0163.007,336,739.831,403.02100.00017,388,437,744
114,6884.007,336,739.831,403.02100.00017,388,437,744
172,0326.007,336,739.831,403.02100.00017,388,437,744
229,3768.007,336,739.831,403.02100.00017,388,437,744


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 (K)
7,1680.546297,6583,103,5050.711,279,668302.88270,691
8,7040.651,595157,8644,377,0921.006,0811.44430,161
10,2400.773,131233,5044,377,8791.005,2941.25430,208
10,7520.813,643256,7344,378,0591.005,1141.21430,215
11,0080.833,899268,1874,378,1581.005,0151.19430,218
11,2640.854,154280,2214,378,2371.004,9361.17430,222
11,5200.874,410291,9074,378,3221.004,8511.15430,225
11,7760.884,666304,0814,378,4021.004,7711.13430,227
12,0320.904,922316,6974,378,4711.004,7021.11430,229
12,2880.925,178329,6564,378,5451.004,6281.10430,230
12,5440.945,434345,3924,378,6181.004,5551.08430,232
12,8000.965,690363,9164,378,7021.004,4711.06430,234
13,0560.985,946381,1914,378,7731.004,4001.04430,235
13,3121.006,202397,8004,378,9481.004,2251.00430,335
13,5681.026,458414,9684,378,9851.004,1880.99430,339
13,8241.046,714432,7704,378,9861.004,1870.99430,340
14,0801.066,969449,9074,378,9871.004,1860.99430,340
14,3361.087,225466,0324,378,9881.004,1850.99430,341
14,5921.107,481481,4084,378,9881.004,1850.99430,342
14,8481.127,737495,2604,378,9881.004,1850.99430,342
15,1041.137,993507,7784,378,9901.004,1830.99430,342
15,3601.158,249519,8474,378,9901.004,1830.99430,342
15,6161.178,505531,2894,378,9921.004,1810.99430,342
16,3841.239,272559,5304,378,9921.004,1810.99430,342
17,9201.3510,808616,1934,379,0011.004,1720.99430,345
19,4561.4612,344683,9974,379,0151.004,1580.98430,351
20,9921.5813,531732,8834,379,0431.004,1300.98430,355
22,5281.6913,531732,8834,379,0431.004,1300.98430,355
24,0641.8113,531732,8834,379,0431.004,1300.98430,355
25,6001.9213,531732,8834,379,0431.004,1300.98430,355
27,1362.0413,531732,8834,379,0431.004,1300.98430,355


Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
16,1280.38544,895174,262,740
21,5040.50373,40785,703,448
26,8800.63295,79245,631,675
32,2560.75267,68031,532,348
37,6320.88262,52129,008,186
43,0081.00260,54128,108,707
48,3841.13259,55127,903,513
53,7601.25259,05627,498,748
59,1361.38258,14427,150,200
64,5121.50257,36321,565,000
69,8881.63257,33721,565,000
75,2641.75257,31121,565,000
80,6401.88257,31121,565,000
86,0162.00257,31121,565,000


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)
2560.500000
5121.000000
7681.500000
1,0242.000000
1,2802.500000
1,5363.000000
1,7923.500000
2,0484.000000
2,3044.500000
2,5605.000000
2,8165.500000
3,0726.000000
3,3286.500000
3,5847.000000
3,8407.500000
4,0968.000000
4,3528.500000
4,6089.000000
4,8649.500000
5,12010.000000


Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP 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
2560.1439531.004,2251.0045
5120.2939531.004,2251.0045
7680.4339531.004,2251.0045
1,0240.5739531.004,2251.0045
1,2800.7139531.004,2251.0045
1,5360.8639531.004,2251.0045
1,7921.0039531.004,2251.0045
2,0481.1439531.004,2251.0045
2,3041.2939531.004,2251.0045
2,5601.4339531.004,2251.0045
2,8161.5739531.004,2251.0045
3,0721.7139531.004,2251.0045
3,3281.8639531.004,2251.0045
3,5842.0039531.004,2251.0045
3,8402.1439531.004,2251.0045
4,0962.2939531.004,2251.0045


Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block23300
undo header1000
undo block500


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) 24924802474821,951.01
MS-Materialized View Refresh Log 3,3663,366043767.50
JS-Job Scheduler (queue lock) 29,09629,096032901.28
CR-Reuse Block Range (block range reuse ckpt) 8,2948,29402045.00
SQ-Sequence Cache 5085080100.00
TX-Transaction (index contention) 4544540100.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
21,694.9263,7981,9733122/47.90/00/0/0/27/163496/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
07-Jan 16:55110,1423,3791,97323480/00/0/0/0/0/0
07-Jan 16:45392,3655,26478323280/00/0/0/0/0/0
07-Jan 16:35337,26122,2001,73731440/00/0/0/0/0/0
07-Jan 16:25103,1693,5161,62224420/00/0/0/0/0/0
07-Jan 16:15418,7027,59657927250/00/0/0/0/0/0
07-Jan 16:05333,27721,84342027220/00/0/0/27/163496/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
AQ deq hash table latch10.00 00 
AQ dequeue txn counter latch3,1340.00 00 
ASM db client latch3,7250.00 00 
ASM map operation hash table10.00 00 
ASM network state latch570.00 00 
AWR Alerted Metric Element list80,5490.00 00 
Change Notification Hash table latch1,2020.00 00 
Consistent RBA41,3080.010.0000 
DML lock allocation225,5550.00 00 
Event Group Locks2,6770.00 00 
FOB s.o list latch4,7010.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC stats buffer allocation latch10.00 00 
In memory undo latch305,4520.000.20032,8830.03
JS Sh mem access6570.00 00 
JS mem alloc latch9580.00 00 
JS queue access latch9590.00 00 
JS queue state obj latch58,1920.00 00 
JS slv state obj latch1510.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list10.00 00 
KJCT flow control latch10.00 00 
KMG MMAN ready and startup request latch1,2040.00 00 
KTF sga latch9480.00 01,1750.00
KWQMN job cache list latch210.00 00 
KWQP Prop Status4660.00 00 
KWQS pqsubs latch50.00 00 
KWQS pqueue ctx latch2970.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch10.00 00 
MQL Tracking Latch0  0720.00
Memory Management Latch10.00 01,2040.00
Memory Queue5790.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch400.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process4,6100.00 00 
OS process allocation9,6510.00 00 
OS process: request allocation2,1090.00 00 
PL/SQL warning settings6,8760.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch45,6190.010.5000 
SGA IO buffer pool latch40.00 040.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch1210.00 01,1700.00
SQL memory manager workarea list latch7,625,9590.000.0000 
Shared B-Tree6,1400.080.0000 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
VPSO SGA780.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch233,7850.120.0000 
active service list22,4600.020.0003,1250.00
begin backup scn array180.00 00 
bq:time manger info latch1290.00 00 
buffer pool10.00 00 
bufq statistics5970.00 00 
business card10.00 00 
cache buffer handles165,8710.000.0000 
cache buffers chains3,159,355,8580.010.0005,592,0590.87
cache buffers lru chain5,810,8780.010.06013,763,5250.02
cache table scan latch12,6930.00 012,6930.00
call allocation12,2140.150.0600 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch2,1180.00 00 
channel operations parent latch37,0800.00 00 
checkpoint queue latch6,871,7630.000.0102,558,1460.00
client/application info11,7550.00 00 
compile environment latch1,5970.00 00 
constraint object allocation8740.00 00 
corrupted undo seg latch4,7830.060.0000 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch570.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch570.00 00 
dml lock allocation570.00 00 
done queue latch10.00 00 
dummy allocation3,1460.00 00 
eighth spare latch - X parent10.00 00 
eleventh spare latch - children10.00 00 
enqueue freelist latch10.00 0184,3950.00
enqueue hash chains554,9490.020.0001650.00
enqueues600.00 00 
fifteenth spare latch - children10.00 00 
file cache latch2,9150.00 00 
first Audit Vault latch9730.00 00 
flashback copy10.00 00 
fourteenth spare latch - children10.00 00 
fourth Audit Vault latch10.00 00 
gc element10.00 00 
gcs commit scn state10.00 00 
gcs partitioned table hash10.00 00 
gcs pcm hashed value bucket hash10.00 00 
gcs resource freelist10.00 00 
gcs resource hash10.00 00 
gcs resource scan list10.00 00 
gcs resource validate list10.00 00 
gcs shadows freelist10.00 00 
ges domain table10.00 00 
ges enqueue table freelist10.00 00 
ges group table10.00 00 
ges process hash list10.00 00 
ges process parent latch10.00 00 
ges resource hash list10.00 00 
ges resource scan list10.00 00 
ges resource table freelist10.00 00 
ges value block free list10.00 00 
global KZLD latch for mem in SGA9950.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch7600.130.0004,884,6060.00
hash table modification latch2700.00 00 
heartbeat check10.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch5190.00 05209.42
job_queue_processes free list latch1,9540.720.0000 
job_queue_processes parameter latch1,5670.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch100.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch320.00 00 
ksfv messages10.00 00 
ksim group membership cache10.00 00 
kss move lock410.00 00 
ksuosstats global area3650.00 00 
ksv allocation latch1370.00 00 
ksv class latch810.00 00 
ksv msg queue latch10.00 00 
ksz_so allocation latch2,1090.00 00 
ktm global data860.00 00 
kwqbsn:qsga2,4520.530.0000 
lgwr LWN SCN41,5250.390.0000 
list of block allocation72,2640.010.0000 
loader state object freelist740.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation20.00 00 
logminer local10.00 00 
logminer work area10.00 00 
longop free list parent610.00 0600.00
mapped buffers lru chain10.00 00 
message pool operations parent latch4,2660.00 00 
messages675,2630.130.0000 
mostly latch-free SCN47,4848.880.0000 
msg queue latch10.00 00 
multiblock read objects36,4140.00 00 
name-service namespace bucket10.00 00 
ncodef allocation latch570.00 00 
nineth spare latch - X parent10.00 00 
object queue header heap3,878,6000.000.0002,929,3450.00
object queue header operation23,425,0580.010.0000 
object stats modification8340.00 00 
parallel query alloc buffer1,4050.00 00 
parallel query stats10.00 00 
parameter list2580.00 00 
parameter table management28,4270.380.0000 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue19,5320.060.00013,1810.03
process allocation2,1970.00 01,0790.00
process group creation2,1090.00 00 
process queue10.00 00 
process queue reference10.00 00 
qmn task queue latch3,9032.490.0000 
query server freelists10.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation271,6171.850.000128,951,4870.05
redo copy10.00 0128,957,8340.00
redo writing384,1280.130.0000 
resmgr group change latch2,0060.00 00 
resmgr:active threads3,1460.00 00 
resmgr:actses change group1,5120.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list3,1450.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config110.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects42,311,5480.140.000380.00
rules engine rule set statistics1000.00 00 
second Audit Vault latch10.00 00 
sequence cache36,3500.050.0000 
session allocation80,4590.00 077,4020.00
session idle bit7,517,0740.000.0000 
session queue latch10.00 00 
session state list latch5,1400.540.4600 
session switching1,0880.00 00 
session timer1,2030.00 00 
seventh spare latch - X parent10.00 00 
shared pool2,970,7410.010.19030.00
shared pool sim alloc2330.00 00 
shared pool simulator18,5720.00 00 
sim partition latch10.00 00 
simulator hash latch88,386,1880.000.0000 
simulator lru latch1,963,7430.040.01086,303,4770.16
sixth spare latch - X parent10.00 00 
sort extent pool1,6300.00 00 
space background state object latch100.00 00 
space background task latch3,8780.030.0002,4080.00
state object free list20.00 00 
statistics aggregation5600.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation4150.00 00 
temporary table state object allocation30.00 00 
tenth spare latch - X parent10.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
thirteenth spare latch - children10.00 00 
threshold alerts latch2690.00 00 
transaction allocation10,9340.00 00 
twelfth spare latch - children10.00 00 
twenty-fifth spare latch - S par10.00 00 
twenty-first spare latch - S par10.00 00 
twenty-fourth spare latch - S par10.00 00 
twenty-second spare latch - S par10.00 00 
twenty-third spare latch - S par10.00 00 
undo global data2,375,3360.010.0100 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 
write info latch0  041,2430.00


Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains3,159,355,858203,983120203,865
row cache objects42,311,54860,6941260,682
redo allocation271,6175,030105,020
object queue header operation23,425,0582,22522,223
simulator hash latch88,386,1888161815
simulator lru latch1,963,7437765771
cache buffers lru chain5,810,87867039631
shared pool2,970,74126350234
undo global data2,375,3361721171
checkpoint queue latch6,871,7631171116
session state list latch5,140281315
call allocation12,21418117
Real-time plan statistics latch45,619633
In memory undo latch305,452514


Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latchktiFlush: child010
In memory undo latchktiFlushMe010
In memory undo latchkturbk011
Real-time plan statistics latchkeswxAddNewPlanEntry033
cache buffers chainskcbchg1: mod cr pin0837
cache buffers chainskcbzgb: scan from tail. nowait0560
cache buffers chainskcbgtcr: fast path (cr pin)02280
cache buffers chainskcbnew: new latch again0156
cache buffers chainskcbgcur_2083
cache buffers chainskcbgtcr: fast path073
cache buffers chainskcbivbr039
cache buffers chainskcbrls: fast release0340
cache buffers chainskcbbxsv011
cache buffers chainskcbchg1: clear MS bit0111
cache buffers chainskcbgcur_40111
cache buffers chainskcbget: fast exchange011
cache buffers chainskcbzibmlt: multi-block read: nowait010
cache buffers lru chainkcbzgws0220
cache buffers lru chainkcbo_link_q0154
cache buffers lru chainkcbzgb0211
call allocationksuxds010
checkpoint queue latchkcbkubc_4011
object queue header operationkcbo_unlink_q042
object queue header operationkcbo_link_q010
redo allocationkcrfw_redo_gen: redo allocation 10100
row cache objectskqrpre: find obj075
row cache objectskqreqd: reget040
row cache objectskqrso013
session state list latchkpseqd0100
session state list latchkpscad037
shared poolkghalo0453
shared poolkghupr10347
shared poolkghalp020
simulator hash latchkcbsacc: lookup dba011
simulator lru latchkcbs_simulate: simulate set050
undo global datakturax010


Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgn1 623630
Library Cachekglpin1 41900
Library Cachekglpnal1 901610
Library Cachekglpndl1 951290
Cursor Pinkksfbc [KKSCHLFSP2]560
Library Cachekglget2 2360
Library Cachekglhdgn2 106360
Library Cachekgllkdl1 85360
Library Cachekglget1 1330
Library Cachekgllkc1 57320
Cursor PinkksLockDelete [KKSCHLPIN6]200


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
PROCESSINGPROCESSINGST_MST TABLE167,312,44811.17
PRODUCTIONPRODUCTIONKCL_PO_HITS TABLE110,442,4487.37
EXPIMPEXPIMPWAREHOUSE_REC TABLE77,043,9685.14
PRODUCTIONPRODUCTIONITEM_PK INDEX63,062,3044.21
PRODUCTIONWAGES_REORG0I_SNAP$_WAGES_SHEET_MV INDEX62,659,0724.18


Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
PRODUCTIONWAGESOPR_WAGES_EMP_DTL TABLE918,22489.99
PRODUCTIONPRODUCTIONTBLPLANPICS TABLE10,6681.05
PRODUCTIONPICTURESUKORDPIC TABLE6,3380.62
PRODUCTIONWAGESCUT_SUPD_IDX INDEX2,7260.27
HRMHRMDAILY_ATTENDANCE TABLE2,5910.25


Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
PRODUCTIONWAGESOPR_WAGES_EMP_DTL TABLE13,03513.42
PRODUCTIONPRODUCTIONTBLPLANPICS TABLE10,66810.99
PRODUCTIONPICTURESUKORDPIC TABLE6,3386.53
PRODUCTIONWAGESCUT_SUPD_IDX INDEX2,7072.79
HRMHRMDAILY_ATTENDANCE TABLE2,5802.66


Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
PRODUCTIONWAGESOPR_WAGES_EMP_DTL TABLE13,03513.42
PRODUCTIONPRODUCTIONTBLPLANPICS TABLE10,66810.99
PRODUCTIONPICTURESUKORDPIC TABLE6,3386.53
PRODUCTIONWAGESCUT_SUPD_IDX INDEX2,7072.79
HRMHRMDAILY_ATTENDANCE TABLE2,5802.66


Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
PRODUCTIONWAGES_REORG0I_SNAP$_WAGES_SHEET_MV INDEX156,5836.02
PRODUCTIONWAGES_REORG0DATED_WGS2 INDEX152,4295.86
PRODUCTIONWAGES_REORG0PLAN_WGS2 INDEX149,4975.75
PRODUCTIONWAGES_REORG0OPRATION_ID_WGS2 INDEX116,5214.48
PRODUCTIONWAGES_REORG0UNIT_NUM_WGS2 INDEX104,8924.04


Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
PRODUCTIONWAGES_REORG0DATED_WGS2 INDEX17,5557.93
PRODUCTIONWAGES_REORG0I_SNAP$_WAGES_SHEET_MV INDEX12,5345.66
PRODUCTIONWAGES_REORG0PLAN_WGS2 INDEX11,1135.02
PRODUCTIONWAGES_REORG0OPRATION_ID_WGS2 INDEX8,8504.00
PRODUCTIONWAGES_REORG0UNIT_NUM_WGS2 INDEX8,3773.78


Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1701927951_0TABLE PARTITION9331.96


Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
PRODUCTIONWAGES_REORG0TBLPLANSHEET_PK INDEX60514.48
DYEDYEVDTL_CODE_IDX INDEX1934.62
PRODUCTIONWAGESPKSUPRECNO INDEX1263.02
PRODUCTIONPRODUCTIONITEM_PK INDEX591.41
PRODUCTIONWAGES_REORG0PLAN_NOA INDEX110.26


Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
PRODUCTIONWAGES_REORG0I_SNAP$_WAGES_SHEET_MV INDEX21,016,36817.92
PRODUCTIONWAGES_REORG0OPRATION_ID_WGS2 INDEX20,845,58417.78
PRODUCTIONWAGES_REORG0DATED_WGS2 INDEX17,214,14414.68
PRODUCTIONWAGES_REORG0PLAN_WGS2 INDEX14,269,92012.17
PRODUCTIONWAGES_REORG0UNIT_NUM_WGS2 INDEX13,823,88811.79


Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
PRODUCTIONPRODUCTIONOPR_WAGES_EMP_MASTER_PK INDEX20930.78
PRODUCTIONWAGESOPR_WAGE_EMP_DTL_01 INDEX19528.72
PRODUCTIONWAGESOPR_MAN_DTL_IND INDEX8913.11
PRODUCTIONWAGESEMPCODE_NR INDEX7210.60
SYSSYSTEMDBMS_LOCK_ALLOCATED TABLE284.12


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
SYSSYSTEMI_SCHEDULER_JOB4 INDEX12453.22
SYSSYSTEMDBMS_LOCK_ALLOCATED TABLE4218.03
PRODUCTIONPRODUCTIONOPR_WAGES_EMP_MASTER_PK INDEX3012.88
SYSSYSTEMSNAP_LOADERTIME$ TABLE156.44
SYSSYSTEMDEPENDENCY$ TABLE135.58


Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control650.000 21
dc_files500.000 050
dc_global_oids4,9510.000 0515
dc_histogram_data924,6460.000 7516,394
dc_histogram_defs634,6230.020 7225,242
dc_object_grants1,914,1760.020 013,133
dc_objects1,201,4430.080 78635,909
dc_profiles4,7600.000 05
dc_rollback_segments4,9060.000 0111
dc_segments138,3980.000 07,144
dc_sequences7880.000 78817
dc_table_scns12,2320.010 77870
dc_tablespaces4,894,1840.000 019
dc_users6,904,1440.000 11,712
global database name4,7850.000 02
outstanding_alerts920.000 016
qmtmrciq_cache_entries90.000 088
qmtmrctn_cache_entries90.000 01
qmtmrctq_cache_entries90.000 01
sch_lj_oids9340.110 061



Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS2,9760.500 00
APP CONTEXT0 4200.0000
BODY12,4880.001,273,1050.0000
CLUSTER1010.001010.0000
DBLINK2,9560.000 00
EDITION1,5060.002,9970.0000
HINTSET OBJECT1618.751637.5000
PIPE3,7100.165,1490.1200
QUEUE1,1860.0013,1930.0000
SCHEMA3,6600.050 00
SECURITY CLASS4860.004860.0000
SQL AREA80,7673.2844,562,9400.025921,089
SQL AREA BUILD3,47480.570 00
SQL AREA STATS3,57686.073,57686.0700
SUBSCRIPTION120.00120.0000
SUMMARY3,9930.003,6651.1542164
TABLE/PROCEDURE382,4960.332,504,1080.031200
TRIGGER1,6650.2415,2010.0420
XDB ACL880.00880.0000
XDB CONFIG140.00140.0000
XML SCHEMA700.001260.0000



Back to Top

Memory Statistics

Back to Top

Memory Dynamic Components

ComponentBegin Snap Size (Mb)Current Size (Mb)Min Size (Mb)Max Size (Mb)Oper CountLast Op Typ/Mod
ASM Buffer Cache0.000.000.000.000STA/
DEFAULT 16K buffer cache0.000.000.000.000STA/
DEFAULT 2K buffer cache0.000.000.000.000STA/
DEFAULT 32K buffer cache0.000.000.000.000STA/
DEFAULT 4K buffer cache0.000.000.000.000STA/
DEFAULT 8K buffer cache0.000.000.000.000STA/
DEFAULT buffer cache25,600.0025,600.0025,600.0025,600.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target28,672.0028,672.0028,672.0028,672.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target43,008.0043,008.0043,008.0043,008.000STA/
Shared IO Pool256.00256.00256.00256.000STA/
java pool1,792.001,792.001,792.001,792.000STA/
large pool1,024.001,024.001,024.001,024.000STA/
shared pool13,312.0013,312.0013,312.0013,312.000STA/
streams pool512.00512.00512.00512.000STA/


Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to 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
BOther1,777.27 1.931.5419139922922
Freeable782.810.000.890.367 880880
PL/SQL71.5430.670.080.1425920920
SQL38.889.570.040.163459898881
EOther1,866.81 1.921.5119139970970
Freeable824.880.000.890.459 923923
SQL83.8143.640.091.0530459946932
PL/SQL75.3232.010.080.1423968968


Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers27,111,981,056 
Fixed Size2,262,656 
Redo Buffers151,117,824 
Variable Size58,250,496,384 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory1,783.141,783.140.00
largefree memory1,016.191,016.190.00
sharedKGLDA158.03157.00-0.65
sharedKGLH03,365.673,365.710.00
sharedKGLHD580.18573.62-1.13
sharedSQLA4,820.804,884.351.32
shareddb_block_hash_buckets178.00178.000.00
sharedfree memory3,233.263,170.01-1.96
streamsfree memory509.30509.300.00
 buffer_cache25,600.0025,600.000.00
 fixed_sga2.162.160.00
 log_buffer144.12144.120.00
 shared_io_pool256.00256.000.00


Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session TypeFirst LogonCPU time(s)User IO Wait time(s)SYS IO Wait time(s)
QMON Slaves0106 15:57:080.170.000.00
QMON Coordinator0106 15:56:580.050.000.00


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 Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

Apply NameCoord Txns RcvdCoord Txns AppliedCoord Txns RollbkdCoord Wait Deps%Coord Wait Comit%Server Mesgs AppliedServer Dequeue Time(s)Server Apply Time(s)Reader Dequeue MesgsReader Lag (s)
STREAMS_APPLY 0000.000.0000.000.000 


Back to Streams Statistics
Back to Top

Streams Apply Rate

Apply NameCoord Txns Rcvd/secCoord Txns Appl/secCoord Txns Rbk/secServer Msgs Appl/secServer Dequeue Time/msgServer Apply Time/msgReader Dequeue Msgs/sec
STREAMS_APPLY 0.000.000.000.00  0.00


Back to Streams Statistics
Back to Top

Buffered Queues

Queue NameEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
STRMADMIN.STREAMS_APPLY_Q(94826) 00.0000.0000.00 


Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

Subscriber/QueueEnq MsgsEnq Msgs/secDeq MsgsDeq Msgs/secSpill MsgsSpill Msgs/sec%Spill Msgs
STREAMS_APPLY(101)/STRMADMIN.STREAMS_APPLY_Q 00.0000.0000.00 


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

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(13069) 00  0.000.00  
SYSMAN.MGMT_NOTIFY_Q(110503) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(110173) 61610.000.000.010.020.000.00


Back to Streams Statistics
Back to Top

Persistent Queues Rate

Queue NameEnqueue Msgs/secDequeue Msgs/secAvg Enqueue sec / msgAvg Dequeue sec / msg
SYS.ALERT_QUE(13069) 0.000.00  
SYSMAN.MGMT_NOTIFY_Q(110503) 0.000.00  
SYSMAN.MGMT_TASK_Q(110173) 0.020.020.000.00


Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE 000   
ORADB11_3938_KLASH(41)/SYS.ALERT_QUE 0000.000.000.00


Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

Avg Total ConnectionsAvg Active ConnectionsAvg Total Shared SrvrsAvg Active Shared SrvrsAvg Total DispatchersAvg Active Dispatchers
001010


Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per SecDisp Queue Per SecServer Msgs/SecServer KB/SecCommon Queue TotalDisp Queue TotalServer Total MsgsServer Total(KB)
0000.000000


Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
3,6130.00100.000.000.00


Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,6130.00100.0000 


Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
_optimizer_adaptive_cursor_sharingFALSE  
_optimizer_extended_cursor_sharingNONE  
_optimizer_extended_cursor_sharing_relNONE  
audit_file_dest/u01/app/oracle/admin/klash/adump  
audit_sys_operationsFALSE  
audit_trailNONE  
compatible11.2.0.4.0  
control_files/u01/app/oracle/oradata/klash/control01.ctl, /u01/app/oracle/fast_recovery_area/klash/control02.ctl  
cursor_sharingEXACT  
db_block_size8192  
db_domain    
db_nameklash  
db_recovery_file_dest/u01/app/oracle/fast_recovery_area  
db_recovery_file_dest_size4385144832  
db_writer_processes12  
diagnostic_dest/u01/app/oracle  
disk_asynch_ioFALSE  
dispatchers(PROTOCOL=TCP) (SERVICE=klashXDB)  
filesystemio_optionsSETALL  
job_queue_processes1000  
memory_max_target85899345920  
memory_target75161927680  
open_cursors10000  
pga_aggregate_target0  
plsql_warningsDISABLE:ALL  
processes2000  
remote_login_passwordfileEXCLUSIVE  
sec_case_sensitive_logonFALSE  
sessions3024  
sga_target0  
undo_tablespaceUNDOTBS1  


Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files/u01/app/oracle/fast_recovery_area/klash/control02.ctl  
/u01/app/oracle/oradata/klash/control01.ctl  


Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.


Back to Top

End of Report