WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
WZOL3239828958wzol106-11月-13 23:1111.2.0.3.0NO

Host NamePlatformCPUsCoresSocketsMemory (GB)
db-m4-85Linux x86 64-bit 32 16 2 31.27

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1917401-12月-13 10:00:5784 1.4
End Snap:1917801-12月-13 12:00:45263 1.6
Elapsed:  119.80 (mins)  
DB Time:  12,414.01 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 11,776M 11,776MStd Block Size: 8K
Shared Pool Size: 3,136M 3,136MLog Buffer: 18,868K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 103.6 31.7 1.34 1.49
DB CPU(s): 1.6 0.5 0.02 0.02
Redo size: 137,492.0 42,085.6  
Logical reads: 197,369.4 60,413.8  
Block changes: 473.2 144.8  
Physical reads: 7,750.5 2,372.4  
Physical writes: 19.1 5.8  
User calls: 69.7 21.3  
Parses: 16.2 5.0  
Hard parses: 0.1 0.0  
W/A MB processed: 11.8 3.6  
Logons: 0.4 0.1  
Executes: 77.1 23.6  
Rollbacks: 0.0 0.0  
Transactions: 3.3   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 97.82
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.64Soft Parse %: 99.29
Execute to Parse %: 78.93Latch Hit %: 98.90
Parse CPU to Parse Elapsd %: 4.40% Non-Parse CPU: 99.70

Shared Pool Statistics

BeginEnd
Memory Usage %: 61.69 63.50
% SQL with executions>1: 93.91 94.17
% Memory for SQL w/exec>1: 91.33 93.40

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
direct path read177,948277,210155837.22User I/O
log file sync18,47997,535527813.09Commit
db file sequential read31,08947,29615216.35User I/O
DB CPU 11,345 1.52 
enq: KO - fast object checkpoint4937,484151801.00Application

Host CPU (CPUs: 32 Cores: 16 Sockets: 2)

Load Average BeginLoad Average End%User%System%WIO%Idle
2.05 116.54 4.6 0.2 33.5 95.1
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
4.8 98.0 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 32,022.3 32,022.3
SGA use (MB): 15,680.0 15,680.0
PGA use (MB): 758.1 1,756.5
% Host Mem used for SGA+PGA: 51.33 54.45

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time638,887.5885.78
DB CPU11,344.861.52
PL/SQL execution elapsed time2,040.160.27
parse time elapsed1,192.990.16
hard parse elapsed time1,156.640.16
PL/SQL compilation elapsed time476.830.06
hard parse (sharing criteria) elapsed time22.440.00
connection management call elapsed time20.910.00
sequence load elapsed time9.690.00
hard parse (bind mismatch) elapsed time1.410.00
failed parse elapsed time0.090.00
repeated bind elapsed time0.050.00
DB time744,840.87 
background elapsed time39,008.67 
background cpu time124.36 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME1,170,560 
IDLE_TIME22,806,724 
IOWAIT_TIME8,020,770 
NICE_TIME158 
SYS_TIME52,292 
USER_TIME1,111,215 
LOAD2117
VM_IN_BYTES2,301,952 
VM_OUT_BYTES210,415,616 
PHYSICAL_MEMORY_BYTES33,577,840,640 
NUM_CPUS32 
NUM_CPU_CORES16 
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
01-12月 10:00:572.05     
01-12月 10:30:207.995.975.680.2794.0320.88
01-12月 11:00:0351.815.285.060.1994.7234.14
01-12月 11:30:5582.315.044.750.2594.9642.49
01-12月 12:00:45116.543.142.940.1796.8636.12

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
User I/O225,1390330,977147044.44
Commit18,479097,535527813.09
DB CPU  11,345 1.52
Application2,11109,79946421.32
Configuration563774,61681990.62
Other4,309844,0349360.54
Concurrency5,15501,5372980.21
System I/O73701,41319170.19
Administrative202031017100.03
Network345,5250300.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
direct path read177,9480277,21015587.5837.22
log file sync18,479097,53552780.7913.09
db file sequential read31,089047,29615211.326.35
enq: KO - fast object checkpoint49307,484151800.021.00
db file scattered read5,58004,1637460.240.56
reliable message4,164863,7869090.180.51
log file switch completion9903,627366350.000.49
enq: TX - row lock contention7302,090286330.000.28
read by other session1,04002,02619480.040.27
control file sequential read73501,41119190.030.19
buffer busy waits1,17007846700.050.11
enq: TX - index contention309074924250.010.10
log buffer space240652271860.000.09
undo segment extension4331003377770.020.05
direct path write35302617400.020.04
enq: CR - block range reuse ckpt32024375970.000.03
enq: RO - fast object reuse32022470140.000.03
switch logfile command202031017100.000.03
db file parallel read180179180.000.00
Parameter File I/O20421730.000.00
enq: JD - contention20420950.000.00
SQL*Net more data to client6,8510300.290.00
library cache: mutex X2,8190210.120.00
kfk: async disk IO20210240.000.00
cursor: pin S wait on X2015170.000.00
Disk file operations I/O9,1090000.390.00
SQL*Net message to client338,38000014.410.00
SQL*Net break/reset to client1,5130000.060.00
latch: shared pool3850000.020.00
latch free290040.000.00
latch: redo allocation200010.000.00
latch: cache buffers chains4640000.020.00
SQL*Net more data from client2940000.010.00
CSS initialization10030.000.00
latch: cache buffers lru chain40000.000.00
SQL*Net message from client338,3470713,680210914.41 
jobq slave wait51,0119625,2204942.17 
KSV master wait6047090.00 
PL/SQL lock timer1100110020.00 

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg time
control file sequential read9,277013,00414020.4033.34
log file parallel write6,27306,71010700.2717.20
db file parallel write31,65306,4332031.3516.49
enq: CF - contention6103,114510520.007.98
control file parallel write1,75302,99417080.077.68
db file sequential read92601,71518520.044.40
log file sequential read588082514030.032.12
log file sync129077760230.011.99
enq: CR - block range reuse ckpt470510108570.001.31
change tracking file synchronous read112043338630.001.11
direct path write198034017160.010.87
reliable message437452114820.020.54
change tracking file synchronous write112020318100.000.52
log buffer space3043142720.000.11
log file switch completion2036178370.000.09
Log archive I/O623030480.030.08
buffer busy waits1502919430.000.07
ASM file metadata operation6,00002850.260.07
enq: JD - contention2027133130.000.07
log file single write1602314690.000.06
os thread startup518011210.020.03
kfk: async disk IO12097690.000.02
direct path read20315520.000.01
LNS wait on SENDREQ5,8350100.250.00
CSS initialization1280140.010.00
CSS operation: action1280010.010.00
Disk file operations I/O1,3010000.060.00
CSS operation: query7680000.030.00
latch: shared pool1080000.000.00
ADR block file write100040.000.00
ADR block file read320010.000.00
SQL*Net break/reset to client200140.000.00
latch: call allocation1350000.010.00
db file async I/O submit20,0650000.850.00
latch free1590000.010.00
asynch descriptor resize907100000.040.00
LGWR wait for redo copy1270000.010.00
latch: redo allocation50010.000.00
latch: cache buffers lru chain320000.000.00
SQL*Net more data from client40000.000.00
rdbms ipc message39,05487128,38032871.66 
class slave wait1,943038,416197720.08 
Space Manager: slave idle wait7,1388833,33946710.30 
DIAG idle wait14,56810014,58310010.62 
dispatcher timer1221007,320600020.01 
Streams AQ: qmn coordinator idle wait522507,310140050.02 
Streams AQ: qmn slave idle wait26107,310280090.01 
wait for unread message on broadcast channel7,3011007,30810010.31 
ASM background timer2,07707,30835180.09 
pmon timer2,559927,30628550.11 
shared server idle wait2431007,290300010.01 
smon timer12006,605550380.01 
LNS ASYNC end of log11,275486,5725830.48 
KSV master wait1,186023200.05 
SQL*Net message from client1,2820430.05 

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 read4877.16.310.46.3    
ADR block file write15  80.020.0    
ADR file lock18100.0       
ARCH wait for archivelog lock47100.0       
ASM file metadata operation610498.01.3.0 .0.1.3.1
CSS initialization136  34.665.4    
CSS operation: action13628.766.25.1     
CSS operation: query81698.81.2      
Disk file operations I/O10.5K99.6.2.0.1.1.0  
LGWR wait for redo copy12799.2.8      
LNS wait on SENDREQ591899.2.4.2.1.1   
Log archive I/O62315.936.416.210.09.56.34.71.1
Parameter File I/O2      50.050.0
SQL*Net break/reset to client155999.2.1.1.1 .1.4 
SQL*Net message to client340K100.0       
SQL*Net more data from client298100.0       
SQL*Net more data to client685599.8     .2 
asynch descriptor resize948100.0       
buffer busy waits118696.7.4    .12.8
buffer deadlock36100.0       
change tracking file synchronous read1151.7 1.7.9.9 18.376.5
change tracking file synchronous write1154.31.7 1.7.91.741.747.8
control file parallel write177824.41.22.62.74.43.419.941.3
control file sequential read10.2K21.02.12.12.63.16.030.932.2
cursor: pin S4100.0       
cursor: pin S wait on X2      100.0 
db file async I/O submit20.5K100.0       
db file parallel read18   16.711.116.727.827.8
db file parallel write32.4K24.55.56.68.612.115.320.66.9
db file scattered read558029.93.45.310.46.67.419.817.3
db file sequential read32.5K4.91.96.413.35.24.930.233.3
direct path read183K1.91.42.03.46.07.637.839.9
direct path write5604.63.03.48.410.011.129.130.4
direct path write temp1100.0       
enq: CF - contention65 1.51.5  1.57.787.7
enq: CR - block range reuse ckpt805.06.3  5.03.823.856.3
enq: HW - contention1100.0       
enq: JD - contention4       100.0
enq: JS - queue lock1100.0       
enq: KO - fast object checkpoint498.2 .8.41.41.813.781.7
enq: RO - fast object reuse32  3.16.331.39.412.537.5
enq: SQ - contention6100.0       
enq: TX - index contention30925.2  .6.61.020.152.4
enq: TX - row lock contention746.8  4.1  9.579.7
kfk: async disk IO1421.4    7.150.021.4
latch free18895.2.5.51.1.52.1  
latch: In memory undo latch1100.0       
latch: active service list3100.0       
latch: cache buffers chains48299.8.2      
latch: cache buffers lru chain3697.22.8      
latch: call allocation14298.6.7 .7    
latch: enqueue hash chains9100.0       
latch: object queue header operation6100.0       
latch: redo allocation2564.028.08.0     
latch: row cache objects3100.0       
latch: shared pool50495.02.2 2.2.6   
library cache: mutex X285493.3.2  6.3.3  
log buffer space27      3.796.3
log file parallel write635624.23.73.34.76.15.628.324.1
log file sequential read5887.87.83.72.73.94.132.537.4
log file single write1625.0    12.518.843.8
log file switch completion101       100.0
log file sync18.7K4.1.8.81.11.51.417.872.5
os thread startup546    35.762.61.6 
read by other session11565.92.81.11.71.83.444.638.8
reliable message46667.9.1.1.0.1.291.6 
switch logfile command2       100.0
undo segment extension4553.7   3.53.389.5 
ASM background timer211724.01.2.4.1.3.11.971.9
DIAG idle wait15K      100.0 
KSV master wait119890.27.2.3.1.2.21.3.6
LNS ASYNC end of log11.5K3.61.01.21.52.33.586.9 
PL/SQL lock timer1      100.0 
SQL*Net message from client340.5K54.911.74.02.53.35.514.04.2
Space Manager: slave idle wait7227.4.3.2.0.1.02.596.5
Streams AQ: qmn coordinator idle wait53650.0      50.0
Streams AQ: qmn slave idle wait268       100.0
class slave wait197249.91.11.41.1.91.06.138.5
dispatcher timer126       100.0
jobq slave wait52.2K.0.0.0.0.1.199.8 
pmon timer2627.2.0.0.2.2.33.195.9
rdbms ipc message40K3.51.0.4.3.81.147.045.9
shared server idle wait250       100.0
smon timer120.82.51.7 .8 9.285.0
wait for unread message on broadcast channel7504      100.0 

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
ASM file metadata operation1899.6.1.1.1.0  .1
Log archive I/O3294.23.7.8.2  .5.6
Parameter File I/O1  50.0    50.0
SQL*Net break/reset to client799.6.4      
SQL*Net more data to client1199.8  .1.0   
buffer busy waits197.1    .1 2.8
change tracking file synchronous read485.23.54.31.72.66.123.553.0
change tracking file synchronous write5010.44.324.37.06.1 1.746.1
control file parallel write50238.82.64.56.14.62.18.333.0
control file sequential read359436.99.310.26.73.51.34.327.9
cursor: pin S wait on X2    50.050.0  
db file parallel read644.4 5.6 16.75.65.622.2
db file parallel write753772.513.06.31.1.2.02.64.3
db file scattered read124062.97.96.63.81.2.32.414.9
db file sequential read11.4K36.57.310.17.13.62.14.828.5
direct path read74K22.38.59.28.57.54.02.737.2
direct path write20940.510.08.05.52.72.98.222.1
enq: CF - contention54.61.5 3.13.1  87.7
enq: CR - block range reuse ckpt2020.02.57.53.810.0 1.355.0
enq: JD - contention1      25.075.0
enq: KO - fast object checkpoint824.61.2.83.61.46.62.878.9
enq: RO - fast object reuse650.0 3.1 3.16.36.331.3
enq: TX - index contention9727.52.95.22.66.52.911.341.1
enq: TX - row lock contention1110.8 2.71.41.44.15.474.3
kfk: async disk IO828.67.114.314.37.17.17.114.3
log buffer space1    3.7  96.3
log file parallel write187347.65.57.77.95.51.71.222.9
log file sequential read21030.18.010.48.83.61.73.234.2
log file single write337.56.3  6.36.3 43.8
log file sync45549.71.62.14.44.55.26.566.0
os thread startup998.41.6      
read by other session57016.710.513.412.26.52.04.834.0
reliable message42738.4.4.81.42.786.2  
undo segment extension40710.53.33.33.33.376.3  

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
ASM file metadata operation799.9.1.0     
Log archive I/O499.4.5 .2    
Parameter File I/O150.0 50.0     
buffer busy waits3397.2.2.4.21.3.8  
change tracking file synchronous read6147.025.219.16.11.7.9  
change tracking file synchronous write5353.924.320.9.9    
control file parallel write58767.016.114.02.8.1.1  
control file sequential read284472.114.89.43.1.5.1  
db file parallel read477.816.75.6     
db file parallel write139595.73.4.9.0.0.0  
db file scattered read83285.18.84.51.5.1.1  
db file sequential read927171.515.29.13.7.5.1  
direct path read68.1K62.821.713.22.1.1.0  
direct path write12477.913.67.01.6    
enq: CF - contention4812.34.618.57.718.513.810.813.8
enq: CR - block range reuse ckpt4445.03.813.815.016.35.01.3 
enq: JD - contention325.050.0  25.0   
enq: KO - fast object checkpoint39221.16.815.520.126.18.02.2.2
enq: RO - fast object reuse1068.89.43.16.33.19.4  
enq: TX - index contention12758.918.115.56.51.0   
enq: TX - row lock contention5125.78.117.618.96.810.86.85.4
kfk: async disk IO285.77.17.1     
log buffer space263.7 7.414.840.733.3  
log file parallel write145677.112.18.81.8.1.1  
log file sequential read20165.821.110.72.4    
log file single write756.325.018.8     
log file switch completion101  2.03.037.657.4  
log file sync12.4K34.020.527.814.02.11.3.3 
read by other session39366.016.112.54.9.5   
switch logfile command1      50.050.0

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: CF - contention986.213.8     
enq: KO - fast object checkpoint199.8.2     
enq: TX - row lock contention494.64.11.4    
switch logfile command150.050.0     

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
wzol671,02310,09655,5031,314,275
SYS$USERS40,3371,19582104,140
SYS$BACKGROUND001171
primary0000
wzolXDB0000

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
wzol 20488531257924971465003436423
SYS$USERS 2025318370262471220318870
SYS$BACKGROUND 24282058546400058361

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
328,750.262821,165.7844.140.0549.81gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
122,431.35130941.7816.440.1149.46c412fnd0cdmc0 w3wp.exe SELECT COUNT(1) FROM IF_SALESO...
57,399.14169339.647.710.0944.39cwz9p369sva5w w3wp.exe SELECT COUNT(1) FROM SALESORDE...
52,739.7167787.167.080.0756.82837svcmjhsf06 WZOLService.WindowsService.exe SELECT SALESORDER_BILLDETAIL.M...
7,402.260 0.990.3390.346mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
6,956.448869.560.930.1160.43dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
6,643.301,3624.880.8924.1770.06fp6r6v4ruj77h WZOLService.WindowsService.exe begin Picking_Bill_Order_Sure_...
6,000.557857.220.810.1042.72bypmfr5wammfu WZOLService.WindowsService.exe Select WAYBILL_HANDINGBATCH.BA...
4,789.149532.130.640.0961.8181pj6yhd2qp5k WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
3,948.875789.770.530.1282.29572pfbk8f3x4y WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...

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
1,605.451,3621.1814.156,643.3024.1770.06fp6r6v4ruj77h WZOLService.WindowsService.exe begin Picking_Bill_Order_Sure_...
1,595.671,3571.1814.071,630.1797.881.52d6fx4dcuz5a30 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
972.793131.388.571,206.9680.603.758q1r67mcuxg6f WZOLService.WindowsService.exe begin Sorting_Bill_Sure30(AS_S...
962.632933.198.49970.4699.190.003rfa3jdts90xg WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
721.524991.456.36727.8399.130.8398t4azsnjmvp0 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
654.506041.085.771,456.1044.9538.588ht8yrs78xj49 WZOLService.WindowsService.exe begin Create_Waybillpackage30(...
650.556041.085.73751.0486.628.67578kvyc0rcmm4 WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
641.311,0860.595.65671.8895.450.00cg6hra1s3mg6v Mic.DataChangeServer.exe SELECT * FROM (SELECT S.SALESO...
583.955591.045.15584.1699.960.00003090gzr56w2 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
447.587540.593.95447.9199.930.00fg6k4m6t4cgx7   SELECT KQ.CXFLAG, KQ.WAREHOUSE...
444.042142.073.911,389.2631.9660.556182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...
441.461,0400.423.89464.6295.024.860tnjgjztc81h2 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
366.522921.263.232,124.7817.2573.45a1bq05mx2wp39 WZOLService.WindowsService.exe begin Picking_Bill_Consign30(A...
359.722801.283.17360.8199.700.28ah0gcgvg8d726   INSERT INTO SALESORDER_BILL_IN...
339.952911.173.00381.8989.0210.71f319mcpzrcydh WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
318.702,3710.132.81319.2799.820.000bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
281.841931.462.48698.1140.3746.027d9bcscmbwshd WZOLService.WindowsService.exe begin Picking_Bill_Sure30(AS_S...
274.295950.462.42323.6184.7615.209rdgpzbfxaz5w WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
263.903180.832.33304.8286.580.00g0g00yjvb0f5n WZOLService.WindowsService.exe Select nvl(z.Entering_Weight, ...
219.301931.141.93225.2797.352.6184k2mp6rgxpy6 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
212.441119.311.872,564.638.2882.5957a37zd77u4yv WZOLService.WindowsService.exe begin Purchase_Returnbill_Outs...
194.171019.421.71194.2199.980.007urcp0fzuzgcc WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
186.132800.661.64186.2099.960.00ags6vx459vc0s PL/SQL Developer INSERT INTO SALESORDER_CONSIGN...
173.073190.541.53173.1599.950.002vq7yv9nn1b0r WZOLService.WindowsService.exe Select :reprintflag, pr.outpur...
161.102820.571.42328,750.260.0549.81gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
158.291,7860.091.40158.5799.820.00ckk296gsdch3b Mic.DataChangeServer.exe Select Systemid, Availablesale...
141.839160.151.25141.8799.970.001hyv78p73sby6 WZOLService.WindowsService.exe SELECT SUM(B.PACKAGE_QTY) FROM...
137.131101.251.21523.0526.2267.217wahvsbqhx79c WZOLService.WindowsService.exe begin Salesorder_Collect31(AS_...
133.601301.031.18122,431.350.1149.46c412fnd0cdmc0 w3wp.exe SELECT COUNT(1) FROM IF_SALESO...
131.251101.191.16153.1185.7314.245hwdf0wvghfcw WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...

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
163,737.47282580.6349.17328,750.260.0549.81gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
60,556.92130465.8218.18122,431.350.1149.46c412fnd0cdmc0 w3wp.exe SELECT COUNT(1) FROM IF_SALESO...
29,964.5467447.239.0052,739.710.0756.82837svcmjhsf06 WZOLService.WindowsService.exe SELECT SALESORDER_BILLDETAIL.M...
25,478.05169150.767.6557,399.140.0944.39cwz9p369sva5w w3wp.exe SELECT COUNT(1) FROM SALESORDE...
6,687.270 2.017,402.260.3390.346mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
4,654.281,3623.421.406,643.3024.1770.06fp6r6v4ruj77h WZOLService.WindowsService.exe begin Picking_Bill_Order_Sure_...
4,203.498525.441.266,956.440.1160.43dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
3,249.635649.930.983,948.870.1282.29572pfbk8f3x4y WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
3,157.0813,157.080.953,157.300.0199.996uhvyfmmqfkgr   SELECT COUNT(1) FROM WAYBILL_P...
2,960.039328.890.894,789.140.0961.8181pj6yhd2qp5k WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...

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
186,120,3511,362136,652.2413.126,643.3024.270.1fp6r6v4ruj77h WZOLService.WindowsService.exe begin Picking_Bill_Order_Sure_...
142,316,011214665,028.0910.031,389.263260.56182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...
142,195,9241,040136,726.8510.02464.62954.90tnjgjztc81h2 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
138,147,083314,456,357.529.741,206.9680.63.88q1r67mcuxg6f WZOLService.WindowsService.exe begin Sorting_Bill_Sure30(AS_S...
135,445,031294,670,518.319.55970.4699.203rfa3jdts90xg WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
130,206,9601,35795,952.079.181,630.1797.91.5d6fx4dcuz5a30 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
83,605,309193433,188.135.89698.1140.4467d9bcscmbwshd WZOLService.WindowsService.exe begin Picking_Bill_Sure30(AS_S...
82,571,448604136,707.705.82751.0486.68.7578kvyc0rcmm4 WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
82,558,401604136,686.095.821,456.1044.938.68ht8yrs78xj49 WZOLService.WindowsService.exe begin Create_Waybillpackage30(...
81,309,873595136,655.255.73323.6184.815.29rdgpzbfxaz5w WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
80,384,683559143,800.865.67584.161000003090gzr56w2 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
48,214,088292165,116.743.402,124.7817.273.5a1bq05mx2wp39 WZOLService.WindowsService.exe begin Picking_Bill_Consign30(A...
46,760,51549993,708.453.30727.8399.1.898t4azsnjmvp0 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
39,831,838291136,879.172.81381.898910.7f319mcpzrcydh WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
38,304,077280136,800.282.70186.201000ags6vx459vc0s PL/SQL Developer INSERT INTO SALESORDER_CONSIGN...
38,293,922280136,764.012.70360.8199.7.3ah0gcgvg8d726   INSERT INTO SALESORDER_BILL_IN...
37,205,7502,37115,692.012.62319.2799.800bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
31,721,663282112,488.172.24328,750.26049.8gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
28,202,490112,563,862.731.992,564.638.382.657a37zd77u4yv WZOLService.WindowsService.exe begin Purchase_Returnbill_Outs...
27,885,484169165,002.861.9770.751000apn3u2a6rx4s0 WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
26,946,478110244,967.981.9050.0810004y3n46d9brtxv WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
26,808,76931884,304.311.89304.8286.60g0g00yjvb0f5n WZOLService.WindowsService.exe Select nvl(z.Entering_Weight, ...
26,635,0351,08624,525.811.88671.8895.40cg6hra1s3mg6v Mic.DataChangeServer.exe SELECT * FROM (SELECT S.SALESO...
26,363,960193136,600.831.86225.2797.32.684k2mp6rgxpy6 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
26,290,222102,629,022.201.85194.2110007urcp0fzuzgcc WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
18,726,48677243,201.121.3234.9699.901q85jprkn4c32 WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
18,021,50931956,493.761.27173.1510002vq7yv9nn1b0r WZOLService.WindowsService.exe Select :reprintflag, pr.outpur...
15,358,622110139,623.841.08523.0526.267.27wahvsbqhx79c WZOLService.WindowsService.exe begin Salesorder_Collect31(AS_...
15,037,047110136,700.431.06153.1185.714.25hwdf0wvghfcw WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
31,455,378282111,543.8956.46328,750.260.0549.81gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
11,415,39613087,810.7420.49122,431.350.1149.46c412fnd0cdmc0 w3wp.exe SELECT COUNT(1) FROM IF_SALESO...
7,698,55567114,903.8113.8252,739.710.0756.82837svcmjhsf06 WZOLService.WindowsService.exe SELECT SALESORDER_BILLDETAIL.M...
4,209,68416924,909.377.5657,399.140.0944.39cwz9p369sva5w w3wp.exe SELECT COUNT(1) FROM SALESORDE...
1,136,5738142,071.632.046,956.440.1160.43dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
682,9405136,588.001.233,948.870.1282.29572pfbk8f3x4y WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
377,670941,963.330.684,789.140.0961.8181pj6yhd2qp5k WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
347,089749,584.140.626,000.550.1042.72bypmfr5wammfu WZOLService.WindowsService.exe Select WAYBILL_HANDINGBATCH.BA...
300,2573100,085.670.541,784.620.1170.63f9qxutrsfs9m6 WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
292,538648,756.330.533,482.250.1069.20830grrcnqx0ja WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...

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
95,72895,728130736.370.0019.04c412fnd0cdmc0 w3wp.exe SELECT COUNT(1) FROM IF_SALESO...
34,64234,642169204.980.006.89cwz9p369sva5w w3wp.exe SELECT COUNT(1) FROM SALESORDE...
13,99513,9950 0.002.786mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
9,2839,28381,160.380.001.85dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
5,8195,81951,163.800.001.16572pfbk8f3x4y WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
3,1063,1069345.110.000.6281pj6yhd2qp5k WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
2,8292,8297404.140.000.56bypmfr5wammfu WZOLService.WindowsService.exe Select WAYBILL_HANDINGBATCH.BA...
2,3972,3976399.500.000.48830grrcnqx0ja WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,7571,7571,3621.290.000.35fp6r6v4ruj77h WZOLService.WindowsService.exe begin Picking_Bill_Order_Sure_...
1,3921,39211,392.000.000.286uhvyfmmqfkgr   SELECT COUNT(1) FROM WAYBILL_P...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
20,14620,1461.002.0298.50as0uaw3pvcz1c   SELECT COUNT(*) FROM USER_OBJE...
11,11992,6748.331.53102.90cm5vu20fhtnq1   select /*+ connect_by_filterin...
7,8677,8671.000.28102.603hkxqb42macn7   SELECT S.SYSTEM_PREFIXION FROM...
3,69363,95017.327.4997.50gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
2,9972,9971.003.3630.668.9d1bcnr2fp1hqq   INSERT INTO IF_INVENTORY_AVAIL...
2,3711200.05319.2799.800bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
2,1892,1891.0020.311.698.4ghn9v5v7n3h10   UPDATE INVENTORY_OWNER B SET B...
2,18611,5145.270.50100.500k8522rmdzg4k   select privilege# from sysauth...
1,9251,9271.000.12103.20b9vkrdqqk15mr WZOLService.WindowsService.exe SELECT COUNT(1) FROM WAYBILL_P...
1,8091,7820.990.7376.20cumjq42201t37   select u1.user#, u2.user#, u3....

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2,18411,1191.87cm5vu20fhtnq1   select /*+ connect_by_filterin...
2,1732,1861.860k8522rmdzg4k   select privilege# from sysauth...
1,8091,7861.5547a50dvdgnxc2   update sys.job$ set failures=0...
1,8001,7811.54aq8yqxyyb40nn   update sys.job$ set this_date=...
1,7991,8091.54cumjq42201t37   select u1.user#, u2.user#, u3....
1,6651,6611.43awrr2c9hqf7p0   select sysdate+:"SYS_B_0"/:"SY...
1,5743,6931.35gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
9407,8670.813hkxqb42macn7   SELECT S.SYSTEM_PREFIXION FROM...
8401,7510.729b9cx124fxqah WZOLService.WindowsService.exe select count(:"SYS_B_00") from...
6286280.541hk6wj4jy065a   DELETE FROM INVENTORY_GOODSFOR...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
4,720,1173,6930.14gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,973,8251,7510.069b9cx124fxqah WZOLService.WindowsService.exe select count(:"SYS_B_00") from...
1,932,11870.067h38rm3myd747 WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,687,6351690.05apn3u2a6rx4s0 WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,405,6981100.044y3n46d9brtxv WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,165,0461050.049hy85jupdj6qt WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
1,151,6405050.04965myf8ddfzg8 WZOLService.WindowsService.exe SELECT SALESRETURN_INORDER.MOP...
1,072,3452520.03f1qpr4uk5rbtm WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...

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
003090gzr56w2 SELECT (case when plan_qty > return_qty then :"SYS_B_0" else :"SYS_B_1" end) FINISHFLAG, SALESRETURN_BILL.SYSTEMID, SALESRETURN_BILL.SALESRETURNBILLID, SALESRETURN_BILL.SALESRETURNBILLNO, SALESRETURN_BILL.SALESRETURNBILLBATCHID, SALESRETURN_BILL.SALESRETURNBILLBATCHNO, SALESRETURN_BILL.SALESORDERID, SALESRETURN_BILL.OUTERSALESORDERID, SALESRETURN_BILL.ORDERTYPEID, SALESRETURN_BILL.OLDSALESORDERID, SALESRETURN_BILL.OLDOUTSALESORDERID, SALESRETURN_BILL.POSID, SALESRETURN_BILL.OUTWAREHOUSEID, SALESRETURN_BILL.WAREHOUSEID, SALESRETURN_BILL.WAREHOUSEAREAID, SALESRETURN_BILL.CARGOSPACEID, SALESRETURN_BILL.SALESRETURNTYPEID, SALESRETURN_BILL.SALESRETURNREASONID, SALESRETURN_BILL.EXPRESSDELIVERYID, SALESRETURN_BILL.WAYBILLNO, SALESRETURN_BILL.PLAN_VARIETYQTY, SALESRETURN_BILL.PLAN_QTY, SALESRETURN_BILL.PLAN_PRICEAMOUNT, SALESRETURN_BILL.PLAN_SALEAMOUNT, SALESRETURN_BILL.PLAN_WEIGHT, SALESRETURN_BILL.RETURN_VARIETYQTY, SALESRETURN_BILL.RETURN_QTY , SALESRETURN_BILL.RETURN_PRICEAMOUNT, SALESRETURN_BILL.RETURN_SALEAMOUNT, SALESRETURN_BILL.RETURN_WEIGHT, SALESRETURN_BILL.DAMAGE_VARIETYQTY, SALESRETURN_BILL.DAMAGE_QTY, SALESRETURN_BILL.DAMAGE_PRICEMOUNT, SALESRETURN_BILL.DAMAGE_SALEAMOUNT, SALESRETURN_BILL.DAMAGE_WEIGHT, SALESRETURN_BILL.REMARK, SALESRETURN_BILL.CREATEDATE, SALESRETURN_BILL.CONFIRMDATE, SALESRETURN_BILL.SHELVEDATE, SALESRETURN_BILL.ACCOUNTDATE, SALESRETURN_BILL.CREATEUSERID, SALESRETURN_BILL.CONFIRMUSERID, SALESRETURN_BILL.SHELVEUSERID, SALESRETURN_BILL.ACCOUNTUSERID, SALESRETURN_BILL.INPUTFLAG, SALESRETURN_BILL.BILL_STATE, SALESRETURN_BILL.OLDBILL_STATE, SALESRETURN_BILL.STATE_DESC, salesreturn_inorder.RECEIVERNAME, salesreturn_inorder.RECEIVERMOBILE, salesreturn_inorder.RECEIVERPHONE, salesreturn_inorder.receiveraddress , dp.companyname dp, hz.companyname hz, salesreturn_bill.costlyflag, t.DELIVERNO, t.ownerid, t.shopid FROM SALESRETURN_BILL left join salesorder_bill t on t.mopocsales orderbillid = SALESRETURN_BILL.Oldsalesorderid left join base_company hz on hz.companyid = t.ownerid left join base_company dp on dp.companyid = t.shopid left join salesreturn_inorder on SALESRETURN_BILL.salesorderid=salesreturn_inorder.mopocsalesorderbillid where :"SYS_B_2" =:"SYS_B_3" and SALESRETURN_BILL.Salesorderid = :"SYS_B_4"
0bxgpsyhq71ds SELECT SYSTEMID, PICKINGBILLSOURCEID, PICKINGBILLDETAILID, PICKINGBILLID, PICKINGBILLNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, PICKINGTYPEID, MOPOCSALESORDERBILLDETAILID, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, OUTERSALESORDERBILLDETAILID, MOPOCSOURCEORDERBILLID, MOPOCSOURCEBILLDETAILID, OUTERSOURCEORDERBILLID, OUTERSOURCEBILLDETAILID, WAYBILLDETAILID, WAYBILLID, WAYBILLNO, DEPARTMENTID, OWNERID, DELIVERID, WAREHOUSEID, JXFQID, BOXNO, WAREHOUSEAREAID, CARGOSPACEID, INVENTORYCARGOSPACEID, INVENTORYOWNERID, SKUID, PRODUCTION_DATE, PACKED_DATE, WARRANTY_ENDDATE, WARRANTY, PRODUCTION_BATCHNUMBER, PICKING_QTY, PACKAGE_QTY, DIVERSITY_QTY, REMARK, QUALITYUSERID, QUALITYDATE, CREATEUSERID, CREATEDATE, UPDATEUSERID, UPDATEDATE, BILL_STATE, OLDBILL_STATE, STATE_DESC, RECORDTIME, TASKSTATE FROM IF_PICKING_BILLSOURCE WHERE TASKSTATE=:"SYS_B_0" AND OWNERID<>:"SYS_B_1" AND OWNERID<>:"SYS_B_2" AND OWNERID <>:"SYS_B_3" AND ROWNUM < :"SYS_B_4"
0k8522rmdzg4kselect privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0tnjgjztc81h2UPDATE SALESORDER_BILL T SET T.PACKTIME = SYSDATE, T.PACKUSERID = :B2 , T.UPDATETIME = SYSDATE, T.OLDBILL_STATE = T.BILL_STATE, T.BILL_STATE = '05', T.STATE_DESC = '包装确认' WHERE T.MOPOCSALESORDERBILLID = :B1
1hk6wj4jy065aDELETE FROM INVENTORY_GOODSFORSALE T WHERE EXISTS (SELECT 1 FROM INVENTORY_GOODSFORSALE_TEMP S WHERE S.GOODSFORSALEID = T.GOODSFORSALEID AND S.SYSTEMID = T.SYSTEMID AND S.SYSTEMID = :B1 )
1hyv78p73sby6SELECT SUM(B.PACKAGE_QTY) FROM PACKAGE_BILLDETAIL B WHERE B.LOGISTICSTYPEID = '进退单' AND B.SYSTEMID = :B7 AND B.LOGISTICSBILLID = :B6 AND B.OWNERID = :B5 AND B.WAREHOUSEID = :B4 AND B.SKUID = :B3 AND B.WARRANTY_ENDDATE = :B2 AND B.PRODUCTION_BATCHNUMBER = :B1
1q85jprkn4c32 select count(:"SYS_B_0") from (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIETYQ TY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BILL.C ANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_BIL L.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PICKI NGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_1" AND MOPOCSALESORDERBILLID = :"SYS_B_2" Order By MOPOCSALESORDERBILLID)
2vq7yv9nn1b0r Select :reprintflag, pr.outpurchasereturnbillno, pr.remark, pr.purchasereturnbillno, decode(pr.addressid, :"SYS_B_0", :"SYS_B_1", :"SYS_B_2") delivertype, decode(pr.addressid, :"SYS_B_3", :"SYS_B_4", a.address_name) address_name, ck.warehousename, decode(pr.addressid, :"SYS_B_5", :"SYS_B_6", a.receivetel) receivetel, decode(pr.addressid, :"SYS_B_7", :"SYS_B_8", a.receivecontact) receivecontact, hz.companyname, sp.companyname as spcompanyname, z.packagebillno, sysdate pbrp34_date_1, z.entering_varietyqty, z.entering_qty From Package_Billdetail g Left Join Package_Bill z On z.Packagebillid = g.Packagebillid Left Join Base_Company Hz On Hz.Companyid = z.Ownerid Left Join Base_Warehouse Ck On Ck.Warehouseid = z.Warehouseid left join purchase_returnbill pr on (z.Logisticstypeid =:"SYS_B_9" and z.logisticsbillid = pr.purchasereturnbillid) left join base_address a on a.address_id=pr .addressid left join base_company sp on sp.companyid = pr.supplierid where g.packagebillid=:arg_billid
3hkxqb42macn7SELECT S.SYSTEM_PREFIXION FROM SYS_SYSINFO S WHERE S.SYSTEM_ID = :B1
3rfa3jdts90xgUPDATE PURCHASE_RETURNBILLDETAIL T SET (T.CHECK_QUANTITY, T.CHECK_PRICEAMOUNT) = (SELECT SUM(S.SORTING_QTY), SUM(S.SORTING_PRICEAMOUNT) FROM SORTING_BILLDETAIL S WHERE S.LOGISTICSTYPEID = '进退单' AND S.LOGISTICSBILLDETAILID = T.PURCHASERETURNBILLDETAILID) WHERE T.PURCHASERETURNBILLID = :B2 AND T.SYSTEMID = :B1 AND EXISTS (SELECT 1 FROM SORTING_BILLDETAIL Y WHERE Y.LOGISTICSTYPEID = '进退单' AND Y.LOGISTICSBILLDETAILID = T.PURCHASERETURNBILLDETAILID)
47a50dvdgnxc2update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4y3n46d9brtxv SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIE TYQTY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BIL L.CANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_ BILL.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PI CKINGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_0" AND MOPOCSALESORDERBILLID = :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3"
572pfbk8f3x4y select count(:"SYS_B_0") from (select waybill_packagehangding.systemid, waybill_packagehangding.waybill_packageid, waybill_packagehangding.waybill_packageno, waybill_packagehangding.package_serial, waybill_packagehangding.package_number, waybill_packagehangding.mopocsalesorderbillid, waybill_packagehangding.outersalesorderbillid, waybill_packagehangding.shopid, waybill_packagehangding.ownerid, waybill_packagehangding.ordertypeid, waybill_packagehangding.warehouseid, waybill_packagehangding.inputtypeid, waybill_packagehangding.package_varietyqty, waybill_packagehangding.package_detailqty, waybill_packagehangding.package_qty, waybill_packagehangding.package_saleamount, waybill_packagehangding.goods_weight, waybill_packagehangding.othersgoods_weight, waybill_packagehangding.consign_weight, waybill_packagehangding.packaging_skuid, waybill_packagehangding.packaging_cost, waybill_packagehangding.receivable_amount, waybill_packagehangding.scanno, waybill_packa gehangding.deliverid, waybill_packagehangding.deliverno, waybill_packagehangding.delivernoprintflag, waybill_packagehangding.printnum, waybill_packagehangding.pickingbillid, waybill_packagehangding.pickingbillno, waybill_packagehangding.batchbillid, waybill_packagehangding.batchbillno, waybill_packagehangding.createuserid, waybill_packagehangding.updateuserid, waybill_packagehangding.createtime, waybill_packagehangding.updatetime, waybill_packagehangding.bill_state, waybill_packagehangding.oldbill_state, waybill_packagehangding.state_desc, waybill_packagehangding.packtime, waybill_packagehangding.packuserid, waybill_packagehangding.handingtime, waybill_packagehangding.handinguserid, waybill_packagehangding.waybillid, waybill_packagehangding.waybillno, waybill_packagehangding.posid, salesorder_bill.RECEIVERNAME, salesorder_bill.RECEIVERADDRESS, salesorder_bill.RECEIVERZIP, BASE_PROVINCE.PROVINCE_NAME, BASE_CITY.CITY_NAME, BASE_AREA.AREA_NAME, salesorder_bill. RECEIVERMOBILE, salesorder_bill.RECEIVERPHONE, base_goodsinfo.goodsbarcode, PICKING_BILL.PICKINGFLAG from waybill_packagehangding, salesorder_bill, BASE_PROVINCE, BASE_CITY, BASE_AREA, base_goodsinfo, PICKING_BILL where waybill_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid AND salesorder_bill.RECEIVERSTATE = BASE_PROVINCE.PROVINCE_ID(+) AND salesorder_bill.RECEIVERCITY = BASE_CITY.CITY_ID(+) AND salesorder_bill.RECEIVERDISTRICT = BASE_AREA.AREA_ID(+) and waybill_packagehangding.packaging_skuid = base_goodsinfo.skuid(+) and waybill_packagehangding.PICKINGBILLID = picking_bill.pickingbillid(+) AND WAYBILL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND waybill_packagehangding.HANDINGTIME BETWEEN TO_DATE(:"SYS_B_2", :"SYS_B_3") AND TO_DATE(:"SYS_B_4", :"SYS_B_5") Order By CREATETIME desc, WAYBILL_PACKAGEID desc )
578kvyc0rcmm4 INSERT INTO WAYBILL_PACKAGE (SYSTEMID, WAYBILL_PACKAGEID, WAYBILL_PACKAGENO, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, SHOPID, OWNERID, ORDERTYPEID, WAREHOUSEID, INPUTTYPEID, PACKAGE_VARIETYQTY, PACKAGE_DETAILQTY, PACKAGE_QTY, PACKAGE_SALEAMOUNT, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, CONSIGN_WEIGHT, PACKAGING_SKUID, PACKAGING_COST, RECEIVABLE_AMOUNT, SCANNO, DELIVERID, DELIVERNO, DELIVERNOPRINTFLAG, PRINTNUM, PICKINGBILLID, PICKINGBILLNO, BATCHBILLID, BATCHBILLNO, CREATEUSERID, UPDATEUSERID, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, PACKAGE_SERIAL, WAYBILLID, WAYBILLNO, POSID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, INVOICEFLAG, PAYMENTFLAG, COSTLYFLAG, PAYMENTMODEID, BUYERMESSAGE, ORDERTIME, INVOICE_NAME, INVOICE_CONTENT, DELIVERY_COST, PLATFORMID, BOXNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, INVOICE_AMOUNT, SALESODER_COD NO) SELECT P.SYSTEMID, P.WAYBILL_PACKAGEID, P.WAYBILL_PACKAGENO, R.MOPOCSALESORDERBILLID, R.OUTERSALESORDERBILLID, R.SHOPID, R.OWNERID, R.ORDERTYPEID, R.WAREHOUSEID, S.INPUTTYPEID, P.PACKAGE_VARIETYQTY, P.PACKAGE_DETAILQTY, P.PACKAGE_QTY, DECODE(P.PACKAGE_SALEAMOUNT * :B6 * :B5 , 0, 0, (P.PACKAGE_SALEAMOUNT / :B6 * :B5 )), P.GOODS_WEIGHT, 0, 0, NULL, 0, DECODE(S.PAYMENTMODEID, 'COD', S.RECEIVABLE_AMOUNT, 0), NULL, R.DELIVERID, NULL, 'false', 0, R.PICKINGBILLID, R.PICKINGBILLNO, NULL, NULL, :B4 , :B4 , SYSDATE, SYSDATE, R.BILL_STATE, R.BILL_STATE, R.STATE_DESC, :B3 , R.WAYBILLID, R.WAYBILLNO, :B2 , R.RECEIVERNAME, R.RECEIVERADDRESS, R.RECEIVERZIP, R.RECEIVERSTATE, R.RECEIVERCITY, R.RECEIVERDISTRICT, R.RECEIVERMOBILE, R.RECEIVERPHONE, R.INVOICEFLAG, R.PAYMENTFLAG, R.COSTLYFLAG, R.PAYMENTMODEID, R.BUYERMESSAGE, R.ORDERTIME, S.INVOICE_NAME, S.INVOICE_CONTENT, S.DELIVERY_COST, S.PLATFORMID, R.BOXNO, R.PICKINGBILLBATCHID, R.PI CKINGBILLBATCHNO, S.INVOICE_AMOUNT, S.SALESODER_CODNO FROM (SELECT COUNT(DISTINCT T.SKUID) PACKAGE_VARIETYQTY, COUNT(1) PACKAGE_DETAILQTY, SUM(T.PACKAGE_QTY) PACKAGE_QTY, SUM(NVL(T.PACKAGE_SALEAMOUNT, 0)) PACKAGE_SALEAMOUNT, SUM(T.QC_WEIGHT) GOODS_WEIGHT, T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID FROM WAYBILLDETAIL_PACKAGE T WHERE T.WAYBILL_PACKAGEID = :B1 GROUP BY T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID) P, WAYBILL_CONSIGN R, SALESORDER_BILL S WHERE P.MOPOCSALESORDERBILLID = R.MOPOCSALESORDERBILLID AND R.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID
57a37zd77u4yvbegin Purchase_Returnbill_Outsure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PURCHASERETURNBILLID=>:AS_PURCHASERETURNBILLID, AS_PURCHASERETURNBILLNO=>:AS_PURCHASERETURNBILLNO, AS_PURCHASERETURNTYPEID=>:AS_PURCHASERETURNTYPEID, AS_DEPARTMENTID=>:AS_DEPARTMENTID, AS_USERID=>:AS_USERID, AS_BILLSTATE=>:AS_BILLSTATE, DESCERR=>:DESCERR); end;
5hwdf0wvghfcwUPDATE SALESORDER_BILL T SET T.OLDBILL_STATE = T.BILL_STATE, T.BILL_STATE = '02', T.STATE_DESC = '订单汇总', T.MERGETIME = SYSDATE, T.MERGEUSERID = :B1 , (T.ASSIGN_QTY, T.PICKINGBILLID, T.PICKINGBILLNO) = (SELECT YD.ASSIGN_QTY, YD.PICKINGBILLID, YD.PICKINGBILLNO FROM WAYBILL_LEADIN_TEMP YD WHERE YD.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) WHERE EXISTS (SELECT 1 FROM WAYBILL_LEADIN_TEMP S WHERE S.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID)
6182rs2up50j6begin Waybill_Package_Packing(AS_SYSTEMID=>:AS_SYSTEMID, AS_BATCHID=>:AS_BATCHID, AS_BATCHNO=>:AS_BATCHNO, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
6mcpb06rctk0xcall dbms_space.auto_space_advisor_job_proc ( )
6uhvyfmmqfkgrSELECT COUNT(1) FROM WAYBILL_PACKAGINGSKU R WHERE R.BILL_STATE = '02' AND R.SYSTEMID = :B1
7d9bcscmbwshdbegin Picking_Bill_Sure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PICKINGBILLID=>:AS_PICKINGBILLID, AS_PICKINGBILLNO=>:AS_PICKINGBILLNO, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, RFJXFLAG=>:RFJXFLAG, WAYBILLFRONTFLAG=>:WAYBILLFRONTFLAG, DESCERR=>:DESCERR); end;
7h38rm3myd747 SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIE TYQTY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BIL L.CANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_ BILL.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PI CKINGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_0" AND RECEIVERMOBILE Like :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3"
7urcp0fzuzgccUPDATE PURCHASE_RETURNBILLDETAIL T SET (T.CONSIGN_QUANTITY, T.CONSIGN_PRICEAMOUNT) = (SELECT SUM(S.SORTING_QTY), SUM(S.SORTING_PRICEAMOUNT) FROM SORTING_BILLDETAIL S WHERE S.LOGISTICSTYPEID = '进退单' AND S.LOGISTICSBILLDETAILID = T.PURCHASERETURNBILLDETAILID) WHERE T.PURCHASERETURNBILLID = :B2 AND T.SYSTEMID = :B1 AND EXISTS (SELECT 1 FROM SORTING_BILLDETAIL Y WHERE Y.LOGISTICSTYPEID = '进退单' AND Y.LOGISTICSBILLDETAILID = T.PURCHASERETURNBILLDETAILID)
7wahvsbqhx79cbegin Salesorder_Collect31(AS_SYSTEMID=>:AS_SYSTEMID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_USERID=>:AS_USERID, AS_HHZD=>:AS_HHZD, AS_WHERE=>:AS_WHERE, AS_ROWNUMWHERE=>:AS_ROWNUMWHERE, DESCERR=>:DESCERR); end;
81pj6yhd2qp5k select count(:"SYS_B_0") from (Select Waybill_Packagingsku.Systemid, Waybill_Packagingsku.Mopocsalesorderbillid, Waybill_Packagingsku.Outersalesorderbillid, Waybill_Packagingsku.Packaging_Skuid, Waybill_Packagingsku.Packaging_Cost, Waybill_Packagingsku.Packaging_Weight, Waybill_Packagingsku.Packaging_Qty, Waybill_Packagingsku.Createtime, Waybill_Packagingsku.Updatetime, Waybill_Packagingsku.Bill_State, Waybill_Packagingsku.Oldbill_State, Waybill_Packagingsku.State_Desc, Base_Goodsinfo.Goodsno, Base_Goodsinfo.Goodsbarcode, Base_Goodsinfo.Goodsname, Base_Goodsinfo.Other_Barcodes, Waybill_Packagingsku.Warehouseid, Waybill_Packagingsku.Ownerid, Waybill_Packagingsku.Shopid, Waybill_Packagingsku.Departmentid, Waybill_Packagingsku.Sourceownerid, Waybill_Packagingsku.Sourcedepartmentid, Waybill_Packagingsku.WAYBILL_PACKAGENO From Waybill_Packagingsku, Base_Goodsinfo Where Waybill_Packagingsku.Packaging_Skuid = Base_Goodsinfo.Skuid AND Waybill_Packagingsku.WAREHOU SEID=:"SYS_B_1" AND CREATETIME BETWEEN TO_DATE(:"SYS_B_2", :"SYS_B_3") AND TO_DATE(:"SYS_B_4", :"SYS_B_5") and WAREHOUSEID = :"SYS_B_6")
830grrcnqx0ja SELECT * FROM (SELECT A.*, ROWNUM RN FROM (Select Waybill_Packagingsku.Systemid, Waybill_Packagingsku.Mopocsalesorderbillid, Waybill_Packagingsku.Outersalesorderbillid, Waybill_Packagingsku.Packaging_Skuid, Waybill_Packagingsku.Packaging_Cost, Waybill_Packagingsku.Packaging_Weight, Waybill_Packagingsku.Packaging_Qty, Waybill_Packagingsku.Createtime, Waybill_Packagingsku.Updatetime, Waybill_Packagingsku.Bill_State, Waybill_Packagingsku.Oldbill_State, Waybill_Packagingsku.State_Desc, Base_Goodsinfo.Goodsno, Base_Goodsinfo.Goodsbarcode, Base_Goodsinfo.Goodsname, Base_Goodsinfo.Other_Barcodes, Waybill_Packagingsku.Warehouseid, Waybill_Packagingsku.Ownerid, Waybill_Packagingsku.Shopid, Waybill_Packagingsku.Departmentid, Waybill_Packagingsku.Sourceownerid, Waybill_Packagingsku.Sourcedepartmentid, Waybill_Packagingsku.WAYBILL_PACKAGENO From Waybill_Packagingsku, Base_Goodsinfo Where Waybill_Packagingsku.Packaging_Skuid = Base_Goodsinfo.Skuid AND Waybill_Packagingsku.WARE HOUSEID=:"SYS_B_0" AND CREATETIME BETWEEN TO_DATE(:"SYS_B_1", :"SYS_B_2") AND TO_DATE(:"SYS_B_3", :"SYS_B_4") and WAREHOUSEID = :"SYS_B_5") A WHERE ROWNUM <= :"SYS_B_6" ) WHERE RN > :"SYS_B_7"
837svcmjhsf06 SELECT SALESORDER_BILLDETAIL.MOPOCSALESORDERBILLDETAILID, SALESORDER_BILLDETAIL.MOPOCSALESORDERBILLID, SALESORDER_BILLDETAIL.OUTERSALESORDERBILLID, SALESORDER_BILLDETAIL.OUTERSALESORDERBILLDETAILID, SALESORDER_BILLDETAIL.MOPOCSOURCEORDERBILLID, SALESORDER_BILLDETAIL.MOPOCSOURCEBILLDETAILID, SALESORDER_BILLDETAIL.OUTERSOURCEORDERBILLID, SALESORDER_BILLDETAIL.OUTERSOURCEBILLDETAILID, SALESORDER_BILLDETAIL.SHOPID, SALESORDER_BILLDETAIL.OWNERID, SALESORDER_BILLDETAIL.ORDERTYPEID, SALESORDER_BILLDETAIL.WAREHOUSEID, SALESORDER_BILLDETAIL.SKUID, SALESORDER_BILLDETAIL.SALEPRICE, SALESORDER_BILLDETAIL.DISCOUNT, SALESORDER_BILLDETAIL.ORDER_QTY, SALESORDER_BILLDETAIL.ORDER_SALEAMOUNT, SALESORDER_BILLDETAIL.ORDER_WEIGHT, SALESORDER_BILLDETAIL.ASSIGN_QTY, SALESORDER_BILLDETAIL.PICKING_QTY, SALESORDER_BILLDETAIL.QC_QTY, SALESORDER_BILLDETAIL.QC_SALEAMOUNT, SALESORDER_BILLDETAIL.QC_WEIGHT, SALESORDER_BILLDETAIL.CONSIGN_QTY, SALESORDER_BILLDETAIL.CONSIGN_SALEAMOUNT, SALESORDER _BILLDETAIL.CONSIGN_WEIGHT, SALESORDER_BILLDETAIL.QCTIME, SALESORDER_BILLDETAIL.QCUSERID, SALESORDER_BILLDETAIL.ACTUALSHORTTIME, SALESORDER_BILLDETAIL.ACTUALSHORTUSERID, SALESORDER_BILLDETAIL.ACCOUNTDATE, SALESORDER_BILLDETAIL.ACCOUNTUSERID, SALESORDER_BILLDETAIL.MODIFIEDTIME, SALESORDER_BILLDETAIL.SHORTFLAG, SALESORDER_BILLDETAIL.ACTUALSHORTFLAG, SALESORDER_BILLDETAIL.UNITEFLAG, SALESORDER_BILLDETAIL.DONATIONFLAG, SALESORDER_BILLDETAIL.DMFLAG, SALESORDER_BILLDETAIL.ACCOUNTFLAG, SALESORDER_BILLDETAIL.VOUCHERFLAG, SALESORDER_BILLDETAIL.WAYBILLID, SALESORDER_BILLDETAIL.WAYBILLNO, SALESORDER_BILLDETAIL.WAYBILLDETAILID, SALESORDER_BILLDETAIL.PICKINGBILLID, SALESORDER_BILLDETAIL.PICKINGBILLNO, SALESORDER_BILLDETAIL.PICKINGBILLBATCHID, SALESORDER_BILLDETAIL.PICKINGBILLBATCHNO, SALESORDER_BILLDETAIL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILLDETAIL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILLDETAIL.CREATETIME, SALESORDER_BILLDETAIL.UPDATETIME, SALESORDER_BILLDETAIL.BILL_STA TE, SALESORDER_BILLDETAIL.OLDBILL_STATE, --SALESORDER_BILLDETAIL.STATE_DESC, BASE_GOODSINFO.PRODUCTID, BASE_GOODSINFO.BRANDID, BASE_GOODSINFO.GOODSNO, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.SNNO, BASE_GOODSINFO.DISPLAYNAME, BASE_GOODSINFO.ENGLISHNAME, BASE_GOODSINFO.MARKETPRICE, BASE_GOODSINFO.MNEMONICCODE, BASE_GOODSINFO.KEYWORD, BASE_GOODSINFO.GOODSTYPEID, BASE_GOODSINFO.STATISTICID, BASE_GOODSINFO.SEXPROPERTYID, BASE_GOODSINFO.SEASONPROPERTYID, BASE_GOODSINFO.AGEPROPERTYID, BASE_GOODSINFO.SALEPROPERTYID, BASE_GOODSINFO.COLORPROPERTYID, BASE_GOODSINFO.UNITRPROPERTYID, BASE_GOODSINFO.GRADEPROPERTYID, BASE_GOODSINFO.STYLEPROPERTYID, BASE_GOODSINFO.LEVELPROPERTYID, BASE_GOODSINFO.MANAGEPROPERTYID, BASE_GOODSINFO.REGISTERED_TRADEMARK, BASE_GOODSINFO.WARRANTYFLAG, BASE_GOODSINFO.WARRANTY, BASE_GOODSINFO.APPROVAL_CODE, BASE_GOODSINFO.PLACE_PRODUCTION, BASE_GOODSINFO.MANUFACTURER, BASE_GOODSINFO.MANUFACTURERGOODSNO, BASE_GOODST YPE.GOODSTYPE_CODE, BASE_GOODSTYPE.GOODSTYPE_NAME, SALESORDER_BILL.STATE_DESC FROM SALESORDER_BILLDETAIL, BASE_GOODSINFO, BASE_GOODSTYPE, SALESORDER_BILL Where (SALESORDER_BILLDETAIL.SKUID = BASE_GOODSINFO.SKUID(+)) And (BASE_GOODSINFO.GOODSTYPEID = BASE_GOODSTYPE.GOODSTYPE_ID(+)) and salesorder_bill.mopocsalesorderbillid = SALESORDER_BILLDETAIL.MOPOCSALESORDERBILLID And ((SALESORDER_BILLDETAIL.mopocsalesorderbillid =:"SYS_B_0"))
84k2mp6rgxpy6UPDATE SALESORDER_BILL T SET T.ORDERPRINTTIME = SYSDATE, T.ORDERPRINTUSERID = :B3 , T.PICKINGBILLID = NVL(T.PICKINGBILLID, :B2 ), T.PICKINGBILLNO = NVL(T.PICKINGBILLNO, :B1 ) WHERE EXISTS (SELECT 1 FROM PICKING_BILLSOURCE S WHERE S.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND S.PICKINGBILLID = :B2 )
8ht8yrs78xj49begin Create_Waybillpackage30(AS_SYSTEMID=>:AS_SYSTEMID, AS_ORDERBILLID=>:AS_ORDERBILLID, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, AS_WAREHOUSEID=>:AS_WAREHOUSEID, AS_POSID=>:AS_POSID, AS_OUTERBILLID=>:AS_OUTERBILLID, DESCERR=>:DESCERR); end;
8q1r67mcuxg6fbegin Sorting_Bill_Sure30(AS_SYSTEMID=>:AS_SYSTEMID, AS_SORTINGBILLID=>:AS_SORTINGBILLID, AS_SORTINGBILLNO=>:AS_SORTINGBILLNO, AS_POSID=>:AS_POSID, AS_SORTINGUSERID=>:AS_SORTINGUSERID, AS_USERID=>:AS_USERID, AS_BILLSTATE=>:AS_BILLSTATE, DESCERR=>:DESCERR); end;
965myf8ddfzg8 SELECT SALESRETURN_INORDER.MOPOCSALESORDERBILLID, SALESRETURN_INORDER.OUTERSALESORDERBILLID, SALESRETURN_INORDER.MOPOCSOURCEORDERBILLID, SALESRETURN_INORDER.OUTERSOURCEORDERBILLID, SALESRETURN_INORDER.SHOPID, SALESRETURN_INORDER.OWNERID, SALESRETURN_INORDER.PLATFORMID, SALESRETURN_INORDER.PLATFORMSTATUS, SALESRETURN_INORDER.ORDERTYPEID, SALESRETURN_INORDER.INPUTTYPEID, SALESRETURN_INORDER.WAREHOUSEID, SALESRETURN_INORDER.ORDER_VARIETYQTY, SALESRETURN_INORDER.ORDER_DETAILQTY, SALESRETURN_INORDER.ORDER_QTY, SALESRETURN_INORDER.ORDER_SALEAMOUNT, SALESRETURN_INORDER.ORDER_WEIGHT, SALESRETURN_INORDER.ASSIGN_QTY, SALESRETURN_INORDER.PICKING_QTY, SALESRETURN_INORDER.QC_VARIETYQTY, SALESRETURN_INORDER.QC_QTY, SALESRETURN_INORDER.QC_SALEAMOUNT, SALESRETURN_INORDER.QC_WEIGHT, SALESRETURN_INORDER.CONSIGN_VARIETYQTY, SALESRETURN_INORDER.CONSIGN_QTY, SALESRETURN_INORDER.CONSIGN_SALEAMOUNT, SALESRETURN_INORDER.CONSIGN_WEIGHT, SALESRETURN_INORDER.GOODS_WEIGHT, SALESRETURN_I NORDER.OTHERSGOODS_WEIGHT, SALESRETURN_INORDER.BUYERNICK, SALESRETURN_INORDER.BUYEREMAIL, SALESRETURN_INORDER.BUYERMESSAGE, SALESRETURN_INORDER.CUSTOMERID, SALESRETURN_INORDER.RECEIVERNAME, SALESRETURN_INORDER.RECEIVERADDRESS, SALESRETURN_INORDER.RECEIVERZIP, SALESRETURN_INORDER.RECEIVERSTATE, SALESRETURN_INORDER.RECEIVERCITY, SALESRETURN_INORDER.RECEIVERDISTRICT, SALESRETURN_INORDER.RECEIVERMOBILE, SALESRETURN_INORDER.RECEIVERPHONE, SALESRETURN_INORDER.ORDERTIME, SALESRETURN_INORDER.ENTERHEADQUARTERSTIME, SALESRETURN_INORDER.UNITEHEADQUARTERSTIME, SALESRETURN_INORDER.DISTRIBUTETIME, SALESRETURN_INORDER.ENTERWAREHOUSETIME, SALESRETURN_INORDER.UNITEWAREHOUSETIME, SALESRETURN_INORDER.IMPORTTIME, SALESRETURN_INORDER.IMPORTUSERID, SALESRETURN_INORDER.MERGETIME, SALESRETURN_INORDER.MERGEUSERID, SALESRETURN_INORDER.WAITINGTIME, SALESRETURN_INORDER.WAITINGUSERID, SALESRETURN_INORDER.CANCELWAITINGTIME, SALESRETURN_INORDER.CANCELWAITINGUSERID, SALESRETURN_INORDER.CANC ELORDERTIME, SALESRETURN_INORDER.CANCELORDERUSERID, SALESRETURN_INORDER.ACTUALCANCELTIME, SALESRETURN_INORDER.ACTUALCANCELUSERID, SALESRETURN_INORDER.ORDERPRINTTIME, SALESRETURN_INORDER.ORDERPRINTUSERID, SALESRETURN_INORDER.ASSIGNORDERTIME, SALESRETURN_INORDER.ASSIGNORDERUSERID, SALESRETURN_INORDER.PICKINGTIME, SALESRETURN_INORDER.PICKINGUSERID, SALESRETURN_INORDER.QCTIME, SALESRETURN_INORDER.QCUSERID, SALESRETURN_INORDER.ACTUALSHORTTIME, SALESRETURN_INORDER.ACTUALSHORTUSERID, SALESRETURN_INORDER.PACKTIME, SALESRETURN_INORDER.PACKUSERID, SALESRETURN_INORDER.WAYBILLTIME, SALESRETURN_INORDER.WAYBILLUSERID, SALESRETURN_INORDER.HANDINGTIME, SALESRETURN_INORDER.HANDINGUSERID, SALESRETURN_INORDER.CONSIGNTIME, SALESRETURN_INORDER.CONSIGNUSERID, SALESRETURN_INORDER.ENDTIME, SALESRETURN_INORDER.ENDUSERID, SALESRETURN_INORDER.ACCOUNTDATE, SALESRETURN_INORDER.ACCOUNTUSERID, SALESRETURN_INORDER.MODIFIEDTIME, SALESRETURN_INORDER.SHORTFLAG, SALESRETURN_INORDER.ACTUALSHORT FLAG, SALESRETURN_INORDER.UNITEFLAG, SALESRETURN_INORDER.ACCOUNTFLAG, SALESRETURN_INORDER.VOUCHERFLAG, SALESRETURN_INORDER.INNERSTATUS, SALESRETURN_INORDER.REFUNDSTATUS, SALESRETURN_INORDER.STOCKSTATUS, SALESRETURN_INORDER.DELIVERID, SALESRETURN_INORDER.DELIVERNO, SALESRETURN_INORDER.DELIVERYMODEID, SALESRETURN_INORDER.DELIVERYTIME, SALESRETURN_INORDER.RETURNMODEID, SALESRETURN_INORDER.PAYMENTMODEID, SALESRETURN_INORDER.REFUND_MODEID, SALESRETURN_INORDER.PACKAGING_MODEID, SALESRETURN_INORDER.PACKAGING_COST, SALESRETURN_INORDER.PACKAGING_SKUID, SALESRETURN_INORDER.RECEIVABLE_AMOUNT, SALESRETURN_INORDER.GOODS_PAYMENT, SALESRETURN_INORDER.DELIVERY_COST, SALESRETURN_INORDER.INVOICE_AMOUNT, SALESRETURN_INORDER.ACCOUNT_PAID, SALESRETURN_INORDER.SHOPPING_VOUCHER, SALESRETURN_INORDER.ACCOUNT_BALANCE, SALESRETURN_INORDER.PAYTIME, SALESRETURN_INORDER.INVOICEFLAG, SALESRETURN_INORDER.INVOICE_NAME, SALESRETURN_INORDER.INVOICE_CONTENT, SALESRETURN_INORDER.ORDER_DISCOUNT, SALESRETURN_INORDER.GROUPORDERFLAG, SALESRETURN_INORDER.ADVANCEORDERFLAG, SALESRETURN_INORDER.PAYMENTFLAG, SALESRETURN_INORDER.BLENDFLAG, SALESRETURN_INORDER.RETURNREASONDESC, SALESRETURN_INORDER.WAYBILLID, SALESRETURN_INORDER.WAYBILLNO, SALESRETURN_INORDER.PICKINGBILLID, SALESRETURN_INORDER.PICKINGBILLNO, SALESRETURN_INORDER.PICKINGBILLBATCHID, SALESRETURN_INORDER.PICKINGBILLBATCHNO, SALESRETURN_INORDER.ORDERMOVEINGBILLBATCHID, SALESRETURN_INORDER.ORDERMOVEINGBILLBATCHNO, SALESRETURN_INORDER.WAREHOUSEAREAQTY, SALESRETURN_INORDER.WAREHOUSEAREAWAY, SALESRETURN_INORDER.CREATETIME, SALESRETURN_INORDER.UPDATETIME, SALESRETURN_INORDER.BILL_STATE, SALESRETURN_INORDER.OLDBILL_STATE, SALESRETURN_INORDER.STATE_DESC, salesreturn_inorder.costlyflag FROM SALESRETURN_INORDER WHERE SALESRETURN_INORDER.BILL_STATE in (:"SYS_B_0", :"SYS_B_1") and SALESRETURN_INORDER.ORDERTYPEID in (:"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5 ") and SALESRETURN_INORDER.MOPOCSOURCEORDERBILLID LIKE :"SYS_B_6" and SALESRETURN_INORDER.WAREHOUSEID = :"SYS_B_7"
98t4azsnjmvp0 SELECT (case when plan_qty > return_qty then :"SYS_B_00" else :"SYS_B_01" end) FINISHFLAG, SALESRETURN_BILL.SYSTEMID, SALESRETURN_BILL.SALESRETURNBILLID, SALESRETURN_BILL.SALESRETURNBILLNO, SALESRETURN_BILL.SALESRETURNBILLBATCHID, SALESRETURN_BILL.SALESRETURNBILLBATCHNO, SALESRETURN_BILL.SALESORDERID, SALESRETURN_BILL.OUTERSALESORDERID, SALESRETURN_BILL.ORDERTYPEID, SALESRETURN_BILL.OLDSALESORDERID, SALESRETURN_BILL.OLDOUTSALESORDERID, SALESRETURN_BILL.POSID, SALESRETURN_BILL.OUTWAREHOUSEID, SALESRETURN_BILL.WAREHOUSEID, SALESRETURN_BILL.WAREHOUSEAREAID, SALESRETURN_BILL.CARGOSPACEID, SALESRETURN_BILL.SALESRETURNTYPEID, SALESRETURN_BILL.SALESRETURNREASONID, SALESRETURN_BILL.EXPRESSDELIVERYID, SALESRETURN_BILL.WAYBILLNO, SALESRETURN_BILL.PLAN_VARIETYQTY, SALESRETURN_BILL.PLAN_QTY, SALESRETURN_BILL.PLAN_PRICEAMOUNT, SALESRETURN_BILL.PLAN_SALEAMOUNT, SALESRETURN_BILL.PLAN_WEIGHT, SALESRETURN_BILL.RETURN_VARIETYQTY, SALESRETURN_BILL.RETURN_Q TY, SALESRETURN_BILL.RETURN_PRICEAMOUNT, SALESRETURN_BILL.RETURN_SALEAMOUNT, SALESRETURN_BILL.RETURN_WEIGHT, SALESRETURN_BILL.DAMAGE_VARIETYQTY, SALESRETURN_BILL.DAMAGE_QTY, SALESRETURN_BILL.DAMAGE_PRICEMOUNT, SALESRETURN_BILL.DAMAGE_SALEAMOUNT, SALESRETURN_BILL.DAMAGE_WEIGHT, SALESRETURN_BILL.REMARK, SALESRETURN_BILL.CREATEDATE, SALESRETURN_BILL.CONFIRMDATE, SALESRETURN_BILL.SHELVEDATE, SALESRETURN_BILL.ACCOUNTDATE, SALESRETURN_BILL.CREATEUSERID, SALESRETURN_BILL.CONFIRMUSERID, SALESRETURN_BILL.SHELVEUSERID, SALESRETURN_BILL.ACCOUNTUSERID, SALESRETURN_BILL.INPUTFLAG, SALESRETURN_BILL.BILL_STATE, SALESRETURN_BILL.OLDBILL_STATE, SALESRETURN_BILL.STATE_DESC, salesreturn_inorder.RECEIVERNAME, salesreturn_inorder.RECEIVERMOBILE, salesreturn_inorder.RECEIVERPHONE, salesreturn_inorder.receiveraddress , dp.companyname dp, hz.companyname hz, salesreturn_bill.costlyflag, t.DELIVERNO, t.ownerid, t.shopid FROM SALESRETURN_BILL left join salesorder_bill t on t.mopocsal esorderbillid = SALESRETURN_BILL.Oldsalesorderid left join base_company hz on hz.companyid = t.ownerid left join base_company dp on dp.companyid = t.shopid left join salesreturn_inorder on SALESRETURN_BILL.salesorderid=salesreturn_inorder.mopocsalesorderbillid where :"SYS_B_02" =:"SYS_B_03" and (SALESRETURN_BILL.OLDSALESORDERID = t.MOPOCSALESORDERBILLID) AND (SALESRETURN_BILL.SALESRETURNBILLBATCHID = :"SYS_B_04" OR (SALESRETURN_BILL.SALESRETURNBILLBATCHID = :"SYS_B_05" AND SALESRETURN_BILL.BILL_STATE = :"SYS_B_06")) AND (SALESRETURN_BILL.SALESRETURNTYPEID NOT IN ( :"SYS_B_07", :"SYS_B_08")) AND (SALESRETURN_BILL.WAREHOUSEID = :"SYS_B_09") and salesreturn_bill.oldsalesorderid like :"SYS_B_10"
9b9cx124fxqah select count(:"SYS_B_00") from ( Select WAYBILL_LEADIN.SYSTEMID, WAYBILL_LEADIN.PAYTIME, WAYBILL_LEADIN.MOPOCSALESORDERBILLID, WAYBILL_LEADIN.OUTERSALESORDERBILLID, WAYBILL_LEADIN.MOPOCSOURCEORDERBILLID, WAYBILL_LEADIN.OUTERSOURCEORDERBILLID, WAYBILL_LEADIN.WAYBILLID, WAYBILL_LEADIN.WAYBILLNO, WAYBILL_LEADIN.SHOPID, WAYBILL_LEADIN.OWNERID, WAYBILL_LEADIN.ORDERTYPEID, WAYBILL_LEADIN.WAREHOUSEID, WAYBILL_LEADIN.JXFQID, WAYBILL_LEADIN.BOXNO, WAYBILL_LEADIN.ORDER_VARIETYQTY, WAYBILL_LEADIN.ORDER_DETAILQTY, WAYBILL_LEADIN.ORDER_QTY, WAYBILL_LEADIN.ASSIGN_QTY, WAYBILL_LEADIN.RECEIVABLE_AMOUNT, WAYBILL_LEADIN.RECEIVERNAME, WAYBILL_LEADIN.RECEIVERADDRESS, WAYBILL_LEADIN.RECEIVERZIP, WAYBILL_LEADIN.RECEIVERSTATE, WAYBILL_LEADIN.RECEIVERCITY, WAYBILL_LEADIN.RECEIVERDISTRICT, WAYBILL_LEADIN.RECEIVERMOBILE, WAYBILL_LEADIN.RECEIVERPHONE, WAYBILL_LEADIN.ORDERTIME, WAYBILL_LEADIN.DELIVERYTIME, WAYBILL_LEADIN.DELIVERID, WAYBILL_LEADIN.GROUPORDERFLAG, WAYBILL_LEAD IN.INVOICEFLAG, WAYBILL_LEADIN.ADVANCEORDERFLAG, WAYBILL_LEADIN.PAYMENTFLAG, WAYBILL_LEADIN.BLENDFLAG, WAYBILL_LEADIN.PICKINGBILLID, WAYBILL_LEADIN.PICKINGBILLNO, WAYBILL_LEADIN.PICKINGBILLBATCHID, WAYBILL_LEADIN.PICKINGBILLBATCHNO, WAYBILL_LEADIN.WAREHOUSEAREAQTY, WAYBILL_LEADIN.WAREHOUSEAREAWAY, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHID, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHNO, WAYBILL_LEADIN.CREATEUSERID, WAYBILL_LEADIN.UPDATEUSERID, WAYBILL_LEADIN.CREATETIME, WAYBILL_LEADIN.UPDATETIME, WAYBILL_LEADIN.BILL_STATE, WAYBILL_LEADIN.OLDBILL_STATE, WAYBILL_LEADIN.STATE_DESC , WAYBILL_LEADIN.costlyflag , WAYBILL_LEADIN.Paymentmodeid, WAYBILL_LEADIN.Buyermessage, :"SYS_B_01" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_02"=:"SYS_B_03" And ALLOT_OCCUPY_FLAG = :"SYS_B_04" and WAREHOUSEID=:"SYS_B_05" And nvl(DELIVERID, :"SYS_B_06") = :"SYS_B_07" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_08") and Not Exists ( Select :"SYS_B_09" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_10" And Base_Shopgroup.Enableflag = :"SYS_B_11" And Base_Shopgroup_Shop.Shopid = Waybill_Leadin.Shopid And Base_Shopgroup_Shop.warehouseid = Waybill_Leadin.warehouseid ) Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc )
9hy85jupdj6qt select count(:"SYS_B_0") from (SELECT WAYBILL_HANDINGBATCH.BATCHBILLID, WAYBILL_HANDINGBATCH.BATCHBILLNO, WAYBILL_HANDINGBATCH.RF_FLAG, WAYBILL_HANDINGBATCH.WAREHOUSEID, WAYBILL_HANDINGBATCH.DELIVERID, WAYBILL_HANDINGBATCH.POSID, WAYBILL_HANDINGBATCH.DEVICE_CODE, WAYBILL_HANDINGBATCH.ORDERBILL_QTY, WAYBILL_HANDINGBATCH.PRINTFLAG, WAYBILL_HANDINGBATCH.PRINTNUM, WAYBILL_HANDINGBATCH.PRINTDATE, WAYBILL_HANDINGBATCH.PRINTUSERID, WAYBILL_HANDINGBATCH.TRUCK_NUMBER, WAYBILL_HANDINGBATCH.TRUCK_PEOPLE, WAYBILL_HANDINGBATCH.HANDINGUSERID, WAYBILL_HANDINGBATCH.HANDINGTIME, WAYBILL_HANDINGBATCH.CREATEUSERID, WAYBILL_HANDINGBATCH.CREATETIME, WAYBILL_HANDINGBATCH.BILL_STATE, WAYBILL_HANDINGBATCH.OLDBILL_STATE, WAYBILL_HANDINGBATCH.STATE_DESC, WAYBILL_HANDINGBATCH.WEIGHT_TOTAL, WAYBILL_HANDINGBATCH.FINISHDATE, WAYBILL_HANDINGBATCH.FINISHUSERID FROM WAYBILL_HANDINGBATCH where :"SYS_B_1"=:"SYS_B_2" AND WAYBILL_HANDINGBATCH.WAREHOUSEID=:"SYS_B_3 " and WAYBILL_HANDINGBATCH.deliverid=:"SYS_B_4" Order By BATCHBILLNO desc, STATE_DESC)
9rdgpzbfxaz5w INSERT INTO WAYBILL_PACKAGE (SYSTEMID, WAYBILL_PACKAGEID, WAYBILL_PACKAGENO, MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, SHOPID, OWNERID, ORDERTYPEID, WAREHOUSEID, INPUTTYPEID, PACKAGE_VARIETYQTY, PACKAGE_DETAILQTY, PACKAGE_QTY, PACKAGE_SALEAMOUNT, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, CONSIGN_WEIGHT, PACKAGING_SKUID, PACKAGING_COST, RECEIVABLE_AMOUNT, SCANNO, DELIVERID, DELIVERNO, DELIVERNOPRINTFLAG, PRINTNUM, PICKINGBILLID, PICKINGBILLNO, BATCHBILLID, BATCHBILLNO, CREATEUSERID, UPDATEUSERID, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, PACKAGE_SERIAL, WAYBILLID, WAYBILLNO, POSID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, INVOICEFLAG, PAYMENTFLAG, COSTLYFLAG, PAYMENTMODEID, BUYERMESSAGE, ORDERTIME, INVOICE_NAME, INVOICE_CONTENT, DELIVERY_COST, PLATFORMID, BOXNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, INVOICE_AMOUNT, PACKAGE_NUMB ER, SALESODER_CODNO) SELECT P.SYSTEMID, :B1 , :B4 , R.MOPOCSALESORDERBILLID, R.OUTERSALESORDERBILLID, R.SHOPID, R.OWNERID, R.ORDERTYPEID, R.WAREHOUSEID, S.INPUTTYPEID, P.PACKAGE_VARIETYQTY, P.PACKAGE_DETAILQTY, P.PACKAGE_QTY, R.ORDER_SALEAMOUNT, P.GOODS_WEIGHT, 0, 0, NULL, 0, DECODE(S.PAYMENTMODEID, 'COD', S.RECEIVABLE_AMOUNT, 0), NULL, R.DELIVERID, R.WAYBILLID, 'false', 0, R.PICKINGBILLID, R.PICKINGBILLNO, NULL, NULL, :B3 , :B3 , SYSDATE, SYSDATE, R.BILL_STATE, R.BILL_STATE, R.STATE_DESC, 1, R.WAYBILLID, R.WAYBILLNO, '*****', R.RECEIVERNAME, R.RECEIVERADDRESS, R.RECEIVERZIP, R.RECEIVERSTATE, R.RECEIVERCITY, R.RECEIVERDISTRICT, R.RECEIVERMOBILE, R.RECEIVERPHONE, R.INVOICEFLAG, R.PAYMENTFLAG, R.COSTLYFLAG, R.PAYMENTMODEID, R.BUYERMESSAGE, R.ORDERTIME, S.INVOICE_NAME, S.INVOICE_CONTENT, S.DELIVERY_COST, S.PLATFORMID, R.BOXNO, R.PICKINGBILLBATCHID, R.PICKINGBILLBATCHNO, S.INVOICE_AMOUNT, 1, S.SALESODER_CODNO FROM (SELECT C OUNT(DISTINCT T.SKUID) PACKAGE_VARIETYQTY, COUNT(*) PACKAGE_DETAILQTY, SUM(T.PACKAGE_QTY) PACKAGE_QTY, SUM(NVL(T.PACKAGE_SALEAMOUNT, 0)) PACKAGE_SALEAMOUNT, SUM(T.QC_WEIGHT) GOODS_WEIGHT, T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID FROM WAYBILLDETAIL_PACKAGE T WHERE T.WAYBILL_PACKAGEID = :B1 GROUP BY T.MOPOCSALESORDERBILLID, T.WAYBILL_PACKAGEID, T.WAYBILL_PACKAGENO, T.SYSTEMID) P, WAYBILL_COLLECT R, SALESORDER_BILL S WHERE P.MOPOCSALESORDERBILLID = R.MOPOCSALESORDERBILLID AND R.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID AND R.MOPOCSALESORDERBILLID = :B2
a1bq05mx2wp39begin Picking_Bill_Consign30(AS_SYSTEMID=>:AS_SYSTEMID, AS_PICKINGBILLID=>:AS_PICKINGBILLID, AS_PICKINGBILLNO=>:AS_PICKINGBILLNO, AS_PRINTSTATE=>:AS_PRINTSTATE, AS_BILLSTATE=>:AS_BILLSTATE, AS_CONSIGNUSERID=>:AS_CONSIGNUSERID, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
ags6vx459vc0s INSERT INTO SALESORDER_CONSIGNLIST_TEMP (TITLE, SORDERID, OUTSORDERID, JOBNO, SHOPNAME, SHOPCODE, SHOPID, OWNERID, WAREHOUSEID, ORDERTIME, PAYMENTMODE, CONSIGN_WAREHOUSE, CONSIGN_CENTER, CONSIGN_SITE, CONSIGN_PICK, CONSIGN_DELIVER, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, DELIVERTIME, CONSIGN_NOTIFY, CONSIGNTIME, ORDER_SALEAMOUNT, RECEIVABLE_AMOUNT, DELIVERY_COST, DISCOUNT_AMOUNT, OTHER_AMOUNT, REMARK, CONSIGN_NEED, RETURN_REMIND, RETURN_ADDRESS, RETURN_RECEIVER, RETURN_ZIP, RETURN_PHONE, RETURN_POLICY, CODFLAG, GOODS_TOTALQTY) SELECT T.TITLE, T.SORDERID, T.OUTSORDERID, T.JOBNO, T.SHOPNAME, T.SHOPCODE, R.SHOPID, R.OWNERID, R.WAREHOUSEID, T.ORDERTIME, T.PAYMENTMODE, T.CONSIGN_WAREHOUSE, T.CONSIGN_CENTER, T.CONSIGN_SITE, T.CONSIGN_PICK, T.CONSIGN_DELIVER, T.RECEIVERNAME, T.RECEIVERADDRESS, T.RECEIVERZIP, T.RECEIVERSTATE, T.RECEIVERCITY, T.RECEIVER DISTRICT, T.RECEIVERMOBILE, T.RECEIVERPHONE, T.DELIVERTIME, T.CONSIGN_NOTIFY, T.CONSIGNTIME, T.ORDER_SALEAMOUNT, T.RECEIVABLE_AMOUNT, T.DELIVERY_COST, T.DISCOUNT_AMOUNT, T.OTHER_AMOUNT, T.REMARK, T.CONSIGN_NEED, T.RETURN_REMIND, T.RETURN_ADDRESS, T.RETURN_RECEIVER, T.RETURN_ZIP, T.RETURN_PHONE, T.RETURN_POLICY, T.CODFLAG, T.GOODS_TOTALQTY FROM IF_SALESORDER_CONSIGNLIST T, SALESORDER_BILL R WHERE T.SORDERID = R.MOPOCSALESORDERBILLID
ah0gcgvg8d726 INSERT INTO SALESORDER_BILL_INTERCEPT (MOPOCSALESORDERBILLID, OUTERSALESORDERBILLID, MOPOCSOURCEORDERBILLID, OUTERSOURCEORDERBILLID, SHOPID, OWNERID, PLATFORMID, PLATFORMSTATUS, ORDERTYPEID, INPUTTYPEID, WAREHOUSEID, ORDER_VARIETYQTY, ORDER_DETAILQTY, ORDER_QTY, ORDER_SALEAMOUNT, ORDER_WEIGHT, ASSIGN_QTY, PICKING_QTY, QC_VARIETYQTY, QC_QTY, QC_SALEAMOUNT, QC_WEIGHT, CONSIGN_VARIETYQTY, CONSIGN_QTY, CONSIGN_SALEAMOUNT, CONSIGN_WEIGHT, BUYERNICK, BUYEREMAIL, BUYERMESSAGE, CUSTOMERID, RECEIVERNAME, RECEIVERADDRESS, RECEIVERZIP, RECEIVERSTATE, RECEIVERCITY, RECEIVERDISTRICT, RECEIVERMOBILE, RECEIVERPHONE, ORDERTIME, ENTERHEADQUARTERSTIME, UNITEHEADQUARTERSTIME, DISTRIBUTETIME, ENTERWAREHOUSETIME, UNITEWAREHOUSETIME, IMPORTTIME, IMPORTUSERID, MERGETIME, MERGEUSERID, WAITINGTIME, WAITINGUSERID, CANCELWAITINGTIME, CANCELWAITINGUSERID, CANCELORDERTIME, CANCELORDERUSERID, ACTUALCANCELTIME, ACTUALCANCELUSERID, ORDERPRINTTIME, ORDERPRINTUSE RID, ASSIGNORDERTIME, ASSIGNORDERUSERID, QCTIME, QCUSERID, ACTUALSHORTTIME, ACTUALSHORTUSERID, PACKTIME, PACKUSERID, WAYBILLTIME, WAYBILLUSERID, HANDINGTIME, HANDINGUSERID, CONSIGNTIME, CONSIGNUSERID, ENDTIME, ENDUSERID, ACCOUNTDATE, ACCOUNTUSERID, MODIFIEDTIME, SHORTFLAG, ACTUALSHORTFLAG, UNITEFLAG, ACCOUNTFLAG, VOUCHERFLAG, INNERSTATUS, REFUNDSTATUS, STOCKSTATUS, GOODS_WEIGHT, OTHERSGOODS_WEIGHT, DELIVERID, DELIVERNO, DELIVERYMODEID, DELIVERYTIME, RETURNMODEID, PAYMENTMODEID, REFUND_MODEID, PACKAGING_MODEID, PACKAGING_COST, PACKAGING_SKUID, RECEIVABLE_AMOUNT, GOODS_PAYMENT, DELIVERY_COST, INVOICE_AMOUNT, ACCOUNT_PAID, SHOPPING_VOUCHER, ACCOUNT_BALANCE, PAYTIME, INVOICEFLAG, INVOICE_NAME, INVOICE_CONTENT, ORDER_DISCOUNT, GROUPORDERFLAG, ADVANCEORDERFLAG, PAYMENTFLAG, BLENDFLAG, RETURNREASONDESC, WAYBILLID, WAYBILLNO, PICKINGBILLID, PICKINGBILLNO, PICKINGBILLBATCHID, PICKINGBILLBATCHNO, ORDERMOVEINGBILLBATCHID, ORDERMOVEIN GBILLBATCHNO, WAREHOUSEAREAQTY, WAREHOUSEAREAWAY, CREATETIME, UPDATETIME, BILL_STATE, OLDBILL_STATE, STATE_DESC, COSTLYFLAG, FROMSYSTEM) SELECT T.MOPOCSALESORDERBILLID, T.OUTERSALESORDERBILLID, T.MOPOCSOURCEORDERBILLID, T.OUTERSOURCEORDERBILLID, T.SHOPID, T.OWNERID, T.PLATFORMID, T.PLATFORMSTATUS, T.ORDERTYPEID, T.INPUTTYPEID, T.WAREHOUSEID, T.ORDER_VARIETYQTY, T.ORDER_DETAILQTY, T.ORDER_QTY, T.ORDER_SALEAMOUNT, T.ORDER_WEIGHT, T.ASSIGN_QTY, T.PICKING_QTY, T.QC_VARIETYQTY, T.QC_QTY, T.QC_SALEAMOUNT, T.QC_WEIGHT, T.CONSIGN_VARIETYQTY, T.CONSIGN_QTY, T.CONSIGN_SALEAMOUNT, T.CONSIGN_WEIGHT, T.BUYERNICK, T.BUYEREMAIL, T.BUYERMESSAGE, T.CUSTOMERID, T.RECEIVERNAME, T.RECEIVERADDRESS, T.RECEIVERZIP, T.RECEIVERSTATE, T.RECEIVERCITY, T.RECEIVERDISTRICT, T.RECEIVERMOBILE, T.RECEIVERPHONE, T.ORDERTIME, T.ENTERHEADQUARTERSTIME, T.UNITEHEADQUARTERSTIME, T.DISTRIBUTETIME, T.ENTERWAREHOUSETIME, T.UNITEWAREHOUSETIME, T.IMPORTTIME, T.IMPORTUSERID, T.MERGETIME, T.MERGEUSERID, T.WAITINGTIME, T.WAITINGUSERID, T.CANCELWAITINGTIME, T.CANCELWAITINGUSERID, SYSDATE, :B2 , SYSDATE, :B2 , T.ORDERPRINTTIME, T.ORDERPRINTUSERID, T.ASSIGNORDERTIME, T.ASSIGNORDERUSERID, T.QCTIME, T.QCUSERID, T.ACTUALSHORTTIME, T.ACTUALSHORTUSERID, T.PACKTIME, T.PACKUSERID, T.WAYBILLTIME, T.WAYBILLUSERID, T.HANDINGTIME, T.HANDINGUSERID, T.CONSIGNTIME, T.CONSIGNUSERID, T.ENDTIME, T.ENDUSERID, T.ACCOUNTDATE, T.ACCOUNTUSERID, T.MODIFIEDTIME, T.SHORTFLAG, T.ACTUALSHORTFLAG, T.UNITEFLAG, T.ACCOUNTFLAG, T.VOUCHERFLAG, T.INNERSTATUS, T.REFUNDSTATUS, T.STOCKSTATUS, T.GOODS_WEIGHT, T.OTHERSGOODS_WEIGHT, T.DELIVERID, T.DELIVERNO, T.DELIVERYMODEID, T.DELIVERYTIME, T.RETURNMODEID, T.PAYMENTMODEID, T.REFUND_MODEID, T.PACKAGING_MODEID, T.PACKAGING_COST, T.PACKAGING_SKUID, T.RECEIVABLE_AMOUNT, T.GOODS_PAYMENT, T.DELIVERY_COST, T.INVOICE_AMOUNT, T.ACCOUNT_PAID, T.SHOPPING_VOUCHER, T.ACCOUNT_BALANCE, T.PAYTIME, T.INVOIC EFLAG, T.INVOICE_NAME, T.INVOICE_CONTENT, T.ORDER_DISCOUNT, T.GROUPORDERFLAG, T.ADVANCEORDERFLAG, T.PAYMENTFLAG, T.BLENDFLAG, T.RETURNREASONDESC, T.WAYBILLID, T.WAYBILLNO, T.PICKINGBILLID, T.PICKINGBILLNO, T.PICKINGBILLBATCHID, T.PICKINGBILLBATCHNO, T.ORDERMOVEINGBILLBATCHID, T.ORDERMOVEINGBILLBATCHNO, T.WAREHOUSEAREAQTY, T.WAREHOUSEAREAWAY, T.CREATETIME, SYSDATE, T.BILL_STATE, T.OLDBILL_STATE, T.STATE_DESC, T.COSTLYFLAG, T.FROMSYSTEM FROM SALESORDER_BILL T, WAYBILL_LEADIN_JOBTEMP TP WHERE TP.SYSTEMID = :B1 AND TP.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND EXISTS (SELECT 1 FROM SALESORDER_BILL_INTERCEPT_TEMP D WHERE D.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID)
apn3u2a6rx4s0 SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT SALESORDER_BILL.salesoder_codno, SALESORDER_BILL.STATE_DESC, SALESORDER_BILL.MOPOCSALESORDERBILLID, SALESORDER_BILL.OUTERSALESORDERBILLID, SALESORDER_BILL.MOPOCSOURCEORDERBILLID, SALESORDER_BILL.OUTERSOURCEORDERBILLID, SALESORDER_BILL.DELIVERID, SALESORDER_BILL.DELIVERNO, SALESORDER_BILL.DELIVERYMODEID, SALESORDER_BILL.DELIVERYTIME, SALESORDER_BILL.SHOPID, SALESORDER_BILL.OWNERID, SALESORDER_BILL.BUYERNICK, SALESORDER_BILL.BUYEREMAIL, SALESORDER_BILL.BUYERMESSAGE, SALESORDER_BILL.CUSTOMERID, SALESORDER_BILL.RECEIVERNAME, SALESORDER_BILL.RECEIVERADDRESS, SALESORDER_BILL.RECEIVERZIP, SALESORDER_BILL.RECEIVERSTATE, SALESORDER_BILL.RECEIVERCITY, SALESORDER_BILL.RECEIVERDISTRICT, SALESORDER_BILL.RECEIVERMOBILE, SALESORDER_BILL.RECEIVERPHONE, SALESORDER_BILL.PLATFORMID, SALESORDER_BILL.PLATFORMSTATUS, SALESORDER_BILL.ORDERTYPEID, SALESORDER_BILL.INPUTTYPEID, SALESORDER_BILL.WAREHOUSEID, SALESORDER_BILL.ORDER_VARIE TYQTY, SALESORDER_BILL.ORDER_DETAILQTY, SALESORDER_BILL.ORDER_QTY, SALESORDER_BILL.ORDER_SALEAMOUNT, SALESORDER_BILL.ORDER_WEIGHT, SALESORDER_BILL.ASSIGN_QTY, SALESORDER_BILL.PICKING_QTY, SALESORDER_BILL.QC_VARIETYQTY, SALESORDER_BILL.QC_QTY, SALESORDER_BILL.QC_SALEAMOUNT, SALESORDER_BILL.QC_WEIGHT, SALESORDER_BILL.CONSIGN_VARIETYQTY, SALESORDER_BILL.CONSIGN_QTY, SALESORDER_BILL.CONSIGN_SALEAMOUNT, SALESORDER_BILL.CONSIGN_WEIGHT, SALESORDER_BILL.GOODS_WEIGHT, SALESORDER_BILL.OTHERSGOODS_WEIGHT, SALESORDER_BILL.ORDERTIME, SALESORDER_BILL.ENTERHEADQUARTERSTIME, SALESORDER_BILL.UNITEHEADQUARTERSTIME, SALESORDER_BILL.DISTRIBUTETIME, SALESORDER_BILL.ENTERWAREHOUSETIME, SALESORDER_BILL.UNITEWAREHOUSETIME, SALESORDER_BILL.IMPORTTIME, SALESORDER_BILL.IMPORTUSERID, SALESORDER_BILL.MERGETIME, SALESORDER_BILL.MERGEUSERID, SALESORDER_BILL.WAITINGTIME, SALESORDER_BILL.WAITINGUSERID, SALESORDER_BILL.CANCELWAITINGTIME, SALESORDER_BILL.CANCELWAITINGUSERID, SALESORDER_BIL L.CANCELORDERTIME, SALESORDER_BILL.CANCELORDERUSERID, SALESORDER_BILL.ACTUALCANCELTIME, SALESORDER_BILL.ACTUALCANCELUSERID, SALESORDER_BILL.ORDERPRINTTIME, SALESORDER_BILL.ORDERPRINTUSERID, SALESORDER_BILL.ASSIGNORDERTIME, SALESORDER_BILL.ASSIGNORDERUSERID, SALESORDER_BILL.PICKINGTIME, SALESORDER_BILL.PICKINGUSERID, SALESORDER_BILL.QCTIME, SALESORDER_BILL.QCUSERID, SALESORDER_BILL.ACTUALSHORTTIME, SALESORDER_BILL.ACTUALSHORTUSERID, SALESORDER_BILL.PACKTIME, SALESORDER_BILL.PACKUSERID, SALESORDER_BILL.WAYBILLTIME, SALESORDER_BILL.WAYBILLUSERID, SALESORDER_BILL.HANDINGTIME, SALESORDER_BILL.HANDINGUSERID, SALESORDER_BILL.CONSIGNTIME, SALESORDER_BILL.CONSIGNUSERID, SALESORDER_BILL.ENDTIME, SALESORDER_BILL.ENDUSERID, SALESORDER_BILL.ACCOUNTDATE, SALESORDER_BILL.ACCOUNTUSERID, SALESORDER_BILL.MODIFIEDTIME, SALESORDER_BILL.SHORTFLAG, SALESORDER_BILL.ACTUALSHORTFLAG, SALESORDER_BILL.UNITEFLAG, SALESORDER_BILL.ACCOUNTFLAG, SALESORDER_BILL.VOUCHERFLAG, SALESORDER_ BILL.INNERSTATUS, SALESORDER_BILL.REFUNDSTATUS, SALESORDER_BILL.STOCKSTATUS, SALESORDER_BILL.RETURNMODEID, SALESORDER_BILL.PAYMENTMODEID, SALESORDER_BILL.REFUND_MODEID, SALESORDER_BILL.PACKAGING_MODEID, SALESORDER_BILL.PACKAGING_COST, SALESORDER_BILL.PACKAGING_SKUID, SALESORDER_BILL.RECEIVABLE_AMOUNT, SALESORDER_BILL.GOODS_PAYMENT, SALESORDER_BILL.DELIVERY_COST, SALESORDER_BILL.INVOICE_AMOUNT, SALESORDER_BILL.ACCOUNT_PAID, SALESORDER_BILL.SHOPPING_VOUCHER, SALESORDER_BILL.ACCOUNT_BALANCE, SALESORDER_BILL.PAYTIME, SALESORDER_BILL.INVOICEFLAG, SALESORDER_BILL.INVOICE_NAME, SALESORDER_BILL.INVOICE_CONTENT, SALESORDER_BILL.ORDER_DISCOUNT, SALESORDER_BILL.GROUPORDERFLAG, SALESORDER_BILL.ADVANCEORDERFLAG, SALESORDER_BILL.PAYMENTFLAG, SALESORDER_BILL.BLENDFLAG, SALESORDER_BILL.RETURNREASONDESC, SALESORDER_BILL.WAYBILLID, SALESORDER_BILL.WAYBILLNO, SALESORDER_BILL.PICKINGBILLID, SALESORDER_BILL.PICKINGBILLNO, SALESORDER_BILL.PICKINGBILLBATCHID, SALESORDER_BILL.PI CKINGBILLBATCHNO, SALESORDER_BILL.ORDERMOVEINGBILLBATCHID, SALESORDER_BILL.ORDERMOVEINGBILLBATCHNO, SALESORDER_BILL.WAREHOUSEAREAQTY, SALESORDER_BILL.WAREHOUSEAREAWAY, SALESORDER_BILL.CREATETIME, SALESORDER_BILL.UPDATETIME, SALESORDER_BILL.BILL_STATE, SALESORDER_BILL.OLDBILL_STATE, salesorder_bill.costlyflag, salesorder_bill.DANGEROUS_FLAG, salesorder_bill.TRAVELSFLAG, SALESORDER_BILL.batchbillid, SALESORDER_BILL.batchbillno FROM SALESORDER_BILL where WAREHOUSEID=:"SYS_B_0" AND RECEIVERMOBILE = :"SYS_B_1" Order By MOPOCSALESORDERBILLID) A WHERE ROWNUM <= :"SYS_B_2" ) WHERE RN > :"SYS_B_3"
aq8yqxyyb40nnupdate sys.job$ set this_date=:1 where job=:2
as0uaw3pvcz1cSELECT COUNT(*) FROM USER_OBJECTS WHERE OBJECT_TYPE = 'SEQUENCE' AND OBJECT_NAME = UPPER(:B1 )
awrr2c9hqf7p0select sysdate+:"SYS_B_0"/:"SYS_B_1" from dual
b9vkrdqqk15mrSELECT COUNT(1) FROM WAYBILL_PACKAGE T WHERE T.MOPOCSALESORDERBILLID = :B1
bypmfr5wammfu Select WAYBILL_HANDINGBATCH.BATCHBILLID, Substr(waybill_handingbatch.batchbillno, Length(waybill_handingbatch.batchbillno)-:"SYS_B_0", :"SYS_B_1") billnoendstr, WAYBILL_HANDINGBATCH.BATCHBILLNO, WAYBILL_HANDINGBATCH.WAREHOUSEID, base_warehouse.warehousename, WAYBILL_HANDINGBATCH.DELIVERID, (Case When WAYBILL_HANDINGBATCH.DELIVERGROUPFLAG = :"SYS_B_2" Then (select companyname from base_company where base_company.companyid = WAYBILL_HANDINGBATCH.Deliverid) Else (select groupname from base_deliver where base_deliver.delivergroupid = WAYBILL_HANDINGBATCH.Deliverid) End) COMPANYNAME, WAYBILL_HANDINGBATCH.POSID, WAYBILL_HANDINGBATCH.DEVICE_CODE, WAYBILL_HANDINGBATCH.ORDERBILL_QTY, WAYBILL_HANDINGBATCH.PRINTFLAG, WAYBILL_HANDINGBATCH.PRINTNUM, WAYBILL_HANDINGBATCH.PRINTDATE, WAYBILL_HANDINGBATCH.PRINTUSERID, WAYBILL_HANDINGBATCH.TRUCK_NUMBER, WAYBILL_HANDINGBATCH.TRUCK_PEOPLE, ( select a.username from sys_user a where a.userid=WAYBILL_HANDINGBATCH .HANDINGUSERID) as HANDINGUSERID, WAYBILL_HANDINGBATCH.HANDINGTIME, WAYBILL_HANDINGBATCH.CREATEUSERID, WAYBILL_HANDINGBATCH.CREATETIME, WAYBILL_HANDINGBATCH.BILL_STATE, WAYBILL_HANDINGBATCH.OLDBILL_STATE, WAYBILL_HANDINGBATCH.STATE_DESC, WAYBILL_HANDINGBATCH.WEIGHT_TOTAL, WAYBILL_HANDINGBATCH.FINISHDATE, WAYBILL_HANDINGBATCH.FINISHUSERID, Waybill_Handingbatch_Detail.Mopocsalesorderbillid, Waybill_Handingbatch_Detail.Outersalesorderbillid, Waybill_Handingbatch_Detail.Consign_Weight, Waybill_Package.Deliverno, Waybill_Handingbatch_Detail.Waybill_Packageno, sysdate as dtnow, rownum, Waybill_Package.Package_Serial From Waybill_Handingbatch_Detail Left Join Waybill_Package On Waybill_Handingbatch_Detail.Waybill_Packageid = Waybill_Package.Waybill_Packageid Left Join Waybill_Packagehangding On Waybill_Handingbatch_Detail.Waybill_Packageid = Waybill_Packagehangding.Waybill_Packageid left join WAYBILL_HANDINGBATCH on Waybill_Handingbatch_Detail.Batchbillid = WAYBILL_HANDINGBAT CH.BATCHBILLID left join base_warehouse on WAYBILL_HANDINGBATCH.WAREHOUSEID = base_warehouse.warehouseid Where Waybill_Handingbatch_Detail.Batchbillid = :Arg_Batchbillid
c412fnd0cdmc0SELECT COUNT(1) FROM IF_SALESORDER_BILL_INTERCEPT T WHERE T.MOPOCSALESORDERBILLID = :B1 AND NOT EXISTS (SELECT 1 FROM SALESORDER_BILL A WHERE A.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND A.BILL_STATE IN ('05', '06', '07', '08') UNION SELECT 1 FROM SALESRETURN_BILL S WHERE T.MOPOCSALESORDERBILLID = S.SALESORDERID AND S.BILL_STATE IN ('02', '03'))
cg6hra1s3mg6vSELECT * FROM (SELECT S.SALESORDERBILLSTATEID, S.MOPOCSALESORDERBILLID, S.OUTERSALESORDERBILLID, MOPOCSOURCEORDERBILLID, OUTERSOURCEORDERBILLID, SHOPID, S.OWNERID, ORDERTYPEID, S.WAREHOUSEID, QTY, BILLSTATE, OLDBILL_STATE, STATE_DESC, CREATETIME, CREATEUSERID, S.DELIVERID, DELIVERNO, WEIGHT, WAYBILL_PACKAGEID, INPUTTYPEID, S.RECORDTIME, FROMSYSTEM, TASKSTATE , NVL(G.GROUPNO, :"SYS_B_0") GROUPNO FROM IF_SALESORDER_BILLSTATE S LEFT JOIN IF_SALESORDER_GROUP G ON G.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID WHERE S.TASKSTATE =:"SYS_B_1" AND S.BILLSTATE > :"SYS_B_2" ORDER BY RECORDTIME) WHERE ROWNUM < :"SYS_B_3"
ckk296gsdch3bSelect Systemid, Availablesaleid, Departmentid, Ownerid, Warehouseid, Skuid, Availableqty, Stateflag, Createdate, Updatedate, Recordtime, Onwayqty, Fororder_Qty From If_Inventory_Availablesale where taskstate=:"SYS_B_0" and rownum <= :"SYS_B_1" and OWNERID<>:"SYS_B_2" AND OWNERID<>:"SYS_B_3" AND OWNERID<>:"SYS_B_4" order by availablesaleid asc
cm5vu20fhtnq1select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cumjq42201t37select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, env, field1, next_date from sys.job$ j, sys.user$ u1, sys.user$ u2, sys.user$ u3 where job=:1 and (next_date <= sysdate or :2 != 0) and lowner = u1.name and powner = u2.name and cowner = u3.name
cwz9p369sva5wSELECT COUNT(1) FROM SALESORDER_BILL_INTERCEPT T WHERE T.MOPOCSALESORDERBILLID = :B1 AND NOT EXISTS (SELECT 1 FROM SALESORDER_BILL A WHERE A.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND A.BILL_STATE IN ('05', '06', '07', '08') UNION SELECT 1 FROM SALESRETURN_BILL S WHERE T.MOPOCSALESORDERBILLID = S.SALESORDERID AND S.BILL_STATE IN ('02', '03'))
d1bcnr2fp1hqqINSERT INTO IF_INVENTORY_AVAILABLESALE (SYSTEMID, AVAILABLESALEID, DEPARTMENTID, OWNERID, WAREHOUSEID, SKUID, AVAILABLEQTY, FORORDER_QTY, ONWAYQTY, STATEFLAG, CREATEDATE, UPDATEDATE) (SELECT B.SYSTEMID, GET_SYS_PREFIXION(B.SYSTEMID) || TO_CHAR(SYSDATE, 'yymmdd') || F_GET_LPADSEQUENCE_VALUE('2', INVENTORY_AVAILABLESALE_SEQ.NEXTVAL, 13, '0'), B.DEPARTMENTID, B.OWNERID, B.WAREHOUSEID, B.SKUID, B.AVAILABLESALEQTY, :B5 , B.ONWAYQTY, '01', SYSDATE, SYSDATE FROM INVENTORY_OWNER B WHERE B.SKUID = :B4 AND B.DEPARTMENTID = :B3 AND :B2 = B.OWNERID AND :B1 = B.WAREHOUSEID)
d6fx4dcuz5a30UPDATE SALESORDER_BILL T SET T.BILL_STATE = '04', T.STATE_DESC = '质检确认', (T.PICKING_QTY, T.QC_VARIETYQTY, T.QC_QTY, T.QC_SALEAMOUNT, T.QC_WEIGHT, T.QCTIME, T.QCUSERID) = (SELECT S.QC_QTY, S.QC_VARIETYQTY, S.QC_QTY, S.QC_SALEAMOUNT, S.GOODS_WEIGHT, SYSDATE, :B1 FROM WAYBILL_DELIVERY_TEMP S WHERE T.MOPOCSALESORDERBILLID = S.MOPOCSALESORDERBILLID) WHERE EXISTS (SELECT 1 FROM WAYBILL_DELIVERY_TEMP TP WHERE TP.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID)
dn8w89jx7k958SELECT /*+ OPAQUE_TRANSFORM */ "SALESORDERBILLSTATEID", "MOPOCSALESORDERBILLID", "OUTERSALESORDERBILLID", "OWNERID", "WAREHOUSEID", "BILLSTATE", "CREATETIME", "DELIVERID", "RECORDTIME" FROM "IF_SALESORDER_BILLSTATE" "IF_SALESORDER_BILLSTATE" WHERE "CREATETIME">=:1 AND "BILLSTATE"=:"SYS_B_0"
f1qpr4uk5rbtm SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT WAYBILL_HANDINGBATCH.BATCHBILLID, WAYBILL_HANDINGBATCH.BATCHBILLNO, WAYBILL_HANDINGBATCH.RF_FLAG, WAYBILL_HANDINGBATCH.WAREHOUSEID, WAYBILL_HANDINGBATCH.DELIVERID, WAYBILL_HANDINGBATCH.POSID, WAYBILL_HANDINGBATCH.DEVICE_CODE, WAYBILL_HANDINGBATCH.ORDERBILL_QTY, WAYBILL_HANDINGBATCH.PRINTFLAG, WAYBILL_HANDINGBATCH.PRINTNUM, WAYBILL_HANDINGBATCH.PRINTDATE, WAYBILL_HANDINGBATCH.PRINTUSERID, WAYBILL_HANDINGBATCH.TRUCK_NUMBER, WAYBILL_HANDINGBATCH.TRUCK_PEOPLE, WAYBILL_HANDINGBATCH.HANDINGUSERID, WAYBILL_HANDINGBATCH.HANDINGTIME, WAYBILL_HANDINGBATCH.CREATEUSERID, WAYBILL_HANDINGBATCH.CREATETIME, WAYBILL_HANDINGBATCH.BILL_STATE, WAYBILL_HANDINGBATCH.OLDBILL_STATE, WAYBILL_HANDINGBATCH.STATE_DESC, WAYBILL_HANDINGBATCH.WEIGHT_TOTAL, WAYBILL_HANDINGBATCH.FINISHDATE, WAYBILL_HANDINGBATCH.FINISHUSERID FROM WAYBILL_HANDINGBATCH where :"SYS_B_0"=:"SYS_B_1" AND WAYBILL_HANDINGBATCH.WAREHOUSEID=:"SYS_B_ 2" and WAYBILL_HANDINGBATCH.deliverid=:"SYS_B_3" Order By BATCHBILLNO desc, STATE_DESC) A WHERE ROWNUM <= :"SYS_B_4" ) WHERE RN > :"SYS_B_5"
f319mcpzrcydhUPDATE SALESORDER_BILL T SET T.ASSIGNORDERTIME = SYSDATE, T.ASSIGNORDERUSERID = :B4 , T.PICKINGTIME = SYSDATE, T.PICKINGUSERID = :B3 , T.BILL_STATE = '03', T.STATE_DESC = '分配确认', T.PICKINGBILLID = NVL(T.PICKINGBILLID, :B2 ), T.PICKINGBILLNO = NVL(T.PICKINGBILLNO, :B1 ), T.PICKING_QTY = (SELECT SUM(A.PICKING_QTY) FROM PICKING_BILLSOURCE A WHERE A.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID) WHERE EXISTS (SELECT 1 FROM PICKING_BILLSOURCE S WHERE S.MOPOCSALESORDERBILLID = T.MOPOCSALESORDERBILLID AND S.PICKINGBILLID = :B2 )
f9qxutrsfs9m6 select count(:"SYS_B_0") from (select waybill_packagehangding.systemid, waybill_packagehangding.waybill_packageid, waybill_packagehangding.waybill_packageno, waybill_packagehangding.package_serial, waybill_packagehangding.package_number, waybill_packagehangding.mopocsalesorderbillid, waybill_packagehangding.outersalesorderbillid, waybill_packagehangding.shopid, waybill_packagehangding.ownerid, waybill_packagehangding.ordertypeid, waybill_packagehangding.warehouseid, waybill_packagehangding.inputtypeid, waybill_packagehangding.package_varietyqty, waybill_packagehangding.package_detailqty, waybill_packagehangding.package_qty, waybill_packagehangding.package_saleamount, waybill_packagehangding.goods_weight, waybill_packagehangding.othersgoods_weight, waybill_packagehangding.consign_weight, waybill_packagehangding.packaging_skuid, waybill_packagehangding.packaging_cost, waybill_packagehangding.receivable_amount, waybill_packagehangding.scanno, waybill_packa gehangding.deliverid, waybill_packagehangding.deliverno, waybill_packagehangding.delivernoprintflag, waybill_packagehangding.printnum, waybill_packagehangding.pickingbillid, waybill_packagehangding.pickingbillno, waybill_packagehangding.batchbillid, waybill_packagehangding.batchbillno, waybill_packagehangding.createuserid, waybill_packagehangding.updateuserid, waybill_packagehangding.createtime, waybill_packagehangding.updatetime, waybill_packagehangding.bill_state, waybill_packagehangding.oldbill_state, waybill_packagehangding.state_desc, waybill_packagehangding.packtime, waybill_packagehangding.packuserid, waybill_packagehangding.handingtime, waybill_packagehangding.handinguserid, waybill_packagehangding.waybillid, waybill_packagehangding.waybillno, waybill_packagehangding.posid, salesorder_bill.RECEIVERNAME, salesorder_bill.RECEIVERADDRESS, salesorder_bill.RECEIVERZIP, BASE_PROVINCE.PROVINCE_NAME, BASE_CITY.CITY_NAME, BASE_AREA.AREA_NAME, salesorder_bill. RECEIVERMOBILE, salesorder_bill.RECEIVERPHONE, base_goodsinfo.goodsbarcode, PICKING_BILL.PICKINGFLAG from waybill_packagehangding, salesorder_bill, BASE_PROVINCE, BASE_CITY, BASE_AREA, base_goodsinfo, PICKING_BILL where waybill_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid AND salesorder_bill.RECEIVERSTATE = BASE_PROVINCE.PROVINCE_ID(+) AND salesorder_bill.RECEIVERCITY = BASE_CITY.CITY_ID(+) AND salesorder_bill.RECEIVERDISTRICT = BASE_AREA.AREA_ID(+) and waybill_packagehangding.packaging_skuid = base_goodsinfo.skuid(+) and waybill_packagehangding.PICKINGBILLID = picking_bill.pickingbillid(+) AND WAYBILL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND WAYBILL_PACKAGEHANGDING.OUTERSALESORDERBILLID = :"SYS_B_2" Order By CREATETIME desc, WAYBILL_PACKAGEID desc )
fg6k4m6t4cgx7SELECT KQ.CXFLAG, KQ.WAREHOUSEAREAID, KQ.SORTNO, KQ.WAREHOUSEAREACODE FROM BASE_WAREHOUSEAREA KQ, BASE_WAREHOUSECARGOSPACE HW WHERE KQ.WAREHOUSEID = :B1 AND HW.WAREHOUSEID = KQ.WAREHOUSEID AND HW.WAREHOUSEAREAID = KQ.WAREHOUSEAREAID AND KQ.ENABLEFLAG = '启用' AND HW.PURPOSEPROPERTYID = 'JX' AND HW.ENABLEFLAG = '启用' AND HW.CARGOSPACESTATEID <= '2' AND EXISTS (SELECT 1 FROM WAYBILLDETAIL_LEADIN_TEMP T, WAYBILL_LEADIN_TEMP W WHERE T.MOPOCSALESORDERBILLID = W.MOPOCSALESORDERBILLID AND W.ALLOT_OCCUPY_FLAG = 'false' AND T.OWNERID = HW.OWNERID AND T.DEPARTMENTID = HW.DEPAREMENTID AND T.WAREHOUSEID = HW.WAREHOUSEID) GROUP BY KQ.CXFLAG, KQ.WAREHOUSEAREAID, KQ.SORTNO, KQ.WAREHOUSEAREACODE ORDER BY DECODE(NVL(KQ.CXFLAG, 'false'), 'false', '1', '2'), KQ.SORTNO, KQ.WAREHOUSEAREACODE
fp6r6v4ruj77hbegin Picking_Bill_Order_Sure_Cd30(AS_SYSTEMID=>:AS_SYSTEMID, AS_ORDERBILLID=>:AS_ORDERBILLID, AS_BILLSTATE=>:AS_BILLSTATE, AS_USERID=>:AS_USERID, DESCERR=>:DESCERR); end;
g0g00yjvb0f5n Select nvl(z.Entering_Weight, :"SYS_B_0")||:"SYS_B_1" Entering_Weight, :reprintflag, s.Goodsname, g.Entering_Qty, z.packagebillno, pr.purchasereturnbillno, pr.OUTPURCHASERETURNBILLNO, decode( pr.OUTPURCHASERETURNBILLNO, null, pr.purchasereturnbillno, pr.OUTPURCHASERETURNBILLNO) printcod, z.logisticsbillno, ck.SUPPLY_DELIVERYTEL, ck.Supply_Deliveryaddress, pr.remark, ck.SUPPLY_DELIVERYCONTACT, rownum pbrp34_compute_1, decode(s.goodsno, null , s.goodsbarcode, s.goodsno ) pbrp34_compute_9, sysdate pbrp34_date_1 From Package_Billdetail g Left Join Base_Goodsinfo s On s.Skuid = g.Skuid Left Join Package_Bill z On z.Packagebillid = g.Packagebillid Left Join Base_Company Hz On Hz.Companyid = z.Ownerid Left Join Base_Warehouse Ck On Ck.Warehouseid = z.Warehouseid left join purchase_returnbill pr on (z.Logisticstypeid =:"SYS_B_2" and z.logisticsbillid = pr.purchasereturnbillid) where g.packagebillid=:arg_billid
gamdzj6zhw0wz SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( Select WAYBILL_LEADIN.SYSTEMID, WAYBILL_LEADIN.PAYTIME, WAYBILL_LEADIN.MOPOCSALESORDERBILLID, WAYBILL_LEADIN.OUTERSALESORDERBILLID, WAYBILL_LEADIN.MOPOCSOURCEORDERBILLID, WAYBILL_LEADIN.OUTERSOURCEORDERBILLID, WAYBILL_LEADIN.WAYBILLID, WAYBILL_LEADIN.WAYBILLNO, WAYBILL_LEADIN.SHOPID, WAYBILL_LEADIN.OWNERID, WAYBILL_LEADIN.ORDERTYPEID, WAYBILL_LEADIN.WAREHOUSEID, WAYBILL_LEADIN.JXFQID, WAYBILL_LEADIN.BOXNO, WAYBILL_LEADIN.ORDER_VARIETYQTY, WAYBILL_LEADIN.ORDER_DETAILQTY, WAYBILL_LEADIN.ORDER_QTY, WAYBILL_LEADIN.ASSIGN_QTY, WAYBILL_LEADIN.RECEIVABLE_AMOUNT, WAYBILL_LEADIN.RECEIVERNAME, WAYBILL_LEADIN.RECEIVERADDRESS, WAYBILL_LEADIN.RECEIVERZIP, WAYBILL_LEADIN.RECEIVERSTATE, WAYBILL_LEADIN.RECEIVERCITY, WAYBILL_LEADIN.RECEIVERDISTRICT, WAYBILL_LEADIN.RECEIVERMOBILE, WAYBILL_LEADIN.RECEIVERPHONE, WAYBILL_LEADIN.ORDERTIME, WAYBILL_LEADIN.DELIVERYTIME, WAYBILL_LEADIN.DELIVERID, WAYBILL_LEADIN.GROUPORDERFLAG, WAYBILL_LE ADIN.INVOICEFLAG, WAYBILL_LEADIN.ADVANCEORDERFLAG, WAYBILL_LEADIN.PAYMENTFLAG, WAYBILL_LEADIN.BLENDFLAG, WAYBILL_LEADIN.PICKINGBILLID, WAYBILL_LEADIN.PICKINGBILLNO, WAYBILL_LEADIN.PICKINGBILLBATCHID, WAYBILL_LEADIN.PICKINGBILLBATCHNO, WAYBILL_LEADIN.WAREHOUSEAREAQTY, WAYBILL_LEADIN.WAREHOUSEAREAWAY, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHID, WAYBILL_LEADIN.ORDERMOVEINGBILLBATCHNO, WAYBILL_LEADIN.CREATEUSERID, WAYBILL_LEADIN.UPDATEUSERID, WAYBILL_LEADIN.CREATETIME, WAYBILL_LEADIN.UPDATETIME, WAYBILL_LEADIN.BILL_STATE, WAYBILL_LEADIN.OLDBILL_STATE, WAYBILL_LEADIN.STATE_DESC , WAYBILL_LEADIN.costlyflag , WAYBILL_LEADIN.Paymentmodeid, WAYBILL_LEADIN.Buyermessage, :"SYS_B_00" as selectedflag, WAYBILL_LEADIN.INPUTTYPEID, WAYBILL_LEADIN.ORDER_SALEAMOUNT, WAYBILL_LEADIN.PLATFORMID, WAYBILL_LEADIN.CUSTOMER_MESSAGE From WAYBILL_LEADIN Where :"SYS_B_01"=:"SYS_B_02" And ALLOT_OCCUPY_FLAG = :"SYS_B_03" and WAREHOUSEID=:"SYS_B_04 " And nvl(DELIVERID, :"SYS_B_05") = :"SYS_B_06" And (WAYBILL_LEADIN.OWNERID =:"SYS_B_07") and Not Exists ( Select :"SYS_B_08" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_09" And Base_Shopgroup.Enableflag = :"SYS_B_10" And Base_Shopgroup_Shop.Shopid = Waybill_Leadin.Shopid And Base_Shopgroup_Shop.warehouseid = Waybill_Leadin.warehouseid ) Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc ) A WHERE ROWNUM <= :"SYS_B_11" ) WHERE RN > :"SYS_B_12"
ghn9v5v7n3h10UPDATE INVENTORY_OWNER B SET B.AVAILABLESALEQTY = B.AVAILABLESALEQTY + :B2 , B.ONWAYQTY=B.ONWAYQTY+:B1 WHERE B.SKUID = :B7 AND B.DEPARTMENTID = :B6 AND B.OWNERID = :B5 AND B.SYSTEMID = :B4 AND B.WAREHOUSEID = :B3
gkz1gdwyk1ubwSELECT T.BILL_STATE, T.WAREHOUSEID, T.OWNERID FROM SALESORDER_BILL T WHERE T.MOPOCSALESORDERBILLID = :B1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count190.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count640.010.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count20.000.00
Batched IO same unit count380.010.00
Batched IO single block count200.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count50.000.00
Batched IO vector read count10.000.00
Block Cleanout Optim referenced8,4261.170.36
CCursor + sql area evicted500.010.00
CPU used by this session1,117,176155.4247.57
CPU used when call started993,191138.1742.29
CR blocks created127,05617.685.41
Cached Commit SCN referenced14,8822.070.63
Commit SCN cached12,8671.790.55
DB time44,838,5906,237.951,909.41
DBWR checkpoint buffers written89,60912.473.82
DBWR checkpoints5290.070.02
DBWR object drop buffers written8880.120.04
DBWR parallel query checkpoint buffers written00.000.00
DBWR revisited being-written buffer3,786,851526.83161.26
DBWR tablespace checkpoint buffers written9,3651.300.40
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes720.010.00
DBWR undo block writes24,4963.411.04
DFO trees parallelized00.000.00
DML statements parallelized00.000.00
Effective IO time277,919,383,93638,664,182.9011,834,918.19
HSC Heap Segment Block Changes648,32390.1927.61
HSC IDL Compressed Blocks23,3553.250.99
Heap Segment Array Inserts65,5269.122.79
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued464,57164.6319.78
PX local messages recv'd00.000.00
PX local messages sent00.000.00
Parallel operations downgraded 1 to 25 pct00.000.00
Parallel operations downgraded 25 to 50 pct00.000.00
Parallel operations downgraded 50 to 75 pct00.000.00
Parallel operations downgraded 75 to 99 pct00.000.00
Parallel operations not downgraded00.000.00
Requests to/from client338,07147.0314.40
RowCR - row contention2280.030.01
RowCR attempts88,72612.343.78
RowCR hits180,30225.087.68
SMON posted for dropping temp segment00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink350.000.00
SQL*Net roundtrips to/from client338,41647.0814.41
SQL*Net roundtrips to/from dblink00.000.00
active txn count during cleanout143,42419.956.11
application wait time979,945136.3341.73
background checkpoints completed20.000.00
background checkpoints started40.000.00
background timeouts35,3344.921.50
branch node splits80.000.00
buffer is not pinned count207,839,98128,914.738,850.66
buffer is pinned count3,490,157,825485,551.24148,624.87
bytes received via SQL*Net from client190,634,78726,521.148,117.99
bytes received via SQL*Net from dblink00.000.00
bytes sent via SQL*Net to client553,242,01676,967.1123,559.26
bytes sent via SQL*Net to dblink00.000.00
calls to get snapshot scn: kcmgss642,87989.4427.38
calls to kcmgas238,14233.1310.14
calls to kcmgcs925,045128.6939.39
cell physical IO interconnect bytes461,753,964,54464,239,275.0319,663,329.41
change write time71,0509.883.03
cleanout - number of ktugct calls144,30320.086.14
cleanouts and rollbacks - consistent read gets110,16415.334.69
cleanouts only - consistent read gets12,5691.750.54
cluster key scan block gets17,8732.490.76
cluster key scans12,1981.700.52
commit batch performed7,6121.060.32
commit batch requested7,6121.060.32
commit batch/immediate performed8,6681.210.37
commit batch/immediate requested8,6681.210.37
commit cleanout failures: block lost27,8053.871.18
commit cleanout failures: buffer being written3200.040.01
commit cleanout failures: callback failure6150.090.03
commit cleanout failures: cannot pin2010.030.01
commit cleanouts397,00855.2316.91
commit cleanouts successfully completed368,06751.2115.67
commit immediate performed1,0560.150.04
commit immediate requested1,0560.150.04
commit nowait performed7,3511.020.31
commit nowait requested7,3511.020.31
commit txn count during cleanout56,3977.852.40
commit wait/nowait performed7,3511.020.31
commit wait/nowait requested7,3511.020.31
concurrency wait time157,72221.946.72
consistent changes1,079,921150.2445.99
consistent gets1,415,331,036196,901.0560,270.45
consistent gets - examination9,957,4121,385.28424.03
consistent gets direct55,538,9537,726.592,365.07
consistent gets from cache1,359,792,071189,174.4657,905.38
consistent gets from cache (fastpath)1,348,675,887187,627.9757,432.01
cursor authentications3000.040.01
data blocks consistent reads - undo records applied943,655131.2840.18
db block changes3,401,243473.18144.84
db block gets3,365,852468.26143.33
db block gets direct35,3174.911.50
db block gets from cache3,330,535463.34141.83
db block gets from cache (fastpath)580,82080.8024.73
deferred (CURRENT) block cleanout applications133,73818.615.70
dirty buffers inspected2,5650.360.11
enqueue conversions6,8310.950.29
enqueue deadlocks00.000.00
enqueue releases414,23257.6317.64
enqueue requests414,82557.7117.66
enqueue timeouts3870.050.02
enqueue waits1,0610.150.05
exchange deadlocks360.010.00
execute count553,96777.0723.59
failed probes on index block reclamation70.000.00
file io service time2,745,839382.00116.93
file io wait time125,964,629,33617,524,216.555,364,077.39
frame signature mismatch00.000.00
free buffer inspected151,04821.016.43
free buffer requested435,72760.6218.55
heap block compress496,27969.0421.13
hot buffers moved to head of LRU152,63621.236.50
immediate (CR) block cleanout applications122,73317.075.23
immediate (CURRENT) block cleanout applications55,3407.702.36
in call idle wait time28,991,0714,033.241,234.56
index crx upgrade (positioned)8130.110.03
index fast full scans (direct read)00.000.00
index fast full scans (full)1,6440.230.07
index fast full scans (rowid ranges)00.000.00
index fetch by key5,896,325820.30251.09
index scans kdiixs136,471,1125,073.871,553.09
leaf node 90-10 splits7540.100.03
leaf node splits2,7300.380.12
lob reads1,6910.240.07
lob writes1,9670.270.08
lob writes unaligned1,9670.270.08
logical read bytes from cache11,166,699,749,3761,553,512,804.25475,522,707.89
logons cumulative2,6270.370.11
max cf enq hold time358,37049.8615.26
messages received1,049,985146.0744.71
messages sent1,049,986146.0744.71
min active SCN optimization applied on CR26,8173.731.14
no buffer to keep pinned count1,6350.230.07
no work - consistent read gets1,403,935,122195,315.6559,785.17
non-idle wait count1,731,453240.8873.73
non-idle wait time48,860,3546,797.462,080.67
opened cursors cumulative558,93577.7623.80
parse count (describe)50.000.00
parse count (failures)130.000.00
parse count (hard)8280.120.04
parse count (total)116,72516.244.97
parse time cpu3,4300.480.15
parse time elapsed77,98410.853.32
physical read IO requests502,70569.9421.41
physical read bytes456,381,292,54463,491,828.1619,434,539.56
physical read total IO requests513,98971.5121.89
physical read total bytes457,485,928,44863,645,505.2619,481,579.37
physical read total multi block requests457,89763.7019.50
physical reads55,710,6077,750.472,372.38
physical reads cache115,60816.084.92
physical reads cache prefetch78,11610.873.33
physical reads direct55,594,9997,734.382,367.46
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests54,4407.572.32
physical write bytes1,123,696,640156,328.8347,851.49
physical write total IO requests78,77110.963.35
physical write total bytes4,268,036,096593,769.77181,750.04
physical write total multi block requests7,9271.100.34
physical writes137,17019.085.84
physical writes direct35,3854.921.51
physical writes direct (lob)690.010.00
physical writes direct temporary tablespace10.000.00
physical writes from cache101,78514.164.33
physical writes non checkpoint75,49610.503.21
pinned buffers inspected1070.010.00
pinned cursors current3220.040.01
prefetch clients - default1230.020.01
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time7,6241.060.32
queries parallelized00.000.00
recovery blocks read00.000.00
recursive aborts on index block reclamation00.000.00
recursive calls1,159,755161.3549.39
recursive cpu usage677,60694.2728.86
redo KB read2,073,873288.5288.31
redo KB read (memory)842,779117.2535.89
redo KB read (memory) for transport842,779117.2535.89
redo KB read for transport902,460125.5538.43
redo blocks checksummed by FG (exclusive)832,967115.8835.47
redo blocks read for recovery00.000.00
redo blocks written1,807,913251.5276.99
redo buffer allocation retries13,7191.910.58
redo entries1,765,703245.6475.19
redo k-bytes read for recovery00.000.00
redo log space requests38,5735.371.64
redo log space wait time366,18350.9415.59
redo ordering marks4,9710.690.21
redo size988,297,076137,492.0342,085.64
redo size for direct writes292,509,05240,693.9012,456.20
redo subscn max counts5,1560.720.22
redo synch long waits2,4920.350.11
redo synch poll writes00.000.00
redo synch polls00.000.00
redo synch time9,835,3311,368.29418.83
redo synch time (usec)98,353,249,85113,682,917.644,188,274.49
redo synch writes18,7152.600.80
redo wastage2,121,448295.1490.34
redo write time672,09393.5028.62
redo writes6,2830.870.27
rollback changes - undo records applied16,8072.340.72
rollbacks only - consistent read gets122,57317.055.22
root node splits20.000.00
rows fetched via callback1,621,191225.5469.04
session connect time00.000.00
session cursor cache hits442,44061.5518.84
session logical reads1,418,697,596197,369.4060,413.81
shared hash latch upgrades - no wait431,35560.0118.37
shared hash latch upgrades - wait5290.070.02
sorts (disk)00.000.00
sorts (memory)184,25725.637.85
sorts (rows)187,247,57826,049.917,973.75
sql area evicted4420.060.02
sql area purged190.000.00
summed dirty queue length118,22516.455.03
switch current to new buffer75,79510.543.23
table fetch by rowid1,818,301,321252,962.3377,430.54
table fetch continued row51,754,6937,200.122,203.92
table scan blocks gotten1,173,213,790163,217.6649,960.13
table scan rows gotten18,033,251,9392,508,788.49767,927.95
table scans (cache partitions)00.000.00
table scans (direct read)5230.070.02
table scans (long tables)140.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)117,13416.304.99
total cf enq hold time2,043,540284.3087.02
total number of cf enq holders2600.040.01
total number of slots3870.050.02
total number of times SMON posted1190.020.01
transaction rollbacks5640.080.02
transaction tables consistent read rollbacks420.010.00
transaction tables consistent reads - undo records applied2,6920.370.11
undo change vector size282,593,80039,314.4912,033.97
user I/O wait time33,389,5974,645.171,421.86
user calls500,92369.6921.33
user commits23,2003.230.99
user rollbacks2830.040.01
workarea executions - onepass00.000.00
workarea executions - optimal135,41618.845.77
write clones created in background20.000.00
write clones created in foreground2,0190.280.09

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current84263
session uga memory max1,440,815,127,6161,448,658,042,816
session pga memory2,029,891,664,4802,034,047,217,888
session pga memory max5,967,252,212,9445,974,532,664,992
session cursor cache count56,352,84756,466,810
session uga memory4,048,260,384,727,1844,055,515,288,054,064
opened cursors current114430
workarea memory allocated59,18438,925

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)42.00

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)
Direct Reads433.4G66.0461.73770M0.000M0 
Others1.4G1.64.1975501.3G1.03.18322112.4K1550.14
LGWR1M0.01.0001391.8G2.49.24930364951093.36
Buffer Cache Reads906M5.29.1260420M0.000M37.9K1440.15
DBWR0M0.000M814M7.50.1132430 
Direct Writes0M0.000M193M0.15.0268500 
TOTAL:435.6G72.9962.06144G11.17.57261856.8K1424.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
Data File438G71.9362.39671.1G7.82.1520581546.072925.46
Log File1.2G0.19.1672221.8G2.50.2509721829.761829.97
Archive Log0M0.000M1.1G0.16.159153  
Control File195M1.43.02712884M0.75.0116861482.026284.29
Other0M0.020M7M0.05.0009733826.92 
Temp File0M0.000M0M0.000M0.00 
TOTAL:439.4G73.5862.59114G11.27.5748441540.042922.93

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)
Direct Reads 440.4G67.0962.74200M0.000M0 
Direct Reads (Data File) 440.4G67.0962.74200M0.000M0 
Others 1.4G1.64.1978281.3G0.99.18224710.6K1521.55
Others (Log File) 1.2G0.19.1672220M0.000M1381690.77
Others (Archive Log) 0M0.000M1.1G0.16.1591530 
Others (Control File) 194M1.43.02698982M0.73.01140710.2K1500.55
Others (Data File) 26M0.03.00361784M0.10.0116861642691.59
LGWR 1M0.01.0001391.8G2.52.2512501001507.86
LGWR (Log File) 0M0.000M1.8G2.50.250972322027.31
LGWR (Control File) 1M0.01.0001392M0.02.000278681263.41
Buffer Cache Reads 908M5.32.1263210M0.000M38.1K1453.45
Buffer Cache Reads (Data File) 908M5.32.1263210M0.000M38.1K1453.45
DBWR 0M0.000M828M7.65.1151910 
DBWR (Data File) 0M0.000M828M7.65.1151910 
Direct Writes 0M0.000M193M0.15.0268500 
Direct Writes (Data File) 0M0.000M193M0.15.0268500 
TOTAL: 442.7G74.0763.06634G11.31.57554048.8K1468.29

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
WZOL_DATA 495,6686994.05111.4648,69873,791646.02
SYSAUX 1,30202042.601.001,342000.00
WZOL_INDEX 57701963.081.001,94102820.18
UNDOTBS1 1502057.331.001,8510267645.96
SYSTEM 1,13802079.321.002690406429.66
USERS 200.001.002000.00
TEMP 100.001.001000.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
SYSAUX+DATA/wzol/datafile/sysaux01.dbf 1,30202042.601.001,342000.00
SYSTEM+DATA/wzol/datafile/system01.dbf 1,02602142.711.002170340417.74
SYSTEM+DATA/wzol/datafile/system02.dbf 11201498.661.0052066491.06
TEMP+DATA/wzol/datafile/temp02.dbf 100.001.00100 
UNDOTBS1+DATA/wzol/datafile/undotbs01.dbf 702137.141.006650191646.91
UNDOTBS1+DATA/wzol/datafile/undotbs02.dbf 30723.331.004800100.00
UNDOTBS1+DATA/wzol/datafile/undotbs03.dbf 502746.001.00706066741.06
USERS+DATA/wzol/datafile/users01.dbf 200.001.002000.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_001.dbf 23,758365.86117.041,8550108642.31
WZOL_DATA+DATA/wzol/datafile/wzol_data_009.dbf 23,727394.37116.841,7950149584.83
WZOL_DATA+DATA/wzol/datafile/wzol_data_010.dbf 22,150358.17116.601,6540366691.34
WZOL_DATA+DATA/wzol/datafile/wzol_data_011.dbf 22,118373.12118.631,2680474808.33
WZOL_DATA+DATA/wzol/datafile/wzol_data_012.dbf 52,260732.2872.988,5261260500.46
WZOL_DATA+DATA/wzol/datafile/wzol_data_013.dbf 22,227382.48117.272,293042433.57
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201210291128.dbf 22,9553132.91114.213,103036212.50
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201212280950.dbf 22,072382.11117.691,641080.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201212281000.dbf 22,315394.10116.071,8410383.42
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201303211009.dbf 22,100366.32116.841,351018286.11
WZOL_DATA+DATA/wzol/datafile/wzol_data_wms_101.dbf 23,0493129.52114.133,059032143.13
WZOL_DATA+DATA/wzol/datafile/wzol_data_wms_120.dbf 22,9403145.33114.793,6591270.00
WZOL_DATA+DATA/wzol/datafile/wzoldata001.dbf 20,8053112.54107.051,5750166402.17
WZOL_DATA+DATA/wzol/datafile/wzoldata002.dbf 20,0593106.78109.421,083079223.29
WZOL_DATA+DATA/wzol/datafile/wzoldata003.dbf 19,119371.84115.641,453030259.33
WZOL_DATA+DATA/wzol/datafile/wzoldata004.dbf 19,909380.57119.491,311021277.62
WZOL_DATA+DATA/wzol/datafile/wzoldata005.dbf 22,238375.67120.431,435070.00
WZOL_DATA+DATA/wzol/datafile/wzoldata006.dbf 22,5843153.15118.631,4600811950.39
WZOL_DATA+DATA/wzol/datafile/wzoldata007.dbf 22,9103131.54116.322,7530594748.25
WZOL_DATA+DATA/wzol/datafile/wzoldata008.dbf 23,3273159.52113.672,795024995.86
WZOL_DATA+DATA/wzol/datafile/wzoldata100.dbf 23,046399.90118.232,7880276555.87
WZOL_INDEX+DATA/wzol/datafile/wzol_index_84_201210291133.dbf 3502013.711.00152000.00
WZOL_INDEX+DATA/wzol/datafile/wzol_index_84_201212281000.dbf 3102097.421.00200010.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex001.dbf 15501551.741.005100880.34
WZOL_INDEX+DATA/wzol/datafile/wzolindex002.dbf 13802109.281.00596030.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex003.dbf 8201513.171.00218000.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex004.dbf 13602511.181.0026501900.11

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
D1,450,1891001,359,772,888115,616101,751004,970

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
000080,2320

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
B0267997634754885522488320488552   
E04339966788554195694524883201956945   

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
D1,1520.10142635.6871,779,6431352307513.00
D2,3040.2028450.635,717,538127798824.00
D3,4560.294269.841,111,36715172500.00
D4,6080.395683.53398,61811671355.00
D5,7600.497102.06232,2971854355.00
D6,9120.598521.56175,9691577664.00
D8,0640.689941.31147,5291437960.00
D9,2160.781,1361.17132,1351362343.00
D10,3680.881,2781.08121,8101311621.00
D11,5200.981,4201.01114,1821274155.00
D11,7761.001,4521.00112,9181267946.00
D12,6721.081,5620.96108,4121245809.00
D13,8241.171,7040.92103,4601221485.00
D14,9761.271,8460.8899,1881200498.00
D16,1281.371,9880.8495,4001181895.00
D17,2801.472,1300.8191,9881165133.00
D18,4321.572,2720.7888,3251147138.00
D19,5841.662,4140.7585,0411131008.00
D20,7361.762,5560.7180,6001109194.00
D21,8881.862,6980.6977,425193596.00
D23,0401.962,8400.6371,543164705.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.0098,6560

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
2K4K110,768110,76800
64K128K1,0321,03200
128K256K61461400
256K512K26826800
512K1024K16,00316,00300
1M2M4,1084,10800
2M4M34734700
4M8M666600
8M16M91591500
16M32M13613600
32M64M1,1041,10400
128M256M3300

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
1,0480.1343,274,417.467,003.11100.00011,976,642,495
2,0960.2543,274,417.466,269.98100.00011,976,439,627
4,1920.5043,274,417.464,424.65100.00011,975,928,996
6,2880.7543,274,417.464,424.65100.00011,975,928,996
8,3841.0043,274,417.463,577.77100.00011,975,694,651
10,0611.2043,274,417.462,120.56100.00011,975,291,419
11,7381.4043,274,417.462,120.56100.00011,975,291,419
13,4141.6043,274,417.462,120.56100.00011,975,291,419
15,0911.8043,274,417.462,120.56100.00011,975,291,419
16,7682.0043,274,417.462,120.56100.00011,975,291,419
25,1523.0043,274,417.462,120.56100.00011,975,291,419
33,5364.0043,274,417.462,120.56100.00011,975,291,419
50,3046.0043,274,417.462,120.56100.00011,975,291,419
67,0728.0043,274,417.462,120.56100.00011,975,291,419

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)
2,8160.902729,1556,088,2571.0023,0071.05376,809
2,8800.9233511,5956,088,5251.0022,7391.04376,831
2,9440.9439913,1696,088,8141.0022,4501.02376,857
3,0080.9646214,5556,089,0201.0022,2441.01376,874
3,0720.9852615,9646,089,1711.0022,0931.01376,887
3,1361.0059017,4356,089,3101.0021,9541.00376,899
3,2001.0265419,1376,089,3791.0021,8851.00376,905
3,2641.0471821,7396,089,4421.0021,8220.99376,911
3,3281.0678124,5396,089,5251.0021,7390.99376,918
3,3921.0884526,2506,089,5821.0021,6820.99376,922
3,4561.1090927,5946,089,6491.0021,6150.98376,927
3,5201.1297328,8996,089,6971.0021,5670.98376,932
3,5841.141,03730,2566,089,7651.0021,4990.98376,938
3,6481.161,10131,6296,089,8371.0021,4270.98376,943
3,7121.181,16533,3276,089,8851.0021,3790.97376,948
3,7761.201,22934,9796,089,9291.0021,3350.97376,952
4,0961.311,54943,1596,090,0791.0021,1850.97376,965
4,4161.411,86950,0466,090,1931.0021,0710.96376,977
4,7361.512,18858,2466,090,2901.0020,9740.96376,985
5,0561.612,50866,2816,090,3441.0020,9200.95376,990
5,3761.712,82874,1196,090,3821.0020,8820.95376,995
5,6961.823,14881,9576,090,4121.0020,8520.95376,998
6,0161.923,46889,7956,090,4371.0020,8270.95377,001
6,3362.023,78897,6336,090,4621.0020,8020.95377,004

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
5,8800.3833,346,1745,955,206,234
7,8400.5010,479,0801,157,563,121
9,8000.636,115,404241,950,826
11,7600.755,695,156153,659,721
13,7200.885,567,568126,875,413
15,6801.005,501,305112,918,666
17,6401.135,476,294107,758,283
19,6001.255,436,17899,368,426
21,5601.385,401,57491,994,837
23,5201.505,363,62283,955,028
25,4801.635,319,07874,515,028
27,4401.755,317,44774,515,028
29,4001.885,317,47774,515,028
31,3602.005,317,50274,515,028

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)
641.000000
1282.000000
1923.000000
2564.000000
3205.000000
3846.000000
4487.000000
5128.000000
5769.000000
64010.000000
70411.000000
76812.000000
83213.000000
89614.000000
96015.000000
1,02416.000000
1,08817.000000
1,15218.000000
1,21619.000000
1,28020.000000

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block4,3702,675612
undo header178124694
undo block8041512
file header block98884
segment header32300
1st level bmb500

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
KO-Multiple Object Checkpoint (fast object checkpoint) 4,9784,97704937,46115,133.29
CF-Controlfile Transaction 1,8451,628217623,11650,264.03
TX-Transaction (row lock contention) 2312290732,09028,628.90
CR-Reuse Block Range (block range reuse ckpt) 1,8941,8940797569,570.13
TX-Transaction (index contention) 1,5081,50803097492,424.37
RO-Multiple Object Reuse (fast object reuse) 3203200322247,013.13
JD-Job Queue Date 2,9572,95704317,705.00
SQ-Sequence Cache 2,5142,5140601.67
HW-Segment High Water Mark 44,86344,8630100.00
JS-Job Scheduler (queue lock) 33,48033,4800100.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
238.5634,9502,7812320.8/61.40/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
01-12月 11:592,4761,6362,54418560/00/0/0/0/0/0
01-12月 11:493,0382,7362,78118610/00/0/0/0/0/0
01-12月 11:392,7402,4402,17923510/00/0/0/0/0/0
01-12月 11:292,7152,1561,57719410/00/0/0/0/0/0
01-12月 11:192,2002,5591,56020410/00/0/0/0/0/0
01-12月 11:093,9403,85894522310/00/0/0/0/0/0
01-12月 10:592,1832,46460016250/00/0/0/0/0/0
01-12月 10:493,2772,88699119320/00/0/0/0/0/0
01-12月 10:392,4412,67685919290/00/0/0/0/0/0
01-12月 10:293,3362,90499119320/00/0/0/0/0/0
01-12月 10:194,7373,36534615210/00/0/0/0/0/0
01-12月 10:095,4805,27099212320/00/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
AQ deq hash table latch40.00 00 
AQ dequeue txn counter latch1,4620.00 00 
ASM Keyed state latch1,6530.00 00 
ASM allocation1,9000.00 00 
ASM db client latch2,9560.00 00 
ASM map headers9310.110.0000 
ASM map load waiting list2600.00 00 
ASM map operation freelist5,1412.140.0500 
ASM map operation hash table1,548,7200.070.0000 
ASM network SGA latch120.00 00 
ASM network background latch4,6500.00 00 
ASM network state latch1,4840.070.0000 
ASM scan context latch160.00 00 
AWR Alerted Metric Element list72,9050.00 00 
Change Notification Hash table latch1,9490.00 00 
Consistent RBA6,2880.00 00 
DML lock allocation73,358,2740.000.0000 
Event Group Locks3,5470.00 00 
FAL Queue2860.350.0000 
FIB s.o chain latch2660.00 00 
FOB s.o list latch16,0641.000.0200 
File State Object Pool Parent Latch40.00 00 
I/O Staticstics latch40.00 00 
IPC stats buffer allocation latch40.00 00 
In memory undo latch261,5040.340.0000 
JS Sh mem access200.00 00 
JS broadcast autostart latch10.00 00 
JS mem alloc latch320.00 00 
JS queue access latch360.00 00 
JS queue state obj latch66,9600.00 00 
JS slv state obj latch9463.280.0000 
KFC FX Hash Latch40.00 00 
KFC Hash Latch40.00 00 
KFCL LE Freelist40.00 00 
KFK SGA Libload latch1,4160.00 00 
KFMD SGA1300.00 00 
KGNFS-NFS:SHM structure40.00 00 
KGNFS-NFS:SVR LIST40.00 00 
KJC message pool free list40.00 00 
KJCT flow control latch40.00 00 
KMG MMAN ready and startup request latch2,4390.00 00 
KTF sga latch420.00 01,3580.00
KWQMN job cache list latch80.00 00 
KWQP Prop Status80.00 00 
KWQS pqsubs latch200.00 00 
KWQS pqueue ctx latch1470.00 00 
LGWR NS Write11,9220.070.0000 
Locator state objects pool parent latch40.00 00 
Lsod array latch11,4760.750.0800 
MQL Tracking Latch0  01460.00
Memory Management Latch40.00 02,4390.00
Memory Queue40.00 00 
Memory Queue Message Subscriber #140.00 00 
Memory Queue Message Subscriber #240.00 00 
Memory Queue Message Subscriber #340.00 00 
Memory Queue Message Subscriber #440.00 00 
Memory Queue Subscriber40.00 00 
MinActiveScn Latch800.00 00 
Mutex40.00 00 
Mutex Stats40.00 00 
OS process5,7640.00 00 
OS process allocation18,3270.070.0000 
OS process: request allocation1,6530.300.0000 
PL/SQL warning settings13,7910.010.0000 
PX hash array latch40.00 00 
QMT40.00 00 
Real-time plan statistics latch59,5030.020.2500 
SGA IO buffer pool latch740.00 0740.00
SGA blob parent40.00 00 
SGA bucket locks40.00 00 
SGA heap locks40.00 00 
SGA pool locks40.00 00 
SQL memory manager latch2050.00 01,0920.09
SQL memory manager workarea list latch186,2400.000.0000 
Shared B-Tree6340.00 00 
Streams Generic40.00 00 
Testing40.00 00 
Token Manager40.00 00 
WCR: sync40.00 00 
Write State Object Pool Parent Latch40.00 00 
X$KSFQP10,4280.00 00 
XDB NFS Security Latch40.00 00 
XDB unused session pool40.00 00 
XDB used session pool40.00 00 
active checkpoint queue latch1,046,3120.000.0000 
active service list27,2020.620.02011,5010.00
alert log latch200.00 00 
archive control3410.00 00 
archive process latch7031.990.7100 
begin backup scn array1,7220.00 00 
buffer pool40.00 00 
business card40.00 00 
cache buffer handles33,0940.000.0000 
cache buffers chains2,733,405,9491.280.000547,6130.00
cache buffers lru chain27,867,3510.000.210761,3290.12
cache table scan latch5,5800.00 05,5800.00
call allocation28,1031.430.4100 
cas latch40.00 00 
change notification client cache latch40.00 00 
channel handle pool latch2,0510.050.0000 
channel operations parent latch46,1380.120.0000 
checkpoint queue latch134,074,7560.000.000131,3930.00
client/application info13,3410.010.0000 
compile environment latch2,6270.080.0000 
corrupted undo seg latch50,9760.00 00 
cp cmon/server latch40.00 00 
cp pool latch40.00 00 
cp server hash latch40.00 00 
cp sga latch2670.00 00 
cvmap freelist lock40.00 00 
database property service latch80.00 00 
deferred cleanup latch2670.00 00 
dml lock allocation3310.00 00 
done queue latch40.00 00 
dummy allocation5,0771.750.0000 
enqueue freelist latch40.00 0504,6450.00
enqueue hash chains844,8940.090.0104,9750.00
enqueues220.00 00 
fifth spare latch40.00 00 
file cache latch2,3850.00 00 
flashback copy40.00 00 
fourth Audit Vault latch40.00 00 
gc element40.00 00 
gcs commit scn state40.00 00 
gcs partitioned table hash40.00 00 
gcs pcm hashed value bucket hash40.00 00 
gcs resource freelist40.00 00 
gcs resource hash40.00 00 
gcs resource scan list40.00 00 
gcs shadows freelist40.00 00 
ges domain table40.00 00 
ges enqueue table freelist40.00 00 
ges group table40.00 00 
ges process hash list40.00 00 
ges process parent latch40.00 00 
ges resource hash list40.00 00 
ges resource scan list40.00 00 
ges resource table freelist40.00 00 
ges value block free list40.00 00 
global KZLD latch for mem in SGA3870.00 00 
global tx hash mapping8,6790.00 00 
granule operation40.00 00 
hash table column usage latch6480.00 0154,7590.00
hash table modification latch3970.00 00 
heartbeat check40.00 00 
internal temp table object number allocation latch30.00 00 
interrupt manipulation50.00 00 
intra txn parallel recovery40.00 00 
io pool granule metadata list40.00 00 
job workq parent latch1,7640.00 01,7669.68
job_queue_processes free list latch3,5250.280.0000 
job_queue_processes parameter latch3,3880.00 00 
k2q lock allocation40.00 00 
kcbtsemkid latch40.00 00 
kdlx hb parent latch40.00 00 
kgb parent40.00 00 
kgnfs mount latch40.00 00 
kokc descriptor allocation latch5770.00 00 
ksfv messages40.00 00 
ksim group membership cache40.00 00 
kss move lock3720.00 00 
ksuosstats global area7440.00 00 
ksv allocation latch1,0020.00 00 
ksv class latch7,5600.380.0700 
ksv instance latch300.00 00 
ksv msg queue latch3330.00 03290.00
ksz_so allocation latch1,6531.210.0000 
ktm global data5340.00 00 
kwqbsn:qsga2690.00 00 
lgwr LWN SCN6,3500.00 00 
list of block allocation28,0450.320.0000 
loader state object freelist56,6000.140.0500 
lob segment dispenser latch40.00 00 
lob segment hash table latch280.00 00 
lob segment query latch40.00 00 
lock DBA buffer during media recovery40.00 00 
logical standby cache40.00 00 
logminer context allocation80.00 00 
logminer work area40.00 00 
longop free list parent51,4640.000.0006130.00
managed standby latch2241.340.0000 
mapped buffers lru chain40.00 00 
message pool operations parent latch2,3961.540.0000 
messages2,175,3490.000.0000 
mostly latch-free SCN6,4140.250.0600 
msg queue latch40.00 00 
multiblock read objects11,7120.00 00 
name-service namespace bucket40.00 00 
ncodef allocation latch2670.00 00 
object queue header heap90,8030.000.00089,3080.00
object queue header operation106,010,5150.000.0000 
object stats modification16,9330.010.0000 
parallel query alloc buffer1,5160.00 00 
parallel query stats40.00 00 
parameter list5,5840.00 00 
parameter table management24,5362.680.0100 
peshm40.00 00 
pesom_free_list40.00 00 
pesom_hash_node40.00 00 
post/wait queue1,024,3680.420.0001,027,3910.33
process allocation2,1800.370.0009170.00
process group creation1,6530.600.0000 
process queue40.00 00 
process queue reference40.00 00 
qmn task queue latch1,0620.00 00 
query server freelists40.00 00 
queued dump request240.00 00 
queuing load statistics40.00 00 
readredo stats and histogram5,8460.00 00 
recovery domain hash list40.00 00 
redo allocation98,1350.250.1001,767,4790.14
redo copy40.00 01,768,0160.05
redo writing1,106,7330.140.0000 
resmgr group change latch2,1830.050.0000 
resmgr:active threads5,0770.00 00 
resmgr:actses change group2,2730.00 00 
resmgr:actses change state40.00 00 
resmgr:free threads list5,0733.230.0000 
resmgr:plan CPU method40.00 00 
resmgr:resource group CPU method40.00 00 
resmgr:schema config40.00 00 
resmgr:session queuing40.00 00 
rm cas latch40.00 00 
row cache objects1,809,3800.250.0001160.00
rules engine aggregate statistics40.00 00 
rules engine rule set statistics4080.00 00 
second Audit Vault latch40.00 00 
second spare latch40.00 00 
segmented array pool2620.00 00 
sequence cache161,1560.130.0000 
session allocation18,1060.020.00013,5870.00
session idle bit1,012,6350.000.0000 
session queue latch40.00 00 
session state list latch4,7141.530.0000 
session switching1,0050.00 040.00
session timer2,5630.00 00 
shared pool2,066,4630.310.0804640.00
shared pool sim alloc220.00 00 
shared pool simulator2,6330.00 00 
sim partition latch40.00 00 
simulator hash latch83,482,9110.000.0000 
simulator lru latch45,5550.090.00083,423,8882.11
sort extent pool251,1590.060.0000 
space background state object latch430.00 00 
space background task latch19,4864.520.1604,9660.12
state object free list80.00 00 
statistics aggregation3,3600.00 00 
tablespace key chain6290.00 00 
temp lob duration state obj allocation100.00 00 
temporary table state object allocation2,4280.250.0000 
test excl. parent l040.00 00 
test excl. parent2 l040.00 00 
third spare latch40.00 00 
threshold alerts latch2790.00 00 
trace latch1110.00 00 
transaction allocation12,190,0310.000.0000 
transaction branch allocation10,5740.00 00 
undo global data753,7670.060.00020.00
virtual circuit buffers40.00 00 
virtual circuit holder40.00 00 
virtual circuit queues40.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
cache buffers chains2,733,405,94935,017,35648835,047,289
shared pool2,066,4636,4215215,921
row cache objects1,809,3804,51234,509
object queue header operation106,010,5152,88752,882
ASM map operation hash table1,548,7201,08231,079
In memory undo latch261,5049001899
space background task latch19,486881142739
enqueue hash chains844,89476510756
parameter table management24,5366578649
call allocation28,103401166263
redo allocation98,13524325218
cache buffers lru chain27,867,35117537139
active service list27,2021683165
FOB s.o list latch16,0641614157
ASM map operation freelist5,1411105105
Lsod array latch11,47686780
loader state object freelist56,60082478
ksv class latch7,56029227
mostly latch-free SCN6,41416115
archive process latch70314104
Real-time plan statistics latch59,5031239

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation freelistkffmTranslate2042
ASM map operation freelistkffmTranslate1015
ASM map operation hash tablekffmTranslate021
ASM map operation hash tablekffmDoDone_1012
FOB s.o list latchksfd_allfob044
In memory undo latchktiFlush: child011
Lsod array latchkfklsodtablCleanup077
PC and Classifier lists for WLMNo latch010
Real-time plan statistics latchkeswxAddNewPlanEntry033
active service listkswslogon: session logout061
active service listkswsite: service iterator010
archive process latchkcrrgpll01010
cache buffers chainskcbchg1: mod cr pin0415224
cache buffers chainskcbgtcr: fast path (cr pin)0102180
cache buffers chainskcbgcur_205012
cache buffers chainskcbgtcr_201716
cache buffers chainskcbgtcr: fast path0125
cache buffers chainskcbrls: fast release0930
cache buffers chainskcbgtcr: kslbegin excl0819
cache buffers chainskcbzwb085
cache buffers chainskcbrls_20419
cache buffers chainskcbget: fast exchange020
cache buffers chainskcbnew: new latch again010
cache buffers lru chainkcbzgws0280
cache buffers lru chainkcbo_link_q060
cache buffers lru chainkcbzgb020
cache buffers lru chainkcbbic201626
call allocationksuxds0162151
call allocationksudlp: top call0413
enqueue hash chainsksqrcl083
enqueue hash chainsksqcmi: get hash chain latch after wait027
ksv class latchksvclsl: rdp - recycle020
lgwr LWN SCNkcs023010
loader state object freelistkcblgs044
object queue header operationkcbo_ivbo031
object queue header operationkcbo_switch_cq021
object queue header operationkcbo_unlink_q010
object queue header operationkcbo_write_q017
parameter table managementkspcpy063
parameter table managementksp_param_table_free020
redo allocationkcrfw_redo_gen: redo allocation 10140
redo allocationkcrfw_redo_gen: redo allocation 301122
row cache objectskqreqd: reget030
shared poolkghalo0479335
shared poolkghfre040158
shared poolkgh_next_free010
shared poolkghupr10127
space background task latchktsj_grab_task0141142

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekgllkdl1 859740
Library Cachekglhdgn2 1067290
Library Cachekglpndl1 956270
Library Cachekgllkc1 576000
Library Cachekglhdgh1 641710
Library Cachekglpin1 41180
Library Cachekglpnal1 901180
Library Cachekglhdgn1 621120
Cursor Pinkkslce [KKSCHLPIN2]1000
Library Cachekglget1 1150
Library Cachekglget2 210
Library Cachekglrfcl1 7910
Cursor Pinkksfbc [KKSCHLFSP2]10
Cursor Pinkksfbc [KKSCHLPIN1]10

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
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE980,089,13669.08
WZOLWMS30WZOL_DATASORTING_BILLDETAIL TABLE165,035,24811.63
WZOLWMS30WZOL_DATAIF_PICKING_BILLSOURCE TABLE35,911,1522.53
WZOLWMS30WZOL_DATAPACKAGE_BILLDETAIL TABLE34,033,3922.40
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE13,334,1760.94

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE52,589,46194.40
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE999,9411.79
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE266,6550.48
WZOLWMS30WZOL_DATASHELVE_BILLSOURCE TABLE145,7210.26
WZOLWMSWZOL_DATADBMS_TABCOMP_TEMP_UNCMP TABLE3,0690.01

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE440,43287.61
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE10,6742.12
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE2,7740.55
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE2,2290.44
WZOLWMS30WZOL_DATASHELVE_BILLSOURCE TABLE1,2750.25

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE440,43287.61
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE10,6742.12
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE2,7740.55
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE2,2290.44
WZOLWMS30WZOL_DATASHELVE_BILLSOURCE TABLE1,2750.25

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

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Reads%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE52,591,63394.60
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE997,4141.79
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE266,6120.48
WZOLWMS30WZOL_DATASHELVE_BILLSOURCE TABLE145,6370.26

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE8,1275.92
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_3239828958_19173TABLE PARTITION3,2352.36
WZOLWMSWZOL_DATADBMS_TABCOMP_TEMP_UNCMP TABLE3,0692.24
** MISSING **WZOL_DATA** MISSING: 255983/255983** MISSING **UNDEFINED3,0252.21
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE2,7131.98

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE6,81812.52
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_INDX INDEX9611.77
WZOLWMS30WZOL_DATABASE_WAREHOUSECARGOSPACE TABLE6041.11
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE5300.97
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE3780.69

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
WZOLWMSWZOL_DATADBMS_TABCOMP_TEMP_UNCMP TABLE3,0698.67
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_3239828958_19173TABLE PARTITION3,0478.61
** MISSING **WZOL_DATA** MISSING: 255983/255983** MISSING **UNDEFINED3,0248.55
** MISSING **WZOL_DATA** MISSING: 255991/255991** MISSING **UNDEFINED2,5727.27
** MISSING **WZOL_DATA** MISSING: 256001/256001** MISSING **UNDEFINED1,8085.11

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
WZOLWMS30WZOL_DATAPK_PALLETID INDEX804.83
WZOLWMS30WZOL_DATAIK_BASE_GOODSINFO_SKUID INDEX452.71
WZOLWMS30WZOL_DATAIK_BASE_WAREHOUSECARGOSPACE_1 INDEX301.81

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE200,96021.85
WZOLWMS30WZOL_DATAPACKAGE_BILLDETAIL TABLE107,10411.64
WZOLWMS30WZOL_DATAWAYBILL_PACKAGE TABLE46,4325.05
WZOLWMS30WZOL_DATABASE_WAREHOUSECARGOSPACE TABLE44,0324.79
WZOLWMS30WZOL_DATASALESRETURN_BILL TABLE39,6324.31

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WZOLWMS30WZOL_INDEXSYS_C00956248 INDEX20718.38
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_T INDEX13411.90
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_INDX INDEX625.51
WZOLWMS30WZOL_DATAWAYBILL_DELIVERY_IDX1 INDEX423.73
WZOLWMS30WZOL_DATABASE_TABLE_DATAVERSION TABLE413.64

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
WZOLWMS30WZOL_INDEXSYS_C00956248 INDEX327.27
WZOLWMS30WZOL_DATASYS_C00958544 INDEX327.27
WZOLWMS30WZOL_DATAIDX_SALESORDER_BILLDETAIL_1 INDEX19.09
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_T INDEX19.09
WZOLWMS30WZOL_DATAINOUTDETAIL_IDX1 INDEX19.09

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
WZOLWMS30WZOL_DATARF_USER_ONLINE TABLE45726.71
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE23413.68
WZOLWMS30WZOL_INDEXSYS_C00956248 INDEX19111.16
SYSSYSTEMJOB$ TABLE1518.83
SYSSYSTEMUNDO$ TABLE1086.31

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control3750.000 81
dc_constraints1,27233.330 1,2721
dc_files1360.000 034
dc_global_oids6580.610 0102
dc_histogram_data58,2162.340 019,404
dc_histogram_defs36,0318.020 018,285
dc_object_grants10721.500 065
dc_objects56,1820.620 1106,527
dc_profiles2,0860.000 01
dc_rollback_segments19,2170.000 12169
dc_segments9,8401.540 3173,241
dc_sequences2,5090.160 2,50986
dc_table_scns32100.000 00
dc_tablespaces267,3390.000 08
dc_users184,2090.000 0146
global database name5,9570.000 01
outstanding_alerts704.290 47
sch_lj_objs333.330 012
sch_lj_oids714.290 016


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS7770.000 00
APP CONTEXT240.00240.0000
BODY4,4010.0718,6190.0200
CLUSTER330.00350.0000
DBLINK7820.000 00
EDITION2,2440.004,3270.0000
INDEX365.56365.5600
JAVA DATA450.00450.0000
JAVA RESOURCE540.00540.0000
JAVA SOURCE540.00540.0000
OBJECT ID33100.000 00
QUEUE1,5600.001,7990.0000
RULESET0 40.0000
SCHEMA2,4580.040 00
SQL AREA180,54631.49594,1040.2948585
SQL AREA BUILD88555.480 00
SQL AREA STATS64264.4964264.4900
SUBSCRIPTION130.00130.0000
TABLE/PROCEDURE9,7161.95145,5830.422271
TRANSFORMATION7310.007310.0000
TRIGGER2,1040.1911,7980.0410


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 cache11,776.0011,776.0011,776.0012,480.000SHR/DEF
KEEP buffer cache0.000.000.000.000STA/
PGA Target8,384.008,384.008,384.008,384.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target15,680.0015,680.0015,680.0015,680.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool64.0064.0064.0064.000STA/
large pool512.00512.00320.00512.000GRO/IMM
shared pool3,136.003,136.002,432.003,136.000GRO/DEF
streams pool64.0064.0064.00128.000SHR/DEF

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
BOther569.68 6.4712.5454548888
Freeable124.060.002.435.0527 5151
SQL76.3273.341.369.00671585644
PL/SQL8.717.510.100.27128686
EOther1,103.01 4.107.395454269269
SQL444.15432.791.861.33648239224
Freeable176.060.001.763.8027 100100
PL/SQL33.6530.660.130.2222267267

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers12,348,030,976 
Fixed Size2,240,016 
Redo Buffers19,320,832 
Variable Size12,750,684,656 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory64.0064.000.00
largePX msg pool319.71319.710.00
largefree memory185.24185.240.00
sharedASH buffers64.0064.000.00
sharedKGH: NO ACCESS500.51500.510.00
sharedKGLH0236.45237.670.52
sharedKGLHD276.95285.443.07
sharedKGLNA44.0746.886.38
sharedSQLA433.07438.771.32
shareddb_block_hash_buckets89.0089.000.00
sharedevent statistics per sess37.9437.940.00
sharedfree memory1,201.551,144.65-4.74
sharedkkslBind_value45.7850.119.46
sharedkkslLoadParentOnLock:lite156.29170.138.86
sharedprivate strands64.9464.940.00
streamsfree memory64.0064.000.00
 buffer_cache11,776.0011,776.000.00
 fixed_sga2.142.140.00
 log_buffer18.4318.430.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 Coordinator1106 23:40:050.020.000.00
QMON Slaves1106 23:40:150.010.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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

RuleEvalsNo-SQL Eval%SQL ExecsCPU(s)Ela(s)Eval /SecSQL per EvalEla(s) per EvalCPU(s) per EvalReloads
SYS.ALERT_QUE_R 40.0000.000.000.000.000.000.000

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(12343) 40100.000.007.240.000.000.01
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(66573) 1051050.000.000.020.080.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(12343) 0.000.001.81 
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_TASK_Q(66573) 0.010.010.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
DBWMS_MASTER__3938_WZOL(22)/SYS.ALERT_QUE 4000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   
WMS_90_23_3938_WZOL(23)/SYS.ALERT_QUE 4000.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 %
7,6320.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.007,6320.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)
_cursor_obsolete_threshold10  
_log_deletion_policyALL  
audit_file_dest/u01/app/oracle/admin/wzol/adump  
audit_trailNONE  
backup_tape_io_slavesTRUE  
commit_loggingBATCH  
commit_waitNOWAIT  
compatible11.2.0.0.0  
control_file_record_keep_time30  
control_files+DATA/wzol/controlfile/control01.ctl, +DATA/wzol/controlfile/control02.ctl, +DATA/wzol/controlfile/control03.ctl  
cursor_sharingSIMILAR  
db_block_size8192  
db_domain    
db_file_name_convert/u01/app/oracle/oradata/wzol/, +data/wzol/datafile/  
db_namewzol  
db_recovery_file_dest+RECOVERY  
db_recovery_file_dest_size4070572032  
db_unique_nameprimary  
db_writer_processes1  
dbwr_io_slaves5  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=wzolXDB)  
fal_clientprimary  
fal_serverstandby  
filesystemio_optionsSETALL  
job_queue_processes10  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))))  
log_archive_configdg_config=(primary, standby)  
log_archive_dest_1location=+data valid_for=(all_logfiles, all_roles) db_unique_name=primary  
log_archive_dest_2service=standby LGWR ASYNC valid_for=(online_logfile, primary_role) db_unique_name=standby  
log_archive_dest_state_1ENABLE  
log_archive_dest_state_2ENABLE  
log_archive_max_processes8  
log_file_name_convert/u01/app/oracle/oradata/wzol/, +data/wzol/ONLINELOG/  
max_dump_file_size100M  
memory_max_target25232932864  
memory_target25232932864  
open_cursors1000  
open_links50  
optimizer_dynamic_sampling0  
optimizer_index_caching95  
optimizer_index_cost_adj50  
parallel_adaptive_multi_userTRUE  
parallel_execution_message_size32768  
parallel_max_servers8  
parallel_min_servers2  
processes2000  
recovery_parallelism5  
recyclebinON  
remote_login_passwordfileEXCLUSIVE  
resumable_timeout60  
service_namesWZOL  
session_cached_cursors400  
sort_area_size1048576  
spfile+DATA/primary/parameterfile/spfile.309.826438625  
standby_file_managementAUTO  
transactions5000  
transactions_per_rollback_segment50  
undo_retention0  
undo_tablespaceUNDOTBS1  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA/wzol/controlfile/control01.ctl  
+DATA/wzol/controlfile/control02.ctl  
+DATA/wzol/controlfile/control03.ctl  
db_file_name_convert+data/wzol/datafile/  
/u01/app/oracle/oradata/wzol/  
log_file_name_convert+data/wzol/ONLINELOG/  
/u01/app/oracle/oradata/wzol/  

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