WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host
DB 1565577016 db1 1 10.2.0.5.0 YES db1

Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 20150 31-3ÔÂ -15 08:34:25 626 59.8
End Snap: 20153 31-3ÔÂ -15 09:04:33 276 36.8
Elapsed:   30.13 (mins)    
DB Time:   744.89 (mins)    

Report Summary

Cache Sizes

Begin End
Buffer Cache: 12,288M 12,288M Std Block Size: 8K
Shared Pool Size: 4,096M 4,096M Log Buffer: 14,304K

Load Profile

Per Second Per Transaction
Redo size: 103,279.96 7,565.97
Logical reads: 296,115.86 21,692.54
Block changes: 824.43 60.40
Physical reads: 51.50 3.77
Physical writes: 30.80 2.26
User calls: 1,336.90 97.94
Parses: 587.07 43.01
Hard parses: 14.39 1.05
Sorts: 404.78 29.65
Logons: 0.68 0.05
Executes: 4,642.50 340.10
Transactions: 13.65  

% Blocks changed per Read: 0.28 Recursive Call %: 80.11
Rollback per transaction %: 8.54 Rows per Sort: 57.36

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.97
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.45 Soft Parse %: 97.55
Execute to Parse %: 87.35 Latch Hit %: 99.48
Parse CPU to Parse Elapsd %: 0.75 % Non-Parse CPU: 98.17

Shared Pool Statistics

Begin End
Memory Usage %: 91.26 90.85
% SQL with executions>1: 57.71 86.02
% Memory for SQL w/exec>1: 63.11 86.76

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
latch: library cache 119,049 33,273 279 74.4 Concurrency
latch: shared pool 44,985 12,218 272 27.3 Concurrency
CPU time   3,251   7.3  
latch free 7,224 1,931 267 4.3 Other
latch: cache buffers chains 16,285 1,566 96 3.5 Concurrency

RAC Statistics

Begin End
Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction
Global Cache blocks received: 49.37 3.62
Global Cache blocks served: 173.92 12.74
GCS/GES messages received: 1,319.91 96.69
GCS/GES messages sent: 693.10 50.77
DBWR Fusion writes: 2.28 0.17
Estd Interconnect traffic (KB) 2,179.47  

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

Buffer access - local cache %: 99.97
Buffer access - remote cache %: 0.02
Buffer access - disk %: 0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 1.4
Avg global cache cr block receive time (ms): 5.6
Avg global cache current block receive time (ms): 3.5
Avg global cache cr block build time (ms): 1.0
Avg global cache cr block send time (ms): 0.2
Global cache log flushes for cr blocks served %: 0.3
Avg global cache cr block flush time (ms): 24.5
Avg global cache current block pin time (ms): 0.1
Avg global cache current block send time (ms): 0.4
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 3.6

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 11.0
Avg message sent queue time on ksxp (ms): 1.0
Avg message received queue time (ms): 0.4
Avg GCS message process time (ms): 0.3
Avg GES message process time (ms): 0.7
% of direct sent messages: 49.05
% of indirect sent messages: 35.17
% of flow controlled messages: 15.77

Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic Name Time (s) % of DB Time
sql execute elapsed time 29,070.64 65.04
PL/SQL execution elapsed time 10,580.47 23.67
parse time elapsed 8,344.48 18.67
DB CPU 3,250.86 7.27
hard parse elapsed time 2,205.28 4.93
PL/SQL compilation elapsed time 1,593.59 3.57
failed parse elapsed time 452.76 1.01
connection management call elapsed time 171.95 0.38
hard parse (sharing criteria) elapsed time 29.83 0.07
sequence load elapsed time 27.82 0.06
hard parse (bind mismatch) elapsed time 8.09 0.02
repeated bind elapsed time 0.61 0.00
DB time 44,693.36  
background elapsed time 2,894.49  
background cpu time 74.40  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait Class Waits %Time -outs Total Wait Time (s) Avg wait (ms) %Total Call Time
Concurrency 7,117,617 0 48,402 7 108.30
Other 4,757,343 15 3,560 1 7.97
CPU time     3,251   7.27
User I/O 77,176   553 7 1.24
Cluster 102,132 0 524 5 1.17
Commit 26,339 4 154 6 0.34
Application 13,129 0 38 3 0.08
Network 2,684,749   32 0 0.07
System I/O 57,912   30 1 0.07
Configuration 64 2 6 92 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
latch: library cache 119,049 0 33,273 279 4.82
latch: shared pool 44,985 0 12,218 272 1.82
latch free 7,224   1,931 267 0.29
latch: cache buffers chains 16,285   1,566 96 0.66
latch: library cache lock 3,877 1 1,033 267 0.16
latch: session allocation 2,912   825 283 0.12
db file sequential read 67,123   537 8 2.72
gc buffer busy 955 30 328 344 0.04
latch: gcs resource hash 1,318   296 225 0.05
log file sync 26,339 4 154 6 1.07
cursor: pin S wait on X 12,620 100 124 10 0.51
latch: KCL gc element parent latch 444   93 209 0.02
gc cr block 2-way 21,284   88 4 0.86
latch: undo global data 306   87 285 0.01
enq: PR - contention 26 81 62 2372 0.00
os thread startup 128 35 50 394 0.01
enq: CF - contention 831 10 47 57 0.03
library cache lock 22,463 0 43 2 0.91
latch: row cache objects 225   40 177 0.01
gc current block 2-way 20,875   39 2 0.85
latch: library cache pin 139   38 272 0.01
enq: TX - row lock contention 118 32 35 294 0.00
kksfbc child completion 691 100 34 49 0.03
DFS lock handle 1,437 4 28 20 0.06
enq: DX - contention 10 90 27 2673 0.00
gc cr block busy 171 9 22 129 0.01
log file parallel write 27,070   22 1 1.10
enq: XR - database force logging 638 6 21 32 0.03
gc current grant busy 7,303 0 19 3 0.30
gc cr multi block request 31,219   14 0 1.27
rdbms ipc reply 95 7 13 139 0.00
LNS wait on SENDREQ 197   13 66 0.01
SQL*Net more data to client 527,884   13 0 21.39
latch: cache buffers lru chain 53   13 238 0.00
kjbdrmcvtq lmon drm quiesce: ping completion 68 90 12 183 0.00
name-service call wait 157   12 76 0.01
row cache lock 7,968 0 11 1 0.32
db file scattered read 5,880   10 2 0.24
ges lmd/lmses to freeze in rcfg - mrcvr 1,159 68 9 8 0.05
reliable message 399 2 8 21 0.02
latch: ges resource hash list 51   7 131 0.00
gc cr grant 2-way 14,032   7 0 0.57
log file sequential read 19,287   6 0 0.78
read by other session 809   5 6 0.03
gcs log flush sync 510 29 5 10 0.02
CSS operation: query 204   4 22 0.01
CSS initialization 68   4 63 0.00
log file switch completion 33   4 130 0.00
Streams AQ: qmn coordinator waiting for slave to start 2   4 2134 0.00
SQL*Net more data from client 49,869   4 0 2.02
cursor: mutex X 6,889,731   4 0 279.19
inactive transaction branch 4 100 4 977 0.00
latch: object queue header operation 25   4 145 0.00
gc current grant 2-way 5,894   3 1 0.24
gc current multi block request 336 1 3 10 0.01
cursor: pin S 4,005,577   3 0 162.31
SQL*Net break/reset to client 12,585   3 0 0.51
control file sequential read 10,337   2 0 0.42
buffer busy waits 87 1 2 21 0.00
CGS wait for IPC msg 324,663 99 2 0 13.16
enq: SQ - contention 16   1 92 0.00
SQL*Net message to client 2,106,799   1 0 85.37
wait for scn ack 40 20 1 34 0.00
enq: PS - contention 318   1 4 0.01
inactive session 1 100 1 977 0.00
direct path read 2,246   1 0 0.09
gc current block busy 52   1 16 0.00
ges global resource directory to be frozen 64 100 1 10 0.00
enq: TX - index contention 19 5 1 31 0.00
ksdxexeotherwait 376,697 100 0 0 15.26
ges2 LMON to wake up LMD - mrcvr 64 5 0 7 0.00
control file parallel write 1,026   0 0 0.04
PX Deq: Signal ACK 191 32 0 1 0.01
ksxr poll remote instances 19,556 51 0 0 0.79
direct path write 1,017   0 0 0.04
latch: redo allocation 15   0 8 0.00
PX Deq: reap credit 10,413 99 0 0 0.42
db file parallel read 11   0 10 0.00
enq: TM - contention 426   0 0 0.02
undo segment extension 1 100 0 98 0.00
PX Deq Credit: send blkd 249 25 0 0 0.01
IPC send completion sync 248 100 0 0 0.01
latch: messages 4   0 16 0.00
latch: checkpoint queue latch 3   0 20 0.00
enq: WF - contention 28   0 2 0.00
Data file init write 89   0 1 0.00
ges inquiry response 3   0 14 0.00
CSS operation: action 102   0 0 0.00
Log archive I/O 188   0 0 0.01
enq: FB - contention 69   0 0 0.00
latch: parallel query alloc buffer 1   0 17 0.00
enq: TT - contention 55   0 0 0.00
library cache pin 41   0 0 0.00
LGWR wait for redo copy 111   0 0 0.00
KJC: Wait for msg sends to complete 207   0 0 0.01
enq: HW - contention 12   0 0 0.00
enq: US - contention 9   0 0 0.00
enq: TD - KTF dump entries 5   0 0 0.00
log file single write 4   0 0 0.00
gc current block unknown 2   0 0 0.00
enq: TA - contention 4   0 0 0.00
enq: PI - contention 2   0 0 0.00
enq: TX - allocate ITL entry 2   0 0 0.00
enq: MW - contention 1   0 0 0.00
gc current split 1   0 0 0.00
enq: AF - task serialization 1   0 0 0.00
enq: WR - contention 1   0 0 0.00
enq: DR - contention 1   0 0 0.00
db file single write 1   0 0 0.00
enq: WL - contention 1   0 0 0.00
enq: SW - contention 1   0 0 0.00
gc object scan 8 100 0 0 0.00
PX qref latch 2 50 0 0 0.00
buffer deadlock 3 67 0 0 0.00
latch: enqueue hash chains 1   0 0 0.00
SQL*Net message from client 2,107,895   663,905 315 85.42
PX Idle Wait 7,292 98 17,513 2402 0.30
gcs remote message 892,835 40 13,354 15 36.18
class slave wait 439 89 3,275 7461 0.02
Streams AQ: waiting for time management or cleanup tasks 1 100 3,182 3182337 0.00
Streams AQ: qmn slave idle wait 67 4 1,815 27092 0.00
DIAG idle wait 9,118   1,784 196 0.37
ASM background timer 438   1,782 4068 0.02
LNS ASYNC end of log 179,646 100 1,761 10 7.28
ges remote message 58,397 20 1,722 29 2.37
Streams AQ: qmn coordinator idle wait 127 50 1,660 13069 0.01
Streams AQ: waiting for messages in the queue 166 100 1,547 9322 0.01
jobq slave wait 350 100 1,020 2915 0.01
i/o slave wait 8,659   8 1 0.35
KSV master wait 45 2 5 102 0.00
PX Deq: Execution Msg 814 20 1 2 0.03
PX Deq: Join ACK 202 33 0 2 0.01
PX Deq: Msg Fragment 177 40 0 1 0.01
PX Deq: Parse Reply 192 31 0 1 0.01
PX Deq: Execute Reply 172 23 0 1 0.01
Streams AQ: RAC qmn coordinator idle wait 129 100 0 0 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
events in waitclass Other 350,305 95 543 2 14.20
latch: shared pool 711 13 183 257 0.03
os thread startup 88 51 47 529 0.00
latch: library cache 144 3 40 276 0.01
latch: cache buffers chains 132   34 254 0.01
log file parallel write 27,071   22 1 1.10
LNS wait on SENDREQ 197   13 66 0.01
latch: library cache lock 67 51 12 185 0.00
log file sequential read 19,287   6 0 0.78
library cache lock 366 2 5 13 0.01
gc cr block 2-way 109   2 21 0.00
control file sequential read 10,065   2 0 0.41
buffer busy waits 9 11 2 203 0.00
gc current block 2-way 121   1 11 0.00
control file parallel write 1,023   0 0 0.04
db file sequential read 12   0 14 0.00
enq: TM - contention 423   0 0 0.02
gc current block busy 1   0 38 0.00
direct path read 541   0 0 0.02
Log archive I/O 188   0 0 0.01
row cache lock 22   0 0 0.00
direct path write 214   0 0 0.01
gc current grant busy 9   0 0 0.00
log file single write 4   0 0 0.00
gc current grant 2-way 5   0 0 0.00
gc cr grant 2-way 2   0 0 0.00
gc cr multi block request 3   0 0 0.00
gc object scan 8 100 0 0 0.00
rdbms ipc message 103,091 23 28,551 277 4.18
gcs remote message 892,934 40 13,355 15 36.18
Streams AQ: waiting for time management or cleanup tasks 1 100 3,182 3182337 0.00
DIAG idle wait 9,119   1,784 196 0.37
ASM background timer 438   1,782 4068 0.02
LNS ASYNC end of log 179,662 100 1,761 10 7.28
smon timer 403 93 1,731 4295 0.02
ges remote message 58,399 20 1,723 29 2.37
pmon timer 1,172 87 1,712 1460 0.05
Streams AQ: qmn coordinator idle wait 127 50 1,660 13069 0.01
KSV master wait 38 3 3 88 0.00
Streams AQ: RAC qmn coordinator idle wait 129 100 0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic Total
NUM_LCPUS 0
NUM_VCPUS 0
AVG_BUSY_TIME 19,683
AVG_IDLE_TIME 162,934
AVG_IOWAIT_TIME 11,073
AVG_SYS_TIME 3,424
AVG_USER_TIME 16,206
BUSY_TIME 631,727
IDLE_TIME 5,215,779
IOWAIT_TIME 356,355
SYS_TIME 111,353
USER_TIME 520,374
LOAD 3
OS_CPU_WAIT_TIME 699,900
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 879,427,584
VM_OUT_BYTES 7,717,502,976
PHYSICAL_MEMORY_BYTES 33,017,561,088
NUM_CPUS 32
NUM_CPU_CORES 16

Back to Wait Events Statistics
Back to Top

Service Statistics

Service Name DB Time (s) DB CPU (s) Physical Reads Logical Reads
db 44,427.10 3,254.20 92,131 535,612,550
SYS$USERS 288.30 2.90 460 36,500
SYS$BACKGROUND 0.00 0.00 553 98,034

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service Name User I/O Total Wts User I/O Wt Time Concurcy Total Wts Concurcy Wt Time Admin Total Wts Admin Wt Time Network Total Wts Network Wt Time
db 75612 550 7093228 41626 0 0 2678792 18
SYS$USERS 798 3 2248 444 0 0 889 0
SYS$BACKGROUND 767 0 1715 345 0 0 197 13

Back to Wait Events Statistics
Back to Top

SQL Statistics

Back to Top

SQL ordered by Elapsed Time

Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
3,425 46 1,101 3.11 7.66 6cksnupbmk7kp BQYZ.EXE SELECT COUNT(B.YIZHUXMID), B.Y...
2,016 559 14,495 0.14 4.51 6dtu480vu4auh w3wp.exe SELECT b.paiduiph, bingrenxm F...
1,116 314 213 5.24 2.50 1zsqsyn3s7wdp BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
1,091 3 10,384 0.11 2.44 82a5wb9wh14x7 BQYZ.EXE begin Prc_Gy_Getorder ( :prmXu...
626 304 203 3.08 1.40 bta2dxczbts04 FYSC.EXE Select sum ( Nvl ( zifeije , 0...
518 1 713 0.73 1.16 9yjyffcc5hbbt MZZJ.EXE SELECT A.GUAHAOID||chr(9)||A.J...
457 101 54 8.46 1.02 ddh58ya0uh1jg w3wp.exe select :"SYS_B_00" as yiyuanmc...
429 0 87,447 0.00 0.96 6pwhuakcu5kqq labcom.exe select soufull , souid from l_...
420 2 3,892 0.11 0.94 1pfkguk2wbp48 PDJH.EXE SELECT A.DUILIEMC||chr(:"SYS_B...
403 150 3 134.43 0.90 21sxrpfuc4fwh BQYF.EXE SELECT JIAGEID||chr(:"SYS_B_00...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s) Elapsed Time (s) Executions CPU per Exec (s) % Total % Total DB Time SQL Id SQL Module SQL Text
559 2,016 14,495 0.04 17.20 4.51 6dtu480vu4auh w3wp.exe SELECT b.paiduiph, bingrenxm F...
314 1,116 213 1.47 9.66 2.50 1zsqsyn3s7wdp BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
304 626 203 1.50 9.34 1.40 bta2dxczbts04 FYSC.EXE Select sum ( Nvl ( zifeije , 0...
198 373 282 0.70 6.09 0.84 f4p11q882k5b5 BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
150 403 3 49.93 4.61 0.90 21sxrpfuc4fwh BQYF.EXE SELECT JIAGEID||chr(:"SYS_B_00...
140 383 146 0.96 4.32 0.86 agp1wj2adbhad BQYZ.EXE begin PKG_YZ_YEWU . prc_YZ_Zhi...
121 195 98 1.24 3.74 0.44 dfurxfh5cpsr3 FYSC.EXE Select Sum ( JieSuanJE ) From ...
104 293 146 0.71 3.21 0.66 144c03k0yybkt BQYZ.EXE Begin Prc_YZ_GengXingBRFJXX(:P...
101 457 54 1.87 3.11 1.02 ddh58ya0uh1jg w3wp.exe select :"SYS_B_00" as yiyuanmc...
89 227 254,214 0.00 2.73 0.51 cfmz0r3g3q9us BQYZ.EXE SELECT XIANSHIMC, A.YIZHUXMID,...
85 204 155 0.55 2.60 0.46 fp7b2u9jbu1rb PTJC.EXE SELECT DANGQIANBQ||chr(:"SYS_B...
81 147 1,757 0.05 2.51 0.33 g4up0s70udyd6 FYSC.EXE Select ZaiYuanZT From zy_BingR...
81 154 6,004 0.01 2.49 0.34 89vrgdpx747fg w3wp.exe SELECT BINGRENID, ZHENDUANLX, ...
48 82 656 0.07 1.47 0.18 8jvrhdh2ax6r7 w3wp.exe SELECT A.BINGRENID, A.BINGANHA...
46 3,425 1,101 0.04 1.42 7.66 6cksnupbmk7kp BQYZ.EXE SELECT COUNT(B.YIZHUXMID), B.Y...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
168,577,286 14,495 11,630.03 31.49 559.15 2016.26 6dtu480vu4auh w3wp.exe SELECT b.paiduiph, bingrenxm F...
59,821,989 203 294,689.60 11.17 303.63 625.53 bta2dxczbts04 FYSC.EXE Select sum ( Nvl ( zifeije , 0...
31,440,380 3 10,480,126.67 5.87 149.78 403.30 21sxrpfuc4fwh BQYF.EXE SELECT JIAGEID||chr(:"SYS_B_00...
29,288,375 98 298,860.97 5.47 121.48 195.30 dfurxfh5cpsr3 FYSC.EXE Select Sum ( JieSuanJE ) From ...
24,420,048 282 86,595.91 4.56 197.98 373.46 f4p11q882k5b5 BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
22,443,484 6,004 3,738.09 4.19 81.09 153.78 89vrgdpx747fg w3wp.exe SELECT BINGRENID, ZHENDUANLX, ...
21,009,276 146 143,899.15 3.92 140.35 383.48 agp1wj2adbhad BQYZ.EXE begin PKG_YZ_YEWU . prc_YZ_Zhi...
17,889,570 213 83,988.59 3.34 314.08 1115.71 1zsqsyn3s7wdp BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
17,882,873 1,101 16,242.39 3.34 46.08 3424.79 6cksnupbmk7kp BQYZ.EXE SELECT COUNT(B.YIZHUXMID), B.Y...
14,593,937 3,886 3,755.52 2.73 30.89 289.85 2bbt948395up8 PDJH.EXE SELECT PAIDUIID||chr(:"SYS_B_0...
14,414,046 146 98,726.34 2.69 104.37 293.25 144c03k0yybkt BQYZ.EXE Begin Prc_YZ_GengXingBRFJXX(:P...
13,802,984 1,757 7,856.00 2.58 81.44 146.52 g4up0s70udyd6 FYSC.EXE Select ZaiYuanZT From zy_BingR...
12,774,406 254,214 50.25 2.39 88.65 227.50 cfmz0r3g3q9us BQYZ.EXE SELECT XIANSHIMC, A.YIZHUXMID,...
6,342,519 2,114,211 3.00 1.18 19.78 36.71 5p3wb4w001mhh BQYZ.EXE SELECT PINCILX FROM GY_PINCI W...
6,159,771 1,633 3,772.06 1.15 25.16 54.64 52w9gnwhhnt62 w3wp.exe SELECT B.JIBINGMC, B.ZHENDUANS...
5,983,637 155 38,604.11 1.12 84.63 204.05 fp7b2u9jbu1rb PTJC.EXE SELECT DANGQIANBQ||chr(:"SYS_B...
5,779,196 71,048 81.34 1.08 20.19 113.38 csf1x66vmvd70 BQYF.EXE Select Nvl(Sum(KuCunSL - Nvl(Y...
5,469,201 315 17,362.54 1.02 27.52 45.16 7tr51f4s0f00b BQYZ.EXE SELECT COUNT(FUJIAJFMXID) FROM...
5,463,183 66,829 81.75 1.02 14.19 52.75 2xqt1w0rd1mub BQYF.EXE Select Nvl(Sum(KuCunSL - Nvl(Y...
5,407,058 54 100,130.70 1.01 101.23 457.04 ddh58ya0uh1jg w3wp.exe select :"SYS_B_00" as yiyuanmc...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical Reads Executions Reads per Exec %Total CPU Time (s) Elapsed Time (s) SQL Id SQL Module SQL Text
8,664 2 4,332.00 9.31 7.15 260.23 c7kchyk4yk76v BQYZ.EXE SELECT B.BINGANHAO סԺºÅ, B.XING...
7,450 2 3,725.00 8.00 0.61 70.83 f28yvjkfp3a1j BQYZ.EXE SELECT C.DANGQIANCW, C.XINGMIN...
3,576 2 1,788.00 3.84 0.51 160.24 1u3m4qp04hvzs BQYZ.EXE SELECT B.YIZHUMC||chr(:"SYS_B_...
2,863 146 19.61 3.08 140.35 383.48 agp1wj2adbhad BQYZ.EXE begin PKG_YZ_YEWU . prc_YZ_Zhi...
487 1 487.00 0.52 4.77 10.77 4gqsss1qnupwb GHSF.EXE SELECT BINGRENID||chr(:"SYS_B_...
414 427 0.97 0.44 4.38 265.15 4np4fqp3v18qh BQYZ.EXE begin PKG_ZY_YEWU . Prc_ZY_YuJ...
335 2 167.50 0.36 0.03 45.55 5avb9xmhsx2k4 w3wp.exe SELECT COUNT(*) FROM (SELECT A...
110 29 3.79 0.12 1.40 40.92 3jyu041kv22wx BQYF.EXE begin Pkg_BY_FaYao . Prc_BY_Yi...
43 2 21.50 0.05 0.03 0.07 0dwr2vd6vbqzs   SELECT count(*) over () as tot...
43 2 21.50 0.05 8.35 14.60 dnnhq1970sxnf TOAD 11.0.0.116 Select * from table(dbms_workl...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows Processed Rows per Exec CPU per Exec (s) Elap per Exec (s) SQL Id SQL Module SQL Text
2,114,211 2,114,174 1.00 0.00 0.00 5p3wb4w001mhh BQYZ.EXE SELECT PINCILX FROM GY_PINCI W...
254,214 19,095 0.08 0.00 0.00 cfmz0r3g3q9us BQYZ.EXE SELECT XIANSHIMC, A.YIZHUXMID,...
87,447 2,704 0.03 0.00 0.00 6pwhuakcu5kqq labcom.exe select soufull , souid from l_...
74,596 74,593 1.00 0.00 0.00 f0wzs9nc663bn labcom.exe select sysdate from dual
71,048 71,048 1.00 0.00 0.00 csf1x66vmvd70 BQYF.EXE Select Nvl(Sum(KuCunSL - Nvl(Y...
66,829 66,830 1.00 0.00 0.00 2xqt1w0rd1mub BQYF.EXE Select Nvl(Sum(KuCunSL - Nvl(Y...
44,311 44,311 1.00 0.00 0.00 32apq41xqy74s MZYF.EXE SELECT PKG_GY_KUFANGGY.FUN_GY_...
44,303 44,303 1.00 0.00 0.00 ctc36xs0g9jh9 BQYF.EXE SELECT COUNT(*) FROM BY_KUCUN2...
30,620 30,620 1.00 0.00 0.00 596aaa7y9rr3h BQYF.EXE SELECT JINJIA FROM ( SELECT JI...
19,481 1,324,107 67.97 0.00 0.00 c6fa2u8w4d8bu MZZJ.EXE SELECT YINGYONGID||chr(9)||KES...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse Calls Executions % Total Parses SQL Id SQL Module SQL Text
174,652 87,447 16.46 6pwhuakcu5kqq labcom.exe select soufull , souid from l_...
148,949 74,596 14.03 f0wzs9nc663bn labcom.exe select sysdate from dual
71,048 71,048 6.69 csf1x66vmvd70 BQYF.EXE Select Nvl(Sum(KuCunSL - Nvl(Y...
66,829 66,829 6.30 2xqt1w0rd1mub BQYF.EXE Select Nvl(Sum(KuCunSL - Nvl(Y...
19,482 19,481 1.84 c6fa2u8w4d8bu MZZJ.EXE SELECT YINGYONGID||chr(9)||KES...
14,372 14,372 1.35 58nqcgq93qdpp lis2.exe SELECT sysdate FROM dual
11,342 11,342 1.07 2p09jrn1gd47b BQYZ.EXE begin select SEQ_ZY_JIESUAN2.n...
11,319 11,322 1.07 7hxxth3uzdvh1 BQYZ.EXE SELECT SEQ_ZY_JIESUAN2.NEXTVAL...
10,061 14,495 0.95 6dtu480vu4auh w3wp.exe SELECT b.paiduiph, bingrenxm F...
8,168 8,168 0.77 9h3su635dcp95 w3wp.exe select shuzhi1, jilusj from tw...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b) Executions % Total SQL Id SQL Module SQL Text
2,705,937 57 0.06 d21030v816kbp BQYZ.EXE SELECT case a.YAOPINLX when :"...
1,297,150 4 0.03 1wdg63j811f3c MZZJ.EXE SELECT case a.YAOPINLX when :"...
1,134,424 30 0.03 986rqx6ajbdqq MZZJ.EXE SELECT case a.YAOPINLX when '1...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL Id SQL Module SQL Text
48 4 8xzq1tmuq2jnm MZYF.EXE SELECT A.YAOPINID||chr(:"SYS_B...
48 4 8xzq1tmuq2jnm MZYF.EXE SELECT A.YAOPINID||chr(:"SYS_B...
48 4 8xzq1tmuq2jnm MZYF.EXE SELECT A.YAOPINID||chr(:"SYS_B...
28 89 bvnfcw92wu4xz MZZJ.EXE SELECT A.CHUFANGMXID||chr(:"SY...
22 137 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s) CWT % of Elapsd Time Elapsed Time(s) CPU Time(s) Executions SQL Id SQL Module SQL Text
143.66 33.49 429.02 0.47 87,447 6pwhuakcu5kqq labcom.exe select soufull , souid from l_...
104.07 20.09 518.06 0.68 713 9yjyffcc5hbbt MZZJ.EXE SELECT A.GUAHAOID||chr(9)||A.J...
85.32 29.65 287.75 0.17 4,892 85qr8tbyns2qq MZZJ.EXE SELECT COUNT(*), SUM(NVL(A.SHO...
72.30 3.59 2,016.26 559.15 14,495 6dtu480vu4auh w3wp.exe SELECT b.paiduiph, bingrenxm F...
37.78 20.16 187.42 0.13 1,372 3nb48pv52ujm8 w3wp.exe SELECT XIANSHISJ, XIANSHIBZ, N...
25.92 13.65 189.97 7.21 239 ah8v40tmb7s8s MZZJ.EXE SELECT A.GUAHAOID||chr(9)||A.J...
22.22 7.67 289.85 30.89 3,886 2bbt948395up8 PDJH.EXE SELECT PAIDUIID||chr(:"SYS_B_0...
13.34 14.22 93.81 0.13 2,437 dvw272yj2xruh w3wp.exe select * from(SELECT NEIRONG1|...
12.11 3.12 388.34 24.22 6 11czwqw4drzyu eRadRegister.exe SELECT JZKH , XM , XB , CSRQ ,...
10.38 2.47 419.58 1.62 3,892 1pfkguk2wbp48 PDJH.EXE SELECT A.DUILIEMC||chr(:"SYS_B...
8.78 0.26 3,424.79 46.08 1,101 6cksnupbmk7kp BQYZ.EXE SELECT COUNT(B.YIZHUXMID), B.Y...
4.60 3.07 149.56 2.53 25 291qc4sadytyj BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
4.55 9.81 46.31 0.24 47 79rjzm0120ju4 GHSF.EXE begin pkg_yj_jiekou . Prc_YJ_J...
4.52 1.18 383.48 140.35 146 agp1wj2adbhad BQYZ.EXE begin PKG_YZ_YEWU . prc_YZ_Zhi...
4.32 1.16 373.46 197.98 282 f4p11q882k5b5 BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
4.31 2.69 160.24 0.51 2 1u3m4qp04hvzs BQYZ.EXE SELECT B.YIZHUMC||chr(:"SYS_B_...
3.44 68.74 5.01 0.57 5 22jdv01bx51vt BQYF.EXE SELECT case a.YAOPINLX when :"...
3.05 1.04 293.25 104.37 146 144c03k0yybkt BQYZ.EXE Begin Prc_YZ_GengXingBRFJXX(:P...
1.99 25.62 7.76 1.18 49 5d8dmu32amh58 BQYZ.EXE SELECT A.DANGQIANCW||chr(:"SYS...
1.67 11.13 14.99 0.05 941 b1skxa0jk4tp4 w3wp.exe DELETE FROM GY_YEWUDJ WHERE YE...
1.18 0.52 227.50 88.65 254,214 cfmz0r3g3q9us BQYZ.EXE SELECT XIANSHIMC, A.YIZHUXMID,...
0.98 31.30 3.13 0.05 5,542 f0xat52js9a6f w3wp.exe SELECT A.BINGRENZYID AS BINGRE...
0.96 0.47 204.05 84.63 155 fp7b2u9jbu1rb PTJC.EXE SELECT DANGQIANBQ||chr(:"SYS_B...
0.94 0.51 183.21 1.08 11 asnfw2nc3ycq2 BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
0.93 0.08 1,115.71 314.08 213 1zsqsyn3s7wdp BQYS.EXE SELECT MENZHENZYBZ||chr(9)||BA...
0.83 0.31 265.15 4.38 427 4np4fqp3v18qh BQYZ.EXE begin PKG_ZY_YEWU . Prc_ZY_YuJ...
0.82 0.31 260.23 7.15 2 c7kchyk4yk76v BQYZ.EXE SELECT B.BINGANHAO סԺºÅ, B.XING...
0.81 8.07 9.99 0.10 7,069 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
0.69 2.73 25.26 15.14 825 fsx3gt68k4t82 w3wp.exe SELECT WANGKADZ, JISUANJM, CAO...
0.42 0.22 189.63 4.15 45 0axfq4fv1js0p BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
0.25 0.02 1,090.64 2.62 10,384 82a5wb9wh14x7 BQYZ.EXE begin Prc_Gy_Getorder ( :prmXu...
0.24 0.34 70.83 0.61 2 f28yvjkfp3a1j BQYZ.EXE SELECT C.DANGQIANCW, C.XINGMIN...
0.17 0.42 40.92 1.40 29 3jyu041kv22wx BQYF.EXE begin Pkg_BY_FaYao . Prc_BY_Yi...
0.16 0.15 107.28 17.24 57 d21030v816kbp BQYZ.EXE SELECT case a.YAOPINLX when :"...
0.16 0.07 229.28 1.86 18 bzy47jqr66vyk BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
0.12 1.38 8.65 0.05 185 91sz07pbyy1mz lis2.exe INSERT INTO "L_PATIENTINFO" ( ...
0.11 0.57 19.70 1.65 11,342 2p09jrn1gd47b BQYZ.EXE begin select SEQ_ZY_JIESUAN2.n...
0.11 71.92 0.16 0.00 6 3w5bj9r5mj65z BQYZ.EXE SELECT FEIYONGID||chr(9)||YING...
0.11 0.05 221.67 2.79 28 2h3qjrgdj40dj BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
0.11 1.57 7.06 0.01 74 fu58bh5cxz9un MZZJ.EXE UPDATE ZJ_JIUZHENXX SET JIEZHE...
0.11 1.00 11.08 1.17 11,322 7hxxth3uzdvh1 BQYZ.EXE SELECT SEQ_ZY_JIESUAN2.NEXTVAL...
0.11 1.12 9.54 4.00 30 986rqx6ajbdqq MZZJ.EXE SELECT case a.YAOPINLX when '1...
0.10 0.10 95.72 2.48 67 3ccb451dhwj9r MZYF.EXE SELECT SHOUFEIID||chr(:"SYS_B_...
0.09 0.06 150.84 8.87 96 3gu3jwxnrb2hf BQYZ.EXE SELECT JIFEIJKID FROM ZY_JIFEI...
0.07 0.03 259.41 2.27 22 8xu6m654zvra6 BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
0.07 0.05 147.98 1.43 14 6wy3sj2ftgv0t BQYZ.EXE BEGIN PKG_YZ_JIEKOU.PRC_YZ_BIN...
0.07 0.47 14.60 8.35 2 dnnhq1970sxnf TOAD 11.0.0.116 Select * from table(dbms_workl...
0.06 0.51 12.85 0.04 328 fm2s1d8zmxvq8 MZZJ.EXE SELECT JIANYANZT||chr(9)||YIZH...
0.06 0.55 10.77 4.77 1 4gqsss1qnupwb GHSF.EXE SELECT BINGRENID||chr(:"SYS_B_...
0.05 13.54 0.39 0.04 37 gzwr3sg0qq0wv BQYZ.EXE SELECT DANGQIANKS||chr(:"SYS_B...
0.04 0.39 11.38 5.98 1 2n79auny8j7qs BQYZ.EXE SELECT SUM(ROUND(B.JIESUANJE, ...
0.03 6.63 0.51 0.05 1,190 96g93hntrzjtr   select /*+ rule */ bucket_cnt,...
0.03 0.59 4.73 0.79 2 gp2srf6v3th3r plsqldev.exe select s.synonym_name object_n...
0.02 0.02 142.51 1.32 8 arghxnr7sa2sp GHSF.EXE SELECT SHEBAOBH||chr(:"SYS_B_0...
0.02 0.03 64.57 1.45 3,836 4gf2f3ajd1jsg BQYZ.EXE INSERT INTO ZY_JIESUAN2 (BINGR...
0.02 0.80 2.45 0.59 84 dn7p378t5fwbb MZZJ.EXE SELECT PAIDUIID FROM JH_PAIDUI...
0.02 0.06 29.09 18.57 1 2sk5ykz25tzup w3wp.exe SELECT A.BINGRENID, A.ZHUYUANH...
0.02 0.06 25.57 0.61 4 9k04hj56dvp3q BQYZ.EXE SELECT case a.YAOPINLX when :"...
0.01 1.53 0.94 0.24 1 1fh0g8jhv7cp2 MZYF.EXE SELECT case a.YAOPINLX when :"...
0.01 0.03 40.26 24.29 1,100 bjjq3tdqckd2u BQYZ.EXE SELECT COUNT(A.BINGRENZYID) FR...
0.01 0.04 33.60 0.08 227 6uutwag4x46tr BQYS.EXE SELECT B.YIZHUID||chr(:"SYS_B_...
0.01 0.57 1.69 0.50 1 0nfq9jhkx216w BQYZ.EXE SELECT case a.YAOPINLX when :"...
0.01 1.18 0.81 0.46 3 a6zbz0vpdj6d7 GHSF.EXE SELECT BINGRENID||chr(:"SYS_B_...
0.01 13.06 0.07 0.03 2 0dwr2vd6vbqzs   SELECT count(*) over () as tot...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text
0axfq4fv1js0p BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('114', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0nfq9jhkx216w SELECT case a.YAOPINLX when :"SYS_B_000" then :"SYS_B_001" when :"SYS_B_002" then :"SYS_B_003" when :"SYS_B_004" then :"SYS_B_005" when :"SYS_B_006" then :"SYS_B_007" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_008"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, :"SYS_B_009") as DanJia1, d.KuCunSL AS KuCunSL, :"SYS_B_010" As XiangMuLX, :"SYS_B_011" as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||:"SYS_B_012"||b.BIEMINGID||:"SYS_B_013"||a.ZHANGBULB||:"SYS_B_014"||a.GUIGEID||:"SYS_B_015"||a.CHANDI||:"SYS_B_016"||a.SHOUFEIXM||:"SYS_B_017"||a.DULIFL||:"SYS_B_018"||a.JIAZHIFL||:"SYS_B_019"||a.GEIYAOFS||:"SYS_B_020"||a.YONGYAOTC||:"SYS_B_021"||a.PISHIBZ||:"SYS_B_022"||a.KANGSHENGSXJ||:"SYS_B_023"||a.KANGJUNYXJ||:"SYS_B_024"||a.DASHUYBZ||:"SYS_B_025"||a.FUFANGBZ||:"SYS_B_026"||a.JIZHENYYBZ||:"SYS_B_027"||a.JIXING||:"SYS_B_028"||a.DuiYingPSYP||:"SYS_B_029"||b.YAOPINMC||:"SYS_B_030"||a.YAOPINGG||:"SYS_B_031"||a.YiBaoDJ||:"SYS_B_032"||a.ZuiXiaoDW||:"SYS_B_033"||a.JiLiang||:"SYS_B_034"||a.JiLiangDW||:"SYS_B_035"||a.PingJunJJ||:"SYS_B_036" ;||a.PiFaJia||:"SYS_B_037"||a.YaoPinLX||:"SYS_B_038"||a.BaoZhuangLiang||:"SYS_B_039"||a.XianLiang3||:"SYS_B_040"||a.XianLiang7||:"SYS_B_041"||a.TiJi||:"SYS_B_042"||a.TiJiDW||:"SYS_B_043"||e.YAOPINFL||:"SYS_B_044"||a.FuYaoSX||:"SYS_B_045"||a.YaoPinID||:"SYS_B_046"||a.XiaoGuiGID||:"SYS_B_047"||a.DaGuiGID||:"SYS_B_048"||a.QiTaSX||:"SYS_B_049"||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_050" And a.YingYongID=:"SYS_B_051") or (b.YaoPinLX=:"SYS_B_052" And a.YingYongID=:"SYS_B_053") or (b.YaoPinLX=:"SYS_B_054" And a.YingYongID=:"SYS_B_055") or (b.YaoPinLX=:"SYS_B_056" And a.YingYongID=:"SYS_B_057"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = :"SYS_B_058" And a.ZUOFEIBZ = :"SYS_B_059" AND a.CHAXUNBZ = :"SYS_B_060" And (:"SYS_B_061"=:"SYS_B_062" or (b.SHURUMA3 Like :"SYS_B_063" or b.yaopinmc like :"SYS_B_064")) and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_065") = :"SYS_B_066" and a.LinChuangSYBZ = :"SYS_B_067" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SY S_B_068") And (d.ShiYongPL <> :"SYS_B_069")) and ((a.YaoPinLX = :"SYS_B_070"and a.baozhuangliang=:"SYS_B_071") or (a.YaoPinLX = :"SYS_B_072") or (a.YaoPinLX = :"SYS_B_073") or (a.YaoPinLX = :"SYS_B_074")) and ((a.YaoPinLX = :"SYS_B_075" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_076", :"SYS_B_077", :"SYS_B_078")), :"SYS_B_079") = :"SYS_B_080") or (a.YaoPinLX = :"SYS_B_081" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_082", :"SYS_B_083", :"SYS_B_084")), :"SYS_B_085") = :"SYS_B_086") or (a.YaoPinLX = :"SYS_B_087" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_088", :"SYS_B_089", :"SYS_B_090")), :"SYS_B_091") = :"SYS_B_092") or (a.YaoPinLX = :"SYS_B_093" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_094", :"SYS_B_095", :"SYS_B_096")), :"SYS_B_097") = :"SYS_B_098")) and a.TINGYONGBZ = :"SYS_B_099" union all SELECT case a.YAOPINLX when :"SYS_B_100" then :"SYS_B_101" when :"SYS_B_102" then :"SYS_B_103" when :"SYS_B_104" then :"SYS_B_105" when :"SYS_B_106" then :"SYS_B_107" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_108"||a.YAOPINGG As YAOPINMCGG, a.CHANDI MC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, :"SYS_B_109") as DanJia1, d.KuCunSL AS KuCunSL, :"SYS_B_110" As XiangMuLX, :"SYS_B_111" as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||:"SYS_B_112"||b.BIEMINGID||:"SYS_B_113"||a.ZHANGBULB||:"SYS_B_114"||a.GUIGEID||:"SYS_B_115"||a.CHANDI||:"SYS_B_116"||a.SHOUFEIXM||:"SYS_B_117"||a.DULIFL||:"SYS_B_118"||a.JIAZHIFL||:"SYS_B_119"||a.GEIYAOFS||:"SYS_B_120"||a.YONGYAOTC||:"SYS_B_121"||a.PISHIBZ||:"SYS_B_122"||a.KANGSHENGSXJ||:"SYS_B_123"||a.KANGJUNYXJ||:"SYS_B_124"||a.DASHUYBZ||:"SYS_B_125"||a.FUFANGBZ||:"SYS_B_126"||a.JIZHENYYBZ||:"SYS_B_127"||a.JIXING||:"SYS_B_128"||a.DuiYingPSYP||:"SYS_B_129"||b.YAOPINMC||:"SYS_B_130"||a.YAOPINGG||:"SYS_B_131"||a.YiBaoDJ||:"SYS_B_132"||a.ZuiXiaoDW||:"SYS_B_133"||a.JiLiang||:"SYS_B_134"||a.JiLiangDW||:"SYS_B_135"||a.PingJunJJ||:"SYS_B_136"||a.PiFaJia||:"SYS_B_137"||a.YaoPinLX||:"SYS_B_138"||a.BaoZhuangLiang||:"SYS_B_139"||a.XianLiang3||:"SYS_B_140"||a.XianLiang7||:"SYS_B_141"||a.TiJi||:"SYS_B_142"||a.TiJiDW||:"SYS_B_143"||e.YAOPINFL||:"SYS_B_144"||a.FuYaoSX||:"SYS_B_145"||a.YaoP inID||:"SYS_B_146"||a.XiaoGuiGID||:"SYS_B_147"||a.DaGuiGID||:"SYS_B_148"||a.QiTaSX||:"SYS_B_149"||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_150" And a.YingYongID=:"SYS_B_151") or (b.YaoPinLX=:"SYS_B_152" And a.YingYongID=:"SYS_B_153") or (b.YaoPinLX=:"SYS_B_154" And a.YingYongID=:"SYS_B_155") or (b.YaoPinLX=:"SYS_B_156" And a.YingYongID=:"SYS_B_157"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = :"SYS_B_158" And a.ZUOFEIBZ = :"SYS_B_159" AND a.CHAXUNBZ = :"SYS_B_160" And b.SHURUMA3 Like :"SYS_B_161" and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_162") = :"SYS_B_163" and a.LinChuangSYBZ = :"SYS_B_164" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SYS_B_165") And (d.ShiYongPL <> :"SYS_B_166")) and ((a.YaoPinLX = :"SYS_B_167"and a.baozhuangliang=:"SYS_B_168") or (a.YaoPinLX = :"SYS_B_169") or (a.YaoPinLX = :"SYS_B_170") or (a.YaoPinLX = :"SYS_B_171")) and ((a.YaoPinLX = :&quo t;SYS_B_172" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_173", :"SYS_B_174", :"SYS_B_175")), :"SYS_B_176") = :"SYS_B_177") or (a.YaoPinLX = :"SYS_B_178" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_179", :"SYS_B_180", :"SYS_B_181")), :"SYS_B_182") = :"SYS_B_183") or (a.YaoPinLX = :"SYS_B_184" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_185", :"SYS_B_186", :"SYS_B_187")), :"SYS_B_188") = :"SYS_B_189") or (a.YaoPinLX = :"SYS_B_190" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_191", :"SYS_B_192", :"SYS_B_193")), :"SYS_B_194") = :"SYS_B_195")) and a.TINGYONGBZ = :"SYS_B_196" union all Select :"SYS_B_197" as leibie , XiangMuMC, MiaoShu , PinCi, FUN_YZ_YIZHUXMJGHZ(XIANGMUID) as danjia, :"SYS_B_198" as kucunsl, :"SYS_B_199" As LeiXing, :"SYS_B_200" as taocanbz, XiangMuID, ShuRuMa1, ShuRuMa2, ShuRuMa3, PaiChiLX||:"SYS_B_201"||DaYinBZ as kuozhanlie From YZ_YiZhuXM where SHURUMA3 Like Upper(:"SYS_B_202") And ( BingQuID = :"SYS_B_203" Or BingQuID Is Null ) and (fuleiid != -:"SYS_B_204") and zuofeibz=:"SYS_B_205" union all Select :"SYS_B_206" As leibie, mingcheng, :"SYS_B_207"As MiaoSHu, :"SYS_B_2 08" As PinCi, :"SYS_B_209" As danjia, :"SYS_B_210" As kucunsl, :"SYS_B_211" As LeiXing, :"SYS_B_212" As taocanbz, ChengZuYZID, ShuRuMa1, ShuRuMa2, ShuRuMa3, :"SYS_B_213" as kuozhanlie From YZ_ChengZuYZ1 where SHURUMA3 Like Upper(:"SYS_B_214") And ZuoFeiBZ = :"SYS_B_215" And ((SHIYONGFW = :"SYS_B_216" AND YISHENGKS = :"SYS_B_217") OR (SHIYONGFW = :"SYS_B_218" AND YISHENGKS = :"SYS_B_219") OR (SHIYONGFW = :"SYS_B_220" ) OR (SHIYONGFW = :"SYS_B_221" AND YISHENGKS = :"SYS_B_222") OR (SHIYONGFW = :"SYS_B_223" AND YISHENGKS = :"SYS_B_224") )
11czwqw4drzyu SELECT JZKH , XM , XB , CSRQ , LXDH , JTZZ , KAIDANYS , KAIDANYSXM , KAIDANKS , KAIDANKSMC FROM V_MZBRXX WHERE (JZKH = :"SYS_B_0" OR fapiaohm = :"SYS_B_1" OR fapiaohm LIKE :"SYS_B_2" OR fapiaohm LIKE :"SYS_B_3")
144c03k0yybkt Begin Prc_YZ_GengXingBRFJXX(:P1, :P2, :P3); End;
1fh0g8jhv7cp2 SELECT case a.YAOPINLX when :"SYS_B_00" then :"SYS_B_01" when :"SYS_B_02" then :"SYS_B_03" when :"SYS_B_04" then :"SYS_B_05" when :"SYS_B_06" then :"SYS_B_07" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_08"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx_Ex(a.Jiageid, :"SYS_B_09", d.YingYongID) As Danjia1, d.KuCunSL AS KuCunSL, a.JIAGEID, a.YAOPINMC as ZHUMINGMC, b.BIEMINGID, a.ZHANGBULB, a.GUIGEID, a.CHANDI, a.SHOUFEIXM, a.DULIFL, a.JIAZHIFL, a.GEIYAOFS, a.YONGYAOTC, a.PISHIBZ, a.KANGSHENGSXJ, a.KANGJUNYXJ, a.DASHUYBZ, a.FUFANGBZ, a.JIZHENYYBZ, a.JIXING, :"SYS_B_10" As XiangMuLX, a.DuiYingPSYP, b.YAOPINMC as BIEMINGMC, a.YAOPINGG, a.YiBaoDJ, a.ZuiXiaoDW, a.JiLiang, a.JiLiangDW, a.PingJunJJ, a.PiFaJia, a.YaoPinLX, a.BaoZhuangLiang, a.XianLiang3, a.XianLiang7, a.TiJi, a.TiJiDW, e.YAOPINFL, a.FuYaoSX, a.YaoPinID, a.XiaoGuiGID, a.DaGuiGID, a.QiTaSX, a.DuiYingPSYPSL, a.LingChaJBZ FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.YingYongID, a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL , a.LAIYUAN From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_11" And a.YingYongID=:"SYS_B_12") or (b.YaoPinLX=:"SYS_B_13" And a.YingYongID=:"SYS_B_14") or (b.YaoPinLX=:"SYS_B_15" And a.YingYongID=:"SYS_B_16") or (b.YaoPinLX=:"SYS_B_17" And a.YingYongID=:& quot;SYS_B_18"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = :"SYS_B_19" And a.ZUOFEIBZ = :"SYS_B_20" AND a.CHAXUNBZ = :"SYS_B_21" And (b.SHURUMA1 Like :"SYS_B_22" or b.yaopinmc like :"SYS_B_23") and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_24") = :"SYS_B_25" and (a.JiaGeId=d.JiaGeID(+)) and a.GuiGeID = a.DaGuiGID union all SELECT case a.YAOPINLX when :"SYS_B_26" then :"SYS_B_27" when :"SYS_B_28" then :"SYS_B_29" when :"SYS_B_30" then :"SYS_B_31" when :"SYS_B_32" then :"SYS_B_33" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_34"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx_Ex(a.Jiageid, :"SYS_B_35", d.YingYongID) As Danjia1, d.KuCunSL AS KuCunSL, a.JIAGEID, a.YAOPINMC as ZHUMINGMC, b.BIEMINGID, a.ZHANGBULB, a.GUIGEID, a.CHANDI, a.SHOUFEIXM, a.DULIFL, a.JIAZHIFL, a.GEIYAOFS, a.YONGYAOTC, a.PISHIBZ, a.KANGSHENGSXJ, a.KANGJUNYXJ, a.DASHUYBZ, a.FUFANGBZ, a.JIZHENYYBZ, a.JIXING, :"SYS_B_36" As XiangMuLX, a.DuiYingPSYP, b.YAOPINMC as BIEMINGMC, a.YAOPINGG, a.YiBaoDJ, a.ZuiXiaoDW, a.JiLiang, a.JiLiangDW, a.PingJunJJ, a.PiFaJia, a.YaoPinLX, a.BaoZhuangLiang, a.XianLiang3, a.XianLiang7, a.TiJi, a.TiJiDW, e.YAOPINFL, a.FuYaoSX, a.YaoPinID, a.XiaoGuiGID, a.DaGuiGID, a.QiTaSX, a.DuiYingPSYPSL, a.LingChaJBZ FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.YingYongID, a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL , a.LAIYUAN From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_37" And a.YingYongID=:"SYS_B_38") or (b.YaoPinLX=:"SYS_B_39" And a.YingYongID=:"SYS_B_40") or (b.YaoPinLX=:"SYS_B_41" And a.YingYongID=:"SYS_B_42") or (b.YaoPinLX=:"SYS_B_43" And a.YingYongID=:"SYS_B_44"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = :"SYS_B_45" And a.ZUOFEIBZ = :"SYS_B_46" AND a.CHAXUNBZ = :"SYS_B_47" And b.SHURUMA1 Like :"SYS_B_48" and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_49") = :"SYS_B_50" and (a.JiaGeId=d.JiaGeID(+)) and a.GuiGeID = a.DaGuiGID
1pfkguk2wbp48 SELECT A.DUILIEMC||chr(:"SYS_B_00")||A.PAIDUIID||chr(:"SYS_B_01")||A.PAIDUIXH||chr(:"SYS_B_02")||A.BINGRENID||chr(:"SYS_B_03")||A.BINGRENXM||chr(:"SYS_B_04")||A.JIUZHENKH||chr(:"SYS_B_05")||A.PAIDUIPH||chr(:"SYS_B_06")||A.SHANGXIAWBZ||chr(:"SYS_B_07")||A.ZHUANGTAIID||chr(:"SYS_B_08")||A.YISHENGID||chr(:"SYS_B_09")||to_char(A.CHUDUISJ , :"SYS_B_10")||chr(:"SYS_B_11")||A.DUILIEID||chr(:"SYS_B_12")||A.YUANQUID||chr(:"SYS_B_13")||A.YINGYONGID||chr(:"SYS_B_14")||A.PAIDUILXID||chr(:"SYS_B_15")||A.LEIXINMC||chr(:"SYS_B_16")||A.YEWUXH||chr(:"SYS_B_17")||A.XINGBIE||chr(:"SYS_B_18")||A.YEWUID||chr(:"SYS_B_19")||A.YEWUXX||chr(:"SYS_B_20")||B.FUDUILID FROM JH_JIESHUDL A, JH_DUILIEXX B WHERE B.DUILIEID = A.DUILIEID AND (A.DUILIEID = :"SYS_B_21" or B.FUDUILID = :"SYS_B_22") and A.SHANGXIAWBZ=:"SYS_B_23" AND :"SYS_B_24"=:A
1u3m4qp04hvzs SELECT B.YIZHUMC||chr(:"SYS_B_00")||B.GUIGEID||chr(:"SYS_B_01")||to_char(B.KAISHISJ , :"SYS_B_02")||chr(:"SYS_B_03")||B.JILIANGDW||chr(:"SYS_B_04")||B.YICIYL||chr(:"SYS_B_05")||B.DANGRICS||chr(:"SYS_B_06")||to_char(B.JIESHUSJ , :"SYS_B_07")||chr(:"SYS_B_08")||B.FUYIZMC||chr(:"SYS_B_09")||B.YIZHUMS||chr(:"SYS_B_10")||B.YISHENGZT||chr(:"SYS_B_11")||B.KAIZHUYSXM||chr(:"SYS_B_12")||B.PISHIJG||chr(:"SYS_B_13")||B.ZHIXINGYL||chr(:"SYS_B_14")||B.GEIYAOFSMC||chr(:"SYS_B_15")||B.YAOPINGG||chr(:"SYS_B_16")||B.LINGYAOFS||chr(:"SYS_B_17")||B.DANGQIANZT||chr(:"SYS_B_18")||B.PINCI||chr(:"SYS_B_19")||B.YIZHUID||chr(:"SYS_B_20")||B.BINGRENZYID||chr(:"SYS_B_21")||B.BINGRENXM||chr(:"SYS_B_22")||B.YAOFANGYYID||chr(:"SYS_B_23")||B.YIZHUFL||chr(:"SYS_B_24")||B.JIZHENBZ||chr(:"SYS_B_25")||B.TAKEBZ||chr(:"SYS_B_26")||B.YEJIANBZ||chr(:"SYS_B_27")||B.FUYIZID||chr(:"SYS_B_28")||B.ZUHAO||chr(:"SYS_B_29")||A.DANGQIANCW||chr(:"SYS_B_30")||B.YIZHUZT||chr(:"SYS_B_31")||B.YICIJL||chr(:"SYS_B_32")||B.FAYAOZT||chr(:"SYS_B_33")||B.CAOYAOBZ||chr(:"SYS_B_34")||B.DAIJIANTS||chr(:"SYS_B_35")||B.GEIYAOFSLX||chr(:"SYS_B_36")||B.YIZHUXMID||chr(:"S YS_B_37")||B.GEIYAOFS||chr(:"SYS_B_38")||B.BAOZHUANGDW||chr(:"SYS_B_39")||B.ZUIXIAODW||chr(:"SYS_B_40")||B.BAOZHUANGLIANG||chr(:"SYS_B_41")||B.YAOPINMC||chr(:"SYS_B_42")||B.JIAGEID||chr(:"SYS_B_43")||B.YAOPINBMID||chr(:"SYS_B_44")||B.JIXING||chr(:"SYS_B_45")||B.YICIJLDW||chr(:"SYS_B_46")||B.JINGMAIPBZ||chr(:"SYS_B_47")||B.JILIANG||chr(:"SYS_B_48")||B.QUZHENGLX||chr(:"SYS_B_49")||A.LINCHUANGLJBZ||chr(:"SYS_B_50")||B.KAIZHUBQ||chr(:"SYS_B_51")||C.YIRICS||chr(:"SYS_B_52")||C.PINCILX FROM ZY_V_XUANZEBR A, YZ_BINGRENYZ B, GY_PINCI C, SM_SHOUSHUXX D WHERE B.BINGRENZYID = A.BINGRENZYID AND B.YINGERID = A.YINGERID and B.PINCI = C.PINCIID and D.SHOUSHUDID(+) = B.PAICHIYZID AND YIZHUFL in (:"SYS_B_53", :"SYS_B_54", :"SYS_B_55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61", :"SYS_B_62", :"SYS_B_63") and KAISHISJ >= To_Date(:"SYS_B_64", :"SYS_B_65") and yizhuzt <> :"SYS_B_66" and KaiZhuBQ=:"SYS_B_67" and A.BingRenZYID =:"SYS_B_68" and DANGQIANCW=:"SYS_B_69" and :"SYS_B_70"=:A
1wdg63j811f3c SELECT case a.YAOPINLX when :"SYS_B_000" then :"SYS_B_001" when :"SYS_B_002" then :"SYS_B_003" when :"SYS_B_004" then :"SYS_B_005" when :"SYS_B_006" then :"SYS_B_007" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_008"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, :"SYS_B_009") as DanJia1, d.KuCunSL AS KuCunSL, :"SYS_B_010" As XiangMuLX, :"SYS_B_011" as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||:"SYS_B_012"||b.BIEMINGID||:"SYS_B_013"||a.ZHANGBULB||:"SYS_B_014"||a.GUIGEID||:"SYS_B_015"||a.CHANDI||:"SYS_B_016"||a.SHOUFEIXM||:"SYS_B_017"||a.DULIFL||:"SYS_B_018"||a.JIAZHIFL||:"SYS_B_019"||a.GEIYAOFS||:"SYS_B_020"||a.YONGYAOTC||:"SYS_B_021"||a.PISHIBZ||:"SYS_B_022"||a.KANGSHENGSXJ||:"SYS_B_023"||a.KANGJUNYXJ||:"SYS_B_024"||a.DASHUYBZ||:"SYS_B_025"||a.FUFANGBZ||:"SYS_B_026"||a.JIZHENYYBZ||:"SYS_B_027"||a.JIXING||:"SYS_B_028"||a.DuiYingPSYP||:"SYS_B_029"||b.YAOPINMC||:"SYS_B_030"||a.YAOPINGG||:"SYS_B_031"||a.YiBaoDJ||:"SYS_B_032"||a.ZuiXiaoDW||:"SYS_B_033"||a.JiLiang||:"SYS_B_034"||a.JiLiangDW||:"SYS_B_035"||a.PingJunJJ||:"SYS_B_036" ;||a.PiFaJia||:"SYS_B_037"||a.YaoPinLX||:"SYS_B_038"||a.BaoZhuangLiang||:"SYS_B_039"||a.XianLiang3||:"SYS_B_040"||a.XianLiang7||:"SYS_B_041"||a.TiJi||:"SYS_B_042"||a.TiJiDW||:"SYS_B_043"||e.YAOPINFL||:"SYS_B_044"||a.FuYaoSX||:"SYS_B_045"||a.YaoPinID||:"SYS_B_046"||a.XiaoGuiGID||:"SYS_B_047"||a.DaGuiGID||:"SYS_B_048"||a.QiTaSX||:"SYS_B_049"||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_050" And a.YingYongID=:"SYS_B_051") or (b.YaoPinLX=:"SYS_B_052" And a.YingYongID=:"SYS_B_053") or (b.YaoPinLX=:"SYS_B_054" And a.YingYongID=:"SYS_B_055") or (b.YaoPinLX=:"SYS_B_056" And a.YingYongID=:"SYS_B_057"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = :"SYS_B_058" And a.ZUOFEIBZ = :"SYS_B_059" AND a.CHAXUNBZ = :"SYS_B_060" And (:"SYS_B_061"=:"SYS_B_062" or (b.SHURUMA1 Like :"SYS_B_063" or b.yaopinmc like :"SYS_B_064")) and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_065") = :"SYS_B_066" and a.LinChuangSYBZ = :"SYS_B_067" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SY S_B_068") And (d.ShiYongPL <> :"SYS_B_069")) and ((a.YaoPinLX = :"SYS_B_070"and a.baozhuangliang=:"SYS_B_071") or (a.YaoPinLX = :"SYS_B_072") or (a.YaoPinLX = :"SYS_B_073") or (a.YaoPinLX = :"SYS_B_074")) and (((a.YaoPinLX = :"SYS_B_075" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_076", :"SYS_B_077", :"SYS_B_078")), :"SYS_B_079") = :"SYS_B_080") or (a.YaoPinLX = :"SYS_B_081" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_082", :"SYS_B_083", :"SYS_B_084")), :"SYS_B_085") = :"SYS_B_086") or (a.YaoPinLX = :"SYS_B_087" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_088", :"SYS_B_089", :"SYS_B_090")), :"SYS_B_091") = :"SYS_B_092") or (a.YaoPinLX = :"SYS_B_093" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_094", :"SYS_B_095", :"SYS_B_096")), :"SYS_B_097") = :"SYS_B_098")) and a.menzhenqybz = :"SYS_B_099") and a.TINGYONGBZ = :"SYS_B_100" union all SELECT case a.YAOPINLX when :"SYS_B_101" then :"SYS_B_102" when :"SYS_B_103" then :"SYS_B_104" when :"SYS_B_105" then :"SYS_B_106" when :"SYS_B_107" then :"SYS_B_108" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_10 9"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, :"SYS_B_110") as DanJia1, d.KuCunSL AS KuCunSL, :"SYS_B_111" As XiangMuLX, :"SYS_B_112" as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||:"SYS_B_113"||b.BIEMINGID||:"SYS_B_114"||a.ZHANGBULB||:"SYS_B_115"||a.GUIGEID||:"SYS_B_116"||a.CHANDI||:"SYS_B_117"||a.SHOUFEIXM||:"SYS_B_118"||a.DULIFL||:"SYS_B_119"||a.JIAZHIFL||:"SYS_B_120"||a.GEIYAOFS||:"SYS_B_121"||a.YONGYAOTC||:"SYS_B_122"||a.PISHIBZ||:"SYS_B_123"||a.KANGSHENGSXJ||:"SYS_B_124"||a.KANGJUNYXJ||:"SYS_B_125"||a.DASHUYBZ||:"SYS_B_126"||a.FUFANGBZ||:"SYS_B_127"||a.JIZHENYYBZ||:"SYS_B_128"||a.JIXING||:"SYS_B_129"||a.DuiYingPSYP||:"SYS_B_130"||b.YAOPINMC||:"SYS_B_131"||a.YAOPINGG||:"SYS_B_132"||a.YiBaoDJ||:"SYS_B_133"||a.ZuiXiaoDW||:"SYS_B_134"||a.JiLiang||:"SYS_B_135"||a.JiLiangDW||:"SYS_B_136"||a.PingJunJJ||:"SYS_B_137"||a.PiFaJia||:"SYS_B_138"||a.YaoPinLX||:"SYS_B_139"||a.BaoZhuangLiang||:"SYS_B_140"||a.XianLiang3||:"SYS_B_141"||a.XianLiang7||:"SYS_B_142"||a.TiJi||:"SYS_B_143"||a.TiJiDW||:"SYS_B_144"||e.YAOPINFL||:"SYS_B_145" ||a.FuYaoSX||:"SYS_B_146"||a.YaoPinID||:"SYS_B_147"||a.XiaoGuiGID||:"SYS_B_148"||a.DaGuiGID||:"SYS_B_149"||a.QiTaSX||:"SYS_B_150"||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_151" And a.YingYongID=:"SYS_B_152") or (b.YaoPinLX=:"SYS_B_153" And a.YingYongID=:"SYS_B_154") or (b.YaoPinLX=:"SYS_B_155" And a.YingYongID=:"SYS_B_156") or (b.YaoPinLX=:"SYS_B_157" And a.YingYongID=:"SYS_B_158"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = :"SYS_B_159" And a.ZUOFEIBZ = :"SYS_B_160" AND a.CHAXUNBZ = :"SYS_B_161" And b.SHURUMA1 Like :"SYS_B_162" and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_163") = :"SYS_B_164" and a.LinChuangSYBZ = :"SYS_B_165" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SYS_B_166") And (d.ShiYongPL <> :"SYS_B_167")) and ((a.YaoPinLX = :"SYS_B_168"and a.baozhuangliang=:"SYS_B_169") or (a.YaoPinLX = :"SYS_B_170") or (a.YaoPinLX = :"SYS_B_171") or (a.YaoPinLX = :" ;SYS_B_172")) and (((a.YaoPinLX = :"SYS_B_173" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_174", :"SYS_B_175", :"SYS_B_176")), :"SYS_B_177") = :"SYS_B_178") or (a.YaoPinLX = :"SYS_B_179" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_180", :"SYS_B_181", :"SYS_B_182")), :"SYS_B_183") = :"SYS_B_184") or (a.YaoPinLX = :"SYS_B_185" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_186", :"SYS_B_187", :"SYS_B_188")), :"SYS_B_189") = :"SYS_B_190") or (a.YaoPinLX = :"SYS_B_191" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_192", :"SYS_B_193", :"SYS_B_194")), :"SYS_B_195") = :"SYS_B_196")) and a.menzhenqybz = :"SYS_B_197") and a.TINGYONGBZ = :"SYS_B_198"
1zsqsyn3s7wdp SELECT MENZHENZYBZ||chr(9)||BAOGAODLX||chr(9)||SHENQINGDID||chr(9)||BINGRENSY||chr(9)||BINGRENXM||chr(9)||XIANGMUMC||chr(9)||KAIDANKS||chr(9)||KAIDANKSMC||chr(9)||KAIDANYS||chr(9)||KAIDANYSXM||chr(9)||ZHIXINGKS||chr(9)||ZHIXINGKSMC||chr(9)||ZHIXINGREN||chr(9)||ZHIXINGRXM||chr(9)||to_char(ZHIXINGRQ , 'yyyy-mm-dd hh24:mi:ss') FROM YJ_V_ZHILIAODAN WHERE MENZHENZYBZ=:A1
21sxrpfuc4fwh SELECT JIAGEID||chr(:"SYS_B_00")||ZHANGBULB||chr(:"SYS_B_01")||YAOPINMC||chr(:"SYS_B_02")||KUCUNZSL||chr(:"SYS_B_03")||KUCUNLSL||chr(:"SYS_B_04")||PANCUNZSL||chr(:"SYS_B_05")||PANCUNLSL||chr(:"SYS_B_06")||PIFAJIA||chr(:"SYS_B_07")||LINGSHOUJIA||chr(:"SYS_B_08")||CHANDIMC||chr(:"SYS_B_09")||BAOZHUANGDW||chr(:"SYS_B_10")||DANJIA1||chr(:"SYS_B_11")||YAOPINLX||chr(:"SYS_B_12")||YAOPINGG||chr(:"SYS_B_13")||BAOZHUANGLIANG||chr(:"SYS_B_14")||SHIYONGPL||chr(:"SYS_B_15")||YINGYONGID||chr(:"SYS_B_16")||DULIFL||chr(:"SYS_B_17")||YAOPINMC||YAOPINGG||chr(:"SYS_B_18")||Pkg_GY_KuFangGY.Fun_GY_GetBaiFangWZ(JIAGEID, :"SYS_B_19")||chr(:"SYS_B_20")||Pkg_GY_KuFangGY.Fun_GY_GetKuCunSL(JIAGEID, :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24")||chr(:"SYS_B_25")||Case When LINGCHAJBZ = :"SYS_B_26" And :"SYS_B_27" = :"SYS_B_28" Then pkg_gy_kufanggy.Fun_GY_GetYaoFangJJ(:"SYS_B_29", JIAGEID, :"SYS_B_30") Else JINJIA End||chr(:"SYS_B_31")||SHURUMA1||chr(:"SYS_B_32")||SHURUMA2||chr(:"SYS_B_33")||SHURUMA3||chr(:"SYS_B_34")||YAOPINID||chr(:"SYS_B_35")||YAOPINFLMC||chr(:"SYS_B_36")||YAOPINBZBM||chr(:"SYS_B_37")||SHENGCHANPH||c hr(:"SYS_B_38")||GUANLIMS||chr(:"SYS_B_39")||to_char(YAOPINXQ , :"SYS_B_40")||chr(:"SYS_B_41")||LINGCHAJBZ||chr(:"SYS_B_42")||Pkg_GY_KuFangGY.Fun_GY_GetKuCunSL_LCJ(JIAGEID, :"SYS_B_43", :"SYS_B_44", :"SYS_B_45", :"SYS_B_46", LINGSHOUJIA, SHENGCHANPH, YAOPINXQ)||chr(:"SYS_B_47")||MAXYAOPINFLID||chr(:"SYS_B_48")||MINYAOPINFLID||chr(:"SYS_B_49")||JINJIA||chr(:"SYS_B_50")||Pkg_GY_KuFangGY.Fun_Gy_GetKuCunSL_New(JIAGEID, :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54", JINJIA, SHENGCHANPH, YAOPINXQ) FROM BY_V_PILIANGSCPCDMX WHERE :"SYS_B_55"=:"SYS_B_56" AND ZHANGBULB IN (:"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61", :"SYS_B_62", :"SYS_B_63", :"SYS_B_64", :"SYS_B_65", :"SYS_B_66", :"SYS_B_67", :"SYS_B_68", :"SYS_B_69") AND SHIYONGPL <> :"SYS_B_70" AND YINGYONGID=:A1
22jdv01bx51vt SELECT case a.YAOPINLX when :"SYS_B_00" then :"SYS_B_01" when :"SYS_B_02" then :"SYS_B_03" when :"SYS_B_04" then :"SYS_B_05" when :"SYS_B_06" then :"SYS_B_07" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_08"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx_Ex(a.Jiageid, :"SYS_B_09", d.YingYongID) As Danjia1, d.KuCunSL AS KuCunSL, a.JIAGEID, a.YAOPINMC as ZHUMINGMC, b.BIEMINGID, a.ZHANGBULB, a.GUIGEID, a.CHANDI, a.SHOUFEIXM, a.DULIFL, a.JIAZHIFL, a.GEIYAOFS, a.YONGYAOTC, a.PISHIBZ, a.KANGSHENGSXJ, a.KANGJUNYXJ, a.DASHUYBZ, a.FUFANGBZ, a.JIZHENYYBZ, a.JIXING, :"SYS_B_10" As XiangMuLX, a.DuiYingPSYP, b.YAOPINMC as BIEMINGMC, a.YAOPINGG, a.YiBaoDJ, a.ZuiXiaoDW, a.JiLiang, a.JiLiangDW, a.PingJunJJ, a.PiFaJia, a.YaoPinLX, a.BaoZhuangLiang, a.XianLiang3, a.XianLiang7, a.TiJi, a.TiJiDW, e.YAOPINFL, a.FuYaoSX, a.YaoPinID, a.XiaoGuiGID, a.DaGuiGID, a.QiTaSX, a.DuiYingPSYPSL, a.LingChaJBZ FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.YingYongID, a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL , a.LAIYUAN From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_11" And a.YingYongID=:"SYS_B_12") or (b.YaoPinLX=:"SYS_B_13" And a.YingYongID=:"SYS_B_14") or (b.YaoPinLX=:"SYS_B_15" And a.YingYongID=:"SYS_B_16") or (b.YaoPinLX=:"SYS_B_17" And a.YingYongID=:& quot;SYS_B_18"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = :"SYS_B_19" And a.ZUOFEIBZ = :"SYS_B_20" AND a.CHAXUNBZ = :"SYS_B_21" And (b.SHURUMA1 Like :"SYS_B_22" or b.yaopinmc like :"SYS_B_23") and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_24") = :"SYS_B_25" and (a.JiaGeId=d.JiaGeID(+)) and a.GuiGeID = a.DaGuiGID and a.TINGYONGBZ = :"SYS_B_26" union all SELECT case a.YAOPINLX when :"SYS_B_27" then :"SYS_B_28" when :"SYS_B_29" then :"SYS_B_30" when :"SYS_B_31" then :"SYS_B_32" when :"SYS_B_33" then :"SYS_B_34" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_35"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx_Ex(a.Jiageid, :"SYS_B_36", d.YingYongID) As Danjia1, d.KuCunSL AS KuCunSL, a.JIAGEID, a.YAOPINMC as ZHUMINGMC, b.BIEMINGID, a.ZHANGBULB, a.GUIGEID, a.CHANDI, a.SHOUFEIXM, a.DULIFL, a.JIAZHIFL, a.GEIYAOFS, a.YONGYAOTC, a.PISHIBZ, a.KANGSHENGSXJ, a.KANGJUNYXJ, a.DASHUYBZ, a.FUFANGBZ, a.JIZHENYYBZ, a.JIXING, :"SYS_B_37" As XiangMuLX, a.DuiYingPSYP, b.YAOPINMC as BIEMINGMC, a.YAOPINGG, a.YiBaoDJ, a.ZuiXiaoDW, a.JiLiang, a.JiLiangDW, a.PingJunJJ, a.PiFaJia, a.YaoPinLX, a.BaoZhuangLiang, a.XianLiang3, a.XianLiang7, a.TiJi, a.TiJiDW, e.YAOPINFL, a.FuYaoSX, a.YaoPinID, a.XiaoGuiGID, a.DaGuiGID, a.QiTaSX, a.DuiYingPSYP SL, a.LingChaJBZ FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.YingYongID, a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL , a.LAIYUAN From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_38" And a.YingYongID=:"SYS_B_39") or (b.YaoPinLX=:"SYS_B_40" And a.YingYongID=:"SYS_B_41") or (b.YaoPinLX=:"SYS_B_42" And a.YingYongID=:"SYS_B_43") or (b.YaoPinLX=:"SYS_B_44" And a.YingYongID=:"SYS_B_45"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = :"SYS_B_46" And a.ZUOFEIBZ = :"SYS_B_47" AND a.CHAXUNBZ = :"SYS_B_48" And b.SHURUMA1 Like :"SYS_B_49" and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_50") = :"SYS_B_51" and (a.JiaGeId=d.JiaGeID(+)) and a.GuiGeID = a.DaGuiGID and a.TINGYONGBZ = :"SYS_B_52"
291qc4sadytyj BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('108', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
2bbt948395up8 SELECT PAIDUIID||chr(:"SYS_B_00")||PAIDUIXH||chr(:"SYS_B_01")||BINGRENID||chr(:"SYS_B_02")||BINGRENXM||chr(:"SYS_B_03")||JIUZHENKH||chr(:"SYS_B_04")||PAIDUIPH||chr(:"SYS_B_05")||SHANGXIAWBZ||chr(:"SYS_B_06")||ZHUANGTAIID||chr(:"SYS_B_07")||YISHENGID||chr(:"SYS_B_08")||DUILIEID||chr(:"SYS_B_09")||YUANQUID||chr(:"SYS_B_10")||YINGYONGID||chr(:"SYS_B_11")||DUILIEMC||chr(:"SYS_B_12")||PAIDUILXID||chr(:"SYS_B_13")||LEIXINMC||chr(:"SYS_B_14")||to_char(RUDUISJ , :"SYS_B_15")||chr(:"SYS_B_16")||YEWUXH||chr(:"SYS_B_17")||YEWUID||chr(:"SYS_B_18")||XINGBIE||chr(:"SYS_B_19")||YEWUXX||chr(:"SYS_B_20")||QIANMIANRS||chr(:"SYS_B_21")||to_char(JIUZHENRQ , :"SYS_B_22")||chr(:"SYS_B_23")||YUYUBZ||chr(:"SYS_B_24")||YUYUELX FROM JH_PAIDUIDL WHERE DUILIEID = :"SYS_B_25" And JIUZHENRQ = to_date(:"SYS_B_26", :"SYS_B_27") AND :"SYS_B_28"=:A
2h3qjrgdj40dj BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('129', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
2n79auny8j7qs SELECT SUM(ROUND(B.JIESUANJE, :"SYS_B_0")) AS FEIYONGHJ, B.HESUANXM, B.ZHIXINGKS FROM ZY_FEIYONG1 B WHERE B.JIFEIRQ BETWEEN TO_DATE(:"SYS_B_1" || :"SYS_B_2", :"SYS_B_3") AND TO_DATE(:"SYS_B_4" || :"SYS_B_5", :"SYS_B_6") GROUP BY B.HESUANXM, B.ZHIXINGKS ORDER BY B.ZHIXINGKS
2p09jrn1gd47b begin select SEQ_ZY_JIESUAN2.nextval into :xuhao from DUAL; end;
2sk5ykz25tzup SELECT A.BINGRENID, A.ZHUYUANHAO, A.BINGANHAO, A.XINGMING, A.XINGBIE, B.NIANLING AS NIANLING, PKG_GY.FUN_GET_ZHIGONGXX(B.ZHUYUANYS, :"SYS_B_00") ZHUYUANYSXM, PKG_GY.FUN_GET_ZHIGONGXX(B.ZHUZHIYS, :"SYS_B_01") ZHUZHIYSXM, B.ZHUZHIYS, PKG_GY.FUN_GET_KESHIMC(A.RUYUANKS) AS RUYUANKSMC, TO_CHAR(A.RUYUANRQ, :"SYS_B_02") AS RUYUANRQ, NVL(PKG_ZY_EMRAPP.FUN_GET_BINGRENRYZD(A.BINGRENID), A.RUYUANZDMC) AS RUYUANZD, PKG_GY.FUN_GET_KESHIMC(A.DANGQIANKS) AS CHUYUANKSMC, TO_CHAR(A.CHUYUANRQ, :"SYS_B_03") AS CHUYUANRQ, PKG_ZY_EMRAPP.FUN_GET_BINGRENCYZD(A.BINGRENID) AS CHUYUANZD, decode(TRUNC(NVL(a.CHUYUANRQ, SYSDATE))-TRUNC(a.RUYUANRQ), :"SYS_B_04", :"SYS_B_05", TRUNC(NVL(a.CHUYUANRQ, SYSDATE))-TRUNC(a.RUYUANRQ)) AS ZHUYUANTS, A.ZHUYUANCS, NVL(B.GUIDANGBZ, :"SYS_B_06") AS GUIDANGBZ, A.DANGQIANCW, PKG_ZY_EMRAPP.FUN_GET_BINGRENZGQK(:"SYS_B_07", A.BINGRENID) AS BINGRENZG, B.ZHIYE AS ZHIYEID, :"SYS_B_08" ZHIYE, B.HUKOUDZ, B.GONGZUODW, B.GUANXIRDH, PKG_BINGLIGL.Fun_Get_SUODINGZT(TO_NUMBER(A.BINGRENID), :"SYS_B_09", :"SYS_B_10") SUODINGZT, TO_CHAR(DECODE(B.LIYUANFS, NULL, B.SIWANGBZ, :"SYS_B_11", :"SYS_B_12", NULL)) SIWANGBZ, B.SIWANGYY, B.SIWANGRQ, A.JIATINGDZ, A.LIANXIRDH, A.LIANXIREN, A.JIATINGDH , PKG_GY.FUN_GET_BINGQUMC(A.DANGQIANBQ) DANGQIANBQMC, A.DANGQIANBQ, PKG_ZY_EMRAPP.FUN_GET_BINGRENZDMC(A.BINGRENID, :"SYS_B_13", :"SYS_B_14") CHUYUANZZD, TO_CHAR(A.YUCHUYRQ, :"SYS_B_15") AS YUCHUYRQ, NVL(A.YUANQUID, :"SYS_B_16") AS YUANQUID, PKG_GY.FUN_GET_ZHIGONGXX(B.ZHURENYS, :"SYS_B_17") ZHURENYSXM, B.ZHURENYS, C.BIAOJIID , A.FEIYONGXZ, A.FEIYONGLB, d.ZHUZHENDUANZYHZQK , C.BEIWANGXX , PKG_ZY_EMRAPP.FUN_GET_BINGRENZDBKLX(A.BINGRENID, :"SYS_B_18") AS BAOKALX FROM V_ZY_BINGRENJBXX A, V_BL_BINGRENJBXX B, BL_BINGRENJBXX_KZXX D, BL_BINGLIBWJL C WHERE A.BINGRENID = B.BINGRENID AND A.BINGRENID= D.BINGRENID(+) AND B.BINGRENID = C.BINGRENID(+) AND A.RUYUANRQ >= :RUYUANSJ_S AND A.RUYUANRQ <= :RUYUANSJ_E AND A.DANGQIANKS =:KESHI Order By A.RUYUANRQ
2xqt1w0rd1mub Select Nvl(Sum(KuCunSL - Nvl(YiShouWFSL, :"SYS_B_00")), :"SYS_B_01"), Nvl(Sum(KuCunSL - Nvl(YiShouWFSL, :"SYS_B_02")), :"SYS_B_03"), Nvl(Sum(KuCunSL - Nvl(YiShouWFSL, :"SYS_B_04") - Nvl(XuKuCSL, :"SYS_B_05") - Nvl(LinShiKCSL, :"SYS_B_06")), :"SYS_B_07"), Nvl(Sum(KuCunSL - Nvl(XuKuCSL, :"SYS_B_08")), :"SYS_B_09") From BY_KuCun2 Where YingYongID = :"SYS_B_10" And JiaGeID = :"SYS_B_11" And NVL(TingYongBZ, :"SYS_B_12") = :"SYS_B_13" And KuCunSL > :"SYS_B_14" And JinJia = :"SYS_B_15" And ShengChanPH = :"SYS_B_16" And YaoPinXQ = To_Date(:"SYS_B_17", :"SYS_B_18")
32apq41xqy74s SELECT PKG_GY_KUFANGGY.FUN_GY_GETKUCUNJGID(:B2 , :B1 , '2') FROM DUAL
3ccb451dhwj9r SELECT SHOUFEIID||chr(:"SYS_B_00")||FAPIAOID||chr(:"SYS_B_01")||YINGYONGID||chr(:"SYS_B_02")||CHUFANGID||chr(:"SYS_B_03")||CHUFANGHM||chr(:"SYS_B_04")||FEIYONGLB||chr(:"SYS_B_05")||FEIYONGXZ||chr(:"SYS_B_06")||KAIDANKS||chr(:"SYS_B_07")||KAIDANYS||chr(:"SYS_B_08")||BINGRENID||chr(:"SYS_B_09")||BINGRENXM||chr(:"SYS_B_10")||XINGBIE||chr(:"SYS_B_11")||NIANLING||chr(:"SYS_B_12")||NIANLINGDW||chr(:"SYS_B_13")||CHUFANGLX||chr(:"SYS_B_14")||PISHIBZ||chr(:"SYS_B_15")||SHOUFEIBZ||chr(:"SYS_B_16")||FAYAOBZ||chr(:"SYS_B_17")||JIANYAOFS||chr(:"SYS_B_18")||JIZHENBZ||chr(:"SYS_B_19")||JIAOYILX||chr(:"SYS_B_20")||CHONGXIAOBZ||chr(:"SYS_B_21")||CHUFANGTS||chr(:"SYS_B_22")||YISHENGZT||chr(:"SYS_B_23")||TESHUFF||chr(:"SYS_B_24")||KESHIMC||chr(:"SYS_B_25")||LIANXIRDZ||chr(:"SYS_B_26")||XINGZHIMC||chr(:"SYS_B_27")||to_char(KAIDANRQ , :"SYS_B_28")||chr(:"SYS_B_29")||LIANXIRDH||chr(:"SYS_B_30")||JIUZHENKH||chr(:"SYS_B_31")||YICHANGBZ||chr(:"SYS_B_32")||JIBING||chr(:"SYS_B_33")||SHOUFEIYUAN||chr(:"SYS_B_34")||CHUANGKOUID||chr(:"SYS_B_35")||TIZHONG||chr(:"SYS_B_36")||ZHUSHEFEI||chr(:"SYS_B_37")||KONGZHISX||chr(:"SYS_B_38 ")||DULIFL||chr(:"SYS_B_39")||ISGUIZONGPSCF||chr(:"SYS_B_40")||SHENHEREN||chr(:"SYS_B_41")||SHENHEREN2||chr(:"SYS_B_42")||BEIYAODYBZ||chr(:"SYS_B_43")||FAYAOSHBZ||chr(:"SYS_B_44")||SHENHERXM||chr(:"SYS_B_45")||SHENHER2XM||chr(:"SYS_B_46")||BEIYAOBZ||chr(:"SYS_B_47")||TUIYAOYY||chr(:"SYS_B_48")||DAIJIANTS||chr(:"SYS_B_49")||JIATINGDZ||chr(:"SYS_B_50")||JIATINGDH||chr(:"SYS_B_51")||CHUFANGFYSL||chr(:"SYS_B_52")||JIUZHENID||chr(:"SYS_B_53")||YIBAOKH||chr(:"SYS_B_54")||GONGZUODW||chr(:"SYS_B_55")||DANWEIDH||chr(:"SYS_B_56")||YIBAOBRXX||chr(:"SYS_B_57")||JIESUANLB||chr(:"SYS_B_58")||FAPIAOHM||chr(:"SYS_B_59")||SHOUFEIFS||chr(:"SYS_B_60")||WAIPEIBZ||chr(:"SYS_B_61")||to_char(SHOUFEIRQ , :"SYS_B_62")||chr(:"SYS_B_63")||SHENFENZH||chr(:"SYS_B_64")||FAYAOREN||chr(:"SYS_B_65")||FAYAORXM||chr(:"SYS_B_66")||to_char(FAYAOSJ , :"SYS_B_67")||chr(:"SYS_B_68")||GONGFEIZH||chr(:"SYS_B_69")||HUJIAOBZ FROM MY_V_CHUFANGBY WHERE KUFANGYYID = :"SYS_B_70" AND FAYAOBZ = :"SYS_B_71" AND JIAOYILX = :"SYS_B_72" AND CHONGXIAOBZ = :"SYS_B_73" AND (KAIDANRQ BETWEEN TO_DATE(:A1, :"SYS_B_74") AND TO_DATE(:A2, :"SYS_B_75")) AND Pkg_GY_Ku FangGY.Fun_GY_HaveChuFangLX(CHUFANGLX, :"SYS_B_76") = :"SYS_B_77" AND (BEIYAOBZ = :"SYS_B_78" OR BEIYAOBZ = :"SYS_B_79") AND (SHOUFEIBZ = :"SYS_B_80" OR WEISHOUXFBZ = :"SYS_B_81" OR FAYAOBZ = -:"SYS_B_82") And WAIPEIBZ = :"SYS_B_83"
3gu3jwxnrb2hf SELECT JIFEIJKID FROM ZY_JIFEIJK1 WHERE YIZHUID = :A
3jyu041kv22wx begin Pkg_BY_FaYao . Prc_BY_YiZhuFY ( :prm_FaYaoXH , :prm_YingYongID , :prm_YuanQuID , :prm_JiLuLY , :prm_LaiYuanID , :prm_ShenQingDList , :prm_FaYaoKS , :prm_FaYaoRen , :prm_ShenHeRen , :prm_BingRenZYID , :prm_YingErID , :prm_AppCode:NULL_VALUE , :prm_OutBuffer:NULL_VALUE ) ; END ;
3nb48pv52ujm8 SELECT XIANSHISJ, XIANSHIBZ, NEIRONG1|| :"SYS_B_0" xuhao, NEIRONG2 dangqianjz, NEIRONG3 zhenshi, NEIRONG4 yisheng, :"SYS_B_1" zhunbeijz, hangzhi, yewuid FROM JH_PINGMUXS WHERE YINGYONGID = :"SYS_B_2" AND XIANSHIBZ >= :"SYS_B_3" and pingmuid=:"SYS_B_4" ORDER BY HANGZHI
3w5bj9r5mj65z SELECT FEIYONGID||chr(9)||YINGYONGID||chr(9)||KAIDANYYID||chr(9)||YUANQUID||chr(9)||BINGRENZYID||chr(9)||BINGRENID||chr(9)||YINGERID||chr(9)||BAOXIAOID||chr(9)||JIESUANSB||chr(9)||HESUANXM||chr(9)||XIANGMUID||chr(9)||XIANGMULX||chr(9)||TAOCANID||chr(9)||XIANGMUMC||chr(9)||BIAOZHUNJIA||chr(9)||JIESUANJIA||chr(9)||XIANJIA||chr(9)||SHULIANG||chr(9)||BIAOZHUNJE||chr(9)||JIESUANJE||chr(9)||DANGQIANBQ||chr(9)||BINGQUMC||chr(9)||DANGQIANKS||chr(9)||KESHIMC||chr(9)||DANGQIANCW||chr(9)||GUANLIKS||chr(9)||GUANLIKSMC||chr(9)||JIECHUANGBZ||chr(9)||JIATINGBCBZ||chr(9)||FUFANGBZ||chr(9)||FENTANBL||chr(9)||ZIFUBL||chr(9)||YOUHUIBL||chr(9)||KAIDANYS||chr(9)||KAIDANYSXM||chr(9)||KAIDANYSZ||chr(9)||KAIDANKS||chr(9)||KAIDANYSZM||chr(9)||KAIDANKSMC||chr(9)||ZHIXINGKS||chr(9)||ZHIXINGKSMC||chr(9)||ZHUZHIYS||chr(9)||ZHUZHIYSXM||chr(9)||YILIAOZU||chr(9)||YILIAOZM||chr(9)||ZILIJE||chr(9)||ZIFEIJE||chr(9)||ZIFEIBZ||chr(9)||ZIFEISM||chr(9)||QIANGZHIBZ||chr(9)||KETUIJE||chr(9)||KETUISL||chr(9)||JIAOYILX||chr(9)||YUANFEIYID||chr(9)||YIBAODM||chr(9)||YIBAOZFBL||chr(9)||YIBAODJ||chr(9)||SHENPIBH||chr(9)||YIZHUID||chr(9)||JIFEIID||chr(9)||FEIYONGKZ||chr(9)||ZIDONGJFID||chr(9)||BEIZHU||chr(9)||JIFEIREN||chr(9)||JIFEIRXM||chr(9)||JIFEIKS||chr(9)||JIFEIKSMC||chr(9)||to_char(JIFEIRQ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||to_char(FASHENGRQ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||FUHEREN||chr(9)||FUHERXM||chr(9)||to_char(FUHERQ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||to_char(SHANGCHUANRQ , 'yyyy-mm-dd hh24:mi:ss')||chr (9)||JIESUANXH||chr(9)||SHOUFEIFS||chr(9)||PINCI||chr(9)||YICIJL||chr(9)||YAOPINGG||chr(9)||YICIJLDW||chr(9)||BAOZHUANGLIANG||chr(9)||JIJIADW||chr(9)||ZUIXIAODW||chr(9)||JILIANG||chr(9)||JILIANGDW||chr(9)||SHENPILX||chr(9)||JINJIA||chr(9)||CHONGSUANBZ||chr(9)||YIBAOXX||chr(9)||YIBAOSFLB||chr(9)||SHIYONGYLYBDM||chr(9)||SHANGCHUANLSH||chr(9)||CHUFANGLSH FROM ZY_FEIYONG1 WHERE YIZHUID=:A1
4gf2f3ajd1jsg INSERT INTO ZY_JIESUAN2 (BINGRENID, BINGRENZYID, HESUANXM, JIESUANID, JIESUANJE, JIESUANMXID, JIESUANXH, YINGERID, YINGYONGID, YOUHUIJE, YUANQUID, ZIFEIJE, ZILIJE, MUQINZYID, YINGERBZ) VALUES (:B14 , :B13 , :B12 , :B11 , :B10 , FUN_GY_GETORDER(:B5 , 'ZY_JIESUAN2', 10), :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
4gqsss1qnupwb SELECT BINGRENID||chr(:"SYS_B_00")||GUAHAOID||chr(:"SYS_B_01")||GUAHAOXH||chr(:"SYS_B_02")||FAPIAOHM||chr(:"SYS_B_03")||JIUZHENKH||chr(:"SYS_B_04")||BINGRENXM||chr(:"SYS_B_05")||GUAHAOKSMC||chr(:"SYS_B_06")||GUAHAOYSXM||chr(:"SYS_B_07")||JINE||chr(:"SYS_B_08")||to_char(GUAHAORQ , :"SYS_B_09")||chr(:"SYS_B_10")||BINGANHAO||chr(:"SYS_B_11")||GUAHAOLBMC||chr(:"SYS_B_12")||GUAHAOSD||chr(:"SYS_B_13")||YUYUELXMC||chr(:"SYS_B_14")||ZHUANGTAIMC||chr(:"SYS_B_15")||ZHUANGTAI||chr(:"SYS_B_16")||GUAHAORXM||chr(:"SYS_B_17")||to_char(CHUSHENGRQ , :"SYS_B_18")||chr(:"SYS_B_19")||XINGBIE||chr(:"SYS_B_20")||ZUOFEIBZ||chr(:"SYS_B_21")||SHOUFEIID||chr(:"SYS_B_22")||FEIYONGLB||chr(:"SYS_B_23")||YUANQUID||chr(:"SYS_B_24")||YINGYONGID||chr(:"SYS_B_25")||PAIBANID||chr(:"SYS_B_26")||YOUHUILB||chr(:"SYS_B_27")||YUYUEBZ||chr(:"SYS_B_28")||YUYUELX||chr(:"SYS_B_29")||GUAHAOLB||chr(:"SYS_B_30")||GUAHAOKS||chr(:"SYS_B_31")||GUAHAOYS||chr(:"SYS_B_32")||SHANGXIAWBZ||chr(:"SYS_B_33")||JIAOYILX||chr(:"SYS_B_34")||GUAHAOREN||chr(:"SYS_B_35")||FEIYONGXZ||chr(:"SYS_B_36")||YIBAOKH||chr(:"SYS_B_37")||to_char(ZHIDANRQ , :"SYS_B_38&qu ot;) FROM MZ_V_YIGUAHXX WHERE (GUAHAORQ BETWEEN TO_DATE(:"SYS_B_39", :"SYS_B_40") AND TO_DATE(:"SYS_B_41", :"SYS_B_42")) AND FAPIAOHM LIKE :A1 AND JIAOYILX = :"SYS_B_43" AND ZUOFEIBZ = :"SYS_B_44" And ZHUANGTAIMC <> :A2
4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4np4fqp3v18qh begin PKG_ZY_YEWU . Prc_ZY_YuJieSuan ( :prm_BingRenZYID , :prm_YingYongID , :prm_JieSuanFS , :prm_AppCode:inappcode , :prm_OutBuffer:inoutput ) ; END ;
52w9gnwhhnt62 SELECT B.JIBINGMC, B.ZHENDUANSM, B.ZHONGYIZZZDJLID FROM V_BL_BINGRENZDQK B WHERE B.BINGRENID = :B3 AND ZHENDUANLX = :B2 AND (NVL(B.ZHONGYIZDBZ, 0) = :B1 OR (:B1 = 9)) ORDER BY B.ZHENDUANLX , B.ZHENDUANSJ
58nqcgq93qdpp SELECT sysdate FROM dual
596aaa7y9rr3h SELECT JINJIA FROM ( SELECT JINJIA FROM BY_KUCUN2 WHERE JIAGEID = :B2 AND YINGYONGID = :B1 AND JINJIA > 0 ORDER BY JINHUORQ DESC) WHERE ROWNUM = 1
5avb9xmhsx2k4 SELECT COUNT(*) FROM (SELECT A.WEIZHONGID, A.WEIZHONGMXID, A.CAIJIREN, A.CAIJIRQ, A.CAIJISJ, A.SHUJULB, A.CAIJINR, A.CAIJIRENXM, A.XIUGAIREN, A.XIUGAIRENXM, A.XIUGAISJ, A.SHENHEREN, A.SHENHERENXM, A.SHENHESJ, A.VIEWDATA FROM HL_WEIZHONGHLXXMX A WHERE A.WEIZHONGID IN('200124') AND NVL(A.ZUOFEIBZ, 0)=0 ORDER BY A.CAIJIRQ DESC , A.CAIJISJ DESC , A.SHUJULB DESC)
5d8dmu32amh58 SELECT A.DANGQIANCW||chr(:"SYS_B_000")||B.YIZHUID||chr(:"SYS_B_001")||B.YINGYONGID||chr(:"SYS_B_002")||B.YUANQUID||chr(:"SYS_B_003")||B.BINGQUID||chr(:"SYS_B_004")||B.BINGRENZYID||chr(:"SYS_B_005")||B.YINGERID||chr(:"SYS_B_006")||B.BINGRENXM||chr(:"SYS_B_007")||B.YIZHUXMID||chr(:"SYS_B_008")||B.YIZHUMC||chr(:"SYS_B_009")||to_char(B.KAIZHUSJ , :"SYS_B_010")||chr(:"SYS_B_011")||B.YIZHUMS||chr(:"SYS_B_012")||to_char(B.SHURUSJ , :"SYS_B_013")||chr(:"SYS_B_014")||B.PINCI||chr(:"SYS_B_015")||B.SHURUREN||chr(:"SYS_B_016")||to_char(B.KAISHISJ , :"SYS_B_017")||chr(:"SYS_B_018")||to_char(B.JIESHUSJ , :"SYS_B_019")||chr(:"SYS_B_020")||B.YIZHUFL||chr(:"SYS_B_021")||B.GEIYAOFS||chr(:"SYS_B_022")||B.GEIYAOFSLX||chr(:"SYS_B_023")||B.GEIYAOFSMC||chr(:"SYS_B_024")||B.KAIZHUYS||chr(:"SYS_B_025")||B.KAIZHUYSXM||chr(:"SYS_B_026")||B.KAIZHUKS||chr(:"SYS_B_027")||B.KAIZHUKSMC||chr(:"SYS_B_028")||B.KAIZHUBQ||chr(:"SYS_B_029")||B.KAIZHUBQMC||chr(:"SYS_B_030")||to_char(B.ZHIXINGSJ , :"SYS_B_031")||chr(:"SYS_B_032")||B.ZHIXINGREN||chr(:"SYS_B_033")||to_char(B.TINGZHUSJ , :"SYS_B_034")||chr(:"SYS_B_035")||to_char(B.FUHESJ , :"SYS_B_036&q uot;)||chr(:"SYS_B_037")||B.FUHEREN||chr(:"SYS_B_038")||B.TINGZHUREN||chr(:"SYS_B_039")||B.TINGZHUFHR||chr(:"SYS_B_040")||to_char(B.TINGZHUFHSJ , :"SYS_B_041")||chr(:"SYS_B_042")||to_char(B.CHEXIAOSJ , :"SYS_B_043")||chr(:"SYS_B_044")||B.CHEXIAOREN||chr(:"SYS_B_045")||B.YIZHUZT||chr(:"SYS_B_046")||B.DANGQIANZT||chr(:"SYS_B_047")||to_char(B.ZHUANGTAISJ , :"SYS_B_048")||chr(:"SYS_B_049")||B.YICIJL||chr(:"SYS_B_050")||B.YICIJLDW||chr(:"SYS_B_051")||B.YICIYL||chr(:"SYS_B_052")||B.BAOZHUANGLIANG||chr(:"SYS_B_053")||B.BAOZHUANGDW||chr(:"SYS_B_054")||B.JILIANG||chr(:"SYS_B_055")||B.JILIANGDW||chr(:"SYS_B_056")||B.ZUIXIAODW||chr(:"SYS_B_057")||B.FUYIZMC||chr(:"SYS_B_058")||B.YAOFANGYYID||chr(:"SYS_B_059")||B.YAOPINMC||chr(:"SYS_B_060")||B.YAOPINGG||chr(:"SYS_B_061")||B.GUIGEID||chr(:"SYS_B_062")||B.JIAGEID||chr(:"SYS_B_063")||B.YAOPINBMID||chr(:"SYS_B_064")||B.CHANDILB||chr(:"SYS_B_065")||to_char(B.PAICHISJ , :"SYS_B_066")||chr(:"SYS_B_067")||B.PAICHIYZID||chr(:"SYS_B_068")||B.JIXING||chr(:"SYS_B_069")||B.PISHIJG||chr(:"SYS_B_070")||B.LINGYAOFS||chr(:"SYS_B_071")||B.DAYINBZ||chr(:"SYS_B_072")||B.FUYIZID||chr(:"SYS_B_073&q uot;)||B.YISHENGZID||chr(:"SYS_B_074")||B.DANJIA||chr(:"SYS_B_075")||B.YISHENGZT||chr(:"SYS_B_076")||B.ZHIXINGYL||chr(:"SYS_B_077")||B.KESHIID||chr(:"SYS_B_078")||B.ZUHAO||chr(:"SYS_B_079")||B.PAICHILX||chr(:"SYS_B_080")||B.PAIXUBH||chr(:"SYS_B_081")||B.SHOURICS||chr(:"SYS_B_082")||B.DANGRICS||chr(:"SYS_B_083")||B.DAYINJL||chr(:"SYS_B_084")||B.MORICS||chr(:"SYS_B_085")||B.QIANGZHIBZ||chr(:"SYS_B_086")||B.JIZHENBZ||chr(:"SYS_B_087")||B.CHULIYJ||chr(:"SYS_B_088")||B.BINGRENID||chr(:"SYS_B_089")||B.ZUIXIAODWZXYL||chr(:"SYS_B_090")||B.ZUIXIAODWYL||chr(:"SYS_B_091")||B.PISHIBZ||chr(:"SYS_B_092")||B.FUYAOSX||chr(:"SYS_B_093")||B.YEJIANBZ||chr(:"SYS_B_094")||B.TAKEBZ||chr(:"SYS_B_095")||B.CAOYAOBZ||chr(:"SYS_B_096")||B.DAIJIANTS||chr(:"SYS_B_097")||B.QIANFEISHBZ||chr(:"SYS_B_098")||B.YIYUANSPBZ||chr(:"SYS_B_099")||B.YIYUANSPLX||chr(:"SYS_B_100")||B.YIYUANSPSM||chr(:"SYS_B_101")||B.YIYUANSPBL||chr(:"SYS_B_102")||B.DONGJIEBZ||chr(:"SYS_B_103")||B.TUIYAOSPBZ||chr(:"SYS_B_104")||B.ZHIXINGZT||chr(:"SYS_B_105")||A.YINGERBZ||chr(:"SYS_B_106")||A.MUQINZYID||chr(:"SYS_B_107")||to_char(B.DONGJIERQ , :"SYS_B_108")||chr(:"SYS_B_109")||to_ch ar(B.JIEDONGRQ , :"SYS_B_110")||chr(:"SYS_B_111")||B.PISHILX||chr(:"SYS_B_112")||B.PISHIFHR1||chr(:"SYS_B_113")||to_char(B.PISHIFHSJ1 , :"SYS_B_114")||chr(:"SYS_B_115")||B.PISHIFHR2||chr(:"SYS_B_116")||to_char(B.PISHIFHSJ2 , :"SYS_B_117")||chr(:"SYS_B_118")||C.YIRICS||chr(:"SYS_B_119")||C.PINCILX FROM ZY_BINGRENXX A, YZ_BINGRENYZ B, GY_PINCI C WHERE A.BINGRENZYID = B.BINGRENZYID and B.PINCI = C.PINCIID AND KAIZHUBQ=:"SYS_B_120" and (Decode(YiZhuZT, :"SYS_B_121", NULL, YIZHUZT)=:"SYS_B_122" or Decode(YiZhuZT, :"SYS_B_123", NULL, YIZHUZT)=:"SYS_B_124") And ZhiXingZT = :"SYS_B_125" and :"SYS_B_126"=:A
5p3wb4w001mhh SELECT PINCILX FROM GY_PINCI WHERE PINCIID = :B1
6cksnupbmk7kp SELECT COUNT(B.YIZHUXMID), B.YIZHUXMID, B.XIANSHIMC FROM YZ_BINGRENYZ A, YZ_CHUANGWEIPXS B, ZY_BINGRENXX C WHERE A.YIZHUFL = '1' AND A.YIZHUXMID = B.YIZHUXMID AND A.BINGRENZYID = C.BINGRENZYID AND A.YIZHUZT IN ('1', '2', '3') AND (C.YINGERBZ = 0 OR C.YINGERBZ IS NULL) AND B.XIANSHILX = '3' AND C.DANGQIANBQ = :B1 GROUP BY B.YIZHUXMID, B.XIANSHIMC HAVING COUNT(B.YIZHUXMID) > 0
6dtu480vu4auh SELECT b.paiduiph, bingrenxm FROM JH_DUILIEXX A, JH_PAIDUIDL B WHERE B.DUILIEID in(a.duilieid, a.fuduilid) and B.zhuangtaiid=:"SYS_B_0" AND A.DUILIEID IN (SELECT DUILIEID FROM JH_PAIDUIDL WHERE PAIDUIID = :"SYS_B_1" UNION ALL SELECT DUILIEID FROM JH_JIESHUDL WHERE PAIDUIID = :"SYS_B_2") order by b.paiduixh
6pwhuakcu5kqq select soufull , souid from l_source where souid =( select min ( souid ) from l_source where deviceid =:1 )
6uutwag4x46tr SELECT B.YIZHUID||chr(:"SYS_B_000")||B.YINGYONGID||chr(:"SYS_B_001")||B.YUANQUID||chr(:"SYS_B_002")||B.BINGRENZYID||chr(:"SYS_B_003")||B.YINGERID||chr(:"SYS_B_004")||B.BINGRENXM||chr(:"SYS_B_005")||B.YIZHUXMID||chr(:"SYS_B_006")||B.YIZHUMC||chr(:"SYS_B_007")||to_char(B.KAIZHUSJ , :"SYS_B_008")||chr(:"SYS_B_009")||B.YIZHUMS||chr(:"SYS_B_010")||to_char(B.SHURUSJ , :"SYS_B_011")||chr(:"SYS_B_012")||B.PINCI||chr(:"SYS_B_013")||B.SHURUREN||chr(:"SYS_B_014")||to_char(B.KAISHISJ , :"SYS_B_015")||chr(:"SYS_B_016")||to_char(B.JIESHUSJ , :"SYS_B_017")||chr(:"SYS_B_018")||B.YIZHUFL||chr(:"SYS_B_019")||B.GEIYAOFS||chr(:"SYS_B_020")||B.GEIYAOFSLX||chr(:"SYS_B_021")||B.GEIYAOFSMC||chr(:"SYS_B_022")||B.KAIZHUYS||chr(:"SYS_B_023")||B.KAIZHUYSXM||chr(:"SYS_B_024")||B.KAIZHUBQ||chr(:"SYS_B_025")||B.KAIZHUKS||chr(:"SYS_B_026")||to_char(B.ZHIXINGSJ , :"SYS_B_027")||chr(:"SYS_B_028")||B.ZHIXINGREN||chr(:"SYS_B_029")||to_char(B.TINGZHUSJ , :"SYS_B_030")||chr(:"SYS_B_031")||to_char(B.FUHESJ , :"SYS_B_032")||chr(:"SYS_B_033")||B.FUHEREN||chr(:"SYS_B_034")||B.TINGZHUREN||chr(:"SYS_B_035")||B.TINGZHUFHR||chr(:"SYS_B_036")||to_char( B.TINGZHUFHSJ , :"SYS_B_037")||chr(:"SYS_B_038")||B.GUIGEID||chr(:"SYS_B_039")||to_char(B.CHEXIAOSJ , :"SYS_B_040")||chr(:"SYS_B_041")||B.CHEXIAOREN||chr(:"SYS_B_042")||B.YIZHUZT||chr(:"SYS_B_043")||B.DANGQIANZT||chr(:"SYS_B_044")||to_char(B.ZHUANGTAISJ , :"SYS_B_045")||chr(:"SYS_B_046")||B.JILIANGDW||chr(:"SYS_B_047")||B.BAOZHUANGDW||chr(:"SYS_B_048")||B.ZUIXIAODW||chr(:"SYS_B_049")||B.BAOZHUANGLIANG||chr(:"SYS_B_050")||B.FUYIZMC||chr(:"SYS_B_051")||B.YAOFANGYYID||chr(:"SYS_B_052")||B.YAOPINMC||chr(:"SYS_B_053")||B.JIAGEID||chr(:"SYS_B_054")||B.YAOPINBMID||chr(:"SYS_B_055")||B.YAOPINGG||chr(:"SYS_B_056")||to_char(B.PAICHISJ , :"SYS_B_057")||chr(:"SYS_B_058")||B.PAICHIYZID||chr(:"SYS_B_059")||B.JIXING||chr(:"SYS_B_060")||B.PISHIJG||chr(:"SYS_B_061")||B.LINGYAOFS||chr(:"SYS_B_062")||B.DAYINBZ||chr(:"SYS_B_063")||B.FUYIZID||chr(:"SYS_B_064")||B.YISHENGZID||chr(:"SYS_B_065")||B.DANJIA||chr(:"SYS_B_066")||B.YISHENGZT||chr(:"SYS_B_067")||B.ZHIXINGYL||chr(:"SYS_B_068")||B.KESHIID||chr(:"SYS_B_069")||B.ZUHAO||chr(:"SYS_B_070")||B.PAICHILX||chr(:"SYS_B_071")||B.PAIXUBH||chr(:"SYS_B_072")||B.SHOURICS||chr(:"SYS_B_073" )||B.DANGRICS||chr(:"SYS_B_074")||B.DAYINJL||chr(:"SYS_B_075")||B.MORICS||chr(:"SYS_B_076")||B.BINGQUID||chr(:"SYS_B_077")||B.CHANDILB||chr(:"SYS_B_078")||B.KAIZHUKSMC||chr(:"SYS_B_079")||B.KAIZHUBQMC||chr(:"SYS_B_080")||B.YICIJL||chr(:"SYS_B_081")||B.YICIJLDW||chr(:"SYS_B_082")||B.YICIYL||chr(:"SYS_B_083")||B.JILIANG||chr(:"SYS_B_084")||B.QIANGZHIBZ||chr(:"SYS_B_085")||A.DANGQIANCW||chr(:"SYS_B_086")||B.CHULIYJ||chr(:"SYS_B_087")||B.JIZHENBZ||chr(:"SYS_B_088")||B.BINGRENID||chr(:"SYS_B_089")||B.ZUIXIAODWZXYL||chr(:"SYS_B_090")||B.ZUIXIAODWYL||chr(:"SYS_B_091")||B.PISHIBZ||chr(:"SYS_B_092")||B.FUYAOSX||chr(:"SYS_B_093")||B.TAKEBZ||chr(:"SYS_B_094")||B.YEJIANBZ||chr(:"SYS_B_095")||B.PISHILX||chr(:"SYS_B_096")||B.PISHIFHR1||chr(:"SYS_B_097")||to_char(B.PISHIFHSJ1 , :"SYS_B_098")||chr(:"SYS_B_099")||B.PISHIFHR2||chr(:"SYS_B_100")||to_char(B.PISHIFHSJ2 , :"SYS_B_101")||chr(:"SYS_B_102")||B.JIFEIJG||chr(:"SYS_B_103")||B.JIFEIFS||chr(:"SYS_B_104")||B.ZHIXINGSJLX||chr(:"SYS_B_105")||B.FEIYONGXZZHBZ||chr(:"SYS_B_106")||B.JINGMAIPBZ||chr(:"SYS_B_107")||B.FAYAOZT||chr(:"SYS_B_108")||B.YUANYAOFYYID||chr(:"SYS_B_109")||B.ZIFUBL||chr (:"SYS_B_110")||B.CAOYAOBZ||chr(:"SYS_B_111")||B.DAIJIANTS||chr(:"SYS_B_112")||B.TINGZHUBQ||chr(:"SYS_B_113")||B.PAIXUZH||chr(:"SYS_B_114")||B.QIANFEISHBZ||chr(:"SYS_B_115")||B.ZHIXINGKSJFBZ||chr(:"SYS_B_116")||B.ZHIXINGKS||chr(:"SYS_B_117")||B.PINCIZXSJ||chr(:"SYS_B_118")||B.YIYUANSPBZ||chr(:"SYS_B_119")||B.YIYUANSPLX||chr(:"SYS_B_120")||B.YIYUANSPSM||chr(:"SYS_B_121")||B.YIYUANSPBL||chr(:"SYS_B_122")||B.JIAOBANHDBZ||chr(:"SYS_B_123")||B.YUANYIZZT||chr(:"SYS_B_124")||B.YUANDANGQZT||chr(:"SYS_B_125")||B.FUJIAFYJFFS||chr(:"SYS_B_126")||to_char(B.JIAOBANHDSJ , :"SYS_B_127")||chr(:"SYS_B_128")||B.JIAOBANHDR||chr(:"SYS_B_129")||B.TUIYAOSPBZ||chr(:"SYS_B_130")||B.YAOPINJX||chr(:"SYS_B_131")||B.ZHIXINGRQ||chr(:"SYS_B_132")||B.BIANGENGDDYBZ||chr(:"SYS_B_133")||B.QINGJIABZ||chr(:"SYS_B_134")||B.KAPIANDYBZ||chr(:"SYS_B_135")||B.CHEXIAOLX||chr(:"SYS_B_136")||B.CHEXIAOYY||chr(:"SYS_B_137")||to_char(B.DONGJIERQ , :"SYS_B_138")||chr(:"SYS_B_139")||to_char(B.YIYUANSPRQ , :"SYS_B_140")||chr(:"SYS_B_141")||B.ZHIXINGZT||chr(:"SYS_B_142")||B.QUZHENGLX||chr(:"SYS_B_143")||B.DONGJIEBZ||chr(:"SYS_B_144")||to_char(B.JIEDONGRQ , :"SYS_B_145" )||chr(:"SYS_B_146")||A.DANGQIANBQ||chr(:"SYS_B_147")||A.ZAIYUANZT||chr(:"SYS_B_148")||A.CHANFUBZ||chr(:"SYS_B_149")||A.MUQINZYID||chr(:"SYS_B_150")||A.ZHUYUANHAO||chr(:"SYS_B_151")||B.CHUYUANDYBZ||chr(:"SYS_B_152")||B.CHANGQILSBZ||chr(:"SYS_B_153")||to_char(B.YUYUERQ , :"SYS_B_154")||chr(:"SYS_B_155")||C.PINCILX||chr(:"SYS_B_156")||to_char(B.YUANZHIXSJ , :"SYS_B_157")||chr(:"SYS_B_158")||B.GONGZUOZID FROM ZY_V_XUANZEBR A, YZ_BINGRENYZ B, GY_PINCI C, SM_SHOUSHUXX D WHERE B.BINGRENZYID = A.BINGRENZYID AND B.YINGERID = A.YINGERID and B.PINCI = C.PINCIID and D.SHOUSHUDID(+) = B.PAICHIYZID AND B.BINGRENZYID = :A1 and B.YIZHUFL = :"SYS_B_159" and B.YIZHUZT <> :"SYS_B_160" and B.YIZHUID IN (SELECT SHOUSHUDID from sm_shoushuxx where paichibz=:"SYS_B_161" and bingrenzyid=:"SYS_B_162")
6wy3sj2ftgv0t BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('130', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
79rjzm0120ju4 begin pkg_yj_jiekou . Prc_YJ_JianYanJFYCL ( :prm_BingRenID , :prm_YingYongID , :prm_YuanQuID , :prm_youxiaots , :prm_ZaoZuoRen , :prm_zidongjssj , :prm_AppCode:NULL_VALUE , :prm_OutBuffer:NULL_VALUE ) ; END ;
7hxxth3uzdvh1 SELECT SEQ_ZY_JIESUAN2.NEXTVAL FROM DUAL
7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7tr51f4s0f00b SELECT COUNT(FUJIAJFMXID) FROM YZ_FUJIAJFMX WHERE JIFEIRQ=TRUNC(:B3 ) AND BINGRENZYID=:B2 AND GEIYAOFS=:B1
82a5wb9wh14x7 begin Prc_Gy_Getorder ( :prmXuHaoMC , :prmQianZhui , :prmAppCode:inappcode , :prmOrder:inoutput ) ; END ;
85qr8tbyns2qq SELECT COUNT(*), SUM(NVL(A.SHOUFEIBZ, 0)), SUM(NVL(A.FAYAOBZ, 0)) FROM MZ_CHUFANG1 A WHERE A.JIUZHENID = :B1
89vrgdpx747fg SELECT BINGRENID, ZHENDUANLX, JIBINGID, JIBINGMC, ZHENDUANYS, ZHENDUANSJ, ZHENDUANJLID, SHUNXUHAO, RUYUANQK, ZHUANGUIQK, ICD10 FROM V_BL_BINGRENZDQK WHERE BINGRENID=:BINGRENID AND ZHENDUANLX=:ZHENDUANLB ORDER BY ZHENDUANLX
8jvrhdh2ax6r7 SELECT A.BINGRENID, A.BINGANHAO, A.BINGRENXM, A.XINGBIE, A.ZHUYUANCS, A.CHUSHENGRQ, A.NIANLING, A.HUNYIN, A.ZHIYE, A.JIGUAN, A.MINZU, A.SHENFENZH, A.GONGZUODW, A.DANWEIDH, A.DANWEIYB, A.JIATINGDZ, A.JIATINGDH, A.JIATINGYB, A.GUANXIRXM, A.GUANXI, A.GUANXIRDZ, A.GUANXIRDH, A.XUEXING, A.RH, A.QIANGJIUCS, A.CHENGGONGCS, A.SUIZHENBZ, A.SUIZHENQXN, A.SUIZHENQXY, A.SUIZHENQXZ, A.HUIMINBZ, A.SHIJIAOBLBZ, A.BINGANZL, A.ZHIKONGYS, A.ZHIKONGHS, A.ZHILIAOSLBZ, A.RUYUANTJ, A.SHUXUEQK, A.KEZHUREN, A.ZHURENYS, A.YANJIUSHEN, A.ZHUZHIYS, A.ZHUYUANYS, A.JINXIUYSBH, A.SHIXIYS, A.MENZHENYS, A.LURURQ, A.CAOZUOYUAN, A.SHOUSHUBZ, A.RUYUANKS, A.RUYUANRQ, A.RUYUANQK, A.CHUYUANKS, A.CHUYUANRQ, A.QUEZHENTS, A.QUEZHENRQ, A.ZHUYUANTS, A.ZONGFEIYONG, A.JIBINGXH, A.ZHUANGUIQK, A.RUCHUFHBZ, A.MENCHUFHBZ, A.EXH, A.MXH, A.HBSAG, A.HCVAB, A.HIVAB, A.BENYUANSLBZ, A.SIWANGRQ, A.SHIJIANBZ, A.SHIJIANFHBZ, A.RUYUANBS, A.CHUYUANBS, A.SHOUSHUSL, A.ZHILIAOSL, A.JIANCHASL, A.ZHENDUANSL, A.GUOJI, A.SHOUSHUFHBZ, A.LINCHUANGBLFHBZ, A.FANGSHEBLFHBZ, A.XX, A.CT, A.MRI, A.DSA, A.BINGLIZDH, A.ECT, A.BINGLIZD, A.SHUQIANZD, A.SHUHOUZD, A.GUIDANGBZ, A.DANGQIANKS, A.BINGLIFX, A.QINGJIUFF, A.YINGERBZ, A.CHUSHENGDI, A.YOUWUWYZZ, A.KEYANBLBZ, A.SHUXUEFY, A.SHUYEFY, A.ZHUGUANYS, A.BINGQINGZY, A.BINGQINGZYGXSJ, A.SHUJUXJBZ, A.JIUZHENKH, A.HUKOUDZ, A.HUKOUDZYB, A.DANGQIANBQ, A.WAIBUYS, A.DANGQIANCW, A.XINSHENGERCSTZ, A.XINSHENGERRYTZ, A. CHUSHENGDID_SHENG, A.CHUSHENGDID_SHI, CHUSHENGDID_XIAN, A.JIGUANID_SHENG, A.HUNYIN_NEW, A.JIGUANID_SHI, A.JIGUAN_SSX, A.XIANZHUZHIID_SHENG, A.XIANZHUZHIID_SHI, A.XIANZHUZHIID_XIAN, A.XIANZHUZHI, A.XIANZHUZHI_SSX, A.XIANZHUZHIDH, A.XIANZHUZHIYB, A.HUKOUDZID_SSX, A.HUKOUDZID_SHENG, A.HUKOUDZID_SHI, A.HUKOUDZID_XIAN, A.WAIBUYSJBXH, A.YAOWUGMBZ, A.ZERENHUSHI, A.ZERENHSXM, A.LIYUANFS, A.YIJIESOUYLJGMC, A.CHUYUANZYJL, A.CHUYUANZYJLMD, A.HUNMISJ_RYQT, A.HUNMISJ_RYQX, A.HUNMISJ_RYQF, A.HUNMISJ_RYHT, A.HUNMISJ_RYHX, A.HUNMISJ_RYHF, A.XUEXING_NEW, A.RH_NEW, A.RUYUANTJ_NEW, A.ZHIKONGRQ, A.ZHILIAOLB, A.LINCHUANLJSS, A.YILIAOJGZYZJSY, A.ZHONGYIZLSZSY, A.ZHONGYIZLJSSY, A.BIANZHENGSH, NVL(A.BINGANSYBB, 0) AS BINGANSYBB, A.RUYUANFJH, A.CHUYUANFJH, B.ZHILIAO_KJYW, B.YUFANG_KJYW, B.SONGJIAN FROM V_BL_BINGRENJBXX A, V_BL_BINGRENJBXX_KZXX B WHERE A.BINGRENID = B.BINGRENID(+) AND A.BINGRENID=:BINGRENID
8xu6m654zvra6 BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('126', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
8xzq1tmuq2jnm SELECT A.YAOPINID||chr(:"SYS_B_00")||A.SHOUFEIXM||chr(:"SYS_B_01")||A.YAOPINFL||chr(:"SYS_B_02")||A.BIAOZHUNBM||chr(:"SYS_B_03")||A.YAOPINLX||chr(:"SYS_B_04")||A.KUFANGLX||chr(:"SYS_B_05")||A.JIZHENYYBZ||chr(:"SYS_B_06")||A.KONGZHIYLBZ||chr(:"SYS_B_07")||A.ZUOFEIBZ||chr(:"SYS_B_08")||A.XIUGAIREN||chr(:"SYS_B_09")||to_char(A.XIUGAISJ , :"SYS_B_10")||chr(:"SYS_B_11")||A.DULIFL||chr(:"SYS_B_12")||A.JIAZHIFL||chr(:"SYS_B_13")||B.BIEMINGID||chr(:"SYS_B_14")||B.GUIGEID||chr(:"SYS_B_15")||B.ZHUMINGID||chr(:"SYS_B_16")||DECODE(B.ZHUMINGID, NULL, NULL, B.YAOPINMC)||chr(:"SYS_B_17")||A.SHURUMA1||chr(:"SYS_B_18")||A.SHURUMA2||chr(:"SYS_B_19")||A.SHURUMA3||chr(:"SYS_B_20")||B.JIAGEID||chr(:"SYS_B_21")||A.YAOPINMC||chr(:"SYS_B_22")||C.FENLEIMC||chr(:"SYS_B_23")||B.ZUOFEIBZ||chr(:"SYS_B_24")||B.YAOPINMC FROM GY_YAOPINMC A, GY_YAOPINZBM B, GY_YAOPINFL C WHERE A.YAOPINFL = C.YAOPINFLID(+) AND A.YAOPINID = B.YAOPINID(+) AND A.ZUOFEIBZ =:A1 And (B.ZUOFEIBZ = :"SYS_B_25" Or B.ZUOFEIBZ Is Null) AND A.YAOPINFL IN (:"SYS_B_26")
91sz07pbyy1mz INSERT INTO "L_PATIENTINFO" ( "NOTES", "PATIENTID", "TOPONYMY", "DEPART_BED", "BIRTHDAY", "CHKOPER2", "EXAMINAIM", "RECEIVER", "RECEIVETIME", "FEE", "STAYHOSPITALMODE", "REQUESTMODE", "DIAGNOSTIC", "NL", "NLDW", "CANCELER", "CANCELTIME", "SYMSTATUS", "CYCLE", "CHECKOPERATOR", "CHECKTIME", "CHECKEROPINION", "SECTION", "REQUESTER", "REQUESTTIME", "FEESTATUS", "SEX", "PATIENTNAME", "SAMPLENO", "SAMPLETYPE", "RESULTSTATUS", "YLXH", "INFANTFLAG", "DOCTADVISENO", "LABDEPARTMENT", "EXECUTOR", "EXECUTETIME", "BINGRENID", "BINGRENZYID", "YINGERID", "BINGANHAO", "RENYUANID", "RESULTCOMMENT", "CISBORDER", "CURBQ", "SONGJIANDW" ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46 )
96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
986rqx6ajbdqq SELECT case a.YAOPINLX when '1' then 'Î÷' when '2' then '³É' when '3' then '²Ý' when '4' then 'ÎÀ' end AS XIANSHILX, b.YAOPINMC||' '||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, 1) as DanJia1, d.KuCunSL AS KuCunSL, 1 As XiangMuLX, 0 as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||'^'||b.BIEMINGID||'^'||a.ZHANGBULB||'^'||a.GUIGEID||'^'||a.CHANDI||'^'||a.SHOUFEIXM||'^'||a.DULIFL||'^'||a.JIAZHIFL||'^'||a.GEIYAOFS||'^'||a.YONGYAOTC||'^'||a.PISHIBZ||'^'||a.KANGSHENGSXJ||'^'||a.KANGJUNYXJ||'^'||a.DASHUYBZ||'^'||a.FUFANGBZ||'^'||a.JIZHENYYBZ||'^'||a.JIXING||'^'||a.DuiYingPSYP||'^'||b.YAOPINMC||'^'||a.YAOPINGG||'^'||a.YiBaoDJ||'^'||a.ZuiXiaoDW||'^'||a.JiLiang||'^'||a.JiLiangDW||'^'||a.PingJunJJ||'^'||a.PiFaJia||'^'||a.YaoPinLX||'^'||a.BaoZhuangLiang||'^'||a.XianLiang3||'^'||a.XianLiang7||'^'||a.TiJi||'^'||a.TiJiDW||'^'||e.YAOPINFL||'^'||a.FuYaoSX||'^'||a.YaoPinID||'^'||a.XiaoGuiGID||'^'||a.DaGuiGID||'^'||a.QiTaSX||'^'||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX='1' And a.YingYongID='0501') or (b.YaoPinLX='2' And a.YingYongID='0501') or (b.YaoPinLX='3' And a.YingYongID='0503') or (b.YaoPinLX='4' And a.YingYongID=''))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = 0 And a.ZUOFEIBZ = 0 AND a. CHAXUNBZ = 0 And ('%'='%' or (b.SHURUMA1 Like '%%' or b.yaopinmc like '%%%')) and Fun_GY_HaveChuFangLX(a.YaoPinLX, '110') = 1 and a.LinChuangSYBZ = 1 and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > 0) And (d.ShiYongPL <> '0')) and ((a.YaoPinLX = '3'and a.baozhuangliang=1) or (a.YaoPinLX = '1') or (a.YaoPinLX = '2') or (a.YaoPinLX = '4')) and (((a.YaoPinLX = '1' and substr(a.MenYaoSY, to_number(substr('0501', 3, 2)), 1) = 1) or (a.YaoPinLX = '2' and substr(a.MenYaoSY, to_number(substr('0501', 3, 2)), 1) = 1) or (a.YaoPinLX = '3' and substr(a.MenYaoSY, to_number(substr('0503', 3, 2)), 1) = 1) or (a.YaoPinLX = '4' and substr(a.MenYaoSY, to_number(substr('', 3, 2)), 1) = 1)) and a.menzhenqybz = 1) and a.TINGYONGBZ = 0 union all SELECT case a.YAOPINLX when '1' then 'Î÷' when '2' then '³É' when '3' then '²Ý' when '4' then 'ÎÀ' end AS XIANSHILX, b.YAOPINMC||' '||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, 1) as DanJia1, d.KuCunSL AS KuCunSL, 1 As XiangMuLX, 0 as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||'^'||b.BIEMINGID||'^'||a.ZHANGBULB||'^'||a.GUIGEID||'^'||a.CHANDI||'^'||a.SHOUFEIXM||'^'||a.DULIFL||'^'||a.JIAZHIFL||'^'||a.GEIYAOFS||'^'||a.YONGYAOTC||'^'||a.PISHIBZ||'^'||a.KANGSHENGSXJ||'^'||a.KANGJUNYXJ||'^'||a.DASHUYBZ||'^'||a.FUFANGBZ||'^'||a.JIZHENYYBZ||'^'||a.JIXING||'^'||a.DuiYingPSYP||'^'||b.YAOPINMC||'^'||a.YAOPINGG||'^'||a.YiBaoDJ||'^'||a.ZuiXiaoDW||'^'||a.Ji Liang||'^'||a.JiLiangDW||'^'||a.PingJunJJ||'^'||a.PiFaJia||'^'||a.YaoPinLX||'^'||a.BaoZhuangLiang||'^'||a.XianLiang3||'^'||a.XianLiang7||'^'||a.TiJi||'^'||a.TiJiDW||'^'||e.YAOPINFL||'^'||a.FuYaoSX||'^'||a.YaoPinID||'^'||a.XiaoGuiGID||'^'||a.DaGuiGID||'^'||a.QiTaSX||'^'||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX='1' And a.YingYongID='0501') or (b.YaoPinLX='2' And a.YingYongID='0501') or (b.YaoPinLX='3' And a.YingYongID='0503') or (b.YaoPinLX='4' And a.YingYongID=''))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = 0 And a.ZUOFEIBZ = 0 AND a.CHAXUNBZ = 0 And b.SHURUMA1 Like '%%%' and Fun_GY_HaveChuFangLX(a.YaoPinLX, '110') = 1 and a.LinChuangSYBZ = 1 and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > 0) And (d.ShiYongPL <> '0')) and ((a.YaoPinLX = '3'and a.baozhuangliang=1) or (a.YaoPinLX = '1') or (a.YaoPinLX = '2') or (a.YaoPinLX = '4')) and (((a.YaoPinLX = '1' and substr(a.MenYaoSY, to_number(substr('0501', 3, 2)), 1) = 1) or (a.YaoPinLX = '2' and substr(a.MenYaoSY, to_number(substr('0501', 3, 2)), 1) = 1) or (a.YaoPinLX = '3' and substr(a.MenYaoSY, to_number(substr('0503', 3, 2)), 1) = 1) or (a.YaoPinLX = '4' and substr(a.MenYaoS Y, to_number(substr('', 3, 2)), 1) = 1)) and a.menzhenqybz = 1) and a.TINGYONGBZ = 0
9h3su635dcp95 select shuzhi1, jilusj from twd_tizhengyw WHERE bingrenzyid=:1 and YINGERBZ = :2 and XiangMuId = :3 and JILUSJ>=TO_DATE(:RIQI1, 'YYYY-MM-DD HH24:MI:SS') and JILUSJ<=TO_DATE(:RIQI2, 'YYYY-MM-DD HH24:MI:SS') and CELIANGSJD = :CELIANGSJD
9k04hj56dvp3q SELECT case a.YAOPINLX when :"SYS_B_000" then :"SYS_B_001" when :"SYS_B_002" then :"SYS_B_003" when :"SYS_B_004" then :"SYS_B_005" when :"SYS_B_006" then :"SYS_B_007" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_008"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx_Ex(a.Jiageid, :"SYS_B_009", d.YingYongID) As Danjia1, d.KuCunSL AS KuCunSL, a.JIAGEID, a.YAOPINMC as ZHUMINGMC, b.BIEMINGID, a.ZHANGBULB, a.GUIGEID, a.CHANDI, a.SHOUFEIXM, a.DULIFL, a.JIAZHIFL, a.GEIYAOFS, a.YONGYAOTC, a.PISHIBZ, a.KANGSHENGSXJ, a.KANGJUNYXJ, a.DASHUYBZ, a.FUFANGBZ, a.JIZHENYYBZ, a.JIXING, :"SYS_B_010" As XiangMuLX, a.DuiYingPSYP, b.YAOPINMC as BIEMINGMC, a.YAOPINGG, a.YiBaoDJ, a.ZuiXiaoDW, a.JiLiang, a.JiLiangDW, a.PingJunJJ, a.PiFaJia, a.YaoPinLX, a.BaoZhuangLiang, a.XianLiang3, a.XianLiang7, a.TiJi, a.TiJiDW, e.YAOPINFL, a.FuYaoSX, a.YaoPinID, a.XiaoGuiGID, a.DaGuiGID, a.QiTaSX, a.DuiYingPSYPSL, a.LingChaJBZ FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.YingYongID, a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL , a.LAIYUAN From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_011" And a.YingYongID=:"SYS_B_012") or (b.YaoPinLX=:"SYS_B_013" And a.YingYongID=:"SYS_B_014") or (b.YaoPinLX=:"SYS_B_015" And a.YingYongID=:"SYS_B_016") or (b.YaoPinLX=:"SYS_B_017" A nd a.YingYongID=:"SYS_B_018"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = :"SYS_B_019" And a.ZUOFEIBZ = :"SYS_B_020" AND a.CHAXUNBZ = :"SYS_B_021" And (b.SHURUMA1 Like :"SYS_B_022" or b.yaopinmc like :"SYS_B_023") and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_024") = :"SYS_B_025" and a.LinChuangSYBZ = :"SYS_B_026" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SYS_B_027") And (d.ShiYongPL <> :"SYS_B_028")) and ((a.YaoPinLX = :"SYS_B_029" and a.baozhuangliang=:"SYS_B_030") or (a.YaoPinLX = :"SYS_B_031") or (a.YaoPinLX = :"SYS_B_032") or (a.YaoPinLX = :"SYS_B_033")) and (((a.YaoPinLX = :"SYS_B_034" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_035", :"SYS_B_036", :"SYS_B_037")), :"SYS_B_038") = :"SYS_B_039") or (a.YaoPinLX = :"SYS_B_040" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_041", :"SYS_B_042", :"SYS_B_043")), :"SYS_B_044") = :"SYS_B_045") or (a.YaoPinLX = :"SYS_B_046" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_047", :"SYS_B_048", :"SYS_B_049")), :"SYS_B_050") = :"SYS_B_051") or (a.YaoPinLX = :"SYS_B_052" and substr(a.BingYaoSY, to_number(substr(: "SYS_B_053", :"SYS_B_054", :"SYS_B_055")), :"SYS_B_056") = :"SYS_B_057")) and a.zhuyuanqybz = :"SYS_B_058") and a.TINGYONGBZ = :"SYS_B_059" and e.FeiYongLLBZ = :"SYS_B_060" union all SELECT case a.YAOPINLX when :"SYS_B_061" then :"SYS_B_062" when :"SYS_B_063" then :"SYS_B_064" when :"SYS_B_065" then :"SYS_B_066" when :"SYS_B_067" then :"SYS_B_068" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_069"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx_Ex(a.Jiageid, :"SYS_B_070", d.YingYongID) As Danjia1, d.KuCunSL AS KuCunSL, a.JIAGEID, a.YAOPINMC as ZHUMINGMC, b.BIEMINGID, a.ZHANGBULB, a.GUIGEID, a.CHANDI, a.SHOUFEIXM, a.DULIFL, a.JIAZHIFL, a.GEIYAOFS, a.YONGYAOTC, a.PISHIBZ, a.KANGSHENGSXJ, a.KANGJUNYXJ, a.DASHUYBZ, a.FUFANGBZ, a.JIZHENYYBZ, a.JIXING, :"SYS_B_071" As XiangMuLX, a.DuiYingPSYP, b.YAOPINMC as BIEMINGMC, a.YAOPINGG, a.YiBaoDJ, a.ZuiXiaoDW, a.JiLiang, a.JiLiangDW, a.PingJunJJ, a.PiFaJia, a.YaoPinLX, a.BaoZhuangLiang, a.XianLiang3, a.XianLiang7, a.TiJi, a.TiJiDW, e.YAOPINFL, a.FuYaoSX, a.YaoPinID, a.XiaoGuiGID, a.DaGuiGID, a.QiTaSX, a.DuiYingPSYPSL, a.LingChaJBZ FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.YingYongID, a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL , a.LAIYUAN From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoP inLX=:"SYS_B_072" And a.YingYongID=:"SYS_B_073") or (b.YaoPinLX=:"SYS_B_074" And a.YingYongID=:"SYS_B_075") or (b.YaoPinLX=:"SYS_B_076" And a.YingYongID=:"SYS_B_077") or (b.YaoPinLX=:"SYS_B_078" And a.YingYongID=:"SYS_B_079"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = :"SYS_B_080" And a.ZUOFEIBZ = :"SYS_B_081" AND a.CHAXUNBZ = :"SYS_B_082" And b.SHURUMA1 Like :"SYS_B_083" and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_084") = :"SYS_B_085" and a.LinChuangSYBZ = :"SYS_B_086" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SYS_B_087") And (d.ShiYongPL <> :"SYS_B_088")) and ((a.YaoPinLX = :"SYS_B_089" and a.baozhuangliang=:"SYS_B_090") or (a.YaoPinLX = :"SYS_B_091") or (a.YaoPinLX = :"SYS_B_092") or (a.YaoPinLX = :"SYS_B_093")) and (((a.YaoPinLX = :"SYS_B_094" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_095", :"SYS_B_096", :"SYS_B_097")), :"SYS_B_098") = :"SYS_B_099") or (a.YaoPinLX = :"SYS_B_100" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_101", :"SYS_B_102", :"SYS_B_103& quot;)), :"SYS_B_104") = :"SYS_B_105") or (a.YaoPinLX = :"SYS_B_106" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_107", :"SYS_B_108", :"SYS_B_109")), :"SYS_B_110") = :"SYS_B_111") or (a.YaoPinLX = :"SYS_B_112" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_113", :"SYS_B_114", :"SYS_B_115")), :"SYS_B_116") = :"SYS_B_117")) and a.zhuyuanqybz = :"SYS_B_118") and a.TINGYONGBZ = :"SYS_B_119" and e.FeiYongLLBZ = :"SYS_B_120"
9yjyffcc5hbbt SELECT A.GUAHAOID||chr(9)||A.JIUZHENID||chr(9)||A.BINGRENID||chr(9)||A.XINGMING||chr(9)||A.XINGBIE||chr(9)||A.NIANLING||chr(9)||A.NIANLINGDW||chr(9)||to_char(A.JIUZHENRQ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||A.FEIYONGLB||chr(9)||A.JIUZHENZT||chr(9)||B.JIUZHENKH||chr(9)||B.MINZU||chr(9)||B.HUNYIN||chr(9)||B.ZHIYE||chr(9)||A.GUAHAOYS||chr(9)||A.GUAHAOKS||chr(9)||A.YUANQUID||chr(9)||A.YINGYONGID||chr(9)||A.JIUZHENYS||chr(9)||A.JIUZHENKS||chr(9)||B.YIBAOKH||chr(9)||B.GONGFEIZH||chr(9)||C.LEIBIEMC||chr(9)||A.ZHAOHUIBZ||chr(9)||A.YUYUEBZ||chr(9)||B.BINGANHAO||chr(9)||A.SHANGXIAWBZ||chr(9)||A.GUAHAODYID||chr(9)||A.GUAHAOXH||chr(9)||B.YIBAOBRXX||chr(9)||A.JILULY||chr(9)||pkg_mz_zhenjian.FUN_ZJ_GETJIUZHENKDZT(A.JIUZHENID)||chr(9)||A.ZUOFEIBZ||chr(9)||A.GUAHAOLB||chr(9)||A.LIUGUANZT||chr(9)||A.LIUGUANKS||chr(9)||A.LIUGUANKSMC||chr(9)||to_char(A.LIUGUANKSSJ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||to_char(A.LIUGUANJSSJ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||to_char(A.XITONGSJ , 'yyyy-mm-dd hh24:mi:ss') FROM ZJ_JIUZHENXX A, GY_BINGRENXX B, GY_FEIYONGLB C WHERE A.BINGRENID = B.BINGRENID AND C.LEIBIEID = A.FEIYONGLB AND A.JIUZHENZT= :A1 AND A.JIUZHENKS= :A2 AND (A.JIUZHENYS IS NULL OR A.JIUZHENYS = :A3 OR A.PAIBANID IN (SELECT PAIBANID FROM MZ_GUAHAOPB B WHERE B.RIQI BETWEEN TO_DATE(:A, 'YYYY-MM-DD HH24:MI:SS') AND to_date(:A, 'YYYY-MM-DD HH24:MI:SS') AND B.TIZHENYS = :A ) ) AND A.YUANQUID = :A AND (A.YINGYONGID=:B1 OR (A.YINGYONGID NOT LIKE '04__' AND A.YINGYONGID<>:B2)) AND G UAHAOLBGL <> '4' AND A.XITONGSJ Between To_Date(:A2, 'yyyy-mm-dd hh24:mi:ss') And To_Date(:A3, 'yyyy-mm-dd hh24:mi:ss')
a6zbz0vpdj6d7 SELECT BINGRENID||chr(:"SYS_B_00")||GUAHAOID||chr(:"SYS_B_01")||GUAHAOXH||chr(:"SYS_B_02")||FAPIAOHM||chr(:"SYS_B_03")||JIUZHENKH||chr(:"SYS_B_04")||BINGRENXM||chr(:"SYS_B_05")||GUAHAOKSMC||chr(:"SYS_B_06")||GUAHAOYSXM||chr(:"SYS_B_07")||JINE||chr(:"SYS_B_08")||to_char(GUAHAORQ , :"SYS_B_09")||chr(:"SYS_B_10")||BINGANHAO||chr(:"SYS_B_11")||GUAHAOLBMC||chr(:"SYS_B_12")||GUAHAOSD||chr(:"SYS_B_13")||YUYUELXMC||chr(:"SYS_B_14")||ZHUANGTAIMC||chr(:"SYS_B_15")||ZHUANGTAI||chr(:"SYS_B_16")||GUAHAORXM||chr(:"SYS_B_17")||to_char(CHUSHENGRQ , :"SYS_B_18")||chr(:"SYS_B_19")||XINGBIE||chr(:"SYS_B_20")||ZUOFEIBZ||chr(:"SYS_B_21")||SHOUFEIID||chr(:"SYS_B_22")||FEIYONGLB||chr(:"SYS_B_23")||YUANQUID||chr(:"SYS_B_24")||YINGYONGID||chr(:"SYS_B_25")||PAIBANID||chr(:"SYS_B_26")||YOUHUILB||chr(:"SYS_B_27")||YUYUEBZ||chr(:"SYS_B_28")||YUYUELX||chr(:"SYS_B_29")||GUAHAOLB||chr(:"SYS_B_30")||GUAHAOKS||chr(:"SYS_B_31")||GUAHAOYS||chr(:"SYS_B_32")||SHANGXIAWBZ||chr(:"SYS_B_33")||JIAOYILX||chr(:"SYS_B_34")||GUAHAOREN||chr(:"SYS_B_35")||FEIYONGXZ||chr(:"SYS_B_36")||YIBAOKH||chr(:"SYS_B_37")||to_char(ZHIDANRQ , :"SYS_B_38&qu ot;) FROM MZ_V_YIGUAHXX WHERE GUAHAORQ BETWEEN TO_DATE(TO_CHAR(SYSDATE, :"SYS_B_39") || :"SYS_B_40", :"SYS_B_41") AND TO_DATE(TO_CHAR(SYSDATE, :"SYS_B_42") || :"SYS_B_43", :"SYS_B_44") AND GUAHAOREN LIKE :A1 AND JIAOYILX = :"SYS_B_45" AND ZUOFEIBZ = :"SYS_B_46" And ZHUANGTAIMC <> :A2
agp1wj2adbhad begin PKG_YZ_YEWU . prc_YZ_ZhiXingYZ ( :prm_BingQuID , :prm_ZhiXingRQ , :prm_YiZhuIDList , :prm_YingYongID , :prm_ZhiXingRen , :prm_BingRenZYID , :prm_YingErID , :prm_IP , :n_appcode:NULL_VALUE , :s_outbuffer:NULL_VALUE ) ; END ;
ah8v40tmb7s8s SELECT A.GUAHAOID||chr(9)||A.JIUZHENID||chr(9)||A.BINGRENID||chr(9)||A.XINGMING||chr(9)||A.XINGBIE||chr(9)||A.NIANLING||chr(9)||A.NIANLINGDW||chr(9)||to_char(A.JIUZHENRQ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||A.FEIYONGLB||chr(9)||A.JIUZHENZT||chr(9)||B.JIUZHENKH||chr(9)||B.MINZU||chr(9)||B.HUNYIN||chr(9)||B.ZHIYE||chr(9)||A.GUAHAOYS||chr(9)||A.GUAHAOKS||chr(9)||A.YUANQUID||chr(9)||A.YINGYONGID||chr(9)||A.JIUZHENYS||chr(9)||A.JIUZHENKS||chr(9)||B.YIBAOKH||chr(9)||B.GONGFEIZH||chr(9)||C.LEIBIEMC||chr(9)||A.ZHAOHUIBZ||chr(9)||A.YUYUEBZ||chr(9)||B.BINGANHAO||chr(9)||A.SHANGXIAWBZ||chr(9)||A.GUAHAODYID||chr(9)||A.GUAHAOXH||chr(9)||B.YIBAOBRXX||chr(9)||A.JILULY||chr(9)||pkg_mz_zhenjian.FUN_ZJ_GETJIUZHENKDZT(A.JIUZHENID)||chr(9)||A.ZUOFEIBZ||chr(9)||A.GUAHAOLB||chr(9)||A.LIUGUANZT||chr(9)||A.LIUGUANKS||chr(9)||A.LIUGUANKSMC||chr(9)||to_char(A.LIUGUANKSSJ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||to_char(A.LIUGUANJSSJ , 'yyyy-mm-dd hh24:mi:ss')||chr(9)||to_char(A.XITONGSJ , 'yyyy-mm-dd hh24:mi:ss') FROM ZJ_JIUZHENXX A, GY_BINGRENXX B, GY_FEIYONGLB C WHERE A.BINGRENID = B.BINGRENID AND C.LEIBIEID = A.FEIYONGLB AND A.JIUZHENZT= :A AND A.JIUZHENKS= :A AND (A.JIUZHENYS IS NOT NULL ) AND ( (A.XITONGSJ Between To_Date(:A1, 'yyyy-mm-dd hh24:mi:ss') And To_Date(:A2, 'yyyy-mm-dd hh24:mi:ss')) ) AND A.YUANQUID = :A AND (A.YINGYONGID=:B1 OR (A.YINGYONGID NOT LIKE '04__' AND A.YINGYONGID<>:B2)) AND ( A.LIUGUANZT = 0 OR A.LIUGUANZT IS NULL ) AND GUAHAOLBGL <> '4'
arghxnr7sa2sp SELECT SHEBAOBH||chr(:"SYS_B_00")||YIBAOKH||chr(:"SYS_B_01")||JIUZHENKH||chr(:"SYS_B_02")||SHEQUBH||chr(:"SYS_B_03")||FEIYONGLB||chr(:"SYS_B_04")||FEIYONGXZ||chr(:"SYS_B_05")||YOUHUILB||chr(:"SYS_B_06")||GONGFEIZH||chr(:"SYS_B_07")||GONGFEIDW||chr(:"SYS_B_08")||GONGFEIDWMC||chr(:"SYS_B_09")||XINGMING||chr(:"SYS_B_10")||SHURUMA1||chr(:"SYS_B_11")||SHURUMA3||chr(:"SYS_B_12")||SHURUMA2||chr(:"SYS_B_13")||XINGBIE||chr(:"SYS_B_14")||NIANLINGDW||chr(:"SYS_B_15")||SHENFENZH||chr(:"SYS_B_16")||to_char(CHUSHENGRQ , :"SYS_B_17")||chr(:"SYS_B_18")||GONGZUODW||chr(:"SYS_B_19")||DANWEIDH||chr(:"SYS_B_20")||DANWEIYB||chr(:"SYS_B_21")||JIATINGDZ||chr(:"SYS_B_22")||JIATINGDH||chr(:"SYS_B_23")||JIATINGYB||chr(:"SYS_B_24")||XUEXING||chr(:"SYS_B_25")||HUNYIN||chr(:"SYS_B_26")||ZHIYE||chr(:"SYS_B_27")||GUOJI||chr(:"SYS_B_28")||MINZU||chr(:"SYS_B_29")||SHENGFEN||chr(:"SYS_B_30")||XIANGZHENJD||chr(:"SYS_B_31")||SHIDIQU||chr(:"SYS_B_32")||JIGUAN||chr(:"SYS_B_33")||CHUSHENGDI||chr(:"SYS_B_34")||YOUBIAN||chr(:"SYS_B_35")||LIANXIREN||chr(:"SYS_B_36")||GUANXI||chr(:"SYS_B_37")||LIANXIRDZ||chr(:"SYS_B_38")||LIANXIRDH||c hr(:"SYS_B_39")||LIANXIRYB||chr(:"SYS_B_40")||JIWANGSHI||chr(:"SYS_B_41")||GUOMINSHI||chr(:"SYS_B_42")||PISHIJG||chr(:"SYS_B_43")||JIANDANGREN||chr(:"SYS_B_44")||to_char(JIANDANGRQ , :"SYS_B_45")||chr(:"SYS_B_46")||XIUGAIREN||chr(:"SYS_B_47")||to_char(XIUGAISJ , :"SYS_B_48")||chr(:"SYS_B_49")||MENZHENCS||chr(:"SYS_B_50")||BINGRENZYID||chr(:"SYS_B_51")||ZHUYUANCS||chr(:"SYS_B_52")||JILULY||chr(:"SYS_B_53")||QUYU||chr(:"SYS_B_54")||GERENBH||chr(:"SYS_B_55")||YIBAOKID||chr(:"SYS_B_56")||ICXX||chr(:"SYS_B_57")||QIGUANYZBZ||chr(:"SYS_B_58")||BINGRENID||chr(:"SYS_B_59")||ZIJINZHQYBZ||chr(:"SYS_B_60")||LVSETDBZ||chr(:"SYS_B_61")||DANBAOLX||chr(:"SYS_B_62")||XINGMINGQP||chr(:"SYS_B_63")||MUQINXM||chr(:"SYS_B_64")||MUQINXMQP||chr(:"SYS_B_65")||JIATINGDZSZDQ||chr(:"SYS_B_66")||DANWEIDZSZDQ||chr(:"SYS_B_67")||ZHENGJIANLX||chr(:"SYS_B_68")||BINGANHAO||chr(:"SYS_B_69")||BINGLISLZT||chr(:"SYS_B_70")||YIBAOBRXX FROM GY_BINGRENXX WHERE SHENFENZH = :A1
asnfw2nc3ycq2 BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('282', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
b1skxa0jk4tp4 DELETE FROM GY_YEWUDJ WHERE YEWUDJID = :B1
bjjq3tdqckd2u SELECT COUNT(A.BINGRENZYID) FROM ZY_CHUANGWEIBD A, ZY_JIESUAN1 B, ZY_BINGRENXX C WHERE C.BINGRENZYID = A.BINGRENZYID AND C.BINGRENZYID = B.BINGRENZYID AND B.JIESUANFS <> 5 AND B.JIESUANXH = 0 AND A.XITONGSJ BETWEEN :B3 AND :B2 AND A.BIANDONGYY = '4' AND A.BINGQU1 <> A.BINGQU2 AND A.BINGQU2 = :B1 AND C.YINGERBZ = 0
bta2dxczbts04 Select sum ( Nvl ( zifeije , 0 ) + Nvl ( ZiLiJE , 0 ) ) From zy_feiyong1 Where jiesuanxh =0 And jifeirq < to_date ( :1 , 'yyyy-mm-dd' ) And bingrenzyid =:2
bvnfcw92wu4xz SELECT A.CHUFANGMXID||chr(:"SYS_B_00")||A.CHUFANGID||chr(:"SYS_B_01")||A.SHUNXUHAO||chr(:"SYS_B_02")||A.JIAGEID||chr(:"SYS_B_03")||A.BIEMINGID||chr(:"SYS_B_04")||A.GEIYAOFS||chr(:"SYS_B_05")||A.GEIYAOFSJFBZ||chr(:"SYS_B_06")||A.HESUANXM||chr(:"SYS_B_07")||A.SHOUFEIXM||chr(:"SYS_B_08")||A.SHOUFEITCID||chr(:"SYS_B_09")||A.ZUHAO||chr(:"SYS_B_10")||A.ZHUYAOBZ||chr(:"SYS_B_11")||A.YAOPINLX||chr(:"SYS_B_12")||A.YAOPINMC||chr(:"SYS_B_13")||A.DAYINMC||chr(:"SYS_B_14")||A.PIFAJIA||chr(:"SYS_B_15")||A.JINJIA||chr(:"SYS_B_16")||A.JIESUANJIA||chr(:"SYS_B_17")||A.BIAOZHUNJIA||chr(:"SYS_B_18")||A.SHULIANG||chr(:"SYS_B_19")||A.JIESUANJE||chr(:"SYS_B_20")||A.BIAOZHUNJE||chr(:"SYS_B_21")||A.ZIFUBL||chr(:"SYS_B_22")||A.PINCI||chr(:"SYS_B_23")||A.YICIJL||chr(:"SYS_B_24")||A.JILIANGDW||chr(:"SYS_B_25")||A.YONGYAOTS||chr(:"SYS_B_26")||A.ZHUSHECS||chr(:"SYS_B_27")||A.YIBAOZFBL||chr(:"SYS_B_28")||A.YIBAODJ||chr(:"SYS_B_29")||A.SHENPIBH||chr(:"SYS_B_30")||A.TUIYAOYY||chr(:"SYS_B_31")||A.ZIFEIBZ||chr(:"SYS_B_32")||A.ZIBEIBZ||chr(:"SYS_B_33")||A.YISHENGZT||chr(:"SYS_B_34")||A.PISHIBZ||chr(:"SYS_B_35")||A.PISHILX||chr(:"SYS_B_36")||A.PISHI JG||chr(:"SYS_B_37")||A.BEIZHU||chr(:"SYS_B_38")||A.YOUHUIBL||chr(:"SYS_B_39")||A.BENYUANZSCS||chr(:"SYS_B_40")||A.BAOZHUANGDW||chr(:"SYS_B_41")||A.YAOPINGG||chr(:"SYS_B_42")||A.ZUIXIAODW||chr(:"SYS_B_43")||A.BAOZHUANGLIANG||chr(:"SYS_B_44")||A.JILIANG||chr(:"SYS_B_45")||A.SHENPILX||chr(:"SYS_B_46")||A.YIBAODM||chr(:"SYS_B_47")||A.YICIJLDW||chr(:"SYS_B_48")||A.YIBAOXX||chr(:"SYS_B_49")||A.YIBAOSFLB||chr(:"SYS_B_50")||A.ZIFEIJE||chr(:"SYS_B_51")||A.ZILIJE||chr(:"SYS_B_52")||A.XIANJIA||chr(:"SYS_B_53")||A.SHIYONGYLYBDM||chr(:"SYS_B_54")||A.FEIYONGKZ||chr(:"SYS_B_55")||A.TIJI||chr(:"SYS_B_56")||A.TIJIDW||chr(:"SYS_B_57")||A.CHULIYJ||chr(:"SYS_B_58")||A.YIZHUID||chr(:"SYS_B_59")||A.YISHENGQM||chr(:"SYS_B_60")||B.JIUZHENID||chr(:"SYS_B_61")||A.YAOPINXL||chr(:"SYS_B_62")||A.PISHICFSL||chr(:"SYS_B_63")||A.DAYINJL||chr(:"SYS_B_64")||A.QIANGZHIBZ||chr(:"SYS_B_65")||D.GUIGEID||chr(:"SYS_B_66")||D.XIAOGUIGID||chr(:"SYS_B_67")||D.DAGUIGID||chr(:"SYS_B_68")||A.ZHONGYAOKLZHSL||chr(:"SYS_B_69")||A.ZHONGYAOKLCZSL||chr(:"SYS_B_70")||A.QITASX FROM MZ_CHUFANG2 A, MZ_CHUFANG1 B, GY_GEIYAOFS C, GY_YAOPINCDJG2 D WHERE B.CHUFANGID = A.CHUFANGID AND A.GEIYAOFS = C.GEIYAOFSID(+) and D.JIAGEID = A.JIAGEID AND A.CHUFANGID IN (:"SYS_B_71") AND :"SYS_B_72" = :A1
bzy47jqr66vyk BEGIN PKG_YZ_JIEKOU.PRC_YZ_BINGQUTJ('102', :PRM_APPCODE INDICATOR :NULL_VALUE, :PRM_OUTBUFFER INDICATOR :NULL_VALUE); END;
c6fa2u8w4d8bu SELECT YINGYONGID||chr(9)||KESHIJSBZ||chr(9)||BINGQUJSBZ||chr(9)||YUANQUJSBZ||chr(9)||GONGZUOZJSBZ||chr(9)||YILIAOZJSBZ||chr(9)||XITONGID||chr(9)||YINGYONGMC||chr(9)||KESHIID||chr(9)||YUANQUID FROM GY_YINGYONG WHERE 1=:A1
c7kchyk4yk76v SELECT B.BINGANHAO סԺºÅ, B.XINGMING ÐÕÃû, C.DANGQIANCW ´²Î», ROUND(C.YAOPIN, :"SYS_B_00") Ò©Æ··Ñ, ROUND(C.CHUANGWEI, :"SYS_B_01") ´²Î»·Ñ, ROUND(C.XIANGMU, :"SYS_B_02") ÏîÄ¿·Ñ, ROUND(C.JE, :"SYS_B_03") ×Ü·ÑÓÃ, ROUND(C.YAOPIN / C.JE * :"SYS_B_04", :"SYS_B_05") AS Ò©Æ·±ÈÀý, D.YILIAOZM AS Ò½ÁÆ×é FROM ZY_BINGRENXX B, (SELECT A.BINGRENZYID, A.DANGQIANCW, SUM(CASE WHEN A.HESUANXM IN (:"SYS_B_06", :"SYS_B_07", :"SYS_B_08") THEN A.JIESUANJE ELSE :"SYS_B_09" END) AS YAOPIN, SUM(CASE WHEN A.HESUANXM IN (:"SYS_B_10") THEN A.JIESUANJE ELSE :"SYS_B_11" END) AS CHUANGWEI, SUM(CASE WHEN A.HESUANXM NOT IN (:"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15") THEN A.JIESUANJE ELSE :"SYS_B_16" END) AS XIANGMU, SUM(A.JIESUANJE) AS JE FROM ZY_FEIYONG1 A WHERE A.JIFEIRQ BETWEEN TO_DATE(:"SYS_B_17", :"SYS_B_18") AND TO_DATE(:"SYS_B_19", :"SYS_B_20") AND A.DANGQIANKS = :"SYS_B_21" GROUP BY A.BINGRENZYID, A.DANGQIANCW HAVING SUM(A.JIESUANJE) <> :"SYS_B_22") C, GY_YILIAOZU1 D WHERE B.BINGRENZYID = C.BINGRENZYID AND B.YILIAOZID = D.YILIAOZID(+) ORDER BY B.XINGMING, C.DANGQIANCW
cfmz0r3g3q9us SELECT XIANSHIMC, A.YIZHUXMID, XIANSHILX FROM YZ_CHUANGWEIPXS A, YZ_BINGRENYZ B WHERE A.YIZHUXMID = B.YIZHUXMID AND B.BINGRENZYID = :B1 AND (FUN_YZ_YIZHUPCLX(PINCI) = 2 OR DECODE(B.YIZHUZT, '4', NULL, B.YIZHUZT) = '3') ORDER BY A.XIANSHILX, B.KAISHISJ DESC
csf1x66vmvd70 Select Nvl(Sum(KuCunSL - Nvl(YiShouWFSL, :"SYS_B_00")), :"SYS_B_01"), Nvl(Sum(KuCunSL - Nvl(YiShouWFSL, :"SYS_B_02")), :"SYS_B_03"), Nvl(Sum(KuCunSL - Nvl(YiShouWFSL, :"SYS_B_04") - Nvl(XuKuCSL, :"SYS_B_05") - Nvl(LinShiKCSL, :"SYS_B_06")), :"SYS_B_07"), Nvl(Sum(KuCunSL - Nvl(XuKuCSL, :"SYS_B_08")), :"SYS_B_09") From BY_KuCun2 Where YingYongID = :"SYS_B_10" And JiaGeID = :"SYS_B_11" And NVL(TingYongBZ, :"SYS_B_12") = :"SYS_B_13"
ctc36xs0g9jh9 SELECT COUNT(*) FROM BY_KUCUN2 WHERE YINGYONGID = :B3 AND (JIAGEID = :B2 OR (JIAGEID = :B1 )) AND JINJIA > 0
d21030v816kbp SELECT case a.YAOPINLX when :"SYS_B_000" then :"SYS_B_001" when :"SYS_B_002" then :"SYS_B_003" when :"SYS_B_004" then :"SYS_B_005" when :"SYS_B_006" then :"SYS_B_007" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_008"||a.YAOPINGG As YAOPINMCGG, a.CHANDIMC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, :"SYS_B_009") as DanJia1, d.KuCunSL AS KuCunSL, :"SYS_B_010" As XiangMuLX, :"SYS_B_011" as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||:"SYS_B_012"||b.BIEMINGID||:"SYS_B_013"||a.ZHANGBULB||:"SYS_B_014"||a.GUIGEID||:"SYS_B_015"||a.CHANDI||:"SYS_B_016"||a.SHOUFEIXM||:"SYS_B_017"||a.DULIFL||:"SYS_B_018"||a.JIAZHIFL||:"SYS_B_019"||a.GEIYAOFS||:"SYS_B_020"||a.YONGYAOTC||:"SYS_B_021"||a.PISHIBZ||:"SYS_B_022"||a.KANGSHENGSXJ||:"SYS_B_023"||a.KANGJUNYXJ||:"SYS_B_024"||a.DASHUYBZ||:"SYS_B_025"||a.FUFANGBZ||:"SYS_B_026"||a.JIZHENYYBZ||:"SYS_B_027"||a.JIXING||:"SYS_B_028"||a.DuiYingPSYP||:"SYS_B_029"||b.YAOPINMC||:"SYS_B_030"||a.YAOPINGG||:"SYS_B_031"||a.YiBaoDJ||:"SYS_B_032"||a.ZuiXiaoDW||:"SYS_B_033"||a.JiLiang||:"SYS_B_034"||a.JiLiangDW||:"SYS_B_035"||a.PingJunJJ||:"SYS_B_036" ;||a.PiFaJia||:"SYS_B_037"||a.YaoPinLX||:"SYS_B_038"||a.BaoZhuangLiang||:"SYS_B_039"||a.XianLiang3||:"SYS_B_040"||a.XianLiang7||:"SYS_B_041"||a.TiJi||:"SYS_B_042"||a.TiJiDW||:"SYS_B_043"||e.YAOPINFL||:"SYS_B_044"||a.FuYaoSX||:"SYS_B_045"||a.YaoPinID||:"SYS_B_046"||a.XiaoGuiGID||:"SYS_B_047"||a.DaGuiGID||:"SYS_B_048"||a.QiTaSX||:"SYS_B_049"||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_050" And a.YingYongID=:"SYS_B_051") or (b.YaoPinLX=:"SYS_B_052" And a.YingYongID=:"SYS_B_053") or (b.YaoPinLX=:"SYS_B_054" And a.YingYongID=:"SYS_B_055") or (b.YaoPinLX=:"SYS_B_056" And a.YingYongID=:"SYS_B_057"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.DAGUIGID = b.GUIGEID And b.ZuoFeiBZ = :"SYS_B_058" And a.ZUOFEIBZ = :"SYS_B_059" AND a.CHAXUNBZ = :"SYS_B_060" And (:"SYS_B_061"=:"SYS_B_062" or (b.SHURUMA1 Like :"SYS_B_063" or b.yaopinmc like :"SYS_B_064")) and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_065") = :"SYS_B_066" and a.LinChuangSYBZ = :"SYS_B_067" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SY S_B_068") And (d.ShiYongPL <> :"SYS_B_069")) and ((a.YaoPinLX = :"SYS_B_070"and a.baozhuangliang=:"SYS_B_071") or (a.YaoPinLX = :"SYS_B_072") or (a.YaoPinLX = :"SYS_B_073") or (a.YaoPinLX = :"SYS_B_074")) and ((a.YaoPinLX = :"SYS_B_075" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_076", :"SYS_B_077", :"SYS_B_078")), :"SYS_B_079") = :"SYS_B_080") or (a.YaoPinLX = :"SYS_B_081" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_082", :"SYS_B_083", :"SYS_B_084")), :"SYS_B_085") = :"SYS_B_086") or (a.YaoPinLX = :"SYS_B_087" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_088", :"SYS_B_089", :"SYS_B_090")), :"SYS_B_091") = :"SYS_B_092") or (a.YaoPinLX = :"SYS_B_093" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_094", :"SYS_B_095", :"SYS_B_096")), :"SYS_B_097") = :"SYS_B_098")) and a.TINGYONGBZ = :"SYS_B_099" union all SELECT case a.YAOPINLX when :"SYS_B_100" then :"SYS_B_101" when :"SYS_B_102" then :"SYS_B_103" when :"SYS_B_104" then :"SYS_B_105" when :"SYS_B_106" then :"SYS_B_107" end AS XIANSHILX, b.YAOPINMC||:"SYS_B_108"||a.YAOPINGG As YAOPINMCGG, a.CHANDI MC, a.BAOZHUANGDW, Fun_Gy_Getyaopinjg_Jgtx(a.Jiageid, :"SYS_B_109") as DanJia1, d.KuCunSL AS KuCunSL, :"SYS_B_110" As XiangMuLX, :"SYS_B_111" as taocanbz, a.JIAGEID, b.ShuRuMa1 shuruma1, b.ShuRuMa2 shuruma2, b.ShuRuMa3 shuruma3, a.YAOPINMC||:"SYS_B_112"||b.BIEMINGID||:"SYS_B_113"||a.ZHANGBULB||:"SYS_B_114"||a.GUIGEID||:"SYS_B_115"||a.CHANDI||:"SYS_B_116"||a.SHOUFEIXM||:"SYS_B_117"||a.DULIFL||:"SYS_B_118"||a.JIAZHIFL||:"SYS_B_119"||a.GEIYAOFS||:"SYS_B_120"||a.YONGYAOTC||:"SYS_B_121"||a.PISHIBZ||:"SYS_B_122"||a.KANGSHENGSXJ||:"SYS_B_123"||a.KANGJUNYXJ||:"SYS_B_124"||a.DASHUYBZ||:"SYS_B_125"||a.FUFANGBZ||:"SYS_B_126"||a.JIZHENYYBZ||:"SYS_B_127"||a.JIXING||:"SYS_B_128"||a.DuiYingPSYP||:"SYS_B_129"||b.YAOPINMC||:"SYS_B_130"||a.YAOPINGG||:"SYS_B_131"||a.YiBaoDJ||:"SYS_B_132"||a.ZuiXiaoDW||:"SYS_B_133"||a.JiLiang||:"SYS_B_134"||a.JiLiangDW||:"SYS_B_135"||a.PingJunJJ||:"SYS_B_136"||a.PiFaJia||:"SYS_B_137"||a.YaoPinLX||:"SYS_B_138"||a.BaoZhuangLiang||:"SYS_B_139"||a.XianLiang3||:"SYS_B_140"||a.XianLiang7||:"SYS_B_141"||a.TiJi||:"SYS_B_142"||a.TiJiDW||:"SYS_B_143"||e.YAOPINFL||:"SYS_B_144"||a.FuYaoSX||:"SYS_B_145"||a.YaoP inID||:"SYS_B_146"||a.XiaoGuiGID||:"SYS_B_147"||a.DaGuiGID||:"SYS_B_148"||a.QiTaSX||:"SYS_B_149"||a.DuiYingPSYPSL as kuozhanlie FROM GY_YAOPINCDJG2 a, GY_YAOPINZBM b, (Select a.JiaGeID, a.KuCunSL, a.KuCunZT, a.ShiYongPL From GY_YaoPinKCZT a, GY_YaoPinCDJG2 b Where a.JiaGeID=b.JiaGeID And ((b.YaoPinLX=:"SYS_B_150" And a.YingYongID=:"SYS_B_151") or (b.YaoPinLX=:"SYS_B_152" And a.YingYongID=:"SYS_B_153") or (b.YaoPinLX=:"SYS_B_154" And a.YingYongID=:"SYS_B_155") or (b.YaoPinLX=:"SYS_B_156" And a.YingYongID=:"SYS_B_157"))) d, GY_YAOPINMC e where a.YAOPINID = e.YAOPINID And a.JIAGEID IN (SELECT c.JIAGEID FROM GY_YAOPINCDJG2 c, GY_YAOPINCDJG2 d WHERE c.DAGUIGID = d.DAGUIGID AND c.CHANDI = d.CHANDI and d.JIAGEID = b.JIAGEID) And b.ZuoFeiBZ = :"SYS_B_158" And a.ZUOFEIBZ = :"SYS_B_159" AND a.CHAXUNBZ = :"SYS_B_160" And b.SHURUMA1 Like :"SYS_B_161" and Fun_GY_HaveChuFangLX(a.YaoPinLX, :"SYS_B_162") = :"SYS_B_163" and a.LinChuangSYBZ = :"SYS_B_164" and (a.JiaGeId=d.JiaGeID And (d.KuCunSL > :"SYS_B_165") And (d.ShiYongPL <> :"SYS_B_166")) and ((a.YaoPinLX = :"SYS_B_167"and a.baozhuangliang=:"SYS_B_168") or (a.YaoPinLX = :"SYS_B_169") or (a.YaoPinLX = :"SYS_B_170") or (a.YaoPinLX = :"SYS_B_171")) and ((a.YaoPinLX = :&quo t;SYS_B_172" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_173", :"SYS_B_174", :"SYS_B_175")), :"SYS_B_176") = :"SYS_B_177") or (a.YaoPinLX = :"SYS_B_178" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_179", :"SYS_B_180", :"SYS_B_181")), :"SYS_B_182") = :"SYS_B_183") or (a.YaoPinLX = :"SYS_B_184" and substr(a.MenYaoSY, to_number(substr(:"SYS_B_185", :"SYS_B_186", :"SYS_B_187")), :"SYS_B_188") = :"SYS_B_189") or (a.YaoPinLX = :"SYS_B_190" and substr(a.BingYaoSY, to_number(substr(:"SYS_B_191", :"SYS_B_192", :"SYS_B_193")), :"SYS_B_194") = :"SYS_B_195")) and a.TINGYONGBZ = :"SYS_B_196" union all Select :"SYS_B_197" as leibie , XiangMuMC, MiaoShu , PinCi, FUN_YZ_YIZHUXMJGHZ(XIANGMUID) as danjia, :"SYS_B_198" as kucunsl, :"SYS_B_199" As LeiXing, :"SYS_B_200" as taocanbz, XiangMuID, ShuRuMa1, ShuRuMa2, ShuRuMa3, PaiChiLX||:"SYS_B_201"||DaYinBZ as kuozhanlie From YZ_YiZhuXM where SHURUMA1 Like Upper(:"SYS_B_202") And ( BingQuID = :"SYS_B_203" Or BingQuID Is Null ) and (fuleiid != -:"SYS_B_204") and zuofeibz=:"SYS_B_205" union all Select :"SYS_B_206" As leibie, mingcheng, :"SYS_B_207"As MiaoSHu, :"SYS_B_2 08" As PinCi, :"SYS_B_209" As danjia, :"SYS_B_210" As kucunsl, :"SYS_B_211" As LeiXing, :"SYS_B_212" As taocanbz, ChengZuYZID, ShuRuMa1, ShuRuMa2, ShuRuMa3, :"SYS_B_213" as kuozhanlie From YZ_ChengZuYZ1 where SHURUMA1 Like Upper(:"SYS_B_214") And ZuoFeiBZ = :"SYS_B_215" And ((SHIYONGFW = :"SYS_B_216" AND YISHENGKS = :"SYS_B_217") OR (SHIYONGFW = :"SYS_B_218" AND YISHENGKS = :"SYS_B_219") OR (SHIYONGFW = :"SYS_B_220" ) OR (SHIYONGFW = :"SYS_B_221" AND YISHENGKS = :"SYS_B_222") OR (SHIYONGFW = :"SYS_B_223" AND YISHENGKS = :"SYS_B_224") )
ddh58ya0uh1jg select :"SYS_B_00" as yiyuanmc, :"SYS_B_01"||:"SYS_B_02"||:"SYS_B_03" as pageno, :"SYS_B_04" as pageno1, b.xingming, b.chushengrq, b.xingbie, to_char(b.ruyuanrq, :"SYS_B_05") as ruyuanrq, a.chuanghao as dangqiancw, a.bingquid caozuobqid , :"SYS_B_06" as dangqianbqmc, b.binganhao as zhuyuanhao, b.DANGQIANKS , :"SYS_B_07" as dangqianksmc, :"SYS_B_08" as nianling, :"SYS_B_09" as ruyuanzdmc, :"SYS_B_10" as yingerxb, b.xingming as muqinxm, b.dangqianbq as dangqianbq, :"SYS_B_11" as bingansynl from v_twd_nurse a, v_zy_bingrenjbxx b where to_char(a.bingrenid)=b.bingrenid and nvl(a.yingerbz, :"SYS_B_12")=nvl(b.yingerbz, :"SYS_B_13") and to_char(a.bingrenid) =:"SYS_B_14" and nvl(a.yingerbz, :"SYS_B_15")=:"SYS_B_16" and a.jilusj between to_date(:"SYS_B_17", :"SYS_B_18") and to_date(:"SYS_B_19", :"SYS_B_20")
dfurxfh5cpsr3 Select Sum ( JieSuanJE ) From ZY_Feiyong1 Where BingRenZYID =:1 And JieSuanXH =0
dn7p378t5fwbb SELECT PAIDUIID FROM JH_PAIDUIDL WHERE DUILIEID = :B1 AND ZHUANGTAIID = '06'
dnnhq1970sxnf Select * from table(dbms_workload_repository.awr_report_html( :"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4"))
dvw272yj2xruh select * from(SELECT NEIRONG1|| :"SYS_B_0" xuhao, NEIRONG2 dangqianjz, NEIRONG3 zhenshi, NEIRONG4 yisheng, :"SYS_B_1" zhunbeijz, hangzhi, yewuid FROM JH_PINGMUXS WHERE YINGYONGID = :"SYS_B_2" AND XIANSHIBZ >= :"SYS_B_3" and pingmuid=:"SYS_B_4" ORDER BY HANGZHI desc) where rownum<=:"SYS_B_5"
f0wzs9nc663bn select sysdate from dual
f0xat52js9a6f SELECT A.BINGRENZYID AS BINGRENID, A.XIANSHILX, A.XIANSHIMC, B.XIANSHIYS FROM YZ_BINGRENFJXX A, YZ_CHUANGWEIPXS B WHERE A.YIZHUXMID=B.YIZHUXMID AND A.BINGRENZYID =:BINGRENID
f28yvjkfp3a1j SELECT C.DANGQIANCW, C.XINGMING, A.YAOPINMC||A.YAOPINGG, B.SHENQINGSL, A.BAOZHUANGDW, DECODE(MOD(B.LINGYAODFL, :"SYS_B_00"), :"SYS_B_01", :"SYS_B_02", :"SYS_B_03") AS QUETUIY , TO_CHAR(B.SHENQINGRQ, :"SYS_B_04"), PKG_YZ_YEWU.FUN_GETZHIGONGXM(B.FAYAOREN) AS FAYAOREN, D.YINGYONGMC FROM GY_YAOPINMCGG2 A, BY_SHENQINGDAN B , ZY_BINGRENXX C , GY_YINGYONG D WHERE (A.GUIGEID=B.GUIGEID ) AND (B.BINGRENZYID=C.BINGRENZYID) AND (B.YAOFANGYYID=D.YINGYONGID) AND ((B.FAYAOBZ=:"SYS_B_05") OR (B.JIAOYILX=-:"SYS_B_06")) AND (B.SHENQINGBQ IN ( :"SYS_B_07")) AND ((B.SHENQINGRQ>TO_DATE(:"SYS_B_08"||:"SYS_B_09", :"SYS_B_10")) AND (B.SHENQINGRQ<TO_DATE(:"SYS_B_11"||:"SYS_B_12", :"SYS_B_13"))) AND (C.DANGQIANCW IN (:"SYS_B_14" , :"SYS_B_15" , :"SYS_B_16" , :"SYS_B_17" , :"SYS_B_18" , :"SYS_B_19" , :"SYS_B_20" , :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" , :"SYS_B_25" , :"SYS_B_26" , :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" , :"SYS_B_30" , :"SYS_B_31" , :"SYS_B_32" , :"SYS_B_33" , :"SYS_B_34" , :"SYS_B_35" , :"SYS_B_36" , :"SYS_B_37" , :"SYS_B_38" , :"SYS_B_39 " , :"SYS_B_40" , :"SYS_B_41" , :"SYS_B_42" , :"SYS_B_43" , :"SYS_B_44" , :"SYS_B_45" , :"SYS_B_46")) ORDER BY DANGQIANCW
f4p11q882k5b5 SELECT MENZHENZYBZ||chr(9)||BAOGAODLX||chr(9)||SHENQINGDID||chr(9)||BINGRENSY||chr(9)||BINGRENXM||chr(9)||XIANGMUMC||chr(9)||KAIDANKS||chr(9)||KAIDANKSMC||chr(9)||KAIDANYS||chr(9)||KAIDANYSXM||chr(9)||ZHIXINGKS||chr(9)||ZHIXINGKSMC||chr(9)||ZHIXINGREN||chr(9)||ZHIXINGRXM||chr(9)||to_char(ZHIXINGRQ , 'yyyy-mm-dd hh24:mi:ss') FROM YJ_V_ZHILIAODAN WHERE MENZHENZYBZ=:A1 AND BINGRENSY = :A2
fm2s1d8zmxvq8 SELECT JIANYANZT||chr(9)||YIZHUMC||chr(9)||to_char(KAIZHUSJ , 'yyyy-mm-dd hh24:mi:ss') FROM JY_V_JIANYANYZ WHERE BINGRENZYID = :A1
fp7b2u9jbu1rb SELECT DANGQIANBQ||chr(:"SYS_B_00")||YEWUKS||chr(:"SYS_B_01")||LIYUANQX||chr(:"SYS_B_02")||DANGQIANKS||chr(:"SYS_B_03")||KESHI2||chr(:"SYS_B_04")||YEWULX||chr(:"SYS_B_05")||KESHI1||chr(:"SYS_B_06")||to_char(RUYUANRQ , :"SYS_B_07")||chr(:"SYS_B_08")||DANGQIANCW||chr(:"SYS_B_09")||BINGRENZYID||chr(:"SYS_B_10")||XINGMING||chr(:"SYS_B_11")||BINGANHAO FROM ZY_V_BINGQURZMX WHERE YEWUKS=:A1 and RUYUANRQ Between to_date(:"SYS_B_12", :"SYS_B_13") and to_date(:"SYS_B_14", :"SYS_B_15")
fsx3gt68k4t82 SELECT WANGKADZ, JISUANJM, CAOZUOYUAN, YEWULX FROM GY_YEWUDJ WHERE SUBSTR(YEWUID, 1, INSTR(YEWUID, '|') - 1) = :B2 AND INSTR(:B1 , YEWULX) > 0 AND ROWNUM = 1
fu58bh5cxz9un UPDATE ZJ_JIUZHENXX SET JIEZHENSJ = TO_DATE(:"SYS_B_0", :"SYS_B_1") WHERE JIUZHENID = :"SYS_B_2"
g4up0s70udyd6 Select ZaiYuanZT From zy_BingRenXX Where BingRenZYID =:1
gp2srf6v3th3r select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in (:"SYS_B_0", :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")
gzwr3sg0qq0wv SELECT DANGQIANKS||chr(:"SYS_B_00")||DANGQIANBQ||chr(:"SYS_B_01")||DANGQIANCW||chr(:"SYS_B_02")||XINGMING||chr(:"SYS_B_03")||FEIYONGXZ||chr(:"SYS_B_04")||YOUHUILB||chr(:"SYS_B_05")||ZHUZHIYS||chr(:"SYS_B_06")||ZAIYUANZT||chr(:"SYS_B_07")||RUYUANZDDM||chr(:"SYS_B_08")||YINGERID||chr(:"SYS_B_09")||BINGRENZYID||chr(:"SYS_B_10")||BINGRENID||chr(:"SYS_B_11")||SHIFOUYE||chr(:"SYS_B_12")||ZHUYUANHAO FROM ZY_V_XUANZEBR WHERE ZaiYuanZT = :"SYS_B_13" And BingRenZYID in (Select a.BingRenZYID From Yz_BingRenYZ a Where a.ZhiXingZT=:"SYS_B_14" And (a.YizhuZT = :"SYS_B_15" Or a.Yizhuzt = :"SYS_B_16")) And DangQianBQ=:"SYS_B_17"And :"SYS_B_18"=:A

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

Statistic Total per Second per Trans
CPU used by this session 296,240 163.86 12.00
CPU used when call started 292,631 161.87 11.86
CR blocks created 25,227 13.95 1.02
Cached Commit SCN referenced 4,035 2.23 0.16
Commit SCN cached 97 0.05 0.00
DB time 4,245,464 2,348.37 172.03
DBWR checkpoint buffers written 47,989 26.55 1.94
DBWR checkpoints 2 0.00 0.00
DBWR fusion writes 4,115 2.28 0.17
DBWR object drop buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 198 0.11 0.01
DBWR undo block writes 10,876 6.02 0.44
DFO trees parallelized 71 0.04 0.00
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 405 0.22 0.02
PX local messages sent 405 0.22 0.02
PX remote messages recv'd 475 0.26 0.02
PX remote messages sent 452 0.25 0.02
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 71 0.04 0.00
RowCR - row contention 22 0.01 0.00
RowCR attempts 40,842 22.59 1.65
RowCR hits 40,905 22.63 1.66
SMON posted for undo segment recovery 7 0.00 0.00
SMON posted for undo segment shrink 12 0.01 0.00
SQL*Net roundtrips to/from client 2,103,757 1,163.69 85.25
active txn count during cleanout 33,656 18.62 1.36
application wait time 3,692 2.04 0.15
background checkpoints completed 3 0.00 0.00
background checkpoints started 2 0.00 0.00
background timeouts 8,420 4.66 0.34
branch node splits 5 0.00 0.00
buffer is not pinned count 139,473,455 77,149.44 5,651.73
buffer is pinned count 800,801,235 442,961.46 32,450.01
bytes received via SQL*Net from client 442,781,871 244,923.83 17,942.37
bytes sent via SQL*Net to client 1,570,661,685 868,808.10 63,646.23
calls to get snapshot scn: kcmgss 24,878,912 13,761.72 1,008.14
calls to kcmgas 204,607 113.18 8.29
calls to kcmgcs 2,769 1.53 0.11
change write time 651 0.36 0.03
cleanout - number of ktugct calls 21,748 12.03 0.88
cleanouts and rollbacks - consistent read gets 16,834 9.31 0.68
cleanouts only - consistent read gets 852 0.47 0.03
cluster key scan block gets 50,706 28.05 2.05
cluster key scans 25,582 14.15 1.04
cluster wait time 52,447 29.01 2.13
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 571 0.32 0.02
commit batch/immediate requested 571 0.32 0.02
commit cleanout failures: block lost 147 0.08 0.01
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 322 0.18 0.01
commit cleanout failures: cannot pin 8 0.00 0.00
commit cleanouts 159,985 88.50 6.48
commit cleanouts successfully completed 159,507 88.23 6.46
commit immediate performed 571 0.32 0.02
commit immediate requested 571 0.32 0.02
commit txn count during cleanout 16,209 8.97 0.66
concurrency wait time 4,407,847 2,438.19 178.61
consistent changes 548,516 303.41 22.23
consistent gets 532,883,943 294,763.59 21,593.48
consistent gets - examination 26,190,626 14,487.29 1,061.29
consistent gets direct 2,163 1.20 0.09
consistent gets from cache 532,881,728 294,762.37 21,593.39
current blocks converted for CR 2 0.00 0.00
cursor authentications 10,515 5.82 0.43
data blocks consistent reads - undo records applied 120,292 66.54 4.87
db block changes 1,490,441 824.43 60.40
db block gets 2,443,689 1,351.72 99.02
db block gets direct 1,824 1.01 0.07
db block gets from cache 2,441,865 1,350.71 98.95
deferred (CURRENT) block cleanout applications 54,051 29.90 2.19
dirty buffers inspected 378 0.21 0.02
enqueue conversions 378,238 209.22 15.33
enqueue deadlocks 0 0.00 0.00
enqueue releases 908,449 502.51 36.81
enqueue requests 909,800 503.25 36.87
enqueue timeouts 1,386 0.77 0.06
enqueue waits 2,277 1.26 0.09
exchange deadlocks 4 0.00 0.00
execute count 8,392,865 4,642.50 340.10
failed probes on index block reclamation 6 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 212,470 117.53 8.61
free buffer requested 325,858 180.25 13.20
gc CPU used by this session 6,968 3.85 0.28
gc cr block build time 7,234 4.00 0.29
gc cr block flush time 524 0.29 0.02
gc cr block receive time 12,997 7.19 0.53
gc cr block send time 1,224 0.68 0.05
gc cr blocks received 23,320 12.90 0.94
gc cr blocks served 71,754 39.69 2.91
gc current block flush time 12 0.01 0.00
gc current block pin time 1,452 0.80 0.06
gc current block receive time 23,158 12.81 0.94
gc current block send time 10,291 5.69 0.42
gc current blocks received 65,927 36.47 2.67
gc current blocks served 242,666 134.23 9.83
gc local grants 75,823 41.94 3.07
gc remote grants 28,242 15.62 1.14
gcs messages sent 1,194,928 660.97 48.42
ges messages sent 58,091 32.13 2.35
global enqueue get time 23,939 13.24 0.97
global enqueue gets async 9,179 5.08 0.37
global enqueue gets sync 164,161 90.81 6.65
global enqueue releases 155,927 86.25 6.32
heap block compress 16,032 8.87 0.65
hot buffers moved to head of LRU 340,167 188.16 13.78
immediate (CR) block cleanout applications 17,687 9.78 0.72
immediate (CURRENT) block cleanout applications 18,904 10.46 0.77
index crx upgrade (found) 51 0.03 0.00
index crx upgrade (positioned) 290,322 160.59 11.76
index fast full scans (full) 5,721 3.16 0.23
index fetch by key 9,628,038 5,325.73 390.15
index scans kdiixs1 5,943,207 3,287.47 240.83
leaf node 90-10 splits 148 0.08 0.01
leaf node splits 847 0.47 0.03
lob reads 163,047 90.19 6.61
lob writes 127,800 70.69 5.18
lob writes unaligned 127,546 70.55 5.17
logons cumulative 1,230 0.68 0.05
messages received 75,441 41.73 3.06
messages sent 75,441 41.73 3.06
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 490,309,752 271,213.77 19,868.29
opened cursors cumulative 265,394 146.80 10.75
parse count (failures) 3,344 1.85 0.14
parse count (hard) 26,015 14.39 1.05
parse count (total) 1,061,334 587.07 43.01
parse time cpu 5,947 3.29 0.24
parse time elapsed 788,353 436.08 31.95
physical read IO requests 74,929 41.45 3.04
physical read bytes 762,683,392 421,876.66 30,905.40
physical read total IO requests 104,913 58.03 4.25
physical read total bytes 1,330,492,928 735,959.27 53,914.13
physical read total multi block requests 24,943 13.80 1.01
physical reads 93,101 51.50 3.77
physical reads cache 90,468 50.04 3.67
physical reads cache prefetch 18,174 10.05 0.74
physical reads direct 2,633 1.46 0.11
physical reads direct (lob) 1,738 0.96 0.07
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 38,446 21.27 1.56
physical write bytes 456,146,944 252,316.69 18,483.95
physical write total IO requests 69,230 38.29 2.81
physical write total bytes 975,762,944 539,741.15 39,539.79
physical write total multi block requests 30,240 16.73 1.23
physical writes 55,682 30.80 2.26
physical writes direct 2,038 1.13 0.08
physical writes direct (lob) 1,715 0.95 0.07
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 53,644 29.67 2.17
physical writes non checkpoint 29,406 16.27 1.19
pinned buffers inspected 10 0.01 0.00
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 1,827 1.01 0.07
queries parallelized 69 0.04 0.00
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 9,731,870 5,383.16 394.35
recursive cpu usage 58,232 32.21 2.36
redo blocks written 390,614 216.07 15.83
redo buffer allocation retries 151 0.08 0.01
redo entries 573,473 317.22 23.24
redo log space requests 155 0.09 0.01
redo log space wait time 439 0.24 0.02
redo ordering marks 8,743 4.84 0.35
redo size 186,713,124 103,279.96 7,565.97
redo subscn max counts 6,919 3.83 0.28
redo synch time 16,699 9.24 0.68
redo synch writes 25,716 14.22 1.04
redo wastage 6,780,732 3,750.75 274.77
redo write broadcast ack time 4,880 2.70 0.20
redo write time 3,230 1.79 0.13
redo writer latching time 2 0.00 0.00
redo writes 27,073 14.98 1.10
rollback changes - undo records applied 7,856 4.35 0.32
rollbacks only - consistent read gets 8,301 4.59 0.34
root node splits 0 0.00 0.00
rows fetched via callback 7,040,395 3,894.38 285.29
session connect time 84,555 46.77 3.43
session cursor cache hits 939,577 519.72 38.07
session logical reads 535,328,610 296,115.86 21,692.54
shared hash latch upgrades - no wait 348,952 193.02 14.14
shared hash latch upgrades - wait 120 0.07 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 731,778 404.78 29.65
sorts (rows) 41,975,332 23,218.56 1,700.92
sql area evicted 12,508 6.92 0.51
sql area purged 2,880 1.59 0.12
summed dirty queue length 475 0.26 0.02
switch current to new buffer 9,598 5.31 0.39
table fetch by rowid 462,858,580 256,029.22 18,755.92
table fetch continued row 1,051,662 581.72 42.62
table scan blocks gotten 338,198,037 187,073.51 13,704.43
table scan rows gotten 14,344,623,148 7,934,697.11 581,271.71
table scans (cache partitions) 0 0.00 0.00
table scans (long tables) 0 0.00 0.00
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 5,222,774 2,888.97 211.64
total number of times SMON posted 29 0.02 0.00
transaction lock background gets 0 0.00 0.00
transaction lock foreground requests 0 0.00 0.00
transaction lock foreground wait time 0 0.00 0.00
transaction rollbacks 571 0.32 0.02
transaction tables consistent read rollbacks 4 0.00 0.00
transaction tables consistent reads - undo records applied 241 0.13 0.01
undo change vector size 63,034,940 34,867.64 2,554.30
user I/O wait time 55,319 30.60 2.24
user calls 2,416,891 1,336.90 97.94
user commits 22,571 12.49 0.91
user rollbacks 2,107 1.17 0.09
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 211,392 116.93 8.57
write clones created in background 1 0.00 0.00
write clones created in foreground 6 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistic Begin Value End Value
session uga memory max 1.0E+12 1.0E+12
session pga memory 8.5E+11 8.5E+11
session pga memory max 1.3E+12 1.3E+12
session cursor cache count 44,944,181 44,993,773
session uga memory 9.0E+14 9.0E+14
opened cursors current 37,410 10,143
workarea memory allocated 69,854 77,319
logons current 626 276

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistic Total per Hour
log switches (derived) 2 3.98

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

Tablespace Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
TS_HIS3 55,316 31 6.69 1.24 30,504 17 1,385 146.87
TS_EMR 8,679 5 7.79 1.00 1,189 1 0 0.00
TS_EMR_ZY 4,946 3 9.74 1.00 1,696 1 0 0.00
TS_EMR_GY 3,361 2 11.87 1.00 52 0 0 0.00
TS_JYK 707 0 9.96 1.01 1,983 1 138 496.30
SYSAUX 502 0 5.46 1.00 1,165 1 0 0.00
UNDOTBS1 9 0 6.67 1.00 1,000 1 36 52.22
TS_ZONGWU 610 0 11.15 1.00 58 0 0 0.00
SYSTEM 321 0 5.73 1.02 117 0 0 0.00
TS_BATJ 210 0 10.76 23.67 173 0 0 0.00
TEMP 5 0 0.00 1.00 294 0 0 0.00
TS_TJGL 101 0 2.48 1.00 177 0 0 0.00
TS_SIIM 30 0 0.00 1.00 10 0 0 0.00
TS_SIIMHIS 30 0 0.00 1.00 10 0 0 0.00
TS_EMR_MZ 30 0 0.00 1.00 8 0 0 0.00
XUEYE 20 0 2.50 1.00 5 0 0 0.00
TS_EMR_JK 14 0 0.00 1.00 4 0 0 0.00
TS_YYGL 12 0 0.00 1.00 6 0 0 0.00
YUANGAN 12 0 0.00 1.00 6 0 0 0.00
TS_HISFX 12 0 0.00 1.00 4 0 0 0.00
TS_HISJC 10 0 0.00 1.00 4 0 0 0.00
TS_HISJK 10 0 0.00 1.00 4 0 0 0.00
TS_EMR_TJFX 6 0 0.00 1.00 2 0 0 0.00
USERS 5 0 4.00 1.00 2 0 0 0.00
TS_CP3 3 0 0.00 1.00 2 0 0 0.00
BATJ 2 0 0.00 1.00 2 0 0 0.00
TS_CBHS 2 0 0.00 1.00 2 0 0 0.00
UNDOTBS2 2 0 0.00 1.00 2 0 290 255.86

Back to IO Stats
Back to Top

File IO Stats

Tablespace Filename Reads Av Reads/s Av Rd(ms) Av Blks/Rd Writes Av Writes/s Buffer Waits Av Buf Wt(ms)
BATJ +DATA/db/datafile/batj.dbf 2 0 0.00 1.00 2 0 0 0.00
SYSAUX +DATA/db/datafile/sysaux.263.801761221 502 0 5.46 1.00 1,165 1 0 0.00
SYSTEM +DATA/db/datafile/system.261.801761217 321 0 5.73 1.02 117 0 0 0.00
TEMP +DATA/db/tempfile/temp.264.801761223 5 0 0.00 1.00 294 0 0  
TS_BATJ +DATA/db/datafile/ts_batj.dbf 175 0 10.23 22.49 153 0 0 0.00
TS_BATJ +DATA/db/datafile/ts_batj02.dbf 35 0 13.43 29.57 20 0 0 0.00
TS_CBHS +DATA/db/datafile/ts_cbhs.dbf 2 0 0.00 1.00 2 0 0 0.00
TS_CP3 +DATA/db/datafile/ts_cp3.dbf 3 0 0.00 1.00 2 0 0 0.00
TS_EMR +DATA/db/datafile/ts_emr01.dbf 1,136 1 5.33 1.00 182 0 0 0.00
TS_EMR +DATA/db/datafile/ts_emr02.dbf 995 1 6.23 1.00 156 0 0 0.00
TS_EMR +DATA/db/datafile/ts_emr03.dbf 829 0 5.74 1.00 119 0 0 0.00
TS_EMR +DATA/db/datafile/ts_emr04.dbf 954 1 5.28 1.00 75 0 0 0.00
TS_EMR +DATA/db/datafile/ts_emr05.dbf 1,006 1 5.19 1.00 100 0 0 0.00
TS_EMR +DATA/db/datafile/ts_emr06.dbf 3,759 2 10.72 1.00 557 0 0 0.00
TS_EMR_GY +DATA/db/datafile/ts_emr_gy.dbf 1,285 1 3.40 1.00 3 0 0 0.00
TS_EMR_GY +DATA/db/datafile/ts_emr_gy_02.dbf 2,076 1 17.11 1.00 49 0 0 0.00
TS_EMR_JK +DATA/db/datafile/ts_emr_jk.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_EMR_JK +DATA/db/datafile/ts_emr_jk02.dbf 8 0 0.00 1.00 2 0 0 0.00
TS_EMR_MZ +DATA/db/datafile/ts_emr_mz.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_EMR_MZ +DATA/db/datafile/ts_emr_mz_02.dbf 8 0 0.00 1.00 2 0 0 0.00
TS_EMR_MZ +DATA/db/datafile/ts_emr_mz_03.dbf 8 0 0.00 1.00 2 0 0 0.00
TS_EMR_MZ +DATA/db/datafile/ts_emr_mz_04.dbf 8 0 0.00 1.00 2 0 0 0.00
TS_EMR_TJFX +DATA/db/datafile/ts_emr_tjfx.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy.dbf 132 0 7.65 1.00 82 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy09.dbf 1,314 1 20.13 1.00 789 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_02.dbf 297 0 7.61 1.00 94 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_03.dbf 310 0 7.55 1.00 91 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_04.dbf 292 0 7.74 1.00 92 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_05.dbf 614 0 4.06 1.00 61 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_06.dbf 699 0 6.45 1.00 146 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_07.dbf 831 0 5.82 1.00 215 0 0 0.00
TS_EMR_ZY +DATA/db/datafile/ts_emr_zy_08.dbf 457 0 4.35 1.00 126 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his01.dbf 1,283 1 2.92 2.17 414 0 101 556.04
TS_HIS3 +DATA/db/datafile/ts_his02.dbf 1,343 1 4.42 2.34 249 0 1 10.00
TS_HIS3 +DATA/db/datafile/ts_his03.dbf 1,069 1 2.97 2.20 279 0 40 840.00
TS_HIS3 +DATA/db/datafile/ts_his04.dbf 987 1 2.68 2.29 282 0 33 271.82
TS_HIS3 +DATA/db/datafile/ts_his05.dbf 1,094 1 2.71 2.04 116 0 1 0.00
TS_HIS3 +DATA/db/datafile/ts_his06.dbf 1,304 1 2.65 2.17 120 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his07.dbf 1,107 1 3.16 2.06 83 0 2 10.00
TS_HIS3 +DATA/db/datafile/ts_his08.dbf 769 0 3.59 1.99 63 0 38 550.79
TS_HIS3 +DATA/db/datafile/ts_his09.dbf 984 1 2.92 2.16 90 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his10.dbf 795 0 3.50 1.95 275 0 4 7.50
TS_HIS3 +DATA/db/datafile/ts_his11.dbf 434 0 7.42 1.58 140 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his12.dbf 466 0 31.44 1.32 207 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his13.dbf 579 0 9.90 1.05 160 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his14.dbf 475 0 7.92 1.31 91 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his15.dbf 778 0 4.10 1.00 127 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his16.dbf 718 0 4.87 1.17 133 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his17.dbf 503 0 3.98 1.05 125 0 61 128.85
TS_HIS3 +DATA/db/datafile/ts_his18.dbf 799 0 5.94 1.00 100 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his19.dbf 588 0 4.74 1.00 56 0 0 0.00
TS_HIS3 +DATA/db/datafile/ts_his20.dbf 1,890 1 6.87 1.07 708 0 4 20.00
TS_HIS3 +DATA/db/datafile/ts_his21.dbf 2,808 2 6.51 1.00 1,566 1 7 1.43
TS_HIS3 +DATA/db/datafile/ts_his22.dbf 3,238 2 10.19 1.01 1,177 1 3 6.67
TS_HIS3 +DATA/db/datafile/ts_his23.dbf 7,021 4 4.03 1.02 1,775 1 43 214.88
TS_HIS3 +DATA/db/datafile/ts_his24.dbf 3,351 2 9.54 1.00 3,448 2 125 7.84
TS_HIS3 +DATA/db/datafile/ts_his25.dbf 2,837 2 6.15 1.00 4,584 3 194 6.75
TS_HIS3 +DATA/db/datafile/ts_his26.dbf 2,929 2 6.14 1.00 1,387 1 162 5.62
TS_HIS3 +DATA/db/datafile/ts_his27.dbf 3,885 2 8.02 1.00 3,017 2 124 149.44
TS_HIS3 +DATA/db/datafile/ts_his28.dbf 3,759 2 6.25 1.00 3,765 2 99 6.77
TS_HIS3 +DATA/db/datafile/ts_his29.dbf 4,493 2 10.66 1.00 2,606 1 284 153.35
TS_HIS3 +DATA/db/datafile/ts_his30.dbf 1,367 1 6.30 1.00 2,128 1 37 9.19
TS_HIS3 +DATA/db/datafile/ts_his31.dbf 1,663 1 12.79 1.00 1,233 1 22 9.09
TS_HISFX +DATA/db/datafile/ts_hisfx.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_HISFX +DATA/db/datafile/ts_hisfx02.dbf 8 0 0.00 1.00 2 0 0 0.00
TS_HISJC +DATA/db/datafile/ts_hisjc.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_HISJC +DATA/db/datafile/ts_hisjc02.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_HISJK +DATA/db/datafile/ts_hisjk.dbf 2 0 0.00 1.00 2 0 0 0.00
TS_HISJK +DATA/db/datafile/ts_hisjk02.dbf 8 0 0.00 1.00 2 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk01.dbf 48 0 6.25 1.00 174 0 137 499.93
TS_JYK +DATA/db/datafile/ts_jyk02.dbf 81 0 5.06 1.00 116 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk03.dbf 17 0 4.71 1.00 6 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk04.dbf 38 0 5.00 1.00 56 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk05.dbf 117 0 8.29 1.04 196 0 1 0.00
TS_JYK +DATA/db/datafile/ts_jyk06.dbf 29 0 5.52 1.00 163 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk07.dbf 16 0 167.50 1.00 32 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk08.dbf 24 0 3.33 1.00 46 0 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk09.dbf 281 0 6.23 1.00 984 1 0 0.00
TS_JYK +DATA/db/datafile/ts_jyk10.dbf 56 0 7.50 1.00 210 0 0 0.00
TS_SIIM +DATA/db/datafile/ts_siim01.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIM +DATA/db/datafile/ts_siim02.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIM +DATA/db/datafile/ts_siim03.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIM +DATA/db/datafile/ts_siim04.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIM +DATA/db/datafile/ts_siim05.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIMHIS +DATA/db/datafile/ts_siimhis01.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIMHIS +DATA/db/datafile/ts_siimhis02.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIMHIS +DATA/db/datafile/ts_siimhis03.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIMHIS +DATA/db/datafile/ts_siimhis04.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_SIIMHIS +DATA/db/datafile/ts_siimhis05.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_TJGL +DATA/db/datafile/ts_tjgl01.dbf 52 0 1.35 1.00 20 0 0 0.00
TS_TJGL +DATA/db/datafile/ts_tjgl02.dbf 5 0 2.00 1.00 10 0 0 0.00
TS_TJGL +DATA/db/datafile/ts_tjgl03.dbf 19 0 4.21 1.00 63 0 0 0.00
TS_TJGL +DATA/db/datafile/ts_tjgl04.dbf 25 0 3.60 1.00 84 0 0 0.00
TS_YYGL +DATA/db/datafile/ts_yygl01.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_YYGL +DATA/db/datafile/ts_yygl02.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_YYGL +DATA/db/datafile/ts_yygl03.dbf 4 0 0.00 1.00 2 0 0 0.00
TS_ZONGWU +DATA/db/datafile/zongwu01.dbf 31 0 3.55 1.00 19 0 0 0.00
TS_ZONGWU +DATA/db/datafile/zongwu02.dbf 12 0 4.17 1.00 13 0 0 0.00
TS_ZONGWU +DATA/db/datafile/zongwu03.dbf 6 0 0.00 1.00 2 0 0 0.00
TS_ZONGWU +DATA/db/datafile/zongwu04.dbf 561 0 11.84 1.00 24 0 0 0.00
UNDOTBS1 +DATA/db/datafile/undotbs1.262.801761221 9 0 6.67 1.00 1,000 1 36 52.22
UNDOTBS2 +DATA/db/datafile/undotbs2.265.801761227 2 0 0.00 1.00 2 0 290 255.86
USERS +DATA/db/datafile/users.266.801761227 5 0 4.00 1.00 2 0 0 0.00
XUEYE +DATA/db/datafile/ts_xueye02.dbf 13 0 2.31 1.00 3 0 0 0.00
XUEYE +DATA/db/datafile/xueye.dbf 7 0 2.86 1.00 2 0 0 0.00
YUANGAN +DATA/db/datafile/ts_yuangan01.dbf 4 0 0.00 1.00 2 0 0 0.00
YUANGAN +DATA/db/datafile/ts_yuangan02.dbf 4 0 0.00 1.00 2 0 0 0.00
YUANGAN +DATA/db/datafile/ts_yuangan03.dbf 4 0 0.00 1.00 2 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

P Number of Buffers Pool Hit% Buffer Gets Physical Reads Physical Writes Free Buff Wait Writ Comp Wait Buffer Busy Waits
D 1,472,256 100 534,001,810 90,464 53,636 0 0 1,849


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s) Recovery Estd IOs Actual Redo Blks Target Redo Blks Log File Size Redo Blks Log Ckpt Timeout Redo Blks Log Ckpt Interval Redo Blks
B 0 10 11373 114021 368640 368640 588557  
E 0 5 5762 48304 368640 368640 417856  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

P Size for Est (M) Size Factor Buffers for Estimate Est Phys Read Factor Estimated Physical Reads
D 1,216 0.10 145,692 427.91 2.7E+11
D 2,432 0.20 291,384 393.91 2.5E+11
D 3,648 0.30 437,076 85.35 54,320,353,035
D 4,864 0.40 582,768 14.07 8,952,056,662
D 6,080 0.49 728,460 3.22 2,046,410,035
D 7,296 0.59 874,152 1.79 1,136,119,880
D 8,512 0.69 1,019,844 1.38 878,923,057
D 9,728 0.79 1,165,536 1.19 756,464,273
D 10,944 0.89 1,311,228 1.08 688,459,172
D 12,160 0.99 1,456,920 1.01 640,645,595
D 12,288 1.00 1,472,256 1.00 636,421,401
D 13,376 1.09 1,602,612 0.95 607,349,618
D 14,592 1.19 1,748,304 0.92 583,517,864
D 15,808 1.29 1,893,996 0.89 564,993,183
D 17,024 1.39 2,039,688 0.87 551,029,318
D 18,240 1.48 2,185,380 0.85 539,891,830
D 19,456 1.58 2,331,072 0.83 531,314,463
D 20,672 1.68 2,476,764 0.82 524,515,604
D 21,888 1.78 2,622,456 0.81 518,420,148
D 23,104 1.88 2,768,148 0.80 508,168,785
D 24,320 1.98 2,913,840 0.74 469,119,322

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
100.00 24,361 0

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 Mem Global Mem Bound(K)
B 4,096 1,459 3,225.24 70.50 2.19 100.00 0.00 419,430
E 4,096 2,797 1,254.24 0.00 0.00 0.00 0.00 419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
2K 4K 186,786 186,786 0 0
64K 128K 2,735 2,735 0 0
128K 256K 4,722 4,722 0 0
256K 512K 232 232 0 0
512K 1024K 13,642 13,642 0 0
1M 2M 2,495 2,495 0 0
2M 4M 11 11 0 0
4M 8M 455 455 0 0
8M 16M 311 311 0 0
16M 32M 1 1 0 0
32M 64M 6 6 0 0
64M 128M 6 6 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB) Size Factr W/A MB Processed Estd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit % Estd PGA Overalloc Count
512 0.13 1,882,695.51 18,058.44 99.00 1,521
1,024 0.25 1,882,695.51 15,341.24 99.00 1,438
2,048 0.50 1,882,695.51 10,648.56 99.00 805
3,072 0.75 1,882,695.51 7,362.68 100.00 414
4,096 1.00 1,882,695.51 4.09 100.00 0
4,915 1.20 1,882,695.51 0.00 100.00 0
5,734 1.40 1,882,695.51 0.00 100.00 0
6,554 1.60 1,882,695.51 0.00 100.00 0
7,373 1.80 1,882,695.51 0.00 100.00 0
8,192 2.00 1,882,695.51 0.00 100.00 0
12,288 3.00 1,882,695.51 0.00 100.00 0
16,384 4.00 1,882,695.51 0.00 100.00 0
24,576 6.00 1,882,695.51 0.00 100.00 0
32,768 8.00 1,882,695.51 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M) SP Size Factr Est LC Size (M) Est LC Mem Obj Est LC Time Saved (s) Est LC Time Saved Factr Est LC Load Time (s) Est LC Load Time Factr Est LC Mem Obj Hits (K)
2,864 0.70 481 38,197 17,855,415 0.99 418,420 1.40 3,942,732
3,280 0.80 865 56,335 17,954,040 1.00 319,795 1.07 3,966,177
3,696 0.90 1,279 78,038 17,968,490 1.00 305,345 1.02 3,969,995
4,112 1.00 1,692 98,681 17,974,982 1.00 298,853 1.00 3,971,799
4,528 1.10 2,107 119,777 17,978,348 1.00 295,487 0.99 3,972,766
4,944 1.20 2,522 141,651 17,980,533 1.00 293,302 0.98 3,973,431
5,360 1.30 2,937 162,779 17,982,287 1.00 291,548 0.98 3,973,985
5,776 1.40 3,352 182,970 17,983,648 1.00 290,187 0.97 3,974,549
6,192 1.51 3,767 204,017 17,984,904 1.00 288,931 0.97 3,975,143
6,608 1.61 4,182 225,045 17,986,033 1.00 287,802 0.96 3,975,754
7,024 1.71 4,597 247,461 17,986,994 1.00 286,841 0.96 3,976,292
7,440 1.81 5,012 270,357 17,987,836 1.00 285,999 0.96 3,976,767
7,856 1.91 5,427 292,872 17,988,705 1.00 285,130 0.95 3,977,175
8,272 2.01 5,842 316,151 17,989,316 1.00 284,519 0.95 3,977,535

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB) Size Factor Est Spill Count Est Spill Time (s) Est Unspill Count Est Unspill Time (s)
48 0.23 0 0 0 0
80 0.38 0 0 0 0
112 0.54 0 0 0 0
144 0.69 0 0 0 0
176 0.85 0 0 0 0
208 1.00 0 0 0 0
240 1.15 0 0 0 0
272 1.31 0 0 0 0
304 1.46 0 0 0 0
336 1.62 0 0 0 0
368 1.77 0 0 0 0
400 1.92 0 0 0 0
432 2.08 0 0 0 0
464 2.23 0 0 0 0
496 2.38 0 0 0 0
528 2.54 0 0 0 0
560 2.69 0 0 0 0
592 2.85 0 0 0 0
624 3.00 0 0 0 0
656 3.15 0 0 0 0

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

Class Waits Total Wait Time (s) Avg Time (ms)
data block 1,523 272 179
undo header 292 76 261
undo block 34 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason) Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
PR-Process Startup 71 71 0 4 63 15,786.25
CF-Controlfile Transaction 5,461 5,450 11 653 48 73.94
TX-Transaction (row lock contention) 73 74 0 74 36 486.78
DX-Distributed Transaction 949,073 949,045 27 5 27 5,475.00
XR-Quiesce / Force Logging (database force logging) 588 588 0 588 23 38.74
SQ-Sequence Cache 1,996 1,996 0 16 2 94.63
PS-PX Process Reservation 1,968 621 1,348 314 1 4.65
TX-Transaction (index contention) 431 431 0 17 1 39.65
TM-DML 49,380 49,379 0 421 0 0.25
WF-AWR Flush 60 60 0 27 0 1.93
FB-Format Block 151 151 0 65 0 0.52
TT-Tablespace 246 246 0 53 0 0.25
HW-Segment High Water Mark 1,463 1,463 0 12 0 0.25
SW-Suspend Writes 1 1 0 1 0 3.00
US-Undo Segment 13 13 0 9 0 0.22
TD-KTF map table enqueue (KTF dump entries) 5 5 0 5 0 0.20
TX-Transaction (allocate ITL entry) 4 4 0 2 0 0.50
DR-Distributed Recovery 1 1 0 1 0 1.00
MW-MWIN Schedule 1 1 0 1 0 1.00
WR-LNS archiving log 2 2 0 1 0 1.00
TA-Instance Undo 12 12 0 3 0 0.00
PI-Remote PX Process Spawn Status 17 17 0 2 0 0.00
AF-Advisor Framework (task serialization) 21 21 0 1 0 0.00
WL-Being Written Redo Log 2 2 0 1 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS# Num Undo Blocks (K) Number of Transactions Max Qry Len (s) Max Tx Concurcy Min/Max TR (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
1 10.63 34,708 122 21 15.3/16.7 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End Time Num Undo Blocks Number of Transactions Max Qry Len (s) Max Tx Concy Tun Ret (mins) STO/ OOS uS/uR/uU/ eS/eR/eU
31-3ÔÂ 08:59 1,448 7,009 0 18 17 0/0 0/0/0/0/0/0
31-3ÔÂ 08:49 3,653 12,326 74 17 15 0/0 0/0/0/0/0/0
31-3ÔÂ 08:39 5,524 15,373 122 21 16 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch Name Get Requests Pct Get Miss Avg Slps /Miss Wait Time (s) NoWait Requests Pct NoWait Miss
ASM allocation 149 0.00   0 0  
ASM db client latch 1,333 0.00   0 0  
ASM map headers 156 0.00   0 0  
ASM map load waiting list 34 0.00   0 0  
ASM map operation freelist 3,487 0.00   0 0  
ASM map operation hash table 423,313 0.00 9.00 2 0  
ASM network background latch 881 0.00   0 0  
AWR Alerted Metric Element list 20,752 0.00   0 0  
Consistent RBA 27,081 0.00   0 0  
FAL request queue 39 0.00   0 0  
FAL subheap alocation 39 0.00   0 0  
FIB s.o chain latch 41 0.00   0 0  
FOB s.o list latch 18,683 0.00   0 0  
JS broadcast add buf latch 395 0.00   0 0  
JS broadcast drop buf latch 395 0.00   0 0  
JS broadcast load blnc latch 344 0.00   0 0  
JS queue state obj latch 10,320 0.00   0 0  
KCL gc element parent latch 1,312,045 0.02 2.14 93 1,957 0.00
KFK SGA context latch 1,776 0.00   0 0  
KFMD SGA 1,041 0.19 1.00 0 0  
KJC message pool free list 48,593 0.36 0.64 24 4,654 0.17
KJCT flow control latch 485,050 0.00 0.00 0 0  
KMG MMAN ready and startup request latch 609 0.00   0 0  
KSXR large replies 126 0.00   0 0  
KTF sga latch 11 0.00   0 571 0.00
KWQMN job cache list latch 130 0.00   0 0  
KWQP Prop Status 6 0.00   0 0  
LGWR NS Write 451 0.00   0 0  
MQL Tracking Latch 0     0 36 0.00
Memory Management Latch 0     0 609 0.00
OS process 5,140 0.00   0 0  
OS process allocation 3,684 0.33 0.42 1 0  
OS process: request allocation 2,790 0.36 0.20 0 0  
PL/SQL warning settings 195,686 0.00   0 0  
SGA IO buffer pool latch 442 0.00   0 442 0.00
SQL memory manager latch 3 0.00   0 588 0.00
SQL memory manager workarea list latch 199,680 0.01 0.00 0 0  
Shared B-Tree 70 0.00   0 0  
active checkpoint queue latch 12,604 0.16 0.00 0 0  
active service list 9,620 0.22 0.05 0 3,858 0.08
alert log latch 10 0.00   0 0  
archive control 99 0.00   0 0  
archive process latch 670 0.00   0 0  
begin backup scn array 1,664 0.00   0 0  
business card 142 0.00   0 0  
cache buffer handles 38,752 0.00   0 0  
cache buffers chains 1,051,012,648 0.57 0.00 1562 2,813,823 0.01
cache buffers lru chain 259,702 0.02 1.29 13 2,359,356 0.01
cache table scan latch 0     0 5,880 0.00
channel handle pool latch 2,879 0.49 0.43 0 0  
channel operations parent latch 521,266 0.00 0.00 0 0  
checkpoint queue latch 427,449 0.00 0.30 0 54,672 0.00
client/application info 6,770 0.00   0 0  
commit callback allocation 267 0.00   0 0  
compile environment latch 1,282 0.00   0 0  
dml lock allocation 98,958 0.02 0.00 0 0  
dummy allocation 2,864 0.35 0.00 0 0  
enqueue hash chains 2,305,752 0.00 0.01 0 12,818 0.00
enqueues 1,818,910 0.05 0.01 0 0  
error message lists 347 0.00   0 0  
event group latch 1,219 0.00   0 0  
file cache latch 1,252 0.00   0 0  
gcs opaque info freelist 436,970 0.04 0.00 0 0  
gcs partitioned table hash 12,879,413 0.00   0 59,647 0.00
gcs remastering latch 2,527,236 0.00 0.00 0 304 0.00
gcs resource freelist 1,330,062 0.00 0.00 0 1,022,252 0.00
gcs resource hash 3,853,559 0.02 1.81 296 1 0.00
gcs resource scan list 2 0.00   0 0  
gcs shadows freelist 1,231,175 0.00 0.00 0 1,224,876 0.00
ges caches resource lists 359,867 0.04 0.52 5 308,464 0.02
ges deadlock list 42,559 0.01 0.00 0 6 0.00
ges domain table 309,116 0.00 0.00 0 0  
ges enqueue table freelist 332,723 0.01 0.00 0 0  
ges group table 446,931 0.00 0.00 0 0  
ges process hash list 94,038 0.00 0.00 0 0  
ges process parent latch 689,481 0.00   0 30,345 0.00
ges process table freelist 2,786 0.54 0.07 0 0  
ges resource hash list 516,942 0.10 0.10 7 68,122 0.02
ges resource scan list 198 0.00   0 0  
ges resource table freelist 70,771 0.01 0.00 0 0  
ges synchronous data 64 0.00   0 34,147 0.01
ges timeout list 3,930 0.00   0 2,026 0.00
global KZLD latch for mem in SGA 995 0.00   0 0  
global tx hash mapping 573,480 0.00   0 39 0.00
hash table column usage latch 707 0.00   0 122,998 0.00
hash table modification latch 69 0.00   0 0  
interrupt manipulation 1,228 0.00   0 0  
job_queue_processes parameter latch 29 0.00   0 0  
kks stats 90,605 0.30 7.94 624 0  
kokc descriptor allocation latch 230 0.00   0 0  
ksuosstats global area 120 0.00   0 0  
ksv instance 5 0.00   0 0  
ktm global data 434 0.00   0 0  
kwqbsn:qsga 67 0.00   0 0  
lgwr LWN SCN 27,197 0.06 0.00 0 0  
library cache 3,915,245 0.29 8.13 33259 58,105 5.52
library cache load lock 1,182 0.00   0 0  
library cache lock 19,513,251 0.01 1.30 1032 0  
library cache lock allocation 57,427 0.00   0 0  
library cache pin 1,715,934 0.02 0.51 38 0  
library cache pin allocation 38,323 0.00 0.00 0 0  
list of block allocation 5,724 0.00   0 0  
loader state object freelist 3,566 0.00   0 0  
logminer context allocation 10 0.00   0 0  
longop free list parent 721 0.00   0 36 0.00
message pool operations parent latch 1,212 0.00   0 0  
messages 295,034 0.05 0.03 0 0  
mostly latch-free SCN 28,926 5.10 0.00 0 0  
msg queue 39 0.00   0 39 0.00
multiblock read objects 32,610 0.00   0 181 0.00
name-service memory objects 23,944 0.01 0.00 0 0  
name-service namespace bucket 23,714 0.00   0 0  
name-service pending queue 11,552 0.00   0 0  
name-service request 314 0.64 0.00 0 0  
name-service request queue 31,314 0.00   0 0  
ncodef allocation latch 195 0.00   0 0  
object queue header heap 53,905 0.00   0 1,680 0.00
object queue header operation 857,039 0.00 0.68 4 0  
object stats modification 9 0.00   0 0  
parallel query alloc buffer 2,383 0.13 0.33 0 0  
parallel query stats 363 0.00   0 0  
parallel txn reco latch 1,171 0.00   0 0  
parameter list 8,496 0.15 0.00 0 0  
parameter table management 2,950 0.31 1.11 0 0  
post/wait queue 60,179 0.01 0.00 0 26,912 0.01
process allocation 14,096 0.04 0.00 0 1,217 0.16
process group creation 2,790 0.32 0.00 0 0  
process queue 1,117 0.00   0 0  
process queue reference 18,452 0.02 0.00 0 1,800 0.11
qmn state object latch 4 0.00   0 0  
qmn task queue latch 252 0.40 0.00 0 0  
query server freelists 902 1.88 0.65 0 0  
query server process 53 77.36 8.68 98 52 0.00
queued dump request 9,119 0.00   0 0  
redo allocation 82,138 0.05 0.37 0 573,562 0.07
redo copy 0     0 573,720 0.05
redo writing 95,644 0.02 0.00 0 0  
resmgr group change latch 1,192 0.00   0 0  
resmgr:active threads 2,852 0.00   0 0  
resmgr:actses change group 1,153 0.00   0 0  
resmgr:free threads list 2,849 3.09 1.30 14 0  
resmgr:resource group CPU method 892 0.00   0 0  
resmgr:schema config 3 0.00   0 0  
row cache objects 1,525,445 0.17 0.09 40 816 1.59
rules engine rule set statistics 300 0.00   0 0  
segmented array pool 29 0.00   0 0  
sequence cache 131,908 0.09 0.00 0 0  
session allocation 392,105 0.12 6.41 825 0  
session idle bit 5,001,995 0.00 0.00 0 0  
session state list latch 2,280 0.00   0 0  
session switching 8,055 0.06 0.40 0 0  
session timer 1,129 0.00   0 0  
shared pool 1,342,503 0.54 5.75 12218 0  
shared pool simulator 112,053 0.02 0.44 1 0  
simulator hash latch 30,003,658 0.00 0.02 6 0  
simulator lru latch 0     0 29,992,526 0.88
slave class 152 0.00   0 0  
slave class create 850 0.71 66.67 116 0  
sort extent pool 1,043 0.00   0 0  
state object free list 6 0.00   0 0  
statistics aggregation 1,008 0.00   0 0  
temp lob duration state obj allocation 54 0.00   0 0  
temporary table state object allocation 20 0.00   0 0  
threshold alerts latch 197 0.00   0 0  
transaction allocation 2,954 0.00   0 0  
transaction branch allocation 574,049 0.00 0.00 0 0  
undo global data 177,517 0.02 8.74 87 0  
user lock 4,719 11.40 2.54 1038 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch Name Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
cache buffers chains 1,051,012,648 6,007,269 16,277 5,997,356 0 0 0
library cache 3,915,245 11,171 90,876 2,585 0 0 0
shared pool 1,342,503 7,184 41,317 2,640 0 0 0
library cache lock 19,513,251 2,882 3,733 2,342 0 0 0
row cache objects 1,525,445 2,541 225 2,453 0 0 0
simulator hash latch 30,003,658 1,394 28 1,388 0 0 0
enqueues 1,818,910 882 6 876 0 0 0
gcs resource hash 3,853,559 727 1,319 373 0 0 0
user lock 4,719 538 1,364 40 0 0 0
ges resource hash list 516,942 497 51 466 0 0 0
session allocation 392,105 454 2,912 281 0 0 0
kks stats 90,605 273 2,168 55 0 0 0
library cache pin 1,715,934 273 139 257 0 0 0
KCL gc element parent latch 1,312,045 207 444 35 0 0 0
KJC message pool free list 48,593 177 114 136 0 0 0
ges caches resource lists 359,867 152 79 83 0 0 0
messages 295,034 134 4 130 0 0 0
enqueue hash chains 2,305,752 93 1 92 0 0 0
resmgr:free threads list 2,849 88 114 14 0 0 0
cache buffers lru chain 259,702 41 53 30 0 0 0
query server process 53 41 356 0 0 0 0
redo allocation 82,138 41 15 26 0 0 0
object queue header operation 857,039 37 25 23 0 0 0
undo global data 177,517 35 306 20 0 0 0
active service list 9,620 21 1 20 0 0 0
shared pool simulator 112,053 18 8 11 0 0 0
query server freelists 902 17 11 6 0 0 0
ges process table freelist 2,786 15 1 14 0 0 0
channel handle pool latch 2,879 14 6 8 0 0 0
OS process allocation 3,684 12 5 10 0 0 0
OS process: request allocation 2,790 10 2 8 0 0 0
checkpoint queue latch 427,449 10 3 7 0 0 0
parameter table management 2,950 9 10 0 0 0 0
slave class create 850 6 400 0 0 0 0
session switching 8,055 5 2 4 0 0 0
parallel query alloc buffer 2,383 3 1 2 0 0 0
KFMD SGA 1,041 2 2 0 0 0 0
ASM map operation hash table 423,313 1 9 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch Name Where NoWait Misses Sleeps Waiter Sleeps
ASM map operation hash table kffmTranslate 0 9 9
KCL gc element parent latch kclnfndnewm 0 205 74
KCL gc element parent latch kclrwrite 0 153 204
KCL gc element parent latch kclfwrite1 0 26 57
KCL gc element parent latch kclwrt 0 24 2
KCL gc element parent latch kclnfnd 0 19 7
KCL gc element parent latch kclplz 0 16 20
KCL gc element parent latch kclbla 0 3 23
KCL gc element parent latch KCLUNLNK 0 1 19
KCL gc element parent latch kcldlc 0 1 0
KFMD SGA kfmdSlvJoinFetch 0 2 0
KJC message pool free list kjcsmpav: allocate a msg buffer 0 96 112
KJC message pool free list kjcspfmbq: free vector of msg buffers 0 16 0
KJC message pool free list kjcsombd: free freelist msg buffs 0 2 2
OS process allocation kso_new_process:2 0 4 2
OS process allocation ksosp_scrub:1 0 1 3
OS process: request allocation kso_new_process 0 2 2
active service list kswslogon: session login 0 1 1
active service list kswslogon: session logout 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 17,835 17,510
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 2,951 457
cache buffers chains kcbrls: kslbegin 0 2,218 5,756
cache buffers chains kclbla 0 512 0
cache buffers chains kclebs_1 0 184 1
cache buffers chains kcbgcur: kslbegin 0 155 19
cache buffers chains kclexpandlock 0 139 0
cache buffers chains kcbget: pin buffer 0 115 5
cache buffers chains kclwrt 0 109 0
cache buffers chains kcbbxsv 0 95 34
cache buffers chains kcbgkcbcr 0 95 434
cache buffers chains kcbzwb 0 84 69
cache buffers chains kcbgtcr: fast path 0 80 82
cache buffers chains kclcls_3 0 23 1
cache buffers chains kcbnlc 0 19 16
cache buffers chains kclpred 0 9 0
cache buffers chains kcbzib: multi-block read: nowait 0 8 0
cache buffers chains kcbnew: new latch again 0 7 0
cache buffers chains kclwcrs 0 6 0
cache buffers chains kcbchg: kslbegin: call CR func 0 4 238
cache buffers chains kcbgtcr 0 3 3
cache buffers chains kclfbst_1 0 3 0
cache buffers chains kcbbic1 0 1 0
cache buffers chains kcbcge 0 1 28
cache buffers chains kcbzgb: scan from tail. nowait 0 1 0
cache buffers chains kcllwr 0 1 0
cache buffers chains kclobj_1 0 1 0
cache buffers lru chain kcbzgws 0 46 0
cache buffers lru chain kcbbxsv: move to being written 0 5 31
cache buffers lru chain kcbbic2 0 1 1
cache buffers lru chain kcbzgb: posted for free bufs 0 1 20
channel handle pool latch ksrchconnect() 0 6 6
checkpoint queue latch kcbkubc 0 2 1
checkpoint queue latch kcbbwthc: thread checkpoint buffers 0 1 1
cost function kzulrl 0 2,909 2,189
cost function kzulgt: find user res 0 873 1,594
enqueue hash chains ksqrcl 0 1 0
enqueues ksqdel 0 3 1
enqueues ksqgel: create enqueue 0 3 5
event range base latch No latch 0 254 2,145
gcs resource hash kjbmpclose 0 400 18
gcs resource hash kjbrdrmcvtq_98 0 346 133
gcs resource hash kjbmpopen 0 335 61
gcs resource hash kjbcropen:affinity 0 43 123
gcs resource hash kjbmpwrite 0 38 14
gcs resource hash kjbrrcres_99 0 28 0
gcs resource hash kclrwrite 0 26 467
gcs resource hash kclgrantlk_1 0 17 4
gcs resource hash kjbopen:affinity 0 16 8
gcs resource hash kclzcl 0 15 22
gcs resource hash kjblocalfile_nolock 0 14 24
gcs resource hash kclfwrite1 0 12 203
gcs resource hash kjbcropen 0 7 161
gcs resource hash kjbmpconvert 0 6 1
gcs resource hash kjbrwrdone reget 0 6 0
gcs resource hash kclpdc 0 5 3
gcs resource hash kjbopen 0 2 4
gcs resource hash kjbconvert 0 1 6
gcs resource hash kjblpwreq 0 1 12
gcs resource hash kjbmpflushpi 0 1 9
ges process table freelist kjpalc: process allocation 0 1 0
ges resource hash list kjrref: find matched resource 0 19 49
ges resource hash list kjlrlr: remove lock from resource queue 0 10 0
ges resource hash list kjrmas1: lookup master node 0 10 0
ges resource hash list kjruch: move resource from cache to freelist 0 8 0
ges resource hash list kjucvl: lock convert request 0 4 0
ges resource table freelist kjruch: cached obj cleanup 0 49 0
ges resource table freelist kjrchc: cached obj cleanup 0 24 0
ges resource table freelist kjrm2c: move resource to cache 0 5 79
ges resource table freelist kjrchc2: cached obj cleanup 0 1 0
kks stats kks stats alloc/free 0 2,286 2,286
library cache kgldti: 2child 0 38,241 352
library cache kglobpn: child: 0 8,721 4,838
library cache kglpndl: child: before processing 0 6,301 9,791
library cache kglpnp: child 0 3,410 42,927
library cache kgldte: child 0 0 3,395 34,704
library cache kglukp: child 0 2,139 577
library cache kglpndl: child: after processing 0 1,971 109
library cache kglhdgn: child: 0 1,482 16,393
library cache kglnti 0 606 49
library cache kglLockCursor 0 579 1,958
library cache kglpin 0 401 250
library cache kglati 0 165 0
library cache kglhdgc: child: 0 19 2
library cache kglScanDependency 0 18 0
library cache kglobld 0 6 39
library cache kglic 0 4 1
library cache kglhdbrnl: child 0 1 8
library cache lock kgllkdl: child: no lock handle 0 24,756 3,710
library cache lock kgllkdl: child: cleanup 0 3,597 1,612
library cache lock kgllkal: child: multiinstance 0 22 116
library cache lock ksucallcbksafely: kqllhng 0 1 0
library cache pin kglpndl 0 137 109
library cache pin kglpnp: child 0 2 29
messages ksaamb: after wakeup 0 2 2
messages ksarcv 0 2 0
object queue header operation kclobj_1 0 11 2
object queue header operation kcbo_switch_q_bg 0 9 3
object queue header operation kclobj_3 0 6 0
parallel query alloc buffer kxfpbalo 0 1 1
parameter table management ksp_param_table_free 0 10 2
query server freelists kxfpobadf 0 6 11
query server freelists kxfpgsg: KSLBEGIN: nullgrp 0 5 0
query server process kxfpg1srv 0 315 342
query server process kxfpcrer 0 41 14
redo allocation kcrfw_redo_gen: redo allocation 1 0 13 0
redo allocation kcrfw_redo_gen: redo allocation 3 0 2 2
resmgr:free threads list kgskthrcreate 0 112 110
resmgr:free threads list kgskthrsod 0 2 4
row cache objects kqreqd 0 73 1
row cache objects kqreqd: reget 0 69 2
row cache objects kqrpre: find obj 0 25 203
row cache objects kqrbgl 0 3 0
row cache objects kqrso 0 2 0
row cache objects kqrbtm: pop parent 0 1 0
session allocation ksucrp 0 2,801 1,578
session allocation ksucri 0 95 1,084
session allocation ksuxds: not user session 0 9 2
session allocation ksudlp 0 3 132
session allocation ksuxds: KSUSFCLC not set 0 2 115
session allocation ksuprc 0 1 0
session switching kskexeall 0 2 2
shared pool kghalo 0 26,637 32,422
shared pool kghfrunp: alloc: wait 0 15,738 1,043
shared pool kghfrunp: clatch: wait 0 15,422 3,244
shared pool kghfrunp: clatch: nowait 0 11,382 0
shared pool kghfrh 0 1,323 0
shared pool kghfre 0 574 3,885
shared pool kghupr1 0 552 6,742
shared pool kghalp 0 149 882
shared pool kghasp 0 5 2
shared pool simulator kglsim_unpin_simhp 0 4 6
shared pool simulator kglsim_upd_newhp 0 4 2
simulator hash latch kcbsacc: lookup dba 0 28 28
slave class create ksvcreate 0 395 0
slave class create ksvgetwork1 0 3 2
slave class create ksvsubmit 0 2 2
undo global data ktucof: at start 0 294 0
undo global data ktudba: KSLBEGIN 0 12 306

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

Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
HIS4TL TS_HIS3 JH_DUILIEXX   TABLE 115,121,888 21.50
HIS4TL TS_HIS3 JH_PAIDUIDL   TABLE 74,528,720 13.92
HIS4TL TS_HIS3 ZY_FEIYONG1   TABLE 67,325,264 12.58
HIS4TL TS_HIS3 YJ_JIANYANSQD   TABLE 39,463,536 7.37
HIS4TL TS_HIS3 ZY_BINGRENXX   TABLE 35,505,184 6.63

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Owner Tablespace Name Object Name Subobject Name Obj. Type Physical Reads %Total
HIS4TL TS_HIS3 ZY_FEIYONG1   TABLE 11,218 12.05
HIS4TL TS_HIS3 BY_SHENQINGDAN   TABLE 7,211 7.75
HIS4TL TS_HIS3 YZ_BINGRENYZ   TABLE 3,154 3.39
EMR3 TS_EMR_GY GY_DOC_MOBAN_V4   TABLE 3,142 3.37
HIS4TL TS_HIS3 IDX_ZY_FEIYONG1_BRZYID_JFRQ   INDEX 2,709 2.91

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Row Lock Waits % of Capture
HIS4TL TS_HIS3 YZ_BINGRENFJXX   TABLE 100 22.47
JYK TS_JYK IDX_L_TESTRESULT_SAMPLENO   INDEX 25 5.62
HIS4TL TS_HIS3 IDX_MZ_FAPIAO1_NVLRBID   INDEX 19 4.27
HIS4TL TS_HIS3 IDX_YZ_YIZHUZX_ZXSJ   INDEX 15 3.37
HIS4TL TS_HIS3 PK_YZ_YIZHUZX   INDEX 13 2.92

Back to Segment Statistics
Back to Top

Segments by ITL Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type ITL Waits % of Capture
HIS4TL TS_HIS3 IDX_MZ_FAPIAO1_YFPID   INDEX 1 33.33
HIS4TL TS_HIS3 IDX_MZ_SHOUFEI1_GHID   INDEX 1 33.33
HIS4TL TS_HIS3 PK_ZY_FEIYONG1   INDEX 1 33.33

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

Owner Tablespace Name Object Name Subobject Name Obj. Type Buffer Busy Waits % of Capture
HIS4TL TS_HIS3 PK_ZY_JIESUAN2   INDEX 14 29.79
HIS4TL TS_HIS3 JH_DUILIEXX   TABLE 11 23.40
HIS4TL TS_HIS3 YZ_BINGRENFJXX   TABLE 9 19.15
HIS4TL TS_HIS3 IDX_MZ_FAPIAO1_NVLRBID   INDEX 6 12.77
HIS4TL TS_HIS3 GY_YEWUDJ   TABLE 3 6.38

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

Owner Tablespace Name Object Name Subobject Name Obj. Type GC Buffer Busy % of Capture
JYK TS_JYK IDX_L_SOURCE_DEVICEID   INDEX 137 22.35
HIS4TL TS_HIS3 JH_DUILIEXX   TABLE 91 14.85
HIS4TL TS_HIS3 IDX_MZ_CHUFANG1_JIUZHENID   INDEX 86 14.03
HIS4TL TS_HIS3 JH_PINGMUXS   TABLE 65 10.60
HIS4TL TS_HIS3 JH_PAIDUIDL   TABLE 43 7.01

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

Owner Tablespace Name Object Name Subobject Name Obj. Type CR Blocks Received %Total
HIS4TL TS_HIS3 YZ_BINGRENYZ   TABLE 3,480 14.92
JYK TS_JYK IDX_L_SOURCE_DEVICEID   INDEX 1,470 6.30
HIS4TL TS_HIS3 GY_YEWUDJ   TABLE 1,036 4.44
HIS4TL TS_HIS3 PK_YZ_BINGRENFJXX   INDEX 837 3.59
HIS4TL TS_HIS3 YJ_JIANYANSQD   TABLE 826 3.54

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

Owner Tablespace Name Object Name Subobject Name Obj. Type Current Blocks Received %Total
HIS4TL TS_HIS3 MZ_YIJI1   TABLE 44,839 68.01
JYK TS_JYK IDX_L_PATIENTINFO_SAMPLENO   INDEX 2,696 4.09
HIS4TL TS_HIS3 YZ_BINGRENYZ   TABLE 1,469 2.23
HIS4TL TS_HIS3 PK_YZ_BINGRENYZ   INDEX 684 1.04
HIS4TL TS_HIS3 IDX_ZY_FEIYONG1_BRZYID_JFRQ   INDEX 657 1.00

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

Cache Get Requests Pct Miss Scan Reqs Pct Miss Mod Reqs Final Usage
dc_awr_control 42 0.00 0   6 1
dc_database_links 2,036 0.00 0   0 1
dc_global_oids 193 2.59 0   0 26
dc_histogram_data 51,690 1.53 0   0 10,576
dc_histogram_defs 37,650 3.16 0   0 7,935
dc_object_grants 8,486 0.59 0   0 94
dc_object_ids 115,513 0.10 0   0 2,219
dc_objects 11,010 1.93 0   0 1,229
dc_profiles 995 0.00 0   0 1
dc_rollback_segments 3,727 0.13 0   0 67
dc_segments 36,861 0.75 0   23 1,725
dc_sequences 7,059 4.92 0   7,059 55
dc_tablespace_quotas 3 33.33 0   3 2
dc_tablespaces 101,000 0.00 0   0 29
dc_usernames 8,306 0.06 0   0 27
dc_users 139,492 0.00 0   0 59
outstanding_alerts 81 96.30 0   0 27

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

Cache GES Requests GES Conflicts GES Releases
dc_awr_control 12 0 0
dc_global_oids 5 0 2
dc_histogram_defs 1,190 0 790
dc_object_ids 115 0 64
dc_objects 213 0 114
dc_rollback_segments 5 5 0
dc_segments 313 7 107
dc_sequences 14,077 372 13
dc_tablespace_quotas 6 2 0
dc_usernames 5 0 19
outstanding_alerts 162 78 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

Namespace Get Requests Pct Miss Pin Requests Pct Miss Reloads Invali- dations
BODY 2,313 0.00 202,872 0.00 1 0
CLUSTER 7 0.00 12 0.00 0 0
INDEX 6 0.00 53 1.89 1 0
SQL AREA 338,279 75.95 9,072,385 0.59 4,708 201
TABLE/PROCEDURE 6,848 0.54 605,976 0.10 346 0
TRIGGER 887 0.00 42,574 0.01 3 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

Namespace GES Lock Requests GES Pin Requests GES Pin Releases GES Inval Requests GES Invali- dations
CLUSTER 12 0 0 0 0
INDEX 53 0 8 0 0
TABLE/PROCEDURE 93,959 40 57 26 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

Category Alloc (MB) Used (MB) Avg Alloc (MB) Std Dev Alloc (MB) Max Alloc (MB) Hist Max Alloc (MB) Num Proc Num Alloc
B Other 2,580.34   4.09 5.26 112 112 631 631
  Freeable 412.75 0.00 0.87 0.80 15   472 472
  SQL 193.34 126.59 0.32 2.19 54 231 602 592
  PL/SQL 23.41 15.41 0.04 0.04 0 19 631 627
E Other 1,062.80   3.81 7.20 112 112 279 279
  Freeable 147.13 0.00 0.82 0.83 11   179 179
  SQL 35.80 18.44 0.14 0.20 1 232 253 243
  PL/SQL 8.68 5.44 0.03 0.04 0 0 279 277

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions Begin Size (Bytes) End Size (Bytes) (if different)
Database Buffers 12,884,901,888  
Fixed Size 2,127,832  
Redo Buffers 14,647,296  
Variable Size 4,949,280,808  

Back to Memory Statistics
Back to Top

SGA breakdown difference

Pool Name Begin MB End MB % Diff
java free memory 208.00 208.00 0.00
large free memory 207.63 207.63 0.00
shared ASH buffers 50.00 50.00 0.00
shared CCursor 1,029.96 1,004.72 -2.45
shared Cursor Stats 44.38 44.38 0.00
shared PCursor 412.42 401.77 -2.58
shared db_block_hash_buckets 90.00 90.00 0.00
shared free memory 357.92 374.97 4.76
shared gcs resources 280.22 280.22 0.00
shared gcs shadows 154.34 154.34 0.00
shared kglsim object batch 61.47 61.47 0.00
shared library cache 203.15 205.50 1.16
shared sql area 471.67 501.22 6.27
shared sql area:PLSQL 643.94 637.27 -1.04
streams free memory 208.00 208.00 0.00
  buffer_cache 12,288.00 12,288.00 0.00
  fixed_sga 2.03 2.03 0.00
  log_buffer 13.97 13.97 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

Session Type CPU Time User I/O Time Sys I/O Time
QMON Coordinator 90,000 0 0
QMON Slaves -140,000 0 0

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

Ruleset Name Evals Fast Evals SQL Execs CPU Time Elapsed Time
SYS.ALERT_QUE_R 0 0 0 0 0

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource Name Current Utilization Maximum Utilization Initial Allocation Limit
gcs_resources 967,412 1,704,239 1668065 1668065
ges_procs 279 998 1001 1001
processes 280 1,000 1000 1000
sessions 293 1,105 1105 1105


Back to Top

init.ora Parameters

Parameter Name Begin value End value (if different)
archive_lag_target 1800   
audit_file_dest /oracle/admin/db/adump   
background_dump_dest /oracle/admin/db/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.5.0   
control_files +DATA/db/control01.ctl, +DATA/db/control02.ctl, +DATA/db/control03.ctl   
core_dump_dest /oracle/admin/db/cdump   
cursor_sharing FORCE   
db_block_size 8192   
db_cache_size 12884901888   
db_domain      
db_file_multiblock_read_count 128   
db_name db   
fal_client DB   
fal_server DG   
instance_number 1   
java_pool_size 218103808   
job_queue_processes 10   
large_pool_size 218103808   
local_listener LISTENERS_DB1   
log_archive_config DG_CONFIG=(db, dg)   
log_archive_dest_1 location=+data/db/archivelog   
log_archive_dest_2 SERVICE=dg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=dg   
log_archive_dest_state_1 ENABLE   
log_archive_dest_state_2 ENABLE   
open_cursors 3000   
pga_aggregate_target 4294967296   
processes 1000   
remote_listener      
remote_login_passwordfile EXCLUSIVE   
session_cached_cursors 200   
sessions 1105   
sga_max_size 17850957824   
sga_target 0   
shared_pool_size 4294967296   
spfile +DATA/db/spfiledb.ora   
standby_file_management AUTO   
streams_pool_size 218103808   
thread 1   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/admin/db/udump   


Back to Top

Global Enqueue Statistics

Statistic Total per Second per Trans
acks for commit broadcast(actual) 6,666 3.69 0.27
acks for commit broadcast(logical) 7,373 4.08 0.30
broadcast msgs on commit(actual) 27,046 14.96 1.10
broadcast msgs on commit(logical) 27,073 14.98 1.10
broadcast msgs on commit(wasted) 1,011 0.56 0.04
broadcast on commit wait time(ms) 37,928 20.98 1.54
broadcast on commit waits 21,690 12.00 0.88
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 16 0.01 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 0 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 205,373 113.60 8.32
gcs ast xid 1 0.00 0.00
gcs blocked converts 13,919 7.70 0.56
gcs blocked cr converts 50,730 28.06 2.06
gcs compatible basts 349 0.19 0.01
gcs compatible cr basts (global) 3,299 1.82 0.13
gcs compatible cr basts (local) 204,304 113.01 8.28
gcs cr basts to PIs 0 0.00 0.00
gcs cr serve without current lock 0 0.00 0.00
gcs dbwr flush pi msgs 3,239 1.79 0.13
gcs dbwr write request msgs 2,815 1.56 0.11
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 1,828 1.01 0.07
gcs immediate (null) converts 145,881 80.69 5.91
gcs immediate cr (compatible) converts 1 0.00 0.00
gcs immediate cr (null) converts 1,031,639 570.65 41.80
gcs indirect ast 31,675 17.52 1.28
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 788 0.44 0.03
gcs msgs process time(ms) 694,424 384.12 28.14
gcs msgs received 2,345,199 1,297.24 95.03
gcs out-of-order msgs 0 0.00 0.00
gcs pings refused 1 0.00 0.00
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 0 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 0 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 33 0.02 0.00
gcs side channel msgs actual 16,300 9.02 0.66
gcs side channel msgs logical 112,901 62.45 4.57
gcs stale cr 0 0.00 0.00
gcs undo cr 68 0.04 0.00
gcs write notification msgs 247 0.14 0.01
gcs writes refused 11 0.01 0.00
ges msgs process time(ms) 30,007 16.60 1.22
ges msgs received 40,989 22.67 1.66
global posts dropped 0 0.00 0.00
global posts queue time 0 0.00 0.00
global posts queued 0 0.00 0.00
global posts requested 0 0.00 0.00
global posts sent 0 0.00 0.00
implicit batch messages received 73,056 40.41 2.96
implicit batch messages sent 7,398 4.09 0.30
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 30,174 16.69 1.22
messages queue sent actual 83,600 46.24 3.39
messages queue sent logical 103,642 57.33 4.20
messages received actual 548,879 303.61 22.24
messages received logical 2,386,238 1,319.94 96.69
messages sent directly 93,845 51.91 3.80
messages sent indirectly 67,287 37.22 2.73
messages sent not implicit batched 76,203 42.15 3.09
messages sent pbatched 1,096,158 606.34 44.42
msgs causing lmd to send msgs 7,664 4.24 0.31
msgs causing lms(s) to send msgs 111,796 61.84 4.53
msgs received queue time (ms) 884,749 489.40 35.85
msgs received queued 2,386,257 1,319.95 96.70
msgs sent queue time (ms) 1,035,915 573.01 41.98
msgs sent queue time on ksxp (ms) 273,208 151.12 11.07
msgs sent queued 93,934 51.96 3.81
msgs sent queued on ksxp 286,612 158.54 11.61
number of ges deadlock detected 0 0.00 0.00
process batch messages received 163,423 90.40 6.62
process batch messages sent 140,237 77.57 5.68


Back to Top

Global CR Served Stats

Statistic Total
CR Block Requests 69,617
CURRENT Block Requests 2,277
Data Block Requests 69,617
Undo Block Requests 70
TX Block Requests 1,665
Current Results 71,130
Private results 117
Zero Results 642
Disk Read Results 0
Fail Results 0
Fairness Down Converts 16,717
Fairness Clears 0
Free GC Elements 0
Flushes 214
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 0
Light Works 183
Errors 0


Back to Top

Global CURRENT Served Stats

Statistic Total % <1ms % <10ms % <100ms % <1s % <10s
Pins 242,790 99.80 0.13 0.07 0.00 0.00
Flushes 33 66.67 21.21 12.12 0.00 0.00
Writes 4,072 67.49 20.31 5.82 2.19 4.20


Back to Top

Global Cache Transfer Stats

    CR Current
Inst No Block Class Blocks Received % Immed % Busy % Congst Blocks Received % Immed % Busy % Congst
2 data block 22,396 99.36 0.64 0.00 65,314 99.93 0.07 0.00
2 Others 359 99.72 0.28 0.00 566 100.00 0.00 0.00
2 undo header 527 97.91 2.09 0.00 17 100.00 0.00 0.00
2 undo block 59 98.31 1.69 0.00 0      


Back to Top

End of Report