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:1912630-11月-13 10:00:2187 1.3
End Snap:1913030-11月-13 12:00:2876 1.2
Elapsed:  120.11 (mins)  
DB Time:  396.98 (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): 3.3 0.3 0.02 0.03
DB CPU(s): 2.8 0.3 0.02 0.02
Redo size: 185,182.0 17,795.7  
Logical reads: 350,928.2 33,723.5  
Block changes: 915.4 88.0  
Physical reads: 2,444.8 234.9  
Physical writes: 45.6 4.4  
User calls: 114.0 11.0  
Parses: 23.6 2.3  
Hard parses: 0.2 0.0  
W/A MB processed: 26.8 2.6  
Logons: 0.4 0.0  
Executes: 157.9 15.2  
Rollbacks: 0.1 0.0  
Transactions: 10.4   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.99In-memory Sort %: 100.00
Library Hit %: 99.72Soft Parse %: 99.12
Execute to Parse %: 85.09Latch Hit %: 99.74
Parse CPU to Parse Elapsd %: 95.47% Non-Parse CPU: 99.75

Shared Pool Statistics

BeginEnd
Memory Usage %: 48.80 59.58
% SQL with executions>1: 95.36 95.59
% Memory for SQL w/exec>1: 90.51 92.14

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 19,963 83.81 
log file sync47,7362,032438.53Commit
direct path read100,5371,245125.23User I/O
db file sequential read149,70342231.77User I/O
enq: KO - fast object checkpoint129554300.23Application

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

Load Average BeginLoad Average End%User%System%WIO%Idle
2.23 0.61 8.4 0.3 0.8 91.2
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
8.7 99.2 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): 790.1 690.1
% Host Mem used for SGA+PGA: 51.43 51.12

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time21,552.1990.48
DB CPU19,962.5283.81
PL/SQL execution elapsed time79.710.33
parse time elapsed63.580.27
hard parse elapsed time12.060.05
hard parse (sharing criteria) elapsed time5.410.02
sequence load elapsed time1.050.00
hard parse (bind mismatch) elapsed time0.890.00
PL/SQL compilation elapsed time0.700.00
connection management call elapsed time0.440.00
repeated bind elapsed time0.050.00
DB time23,818.64 
background elapsed time528.53 
background cpu time123.05 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
BUSY_TIME2,025,425 
IDLE_TIME21,034,443 
IOWAIT_TIME178,693 
NICE_TIME145 
SYS_TIME78,171 
USER_TIME1,943,942 
LOAD21
VM_IN_BYTES407,552 
VM_OUT_BYTES0 
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
30-11月 10:00:212.23     
30-11月 10:30:221.508.257.920.3291.750.74
30-11月 11:00:243.218.508.130.3591.501.02
30-11月 11:30:263.6411.0810.690.3888.920.58
30-11月 12:00:280.617.316.980.3192.690.76

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%DB time
DB CPU  19,963 83.81
Commit47,73602,032438.53
User I/O257,76401,69277.10
Application1,603059370.25
Concurrency2,5390210.01
Network546,3390100.00
Configuration28751230.00
Other2400120.00
System I/O2840000.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
log file sync47,73602,032430.648.53
direct path read100,53701,245121.345.23
db file sequential read149,703042232.001.77
enq: KO - fast object checkpoint1290554300.000.23
db file scattered read3,97801640.050.07
db file parallel read58306110.010.03
enq: TX - row lock contention20315000.000.01
library cache: mutex X1,8200210.020.01
direct path write1910280.000.01
SQL*Net message to client539,1990107.190.00
enq: RO - fast object reuse3201190.000.00
log file switch completion701750.000.00
enq: CR - block range reuse ckpt3200150.000.00
undo segment extension21100060.000.00
SQL*Net more data to client7,0530000.090.00
Disk file operations I/O2,7710000.040.00
reliable message1930000.000.00
control file sequential read2840000.000.00
SQL*Net break/reset to client1,4400000.020.00
enq: TX - index contention60060.000.00
buffer busy waits6090000.010.00
read by other session10080.000.00
latch: shared pool120000.000.00
CSS initialization10050.000.00
latch: cache buffers chains780000.000.00
CSS operation: action10020.000.00
SQL*Net message from client539,2110364,7796777.19 
jobq slave wait70,3089534,8154950.94 
PL/SQL lock timer1100110010.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
log file parallel write56,727019430.7636.61
db file parallel write122,04505701.6310.82
log file sync1104439860.008.30
control file parallel write10,26902930.145.58
control file sequential read22,83301810.303.32
os thread startup49909180.011.74
Log archive I/O1,4710960.021.73
log file sequential read47205100.010.89
LNS wait on SENDREQ56,6900400.760.68
db file sequential read3780240.010.32
ASM file metadata operation6,1300100.080.26
change tracking file synchronous read1170030.000.07
direct path write2100110.000.04
change tracking file synchronous write1170010.000.03
reliable message4300000.010.02
direct path read130060.000.01
enq: CF - contention100560.000.01
db file scattered read100050.000.01
db file async I/O submit94,8460001.260.01
ADR block file write100040.000.01
log file single write120030.000.01
CSS initialization80040.000.01
kfk: async disk IO90040.000.01
ADR block file read320010.000.01
Disk file operations I/O7840000.010.00
LGWR wait for redo copy4340000.010.00
CSS operation: action80010.000.00
asynch descriptor resize599100000.010.00
CSS operation: query480000.000.00
latch free990000.000.00
rdbms ipc message103,63843158,04615251.38 
class slave wait2,871043,241150610.04 
Space Manager: slave idle wait5,1509124,31947220.07 
DIAG idle wait14,36910014,38410010.19 
smon timer12467,344592280.00 
ASM background timer1,61107,20844740.02 
wait for unread message on broadcast channel7,1991007,20610010.10 
pmon timer2,465967,20629230.03 
dispatcher timer1201007,200600020.00 
shared server idle wait2401007,200300010.00 
LNS ASYNC end of log57,25017,1991260.76 
Streams AQ: qmn slave idle wait25707,198280090.00 
Streams AQ: qmn coordinator idle wait514507,198140050.01 
SQL*Net message from client4060110.01 
KSV master wait1,0850000.01 

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 read3275.06.315.63.1    
ADR block file write10  80.020.0    
ADR file lock12100.0       
ARCH wait for archivelog lock3100.0       
ASM file metadata operation613099.4.3.0.0.0.1.1 
CSS initialization9  44.455.6    
CSS operation: action933.366.7      
CSS operation: query54100.0       
Disk file operations I/O3556100.0       
LGWR wait for redo copy439100.0       
LNS wait on SENDREQ56.7K100.0.0 .0.0 .0 
Log archive I/O147116.034.816.912.110.06.43.8 
SQL*Net break/reset to client144099.9.1      
SQL*Net message to client539.2K100.0       
SQL*Net more data from client87100.0       
SQL*Net more data to client7053100.0       
asynch descriptor resize598100.0       
buffer busy waits619100.0       
change tracking file synchronous read11759.81.711.119.74.33.4  
change tracking file synchronous write11790.6.92.61.73.4 .9 
control file parallel write10.3K83.11.72.43.65.72.41.2 
control file sequential read23.1K93.5.6.82.81.4.7.2 
cursor: pin S14100.0       
db file async I/O submit94.8K100.0       
db file parallel read58313.03.411.335.815.314.17.0 
db file parallel write122K94.32.21.31.1.7.3.1 
db file scattered read398854.84.510.818.36.83.41.3 
db file sequential read150.2K56.82.413.322.33.01.8.5 
direct path read100.6K13.16.510.414.426.922.95.8 
direct path write21225.912.711.314.221.710.83.3 
direct path write temp1100.0       
enq: CF - contention1      100.0 
enq: CR - block range reuse ckpt329.418.86.33.140.612.59.4 
enq: JS - queue lock1100.0       
enq: KO - fast object checkpoint1291.614.019.417.836.47.03.1.8
enq: RO - fast object reuse329.49.46.328.121.915.69.4 
enq: TX - index contention633.3  33.333.3   
enq: TX - row lock contention2       100.0
kfk: async disk IO955.6  33.311.1   
latch free101100.0       
latch: cache buffers chains84100.0       
latch: cache buffers lru chain2100.0       
latch: call allocation13100.0       
latch: object queue header operation1100.0       
latch: redo allocation5100.0       
latch: row cache objects1100.0       
latch: shared pool1392.3 7.7     
library cache: mutex X181992.2.2.1 7.4.1  
log file parallel write56.7K78.84.54.04.15.32.5.8.0
log file sequential read47226.129.915.57.65.16.89.1 
log file single write1266.716.7 8.3 8.3  
log file switch completion7     28.671.4 
log file sync47.7K77.45.13.74.05.82.71.1.1
os thread startup498    60.439.2.4 
read by other session1   100.0    
reliable message62399.5 .3   .2 
undo segment extension2147.6   47.64.8  
ASM background timer16118.0.8.2.2.1.4.789.4
DIAG idle wait14.4K      100.0 
KSV master wait108597.81.3.2.1.1.1.5 
LNS ASYNC end of log57.3K7.97.017.62.94.47.353.0 
PL/SQL lock timer1      100.0 
SQL*Net message from client539.5K51.712.73.42.54.06.815.23.6
Space Manager: slave idle wait5133.3.3.1.1.2.12.097.0
Streams AQ: qmn coordinator idle wait51450.0      50.0
Streams AQ: qmn slave idle wait257       100.0
class slave wait287135.9.519.33.12.92.44.032.0
dispatcher timer120       100.0
jobq slave wait70.3K.0.0.0.1.1.299.5 
pmon timer2464.1   .1.11.997.8
rdbms ipc message103.6K6.511.32.61.32.74.250.920.5
shared server idle wait240       100.0
smon timer124 4.8.8 .8 21.072.6
wait for unread message on broadcast channel7200      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 operation599.9.1.0     
LNS wait on SENDREQ2100.0.0      
Log archive I/O5696.23.6.1.1    
change tracking file synchronous write199.1.9      
control file parallel write12098.8.8.2.1.1   
control file sequential read4799.8.2.0.0    
db file parallel read4193.06.2.9     
db file parallel write14599.9.1.0.0    
db file scattered read5098.71.0.2.1    
db file sequential read67899.5.4.1.0    
direct path read583494.25.3.5.0.0   
direct path write796.72.4.5.5    
enq: CF - contention1 100.0      
enq: CR - block range reuse ckpt390.63.16.3     
enq: KO - fast object checkpoint496.13.1     .8
enq: RO - fast object reuse390.63.1 6.3    
enq: TX - row lock contention2      100.0 
log file parallel write46599.2.6.1.0.0  .0
log file sequential read4390.94.94.0.2    
log file switch completion528.628.614.328.6    
log file sync51998.8.8.2.1.1  .1
os thread startup299.6.4      
reliable message199.8.2      

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
enq: KO - fast object checkpoint199.2    .8  
log file parallel write1100.0    .0  
log file sync4799.9.0.0.0.0.1  

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical Reads (K)Logical Reads (K)
wzol20,84417,59817,5322,273,378
SYS$USERS2,9702,36384255,433
SYS$BACKGROUND000163
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 21008915434160005449001
SYS$USERS 47670149212320014400
SYS$BACKGROUND 12072520900566854

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
4,028.767,0840.5716.9199.940.00cg6hra1s3mg6v Mic.DataChangeServer.exe SELECT * FROM (SELECT S.SALESO...
2,742.122,3711.1611.5199.950.00d6fx4dcuz5a30 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
1,842.711,7251.077.7499.900.06578kvyc0rcmm4 WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
1,455.481,3601.076.1199.730.228ht8yrs78xj49 WZOLService.WindowsService.exe begin Create_Waybillpackage30(...
1,240.528651.435.2199.400.576182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...
1,229.212,9230.425.1699.950.020tnjgjztc81h2 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
1,192.863732.245.0199.980.013rfa3jdts90xg WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
1,169.432940.334.9199.970.018q1r67mcuxg6f WZOLService.WindowsService.exe begin Sorting_Bill_Sure30(AS_S...
919.286931.333.8699.970.00ah0gcgvg8d726   INSERT INTO SALESORDER_BILL_IN...
897.025851.533.7799.930.0398t4azsnjmvp0 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
713.686971.023.0099.950.00003090gzr56w2 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
549.479480.582.3199.930.00fg6k4m6t4cgx7   SELECT KQ.CXFLAG, KQ.WAREHOUSE...
475.453801.252.0098.501.46a1bq05mx2wp39 WZOLService.WindowsService.exe begin Picking_Bill_Consign30(A...
469.664410.671.974.4495.69gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
469.373,5960.131.9799.690.000bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
440.013801.161.8599.920.04f319mcpzrcydh WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
433.446920.631.8299.950.00ags6vx459vc0s PL/SQL Developer INSERT INTO SALESORDER_CONSIGN...
317.382311.371.3399.240.717d9bcscmbwshd WZOLService.WindowsService.exe begin Picking_Bill_Sure30(AS_S...
315.422851.111.3299.960.0084k2mp6rgxpy6 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
306.916620.461.2999.820.129rdgpzbfxaz5w WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
304.983,5990.081.2899.710.00ckk296gsdch3b Mic.DataChangeServer.exe Select Systemid, Availablesale...
260.682410.861.096.6293.45dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
242.561961.241.0298.491.467wahvsbqhx79c WZOLService.WindowsService.exe begin Salesorder_Collect31(AS_...

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
4,026.427,0840.5720.174,028.7699.940.00cg6hra1s3mg6v Mic.DataChangeServer.exe SELECT * FROM (SELECT S.SALESO...
2,740.772,3711.1613.732,742.1299.950.00d6fx4dcuz5a30 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
1,840.801,7251.079.221,842.7199.900.06578kvyc0rcmm4 WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
1,451.601,3601.077.271,455.4899.730.228ht8yrs78xj49 WZOLService.WindowsService.exe begin Create_Waybillpackage30(...
1,233.058651.436.181,240.5299.400.576182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...
1,228.542,9230.426.151,229.2199.950.020tnjgjztc81h2 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
1,192.583732.235.971,192.8699.980.013rfa3jdts90xg WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
1,169.042940.315.861,169.4399.970.018q1r67mcuxg6f WZOLService.WindowsService.exe begin Sorting_Bill_Sure30(AS_S...
918.996931.334.60919.2899.970.00ah0gcgvg8d726   INSERT INTO SALESORDER_BILL_IN...
896.435851.534.49897.0299.930.0398t4azsnjmvp0 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
713.366971.023.57713.6899.950.00003090gzr56w2 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
549.119480.582.75549.4799.930.00fg6k4m6t4cgx7   SELECT KQ.CXFLAG, KQ.WAREHOUSE...
468.313801.232.35475.4598.501.46a1bq05mx2wp39 WZOLService.WindowsService.exe begin Picking_Bill_Consign30(A...
467.923,5960.132.34469.3799.690.000bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
439.683801.162.20440.0199.920.04f319mcpzrcydh WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
433.226920.632.17433.4499.950.00ags6vx459vc0s PL/SQL Developer INSERT INTO SALESORDER_CONSIGN...
315.302851.111.58315.4299.960.0084k2mp6rgxpy6 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
314.982311.361.58317.3899.240.717d9bcscmbwshd WZOLService.WindowsService.exe begin Picking_Bill_Sure30(AS_S...
306.366620.461.53306.9199.820.129rdgpzbfxaz5w WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
304.093,5990.081.52304.9899.710.00ckk296gsdch3b Mic.DataChangeServer.exe Select Systemid, Availablesale...
238.901961.221.20242.5698.491.467wahvsbqhx79c WZOLService.WindowsService.exe begin Salesorder_Collect31(AS_...
230.161971.171.15230.6099.810.135hwdf0wvghfcw 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
449.434410.2126.54469.664.4495.69gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
243.602410.1514.38260.686.6293.45dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
178.00208.9010.51199.8411.0589.078mqu64chw8cmd WZOLService.WindowsService.exe Select Z.Mopocsalesorderbillid...
145.12178.548.57163.7911.4888.60f2mwz1zyzc4uv WZOLService.WindowsService.exe Select Z.Mopocsalesorderbillid...
72.66172.664.2993.1221.6178.036mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
60.15125.013.5570.4214.6485.42bypmfr5wammfu WZOLService.WindowsService.exe Select WAYBILL_HANDINGBATCH.BA...
56.75156.753.3559.837.2194.8519ndx01y0mz8a WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
35.16103.522.0835.852.7898.068szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
8.6618.660.5163.450.8113.6549235vb3j9h2h WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
7.058650.010.421,240.5299.400.576182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...

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
395,865,922865457,648.4615.651,240.5299.4.66182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...
395,505,4432,923135,308.0515.641,229.2199.900tnjgjztc81h2 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
320,486,1542,371135,169.1912.672,742.121000d6fx4dcuz5a30 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
233,294,6691,725135,243.299.221,842.7199.9.1578kvyc0rcmm4 WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
184,225,0871,360135,459.627.281,455.4899.7.28ht8yrs78xj49 WZOLService.WindowsService.exe begin Create_Waybillpackage30(...
170,661,1657,08424,091.076.754,028.7699.90cg6hra1s3mg6v Mic.DataChangeServer.exe SELECT * FROM (SELECT S.SALESO...
169,712,235374,586,817.166.711,192.8610003rfa3jdts90xg WZOLService.WindowsService.exe UPDATE PURCHASE_RETURNBILLDETA...
168,323,012295,804,241.796.661,169.4310008q1r67mcuxg6f WZOLService.WindowsService.exe begin Sorting_Bill_Sure30(AS_S...
99,120,721697142,210.503.92713.681000003090gzr56w2 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
93,713,695693135,229.003.71919.281000ah0gcgvg8d726   INSERT INTO SALESORDER_BILL_IN...
93,603,900692135,265.753.70433.4499.90ags6vx459vc0s PL/SQL Developer INSERT INTO SALESORDER_CONSIGN...
92,206,638231399,162.943.65317.3899.2.77d9bcscmbwshd WZOLService.WindowsService.exe begin Picking_Bill_Sure30(AS_S...
89,488,874662135,179.573.54306.9199.8.19rdgpzbfxaz5w WZOLService.WindowsService.exe INSERT INTO WAYBILL_PACKAGE (S...
62,286,574380163,912.042.46475.4598.51.5a1bq05mx2wp39 WZOLService.WindowsService.exe begin Picking_Bill_Consign30(A...
57,818,59558598,835.212.29897.0299.9098t4azsnjmvp0 WZOLService.WindowsService.exe SELECT (case when plan_qty > r...
55,738,9343,59615,500.262.20469.3799.700bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
51,443,303380135,377.112.03440.0199.90f319mcpzrcydh WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
50,684,957235215,680.672.0093.9510004y3n46d9brtxv WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
48,191,910315152,990.191.91121.781000apn3u2a6rx4s0 WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
48,191,868315152,990.061.91115.6099.902mqb8vy7su3f0 WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
40,238,656183219,883.371.5975.9899.901q85jprkn4c32 WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
38,529,566285135,191.461.52315.42100084k2mp6rgxpy6 WZOLService.WindowsService.exe UPDATE SALESORDER_BILL T SET T...
27,448,288168163,382.671.0966.911000fwwdq59ky8mqb WZOLService.WindowsService.exe select a.posid , decode(a.rf_f...
27,164,856196138,596.201.07242.5698.51.57wahvsbqhx79c WZOLService.WindowsService.exe begin Salesorder_Collect31(AS_...
26,679,561197135,429.241.05230.6099.8.15hwdf0wvghfcw 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
5,946,97244135,158.4533.75469.664.4495.69gkz1gdwyk1ubw w3wp.exe SELECT T.BILL_STATE, T.WAREHOU...
3,330,36024138,765.0018.90260.686.6293.45dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
2,708,02020135,401.0015.37199.8411.0589.078mqu64chw8cmd WZOLService.WindowsService.exe Select Z.Mopocsalesorderbillid...
2,296,00917135,059.3513.03163.7911.4888.60f2mwz1zyzc4uv WZOLService.WindowsService.exe Select Z.Mopocsalesorderbillid...
896,9941274,749.505.0970.4214.6485.42bypmfr5wammfu WZOLService.WindowsService.exe Select WAYBILL_HANDINGBATCH.BA...
194,4281194,428.001.1059.837.2194.8519ndx01y0mz8a WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
135,0841135,084.000.7763.450.8113.6549235vb3j9h2h WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
67,500167,500.000.3893.1221.6178.036mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
11,557101,155.700.0735.852.7898.068szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
3,1295625.800.021.4937.3463.314wp3919j4r4wx WZOLService.WindowsService.exe select tt.* from ( select rq,...

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
60,54660,546160,546.000.0019.9719ndx01y0mz8a WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
31,76331,763131,763.000.0010.486mcpb06rctk0x DBMS_SCHEDULER call dbms_space.auto_space_adv...
26,61926,619241,109.130.008.78dn8w89jx7k958 oracle@db-bi-218 (TNS V1-V3) SELECT /*+ OPAQUE_TRANSFORM */...
20,98820,988201,049.400.006.928mqu64chw8cmd WZOLService.WindowsService.exe Select Z.Mopocsalesorderbillid...
19,55619,556171,150.350.006.45f2mwz1zyzc4uv WZOLService.WindowsService.exe Select Z.Mopocsalesorderbillid...
11,55711,557101,155.700.003.818szmwam7fysa3 DBMS_SCHEDULER insert into wri$_adv_objspace_...
7,2257,22512602.080.002.38bypmfr5wammfu WZOLService.WindowsService.exe Select WAYBILL_HANDINGBATCH.BA...
1,1531,15311,153.000.000.3849235vb3j9h2h WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
1,0201,0208651.180.000.346182rs2up50j6 WZOLService.WindowsService.exe begin Waybill_Package_Packing(...
9619613802.530.000.32a1bq05mx2wp39 WZOLService.WindowsService.exe begin Picking_Bill_Consign30(A...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
32,33232,3321.000.7389.303hkxqb42macn7   SELECT S.SYSTEM_PREFIXION FROM...
13,583107,2847.901.50103.20cm5vu20fhtnq1   select /*+ connect_by_filterin...
13,20013,2001.002.289807a5jkcsq9rghb w3wp.exe insert into if_base_goodsinfo...
10,32910,3291.000.8898.20as0uaw3pvcz1c   SELECT COUNT(*) FROM USER_OBJE...
7,08417,0342.404,028.7699.90cg6hra1s3mg6v Mic.DataChangeServer.exe SELECT * FROM (SELECT S.SALESO...
6,1096,1041.001.2063.435.1ghn9v5v7n3h10   UPDATE INVENTORY_OWNER B SET B...
3,61362,19417.218.6798.90gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
3,5994,1151.14304.9899.70ckk296gsdch3b Mic.DataChangeServer.exe Select Systemid, Availablesale...
3,5963,6891.03469.3799.700bxgpsyhq71ds Mic.DataChangeServer.exe SELECT SYSTEMID, PICKINGBILLSO...
3,4943,4941.001.0198.41.9d1bcnr2fp1hqq   INSERT INTO IF_INVENTORY_AVAIL...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
2,51713,5831.48cm5vu20fhtnq1   select /*+ connect_by_filterin...
2,5132,5181.480k8522rmdzg4k   select privilege# from sysauth...
2,4272,4241.4347a50dvdgnxc2   update sys.job$ set failures=0...
2,4192,4191.43aq8yqxyyb40nn   update sys.job$ set this_date=...
2,4182,4191.42cumjq42201t37   select u1.user#, u2.user#, u3....
2,2672,2681.34awrr2c9hqf7p0   select sysdate+:"SYS_B_0"/:"SY...
1,7591,7591.04350f5yrnnmshs   lock table sys.mon_mods$ in ex...
1,52232,3320.903hkxqb42macn7   SELECT S.SYSTEM_PREFIXION FROM...
7706,1090.45ghn9v5v7n3h10   UPDATE INVENTORY_OWNER B SET B...
7162,1010.429ft6j9dzp08fu   DELETE FROM SALESORDER_BILL_IN...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
18,005,1973,6130.55gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
3,516,0532970.11855ujr57gfudb WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
3,199,6533,6130.10gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
2,852,5401430.099arsdb1fdbbky WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
2,369,4533,6130.07gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
2,253,515700.077k8g2vt2m1c8p WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,893,9752990.063h8bbarvsmgjn WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,562,1332970.05855ujr57gfudb WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,450,4273150.04apn3u2a6rx4s0 WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,259,1662590.049hy85jupdj6qt WZOLService.WindowsService.exe select count(:"SYS_B_0") from ...
1,220,06270.047h38rm3myd747 WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,124,1573,6130.03gamdzj6zhw0wz WZOLService.WindowsService.exe SELECT * FROM (SELECT A.*, ROW...
1,072,3455280.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
19ndx01y0mz8a select count(:"SYS_B_0") from (select waybilldetail_packagehangding.systemid, waybilldetail_packagehangding.waybill_packagedetailid, waybilldetail_packagehangding.waybill_packageid, waybilldetail_packagehangding.waybill_packageno, waybilldetail_packagehangding.mopocsalesorderbilldetailid, waybilldetail_packagehangding.mopocsalesorderbillid, waybilldetail_packagehangding.outersalesorderbillid, waybilldetail_packagehangding.outersalesorderbilldetailid, waybilldetail_packagehangding.shopid, waybilldetail_packagehangding.ownerid, waybilldetail_packagehangding.ordertypeid, waybilldetail_packagehangding.departmentid, waybilldetail_packagehangding.warehouseid, waybilldetail_packagehangding.skuid, waybilldetail_packagehangding.saleprice, waybilldetail_packagehangding.discount, waybilldetail_packagehangding.package_qty, waybilldetail_packagehangding.package_saleamount, waybilldetail_packagehangding.qc_weight, waybilldetail_packagehangding.production_date, waybilldet ail_packagehangding.packed_date, waybilldetail_packagehangding.warranty_enddate, waybilldetail_packagehangding.warranty, waybilldetail_packagehangding.production_batchnumber, waybilldetail_packagehangding.pickingbillid, waybilldetail_packagehangding.pickingbillno, waybilldetail_packagehangding.createuserid, waybilldetail_packagehangding.updateuserid, waybilldetail_packagehangding.createtime, waybilldetail_packagehangding.updatetime, waybilldetail_packagehangding.bill_state, waybilldetail_packagehangding.oldbill_state, waybilldetail_packagehangding.state_desc, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.GOODSNO, 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 from waybilldetail_packagehangding, salesorder_bill, BASE_GOODSINFO, BASE_PROVINCE, BASE_CITY, BASE_AR EA where waybilldetail_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid and waybilldetail_packagehangding.SKUID = BASE_GOODSINFO.SKUID(+) 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 WAYBILLDETAIL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND WAYBILLDETAIL_PACKAGEHANGDING.PICKINGBILLNO = :"SYS_B_2" Order By CREATETIME desc, WAYBILL_PACKAGEDETAILID desc, WAYBILL_PACKAGEDETAILID desc)
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)
2mqb8vy7su3f0 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 RECEIVERMOBILE = :"SYS_B_2" Order By MOPOCSALESORDERBILLID)
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
3h8bbarvsmgjn 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 (WAYBILL_LEADIN.OWNERID =:"SYS_B_05") and Not Exists ( Select :"SYS_B_06" From Base_Shopgroup, Base_Shopgroup_Shop Where Base_Shopgroup.Shopgroupid = Base_Shopgroup_Shop.Shopgroupid And Base_Shopgroup_Shop.Enableflag = :"SYS_B_07" And Base_Shopgroup.Enableflag = :"SYS_B_08" 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_09" ) WHERE RN > :"SYS_B_10"
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
49235vb3j9h2h select count(:"SYS_B_0") from (select waybilldetail_packagehangding.systemid, waybilldetail_packagehangding.waybill_packagedetailid, waybilldetail_packagehangding.waybill_packageid, waybilldetail_packagehangding.waybill_packageno, waybilldetail_packagehangding.mopocsalesorderbilldetailid, waybilldetail_packagehangding.mopocsalesorderbillid, waybilldetail_packagehangding.outersalesorderbillid, waybilldetail_packagehangding.outersalesorderbilldetailid, waybilldetail_packagehangding.shopid, waybilldetail_packagehangding.ownerid, waybilldetail_packagehangding.ordertypeid, waybilldetail_packagehangding.departmentid, waybilldetail_packagehangding.warehouseid, waybilldetail_packagehangding.skuid, waybilldetail_packagehangding.saleprice, waybilldetail_packagehangding.discount, waybilldetail_packagehangding.package_qty, waybilldetail_packagehangding.package_saleamount, waybilldetail_packagehangding.qc_weight, waybilldetail_packagehangding.production_date, waybilldet ail_packagehangding.packed_date, waybilldetail_packagehangding.warranty_enddate, waybilldetail_packagehangding.warranty, waybilldetail_packagehangding.production_batchnumber, waybilldetail_packagehangding.pickingbillid, waybilldetail_packagehangding.pickingbillno, waybilldetail_packagehangding.createuserid, waybilldetail_packagehangding.updateuserid, waybilldetail_packagehangding.createtime, waybilldetail_packagehangding.updatetime, waybilldetail_packagehangding.bill_state, waybilldetail_packagehangding.oldbill_state, waybilldetail_packagehangding.state_desc, BASE_GOODSINFO.GOODSBARCODE, BASE_GOODSINFO.GOODSNAME, BASE_GOODSINFO.GOODSNO, 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 from waybilldetail_packagehangding, salesorder_bill, BASE_GOODSINFO, BASE_PROVINCE, BASE_CITY, BASE_AR EA where waybilldetail_packagehangding.mopocsalesorderbillid = salesorder_bill.mopocsalesorderbillid and waybilldetail_packagehangding.SKUID = BASE_GOODSINFO.SKUID(+) 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 WAYBILLDETAIL_PACKAGEHANGDING.WAREHOUSEID=:"SYS_B_1" AND WAYBILLDETAIL_PACKAGEHANGDING.MOPOCSALESORDERBILLID = :"SYS_B_2" Order By CREATETIME desc, WAYBILL_PACKAGEDETAILID desc, WAYBILL_PACKAGEDETAILID desc)
4wp3919j4r4wx select tt.* from ( select rq, sum(jxdds) jxdds, sum(jxrs) jxrs, trunc(sum(jxdds) / decode(sum(jxrs), :"SYS_B_00", :"SYS_B_01", sum(jxrs)), :"SYS_B_02") zdxl, sum(zjdds) zjdds, sum(zjrs) zjrs, trunc(sum(zjdds) / decode(sum(zjrs), :"SYS_B_03", :"SYS_B_04", sum(zjrs)), :"SYS_B_05") zjxl, sum(xtdds) xtdds, sum(xtrs) xtrs, trunc(sum(xtdds) / decode(sum(xtrs), :"SYS_B_06", :"SYS_B_07", sum(xtrs)), :"SYS_B_08") xtxl from (select trunc(t.pickingtime) rq, count(*) jxdds, count(distinct t.pickinguserid) jxrs, :"SYS_B_09" zjdds, :"SYS_B_10" zjrs, :"SYS_B_11" xtdds, :"SYS_B_12" xtrs from salesorder_bill t where t.pickingtime > to_date(:"SYS_B_13", :"SYS_B_14") and t.pickingtime < to_date(:"SYS_B_15", :"SYS_B_16") and t.warehouseid = :"SYS_B_17" group by trunc(t.pickingtime) union all sel ect trunc(r.QCTIME) rq, :"SYS_B_18", :"SYS_B_19", count(*) zjdds, count(distinct b.posid), :"SYS_B_20", :"SYS_B_21" from salesorder_bill r, picking_bill_his b where r.pickingbillid = b.pickingbillid and r.qctime > to_date(:"SYS_B_22", :"SYS_B_23") and r.qctime < to_date(:"SYS_B_24", :"SYS_B_25") and r.warehouseid = :"SYS_B_26" group by trunc(r.QCTIME) union select trunc(y.QCTIME) rq, :"SYS_B_27", :"SYS_B_28", count(*) zjdds, count(distinct c.posid), :"SYS_B_29", :"SYS_B_30" from salesorder_bill y, picking_bill c where y.pickingbillid = c.pickingbillid and y.qctime > to_date(:"SYS_B_31", :"SYS_B_32") and y.qctime < to_date(:"SYS_B_33", :"SYS_B_34") and y.warehouseid like :"SYS_B_35" group by trunc(y.QCTIME) union select trunc(w.createdate), :"SYS_B_36", :"SYS_B_37 ", :"SYS_B_38", :"SYS_B_39", count(*), count(distinct w.confirmuserid) from salesreturn_bill w where w.createdate > to_date(:"SYS_B_40", :"SYS_B_41") and w.createdate < to_date(:"SYS_B_42", :"SYS_B_43") and w.warehouseid = :"SYS_B_44" group by trunc(w.createdate)) y group by rq --order by rq ) tt where :"SYS_B_45"=:"SYS_B_46" AND :"SYS_B_47"=:"SYS_B_48" Order By rq
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"
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
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 ( )
7a5jkcsq9rghb insert into if_base_goodsinfo (goodsid, skuid, productid, brandid, goodsno, goodsbarcode, goodsname, snno, displayname, englishname, marketprice, mnemoniccode, keyword, goodstypeid, statisticid, sexpropertyid, seasonpropertyid, agepropertyid, salepropertyid, colorpropertyid, unitrpropertyid, gradepropertyid, stylepropertyid, levelpropertyid, managepropertyid, registered_trademark, warrantyflag, warranty, approval_code, place_production, manufacturer, manufacturergoodsno, taxrate, accountrate, marketingtypeid, remark, prodescription, marketdate, freight, specification, costlyflag, weight, length, width, heigth, volume, partitionqty, partitionrate, partitionflag, logisticsflag, jitflag, snflag, pubflag, pubdate, pubuserid, enableflag, enableuserid, enabledate, disableuserid, disabledate, createuserid, createdate, updateuserid, updatedate, dangerflag, ownerid) values(:goodsid, :skuid, :productid, :brandid, :goodsno, :goodsbarcode, :goodsname, :snno, :displayname, :englishname, :mark etprice, :mnemoniccode, :keyword, :goodstypeid, :statisticid, :sexpropertyid, :seasonpropertyid, :agepropertyid, :salepropertyid, :colorpropertyid, :unitrpropertyid, :gradepropertyid, :stylepropertyid, :levelpropertyid, :managepropertyid, :registered_trademark, :warrantyflag, :warranty, :approval_code, :place_production, :manufacturer, :manufacturergoodsno, :taxrate, :accountrate, :marketingtypeid, :remark, :prodescription, :marketdate, :freight, :specification, :costlyflag, :weight, :length, :width, :heigth, :volume, :partitionqty, :partitionrate, :partitionflag, :logisticsflag, :jitflag, :snflag, :pubflag, :pubdate, :pubuserid, :enableflag, :enableuserid, :enabledate, :disableuserid, :disabledate, :createuserid, :createdate, :updateuserid, :updatedate, :dangerousflag, :ownerid)
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"
7k8g2vt2m1c8p 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 ) And SHOPID in (:"SYS_B_11") Order By WAYBILL_LEADIN.BILL_STATE asc , WAYBILL_LEADIN.paytime asc, WAYBILL_LEADIN.MOPOCSALESORDERBILLID asc ) A WHERE ROWNUM <= :"SYS_B_12" ) WHERE RN > :"SYS_B_13"
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;
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 )
855ujr57gfudb 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"
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;
8mqu64chw8cmd Select Z.Mopocsalesorderbillid, Z.Outersalesorderbillid, Z.Invoice_Amount, Z.Invoice_Name, Z.Invoice_Content, Z.Ordertime, Z.Package_Saleamount, S.Skuid, S.Goodsbarcode, S.Goodsname, G.Package_Qty, G.Saleprice, G.Package_Saleamount, Z.Receivername, z.Posid, Z.Invoiceflag, Z.Shopid, Z.Waybill_Packageid, Z.Waybill_Packageno, Z.Package_Serial, Z.Package_Number, nvl((Select h.Waybill_Packageno From Waybill_Package h Where h.Mopocsalesorderbillid = Z.Mopocsalesorderbillid And h.Package_Serial = :"SYS_B_0"), :"SYS_B_1") Fpbg, F.Ksdz_Printflag, F.Ksdz, z.boxno, p.province_name, c.city_name, q.area_name, z.receiveraddress, z.receivermobile, z.receiverphone, d.account_paid, d.order_saleamount, d.Delivery_Cost, d.receivable_amount, z.Outersalesorderbillid sbrv27_compute_1, --条码为外部单号 s.goodsname sbrv27_compute_5, g.saleprice * g.PACKAGE_QTY sbrv27_detail_total, s.skuid sbrv27_compute_4, rownum sbrv27_compute_7, g.package_qty sbrv27_comp ute_2, g.saleprice * g.PACKAGE_QTY sbrv27_compute_6, decode(d.account_paid, null, :"SYS_B_2", d.account_paid) sbrv27_compute_3 From Waybilldetail_Package g Left Join Waybill_Package z On Z.Waybill_Packageid = G.Waybill_Packageid Left Join Base_Goodsinfo s On S.Skuid = G.Skuid Left Join Base_Owner_Forhaitao f On F.Warehouseid = Z.Warehouseid And F.Platformid = Z.Platformid And F.Ownerid = Z.Ownerid Left Join Base_Province p On p.Province_Id = Z.Receiverstate Left Join Base_City c On C.City_Id = Z.Receivercity Left Join Base_Area q On Q.Area_Id = Z.Receiverdistrict Left Join salesorder_bill d On D.MOPOCSALESORDERBILLID = z.mopocsalesorderbillid Where G.Waybill_Packageid = :Arg_Billid
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;
8szmwam7fysa3insert into wri$_adv_objspace_trend_data select timepoint, space_usage, space_alloc, quality from table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL, NULL, 'FALSE', :5, 'FALSE'))
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"
9arsdb1fdbbky SELECT * FROM (SELECT A.*, ROWNUM RN FROM ( SELECT STOCKOUT_DETAIL.SYSTEMID, STOCKOUT_DETAIL.STOCKOUTSTATE, STOCKOUT_DETAIL.STOCKOUTDETAILID, STOCKOUT_DETAIL.SOURCETYPEID, STOCKOUT_DETAIL.SOURCEBILLID, STOCKOUT_DETAIL.SOURCEBILLNO, STOCKOUT_DETAIL.SOURCEBILLDETAILID, STOCKOUT_DETAIL.OWNERID, STOCKOUT_DETAIL.DEPARTMENTID, STOCKOUT_DETAIL.WAREHOUSEID, STOCKOUT_DETAIL.STOCKOUTTYPEID, STOCKOUT_DETAIL.STOCKOUTRANKID, STOCKOUT_DETAIL.SKUID, STOCKOUT_DETAIL.PRICE, STOCKOUT_DETAIL.QTY, STOCKOUT_DETAIL.QTY_PRICEAMOUNT, STOCKOUT_DETAIL.CREATEUSERID, STOCKOUT_DETAIL.CREATEDATE, STOCKOUT_DETAIL.CHECKUSERID, STOCKOUT_DETAIL.CHECKDATE, STOCKOUT_DETAIL.UPDATEUSERID, STOCKOUT_DETAIL.UPDATEDATE, STOCKOUT_DETAIL.BILL_STATE, STOCKOUT_DETAIL.OLDBILL_STATE, STOCKOUT_DETAIL.STATE_DESC, BASE_GOODSINFO.GOODSNAME , BASE_GOODSINFO.GOODSNO , BASE_GOODSINFO.GOODSBARCODE , :"SYS_B_0" as selectedflag FROM STOCKOUT_DETAIL, BASE_GOODSINFO WHERE ( STOCKOUT_DETAIL.SKUID = BASE_GOODSINFO.SKUID(+) ) and (STOCK OUT_DETAIL.BILL_STATE=:"SYS_B_1") and Stockout_Detail.warehouseid=:"SYS_B_2" and Stockout_Detail.ownerid=:"SYS_B_3" Order By STOCKOUTDETAILID desc) A WHERE ROWNUM <= :"SYS_B_4" ) WHERE RN > :"SYS_B_5"
9ft6j9dzp08fuDELETE FROM SALESORDER_BILL_INTERCEPT_TEMP
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
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
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
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"
f2mwz1zyzc4uv Select Z.Mopocsalesorderbillid, Z.Outersalesorderbillid, Z.Invoice_Amount, Z.Invoice_Name, Z.Invoice_Content, Z.Ordertime, Z.Package_Saleamount, S.Skuid, S.Goodsbarcode, S.Goodsname, G.Package_Qty, G.Saleprice, G.Package_Saleamount, Z.Receivername, z.Posid, Z.Invoiceflag, Z.Shopid, Z.Waybill_Packageid, Z.Waybill_Packageno, Z.Package_Serial, Z.Package_Number, nvl((Select h.Waybill_Packageno From Waybill_Package h Where h.Mopocsalesorderbillid = Z.Mopocsalesorderbillid And h.Package_Serial = :"SYS_B_0"), :"SYS_B_1") Fpbg, F.Ksdz_Printflag, F.Ksdz, z.boxno, p.province_name, c.city_name, q.area_name, z.receiveraddress, z.receivermobile, z.receiverphone, d.account_paid, d.order_saleamount, d.Delivery_Cost, d.receivable_amount, z.Outersalesorderbillid sbrvs30_compute_1, --条码为外部单号 s.goodsname sbrvs30_compute_5, g.saleprice * g.PACKAGE_QTY sbrvs30_detail_total, s.skuid sbrvs30_compute_4, rownum sbrvs30_compute_7, g.package_qty sbrvs3 0_compute_2, g.saleprice * g.PACKAGE_QTY sbrvs30_compute_6, decode(d.account_paid, null, :"SYS_B_2", d.account_paid) sbrvs30_compute_3 From Waybilldetail_Package g Left Join Waybill_Package z On Z.Waybill_Packageid = G.Waybill_Packageid Left Join Base_Goodsinfo s On S.Skuid = G.Skuid Left Join Base_Owner_Forhaitao f On F.Warehouseid = Z.Warehouseid And F.Platformid = Z.Platformid And F.Ownerid = Z.Ownerid Left Join Base_Province p On p.Province_Id = Z.Receiverstate Left Join Base_City c On C.City_Id = Z.Receivercity Left Join Base_Area q On Q.Area_Id = Z.Receiverdistrict Left Join salesorder_bill d On D.MOPOCSALESORDERBILLID = z.mopocsalesorderbillid Where G.Waybill_Packageid = :Arg_Billid
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 )
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
fwwdq59ky8mqbselect a.posid , decode(a.rf_flag, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02")||a.posid as post, count(*) as count from shelve_batch a where a.rf_flag<>:"SYS_B_03" and nvl(a.BUSINESSTYPEID, :"SYS_B_04") <> :"SYS_B_05" and (bill_state=:"SYS_B_06" or (bill_state=:"SYS_B_07" and (state_desc=:"SYS_B_08" or (state_desc=:"SYS_B_09" and exists (select a.shelve_batchid from receive_bill left join shelve_bill on shelve_bill.logisticsbillid=receive_bill.receivebillid where receive_bill.shelve_batchid =a.SHELVE_BATCHID group by a.shelve_batchid having sum(decode(shelve_bill.shelveprint, :"SYS_B_10", :"SYS_B_11", :"SYS_B_12")) < count(shelve_bill.shelvebillid) Or sum(shelve_bill.shelveprint)=:"SYS_B_13"))))) and a.warehouseid=:"SYS_B_14" group by a.posid, a.rf_flag
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 count1,1760.160.02
Batched IO (full) vector count9610.130.01
Batched IO block miss count6,4230.890.09
Batched IO buffer defrag count80.000.00
Batched IO double miss count540.010.00
Batched IO same unit count3,6940.510.05
Batched IO single block count1,5960.220.02
Batched IO slow jump count80.000.00
Batched IO vector block count2,0930.290.03
Batched IO vector read count5600.080.01
Block Cleanout Optim referenced20,8842.900.28
CCursor + sql area evicted210.000.00
CPU used by this session1,994,901276.8126.60
CPU used when call started1,758,221243.9623.44
CR blocks created37,9755.270.51
Cached Commit SCN referenced9,9921.390.13
Commit SCN cached19,3992.690.26
DB time5,816,744807.1177.56
DBWR checkpoint buffers written308,53142.814.11
DBWR checkpoints1640.020.00
DBWR object drop buffers written5100.070.01
DBWR parallel query checkpoint buffers written00.000.00
DBWR revisited being-written buffer342,10647.474.56
DBWR tablespace checkpoint buffers written8,0341.110.11
DBWR thread checkpoint buffers written00.000.00
DBWR transaction table writes4480.060.01
DBWR undo block writes79,30911.001.06
DFO trees parallelized00.000.00
DML statements parallelized00.000.00
Effective IO time1,245,678,835172,845.8116,610.16
HSC Heap Segment Block Changes1,279,542177.5417.06
HSC IDL Compressed Blocks12,2461.700.16
Heap Segment Array Inserts130,09018.051.73
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued146,60020.341.95
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 client539,20074.827.19
RowCR - row contention2670.040.00
RowCR attempts209,39929.062.79
RowCR hits508,57270.576.78
SMON posted for dropping temp segment00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink400.010.00
SQL*Net roundtrips to/from client539,19274.827.19
SQL*Net roundtrips to/from dblink00.000.00
active txn count during cleanout81,17411.261.08
application wait time5,9100.820.08
background checkpoints completed30.000.00
background checkpoints started30.000.00
background timeouts44,8486.220.60
branch node splits130.000.00
buffer is not pinned count436,082,49960,509.205,814.82
buffer is pinned count8,803,628,1031,221,559.03117,389.53
bytes received via SQL*Net from client364,227,95450,538.934,856.70
bytes received via SQL*Net from dblink00.000.00
bytes sent via SQL*Net to client714,673,20799,165.429,529.61
bytes sent via SQL*Net to dblink00.000.00
calls to get snapshot scn: kcmgss1,329,501184.4817.73
calls to kcmgas280,91038.983.75
calls to kcmgcs1,573,313218.3120.98
cell physical IO interconnect bytes153,348,036,60821,278,009.052,044,776.81
change write time2,3750.330.03
cleanout - number of ktugct calls74,63810.361.00
cleanouts and rollbacks - consistent read gets23,6113.280.31
cleanouts only - consistent read gets14,2261.970.19
cluster key scan block gets15,2522.120.20
cluster key scans10,6281.470.14
commit batch performed31,4054.360.42
commit batch requested31,4054.360.42
commit batch/immediate performed32,1444.460.43
commit batch/immediate requested32,1444.460.43
commit cleanout failures: block lost52,3247.260.70
commit cleanout failures: buffer being written20.000.00
commit cleanout failures: callback failure1,0190.140.01
commit cleanout failures: cannot pin2130.030.00
commit cleanouts766,704106.3910.22
commit cleanouts successfully completed713,14698.959.51
commit immediate performed7390.100.01
commit immediate requested7390.100.01
commit nowait performed31,1034.320.41
commit nowait requested31,1034.320.41
commit txn count during cleanout92,94712.901.24
commit wait/nowait performed31,1034.320.41
commit wait/nowait requested31,1034.320.41
concurrency wait time1,0870.150.01
consistent changes1,610,171223.4221.47
consistent gets2,522,541,641350,018.5933,636.13
consistent gets - examination21,565,9322,992.41287.56
consistent gets direct17,415,4902,416.51232.22
consistent gets from cache2,505,126,178347,602.0933,403.91
consistent gets from cache (fastpath)2,479,903,200344,102.2433,067.58
cursor authentications9900.140.01
data blocks consistent reads - undo records applied156,33621.692.08
db block changes6,596,793915.3587.96
db block gets6,557,095909.8487.43
db block gets direct17,8432.480.24
db block gets from cache6,539,252907.3687.20
db block gets from cache (fastpath)1,066,201147.9414.22
deferred (CURRENT) block cleanout applications274,20338.053.66
dirty buffers inspected5100.070.01
enqueue conversions6,9840.970.09
enqueue deadlocks00.000.00
enqueue releases906,053125.7212.08
enqueue requests906,104125.7312.08
enqueue timeouts90.000.00
enqueue waits2030.030.00
exchange deadlocks00.000.00
execute count1,137,762157.8715.17
failed probes on index block reclamation60.000.00
file io service time00.000.00
file io wait time727,475,291100,941.799,700.32
frame signature mismatch00.000.00
free buffer inspected268,39437.243.58
free buffer requested569,77579.067.60
heap block compress169,32923.502.26
hot buffers moved to head of LRU130,41918.101.74
immediate (CR) block cleanout applications37,8375.250.50
immediate (CURRENT) block cleanout applications100,05813.881.33
in call idle wait time32,522,7204,512.73433.67
index crx upgrade (positioned)7400.100.01
index fast full scans (direct read)00.000.00
index fast full scans (full)1,3260.180.02
index fast full scans (rowid ranges)00.000.00
index fetch by key9,610,9591,333.58128.15
index scans kdiixs161,687,8258,559.58822.56
leaf node 90-10 splits7390.100.01
leaf node splits4,9090.680.07
lob reads2,4410.340.03
lob writes2,7480.380.04
lob writes unaligned2,7480.380.04
logical read bytes from cache20,575,564,005,3762,854,989,518.40274,359,144.01
logons cumulative3,0300.420.04
max cf enq hold time600.010.00
messages received1,815,767251.9524.21
messages sent1,815,767251.9524.21
min active SCN optimization applied on CR40,6475.640.54
no buffer to keep pinned count6,8000.940.09
no work - consistent read gets2,497,682,064346,569.1733,304.65
non-idle wait count1,301,701180.6217.36
non-idle wait time415,94557.715.55
opened cursors cumulative1,165,617161.7415.54
parse count (describe)120.000.00
parse count (failures)00.000.00
parse count (hard)1,4870.210.02
parse count (total)169,68623.552.26
parse time cpu4,9080.680.07
parse time elapsed5,1410.710.07
physical read IO requests303,18242.074.04
physical read bytes144,339,853,31220,028,066.701,924,659.69
physical read total IO requests327,85745.494.37
physical read total bytes146,041,845,24820,264,228.841,947,354.43
physical read total multi block requests145,99220.261.95
physical reads17,619,6112,444.83234.94
physical reads cache203,79128.282.72
physical reads cache prefetch49,2656.840.66
physical reads direct17,415,8202,416.56232.23
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests188,93726.222.52
physical write bytes2,691,743,744373,496.4535,892.31
physical write total IO requests340,12547.194.54
physical write total bytes7,306,191,3601,013,780.2297,422.38
physical write total multi block requests11,3211.570.15
physical writes328,58245.594.38
physical writes direct17,9452.490.24
physical writes direct (lob)120.000.00
physical writes direct temporary tablespace10.000.00
physical writes from cache310,63743.104.14
physical writes non checkpoint127,60817.711.70
pinned buffers inspected100.000.00
pinned cursors current60.000.00
prefetch clients - default1150.020.00
prefetch warmup blocks aged out before use00.000.00
prefetch warmup blocks flushed out before use00.000.00
prefetched blocks aged out before use31,0424.310.41
process last non-idle time7,3331.020.10
queries parallelized00.000.00
recovery blocks read00.000.00
recursive aborts on index block reclamation10.000.00
recursive calls2,076,323288.1027.69
recursive cpu usage1,110,384154.0714.81
redo KB read2,632,493365.2835.10
redo KB read (memory)1,349,513187.2517.99
redo KB read (memory) for transport1,349,513187.2517.99
redo KB read for transport1,349,559187.2618.00
redo blocks checksummed by FG (exclusive)814,585113.0310.86
redo blocks read for recovery00.000.00
redo blocks written2,722,383377.7536.30
redo buffer allocation retries70.000.00
redo entries3,305,096458.6044.07
redo k-bytes read for recovery00.000.00
redo log space requests90.000.00
redo log space wait time510.010.00
redo ordering marks15,5412.160.21
redo size1,334,584,516185,182.0317,795.65
redo size for direct writes147,593,20420,479.491,968.04
redo subscn max counts8,6451.200.12
redo synch long waits5190.070.01
redo synch poll writes00.000.00
redo synch polls00.000.00
redo synch time207,46228.792.77
redo synch time (usec)2,076,364,753288,108.7327,686.71
redo synch writes48,5876.740.65
redo wastage14,130,5401,960.70188.42
redo write time19,8762.760.27
redo writes56,7437.870.76
rollback changes - undo records applied1,0710.150.01
rollbacks only - consistent read gets15,0812.090.20
root node splits00.000.00
rows fetched via callback2,418,314335.5632.25
session connect time00.000.00
session cursor cache hits813,584112.8910.85
session logical reads2,529,097,153350,928.2133,723.54
shared hash latch upgrades - no wait1,963,248272.4126.18
shared hash latch upgrades - wait2550.040.00
sorts (disk)00.000.00
sorts (memory)329,09445.664.39
sorts (rows)84,020,13611,658.321,120.34
sql area evicted7840.110.01
sql area purged130.000.00
summed dirty queue length4,2720.590.06
switch current to new buffer103,16614.311.38
table fetch by rowid4,561,435,672632,928.0260,823.20
table fetch continued row88,847,37012,328.131,184.71
table scan blocks gotten2,028,483,873281,464.9527,048.25
table scan rows gotten35,335,383,1674,903,007.69471,169.85
table scans (cache partitions)00.000.00
table scans (direct read)1350.020.00
table scans (long tables)10.000.00
table scans (rowid ranges)00.000.00
table scans (short tables)187,38726.002.50
temp space allocated (bytes)15,728,6402,182.45209.73
total cf enq hold time9,6901.340.13
total number of cf enq holders9310.130.01
total number of slots20.000.00
total number of times SMON posted1170.020.00
transaction rollbacks5670.080.01
transaction tables consistent read rollbacks70.000.00
transaction tables consistent reads - undo records applied3930.050.01
undo change vector size587,997,29281,588.347,840.49
user I/O wait time169,40723.512.26
user calls821,463113.9810.95
user commits74,66210.361.00
user rollbacks3330.050.00
workarea executions - onepass00.000.00
workarea executions - optimal243,18433.743.24
write clones created in background00.000.00
write clones created in foreground170.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
logons current8776
session uga memory max1,388,075,264,7441,393,816,312,864
session pga memory1,965,208,674,8481,970,860,891,680
session pga memory max5,794,761,340,7205,807,763,075,216
session cursor cache count54,095,51854,305,920
session uga memory3,923,648,664,404,5843,934,072,692,654,208
opened cursors current11390
workarea memory allocated9,08312,655

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)31.50

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 Reads133G20.3718.89400M0.010M0 
Others1.6G3.42.2253401.7G4.52.24573733.7K1.19
LGWR1M0.01.0001382.6G16.49.36881456.8K3.08
DBWR0M0.000M2.4G26.08.3367610 
Buffer Cache Reads1.6G21.72.2210380M0.000M154.6K2.57
Direct Writes0M0.000M110M0.10.0152630 
TOTAL:136.1G45.5219.34056.8G47.19.966576245.2K2.50

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 File134.5G42.1219.11532.5G26.22.3566032.6018.81
Log File1.2G0.18.1740002.6G16.48.3686751.369.03
Archive Log0M0.000M1.2G0.17.173861  
Control File372M3.21.051617482M4.28.0668800.6020.50
Other0M0.020M8M0.05.0011102.67 
Temp File0M0.000M0M0.000M0.00 
TOTAL:136.1G45.5219.34096.8G47.19.9671312.3518.72

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 133G20.3718.89470M0.010M0 
Direct Reads (Data File) 133G20.3718.89470M0.010M0 
Others 1.6G3.40.2254791.7G4.47.24462723.3K0.64
Others (Archive Log) 0M0.000M1.2G0.17.1738610 
Others (Log File) 1.2G0.18.1738610M0.000M390.31
Others (Control File) 371M3.20.051478480M4.26.06660323.1K0.60
Others (Data File) 1M0.02.00013830M0.04.0041621476.47
LGWR 1M0.01.0001382.6G16.49.368814753.75
LGWR (Log File) 0M0.000M2.6G16.48.368675243.88
LGWR (Control File) 1M0.01.0001381M0.01.000138513.69
DBWR 0M0.000M2.4G26.08.3367610 
DBWR (Data File) 0M0.000M2.4G26.08.3367610 
Buffer Cache Reads 1.6G21.73.2210380M0.000M154K2.54
Buffer Cache Reads (Data File) 1.6G21.73.2210380M0.000M154K2.54
Direct Writes 0M0.000M110M0.10.0152630 
Direct Writes (Data File) 0M0.000M110M0.10.0152630 
TOTAL: 136.1G45.5119.34136.8G47.14.965466177.4K2.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 290,520401.4260.59172,597243360.03
WZOL_INDEX 11,64921.761.007,322180.00
UNDOTBS1 900.001.006,2501470.00
SYSAUX 65604.281.092,238000.00
SYSTEM 28107.081.0052602490.08
USERS 300.001.003000.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 65604.281.092,238000.00
SYSTEM+DATA/wzol/datafile/system01.dbf 22807.321.0043202490.08
SYSTEM+DATA/wzol/datafile/system02.dbf 5306.041.0094000.00
TEMP+DATA/wzol/datafile/temp01.dbf 100.001.00100 
UNDOTBS1+DATA/wzol/datafile/undotbs01.dbf 300.001.002,3150320.00
UNDOTBS1+DATA/wzol/datafile/undotbs02.dbf 300.001.001,873040.00
UNDOTBS1+DATA/wzol/datafile/undotbs03.dbf 300.001.002,0620110.00
USERS+DATA/wzol/datafile/users01.dbf 300.001.003000.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_001.dbf 18,14531.4346.477,598180.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_009.dbf 19,39031.1643.579,971100.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_010.dbf 16,45020.8951.114,724110.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_011.dbf 14,62921.1369.005,284161.67
WZOL_DATA+DATA/wzol/datafile/wzol_data_012.dbf 20,55830.6749.629,981170.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_013.dbf 12,39621.6967.519,425100.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201210291128.dbf 13,66121.8361.3411,582200.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201212280950.dbf 12,22721.3568.436,597100.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201212281000.dbf 11,99721.3069.726,982100.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_84_201303211009.dbf 11,78521.4270.945,099120.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_wms_101.dbf 14,19621.8860.2112,703220.00
WZOL_DATA+DATA/wzol/datafile/wzol_data_wms_120.dbf 14,42921.7559.1715,489250.00
WZOL_DATA+DATA/wzol/datafile/wzoldata001.dbf 12,01721.3259.555,497100.00
WZOL_DATA+DATA/wzol/datafile/wzoldata002.dbf 11,75121.3859.014,835120.00
WZOL_DATA+DATA/wzol/datafile/wzoldata003.dbf 10,59111.2869.635,447130.00
WZOL_DATA+DATA/wzol/datafile/wzoldata004.dbf 10,41111.4772.415,299130.00
WZOL_DATA+DATA/wzol/datafile/wzoldata005.dbf 11,78321.3970.975,802100.00
WZOL_DATA+DATA/wzol/datafile/wzoldata006.dbf 12,05521.3570.696,110100.00
WZOL_DATA+DATA/wzol/datafile/wzoldata007.dbf 14,47522.2059.0412,20221790.00
WZOL_DATA+DATA/wzol/datafile/wzoldata008.dbf 14,16921.8960.3412,12321170.00
WZOL_DATA+DATA/wzol/datafile/wzoldata100.dbf 13,40521.6063.689,847110.00
WZOL_INDEX+DATA/wzol/datafile/wzol_index_84_201210291133.dbf 1,84801.531.00562000.00
WZOL_INDEX+DATA/wzol/datafile/wzol_index_84_201212281000.dbf 1,74901.691.00817000.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex001.dbf 2,01402.131.003,076000.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex002.dbf 1,94101.521.00563000.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex003.dbf 1,85701.651.00722000.00
WZOL_INDEX+DATA/wzol/datafile/wzolindex004.dbf 2,24001.981.001,582080.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D1,450,189100-1,786,178,497203,778310,63700640

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000300,4970

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
B02711332927495096112488320509611   
E02611446750424560352488320456035   

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.10142590.9165,952,8231256577349.00
D2,3040.2028448.195,378,653120716409.00
D3,4560.294269.551,065,83913923371.00
D4,6080.395683.49389,48711289821.00
D5,7600.497102.05229,1321665440.00
D6,9120.598521.56173,8441450161.00
D8,0640.689941.31145,8481341150.00
D9,2160.781,1361.17130,6161281844.00
D10,3680.881,2781.08120,4561242283.00
D11,5200.981,4201.01112,8601212705.00
D11,7761.001,4521.00111,6121207845.00
D12,6721.081,5620.96107,2361190807.00
D13,8241.171,7040.92102,3961171962.00
D14,9761.271,8460.8898,1911155585.00
D16,1281.371,9880.8594,4411140986.00
D17,2801.472,1300.8291,0551127801.00
D18,4321.572,2720.7887,5061113982.00
D19,5841.662,4140.7684,2651101364.00
D20,7361.762,5560.7280,215185591.00
D21,8881.862,6980.6977,050173269.00
D23,0401.962,8400.6471,253150696.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00445,6660

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
2K4K207,060207,06000
64K128K67367300
128K256K48148100
256K512K22822800
512K1024K23,87723,87700
1M2M2,8682,86800
2M4M18318300
4M8M575700
8M16M28428400
16M32M34034000
32M64M7,1017,10100
64M128M4400

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.1341,076,362.727,003.11100.00011,294,664,064
2,0960.2541,076,362.726,269.98100.00011,294,462,511
4,1920.5041,076,362.724,424.65100.00011,293,955,193
6,2880.7541,076,362.724,424.65100.00011,293,955,193
8,3841.0041,076,362.723,577.77100.00011,293,722,368
10,0611.2041,076,362.722,120.56100.00011,293,321,751
11,7381.4041,076,362.722,120.56100.00011,293,321,751
13,4141.6041,076,362.722,120.56100.00011,293,321,751
15,0911.8041,076,362.722,120.56100.00011,293,321,751
16,7682.0041,076,362.722,120.56100.00011,293,321,751
25,1523.0041,076,362.722,120.56100.00011,293,321,751
33,5364.0041,076,362.722,120.56100.00011,293,321,751
50,3046.0041,076,362.722,120.56100.00011,293,321,751
67,0728.0041,076,362.722,120.56100.00011,293,321,751

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.901947,1515,987,0681.0021,4841.04370,875
2,8800.922588,9055,987,2981.0021,2541.03370,893
2,9440.9432211,9715,987,5601.0020,9921.02370,917
3,0080.9638614,9775,987,7511.0020,8011.01370,932
3,0720.9845017,2925,987,8901.0020,6621.01370,943
3,1361.0051418,8265,987,9921.0020,5601.00370,951
3,2001.0257820,1495,988,0521.0020,5001.00370,957
3,2641.0464121,4745,988,1131.0020,4390.99370,963
3,3281.0670522,8635,988,1881.0020,3640.99370,969
3,3921.0876924,2735,988,2441.0020,3080.99370,973
3,4561.1083325,5915,988,3051.0020,2470.98370,978
3,5201.1289727,8575,988,3521.0020,2000.98370,983
3,5841.1496129,1315,988,4171.0020,1350.98370,989
3,6481.161,02430,4655,988,4861.0020,0660.98370,994
3,7121.181,08731,8195,988,5311.0020,0210.97370,999
3,7761.201,15133,2545,988,5741.0019,9780.97371,003
4,0961.311,47141,3015,988,7191.0019,8330.96371,015
4,4161.411,79148,8815,988,8291.0019,7230.96371,026
4,7361.512,11157,0255,988,9221.0019,6300.95371,034
5,0561.612,43164,6105,988,9721.0019,5800.95371,039
5,3761.712,75172,4975,989,0071.0019,5450.95371,043
5,6961.823,07180,3845,989,0351.0019,5170.95371,046
6,0161.923,39188,2715,989,0571.0019,4950.95371,049
6,3362.023,71196,1585,989,0781.0019,4740.95371,052

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.3825,204,4135,598,097,255
7,8400.508,349,4401,109,324,449
9,8000.635,080,206238,479,309
11,7600.754,754,663151,802,176
13,7200.884,655,666125,372,681
15,6801.004,604,555111,611,040
17,6401.134,584,755106,577,382
19,6001.254,553,44498,295,843
21,5601.384,526,73891,074,609
23,5201.504,498,65083,485,058
25,4801.634,463,65674,154,375
27,4401.754,462,73574,154,375
29,4001.884,462,27474,154,375
31,3602.004,462,27474,154,375

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 block29400
segment header29900
undo header2600
undo block2100

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) 1,2901,290012955430.00
TX-Transaction (row lock contention) 1811810231,500.00
RO-Multiple Object Reuse (fast object reuse) 320320032119.38
CR-Reuse Block Range (block range reuse ckpt) 2,8882,888032015.31
CF-Controlfile Transaction 9,0219,02101060.00
TX-Transaction (index contention) 2,8332,8330608.33
JS-Job Scheduler (queue lock) 30,68730,6870100.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
279.0693,0011,708915.4/42.50/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
30-11月 11:595,1893,7961,7086420/00/0/0/0/0/0
30-11月 11:494,4795,0641,3457360/00/0/0/0/0/0
30-11月 11:395,4935,8427447260/00/0/0/0/0/0
30-11月 11:297,6076,810818150/00/0/0/0/0/0
30-11月 11:199,6238,1257449260/00/0/0/0/0/0
30-11月 11:097,9417,489848150/00/0/0/0/0/0
30-11月 10:596,72025,0777458260/00/0/0/0/0/0
30-11月 10:495,6675,7061437160/00/0/0/0/0/0
30-11月 10:396,3915,8937477260/00/0/0/0/0/0
30-11月 10:295,7645,9711317160/00/0/0/0/0/0
30-11月 10:198,0035,8757478260/00/0/0/0/0/0
30-11月 10:096,1817,3531457160/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,4400.00 00 
ASM Keyed state latch1,2090.00 00 
ASM allocation2,8230.00 00 
ASM db client latch15,1140.00 00 
ASM map headers2430.00 00 
ASM map load waiting list660.00 00 
ASM map operation freelist1,3880.00 00 
ASM map operation hash table1,441,5520.000.0000 
ASM network SGA latch90.00 00 
ASM network background latch4,1610.00 00 
ASM network state latch2,1130.00 00 
ASM scan context latch120.00 00 
AWR Alerted Metric Element list60,5990.00 00 
Change Notification Hash table latch2,4390.00 00 
Consistent RBA56,7560.000.0000 
DML lock allocation631,9320.000.0000 
Event Group Locks3,6330.030.0000 
FAL Queue4140.00 00 
FIB s.o chain latch660.00 00 
FOB s.o list latch7,2490.00 00 
File State Object Pool Parent Latch40.00 00 
I/O Staticstics latch40.00 00 
IPC stats buffer allocation latch40.00 00 
In memory undo latch67,5040.00 00 
JS Sh mem access200.00 00 
JS broadcast autostart latch10.00 00 
JS mem alloc latch280.00 00 
JS queue access latch320.00 00 
JS queue state obj latch61,3740.00 00 
JS slv state obj latch1,0360.480.0000 
KFC FX Hash Latch40.00 00 
KFC Hash Latch40.00 00 
KFCL LE Freelist40.00 00 
KFK SGA Libload latch1,4340.00 00 
KFMD SGA90.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,4010.00 00 
KTF sga latch410.00 02,3900.00
KWQMN job cache list latch40.00 00 
KWQP Prop Status80.00 00 
KWQS pqsubs latch120.00 00 
KWQS pqueue ctx latch1730.00 00 
LGWR NS Write113,7090.00 00 
Locator state objects pool parent latch40.00 00 
Lsod array latch8,5090.00 00 
MQL Tracking Latch0  01440.00
Memory Management Latch40.00 02,4010.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 process4,9280.00 00 
OS process allocation17,5470.00 00 
OS process: request allocation1,2090.00 00 
PL/SQL warning settings19,3820.010.0000 
PX hash array latch40.00 00 
QMT40.00 00 
Real-time plan statistics latch63,6940.00 00 
SGA IO buffer pool latch10.00 010.00
SGA blob parent40.00 00 
SGA bucket locks40.00 00 
SGA heap locks40.00 00 
SGA pool locks40.00 00 
SQL memory manager latch2440.00 07,1500.00
SQL memory manager workarea list latch683,5900.00 00 
Shared B-Tree7080.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,5240.00 00 
XDB NFS Security Latch40.00 00 
XDB unused session pool40.00 00 
XDB used session pool40.00 00 
active checkpoint queue latch1,760,5280.000.0000 
active service list26,1720.110.0009,9800.00
alert log latch150.00 00 
archive control6210.00 00 
archive process latch8850.111.0000 
begin backup scn array8810.00 00 
buffer pool40.00 00 
business card40.00 00 
cache buffer handles53,5260.00 00 
cache buffers chains5,017,058,5580.290.000723,1690.00
cache buffers lru chain839,5860.000.2001,084,4840.01
cache table scan latch3,9880.00 03,9880.00
call allocation45,2750.170.1800 
cas latch40.00 00 
change notification client cache latch40.00 00 
channel handle pool latch1,3590.00 00 
channel operations parent latch90,8720.00 00 
checkpoint queue latch224,808,0320.000.000309,0380.00
client/application info15,7130.010.0000 
compile environment latch3,0300.030.0000 
corrupted undo seg latch3,7800.030.0000 
cp cmon/server latch40.00 00 
cp pool latch40.00 00 
cp server hash latch40.00 00 
cp sga latch1850.00 00 
cvmap freelist lock40.00 00 
database property service latch80.00 00 
deferred cleanup latch1850.00 00 
dml lock allocation2490.00 00 
done queue latch40.00 00 
dummy allocation6,0750.200.0000 
enqueue freelist latch40.00 0979,4910.00
enqueue hash chains1,819,5660.020.000210.00
enqueues60.00 00 
fifth spare latch40.00 00 
file cache latch2,3230.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 SGA1000.00 00 
global tx hash mapping12,3280.00 00 
granule operation40.00 00 
hash table column usage latch1,0810.00 0369,7870.00
hash table modification latch4840.00 00 
heartbeat check40.00 00 
internal temp table object number allocation latch90.00 00 
intra txn parallel recovery40.00 00 
io pool granule metadata list40.00 00 
job workq parent latch2,4450.00 02,45818.43
job_queue_processes free list latch4,8880.270.0000 
job_queue_processes parameter latch4,0040.00 00 
k2q lock allocation40.00 00 
kcbtsemkid latch30.00 00 
kdlx hb parent latch40.00 00 
kgb parent40.00 00 
kgnfs mount latch40.00 00 
kokc descriptor allocation latch7600.00 00 
ksfv messages40.00 00 
ksim group membership cache40.00 00 
kss move lock1180.00 00 
ksuosstats global area7330.00 00 
ksv allocation latch4130.00 00 
ksv class latch9,0820.990.0000 
ksv instance latch320.00 00 
ksv msg queue latch730.00 0690.00
ksz_so allocation latch1,2090.00 00 
ktm global data5150.00 00 
kwqbsn:qsga2650.00 00 
lgwr LWN SCN58,2050.000.0000 
list of block allocation45,6300.170.0000 
loader state object freelist98,2050.030.0000 
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 parent3070.00 01460.00
managed standby latch2910.00 00 
mapped buffers lru chain40.00 00 
message pool operations parent latch1,8790.00 00 
messages3,784,6100.000.0000 
mostly latch-free SCN61,1932.340.0000 
msg queue latch40.00 00 
multiblock read objects10,0020.00 00 
name-service namespace bucket40.00 00 
ncodef allocation latch1850.00 00 
object queue header heap164,1060.00 0162,3650.00
object queue header operation78,714,0150.000.0000 
object stats modification11,0200.010.0000 
parallel query alloc buffer1,9160.00 00 
parallel query stats40.00 00 
parameter list1,7770.00 00 
parameter table management27,0912.760.0000 
peshm40.00 00 
pesom_free_list40.00 00 
pesom_hash_node40.00 00 
post/wait queue97,7530.340.00072,8750.27
process allocation1,7080.00 05990.00
process group creation1,2090.00 00 
process queue40.00 00 
process queue reference40.00 00 
qmn task queue latch1,0460.00 00 
query server freelists40.00 00 
queued dump request240.00 00 
queuing load statistics40.00 00 
readredo stats and histogram56,6970.00 00 
recovery domain hash list40.00 00 
redo allocation238,3990.100.0203,304,0850.07
redo copy40.00 03,305,0030.03
redo writing1,942,4510.000.0000 
resmgr group change latch2,6600.040.0000 
resmgr:active threads6,0750.00 00 
resmgr:actses change group2,5900.00 00 
resmgr:actses change state40.00 00 
resmgr:free threads list6,0710.400.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 objects3,335,0180.150.00090.00
rules engine rule set statistics4000.00 00 
second Audit Vault latch40.00 00 
second spare latch40.00 00 
segmented array pool660.00 00 
sequence cache278,7650.080.0000 
session allocation27,6470.00 021,6770.00
session idle bit1,661,5870.000.0000 
session queue latch40.00 00 
session state list latch6,0010.230.0000 
session switching7990.00 00 
session timer2,4640.00 00 
shared pool3,472,5520.030.0101130.00
shared pool sim alloc230.00 00 
shared pool simulator4,3220.00 00 
sim partition latch40.00 00 
simulator hash latch154,633,6140.000.0000 
simulator lru latch121,0430.110.000154,494,8420.66
sort extent pool453,6950.020.0000 
space background state object latch380.00 00 
space background task latch15,3785.640.1104,8800.02
state object free list80.00 00 
statistics aggregation3,3600.00 00 
tablespace key chain7420.00 00 
temp lob duration state obj allocation100.00 00 
temporary table state object allocation3,7710.030.0000 
test excl. parent l040.00 00 
test excl. parent2 l040.00 00 
third spare latch40.00 00 
threshold alerts latch2860.00 00 
transaction allocation96,1300.000.2500 
transaction branch allocation13,6800.00 00 
undo global data578,5500.010.0000 
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 chains5,017,058,55814,504,2948414,507,653
row cache objects3,335,0185,14815,147
object queue header operation78,714,0151,31011,309
shared pool3,472,5521,142131,131
space background task latch15,37886798770
parameter table management27,0917471746
redo allocation238,3992335228
call allocation45,275781465
cache buffers lru chain839,5861028
transaction allocation96,130413
archive process latch885110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
PC and Classifier lists for WLMNo latch050
archive process latchkcrrsarc010
cache buffers chainskcbchg1: mod cr pin03623
cache buffers chainskcbgcur_20343
cache buffers chainskcbgtcr: fast path (cr pin)03416
cache buffers chainskcbgtcr: fast path061
cache buffers chainskcbrls: fast release0421
cache buffers chainskcbgtcr: kslbegin excl023
cache buffers chainskcbgtcr_2021
cache buffers chainskcbgcur_4012
cache buffers chainskcbget: pin buffer010
cache buffers chainskcbgtcr: kslbegin shared010
cache buffers chainskcbnew: new latch again010
cache buffers chainskcbrls_20121
cache buffers chainskcbzgb: scan from tail. nowait010
cache buffers lru chainkcbo_link_q010
cache buffers lru chainkcbzgws010
call allocationksuxds0137
call allocationksudlp: top call013
object queue header operationkcbo_switch_cq020
object queue header operationkcbo_link_q010
parameter table managementksp_param_table_free010
redo allocationkcrfw_redo_gen: redo allocation 1050
row cache objectskqreqd011
shared poolkghalo0136
space background task latchktsj_grab_task09398
transaction allocationktcxbr010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglhdgn2 1069320
Library Cachekgllkc1 576450
Library Cachekglhdgh1 641700
Library Cachekgllkdl1 851210
Library Cachekglpnal1 901130
Library Cachekglpndl1 951080
Library Cachekglpin1 41030
Library Cachekglhdgn1 62880
Cursor Pinkksfbc [KKSCHLFSP2]100
Cursor Pinkkslce [KKSCHLPIN2]20
Library Cachekglget1 110
Cursor PinkksLockDelete [KKSCHLPIN6]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 TABLE1,802,403,23271.27
WZOLWMS30WZOL_DATASORTING_BILLDETAIL TABLE176,027,3446.96
WZOLWMS30WZOL_DATAIF_SALESORDER_GROUP TABLE86,134,3843.41
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE80,545,1683.18
WZOLWMS30WZOL_DATAIF_PICKING_BILLSOURCE TABLE53,756,9282.13

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE12,978,67273.66
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE3,332,64918.91
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE389,0792.21
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE7,1030.04
WZOLWMS30WZOL_DATAPICKING_BILLDETAIL TABLE2,9180.02

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE111,06636.63
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE28,9089.53
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE7,1022.34
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE3,2141.06
WZOLWMS30WZOL_DATAINDX_WAYBILLDETAIL_PKHANGDING5 INDEX2,8270.93

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE111,06636.63
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE28,9089.53
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE7,1022.34
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE3,2141.06
WZOLWMS30WZOL_DATAINDX_WAYBILLDETAIL_PKHANGDING5 INDEX2,8270.93

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 TABLE12,978,67274.52
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE3,330,36019.12
WZOLWMS30WZOL_DATAWAYBILL_HANDINGBATCH_DETAIL TABLE388,9952.23

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE7,2572.21
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_INDX INDEX5,5571.69
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE4,9301.50
** MISSING **WZOL_DATA** MISSING: 255816/255816** MISSING **UNDEFINED2,5620.78
** MISSING **WZOL_DATA** MISSING: 255812/255812** MISSING **UNDEFINED2,0560.63

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE5,0822.69
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_INDX INDEX4,4632.36
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE2,9501.56
WZOLWMS30WZOL_DATAWAYBILL_PACKAGE TABLE1,4050.74
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_T INDEX1,1630.62

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
** MISSING **WZOL_DATA** MISSING: 255816/255816** MISSING **UNDEFINED2,56214.28
** MISSING **WZOL_DATA** MISSING: 255812/255812** MISSING **UNDEFINED2,06111.49
** MISSING **WZOL_DATA** MISSING: 255820/255820** MISSING **UNDEFINED2,05411.45
** MISSING **WZOL_DATA** MISSING: 255810/255810** MISSING **UNDEFINED1,83910.25
** MISSING **WZOL_DATA** MISSING: 255808/255808** MISSING **UNDEFINED1,80310.05

Back to Segment Statistics
Back to Top

Segments by Table Scans

OwnerTablespace NameObject NameSubobject NameObj. TypeTable Scans%Total
WZOLWMS30WZOL_DATAIK_BASE_GOODSINFO_SKUID INDEX433.24
WZOLWMS30WZOL_DATAPK_PALLETID INDEX322.41
WZOLWMS30TEMPIK_LEADINDETAIL_TEMP_2 INDEX100.75

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE85,7607.46
WZOLWMS30WZOL_DATAWAYBILL_PACKAGE TABLE76,6886.67
WZOLWMS30WZOL_DATARECEIVESUMDETAIL TABLE42,9123.73
WZOLWMS30WZOL_DATASALESORDER_BILLDETAIL TABLE42,8803.73
WZOLWMS30WZOL_DATAIF_SALESORDER_BILLSTATE TABLE28,5442.48

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_T INDEX17110.32
WZOLWMS30WZOL_INDEXIF_SALESORDER_BILLSTATE_INDX INDEX1398.39
WZOLWMS30WZOL_DATAIK_IF_SALESORDER_BILLSTATE INDEX975.85
WZOLWMS30WZOL_DATASYS_C00958553 INDEX814.89
WZOLWMS30WZOL_DATAINVENTORY_INOUTDETAIL_05 INDEX754.53

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
WZOLWMS30WZOL_DATAINDX_WAYBILLDETAIL_PKHANGDING3 INDEX220.00
WZOLWMS30WZOL_DATAINVENTORY_INOUTDETAIL_010 INDEX220.00
WZOLWMS30WZOL_DATAINDX_WAYBILL_PACKAGE_HANGDING5 INDEX110.00
WZOLWMS30WZOL_DATAINVENTORY_INOUTDETAIL_04 INDEX110.00
WZOLWMS30WZOL_DATAINVENTORY_INOUTDETAIL_05 INDEX110.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
SYSSYSTEMJOB$ TABLE18732.86
WZOLWMS30WZOL_DATASORTING_BILLDETAIL TABLE17831.28
WZOLWMS30WZOL_DATASALESORDER_BILL TABLE11920.91
SYSSYSTEMI_JOB_NEXT INDEX559.67
WZOLWMS30WZOL_DATAIF_WAYBILLDETAIL_PACKAGE_TOERP TABLE81.41

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control1420.000 81
dc_constraints1,52433.330 1,5241
dc_files680.000 034
dc_global_oids9490.000 0126
dc_histogram_data159,9790.230 021,685
dc_histogram_defs70,9472.240 018,324
dc_object_grants220.000 036
dc_objects167,6480.120 1145,992
dc_profiles2,5320.000 01
dc_rollback_segments15,8460.000 0169
dc_segments27,2720.220 2853,022
dc_sequences4,3960.270 4,39688
dc_table_scns32100.000 00
dc_tablespaces463,5480.000 08
dc_users292,1420.000 0194
global database name7,3820.000 01
outstanding_alerts600.000 05
sch_lj_objs520.000 06
sch_lj_oids714.290 014


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS2000.000 00
APP CONTEXT720.00720.0000
BODY6,9370.0030,3030.0000
CLUSTER80.0080.0000
DBLINK2040.000 00
EDITION2,5670.005,0950.0000
INDEX873.45935.3800
JAVA DATA425.00425.0000
JAVA RESOURCE425.00425.0000
JAVA SOURCE425.00425.0000
OBJECT ID33100.000 00
QUEUE1,5720.001,8820.0000
SCHEMA2,7790.000 00
SQL AREA288,14835.501,192,7490.251,19577
SQL AREA BUILD1,74156.230 00
SQL AREA STATS1,18665.681,18665.6800
SUBSCRIPTION380.00380.0000
TABLE/PROCEDURE13,2720.60257,2070.151632
TRANSFORMATION7200.007200.0000
TRIGGER3,1020.0323,6360.0230


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
BOther580.52 6.3812.3354549191
Freeable129.880.002.204.7227 5959
PL/SQL9.598.160.110.28128989
SQL5.461.840.090.1612405948
EOther555.38 6.9413.0654548080
Freeable119.310.002.435.1627 4949
SQL9.267.260.190.7552004839
PL/SQL6.154.890.080.24127878

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
sharedKGLH0250.11251.720.64
sharedKGLHD123.98268.70116.72
sharedSQLA339.94372.709.63
shareddb_block_hash_buckets89.0089.000.00
sharedevent statistics per sess37.9437.940.00
sharedfree memory1,605.651,267.69-21.05
sharedkkslBind_value 46.71 
sharedkkslLoadParentOnLock:lite50.04159.59218.91
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.080.000.00
QMON Slaves1106 23:40:150.020.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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

Queue NameEnq MsgsDeq Msgs%Exp Msgs%Delay MsgsEnq Time(s)Deq Time(s)%Transf Time%Eval Time
SYS.ALERT_QUE(12343) 00  0.000.00  
SYS.AQ$_ALERT_QT_E(12342) 00  0.000.00  
SYSMAN.MGMT_TASK_Q(66573) 1241240.000.000.030.120.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.00  
SYS.AQ$_ALERT_QT_E(12342) 0.000.00  
SYSMAN.MGMT_TASK_Q(66573) 0.020.020.000.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Subscriber/QueueEnqueue MsgsDequeue MsgsExpire MsgsEnqueue Msgs/secDequeue Msgs/secExpire Msgs/sec
DBWMS_MASTER__3938_WZOL(22)/SYS.ALERT_QUE 0000.000.000.00
HAE_SUB(1)/SYS.ALERT_QUE 000   
WMS_90_23_3938_WZOL(23)/SYS.ALERT_QUE 0000.000.000.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Total Server Time (s)%Busy%IdleIncoming Net %Outgoing Net %
7,2060.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,2060.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