WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numStartup TimeReleaseRAC
QUERYDB1813880573querydb3307-Feb-14 11:0211.2.0.3.0YES

Host NamePlatformCPUsCoresSocketsMemory (GB)
expquery03HP-UX IA (64-bit) 16 16 4 127.84

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:480327-Feb-14 08:00:18791 3.5
End Snap:480427-Feb-14 09:00:33822 3.8
Elapsed:  60.24 (mins)  
DB Time:  30.30 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 40,960M 40,960MStd Block Size: 8K
Shared Pool Size: 4,096M 4,096MLog Buffer: 44,656K

Load Profile

Per SecondPer TransactionPer ExecPer Call
DB Time(s): 0.5 0.0 0.00 0.00
DB CPU(s): 0.2 0.0 0.00 0.00
Redo size: 197,694.9 1,802.9  
Logical reads: 6,807.9 62.1  
Block changes: 871.2 7.9  
Physical reads: 38.8 0.4  
Physical writes: 118.3 1.1  
User calls: 565.0 5.2  
Parses: 96.7 0.9  
Hard parses: 0.0 0.0  
W/A MB processed: 0.0 0.0  
Logons: 0.7 0.0  
Executes: 173.9 1.6  
Rollbacks: 0.4 0.0  
Transactions: 109.7   

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.43In-memory Sort %: 100.00
Library Hit %: 99.95Soft Parse %: 99.98
Execute to Parse %: 44.41Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 94.15% Non-Parse CPU: 96.45

Shared Pool Statistics

BeginEnd
Memory Usage %: 94.69 94.71
% SQL with executions>1: 93.64 91.67
% Memory for SQL w/exec>1: 94.07 92.66

Top 5 Timed Foreground Events

EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
DB CPU 779 42.84 
db file sequential read140,202753541.42User I/O
log file sync394,096185010.20Commit
gc cr block 2-way98,6544502.46Cluster
gc cr block 3-way49,9603912.17Cluster

Host CPU (CPUs: 16 Cores: 16 Sockets: 4)

Load Average BeginLoad Average End%User%System%WIO%Idle
0.03 0.04 2.2 0.9 2.3 96.8
Instance CPU

%Total CPU%Busy CPU%DB time waiting for CPU (Resource Manager)
2.2 68.9 0.0
Memory Statistics

BeginEnd
Host Mem (MB): 130,907.9 130,907.9
SGA use (MB): 47,149.7 47,149.7
PGA use (MB): 2,239.9 2,309.0
% Host Mem used for SGA+PGA: 37.73 37.78

RAC Statistics

BeginEnd
Number of Instances: 3 3

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 54.59 0.50
Global Cache blocks served: 19.67 0.18
GCS/GES messages received: 756.72 6.90
GCS/GES messages sent: 737.07 6.72
DBWR Fusion writes: 3.13 0.03
Estd Interconnect traffic (KB) 885.83 

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 98.63
Buffer access - remote cache %: 0.80
Buffer access - disk %: 0.57

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.0
Avg global cache cr block receive time (ms): 0.6
Avg global cache current block receive time (ms): 0.5
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 0.3
Avg global cache cr block flush time (ms): 0.8
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.1
Avg global cache current block flush time (ms): 0.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0
Avg message sent queue time on ksxp (ms): 0.3
Avg message received queue time (ms): 0.1
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 80.86
% of indirect sent messages: 17.65
% of flow controlled messages: 1.49


Cluster Interconnect

 Begin End
InterfaceIP AddressPubSourceIPPubSrc
lan901:801169.254.162.52N    

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time1,293.9971.17
DB CPU778.8442.84
parse time elapsed32.561.79
connection management call elapsed time3.960.22
hard parse elapsed time1.150.06
hard parse (sharing criteria) elapsed time0.780.04
hard parse (bind mismatch) elapsed time0.100.01
sequence load elapsed time0.010.00
repeated bind elapsed time0.000.00
DB time1,818.07 
background elapsed time778.46 
background cpu time488.32 

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticValueEnd Value
AVG_BUSY_TIME11,330 
AVG_IDLE_TIME349,614 
AVG_IOWAIT_TIME7,981 
AVG_SYS_TIME3,242 
AVG_USER_TIME7,930 
BUSY_TIME183,914 
IDLE_TIME5,596,478 
IOWAIT_TIME130,367 
SYS_TIME54,506 
USER_TIME129,408 
LOAD00
OS_CPU_WAIT_TIME48,941,857,800 
RSRC_MGR_CPU_WAIT_TIME0 
VM_IN_BYTES73,318,400 
PHYSICAL_MEMORY_BYTES137,266,900,992 
NUM_CPUS16 
NUM_CPU_CORES16 
NUM_CPU_SOCKETS4 
TCP_RECEIVE_SIZE_DEFAULT32,768 
TCP_RECEIVE_SIZE_MAX1,073,725,440 
TCP_RECEIVE_SIZE_MIN24,576 
TCP_SEND_SIZE_DEFAULT32,768 
TCP_SEND_SIZE_MAX2,147,483,647 

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap TimeLoad%busy%user%sys%idle%iowait
27-Feb 08:00:180.03     
27-Feb 09:00:330.043.182.240.9496.822.26

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  779 42.84
User I/O144,0970754541.46
Commit394,0960185010.20
Cluster300,319014007.71
Network1,423,2480100.07
Concurrency9281110.05
Other3,31511100.03
Application7260000.00
Configuration60010.00
Administrative0 0 0.00
System I/O0 0 0.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
db file sequential read140,202075350.3541.42
log file sync394,096018500.9910.20
gc cr block 2-way98,65404500.252.46
gc cr block 3-way49,96003910.132.17
gc cr grant 2-way90,70202700.231.50
gc current block 2-way31,64901300.080.69
gc current block 3-way15,5010910.040.52
gc current grant busy8,2940300.020.14
SQL*Net message to client1,422,9600103.590.07
gc buffer busy acquire2780140.000.06
gc current multi block request1,3180110.000.05
row cache lock4690120.000.05
read by other session1410160.000.04
gc current grant 2-way3,4180100.010.04
gc cr block busy4470110.000.03
enq: FB - contention1,2100000.000.02
gc cr block congested570070.000.02
gc cr grant congested2000200.000.02
Disk file operations I/O3,7540000.010.01
latch: object queue header operation1,0030000.000.00
SQL*Net break/reset to client7120000.000.00
gc current block congested170030.000.00
library cache lock1847000.000.00
library cache pin1760000.000.00
IPC send completion sync1440000.000.00
SQL*Net more data from client2880000.000.00
DFS lock handle1811010.000.00
enq: PS - contention360000.000.00
latch: cache buffers chains770000.000.00
PX Deq: Slave Session Stats420000.000.00
enq: TT - contention150000.000.00
latch: ges resource hash list3240000.000.00
enq: TM - contention140000.000.00
enq: HW - contention60010.000.00
gc current grant congested10040.000.00
latch free610000.000.00
enq: TX - index contention80000.000.00
PX Deq: reap credit361100000.000.00
latch: gcs resource hash110000.000.00
latch: gc element210000.000.00
latch: enqueue hash chains530000.000.00
enq: JS - job run lock - synchronize2100010.000.00
gc current block busy30000.000.00
SQL*Net message from client1,422,92603,902,28127423.59 
jobq slave wait2401001225100.00 
PX Deq: Execution Msg16807420.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
Streams AQ: qmn coordinator waiting for slave to start31001757430.002.21
ges lms sync during dynamic remastering and reconfig7279172390.002.21
log file sequential read1,3440540.000.61
log file parallel write392,8820400.990.46
control file sequential read11,7140200.030.25
os thread startup2402790.000.24
reliable message2050290.000.24
ASM file metadata operation1,7840210.000.19
row cache lock4070140.000.19
db file sequential read8810110.000.11
enq: CO - master slave det1,200100110.000.10
CSS operation: data query2850120.000.07
enq: WF - contention1700200.000.04
row cache process14,8390000.040.04
DFS lock handle32891010.000.03
CGS wait for IPC msg30,616100000.080.03
row cache cleanup12,2620000.030.01
LGWR wait for redo copy2,3770000.010.01
gc current block 2-way3860000.000.01
ksxr poll remote instances8,552100000.020.01
db file async I/O submit211,2250000.530.01
db file single write4790000.000.01
gc cr block 2-way2840000.000.01
latch free1930000.000.01
CSS group membership query570010.000.01
enq: CF - contention12995010.000.01
gcs log flush sync2201000.000.01
gc current block 3-way1550000.000.01
latch: object queue header operation1,6150000.000.01
SQL*Net break/reset to client2020000.000.01
ADR block file read160030.000.01
gc cr block 3-way1060000.000.01
enq: TT - contention21598000.000.01
gc current block busy410010.000.01
control file parallel write1,8400000.000.00
library cache pin810000.000.00
Disk file operations I/O1,7440000.000.00
gc current grant 2-way1470000.000.00
latch: ges resource hash list8050000.000.00
ADR block file write50040.000.00
PX Deq: reap credit1,771100000.000.00
gc current grant busy530000.000.00
enq: TX - index contention100140.000.00
enq: PS - contention3735000.000.00
libcache interrupt action by LCK11,0880000.030.00
CSS initialization20060.000.00
enq: TD - KTF dump entries80010.000.00
library cache lock4040000.000.00
CSS operation: action60010.000.00
asynch descriptor resize2,608100000.010.00
gc cr block busy60010.000.00
SQL*Net message to client5,2840000.010.00
latch: redo allocation2170000.000.00
gc cr multi block request100010.000.00
latch: checkpoint queue latch740000.000.00
PX Deq: Slave Session Stats300000.000.00
enq: TQ - TM contention130000.000.00
gc cr grant 2-way250000.000.00
latch: gc element790000.000.00
gc buffer busy release90000.000.00
enq: US - contention60000.000.00
latch: cache buffers chains300000.000.00
latch: cache buffers lru chain200000.000.00
enq: TM - contention888000.000.00
IPC send completion sync240000.000.00
gc current multi block request30010.000.00
enq: FB - contention50000.000.00
log file single write80000.000.00
kfk: async disk IO70000.000.00
latch: messages360000.000.00
enq: TA - contention50000.000.00
rdbms ipc message835,033786,0451032.11 
class slave wait519011,741226220.00 
wait for unread message on broadcast channel7,1851007,22810060.02 
DIAG idle wait61,014667,1711180.15 
gcs remote message2,688,89987,11236.78 
Space Manager: slave idle wait1,287966,30048950.00 
Streams AQ: qmn slave idle wait14323,808266290.00 
PING1,867153,62419410.00 
GCR sleep7211003,61250090.00 
ges remote message52,875563,611680.13 
ASM background timer73403,61149200.00 
Streams AQ: qmn coordinator idle wait162753,610222820.00 
PX Idle Wait4203,607858800.00 
pmon timer1,1991003,60630080.00 
shared server idle wait1201003,602300180.00 
dispatcher timer601003,601600180.00 
Streams AQ: waiting for time management or cleanup tasks296703,600121620.00 
smon timer28143,4641237200.00 
SQL*Net message from client7,86701220.02 
KSV master wait2,37091100.01 
PX Deq: Join ACK300010.00 
PX Deq: Parse Reply300000.00 
PX Deq: Execute Reply300000.00 
Streams AQ: RAC qmn coordinator idle wait254100000.00 

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

  % of Waits
EventTotal Waits <1ms <2ms <4ms <8ms<16ms<32ms <=1s >1s
ADR block file read1625.06.337.531.3    
ADR block file write5  80.020.0    
ADR file lock6100.0       
ARCH wait for archivelog lock2100.0       
ASM file metadata operation178598.2.7.2.3 .1.4 
CGS wait for IPC msg30.6K100.0       
CSS group membership query5736.863.2      
CSS initialization250.0   50.0   
CSS operation: action650.016.733.3     
CSS operation: data query285 99.6.4     
CSS operation: query63100.0       
DFS lock handle34698.0.9.9   .3 
Data file init write1100.0       
Disk file operations I/O549999.9.1      
IPC send completion sync16898.81.2      
KJC: Wait for msg sends to complete9100.0       
LGWR wait for redo copy237899.7.3      
Log archive I/O2100.0       
PX Deq: Signal ACK EXT30100.0       
PX Deq: Signal ACK RSG30100.0       
PX Deq: Slave Session Stats72100.0       
PX Deq: reap credit2132100.0       
SQL*Net break/reset to client91499.8.2      
SQL*Net message to client1428.5K100.0.0      
SQL*Net more data from client28899.3  .7    
Streams AQ: qmn coordinator waiting for slave to start3       100.0
asynch descriptor resize2608100.0       
buffer busy waits3100.0       
control file parallel write1840100.0       
control file sequential read11.7K99.8.2.0.0.0   
db file async I/O submit211.4K100.0.0      
db file sequential read141.1K3.52.728.857.85.11.8.3 
db file single write479100.0       
enq: AF - task serialization2100.0       
enq: CF - contention12995.31.61.61.6    
enq: CO - master slave det120194.52.91.51.0  .1 
enq: CR - block range reuse ckpt3100.0       
enq: CT - state1100.0       
enq: DR - contention2100.0       
enq: FB - contention121397.71.5.4.2.2   
enq: FD - Flashback logical operations1100.0       
enq: HW - contention683.3 16.7     
enq: JS - job run lock - synchronize250.050.0      
enq: MV - datafile move1100.0       
enq: MW - contention2100.0       
enq: PS - contention7397.3 2.7     
enq: SW - contention1100.0       
enq: TA - contention5100.0       
enq: TD - KTF dump entries887.5  12.5    
enq: TM - contention22100.0       
enq: TQ - TM contention13100.0       
enq: TT - contention23098.7.4.9     
enq: TX - index contention988.9   11.1   
enq: US - contention6100.0       
enq: WF - contention1782.45.95.9   5.9 
enq: WL - contention1100.0       
gc buffer busy acquire27836.73.618.337.81.81.1.7 
gc buffer busy release10100.0       
gc cr block 2-way98.9K98.01.0.4.4.1.0.1 
gc cr block 3-way50.1K96.91.4.6.5.4.1.2 
gc cr block busy45350.144.24.6.7.4   
gc cr block congested57 43.942.17.03.51.81.8 
gc cr grant 2-way90.7K98.5.5.3.4.2.0.1 
gc cr grant congested20 30.045.010.010.0 5.0 
gc cr multi block request1080.020.0      
gc current block 2-way32K98.2.9.4.3.1.0.0 
gc current block 3-way15.7K97.31.3.5.4.3.1.1 
gc current block busy4273.823.82.4     
gc current block congested17 52.929.411.85.9   
gc current grant 2-way355298.8.5.2.3.2.0.0 
gc current grant busy834998.6.7.3.2.2.0.0 
gc current grant congested1  100.0     
gc current multi block request131995.82.9.7.3.2.1  
gc current split1100.0       
gcs log flush sync19297.91.6.5     
ges inquiry response1100.0       
ges lms sync during dynamic remastering and reconfig72   18.115.3 66.7 
ges2 LMON to wake up LMD - mrcvr4100.0       
kfk: async disk IO7100.0       
ksxr poll remote instances8555100.0.0      
latch free25497.6.8.4  1.2  
latch: cache buffers chains10798.11.9      
latch: cache buffers lru chain2095.05.0      
latch: checkpoint queue latch7497.32.7      
latch: enqueue hash chains54100.0       
latch: gc element10099.01.0      
latch: gcs resource hash20100.0       
latch: ges resource hash list112999.8.1.1     
latch: messages40100.0       
latch: object queue header operation261899.4.4.1.1    
latch: redo allocation217100.0       
latch: redo writing25100.0       
latch: row cache objects1100.0       
latch: shared pool2100.0       
latch: undo global data1100.0       
libcache interrupt action by LCK11.1K100.0.0      
library cache lock22499.6.4      
library cache pin25799.6   .4   
library cache: mutex X12100.0       
log file parallel write393K100.0.0.0     
log file sequential read13441.447.538.54.84.62.5.5 
log file single write8100.0       
log file sync394.2K96.92.1.4.3.2.0.0 
os thread startup24      100.0 
read by other session1416.410.632.640.46.42.8.7 
reliable message20592.24.4.51.0  2.0 
row cache cleanup12.3K99.9 .0.0.0   
row cache lock87697.51.3.7.1 .1.2.1
row cache process14.8K99.8.2.0     
ASM background timer7356.0.8.81.1 .31.189.9
DIAG idle wait61.1K29.21.0.3.21.56.261.6 
GCR sleep721       100.0
KSV master wait237099.3.3.1.2  .1 
PING185884.4.2.2.1   15.2
PX Deq: Execute Reply30100.0       
PX Deq: Execution Msg16875.611.98.31.2  1.81.2
PX Deq: Join ACK3060.030.010.0     
PX Deq: Parse Reply30100.0       
PX Idle Wait42      26.273.8
SQL*Net message from client1431.1K72.18.72.1.7.61.49.74.8
Space Manager: slave idle wait1288.2.1  .2 1.198.5
Streams AQ: RAC qmn coordinator idle wait254100.0       
Streams AQ: qmn coordinator idle wait16221.0      79.0
Streams AQ: qmn slave idle wait1432.1      97.9
Streams AQ: waiting for time management or cleanup tasks29729.0     31.339.7
class slave wait51936.6.823.11.94.81.01.030.8
dispatcher timer60       100.0
gcs remote message2689.5K53.616.913.96.15.44.0.0 
ges remote message52.9K22.83.82.31.91.82.764.6 
jobq slave wait240      100.0 
pmon timer1200       100.0
rdbms ipc message835.2K53.49.026.32.4.4.26.22.2
shared server idle wait121       100.0
smon timer2814.3      85.7
wait for unread message on broadcast channel7185      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 operation899.6.1.3 .1   
DFS lock handle199.7  .3    
db file sequential read40799.7.2.0.0    
enq: CO - master slave det199.9  .1    
enq: WF - contention194.1   5.9   
gc buffer busy acquire299.3.7      
gc cr block 2-way8799.9.0.0.0.0   
gc cr block 3-way9099.8.0.1.1.0   
gc cr block congested198.2  1.8    
gc cr grant 2-way7599.9.0.0.0.0   
gc cr grant congested195.0   5.0   
gc current block 2-way12100.0 .0.0.0   
gc current block 3-way1899.9.0.1.0.0   
gc current grant 2-way1100.0.0      
gc current grant busy2100.0.0.0     
ges lms sync during dynamic remastering and reconfig4833.3  33.333.3   
log file sequential read799.5.5      
log file sync32100.0.0.0.0.0   
os thread startup24  100.0     
read by other session199.3 .7     
reliable message498.0 .5.5 1.0  
row cache lock399.7   .2 .1 

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
Streams AQ: qmn coordinator waiting for slave to start3  100.0     

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)
yttrc31,70063014024,503
querydb11714800
SYS$USERS1100
SYS$BACKGROUND000105
querydbXDB0000

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
yttrc3 14409575485210014201381
querydb 102000024310
SYS$USERS 20560007240
SYS$BACKGROUND 310611167431000

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.345060.010.2413.3658.4551avhw9u9t9db JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4.154800.010.2316.3877.99ac5s36tc9m3by JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.885160.010.2112.1058.88509v2xwujkv3n JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.864900.010.2116.0563.942ts0w3kdmvzja JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.624500.010.2014.9264.1693600h5ddhh33 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.615440.010.2018.3074.542yz6kg5nfgag3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.594520.010.2014.2284.81bx2u759vu9tf9 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.574590.010.2018.4964.44c6bznpaj65upg JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.564310.010.2014.3476.830tykbt6m9jb4r JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.545500.010.1917.5267.6193mtsyxuvufhq JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
1.452,0010.000.191.5493.934.245qm2a5vqnc4wb JDBC Thin Client INSERT INTO T_EXP_TRACE_806 (I...
1.091,9830.000.141.1793.501.7211xr0wzcvtyr6 JDBC Thin Client INSERT INTO T_EXP_TRACE_807 (I...
1.081,8670.000.140.96112.2312.5059vgsp5cua92a JDBC Thin Client INSERT INTO T_EXP_TRACE_988 (I...
1.011,9800.000.130.92109.282.307ku298f0wvw97 JDBC Thin Client INSERT INTO T_EXP_TRACE_824 (I...
0.971,9400.000.120.86113.382.6613jry4ymj3jcd JDBC Thin Client INSERT INTO T_EXP_TRACE_822 (I...
0.971,9730.000.121.0592.6915.42a9bhfg7d2ckgj JDBC Thin Client INSERT INTO T_EXP_TRACE_820 (I...
0.971,9710.000.121.0096.930.40byjsxpwyc9zvb JDBC Thin Client INSERT INTO T_EXP_TRACE_842 (I...
0.961,9660.000.120.93103.100.782xtghs0fcy20q JDBC Thin Client INSERT INTO T_EXP_TRACE_805 (I...
0.941,9530.000.120.94100.360.598838udw9yafx1 JDBC Thin Client INSERT INTO T_EXP_TRACE_912 (I...
0.911,9500.000.120.78116.810.8002cr0vm7xwsn1 JDBC Thin Client INSERT INTO T_EXP_TRACE_938 (I...

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
3.244800.010.434.1516.3877.99ac5s36tc9m3by JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3.044520.010.403.5914.2284.81bx2u759vu9tf9 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.734310.010.363.5614.3476.830tykbt6m9jb4r JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.695440.000.363.6118.3074.542yz6kg5nfgag3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.573960.010.343.5212.2073.01cubj9bfkf4uc8 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.564070.010.343.3116.9277.50ad50zpu6a7xbh JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.564500.010.343.3717.2376.07fddtnraagbjg3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.545060.010.344.3413.3658.4551avhw9u9t9db JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.474900.010.333.8616.0563.942ts0w3kdmvzja JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
2.424020.010.323.1517.4476.570rg4xq51ud6u3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...

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
49,23455089.520.203.5417.567.693mtsyxuvufhq JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
49,20454490.450.203.6118.374.52yz6kg5nfgag3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
47,06351192.100.193.1622.255.21mqhpj3nctdpd JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
46,24551689.620.193.8812.158.9509v2xwujkv3n JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
45,45450689.830.184.3413.458.551avhw9u9t9db JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
44,72549889.810.183.1218.362.3bx59qwpx45d2d JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
44,40749090.630.183.861663.92ts0w3kdmvzja JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
44,13648790.630.183.0623.662.797w00msv9wky3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
43,43248090.480.184.1516.478ac5s36tc9m3by JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
43,16746992.040.183.2618.749.97m6kfuckjugvy JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
5804801.210.414.1516.3877.99ac5s36tc9m3by JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
5504521.220.393.5914.2284.81bx2u759vu9tf9 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4965440.910.353.6118.3074.542yz6kg5nfgag3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4944071.210.353.3116.9277.50ad50zpu6a7xbh JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4884311.130.353.5614.3476.830tykbt6m9jb4r JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4864900.990.353.8616.0563.942ts0w3kdmvzja JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4714501.050.343.3717.2376.07fddtnraagbjg3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4615500.840.333.5417.5267.6193mtsyxuvufhq JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4594021.140.333.1517.4476.570rg4xq51ud6u3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4505160.870.323.8812.1058.88509v2xwujkv3n JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...

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
4884884311.130.000.350tykbt6m9jb4r JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4594594021.140.000.330rg4xq51ud6u3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4504505160.870.000.32509v2xwujkv3n JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4434435060.880.000.3251avhw9u9t9db JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4244244500.940.000.3093600h5ddhh33 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4244244530.940.000.30a50w5yct8bkpv JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4244244370.970.000.30b0zj5yqqf2g5w JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
4224224590.920.000.30c6bznpaj65upg JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3803804530.840.000.278bt75f6y8g8fy JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
3673674380.840.000.262nw2gfm2156t6 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecElapsed Time (s) %CPU %IO SQL IdSQL ModuleSQL Text
2,0242,5891.281.0976.513.3az4vx9kw6kfhk JDBC Thin Client INSERT INTO T_EXP_TRACE_861 (I...
2,0132,5791.281.0282.314gs3t419sxky8d JDBC Thin Client INSERT INTO T_EXP_TRACE_829 (I...
2,0112,5731.280.9294.47.10bquu05y3vycz JDBC Thin Client INSERT INTO T_EXP_TRACE_855 (I...
2,0102,5391.260.8787.63.7ffyt0ux47p15q JDBC Thin Client INSERT INTO T_EXP_TRACE_932 (I...
2,0092,5261.260.9191.53.818c2cyyb8w0mc JDBC Thin Client INSERT INTO T_EXP_TRACE_930 (I...
2,0092,5571.270.8871.927k0bj5q812hjt JDBC Thin Client INSERT INTO T_EXP_TRACE_817 (I...
2,0072,5311.261.1960.629.8gd8mggw29h5fn JDBC Thin Client INSERT INTO T_EXP_TRACE_872 (I...
2,0052,5741.280.90100.65.342tcw817nx11p JDBC Thin Client INSERT INTO T_EXP_TRACE_803 (I...
2,0032,5271.260.9190.210.92qtu8sa3q0frv JDBC Thin Client INSERT INTO T_EXP_TRACE_834 (I...
2,0012,5281.260.9779.716.438kc0wgj5s7wk JDBC Thin Client INSERT INTO T_EXP_TRACE_992 (I...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
1,9341,9400.551gc3c16ukr5md JDBC Thin Client INSERT INTO T_EXP_TRACE_844 (I...
1,9071,9130.550qpngu8dhm6vj JDBC Thin Client INSERT INTO T_EXP_TRACE_835 (I...
1,6951,6950.49350f5yrnnmshs   lock table sys.mon_mods$ in ex...
9431,9720.277fusfgbufzns7 JDBC Thin Client INSERT INTO T_EXP_TRACE_985 (I...
9361,9460.2711ns5xsbmbsdm JDBC Thin Client INSERT INTO T_EXP_TRACE_882 (I...
9312,0240.27az4vx9kw6kfhk JDBC Thin Client INSERT INTO T_EXP_TRACE_861 (I...
9261,9690.277g652ymu7sd0h JDBC Thin Client INSERT INTO T_EXP_TRACE_921 (I...
9241,9300.26758khmvzsfh0t JDBC Thin Client INSERT INTO T_EXP_TRACE_995 (I...
9221,8710.264xv6mtm7dggd1 JDBC Thin Client INSERT INTO T_EXP_TRACE_981 (I...
9221,9290.265gccydcrgs8b5 JDBC Thin Client INSERT INTO T_EXP_TRACE_898 (I...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
2,262,2081,9360.053r3dqkjw03gu6 JDBC Thin Client INSERT INTO T_EXP_TRACE_837 (I...
2,008,5361,9720.05f26ptwgdbd7j2 JDBC Thin Client INSERT INTO T_EXP_TRACE_889 (I...
1,738,4801,9370.042m2n50x33tkpv JDBC Thin Client INSERT INTO T_EXP_TRACE_828 (I...
1,642,3122,0010.045qm2a5vqnc4wb JDBC Thin Client INSERT INTO T_EXP_TRACE_806 (I...
1,578,3921,9450.045fjjf1vrpk874 JDBC Thin Client INSERT INTO T_EXP_TRACE_924 (I...
1,565,8801,9700.0481cbtzrt6g62r JDBC Thin Client INSERT INTO T_EXP_TRACE_851 (I...
1,555,5361,9620.04dztcgn6tsqux0 JDBC Thin Client INSERT INTO T_EXP_TRACE_841 (I...
1,500,9361,9830.0311xr0wzcvtyr6 JDBC Thin Client INSERT INTO T_EXP_TRACE_807 (I...
1,454,3921,9790.03bf0x3hnmus8p2 JDBC Thin Client INSERT INTO T_EXP_TRACE_858 (I...
1,452,2401,9690.03bfa26fswkrrhk JDBC Thin Client INSERT INTO T_EXP_TRACE_802 (I...
1,435,5041,9790.031dvj422rkwt7h JDBC Thin Client INSERT INTO T_EXP_TRACE_848 (I...
1,387,6481,9500.03g1wcgyuv5nzcy JDBC Thin Client INSERT INTO T_EXP_TRACE_821 (I...
1,261,5921,9530.03guacg2wf2a2mf JDBC Thin Client INSERT INTO T_EXP_TRACE_816 (I...
1,260,1761,9290.032hvryhgg7k9uq JDBC Thin Client INSERT INTO T_EXP_TRACE_849 (I...
1,203,6481,9630.03bmm8rvby36rg2 JDBC Thin Client INSERT INTO T_EXP_TRACE_830 (I...
1,181,3441,9540.03fct0xvwzs6wa2 JDBC Thin Client INSERT INTO T_EXP_TRACE_909 (I...
1,056,2961,9290.02fjk08r5k5s9qn JDBC Thin Client INSERT INTO T_EXP_TRACE_997 (I...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
641,9363r3dqkjw03gu6 JDBC Thin Client INSERT INTO T_EXP_TRACE_837 (I...
561,962g2wm8u2m1vxvc JDBC Thin Client INSERT INTO T_EXP_TRACE_833 (I...
491,93505jr041y636gy JDBC Thin Client INSERT INTO T_EXP_TRACE_832 (I...
481,979bf0x3hnmus8p2 JDBC Thin Client INSERT INTO T_EXP_TRACE_858 (I...
481,969bfa26fswkrrhk JDBC Thin Client INSERT INTO T_EXP_TRACE_802 (I...
481,971byjsxpwyc9zvb JDBC Thin Client INSERT INTO T_EXP_TRACE_842 (I...
471,9807ku298f0wvw97 JDBC Thin Client INSERT INTO T_EXP_TRACE_824 (I...
471,972f26ptwgdbd7j2 JDBC Thin Client INSERT INTO T_EXP_TRACE_889 (I...
461,9455fjjf1vrpk874 JDBC Thin Client INSERT INTO T_EXP_TRACE_924 (I...
461,950g1wcgyuv5nzcy JDBC Thin Client INSERT INTO T_EXP_TRACE_821 (I...
451,963bmm8rvby36rg2 JDBC Thin Client INSERT INTO T_EXP_TRACE_830 (I...
441,9067xykd4vpc4pck JDBC Thin Client INSERT INTO T_EXP_TRACE_991 (I...
441,948g82wmr4udk9w7 JDBC Thin Client INSERT INTO T_EXP_TRACE_999 (I...
432,0110bquu05y3vycz JDBC Thin Client INSERT INTO T_EXP_TRACE_855 (I...
432,0015qm2a5vqnc4wb JDBC Thin Client INSERT INTO T_EXP_TRACE_806 (I...
431,950a3mw8nv9481ws JDBC Thin Client INSERT INTO T_EXP_TRACE_971 (I...
432,024az4vx9kw6kfhk JDBC Thin Client INSERT INTO T_EXP_TRACE_861 (I...
421,9314wbb60jxm3k8z JDBC Thin Client INSERT INTO T_EXP_TRACE_867 (I...
421,871f3trg5pc2f1wm JDBC Thin Client INSERT INTO T_EXP_TRACE_894 (I...
411,9901z85srt3qt8kc JDBC Thin Client INSERT INTO T_EXP_TRACE_926 (I...
411,9665jku1sh26sya4 JDBC Thin Client INSERT INTO T_EXP_TRACE_826 (I...
411,954b8fvv7udn5uq2 JDBC Thin Client INSERT INTO T_EXP_TRACE_969 (I...
411,932dqr3xghswc13q JDBC Thin Client INSERT INTO T_EXP_TRACE_815 (I...
401,98311xr0wzcvtyr6 JDBC Thin Client INSERT INTO T_EXP_TRACE_807 (I...
401,9412n52k27y0t4d8 JDBC Thin Client INSERT INTO T_EXP_TRACE_955 (I...
391,9292hvryhgg7k9uq JDBC Thin Client INSERT INTO T_EXP_TRACE_849 (I...
391,957f5yn5kt78s9ty JDBC Thin Client INSERT INTO T_EXP_TRACE_905 (I...
391,953guacg2wf2a2mf JDBC Thin Client INSERT INTO T_EXP_TRACE_816 (I...
381,9662xtghs0fcy20q JDBC Thin Client INSERT INTO T_EXP_TRACE_805 (I...
381,97081cbtzrt6g62r JDBC Thin Client INSERT INTO T_EXP_TRACE_851 (I...
381,946a4tm4wvys50sk JDBC Thin Client INSERT INTO T_EXP_TRACE_940 (I...
381,967g9dc29kxccgbq JDBC Thin Client INSERT INTO T_EXP_TRACE_900 (I...
371,9401gc3c16ukr5md JDBC Thin Client INSERT INTO T_EXP_TRACE_844 (I...
372,00138kc0wgj5s7wk JDBC Thin Client INSERT INTO T_EXP_TRACE_992 (I...
371,9304su21fq9vwa6g JDBC Thin Client INSERT INTO T_EXP_TRACE_838 (I...
371,9697g652ymu7sd0h JDBC Thin Client INSERT INTO T_EXP_TRACE_921 (I...
362,00542tcw817nx11p JDBC Thin Client INSERT INTO T_EXP_TRACE_803 (I...
361,9727fusfgbufzns7 JDBC Thin Client INSERT INTO T_EXP_TRACE_985 (I...
361,965d320kb921tv88 JDBC Thin Client INSERT INTO T_EXP_TRACE_847 (I...
351,9246f3cds56awwga JDBC Thin Client INSERT INTO T_EXP_TRACE_923 (I...
352,010ffyt0ux47p15q JDBC Thin Client INSERT INTO T_EXP_TRACE_932 (I...
341,9130qpngu8dhm6vj JDBC Thin Client INSERT INTO T_EXP_TRACE_835 (I...
341,9791dvj422rkwt7h JDBC Thin Client INSERT INTO T_EXP_TRACE_848 (I...
331,86759vgsp5cua92a JDBC Thin Client INSERT INTO T_EXP_TRACE_988 (I...
321,94611ns5xsbmbsdm JDBC Thin Client INSERT INTO T_EXP_TRACE_882 (I...
321,94013jry4ymj3jcd JDBC Thin Client INSERT INTO T_EXP_TRACE_822 (I...
321,9372m2n50x33tkpv JDBC Thin Client INSERT INTO T_EXP_TRACE_828 (I...
321,9814adn8k4x48zru JDBC Thin Client INSERT INTO T_EXP_TRACE_963 (I...
321,9887157yzxufgwv3 JDBC Thin Client INSERT INTO T_EXP_TRACE_886 (I...
321,89483zf01f1nswxt JDBC Thin Client INSERT INTO T_EXP_TRACE_968 (I...
321,931f7fkfc2wsuttg JDBC Thin Client INSERT INTO T_EXP_TRACE_989 (I...
322,007gd8mggw29h5fn JDBC Thin Client INSERT INTO T_EXP_TRACE_872 (I...
312,00918c2cyyb8w0mc JDBC Thin Client INSERT INTO T_EXP_TRACE_930 (I...
311,9295gccydcrgs8b5 JDBC Thin Client INSERT INTO T_EXP_TRACE_898 (I...
311,971a6tcbtpf4zgr7 JDBC Thin Client INSERT INTO T_EXP_TRACE_827 (I...
311,962dztcgn6tsqux0 JDBC Thin Client INSERT INTO T_EXP_TRACE_841 (I...
301,940cxjy7pyghbkuv JDBC Thin Client INSERT INTO T_EXP_TRACE_956 (I...
292,0032qtu8sa3q0frv JDBC Thin Client INSERT INTO T_EXP_TRACE_834 (I...
281,893b1gzp0czaprxw JDBC Thin Client INSERT INTO T_EXP_TRACE_831 (I...
281,954fct0xvwzs6wa2 JDBC Thin Client INSERT INTO T_EXP_TRACE_909 (I...
271,9459x2pxrf9vc75z JDBC Thin Client INSERT INTO T_EXP_TRACE_987 (I...
271,978ftqs6gmg1u20b JDBC Thin Client INSERT INTO T_EXP_TRACE_866 (I...
261,930758khmvzsfh0t JDBC Thin Client INSERT INTO T_EXP_TRACE_995 (I...
261,9587qp03m3f5k7fd JDBC Thin Client INSERT INTO T_EXP_TRACE_899 (I...
261,929fjk08r5k5s9qn JDBC Thin Client INSERT INTO T_EXP_TRACE_997 (I...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)Executions%TotalElapsed Time(s)%Clu%CPU%IO SQL IdSQL ModuleSQL Text
1.235060.884.3428.3313.3658.4551avhw9u9t9db JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
1.154450.823.4233.5712.5650.880fhr6s3nu267f JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
1.064690.763.2632.5718.7049.947m6kfuckjugvy JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.975160.693.8825.0212.1058.88509v2xwujkv3n JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.954260.673.2828.8917.6955.29816bf7j9r4b5a JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.844900.603.8621.7116.0563.942ts0w3kdmvzja JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.825110.583.1625.9322.1655.231mqhpj3nctdpd JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.814470.573.1425.6318.1557.32a16ww656531vw JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.764500.543.6220.9714.9264.1693600h5ddhh33 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.734590.523.5720.5818.4964.44c6bznpaj65upg JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.724470.513.0723.4214.3459.22aafmzj9pr2230 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.714530.503.4320.6318.9863.158bt75f6y8g8fy JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.664520.473.0921.2320.3961.23gxbhmu1rkxdwv JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.614980.443.1219.6718.2962.28bx59qwpx45d2d JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.594380.423.0919.1117.4863.992nw2gfm2156t6 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.564870.403.0618.2623.5762.7297w00msv9wky3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.554530.393.3816.2519.8467.18a50w5yct8bkpv JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.525500.373.5414.7317.5267.6193mtsyxuvufhq JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.514580.363.3915.0016.5269.10fz62vb7zys43g JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.483960.343.5213.5312.2073.01cubj9bfkf4uc8 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.354370.253.1810.9016.0472.65b0zj5yqqf2g5w JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.334800.244.157.9716.3877.99ac5s36tc9m3by JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.324650.233.1810.0216.6573.38g1pvptr1xk8qu JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.314630.223.0610.2420.5972.56f1z6xss2wc3wq JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.304310.223.568.5014.3476.830tykbt6m9jb4r JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.305440.213.618.2018.3074.542yz6kg5nfgag3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.274500.193.377.9417.2376.07fddtnraagbjg3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.264070.183.317.8316.9277.50ad50zpu6a7xbh JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.264020.183.158.1417.4476.570rg4xq51ud6u3 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.084520.063.592.3314.2284.81bx2u759vu9tf9 JDBC Thin Client SELECT OP_TIME, OP_ORG_NAME, O...
0.081,9530.050.948.07100.360.598838udw9yafx1 JDBC Thin Client INSERT INTO T_EXP_TRACE_912 (I...
0.071,8770.050.858.5788.990.003xhqnspt6uu05 JDBC Thin Client INSERT INTO T_EXP_TRACE_871 (I...
0.061,9500.051.165.5969.751.07g1wcgyuv5nzcy JDBC Thin Client INSERT INTO T_EXP_TRACE_821 (I...
0.052,0090.040.915.5691.553.7918c2cyyb8w0mc JDBC Thin Client INSERT INTO T_EXP_TRACE_930 (I...
0.051,9510.031.014.8077.4118.750dnwz5d73tbfd JDBC Thin Client INSERT INTO T_EXP_TRACE_986 (I...
0.051,9730.031.054.3292.6915.42a9bhfg7d2ckgj JDBC Thin Client INSERT INTO T_EXP_TRACE_820 (I...
0.051,9660.030.845.36101.080.385jku1sh26sya4 JDBC Thin Client INSERT INTO T_EXP_TRACE_826 (I...
0.041,9690.030.994.4189.097.31bfa26fswkrrhk JDBC Thin Client INSERT INTO T_EXP_TRACE_802 (I...
0.041,9400.030.914.7276.161.211gc3c16ukr5md JDBC Thin Client INSERT INTO T_EXP_TRACE_844 (I...
0.041,9420.030.994.1591.810.00g7qthhyqf0531 JDBC Thin Client INSERT INTO T_EXP_TRACE_804 (I...
0.041,9370.030.944.2190.287.852m2n50x33tkpv JDBC Thin Client INSERT INTO T_EXP_TRACE_828 (I...
0.041,8710.030.794.63105.290.004xv6mtm7dggd1 JDBC Thin Client INSERT INTO T_EXP_TRACE_981 (I...
0.041,9710.030.963.7690.828.52a6tcbtpf4zgr7 JDBC Thin Client INSERT INTO T_EXP_TRACE_827 (I...
0.031,9540.020.794.3387.350.00b8fvv7udn5uq2 JDBC Thin Client INSERT INTO T_EXP_TRACE_969 (I...
0.031,9290.020.963.5573.8413.99fjk08r5k5s9qn JDBC Thin Client INSERT INTO T_EXP_TRACE_997 (I...
0.031,9310.020.863.7289.411.244wbb60jxm3k8z JDBC Thin Client INSERT INTO T_EXP_TRACE_867 (I...
0.031,9240.020.923.4375.3616.036f3cds56awwga JDBC Thin Client INSERT INTO T_EXP_TRACE_923 (I...
0.031,9630.020.803.8795.000.00bmm8rvby36rg2 JDBC Thin Client INSERT INTO T_EXP_TRACE_830 (I...
0.032,0130.021.022.9982.2613.95gs3t419sxky8d JDBC Thin Client INSERT INTO T_EXP_TRACE_829 (I...
0.031,9290.021.022.9764.7819.325gccydcrgs8b5 JDBC Thin Client INSERT INTO T_EXP_TRACE_898 (I...
0.031,9830.021.172.5993.501.7211xr0wzcvtyr6 JDBC Thin Client INSERT INTO T_EXP_TRACE_807 (I...
0.031,9880.020.863.3286.761.867157yzxufgwv3 JDBC Thin Client INSERT INTO T_EXP_TRACE_886 (I...
0.031,9800.020.923.04109.282.307ku298f0wvw97 JDBC Thin Client INSERT INTO T_EXP_TRACE_824 (I...
0.032,0240.021.092.5276.4513.33az4vx9kw6kfhk JDBC Thin Client INSERT INTO T_EXP_TRACE_861 (I...
0.032,0010.020.972.8379.6716.3538kc0wgj5s7wk JDBC Thin Client INSERT INTO T_EXP_TRACE_992 (I...
0.031,9660.020.932.93103.100.782xtghs0fcy20q JDBC Thin Client INSERT INTO T_EXP_TRACE_805 (I...
0.032,0100.020.873.1287.633.67ffyt0ux47p15q JDBC Thin Client INSERT INTO T_EXP_TRACE_932 (I...
0.031,9620.020.982.7088.416.63dztcgn6tsqux0 JDBC Thin Client INSERT INTO T_EXP_TRACE_841 (I...
0.031,9810.020.793.3281.921.804adn8k4x48zru JDBC Thin Client INSERT INTO T_EXP_TRACE_963 (I...
0.031,9700.020.843.1090.230.6281cbtzrt6g62r JDBC Thin Client INSERT INTO T_EXP_TRACE_851 (I...
0.031,9710.021.002.5796.930.40byjsxpwyc9zvb JDBC Thin Client INSERT INTO T_EXP_TRACE_842 (I...
0.021,9350.020.832.9983.261.9405jr041y636gy JDBC Thin Client INSERT INTO T_EXP_TRACE_832 (I...
0.021,9450.020.912.7369.597.599x2pxrf9vc75z JDBC Thin Client INSERT INTO T_EXP_TRACE_987 (I...
0.022,0110.020.922.6894.367.060bquu05y3vycz JDBC Thin Client INSERT INTO T_EXP_TRACE_855 (I...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02cr0vm7xwsn1 INSERT INTO T_EXP_TRACE_938 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
05jr041y636gy INSERT INTO T_EXP_TRACE_832 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
0bquu05y3vycz INSERT INTO T_EXP_TRACE_855 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
0dnwz5d73tbfd INSERT INTO T_EXP_TRACE_986 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
0fhr6s3nu267fSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_786 WHERE WAYBILL_NO=:1
0qpngu8dhm6vj INSERT INTO T_EXP_TRACE_835 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
0rg4xq51ud6u3SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_733 WHERE WAYBILL_NO=:1
0tykbt6m9jb4rSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_518 WHERE WAYBILL_NO=:1
11ns5xsbmbsdm INSERT INTO T_EXP_TRACE_882 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
11xr0wzcvtyr6 INSERT INTO T_EXP_TRACE_807 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
13jry4ymj3jcd INSERT INTO T_EXP_TRACE_822 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
18c2cyyb8w0mc INSERT INTO T_EXP_TRACE_930 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
1dvj422rkwt7h INSERT INTO T_EXP_TRACE_848 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
1gc3c16ukr5md INSERT INTO T_EXP_TRACE_844 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
1mqhpj3nctdpdSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_709 WHERE WAYBILL_NO=:1
1z85srt3qt8kc INSERT INTO T_EXP_TRACE_926 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
2hvryhgg7k9uq INSERT INTO T_EXP_TRACE_849 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
2m2n50x33tkpv INSERT INTO T_EXP_TRACE_828 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
2n52k27y0t4d8 INSERT INTO T_EXP_TRACE_955 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
2nw2gfm2156t6SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_744 WHERE WAYBILL_NO=:1
2qtu8sa3q0frv INSERT INTO T_EXP_TRACE_834 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
2ts0w3kdmvzjaSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_758 WHERE WAYBILL_NO=:1
2xtghs0fcy20q INSERT INTO T_EXP_TRACE_805 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
2yz6kg5nfgag3SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_790 WHERE WAYBILL_NO=:1
350f5yrnnmshslock table sys.mon_mods$ in exclusive mode nowait
38kc0wgj5s7wk INSERT INTO T_EXP_TRACE_992 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
3r3dqkjw03gu6 INSERT INTO T_EXP_TRACE_837 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
3xhqnspt6uu05 INSERT INTO T_EXP_TRACE_871 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
42tcw817nx11p INSERT INTO T_EXP_TRACE_803 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
4adn8k4x48zru INSERT INTO T_EXP_TRACE_963 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
4su21fq9vwa6g INSERT INTO T_EXP_TRACE_838 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
4wbb60jxm3k8z INSERT INTO T_EXP_TRACE_867 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
4xv6mtm7dggd1 INSERT INTO T_EXP_TRACE_981 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
509v2xwujkv3nSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_609 WHERE WAYBILL_NO=:1
51avhw9u9t9dbSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_684 WHERE WAYBILL_NO=:1
59vgsp5cua92a INSERT INTO T_EXP_TRACE_988 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
5fjjf1vrpk874 INSERT INTO T_EXP_TRACE_924 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
5gccydcrgs8b5 INSERT INTO T_EXP_TRACE_898 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
5jku1sh26sya4 INSERT INTO T_EXP_TRACE_826 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
5qm2a5vqnc4wb INSERT INTO T_EXP_TRACE_806 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
6f3cds56awwga INSERT INTO T_EXP_TRACE_923 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7157yzxufgwv3 INSERT INTO T_EXP_TRACE_886 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
758khmvzsfh0t INSERT INTO T_EXP_TRACE_995 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7fusfgbufzns7 INSERT INTO T_EXP_TRACE_985 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7g652ymu7sd0h INSERT INTO T_EXP_TRACE_921 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7k0bj5q812hjt INSERT INTO T_EXP_TRACE_817 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7ku298f0wvw97 INSERT INTO T_EXP_TRACE_824 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7m6kfuckjugvySELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_572 WHERE WAYBILL_NO=:1
7qp03m3f5k7fd INSERT INTO T_EXP_TRACE_899 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
7xykd4vpc4pck INSERT INTO T_EXP_TRACE_991 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
816bf7j9r4b5aSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_798 WHERE WAYBILL_NO=:1
81cbtzrt6g62r INSERT INTO T_EXP_TRACE_851 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
83zf01f1nswxt INSERT INTO T_EXP_TRACE_968 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
8838udw9yafx1 INSERT INTO T_EXP_TRACE_912 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
8bt75f6y8g8fySELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_583 WHERE WAYBILL_NO=:1
93600h5ddhh33SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_531 WHERE WAYBILL_NO=:1
93mtsyxuvufhqSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_604 WHERE WAYBILL_NO=:1
97w00msv9wky3SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_586 WHERE WAYBILL_NO=:1
9x2pxrf9vc75z INSERT INTO T_EXP_TRACE_987 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
a16ww656531vwSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_660 WHERE WAYBILL_NO=:1
a3mw8nv9481ws INSERT INTO T_EXP_TRACE_971 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
a4tm4wvys50sk INSERT INTO T_EXP_TRACE_940 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
a50w5yct8bkpvSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_725 WHERE WAYBILL_NO=:1
a6tcbtpf4zgr7 INSERT INTO T_EXP_TRACE_827 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
a9bhfg7d2ckgj INSERT INTO T_EXP_TRACE_820 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
aafmzj9pr2230SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_759 WHERE WAYBILL_NO=:1
ac5s36tc9m3bySELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_588 WHERE WAYBILL_NO=:1
ad50zpu6a7xbhSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_728 WHERE WAYBILL_NO=:1
az4vx9kw6kfhk INSERT INTO T_EXP_TRACE_861 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
b0zj5yqqf2g5wSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_703 WHERE WAYBILL_NO=:1
b1gzp0czaprxw INSERT INTO T_EXP_TRACE_831 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
b8fvv7udn5uq2 INSERT INTO T_EXP_TRACE_969 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
bf0x3hnmus8p2 INSERT INTO T_EXP_TRACE_858 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
bfa26fswkrrhk INSERT INTO T_EXP_TRACE_802 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
bmm8rvby36rg2 INSERT INTO T_EXP_TRACE_830 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
bx2u759vu9tf9SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_986 WHERE WAYBILL_NO=:1
bx59qwpx45d2dSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_521 WHERE WAYBILL_NO=:1
byjsxpwyc9zvb INSERT INTO T_EXP_TRACE_842 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
c6bznpaj65upgSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_536 WHERE WAYBILL_NO=:1
cubj9bfkf4uc8SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_724 WHERE WAYBILL_NO=:1
cxjy7pyghbkuv INSERT INTO T_EXP_TRACE_956 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
d320kb921tv88 INSERT INTO T_EXP_TRACE_847 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
dqr3xghswc13q INSERT INTO T_EXP_TRACE_815 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
dztcgn6tsqux0 INSERT INTO T_EXP_TRACE_841 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
f1z6xss2wc3wqSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_612 WHERE WAYBILL_NO=:1
f26ptwgdbd7j2 INSERT INTO T_EXP_TRACE_889 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
f3trg5pc2f1wm INSERT INTO T_EXP_TRACE_894 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
f5yn5kt78s9ty INSERT INTO T_EXP_TRACE_905 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
f7fkfc2wsuttg INSERT INTO T_EXP_TRACE_989 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
fct0xvwzs6wa2 INSERT INTO T_EXP_TRACE_909 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
fddtnraagbjg3SELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_629 WHERE WAYBILL_NO=:1
ffyt0ux47p15q INSERT INTO T_EXP_TRACE_932 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
fjk08r5k5s9qn INSERT INTO T_EXP_TRACE_997 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
ftqs6gmg1u20b INSERT INTO T_EXP_TRACE_866 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
fz62vb7zys43gSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_589 WHERE WAYBILL_NO=:1
g1pvptr1xk8quSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_666 WHERE WAYBILL_NO=:1
g1wcgyuv5nzcy INSERT INTO T_EXP_TRACE_821 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
g2wm8u2m1vxvc INSERT INTO T_EXP_TRACE_833 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
g7qthhyqf0531 INSERT INTO T_EXP_TRACE_804 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
g82wmr4udk9w7 INSERT INTO T_EXP_TRACE_999 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
g9dc29kxccgbq INSERT INTO T_EXP_TRACE_900 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
gd8mggw29h5fn INSERT INTO T_EXP_TRACE_872 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
gs3t419sxky8d INSERT INTO T_EXP_TRACE_829 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
guacg2wf2a2mf INSERT INTO T_EXP_TRACE_816 (ID, OP_ORG_ID, OP_ORG_NAME, CITY_NAME, OP_TIME, OP_CODE, OP_NAME, WAYBILL_NO, CONTAINER_NO, WEIGH_WEIGHT, INPUT_WEIGHT, UNFOLD_FLAG, EXP_TYPE, TRACE_MESSAGE, AUX_MESSAGE, DISPLAY_FLAG, WEIGHT, PRODUCT_CODE, OP_MACHINE, UPLOAD_TIME, DATAID, EXP_STATUS, EXTEND_TIME, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON, EMP_CODE, CREATE_USER_CODE, PREVIOUSE_ORG_CODE, NEXT_ORG_CODE, DES_ORG_CODE, DES_ORG_NAME, PKG_QTY, EXPRESS_CONTENT_CODE, VOLOME_WEIGHT, AUX_OP_CODE, CREATE_TIEM, MODIFY_TIME, MODIFY_USER_CODE, MODIFY_USER_NAME, SIGNOFF_TYPE_CODE, DELIVERY_FAIL_REASON_CODE) VALUES (:1 , :2 , :3 , :4 , to_timestamp(:5 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , to_timestamp(:20 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :21 , :22 , to_timestamp(:23 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 , :37 , :38 , :39 , :40 , to_timestamp(:41 , 'yyyy-mm-dd hh24:mi:ss.ff3'), to_timestamp(:42 , 'yyyy-mm-dd hh24:mi:ss.ff3'), :43 , :44 , :45 , :46 )
gxbhmu1rkxdwvSELECT OP_TIME, OP_ORG_NAME, OP_NAME, WAYBILL_NO, EXP_STATUS, TRACE_MESSAGE, CONTAINER_NO, UPLOAD_TIME, WEIGHT, CITY_NAME, OP_CODE, UNFOLD_FLAG, EXP_TYPE, AUX_MESSAGE, DISPLAY_FLAG, PRODUCT_CODE, OP_MACHINE, FREQUENCY_NO, PREVIOUSE_ORG_NAME, NEXT_ORG_NAME, CREATE_USER_NAME, EMP_NAME, ID, DATAID, EXTEND_TIME, WEIGH_WEIGHT, INPUT_WEIGHT, OP_ORG_ID, RECIEVER_SIGNOFF, DELIVERY_FAIL_REASON FROM T_EXP_TRACE_696 WHERE WAYBILL_NO=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
Batched IO (bound) vector count00.000.00
Batched IO (full) vector count00.000.00
Batched IO block miss count40.000.00
Batched IO buffer defrag count00.000.00
Batched IO double miss count20.000.00
Batched IO same unit count00.000.00
Batched IO single block count10.000.00
Batched IO slow jump count00.000.00
Batched IO vector block count20.000.00
Batched IO vector read count10.000.00
Block Cleanout Optim referenced1,3610.380.00
CCursor + sql area evicted40.000.00
CPU used by this session77,29821.380.20
CPU used when call started55,39315.320.14
CR blocks created190.010.00
Cached Commit SCN referenced2760.080.00
Commit SCN cached2040.060.00
DB time176,40348.800.45
DBWR checkpoint buffers written412,495114.121.04
DBWR checkpoints20.000.00
DBWR fusion writes11,3093.130.03
DBWR object drop buffers written00.000.00
DBWR transaction table writes1340.040.00
DBWR undo block writes19,1055.290.05
DFO trees parallelized120.000.00
HSC Heap Segment Block Changes403,689111.681.02
HSC IDL Compressed Blocks00.000.00
Heap Segment Array Inserts93,69025.920.24
Heap Segment Array Updates170.000.00
LOB table id lookup cache misses00.000.00
Misses for writing mapping00.000.00
Number of read IOs issued00.000.00
PX local messages recv'd240.010.00
PX local messages sent240.010.00
PX remote messages recv'd1200.030.00
PX remote messages sent1200.030.00
Parallel operations downgraded 25 to 50 pct00.000.00
Parallel operations not downgraded120.000.00
Requests to/from client1,420,512392.983.58
RowCR attempts00.000.00
RowCR hits00.000.00
SMON posted for instance recovery00.000.00
SMON posted for undo segment recovery00.000.00
SMON posted for undo segment shrink80.000.00
SQL*Net roundtrips to/from client1,423,034393.683.59
TBS Extension: bytes extended10,485,7602,900.8826.45
TBS Extension: files extended10.000.00
TBS Extension: tasks created60.000.00
TBS Extension: tasks executed60.000.00
active txn count during cleanout3,1400.870.01
application wait time60.000.00
background checkpoints completed20.000.00
background checkpoints started20.000.00
background timeouts25,6827.100.06
branch node splits10.000.00
buffer is not pinned count10,417,0262,881.8626.28
buffer is pinned count681,626188.571.72
bytes received via SQL*Net from client1,045,893,523289,345.532,638.66
bytes sent via SQL*Net to client459,548,183127,133.601,159.38
calls to get snapshot scn: kcmgss637,800176.451.61
calls to kcmgas878,704243.092.22
calls to kcmgcs419,614116.091.06
cell physical IO interconnect bytes9,556,103,1682,643,687.5924,108.87
change write time5,7061.580.01
cleanout - number of ktugct calls4,0031.110.01
cleanouts and rollbacks - consistent read gets60.000.00
cleanouts only - consistent read gets3880.110.00
cluster key scan block gets1,0140.280.00
cluster key scans8470.230.00
cluster wait time14,0553.890.04
commit batch/immediate performed170.000.00
commit batch/immediate requested170.000.00
commit cleanout failures: block lost310.010.00
commit cleanout failures: buffer being written20.000.00
commit cleanout failures: callback failure330.010.00
commit cleanout failures: cannot pin20.000.00
commit cleanouts917,197253.742.31
commit cleanouts successfully completed917,129253.722.31
commit immediate performed170.000.00
commit immediate requested170.000.00
commit txn count during cleanout1,0860.300.00
concurrency wait time4380.120.00
consistent changes710.020.00
consistent gets21,032,1735,818.5353.06
consistent gets - examination4,289,3231,186.6410.82
consistent gets direct00.000.00
consistent gets from cache21,032,1735,818.5353.06
cursor authentications650.020.00
data blocks consistent reads - undo records applied320.010.00
db block changes3,148,930871.157.94
db block gets3,576,325989.399.02
db block gets direct90.000.00
db block gets from cache3,576,316989.389.02
deferred (CURRENT) block cleanout applications838,579231.992.12
dirty buffers inspected90.000.00
enqueue conversions1,0820.300.00
enqueue releases1,246,034344.713.14
enqueue requests1,247,268345.063.15
enqueue timeouts1,2000.330.00
enqueue waits2,9470.820.01
exchange deadlocks20.000.00
execute count628,639173.911.59
failed probes on index block reclamation00.000.00
file io service time157,13643.470.40
file io wait time803,737,537222,353.292,027.73
free buffer inspected381,123105.440.96
free buffer requested387,086107.090.98
gc blocks compressed51,46714.240.13
gc blocks lost00.000.00
gc cr block flush time50.000.00
gc cr block receive time8,4982.350.02
gc cr blocks received149,54141.370.38
gc cr blocks served20,0415.540.05
gc current block flush time20.000.00
gc current block pin time00.000.00
gc current block receive time2,2180.610.01
gc current blocks received47,77013.220.12
gc current blocks served51,07214.130.13
gc kbytes saved145,53440.260.37
gc kbytes sent423,393117.131.07
gc local grants71,44519.770.18
gc read wait time00.000.00
gc read wait timeouts00.000.00
gc read waits00.000.00
gc reader bypass grants2730.080.00
gc remote grants123,74934.240.31
gcs messages sent2,633,747728.626.64
ges messages sent30,5468.450.08
global enqueue get time1,4410.400.00
global enqueue gets async9230.260.00
global enqueue gets sync818,073226.322.06
global enqueue releases820,972227.122.07
heap block compress1500.040.00
hot buffers moved to head of LRU219,37560.690.55
immediate (CR) block cleanout applications3940.110.00
immediate (CURRENT) block cleanout applications6,4471.780.02
in call idle wait time15,831,3334,379.7239.94
index crx upgrade (positioned)5060.140.00
index crx upgrade (prefetch)00.000.00
index fast full scans (full)30.000.00
index fetch by key9,5242.630.02
index scans kdiixs19,527,4902,635.7724.04
leaf node 90-10 splits340.010.00
leaf node splits2,1150.590.01
lob reads00.000.00
lob writes350.010.00
lob writes unaligned350.010.00
logical read bytes from cache201,592,725,50455,770,451.36508,593.49
logons cumulative2,6510.730.01
max cf enq hold time10.000.00
messages received613,733169.791.55
messages sent613,733169.791.55
min active SCN optimization applied on CR00.000.00
no work - consistent read gets16,107,5774,456.1540.64
non-idle wait count3,755,2001,038.879.47
non-idle wait time113,86931.500.29
opened cursors cumulative624,736172.831.58
parse count (describe)30.000.00
parse count (failures)00.000.00
parse count (hard)800.020.00
parse count (total)349,43196.670.88
parse time cpu2,7670.770.01
parse time elapsed2,9390.810.01
physical read IO requests140,38538.840.35
physical read bytes1,150,033,920318,155.882,901.39
physical read total IO requests154,16342.650.39
physical read total bytes2,736,249,856756,981.136,903.22
physical read total multi block requests1,3260.370.00
physical reads140,38538.840.35
physical reads cache140,38538.840.35
physical reads cache prefetch00.000.00
physical reads direct00.000.00
physical reads direct (lob)00.000.00
physical reads direct temporary tablespace00.000.00
physical reads prefetch warmup00.000.00
physical write IO requests219,26460.660.55
physical write bytes3,503,661,056969,284.778,839.30
physical write total IO requests1,018,534281.782.57
physical write total bytes6,819,853,3121,886,706.4617,205.65
physical write total multi block requests4,4351.230.01
physical writes427,693118.321.08
physical writes direct90.000.00
physical writes direct (lob)00.000.00
physical writes direct temporary tablespace00.000.00
physical writes from cache427,684118.321.08
physical writes non checkpoint59,29916.410.15
pinned buffers inspected150.000.00
pinned cursors current20.000.00
prefetch clients - default00.000.00
prefetch warmup blocks aged out before use00.000.00
prefetched blocks aged out before use00.000.00
process last non-idle time3,6371.010.01
queries parallelized120.000.00
recovery blocks read00.000.00
recursive calls834,767230.942.11
recursive cpu usage2,7240.750.01
redo KB read1,352,611374.203.41
redo blocks checksummed by FG (exclusive)35,0429.690.09
redo blocks written906,455250.772.29
redo buffer allocation retries00.000.00
redo entries2,030,002561.605.12
redo log space requests00.000.00
redo log space wait time00.000.00
redo ordering marks11,9133.300.03
redo size714,605,104197,694.881,802.86
redo size for direct writes74,08820.500.19
redo subscn max counts40,69911.260.10
redo synch long waits290.010.00
redo synch poll writes00.000.00
redo synch polls00.000.00
redo synch time18,7665.190.05
redo synch time (usec)187,803,30251,955.62473.80
redo synch writes395,119109.311.00
redo wastage198,714,99254,974.33501.33
redo write broadcast ack count13,6143.770.03
redo write broadcast ack time29,589,4568,185.9074.65
redo write broadcast lgwr post count10.000.00
redo write time16,2864.510.04
redo writes392,890108.690.99
rollback changes - undo records applied230.010.00
rollbacks only - consistent read gets140.000.00
root node splits00.000.00
rows fetched via callback1,5110.420.00
scheduler wait time00.000.00
session connect time00.000.00
session cursor cache hits141,89839.260.36
session logical reads24,608,3806,807.8962.08
shared hash latch upgrades - no wait228,39263.180.58
shared hash latch upgrades - wait00.000.00
sorts (memory)3,2230.890.01
sorts (rows)19,6295.430.05
sql area evicted410.010.00
sql area purged00.000.00
summed dirty queue length2370.070.00
switch current to new buffer1,3550.370.00
table fetch by rowid779,610215.681.97
table fetch continued row1010.030.00
table scan blocks gotten33,8949.380.09
table scan rows gotten3,161,184874.547.98
table scans (long tables)00.000.00
table scans (short tables)1,9970.550.01
temp space allocated (bytes)00.000.00
total cf enq hold time6100.170.00
total number of cf enq holders1800.050.00
total number of times SMON posted240.010.00
transaction lock background gets00.000.00
transaction lock foreground requests00.000.00
transaction lock foreground wait time00.000.00
transaction rollbacks170.000.00
transaction tables consistent read rollbacks00.000.00
transaction tables consistent reads - undo records applied00.000.00
undo change vector size137,464,73638,029.50346.81
user I/O wait time75,49120.880.19
user calls2,042,241564.985.15
user commits395,042109.291.00
user rollbacks1,3310.370.00
workarea executions - onepass00.000.00
workarea executions - optimal7030.190.00
write clones created in background00.000.00
write clones created in foreground50.000.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session uga memory8,107,782,933,8808,107,933,565,280
opened cursors current2,7413,134
logons current791822
session uga memory max957,480,038,264958,022,345,360
session pga memory8,885,696,5448,954,880,024
session pga memory max11,765,849,31211,830,428,216
session cursor cache count2,976,0572,985,092

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived)21.99

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)
DBWR0M0.000M3.3G60.66.924284211.4K0.00
Others1.5G3.80.4185701.4G1.51.38509519.2K0.36
LGWR0M0.010M1.7G219.66.489945786K0.01
Buffer Cache Reads1.1G38.83.3034840M0.000M140.4K4.91
Direct Writes0M0.000M0M0.000M10.00
TOTAL:2.5G42.64.7220546.4G281.831.799321157K0.61

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 File1.1G39.03.3051433.3G60.79.9240084.88 
Log File1.3G0.37.3654531.7G219.65.4896680.822.95
Archive Log0M0.000M1.3G0.37.365453  
Control File187M3.24.05173357M1.02.0157690.002.25
TOTAL:2.5G42.64.7223306.3G281.821.794894.512.95

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)
DBWR 0M0.000M3.3G60.66.92428450.00
DBWR (Data File) 0M0.000M3.3G60.66.9242840 
DBWR (Control File) 0M0.000M0M0.000M50.00
Others 1.5G3.80.4182931.4G1.51.38509514.2K0.28
Others (Archive Log) 0M0.000M1.3G0.37.3654530 
Others (Log File) 1.3G0.37.3654530M0.000M13362.92
Others (Control File) 186M3.23.05145657M1.01.01576911.7K0.01
Others (Data File) 5M0.20.00138314M0.14.00387311980.00
LGWR 0M0.010M1.7G219.66.489945420.43
LGWR (Log File) 0M0.000M1.7G219.65.489668161.13
LGWR (Control File) 0M0.010M1M0.01.000276260.00
Buffer Cache Reads 1.1G38.83.3034840M0.000M140.4K4.91
Buffer Cache Reads (Data File) 1.1G38.83.3034840M0.000M140.4K4.91
Direct Writes 0M0.000M0M0.000M0 
Direct Writes (Data File) 0M0.000M0M0.000M0 
TOTAL: 2.5G42.64.7217776.4G281.821.79932154.6K4.48

Back to IO Stats
Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
TS_INDX_YTTRC 59,600165.451.00126,652352953.56
EXP_HIS_02_3 51,743145.211.0090,499251154.00
EXP_HIS_02_2 12,44035.471.00330224.55
EXP_HIS_01_2 4,88715.421.004000.00
EXP_HIS_01_1 3,06515.571.00100115.45
EXP_HIS_02_1 2,29615.191.0024010.00
EXP_HIS_12_3 1,75905.651.000000.00
EXP_HIS_01_3 1,50905.721.000000.00
UNDOTBS3 000.000.001,402030.00
EXP_HIS_12_2 1,30905.621.000000.00
EXP_HIS_12_1 63105.641.000000.00
SYSAUX 16404.511.00404000.00
EXP_HIS_11_3 37905.461.000045.00
EXP_HIS_11_2 32105.761.0000275.19
EXP_HIS_11_1 20605.291.000000.00
SYSTEM 1104.551.0076000.00
EXP_HIS_10_3 4105.371.000000.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)
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_001.dbf 66805.461.0000110.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_002.dbf 52405.741.000036.67
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_003.dbf 67305.591.000000.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_004.dbf 55805.521.000033.33
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_006.dbf 18005.721.000025.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_007.dbf 9106.481.0010000.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_008.dbf 205.001.000000.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_009.dbf 1010.001.000000.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_05.dbf 22105.161.000000.00
EXP_HIS_01_1+DATA_DG/querydb/datafile/exphis0101_06.dbf 14705.311.000025.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_001.dbf 77005.441.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_002.dbf 61205.421.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_003.dbf 65905.341.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_004.dbf 81405.451.004000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_005.dbf 70805.611.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_006.dbf 34605.521.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_007.dbf 32605.121.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_008.dbf 34805.341.000000.00
EXP_HIS_01_2+DATA_DG/querydb/datafile/exphis0102_009.dbf 30405.301.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_001.dbf 32505.451.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_002.dbf 31006.261.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_003.dbf 25105.941.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_004.dbf 30505.641.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_005.dbf 26705.471.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_006.dbf 1606.251.000000.00
EXP_HIS_01_3+DATA_DG/querydb/datafile/exphis0103_007.dbf 3504.291.000000.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/0201_006.dbf 34005.381.004000.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/0201_007.dbf 30905.181.0010010.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/exphis0201_001.dbf 24505.711.000000.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/exphis0201_002.dbf 37105.121.006000.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/exphis0201_003.dbf 27305.021.001000.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/exphis0201_004.dbf 34505.161.000000.00
EXP_HIS_02_1+DATA_DG/querydb/datafile/exphis0201_005.dbf 41304.941.003000.00
EXP_HIS_02_2+DATA_DG/querydb/datafile/0202_006.dbf 1,86915.431.007075.71
EXP_HIS_02_2+DATA_DG/querydb/datafile/0202_007.dbf 1,89515.551.000083.75
EXP_HIS_02_2+DATA_DG/querydb/datafile/exphis0202_001.dbf 1,74805.461.008000.00
EXP_HIS_02_2+DATA_DG/querydb/datafile/exphis0202_002.dbf 1,81115.331.009000.00
EXP_HIS_02_2+DATA_DG/querydb/datafile/exphis0202_003.dbf 1,76105.571.0030110.00
EXP_HIS_02_2+DATA_DG/querydb/datafile/exphis0202_004.dbf 1,59605.391.001030.00
EXP_HIS_02_2+DATA_DG/querydb/datafile/exphis0202_005.dbf 1,76005.521.005036.67
EXP_HIS_02_3+DATA_DG/querydb/datafile/0203_006.dbf 7,94725.281.009,514385.00
EXP_HIS_02_3+DATA_DG/querydb/datafile/0203_007.dbf 8,67925.171.0012,8524152.67
EXP_HIS_02_3+DATA_DG/querydb/datafile/exphis0203_001.dbf 6,78625.201.0013,1634151.33
EXP_HIS_02_3+DATA_DG/querydb/datafile/exphis0203_002.dbf 6,55725.231.0011,2183257.60
EXP_HIS_02_3+DATA_DG/querydb/datafile/exphis0203_003.dbf 6,39025.131.0023,046670.00
EXP_HIS_02_3+DATA_DG/querydb/datafile/exphis0203_004.dbf 7,10625.201.0011,0623263.85
EXP_HIS_02_3+DATA_DG/querydb/datafile/exphis0203_005.dbf 8,27825.251.009,6443193.68
EXP_HIS_10_3+DATA_DG/querydb/datafile/exphis1002_003.dbf 506.001.000000.00
EXP_HIS_10_3+DATA_DG/querydb/datafile/exphis1003_002.dbf 1104.551.000000.00
EXP_HIS_10_3+DATA_DG/querydb/datafile/exphis1003_004.dbf 1704.711.000000.00
EXP_HIS_10_3+DATA_DG/querydb/datafile/exphis1003_005.dbf 807.501.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_001.dbf 2905.521.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_002.dbf 2405.831.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_003.dbf 2205.451.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_004.dbf 1604.381.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_005.dbf 1007.001.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_006.dbf 2305.651.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_007.dbf 2204.551.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_008.dbf 2705.191.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_009.dbf 1605.001.000000.00
EXP_HIS_11_1+DATA_DG/querydb/datafile/exphis1101_010.dbf 1704.711.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_001.dbf 3604.721.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_002.dbf 2607.691.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_003.dbf 2106.671.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_004.dbf 4806.041.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_005.dbf 3105.811.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_006.dbf 2705.191.000082.50
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_007.dbf 3205.311.0000104.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_008.dbf 3406.471.000098.89
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_009.dbf 2906.211.000000.00
EXP_HIS_11_2+DATA_DG/querydb/datafile/exphis1102_010.dbf 3704.321.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_001.dbf 2504.801.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_002.dbf 4405.001.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_003.dbf 3705.411.000045.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_004.dbf 2907.591.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_005.dbf 5105.101.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_006.dbf 1904.741.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_007.dbf 3006.671.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_008.dbf 4205.001.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_009.dbf 4305.811.000000.00
EXP_HIS_11_3+DATA_DG/querydb/datafile/exphis1103_010.dbf 5905.081.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_001.dbf 5205.581.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_002.dbf 4305.581.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_003.dbf 4506.891.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_004.dbf 4705.531.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_005.dbf 4505.561.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_006.dbf 5105.691.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_007.dbf 8505.761.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_008.dbf 10805.091.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_009.dbf 9005.441.000000.00
EXP_HIS_12_1+DATA_DG/querydb/datafile/exphis1201_010.dbf 6506.001.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_001.dbf 15605.131.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_002.dbf 14306.431.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_003.dbf 15405.451.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_004.dbf 10206.271.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_005.dbf 12205.571.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_006.dbf 14805.611.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_007.dbf 13205.761.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_008.dbf 13905.541.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_009.dbf 10805.281.000000.00
EXP_HIS_12_2+DATA_DG/querydb/datafile/exphis1202_010.dbf 10505.241.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_001.dbf 20205.941.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_002.dbf 16205.251.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_003.dbf 17205.411.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_004.dbf 15505.481.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_005.dbf 19705.691.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_006.dbf 19406.031.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_007.dbf 16605.601.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_008.dbf 16605.301.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_009.dbf 17305.721.000000.00
EXP_HIS_12_3+DATA_DG/querydb/datafile/exphis1203_010.dbf 17205.871.000000.00
SYSAUX+DATA_DG/querydb/datafile/sysaux.261.822838405 16404.511.00404000.00
SYSTEM+DATA_DG/querydb/datafile/system.260.822838401 1104.551.0076000.00
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf001.dbf 3,01915.311.005,679261.67
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf002.dbf 3,08315.461.008,9422211.43
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf003.dbf 2,92315.291.0015,3164200.00
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf004.dbf 2,77515.501.009,9523223.64
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf005.dbf 2,56815.641.005,4782144.29
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf006.dbf 2,66315.551.006,9442132.31
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf007.dbf 2,85815.481.007,9572155.33
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf008.dbf 3,10515.441.0010,3433124.17
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf009.dbf 3,15715.321.004,245163.33
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf010.dbf 3,05215.521.004,6901224.55
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf011.dbf 2,96415.441.003,492172.86
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf012.dbf 3,30015.611.007,2922173.53
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf013.dbf 3,21315.411.003,8691102.00
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf014.dbf 3,00415.431.008,5632273.33
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf015.dbf 3,11015.411.007,2602247.50
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf016.dbf 2,94015.331.006,3482105.00
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf017.dbf 2,92515.411.003,3101144.29
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf018.dbf 3,10115.501.0076083.75
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf019.dbf 3,06015.511.002,1991142.86
TS_INDX_YTTRC+DATA_DG/querydb/datafile/yttrc_indx_dbf020.dbf 2,78015.571.004,6971133.08
UNDOTBS3+DATA_DG/querydb/datafile/undotbs3.265.822838419 00  1,402030.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
D4,839,0409924,608,411140,382427,68400478

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

MTTR WritesLog Size WritesLog Ckpt WritesOther Settings WritesAutotune Ckpt WritesThread Ckpt Writes
0000412,4850

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
B0828532613173152364246668315236  3
E0931588799724700754246668470075  3

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
D4,0960.104843.84586,25211798550.00
D8,1920.209682.87437,72411277858.00
D12,2880.301,4522.31352,6491979611.00
D16,3840.401,9361.94295,3151778617.00
D20,4800.502,4201.67254,1471634293.00
D24,5760.602,9031.45220,4531516173.00
D28,6720.703,3871.29196,8571433453.00
D32,7680.803,8711.17177,7281366393.00
D36,8640.904,3551.07163,2951315795.00
D40,9601.004,8391.00152,5291278053.00
D45,0561.105,3230.95144,6261250347.00
D49,1521.205,8070.91138,7691229816.00
D53,2481.306,2910.88134,1931213773.00
D57,3441.406,7750.85130,3421200272.00
D61,4401.507,2590.83127,2141189308.00
D65,5361.607,7420.81124,2181178801.00
D69,6321.708,2260.80121,7651170204.00
D73,7281.808,7100.78119,6301162720.00
D77,8241.909,1940.77117,7201156024.00
D81,9202.009,6780.76115,9381149775.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00750

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B10,2407,6602,239.910.000.000.000.001,048,570
E10,2407,5992,309.000.000.000.000.001,048,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K4K61761700
64K128K141400
256K512K2200
512K1024K464600
1M2M222200
4M8M2200

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,2800.13643,741.3372,673.4490.005,7610
2,5600.25643,741.3314.64100.0000
5,1200.50643,741.3314.64100.0000
7,6800.75643,741.3314.64100.0000
10,2401.00643,741.3314.64100.0000
12,2881.20643,741.330.00100.0000
14,3361.40643,741.330.00100.0000
16,3841.60643,741.330.00100.0000
18,4321.80643,741.330.00100.0000
20,4802.00643,741.330.00100.0000
30,7203.00643,741.330.00100.0000
40,9604.00643,741.330.00100.0000
61,4406.00643,741.330.00100.0000
81,9208.00643,741.330.00100.0000

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)
4,0961.0048414,0732,652,7411.0017,4591.00155,266
4,2241.0361116,9932,653,2501.0016,9500.97155,329
4,3521.0673919,7692,653,4461.0016,7540.96155,354
4,4801.0986722,4072,653,6271.0016,5730.95155,378
4,6081.1399425,0232,653,7851.0016,4150.94155,399
4,7361.161,12227,7872,653,9361.0016,2640.93155,417
4,8641.191,25030,8292,654,0441.0016,1560.93155,430
4,9921.221,37833,8502,654,1291.0016,0710.92155,442
5,1201.251,50636,6522,654,2231.0015,9770.92155,455
5,2481.281,63439,4932,654,2981.0015,9020.91155,465
5,6321.382,01851,0362,654,4691.0015,7310.90155,489
6,1441.502,53069,4852,654,6341.0015,5660.89155,511
6,6561.633,04287,9342,654,7681.0015,4320.88155,527
7,1681.753,554103,6122,654,8861.0015,3140.88155,540
7,6801.884,066115,9902,654,9491.0015,2510.87155,548
8,1922.004,578128,3682,654,9981.0015,2020.87155,553

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block47424
1st level bmb1010
undo header300

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
CO-KTUCLO Master Slave enq (master slave det) 1,20001,2001,20010.74
FB-Format Block 2,0262,02601,21510.48
WF-AWR Flush 2222017020.65
CF-Controlfile Transaction 7,7027,702012900.63
TT-Tablespace 546546023000.27
PS-PX Process Reservation 13213207300.45
TX-Transaction (index contention) 12120901.78
TQ-Queue table enqueue (TM contention) 12212201300.77
TD-KTF map table enqueue (KTF dump entries) 880801.25
TM-DML 795,628795,62002200.27
HW-Segment High Water Mark 7117110600.83
US-Undo Segment 12120600.83
JS-Job Scheduler (job run lock - synchronize) 220201.00
CR-Reuse Block Range (block range reuse ckpt) 4024020300.33
AF-Advisor Framework (task serialization) 13130200.50
DR-Distributed Recovery 220200.50
MW-MWIN Schedule 220200.50
WL-Being Written Redo Log 220101.00
TA-Instance Undo 11110500.00
CT-Block Change Tracking (state) 110100.00
FD-Flashback Database (Flashback logical operations) 110100.00
MV-Online Datafile Move (datafile move) 110100.00
SW-Suspend Writes 110100.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
516.37334,167961515/31.10/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
27-Feb 08:493,43570,3329615310/00/0/0/0/0/0
27-Feb 08:393,48070,3073544240/00/0/0/0/0/0
27-Feb 08:293,33468,573354180/00/0/0/0/0/0
27-Feb 08:193,13265,7163524240/00/0/0/0/0/0
27-Feb 08:092,98659,23904150/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 latch10.00 00 
AQ dequeue txn counter latch8320.00 00 
ASM Keyed state latch5,1830.00 00 
ASM allocation3510.00 00 
ASM db client latch2,8660.00 00 
ASM map headers1000.00 00 
ASM map load waiting list250.00 00 
ASM map operation freelist1670.00 00 
ASM map operation hash table2,402,1900.000.2000 
ASM network background latch1,6530.00 00 
ASM network state latch4400.00 00 
AWR Alerted Metric Element list80,8690.00 00 
Change Notification Hash table latch1,2010.00 00 
Consistent RBA392,8870.001.0000 
DML lock allocation1,591,2160.000.0600 
Event Group Locks5,2590.00 00 
FAL Queue1000.00 00 
FIB s.o chain latch220.00 00 
FOB s.o list latch8,4650.00 00 
File State Object Pool Parent Latch10.00 00 
I/O Staticstics latch10.00 00 
IPC other latch300.00 00 
IPC stats buffer allocation latch5,4390.00 05,6330.00
In memory undo latch10.00 00 
JS Sh mem access90.00 00 
JS broadcast add buf latch8340.00 00 
JS broadcast drop buf latch8340.00 00 
JS broadcast load blnc latch7230.00 00 
JS mem alloc latch40.00 00 
JS queue access latch50.00 00 
JS queue state obj latch30,7380.00 00 
JS slv state obj latch90.00 00 
KFC FX Hash Latch10.00 00 
KFC Hash Latch10.00 00 
KFCL LE Freelist10.00 00 
KFK SGA Libload latch6540.00 00 
KFMD SGA10.00 00 
KGNFS-NFS:SHM structure10.00 00 
KGNFS-NFS:SVR LIST10.00 00 
KJC message pool free list42,2980.020.0004,7720.00
KJCT flow control latch3,765,0730.000.1700 
KMG MMAN ready and startup request latch1,2010.00 00 
KSXR large replies30.00 00 
KTF sga latch270.00 01,1440.00
KWQMN job cache list latch8130.00 00 
KWQS pqsubs latch60.00 00 
KWQS pqueue ctx latch40.00 00 
Locator state objects pool parent latch10.00 00 
Lsod array latch33,8170.00 00 
MQL Tracking Latch0  0700.00
Memory Management Latch10.00 01,2010.00
Memory Queue10.00 00 
Memory Queue Message Subscriber #110.00 00 
Memory Queue Message Subscriber #210.00 00 
Memory Queue Message Subscriber #310.00 00 
Memory Queue Message Subscriber #410.00 00 
Memory Queue Subscriber10.00 00 
MinActiveScn Latch1,2800.00 00 
Mutex10.00 00 
Mutex Stats10.00 00 
OS process10,4560.00 00 
OS process allocation12,1630.00 00 
OS process: request allocation5,1830.00 00 
PL/SQL warning settings2,7690.00 00 
PX hash array latch10.00 00 
QMT10.00 00 
Real-time plan statistics latch16,5600.00 00 
Reserved Space Latch80.00 00 
SGA IO buffer pool latch40.00 040.00
SGA blob parent10.00 00 
SGA bucket locks10.00 00 
SGA heap locks10.00 00 
SGA pool locks10.00 00 
SQL memory manager latch10.00 01,2010.00
SQL memory manager workarea list latch80,9310.00 00 
Shared B-Tree4350.00 00 
Streams Generic10.00 00 
Testing10.00 00 
Token Manager10.00 00 
WCR: sync10.00 00 
Write State Object Pool Parent Latch10.00 00 
X$KSFQP10.00 00 
XDB NFS Security Latch10.00 00 
XDB unused session pool10.00 00 
XDB used session pool10.00 00 
active checkpoint queue latch221,0290.040.2800 
active service list21,5380.00 04,9810.00
alert log latch40.00 00 
archive control660.00 00 
archive process latch3020.331.0000 
begin backup scn array10.00 00 
buffer pool10.00 00 
business card250.00 00 
cache buffer handles32,4760.00 00 
cache buffers chains53,075,5220.000.480430,3920.00
cache buffers lru chain566,5370.020.1701,045,9190.02
call allocation10,5800.00 00 
cas latch10.00 00 
change notification client cache latch10.00 00 
channel handle pool latch5,1980.00 00 
channel operations parent latch709,4330.000.0000 
checkpoint queue latch6,080,6460.010.090438,2150.00
client/application info3,1800.00 00 
compile environment latch2,6510.00 00 
corrupted undo seg latch860.00 00 
cp cmon/server latch10.00 00 
cp pool latch10.00 00 
cp server hash latch10.00 00 
cp sga latch580.00 00 
cvmap freelist lock10.00 00 
deferred cleanup latch580.00 00 
dml lock allocation580.00 00 
done queue latch10.00 00 
dummy allocation5,2720.00 00 
enqueue freelist latch10.00 0104,4960.00
enqueue hash chains4,096,3240.010.12020.00
enqueues40.00 00 
error message lists720.00 00 
fifth spare latch10.00 00 
file cache latch4,6120.00 00 
flashback copy10.00 00 
fourth Audit Vault latch10.00 00 
gc element2,469,5260.050.09022,6560.01
gcs commit scn state10.00 00 
gcs opaque info freelist77,4880.000.0000 
gcs partitioned table hash34,720,5290.000.00016,1970.00
gcs pcm hashed value bucket hash10.00 00 
gcs remaster request queue10.00 00 
gcs remastering latch12,312,8190.500.0001,0333.29
gcs resource freelist311,7750.000.080195,6230.00
gcs resource hash21,314,6050.010.0100 
gcs resource scan list10.00 00 
gcs shadows freelist216,8190.000.330213,1430.00
ges caches resource lists692,7530.020.07069,7710.02
ges deadlock list9540.00 010.00
ges domain table1,637,1840.000.0000 
ges enqueue table freelist1,672,6760.010.1000 
ges group table1,634,9460.000.0000 
ges process hash list42,2400.001.0000 
ges process parent latch3,327,2540.00 00 
ges process table freelist5,1830.00 00 
ges resource hash list2,612,5160.040.97017,1720.00
ges resource scan list210.00 00 
ges resource table freelist28,6300.000.0000 
ges timeout list1,6660.00 03890.00
ges value block free list90.00 00 
global KZLD latch for mem in SGA2530.00 00 
global tx hash mapping10.00 00 
granule operation10.00 00 
hash table column usage latch910.00 01,1430.00
hash table modification latch6240.00 00 
heartbeat check10.00 01,0200.00
heartbeat structure management0  07210.00
internal temp table object number allocation latch30.00 00 
interrupt manipulation3480.00 00 
intra txn parallel recovery10.00 00 
io pool granule metadata list10.00 00 
job workq parent latch30.00 020.00
job_queue_processes free list latch40.00 00 
job_queue_processes parameter latch7910.00 00 
k2q global data latch2,4020.00 00 
k2q lock allocation10.00 00 
kcbtsemkid latch20.00 00 
kdlx hb parent latch10.00 00 
kgb parent10.00 00 
kgnfs mount latch10.00 00 
kokc descriptor allocation latch40.00 00 
ksfv messages10.00 00 
ksim group membership cache2080.00 00 
ksim membership request latch0  02,3460.00
kss move lock410.00 00 
ksuosstats global area3640.00 00 
ksv allocation latch1410.00 00 
ksv class latch8,2010.00 00 
ksv instance latch180.00 00 
ksv msg queue latch170.00 0160.00
ksxp shared latch5,1830.00 00 
ksxp so latch5,1830.00 00 
ksz_so allocation latch5,1830.00 00 
ktm global data1100.00 00 
kwqbsn:qsga1260.00 00 
lgwr LWN SCN393,0620.000.5000 
list of block allocation4030.00 00 
loader state object freelist20.00 00 
lob segment dispenser latch10.00 00 
lob segment hash table latch130.00 00 
lob segment query latch10.00 00 
lock DBA buffer during media recovery10.00 00 
logical standby cache10.00 00 
logminer context allocation10.00 00 
logminer work area10.00 00 
longop free list parent10.00 00 
managed standby latch980.00 00 
mapped buffers lru chain10.00 00 
message pool operations parent latch8,7710.00 00 
messages2,525,3880.090.0200 
mostly latch-free SCN394,3840.170.0500 
msg queue latch10.00 00 
multiblock read objects1700.00 00 
name-service memory objects40,9400.00 00 
name-service namespace bucket38,5450.00 00 
name-service pending queue15,5740.00 00 
name-service request queue70,0900.00 00 
ncodef allocation latch580.00 00 
object queue header heap109,3860.00 0111,5290.00
object queue header operation12,514,2410.060.3700 
object stats modification796,4930.010.0100 
parallel query alloc buffer9970.00 00 
parallel query stats790.00 00 
parallel txn reco latch4,3560.00 00 
parameter list9,4280.00 00 
parameter table management5,4690.00 00 
peshm10.00 00 
pesom_free_list10.00 00 
pesom_hash_node10.00 00 
post/wait queue669,2910.010.110449,5560.01
process allocation21,3990.011.0002,6070.00
process group creation5,1830.00 00 
process queue2410.00 00 
process queue reference4,3380.00 03900.00
qmn state object latch60.00 00 
qmn task context latch60.00 00 
qmn task queue latch55117.601.0000 
query server freelists1810.00 00 
query server process60.00 00 
queued dump request120.00 00 
queuing load statistics10.00 00 
recovery domain hash list10.00 00 
redo allocation1,184,4650.070.2502,028,2700.21
redo copy10.00 02,029,9040.14
redo writing1,406,2410.020.1000 
reservation so alloc latch40.00 00 
resmgr group change latch1050.00 00 
resmgr:active threads5,2720.00 00 
resmgr:actses change group1140.00 00 
resmgr:actses change state10.00 00 
resmgr:free threads list5,2710.00 00 
resmgr:plan CPU method10.00 00 
resmgr:resource group CPU method10.00 00 
resmgr:schema config810.00 00 
resmgr:session queuing10.00 00 
rm cas latch10.00 00 
row cache objects113,6260.000.670760.00
second Audit Vault latch10.00 00 
second spare latch10.00 00 
segmented array pool220.00 00 
sequence cache7,9890.00 00 
session allocation798,5310.000.000793,3310.00
session idle bit4,875,0710.000.1600 
session queue latch10.00 00 
session state list latch4640.00 00 
session switching2,6350.00 00 
session timer1,1990.00 00 
shared pool335,0650.010.10070.00
shared pool sim alloc30.00 00 
shared pool simulator2610.00 00 
sim partition latch10.00 00 
simulator hash latch1,543,5380.000.2500 
simulator lru latch10.00 01,530,8010.02
sort extent pool1460.00 00 
space background state object latch70.00 00 
space background task latch5,0430.810.5102,4080.00
state object free list20.00 00 
statistics aggregation8400.00 00 
tablespace key chain10.00 00 
temp lob duration state obj allocation20.00 00 
test excl. parent l010.00 00 
test excl. parent2 l010.00 00 
third spare latch10.00 00 
threshold alerts latch8520.00 00 
transaction allocation1,6020.00 00 
undo global data1,222,7880.000.0500 
virtual circuit buffers10.00 00 
virtual circuit holder10.00 00 
virtual circuit queues10.00 00 

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin Gets
object queue header operation12,514,2417,1922,6694,581
gcs resource hash21,314,6052,690202,670
messages2,525,3882,304412,264
ges resource hash list2,612,5161,1681,13039
gc element2,469,5261,1191011,019
redo allocation1,184,465864217647
checkpoint queue latch6,080,64684874774
mostly latch-free SCN394,38468031650
enqueue hash chains4,096,32446854414
redo writing1,406,24126225237
cache buffers chains53,075,522239114132
KJCT flow control latch3,765,07318030152
ges caches resource lists692,7531359126
cache buffers lru chain566,5371162096
object stats modification796,4931071106
ges enqueue table freelist1,672,676971087
qmn task queue latch55197970
active checkpoint queue latch221,029852461
session idle bit4,875,071751263
space background task latch5,043412120
post/wait queue669,29136432
shared pool335,06529327
undo global data1,222,78821120
DML lock allocation1,591,21618117
gcs resource freelist311,77512111
lgwr LWN SCN393,062633
ASM map operation hash table2,402,190514
Consistent RBA392,887550
simulator hash latch1,543,538413
gcs shadows freelist216,819312
process allocation21,399330
row cache objects113,626322
archive process latch302110
ges process hash list42,240110

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
ASM map operation hash tablekffmTranslate010
DML lock allocationktaidm010
KJCT flow control latchkjctcsnd: send normal message02127
KJCT flow control latchkjcts_sedeqv2: dequeue a vector of msgs040
KJCT flow control latchkjctr_updatetkt: update ticket info032
KJCT flow control latchkjcts_sqenq: queue a message020
PC and Classifier lists for WLMNo latch080
active checkpoint queue latchkcbbacq: scan active checkpoints02424
archive process latchkcrrsarc010
cache buffers chainskcbgtcr_208684
cache buffers chainskclwrt0180
cache buffers chainskcbbxsv0826
cache buffers chainskcbzib: finish processing buffer031
cache buffers chainskclbla030
cache buffers chainskcbget: pin buffer023
cache buffers chainskcbchg1: clear MS bit010
cache buffers chainskcbrls_2011
cache buffers lru chainkcbzgws0150
cache buffers lru chainkcbbic20220
cache buffers lru chainkclmvreqbg020
cache buffers lru chainkcbbxsv: move to being written010
checkpoint queue latchkcbkubc_40679
checkpoint queue latchkcbbwthc: thread checkpoint buffers0465
checkpoint queue latchkcbbwdl: thread checkpoint queue020
checkpoint queue latchkcbklbc_cql010
enqueue hash chainsksqgtl302616
enqueue hash chainsksqrcl01938
enqueue hash chainsksqcmi: if lk mode requested050
enqueue hash chainsksqcmi: if lk mode not requested040
gc elementkclnfndnewm0363
gc elementkclfwrite102829
gc elementkclrwrite02037
gc elementkclbla072
gc elementkclulb0712
gc elementkclwrt070
gc elementKCLUNLNK027
gc elementkcllwr020
gc elementkclplz0217
gc elementkclrlstp020
gc elementkcl_fairness010
gc elementkclchkping010
gc elementkclfwrite2010
gc elementkclpdc_21010
gc elementkclplz_1016
gc elementkclrwrite_10010
gcs resource freelistkjbralc add resource010
gcs resource hashkjbrrcfwst041
gcs resource hashkclfwrite1034
gcs resource hashkjbmdowncvt032
gcs resource hashkjbmpclose030
gcs resource hashkjbcrcomplete024
gcs resource hashkjbrdrmcvtq_98020
gcs resource hashkclrwrite011
gcs resource hashkjbassume012
gcs resource hashkjbmpcreatepi010
gcs shadows freelistkjblfr free lock011
ges enqueue table freelistkjlfr: remove lock from parent object065
ges enqueue table freelistkjlalc: lock allocation045
ges process hash listkjakiqa: set inquiry response010
ges resource hash listkjakcai: search for resp by resname01,0163
ges resource hash listkjlmfnd: search for lockp by rename and inst id01080
ges resource hash listkjrmas1: lookup master node030
ges resource hash listkjakoca: search for resp by resname01469
ges resource hash listkjcvscn: remove from scan queue010
ges resource hash listkjrref: find matched resource012
ges resource table freelistkjchc: clean resource cache050
ges resource table freelistkjrm2c: move resource to cache029
ges resource table freelistkjruch: cached obj cleanup020
lgwr LWN SCNkcs0230210
messagesksaamb: after wakeup02726
messagesksarcv01212
messagesksarcv: after wait023
mostly latch-free SCNkcslcu301034
mostly latch-free SCNkcsnew_scn_rba050
mostly latch-free SCNkcs024030
object queue header operationkcldbufs02,788362
object queue header operationkcbo_link_q0231534
object queue header operationkcbo_switch_q_bg0180585
object queue header operationkcbo_unlink_q0119380
object queue header operationkcbo_switch_cq061449
object queue header operationkcbo_switch_mq_bg038953
object queue header operationkclbufs0314
object queue header operationkcbo_unlink_q_bg0340
object queue header operationkcbo_link_q:reget02147
object queue header operationkcbo_sw_buf011
object queue header operationkclobj_1010
object stats modificationksoslinentry011
post/wait queueksliwat:add:nowait030
post/wait queuekslpstevent:get014
process allocationksufap: active procs030
qmn task queue latchkwqmnmvtsks: delay to ready list0920
qmn task queue latchkwqmnaddtsk: add task050
redo allocationkcrfw_redo_gen: redo allocation 102160
redo allocationkcrfw_redo_gen: redo allocation 2010
redo writingkcrfwcr02223
redo writingkcrfw_post: rba scn pair020
redo writingkcrfw_post: after write012
row cache objectskqrbgl010
row cache objectskqrigt010
session idle bitksupuc: set busy092
session idle bitksupuc: clear busy023
session idle bitksuxds017
shared poolkghfre030
simulator hash latchkcbsacc: lookup dba011
space background task latchktsj_grab_task01321
undo global dataktudba: KSLBEGIN010

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

Mutex TypeLocationSleepsWait Time (ms)
Library Cachekglget1 130
Library Cachekglhdgn2 10630
Library Cachekgllkdl1 8530
Library Cachekglpndl1 9520
Library Cachekglpin1 410

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
YTTRCTS_INDX_YTTRCIDX01_T_EXP_PACKAGE_TRACEPAR_2014_02_06INDEX PARTITION58,7840.24
SYSSYSAUXWRH$_SEG_STAT_OBJ_PK INDEX20,0000.08
YTTRCEXP_HIS_02_3T_EXP_PACKAGE_TRACEPAR_2014_02_06TABLE PARTITION18,6560.08
SYSSYSTEMRECYCLEBIN$ TABLE13,4400.05
YTTRCEXP_HIS_02_3T_EXP_TRACE_978PAR_2014_02_06TABLE PARTITION12,4000.05

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
YTTRCEXP_HIS_02_3T_EXP_TRACE_708PAR_2014_02_05TABLE PARTITION1350.10
YTTRCEXP_HIS_02_3T_EXP_TRACE_864PAR_2014_02_06TABLE PARTITION840.06
YTTRCEXP_HIS_02_3T_EXP_TRACE_901PAR_2014_02_06TABLE PARTITION810.06
YTTRCEXP_HIS_02_3T_EXP_TRACE_854PAR_2014_02_06TABLE PARTITION650.05
YTTRCEXP_HIS_02_3T_EXP_TRACE_622PAR_2014_02_05TABLE PARTITION640.05

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Read Requests%Total
YTTRCEXP_HIS_02_3T_EXP_TRACE_708PAR_2014_02_05TABLE PARTITION1350.10
YTTRCEXP_HIS_02_3T_EXP_TRACE_864PAR_2014_02_06TABLE PARTITION840.06
YTTRCEXP_HIS_02_3T_EXP_TRACE_901PAR_2014_02_06TABLE PARTITION810.06
YTTRCEXP_HIS_02_3T_EXP_TRACE_854PAR_2014_02_06TABLE PARTITION650.05
YTTRCEXP_HIS_02_3T_EXP_TRACE_622PAR_2014_02_05TABLE PARTITION640.05

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeUnOptimized Reads%Total
YTTRCEXP_HIS_02_3T_EXP_TRACE_708PAR_2014_02_05TABLE PARTITION1350.10
YTTRCEXP_HIS_02_3T_EXP_TRACE_864PAR_2014_02_06TABLE PARTITION840.06
YTTRCEXP_HIS_02_3T_EXP_TRACE_901PAR_2014_02_06TABLE PARTITION810.06
YTTRCEXP_HIS_02_3T_EXP_TRACE_854PAR_2014_02_06TABLE PARTITION650.05
YTTRCEXP_HIS_02_3T_EXP_TRACE_622PAR_2014_02_05TABLE PARTITION640.05

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Writes%Total
YTTRCTS_INDX_YTTRCIDX01_T_EXP_PACKAGE_TRACEPAR_2014_02_06INDEX PARTITION5,6481.32
YTTRCEXP_HIS_02_3T_EXP_PACKAGE_TRACEPAR_2014_02_06TABLE PARTITION1,7830.42
YTTRCEXP_HIS_02_3T_EXP_TRACE_994PAR_2014_02_06TABLE PARTITION1,4330.34
YTTRCEXP_HIS_02_3T_EXP_TRACE_871PAR_2014_02_06TABLE PARTITION1,3570.32
YTTRCEXP_HIS_02_3T_EXP_TRACE_821PAR_2014_02_06TABLE PARTITION1,3090.31

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

OwnerTablespace NameObject NameSubobject NameObj. TypePhys Write Requests%Total
YTTRCTS_INDX_YTTRCIDX01_T_EXP_PACKAGE_TRACEPAR_2014_02_06INDEX PARTITION4,9902.28
YTTRCEXP_HIS_02_3T_EXP_PACKAGE_TRACEPAR_2014_02_06TABLE PARTITION7010.32
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_854PAR_2014_02_06INDEX PARTITION6300.29
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_878PAR_2014_02_06INDEX PARTITION6190.28
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_812PAR_2014_02_06INDEX PARTITION6140.28

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

OwnerTablespace NameObject NameSubobject NameObj. TypeDirect Writes%Total
SYSSYSAUXWRH$_ACTIVE_SESSION_HISTORYWRH$_ACTIVE_1813880573_2878TABLE PARTITION9100.00

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

OwnerTablespace NameObject NameSubobject NameObj. TypeDB Block Changes% of Capture
YTTRCTS_INDX_YTTRCIDX01_T_EXP_PACKAGE_TRACEPAR_2014_02_06INDEX PARTITION15,7125.99
YTTRCEXP_HIS_02_3T_EXP_PACKAGE_TRACEPAR_2014_02_06TABLE PARTITION8,3363.18
YTTRCEXP_HIS_02_3T_EXP_TRACE_868PAR_2014_02_06TABLE PARTITION4,8961.87
YTTRCEXP_HIS_02_3T_EXP_TRACE_821PAR_2014_02_06TABLE PARTITION4,8801.86
YTTRCEXP_HIS_02_3T_EXP_TRACE_927PAR_2014_02_06TABLE PARTITION4,8001.83

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_812PAR_2014_02_06INDEX PARTITION250.00
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_693PAR_2014_02_06INDEX PARTITION125.00
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_854PAR_2014_02_06INDEX PARTITION125.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_588PAR_2014_02_06INDEX PARTITION220.00
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_639PAR_2014_02_06INDEX PARTITION220.00
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_659PAR_2014_02_06INDEX PARTITION220.00
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_513PAR_2014_02_06INDEX PARTITION110.00
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_548PAR_2014_02_06INDEX PARTITION110.00

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_609PAR_2014_02_06INDEX PARTITION4850.32
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_681PAR_2014_02_06INDEX PARTITION4800.32
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_521PAR_2014_02_06INDEX PARTITION4600.31
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_548PAR_2014_02_06INDEX PARTITION4600.31
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_604PAR_2014_02_06INDEX PARTITION4600.31

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
YTTRCTS_INDX_YTTRCIDX01_T_EXP_PACKAGE_TRACEPAR_2014_02_06INDEX PARTITION2,2704.75
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_681PAR_2014_02_06INDEX PARTITION830.17
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_638PAR_2014_02_06INDEX PARTITION790.17
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_642PAR_2014_02_06INDEX PARTITION790.17
YTTRCTS_INDX_YTTRCIDX01_T_EXP_TRACE_680PAR_2014_02_06INDEX PARTITION780.16

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control650.000 21
dc_global_oids70.000 042
dc_histogram_data1,2374.530 016,215
dc_histogram_defs8188.800 026,036
dc_objects3,9860.300 03,856
dc_profiles510.000 01
dc_rollback_segments7,7710.000 0398
dc_segments1,61924.090 1558,088
dc_sequences955.560 94
dc_tablespaces2,4570.000 068
dc_users15,0210.000 0107
global database name3,3260.000 01
outstanding_alerts38898.970 02
sch_lj_oids40.000 09

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control400
dc_histogram_defs72025
dc_objects12211
dc_segments42094,841
dc_sequences1830
outstanding_alerts7683840

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
ACCOUNT_STATUS1020.000 00
BODY290.001400.0000
DBLINK2,7370.000 00
EDITION660.001170.0000
INDEX819.888116.0550
QUEUE1,0460.001,1100.0000
SCHEMA2,4820.000 00
SQL AREA349,3080.01729,9230.02560
SQL AREA BUILD8354.220 00
SQL AREA STATS7681.587681.5800
TABLE/PROCEDURE2,7610.006,3041.27300
TRANSFORMATION3560.003560.0000

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
ACCOUNT_STATUS1020000
BODY013813800
DBLINK2,7370000
EDITION66666600
INDEX81818100
QUEUE5281,1101,11000
SCHEMA2,4820000
TABLE/PROCEDURE4045,8585,85800
TRANSFORMATION35635635600

Back to Library Cache Statistics
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 cache40,960.0040,960.0040,960.0040,960.000INI/
KEEP buffer cache0.000.000.000.000STA/
PGA Target10,240.0010,240.0010,240.0010,240.000STA/
RECYCLE buffer cache0.000.000.000.000STA/
SGA Target0.000.000.000.000STA/
Shared IO Pool0.000.000.000.000STA/
java pool1,024.001,024.001,024.001,024.000STA/
large pool1,024.001,024.001,024.001,024.000STA/
shared pool4,096.004,096.004,096.004,096.000STA/
streams pool0.000.000.000.000STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
BOther2,080.10 2.626.29121121794794
Freeable139.880.000.320.6910 438438
SQL18.892.650.020.0205759752
PL/SQL1.750.380.000.0000792791
EOther2,151.63 2.616.17121121825825
Freeable135.190.000.310.659 439439
SQL21.112.790.030.0205789782
PL/SQL1.810.390.000.0000823822

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers42,949,672,960 
Fixed Size2,193,928 
Redo Buffers45,727,744 
Variable Size6,442,452,472 

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
javafree memory1,024.001,024.000.00
largefree memory1,023.631,023.630.00
sharedFileOpenBlock112.00112.000.00
sharedKGLH0195.77195.990.11
sharedKKSSP51.7855.336.87
sharedKQR L PO87.2682.85-5.06
sharedSQLA356.34356.690.10
shareddb_block_hash_buckets356.00356.000.00
sharedfree memory217.42216.71-0.33
sharedgc name table96.0096.000.00
sharedgcs resources1,072.131,072.130.00
sharedgcs shadows625.41625.410.00
sharedges enqueues91.8191.810.00
sharedges resource90.6590.650.00
sharedobject queue69.1869.180.00
 buffer_cache40,960.0040,960.000.00
 fixed_sga2.092.090.00
 log_buffer43.6143.610.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

Shared Server Statistics

Back to Top

Shared Servers Activity

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

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

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

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

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

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

NameAvg ConnsTotal Disp Time (s)%Busy%IdleTotal QueuedTotal Queue Wait (s)Avg Queue Wait (ms)
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
D0000.003,6140.00100.0000 
Sum0.00   00 
Avg0.00 0.00100.0000 
Std0.00 0.000.0000 

Back to Shared Server Statistics
Back to Top

init.ora Parameters

Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest/u01/app/oracle/admin/querydb/adump  
audit_trailDB  
cluster_databaseTRUE  
compatible11.2.0.0.0  
control_files+DATA_DG/querydb/control01.ctl, +DATA_DG/querydb/control02.ctl  
db_block_size8192  
db_cache_size42949672960  
db_domain    
db_files1000  
db_namequerydb  
db_recovery_file_dest+DATA_DG  
db_recovery_file_dest_size1099511627776  
diagnostic_dest/u01/app/oracle  
dispatchers(PROTOCOL=TCP) (SERVICE=querydbXDB)  
instance_number3  
java_pool_size1073741824  
large_pool_size1073741824  
local_listener(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.194.206)(PORT=1521))))  
open_cursors300  
pga_aggregate_target10737418240  
processes2000  
remote_listenerquerydb-scan:1521  
remote_login_passwordfileEXCLUSIVE  
service_namesyttrc3  
session_cached_cursors128  
sessions3024  
shared_pool_size4294967296  
spfile+DATA_DG/querydb/spfilequerydb.ora  
thread3  
timed_statisticsTRUE  
undo_tablespaceUNDOTBS3  

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

Parameter NameBegin valueEnd value (if different)
control_files+DATA_DG/querydb/control01.ctl  
+DATA_DG/querydb/control02.ctl  

Back to init.ora Parameters
Back to Top

Global Messaging Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual)1,285,688355.683.24
acks for commit broadcast(logical)1,358,080375.713.43
broadcast msgs on commit(actual)762,246210.871.92
broadcast msgs on commit(logical)785,922217.421.98
broadcast msgs on commit(wasted)8,9222.470.02
dynamically allocated gcs resources00.000.00
dynamically allocated gcs shadows00.000.00
flow control messages received00.000.00
flow control messages sent10.000.00
gcs apply delta00.000.00
gcs assume cvt00.000.00
gcs assume no cvt17,8224.930.04
gcs ast xid10.000.00
gcs blocked converts15,9784.420.04
gcs blocked cr converts54,21915.000.14
gcs compatible basts1530.040.00
gcs compatible cr basts (global)3,6171.000.01
gcs compatible cr basts (local)21,4105.920.05
gcs cr basts to PIs00.000.00
gcs cr serve without current lock00.000.00
gcs dbwr flush pi msgs9,5882.650.02
gcs dbwr write request msgs7,8672.180.02
gcs delta msgs sent00.000.00
gcs delta push aborted by cancel00.000.00
gcs delta push aborted by remastering00.000.00
gcs delta push cancelled00.000.00
gcs delta push cancelled at master00.000.00
gcs delta push cancelled by close00.000.00
gcs delta push cancelled by consign00.000.00
gcs delta push cancelled by cvt ping00.000.00
gcs delta push cancelled by dwncvt00.000.00
gcs delta push create pi00.000.00
gcs delta update master msgs sent00.000.00
gcs delta wait aborted by remastering00.000.00
gcs delta wait cancelled00.000.00
gcs error msgs00.000.00
gcs force cr block only50.000.00
gcs force cr grant80.000.00
gcs force cr no current00.000.00
gcs forward cr to pinged instance00.000.00
gcs immediate (compatible) converts18,8445.210.05
gcs immediate (null) converts72,98720.190.18
gcs immediate cr (compatible) converts00.000.00
gcs immediate cr (null) converts175,44748.540.44
gcs indirect ast168,57846.640.43
gcs indirect bidless ast3410.090.00
gcs indirect fg ast168,57846.640.43
gcs lms flush pi msgs800.020.00
gcs lms write request msgs7,5812.100.02
gcs msgs process time(ms)18,6385.160.05
gcs msgs received2,693,361745.126.80
gcs new served by master60,29016.680.15
gcs out-of-order msgs00.000.00
gcs pings refused30.000.00
gcs pkey conflicts retry00.000.00
gcs push delta00.000.00
gcs queued converts00.000.00
gcs reader bypass N->Xw ping local40.000.00
gcs reader bypass N->Xw ping remote00.000.00
gcs reader bypass grant X on assume40.000.00
gcs reader bypass grant ast00.000.00
gcs reader bypass grant fg ast1760.050.00
gcs reader bypass grant immediate4410.120.00
gcs recovery claim msgs00.000.00
gcs refuse xid10.000.00
gcs regular cr1,1100.310.00
gcs retry convert request00.000.00
gcs share recovery bast00.000.00
gcs side channel msgs actual38,21110.570.10
gcs side channel msgs logical297,58982.330.75
gcs stale cr00.000.00
gcs undo cr00.000.00
gcs write notification msgs4130.110.00
gcs writes refused90.000.00
ges msgs process time(ms)1,3050.360.00
ges msgs received41,95511.610.11
global posts dropped00.000.00
global posts queue time100.000.00
global posts queued40.000.00
global posts requested40.000.00
global posts sent40.000.00
implicit batch messages received54,72915.140.14
implicit batch messages sent39,47710.920.10
lmd msg send time(ms)00.000.00
lms(s) msg send time(ms)40.000.00
messages flow controlled19,5525.410.05
messages queue sent actual252,72169.920.64
messages queue sent logical85,40123.630.22
messages received actual2,571,878711.516.49
messages received logical2,735,297756.726.90
messages sent directly1,063,965294.342.68
messages sent indirectly232,25964.250.59
messages sent not implicit batched00.000.00
messages sent pbatched1,388,287384.073.50
msgs causing lmd to send msgs18,2455.050.05
msgs causing lms(s) to send msgs27,7167.670.07
msgs received queue time (ms)308,78785.430.78
msgs received queued2,735,322756.726.90
msgs sent queue time (ms)7,7302.140.02
msgs sent queue time on ksxp (ms)775,543214.551.96
msgs sent queued296,90782.140.75
msgs sent queued on ksxp2,547,245704.696.43
number of broadcasted resources00.000.00
number of ges deadlock detected00.000.00
process batch messages received753,124208.351.90
process batch messages sent1,315,183363.843.32


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests18,437
CURRENT Block Requests1,605
Data Block Requests18,437
Undo Block Requests0
TX Block Requests272
Current Results20,029
Private results0
Zero Results13
Disk Read Results0
Fail Results0
Fairness Down Converts9,986
Fairness Clears1,748
Free GC Elements0
Flushes62
Flushes Queued0
Flush Queue Full0
Flush Max Time (us)0
Light Works5
Errors0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins2100.000.000.000.000.00
Flushes3892.117.890.000.000.00
Writes11,30977.5919.820.870.341.38


Back to Top

Global Cache Transfer Stats

Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
2data block148,60199.660.300.0444,66599.910.050.04
1data block10799.070.930.002,48199.440.560.00
2Others79299.870.000.1357099.470.530.00
1Others14100.000.000.0038100.000.000.00
2undo header17100.000.000.00580.0020.000.00
1undo header2100.000.000.002100.000.000.00
2undo block366.6733.330.000   

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer Times (ms)

  CR Avg Time (ms) Current Avg Time (ms)
Inst NoBlock Class AllImmedBusyCongstAllImmedBusyCongst
2data block0.570.571.227.290.460.460.932.77
1data block0.320.311.27 0.590.581.30 
2others0.210.20 1.950.260.250.50 
1others0.230.23  0.230.23  
2undo header0.230.23  0.380.290.75 
1undo header0.180.18  0.250.25  
2undo block0.390.250.68     
1undo block        

Back to Global Cache Transfer Stats
Back to Top

Global Cache Transfer (Immediate)

   CR Current
Src Inst#Block Class Blocks LostImmed Blks Received% 2hop% 3hopImmed Blks Received% 2hop% 3hop
2data block0148,09366.4233.5844,62366.9633.04
1data block010666.0433.962,46772.6027.40
2others079162.5837.4256760.8539.15
1others01492.867.143873.6826.32
2undo header017100.000.004100.000.00
1undo header02100.000.002100.000.00
2undo block02100.000.000  
1undo block00  0  

Back to Global Cache Transfer Stats
Back to Top

Global Cache Times (Immediate)

   CR Avg Time (ms) Current Avg Time (ms)
Src Inst#Block Class Lost TimeImmed2hop3hopImmed2hop3hop
2data block 0.570.450.790.460.390.61
1data block 0.310.290.350.580.540.70
2others 0.200.170.270.250.240.27
1others 0.230.230.240.230.220.27
2undo header 0.230.23 0.290.29 
1undo header 0.180.18 0.250.25 
2undo block 0.250.25    
1undo block       

Back to Global Cache Transfer Stats
Back to Top

Interconnect Stats

Back to Top

Interconnect Ping Latency Stats

Target Instance500B Ping CountAvg Latency 500B msgStddev 500B msg8K Ping CountAvg Latency 8K msgStddev 8K msg
12820.450.322820.550.33
22820.380.532820.530.58
32820.220.072820.220.07

Back to Interconnect Stats
Back to Top

Interconnect Throughput by Client

Used BySend Mbytes/secReceive Mbytes/sec
Global Cache0.110.33
Parallel Query0.000.00
DB Locks0.120.12
DB Streams0.000.00
Other0.020.00

Back to Interconnect Stats
Back to Top

Interconnect Device Statistics

Device NameIP AddressPublicSourceSend Mbytes/secSend ErrorsSend DroppedSend Buffer OverrunSend Carrier LostReceive Mbytes/secReceive ErrorsReceive DroppedReceive Buffer OverrunReceive Frame Errors
lan901:801169.254.162.52NO  0.000000 0.000000

Back to Interconnect Stats
Back to Top

Dynamic Remastering Stats

NameTotalper Remaster OpBegin SnapEnd Snap
remaster ops31.00  
remastered objects51.67  
replayed locks received1,911637.00  
replayed locks sent62.00  
resources cleaned00.00  
remaster time (s)36.712.23  
quiesce time (s)10.83.60  
freeze time (s)0.70.24  
cleanup time (s)5.91.97  
replay time (s)0.20.07  
fixwrite time (s)11.13.69  
sync time (s)7.92.64  
affinity objects  1,7341,734


Back to Top

End of Report