WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1226649220orcl2210.2.0.4.0YESrac02

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:3359231-7月 -13 09:00:05192 58.5
End Snap:3359331-7月 -13 10:00:07185 59.2
Elapsed:  60.03 (mins)  
DB Time:  205.04 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,664M 1,760MStd Block Size: 8K
Shared Pool Size: 2,368M 2,272MLog Buffer: 14,340K

Load Profile

Per SecondPer Transaction
Redo size: 14,843.57 6,285.59
Logical reads: 46,087.51 19,516.00
Block changes: 92.02 38.97
Physical reads: 133.00 56.32
Physical writes: 6.07 2.57
User calls: 625.83 265.01
Parses: 119.95 50.79
Hard parses: 3.14 1.33
Sorts: 89.34 37.83
Logons: 0.13 0.06
Executes: 355.47 150.53
Transactions: 2.36 

% Blocks changed per Read: 0.20Recursive Call %: 46.79
Rollback per transaction %: 43.23Rows per Sort: 79.39

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.73In-memory Sort %: 100.00
Library Hit %: 98.61Soft Parse %: 97.39
Execute to Parse %: 66.26Latch Hit %: 99.95
Parse CPU to Parse Elapsd %: 35.91% Non-Parse CPU: 90.68

Shared Pool Statistics

BeginEnd
Memory Usage %: 86.35 85.19
% SQL with executions>1: 87.59 86.52
% Memory for SQL w/exec>1: 83.01 83.85

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 431,376 3,990 9 32.4User I/O
log file sync 7,250 2,354 325 19.1Commit
gc buffer busy 2,501 2,282 912 18.5Cluster
gc cr block busy 2,904 2,280 785 18.5Cluster
CPU time  1,195  9.7 

RAC Statistics

BeginEnd
Number of Instances: 2 2

Global Cache Load Profile

Per SecondPer Transaction
Global Cache blocks received: 62.04 26.27
Global Cache blocks served: 304.97 129.14
GCS/GES messages received: 518.43 219.53
GCS/GES messages sent: 249.77 105.77
DBWR Fusion writes: 1.05 0.44
Estd Interconnect traffic (KB) 3,086.08 

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

Buffer access - local cache %: 99.59
Buffer access - remote cache %: 0.13
Buffer access - disk %: 0.27

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2
Avg global cache cr block receive time (ms): 92.5
Avg global cache current block receive time (ms): 0.4
Avg global cache cr block build time (ms): 0.0
Avg global cache cr block send time (ms): 0.0
Global cache log flushes for cr blocks served %: 5.1
Avg global cache cr block flush time (ms): 1,399.7
Avg global cache current block pin time (ms): 0.0
Avg global cache current block send time (ms): 0.0
Global cache log flushes for current blocks served %: 0.0
Avg global cache current block flush time (ms): 0.5

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1
Avg message sent queue time on ksxp (ms): 0.1
Avg message received queue time (ms): 0.0
Avg GCS message process time (ms): 0.0
Avg GES message process time (ms): 0.0
% of direct sent messages: 51.54
% of indirect sent messages: 47.00
% of flow controlled messages: 1.46


Main Report

More RAC Statistics


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 9,787.25 79.56
DB CPU 1,195.34 9.72
parse time elapsed 365.21 2.97
hard parse elapsed time 246.92 2.01
PL/SQL execution elapsed time 128.94 1.05
sequence load elapsed time 117.93 0.96
hard parse (sharing criteria) elapsed time 26.44 0.21
hard parse (bind mismatch) elapsed time 25.35 0.21
PL/SQL compilation elapsed time 4.04 0.03
connection management call elapsed time 0.46 0.00
failed parse elapsed time 0.15 0.00
repeated bind elapsed time 0.07 0.00
DB time 12,302.13  
background elapsed time 2,474.69  
background cpu time 106.72  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Cluster 455,673 0.84 4,709 10 53.57
User I/O 452,957 0.00 4,220 9 53.25
Commit 7,250 26.77 2,354 325 0.85
System I/O 34,894 0.00 1,296 37 4.10
Other 127,346 79.05 902 7 14.97
Concurrency 11,354 0.20 32 3 1.33
Configuration 1,240 98.87 24 19 0.15
Network 2,434,260 0.00 6 0 286.18
Application 77 0.00 0 0 0.01

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file sequential read 431,376 0.00 3,990 9 50.71
log file sync 7,250 26.77 2,354 325 0.85
gc buffer busy 2,501 76.01 2,282 912 0.29
gc cr block busy 2,904 62.95 2,280 785 0.34
gcs log flush sync 29,764 96.19 669 22 3.50
db file parallel write 6,431 0.00 455 71 0.76
control file sequential read 14,797 0.00 287 19 1.74
log file parallel write 6,614 0.00 275 42 0.78
control file parallel write 1,459 0.00 273 187 0.17
db file parallel read 4,269 0.00 123 29 0.50
direct path read 12,017 0.00 97 8 1.41
ARCH wait on c/f tx acquire 2 83 100.00 81 977 0.01
cr request retry 73 79.45 71 966 0.01
DFS lock handle 1,036 10.91 62 60 0.12
gc cr multi block request 56,646 0.07 61 1 6.66
gc current block 2-way 147,771 0.00 41 0 17.37
gc cr grant 2-way 210,799 0.00 33 0 24.78
buffer busy waits 46 47.83 27 587 0.01
enq: SQ - contention 10 40.00 24 2353 0.00
Streams AQ: qmn coordinator waiting for slave to start 4 75.00 16 3900 0.00
db file scattered read 4,768 0.00 10 2 0.56
gc cr block 2-way 24,382 0.00 8 0 2.87
log file sequential read 5,396 0.00 6 1 0.63
gc current block busy 50 4.00 3 67 0.01
SQL*Net message to client 2,274,129 0.00 2 0 267.36
gc current grant busy 4,996 0.00 2 0 0.59
SQL*Net more data to client 149,983 0.00 2 0 17.63
name-service call wait 21 0.00 2 73 0.00
library cache lock 5,094 0.00 1 0 0.60
row cache lock 4,639 0.00 1 0 0.55
LNS wait on SENDREQ 784 0.00 1 2 0.09
os thread startup 26 0.00 1 42 0.00
SQL*Net more data from client 9,364 0.00 1 0 1.10
gc current grant 2-way 5,260 0.00 1 0 0.62
PX Deq Credit: send blkd 8,707 12.58 1 0 1.02
latch: library cache 57 0.00 1 10 0.01
Log archive I/O 195 0.00 0 2 0.02
direct path read temp 213 0.00 0 2 0.03
enq: XR - database force logging 1,168 0.00 0 0 0.14
PX Deq: reap credit 34,402 85.83 0 0 4.04
library cache pin 1,194 0.00 0 0 0.14
CGS wait for IPC msg 32,354 99.94 0 0 3.80
enq: PS - contention 538 0.00 0 0 0.06
rdbms ipc reply 1,016 0.00 0 0 0.12
enq: CF - contention 292 0.00 0 1 0.03
reliable message 631 0.00 0 0 0.07
gc current split 9 0.00 0 16 0.00
IPC send completion sync 574 96.52 0 0 0.07
wait for scn ack 216 0.00 0 1 0.03
ksxr poll remote instances 15,335 52.47 0 0 1.80
direct path write temp 230 0.00 0 0 0.03
ges global resource directory to be frozen 7 100.00 0 11 0.00
enq: TX - index contention 14 0.00 0 5 0.00
PX Deq: Signal ACK 442 35.29 0 0 0.05
latch free 24 0.00 0 1 0.00
SQL*Net break/reset to client 58 0.00 0 1 0.01
latch: cache buffers chains 232 0.00 0 0 0.03
gc cr disk read 126 0.00 0 0 0.01
gc current multi block request 107 0.00 0 0 0.01
latch: shared pool 36 0.00 0 0 0.00
gc cr failure 73 0.00 0 0 0.01
cursor: pin S wait on X 1 100.00 0 12 0.00
Data file init write 3 0.00 0 4 0.00
enq: TT - contention 50 0.00 0 0 0.01
direct path write 80 0.00 0 0 0.01
kjbdrmcvtq lmon drm quiesce: ping completion 7 28.57 0 1 0.00
LGWR wait for redo copy 208 0.00 0 0 0.02
enq: TM - contention 18 0.00 0 0 0.00
enq: FB - contention 24 0.00 0 0 0.00
enq: WF - contention 11 0.00 0 1 0.00
enq: TD - KTF dump entries 12 0.00 0 0 0.00
enq: PI - contention 8 0.00 0 1 0.00
enq: TA - contention 19 0.00 0 0 0.00
latch: ges resource hash list 58 0.00 0 0 0.01
latch: cache buffers lru chain 11 0.00 0 0 0.00
latch: session allocation 30 0.00 0 0 0.00
undo segment extension 1,222 100.00 0 0 0.14
enq: HW - contention 7 0.00 0 0 0.00
latch: KCL gc element parent latch 80 0.00 0 0 0.01
enq: PE - contention 8 0.00 0 0 0.00
enq: PG - contention 6 0.00 0 0 0.00
latch: row cache objects 12 0.00 0 0 0.00
enq: TO - contention 4 0.00 0 0 0.00
KJC: Wait for msg sends to complete 43 0.00 0 0 0.01
enq: JS - job run lock - synchronize 2 0.00 0 0 0.00
gc current block unknown 3 0.00 0 0 0.00
db file single write 1 0.00 0 1 0.00
log file single write 2 0.00 0 0 0.00
enq: DR - contention 2 0.00 0 0 0.00
enq: IR - contention 2 0.00 0 0 0.00
gc object scan 46 100.00 0 0 0.01
latch: gcs resource hash 11 0.00 0 0 0.00
enq: TX - allocate ITL entry 1 0.00 0 0 0.00
latch: library cache lock 3 0.00 0 0 0.00
enq: CT - state 1 0.00 0 0 0.00
enq: TX - row lock contention 1 0.00 0 0 0.00
cursor: pin S 6 0.00 0 0 0.00
buffer deadlock 27 100.00 0 0 0.00
PX qref latch 25 100.00 0 0 0.00
latch: redo allocation 1 0.00 0 0 0.00
latch: messages 1 0.00 0 0 0.00
ges2 LMON to wake up LMD - mrcvr 2 0.00 0 0 0.00
SQL*Net message from client 2,274,124 0.00 514,601 226 267.36
gcs remote message 1,024,011 98.39 9,810 10 120.39
PX Idle Wait 2,543 85.84 5,763 2266 0.30
Streams AQ: qmn slave idle wait 132 6.06 3,696 28002 0.02
class slave wait 78 21.79 3,546 45462 0.01
DIAG idle wait 17,849 0.00 3,518 197 2.10
ASM background timer 820 0.00 3,517 4289 0.10
ges remote message 71,143 91.52 3,517 49 8.36
LNS ASYNC end of log 326,328 100.00 3,513 11 38.36
Streams AQ: qmn coordinator idle wait 264 52.27 3,503 13271 0.03
virtual circuit status 120 100.00 3,500 29170 0.01
Streams AQ: waiting for time management or cleanup tasks 189 64.55 3,446 18233 0.02
jobq slave wait 60 100.00 176 2930 0.01
PX Deq: Execution Msg 1,815 21.16 126 69 0.21
SGA: MMAN sleep for component shrink 5,523 99.91 59 11 0.65
PX Deq: Join ACK 511 34.44 0 1 0.06
PX Deq: Execute Reply 346 6.65 0 1 0.04
KSV master wait 56 0.00 0 5 0.01
PX Deq: Parse Reply 499 33.07 0 0 0.06
PX Deq: Msg Fragment 692 22.25 0 0 0.08
Streams AQ: RAC qmn coordinator idle wait 265 100.00 0 0 0.03

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 80,995 85.61 767 9 9.52
db file parallel write 6,431 0.00 455 71 0.76
gc cr block busy 244 95.90 292 1197 0.03
control file sequential read 13,578 0.00 286 21 1.60
log file parallel write 6,615 0.00 275 42 0.78
control file parallel write 1,456 0.00 273 187 0.17
db file sequential read 1,926 0.00 7 3 0.23
log file sequential read 5,396 0.00 6 1 0.63
LNS wait on SENDREQ 784 0.00 1 2 0.09
os thread startup 25 0.00 1 40 0.00
Log archive I/O 195 0.00 0 2 0.02
gc current block 2-way 1,424 0.00 0 0 0.17
row cache lock 544 0.00 0 0 0.06
db file scattered read 64 0.00 0 3 0.01
gc cr grant 2-way 978 0.00 0 0 0.11
gc cr block 2-way 331 0.00 0 0 0.04
db file parallel read 15 0.00 0 6 0.00
direct path read 72 0.00 0 1 0.01
gc current grant 2-way 249 0.00 0 0 0.03
gc cr multi block request 225 0.00 0 0 0.03
direct path write 52 0.00 0 0 0.01
gc current multi block request 12 0.00 0 0 0.00
gc current grant busy 2 0.00 0 1 0.00
latch: shared pool 4 0.00 0 0 0.00
log file single write 2 0.00 0 0 0.00
gc object scan 46 100.00 0 0 0.01
buffer busy waits 5 0.00 0 0 0.00
latch: cache buffers chains 9 0.00 0 0 0.00
latch: row cache objects 1 0.00 0 0 0.00
enq: TM - contention 12 0.00 -0 -3 0.00
rdbms ipc message 82,476 71.02 57,569 698 9.70
gcs remote message 1,024,059 98.39 9,810 10 120.39
class slave wait 73 23.29 3,546 48576 0.01
DIAG idle wait 17,849 0.00 3,518 197 2.10
ASM background timer 820 0.00 3,517 4289 0.10
ges remote message 71,143 91.52 3,517 49 8.36
pmon timer 1,934 100.00 3,517 1818 0.23
LNS ASYNC end of log 326,329 100.00 3,513 11 38.36
Streams AQ: qmn coordinator idle wait 264 52.27 3,503 13271 0.03
smon timer 591 0.00 3,494 5912 0.07
Streams AQ: waiting for time management or cleanup tasks 189 64.55 3,446 18233 0.02
SGA: MMAN sleep for component shrink 5,523 99.91 59 11 0.65
KSV master wait 49 0.00 0 5 0.01
PX Deq: Join ACK 30 40.00 0 0 0.00
PX Deq: Parse Reply 30 40.00 0 0 0.00
PX Deq: Execute Reply 24 25.00 0 0 0.00
Streams AQ: RAC qmn coordinator idle wait 265 100.00 0 0 0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 144,979
IDLE_TIME 4,175,958
IOWAIT_TIME 380,746
NICE_TIME 0
SYS_TIME 14,516
USER_TIME 124,544
LOAD 1
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 8,371,716,096
NUM_CPUS 12
NUM_CPU_SOCKETS 3

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
orcl.domain 12,254.30 1,190.10 474,933 165,834,609
SYS$USERS 48.00 5.40 0 34
SYS$BACKGROUND 0.00 0.00 4,092 120,053
orclXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
orcl.domain 449636 420944 10583 3059 0 0 2429390 478
SYS$USERS 3 1 37 1 0 0 3738 1
SYS$BACKGROUND 3307 1058 735 131 0 0 784 136

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 IdSQL ModuleSQL Text
383 12 17,297 0.02 3.12 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
350 2 766 0.46 2.85 02ty4b6sxjuwm ZLHIS+.exe Select Nvl(Sum(A.可用数量), 0)/Nv...
298 9 1,706 0.17 2.43 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
291 7 1 291.24 2.37 dtw1akmdumhdr ZLHIS+.exe SELECT E.编码, E.名称, A.采购金额, A.售...
282 3 5,547 0.05 2.29 bdr14zub67875 ZLHIS+.exe SELECT 内容 FROM 电子病历格式 WHERE 文件...
270 1 120 2.25 2.20 f0zj3p6vu1tqf ZLHIS+.exe Select 参数ID, Nvl(用户名, 'NullUs...
241 0 672 0.36 1.96 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
185 0 109 1.70 1.51 4t5vwwg5ky28b ZLHIS+.exe Select 站点 From zlClients Where...
184 2 1,211 0.15 1.50 f4fkjrchf97v7 ZLHIS+.exe Select 1 From 病人护理记录 A Where a...
160 10 34 4.70 1.30 g3f752jw1w1pc ZLHIS+.exe Select /*+ rule*/Rownum as Key...
149 44 341 0.44 1.21 3r7wxubrs37wn ZLHIS+.exe Select /*+ rule */ e.医嘱内容, ...
144 0 200 0.72 1.17 b564h8c70x81x ZLHIS+.exe Select NextNO(:V001, :V002, :V...
144 0 916 0.16 1.17 2bj72tnb5yx29 ZLHIS+.exe SELECT NVL(编号规则, 0) FROM 号码控制...
124 3 132 0.94 1.01 7ys86yy69t4h4 ZLHIS+.exe Select Nvl(Sum(实收金额), 0) As 划价...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
64 64 214 0.30 0.52 2rj53wykjv6un ZLHIS+.exe Select /*+ rule*/Rownum as Key...
59 59 190 0.31 0.48 b5gtjpxd3ktkp ZLHIS+.exe Select /*+ rule*/Rownum as Key...
46 46 85,112 0.00 0.37 8cjb6s69gx64k ZLHIS+.exe SELECT ZL_GET_REFERENCE(0, :B...
44 149 341 0.13 1.21 3r7wxubrs37wn ZLHIS+.exe Select /*+ rule */ e.医嘱内容, ...
42 43 2,143 0.02 0.35 47vyxbdrj6zy9 ZLHIS+.exe Select Text as 功能 From Table(C...
30 31 1 30.20 0.25 f3jpz99b2scw4 PL/SQL Developer select 编码, 设备名称, 单位, 订购时间, 登记时...
28 28 224 0.13 0.23 b05d9j9myusm2 ZLHIS+.exe Select /*+ rule */ Sum(Nvl(收...
17 17 1,234 0.01 0.14 29k7ndmsybj32 ZLHIS+.exe Select Sum(Decode(Nvl(A.是否变价,...
15 15 102 0.14 0.12 gvh0t43k0t9wh ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
13 104 15 0.84 0.85 0ppkwk8dnnb5w ZLHIS+.exe Call ZL1_AUTOCPTPATI(:V001, :V...
12 383 17,297 0.00 3.12 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
10 160 34 0.30 1.30 g3f752jw1w1pc ZLHIS+.exe Select /*+ rule*/Rownum as Key...
9 298 1,706 0.01 2.43 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
7 291 1 7.31 2.37 dtw1akmdumhdr ZLHIS+.exe SELECT E.编码, E.名称, A.采购金额, A.售...
3 282 5,547 0.00 2.29 bdr14zub67875 ZLHIS+.exe SELECT 内容 FROM 电子病历格式 WHERE 文件...
3 124 132 0.02 1.01 7ys86yy69t4h4 ZLHIS+.exe Select Nvl(Sum(实收金额), 0) As 划价...
2 350 766 0.00 2.85 02ty4b6sxjuwm ZLHIS+.exe Select Nvl(Sum(A.可用数量), 0)/Nv...
2 184 1,211 0.00 1.50 f4fkjrchf97v7 ZLHIS+.exe Select 1 From 病人护理记录 A Where a...
1 270 120 0.01 2.20 f0zj3p6vu1tqf ZLHIS+.exe Select 参数ID, Nvl(用户名, 'NullUs...
0 144 200 0.00 1.17 b564h8c70x81x ZLHIS+.exe Select NextNO(:V001, :V002, :V...
0 185 109 0.00 1.51 4t5vwwg5ky28b ZLHIS+.exe Select 站点 From zlClients Where...
0 241 672 0.00 1.96 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
0 144 916 0.00 1.17 2bj72tnb5yx29 ZLHIS+.exe SELECT NVL(编号规则, 0) FROM 号码控制...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Buffer Gets Executions Gets per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
23,672,743 214 110,620.29 14.26 63.60 63.66 2rj53wykjv6un ZLHIS+.exe Select /*+ rule*/Rownum as Key...
21,145,965 190 111,294.55 12.74 58.55 58.63 b5gtjpxd3ktkp ZLHIS+.exe Select /*+ rule*/Rownum as Key...
8,646,398 224 38,599.99 5.21 28.05 28.11 b05d9j9myusm2 ZLHIS+.exe Select /*+ rule */ Sum(Nvl(收...
4,021,470 102 39,426.18 2.42 14.55 14.60 gvh0t43k0t9wh ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
3,811,647 1,902 2,004.02 2.30 12.35 119.18 8crc55tpkcbs3 ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
3,569,450 36 99,151.39 2.15 9.71 9.73 f32d9pqhr4rxu ZLHIS+.exe Select /*+ rule*/Rownum as Key...
3,471,050 35 99,172.86 2.09 9.80 9.80 3d96syn8avp49 ZLHIS+.exe Select /*+ rule*/Rownum as Key...
3,455,338 34 101,627.59 2.08 10.29 159.65 g3f752jw1w1pc ZLHIS+.exe Select /*+ rule*/Rownum as Key...
3,259,113 32 101,847.28 1.96 9.35 9.38 aumbw9np1mnh0 ZLHIS+.exe Select /*+ rule*/Rownum as Key...
2,800,485 73 38,362.81 1.69 9.16 9.21 gav1bu4ngn5sd ZLHIS+.exe Select /*+ rule */ Sum(Nvl(收...
2,192,280 22 99,649.09 1.32 5.87 5.98 bdzkty8cx0x6p ZLHIS+.exe Select /*+ rule*/Rownum as Key...
1,870,928 341 5,486.59 1.13 43.95 149.11 3r7wxubrs37wn ZLHIS+.exe Select /*+ rule */ e.医嘱内容, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Physical ReadsExecutionsReads per Exec %TotalCPU Time (s)Elapsed Time (s) SQL IdSQL ModuleSQL Text
48,685 1 48,685.00 10.16 7.31 291.24 dtw1akmdumhdr ZLHIS+.exe SELECT E.编码, E.名称, A.采购金额, A.售...
25,065 132 189.89 5.23 2.54 124.13 7ys86yy69t4h4 ZLHIS+.exe Select Nvl(Sum(实收金额), 0) As 划价...
15,441 1,706 9.05 3.22 8.61 298.41 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
13,046 17,297 0.75 2.72 11.92 383.44 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
6,375 341 18.70 1.33 43.95 149.11 3r7wxubrs37wn ZLHIS+.exe Select /*+ rule */ e.医嘱内容, ...
2,888 7,967 0.36 0.60 1.56 92.11 ftj9uawt4wwzb   select condition from cdef$ wh...
2,455 1 2,455.00 0.51 30.20 30.61 f3jpz99b2scw4 PL/SQL Developer select 编码, 设备名称, 单位, 订购时间, 登记时...
1,954 2,529 0.77 0.41 1.50 12.44 ckgxr4xhw7tz5 ZLHIS+.exe Select ID, 文件id, 开始版, 终止版, 父...
1,385 240 5.77 0.29 0.48 97.24 gf01bfdmyaukq ZLHIS+.exe SELECT A.应收款总额 - NVL(SUM(金额), ...
1,332 1,043 1.28 0.28 1.11 98.23 1994hz7y6wqs1 ZLHIS+.exe Select 文件ID ID, 病历编号 || '-' ||...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Executions Rows ProcessedRows per ExecCPU per Exec (s)Elap per Exec (s) SQL IdSQL ModuleSQL Text
85,112 85,112 1.00 0.00 0.00 8cjb6s69gx64k ZLHIS+.exe SELECT ZL_GET_REFERENCE(0, :B...
17,297 17,296 1.00 0.00 0.02 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
16,952 16,952 1.00 0.00 0.00 c749bc43qqfz3 ZLHIS+.exe SELECT SYSDATE FROM DUAL
7,967 7,967 1.00 0.00 0.01 ftj9uawt4wwzb   select condition from cdef$ wh...
5,547 4,411 0.80 0.00 0.05 bdr14zub67875 ZLHIS+.exe SELECT 内容 FROM 电子病历格式 WHERE 文件...
5,531 5,531 1.00 0.00 0.00 a8rdu73vtbs66 ZLHIS+.exe Select 医院编码 From 保险类别 Where 序号...
5,456 5,456 1.00 0.00 0.02 fmn19m0fr5ps2 ZLHIS+.exe Select 电子病历内容_ID.Nextval From ...
5,349 181,866 34.00 0.00 0.00 9wqqut4ajt6hh ZLHIS+.exe select 参数名, 参数值 from 保险参数 wher...
5,343 5,343 1.00 0.00 0.00 bwayuumbpdr73 ZLHIS+.exe Select 医院编码 From 保险类别 Where 序号...
4,524 0 0.00 0.00 0.00 fuqd9gf3sbxsu ZLHIS+.exe Call ZL_电子病历内容_Update(:V001, :...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
17,297 17,297 4.00 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
16,154 16,952 3.74 c749bc43qqfz3 ZLHIS+.exe SELECT SYSDATE FROM DUAL
7,967 7,967 1.84 ftj9uawt4wwzb   select condition from cdef$ wh...
5,531 5,531 1.28 a8rdu73vtbs66 ZLHIS+.exe Select 医院编码 From 保险类别 Where 序号...
5,456 5,456 1.26 fmn19m0fr5ps2 ZLHIS+.exe Select 电子病历内容_ID.Nextval From ...
5,349 5,349 1.24 9wqqut4ajt6hh ZLHIS+.exe select 参数名, 参数值 from 保险参数 wher...
5,343 5,343 1.24 bwayuumbpdr73 ZLHIS+.exe Select 医院编码 From 保险类别 Where 序号...
4,524 4,524 1.05 fuqd9gf3sbxsu ZLHIS+.exe Call ZL_电子病历内容_Update(:V001, :...
3,879 3,879 0.90 g7pa9azppjarw ZLHIS+.exe Select 项目, 内容 From 病人医嘱附件 Wher...
3,820 3,820 0.88 6022mtczwqcw6 ZLHIS+.exe Select Distinct 0 as 发送号, B.操...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,496,128 1 0.06 attz3csb61tp5 ZLHIS+.exe SELECT ROWNUM AS 序号, 手术时间, 手术规...
1,069,418 162 0.04 0rsq39vp8d0qx ZLHIS+.exe SELECT /*+ Rule */ DISTINCT A....

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Cluster Wait Time (s)CWT % of Elapsd TimeElapsed Time(s)CPU Time(s)Executions SQL IdSQL ModuleSQL Text
268.36 99.32 270.21 0.89 120 f0zj3p6vu1tqf ZLHIS+.exe Select 参数ID, Nvl(用户名, 'NullUs...
257.45 73.54 350.06 2.44 766 02ty4b6sxjuwm ZLHIS+.exe Select Nvl(Sum(A.可用数量), 0)/Nv...
240.91 99.96 241.01 0.15 672 6ssrk2dqj7jbx   select job, nvl2(last_date, ...
209.09 70.07 298.41 8.61 1,706 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
185.15 99.91 185.31 0.21 109 4t5vwwg5ky28b ZLHIS+.exe Select 站点 From zlClients Where...
149.33 93.54 159.65 10.29 34 g3f752jw1w1pc ZLHIS+.exe Select /*+ rule*/Rownum as Key...
143.62 99.80 143.91 0.25 200 b564h8c70x81x ZLHIS+.exe Select NextNO(:V001, :V002, :V...
143.61 99.94 143.70 0.14 916 2bj72tnb5yx29 ZLHIS+.exe SELECT NVL(编号规则, 0) FROM 号码控制...
105.52 88.54 119.18 12.35 1,902 8crc55tpkcbs3 ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
105.49 91.71 115.02 9.42 234 9h8nnhxxbm3r8 ZLHIS+.exe Select /*+ rule */ Distinct A....
93.98 79.78 117.80 0.30 5,456 fmn19m0fr5ps2 ZLHIS+.exe Select 电子病历内容_ID.Nextval From ...
91.61 87.56 104.63 10.88 904 0dtg7gj9qq7r5 ZLHIS+.exe Select A.ID, A.相关ID, A.序号, A....
82.98 90.21 91.99 8.84 114 2pu6w6qb51a94 ZLHIS+.exe Call zl_医保调用日志_INSERT(:V001, :...
82.96 90.54 91.62 8.70 57 g37byx2zf1gjd ZLHIS+.exe UPDATE 医保调用日志 SET 返回信息=:B6 , 操...
78.76 99.41 79.22 0.35 3 0jsnzk398x22f ZLHIS+.exe SELECT /*+rule*/ Distinct A.*,...
69.32 46.49 149.11 43.95 341 3r7wxubrs37wn ZLHIS+.exe Select /*+ rule */ e.医嘱内容, ...
61.48 64.83 94.84 2.02 744 7chypkudb07cq ZLHIS+.exe Call ZL_病人医嘱记录_Insert(:V001, :...
61.39 99.80 61.52 0.15 45 fzphwsw5fzbnk ZLHIS+.exe Select /*+ Rule*/B.NO, B.病人ID...
58.02 67.07 86.52 0.52 221 1kb91yksqgp3m ZLHIS+.exe INSERT INTO 病人医嘱记录 (ID, 相关ID,...
6.67 2.29 291.24 7.31 1 dtw1akmdumhdr ZLHIS+.exe SELECT E.编码, E.名称, A.采购金额, A.售...
3.87 1.01 383.44 11.92 17,297 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
3.86 1.37 281.55 2.97 5,547 bdr14zub67875 ZLHIS+.exe SELECT 内容 FROM 电子病历格式 WHERE 文件...
1.21 0.98 124.13 2.54 132 7ys86yy69t4h4 ZLHIS+.exe Select Nvl(Sum(实收金额), 0) As 划价...
0.30 0.33 92.11 1.56 7,967 ftj9uawt4wwzb   select condition from cdef$ wh...
0.28 3.91 7.10 3.13 3,820 6022mtczwqcw6 ZLHIS+.exe Select Distinct 0 as 发送号, B.操...
0.25 0.25 100.11 4.15 678 356fpfrumt6yz ZLHIS+.exe Select Zl_In_Epr_Allowed(:V001...
0.20 1.64 12.44 1.50 2,529 ckgxr4xhw7tz5 ZLHIS+.exe Select ID, 文件id, 开始版, 终止版, 父...
0.18 3.13 5.76 3.51 239 1j83wbw9nwaxm ZLHIS+.exe Select /*+ RULE */ A.ID, A.相关I...
0.17 3.37 5.12 1.96 1,957 0nzt1m3rp322n ZLHIS+.exe Select 记录来源, 诊断类型, 诊断次序, 诊断描述,...
0.17 4.02 4.22 1.03 374 d235wddmn4md7 ZLHIS+.exe Select /*+ RULE */ A.发送序号, A.费...
0.16 0.16 104.37 12.62 15 0ppkwk8dnnb5w ZLHIS+.exe Call ZL1_AUTOCPTPATI(:V001, :V...
0.16 0.16 98.23 1.11 1,043 1994hz7y6wqs1 ZLHIS+.exe Select 文件ID ID, 病历编号 || '-' ||...
0.16 19.74 0.80 0.67 2,082 63c3fzg565g2s ZLHIS+.exe Select Sum(费用余额) as 费用余额, Sum(...
0.15 5.63 2.74 1.46 11 7vq0fm83fwszz ZLHIS+.exe Select B.NO, B.病人ID, B.门诊号, B...
0.15 2.74 5.31 0.63 260 7cy782quuav69 ZLHIS+.exe Select r.科室id 病人科室, Decode(b....
0.14 0.15 97.24 0.48 240 gf01bfdmyaukq ZLHIS+.exe SELECT A.应收款总额 - NVL(SUM(金额), ...
0.14 0.15 96.65 3.31 1,568 cqgv56fmuj63x   select owner#, name, namespace...
0.13 5.41 2.35 1.26 1,889 70wznctgyy8ms ZLHIS+.exe Select a.姓名, a.性别, a.年龄, b....
0.10 3.99 2.47 1.78 3,402 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0.06 3.79 1.50 0.66 534 38q7zs730wthg ZLHIS+.exe INSERT INTO 医嘱执行时间 (要求时间, 医嘱I...
0.06 0.03 184.44 1.57 1,211 f4fkjrchf97v7 ZLHIS+.exe Select 1 From 病人护理记录 A Where a...
0.05 7.27 0.68 0.68 3,819 92m3u2m664cas ZLHIS+.exe Select Distinct D.编号, D.名称, D....
0.05 3.51 1.39 0.63 264 8ah49yca3ntc7 ZLHIS+.exe Select /*+ RULE */ A.发送序号, A.费...
0.05 0.15 30.61 30.20 1 f3jpz99b2scw4 PL/SQL Developer select 编码, 设备名称, 单位, 订购时间, 登记时...
0.04 4.04 1.03 0.84 175 dqfw3npn8zcpx ZLHIS+.exe SELECT F.ID, F.唯一, R.次数, L....
0.04 0.09 43.11 42.14 2,143 47vyxbdrj6zy9 ZLHIS+.exe Select Text as 功能 From Table(C...
0.03 1.79 1.94 1.13 3,879 g7pa9azppjarw ZLHIS+.exe Select 项目, 内容 From 病人医嘱附件 Wher...
0.03 5.03 0.52 0.30 162 0rsq39vp8d0qx ZLHIS+.exe SELECT /*+ Rule */ DISTINCT A....
0.02 4.87 0.37 0.29 7 7q1cvfsy1n2wr ZLHIS+.exe SELECT Substr(Lpad(编号, 5, '0...
0.01 0.15 9.38 9.35 32 aumbw9np1mnh0 ZLHIS+.exe Select /*+ rule*/Rownum as Key...
0.01 0.05 28.11 28.05 224 b05d9j9myusm2 ZLHIS+.exe Select /*+ rule */ Sum(Nvl(收...
0.01 1.84 0.66 0.66 2,342 6qv07bhbah63m ZLHIS+.exe Select Zl_Replace_Element_Valu...
0.01 2.51 0.42 0.20 440 aj1mmfscyf8f0 ZLHIS+.exe Select Distinct B.发生时间 as 挂号时间...
0.01 0.47 1.95 1.91 58 20sfymk1vsq3f operinfo.exe select ROOMNO, ROOM, pname, de...
0.01 4.85 0.18 0.18 2,540 c7rtz3p9fw3bt ZLHIS+.exe Select Decode(归档人, Null, 1, ...
0.01 0.55 1.61 1.54 2,667 50vbxcwxa0npj ZLHIS+.exe Select Zl_Actualmoney(:V001, :...
0.01 0.31 2.80 2.71 20 8y924qm1xnbxz ZLHIS+.exe Select RowNum As ID, 1 As 末级, ...
0.01 1.51 0.55 0.53 3,342 5njyb40wpta5r ZLHIS+.exe Select 内容 From zlRegInfo Where...
0.01 10.76 0.05 0.03 28 9hy4hcdj67cvv ZLHIS+.exe UPDATE 病人信息 SET 门诊号 = :B42 , ...
0.01 0.01 58.63 58.55 190 b5gtjpxd3ktkp ZLHIS+.exe Select /*+ rule*/Rownum as Key...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
02ty4b6sxjuwm Select Nvl(Sum(A.可用数量), 0)/Nvl(B.住院包装, 1) as 库存 From 药品库存 A, 药品规格 B Where A.药品ID=B.药品ID(+) And A.性质=1 And (Nvl(A.批次, 0)=0 Or A.效期 is NULL Or A.效期>Trunc(Sysdate)) And A.药品ID=:V001 And Instr(:V002, ', ' || a.库房id || ', ')>0 Group by Nvl(B.住院包装, 1), A.库房ID
04xtrk7uyhknhselect obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0dtg7gj9qq7r5 Select A.ID, A.相关ID, A.序号, A.诊疗类别, A.诊疗项目ID, A.标本部位, A.检查方法, A.执行标记, Nvl(B.费用性质, 0) as 费用性质, Nvl(B.收费方式, 0) as 收费方式, B.收费细目ID, 1 as 住院包装, C.计算单位, B.数量, Decode(C.是否变价, 1, B.单价, Sum(D.现价)) as 单价, Nvl(B.执行科室ID, A.执行科室ID) as 执行科室ID, Nvl(B.从项, 0) as 从项, C.类别 as 收费类别 From 病人医嘱记录 A, 病人医嘱计价 B, 收费项目目录 C, 收费价目 D Where A.诊疗类别 Not IN('4', '5', '6', '7') And A.ID=B.医嘱ID And Nvl(A.计价特性, 0)=0 And Nvl(A.执行性质, 0) Not IN(0, 5) And B.收费细目ID=C.ID And B.收费细目ID=D.收费细目ID And ((Sysdate Between D.执行日期 and D.终止日期) or (Sysdate>=D.执行日期 And D.终止日期 is NULL)) And (A.ID=:V001 Or A.相关ID=:V002) Group by A.ID, A.相关ID, A.序号, A.诊疗类别, A.诊疗项目ID, A.标本部位, A.检查方法, A.执行标记, Nvl(B.费用性质, 0), Nvl(B.收费方式, 0), B.收费细目ID, C.类别, C.计算单位, B.数量, C.是否变价, B.单价, Nvl(B.执行科室ID, A.执行科室ID), Nvl(B.从项, 0) Order by 序号, 费用性质, 从项, 收费类别
0jsnzk398x22f SELECT /*+rule*/ Distinct A.*, Nvl(C.留存数量, 0) As 留存数量 , '' As 退药人 FROM (SELECT DISTINCT S.ID As 收发ID, to_char(S.效期, 'YYYY-MM-dd') 效期, S.记录状态, S.药品ID, S.费用id, NVL(N.已收费, 0) 已收费, P.名称 科室, S.配药人, C.开单人 开单医生, C.操作员姓名 审核人, S.单据, S.扣率, S.NO, S.序号, C.病人ID, Nvl(C.主页ID, 0) As 主页ID, Nvl(C.床号, '(未安排)') As 床号, C.姓名, C.性别, C.门诊标志, C.标识号, C.操作员姓名, S.付数 付, S.实际数量 数量, NVL(D.药房分批, 0) 分批, Nvl(D.高危药品, 0) As 高危药品, X.规格, T.毒理分类, T.价值分类, Nvl(T.抗生素, 0) 抗生素, C.登记时间, H.编码 As 领药部门编码, H.名称 As 领药部门, H.Id As 领药部门Id, S.零售价 单价, S.零售金额 金额, S.单量, S.频次, S.用法, S.摘要 说明, DECODE(S.批号, NULL, '', S.批号)||DECODE(S.批次, NULL, '', 0, '', '('||S.批次||')') 批号, NVL(S.批次, 0) 批次, Ceil((s.实际数量 * d.剂量系数) / Nvl(s.单量, 1)) As 发送数次, C.医嘱序号, I.计算单位, NVL(S.产地, NVL(X.产地, '')) 产地, nvl(M.审查结果, -1) 审查结果, M.皮试结果, decode(m.用药目的, 1, '预防', 2, '治疗', 3, '预防和治疗', '') 用药目的, m.用药理由, D.药名ID, nvl(C.医嘱序号, -1) 医嘱id, L.库房货位, M.相关ID, C.病人科室ID As 科室ID, C.序号 费用序号, Decode(Sign(Nvl(K.库存数量, 0) - Nvl(L.下限, 0)), -1, 0, 1) 库存下限, Z.名称 As 英文名, R.年龄, N.领药号, NVL(E.名称, '') As 其它名, '['||X.编码||']'||X.名称 As 品名, X.编码 As 药品编码, X.名称 As 药品名称, s.入出类别id, s.入出系数, s.填制人, s.填制日期, s.配药日期 , X.计算单位 单位, 1 包装 , 0 As 库存数量 F ROM 药品收发记录 S, 住院费用记录 C, 病人医嘱记录 M, 未发药品记录 N, 收费项目别名 E, 收费项目目录 X, 诊疗项目目录 I, 药品规格 D, 药品特性 T, 药品储备限额 L, 诊疗项目别名 Z, 部门表 P, 部门表 H, 病人信息 R , Table(Cast(f_Num2List(:V001) As zlTools.t_NumList)) G , (Select 库房id, 药品id, Nvl(Sum(实际数量), 0) 库存数量 From 药品库存 Where 性质 = 1 And 库房id = :V002 Group By 库房id, 药品id) K WHERE S.NO=N.NO AND S.单据=N.单据 AND NVL(S.库房I D, :V003)+0=NVL(N.库房ID, :V004) AND S.费用ID=C.ID And S.药品ID=D.药品ID AND S.对方部门ID+0=H.ID AND S.审核人 IS NULL AND NVL(S.库房ID, :V005)+0=:V006 AND C.病人科室ID=P.id And d.药品ID=X.ID and D.药名ID=T.药名ID AND D.药名ID=I.ID and C.医嘱序号=M.ID(+) And D.药名id = Z.诊疗项目id(+) And Z.性质(+) = 2 And S.药品ID=L.药品ID(+) And Nvl(S.库房ID, :V007)=L.库房ID(+) AND D.药品ID=E.收费细目ID(+) AND E.性质(+)=3 And nvl(S.发药方式, -999)<>-1 And N.病人id = R.病人id And S.单据 In(9, 10) And N.填制日期 Between :V008 And :V009 And S.ID= G.Column_Value And Nvl(S.库房id, :V010) + 0 = K.库房id(+) And S.药品id = K.药品id(+) And S.扣率 Is Not Null And (Ltrim(To_Char(Nvl(S.扣率, 0), '00')) Like '0_' Or Ltrim(To_Char(Nvl(S.扣率, 0), '00')) Like '1_') And Nvl(C.医嘱序号, 0) + 0 > 0 Union All SELECT DISTINCT S.ID As 收发ID, to_char(S.效期, 'YYYY-MM-dd') 效期, S.记录状态, S.药品ID, S.费用id, NVL(N.已收费, 0) 已收费, P.名称 科室, S.配药人, C.开单人 开单医生, C.操作员姓名 审核人, S.单据, S.扣率, S.NO, S.序号, C.病人ID, Nvl(C.主页ID, 0) As 主页ID, Nvl(C.床号, '(未安排)') As 床号, C.姓名, C.性别, C.门诊标志, C.标识号, C.操作员姓名, S.付数 付, S.实际数量 数量, NVL(D.药房分批, 0) 分批, Nvl(D.高危药品, 0) As 高危药品, X.规格, T.毒理分类, T.价值分类, Nvl(T.抗生素, 0) 抗生素, C.登记时间, H.编码 As 领药部门编码, H.名称 As 领药部门, H.Id As 领药部门Id, S.零售价 单价, S.零售金额 金额, S.单量, S.频次, S.用法, S.摘要 说明, DECODE(S.批号, NULL, '', S.批号)||DECODE(S.批次, NULL, '', 0, '', '('||S.批次||')') 批号, NVL(S.批次, 0) 批次, Ceil((s.实际数量 * d.剂量系数) / Nvl(s.单量, 1)) As 发送数次, C.医嘱序号, I.计算单位, NVL(S.产地, NVL(X.产地, '')) 产地, nvl(M.审查结果, -1) 审查结果, M.皮试结果, decode(m.用药目的, 1, '预防', 2, '治疗', 3, '预防和治疗', '') 用药目的, m.用药理由, D.药名ID, nvl(C.医嘱序号, -1) 医嘱id, L.库房货位, M.相关ID, C.病人科室ID As 科室ID, C.序号 费用序号, Decode(Sign(Nvl(K.库存数量, 0) - Nvl(L.下限, 0)), -1, 0, 1) 库存下限, Z.名称 As 英文名, R.年龄, N.领药号, NVL(E.名称, '') As 其它名, '['||X.编码||']'||X.名称 As 品名, X.编码 As 药品编码, X.名称 As 药品名称, s.入出类别id, s.入出系数, s.填制人, s.填制日期, s.配药日期 , X.计算单位 单位, 1 包装 , 0 As 库存数量 FROM 药品收发记录 S, 住院费用记录 C, 病人医嘱记录 M, (Select A.单据, A.NO, A.病人id, A.主页id, A.姓名, Nvl(B.优先级, 0) 优先级, A.对方部门id, A.库房id, A.发药窗口, A.填制日期, A.已收费, Null As 配药人, 0 As 打印状态, 0 As 未发数, A.产品合格证 As 领药号 From (Select B.单据, B.NO, A.病人id, Nvl(A.主页ID, 0) As 主页ID, A.姓名, Decode(A.记录状态, 0, 0, 1) 已收费, B.对方部门id, B.库房id, B.发药窗口 , B.填制日期, C.身份, B.产品合格证 From 住院费用记录 A, 药品收发记录 B, 病人信息 C Where A.ID = B.费用id + 0 And B.审核日期 Is Null And B.摘要 = '拒发' And Nvl(B.库房id, :V011) = :V012 And B.填制日期 Between :V013 And :V014 And A.病人id = C.病人id(+)) A, 身份 B Where B.名称(+) = A.身份) N, 收费项目别名 E, 收费项目目录 X, 诊疗项目目录 I, 药品规格 D, 药品特性 T, 药品储备限额 L, 诊疗项目别名 Z, 部门表 P, 部门表 H, 病人信息 R , Table(Cast(f_Num2List(:V015) As zlTools.t_NumList)) G , (Select 库房id, 药品id, Nvl(Sum(实际数量), 0) 库存数量 From 药品库存 Where 性质 = 1 And 库房id = :V016 Group By 库房id, 药品id) K WHERE S.NO=N.NO AND S.单据=N.单据 AND NVL(S.库房I D, :V017)+0=NVL(N.库房ID, :V018) AND S.费用ID=C.ID And S.药品ID=D.药品ID AND S.对方部门ID+0=H.ID AND S.审核人 IS NULL AND NVL(S.库房ID, :V019)+0=:V020 AND C.病人科室ID=P.id And d.药品ID=X.ID and D.药名ID=T.药名ID AND D.药名ID=I.ID and C.医嘱序号=M.ID(+) And D.药名id = Z.诊疗项目id(+) And Z.性质(+) = 2 And S.药品ID=L.药品ID(+) And Nvl(S.库房ID, :V021)=L.库房ID(+) AND D.药品ID=E.收费细目ID(+) AND E.性质(+)=3 And nvl(S.发药方式, -999)<>-1 And N.病人id = R.病人id And S.单据 In(9, 10) And N.填制日期 Between :V022 And :V023 And S.ID= G.Column_Value And Nvl(S.库房id, :V024) + 0 = K.库房id(+) And S.药品id = K.药品id(+) And S.扣率 Is Not Null And (Ltrim(To_Char(Nvl(S.扣率, 0), '00')) Like '0_' Or Ltrim(To_Char(Nvl(S.扣率, 0), '00')) Like '1_') And Nvl(C.医嘱序号, 0) + 0 > 0 ) A , (Select 药品id, 库房id, 部门id, 留存数量 From 药品留存计划 Where 状态=0) C Where A.领药部门id = C.部门id(+) And C.库房id(+) = :V025 And A.药品id = C.药品id(+) And Not Exists (Select 1 From 病人费用销帐 X Where X.申请类别 = 0 And X.状态 = 0 And X.收费细目id = A.药品id And X.费用id = A.费用id) Order By a.科室, a.No, a.费用序号
0nzt1m3rp322nSelect 记录来源, 诊断类型, 诊断次序, 诊断描述, 是否疑诊, Mod(诊断类型, 10) as 大类 From 病人诊断记录 Where 病人ID=:V001 And 主页ID=:V002 And 诊断类型 IN(1, 2, 3, 11, 12, 13) Order by 记录来源, 诊断类型, 诊断次序
0ppkwk8dnnb5wCall ZL1_AUTOCPTPATI(:V001, :V002)
0rsq39vp8d0qx SELECT /*+ Rule */ DISTINCT A.记录性质, A.NO, A.序号, A.医嘱序号, A.门诊标志 FROM 住院费用记录 A, 病人医嘱发送 B, (SELECT ID FROM 病人医嘱记录 WHERE ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST))) UNION ALL SELECT ID FROM 病人医嘱记录 WHERE 相关ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST)))) C WHERE A.收费类别 NOT IN ('5', '6', '7') AND A.医嘱序号 = C.ID AND A.记录状态 = 0 AND 价格父号 IS NULL AND A.医嘱序号 = B.医嘱ID AND A.记录性质 = B.记录性质 AND A.NO = B.NO AND A.记帐费用 = 1 UNION ALL SELECT /*+ Rule */ DISTINCT A.记录性质, A.NO, A.序号, A.医嘱序号, A.门诊标志 FROM 住院费用记录 A, 病人医嘱附费 B, (SELECT ID FROM 病人医嘱记录 WHERE ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST))) UNION ALL SELECT ID FROM 病人医嘱记录 WHERE 相关ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST)))) C WHERE A.收费类别 NOT IN ('5', '6', '7') AND A.医嘱序号 = C.ID AND A.记录状态 = 0 AND 价格父号 IS NULL AND A.医嘱序号 = B.医嘱ID AND A.记录性质 = B.记录性质 AND A.NO = B.NO AND A.记帐费用 = 1 UNION ALL SELECT /*+ Rule */ DISTINCT A.记录性质, A.NO, A.序号, A.医嘱序号, A.门诊标志 FROM 门诊费用记录 A, 病人医嘱发送 B, (SELECT ID FROM 病人医嘱记录 WHERE ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST))) UNION ALL SELECT ID FROM 病人医嘱记录 WHERE 相关ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST)))) C WHERE A.收费类别 NOT IN ('5', '6', '7') AND A.医嘱序号 = C.ID AND A.记录状态 = 0 AND 价格父号 IS NULL AND A.医嘱序号 = B.医嘱ID AND A.记录性质 = B.记录性质 AND A.NO = B.NO AND A.记帐费用 = 1 UNION ALL SELECT /*+ Rule */ DISTINCT A.记录性质, A.NO, A.序号, A.医嘱序号, A.门诊标志 FROM 门诊费用记录 A, 病人医嘱附费 B, (SELECT ID FROM 病人医嘱记录 WHERE ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST))) UNION ALL SELECT ID FROM 病人医嘱记录 WHERE 相关ID IN (SELECT * FROM TABLE(CAST(F_NUM2LIST(:B1 ) AS ZLTOOLS.T_NUMLIST)))) C WHERE A.收费类别 NOT IN ('5', '6', '7') AND A.医嘱序号 = C.ID AND A.记录状态 = 0 AND 价格父号 IS NULL AND A.医嘱序号 = B.医嘱ID AND A.记录性质 = B.记录性质 AND A.NO = B.NO AND A.记帐费用 = 1 ORDER BY 记录性质, NO, 序号
1994hz7y6wqs1Select 文件ID ID, 病历编号 || '-' || 病历名称 病历名称, 到期时间, Decode(必须, 1, '是', '否') 必写 From 电子病历时机 Where 病人id = :V001 And 主页id = :V002 And 科室id =:V003 and 病历种类 in (2, 5, 6) And 病人来源 = 2 And (Nvl(完成记录id, 0) = 0 And 完成时间 Is Null) Order By 到期时间
1j83wbw9nwaxm Select /*+ RULE */ A.ID, A.相关ID, A.序号, Nvl(A.婴儿, 0) as 婴儿ID, A.医嘱状态, Nvl(A.诊疗类别, '*') as 诊疗类别, B.操作类型, C.毒理分类, A.紧急标志 as 标志, A.审查结果, Decode(Nvl(A.医嘱期效, 0), 0, '长嘱', '临嘱') as 期效, To_Char(A.开始执行时间, 'YYYY-MM-DD HH24:MI') as 开始时间, A.医嘱内容, Null as 内容, A.皮试结果 as 皮试, Decode(A.总给予量, NULL, NULL, Decode(A.诊疗类别, 'E', Decode(B.操作类型, '4', A.总给予量||'付', A.总给予量||B.计算单位), '4', A.总给予量||G.计算单位, '5', Round(A.总给予量/D.住院包装, 5)||D.住院单位, '6', Round(A.总给予量/D.住院包装, 5)||D.住院单位, A.总给予量||B.计算单位)) as 总量, Decode(A.首次用量, Null, '', A.首次用量 || Decode(A.诊疗类别, '4', G.计算单位, B.计算单位) || ':') || Decode(A.单次用量, NULL, NULL, decode(sign(1-A.单次用量), 1, '0'||A.单次用量, A.单次用量)||Decode(A.诊疗类别, '4', G.计算单位, B.计算单位)) as 单量, A.天数, A.执行频次 as 频率, Decode(A.诊疗类别, 'E', Decode(Instr('2468', Nvl(B.操作类型, '0')), 0, NULL, B.名称), NULL) as 用法, A.医生嘱托, A.执行时间方案 as 执行时间, To_Char(A.执行终止时间, 'YYYY-MM-DD HH24:MI') as 终止时间, Nvl(E.名称, Decode(Nvl(A.执行性质, 0), 0, '<叮嘱>', 5, '<院外执行>')) as 执行科室, Decode(Instr('567E', Nvl(A.诊疗类别, '*')), 0, NULL, A.执行性质) as 执行性质, To_Char(A.上次执行时间, 'YYYY-MM-DD HH24:MI') as 上次执行, Decode(A.医嘱状态, 1, '新开', 2, '疑问', 3, '校对', 4, '作废', 5, '重整', 6, '暂停', 7, '启用', 8, '停止', 9, '确认停止') as 状态, A.开嘱医生, To_Char(A.开嘱时间 , 'YYYY-MM-DD HH24:MI') as 开嘱时间, A.校对护士, To_Char(A.校对时间, 'YYYY-MM-DD HH24:MI') as 校对时间, A.停嘱医生, To_Char(A.停嘱时间, 'YYYY-MM-DD HH24:MI') as 停嘱时间, F.操作人员 as 停嘱护士, To_Char(A.确认停嘱时间, 'YYYY-MM-DD HH24:MI') as 确认停嘱时间, A.诊疗项目ID, B.试管编码, A.执行标记, A.屏蔽打印, A.前提ID, Decode(S.签名ID, NULL, 0, 1) as 签名否, M.病历文件ID as 文 件ID, Nvl(N.通用, 0) as 报告项, Y.病历ID as 报告ID, Y.查阅状态, A.收费细目ID, B.计算单位 as 单量单位, A.开嘱科室ID, A.审核状态, A.申请序号, (Select To_Char(Max(P.打印时间), 'YYYY-MM-DD HH24:MI')From 病人医嘱打印 P Where a.Id = p.医嘱id And p.打印标记 = 0) As 打印时间, A.审核标记, Decode(D.基本药物, null, 0, 1) as 基本药物, d.高危药品 From 病人医嘱记录 A, 部门表 E, 药品特性 C, 药品规格 D, 诊疗项目目录 B, 收费项目目录 G, 病人医嘱状态 F, 病人医嘱状态 S, 病人医嘱报告 Y, 病历单据应用 M, 病历文件列表 N Where A.诊疗项目ID=B.ID(+) And A.执行科室ID=E.ID(+) And A.诊疗项目ID=C.药名ID(+) And A.收费细目ID=D.药品ID(+) And A.收费细目ID=G.ID(+) And A.ID=Y.医嘱ID(+) And (Not(A.诊疗类别 IN ('F', 'G', 'D', 'E') And A.相关ID is Not NULL) Or A.诊疗类别='E' And B.操作类型='8') And A.ID=F.医嘱ID(+) And F.操作类型(+)=9 And A.ID=S.医嘱ID And S.操作类型=1 And A.诊疗项目ID=M.诊疗项目ID(+) And M.应用场合(+)=2 And M.病历文件ID=N.ID(+) And N.种类(+)=7 And A.病人ID=:V001 And A.主页ID=:V002 And A.开始执行时间 is Not NULL And Nvl(A.医嘱状态, 0)<>-1 And A.病人来源<>3 Order by 婴儿ID, 序号
1kb91yksqgp3mINSERT INTO 病人医嘱记录 (ID, 相关ID, 序号, 病人来源, 病人ID, 主页ID, 姓名, 性别, 年龄, 婴儿, 医嘱状态, 医嘱期效, 诊疗类别, 诊疗项目ID, 收费细目ID, 天数, 单次用量, 总给予量, 医嘱内容, 医生嘱托, 标本部位, 检查方法, 执行标记, 执行频次, 频率次数, 频率间隔, 间隔单位, 执行时间方案, 计价特性, 执行科室ID, 执行性质, 紧急标志, 可否分零, 开始执行时间, 执行终止时间, 病人科室ID, 开嘱科室ID, 开嘱医生, 开嘱时间, 挂号单, 前提ID, 摘要, 零费记帐, 手术时间, 用药目的, 用药理由, 审核状态, 申请序号, 超量说明, 首次用量, 配方ID, 手术情况, 组合项目ID) VALUES (:B52 , :B51 , :B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43 , :B42 , :B41 , :B11 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B10 , :B33 , :B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 , :B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , DECODE(:B11 , 'F', TO_DATE(:B10 , 'yyyy-mm-dd hh24:mi:ss'), NULL), :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 )
20sfymk1vsq3fselect ROOMNO, ROOM, pname, deptname, bedno, opername, SCALE, DIAG, operdate, SEQUENCE, SURGEON, FIRSTASS, SECONDASS, THIRDASS, FOURTHASS, ANEMETHOD, ANEDOCTOR, BLOODDOCTOR, FIRSTNURSE, SECONDNURSE from operinfo where operdate >= to_date(to_char(sysdate, 'yyyymmdd'), 'yyyymmdd') and operdate < to_date(to_char(sysdate + 1, 'yyyymmdd'), 'yyyymmdd') order by operdate, roomno, sequence
29k7ndmsybj32 Select Sum(Decode(Nvl(A.是否变价, 0), 1, Decode(:V001, 0, B.缺省价格, :V002), B.现价)) as 金额 From 收费项目目录 A, 收费价目 B Where A.ID=B.收费细目ID And A.ID=:V003 And ((Sysdate Between B.执行日期 and B.终止日期) or (Sysdate>=B.执行日期 And B.终止日期 is NULL))
2bj72tnb5yx29SELECT NVL(编号规则, 0) FROM 号码控制表 WHERE 项目序号 = :B1
2pu6w6qb51a94Call zl_医保调用日志_INSERT(:V001, :V002, :V003, :V004, :V005, :V006, :V007, :V008, :V009, :V010, :V011, :V012, :V013)
2rj53wykjv6un Select /*+ rule*/Rownum as KeyID, A.* From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.住院包装||'/'||C.住院单位) as 价格, Null as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3)) And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V009) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date( '3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V010, 3) Or :V011=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V012) Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V013 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V014, ', '||科室ID||', ')>0) Or Not Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V015, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V016) And (A.编码 Like :V017 Or B.名称 Like :V018 Or B.简码 Like :V019) And B.码类=:V020 And (A.撤档时间=To_D ate('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V021, 3) Or :V022=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Null as 基本, A.编码, A.名 称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V023, 3) Or :V024=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V025 Or B.名称 Like :V026 Or B.简码 Like :V027) And B.码类=:V028 And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V029) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V030, 3) Or :V031=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行 频率, 0) IN(0, :V032)) A Order by Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
356fpfrumt6yzSelect Zl_In_Epr_Allowed(:V001, :V002, :V003) IDS From Dual
38q7zs730wthgINSERT INTO 医嘱执行时间 (要求时间, 医嘱ID, 发送号) SELECT TO_DATE(COLUMN_VALUE, 'yyyy-mm-dd hh24:mi:ss'), :B3 , :B2 FROM TABLE(F_STR2LIST(:B1 ))
3d96syn8avp49 Select /*+ rule*/Rownum as KeyID, A.* From (Select A.*, R.频度 as 频度ID From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.住院包装||'/'||C.住院单位) as 价格, Null as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, Null as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3))) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名 称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V009, 3) Or :V010=3 And Nvl(E.服务对象 , 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V011) Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V012 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V013, ', '||科室ID||', ')>0) Or Not Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V014, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V015) And (A.编码 Like :V016 Or B.名称 Like :V017 Or B.简码 Like :V018) And B.码类=:V019 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V020, 3) Or :V021=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Null as 基本, A.编码, A.名称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, Null as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V022, 3) Or :V023=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V024 Or B.名称 Like :V025 Or B.简码 Like :V026) And B.码类=:V027) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V028, 3) Or :V029=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V030)) A, 诊疗个人项目 R Where R.诊疗项目ID=A.诊疗项目ID And (A.收费细目ID is Null Or A.收费细目ID = R.收费细目ID) And R.人员ID=:V031) A Order by 频度ID Desc, Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
3r7wxubrs37wnSelect /*+ rule */ e.医嘱内容, c.中文名 As 检验项目, d.缩写, b.检验结果, d.单位, Decode(b.结果标志, 3, '↑', 2, '↓', 1, '', 4, '异常', 5, '↓↓', 6, '↑↑', '') As 标志, Trim(Replace(Replace(' ' || Zlgetreference(b.检验项目id, a.标本类型, Decode(a.性别, '男', 1, '女', 2, 0), a.出生日期, a.仪器id, a.年龄), ' .', '0.'), '~.', '~0.')) As 参考, Decode(a.病人来源, 1, '门诊', 2, '住院', 4, '体检', '其它') 病人来源, a.审核时间 From 检验标本记录 A, 检验普通结果 B, 诊治所见项目 C, 检验项目 D, 检验项目分布 F, 病人医嘱记录 E Where a.病人id = :V001 And a.审核人 Is Not Null And a.Id = b.检验标本id And b.检验项目id = c.Id And c.Id = d.诊治项目id And b.记录类型 = a.报告结果 And a.Id = f.标本id And f.项目id = d.诊治项目id And f.医嘱id = e.Id Order By a.审核时间 Desc, e.医嘱内容, b.排列序号, c.中文名
47vyxbdrj6zy9Select Text as 功能 From Table(Cast(zltools.f_Reg_Func(:V001, :V002) as zlTools.t_Reg_Rowset))
4t5vwwg5ky28bSelect 站点 From zlClients Where upper(工作站)=upper(SYS_CONTEXT('USERENV', 'TERMINAL'))
50vbxcwxa0npjSelect Zl_Actualmoney(:V001, :V002, :V003, :V004, :V005, :V006) as Actualmoney From Dual
5njyb40wpta5rSelect 内容 From zlRegInfo Where 项目='客户端升级日期'
6022mtczwqcw6 Select Distinct 0 as 发送号, B.操作人员 as 人员, B.操作时间 as 时间, B.操作类型, Decode(B.操作类型, 4, '作废医嘱', 5, '重整医嘱', 6, '暂停医嘱', 7, '启用医嘱', 8, '停止医嘱', 9, '确认停止', 10, '皮试结果', 13, '停嘱申请') as 内容 From 病人医嘱记录 A, 病人医嘱状态 B Where A.ID=B.医嘱ID And (A.ID=:V001 Or A.相关ID=:V002) And (Nvl(A.医嘱期效, 0)=0 And B.操作类型 Not IN(1, 2, 3) Or Nvl(A.医嘱期效, 0)=1 And B.操作类型 Not IN(1, 2, 3, 8)) Union ALL Select Distinct B.发送号, B.发送人 as 人员, B.发送时间 as 时间, 0 as 操作类型, '发送医嘱' as 内容 From 病人医嘱记录 A, 病人医嘱发送 B Where A.ID=B.医嘱ID And (A.ID=:V003 Or A.相关ID=:V004) Order by 时间 Desc, 发送号
63c3fzg565g2sSelect Sum(费用余额) as 费用余额, Sum(预交余额) as 预交余额, Sum(预结费用) as 预结费用 From ( Select 费用余额, 预交余额, 0 as 预结费用 From 病人余额 Where 性质=1 And 病人ID=:V001 And 类型 = 2 Union ALL Select 0, 0, Sum(金额) From 保险模拟结算 A, 病案主页 B Where A.病人ID=B.病人ID And A.主页ID=B.主页ID And B.险类 Is Not Null And A.病人ID=:V002 And A.主页ID=:V003)
6qv07bhbah63mSelect Zl_Replace_Element_Value(:V001, :V002, :V003, :V004, :V005) From Dual
6ssrk2dqj7jbxselect job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
70wznctgyy8msSelect a.姓名, a.性别, a.年龄, b.住院号, b.出院病床, b.医疗付款方式, d.信息值 As 医保号, b.险类, b.当前病况, c.名称 As 护理等级, b.入院日期, b.出院日期, b.编目日期, b.病人类型, b.状态, b.数据转出, b.出院科室id, b.当前病区id, a.住院次数, e.房间号 From 病人信息 A, 病案主页 B, 收费项目目录 C, 病案主页从表 D, 床位状况记录 E Where a.病人id = b.病人id And a.病人id = :V001 And b.主页id = :V002 And b.护理等级id = c.Id(+) And b.病人id = d.病人id(+) And b.主页id = d.主页id(+) And d.信息名(+) = '医保号' And b.出院科室id = e.科室id(+) And b.病人id = e.病人id(+) And b.出院病床 = e.床号(+)
7chypkudb07cqCall ZL_病人医嘱记录_Insert(:V001, :V002, :V003, :V004, :V005, :V006, :V007, :V008, :V009, :V010, :V011, :V012, :V013, :V014, :V015, :V016, :V017, :V018, :V019, :V020, :V021, :V022, :V023, :V024, :V025, :V026, :V027, :V028, :V029, :V030, :V031, :V032, :V033, :V034, :V035, :V036, :V037, :V038, :V039, :V040, :V041, :V042, :V043, :V044, :V045, :V046, :V047, :V048, :V049, :V050)
7cy782quuav69Select r.科室id 病人科室, Decode(b.名称, Null, r.病历名称, b.名称) As 页面, r.病历名称, r.创建人 As 创建人, To_Char(r.创建时间, 'yyyy-mm-dd hh24:mi') As 创建时间, r.保存人, To_Char(r.完成时间, 'yyyy-mm-dd hh24:mi') As 完成时间, r.最后版本 As 当前版本, r.签名级别, Decode(r.最后版本, 1, '书写:', '修订:') || r.保存人 || '在' || To_Char(r.保存时间, 'yyyy-mm-dd hh24:mi') || Decode(Nvl(r.签名级别, 0), 0, '保存(未完成)', 1, '完成', '审签') As 当前情况, r.归档人, r.归档日期, r.科室id, d.名称 As 科室名, c.保留, r.处理状态, Decode(c.编号, b.编号, 1, 0) As 新组, r.Id, r.病历种类, b.编号, r.编辑方式, r.打印人 as 打印 From 电子病历记录 R, 部门表 D, 病历文件列表 C, 病历页面格式 B Where r.文件id = c.Id And r.病人来源 = 2 And r.病历种类 In (2, 5, 6) And r.科室id = d.Id And r.病人id = :V001 And r.主页id = :V002 And c.种类 = b.种类 And c.页面 = b.编号 Order By r.病历种类, b.编号, r.序号, r.创建时间
7q1cvfsy1n2wr SELECT Substr(Lpad(编号, 5, '0'), 4) 编号, 编号 系统, 名称 FROM Zlsystems WHERE 编号 IN (SELECT DISTINCT p.系统 FROM Zlprograms p, (SELECT 系统, 序号 FROM (SELECT DISTINCT p.系统, p.序号, r.功能 AS 授权 FROM Zlprogfuncs p, Zlregfunc r WHERE Trunc(p.系统 / 100) = r.系统(+) AND p.序号 = r.序号(+) AND p.功能 = r.功能(+) AND (EXISTS (SELECT 1 FROM Session_Roles WHERE Role = 'DBA') OR p.系统 IN (SELECT 编号 FROM Zlsystems WHERE Upper(所有者) = USER) OR p.系统 IN (SELECT 系统 FROM Zlrolegrant g, Session_Roles s WHERE g.角色 = s.Role)) MINUS SELECT DISTINCT s.系统, s.序号, r.功能 AS 授权 FROM Zlprogprivs s, Zlregfunc r WHERE Trunc(s.系统 / 100) = r.系统(+) AND s.序号 = r.序号(+) AND s.功能 = r.功能(+) AND (EXISTS (SELECT 1 FROM Session_Roles WHERE Role = 'DBA') OR s.系统 IN (SELECT 编号 FROM Zlsystems WHERE Upper(所有者) = USER) OR s.系统 IN (SELECT 系统 FROM Zlrolegrant g, Session_Roles s WHERE g.角色 = s.Role)) AND s.所有者 <> USER AND s.对象 IN (SELECT Object_Name FROM User_Objects WHERE Object_Type IN ('SEQUENCE', 'TABLE', 'VIEW', 'PROCEDURE', 'FUNCTION', 'PACAKEG'))) WHERE 授权 IS NULL AND 系统 IS NULL OR 授权 IS NOT NULL) f WHERE p.系统 = f.系统 AND p.序号 = f.序号 AND Upper(p.部件) IN ('ZL9LISWORK', 'ZL9TRANSFUSION', 'ZL9MEDISTORE', 'ZL9CISAUDIT', 'ZL9STUFF', 'ZL9BASEITEM', 'ZL9CISJOB', 'ZL9DRUGSTORE', 'ZL9OPS', 'ZL9CASHBILL', 'ZL9DUE', 'ZL9PACSWORK', 'ZL9REGEVENT', 'ZL9CISBASE', 'ZL9INPATIENT', 'ZL9INSURE', 'ZL9CARDSQUARE', 'ZL9OUTEXSE', 'ZL9INEXSE', 'ZL9PATIENT', 'ZL9I_MANAGER', 'ZL9ANALYSIS')) ORDER BY 名称, 编号
7vq0fm83fwszz Select B.NO, B.病人ID, B.门诊号, B.姓名, B.性别, B.年龄, B.复诊, B.急诊, B.社区, B.执行时间 as 时间, A.就诊卡号, A.身份证号, A.IC卡号, A.险类, B.发生时间, B.执行部门ID, B.执行人, B.转诊状态, C.名称 as 转诊科室, B.转诊诊室, B.转诊医生, B.执行状态, B.记录标志 From 病人信息 A, 病人挂号记录 B, 部门表 C Where B.病人ID=A.病人ID And B.转诊科室ID=C.ID(+) And B.执行状态=2 and nvl(B.记录标志, 0)<=1 And B.执行人||''=:V001 And B.记录性质=1 And B.记录状态=1 Order By B.NO
7ys86yy69t4h4Select Nvl(Sum(实收金额), 0) As 划价费用合计 From 住院费用记录 Where 记录状态=0 And 记帐费用=1 And 病人ID=:V001
8ah49yca3ntc7 Select /*+ RULE */ A.发送序号, A.费用序号, A.医嘱ID, A.相关ID, A.诊疗类别, F.名称 as 类别名称, D.名称 as 诊疗项目, A.标本部位, A.检查方法, A.发送时间, A.NO, A.记录性质, A.门诊记帐, Nvl(G.名称, B.名称)||Decode(B.产地, NULL, NULL, '('||B.产地||')')||Decode(B.规格, NULL, NULL, ' '||B.规格) as 收费项目, A.单位, A.发送数次 as 数量, C.名称 as 执行科室, A.执行状态, A.首次时间, A.末次时间, A.计费状态, A.发送人, A.发送号, A.执行部门ID, A.执行状态ID, A.计费状态ID, A.记录状态, D.操作类型, H.跟踪在用 From ( Select B.医嘱ID, C.相关ID, C.标本部位, C.检查方法, B.发送时间, B.NO, B.记录性质, B.门诊记帐, A.收费细目ID, Nvl(A.住院单位, D.住院单位) as 单位, Nvl(A.数次/Nvl(A.住院包装, 1), B.发送数次/Nvl(D.剂量系数, 1)/Nvl(D.住院包装, 1)) as 发送数次, Nvl(A.执行部门ID, B.执行部门ID) as 执行部门ID, Decode(Nvl(Instr(', 4, 5, 6, 7, ', A.收费类别), 0), 0, Decode(Nvl(B.执行状态, 0), 0, '未执行', 1, '执行完成', 2, '拒绝执行', 3, '正在执行'), Decode(Nvl(A.执行状态, 0), 0, '未执行', 1, '完全执行', 2, '部份执行')) as 执行状态, B.首次时间, B.末次时间, Decode(Nvl(B.计费状态, 0), -1, '无需计费', 0, '未计费', Decode(A.执行状态, 9, '收费异常', Decode(A.记录性质, 1, Decode(A.记录状态, 0, '收费划价', 1, '已收费', 3, '已退费'), 2, Decode(A.记录状态, 0, '记帐划价', 1, '已记帐', 3, '已销帐'), '未计费'))) as 计费状态, B.发送人, B.发送号, B.记录序号 as 发送序号, A.序号 as 费用序号, C.诊疗项目ID, C.诊疗类别, B.执行状态 as 执行状态ID, B.计费状态 as 计费状态ID, A.记录状态 From (Select A.*, B.住院包装, B.住院单位 From 住院费用记录 A, 药品规格 B Where A.记录状态 IN(0, 1, 3) And A.价格父号 is NULL And A.收费类别 IN('5', '6', '7') And A.收费细目ID=B.药品ID And A.医嘱序号=:V001) A, 病人医嘱发送 B, 病人医嘱记录 C, 药品规格 D Where B.医嘱ID=C.ID And C.收费细目ID=D.药品ID(+) And A.NO(+)=B.NO And A.记录性质(+)=B.记录性质 And A.医嘱序号(+)=B.医嘱ID And C.ID=:V002 Union ALL Select B.医嘱ID, C.相关ID, C.标本部位, C.检查方法, B.发送时间, B.NO, B.记录性质, B.门诊记帐, A .收费细目ID, Decode(Nvl(Instr('567', A.收费类别), 0), 0, Decode(A.收费类别, '4', F.计算单位, D.计算单位), Nvl(A.住院单位, E.住院单位)) as 单位, Nvl(A.数次/Nvl(A.住院包装, 1), B.发送数次/Nvl(E.剂量系数, 1)/Nvl(E.住院包装, 1)) as 发送数次, Nvl(A.执行部门ID, B.执行部门ID) as 执行部门ID, Decode(Nvl(Instr(', 4, 5, 6, 7, ', A.收费类别), 0), 0, Decode(Nvl(B.执行状态, 0), 0, '未执行', 1, '执行完成', 2, '拒绝执行', 3, '正在执行'), Decode(Nvl(A.执行状态, 0), 0, '未执行', 1, '完全执行', 2, '部份执行')) as 执行状态, B.首次时间, B.末次时间, Decode(Nvl(B.计费状态, 0), -1, '无需计费', 0, '未计费', Decode(A.执行状态, 9, '收费异常', Decode(A.记录性质, 1, Decode(A.记录状态, 0, '收费划价', 1, '已收费', 3, '已退费'), 2, Decode(A.记录状态, 0, '记帐划价', 1, '已记帐', 3, '已销帐'), '未计费'))) as 计费状态, B.发送人, B.发送号, B.记录序号 as 发送序号, A.序号 as 费用序号, C.诊疗项目ID, C.诊疗类别, B.执行状态 as 执行状态ID, B.计费状态 as 计费状态ID, A.记录状态 From (Select A.*, B.住院包装, B.住院单位 From 住院费用记录 A, 药品规格 B Where A.记录状态 IN(0, 1, 3) And A.价格父号 is NULL And A.收费细目ID=B.药品ID(+) And A.医嘱序号=:V003) A, 病人医嘱发送 B, 病人医嘱记录 C, 诊疗项目目录 D, 药品规格 E, 收费项目目录 F Where B.医嘱ID=C.ID And C.诊疗项目ID=D.ID And C.收费细目ID=E.药品ID(+) And C.收费细目ID=F.ID(+) And A.NO(+)=B.NO And A.记录性质(+)=B.记录性质 And 0+A.医嘱序号(+)=B.医嘱ID And C.ID=:V004) A, 收费项目目录 B, 部门表 C, 诊疗项目目录 D, 诊疗项目类别 F, 收费项目别名 G, 材料特性 H Where A.收费细目 ID=B.ID(+) And A.执行部门ID=C.ID(+) And A.诊疗项目ID=D.ID And A.诊疗类别=F.编码 And A.收费细目ID=H.材料ID(+) And A.收费细目ID=G.收费细目ID(+) And G.码类(+)=1 And G.性质(+)=3 Order by A.发送号 Desc, A.诊疗类别, A.发送序号, A.费用序号
8cjb6s69gx64kSELECT ZL_GET_REFERENCE(0, :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) FROM DUAL
8crc55tpkcbs3Select A.病人ID, A.主页ID, B.住院号, C.床号, B.姓名, B.性别, B.年龄, Min(A.完成时间) as 时间, -1 As 医嘱状态, '' as 状态 From ( Select A.病人ID, A.主页ID, A.病历种类, A.病历名称, A.签名级别, A.完成时间, B.保留 From 电子病历记录 A, 病历文件列表 B Where A.病人来源 = 2 And A.病历种类 In (2, 5, 6) And Nvl(A.处理状态, 0)<=0 And A.归档人 Is Null And A.文件ID=B.ID(+) And A.完成时间>=Trunc(Sysdate-(:V001-1)) And A.科室ID IN(Select 科室ID From 病区科室对应 Where 病区ID=:V002)) A, 病人信息 B, 病人变动记录 C Where A.病人ID=B.病人ID And (A.病历种类<>2 Or Nvl(A.保留, 0)>=0) And A.病人ID=C.病人ID And A.主页ID=C.主页ID And C.开始时间 Is Not Null And Nvl(C.附加床位, 0)=0 And (C.终止时间 Is Null Or C.终止原因=1) And A.签名级别<Decode(:V003, C.主任医师, 4, C.主治医师, 2, C.经治医师, 1, 0) Group by A.病人ID, A.主页ID, B.住院号, C.床号, B.姓名, B.性别, B.年龄 Order by 时间
8y924qm1xnbxzSelect RowNum As ID, 1 As 末级, A.* From (Select Decode(B.出院日期, NULL, Decode(B.状态, 3, 2, 1), Decode(B.出院方式, '死亡', 4, 3)) as 排序, Decode(B.出院日期, NULL, Decode(B.状态, 3, '预出院病人', '在院病人'), Decode(B.出院方式, '死亡', '死亡病人', '出院病人')) as 类型, A.病人ID, B.主页ID, B.住院号, A.门诊号, A.姓名, A.性别, A.年龄, C.名称 as 科室, B.住院医师, B.出院病床 as 床号, B.费别, B.入院日期, B.出院日期, B.状态, B.险类, A.就诊卡号 From 病人信息 A, 病案主页 B, 部门表 C Where A.病人ID=B.病人ID And Nvl(B.主页ID, 0)<>0 And (:V001=1 Or Nvl(B.状态, 0)<>1) And B.出院科室ID=C.ID And B.当前病区ID=:V002 And (:V003<>0 And B.出院日期 is NULL Or :V004<>0 And B.出院日期 Between :V005 And :V006) Order by 排序, 床号, 主页ID Desc) A
92m3u2m664casSelect Distinct D.编号, D.名称, D.说明, B.NO From 病人医嘱记录 A, 病人医嘱发送 B, 病历单据应用 C, 病历文件列表 D Where C.诊疗项目ID=A.诊疗项目ID And a.ID=b.医嘱ID And C.应用场合=2 And C.病历文件ID=D.ID And D.种类=7 And (a.ID=:V001 or A.相关ID=:V002) Order by D.编号
9h8nnhxxbm3r8 Select /*+ rule */ Distinct A.标本ID , a.诊疗项目id , A.编码, a.排列序号, a.固定项目, a.Id, a.检验项目, a.原始结果, a.上次结果, a.上次时间, a.Cv, Decode(a.本次结果, '-', '阴性(-)', '+', '阳性(+)', '*', '*.**', a.本次结果) As 本次结果, Rownum As 序号, a.计算公式, a.结果类型, a.标志, a.仪器id, a.标本类别, a.核收时间, a.标本序号, a.标本号显示, a.检验备注, a.姓名, a.性别, a.年龄, a.门诊号, a.住院号, a.当前床号, a.主页id, a.结果范围, Nvl(G.小数位数, 2) as 小数, Trim(Replace(Replace(' ' || Zl_Get_Reference(4, a.Id, a.标本类型, Decode(a.性别, '男', 1, '女', 2, 0), a.出生日期, a.仪器id, a.年龄, a.申请科室ID), ' .', '0.'), '~.', '~0.')) As 警戒上限, Trim(Replace(Replace(' ' || Zl_Get_Reference(3, a.Id, a.标本类型, Decode(a.性别, '男', 1, '女', 2, 0), a.出生日期, a.仪器id, a.年龄, a.申请科室ID), ' .', '0.'), '~.', '~0.')) As 警戒下限, a.单位, a.结果参考 as 参考, Trim(Replace(Replace(' ' || Zlgetreference(a.Id, a.标本类型, Decode(a.性别, '男', 1, '女', 2, 0), a.出生日期, a.仪器id, a.年龄, a.申请科室ID), ' .', '0.'), '~.', '~0.')) As 参考1, a.OD, a.CUTOFF, a.COV, a.酶标板ID, a.变异报警, a.变异警示, lpad(编码, 4, '0') as 排序, a.标本类型 From (Select A.id as 标本ID , b.诊疗项目id, decode(d.排列序号, Null, nvl(h.编码, C.编码), d.排列序号) as 编码, Nvl(b.排列序号, 9999) As 排列序号, Decode(b.诊疗项目id, Null, 0, 1) As 固定项目, b.检验项目id As Id, c.中文名 || Decode(d.缩写, Null, '', '(' || d.缩写 || ')') As 检验项目 , b.原始结果, '' As 上次结果, '' As 上次时间, '' As Cv, b.检验结果 As 本次结果, d.计算公式, d.结果类型, Decode(b.结果标志, 3, '↑', 2, '↓', 1, '', 4, '异常', 5, '↓↓', 6, '↑↑', '') As 标志, Nvl(a.仪器id, -1) As 仪器id, Nvl(a.标本类别, 0) As 标本类别, a.核收时间, a.标本序号, Decode(a.仪器id, Null, To_Char(Trunc(a.标本序号 / 10000) + 1, '0000') || '-' || To_Char(Mod(a.标本序号, 10000), '0000'), a.标本序号) As 标本号显示, a.检验备注, a.姓名, a.性别, a.年龄, a.标本类型, a.出生日期, a.门诊号, a.住院号, a.床号 As 当前床号, a.主页id, d.结果范围, d.警戒上限, d.警戒下限, d.单位, b.OD, B.CUTOFF, B.SCO as COV, b.酶标板ID, d.变异报警率 as 变异报警, d.变异警示率 as 变异警示, b.结果参考, a.申请科室ID , Zl_To_Number(Zl_Get_Reference(1, b.检验项目id, a.标本类型, Decode(a.性别, '男', 1, '女', 2, 0), a.出生日期, a.仪器id, a.年龄, a.申请科室ID)) as 参考ID From 检验标本记录 a, 检验普通结果 b, 诊治所见项目 c, 检验项目 d, 诊疗项目目录 h Where a.Id = b.检验标本id And b.检验项目id = c.Id And c.Id = d.诊治项目id And b.诊疗项目id = h.Id(+) And b.记录类型 = :V001 And a.Id = :V002 Union All Select a.id as 标本ID , b.诊疗项目id, decode(d.排列序号, Null, nvl(h.编码, C.编码), d.排列序号) as 编码, Nvl(b.排列序号, 9999) As 排列序号, Decode(b.诊疗项目id, Null, 0, 1) As 固定项目, b.检验项目id As Id, c.中文名 || Decode(d.缩写, Null, '', '(' || d.缩写 || ')') As 检验项目 , b.原始结果, '' As 上次结果, '' As 上次时间, '' As Cv, b.检验结果 As 本次结果, d.计算公式, d.结果类型, Decode(b.结果标志, 3, '↑', 2, '↓', 1, '', 4, '异常', 5, '↓↓', 6, '↑↑', '') As 标志, Nvl(a.仪器id, -1) As 仪器id, Nvl(a.标本类别, 0) As 标本类别, a.核收时间, a.标本序号, Decode(a.仪器id, Null, To_Char(Trunc(a.标本序号 / 10000) + 1, '0000') || '-' || To_Char(Mod(a.标本序号, 10000), '0000'), a.标本序号) As 标本号显示, a.检验备注, a.姓名, a.性别, a.年龄, a.标本类型, a.出生日期, a.门诊号, a.住院号, a.床号 As 当前床号, a.主页id, d.结果范围, d.警戒上限, d.警戒下限, d.单位, b.OD, B.CUTOFF, B.SCO as COV, b.酶标板ID, d.变异报警率 as 变异报警, d.变异警示率 as 变异警示, b.结果参考, a.申请科室ID , Zl_To_Number(Zl_Get_Reference(1, b.检验项目id, a.标本类型, Decode(a.性别, '男', 1, '女', 2, 0), a.出生日期, a.仪器id, a.年龄, a.申请科室ID)) as 参考ID From 检验标本记录 a, 检验普通结果 b, 诊治所见项目 c, 检验项目 d, 诊疗项目目录 h Where a.Id = b.检验标本id And b.检验项目id = c.Id And c.Id = d.诊治项目id And b.诊疗项目id = h.Id(+) And b.记录类型 = :V003 And a.合并id = :V004 ) A , 检验仪器项目 G, 检验项目参考 F Where A.仪器id = G.仪器id(+) And A.ID = G.项目id(+) and a.参考id=f.id (+) Order by 排序, 排列序号
9hy4hcdj67cvvUPDATE 病人信息 SET 门诊号 = :B42 , 住院号 = :B41 , 医疗付款方式 = :B40 , 费别 = DECODE(NVL(:B39 , 0), 0, :B38 , 费别), 姓名 = :B37 , 性别 = :B36 , 年龄 = :B35 , 出生日期 = :B34 , 出生地点 = :B33 , 身份证号 = :B32 , 身份 = :B31 , 职业 = :B30 , 民族 = :B29 , 国籍 = :B28 , 籍贯 = :B27 , 区域 = :B26 , 学历 = :B25 , 婚姻状况 = :B24 , 家庭地址 = :B23 , 家庭电话 = :B22 , 家庭地址邮编 = :B21 , 户口地址 = :B20 , 户口地址邮编 = :B19 , 联系人姓名 = :B18 , 联系人关系 = :B17 , 联系人地址 = :B16 , 联系人电话 = :B15 , 合同单位ID = DECODE(:B14 , 0, NULL, :B14 ), 工作单位 = :B13 , 单位电话 = :B12 , 单位邮编 = :B11 , 单位开户行 = :B10 , 单位帐号 = :B9 , 担保人 = :B8 , 担保额 = DECODE(:B7 , 0, NULL, :B7 ), 担保性质 = :B6 , 险类 = :B5 , 医保号 = :B4 , 其他证件 = :B3 , 联系人身份证号=:B2 WHERE 病人ID = :B1
9rbfa58tjn76fSelect Max(B.操作时间) as 时间 From 病人医嘱记录 A, 病人医嘱状态 B Where A.ID=B.医嘱ID And B.操作类型=5 And A.病人ID=:V001 And A.主页ID=:V002
9wqqut4ajt6hhselect 参数名, 参数值 from 保险参数 where 险类=:V001
a8rdu73vtbs66Select 医院编码 From 保险类别 Where 序号=:V001
aj1mmfscyf8f0Select Distinct B.发生时间 as 挂号时间, D.名称 as 挂号科室, C.主页ID, E.名称 as 住院科室, A.药物名, Nvl(A.过敏时间, A.记录时间) as 过敏时间, B.NO as 挂号单, A.药物ID From 病人过敏记录 A, 病人挂号记录 B, 病案主页 C, 部门表 D, 部门表 E Where A.病人ID=B.病人ID(+) And A.主页ID=B.ID(+) And B.记录性质(+)=1 And B.记录状态(+)=1 And A.病人ID=C.病人ID(+) And A.主页ID=C.主页ID(+) And B.执行部门ID=D.ID(+) And C.出院科室ID=E.ID(+) And A.结果=1 And 药物名 is Not NULL And A.病人ID=:V001 And Not Exists (Select 药物id From 病人过敏记录 Where (Nvl(药物id, 0) = Nvl(a.药物id, 0) Or Nvl(药物名, 'Null') = Nvl(a.药物名, 'Null')) And Nvl(结果, 0) = 0 And 记录时间>A.记录时间 And 病人id = :V002) Order by Nvl(A.过敏时间, A.记录时间) Desc
attz3csb61tp5 SELECT ROWNUM AS 序号, 手术时间, 手术规模, 手术台次, 手术间号, 手术名称, 医生嘱托, 姓名, 性别, 年龄, 住院科室, 手术科室, 床号, 住院号, 麻醉方式, 主刀医生, 第一助手, 第二助手, 第三助手, 主麻医生, 副麻医生, 巡回护士, 巡回护士II, 器械护士 FROM ( SELECT TRUNC(T.手术时间) 手术时间, T.手术规模, T.手术台次, T.手术间号, Z.名称 手术名称, S.医生嘱托, S.姓名, K.性别, K.年龄, M.名称 住院科室, N.名称 手术科室, B.出院病床 AS 床号, B.住院号, A.名称 麻醉方式, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='主刀医生' AND A.期间=1 AND A.手麻主页ID = T.ID) 主刀医生, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='第一助手' AND A.期间=1 AND A.手麻主页ID = T.ID) 第一助手, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='第二助手' AND A.期间=1 AND A.手麻主页ID = T.ID) 第二助手, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='第三助手' AND A.期间=1 AND A.手麻主页ID = T.ID) 第三助手, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='主麻医生' AND A.期间=1 AND A.手麻主页ID = T.ID) 主麻医生, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='副麻医生' AND A.期间=1 AND A.手麻主页ID = T.ID) 副麻医生, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='巡回护士' AND A.期间=1 AND A.手麻主页ID = T.ID) 巡回护士, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='巡回护士II' AND A.期间=1 AND A.手麻主 页ID = T.ID) 巡回护士II, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='器械护士' AND A.期间=1 AND A.手麻主页ID = T.ID) 器械护士 FROM ZLHIS.病人手麻主页 T, ZLHIS.病人医嘱记录 S, ZLHIS.诊疗项目目录 Z, ZLHIS.病案主页 B, ZLHIS.部门表 M, ZLHIS.部门表 N, ZLHIS.病人信息 K, ZLHIS.诊疗项目目录 A, ZLHIS.病人医嘱记录 C WHERE T.申请ID = S.ID AND S.诊疗项目ID = Z.ID AND S.病人ID = B.病人ID AND T.申请ID = C.相关ID AND C.诊 疗项目ID = A.ID AND C.诊疗类别 = 'G' AND S.主页ID = B.主页ID AND B.当前病区ID = M.ID AND T.执行科室ID = N.ID AND T.病人ID = K.病人ID AND K.住院号 IS NOT NULL AND T.手术时间 BETWEEN To_Date(:V001, 'YYYY-MM-DD') AND To_Date(:V002, 'YYYY-MM-DD HH24:MI:SS') AND T.手术状态<>6 UNION ALL SELECT TRUNC(T.手术时间) 手术时间, T.手术规模, T.手术台次, T.手术间号, A.名称 手术名称, C.医生嘱托, C.姓名, K.性别, K.年龄, '江北院区' 住院科室, N.名称 手术科室, B.出院病床 AS 床号, B.住院号, Z.名称 麻醉方式, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='主刀医生' AND A.期间=1 AND A.手麻主页ID = T.ID) 主刀医生, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='第一助手' AND A.期间=1 AND A.手麻主页ID = T.ID) 第一助手, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='第二助手' AND A.期间=1 AND A.手麻主页ID = T.ID) 第二助手, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='第三助手' AND A.期间=1 AND A.手麻主页ID = T.ID) 第三助手, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='主麻医生' AND A.期间=1 AND A.手麻主页ID = T.ID) 主麻医生, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='副麻医生' AND A.期间=1 AND A.手麻主页ID = T.ID) 副麻医生, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='巡回护士' AND A.期间=1 AND A.手麻主页ID = T.ID) 巡回护士, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A W HERE 岗位='巡回护士II' AND A.期间=1 AND A.手麻主页ID = T.ID) 巡回护士II, (SELECT WMSYS.WM_CONCAT(姓名) AS 姓名 FROM ZLHIS.病人手麻人员 A WHERE 岗位='器械护士' AND A.期间=1 AND A.手麻主页ID = T.ID) 器械护士 FROM ZLHIS.病人手麻主页 T, ZLHIS.诊疗项目目录 Z, ZLHIS.病案主页 B, ZLHIS.部门表 N, ZLHIS.病人信息 K, ZLHIS.诊疗项目目录 A, ZLHIS.病人医嘱记录 C, ZLHIS.病人手麻麻醉 F WH ERE C.病人ID = B.病人ID(+) AND T.申请ID = C.ID AND C.诊疗项目ID = A.ID AND C.诊疗类别 = 'F' AND C.主页ID = B.主页ID(+) /*AND B.当前病区ID = M.ID */AND T.执行科室ID = N.ID AND T.病人ID = K.病人ID /*AND K.住院号 IS NOT NULL*/ AND T.手术时间 BETWEEN To_Date(:V003, 'YYYY-MM-DD') AND To_Date(:V004, 'YYYY-MM-DD HH24:MI:SS') AND T.手术状态<>6 AND 直接登记 IS NOT NULL AND C.医嘱状态<>4 AND T.ID=F.手麻主页ID AND F.诊疗项目ID=Z.ID ) ORDER BY 手术时间
aumbw9np1mnh0 Select /*+ rule*/Rownum as KeyID, A.* From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.门诊包装||'/'||C.门诊单位) as 价格, Decode(X.库存, NULL, NULL, Round(X.库存/C.门诊包装, 5)||C.门诊单位) as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3)) And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V009) A Where A.ID=B.收费细 目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A, (Select A.药品ID, Nvl(Sum(A.可用数量), 0) as 库存 From 药品库存 A, 收费项目目录 B Where A.性质 = 1 And (Nvl(A.批次, 0)=0 Or A.效期 Is N ull Or A.效期>Trunc(Sysdate)) And A.库房ID=Decode(B.类别, '5', :V010, '6', :V011, '7', :V012, Null) And A.药品ID=B.ID And B.类别 IN('5', '6', '7') Group by A.药品ID Having Nvl(Sum(A.可用数量), 0)<>0) X Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V013, 3) Or :V014=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V015) And A.ID=X.药品ID(+) And D.毒理分类<>'麻醉药' And D.毒理分类<>'毒性药' And D.毒理分类 Not IN('精神I类', '精神II类') And Nvl(D.抗生素, 0)<>3 Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊 疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V016 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V017, ', '||科室ID||', ')>0) Or Not E xists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V018, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V019) And (A.编码 Like :V020 Or B.名称 Like :V021 Or B.简码 Like :V022) And B.码类=:V023 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V024, 3) Or :V025=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Null as 基本, A.编码, A.名称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V026, 3) Or :V027=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V028 Or B.名称 Like :V029 Or B.简码 Like :V030) And B.码类=:V031 And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V032) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V033, 3) Or :V034=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V035)) A Order by Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
b05d9j9myusm2Select /*+ rule */ Sum(Nvl(收费数量, 0) * Nvl(现价, 0)) As 金额 From (Select Distinct 诊疗项目id From (Select 诊疗项目id From 检验普通结果 Where 检验标本id = :V001 And 诊疗项目id Is Not Null Union All Select B.诊疗项目id From 检验普通结果 A, 检验报告项目 B, 诊疗项目目录 C Where A.检验项目id = B.报告项目id And B.诊疗项目id = C.ID And C.组合项目 = 0 And A.检验标本id = :V002 And A.诊疗项目id Is Null)) A, (Select E.诊疗项目id, E.收费数量, F.现价, J.编码, J.名称 From 诊疗收费关系 E, 收费价目 F, 收费项目目录 J Where F.收费细目id = J.ID And E.收费项目id = F.收费细目id And (F.终止日期 Is Null Or F.终止日期 = To_Date('3000-01-01', 'yyyy-mm-dd'))) B Where A.诊疗项目id = B.诊疗项目id
b564h8c70x81xSelect NextNO(:V001, :V002, :V003, :V004) as NO From Dual
b5gtjpxd3ktkp Select /*+ rule*/Rownum as KeyID, A.* From (Select A.*, R.频度 as 频度ID From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.住院包装||'/'||C.住院单位) as 价格, Null as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3)) And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V009) A Where A.ID=B.收费细目ID And Sysdate Between B.执 行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY -MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V010, 3) Or :V011=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V012) Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V013 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V014, ', '||科室ID||', ')>0) Or Not Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V015, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V016) And (A.编码 Like :V017 Or B.名称 Like :V018 Or B.简码 Like :V019) An d B.码类=:V020 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V021, 3) Or :V022=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F. 名称 AS 类别, Null as 基本, A.编码, A.名称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V023, 3) Or :V024=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V025 Or B.名称 Like :V026 Or B.简码 Like :V027) And B.码类=:V028 And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V029) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V030, 3) Or :V031=3 And Nvl( E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V032)) A, 诊疗个人项目 R Where R.诊疗项目ID=A.诊疗项目ID And (A.收费细目ID is Null Or A.收费细目ID = R.收费细目ID) And R.人员ID=:V033) A Order by 频度ID Desc, Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
bdr14zub67875SELECT 内容 FROM 电子病历格式 WHERE 文件ID = TO_NUMBER(:B1 )
bdzkty8cx0x6p Select /*+ rule*/Rownum as KeyID, A.* From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.住院包装||'/'||C.住院单位) as 价格, Null as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3)) And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V009) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date( '3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V010, 3) Or :V011=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V012) And E.类别=:V013 Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V014 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V015, ', '||科室ID||', ')>0) Or Not Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V016, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V017) And A.类别=:V018 And (A.编码 Like :V019 Or B.名称 Like :V020 Or B.简码 Like :V021) And B.码类=:V022 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V023, 3) Or :V024=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名 称 AS 类别, Null as 基本, A.编码, A.名称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V025, 3) Or :V026=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V027 Or B.名称 Like :V028 Or B.简码 Like :V029) And B.码类=:V030 And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V031) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V032, 3) Or :V033=3 And Nvl(E. 服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V034) And E.类别=:V035) A Order by Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
bwayuumbpdr73Select 医院编码 From 保险类别 Where 序号=10
c1yr7s5676cm3Select Zl_Lob_Read(:V001, :V002, :V003, :V004) as 片段 From Dual
c749bc43qqfz3SELECT SYSDATE FROM DUAL
c7rtz3p9fw3btSelect Decode(归档人, Null, 1, 0) As 可写 From 电子病历记录 Where ID = :V001
ckgxr4xhw7tz5Select ID, 文件id, 开始版, 终止版, 父id, 对象序号, 对象类型, 对象标记, 保留对象, 对象属性, 内容行次, 内容文本, 是否换行 From 电子病历内容 Where 文件id = :V001 And 对象类型 = 5 And 对象序号 Is Not Null
cqgv56fmuj63xselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
d235wddmn4md7 Select /*+ RULE */ A.发送序号, A.费用序号, A.医嘱ID, A.相关ID, A.诊疗类别, F.名称 as 类别名称, D.名称 as 诊疗项目, A.标本部位, A.检查方法, A.发送时间, A.NO, A.记录性质, A.门诊记帐, Nvl(G.名称, B.名称)||Decode(B.产地, NULL, NULL, '('||B.产地||')')||Decode(B.规格, NULL, NULL, ' '||B.规格) as 收费项目, A.单位, A.发送数次 as 数量, C.名称 as 执行科室, A.执行状态, A.首次时间, A.末次时间, A.计费状态, A.发送人, A.发送号, A.执行部门ID, A.执行状态ID, A.计费状态ID, A.记录状态, D.操作类型, H.跟踪在用 From ( Select B.医嘱ID, C.相关ID, C.标本部位, C.检查方法, B.发送时间, B.NO, B.记录性质, B.门诊记帐, A.收费细目ID, Decode(Nvl(Instr('567', A.收费类别), 0), 0, Decode(A.收费类别, '4', F.计算单位, D.计算单位), Nvl(A.住院单位, E.住院单位)) as 单位, Nvl(Nvl(A.付数, 1)*A.数次/Nvl(A.住院包装, 1), B.发送数次/Nvl(E.剂量系数, 1)/Nvl(E.住院包装, 1)) as 发送数次, Nvl(A.执行部门ID, B.执行部门ID) as 执行部门ID, Decode(Nvl(Instr(', 4, 5, 6, 7, ', A.收费类别), 0), 0, Decode(Nvl(B.执行状态, 0), 0, '未执行', 1, '执行完成', 2, '拒绝执行', 3, '正在执行'), Decode(Nvl(A.执行状态, 0), 0, '未执行', 1, '完全执行', 2, '部份执行')) as 执行状态, B.首次时间, B.末次时间, Decode(Nvl(B.计费状态, 0), -1, '无需计费', 0, '未计费', Decode(A.执行状态, 9, '收费异常', Decode(A.记录性质, 1, Decode(A.记录状态, 0, '收费划价', 1, '已收费', 3, '已退费'), 2, Decode(A.记录状态, 0, '记帐划价', 1, '已记帐', 3, '已销帐'), '未计费'))) as 计费状态, B.发送人, B.发送号, B.记录序号 as 发送序号, A.序号 as 费用序号, C.诊疗项目ID, C.诊疗 类别, B.执行状态 as 执行状态ID, B.计费状态 as 计费状态ID, A.记录状态 From ( Select A.*, B.住院包装, B.住院单位 From 住院费用记录 A, 药品规格 B Where A.记录状态 IN(0, 1, 3) And A.价格父号 is NULL And A.收费细目ID=B.药品ID(+) And A.医嘱序号=:V001 Union ALL Select A.*, B.住院包装, B.住院单位 From 住院费用记录 A, 药品规格 B, 病人医嘱记录 C Where A.记录状态 IN(0, 1, 3) And A.价格父号 is NULL And A.收费细目ID=B.药品ID(+) And A.医嘱序号=C.ID And C.相关 ID=:V002) A, 病人医嘱发送 B, ( Select * From 病人医嘱记录 Where ID=:V003 Union ALL Select * From 病人医嘱记录 Where 相关ID=:V004) C, 诊疗项目目录 D, 药品规格 E, 收费项目目录 F Where B.医嘱ID=C.ID And C.诊疗项目ID=D.ID And C.收费细目ID=E.药品ID(+) And C.收费细目ID=F.ID(+) And A.NO(+)=B.NO And A.记录性质(+)=B.记录性质 And 0+A.医嘱序号(+)=B.医嘱ID) A, 收费项目目录 B, 部门表 C, 诊疗项目目录 D, 诊疗项目类别 F, 收费项目别名 G, 材料特性 H Where A.收费细目ID=B.ID(+) And A.执行部门ID=C.ID(+) And A.诊疗项目ID=D.ID And A.诊疗类别=F.编码 And A.收费细目ID=H.材料ID(+) And A.收费细目ID=G.收费细目ID(+) And G.码类(+)=1 And G.性质(+)=3 Order by A.发送号 Desc, A.诊疗类别, A.发送序号, A.费用序号
dqfw3npn8zcpx SELECT F.ID, F.唯一, R.次数, L.份数 FROM (SELECT F.ID, F.事件, F.必须, F.唯一, F.书写时限 FROM (SELECT F.ID, F.编号, F.通用, A.科室ID, Q.事件, Q.必须, Q.唯一, Q.书写时限 FROM 病历文件列表 F, 病历应用科室 A, 病历时限要求 Q WHERE F.ID = A.文件ID(+) AND F.ID = Q.文件ID AND F.种类 = 2) F WHERE F.通用 = 1 OR F.通用 = 2 AND F.科室ID = :B1 ) F, (SELECT DECODE(:B7 , 1, DECODE(事件, '入院', NULL, '出院', DECODE(:B6 , '死亡', '24小时死亡', '24小时出院'), 事件), DECODE(事件, '出院', DECODE(:B6 , '死亡', '死亡', '出院'), 事件)) AS 事件, 时机, DECODE(事件, '入院', 1, '出院', 1, COUNT(*)) AS 次数 FROM (SELECT DECODE(开始原因, 1, '入院', 2, '入院', 9, '入院', 3, '转科', 7, '交班') AS 事件, '后' AS 时机 FROM 病人变动记录 WHERE 病人ID = :B3 AND 主页ID = :B2 AND 开始时间 >= :B5 AND NVL(终止时间, SYSDATE) <= :B4 AND (科室ID + 0 = :B1 OR 开始原因 IN (1, 2, 9)) UNION ALL SELECT DECODE(终止原因, 3, '转科', 7, '交班', 1, '出院', 10, '出院') AS 事件, DECODE(终止原因, 3, '前', 7, '前', 1, '后', 10, '后') AS 时机 FROM 病人变动记录 WHERE 病人ID = :B3 AND 主页ID = :B2 AND 开始时间 >= :B5 AND 终止时间 <= :B4 AND 科室ID + 0 = :B1 UNION ALL SELECT DECODE(I.操作类型, '5', '出院', '11', '死亡') AS 事件, '后' AS 时机 FROM 病人医嘱记录 R, 诊疗项目目录 I WHERE R.诊疗项目ID = I.ID AND R.病人ID = :B3 AND R.主页ID = :B2 AND R.病人科室ID + 0 = :B1 AND R.相关ID IS NULL AND R.医嘱期效 = 1 AND R.诊疗类别 = 'Z' AND I.操作类型 IN ( '5', '11')) GROUP BY 事件, 时机 HAVING 事件 IS NOT NULL AND 时机 IS NOT NULL UNION ALL SELECT DECODE(R.诊疗类别, 'F', '手术', DECODE(I.操作类型, '7', '会诊', '抢救')) AS 事件, '前' AS 时机, COUNT(*) AS 次数 FROM 病人医嘱记录 R, 诊疗项目目录 I WHERE R.诊疗项目ID = I.ID AND (R. 诊疗类别 = 'F' OR R.诊疗类别 = 'Z' AND I.操作类型 IN ('7', '8')) AND R.病人ID = :B3 AND R.主页ID = :B2 AND R.相关ID IS NULL AND R.病人科室ID + 0 = :B1 AND R.医嘱期效 = 1 AND (R.医嘱状态 = 8 OR R.医嘱状态 = 9) GROUP BY DECODE(R.诊疗类别, 'F', '手术', DECODE(I.操作类型, '7', '会诊', '抢救')) UNION ALL SELECT DECODE(I.操作类型, '7', '会诊', '抢救') AS 事件, '后' AS 时机, COUNT(*) AS 次数 FROM 病人医嘱记录 R, 诊疗项目目录 I WHERE R.诊疗项目ID = I.ID AND R.诊疗类别 = 'Z' AND I.操作类型 IN ('7', '8') AND R.病人ID = :B3 AND R.主页ID = :B2 AND R.相关ID IS NULL AND R.执行科室ID + 0 = :B1 AND R.医嘱期效 = 1 AND (R.医嘱状态 = 8 OR R.医嘱状态 = 9) GROUP BY DECODE(I.操作类型, '7', '会诊', '抢救') UNION ALL SELECT DECODE(R.诊疗类别, 'F', '手术') AS 事件, '后' AS 时机, COUNT(*) AS 次数 FROM 病人医嘱记录 R, 诊疗项目目录 I WHERE R.诊疗项目ID = I.ID AND R.诊疗类别 = 'F' AND R.病人ID = :B3 AND R.主页ID = :B2 AND R.相关ID IS NULL AND R.病人科室ID + 0 = :B1 AND R.医嘱期效 = 1 AND (R.医嘱状态 = 8 OR R.医嘱状态 = 9) GROUP BY DECODE(R.诊疗类别, 'F', '手术')) R, (SELECT R.文件ID, COUNT(*) AS 份数 FROM 电子病历记录 R WHERE R.病人ID = :B3 AND R.主页ID = :B2 AND R.病历种类 = 2 AND R.科室ID + 0 = :B1 GROUP BY R.文件ID) L WHERE (:B9 = 1 AND R.事件 = '入院' AND F.事件 = '再次入院' OR :B9 <> 1 AND R.事件 = '入院' AND F.事件 = '首次入院' OR R.事件 = F.事件) AND (R.事件 = '入院' AND :B8 <> :B1 AND F.唯一 = 0 OR R.事件 = '入院' AND :B8 = :B1 OR R.事件 <> '入院') AND (F.唯一 = 0 AND R.时机 = '后' OR F.唯一 = 1 AND (R.时机 = '前' AND F.书写时限 < 0 OR R.时机 = '后' AND F.书写时限 >= 0)) AND F.ID = L.文件ID(+)
dtw1akmdumhdrSELECT E.编码, E.名称, A.采购金额, A.售价金额 AS 零售金额, A.进销差价 AS 差价 FROM (SELECT 供药单位ID, SUM(成本金额) AS 采购金额, SUM(零售金额) AS 售价金额, SUM(差价) AS 进销差价 FROM ZLHIS.药品收发记录 WHERE 审核日期 BETWEEN To_Date(:V001, 'YYYY-MM-DD') AND To_Date(:V002, 'YYYY-MM-DD HH24:MI:SS') AND 单据=1 AND 库房ID+0 is not null HAVING SUM(成本金额)<>0 OR SUM(零售金额)<>0 OR SUM(差价)<>0 GROUP BY 供药单位ID) A, (SELECT * FROM ZLHIS.供应商 WHERE SUBSTR(类型, 1, 1)=1) E WHERE E.ID=A.供药单位ID ORDER BY E.编码
f0zj3p6vu1tqf Select 参数ID, Nvl(用户名, 'NullUser') as 用户名, Nvl(机器名, 'NullMachine') as 机器名, 参数值 From zlUserParas Where 用户名=:V001 Union Select 参数ID, Nvl(用户名, 'NullUser') as 用户名, Nvl(机器名, 'NullMachine') as 机器名, 参数值 From zlUserParas Where 机器名=:V002
f32d9pqhr4rxu Select /*+ rule*/Rownum as KeyID, A.* From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.住院包装||'/'||C.住院单位) as 价格, Null as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, Null as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3))) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A .零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V009, 3) Or :V010=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V011) Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V012 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V013, ', '||科室ID||', ')>0) Or Not Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V014, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V015) And (A.编码 Like :V016 Or B.名称 Like :V017 Or B.简码 Like :V018) And B.码类=:V019 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V020, 3) Or :V021=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Null as 基本, A.编码, A.名称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, Null as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V022, 3) Or :V023=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V024 Or B.名称 Like :V025 Or B.简码 Like :V026) And B.码类=:V027) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V028, 3) Or :V029=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V030)) A Order by Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
f3jpz99b2scw4 select 编码, 设备名称, 单位, 订购时间, 登记时间, 生产厂家, 型号, 实际使用年限, 使用部门, sum(数量) 数量, sum(原值) 原值, sum(本月折旧) 本月折旧, sum(累计折旧) 累计折旧, sum(净值) 净值 from (Select B.NO 卡号, A.编码, b.报废时间, A.名称 设备名称, A.单位, A.规格 型号, i.数量 数量 , h.名称 as 使用部门, A.产地 as 生产厂家 , to_char(B.订购时间, 'YYYY-MM-DD') 订购时间 , to_char(B.登记日期, 'YYYY-MM-DD') 登记时间, round((sysdate-B.订购时间)/30, 0)||'月' as 实际使用年限, B.使用年限 || '月' as "使用年限", i.原值, --Decode(c.累计折旧, NULL, (Decode(F.累计折旧, null, 0, F.累计折旧+Nvl(F.本月折旧+b.累计折旧, 0))), 0, 0, c.累计折旧+b.累计折旧) 累计折旧, Decode(c.累计折旧, NULL, (Decode(F.累计折旧, null, 0, F.累计折旧+Nvl(F.本月折旧+b.累计折旧, 0))), 0, c.累计折旧+b.累计折旧, c.累计折旧+b.累计折旧) 累计折旧, Decode(i.原值*(1-b.残值率) - c.累计折旧 , NULL, 0, 0, 0, i.原值*(1-b.残值率) - c.累计折旧) 净值, Decode(c.本月折旧, NULL, 0, 0, 0, C.本月折旧) 本月折旧, Decode(B.总工作量, NULL, 0, 0, 0, B.总工作量) 总工作量, Decode(B.累计工作量, NULL, 0, 0, 0, B.累计工作量) 累计工作量, Decode(C.本月工作量, NULL, 0, 0, 0, C.本月工作量) 本月工作量 From 设备目录 A, 设备卡片 B, 折旧方式 D, (SELECT 卡片id , 使用部门id, sum(数量) 数量, sum(原值) 原值, sum(本月折旧) 本月折旧, sum(本月工作量) 本月工作量 FROM ( SELECT 卡片id, a.部门id as 使用部门id, decode(a.设备id, b.设备id, 1, 0)*nvl(实际数量, 0) 数量 , nvl(原值, 0) 原值 , 0 本月折旧, 0 本月工作量 FROM 设备在用记录 a, 设备卡片 b WHERE a.卡片id=b.id AND a.部门id /*B0*/<>0/*E0*/ union all SELECT 卡片id, a.使用部门id, 0 数量 , -1*a.原值 原值, 0 本月折旧, 0 本月工作量 FROM 设备变动记录 a, 设备卡片 b WHERE a.卡片id=b.id AND a.变动类型=1 AND a.审批日期 >(Select 终止日期 From 期间表 where 期间=/*B1*/201306/*E1*/)+1-1/24/60/60 U NION ALL SELECT 卡片id, a.使用部门id, decode(a.设备id, b.设备id, 1, 0)*nvl(数量, 0) 数量 , a.原值, 0 本月折旧, 0 本月工作量 FROM 设备变动记录 a, 设备卡片 b WHERE a.卡片id=b.id AND a.变动类型=3 AND a.审批日期 >(Select 终止日期 From 期间表 where 期间=/*B1*/201306/*E1*/)+1-1/24/60/60 UNION ALL SELECT 卡片id, a.使用部门id, decode(a.设备id, b.设备id, 1, 0)*nvl(数量, 0)*记录系数*-1 数量, nvl(原值, 0)*记录系数*-1 原值, 0 本月折旧, 0 本月工作量 FROM 设备变动记录 a, 设备卡片 b WHERE a.使用部门id /*B0*/<>0/*E0*/ AND A.变动类型=4 and a.卡片id=b.id AND a.审批日期 >(Select 终止日期 From 期间表 where 期间=/*B1*/201306/*E1*/)+1-1/24/60/60 UNION ALL SELECT 卡片id, 部门id as 使用部门id, 0 数量, 0 原值, 本月折旧, 本月工作量 FROM 部门折旧数据 WHERE 部门id /*B0*/<>0/*E0*/ AND 期间=/*B1*/201306/*E1*/ ) GROUP BY 卡片id, 使用部门id) I, (Select * From 设备数据 Where 期间=/*B1*/201306/*E1*/) C, (Select * From 设备数据 Where 期间=(Select Max(期间) From 期间表 Where 期间</*B1*/201306/*E1*/)) F, 部门表 h Where B.设备ID= a.id and I.使用部门id /*B0*/<>0/*E0*/ and b.记录状态=0 and b.启用日期 is not null And B.ID = C.卡片ID(+) And B.ID=F.卡片ID(+) and b.id=I.卡片id And A.折旧方式 = D.编码 ---增加对收费部门判断20130614 and h.id<>21 ---增加对收费部门判断20130614 and (to_char(nvl(b.领用日期, b.订购时间), 'yyyymm')<=/*B1*/201306/*E1*/ or to_char(nvl(b.领用日期, b.订购时间), 'yyyymm') is null) -- And i.使用状态ID=E.ID and i.使用部门id=h.id and b.no not in (select no from 设备卡片 t where (TO_CHAR(t.登记日期, 'yyyymm')>/*B1*/201306/*E1*/ and TO_CHAR(t.报废时间, 'yyyymm')>/*B1*/201306/*E1*/)) an d (TO_CHAR(b.报废时间, 'yyyymm')>/*B1*/201306/*E1*/ or b.报废时间 is null) and A.分类ID /*B2*/is not null/*E2*/) where 数量<>0 And 编码 Not Like '4%' group by 编码, 设备名称, 单位, 订购时间, 登记时间, 生产厂家, 型号, 实际使用年限, 使用部门 order by 设备名称, 订购时间
f4fkjrchf97v7Select 1 From 病人护理记录 A Where a.病人id = :V001 And a.主页id = :V002
fmn19m0fr5ps2Select 电子病历内容_ID.Nextval From Dual
ftj9uawt4wwzbselect condition from cdef$ where rowid=:1
fuqd9gf3sbxsuCall ZL_电子病历内容_Update(:V001, :V002, :V003, :V004, :V005, :V006, :V007, :V008, :V009, :V010, :V011, :V012, :V013)
fzphwsw5fzbnk Select /*+ Rule*/B.NO, B.病人ID, B.门诊号, B.姓名, B.性别, B.年龄, B.复诊, B.急诊, B.社区, B.发生时间 as 时间, A.就诊卡号, A.身份证号, A.IC卡号, A.险类, B.号序, B.诊室, B.分诊时间, B.发生时间, B.执行部门ID, B.执行人, B.转诊状态, C.名称 as 转诊科室, B.转诊诊室, B.转诊医生, B.执行状态, B.记录标志 From 病人信息 A, 病人挂号记录 B, 部门表 C Where B.病人ID=A.病人ID And (Nvl(B.执行状态, 0)=0 or nvl(B.执行状态, 0)=:V001) And B.转诊科室ID=C.ID(+) And B.记录性质=1 And B.记录状态=1 And B.执行时间 is Null And B.发生时间 <= Trunc(Sysdate)+1-1/24/60/60 And B.执行部门ID+0=:V002 And (B.执行人||''=:V003 Or B.执行人 Is Null) And B.发生时间>=Sysdate-1 Order By Decode(B.分诊时间, NULL, 2, 1), B.分诊时间, B.NO
g37byx2zf1gjdUPDATE 医保调用日志 SET 返回信息=:B6 , 操作时间=:B5 , 处理方式=:B4 , YB流水号=:B3 , 状态=:B2 WHERE 序号=:B1
g3f752jw1w1pc Select /*+ rule*/Rownum as KeyID, A.* From (Select A.*, R.频度 as 频度ID From ( Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Decode(C.基本药物, Null, Null, '*') as 基本, A.编码, A.名称, A.商品名, A.简码, E.计算单位, A.规格, A.产地, D.药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, D.处方职务 as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格*C.门诊包装||'/'||C.门诊单位) as 价格, Decode(X.库存, NULL, NULL, Round(X.库存/C.门诊包装, 5)||C.门诊单位) as 库存, Decode(d.抗生素, 0, '', 1, '非限制使用', 2, '限制使用', 3, '特殊使用') as 抗菌等级 From 药品规格 C, 药品特性 D, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位 as 零售单位, 1 as 零售包装, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别 IN ('5', '6', '7') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V001, 3) Or :V002=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V003 And B.码类=:V004 Or B.名称 Like :V005 And B.码类=:V006 Or B.简码 Like :V007 And B.码类 IN(:V008, 3)) And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险 类(+)=:V009) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.商品名, A.简码, A.零售单位, A.零售包装, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A, (Select A.药品ID, Nvl(Sum(A.可用数量), 0) as 库存 From 药品库存 A, 收费项目目录 B Where A.性质 = 1 A nd (Nvl(A.批次, 0)=0 Or A.效期 Is Null Or A.效期>Trunc(Sysdate)) And A.库房ID=Decode(B.类别, '5', :V010, '6', :V011, '7', :V012, Null) And A.药品ID=B.ID And B.类别 IN('5', '6', '7') Group by A.药品ID Having Nvl(Sum(A.可用数量), 0)<>0) X Where A.ID=C.药品ID And C.药名ID=D.药名ID And D.药名ID=E.ID And A.类别=F.编码 And E.类别 IN('5', '6', '7') And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V013, 3) Or :V014=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V015) And A.ID=X.药品ID(+) And D.毒理分类<>'麻醉药' And D.毒理分类<>'毒性药' And D.毒理分类 Not IN('精神I类', '精神II类') And Nvl(D.抗生素, 0)<>3 Union ALL Select A.类别 As 类别ID, A.ID as 诊疗项目ID, -Null as 收费细目ID, D.名称 As 类别, Null as 基本, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.标本部位 as 规格, Null as 产地, Null as 药品剂型, Decode(A.类别, 'H', Decode(A.操作类型, '1', '护理等级', '护理常规'), 'E', Decode(A.操作类型, '1', '过敏试验', '2', '给药途径', '3', '中药煎法', '4', '中药用法', '5', '特殊治疗', '6', '采集方法', '7', '配血方法', '8', '输血途径', Null), 'Z', Decode(A.操作类型, '1', '留观', '2', '住院', '3', '转科', '4', '术后', '5', '出院', '6', '转院', '7', '会诊', '8', '抢救', '9', '病重', '10', '病危', '11', '死亡', '12', '记录入出量', '14', '术前', NULL), A.操作类型) As 项目特性, Null as 费用类型, Null as 医保大类, Null as 说明, Null as 处方职务ID, Null as 价格, Null as 库存, Null As 抗菌等级 From 诊疗项目类别 D, 诊疗项目别名 B, 诊疗项目目录 A Where A.ID=B.诊疗项目ID And A.类别=D.编码 And A.类别 Not IN('4', '5', '6', '7') And ((A.类别<>'9' Or A.类别='9' And (A.人员ID=:V016 Or A.人员ID is Null)) And (Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID And Instr(:V017, ' , '||科室ID||', ')>0) Or Not Exists(Select 1 From 诊疗适用科室 Where 项目ID=A.ID))) And Nvl(A.单独应用, 0)=1 And Instr(:V018, ', '||Nvl(A.适用性别, 0)||', ')>0 And Nvl(A.执行频率, 0) IN(0, :V019) And (A.编码 Like :V020 Or B.名称 Like :V021 Or B.简码 Like :V022) And B.码类=:V023 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V024, 3) Or :V025=3 And Nvl(A.服务对象, 0)<>0) Union ALL Select A.类别 AS 类别ID, E.ID as 诊疗项目ID, A.ID as 收费细目ID, F.名称 AS 类别, Null as 基本, A.编码, A.名称, Null as 商品名, A.简码, A.计算单位, A.规格, A.产地, Null as 药品剂型, Null as 项目特性, A.费用类型, A.医保大类, A.说明, Null as 处方职务ID, Decode(A.价格, NULL, NULL, A.价格||'/'||A.计算单位) as 价格, Null as 库存, Null As 抗菌等级 From 材料特性 C, 诊疗项目目录 E, 收费项目类别 F, (Select A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Sum(Decode(A.是否变价, 1, NULL, B.现价)) as 价格 From 收费价目 B, (Select A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, N.名称 as 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 M, 保险支付大类 N Where A.ID=B.收费细目ID And A.类别='4' And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.服务对象 IN(:V026, 3) Or :V027=3 And Nvl(A.服务对象, 0)<>0) And (A.编码 Like :V028 Or B.名称 Lik e :V029 Or B.简码 Like :V030) And B.码类=:V031 And A.ID=M.收费细目ID(+) And M.大类ID=N.ID(+) And M.险类(+)=:V032) A Where A.ID=B.收费细目ID And Sysdate Between B.执行日期 And Nvl(B.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, A.编码, A.名称, A.简码, A.计算单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明) A Where A.ID=C.材料ID And C.诊疗ID=E.ID And A.类别=F.编码 And E.类别='4' And C.核算材料=0 And (E.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or E.撤档时间 IS NULL) And (E.服务对象 IN(:V033, 3) Or :V034=3 And Nvl(E.服务对象, 0)<>0) And Nvl(E.执行频率, 0) IN(0, :V035)) A, 诊疗个人项目 R Where R.诊疗项目ID=A.诊疗项目ID And (A.收费细目ID is Null Or A.收费细目ID = R.收费细目ID) And R.人员ID=:V036) A Order by 频度ID Desc, Decode(类别ID, '4', 'Z', 类别ID), 类别, 编码
g7pa9azppjarwSelect 项目, 内容 From 病人医嘱附件 Where 医嘱ID=:V001 Order by 排列
gav1bu4ngn5sdSelect /*+ rule */ Sum(Nvl(收费数量, 0) * Nvl(现价, 0)) As 金额 From ( --- 根据标本记录中的 条码,医嘱id, 相关id,得到对应的诊疗项目id Select C.诊疗项目id From 病人医嘱记录 C, 病人医嘱发送 B, 检验标本记录 A Where B.医嘱id = C.ID And A.样本条码 = B.样本条码 And A.ID = :V001 Union Select C.诊疗项目id From 病人医嘱记录 C, 检验标本记录 A Where A.医嘱id = C.ID And A.ID = :V002 Union Select C.诊疗项目id From 病人医嘱记录 C, 检验标本记录 A Where A.医嘱id = C.相关id And A.ID = :V003) A, (Select E.诊疗项目id, E.收费数量, F.现价, J.编码, J.名称 From 诊疗收费关系 E, 收费价目 F, 收费项目目录 J Where F.收费细目id = J.ID And E.收费项目id = F.收费细目id And (F.终止日期 Is Null Or F.终止日期 = To_Date('3000-01-01', 'yyyy-mm-dd'))) B Where A.诊疗项目id = B.诊疗项目id
gf01bfdmyaukqSELECT A.应收款总额 - NVL(SUM(金额), 0) FROM (SELECT A.病人ID, SUM(A.冲预交) 应收款总额 FROM 病人预交记录 A, 结算方式 B WHERE A.病人ID = :B1 AND A.结算方式 = B.名称 AND B.应收款 = 1 GROUP BY 病人ID) A, 病人缴款记录 B WHERE A.病人ID = B.病人ID(+) AND B.记录状态(+) = 1 GROUP BY A.病人ID, 应收款总额
gvh0t43k0t9wh Select A.ID, A.类别 as 类别ID, B.序号 as 顺序ID, B.名称 as 类别, A.编码, A.名称, NULL as 商品名, A.简码, A.计算单位 as 单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Decode(A.是否变价, 1, '变价', LTrim(To_Char(Sum(C.现价), '9999990.00000'))) as 单价, NULL as 库存 From 收费价目 C, ( Select Distinct A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, D.名称 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 C, 保险支付大类 D Where A.ID=B.收费细目ID And A.服务对象 IN(:V001, 3) And A.类别 Not IN('4', '5', '6', '7', '1') And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And A.ID=C.收费细目ID(+) And C.险类(+)=:V002 And C.大类ID=D.ID(+) And Instr(:V003, A.类别)>0 And (A.编码 Like :V004 Or B.名称 Like :V005 Or B.简码 Like :V006) And B.码类=:V007) A, 收费项目类别 B Where A.类别=B.编码 And A.ID=C.收费细目ID And Sysdate Between C.执行日期+0 and Nvl(C.终止日期, To_Date('3000-01-01', 'YYYY-MM-DD')) Group by A.ID, A.类别, B.序号, B.名称, A.编码, A.名称, A.简码, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, A.是否变价, A.计算单位 Order by 顺序ID, 编码

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 119,320 33.13 14.03
CPU used when call started 118,993 33.04 13.99
CR blocks created 2,325 0.65 0.27
Cached Commit SCN referenced 700 0.19 0.08
Commit SCN cached 1 0.00 0.00
DB time 1,280,065 355.38 150.49
DBWR checkpoint buffers written 6,712 1.86 0.79
DBWR checkpoints 1 0.00 0.00
DBWR fusion writes 3,765 1.05 0.44
DBWR revisited being-written buffer 0 0.00 0.00
DBWR transaction table writes 114 0.03 0.01
DBWR undo block writes 2,908 0.81 0.34
DFO trees parallelized 176 0.05 0.02
PX local messages recv'd 955 0.27 0.11
PX local messages sent 955 0.27 0.11
PX remote messages recv'd 1,059 0.29 0.12
PX remote messages sent 13,010 3.61 1.53
Parallel operations downgraded to serial 0 0.00 0.00
Parallel operations not downgraded 176 0.05 0.02
RowCR - row contention 40 0.01 0.00
RowCR attempts 22,933 6.37 2.70
RowCR hits 28,014 7.78 3.29
SMON posted for instance recovery 0 0.00 0.00
SMON posted for undo segment shrink 6 0.00 0.00
SQL*Net roundtrips to/from client 2,272,897 631.03 267.21
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 3,250 0.90 0.38
application wait time 4 0.00 0.00
background checkpoints completed 1 0.00 0.00
background checkpoints started 1 0.00 0.00
background timeouts 14,798 4.11 1.74
branch node splits 1 0.00 0.00
buffer is not pinned count 134,809,194 37,427.13 15,848.72
buffer is pinned count 240,885,910 66,877.25 28,319.53
bytes received via SQL*Net from client 222,169,324 61,680.96 26,119.13
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 682,193,954 189,397.78 80,201.50
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 1,578,824 438.33 185.61
calls to kcmgas 87,857 24.39 10.33
calls to kcmgcs 1,547 0.43 0.18
change write time 173 0.05 0.02
cleanout - number of ktugct calls 4,104 1.14 0.48
cleanouts and rollbacks - consistent read gets 1,990 0.55 0.23
cleanouts only - consistent read gets 802 0.22 0.09
cluster key scan block gets 667,897 185.43 78.52
cluster key scans 441,571 122.59 51.91
cluster wait time 470,909 130.74 55.36
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 14 0.00 0.00
commit batch/immediate requested 14 0.00 0.00
commit cleanout failures: block lost 406 0.11 0.05
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 415 0.12 0.05
commit cleanout failures: cannot pin 1 0.00 0.00
commit cleanouts 33,226 9.22 3.91
commit cleanouts successfully completed 32,404 9.00 3.81
commit immediate performed 14 0.00 0.00
commit immediate requested 14 0.00 0.00
commit txn count during cleanout 3,624 1.01 0.43
concurrency wait time 3,185 0.88 0.37
consistent changes 17,882 4.96 2.10
consistent gets 165,486,127 45,943.98 19,455.22
consistent gets - examination 98,406,032 27,320.51 11,569.01
consistent gets direct 11,996 3.33 1.41
consistent gets from cache 165,474,168 45,940.66 19,453.82
current blocks converted for CR 42 0.01 0.00
cursor authentications 8,280 2.30 0.97
data blocks consistent reads - undo records applied 5,938 1.65 0.70
db block changes 331,446 92.02 38.97
db block gets 516,955 143.52 60.78
db block gets direct 77 0.02 0.01
db block gets from cache 516,881 143.50 60.77
deferred (CURRENT) block cleanout applications 11,631 3.23 1.37
dirty buffers inspected 5,624 1.56 0.66
enqueue conversions 4,915 1.36 0.58
enqueue releases 421,460 117.01 49.55
enqueue requests 421,567 117.04 49.56
enqueue timeouts 114 0.03 0.01
enqueue waits 2,091 0.58 0.25
exchange deadlocks 28 0.01 0.00
execute count 1,280,367 355.47 150.53
free buffer inspected 677,442 188.08 79.64
free buffer requested 702,743 195.10 82.62
gc CPU used by this session 13,212 3.67 1.55
gc cr block build time 41 0.01 0.00
gc cr block flush time 190,923 53.01 22.45
gc cr block receive time 239,270 66.43 28.13
gc cr block send time 78 0.02 0.01
gc cr blocks received 25,876 7.18 3.04
gc cr blocks served 26,824 7.45 3.15
gc current block flush time 3 0.00 0.00
gc current block pin time 440 0.12 0.05
gc current block receive time 7,928 2.20 0.93
gc current block send time 3,009 0.84 0.35
gc current blocks received 197,578 54.85 23.23
gc current blocks served 1,071,643 297.52 125.99
gc local grants 224,169 62.24 26.35
gc remote grants 244,157 67.79 28.70
gcs messages sent 866,739 240.63 101.90
ges messages sent 32,920 9.14 3.87
global enqueue get time 5,408 1.50 0.64
global enqueue gets async 6,224 1.73 0.73
global enqueue gets sync 225,535 62.62 26.51
global enqueue releases 226,209 62.80 26.59
heap block compress 2,316 0.64 0.27
hot buffers moved to head of LRU 904,471 251.11 106.33
immediate (CR) block cleanout applications 2,792 0.78 0.33
immediate (CURRENT) block cleanout applications 2,164 0.60 0.25
index crx upgrade (found) 14 0.00 0.00
index crx upgrade (positioned) 167,103 46.39 19.65
index fast full scans (full) 103 0.03 0.01
index fetch by key 53,369,034 14,816.87 6,274.28
index scans kdiixs1 10,816,949 3,003.11 1,271.68
leaf node 90-10 splits 89 0.02 0.01
leaf node splits 322 0.09 0.04
lob reads 15,986 4.44 1.88
lob writes 361 0.10 0.04
lob writes unaligned 361 0.10 0.04
logons cumulative 474 0.13 0.06
messages received 28,097 7.80 3.30
messages sent 28,065 7.79 3.30
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 65,853,142 18,282.83 7,741.96
opened cursors cumulative 493,108 136.90 57.97
parse count (failures) 111 0.03 0.01
parse count (hard) 11,297 3.14 1.33
parse count (total) 432,055 119.95 50.79
parse time cpu 11,145 3.09 1.31
parse time elapsed 31,033 8.62 3.65
physical read IO requests 460,746 127.92 54.17
physical read bytes 3,924,451,328 1,089,547.00 461,374.48
physical read total IO requests 481,060 133.56 56.56
physical read total bytes 5,331,146,240 1,480,088.28 626,751.26
physical read total multi block requests 11,448 3.18 1.35
physical reads 479,052 133.00 56.32
physical reads cache 463,348 128.64 54.47
physical reads cache prefetch 22,991 6.38 2.70
physical reads direct 15,711 4.36 1.85
physical reads direct (lob) 11,976 3.32 1.41
physical reads direct temporary tablespace 3,643 1.01 0.43
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 14,375 3.99 1.69
physical write bytes 179,126,272 49,730.90 21,058.81
physical write total IO requests 25,714 7.14 3.02
physical write total bytes 511,711,232 142,066.60 60,158.86
physical write total multi block requests 7,635 2.12 0.90
physical writes 21,866 6.07 2.57
physical writes direct 3,772 1.05 0.44
physical writes direct (lob) 26 0.01 0.00
physical writes direct temporary tablespace 3,660 1.02 0.43
physical writes from cache 18,094 5.02 2.13
physical writes non checkpoint 19,073 5.30 2.24
pinned buffers inspected 4,890 1.36 0.57
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 30 0.01 0.00
process last non-idle time 3,615 1.00 0.42
queries parallelized 176 0.05 0.02
recursive calls 1,981,997 550.26 233.01
recursive cpu usage 31,301 8.69 3.68
redo blocks written 111,339 30.91 13.09
redo buffer allocation retries 4 0.00 0.00
redo entries 178,103 49.45 20.94
redo log space requests 4 0.00 0.00
redo log space wait time 0 0.00 0.00
redo ordering marks 2,797 0.78 0.33
redo size 53,465,220 14,843.57 6,285.59
redo subscn max counts 773 0.21 0.09
redo synch time 241,095 66.94 28.34
redo synch writes 4,908 1.36 0.58
redo wastage 1,590,176 441.48 186.95
redo write time 28,184 7.82 3.31
redo writer latching time 0 0.00 0.00
redo writes 6,626 1.84 0.78
rollback changes - undo records applied 1,036 0.29 0.12
rollbacks only - consistent read gets 308 0.09 0.04
rows fetched via callback 40,056,600 11,120.93 4,709.22
session connect time 19,711 5.47 2.32
session cursor cache hits 218,394 60.63 25.68
session logical reads 166,003,102 46,087.51 19,516.00
session pga memory 811,105,184 225,187.46 95,356.83
session pga memory max 1,556,249,504 432,062.18 182,959.03
session uga memory 8,098,640 2,248.43 952.11
session uga memory max 1,120,574,400 311,105.52 131,739.29
shared hash latch upgrades - no wait 1,094,960 303.99 128.73
shared hash latch upgrades - wait 77 0.02 0.01
sorts (memory) 321,777 89.34 37.83
sorts (rows) 25,544,782 7,092.01 3,003.15
sql area evicted 11,376 3.16 1.34
sql area purged 125 0.03 0.01
summed dirty queue length 24,872 6.91 2.92
switch current to new buffer 7,870 2.18 0.93
table fetch by rowid 148,155,717 41,132.53 17,417.79
table fetch continued row 3,111,162 863.75 365.76
table scan blocks gotten 5,612,861 1,558.30 659.87
table scan rows gotten 484,441,838 134,495.78 56,952.96
table scans (long tables) 9 0.00 0.00
table scans (short tables) 119,935 33.30 14.10
total number of times SMON posted 592 0.16 0.07
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 14 0.00 0.00
transaction tables consistent read rollbacks 1 0.00 0.00
transaction tables consistent reads - undo records applied 815 0.23 0.10
undo change vector size 20,217,632 5,613.03 2,376.87
user I/O wait time 422,047 117.17 49.62
user calls 2,254,185 625.83 265.01
user commits 4,829 1.34 0.57
user rollbacks 3,677 1.02 0.43
workarea executions - onepass 16 0.00 0.00
workarea executions - optimal 291,129 80.83 34.23
write clones created in foreground 0 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 29,016 31,460
opened cursors current 11,233 10,949
logons current 192 185

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 1 1.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Back to Top

Tablespace IO Stats

TablespaceReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
ZL9EXPENSE 135,672 38 6.90 1.01 1,143 0 1 0.00
ZL9MEDLST 104,351 29 4.65 1.00 1,042 0 362 928.29
ZL9INDEXHIS 65,193 18 6.31 1.00 2,256 1 332 975.78
ZL9CISREC 46,586 13 13.35 1.00 3,687 1 823 942.43
ZL9EPRDAT 30,728 9 14.95 1.00 1,798 0 54 895.93
ZL9PATIENT 16,268 5 10.52 1.01 530 0 563 939.02
ZL9INDEXCIS 11,632 3 20.79 1.00 1,421 0 28 986.79
ZL9BASEITEM 11,277 3 1.91 1.43 353 0 111 912.25
SYSTEM 11,115 3 19.00 1.33 202 0 0 0.00
ZL9HISTORY 8,560 2 2.91 1.00 2 0 0 0.00
ZLTOOLSTBS 7,077 2 2.10 1.04 63 0 186 842.31
ZL9DUEREC 4,570 1 1.54 1.00 1 0 0 0.00
SYSAUX 2,407 1 2.89 1.03 395 0 0 0.00
USERS 1,176 0 83.60 1.01 309 0 70 941.29
ZL9EPRLOB 1,092 0 254.97 1.00 189 0 0 0.00
ZL9DEVUSE 825 0 2.35 6.38 1 0 0 0.00
UNDOTBS2 313 0 4.89 1.00 434 0 12 0.00
TEMP 382 0 2.15 9.98 364 0 0 0.00
ZL9INDEXMDR 573 0 6.21 1.00 86 0 0 0.00
ZL9INDEXMTL 346 0 5.23 1.00 50 0 0 0.00
UNDOTBS1 127 0 7.32 1.00 1 0 0 0.00
ZL9MTLREC 110 0 3.55 1.12 15 0 0 0.00
ZL9MEDDAY 106 0 4.62 1.00 7 0 0 0.00
ZL9INDEXIFT 71 0 3.38 1.00 1 0 0 0.00
ZL9INDEXDEV 51 0 2.75 1.51 1 0 0 0.00
ZL9MTLBASE 20 0 5.00 2.45 1 0 0 0.00
ZL9BLOODDATA 19 0 5.79 1.00 1 0 0 0.00
ZL9DEVBASE 10 0 2.00 4.50 1 0 0 0.00
ZL9PEISDATA 9 0 2.22 1.00 1 0 0 0.00
ZL9OPSDATA 8 0 2.50 1.00 1 0 0 0.00
ZL9I_MANAGER 4 0 5.00 1.00 1 0 0 0.00
ZL9MEDBASE 4 0 0.00 2.00 1 0 0 0.00
ZLBAK2010 4 0 2.50 1.00 1 0 0 0.00
ZL9CISAUDIT 2 0 0.00 1.00 1 0 0 0.00
ZL9DEVREC 2 0 0.00 1.00 1 0 0 0.00
ZL9IFTBASE 2 0 0.00 1.00 1 0 0 0.00
ZL9IFTREC 2 0 0.00 1.00 1 0 0 0.00
ZL9MEDREC 2 0 0.00 1.00 1 0 0 0.00
ZLBAK2008 2 0 0.00 1.00 1 0 0 0.00
ZLBAK20081 2 0 0.00 1.00 1 0 0 0.00
ZLBAKHIS 2 0 0.00 1.00 1 0 0 0.00
ZLBAKPEIS 2 0 0.00 1.00 1 0 0 0.00
ZLBAKPEISBAK 2 0 0.00 1.00 1 0 0 0.00
INDX 1 0 0.00 1.00 1 0 0 0.00
ZL9INDEXHISTORY 1 0 0.00 1.00 1 0 0 0.00
ZLTOOLSTMP 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

File IO Stats

TablespaceFilenameReadsAv Reads/sAv Rd(ms)Av Blks/RdWritesAv Writes/sBuffer WaitsAv Buf Wt(ms)
INDX +DATA/orcl/indx01.dbf 1 0 0.00 1.00 1 0 0 0.00
SYSAUX +DATA/orcl/sysaux01.dbf 2,407 1 2.89 1.03 395 0 0 0.00
SYSTEM +DATA/orcl/system01.dbf 11,115 3 19.00 1.33 202 0 0 0.00
TEMP +DATA/orcl/temp02.dbf 382 0 2.15 9.98 364 0 0  
UNDOTBS1 +DATA/orcl/undotbs01.dbf 127 0 7.32 1.00 1 0 0 0.00
UNDOTBS2 +DATA/orcl/undotbs02.dbf 313 0 4.89 1.00 434 0 12 0.00
USERS +DATA/orcl/users01.dbf 1,176 0 83.60 1.01 309 0 70 941.29
ZL9BASEITEM +DATA/orcl/zl9baseitem01.dbf 11,277 3 1.91 1.43 353 0 111 912.25
ZL9BLOODDATA +DATA/orcl/zl9blooddata.dbf 19 0 5.79 1.00 1 0 0 0.00
ZL9CISAUDIT +DATA/orcl/zl9cisaudit01.dbf 2 0 0.00 1.00 1 0 0 0.00
ZL9CISREC +DATA/orcl/zl9cisrec01.dbf 43,177 12 13.92 1.00 3,366 1 820 945.88
ZL9CISREC +DATA/orcl/zl9cisrec02.dbf 3,409 1 6.16 1.00 321 0 3 0.00
ZL9DEVBASE +DATA/orcl/zl9devbase.dbf 10 0 2.00 4.50 1 0 0 0.00
ZL9DEVREC +DATA/orcl/zl9devrec.dbf 2 0 0.00 1.00 1 0 0 0.00
ZL9DEVUSE +DATA/orcl/zl9devuse.dbf 825 0 2.35 6.38 1 0 0 0.00
ZL9DUEREC +DATA/orcl/zl9duerec01.dbf 4,570 1 1.54 1.00 1 0 0 0.00
ZL9EPRDAT +DATA/orcl/zl9eprdat01.dbf 28,444 8 15.78 1.00 1,786 0 54 895.93
ZL9EPRDAT +DATA/orcl/zl9eprdat02.dbf 2,284 1 4.53 1.01 12 0 0 0.00
ZL9EPRLOB +DATA/orcl/zl9eprlob01.dbf 857 0 322.96 1.00 172 0 0 0.00
ZL9EPRLOB +DATA/orcl/zl9eprlob02.dbf 235 0 7.02 1.00 17 0 0 0.00
ZL9EXPENSE +DATA/orcl/zl9expense01.dbf 135,672 38 6.90 1.01 1,143 0 1 0.00
ZL9HISTORY +DATA/orcl/zl9history01.dbf 834 0 4.11 1.00 1 0 0 0.00
ZL9HISTORY +DATA/orcl/zl9history02.dbf 7,726 2 2.79 1.00 1 0 0 0.00
ZL9IFTBASE +DATA/orcl/zl9iftbase01.dbf 2 0 0.00 1.00 1 0 0 0.00
ZL9IFTREC +DATA/orcl/zl9iftrec01.dbf 2 0 0.00 1.00 1 0 0 0.00
ZL9INDEXCIS +DATA/orcl/zl9indexcis01.dbf 5,435 2 4.49 1.00 1,266 0 28 986.79
ZL9INDEXCIS +DATA/orcl/zl9indexcis02.dbf 6,197 2 35.08 1.00 155 0 0 0.00
ZL9INDEXDEV +DATA/orcl/zl9indexdev.dbf 51 0 2.75 1.51 1 0 0 0.00
ZL9INDEXHIS +DATA/orcl/zl9indexhis01.dbf 64,832 18 6.31 1.00 2,239 1 332 975.78
ZL9INDEXHIS +DATA/orcl/zl9indexhis02.dbf 361 0 6.29 1.00 17 0 0 0.00
ZL9INDEXHISTORY +DATA/orcl/zl9indexhistory01.dbf 1 0 0.00 1.00 1 0 0 0.00
ZL9INDEXIFT +DATA/orcl/zl9indexift01.dbf 71 0 3.38 1.00 1 0 0 0.00
ZL9INDEXMDR +DATA/orcl/zl9indexmdr.dbf 573 0 6.21 1.00 86 0 0 0.00
ZL9INDEXMTL +DATA/orcl/zl9indexmtl.dbf 346 0 5.23 1.00 50 0 0 0.00
ZL9I_MANAGER +DATA/orcl/zl9i_manager.dbf 4 0 5.00 1.00 1 0 0 0.00
ZL9MEDBASE +DATA/orcl/zl9medbase.dbf 4 0 0.00 2.00 1 0 0 0.00
ZL9MEDDAY +DATA/orcl/zl9medday.dbf 106 0 4.62 1.00 7 0 0 0.00
ZL9MEDLST +DATA/orcl/zl9medlst01.dbf 103,122 29 4.65 1.00 477 0 362 928.29
ZL9MEDLST +DATA/orcl/zl9medlst02.dbf 1,229 0 4.52 1.00 565 0 0 0.00
ZL9MEDREC +DATA/orcl/zl9medrec.dbf 2 0 0.00 1.00 1 0 0 0.00
ZL9MTLBASE +DATA/orcl/zl9mtlbase.dbf 20 0 5.00 2.45 1 0 0 0.00
ZL9MTLREC +DATA/orcl/zl9mtlrec.dbf 110 0 3.55 1.12 15 0 0 0.00
ZL9OPSDATA +DATA/orcl/zl9opsdata.dbf 8 0 2.50 1.00 1 0 0 0.00
ZL9PATIENT +DATA/orcl/zl9patient01.dbf 16,268 5 10.52 1.01 530 0 563 939.02
ZL9PEISDATA +DATA/orcl/zl9peisdata01.dbf 9 0 2.22 1.00 1 0 0 0.00
ZLBAK2008 +DATA/orcl/zlbak200801.dbf 2 0 0.00 1.00 1 0 0 0.00
ZLBAK20081 +DATA/orcl/zlbak2008101.dbf 2 0 0.00 1.00 1 0 0 0.00
ZLBAK2010 +DATA/orcl/zlbak2010.dbf 4 0 2.50 1.00 1 0 0 0.00
ZLBAKHIS +DATA/orcl/zlbakhis01.dbf 2 0 0.00 1.00 1 0 0 0.00
ZLBAKPEIS +DATA/orcl/zlbakpeis01.dbf 2 0 0.00 1.00 1 0 0 0.00
ZLBAKPEISBAK +DATA/orcl/zlbakpeisbak.dbf 2 0 0.00 1.00 1 0 0 0.00
ZLTOOLSTBS +DATA/orcl/zltoolstbs01.dbf 7,077 2 2.10 1.04 63 0 186 842.31
ZLTOOLSTMP +DATA/orcl/zltoolstmp01.dbf 1 0 0.00 1.00 1 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 211,090 100 165,957,377 463,342 18,094 0 0 2,542


Back to Top

Advisory Statistics

Back to Top

Instance Recovery Stats

Targt MTTR (s) Estd MTTR (s)Recovery Estd IOsActual Redo BlksTarget Redo BlksLog File Size Redo BlksLog Ckpt Timeout Redo BlksLog Ckpt Interval Redo Blks
B 0 3 1498 13647 54944 1105920 54944  
E 0 4 1594 11223 55356 1105920 55356  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 176 0.10 21,109 5.35 37,784,838
D 352 0.20 42,218 4.15 29,311,858
D 528 0.30 63,327 3.22 22,699,012
D 704 0.40 84,436 2.51 17,711,391
D 880 0.50 105,545 2.00 14,079,631
D 1,056 0.60 126,654 1.63 11,533,278
D 1,232 0.70 147,763 1.38 9,713,440
D 1,408 0.80 168,872 1.20 8,474,397
D 1,584 0.90 189,981 1.08 7,628,137
D 1,760 1.00 211,090 1.00 7,056,721
D 1,936 1.10 232,199 0.95 6,678,314
D 2,112 1.20 253,308 0.90 6,346,525
D 2,288 1.30 274,417 0.85 6,029,828
D 2,464 1.40 295,526 0.81 5,739,975
D 2,640 1.50 316,635 0.78 5,479,953
D 2,816 1.60 337,744 0.74 5,230,199
D 2,992 1.70 358,853 0.70 4,967,636
D 3,168 1.80 379,962 0.67 4,699,443
D 3,344 1.90 401,071 0.63 4,433,309
D 3,520 2.00 422,180 0.59 4,167,563

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
99.40 16,168 98

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 2,048 1,149 1,517.66 0.87 0.06 100.00 0.00 209,710
E 2,048 1,162 1,447.18 0.00 0.00 0.00 0.00 209,710

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 271,219 271,219 0 0
64K 128K 2,269 2,269 0 0
128K 256K 1,871 1,871 0 0
256K 512K 647 647 0 0
512K 1024K 9,160 9,160 0 0
1M 2M 5,911 5,911 0 0
2M 4M 48 44 4 0
4M 8M 10 4 6 0
8M 16M 9 3 6 0
32M 64M 1 1 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
256 0.13 197,791.69 6,851.46 97.00 1,223
512 0.25 197,791.69 6,057.51 97.00 1,079
1,024 0.50 197,791.69 163.74 100.00 0
1,536 0.75 197,791.69 163.74 100.00 0
2,048 1.00 197,791.69 163.74 100.00 0
2,458 1.20 197,791.69 0.00 100.00 0
2,867 1.40 197,791.69 0.00 100.00 0
3,277 1.60 197,791.69 0.00 100.00 0
3,686 1.80 197,791.69 0.00 100.00 0
4,096 2.00 197,791.69 0.00 100.00 0
6,144 3.00 197,791.69 0.00 100.00 0
8,192 4.00 197,791.69 0.00 100.00 0
12,288 6.00 197,791.69 0.00 100.00 0
16,384 8.00 197,791.69 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
848 0.37 272 19,639 186,742 0.59 130,361 53.04 19,274,632
1,088 0.48 501 24,456 224,260 0.71 92,843 37.77 19,323,175
1,328 0.58 740 30,117 255,505 0.81 61,598 25.06 19,363,554
1,568 0.69 978 35,321 281,870 0.90 35,233 14.33 19,389,528
1,808 0.79 1,216 40,646 298,175 0.95 18,928 7.70 19,405,647
2,048 0.90 1,455 47,082 308,509 0.98 8,594 3.50 19,415,952
2,288 1.00 1,693 53,380 314,645 1.00 2,458 1.00 19,422,915
2,528 1.10 1,930 58,863 318,145 1.01 1 0.00 19,427,839
2,768 1.21 2,169 64,538 320,081 1.02 1 0.00 19,431,526
3,008 1.31 2,408 69,814 321,113 1.02 1 0.00 19,434,380
3,248 1.42 2,647 76,113 321,637 1.02 1 0.00 19,436,744
3,488 1.52 2,886 83,154 321,889 1.02 1 0.00 19,438,689
3,728 1.63 3,125 88,772 322,005 1.02 1 0.00 19,440,355
3,968 1.73 3,363 94,446 322,056 1.02 1 0.00 19,441,823
4,208 1.84 3,602 101,097 322,079 1.02 1 0.00 19,443,099
4,448 1.94 3,841 107,617 322,090 1.02 1 0.00 19,444,246
4,688 2.05 4,080 114,056 322,096 1.02 1 0.00 19,445,197

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,048 0.50 190,205 17,709,899
3,072 0.75 105,989 9,712,996
4,096 1.00 74,819 7,056,299
5,120 1.25 63,641 5,479,922
6,144 1.50 56,376 4,167,450
7,168 1.75 56,376 4,167,450
8,192 2.00 56,376 4,167,450

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 2,530 2,364 934
undo header 10 0 0
undo block 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
SQ-Sequence Cache 165 165 0 2 24 12,050.00
XR-Quiesce / Force Logging (database force logging) 1,107 1,107 0 1,107 1 0.46
PS-PX Process Reservation 1,406 1,376 30 515 0 0.58
CF-Controlfile Transaction 8,524 8,440 84 285 0 0.70
TX-Transaction (index contention) 20 20 0 14 0 3.57
TT-Tablespace 650 650 0 49 0 0.41
HW-Segment High Water Mark 606 606 0 6 0 3.33
FB-Format Block 64 64 0 24 0 0.42
TM-DML 34,052 34,052 0 20 0 0.50
TA-Instance Undo 22 22 0 18 0 0.56
TD-KTF map table enqueue (KTF dump entries) 11 11 0 11 0 0.00
WF-AWR Flush 35 35 0 10 0 0.00
PI-Remote PX Process Spawn Status 19 19 0 8 0 0.00
PE-Parameter 517 517 0 6 0 0.00
PG-Global Parameter 18 18 0 6 0 0.00
TO-Temp Object 302 302 0 4 0 0.00
DR-Distributed Recovery 2 2 0 2 0 0.00
IR-Instance Recovery 17 17 0 2 0 0.00
JS-Job Scheduler (job run lock - synchronize) 2 2 0 2 0 0.00
CT-Block Change Tracking (state) 1 1 0 1 0 0.00
TX-Transaction (row lock contention) 1 1 0 1 0 0.00
TX-Transaction (allocate ITL entry) 1 1 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 TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
5 3.41 7,686 667 10 16.0833333333333333333333333333333333333/26.15 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

End TimeNum Undo BlocksNumber of TransactionsMax Qry Len (s)Max Tx ConcyTun Ret (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
31-7月 10:02 515 990 138 7 17 0/0 0/0/0/0/0/0
31-7月 09:52 402 1,128 130 4 17 0/0 0/0/0/0/0/0
31-7月 09:42 438 1,096 667 4 26 0/0 0/0/0/0/0/0
31-7月 09:32 425 979 181 3 18 0/0 0/0/0/0/0/0
31-7月 09:22 432 993 148 3 17 0/0 0/0/0/0/0/0
31-7月 09:12 503 1,112 107 10 18 0/0 0/0/0/0/0/0
31-7月 09:02 692 1,388 64 4 16 0/0 0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Back to Top

Latch Activity

Latch NameGet RequestsPct Get MissAvg Slps /MissWait Time (s)NoWait RequestsPct NoWait Miss
ASM allocation 336 0.00   0 0  
ASM db client latch 2,343 0.00   0 0  
ASM map headers 191 0.00   0 0  
ASM map load waiting list 42 0.00   0 0  
ASM map operation freelist 788 0.00   0 0  
ASM map operation hash table 1,123,956 0.00   0 0  
ASM network background latch 1,662 0.00   0 0  
AWR Alerted Metric Element list 31,595 0.00   0 0  
Consistent RBA 6,619 0.02 0.00 0 0  
FAL request queue 98 0.00   0 0  
FAL subheap alocation 98 0.00   0 0  
FIB s.o chain latch 52 0.00   0 0  
FOB s.o list latch 3,751 0.03 0.00 0 0  
JS broadcast add buf latch 771 0.00   0 0  
JS broadcast drop buf latch 771 0.00   0 0  
JS broadcast load blnc latch 669 0.00   0 0  
JS mem alloc latch 4 0.00   0 0  
JS queue access latch 4 0.00   0 0  
JS queue state obj latch 24,262 0.00   0 0  
JS slv state obj latch 11 0.00   0 0  
KCL gc element parent latch 4,842,070 0.02 0.07 0 237,529 0.24
KFK SGA context latch 841 0.00   0 0  
KFMD SGA 244 0.00   0 0  
KJC message pool free list 37,080 0.09 0.00 0 12,912 0.00
KJCT flow control latch 1,110,958 0.00 0.09 0 0  
KMG MMAN ready and startup request latch 6,704 0.00   0 0  
KMG resize request state object freelist 18 0.00   0 0  
KTF sga latch 22 0.00   0 905 0.00
KWQMN job cache list latch 603 0.00   0 0  
LGWR NS Write 1,675 0.00   0 0  
MQL Tracking Latch 0     0 68 0.00
Memory Management Latch 5,733 0.03 1.00 0 6,704 0.00
OS process 570 0.00   0 0  
OS process allocation 1,577 0.00   0 0  
OS process: request allocation 304 0.00   0 0  
PL/SQL warning settings 3,022 0.00   0 0  
SGA IO buffer pool latch 786 0.00   0 786 0.00
SQL memory manager latch 1 0.00   0 1,107 0.00
SQL memory manager workarea list latch 265,171 0.00   0 0  
Shared B-Tree 119 0.00   0 0  
active checkpoint queue latch 9,840 0.02 0.00 0 0  
active service list 9,331 0.01 1.00 0 1,934 0.00
archive control 228 0.00   0 0  
archive process latch 1,308 0.00   0 0  
begin backup scn array 31 0.00   0 0  
buffer pool 190 0.00   0 0  
business card 352 0.00   0 0  
cache buffer handles 318,172 0.01 0.00 0 0  
cache buffers chains 237,123,899 0.06 0.00 0 2,802,389 0.00
cache buffers lru chain 604,376 0.06 0.03 0 1,574,711 0.03
cache table scan latch 0     0 4,768 0.00
channel handle pool latch 1,158 0.09 0.00 0 0  
channel operations parent latch 479,852 0.02 0.03 0 0  
checkpoint queue latch 256,416 0.02 0.00 0 70,713 0.06
client/application info 2,342 0.00   0 0  
commit callback allocation 422 0.00   0 0  
compile environment latch 480 0.00   0 0  
constraint object allocation 54 0.00   0 0  
dml lock allocation 63,443 0.00 0.00 0 0  
dummy allocation 967 0.00   0 0  
enqueue hash chains 922,088 0.00 0.00 0 4,430 0.00
enqueues 1,046,924 0.01 0.03 0 0  
error message lists 869 0.00   0 0  
event group latch 150 0.00   0 0  
file cache latch 990 0.00   0 0  
gcs opaque info freelist 477,968 0.00 0.20 0 0  
gcs partitioned table hash 6,690,148 0.00   0 0  
gcs remastering latch 517,580 0.00   0 0  
gcs resource freelist 516,689 0.00 0.44 0 266,714 0.00
gcs resource hash 3,866,076 0.00 0.06 0 43 0.00
gcs resource scan list 86 0.00   0 0  
gcs shadows freelist 405,537 0.00 0.00 0 400,126 0.00
ges caches resource lists 150,041 0.01 0.00 0 74,654 0.01
ges deadlock list 10,042 0.00   0 15 0.00
ges domain table 448,397 0.00   0 0  
ges enqueue table freelist 470,325 0.00 0.00 0 0  
ges group table 669,160 0.00 0.00 0 0  
ges process hash list 16,042 0.00   0 0  
ges process parent latch 949,120 0.00   0 0  
ges process table freelist 304 0.00   0 0  
ges resource hash list 748,579 0.01 0.70 0 37,635 0.00
ges resource scan list 214 0.00   0 0  
ges resource table freelist 60,511 0.00   0 0  
ges synchronous data 32 0.00   0 2,509 0.08
ges timeout list 5,712 0.00   0 6,669 0.00
global KZLD latch for mem in SGA 133 0.00   0 0  
hash table column usage latch 936 0.21 0.00 0 4,546,076 0.00
hash table modification latch 95 0.00   0 0  
internal temp table object number allocation latc 14 0.00   0 0  
job workq parent latch 0     0 4 0.00
job_queue_processes parameter latch 58 0.00   0 0  
kks stats 45,154 0.02 0.00 0 0  
kokc descriptor allocation latch 1,292 0.08 1.00 0 0  
ksuosstats global area 242 0.00   0 0  
ksv instance 1 0.00   0 0  
ktm global data 603 0.00   0 0  
kwqbsn:qsga 119 0.00   0 0  
lgwr LWN SCN 7,504 0.00   0 0  
library cache 3,772,532 0.01 0.12 1 39,606 3.51
library cache load lock 5,242 0.00   0 0  
library cache lock 1,989,008 0.01 0.03 0 0  
library cache lock allocation 33,307 0.00 0.00 0 0  
library cache pin 1,144,958 0.00 0.00 0 4 0.00
library cache pin allocation 20,800 0.00   0 0  
list of block allocation 1,050 0.00   0 0  
loader state object freelist 19,620 0.00   0 0  
longop free list parent 3 0.00   0 3 0.00
message pool operations parent latch 3,919 0.00   0 0  
messages 209,436 0.01 0.03 0 0  
mostly latch-free SCN 7,837 2.41 0.00 0 0  
msg queue 55 0.00   0 55 0.00
multiblock read objects 120,342 0.00   0 0  
name-service memory objects 28,313 0.00   0 0  
name-service namespace bucket 37,809 0.00   0 0  
name-service pending queue 13,934 0.00   0 0  
name-service request 42 0.00   0 0  
name-service request queue 50,850 0.00   0 0  
ncodef allocation latch 93 0.00   0 0  
object queue header heap 36,255 0.00   0 6,851 0.00
object queue header operation 1,474,511 0.00 0.00 0 46,983 0.06
object stats modification 620 0.00   0 0  
parallel query alloc buffer 5,305 0.00   0 0  
parallel query stats 860 0.00   0 0  
parallel txn reco latch 1,408 0.00   0 0  
parameter list 1,228 0.00   0 0  
parameter table allocation management 3,542 0.00   0 0  
post/wait queue 47,785 0.03 0.00 0 45,020 0.01
process allocation 22,931 0.00   0 150 0.00
process group creation 304 0.00   0 0  
process queue 2,388 0.00   0 0  
process queue reference 115,717 0.00 0.00 0 16,049 0.16
qmn state object latch 8 0.00   0 0  
qmn task queue latch 502 0.00   0 0  
query server freelists 1,900 0.00   0 0  
query server process 9 0.00   0 6 0.00
queued dump request 17,850 0.00   0 0  
redo allocation 21,706 0.03 0.14 0 178,130 0.03
redo copy 0     0 178,149 0.13
redo writing 32,122 0.01 0.00 0 0  
resmgr group change latch 552 0.00   0 0  
resmgr:active threads 956 0.00   0 0  
resmgr:actses change group 459 0.00   0 0  
resmgr:free threads list 955 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 13,631,720 0.03 0.00 0 9,435 0.12
rules engine aggregate statistics 30 0.00   0 0  
rules engine rule set statistics 60 0.00   0 0  
segmented array pool 50 0.00   0 0  
sequence cache 36,646 0.00   0 0  
session allocation 657,555 0.02 0.23 0 0  
session idle bit 4,791,390 0.00 0.04 0 0  
session state list latch 1,398 0.00   0 0  
session switching 93 0.00   0 0  
session timer 1,934 0.00   0 0  
shared pool 1,752,612 0.04 0.05 0 0  
shared pool sim alloc 323 0.00   0 0  
shared pool simulator 2,262,021 0.00 0.07 0 0  
simulator hash latch 11,960,364 0.00 0.00 0 0  
simulator lru latch 1,671 0.06 0.00 0 11,911,807 0.17
slave class 171 0.00   0 0  
slave class create 143 0.70 1.00 0 0  
sort extent pool 2,633 0.34 0.11 0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
temporary table state object allocation 219 0.91 0.00 0 0  
threshold alerts latch 1,157 0.00   0 0  
transaction allocation 399 0.00   0 0  
transaction branch allocation 1,934 0.00   0 0  
undo global data 33,213 0.00   0 0  
user lock 1,281 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 237,123,899 131,182 232 130,945 0 0 0
row cache objects 13,631,720 3,774 12 3,762 0 0 0
KCL gc element parent latch 4,842,070 1,136 80 1,060 0 0 0
shared pool 1,752,612 773 36 738 0 0 0
library cache 3,772,532 485 57 435 0 0 0
cache buffers lru chain 604,376 335 11 324 0 0 0
gcs resource hash 3,866,076 191 11 180 0 0 0
session allocation 657,555 130 30 101 0 0 0
library cache lock 1,989,008 107 3 104 0 0 0
channel operations parent latch 479,852 102 3 99 0 0 0
enqueues 1,046,924 91 3 88 0 0 0
ges resource hash list 748,579 83 58 25 0 0 0
KJCT flow control latch 1,110,958 47 4 43 0 0 0
messages 209,436 30 1 29 0 0 0
shared pool simulator 2,262,021 30 2 28 0 0 0
session idle bit 4,791,390 27 1 26 0 0 0
gcs resource freelist 516,689 9 4 5 0 0 0
sort extent pool 2,633 9 1 8 0 0 0
redo allocation 21,706 7 1 6 0 0 0
gcs opaque info freelist 477,968 5 1 4 0 0 0
Memory Management Latch 5,733 2 2 0 0 0 0
active service list 9,331 1 1 0 0 0 0
kokc descriptor allocation latch 1,292 1 1 0 0 0 0
slave class create 143 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
KCL gc element parent latch kclnfndnewm 0 85 6
KCL gc element parent latch kclevict 0 7 0
KCL gc element parent latch kclulb 0 7 5
KCL gc element parent latch kcl_get_le_latch 0 5 0
KCL gc element parent latch KCLUNLNK 0 3 8
KCL gc element parent latch kclchkping 0 3 0
KCL gc element parent latch kclfwrite1 0 3 2
KCL gc element parent latch kclhngcbk1 0 2 0
KCL gc element parent latch kclrwrite 0 2 3
KCL gc element parent latch kclnfnd 0 1 11
KCL gc element parent latch kclpdcl 0 1 24
KCL gc element parent latch kclwritten 0 1 0
KCL gc element parent latch kclwrt 0 1 0
KJCT flow control latch kjctcsnd: send normal message 0 4 0
Memory Management Latch kmgs_perform_parameter_updates1 0 2 2
active service list ksws_event: ksws event 0 1 1
cache buffers chains kcbgtcr: kslbegin excl 0 415 356
cache buffers chains kcbrls: kslbegin 0 101 182
cache buffers chains kcbgtcr: fast path 0 34 20
cache buffers chains kcbzwb 0 20 18
cache buffers chains kcbzgb: scan from tail. nowait 0 8 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 6 5
cache buffers chains kclwrt 0 4 0
cache buffers chains kcbget: pin buffer 0 3 0
cache buffers chains kcbchg: kslbegin: call CR func 0 2 2
cache buffers chains kcbgcur: kslbegin 0 1 1
cache buffers chains kcbget: exchange rls 0 1 0
cache buffers chains kcbzib: multi-block read: nowait 0 1 0
cache buffers chains kclcls_3 0 1 0
cache buffers lru chain kcbzgws 0 4 0
cache buffers lru chain kcbzgb: wait - one set in buffer pool 0 3 3
cache buffers lru chain kclmvreqbg 0 2 10
cache buffers lru chain kcbo_link_q 0 1 0
cache buffers lru chain kcbw_quiesce_granule 0 1 0
channel operations parent latch ksrwait() 0 3 3
enqueues ksqdel 0 1 0
enqueues ksqgel: create enqueue 0 1 2
enqueues ksqies 0 1 1
gcs opaque info freelist kjbrgrant free opaque info 0 1 0
gcs resource freelist kjbralc add resource 0 4 1
gcs resource hash kjbcropen:affinity 0 5 0
gcs resource hash kjbcropen 0 3 0
gcs resource hash kjbassume 0 2 0
gcs resource hash kclfwrite1 0 1 0
ges resource hash list kjakcai: search for resp by resname 0 39 1
ges resource hash list kjlmfnd: search for lockp by rename and inst id 0 15 1
ges resource hash list kjrmas1: lookup master node 0 3 1
ges resource hash list kjlrlr: remove lock from resource queue 0 1 32
kokc descriptor allocation latch kokcdlt: regular free 0 1 1
library cache kqlmbinv: parent 0 9 0
library cache kglLockCursor 0 7 14
library cache kglScanDependency 0 7 0
library cache kgldti: 2child 0 7 3
library cache kqlmbpil: parent 0 3 0
library cache kgldte: child 0 0 1 13
library cache kglhdgn: child: 0 1 5
library cache kglobpn: child: 0 1 2
library cache kglpndl: child: before processing 0 1 6
library cache kglpnp: child 0 1 6
library cache lock kgllkdl: child: no lock handle 0 5 4
library cache lock kgllkdl: child: cleanup 0 2 2
library cache lock kgllkal: child: multiinstance 0 1 1
messages ksarcv: after wait 0 1 1
object queue header operation kclobj_1 0 2 1
redo allocation kcrfw_redo_gen: redo allocation 1 0 1 0
row cache objects kqreqd: reget 0 8 0
row cache objects kqrpre: find obj 0 2 10
row cache objects kqrbip 0 1 0
row cache objects kqrigt 0 1 0
session allocation ksuxds: KSUSFCLC not set 0 20 3
session allocation kxfpqidqr 0 3 17
session allocation ksufap: active sessions 0 2 0
session allocation ksuxds: not user session 0 2 1
session allocation kspallmod 0 1 0
session allocation ksucri 0 1 6
session allocation ksudlp 0 1 1
session idle bit ksupuc: set busy 0 1 0
shared pool kghalo 0 26 15
shared pool kghfrunp: clatch: nowait 0 11 0
shared pool kghfrunp: alloc: wait 0 6 0
shared pool kghfrunp: clatch: wait 0 3 0
shared pool kghupr1 0 2 15
shared pool kgh: quiesce extents 0 1 0
shared pool kghalp 0 1 3
shared pool simulator kglsim_unpin_simhp 0 2 1
slave class create ksvcreate 0 1 0
sort extent pool ktstdt: dealloc sort extent 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
ZLHIS ZL9INDEXHIS 收费项目目录_PK   INDEX 32,815,280 19.77
ZLHIS ZL9BASEITEM 收费项目目录   TABLE 27,320,896 16.46
ZLHIS ZL9INDEXHIS 诊疗项目目录_PK   INDEX 9,229,040 5.56
ZLHIS ZL9BASEITEM 诊疗项目目录   TABLE 8,829,840 5.32
ZLHIS ZL9BASEITEM 收费价目   TABLE 7,765,408 4.68

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ZLHIS ZL9EXPENSE 住院费用记录 P_ONLINE TABLE PARTITION 116,464 24.31
ZLHIS ZL9MEDLST 药品收发记录 P_ONLINE TABLE PARTITION 101,819 21.25
ZLHIS ZL9INDEXHIS 住院费用记录_PK   INDEX 25,431 5.31
ZLHIS ZL9EXPENSE 门诊费用记录   TABLE 16,342 3.41
ZLHIS ZL9BASEITEM 就诊登记记录   TABLE 13,806 2.88

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
ZLHIS ZL9CISREC 病人医嘱记录_PK   INDEX 56 56.00
ZLHIS ZL9PATIENT 病人信息_PK   INDEX 7 7.00
ZLHIS ZL9EPRDAT 电子病历记录_PK   INDEX 7 7.00
ZLHIS ZL9INDEXCIS 病人医嘱记录_IX_开始执行时间   INDEX 4 4.00
ZLHIS ZL9CISREC 病人医嘱状态_PK   INDEX 3 3.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ZLHIS ZL9INDEXHIS 门诊费用记录_IX_病人ID   INDEX 1 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
ZLHIS ZL9INDEXCIS 病人医嘱记录_IX_开始执行时间   INDEX 28 82.35
ZLHIS ZL9EPRDAT 电子病历内容_PK   INDEX 3 8.82
ZLHIS ZL9CISREC 病人医嘱发送_PK   INDEX 1 2.94
ZLHIS ZL9CISREC 病人医嘱状态   TABLE 1 2.94
ZLHIS ZL9EXPENSE 住院费用记录 P_ONLINE TABLE PARTITION 1 2.94

Back to Segment Statistics
Back to Top

Segments by Global Cache Buffer Busy

OwnerTablespace NameObject NameSubobject NameObj. TypeGC Buffer Busy% of Capture
ZLHIS ZL9PATIENT 病人信息   TABLE 557 28.16
ZLHIS ZL9MEDLST 药品库存   TABLE 362 18.30
ZLHIS ZL9CISREC 病人医嘱记录_PK   INDEX 321 16.23
ZLHIS ZL9CISREC 病人医嘱状态_PK   INDEX 282 14.26
ZLTOOLS ZL9BASEITEM ZLUSERPARAS   TABLE 111 5.61

Back to Segment Statistics
Back to Top

Segments by CR Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCR Blocks Received%Total
ZLHIS ZL9CISREC 病人医嘱记录   TABLE 2,014 7.78
ZLHIS ZL9EXPENSE 住院费用记录 P_ONLINE TABLE PARTITION 1,650 6.38
ZLHIS ZL9MEDLST 药品库存   TABLE 1,453 5.62
ZLHIS ZL9PATIENT 病人信息   TABLE 1,076 4.16
ZLHIS ZL9CISREC 病人医嘱状态_PK   INDEX 1,014 3.92

Back to Segment Statistics
Back to Top

Segments by Current Blocks Received

OwnerTablespace NameObject NameSubobject NameObj. TypeCurrent Blocks Received%Total
ZLHIS ZL9CISREC 检验标本记录   TABLE 36,664 18.56
ZLHIS ZL9EXPENSE 住院费用记录 P_ONLINE TABLE PARTITION 31,159 15.77
ZLHIS ZL9BASEITEM 就诊登记记录   TABLE 25,120 12.71
ZLHIS USERS CQ_保险结算记录   TABLE 22,195 11.23
SYS SYSTEM OBJ$   TABLE 7,351 3.72

Back to Segment Statistics
Back to Top

Dictionary Cache Statistics

Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 69 1.45 0   1 1
dc_database_links 266 0.00 0   0 3
dc_global_oids 6,316 1.09 0   0 382
dc_histogram_data 960,424 0.03 0   0 7,120
dc_histogram_defs 418,267 0.08 0   52 4,969
dc_object_grants 25,464 1.59 0   0 3,032
dc_object_ids 1,245,750 0.01 0   4 2,305
dc_objects 128,031 2.67 0   18 12,524
dc_profiles 131 0.00 0   0 1
dc_rollback_segments 3,867 0.00 0   0 66
dc_segments 309,181 0.04 0   9 2,351
dc_sequences 172 51.16 0   172 20
dc_tablespace_quotas 3 100.00 0   3 3
dc_tablespaces 850,145 0.00 0   0 47
dc_usernames 60,921 0.02 0   0 292
dc_users 1,181,502 0.00 0   7 663
outstanding_alerts 562 94.48 0   30 4

Back to Dictionary Cache Statistics
Back to Top

Dictionary Cache Stats (RAC)

CacheGES RequestsGES ConflictsGES Releases
dc_awr_control 3 1 0
dc_global_oids 69 0 57
dc_histogram_defs 296 0 1,413
dc_object_ids 117 0 400
dc_objects 3,432 78 3,162
dc_segments 133 7 253
dc_sequences 344 89 3
dc_tablespace_quotas 6 1 0
dc_usernames 14 0 19
dc_users 33 7 12
outstanding_alerts 1,101 516 0

Back to Dictionary Cache Statistics
Back to Top

Library Cache Statistics

Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 342 0.00 100,245 0.00 1 0
CLUSTER 90 0.00 100 0.00 0 0
INDEX 23 0.00 66 13.64 9 0
SQL AREA 201,265 5.36 1,760,815 1.77 4,522 3,650
TABLE/PROCEDURE 93,985 2.49 567,694 0.46 1,256 0
TRIGGER 191 0.00 6,817 0.04 3 0

Back to Library Cache Statistics
Back to Top

Library Cache Activity (RAC)

NamespaceGES Lock RequestsGES Pin RequestsGES Pin ReleasesGES Inval RequestsGES Invali- dations
CLUSTER 100 0 0 0 0
INDEX 66 0 4 0 0
TABLE/PROCEDURE 182,011 1,177 457 834 0

Back to Library Cache Statistics
Back to Top

Memory Statistics

Back to Top

Process Memory Summary

CategoryAlloc (MB)Used (MB)Avg Alloc (MB)Std Dev Alloc (MB)Max Alloc (MB)Hist Max Alloc (MB)Num ProcNum Alloc
B Other 1,298.20   6.66 8.38 80 80 195 195
  Freeable 182.44 0.00 1.10 1.12 15   166 166
  SQL 31.43 15.49 0.18 0.08 1 14 171 169
  PL/SQL 5.63 4.29 0.03 0.02 0 0 193 193
E Other 1,235.68   6.47 8.46 80 80 191 191
  Freeable 175.13 0.00 1.09 1.15 15   160 160
  SQL 31.17 15.38 0.19 0.09 1 95 167 162
  PL/SQL 5.30 4.08 0.03 0.02 0 0 189 186

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 1,744,830,464 1,845,493,760
Fixed Size 2,089,432  
Redo Buffers 14,684,160  
Variable Size 2,533,363,240 2,432,699,944

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 32.00 32.00 0.00
large ASM map operations hashta 0.38 0.38 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.60 14.60 0.00
shared CCursor 260.35 244.80 -5.97
shared Heap0: KGL 43.33 42.45 -2.03
shared PCursor 100.15 103.73 3.57
shared free memory 323.15 336.53 4.14
shared gcs resources 41.39 41.39 0.00
shared gcs shadows 23.75 23.75 0.00
shared ges enqueues 30.70 30.70 0.00
shared library cache 129.29 133.53 3.28
shared sql area 1,115.69 1,016.44 -8.90
  buffer_cache 1,664.00 1,760.00 5.77
  fixed_sga 1.99 1.99 0.00
  log_buffer 14.00 14.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

Resource NameCurrent UtilizationMaximum Utilization Initial Allocation Limit
gcs_resources 160,684 212,978 256558 256558
gcs_shadows 179,262 232,772 256558 256558


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
O7_DICTIONARY_ACCESSIBILITY TRUE   
audit_file_dest /u01/app/oracle/admin/orcl/adump   
background_dump_dest /u01/app/oracle/admin/orcl/bdump   
cluster_database TRUE   
cluster_database_instances 2   
compatible 10.2.0.3.0   
control_files +DATA/orcl/control01.ctl, +DATA/orcl/control02.ctl, +DATA/orcl/control03.ctl   
core_dump_dest /u01/app/oracle/admin/orcl/cdump   
db_block_size 8192   
db_domain domain   
db_file_multiblock_read_count 16   
db_name orcl   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
fal_client PRIMARY02   
instance_number 2   
job_queue_processes 10   
local_listener LISTENERS_LOCAL   
log_archive_config DG_CONFIG=(primary, standby)   
log_archive_dest_1 LOCATION=/u01/app/oracle/archive VALID_FOR=(ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=orcl   
log_archive_dest_2 SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME=orcl   
log_archive_dest_3      
log_archive_dest_state_1 ENABLE   
log_archive_dest_state_2 ENABLE   
log_archive_dest_state_3 ENABLE   
log_archive_format %t_%s_%r.dbf   
log_archive_max_processes 4   
nls_language SIMPLIFIED CHINESE   
nls_territory CHINA   
open_cursors 300   
optimizer_index_caching 80   
optimizer_index_cost_adj 20   
optimizer_mode CHOOSE   
pga_aggregate_target 2147483648   
processes 2000   
remote_listener LISTENERS_ORCL   
remote_login_passwordfile EXCLUSIVE   
sessions 2205   
sga_target 4294967296   
spfile +DATA/orcl/spfileorcl.ora   
standby_file_management AUTO   
thread 2   
undo_management AUTO   
undo_tablespace UNDOTBS2   
user_dump_dest /u01/app/oracle/admin/orcl/udump   


Back to Top

Global Enqueue Statistics

StatisticTotalper Secondper Trans
acks for commit broadcast(actual) 8,336 2.31 0.98
acks for commit broadcast(logical) 10,187 2.83 1.20
broadcast msgs on commit(actual) 6,614 1.84 0.78
broadcast msgs on commit(logical) 6,627 1.84 0.78
broadcast msgs on commit(wasted) 331 0.09 0.04
broadcast on commit wait time(ms) 3,247,867 901.71 381.83
broadcast on commit waits 202 0.06 0.02
dynamically allocated gcs resources 0 0.00 0.00
dynamically allocated gcs shadows 0 0.00 0.00
false posts waiting for scn acks 0 0.00 0.00
flow control messages received 0 0.00 0.00
flow control messages sent 1 0.00 0.00
gcs assume cvt 0 0.00 0.00
gcs assume no cvt 134,854 37.44 15.85
gcs ast xid 0 0.00 0.00
gcs blocked converts 9,564 2.66 1.12
gcs blocked cr converts 25,531 7.09 3.00
gcs compatible basts 1,006 0.28 0.12
gcs compatible cr basts (global) 3,623 1.01 0.43
gcs compatible cr basts (local) 227,160 63.07 26.71
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 2,667 0.74 0.31
gcs dbwr write request msgs 2,194 0.61 0.26
gcs error msgs 0 0.00 0.00
gcs forward cr to pinged instance 0 0.00 0.00
gcs immediate (compatible) converts 3,428 0.95 0.40
gcs immediate (null) converts 30,159 8.37 3.55
gcs immediate cr (compatible) converts 313 0.09 0.04
gcs immediate cr (null) converts 360,965 100.21 42.44
gcs indirect ast 248,479 68.99 29.21
gcs lms flush pi msgs 0 0.00 0.00
gcs lms write request msgs 1,522 0.42 0.18
gcs msgs process time(ms) 51,698 14.35 6.08
gcs msgs received 1,832,316 508.71 215.41
gcs out-of-order msgs 2 0.00 0.00
gcs pings refused 317 0.09 0.04
gcs pkey conflicts retry 0 0.00 0.00
gcs queued converts 1 0.00 0.00
gcs recovery claim msgs 0 0.00 0.00
gcs refuse xid 2 0.00 0.00
gcs regular cr 0 0.00 0.00
gcs retry convert request 0 0.00 0.00
gcs side channel msgs actual 24,545 6.81 2.89
gcs side channel msgs logical 441,800 122.66 51.94
gcs stale cr 2 0.00 0.00
gcs undo cr 175 0.05 0.02
gcs write notification msgs 84 0.02 0.01
gcs writes refused 7 0.00 0.00
ges msgs process time(ms) 532 0.15 0.06
ges msgs received 35,035 9.73 4.12
global posts dropped 0 0.00 0.00
global posts queue time 1,824,053 506.41 214.44
global posts queued 28 0.01 0.00
global posts requested 32 0.01 0.00
global posts sent 29 0.01 0.00
implicit batch messages received 56,540 15.70 6.65
implicit batch messages sent 66,055 18.34 7.77
lmd msg send time(ms) 0 0.00 0.00
lms(s) msg send time(ms) 0 0.00 0.00
messages flow controlled 11,343 3.15 1.33
messages queue sent actual 195,699 54.33 23.01
messages queue sent logical 384,490 106.75 45.20
messages received actual 867,498 240.84 101.99
messages received logical 1,867,351 518.43 219.53
messages sent directly 401,586 111.49 47.21
messages sent indirectly 366,236 101.68 43.06
messages sent not implicit batched 129,644 35.99 15.24
messages sent pbatched 133,491 37.06 15.69
msgs causing lmd to send msgs 11,659 3.24 1.37
msgs causing lms(s) to send msgs 11,489 3.19 1.35
msgs received queue time (ms) 16,792 4.66 1.97
msgs received queued 1,867,352 518.43 219.53
msgs sent queue time (ms) 35,439 9.84 4.17
msgs sent queue time on ksxp (ms) 82,868 23.01 9.74
msgs sent queued 383,981 106.60 45.14
msgs sent queued on ksxp 632,868 175.70 74.40
process batch messages received 133,239 36.99 15.66
process batch messages sent 54,919 15.25 6.46


Back to Top

Global CR Served Stats

StatisticTotal
CR Block Requests 25,932
CURRENT Block Requests 896
Data Block Requests 25,932
Undo Block Requests 154
TX Block Requests 364
Current Results 25,691
Private results 127
Zero Results 999
Disk Read Results 10
Fail Results 0
Fairness Down Converts 5,523
Fairness Clears 0
Free GC Elements 0
Flushes 1,364
Flushes Queued 0
Flush Queue Full 0
Flush Max Time (us) 29,397
Light Works 251
Errors 0


Back to Top

Global CURRENT Served Stats

StatisticTotal% <1ms% <10ms% <100ms% <1s% <10s
Pins 1,076,676 100.00 0.00 0.00 0.00 0.00
Flushes 56 67.86 32.14 0.00 0.00 0.00
Writes 3,231 23.03 71.68 3.78 0.65 0.87


Back to Top

Global Cache Transfer Stats

  CR Current
Inst NoBlock Class Blocks Received% Immed% Busy% CongstBlocks Received% Immed% Busy% Congst
1 data block 25,202 95.82 4.18 0.00 197,230 99.98 0.02 0.00
1 Others 205 98.54 1.46 0.00 391 97.95 2.05 0.00
1 undo header 429 97.67 2.33 0.00 8 100.00 0.00 0.00
1 undo block 68 95.59 4.41 0.00 0      


Back to Top

End of Report