WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORAL1090325199oral110.2.0.4.0NOX3850

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:694425-6月 -12 08:00:59237 63.6
End Snap:694525-6月 -12 09:00:30303 63.6
Elapsed:  59.52 (mins)  
DB Time:  834.69 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 576M 576MStd Block Size: 8K
Shared Pool Size: 912M 912MLog Buffer: 4,224K

Load Profile

Per SecondPer Transaction
Redo size: 613,313.94 210,018.06
Logical reads: 135,202.24 46,297.52
Block changes: 5,578.90 1,910.39
Physical reads: 3,451.13 1,181.78
Physical writes: 69.70 23.87
User calls: 1,605.54 549.79
Parses: 129.24 44.26
Hard parses: 7.75 2.65
Sorts: 422.28 144.60
Logons: 0.11 0.04
Executes: 1,335.50 457.32
Transactions: 2.92 

% Blocks changed per Read: 4.13Recursive Call %: 52.56
Rollback per transaction %: 0.69Rows per Sort: 9.71

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.95Redo NoWait %: 99.99
Buffer Hit %: 97.45In-memory Sort %: 100.00
Library Hit %: 98.76Soft Parse %: 94.00
Execute to Parse %: 90.32Latch Hit %: 99.80
Parse CPU to Parse Elapsd %: 14.24% Non-Parse CPU: 95.97

Shared Pool Statistics

BeginEnd
Memory Usage %: 82.53 78.00
% SQL with executions>1: 64.66 77.52
% Memory for SQL w/exec>1: 76.65 80.12

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file sequential read 928,723 21,538 23 43.0User I/O
db file scattered read 790,812 19,056 24 38.1User I/O
read by other session 250,646 4,774 19 9.5User I/O
CPU time  1,633  3.3 
db file parallel write 46,536 1,510 32 3.0System I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 46,366.34 92.58
DB CPU 1,633.02 3.26
parse time elapsed 867.88 1.73
hard parse elapsed time 700.39 1.40
hard parse (sharing criteria) elapsed time 105.53 0.21
hard parse (bind mismatch) elapsed time 98.19 0.20
PL/SQL execution elapsed time 76.64 0.15
PL/SQL compilation elapsed time 33.50 0.07
sequence load elapsed time 5.69 0.01
connection management call elapsed time 4.55 0.01
failed parse elapsed time 1.04 0.00
repeated bind elapsed time 0.13 0.00
RMAN cpu time (backup/restore) 0.02 0.00
DB time 50,081.44  
background elapsed time 4,712.04  
background cpu time 10.06  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
User I/O 1,977,105 0.00 45,588 23 189.58
System I/O 73,452 0.00 4,431 60 7.04
Commit 10,210 0.15 1,346 132 0.98
Application 1,133 34.33 1,180 1042 0.11
Configuration 512 9.38 199 389 0.05
Network 5,851,604 0.00 134 0 561.09
Other 291 1.72 30 102 0.03
Concurrency 5,103 0.57 5 1 0.49

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 928,723 0.00 21,538 23 89.05
db file scattered read 790,812 0.00 19,056 24 75.83
read by other session 250,646 0.00 4,774 19 24.03
db file parallel write 46,536 0.00 1,510 32 4.46
log file sync 10,210 0.15 1,346 132 0.98
log file parallel write 11,629 0.00 1,302 112 1.12
Log archive I/O 2,220 0.00 1,246 561 0.21
enq: TX - row lock contention 399 97.49 1,180 2956 0.04
control file parallel write 2,583 0.00 194 75 0.25
log file switch completion 392 9.18 170 434 0.04
direct path write temp 1,316 0.00 124 94 0.13
SQL*Net more data from client 9,964 0.00 117 12 0.96
log file sequential read 2,413 0.00 104 43 0.23
control file sequential read 7,975 0.00 69 9 0.76
direct path read temp 861 0.00 44 51 0.08
Data file init write 105 0.00 29 278 0.01
direct path write 2,258 0.00 20 9 0.22
log file switch (checkpoint incomplete) 28 42.86 19 680 0.00
enq: CF - contention 55 0.00 17 318 0.01
SQL*Net more data to client 101,866 0.00 14 0 9.77
enq: TX - contention 5 80.00 12 2422 0.00
log buffer space 91 0.00 10 108 0.01
log file single write 96 0.00 6 65 0.01
SQL*Net message to client 5,739,774 0.00 3 0 550.37
direct path read 2,366 0.00 2 1 0.23
buffer busy waits 985 0.10 2 2 0.09
row cache lock 1 0.00 1 1209 0.00
enq: TX - index contention 12 0.00 1 92 0.00
SQL*Net break/reset to client 734 0.00 1 1 0.07
db file parallel read 15 0.00 0 31 0.00
cursor: pin S wait on X 29 96.55 0 13 0.00
db file single write 3 0.00 0 75 0.00
os thread startup 5 0.00 0 41 0.00
latch: shared pool 620 0.00 0 0 0.06
enq: HW - contention 1 0.00 0 169 0.00
library cache load lock 3 0.00 0 27 0.00
latch free 34 0.00 0 1 0.00
rdbms ipc reply 3 0.00 0 10 0.00
latch: cache buffers chains 3,433 0.00 0 0 0.33
latch: library cache 7 0.00 0 0 0.00
LGWR wait for redo copy 192 0.00 0 0 0.02
latch: row cache objects 6 0.00 0 0 0.00
latch: In memory undo latch 2 0.00 0 0 0.00
latch: object queue header operation 1 0.00 0 0 0.00
buffer deadlock 1 100.00 0 0 0.00
SQL*Net message from client 5,739,724 0.00 426,124 74 550.36
Streams AQ: qmn slave idle wait 128 0.00 3,559 27801 0.01
Streams AQ: qmn coordinator idle wait 257 50.19 3,559 13847 0.02
virtual circuit status 119 100.00 3,553 29855 0.01
jobq slave wait 1,185 95.11 3,519 2969 0.11
Streams AQ: waiting for time management or cleanup tasks 8 100.00 182 22803 0.00
class slave wait 2 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file parallel write 46,577 0.00 1,511 32 4.47
log file parallel write 11,630 0.00 1,302 112 1.12
Log archive I/O 2,221 0.00 1,247 562 0.21
control file parallel write 2,574 0.00 193 75 0.25
db file sequential read 4,594 0.00 112 24 0.44
log file sequential read 2,414 0.00 105 43 0.23
control file sequential read 7,008 0.00 63 9 0.67
direct path write 2,254 0.00 20 9 0.22
events in waitclass Other 247 0.00 17 71 0.02
log file single write 96 0.00 6 65 0.01
log file switch completion 2 50.00 1 512 0.00
direct path read 2,254 0.00 1 0 0.22
db file scattered read 31 0.00 1 29 0.00
os thread startup 5 0.00 0 41 0.00
latch: shared pool 1 0.00 0 0 0.00
rdbms ipc message 33,838 34.67 38,297 1132 3.24
pmon timer 1,209 99.83 3,585 2965 0.12
Streams AQ: qmn slave idle wait 128 0.00 3,559 27801 0.01
Streams AQ: qmn coordinator idle wait 257 50.19 3,559 13847 0.02
smon timer 236 0.00 3,479 14743 0.02
Streams AQ: waiting for time management or cleanup tasks 8 100.00 182 22803 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 11,560
AVG_IDLE_TIME 347,620
AVG_SYS_TIME 1,292
AVG_USER_TIME 10,156
BUSY_TIME 186,793
IDLE_TIME 5,563,729
SYS_TIME 22,465
USER_TIME 164,328
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES ###############
VM_OUT_BYTES ###############
PHYSICAL_MEMORY_BYTES 8,577,794,048
NUM_CPUS 16
NUM_CPU_CORES 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$USERS 48,359.80 1,510.70 11,808,160 477,153,868
oral 1,463.50 117.00 485,821 4,329,746
SYS$BACKGROUND 0.00 0.00 8,135 46,099
oralXDB 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
SYS$USERS 1932760 4405242 5062 492 0 0 2703007 13263
oral 33412 135898 35 1 0 0 3144042 138
SYS$BACKGROUND 10287 14570 6 20 0 0 0 0

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
18,445 406 22 838.43 36.83 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
16,944 184 31 546.57 33.83 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
3,741 18 216 17.32 7.47 c9khh2t00tx8b Zl9LISComm.exe Select substr(Text, 1, 512) as...
3,730 18 216 17.27 7.45 0j80bq6arfp1h Zl9LISComm.exe select o.obj#, u.name from obj...
2,254 6 38 59.32 4.50 bar657sdc6fg9 ZLHIS+.exe SELECT 收据费目, 开单人, SUM(实收金额) FR...
1,746 16 101 17.29 3.49 0nnzp62vn7vux ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
1,689 3 61 27.68 3.37 fmj9czt4f6prq ZLHIS+.exe Call Zl_电子病历记录_Update(:V001, :...
1,517 15 901 1.68 3.03 1994hz7y6wqs1 ZLHIS+.exe Select 文件ID ID, 病历编号 || '-' ||...
1,345 3 24 56.05 2.69 fud7uuxqfupww ZLHIS+.exe Select Upper(号码) as 号码 From 票据...
1,323 94 0   2.64 0r51ctum3c28k exp.exe SELECT /*+NESTED_TABLE_GET_REF...
1,236 2 23 53.73 2.47 532jygkmprqa3 ZLHIS+.exe UPDATE 电子病历时机 SET 完成时间 = NULL ...
1,133 1 3 377.60 2.26 801ubvy9dasrw ZLHIS+.exe SELECT A.姓名, A.性别, A.年龄, F.收费时...
1,117 3 13 85.89 2.23 ccaw9t4jvasj2 ZLHIS+.exe SELECT B.名称, 开单人, SUM(实收金额) FR...
943 0 28 33.69 1.88 6ux7c1dpfhmf8 ZLHIS+.exe UPDATE 病人变动记录 SET 终止时间 = :B4 ,...
718 2 1,376 0.52 1.43 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...

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
406 18,445 22 18.44 36.83 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
318 324 787 0.40 0.65 973barddfr983 ZLHIS+.exe Select b.时间, a.病人id, a.住院次数 ...
184 16,944 31 5.94 33.83 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
94 1,323 0   2.64 0r51ctum3c28k exp.exe SELECT /*+NESTED_TABLE_GET_REF...
71 73 662 0.11 0.15 dkgvzu0nwqdmw ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
57 75 3,215 0.02 0.15 47vyxbdrj6zy9 Zl9LISComm.exe Select Text as 功能 From Table(C...
48 49 1,252,078 0.00 0.10 67cm7yrk8fzyx ZLHIS+.exe SELECT DECODE(病情, '危', :B5 ,...
39 43 1,546 0.03 0.09 0u495x9dbmb7f ZLHIS+.exe SELECT T_REG_RECORD(:b1 , :b2...
28 29 34,154 0.00 0.06 0x1wutw2sxr85 Zl9LISComm.exe SELECT ZL_GET_REFERENCE(0, :B...
24 29 220 0.11 0.06 4570kj8tdbd9y Zl9LISComm.exe Select zltools.f_Reg_Audit(:V0...
18 3,741 216 0.08 7.47 c9khh2t00tx8b Zl9LISComm.exe Select substr(Text, 1, 512) as...
18 3,730 216 0.08 7.45 0j80bq6arfp1h Zl9LISComm.exe select o.obj#, u.name from obj...
16 1,746 101 0.16 3.49 0nnzp62vn7vux ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
15 1,517 901 0.02 3.03 1994hz7y6wqs1 ZLHIS+.exe Select 文件ID ID, 病历编号 || '-' ||...
6 2,254 38 0.16 4.50 bar657sdc6fg9 ZLHIS+.exe SELECT 收据费目, 开单人, SUM(实收金额) FR...
3 1,689 61 0.06 3.37 fmj9czt4f6prq ZLHIS+.exe Call Zl_电子病历记录_Update(:V001, :...
3 1,117 13 0.22 2.23 ccaw9t4jvasj2 ZLHIS+.exe SELECT B.名称, 开单人, SUM(实收金额) FR...
3 1,345 24 0.11 2.69 fud7uuxqfupww ZLHIS+.exe Select Upper(号码) as 号码 From 票据...
2 718 1,376 0.00 1.43 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
2 1,236 23 0.07 2.47 532jygkmprqa3 ZLHIS+.exe UPDATE 电子病历时机 SET 完成时间 = NULL ...
1 1,133 3 0.49 2.26 801ubvy9dasrw ZLHIS+.exe SELECT A.姓名, A.性别, A.年龄, F.收费时...
0 943 28 0.00 1.88 6ux7c1dpfhmf8 ZLHIS+.exe UPDATE 病人变动记录 SET 终止时间 = :B4 ,...

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
276,122,557 787 350,854.58 57.19 317.77 323.50 973barddfr983 ZLHIS+.exe Select b.时间, a.病人id, a.住院次数 ...
51,089,127 3,215 15,890.86 10.58 57.38 74.57 47vyxbdrj6zy9 Zl9LISComm.exe Select Text as 功能 From Table(C...
50,500,287 1,546 32,665.13 10.46 38.91 42.94 0u495x9dbmb7f ZLHIS+.exe SELECT T_REG_RECORD(:b1 , :b2...
42,820,989 22 1,946,408.59 8.87 405.68 18445.50 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
18,940,387 662 28,610.86 3.92 70.54 73.40 dkgvzu0nwqdmw ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
13,535,024 31 436,613.68 2.80 184.16 16943.63 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
8,980,082 74 121,352.46 1.86 11.07 29.47 g1mgh60hg3rf6 ZLHIS+.exe Select /*+ RULE */ 病人id, 病人来源,...
8,764,729 1,252,078 7.00 1.82 48.27 48.71 67cm7yrk8fzyx ZLHIS+.exe SELECT DECODE(病情, '危', :B5 ,...
6,849,620 25 273,984.80 1.42 13.93 23.97 93205vf021jhb ZLHIS+.exe Select * From (SELECT /*+ Rule...
5,875,962 205 28,663.23 1.22 22.61 25.63 cbg98qms8a3q7 ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
5,442,728 190 28,645.94 1.13 19.34 20.24 2w02jam1rfu7m ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....

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
8,761,922 22 398,269.18 71.09 405.68 18445.50 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
8,755,587 31 282,438.29 71.04 184.16 16943.63 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
1,274,456 216 5,900.26 10.34 17.64 3729.77 0j80bq6arfp1h Zl9LISComm.exe select o.obj#, u.name from obj...
1,273,772 216 5,897.09 10.34 17.68 3741.46 c9khh2t00tx8b Zl9LISComm.exe Select substr(Text, 1, 512) as...
473,084 101 4,684.00 3.84 15.88 1745.97 0nnzp62vn7vux ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
466,992 0   3.79 93.95 1322.70 0r51ctum3c28k exp.exe SELECT /*+NESTED_TABLE_GET_REF...
216,734 31 6,991.42 1.76 2.83 477.07 7pux7ymqn7z81 ZLHIS+.exe Select 0 As 入科标志, A.病人id, A....
98,146 10 9,814.60 0.80 2.80 418.16 an2zf90q9phjx ZLHIS+.exe Select A.出院方式, A.住院天数, A.主页ID,...
85,079 61 1,394.74 0.69 3.49 1688.58 fmj9czt4f6prq ZLHIS+.exe Call Zl_电子病历记录_Update(:V001, :...
75,935 901 84.28 0.62 15.20 1517.26 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
1,252,078 1,252,079 1.00 0.00 0.00 67cm7yrk8fzyx ZLHIS+.exe SELECT DECODE(病情, '危', :B5 ,...
34,154 34,154 1.00 0.00 0.00 0x1wutw2sxr85 Zl9LISComm.exe SELECT ZL_GET_REFERENCE(0, :B...
32,022 32,023 1.00 0.00 0.00 c749bc43qqfz3 ZLHIS+.exe SELECT SYSDATE FROM DUAL
12,853 12,853 1.00 0.00 0.00 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
12,675 6,822 0.54 0.00 0.01 04xtrk7uyhknh   select obj#, type#, ctime, mti...
10,948 10,948 1.00 0.00 0.00 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
9,062 9,062 1.00 0.00 0.00 6dv6fycjabduf ZLHIS+.exe select P.*, D.编码 as 部门编码, D.名称...
6,792 6,792 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...
5,627 5,627 1.00 0.00 0.00 38hnxgpqkhurf ZLHIS+.exe Select 复查上限, 复查下限 From 检验项目参考...
5,408 3,657 0.68 0.00 0.00 8swypbbr0m372   select order#, columns, types ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
28,487 32,022 6.17 c749bc43qqfz3 ZLHIS+.exe SELECT SYSDATE FROM DUAL
12,853 12,853 2.78 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
10,948 10,948 2.37 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
9,062 9,062 1.96 6dv6fycjabduf ZLHIS+.exe select P.*, D.编码 as 部门编码, D.名称...
6,792 6,792 1.47 grwydz59pu6mc   select text from view$ where r...
6,505 12,675 1.41 04xtrk7uyhknh   select obj#, type#, ctime, mti...
5,627 5,627 1.22 38hnxgpqkhurf ZLHIS+.exe Select 复查上限, 复查下限 From 检验项目参考...
5,408 5,408 1.17 8swypbbr0m372   select order#, columns, types ...
5,408 5,408 1.17 cqgv56fmuj63x   select owner#, name, namespace...
4,558 4,558 0.99 50vbxcwxa0npj ZLHIS+.exe Select Zl_Actualmoney(:V001, :...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,139,192 83 0.12 cr1wa975acfv7 ZLHIS+.exe Select Rownum as KeyID, A.* Fr...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
161 1,114 b6k4b1am0837g ZLHIS+.exe SELECT ID, 私有, 本机, 授权, SYS...
56 4,815 g9pzukdxxmx42 zlSvrStudio.exe SELECT NVL(COUNT (*) , 0 ) F...
43 197 71farxwf9kx0m Zl9LISComm.exe Select User, A.Id, A.编号, A.简...
41 972 0a45w3f97k65h ZLHIS+.exe Select /*+ RULE */ A.ID, A.相关I...
41 1,383 f0zj3p6vu1tqf Zl9LISComm.exe Select 参数ID, Nvl(用户名, 'NullUs...
37 220 3t32wcur3nm99 zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
37 207 5k8jr20q2bmv1 ZLHIS+.exe SELECT T_MENU_RECORD(M.层次, M....
37 1,661 cam7tqqfxksj8 Zl9LISComm.exe SELECT T_REG_RECORD(:b1 , :b2...
37 1,661 cam7tqqfxksj8 Zl9LISComm.exe SELECT T_REG_RECORD(:b1 , :b2...
37 1,383 f9rxqw86hgn7z Zl9LISComm.exe Select ID, Nvl(系统, 0) as 系统, N...
37 205 fy5d79ukcwkn7 ZLHIS+.exe Select 1 as 类别, 部门ID From 部门人员...
36 220 2ng5zrq77ssab zlSvrStudio.exe SELECT NVL(COUNT (*) , 0 ) F...
36 1,614 70wznctgyy8ms ZLHIS+.exe Select a.姓名, a.性别, a.年龄, b....
35 807 9jgwywty9dvy6 ZLHIS+.exe Select r.科室id 病人科室, Decode(b....
34 1,546 0u495x9dbmb7f ZLHIS+.exe SELECT T_REG_RECORD(:b1 , :b2...
33 220 chtn34u7bwttj zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 220 2hpt28zkqj3n8 zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 220 52g2k9k04k0zw zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 219 565yqxjyswv5h zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 188 58afvfqm7ja50 ZLHIS+.exe Select 部门ID, 工作性质, 服务对象 From 部...
32 1,826 63c3fzg565g2s ZLHIS+.exe Select Sum(费用余额) as 费用余额, Sum(...
32 220 abc96uy7pcvgs zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 1,607 aj1mmfscyf8f0 ZLHIS+.exe Select Distinct B.发生时间 as 挂号时间...
31 893 9btpmxat54c2z ZLHIS+.exe Select Count(*) as 数量 From 病案主...
30 220 0yfxa80q7t20w zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
30 220 14fm6j48q84k2 zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
30 220 2tds4dtjh0b3u zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
29 107 47pyw8050xz8p ZLHIS+.exe Select 序号, 医保部件, 医保包 From 保险类别...
28 844 0dtg7gj9qq7r5 ZLHIS+.exe Select A.ID, A.相关ID, A.序号, A....
28 1,392 202xz2txrbf2r zlSvrStudio.exe SELECT T_REG_RECORD("项目" , 0 ...
28 110 23t94ak3rbhq0 ZLHIS+.exe Select ID, Nvl(标本部位, '阳性(+);阴性...
28 219 3xfr7pah136aq zlSvrStudio.exe SELECT I."内容" FROM ZLREGINFO I...
28 2,673 837jfn1t399qb ZLHIS+.exe Select Distinct 0 as 发送号, B.操...
25 247 0axbx30kwm393 ZLHIS+.exe Select /*+ rule */ Distinct A...
23 12,675 04xtrk7uyhknh   select obj#, type#, ctime, mti...
22 832 3fms6wzbhcadc ZLHIS+.exe Select /*+ Rule*/ A.ID, A.类别, ...
21 1,909 0nzt1m3rp322n ZLHIS+.exe Select 记录来源, 诊断类型, 诊断次序, 诊断描述,...
21 9,062 6dv6fycjabduf ZLHIS+.exe select P.*, D.编码 as 部门编码, D.名称...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
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
0a45w3f97k65h 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, NULL, 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 H H24: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.申请序号 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, 序号
0axbx30kwm393 Select /*+ rule */ Distinct A.标本id, A.诊疗项目id, A.编码, A.排列序号, A.固定项目, A.ID, A.检验项目, A.缩写 as 英文名, A.Cv, Decode(A.本次结果, '-', '阴性（-）', '+', '阳性（+）', '*', '*.**', A.本次结果) As 本次结果, Rownum As 序号, A.标志, A.仪器id, A.标本类别, A.核收时间, A.标本序号, A.标本号显示, A.检验备注, A.姓名, A.性别, A.年龄, A.门诊号, A.住院号, A.当前床号, A.主页id, A.结果范围, Nvl(G.小数位数, 2) As 小数, A.警戒上限, A.警戒下限, A.单位, Trim(Replace(Replace(' ' || Zlgetreference(A.ID, A.标本类型, Decode(A.性别, '男', 1, '女', 2, 0), A.出生日期, A.仪器id, A.年龄), ' .', '0.'), '～.', '～0.')) As 参考, A.Od, A.Cutoff, A.Cov, A.酶标板id, A.变异报警, A.变异警示, A.结果类型, A.结果参考 From (Select A.ID As 标本id, B.诊疗项目id, lpad(Decode(D.排列序号, Null, Nvl(H.编码, C.编码), D.排列序号), 4, '0') As 编码, Nvl(B.排列序号, 9999) As 排列序号, Decode(B.诊疗项目id, Null, 0, 1) As 固定项目, B.检验项目id As ID, C.中文名 || Decode(D.缩写, Null, '', '(' || D.缩写 || ')') As 检验项目, D.缩写, 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.结果参考 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.记录类型 = A.报告结果 And A.医嘱ID = :V001 Union All Select A.ID As 标本id, B.诊疗项目id, lpad(Decode(D.排列序号, Null, Nvl(H.编码, C.编码), D.排列序号), 4, '0') As 编码, Nvl(B.排列序号, 9999) As 排列序号, Decode(B.诊疗项目id, Null, 0, 1) As 固定项目, B.检验项目id As ID, C.中文名 || Decode(D.缩写, Null, '', '(' || D.缩写 || ')') As 检验项目, D.缩写, 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.结果参考 From 检验标本记录 A, 检验标本记录 E, 检验普通结果 B, 诊治所见项目 C, 检验项目 D, 检验仪器项目 G, 诊疗项目目录 H Where A.ID = B.检验标本id And B.检验项目id = C.ID And C.ID = D.诊治项目id And B.诊疗项目id = H.ID(+) And B.记录类型 = A.报告结果 And E.ID=A.合并id And E.医嘱ID= :V002) A, 检验仪器项目 G Where A.仪器id = G.仪器id(+) And A.ID = G.项目id(+) Order By A.编码, A.排列序号
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 序号, 费用性质, 从项, 收费类别
0j80bq6arfp1hselect o.obj#, u.name from obj$ o, user$ u where u.user#=o.owner# and o.type#=:1
0nnzp62vn7vuxSelect A.病人ID, A.主页ID, B.住院号, C.床号, B.姓名, B.性别, B.年龄, Min(A.完成时间) 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=: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 完成时间
0nzt1m3rp322nSelect 记录来源, 诊断类型, 诊断次序, 诊断描述, 是否疑诊, Mod(诊断类型, 10) as 大类 From 病人诊断记录 Where 病人ID=:V001 And 主页ID=:V002 And 诊断类型 IN(1, 2, 3, 11, 12, 13) Order by 记录来源, 诊断类型, 诊断次序
0r51ctum3c28kSELECT /*+NESTED_TABLE_GET_REFS+*/ "ZLHIS"."住院费用记录".* FROM "ZLHIS"."住院费用记录"
0u495x9dbmb7fSELECT T_REG_RECORD(:b1 , :b2 , G."功能" ) FROM (SELECT DISTINCT G."功能" FROM ZLROLEGRANT G , SYS.DBA_ROLE_PRIVS R WHERE R.GRANTEE = USER AND G."角色" = R.GRANTED_ROLE AND G."系统" IS NULL AND G."序号" = :b2 ) G
0x1wutw2sxr85SELECT ZL_GET_REFERENCE(0, :B6 , :B5 , :B4 , :B3 , :B2 , :B1 ) FROM DUAL
0yfxa80q7t20wINSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '授权日期' , :b1 )
14fm6j48q84k2INSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '单位名称' , :b1 )
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 到期时间
202xz2txrbf2rSELECT T_REG_RECORD("项目" , 0 , DECODE(SUBSTR("项目" , 1 , 2 ) , '影像' , DECODE("内容" , '-1' , NULL , "内容" ) , '检验' , DECODE("内容" , '-1' , NULL , "内容" ) , "内容" ) ) FROM ZLREGAUDIT WHERE "项目" IN ( '单位名称' , '授权性质' , '使用期限' , '授权站点' , '授权日期' , '产品标题' , '产品简名' , '产品开发商' , '技术支持商' , '支持商MAIL' , '支持商URL' , '支持商简名' , '影像DICOM设备数量' , '影像视频设备数量' , '影像胶片打印机数量' , '影像观片站数量' , '检验仪器数量' )
23t94ak3rbhq0Select ID, Nvl(标本部位, '阳性(+);阴性(-)') as 标注 From 诊疗项目目录 Where 类别='E' And 操作类型='1'
2hpt28zkqj3n8INSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '技术支持商' , :b1 )
2ng5zrq77ssabSELECT NVL(COUNT (*) , 0 ) FROM ZLREGINFO WHERE "项目" = '授权证章' AND "内容" = :b1
2tds4dtjh0b3uINSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '授权站点' , :b1 )
2w02jam1rfu7m Select A.ID, A.类别 as 类别ID, B.序号 as 顺序ID, B.名称 as 类别, A.编码, A.名称, A.商品名, A.简码, D.住院单位 as 单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Decode(A.是否变价, 1, '时价', LTrim(To_Char(Sum(C.现价)*Nvl(D.住院包装, 1), '9999990.00000'))) as 单价, NULL as 库存 From ( Select Distinct A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, Null 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.服务对象 IN(:V001, 3) And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And (A.编码 Like :V002 And B.码类=:V003 Or B.名称 Like :V004 And B.码类=:V005 Or B.简码 Like :V006 And B.码类 IN(:V007, 3))) A, 收费项目类别 B, 收费价目 C, 药品规格 D, 诊疗项目目录 E Where A.类别=B.编码 And A.ID=C.收费细目ID And ( (instr( ';6;7;', ';'||A.类别||';', 1)>0 and nvl(D.中药形态, 0)=:V008) or A.类别='5') And A.ID=D.药品ID And D.药名ID=E.ID And Sysdate Between C.执行日期 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.是否变价, D.住院单位, D.住院包装 Union ALL 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 ( Select Distinct A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, Null 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.服务对象 IN(:V009, 3) And A.ID=B.收费细目ID And A.类别='4' And (A.编码 Like :V010 Or B.名称 Like :V011 Or B.简码 Like :V012) And B.码类=:V013 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null)) A, 收费项目类别 B, 收费价目 C, 材料特性 D, 诊疗项目目录 E Where A.类别=B.编码 And A.ID=C.收费细目ID And A.ID=D.材料ID And D.诊疗ID=E.ID And nvl(D.核算材料 , 0)=0 And Sysdate Between C.执行日期 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.计算单位 Union ALL 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.费用类型, Null 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.服务对象 IN(:V014, 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.编码 Like :V015 Or B.名称 Like :V016 Or B.简码 Like :V017) And B.码类=:V018) 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, 编码
38hnxgpqkhurfSelect 复查上限, 复查下限 From 检验项目参考 A Where a.Id = :V001
3fms6wzbhcadcSelect /*+ Rule*/ A.ID, A.类别, A.类别名称, A.编码, Nvl(B.名称, A.名称) as 名称, A.规格, A.产地, A.费用类型, A.是否变价, C.跟踪在用 From (Select A.ID, A.类别, B.名称 as 类别名称, A.编码, A.名称, A.规格, A.产地, A.费用类型, A.是否变价 From 收费项目目录 A, 收费项目类别 B, Table(f_Num2list(:V001)) D Where A.类别=B.编码 And A.ID = D.Column_Value) A, 收费项目别名 B, 材料特性 C Where A.ID=C.材料ID(+) And A.ID=B.收费细目ID(+) And B.码类(+)=1 And B.性质(+)=:V002
3t32wcur3nm99INSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '支持商MAIL' , :b1 )
3xfr7pah136aqSELECT I."内容" FROM ZLREGINFO I WHERE I."项目" = '授权工具' ORDER BY "行号"
4570kj8tdbd9ySelect zltools.f_Reg_Audit(:V001) As Stamp From zltools.zlRegInfo r Where 项目='授权证章'
47pyw8050xz8pSelect 序号, 医保部件, 医保包 From 保险类别
47vyxbdrj6zy9Select Text as 功能 From Table(Cast(zltools.f_Reg_Func(:V001, :V002) as zlTools.t_Reg_Rowset))
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
50vbxcwxa0npjSelect Zl_Actualmoney(:V001, :V002, :V003, :V004, :V005, :V006) as Actualmoney From Dual
52g2k9k04k0zwINSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '产品标题' , :b1 )
532jygkmprqa3UPDATE 电子病历时机 SET 完成时间 = NULL WHERE 文件ID = :B2 AND 完成记录ID = :B1
565yqxjyswv5hINSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '支持商简名' , :b1 )
58afvfqm7ja50Select 部门ID, 工作性质, 服务对象 From 部门性质说明
5bg8y87gqb2rtCall zl_病人变动记录_Out(:V001, :V002, :V003, :V004, :V005, :V006, :V007, :V008, :V009, :V010, :V011, :V012, :V013, :V014, :V015, :V016, :V017, :V018, :V019)
5k8jr20q2bmv1 SELECT T_MENU_RECORD(M.层次, M.ID, M.上级ID, M.标题, M.短标题, M.快键, M.说明, M.模块, M.系统, M.图标, P.部件, 0) FROM (SELECT LEVEL AS 层次, ID, 上级ID, 标题, 短标题, 快键, 说明, 模块, 系统, 图标 FROM ZLMENUS WHERE 组别 = :B3 START WITH 上级ID IS NULL CONNECT BY PRIOR ID = 上级ID) M, (SELECT DISTINCT P.系统, P.序号, P.部件 FROM ZLPROGRAMS P, ZLPROGFUNCS F, ZLREGFUNC R, TABLE(CAST(:B1 AS T_REG_ROWSET)) C, TABLE(CAST(:B2 AS T_REG_ROWSET)) S, (SELECT 1 AS 超级 FROM SYS.DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'DBA' AND GRANTEE = USER) A, (SELECT DECODE(COUNT(*), 0, 0, NULL, 0, 1) AS 编号 FROM ZLSYSTEMS WHERE UPPER(所有者) = USER UNION ALL SELECT 编号 FROM ZLSYSTEMS WHERE UPPER(所有者) = USER) O, (SELECT DISTINCT G.系统, G.序号 FROM ZLROLEGRANT G, SYS.DBA_ROLE_PRIVS R WHERE G.角色 = R.GRANTED_ROLE AND R.GRANTEE = USER) G WHERE NVL(F.系统, 0) = NVL(P.系统, 0) AND F.序号 = P.序号 AND TRUNC(F.系统 / 100) = R.系统(+) AND F.序号 = R.序号(+) AND F.功能 = R.功能(+) AND (R.功能 IS NULL AND F.系统 IS NULL OR R.功能 IS NOT NULL) AND UPPER(P.部件) = C.TEXT AND NVL(P.系统, 0) = S.PROG AND P.序号 = P.序号 * A.超级(+) AND NVL(P.系统, 1) = O.编号(+) AND NVL(P.系统, 0) = NVL(G.系统(+), 0) AND P.序号 = G.序号(+) AND (A.超级 IS NOT NULL OR O.编号 IS NOT NULL OR G.序号 IS NOT NULL)) P WHERE NVL(M.系统, 0) = NVL(P.系统(+), 0) AND M.模块 = P.序号(+) AND (M.模块 IS NULL OR M.模块 IS NOT NULL AND P.序号 IS NOT NULL) ORDER BY M.层次 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)
67cm7yrk8fzyxSELECT DECODE(病情, '危', :B5 , '重', :B4 , :B3 ) AS 时限 FROM (SELECT 病情 FROM 病人变动记录 WHERE 病人ID = :B2 AND 主页ID = :B1 AND 开始原因 IN (1, 2, 3, 9) AND 开始时间 IS NOT NULL AND NVL(附加床位, 0) = 0 ORDER BY 开始时间 DESC) WHERE ROWNUM < 2
6dv6fycjabdufselect P.*, D.编码 as 部门编码, D.名称 as 部门名称, M.部门ID, u.用户名 from 上机人员表 U, 人员表 P, 部门表 D, 部门人员 M Where U.人员id = P.id And P.ID=M.人员ID and M.缺省=1 and M.部门id = D.id and U.用户名=user
6ux7c1dpfhmf8UPDATE 病人变动记录 SET 终止时间 = :B4 , 终止原因 = 1, 终止人员 = :B3 WHERE 病人ID = :B2 AND 主页ID = :B1 AND 终止时间 IS NULL
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.床号(+)
71farxwf9kx0mSelect User, A.Id, A.编号, A.简码, A.姓名, B.用户名, C.部门id, D.编码 As 部门码, D.名称 As 部门名 From 人员表 A, 上机人员表 B, 部门人员 C, 部门表 D Where A.Id = B.人员id And A.Id = C.人员id And C.部门id = D.Id And B.用户名 = :V001 And C.缺省 = 1
7pux7ymqn7z81 Select 0 As 入科标志, A.病人id, A.住院号, A.姓名, A.性别, B.年龄, B.费别, B.主页id, B.当前病区id, E.名称 As 当前病区, B.出院科室id, F.名称 As 当前科室, To_Char(B.入院日期, 'YYYY-MM-DD HH24:MI:SS') As 入院时间, B.当前病况, B.护理等级id, D.名称 As 护理等级, B.出院科室id As 入住科室id, F.名称 As 转入科室, B.责任护士, B.门诊医师, B.住院医师, B.病人性质, B.险类, A.就诊卡号, A.身份证号, A.IC卡号, Nvl(B.病人类型, Decode(B.险类, Null, '普通病人', '医保病人')) 病人类型 From 病人信息 A, 病案主页 B, 收费项目目录 D, 部门表 E, 部门表 F Where B.病人id = A.病人id And B.护理等级id = D.ID(+) And B.当前病区id = E.ID(+) And B.出院科室id = F.ID And B.出院日期 Is Null And Nvl(B.主页id, 0) <> 0 And B.状态 = 1 And (B.当前病区ID+0 = :V001 Or B.当前病区ID Is Null And Exists(Select 1 From 病区科室对应 C Where B.出院科室id = C.科室id And C.病区id = :V002)) And B.入院日期>=Sysdate-:V003 Union All Select 1 As 入科标志, A.病人id, A.住院号, A.姓名, A.性别, B.年龄, B.费别, B.主页id, B.当前病区id, E.名称 As 当前病区, B.出院科室id, F.名称 As 当前科室, To_Char(B.入院日期, 'YYYY-MM-DD HH24:MI:SS') As 入院时间, B.当前病况, B.护理等级id, D.名称 As 护理等级, C.科室id As 入住科室id, G.名称 As 转入科室, B.责任护士, B.门诊医师, B.住院医师, B.病人性质, B.险类, A.就诊卡号, A.身份证号, A.IC卡号, Nvl(B.病人类型, Decode(B.险类, Null, '普通病人', '医保病人')) 病人类型 From 病人信息 A, 病案主页 B, 病人变动记录 C, 收费项目目录 D, 部门表 E, 部门表 F, 部门表 G, 病区科室对应 H Where A.在院=1 And B.病人id = A.病人id And C.病人id = B.病人id And C.主页id = B.主页id And B.护理等级id = D.ID(+) And B.当前病区id+0 = E.ID And B.出院科室id+0 = F.ID And Nvl(B.主页id, 0) <> 0 And C.开始原因 = 3 And C.开始时间 Is Null And C.终止时间 Is Null And B.状态 = 2 And C. 科室id = G.ID And C.科室id+0 = H.科室id And H.病区id = :V004 Union All Select 2 As 入科标志, A.病人id, A.住院号, A.姓名, A.性别, B.年龄, B.费别, B.主页id, B.当前病区id, E.名称 As 当前病区, B.出院科室id, F.名称 As 当前科室, To_Char(B.入院日期, 'YYYY-MM-DD HH24:MI:SS') As 入院时间, B.当前病况, B.护理等级id, D.名称 As 护理等级, C.科室id As 入住科室id, G.名称 As 转入科室, B.责任护士, B.门诊医师, B.住院医师, B.病人性质, B.险类, A.就诊卡号, A.身份证号, A.IC卡号, Nvl(B.病人类型, Decode(B.险类, Null, '普通病人', '医保病人')) 病人类型 From 病人信息 A, 病案主页 B, 病人变动记录 C, 收费项目目录 D, 部门表 E, 部门表 F, 部门表 G, 病区科室对应 H Where A.在院=1 And B.病人id = A.病人id And C.病人id = B.病人id And C.主页id = B.主页id And B.护理等级id = D.ID(+) And B.当前病区id+0 = E.ID And B.出院科室id+0 = F.ID And Nvl(B.主页id, 0) <> 0 And C.开始原因 = 15 And C.开始时间 Is Null And C.终止时间 Is Null And B.状态 = 2 And C.科室id = G.ID And C.病区id+0 = H.病区id And C.科室id+0 = H.科室id And H.病区id = :V005 Order By 入科标志 Desc, 入院时间 Desc, 住院号 Desc
801ubvy9dasrw SELECT A.姓名, A.性别, A.年龄, F.收费时间 结算时间, 工作单位, B.医保号, F.费用总额, F.补偿金额, ROUND(NVL(F.补偿金额, 0) / DECODE(F.费用总额, 0, 1, F.费用总额) * 100, 2) || '%' AS 实际补偿比例 FROM ZLHIS.病人信息 A, ZLHIS.医保病人关联表 B, (SELECT A.病人ID, A.病种名称, B.收费时间, SUM(B.费用总额) 费用总额, SUM(补偿金额) AS 补偿金额 FROM (SELECT A.病人ID, A.结帐ID, C.病种名称, SUM(DECODE(A.结算方式, '统筹帐户支付', A.冲预交)) 补偿金额 FROM ZLHIS.病人预交记录 A, ZLHIS.病人结帐记录 B, ZLHIS.保险结算记录 C WHERE A.结帐ID = B.ID AND B.ID = C.记录ID AND C.结算时间 BETWEEN To_Date(:V001, 'YYYY-MM-DD') AND To_Date(:V002, 'YYYY-MM-DD HH24:MI:SS') AND C.险类 = 411 AND NVL(校对标志, 0) = 0 GROUP BY A.病人ID, A.结帐ID, C.病种名称) A, (SELECT A.病人ID, 结帐ID, C.病种名称, TRUNC(B.收费时间) AS 收费时间, SUM(结帐金额) 费用总额 FROM ZLHIS.住院费用记录 A, ZLHIS.病人结帐记录 B, ZLHIS.病案主页 D, ZLHIS.保险结算记录 C WHERE A.结帐ID = B.ID AND B.ID = C.记录ID AND A.病人ID = D.病人ID AND A.主页ID = D.主页ID AND B.收费时间 BETWEEN To_Date(:V003, 'YYYY-MM-DD') AND To_Date(:V004, 'YYYY-MM-DD HH24:MI:SS') AND C.险类 = 411 AND D.出院科室ID IN (7331) GROUP BY A.病人ID, 结帐ID, TRUNC(B.收费时间), C.病种名称) B WHERE A.结帐ID = B.结帐ID GROUP BY A.病人ID, B.收费时间, A.病种名称 HAVING(SUM(NVL(补偿金额, 0)) <> 400 AND SUM(费用总额) < 33200 AND SUM(费用总额) < 33200 AND SUM(费用总额) > 0)) F WHERE A.病人ID = B.病人ID AND A.病人ID = F.病人ID AND F.病种名称 NOT LIKE 'DBZ%' UNION ALL SELECT ' 汇总' 姓名, NULL 性别, NULL 年龄, NULL 结算时间, NULL 工作单位, NULL AS 医保号, SUM(F.费用总额) AS 费用总额, SUM(F.补偿金额) 补偿金额, ROUND(SUM(NVL(F.补偿金额, 0)) / SUM(DECODE(F.费用总额, 0, 1, F.费用总额)) * 100, 2) || '%' AS 实际补偿比例 FROM ZLHIS.病人信息 A, ZLHIS.医保病人关联表 B, (SELECT A.病人ID, B.结算时间, A.病种名称, SUM(B.费用总额) 费用 总额, SUM(补偿金额) AS 补偿金额 FROM (SELECT A.病人ID, A.结帐ID, C.病种名称, SUM(DECODE(A.结算方式, '统筹帐户支付', A.冲预交)) 补偿金额 FROM ZLHIS.病人预交记录 A, ZLHIS.病人结帐记录 B, ZLHIS.保险结算记录 C WHERE A.结帐ID = B.ID AND B.ID = C.记录ID AND B.收费时间 BETWEEN To_Date(:V005, 'YYYY-MM-DD') AND To_Date(:V006, 'YYYY-MM-DD HH24:MI:SS') AND C.险类 = 411 AND NVL(校对标志, 0) = 0 GROUP BY A.病人ID, A.结帐ID, C.病种名称) A, (SELECT A.病人ID, 结帐ID, C.病种名称, TRUNC(B.收费时间) AS 结算时间, SUM(结帐金额) 费用总额 FROM ZLHIS.住院费用记录 A, ZLHIS.病人结帐记录 B, ZLHIS.病案主页 D, ZLHIS.保险结算记录 C WHERE A.结帐ID = B.ID AND B.ID = C.记录ID AND A.病人ID = D.病人ID AND A.主页ID = D.主页ID AND B.收费时间 BETWEEN To_Date(:V007, 'YYYY-MM-DD') AND To_Date(:V008, 'YYYY-MM-DD HH24:MI:SS') AND C.险类 = 411 AND D.出院科室ID IN (7331) GROUP BY A.病人ID, 结帐ID, TRUNC(B.收费时间), C.病种名称) B WHERE A.结帐ID = B.结帐ID GROUP BY A.病人ID, B.结算时间, A.病种名称 HAVING(SUM(NVL(补偿金额, 0)) <> 400 AND SUM(费用总额) < 33200 AND SUM(费用总额) > 0)) F WHERE A.病人ID = B.病人ID AND A.病人ID = F.病人ID AND F.病种名称 NOT LIKE 'DBZ%'
837jfn1t399qb Select Distinct 0 as 发送号, B.操作人员 as 人员, B.操作时间 as 时间, B.操作类型, Decode(B.操作类型, 4, '作废医嘱', 5, '重整医嘱', 6, '暂停医嘱', 7, '启用医嘱', 8, '停止医嘱', 9, '确认停止', 10, '皮试结果') 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, 发送号
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
93205vf021jhb Select * From (SELECT /*+ Rule*/ Distinct M.药品ID, X.分类ID As 用途分类ID, A.编码, M.基本药物, M.标识码 As 药卡号, A.名称 As 通用名, L.名称 As 商品名, A.规格, Nvl(A.产地, B.上次产地) AS 产地, NULL AS 效期, DECODE(M.药库分批, 1, '是', '否') AS 药库分批 , M.药库单位 as 单位, '' as 上次采购价, nvl(P.现价, 0)*nvl(M.药库包装, 0) as 最后售价, nvl(M.药库包装, 0) as 系数1, Sum(B.可用数量/Decode(M.药库包装, 0, 1, null, 1, M.药库包装)) as 可用数量, Sum(B.实际数量/Decode(M.药库包装, 0, 1, null, 1, M.药库包装)) as 实际数量, Sum(B.实际金额) As 实际金额, Sum(B.实际差价) As 实际差价, Decode(To_Char(A.撤档时间, 'yyyy-MM-dd'), '3000-01-01', ' ', To_Char(A.撤档时间, 'yyyy-MM-dd')) 撤档时间, Decode(M.药库包装, 0, 1, null, 1, M.药库包装) as 除数, Nvl(A.是否变价, 0) 变价, G.名称 As 上次供应商, '' 库房货位 FROM 药品规格 M, 收费价目 P, (Select distinct A.ID, A.编码, A.名称, A.规格, A.产地, A.是否变价, A.撤档时间, A.类别, A.计算单位 From 收费项目目录 A, 收费项目别名 B Where A.ID=B.收费细目ID And (A.编码 Like :V001 OR B.名称 Like :V002 OR B.简码 LIKE :V003)) A , (Select distinct b.药品id, b.上次成本价, '' 上次产地, b.可用数量, b.实际数量, b.实际金额, b.实际差价 From 药品库存 a, (Select 药品id, Avg(上次采购价) As 上次成本价, Max(nvl(批次, 0)) As 批次, Sum(可用数量) As 可用数量, Sum(实际数量) As 实际数量, Sum(实际金额) As 实际金额, Sum(实际差价) As 实际差价 From 药品库存 Where 性质 = 1 Group By 药品id) b Where a.药品id=b.药品id And a.性质 = 1 And nvl(a.批次, 0) = b.批次) B, 诊疗项目目录 X, 药品特性 T, 收费项目别名 L, 供应商 G , Table(Cast(f_Str2list(:V004) As zlTools.t_Strlist)) D WHERE M.药名ID=X.ID And X.ID=T.药名ID And Nvl(M.上次供应商id, 0) = G.ID(+) AND M.药品ID=P.收费细目ID AND SYSDATE BETWEEN P.执行日期 AND NVL(P.终止日期, SYSDATE) AND (TO_CHAR(A.撤档时间, 'YYYY-MM-DD') = '3000-01-01' OR A.撤档时间 IS NULL) AND A.ID= M.药品ID AND M.药品ID=B.药品ID(+) And M.药品ID=L.收费细目ID(+) And L.性质(+)=3 And L.码类(+)=1 And A.类别=D.Column_Value Group by M.药品ID, X.分类id, A.编码, M.基本药物, M.标识码, A.名称, L.名称, A.规格, Nvl(A.产地, B.上次产地), M.药库分批, M.药库单位, nvl(P.现价, 0)*nvl(M.药库包装, 0), nvl(M.药库包装, 0), Decode(M.药库包装, 0, 1, null, 1, M.药库包装), Decode(To_Char(A.撤档时间, 'yyyy-MM-dd'), '3000-01-01', ' ', To_Char(A.撤档时间, 'yyyy-MM-dd')), Nvl(A.是否变价, 0), G.名称) Order By 编码
973barddfr983Select b.时间, a.病人id, a.住院次数 As 主页id, a.住院号, a.姓名, a.当前床号 As 床号, a.险类, b.医嘱状态, b.状态 From (Select c.病人id, c.主页id, Max(d.操作时间) As 时间, c.医嘱状态, Decode(c.医嘱状态, 1, '有新下达医嘱', 8, '有新停止医嘱', 4, '有新作废医嘱') As 状态 From 病人医嘱记录 C, 病人医嘱状态 D Where Instr(:V001, ', ' || c.医嘱状态 || ', ') > 0 And c.Id = d.医嘱id And c.医嘱状态 = d.操作类型 And (c.医嘱状态 <> 8 Or Nvl(c.医嘱期效, 0) = 0) And (c.医嘱状态 <> 4 Or Trunc(d.操作时间) = Trunc(Sysdate)) And d.操作时间 >= Trunc(Sysdate - (10 - 1)) And d.操作类型 In (1, 4, 8) And Not (c.医嘱状态 = 1 And Instr(c.开嘱医生, '/') = 0 And Not Exists (Select m.姓名 From 人员表 M, 执业类别 N Where m.姓名 = c.开嘱医生 And m.执业类别 = n.编码 And n.分类 In ('执业医师', '执业助理医师'))) Group By c.病人id, c.主页id, c.医嘱状态) B, 病人信息 A Where a.当前病区id + 0 = :V002 And b.病人id = a.病人id And b.主页id = a.住院次数 And a.在院 = 1 Order by 时间
9btpmxat54c2zSelect Count(*) as 数量 From 病案主页 B, 病案反馈记录 A Where A.病人ID=B.病人ID and A.主页ID=B.主页ID And A.记录状态=1 And A.反馈对象 IN(1, 2, 5, 6, 7, 8) And B.出院科室ID=:V001
9jgwywty9dvy6Select 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.Id
9rbfa58tjn76fSelect Max(B.操作时间) as 时间 From 病人医嘱记录 A, 病人医嘱状态 B Where A.ID=B.医嘱ID And B.操作类型=5 And A.病人ID=:V001 And A.主页ID=:V002
abc96uy7pcvgsINSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '产品开发商' , :b1 )
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
an2zf90q9phjxSelect A.出院方式, A.住院天数, A.主页ID, to_char(A.出院日期, 'YYYY-MM-DD HH24:MI:SS') as 出院日期, B.就诊时间, B.医疗类别, B.病种ID, B.病种名称, B.并发症, B.HIS流水号, B.YB流水号, B.IC卡信息 From 病案主页 A, 就诊登记记录 B Where A.病人id=:V001 and A.主页ID=:V002 and a.病人id=b.病人id and a.主页id=b.主页id
b6k4b1am0837gSELECT ID, 私有, 本机, 授权, SYS_CONTEXT('USERENV', 'TERMINAL') FROM ZLPARAMETERS WHERE NVL(系统, 0) = NVL(:B3 , 0) AND NVL(模块, 0) = NVL(:B2 , 0) AND 参数名 = :B1
bar657sdc6fg9SELECT 收据费目, 开单人, SUM(实收金额) FROM ZLHIS.病人费用记录 WHERE 登记时间 BETWEEN To_Date(:V001, 'YYYY-MM-DD') AND To_Date(:V002, 'YYYY-MM-DD HH24:MI:SS') AND (门诊标志=:V003 OR 门诊标志=:V004) AND 开单人=:V005 AND 记录状态<>0 GROUP BY 收据费目, 开单人
bs6uun5x4v22zSELECT A.科室ID, A.责任人, A.文件ID, A.病历种类, A.病历编号, A.病历名称, A.事件, A.必须, A.唯一, A.事件时间, A.开始时间, A.到期时间, A.一般周期, A.病重周期, A.病危周期, A.周期号 FROM 电子病历时机 A, 病案主页 B, (SELECT MAX(到期时间) 到期时间, 文件ID FROM 电子病历时机 WHERE 病人ID = :B2 AND 主页ID = :B1 AND (NVL(完成记录ID, 0) = 0 OR 完成时间 IS NULL) AND 唯一 = 0 GROUP BY 文件ID) C WHERE A.到期时间 = C.到期时间 AND A.文件ID = C.文件ID AND A.病人ID = B.病人ID AND A.主页ID = B.主页ID AND A.科室ID = B.出院科室ID
c1yr7s5676cm3Select Zl_Lob_Read(:V001, :V002, :V003, :V004) as 片段 From Dual
c749bc43qqfz3SELECT SYSDATE FROM DUAL
c9khh2t00tx8bSelect substr(Text, 1, 512) as 源码, rownum as line From All_Source Where Owner = 'ZLTOOLS' And Name = 'F_REG_AUDIT' And Line in (3, 5, 7, 9, 11) Order by Line
cam7tqqfxksj8SELECT T_REG_RECORD(:b1 , :b2 , "功能" ) FROM (SELECT G."功能" , R."功能" R_YES , P."功能" P_YES FROM (SELECT DISTINCT G."功能" FROM ZLROLEGRANT G , SYS.DBA_ROLE_PRIVS R WHERE R.GRANTEE = USER AND G."角色" = R.GRANTED_ROLE AND G."系统" = :b1 AND G."序号" = :b2 ) G , (SELECT R."功能" FROM ZLREGFUNC R WHERE R."系统" = TRUNC(:b1 / 100 ) AND R."序号" = :b2 ) R , (SELECT P."功能" FROM ZLREPORTS B , ZLRPTPUTS P WHERE P."报表ID" = B.ID AND B."系统" IS NULL AND P."系统" = :b1 AND P."程序ID" = :b2 ) P WHERE G."功能" = R."功能" (+) AND G."功能" = P."功能" (+) ) WHERE R_YES IS NOT NULL OR P_YES IS NOT NULL
cbg98qms8a3q7 Select A.ID, A.类别 as 类别ID, B.序号 as 顺序ID, B.名称 as 类别, A.编码, A.名称, A.商品名, A.简码, D.门诊单位 as 单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Decode(A.是否变价, 1, '时价', LTrim(To_Char(Sum(C.现价)*Nvl(D.门诊包装, 1), '9999990.00000'))) as 单价, LTrim(To_Char(X.库存/Nvl(D.门诊包装, 1), '9999990.00000')) as 库存 From ( Select Distinct A.ID, A.类别, A.编码, B.名称, Null as 商品名, 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.撤档时间=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 And B.码类=:V005 Or B.名称 Like :V006 And B.码类=:V007 Or B.简码 Like :V008 And B.码类 IN(:V009, 3))) A, 收费项目类别 B, 收费价目 C, 药品规格 D, 诊疗项目目录 E, ( Select A.药品ID, 0 as 非所属部门, Sum(Nvl(A.可用数量, 0)) as 库存 From 药品库存 A, 收费项目目录 B Where A.性质=1 And (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 Sum(Nvl(A.可用数量, 0))<>0) X Where A.类别=B.编码 And A.ID=C.收费细目ID And A.ID=D.药品ID And D.药名ID=E.ID And A.ID=X.药品ID(+) And ( (instr( ';6;7;', ';'||A.类别||';', 1)>0 and nvl(D.中药形态, 0)=:V013) or A.类别='5') And Sysdate Between C.执行日期 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.是否变价, X.库存, D.门诊单位, D.门诊包装 Union ALL 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 ( Select Distinct A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, D.名称 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A, 保险支付项目 C, 保险支付大类 D Where A.服务对象 IN(:V014, 3) And A.ID=B.收费细目ID And A.类别='4' And (A.编码 Like :V015 Or B.名称 Like :V016 Or B.简码 Like :V017) And B.码类=:V018 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.险类(+)=:V019 And C.大类ID=D.ID(+)) A, 收费项目类别 B, 收费价目 C, 材料特性 D, 诊疗项目目录 E Where A.类别=B.编码 And A.ID=C.收费细目ID And nvl(D.核算材料 , 0)=0 And A.ID=D.材料ID And D.诊疗ID=E.ID And Sysdate Between C.执行日期 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.计算单位 Union ALL 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(:V020, 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.险类(+)=:V021 And C.大类ID=D.ID(+) And Instr(:V022, A.类别)>0 And (A.编码 Like :V023 Or B.名称 Like :V024 Or B.简码 Like :V025) And B.码类=:V026) 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, 编码
ccaw9t4jvasj2SELECT B.名称, 开单人, SUM(实收金额) FROM ZLHIS.病人费用记录 A, ZLHIS.部门表 B WHERE A.开单部门ID=B.ID AND A.登记时间 BETWEEN To_Date(:V001, 'YYYY-MM-DD') AND To_Date(:V002, 'YYYY-MM-DD HH24:MI:SS') AND (门诊标志=:V003 OR 门诊标志=:V004) AND 记录状态<>0 AND A.开单部门ID IN (SELECT ID FROM ZLHIS.部门表 START WITH ID=:V005 CONNECT BY PRIOR ID=上级ID) GROUP BY B.名称, A.开单人
chtn34u7bwttjINSERT INTO ZLREGAUDIT ( "项目" , "内容" ) VALUES ( '支持商URL' , :b1 )
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#
cr1wa975acfv7 Select 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 库存 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')) Gr oup 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 Null Or A.效期>Trunc(Sysdate)) And A.库房ID=Decode(B.类别, '5', :V010, '6', :V 011, '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(+) 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 库存 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 Inst r(: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.简码 Li ke :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 库存 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), 类别, 编码
dkgvzu0nwqdmw Select A.ID, A.类别 as 类别ID, B.序号 as 顺序ID, B.名称 as 类别, A.编码, A.名称, A.商品名, A.简码, D.门诊单位 as 单位, A.规格, A.产地, A.费用类型, A.医保大类, A.说明, Decode(A.是否变价, 1, '时价', LTrim(To_Char(Sum(C.现价)*Nvl(D.门诊包装, 1), '9999990.00000'))) as 单价, LTrim(To_Char(X.库存/Nvl(D.门诊包装, 1), '9999990.00000')) as 库存 From ( Select Distinct A.ID, A.类别, A.编码, B.名称, Null as 商品名, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, Null 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.服务对象 IN(:V001, 3) And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null) And Instr(:V002, A.类别)>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, 收费项目类别 B, 收费价目 C, 药品规格 D, 诊疗项目目录 E, ( Select A.药品ID, 0 as 非所属部门, Sum(Nvl(A.可用数量, 0)) as 库存 From 药品库存 A, 收费项目目录 B Where A.性质=1 And (Nvl(A.批次, 0)=0 Or A.效期 Is Null Or A.效期 > Trunc(Sysdate)) And A.库房ID=Decode(B.类别, '5', :V009, '6', :V010, '7', :V011, Null) And A.药品ID=B.ID And B.类别 IN('5', '6', '7') Group by A.药品ID Having Sum(Nvl(A.可用数量, 0))<>0) X Where A.类别=B.编码 And A.ID=C.收费细目ID And A.ID=D.药品ID And D.药名ID=E.ID And A.ID=X.药品ID(+) And ( (instr( ';6;7;', ';'||A.类别||';', 1)>0 and nvl(D.中药形态, 0)=:V012) or A.类别=' 5') And Sysdate Between C.执行日期 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.是否变价, X.库存, D.门诊单位, D.门诊包装 Union ALL 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 ( Select Distinct A.ID, A.类别, A.编码, B.名称, B.简码, A.计算单位, A.规格, A.产地, A.费用类型, Null 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.服务对象 IN(:V013, 3) And A.ID=B.收费细目ID And A.类别='4' And (A.编码 Like :V014 Or B.名称 Like :V015 Or B.简码 Like :V016) And B.码类=:V017 And (A.撤档时间=To_Date('3000-01-01', 'YYYY-MM-DD') Or A.撤档时间 IS NULL) And (A.站点='-' Or A.站点 is Null)) A, 收费项目类别 B, 收费价目 C, 材料特性 D, 诊疗项目目录 E Where A.类别=B.编码 And A.ID=C.收费细目ID And nvl(D.核算材料 , 0)=0 And A.ID=D.材料ID And D.诊疗ID=E.ID And Sysdate Between C.执行日期 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.计算单位 Union ALL 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.费用类型, Nu ll 医保大类, A.说明, A.是否变价 From 收费项目别名 B, 收费项目目录 A Where A.ID=B.收费细目ID And A.服务对象 IN(:V018, 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 Instr(:V019, A.类别)>0 And (A.编码 Like :V020 Or B.名称 Like :V021 Or B.简码 Like :V022) And B.码类=:V023) 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, 编码
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
f9rxqw86hgn7zSelect ID, Nvl(系统, 0) as 系统, Nvl(模块, 0) as 模块, Nvl(私有, 0) as 私有, Nvl(本机, 0) as 本机, Nvl(授权, 0) as 授权, 参数号, 参数名, Nvl(参数值, 缺省值) as 参数值, :V001 as 用户名, :V002 as 机器名 From zlParameters
fmj9czt4f6prqCall Zl_电子病历记录_Update(:V001, :V002, :V003, :V004, :V005, :V006, :V007, :V008, :V009)
fud7uuxqfupwwSelect Upper(号码) as 号码 From 票据使用明细 Where 号码||''>=:V001 And 领用ID=:V002 Order by 号码
fy5d79ukcwkn7Select 1 as 类别, 部门ID From 部门人员 Where 人员ID=:V001 Union Select Distinct 2 as 类别, B.科室ID From 部门人员 A, 病区科室对应 B Where A.部门ID=B.病区ID And A.人员ID=:V002
g1mgh60hg3rf6 Select /*+ RULE */ 病人id, 病人来源, 病人姓名, 病人科室, 性别, 年龄, 就诊卡号, 标识号, 当前床号, Sum(decode(状态, '未登记', 1, 0)) As 未登记, Sum(decode(状态, '已登记', 1, 0)) As 已登记, Sum(decode(状态, '拒收', 1, 0)) As 拒收, Sum(decode(状态, '已执行', 1, 0)) As 已执行, Sum(decode(紧急, '紧急', 1, 0)) As 紧急, Sum(重采) As 重采 From (Select distinct a.病人id, decode(a.病人来源, 1, '门诊', 2, '住院', 3, '院外', 4, '体验') as 病人来源, c.姓名 as 病人姓名, e.名称 as 病人科室, c.性别, c.年龄, c.就诊卡号, b.样本条码, decode(b.执行状态, 1, '已执行', 2, '拒收', 3, '已执行', decode(b.接收人, null, '未登记', '已登记')) as 状态, decode(A.病人来源, 1, C.门诊号, 2, C.住院号) As 标识号, decode(c.当前床号, null, decode(l.出院病床, null, l.入院病床, l.出院病床), c.当前床号) as 当前床号 , decode(a.紧急标志, 1, '紧急', decode(g.急诊, 1, '紧急')) as 紧急 , decode(b.执行状态, 0, '', 2, '拒收') as 拒收, nvl(b.接收批次, 0) as 接收批次, b.接收时间, nvl(b.重采标本, 0) as 重采 From 病人医嘱记录 A, 病人医嘱发送 B, 病人信息 C, 部门表 E, 诊疗项目目录 F, 病人挂号记录 G, 病人医嘱记录 H, 诊疗项目目录 K , 病案主页 L, 病人医嘱发送 M Where A.ID = H.相关ID And H.id = B.医嘱id And A.病人id = C.病人id And A.病人科室id = E.ID And A.诊疗项目id = f.ID And h.诊疗项目ID = k.id And A.挂号单 = G.No(+) and (g.病人ID is null or (g.记录状态=1 and g.记录性质 =1) ) and f.类别 = 'E' and F.操作类型 = '6' and a.病人id = l.病人ID(+) and a.执行科室ID + 0 in (Select * From Table(Cast(f_Num2list(:V001) As zlTools.t_Numlist))) And A.ID = M.医嘱ID And k.试管编码 is not null and B.执行状态 in (0, 1, 2, 3) And A.病人来源 in (2, 0) and m.发送时间 Between :V002 and :V003) Group By 病人id, 病人来源, 病人姓名, 病人科室, 性别, 年龄, 就诊卡号, 标识号, 当前床号 Order by 病人科室
g9pzukdxxmx42SELECT NVL(COUNT (*) , 0 ) FROM (SELECT A."内容" FROM ZLREGAUDIT A WHERE A."项目" = '授权证章' ) A , (SELECT R."内容" FROM ZLREGINFO R WHERE R."项目" = '授权证章' ) R WHERE A."内容" = TRANSLATE(R."内容" , '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ' , :b1 )
grwydz59pu6mcselect text from view$ where rowid=:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 156,040 43.69 14.96
CPU used when call started 131,620 36.86 12.62
CR blocks created 64,258 17.99 6.16
Cached Commit SCN referenced 180 0.05 0.02
Commit SCN cached 1 0.00 0.00
DB time 4,574,909 1,281.05 438.67
DBWR checkpoint buffers written 24,997 7.00 2.40
DBWR checkpoints 48 0.01 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR revisited being-written buffer 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 22,872 6.40 2.19
DBWR transaction table writes 346 0.10 0.03
DBWR undo block writes 112,163 31.41 10.75
IMU CR rollbacks 1,898 0.53 0.18
IMU Flushes 1,544 0.43 0.15
IMU Redo allocation size 27,627,784 7,736.23 2,649.13
IMU commits 8,174 2.29 0.78
IMU contention 118 0.03 0.01
IMU ktichg flush 253 0.07 0.02
IMU pool not allocated 933 0.26 0.09
IMU recursive-transaction flush 67 0.02 0.01
IMU undo allocation size 72,393,136 20,271.27 6,941.52
IMU- failed to get a private strand 933 0.26 0.09
Misses for writing mapping 0 0.00 0.00
PX local messages recv'd 0 0.00 0.00
PX local messages sent 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 0 0.00 0.00
SQL*Net roundtrips to/from client 5,750,192 1,610.15 551.37
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 103,278 28.92 9.90
application wait time 118,013 33.05 11.32
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 46 0.01 0.00
background checkpoints started 48 0.01 0.00
background timeouts 12,619 3.53 1.21
branch node splits 25 0.01 0.00
buffer is not pinned count 267,493,762 74,902.65 25,649.03
buffer is pinned count 469,863,082 131,569.38 45,053.51
bytes received via SQL*Net from client 261,121,993 73,118.45 25,038.07
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 2,793,697,847 782,281.30 267,877.83
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 5,213,387 1,459.83 499.89
calls to kcmgas 362,337 101.46 34.74
calls to kcmgcs 27,497 7.70 2.64
change write time 3,687 1.03 0.35
cleanout - number of ktugct calls 93,897 26.29 9.00
cleanouts and rollbacks - consistent read gets 53,798 15.06 5.16
cleanouts only - consistent read gets 777 0.22 0.07
cluster key scan block gets 141,493 39.62 13.57
cluster key scans 72,404 20.27 6.94
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 119 0.03 0.01
commit batch/immediate requested 119 0.03 0.01
commit cleanout failures: block lost 440 0.12 0.04
commit cleanout failures: buffer being written 11 0.00 0.00
commit cleanout failures: callback failure 125 0.04 0.01
commit cleanout failures: cannot pin 55 0.02 0.01
commit cleanouts 107,752 30.17 10.33
commit cleanouts successfully completed 107,121 30.00 10.27
commit immediate performed 119 0.03 0.01
commit immediate requested 119 0.03 0.01
commit txn count during cleanout 15,625 4.38 1.50
concurrency wait time 514 0.14 0.05
consistent changes 4,820,498 1,349.82 462.22
consistent gets 450,824,183 126,238.18 43,227.94
consistent gets - examination 276,193,955 77,338.85 26,483.26
consistent gets direct 114 0.03 0.01
consistent gets from cache 450,824,069 126,238.15 43,227.93
current blocks converted for CR 42,352 11.86 4.06
cursor authentications 11,645 3.26 1.12
data blocks consistent reads - undo records applied 4,809,672 1,346.79 461.18
db block changes 19,923,474 5,578.90 1,910.39
db block gets 32,012,624 8,964.06 3,069.58
db block gets direct 140 0.04 0.01
db block gets from cache 32,012,484 8,964.02 3,069.56
deferred (CURRENT) block cleanout applications 31,792 8.90 3.05
dirty buffers inspected 91,293 25.56 8.75
doubling up with imu segment 0 0.00 0.00
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 2,282 0.64 0.22
enqueue deadlocks 0 0.00 0.00
enqueue releases 182,689 51.16 17.52
enqueue requests 182,866 51.21 17.53
enqueue timeouts 48 0.01 0.00
enqueue waits 57 0.02 0.01
exchange deadlocks 1 0.00 0.00
execute count 4,769,365 1,335.50 457.32
failed probes on index block reclamation 25 0.01 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 12,448,898 3,485.90 1,193.68
free buffer requested 12,480,571 3,494.76 1,196.72
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 20,630 5.78 1.98
hot buffers moved to head of LRU 769,933 215.59 73.83
immediate (CR) block cleanout applications 54,576 15.28 5.23
immediate (CURRENT) block cleanout applications 39,782 11.14 3.81
index crx upgrade (found) 14 0.00 0.00
index crx upgrade (positioned) 70,021 19.61 6.71
index fast full scans (full) 6,308 1.77 0.60
index fetch by key 168,146,543 47,083.79 16,122.98
index scans kdiixs1 4,646,686 1,301.15 445.55
leaf node 90-10 splits 3,284 0.92 0.31
leaf node splits 9,091 2.55 0.87
lob reads 10,789 3.02 1.03
lob writes 268 0.08 0.03
lob writes unaligned 268 0.08 0.03
local undo segment hints helped 0 0.00 0.00
logons cumulative 383 0.11 0.04
messages received 68,790 19.26 6.60
messages sent 68,790 19.26 6.60
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 174,026,723 48,730.34 16,686.81
opened cursors cumulative 550,218 154.07 52.76
parse count (failures) 308 0.09 0.03
parse count (hard) 27,687 7.75 2.65
parse count (total) 461,560 129.24 44.26
parse time cpu 6,584 1.84 0.63
parse time elapsed 46,227 12.94 4.43
physical read IO requests 1,724,917 483.01 165.40
physical read bytes ############### 28,271,647.72 9,681,105.14
physical read total IO requests 1,735,387 485.94 166.40
physical read total bytes ############### 28,945,558.54 9,911,873.49
physical read total multi block requests 795,024 222.62 76.23
physical reads 12,324,737 3,451.13 1,181.78
physical reads cache 12,312,591 3,447.73 1,180.61
physical reads cache prefetch 10,591,030 2,965.66 1,015.54
physical reads direct 12,146 3.40 1.16
physical reads direct (lob) 112 0.03 0.01
physical reads direct temporary tablespace 9,778 2.74 0.94
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 71,772 20.10 6.88
physical write bytes 2,039,234,560 571,019.18 195,535.00
physical write total IO requests 95,761 26.81 9.18
physical write total bytes 6,790,756,352 1,901,523.36 651,141.66
physical write total multi block requests 41,460 11.61 3.98
physical writes 248,930 69.70 23.87
physical writes direct 17,354 4.86 1.66
physical writes direct (lob) 2 0.00 0.00
physical writes direct temporary tablespace 14,973 4.19 1.44
physical writes from cache 231,576 64.85 22.21
physical writes non checkpoint 239,782 67.14 22.99
pinned buffers inspected 777 0.22 0.07
prefetch clients - default 9 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 371 0.10 0.04
process last non-idle time 3,605 1.01 0.35
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 6,352,606 1,778.83 609.13
recursive cpu usage 66,903 18.73 6.42
redo blocks written 4,430,948 1,240.74 424.87
redo buffer allocation retries 1,412 0.40 0.14
redo entries 10,040,513 2,811.51 962.75
redo log space requests 1,422 0.40 0.14
redo log space wait time 18,927 5.30 1.81
redo ordering marks 69,113 19.35 6.63
redo size 2,190,278,384 613,313.94 210,018.06
redo subscn max counts 121,287 33.96 11.63
redo synch time 134,968 37.79 12.94
redo synch writes 10,126 2.84 0.97
redo wastage 3,253,216 910.95 311.94
redo write time 130,529 36.55 12.52
redo writer latching time 0 0.00 0.00
redo writes 11,652 3.26 1.12
rollback changes - undo records applied 4,447,766 1,245.45 426.48
rollbacks only - consistent read gets 52,920 14.82 5.07
rows fetched via callback 5,249,020 1,469.81 503.31
session connect time 0 0.00 0.00
session cursor cache hits 270,886 75.85 25.97
session logical reads 482,836,808 135,202.24 46,297.52
session pga memory 368,154,888 103,089.42 35,301.07
session pga memory max 953,434,376 266,977.29 91,421.46
session uga memory ############### 73,421,029.40 25,141,679.47
session uga memory max 2,610,089,800 730,868.03 250,272.30
shared hash latch upgrades - no wait 265,573 74.36 25.46
shared hash latch upgrades - wait 8,148 2.28 0.78
sorts (disk) 0 0.00 0.00
sorts (memory) 1,508,037 422.28 144.60
sorts (rows) 14,643,357 4,100.38 1,404.10
space was found by tune down 0 0.00 0.00
sql area evicted 26,023 7.29 2.50
sql area purged 320 0.09 0.03
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 1,135,542 317.97 108.88
switch current to new buffer 15,943 4.46 1.53
table fetch by rowid 274,861,250 76,965.67 26,355.48
table fetch continued row 346,246 96.95 33.20
table scan blocks gotten 24,746,206 6,929.34 2,372.83
table scan rows gotten 1,503,017,262 420,869.53 144,119.02
table scans (cache partitions) 0 0.00 0.00
table scans (long tables) 451 0.13 0.04
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 130,189 36.46 12.48
total number of times SMON posted 238 0.07 0.02
transaction rollbacks 119 0.03 0.01
transaction tables consistent read rollbacks 5 0.00 0.00
transaction tables consistent reads - undo records applied 563 0.16 0.05
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 485,649,956 135,989.97 46,567.26
user I/O wait time 4,570,931 1,279.94 438.29
user calls 5,733,751 1,605.54 549.79
user commits 10,357 2.90 0.99
user rollbacks 72 0.02 0.01
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 15 0.00 0.00
workarea executions - optimal 1,481,211 414.76 142.03
write clones created in background 3 0.00 0.00
write clones created in foreground 575 0.16 0.06

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 9,079,489 9,085,958
opened cursors current 15,067 19,267
workarea memory allocated 8,541 121,056
logons current 237 303

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 48 48.39

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)
ZL9EPRDAT 789,064 221 21.32 11.69 12,562 4 51,588 16.98
ZL9EXPENSE 282,307 79 25.24 2.54 3,052 1 87,541 17.36
UNDOTBS1 176,632 49 26.38 1.00 29,581 8 26,255 27.50
SYSTEM 170,713 48 25.47 8.26 324 0 40,745 20.34
ZL9PATIENT 78,964 22 20.52 4.84 1,339 0 24,630 15.11
ZL9INDEXHIS 57,454 16 27.58 1.00 6,601 2 15,005 21.08
ZL9INDEXCIS 52,498 15 25.89 1.00 8,028 2 2,015 39.14
ZL9CISREC 51,233 14 31.23 1.97 3,878 1 5 4.00
ZLBASEITEM 23,798 7 21.20 4.53 397 0 8 6.25
ZL9MEDLST 19,429 5 27.88 1.00 591 0 2,076 17.25
ZL9BASEITEM 6,392 2 22.87 1.60 273 0 4 17.50
ZLTOOLSTBS 3,642 1 27.87 1.06 487 0 5 4.00
ZLPATIENT 2,736 1 12.65 3.90 366 0 3 36.67
SYSAUX 1,273 0 19.45 1.09 720 0 0 0.00
ZLSOFTTMP 792 0 50.49 9.88 928 0 0 0.00
ZL9EPRLOB 1,012 0 30.41 1.00 185 0 1 120.00
ZL9MEDREC 638 0 31.19 1.00 75 0 0 0.00
ZLTOOLSTMP 348 0 32.33 1.00 196 0 0 0.00
TEMP 92 0 44.35 7.72 404 0 0 0.00
ZL9MEDBASE 200 0 32.50 3.36 46 0 0 0.00
ZL9INDEXMDR 95 0 34.53 1.00 61 0 0 0.00
ZL9OPSDATA 97 0 39.59 1.00 58 0 0 0.00
ZL9MTLBASE 71 0 49.15 1.45 46 0 0 0.00
ZLBAK2009 70 0 49.43 1.00 46 0 0 0.00
ZL9MEDDAY 57 0 49.47 1.00 46 0 0 0.00
ZL9INDEXIFT 52 0 41.35 1.00 46 0 0 0.00
ZL9PEISDATA 51 0 66.67 1.00 46 0 0 0.00
DRSYS 46 0 33.04 1.00 46 0 0 0.00
INDX 46 0 44.57 1.00 46 0 0 0.00
RBS 46 0 38.48 1.00 46 0 0 0.00
USERS 46 0 93.70 1.00 46 0 0 0.00
ZL9CISAUDIT 46 0 34.13 1.00 46 0 0 0.00
ZL9DEVBASE 46 0 63.48 1.00 46 0 0 0.00
ZL9DEVREC 46 0 57.17 1.00 46 0 0 0.00
ZL9DEVUSE 46 0 54.78 1.00 46 0 0 0.00
ZL9DUEREC 46 0 42.39 1.00 46 0 0 0.00
ZL9HISTORY 46 0 56.74 1.00 46 0 0 0.00
ZL9IFTBASE 46 0 36.52 1.00 46 0 0 0.00
ZL9IFTREC 46 0 43.04 1.00 46 0 0 0.00
ZL9INDEXDEV 46 0 79.35 1.00 46 0 0 0.00
ZL9INDEXHISTORY 46 0 56.74 1.00 46 0 0 0.00
ZL9INDEXMTL 46 0 68.48 1.00 46 0 0 0.00
ZL9INDEXorcl 46 0 40.87 1.00 46 0 0 0.00
ZL9I_YB 46 0 78.70 1.00 46 0 0 0.00
ZL9MTLREC 46 0 70.22 1.00 46 0 0 0.00
ZLADVICE 46 0 58.26 1.00 46 0 0 0.00
ZLBAK01 46 0 35.43 1.00 46 0 0 0.00
ZLBAK2008 46 0 61.30 1.00 46 0 0 0.00
ZLBAK2011 46 0 49.57 1.00 46 0 0 0.00
ZLPERBASE 46 0 67.17 1.00 46 0 0 0.00
ZLPERDATA 46 0 119.78 1.00 46 0 0 0.00
ZLSOFTTBS 46 0 37.39 1.00 46 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)
DRSYS D:\ORACLE\ORADATA\ORAL\DR01.DBF 46 0 33.04 1.00 46 0 0 0.00
INDX D:\ORACLE\ORADATA\ORAL\INDX01.DBF 46 0 44.57 1.00 46 0 0 0.00
RBS D:\ORACLE\ORADATA\ORAL\RBS01.DBF 46 0 38.48 1.00 46 0 0 0.00
SYSAUX D:\ORACLE\ORADATA\ORAL\SYSAUX01.DBF 1,273 0 19.45 1.09 720 0 0 0.00
SYSTEM D:\ORACLE\ORADATA\ORAL\SYSTEM01.DBF 170,713 48 25.47 8.26 324 0 40,745 20.34
TEMP D:\ORACLE\ORADATA\ORAL\TEMP01.DBF 92 0 44.35 7.72 404 0 0  
UNDOTBS1 D:\ORACLE\ORADATA\ORAL\UNDOTBS01.DBF 176,632 49 26.38 1.00 29,581 8 26,255 27.50
USERS D:\ORACLE\ORADATA\ORAL\USERS01.DBF 46 0 93.70 1.00 46 0 0 0.00
ZL9BASEITEM D:\ORACLE\ORADATA\ORAL\ZL9BASEITEM.DBF 6,392 2 22.87 1.60 273 0 4 17.50
ZL9CISAUDIT D:\ORACLE\ORADATA\ORAL\ZL9CISAUDIT.DBF 46 0 34.13 1.00 46 0 0 0.00
ZL9CISREC D:\ORACLE\ORADATA\ORAL\ZL9CISREC.DBF 51,233 14 31.23 1.97 3,878 1 5 4.00
ZL9DEVBASE D:\ORACLE\ORADATA\ORAL\ZL9DEVBASE.DBF 46 0 63.48 1.00 46 0 0 0.00
ZL9DEVREC D:\ORACLE\ORADATA\ORAL\ZL9DEVREC.DBF 46 0 57.17 1.00 46 0 0 0.00
ZL9DEVUSE D:\ORACLE\ORADATA\ORAL\ZL9DEVUSE.DBF 46 0 54.78 1.00 46 0 0 0.00
ZL9DUEREC D:\ORACLE\ORADATA\ORAL\ZL9DUEREC.DBF 46 0 42.39 1.00 46 0 0 0.00
ZL9EPRDAT D:\ORACLE\ORADATA\ORAL\ZL9EPRDAT.DBF 789,064 221 21.32 11.69 12,562 4 51,588 16.98
ZL9EPRLOB D:\ORACLE\ORADATA\ORAL\ZL9EPRLOB.DBF 1,012 0 30.41 1.00 185 0 1 120.00
ZL9EXPENSE D:\ORACLE\ORADATA\ORAL\ZL9EXPENSE.DBF 282,307 79 25.24 2.54 3,052 1 87,541 17.36
ZL9HISTORY D:\ORACLE\ORADATA\ORAL\ZL9HISTORY.DBF 46 0 56.74 1.00 46 0 0 0.00
ZL9IFTBASE D:\ORACLE\ORADATA\ORAL\ZL9IFTBASE.DBF 46 0 36.52 1.00 46 0 0 0.00
ZL9IFTREC D:\ORACLE\ORADATA\ORAL\ZL9IFTREC.DBF 46 0 43.04 1.00 46 0 0 0.00
ZL9INDEXCIS D:\ORACLE\ORADATA\ORAL\ZL9INDEXCIS.DBF 52,498 15 25.89 1.00 8,028 2 2,015 39.14
ZL9INDEXDEV D:\ORACLE\ORADATA\ORAL\ZL9INDEXDEV.DBF 46 0 79.35 1.00 46 0 0 0.00
ZL9INDEXHIS D:\ORACLE\ORADATA\ORAL\ZL9INDEXHIS.DBF 57,454 16 27.58 1.00 6,601 2 15,005 21.08
ZL9INDEXHISTORY D:\ORACLE\ORADATA\ORAL\ZL9INDEXHISTORY.DBF 46 0 56.74 1.00 46 0 0 0.00
ZL9INDEXIFT D:\ORACLE\ORADATA\ORAL\ZL9INDEXIFT.DBF 52 0 41.35 1.00 46 0 0 0.00
ZL9INDEXMDR D:\ORACLE\ORADATA\ORAL\ZL9INDEXMDR.DBF 95 0 34.53 1.00 61 0 0 0.00
ZL9INDEXMTL D:\ORACLE\ORADATA\ORAL\ZL9INDEXMTL.DBF 46 0 68.48 1.00 46 0 0 0.00
ZL9INDEXorcl D:\ORACLE\ORADATA\ORAL\ZL9INDEXORCL.DBF 46 0 40.87 1.00 46 0 0 0.00
ZL9I_YB D:\ORACLE\ORADATA\ORAL\ZL9I_YB.DBF 46 0 78.70 1.00 46 0 0 0.00
ZL9MEDBASE D:\ORACLE\ORADATA\ORAL\ZL9MEDBASE.DBF 200 0 32.50 3.36 46 0 0 0.00
ZL9MEDDAY D:\ORACLE\ORADATA\ORAL\ZL9MEDDAY.DBF 57 0 49.47 1.00 46 0 0 0.00
ZL9MEDLST D:\ORACLE\ORADATA\ORAL\ZL9MEDLST.DBF 19,429 5 27.88 1.00 591 0 2,076 17.25
ZL9MEDREC D:\ORACLE\ORADATA\ORAL\ZL9MEDREC.DBF 638 0 31.19 1.00 75 0 0 0.00
ZL9MTLBASE D:\ORACLE\ORADATA\ORAL\ZL9MTLBASE.DBF 71 0 49.15 1.45 46 0 0 0.00
ZL9MTLREC D:\ORACLE\ORADATA\ORAL\ZL9MTLREC.DBF 46 0 70.22 1.00 46 0 0 0.00
ZL9OPSDATA D:\ORACLE\ORADATA\ORAL\ZL9OPSDATA.DBF 97 0 39.59 1.00 58 0 0 0.00
ZL9PATIENT D:\ORACLE\ORADATA\ORAL\ZL9PATIENT.DBF 78,964 22 20.52 4.84 1,339 0 24,630 15.11
ZL9PEISDATA D:\ORACLE\ORADATA\ORAL\ZL9PEISDATA.DBF 51 0 66.67 1.00 46 0 0 0.00
ZLADVICE D:\ORACLE\ORADATA\ORAL\ZLADVICE.DBF 46 0 58.26 1.00 46 0 0 0.00
ZLBAK01 D:\ORACLE\ORADATA\ORAL\ZLBAK01.DBF 46 0 35.43 1.00 46 0 0 0.00
ZLBAK2008 D:\ORACLE\ORADATA\ORAL\ZLBAK2008.DBF 46 0 61.30 1.00 46 0 0 0.00
ZLBAK2009 D:\ORACLE\ORADATA\ORAL\ZLBAK2009.DBF 70 0 49.43 1.00 46 0 0 0.00
ZLBAK2011 D:\ORACLE\ORADATA\ORAL\ZLBAK2011.DBF 46 0 49.57 1.00 46 0 0 0.00
ZLBASEITEM D:\ORACLE\ORADATA\ORAL\ZLBASEITEM.DBF 23,798 7 21.20 4.53 397 0 8 6.25
ZLPATIENT D:\ORACLE\ORADATA\ORAL\ZLPATIENT.DBF 2,736 1 12.65 3.90 366 0 3 36.67
ZLPERBASE D:\ORACLE\ORADATA\ORAL\ZLPERBASE.DBF 46 0 67.17 1.00 46 0 0 0.00
ZLPERDATA D:\ORACLE\ORADATA\ORAL\ZLPERDATA.DBF 46 0 119.78 1.00 46 0 0 0.00
ZLSOFTTBS D:\ORACLE\ORADATA\ORAL\ZLSOFTTBS.DBF 46 0 37.39 1.00 46 0 0 0.00
ZLSOFTTMP D:\ORACLE\ORADATA\ORAL\ZLSOFTTMP.DBF 792 0 50.49 9.88 928 0 0  
ZLTOOLSTBS D:\ORACLE\ORADATA\ORAL\ZLTOOLSTBS.DBF 3,642 1 27.87 1.06 487 0 5 4.00
ZLTOOLSTMP D:\ORACLE\ORADATA\ORAL\ZLTOOLSTMP.DBF 348 0 32.33 1.00 196 0 0  

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 68,308 97 482,344,540 12,305,586 231,389 0 0 251,841


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 12 765 9827 25533 184320 25533  
E 0 19 2089 179345 184320 184320 390425  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 48 0.08 5,937 4.65 15,043,220,107
D 96 0.17 11,874 3.65 11,827,194,119
D 144 0.25 17,811 2.66 8,628,329,495
D 192 0.33 23,748 1.68 5,455,484,764
D 240 0.42 29,685 1.54 5,000,116,173
D 288 0.50 35,622 1.41 4,551,875,780
D 336 0.58 41,559 1.27 4,109,956,323
D 384 0.67 47,496 1.13 3,673,191,611
D 432 0.75 53,433 1.10 3,563,136,443
D 480 0.83 59,370 1.07 3,454,045,867
D 528 0.92 65,307 1.03 3,345,833,012
D 576 1.00 71,244 1.00 3,238,385,245
D 624 1.08 77,181 0.99 3,196,879,349
D 672 1.17 83,118 0.97 3,155,603,029
D 720 1.25 89,055 0.96 3,114,529,367
D 768 1.33 94,992 0.95 3,073,669,970
D 816 1.42 100,929 0.94 3,037,396,193
D 864 1.50 106,866 0.93 3,000,348,982
D 912 1.58 112,803 0.91 2,962,337,769
D 960 1.67 118,740 0.90 2,922,736,528

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.66 35,686 486

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 808 343 677.11 8.34 1.23 100.00 0.00 102,400
E 808 251 942.71 117.03 12.41 100.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 1,446,242 1,446,242 0 0
64K 128K 1,481 1,481 0 0
128K 256K 1,466 1,466 0 0
256K 512K 676 676 0 0
512K 1024K 17,294 17,294 0 0
1M 2M 13,844 13,844 0 0
2M 4M 73 71 2 0
4M 8M 62 62 0 0
16M 32M 11 7 4 0
32M 64M 15 6 9 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
101 0.13 55,335,191.62 3,593,654.76 94.00 516,657
202 0.25 55,335,191.62 3,559,280.18 94.00 515,521
404 0.50 55,335,191.62 2,050,621.53 96.00 289,039
606 0.75 55,335,191.62 164,725.08 100.00 64
808 1.00 55,335,191.62 124,442.66 100.00 0
970 1.20 55,335,191.62 54,377.34 100.00 0
1,131 1.40 55,335,191.62 54,377.34 100.00 0
1,293 1.60 55,335,191.62 54,377.34 100.00 0
1,454 1.80 55,335,191.62 54,377.34 100.00 0
1,616 2.00 55,335,191.62 54,377.34 100.00 0
2,424 3.00 55,335,191.62 54,377.34 100.00 0
3,232 4.00 55,335,191.62 54,377.34 100.00 0
4,848 6.00 55,335,191.62 54,377.34 100.00 0
6,464 8.00 55,335,191.62 54,377.34 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
144 0.16 107 8,218 64,699,539 0.91 7,239,372 14.10 968,461,298
240 0.26 199 10,992 65,564,048 0.92 6,374,863 12.41 971,932,813
336 0.37 294 12,717 66,426,422 0.93 5,512,489 10.73 975,355,544
432 0.47 389 16,116 67,282,754 0.94 4,656,157 9.07 978,731,062
528 0.58 484 19,648 68,131,894 0.95 3,807,017 7.41 982,053,736
624 0.68 579 23,557 68,970,669 0.97 2,968,242 5.78 985,320,949
720 0.79 674 26,869 69,798,220 0.98 2,140,691 4.17 988,533,607
816 0.89 769 30,108 70,615,825 0.99 1,323,086 2.58 991,693,918
912 1.00 864 32,950 71,425,363 1.00 513,548 1.00 994,804,082
1,008 1.11 959 36,214 72,228,773 1.01 1 0.00 997,867,722
1,104 1.21 1,054 39,819 73,025,881 1.02 1 0.00 1,000,888,722
1,200 1.32 1,149 43,526 73,814,784 1.03 1 0.00 1,003,871,466
1,296 1.42 1,244 47,154 74,595,774 1.04 1 0.00 1,006,820,927
1,392 1.53 1,339 51,011 75,370,884 1.06 1 0.00 1,009,742,092
1,488 1.63 1,434 54,661 76,141,393 1.07 1 0.00 1,012,640,319
1,584 1.74 1,529 61,621 76,908,294 1.08 1 0.00 1,015,521,355
1,680 1.84 1,624 65,927 77,672,883 1.09 1 0.00 1,018,390,903
1,776 1.95 1,719 69,361 78,436,282 1.10 1 0.00 1,021,254,114
1,872 2.05 1,872 77,809 79,199,271 1.11 1 0.00 1,024,114,807

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
384 0.25 21,787,123 5,455,311,750
768 0.50 13,050,712 3,673,251,881
1,152 0.75 9,635,039 3,238,342,485
1,536 1.00 6,341,762 3,238,342,485
1,920 1.25 4,892,035 3,000,324,312
2,304 1.50 4,586,996 2,922,604,093
2,688 1.75 4,586,996 2,922,604,093
3,072 2.00 4,586,996 2,922,604,093

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

Java Pool Size(M)JP 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
16 1.00 6 100 1 1.00 513,549 1.00 100
32 2.00 6 100 1 1.00 513,549 1.00 100

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 223,301 4,033 18
undo block 25,838 712 28
1st level bmb 10 0 19
undo header 4 0 0
segment header 1 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 13 10 0 13 1,180 90,741.54
CF-Controlfile Transaction 2,627 2,622 5 30 17 583.30
TX-Transaction 36,296 36,294 0 1 12 12,109.00
TX-Transaction (index contention) 40 40 0 12 1 92.42
HW-Segment High Water Mark 759 759 0 1 0 171.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
1 69.52 37,582 18,884 17 47.15/325.75 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
25-6月 09:01 748 2,136 3,690 17 77 0/0 0/0/0/0/0/0
25-6月 08:51 680 2,182 3,384 15 67 0/0 0/0/0/0/0/0
25-6月 08:41 880 3,223 2,776 15 57 0/0 0/0/0/0/0/0
25-6月 08:31 456 2,275 2,168 12 47 0/0 0/0/0/0/0/0
25-6月 08:21 33,107 12,568 18,884 9 326 0/0 0/0/0/0/0/0
25-6月 08:11 33,311 13,957 18,274 7 316 0/0 0/0/0/0/0/0
25-6月 08:01 335 1,241 17,664 5 305 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 db client latch 2,324 0.00   0 0  
AWR Alerted Metric Element list 35,727 0.00   0 0  
Consistent RBA 11,683 0.00   0 0  
FAL request queue 168 0.00   0 0  
FAL subheap alocation 168 0.00   0 0  
FIB s.o chain latch 406 0.00   0 0  
FOB s.o list latch 4,633 0.15 0.00 0 0  
In memory undo latch 137,638 0.00 1.00 0 15,668 0.05
JS mem alloc latch 6 0.00   0 0  
JS queue access latch 6 0.00   0 0  
JS queue state obj latch 25,882 0.00   0 0  
JS slv state obj latch 19 0.00   0 0  
KMG MMAN ready and startup request latch 1,195 0.00   0 0  
KTF sga latch 12 0.00   0 1,157 0.00
KWQMN job cache list latch 8 0.00   0 0  
MQL Tracking Latch 0     0 70 0.00
Memory Management Latch 0     0 1,195 0.00
OS process 795 0.00   0 0  
OS process allocation 1,792 0.00   0 0  
OS process: request allocation 576 0.00   0 0  
PL/SQL warning settings 4,219 0.00   0 0  
SGA IO buffer pool latch 790,457 0.09 0.04 0 790,466 0.08
SQL memory manager latch 1,784 0.22 0.75 0 1,149 0.00
SQL memory manager workarea list latch 532,673 0.00   0 0  
Shared B-Tree 128 0.00   0 0  
active checkpoint queue latch 59,148 4.54 0.00 0 0  
active service list 8,294 0.00   0 1,208 0.00
archive control 214 0.00   0 0  
archive process latch 1,608 0.06 0.00 0 0  
begin backup scn array 7 0.00   0 0  
cache buffer handles 225,514 0.00 0.00 0 0  
cache buffers chains 760,595,851 0.23 0.00 0 24,645,063 0.00
cache buffers lru chain 539,293 0.14 0.00 0 25,962,925 0.10
cache table scan latch 0     0 790,025 0.13
channel handle pool latch 1,045 0.00   0 0  
channel operations parent latch 19,470 0.07 0.00 0 0  
checkpoint queue latch 1,458,116 0.00 0.00 0 231,616 0.00
client/application info 3,379 0.00   0 0  
commit callback allocation 142 0.00   0 0  
compile environment latch 382 0.00   0 0  
constraint object allocation 54 0.00   0 0  
dictionary lookup 1 0.00   0 0  
dml lock allocation 136,858 0.00 0.00 0 0  
dummy allocation 698 0.00   0 0  
enqueue hash chains 368,070 0.00 0.00 0 4,614 0.00
enqueues 426,252 0.02 0.00 0 0  
event group latch 321 0.00   0 0  
file cache latch 555 0.00   0 0  
global KZLD latch for mem in SGA 315 0.00   0 0  
hash table column usage latch 1,152 0.00   0 7,136,392 0.00
hash table modification latch 112 0.00   0 0  
internal temp table object number allocation latc 58 0.00   0 0  
job workq parent latch 0     0 122 0.00
job_queue_processes parameter latch 120 0.00   0 0  
kks stats 151,520 0.00 0.00 0 0  
kmcptab latch 1 0.00   0 0  
kmcpvec latch 0     0 1 0.00
kokc descriptor allocation latch 1,586 0.00   0 0  
krbmrosl 4 0.00   0 0  
ksuosstats global area 241 0.00   0 0  
ktm global data 237 0.00   0 0  
kwqbsn:qsga 128 0.00   0 0  
lgwr LWN SCN 11,642 0.00   0 0  
library cache 8,350,912 0.01 0.01 0 148,390 0.02
library cache load lock 26,075 0.00 0.00 0 3 0.00
library cache lock 2,335,432 0.01 0.00 0 0  
library cache lock allocation 45,166 0.00   0 0  
library cache pin 3,598,680 0.00 0.00 0 0  
library cache pin allocation 35,838 0.00   0 0  
list of block allocation 2,037 0.00   0 0  
loader state object freelist 812 0.00   0 0  
longop free list parent 4,360 0.00   0 32 0.00
message pool operations parent latch 478 0.00   0 0  
messages 186,938 0.56 0.00 0 0  
mostly latch-free SCN 11,679 0.02 0.00 0 0  
multiblock read objects 1,675,035 0.02 0.00 0 0  
ncodef allocation latch 58 0.00   0 0  
object queue header heap 17,540 0.00   0 16,981 0.00
object queue header operation 25,549,855 0.00 0.01 0 0  
object stats modification 528 0.00   0 0  
parallel query alloc buffer 460 0.00   0 0  
parameter list 38 0.00   0 0  
parameter table allocation management 333 0.00   0 0  
post/wait queue 16,362 0.03 0.00 0 10,739 0.00
process allocation 582 0.00   0 321 0.00
process group creation 576 0.00   0 0  
qmn task queue latch 512 0.00   0 0  
redo allocation 73,252 0.12 0.00 0 10,031,066 0.01
redo copy 0     0 10,031,344 0.00
redo writing 99,335 2.17 0.00 0 0  
resmgr group change latch 623 0.00   0 0  
resmgr:active threads 695 0.00   0 0  
resmgr:actses change group 362 0.00   0 0  
resmgr:free threads list 694 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 39,182,208 0.03 0.00 0 29,178 0.01
sequence cache 3,830,152 0.00 0.00 0 0  
session allocation 1,137,484 0.02 0.00 0 0  
session idle bit 11,747,795 0.00 0.00 0 0  
session state list latch 1,559 0.00   0 0  
session switching 116 0.00   0 0  
session timer 1,208 0.00   0 0  
shared pool 5,379,958 0.10 0.12 0 0  
shared pool simulator 8,346,570 0.00 0.03 0 0  
simulator hash latch 25,253,305 0.00 0.00 0 0  
simulator lru latch 230,969 0.06 0.00 0 23,554,880 0.12
slave class 2 0.00   0 0  
slave class create 8 0.00   0 0  
sort extent pool 2,067 0.48 0.00 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 359 0.56 0.00 0 0  
threshold alerts latch 1,389 0.00   0 0  
transaction allocation 957 0.00   0 0  
transaction branch allocation 1,208 0.00   0 0  
undo global data 427,275 0.49 0.00 0 312 0.00
user lock 2,064 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 760,595,851 1,739,123 3,433 1,735,653 0 0 0
row cache objects 39,182,208 11,779 6 11,773 0 0 0
shared pool 5,379,958 5,147 620 4,599 0 0 0
library cache 8,350,912 966 7 959 0 0 0
SGA IO buffer pool latch 790,457 672 29 643 0 0 0
object queue header operation 25,549,855 196 1 195 0 0 0
shared pool simulator 8,346,570 78 2 76 0 0 0
SQL memory manager latch 1,784 4 3 1 0 0 0
In memory undo latch 137,638 2 2 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 2 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 19 29
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 10 0
SQL memory manager latch qesmmIQueryRefreshBound 0 2 3
SQL memory manager latch qesmmIDeamonCb 0 1 0
cache buffers chains kcbgtcr: kslbegin excl 0 14,417 14,355
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 9,187 6,122
cache buffers chains kcbgtcr: kslbegin shared 0 565 351
cache buffers chains kcbrls: kslbegin 0 459 433
cache buffers chains kcbzwb 0 279 188
cache buffers chains kcbgtcr: fast path 0 205 315
cache buffers chains kcbchg: kslbegin: call CR func 0 152 3,001
cache buffers chains kcbzib: multi-block read: nowait 0 19 0
cache buffers chains kcbzib: finish free bufs 0 12 2
cache buffers chains kcbgcur: kslbegin 0 4 4
cache buffers chains kcbcge 0 3 18
cache buffers chains kcbzgb: scan from tail. nowait 0 3 0
cache buffers chains kcbget: pin buffer 0 2 5
cache buffers chains kcbgtcr 0 2 0
cache buffers chains kcb_is_private 0 1 537
cache buffers chains kcbbxsv 0 1 1
cache buffers chains kcbnew: new latch again 0 1 0
library cache kgldte: child 0 0 1 3
library cache lock kgllkdl: child: no lock handle 0 1 1
object queue header operation kcbo_link_q:reget 0 1 0
row cache objects kqreqd: reget 0 3 0
row cache objects kqreqd 0 1 2
shared pool kghalo 0 468 288
shared pool kgh_next_free 0 93 1
shared pool kghupr1 0 40 66
shared pool kghfrunp: alloc: wait 0 12 0
shared pool kghfrunp: clatch: nowait 0 6 0
shared pool kghfre 0 5 230
shared pool kghalp 0 2 34
shared pool kghfrunp: clatch: wait 0 1 0
shared pool simulator kglsim_unpin_simhp 0 2 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 ZL9CISREC 病人医嘱记录_PK   INDEX 187,238,144 38.78
ZLHIS ZL9CISREC 病人医嘱记录   TABLE 93,984,944 19.47
SYS SYSTEM I_SYSAUTH1   INDEX 49,367,472 10.22
ZLHIS ZL9BASEITEM 收费项目目录   TABLE 17,908,864 3.71
ZLHIS ZL9BASEITEM 收费项目目录_PK   INDEX 16,815,600 3.48

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ZLHIS ZL9EPRDAT 电子病历时机   TABLE 8,724,764 70.79
SYS SYSTEM OBJ$   TABLE 1,336,718 10.85
ZLHIS ZL9EXPENSE 住院费用记录   TABLE 596,544 4.84
ZLHIS ZL9EPRDAT 电子病历记录   TABLE 473,081 3.84
ZLHIS ZL9PATIENT 病人变动记录   TABLE 218,968 1.78

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 62 25.73
ZLHIS ZL9PATIENT 病人信息_PK   INDEX 50 20.75
ZLHIS ZL9CISREC 检验标本记录_PK   INDEX 31 12.86
ZLHIS ZL9INDEXCIS 电子病历时机_IX_文件ID   INDEX 22 9.13
ZLHIS ZLBASEITEM 号码控制表   TABLE 8 3.32

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
ZLHIS ZL9EPRDAT 电子病历时机   TABLE 943 97.62
ZLHIS ZL9PATIENT 病案主页   TABLE 6 0.62
ZLHIS ZLBASEITEM 号码控制表   TABLE 4 0.41
ZLHIS ZLBASEITEM 票据打印内容_ID   INDEX 3 0.31
ZLHIS ZL9INDEXCIS 电子病历时机_IX_文件ID   INDEX 2 0.21

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 62 0.00 0   2 1
dc_database_links 636 0.00 0   0 1
dc_global_oids 9,538 4.80 0   1 95
dc_histogram_data 2,489,226 0.21 0   0 3,610
dc_histogram_defs 743,356 0.90 0   154 2,936
dc_object_grants 46,513 1.89 0   0 1,377
dc_object_ids 2,953,382 0.06 0   11 1,179
dc_objects 198,371 6.31 0   27 2,177
dc_profiles 375 0.00 0   0 1
dc_rollback_segments 1,541 0.00 0   0 49
dc_segments 672,553 0.30 0   15 1,194
dc_sequences 12,852 0.30 0   12,852 16
dc_tablespace_quotas 11 45.45 0   11 1
dc_tablespaces 5,820,400 0.00 0   0 25
dc_usernames 77,577 0.53 0   0 121
dc_users 1,713,226 0.04 0   20 354
outstanding_alerts 662 47.43 0   0 0


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 777 0.64 38,005 0.05 13 0
CLUSTER 193 1.55 351 2.85 7 0
INDEX 38 50.00 101 18.81 0 0
SQL AREA 207,600 17.85 5,450,474 1.45 5,990 768
TABLE/PROCEDURE 132,840 4.74 1,937,502 0.67 7,393 0
TRIGGER 130 7.69 603 3.65 12 0


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 516.85   2.16 3.79 57 87 239 239
  Freeable 104.63 0.00 0.58 0.40 3   180 180
  SQL 49.07 28.19 0.21 0.40 5 42 229 225
  PL/SQL 6.35 3.89 0.03 0.02 0 0 237 237
  JAVA 0.96 0.96 0.96 0.00 1 1 1 1
E Other 638.81   2.09 3.34 57 87 305 305
  SQL 177.76 150.54 0.60 3.97 65 111 296 291
  Freeable 117.81 0.00 0.68 0.47 4   172 172
  PL/SQL 8.36 5.32 0.03 0.02 0 0 304 304
  JAVA 0.96 0.96 0.96 0.00 1 1 1 1

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 603,979,776  
Fixed Size 2,164,384  
Redo Buffers 4,325,376  
Variable Size 1,000,143,200  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 10.41 10.41 0.00
java joxlod exec hp 5.41 5.41 0.00
java joxs heap 0.18 0.18 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared ASH buffers 29.00 29.00 0.00
shared CCursor 153.96 137.63 -10.60
shared Heap0: KGL 27.22 24.77 -8.98
shared KGH: NO ACCESS 409.37 409.37 0.00
shared PCursor 66.14 56.67 -14.32
shared free memory 159.37 200.68 25.92
shared kglsim object batch 14.24 14.24 0.00
shared library cache 65.70 58.12 -11.53
shared sql area 241.56 249.75 3.39
  buffer_cache 576.00 576.00 0.00
  fixed_sga 2.06 2.06 0.00
  log_buffer 4.13 4.13 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

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
audit_file_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORAL\ADUMP   
background_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORAL\BDUMP   
compatible 10.2.0.3.0   
control_files D:\ORACLE\ORADATA\ORAL\CONTROL01.CTL, D:\ORACLE\ORADATA\ORAL\CONTROL02.CTL, D:\ORACLE\ORADATA\ORAL\CONTROL03.CTL   
core_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORAL\CDUMP   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name oral   
db_recovery_file_dest D:\oracle\product\10.2.0\flash_recovery_area   
db_recovery_file_dest_size 2147483648   
dispatchers (PROTOCOL=TCP) (SERVICE=oralXDB)   
job_queue_processes 10   
log_archive_dest_1 location=E:\archivelog   
open_cursors 300   
pga_aggregate_target 847249408   
processes 600   
remote_login_passwordfile EXCLUSIVE   
sga_target 1610612736   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORAL\UDUMP   


Back to Top

End of Report