WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORAL1090325199oral110.2.0.4.0NOX3850

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:694525-6月 -12 09:00:30303 63.6
End Snap:694625-6月 -12 10:00:58320 64.7
Elapsed:  60.46 (mins)  
DB Time:  703.04 (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: 58,430.75 11,536.46
Logical reads: 180,335.56 35,605.12
Block changes: 531.15 104.87
Physical reads: 4,655.25 919.12
Physical writes: 19.25 3.80
User calls: 2,392.04 472.28
Parses: 291.02 57.46
Hard parses: 12.72 2.51
Sorts: 129.53 25.57
Logons: 0.09 0.02
Executes: 733.61 144.84
Transactions: 5.06 

% Blocks changed per Read: 0.29Recursive Call %: 29.65
Rollback per transaction %: 0.46Rows per Sort: 30.14

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.97Redo NoWait %: 99.99
Buffer Hit %: 97.42In-memory Sort %: 100.00
Library Hit %: 97.05Soft Parse %: 95.63
Execute to Parse %: 60.33Latch Hit %: 99.83
Parse CPU to Parse Elapsd %: 20.04% Non-Parse CPU: 94.42

Shared Pool Statistics

BeginEnd
Memory Usage %: 78.00 79.00
% SQL with executions>1: 77.52 68.37
% Memory for SQL w/exec>1: 80.12 77.78

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
db file scattered read 1,183,630 22,083 19 52.4User I/O
db file sequential read 666,589 13,206 20 31.3User I/O
read by other session 195,031 3,313 17 7.9User I/O
CPU time  1,967  4.7 
log file sync 18,147 1,214 67 2.9Commit

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
sql execute elapsed time 40,433.56 95.85
DB CPU 1,967.15 4.66
parse time elapsed 1,020.90 2.42
hard parse elapsed time 853.50 2.02
PL/SQL execution elapsed time 232.81 0.55
hard parse (sharing criteria) elapsed time 132.39 0.31
hard parse (bind mismatch) elapsed time 122.27 0.29
PL/SQL compilation elapsed time 54.05 0.13
Java execution elapsed time 27.82 0.07
inbound PL/SQL rpc elapsed time 21.82 0.05
connection management call elapsed time 2.67 0.01
sequence load elapsed time 1.77 0.00
RMAN cpu time (backup/restore) 1.17 0.00
failed parse elapsed time 0.81 0.00
repeated bind elapsed time 0.74 0.00
DB time 42,182.65  
background elapsed time 2,603.99  
background cpu time 8.42  

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 2,051,529 0.00 38,882 19 111.66
System I/O 76,959 0.00 2,283 30 4.19
Commit 18,147 0.00 1,214 67 0.99
Application 825 14.30 365 443 0.04
Network 8,877,080 0.00 173 0 483.16
Configuration 84 27.38 60 715 0.00
Other 348 28.74 24 68 0.02
Concurrency 2,522 0.48 6 2 0.14

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
db file scattered read 1,183,630 0.00 22,083 19 64.42
db file sequential read 666,589 0.00 13,206 20 36.28
read by other session 195,031 0.00 3,313 17 10.62
log file sync 18,147 0.00 1,214 67 0.99
log file parallel write 17,891 0.00 952 53 0.97
db file parallel write 23,394 0.00 523 22 1.27
enq: TX - row lock contention 133 88.72 365 2741 0.01
control file parallel write 4,527 0.00 323 71 0.25
control file sequential read 30,604 0.00 264 9 1.67
Log archive I/O 234 0.00 196 836 0.01
SQL*Net more data from client 12,774 0.00 149 12 0.70
direct path write 1,529 0.00 118 77 0.08
direct path write temp 713 0.00 59 83 0.04
direct path read 3,261 0.00 58 18 0.18
direct path read temp 734 0.00 40 54 0.04
log file switch (checkpoint incomplete) 41 34.15 32 772 0.00
log file switch completion 42 19.05 27 653 0.00
enq: CF - contention 49 0.00 19 384 0.00
SQL*Net more data to client 145,580 0.00 19 0 7.92
log file sequential read 277 0.00 18 65 0.02
control file single write 24 0.00 7 277 0.00
SQL*Net message to client 8,718,726 0.00 5 0 474.54
buffer busy waits 50 6.00 4 80 0.00
Data file init write 20 0.00 4 184 0.00
enq: TX - contention 2 0.00 3 1418 0.00
LGWR wait for redo copy 189 52.91 2 8 0.01
enq: TX - index contention 16 0.00 1 93 0.00
write complete waits 1 100.00 1 999 0.00
db file parallel read 20 0.00 1 30 0.00
log file single write 8 0.00 1 72 0.00
SQL*Net break/reset to client 692 0.00 1 1 0.04
latch: shared pool 1,230 0.00 0 0 0.07
os thread startup 2 0.00 0 139 0.00
latch free 87 0.00 0 3 0.00
recovery area: computing obsolete files 2 0.00 0 90 0.00
cursor: pin S wait on X 10 90.00 0 14 0.00
db file single write 2 0.00 0 50 0.00
rdbms ipc reply 12 0.00 0 4 0.00
latch: library cache 17 0.00 0 1 0.00
latch: cache buffers chains 1,194 0.00 0 0 0.06
recovery area: computing dropped files 2 0.00 0 3 0.00
recovery area: computing backed up files 2 0.00 0 1 0.00
recovery area: computing applied logs 2 0.00 0 0 0.00
latch: In memory undo latch 1 0.00 0 0 0.00
latch: session allocation 1 0.00 0 0 0.00
latch: row cache objects 2 0.00 0 0 0.00
SQL*Net message from client 8,718,691 0.00 535,563 61 474.54
virtual circuit status 121 100.00 3,601 29758 0.01
Streams AQ: qmn slave idle wait 129 0.00 3,599 27896 0.01
Streams AQ: qmn coordinator idle wait 259 50.19 3,599 13894 0.01
jobq slave wait 1,182 94.67 3,498 2960 0.06
SGA: MMAN sleep for component shrink 82 31.71 0 5 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
log file parallel write 17,890 0.00 952 53 0.97
db file parallel write 23,353 0.00 522 22 1.27
Log archive I/O 233 0.00 194 833 0.01
control file parallel write 1,667 0.00 115 69 0.09
db file sequential read 5,792 0.00 100 17 0.32
control file sequential read 3,633 0.00 27 7 0.20
log file sequential read 245 0.00 16 64 0.01
events in waitclass Other 226 44.25 8 35 0.01
db file scattered read 163 0.00 4 27 0.01
direct path write 294 0.00 1 5 0.02
log file single write 8 0.00 1 72 0.00
direct path read 294 0.00 0 1 0.02
os thread startup 2 0.00 0 139 0.00
latch: shared pool 4 0.00 0 0 0.00
rdbms ipc message 28,956 42.71 39,950 1380 1.58
pmon timer 1,217 99.84 3,614 2969 0.07
Streams AQ: qmn slave idle wait 129 0.00 3,599 27896 0.01
Streams AQ: qmn coordinator idle wait 259 50.19 3,599 13894 0.01
smon timer 326 0.00 3,523 10806 0.02
SGA: MMAN sleep for component shrink 82 31.71 0 5 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 14,369
AVG_IDLE_TIME 346,098
AVG_SYS_TIME 1,845
AVG_USER_TIME 12,418
BUSY_TIME 231,674
IDLE_TIME 5,539,404
SYS_TIME 31,229
USER_TIME 200,445
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 41,303.70 1,770.40 16,652,479 613,502,809
oral 1,134.90 201.20 242,988 41,411,691
SYS$BACKGROUND 0.00 0.00 9,382 118,137
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 2012987 3779507 2486 597 0 0 3791930 17012
oral 30613 94550 25 1 0 0 5087024 295
SYS$BACKGROUND 8504 17206 6 28 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
15,713 241 31 506.88 37.25 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
15,490 235 38 407.64 36.72 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
2,732 31 188 14.53 6.48 0nnzp62vn7vux ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
2,308 11 132 17.49 5.47 0j80bq6arfp1h Zl9LISComm.exe select o.obj#, u.name from obj...
2,302 11 132 17.44 5.46 c9khh2t00tx8b Zl9LISComm.exe Select substr(Text, 1, 512) as...
1,519 4 132 11.51 3.60 fmj9czt4f6prq ZLHIS+.exe Call Zl_电子病历记录_Update(:V001, :...
1,492 3 75 19.89 3.54 532jygkmprqa3 ZLHIS+.exe UPDATE 电子病历时机 SET 完成时间 = NULL ...
1,099 9 38 28.93 2.61 an2zf90q9phjx ZLHIS+.exe Select A.出院方式, A.住院天数, A.主页ID,...
1,057 3 24 44.04 2.51 ccaw9t4jvasj2 ZLHIS+.exe SELECT B.名称, 开单人, SUM(实收金额) FR...
782 5 51 15.34 1.85 7pux7ymqn7z81 ZLHIS+.exe Select 0 As 入科标志, A.病人id, A....
749 2 18 41.62 1.78 bar657sdc6fg9 ZLHIS+.exe SELECT 收据费目, 开单人, SUM(实收金额) FR...
559 3 54 10.35 1.32 fud7uuxqfupww ZLHIS+.exe Select Upper(号码) as 号码 From 票据...
557 544 1,308 0.43 1.32 973barddfr983 ZLHIS+.exe Select b.时间, a.病人id, a.住院次数 ...
553 2 1,767 0.31 1.31 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
486 8 1,627 0.30 1.15 8taxaknvv24b6 ZLHIS+.exe Call ZL_病人医嘱发送_Insert(:V001, :...

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
544 557 1,308 0.42 1.32 973barddfr983 ZLHIS+.exe Select b.时间, a.病人id, a.住院次数 ...
241 15,713 31 7.77 37.25 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
235 15,490 38 6.19 36.72 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
86 90 782 0.11 0.21 dkgvzu0nwqdmw ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
46 46 50,796 0.00 0.11 0x1wutw2sxr85 Zl9LISComm.exe SELECT ZL_GET_REFERENCE(0, :B...
42 118 1 42.29 0.28 5pnqx62dqfv9x exp.exe SELECT SYNNAM, DBMS_JAVA.LONG...
40 40 374,187 0.00 0.10 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOW...
38 48 2,117 0.02 0.11 47vyxbdrj6zy9 Zl9LISComm.exe Select Text as 功能 From Table(C...
31 2,732 188 0.16 6.48 0nnzp62vn7vux ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
27 30 234 0.12 0.07 cbg98qms8a3q7 ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
11 2,308 132 0.09 5.47 0j80bq6arfp1h Zl9LISComm.exe select o.obj#, u.name from obj...
11 2,302 132 0.08 5.46 c9khh2t00tx8b Zl9LISComm.exe Select substr(Text, 1, 512) as...
9 1,099 38 0.23 2.61 an2zf90q9phjx ZLHIS+.exe Select A.出院方式, A.住院天数, A.主页ID,...
8 486 1,627 0.00 1.15 8taxaknvv24b6 ZLHIS+.exe Call ZL_病人医嘱发送_Insert(:V001, :...
5 782 51 0.10 1.85 7pux7ymqn7z81 ZLHIS+.exe Select 0 As 入科标志, A.病人id, A....
4 1,519 132 0.03 3.60 fmj9czt4f6prq ZLHIS+.exe Call Zl_电子病历记录_Update(:V001, :...
3 1,057 24 0.14 2.51 ccaw9t4jvasj2 ZLHIS+.exe SELECT B.名称, 开单人, SUM(实收金额) FR...
3 559 54 0.06 1.32 fud7uuxqfupww ZLHIS+.exe Select Upper(号码) as 号码 From 票据...
3 1,492 75 0.04 3.54 532jygkmprqa3 ZLHIS+.exe UPDATE 电子病历时机 SET 完成时间 = NULL ...
2 553 1,767 0.00 1.31 9rbfa58tjn76f ZLHIS+.exe Select Max(B.操作时间) as 时间 From ...
2 749 18 0.08 1.78 bar657sdc6fg9 ZLHIS+.exe SELECT 收据费目, 开单人, SUM(实收金额) FR...

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
466,263,775 1,308 356,470.78 71.28 543.98 556.73 973barddfr983 ZLHIS+.exe Select b.时间, a.病人id, a.住院次数 ...
32,650,325 2,117 15,422.92 4.99 37.56 48.40 47vyxbdrj6zy9 Zl9LISComm.exe Select Text as 功能 From Table(C...
32,250,535 973 33,145.46 4.93 25.19 27.76 0u495x9dbmb7f ZLHIS+.exe SELECT T_REG_RECORD(:b1 , :b2...
29,936,736 374,187 80.00 4.58 40.50 40.50 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOW...
22,398,855 782 28,643.04 3.42 85.99 89.52 dkgvzu0nwqdmw ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
13,392,571 31 432,018.42 2.05 240.92 15713.36 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
13,113,949 38 345,103.92 2.00 235.25 15490.42 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
6,724,871 234 28,738.76 1.03 27.13 30.43 cbg98qms8a3q7 ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
6,588,458 230 28,645.47 1.01 24.04 25.09 2w02jam1rfu7m ZLHIS+.exe Select A.ID, A.类别 as 类别ID, B....
3,601,580 10 360,158.00 0.55 9.03 24.15 5x28tr8dfhrmd ZLHIS+.exe Select /*+rule*/ H.ID, H.名称 A...

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
12,251,767 31 395,218.29 72.55 240.92 15713.36 bs6uun5x4v22z ZLHIS+.exe SELECT A.科室ID, A.责任人, A.文件ID...
11,965,485 38 314,881.18 70.86 235.25 15490.42 5bg8y87gqb2rt ZLHIS+.exe Call zl_病人变动记录_Out(:V001, :V00...
867,656 132 6,573.15 5.14 11.33 2308.26 0j80bq6arfp1h Zl9LISComm.exe select o.obj#, u.name from obj...
865,399 132 6,556.05 5.12 11.04 2301.69 c9khh2t00tx8b Zl9LISComm.exe Select substr(Text, 1, 512) as...
629,521 188 3,348.52 3.73 30.62 2731.89 0nnzp62vn7vux ZLHIS+.exe Select A.病人ID, A.主页ID, B.住院号, ...
372,629 38 9,806.03 2.21 8.77 1099.19 an2zf90q9phjx ZLHIS+.exe Select A.出院方式, A.住院天数, A.主页ID,...
287,868 1,627 176.93 1.70 7.58 486.44 8taxaknvv24b6 ZLHIS+.exe Call ZL_病人医嘱发送_Insert(:V001, :...
275,735 51 5,406.57 1.63 5.02 782.09 7pux7ymqn7z81 ZLHIS+.exe Select 0 As 入科标志, A.病人id, A....
77,699 132 588.63 0.46 4.09 1518.78 fmj9czt4f6prq ZLHIS+.exe Call Zl_电子病历记录_Update(:V001, :...
76,682 75 1,022.43 0.45 2.94 1491.58 532jygkmprqa3 ZLHIS+.exe UPDATE 电子病历时机 SET 完成时间 = NULL ...

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
381,348 0 0.00 0.00 0.00 95nvamhj37kmz exp.exe SELECT NAMESPACE, ATTRIBUTE ...
381,332 0 0.00 0.00 0.00 fj695q4p2ysg2 exp.exe SELECT POLGRP FROM SYS....
374,187 0 0.00 0.00 0.00 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOW...
57,519 57,518 1.00 0.00 0.00 c749bc43qqfz3 ZLHIS+.exe SELECT SYSDATE FROM DUAL
50,796 50,795 1.00 0.00 0.00 0x1wutw2sxr85 Zl9LISComm.exe SELECT ZL_GET_REFERENCE(0, :B...
19,896 19,896 1.00 0.00 0.00 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
15,376 9,176 0.60 0.00 0.01 04xtrk7uyhknh   select obj#, type#, ctime, mti...
13,275 13,275 1.00 0.00 0.00 6dv6fycjabduf ZLHIS+.exe select P.*, D.编码 as 部门编码, D.名称...
9,460 9,460 1.00 0.00 0.00 38hnxgpqkhurf ZLHIS+.exe Select 复查上限, 复查下限 From 检验项目参考...
9,425 9,425 1.00 0.00 0.00 grwydz59pu6mc   select text from view$ where r...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
374,187 374,187 35.44 7fprcxd5040cz exp.exe SELECT POLGRP, POLICY, POLOW...
56,191 57,519 5.32 c749bc43qqfz3 ZLHIS+.exe SELECT SYSDATE FROM DUAL
19,895 19,896 1.88 c1yr7s5676cm3 ZLHIS+.exe Select Zl_Lob_Read(:V001, :V00...
13,275 13,275 1.26 6dv6fycjabduf ZLHIS+.exe select P.*, D.编码 as 部门编码, D.名称...
9,460 9,460 0.90 38hnxgpqkhurf ZLHIS+.exe Select 复查上限, 复查下限 From 检验项目参考...
9,425 9,425 0.89 grwydz59pu6mc   select text from view$ where r...
7,121 15,376 0.67 04xtrk7uyhknh   select obj#, type#, ctime, mti...
6,801 6,801 0.64 cqgv56fmuj63x   select owner#, name, namespace...
6,800 6,800 0.64 8swypbbr0m372   select order#, columns, types ...
6,628 6,628 0.63 a8rdu73vtbs66 ZLHIS+.exe Select 医院编码 From 保险类别 Where 序号...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Sharable Mem (b)Executions % Total SQL IdSQL ModuleSQL Text
1,139,192 187 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,290 b6k4b1am0837g ZLHIS+.exe SELECT ID, 私有, 本机, 授权, SYS...
56 3,225 g9pzukdxxmx42 zlSvrStudio.exe SELECT NVL(COUNT (*) , 0 ) F...
43 126 71farxwf9kx0m Zl9LISComm.exe Select User, A.Id, A.编号, A.简...
41 1,476 0a45w3f97k65h ZLHIS+.exe Select /*+ RULE */ A.ID, A.相关I...
41 1,469 f0zj3p6vu1tqf Zl9LISComm.exe Select 参数ID, Nvl(用户名, 'NullUs...
37 130 3t32wcur3nm99 zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
37 129 5k8jr20q2bmv1 ZLHIS+.exe SELECT T_MENU_RECORD(M.层次, M....
37 1,121 cam7tqqfxksj8 Zl9LISComm.exe SELECT T_REG_RECORD(:b1 , :b2...
37 1,121 cam7tqqfxksj8 Zl9LISComm.exe SELECT T_REG_RECORD(:b1 , :b2...
37 1,469 f9rxqw86hgn7z Zl9LISComm.exe Select ID, Nvl(系统, 0) as 系统, N...
37 134 fy5d79ukcwkn7 ZLHIS+.exe Select 1 as 类别, 部门ID From 部门人员...
36 130 2ng5zrq77ssab zlSvrStudio.exe SELECT NVL(COUNT (*) , 0 ) F...
36 1,890 70wznctgyy8ms ZLHIS+.exe Select a.姓名, a.性别, a.年龄, b....
35 988 9jgwywty9dvy6 ZLHIS+.exe Select r.科室id 病人科室, Decode(b....
34 973 0u495x9dbmb7f ZLHIS+.exe SELECT T_REG_RECORD(:b1 , :b2...
33 130 chtn34u7bwttj zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 130 2hpt28zkqj3n8 zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 130 565yqxjyswv5h zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 133 58afvfqm7ja50 ZLHIS+.exe Select 部门ID, 工作性质, 服务对象 From 部...
32 2,281 63c3fzg565g2s ZLHIS+.exe Select Sum(费用余额) as 费用余额, Sum(...
32 130 abc96uy7pcvgs zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
32 1,890 aj1mmfscyf8f0 ZLHIS+.exe Select Distinct B.发生时间 as 挂号时间...
31 1,088 9btpmxat54c2z ZLHIS+.exe Select Count(*) as 数量 From 病案主...
30 130 0yfxa80q7t20w zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
30 130 2tds4dtjh0b3u zlSvrStudio.exe INSERT INTO ZLREGAUDIT ( "项目" ...
29 105 47pyw8050xz8p ZLHIS+.exe Select 序号, 医保部件, 医保包 From 保险类别...
28 751 0dtg7gj9qq7r5 ZLHIS+.exe Select A.ID, A.相关ID, A.序号, A....
28 979 202xz2txrbf2r zlSvrStudio.exe SELECT T_REG_RECORD("项目" , 0 ...
28 101 23t94ak3rbhq0 ZLHIS+.exe Select ID, Nvl(标本部位, '阳性(+);阴性...
28 130 3xfr7pah136aq zlSvrStudio.exe SELECT I."内容" FROM ZLREGINFO I...
28 2,802 837jfn1t399qb ZLHIS+.exe Select Distinct 0 as 发送号, B.操...
25 169 0axbx30kwm393 ZLHIS+.exe Select /*+ rule */ Distinct A...
25 3,214 drcyk4t07xnx4 ZLHIS+.exe SELECT 内容 FROM ZLREGINFO WHERE...
23 15,376 04xtrk7uyhknh   select obj#, type#, ctime, mti...
22 752 3fms6wzbhcadc ZLHIS+.exe Select /*+ Rule*/ A.ID, A.类别, ...
21 13,275 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 完成时间
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 )
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 "行号"
47pyw8050xz8pSelect 序号, 医保部件, 医保包 From 保险类别
47vyxbdrj6zy9Select Text as 功能 From Table(Cast(zltools.f_Reg_Func(:V001, :V002) as zlTools.t_Reg_Rowset))
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
5pnqx62dqfv9xSELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM2) SYNNAM2, DBMS_JAVA.LONGNAME(SYNTAB) SYNTAB, TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9SYN WHERE SYNOWNID != 0 ORDER BY SYNOWNID, SYNTIME
5x28tr8dfhrmdSelect /*+rule*/ H.ID, H.名称 As 科室名称, Nvl(A.领药号, 0) As 领药号, A.姓名, A.病人ID, B.性别, B.年龄, S.单据, S.NO, S.药品id, Decode(Nvl(C.医嘱序号, 0), 0, 0, 1) 医嘱序号, C.门诊标志, Nvl(S.扣率, 0) 扣率, S.ID As 收发id, S.填制日期, 0 As 拒发, Nvl(B.当前床号, '') As 床号 From 住院费用记录 C, 药品收发记录 S, 病人信息 B, 药品规格 D, 药品特性 T, 未发药品记录 A, 部门表 H Where A.对方部门id = H.ID And A.病人id = B.病人id And A.单据 = S.单据 And A.NO = S.NO And Nvl(A.库房id, :V001) = Nvl(S.库房id, :V002) And S.费用id = C.ID And Nvl(A.库房id, :V003) = Nvl(C.执行部门id, :V004) And S.药品id = D.药品id And D.药名id = T.药名id And (H.撤档时间 Is Null Or H.撤档时间 = To_Date('3000-01-01', 'yyyy-MM-dd')) And A.填制日期 Between :V005 And :V006 And S.审核日期 Is Null And Nvl(A.库房id, :V007) + 0 = :V008 And A.单据 IN(9, 10) And S.扣率 Is Not Null And (Ltrim(To_Char(Nvl(S.扣率, 0), '00')) Like '0_' Or Ltrim(To_Char(Nvl(S.扣率, 0), '00')) Like '1_') And Nvl(C.医嘱序号, 0) + 0 > 0 And Mod(S.记录状态, 3) = 1 And Not Exists (Select 1 From 病人费用销帐 X Where X.申请类别 = 0 And X.状态 = 0 And X.收费细目id = S.药品id And X.费用id = S.费用id) Order By 科室名称, ID, 领药号, 姓名, NO
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)
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
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
7fprcxd5040czSELECT POLGRP, POLICY, POLOWN, POLSCH, POLFUN, STMT, CHKOPT, ENABLED, SPOLICY FROM SYS.EXU9RLS WHERE OBJOWN = :1 AND OBJNAM = :2
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
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
8taxaknvv24b6Call ZL_病人医嘱发送_Insert(:V001, :V002, :V003, :V004, :V005, :V006, :V007, :V008, :V009, :V010, :V011, :V012, :V013, :V014, :V015, :V016, :V017)
95nvamhj37kmzSELECT NAMESPACE, ATTRIBUTE FROM SYS.EXU9PCT WHERE OBJOWN = :1 AND OBJNAM = :2
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
a8rdu73vtbs66Select 医院编码 From 保险类别 Where 序号=:V001
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, 编码
drcyk4t07xnx4SELECT 内容 FROM ZLREGINFO WHERE 项目 = '站点编号'
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
fj695q4p2ysg2SELECT POLGRP FROM SYS.EXU9PGP WHERE OBJOWN = :1 AND OBJNAM = :2
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
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 201,249 55.48 10.95
CPU used when call started 224,986 62.02 12.25
CR blocks created 34,886 9.62 1.90
Cached Commit SCN referenced 12,708 3.50 0.69
Commit SCN cached 1 0.00 0.00
DB time 5,373,285 1,481.25 292.46
DBWR checkpoint buffers written 9,132 2.52 0.50
DBWR checkpoints 4 0.00 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 499 0.14 0.03
DBWR transaction table writes 180 0.05 0.01
DBWR undo block writes 12,213 3.37 0.66
IMU CR rollbacks 4,358 1.20 0.24
IMU Flushes 4,528 1.25 0.25
IMU Redo allocation size 42,899,340 11,826.04 2,334.91
IMU commits 13,343 3.68 0.73
IMU contention 304 0.08 0.02
IMU ktichg flush 307 0.08 0.02
IMU pool not allocated 653 0.18 0.04
IMU recursive-transaction flush 62 0.02 0.00
IMU undo allocation size 115,413,672 31,816.04 6,281.70
IMU- failed to get a private strand 653 0.18 0.04
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 3 0.00 0.00
SQL*Net roundtrips to/from client 8,711,420 2,401.47 474.14
SQL*Net roundtrips to/from dblink 0 0.00 0.00
active txn count during cleanout 50,242 13.85 2.73
application wait time 36,507 10.06 1.99
auto extends on undo tablespace 0 0.00 0.00
background checkpoints completed 6 0.00 0.00
background checkpoints started 4 0.00 0.00
background timeouts 12,734 3.51 0.69
branch node splits 0 0.00 0.00
buffer is not pinned count 412,757,736 113,784.76 22,465.45
buffer is pinned count 668,316,803 184,234.62 36,374.94
bytes received via SQL*Net from client 700,428,362 193,086.80 38,122.70
bytes received via SQL*Net from dblink 0 0.00 0.00
bytes sent via SQL*Net to client 2,075,548,920 572,165.73 112,967.34
bytes sent via SQL*Net to dblink 0 0.00 0.00
calls to get snapshot scn: kcmgss 6,264,805 1,727.02 340.98
calls to kcmgas 99,812 27.52 5.43
calls to kcmgcs 3,577 0.99 0.19
change write time 660 0.18 0.04
cleanout - number of ktugct calls 37,640 10.38 2.05
cleanouts and rollbacks - consistent read gets 31,180 8.60 1.70
cleanouts only - consistent read gets 1,055 0.29 0.06
cluster key scan block gets 192,039 52.94 10.45
cluster key scans 101,545 27.99 5.53
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 126 0.03 0.01
commit batch/immediate requested 126 0.03 0.01
commit cleanout failures: block lost 612 0.17 0.03
commit cleanout failures: buffer being written 9 0.00 0.00
commit cleanout failures: callback failure 177 0.05 0.01
commit cleanout failures: cannot pin 69 0.02 0.00
commit cleanouts 99,149 27.33 5.40
commit cleanouts successfully completed 98,282 27.09 5.35
commit immediate performed 126 0.03 0.01
commit immediate requested 126 0.03 0.01
commit txn count during cleanout 10,171 2.80 0.55
concurrency wait time 626 0.17 0.03
consistent changes 240,137 66.20 13.07
consistent gets 651,844,122 179,693.60 35,478.37
consistent gets - examination 387,780,479 106,899.29 21,106.00
consistent gets direct 4,036 1.11 0.22
consistent gets from cache 651,840,087 179,692.49 35,478.15
current blocks converted for CR 2,087 0.58 0.11
cursor authentications 19,366 5.34 1.05
data blocks consistent reads - undo records applied 228,972 63.12 12.46
db block changes 1,926,770 531.15 104.87
db block gets 2,328,791 641.98 126.75
db block gets direct 1,350 0.37 0.07
db block gets from cache 2,327,441 641.60 126.68
deferred (CURRENT) block cleanout applications 31,766 8.76 1.73
dirty buffers inspected 23,171 6.39 1.26
doubling up with imu segment 0 0.00 0.00
drop segment calls in space pressure 0 0.00 0.00
enqueue conversions 3,034 0.84 0.17
enqueue deadlocks 0 0.00 0.00
enqueue releases 202,807 55.91 11.04
enqueue requests 202,881 55.93 11.04
enqueue timeouts 124 0.03 0.01
enqueue waits 72 0.02 0.00
exchange deadlocks 0 0.00 0.00
execute count 2,661,195 733.61 144.84
failed probes on index block reclamation 0 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 16,963,786 4,676.40 923.30
free buffer requested 16,937,431 4,669.13 921.87
global undo segment hints helped 0 0.00 0.00
global undo segment hints were stale 0 0.00 0.00
heap block compress 18,336 5.05 1.00
hot buffers moved to head of LRU 952,898 262.69 51.86
immediate (CR) block cleanout applications 32,235 8.89 1.75
immediate (CURRENT) block cleanout applications 7,094 1.96 0.39
index crx upgrade (found) 8 0.00 0.00
index crx upgrade (positioned) 88,047 24.27 4.79
index fast full scans (full) 7,452 2.05 0.41
index fetch by key 221,151,599 60,964.77 12,036.77
index scans kdiixs1 4,160,878 1,147.03 226.47
leaf node 90-10 splits 245 0.07 0.01
leaf node splits 631 0.17 0.03
lob reads 25,170 6.94 1.37
lob writes 3,367 0.93 0.18
lob writes unaligned 3,367 0.93 0.18
local undo segment hints helped 0 0.00 0.00
logons cumulative 326 0.09 0.02
messages received 41,971 11.57 2.28
messages sent 41,971 11.57 2.28
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 260,351,869 71,771.09 14,170.35
opened cursors cumulative 1,196,987 329.97 65.15
parse count (failures) 297 0.08 0.02
parse count (hard) 46,138 12.72 2.51
parse count (total) 1,055,695 291.02 57.46
parse time cpu 10,979 3.03 0.60
parse time elapsed 54,774 15.10 2.98
physical read IO requests 1,852,873 510.78 100.85
physical read bytes ############### 38,135,790.64 7,529,459.68
physical read total IO requests 1,884,523 519.51 102.57
physical read total bytes ############### 38,401,309.66 7,581,883.27
physical read total multi block requests 1,184,454 326.52 64.47
physical reads 16,887,056 4,655.25 919.12
physical reads cache 16,864,887 4,649.14 917.92
physical reads cache prefetch 15,017,788 4,139.95 817.38
physical reads direct 22,169 6.11 1.21
physical reads direct (lob) 2,967 0.82 0.16
physical reads direct temporary tablespace 17,839 4.92 0.97
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 30,549 8.42 1.66
physical write bytes 572,170,240 157,729.94 31,141.91
physical write total IO requests 62,494 17.23 3.40
physical write total bytes 1,289,187,840 355,389.89 70,167.52
physical write total multi block requests 22,531 6.21 1.23
physical writes 69,845 19.25 3.80
physical writes direct 23,174 6.39 1.26
physical writes direct (lob) 1,233 0.34 0.07
physical writes direct temporary tablespace 21,538 5.94 1.17
physical writes from cache 46,671 12.87 2.54
physical writes non checkpoint 63,161 17.41 3.44
pinned buffers inspected 1,475 0.41 0.08
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 292 0.08 0.02
process last non-idle time 3,590 0.99 0.20
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 3,657,868 1,008.36 199.09
recursive cpu usage 69,095 19.05 3.76
redo blocks written 438,357 120.84 23.86
redo buffer allocation retries 86 0.02 0.00
redo entries 905,322 249.57 49.27
redo log space requests 135 0.04 0.01
redo log space wait time 5,919 1.63 0.32
redo ordering marks 4,735 1.31 0.26
redo size 211,959,360 58,430.75 11,536.46
redo subscn max counts 11,092 3.06 0.60
redo synch time 121,066 33.37 6.59
redo synch writes 18,033 4.97 0.98
redo wastage 4,997,048 1,377.53 271.98
redo write time 94,988 26.19 5.17
redo writer latching time 158 0.04 0.01
redo writes 17,909 4.94 0.97
rollback changes - undo records applied 566,402 156.14 30.83
rollbacks only - consistent read gets 5,970 1.65 0.32
rows fetched via callback 6,047,879 1,667.22 329.17
session connect time 0 0.00 0.00
session cursor cache hits 785,829 216.63 42.77
session logical reads 654,172,820 180,335.56 35,605.12
session pga memory 116,825,760 32,205.31 6,358.56
session pga memory max 970,916,960 267,652.28 52,844.77
session uga memory ############### 74,572,855.75 14,723,526.15
session uga memory max 1,938,421,440 534,363.85 105,503.81
shared hash latch upgrades - no wait 179,813 49.57 9.79
shared hash latch upgrades - wait 23 0.01 0.00
sorts (disk) 1 0.00 0.00
sorts (memory) 469,878 129.53 25.57
sorts (rows) 14,162,362 3,904.13 770.82
space was found by tune down 0 0.00 0.00
sql area evicted 41,833 11.53 2.28
sql area purged 305 0.08 0.02
steps of tune down ret. in space pressure 0 0.00 0.00
summed dirty queue length 228,113 62.88 12.42
switch current to new buffer 29,206 8.05 1.59
table fetch by rowid 413,874,143 114,092.52 22,526.21
table fetch continued row 453,331 124.97 24.67
table scan blocks gotten 33,327,861 9,187.48 1,813.96
table scan rows gotten 1,974,976,573 544,440.99 107,493.42
table scans (cache partitions) 0 0.00 0.00
table scans (long tables) 472 0.13 0.03
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 1,303,947 359.46 70.97
total number of times SMON posted 324 0.09 0.02
transaction rollbacks 126 0.03 0.01
transaction tables consistent read rollbacks 7 0.00 0.00
transaction tables consistent reads - undo records applied 472 0.13 0.03
tune down retentions in space pressure 0 0.00 0.00
undo change vector size 42,909,708 11,828.90 2,335.48
user I/O wait time 3,876,019 1,068.50 210.96
user calls 8,677,211 2,392.04 472.28
user commits 18,288 5.04 1.00
user rollbacks 85 0.02 0.00
workarea executions - multipass 0 0.00 0.00
workarea executions - onepass 23 0.01 0.00
workarea executions - optimal 388,226 107.02 21.13
write clones created in background 1 0.00 0.00
write clones created in foreground 132 0.04 0.01

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 9,085,958 9,091,482
opened cursors current 19,267 20,719
workarea memory allocated 121,056 5,859
logons current 303 320

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 4 3.97

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 1,127,998 311 17.46 12.64 1,529 0 110,474 18.19
ZL9EXPENSE 214,231 59 21.57 1.80 3,970 1 22,473 16.98
SYSTEM 155,499 43 24.13 7.17 190 0 21,460 20.26
ZL9PATIENT 90,415 25 18.24 4.67 1,389 0 33,090 10.37
ZLBASEITEM 82,610 23 14.77 4.70 412 0 22 188.64
ZL9CISREC 71,753 20 24.08 2.71 7,475 2 69 15.22
ZL9INDEXHIS 44,803 12 25.02 1.00 7,938 2 4,114 19.71
ZL9INDEXCIS 21,247 6 22.07 1.02 2,214 1 68 17.65
UNDOTBS1 11,789 3 31.06 1.00 1,764 0 122 13.11
ZL9MEDLST 12,494 3 28.23 1.00 521 0 2,639 21.08
ZL9BASEITEM 9,397 3 17.82 1.26 329 0 0 0.00
ZLTOOLSTBS 4,279 1 23.26 1.22 395 0 2 0.00
SYSAUX 1,786 0 27.83 1.11 597 0 0 0.00
ZLPATIENT 1,559 0 18.66 2.28 243 0 1 0.00
TEMP 1,148 0 42.19 11.06 581 0 0 0.00
ZL9DUEREC 1,344 0 15.69 10.25 32 0 0 0.00
ZL9EPRLOB 1,140 0 27.35 1.00 168 0 0 0.00
ZL9MEDREC 901 0 28.35 1.00 210 0 0 0.00
ZLSOFTTMP 299 0 50.13 21.52 330 0 0 0.00
ZL9MEDBASE 544 0 25.40 3.13 6 0 0 0.00
ZLTOOLSTMP 321 0 22.18 1.00 126 0 0 0.00
ZL9MTLBASE 204 0 28.33 1.57 46 0 0 0.00
ZL9MTLREC 137 0 37.81 1.32 52 0 0 0.00
USERS 152 0 49.34 9.28 6 0 0 0.00
ZLBAK2009 152 0 34.87 1.03 6 0 0 0.00
ZL9OPSDATA 121 0 22.15 1.00 21 0 0 0.00
ZL9INDEXMDR 76 0 32.11 1.00 33 0 0 0.00
ZL9MEDDAY 59 0 46.10 8.97 6 0 0 0.00
ZLBAK2011 23 0 19.13 1.17 6 0 0 0.00
ZL9INDEXIFT 19 0 29.47 1.00 6 0 0 0.00
ZL9INDEXMTL 16 0 56.25 1.00 6 0 0 0.00
ZL9PEISDATA 14 0 81.43 1.00 6 0 0 0.00
ZL9IFTBASE 13 0 40.77 1.62 6 0 0 0.00
ZL9HISTORY 11 0 40.00 1.00 6 0 0 0.00
DRSYS 9 0 45.56 1.00 6 0 0 0.00
INDX 9 0 36.67 1.00 6 0 0 0.00
RBS 9 0 28.89 1.00 6 0 0 0.00
ZL9CISAUDIT 9 0 30.00 1.00 6 0 0 0.00
ZL9DEVBASE 9 0 45.56 1.00 6 0 0 0.00
ZL9DEVREC 9 0 36.67 1.00 6 0 0 0.00
ZL9DEVUSE 9 0 57.78 1.00 6 0 0 0.00
ZL9IFTREC 9 0 34.44 1.00 6 0 0 0.00
ZL9INDEXDEV 9 0 90.00 1.00 6 0 0 0.00
ZL9INDEXHISTORY 9 0 33.33 1.00 6 0 0 0.00
ZL9INDEXorcl 9 0 30.00 1.00 6 0 0 0.00
ZL9I_YB 9 0 61.11 1.00 6 0 0 0.00
ZLADVICE 9 0 35.56 1.00 6 0 0 0.00
ZLBAK01 9 0 26.67 1.00 6 0 0 0.00
ZLBAK2008 9 0 38.89 1.00 6 0 0 0.00
ZLPERBASE 9 0 44.44 1.00 6 0 0 0.00
ZLPERDATA 9 0 73.33 1.00 6 0 0 0.00
ZLSOFTTBS 9 0 26.67 1.00 6 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 9 0 45.56 1.00 6 0 0 0.00
INDX D:\ORACLE\ORADATA\ORAL\INDX01.DBF 9 0 36.67 1.00 6 0 0 0.00
RBS D:\ORACLE\ORADATA\ORAL\RBS01.DBF 9 0 28.89 1.00 6 0 0 0.00
SYSAUX D:\ORACLE\ORADATA\ORAL\SYSAUX01.DBF 1,786 0 27.83 1.11 597 0 0 0.00
SYSTEM D:\ORACLE\ORADATA\ORAL\SYSTEM01.DBF 155,499 43 24.13 7.17 190 0 21,460 20.26
TEMP D:\ORACLE\ORADATA\ORAL\TEMP01.DBF 1,148 0 42.19 11.06 581 0 0  
UNDOTBS1 D:\ORACLE\ORADATA\ORAL\UNDOTBS01.DBF 11,789 3 31.06 1.00 1,764 0 122 13.11
USERS D:\ORACLE\ORADATA\ORAL\USERS01.DBF 152 0 49.34 9.28 6 0 0 0.00
ZL9BASEITEM D:\ORACLE\ORADATA\ORAL\ZL9BASEITEM.DBF 9,397 3 17.82 1.26 329 0 0 0.00
ZL9CISAUDIT D:\ORACLE\ORADATA\ORAL\ZL9CISAUDIT.DBF 9 0 30.00 1.00 6 0 0 0.00
ZL9CISREC D:\ORACLE\ORADATA\ORAL\ZL9CISREC.DBF 71,753 20 24.08 2.71 7,475 2 69 15.22
ZL9DEVBASE D:\ORACLE\ORADATA\ORAL\ZL9DEVBASE.DBF 9 0 45.56 1.00 6 0 0 0.00
ZL9DEVREC D:\ORACLE\ORADATA\ORAL\ZL9DEVREC.DBF 9 0 36.67 1.00 6 0 0 0.00
ZL9DEVUSE D:\ORACLE\ORADATA\ORAL\ZL9DEVUSE.DBF 9 0 57.78 1.00 6 0 0 0.00
ZL9DUEREC D:\ORACLE\ORADATA\ORAL\ZL9DUEREC.DBF 1,344 0 15.69 10.25 32 0 0 0.00
ZL9EPRDAT D:\ORACLE\ORADATA\ORAL\ZL9EPRDAT.DBF 1,127,998 311 17.46 12.64 1,529 0 110,474 18.19
ZL9EPRLOB D:\ORACLE\ORADATA\ORAL\ZL9EPRLOB.DBF 1,140 0 27.35 1.00 168 0 0 0.00
ZL9EXPENSE D:\ORACLE\ORADATA\ORAL\ZL9EXPENSE.DBF 214,231 59 21.57 1.80 3,970 1 22,473 16.98
ZL9HISTORY D:\ORACLE\ORADATA\ORAL\ZL9HISTORY.DBF 11 0 40.00 1.00 6 0 0 0.00
ZL9IFTBASE D:\ORACLE\ORADATA\ORAL\ZL9IFTBASE.DBF 13 0 40.77 1.62 6 0 0 0.00
ZL9IFTREC D:\ORACLE\ORADATA\ORAL\ZL9IFTREC.DBF 9 0 34.44 1.00 6 0 0 0.00
ZL9INDEXCIS D:\ORACLE\ORADATA\ORAL\ZL9INDEXCIS.DBF 21,247 6 22.07 1.02 2,214 1 68 17.65
ZL9INDEXDEV D:\ORACLE\ORADATA\ORAL\ZL9INDEXDEV.DBF 9 0 90.00 1.00 6 0 0 0.00
ZL9INDEXHIS D:\ORACLE\ORADATA\ORAL\ZL9INDEXHIS.DBF 44,803 12 25.02 1.00 7,938 2 4,114 19.71
ZL9INDEXHISTORY D:\ORACLE\ORADATA\ORAL\ZL9INDEXHISTORY.DBF 9 0 33.33 1.00 6 0 0 0.00
ZL9INDEXIFT D:\ORACLE\ORADATA\ORAL\ZL9INDEXIFT.DBF 19 0 29.47 1.00 6 0 0 0.00
ZL9INDEXMDR D:\ORACLE\ORADATA\ORAL\ZL9INDEXMDR.DBF 76 0 32.11 1.00 33 0 0 0.00
ZL9INDEXMTL D:\ORACLE\ORADATA\ORAL\ZL9INDEXMTL.DBF 16 0 56.25 1.00 6 0 0 0.00
ZL9INDEXorcl D:\ORACLE\ORADATA\ORAL\ZL9INDEXORCL.DBF 9 0 30.00 1.00 6 0 0 0.00
ZL9I_YB D:\ORACLE\ORADATA\ORAL\ZL9I_YB.DBF 9 0 61.11 1.00 6 0 0 0.00
ZL9MEDBASE D:\ORACLE\ORADATA\ORAL\ZL9MEDBASE.DBF 544 0 25.40 3.13 6 0 0 0.00
ZL9MEDDAY D:\ORACLE\ORADATA\ORAL\ZL9MEDDAY.DBF 59 0 46.10 8.97 6 0 0 0.00
ZL9MEDLST D:\ORACLE\ORADATA\ORAL\ZL9MEDLST.DBF 12,494 3 28.23 1.00 521 0 2,639 21.08
ZL9MEDREC D:\ORACLE\ORADATA\ORAL\ZL9MEDREC.DBF 901 0 28.35 1.00 210 0 0 0.00
ZL9MTLBASE D:\ORACLE\ORADATA\ORAL\ZL9MTLBASE.DBF 204 0 28.33 1.57 46 0 0 0.00
ZL9MTLREC D:\ORACLE\ORADATA\ORAL\ZL9MTLREC.DBF 137 0 37.81 1.32 52 0 0 0.00
ZL9OPSDATA D:\ORACLE\ORADATA\ORAL\ZL9OPSDATA.DBF 121 0 22.15 1.00 21 0 0 0.00
ZL9PATIENT D:\ORACLE\ORADATA\ORAL\ZL9PATIENT.DBF 90,415 25 18.24 4.67 1,389 0 33,090 10.37
ZL9PEISDATA D:\ORACLE\ORADATA\ORAL\ZL9PEISDATA.DBF 14 0 81.43 1.00 6 0 0 0.00
ZLADVICE D:\ORACLE\ORADATA\ORAL\ZLADVICE.DBF 9 0 35.56 1.00 6 0 0 0.00
ZLBAK01 D:\ORACLE\ORADATA\ORAL\ZLBAK01.DBF 9 0 26.67 1.00 6 0 0 0.00
ZLBAK2008 D:\ORACLE\ORADATA\ORAL\ZLBAK2008.DBF 9 0 38.89 1.00 6 0 0 0.00
ZLBAK2009 D:\ORACLE\ORADATA\ORAL\ZLBAK2009.DBF 152 0 34.87 1.03 6 0 0 0.00
ZLBAK2011 D:\ORACLE\ORADATA\ORAL\ZLBAK2011.DBF 23 0 19.13 1.17 6 0 0 0.00
ZLBASEITEM D:\ORACLE\ORADATA\ORAL\ZLBASEITEM.DBF 82,610 23 14.77 4.70 412 0 22 188.64
ZLPATIENT D:\ORACLE\ORADATA\ORAL\ZLPATIENT.DBF 1,559 0 18.66 2.28 243 0 1 0.00
ZLPERBASE D:\ORACLE\ORADATA\ORAL\ZLPERBASE.DBF 9 0 44.44 1.00 6 0 0 0.00
ZLPERDATA D:\ORACLE\ORADATA\ORAL\ZLPERDATA.DBF 9 0 73.33 1.00 6 0 0 0.00
ZLSOFTTBS D:\ORACLE\ORADATA\ORAL\ZLSOFTTBS.DBF 9 0 26.67 1.00 6 0 0 0.00
ZLSOFTTMP D:\ORACLE\ORADATA\ORAL\ZLSOFTTMP.DBF 299 0 50.13 21.52 330 0 0  
ZLTOOLSTBS D:\ORACLE\ORADATA\ORAL\ZLTOOLSTBS.DBF 4,279 1 23.26 1.22 395 0 2 0.00
ZLTOOLSTMP D:\ORACLE\ORADATA\ORAL\ZLTOOLSTMP.DBF 321 0 22.18 1.00 126 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,299 97 654,171,114 16,869,269 46,843 0 0 194,859


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 19 2089 179345 184320 184320 390425  
E 0 13 1775 27635 140755 184320 140755  

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.63 15,084,479,881
D 96 0.17 11,874 3.64 11,860,226,054
D 144 0.25 17,811 2.66 8,654,840,201
D 192 0.33 23,748 1.68 5,476,829,295
D 240 0.42 29,685 1.54 5,020,019,660
D 288 0.50 35,622 1.40 4,570,869,896
D 336 0.58 41,559 1.27 4,128,254,124
D 384 0.67 47,496 1.13 3,690,870,035
D 432 0.75 53,433 1.10 3,580,545,412
D 480 0.83 59,370 1.07 3,471,253,473
D 528 0.92 65,307 1.03 3,362,861,227
D 576 1.00 71,244 1.00 3,255,254,900
D 624 1.08 77,181 0.99 3,213,671,595
D 672 1.17 83,118 0.97 3,172,324,669
D 720 1.25 89,055 0.96 3,131,183,203
D 768 1.33 94,992 0.95 3,090,265,707
D 816 1.42 100,929 0.94 3,053,938,888
D 864 1.50 106,866 0.93 3,016,838,446
D 912 1.58 112,803 0.92 2,978,731,863
D 960 1.67 118,740 0.90 2,938,437,719

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
98.36 39,939 666

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 251 942.71 117.03 12.41 100.00 0.00 102,400
E 808 194 953.81 6.68 0.70 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 345,613 345,613 0 0
64K 128K 1,417 1,417 0 0
128K 256K 1,960 1,960 0 0
256K 512K 870 870 0 0
512K 1024K 23,742 23,742 0 0
1M 2M 14,395 14,395 0 0
2M 4M 142 138 4 0
4M 8M 80 78 2 0
16M 32M 16 12 4 0
32M 64M 18 5 13 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,374,859.90 3,599,977.14 94.00 517,101
202 0.25 55,374,859.90 3,565,602.56 94.00 515,965
404 0.50 55,374,859.90 2,056,943.91 96.00 289,483
606 0.75 55,374,859.90 167,623.66 100.00 97
808 1.00 55,374,859.90 124,710.80 100.00 0
970 1.20 55,374,859.90 54,377.34 100.00 0
1,131 1.40 55,374,859.90 54,377.34 100.00 0
1,293 1.60 55,374,859.90 54,377.34 100.00 0
1,454 1.80 55,374,859.90 54,377.34 100.00 0
1,616 2.00 55,374,859.90 54,377.34 100.00 0
2,424 3.00 55,374,859.90 54,377.34 100.00 0
3,232 4.00 55,374,859.90 54,377.34 100.00 0
4,848 6.00 55,374,859.90 54,377.34 100.00 0
6,464 8.00 55,374,859.90 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 97 9,049 64,777,890 0.91 7,241,668 14.07 970,864,747
240 0.26 192 12,151 65,643,514 0.92 6,376,044 12.39 974,358,795
336 0.37 287 14,714 66,505,504 0.93 5,514,054 10.72 977,791,235
432 0.47 382 17,475 67,361,765 0.94 4,657,793 9.05 981,168,881
528 0.58 477 20,642 68,210,331 0.95 3,809,227 7.40 984,493,362
624 0.68 572 24,855 69,049,005 0.97 2,970,553 5.77 987,762,476
720 0.79 667 28,446 69,876,900 0.98 2,142,658 4.16 990,976,900
816 0.89 762 32,136 70,694,974 0.99 1,324,584 2.57 994,138,857
912 1.00 857 35,742 71,504,987 1.00 514,571 1.00 997,250,974
1,008 1.11 952 38,944 72,308,400 1.01 1 0.00 1,000,316,425
1,104 1.21 1,047 42,880 73,105,131 1.02 1 0.00 1,003,339,438
1,200 1.32 1,142 46,772 73,894,157 1.03 1 0.00 1,006,324,078
1,296 1.42 1,237 50,527 74,675,704 1.04 1 0.00 1,009,275,420
1,392 1.53 1,332 53,984 75,451,165 1.06 1 0.00 1,012,198,514
1,488 1.63 1,427 57,330 76,221,921 1.07 1 0.00 1,015,098,609
1,584 1.74 1,522 60,391 76,989,124 1.08 1 0.00 1,017,981,416
1,680 1.84 1,617 63,560 77,753,977 1.09 1 0.00 1,020,852,679
1,776 1.95 1,712 66,994 78,517,578 1.10 1 0.00 1,023,717,505
1,872 2.05 1,872 72,557 79,280,707 1.11 1 0.00 1,026,579,187

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,881,462 5,476,912,447
768 0.50 13,097,852 3,471,369,648
1,152 0.75 9,678,634 3,255,222,851
1,536 1.00 6,383,902 3,255,222,851
1,920 1.25 4,928,372 3,016,940,538
2,304 1.50 4,618,753 2,938,489,668
2,688 1.75 4,618,753 2,938,489,668
3,072 2.00 4,618,753 2,938,489,668

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 514,572 1.00 100
32 2.00 6 100 1 1.00 514,572 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 193,909 3,302 17
undo block 118 2 14
segment header 6 0 0
undo header 4 0 0
2nd level bmb 2 0 0

Back to Wait Statistics
Back to Top

Enqueue Activity

Enqueue Type (Request Reason)RequestsSucc GetsFailed GetsWaitsWt Time (s)Av Wt Time(ms)
TX-Transaction (row lock contention) 14 14 0 14 365 26,042.36
CF-Controlfile Transaction 6,419 6,298 121 40 19 468.43
TX-Transaction 22,549 22,550 0 2 3 1,414.00
TX-Transaction (index contention) 70 70 0 16 2 93.81

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 5.71 21,876 5,516 20 43.6333333333333333333333333333333333333/107.05 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:51 1,003 3,384 1,716 9 44 0/0 0/0/0/0/0/0
25-6月 09:41 1,048 4,345 2,400 13 55 0/0 0/0/0/0/0/0
25-6月 09:31 893 3,789 5,516 20 107 0/0 0/0/0/0/0/0
25-6月 09:21 987 4,005 4,908 15 97 0/0 0/0/0/0/0/0
25-6月 09:11 1,027 4,217 4,299 14 87 0/0 0/0/0/0/0/0
25-6月 09:01 748 2,136 3,690 17 77 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,351 0.00   0 0  
AWR Alerted Metric Element list 38,261 0.00   0 0  
Consistent RBA 17,903 0.00   0 0  
FAL request queue 82 0.00   0 0  
FAL subheap alocation 82 0.00   0 0  
FIB s.o chain latch 3,321 0.00   0 0  
FOB s.o list latch 4,558 0.00   0 0  
In memory undo latch 218,264 0.00 0.20 0 26,948 0.00
JS mem alloc latch 4 0.00   0 0  
JS queue access latch 4 0.00   0 0  
JS queue state obj latch 26,134 0.00   0 0  
JS slv state obj latch 10 0.00   0 0  
KMG MMAN ready and startup request latch 1,287 0.00   0 0  
KMG resize request state object freelist 4 0.00   0 0  
KTF sga latch 12 0.00   0 1,152 0.00
MQL Tracking Latch 0     0 71 0.00
Memory Management Latch 122 0.00   0 1,287 0.00
OS process 753 0.00   0 0  
OS process allocation 1,724 0.00   0 0  
OS process: request allocation 511 0.00   0 0  
PL/SQL warning settings 8,627 0.00   0 0  
SGA IO buffer pool latch 1,181,805 0.11 0.05 0 1,181,795 0.14
SQL memory manager latch 6,148 0.36 0.64 0 1,169 0.00
SQL memory manager workarea list latch 951,091 0.00 0.00 0 0  
Shared B-Tree 129 0.00   0 0  
active checkpoint queue latch 26,373 0.67 0.00 0 0  
active service list 8,240 0.00   0 1,216 0.00
archive control 96 0.00   0 0  
archive process latch 1,340 0.00   0 0  
begin backup scn array 1,247 0.00   0 0  
buffer pool 142 0.00   0 0  
cache buffer handles 264,254 0.00 0.00 0 0  
cache buffers chains 943,056,538 0.20 0.00 0 35,049,081 0.00
cache buffers lru chain 185,810 0.09 0.00 0 37,599,623 0.13
cache table scan latch 0     0 1,180,914 0.21
channel handle pool latch 1,142 0.00   0 0  
channel operations parent latch 20,262 0.03 0.00 0 0  
checkpoint queue latch 662,317 0.00 0.00 0 49,616 0.00
client/application info 13,094 0.00   0 0  
commit callback allocation 368 0.00   0 0  
compile environment latch 327 0.00   0 0  
constraint object allocation 118 0.00   0 0  
dml lock allocation 177,900 0.00 0.00 0 0  
dummy allocation 637 0.00   0 0  
enqueue hash chains 409,788 0.00 0.00 0 2,576 0.00
enqueues 626,150 0.02 0.00 0 0  
event group latch 264 0.00   0 0  
file cache latch 465 0.00   0 0  
global KZLD latch for mem in SGA 261 0.00   0 0  
hash table column usage latch 1,791 0.00   0 10,008,959 0.00
hash table modification latch 109 0.00   0 0  
internal temp table object number allocation latc 56 0.00   0 0  
job workq parent latch 0     0 126 0.00
job_queue_processes parameter latch 124 0.00   0 0  
kks stats 241,998 0.00 0.00 0 0  
kokc descriptor allocation latch 2,576 0.00   0 0  
krbmrosl 2,393 0.00   0 0  
ksuosstats global area 243 0.00   0 0  
ktm global data 331 0.00   0 0  
kwqbsn:qsga 129 0.00   0 0  
lgwr LWN SCN 17,903 0.00   0 0  
library cache 6,850,228 0.01 0.02 0 196,368 0.03
library cache load lock 38,089 0.00 0.00 0 0  
library cache lock 3,318,311 0.00 0.00 0 0  
library cache lock allocation 54,911 0.00   0 0  
library cache pin 1,729,049 0.00 0.00 0 0  
library cache pin allocation 47,017 0.00   0 0  
list of block allocation 2,689 0.00   0 0  
loader state object freelist 10,628 0.00   0 0  
logminer context allocation 5 0.00   0 0  
longop free list parent 4,113 0.00   0 48 2.08
message pool operations parent latch 644 0.00   0 0  
messages 127,935 0.11 0.00 0 0  
mostly latch-free SCN 17,912 0.01 0.00 0 0  
multiblock read objects 2,549,243 0.03 0.00 0 0  
ncodef allocation latch 60 0.00   0 0  
object queue header heap 18,815 0.00   0 18,547 0.00
object queue header operation 34,024,678 0.00 0.00 0 3,864 0.00
object stats modification 619 0.00   0 0  
parallel query alloc buffer 468 0.00   0 0  
parameter list 33 0.00   0 0  
parameter table allocation management 328 0.00   0 0  
post/wait queue 27,662 0.00   0 18,242 0.01
process allocation 603 0.00   0 264 0.00
process group creation 511 0.00   0 0  
qmn task queue latch 516 0.00   0 0  
redo allocation 94,062 0.01 0.00 0 915,365 0.01
redo copy 0     0 915,389 0.03
redo writing 82,748 0.18 0.00 0 0  
resmgr group change latch 3,891 0.00   0 0  
resmgr:active threads 634 0.00   0 0  
resmgr:actses change group 322 0.00   0 0  
resmgr:free threads list 633 0.00   0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 34,999,433 0.04 0.00 0 32,115 0.03
sequence cache 87,142 0.00   0 0  
session allocation 1,830,141 0.03 0.00 0 0  
session idle bit 17,808,626 0.00 0.00 0 0  
session state list latch 1,202 0.33 0.00 0 0  
session switching 120 0.00   0 0  
session timer 1,216 0.00   0 0  
shared pool 7,907,118 0.13 0.12 0 0  
shared pool simulator 5,092,799 0.00 0.09 0 0  
simulator hash latch 32,967,219 0.00 0.00 0 0  
simulator lru latch 46,842 0.03 0.00 0 30,895,433 0.12
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 2,551 0.04 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 252 0.00   0 0  
threshold alerts latch 1,390 0.00   0 0  
transaction allocation 914 0.00   0 0  
transaction branch allocation 1,216 0.00   0 0  
undo global data 255,801 0.02 0.00 0 933 0.00
user lock 2,792 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 943,056,538 1,875,917 1,194 1,874,733 0 0 0
row cache objects 34,999,433 14,181 2 14,179 0 0 0
shared pool 7,907,118 10,103 1,235 8,964 0 0 0
SGA IO buffer pool latch 1,181,805 1,295 67 1,229 0 0 0
library cache 6,850,228 939 17 925 0 0 0
session allocation 1,830,141 488 1 487 0 0 0
shared pool simulator 5,092,799 53 5 48 0 0 0
SQL memory manager latch 6,148 22 14 8 0 0 0
In memory undo latch 218,264 5 1 4 0 0 0
slave class create 8 1 1 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 1 0
In memory undo latch ktichg: child 0 1 2
In memory undo latch kturbk 0 1 1
SGA IO buffer pool latch ksfd_free_sgabuffer 0 44 67
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 23 0
SQL memory manager latch qesmmIQueryRefreshBound 0 14 14
cache buffers chains kcbgtcr: kslbegin excl 0 12,617 12,494
cache buffers chains kcbrls: kslbegin 0 309 554
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 188 103
cache buffers chains kcbzwb 0 98 43
cache buffers chains kcbzib: multi-block read: nowait 0 32 0
cache buffers chains kcbgtcr: fast path 0 19 26
cache buffers chains kcbgtcr: kslbegin shared 0 9 4
cache buffers chains kcbzib: finish free bufs 0 5 3
cache buffers chains kcbgcur: kslbegin 0 3 0
cache buffers chains kcbzgb: scan from tail. nowait 0 3 0
cache buffers chains kcbchg: kslbegin: call CR func 0 1 49
cache buffers chains kcbget: pin buffer 0 1 2
cache buffers chains kcbgtcr 0 1 0
library cache kglic 0 6 0
library cache kglScanDependency 0 4 0
library cache kgldte: child 0 0 1 5
object queue header operation kcbo_switch_mq_bg 0 1 0
object queue header operation kcbw_unlink_q 0 1 1
row cache objects kqreqd 0 1 1
row cache objects kqreqd: reget 0 1 0
session allocation ksufap: active sessions 0 1 0
shared pool kghalo 0 975 604
shared pool kghupr1 0 100 137
shared pool kgh_next_free 0 88 0
shared pool kghfrunp: alloc: wait 0 30 0
shared pool kghfre 0 20 445
shared pool kgh: add extent to quiesced list 0 16 0
shared pool kghfrunp: clatch: nowait 0 5 0
shared pool kghalp 0 4 46
shared pool kgh: quiesce extents 0 2 0
shared pool kghfrunp: clatch: wait 0 1 1
shared pool simulator kglsim_unpin_simhp 0 5 0
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
ZLHIS ZL9CISREC 病人医嘱记录_PK   INDEX 294,936,784 45.09
ZLHIS ZL9CISREC 病人医嘱记录   TABLE 147,919,408 22.61
SYS SYSTEM I_SYSAUTH1   INDEX 33,295,504 5.09
ZLHIS ZL9CISREC 病人医嘱状态   TABLE 23,606,032 3.61
ZLHIS ZL9BASEITEM 收费项目目录   TABLE 22,603,680 3.46

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
ZLHIS ZL9EPRDAT 电子病历时机   TABLE 13,616,685 80.63
SYS SYSTEM OBJ$   TABLE 1,023,380 6.06
ZLHIS ZL9EPRDAT 电子病历记录   TABLE 632,303 3.74
ZLHIS ZL9PATIENT 病人变动记录   TABLE 299,635 1.77
ZLHIS ZL9EXPENSE 住院费用记录   TABLE 266,420 1.58

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 228 44.88
ZLHIS ZL9PATIENT 病人信息_PK   INDEX 112 22.05
ZLHIS ZL9CISREC 检验标本记录_PK   INDEX 77 15.16
ZLHIS ZLBASEITEM 号码控制表   TABLE 8 1.57
ZLHIS ZL9PATIENT 病案主页   TABLE 6 1.18

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 ZL9CISREC 检验普通结果   TABLE 8 25.81
ZLHIS ZLBASEITEM 号码控制表   TABLE 7 22.58
ZLHIS ZL9PATIENT 病案主页   TABLE 4 12.90
ZLHIS ZLBASEITEM 检验项目分布_PK   INDEX 3 9.68
ZLHIS ZL9INDEXHIS 住院费用记录_UQ_NO   INDEX 3 9.68

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 63 0.00 0   2 1
dc_database_links 524 0.00 0   0 1
dc_files 49 100.00 0   0 0
dc_global_oids 11,935 4.68 0   0 46
dc_histogram_data 3,064,824 0.25 0   0 3,209
dc_histogram_defs 953,859 1.36 0   128 2,350
dc_object_grants 60,821 2.33 0   0 1,457
dc_object_ids 3,388,804 0.09 0   8 1,131
dc_objects 273,855 5.67 0   21 1,721
dc_profiles 325 0.00 0   0 1
dc_rollback_segments 1,658 0.00 0   4 49
dc_segments 835,755 0.48 0   24 1,223
dc_sequences 553 10.67 0   553 12
dc_tablespace_quotas 6 83.33 0   6 1
dc_tablespaces 2,568,371 0.00 0   0 25
dc_usernames 114,500 0.48 0   0 96
dc_users 2,463,429 0.03 0   7 286
outstanding_alerts 662 94.56 0   0 0


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 853 1.29 70,017 0.07 35 0
CLUSTER 311 0.64 510 1.57 6 0
INDEX 37 51.35 110 17.27 0 0
JAVA RESOURCE 1 100.00 1 100.00 0 0
JAVA SOURCE 1 100.00 1 100.00 0 0
SQL AREA 312,362 20.90 3,993,840 3.31 10,137 1,535
TABLE/PROCEDURE 163,705 3.90 1,056,820 1.81 10,772 0
TRIGGER 128 4.69 634 2.21 8 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 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
E Other 765.26   2.38 5.36 79 179 322 322
  Freeable 116.69 0.00 0.66 0.37 2   178 178
  SQL 62.15 33.03 0.20 0.30 5 74 312 308
  PL/SQL 8.82 5.37 0.03 0.02 0 0 320 320
  JAVA 0.97 0.97 0.97 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 137.63 143.68 4.39
shared Heap0: KGL 24.77 24.60 -0.68
shared KGH: NO ACCESS 409.37 441.30 7.80
shared PCursor 56.67 58.80 3.77
shared free memory 200.68 191.52 -4.56
shared kglsim object batch 14.24 14.24 0.00
shared library cache 58.12 61.47 5.76
shared sql area 249.75 246.55 -1.28
  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