WARNING: timed_statistics setting was set to 'FALSE' in the snapshot period: TIMINGS ARE INVALID
WARNING: statistics_level setting was set to 'BASIC' in the snapshot period: TIME MODEL DATA IS INVALID
WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid.

WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1265628295orcl110.2.0.5.0NOHP-RX660

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:124-Jan-13 10:38:01470 8.3
End Snap:324-Jan-13 11:42:11398 7.8
Elapsed:  64.17 (mins)  
DB Time:  0.00 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 6,144M 6,144MStd Block Size: 8K
Shared Pool Size: 1,024M 1,024MLog Buffer: 14,352K

Load Profile

Per SecondPer Transaction
Redo size: 77,248.01 13,270.75
Logical reads: 419,728.04 72,106.77
Block changes: 457.53 78.60
Physical reads: 2,846.06 488.94
Physical writes: 61.32 10.54
User calls: 1,596.92 274.34
Parses: 364.88 62.68
Hard parses: 71.01 12.20
Sorts: 39.94 6.86
Logons: 0.43 0.07
Executes: 1,057.72 181.71
Transactions: 5.82 

% Blocks changed per Read: 0.11Recursive Call %: 45.05
Rollback per transaction %: 7.81Rows per Sort: 83.40

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 100.00
Buffer Hit %: 99.33In-memory Sort %: 100.00
Library Hit %: 88.44Soft Parse %: 80.54
Execute to Parse %: 65.50Latch Hit %: 99.92
Parse CPU to Parse Elapsd %: % Non-Parse CPU: 100.00

Shared Pool Statistics

BeginEnd
Memory Usage %: 93.58 94.71
% SQL with executions>1: 67.38 69.69
% Memory for SQL w/exec>1: 66.77 66.08

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
enq: TX - row lock contention 32 63 1,969 6,299,997,900.0Application
log file sync 24,383 49 2 4,899,951,000.0Commit
latch: cache buffers chains 2,236 3 2 344,627,600.0Concurrency
latch: shared pool 2,203 1 1 129,784,900.0Concurrency
cursor: pin S wait on X 47 0 10 45,995,400.0Concurrency

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)%Total Call Time
Application 5,309 0 63 12 6299997900.00
Commit 24,383 2 49 2 4899951000.00
Concurrency 4,594 1 5 1 530792500.00
Other 256   0 2 42858500.00
CPU time     0   100.00
Network 6,571,281   0 0 0.00
User I/O 1,236,557   0 0 0.00
System I/O 30,714   0 0 0.00
Configuration 14   0 0 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
enq: TX - row lock contention 32 66 63 1969 0.00
log file sync 24,383 2 49 2 1.09
latch: cache buffers chains 2,236   3 2 0.10
latch: shared pool 2,203   1 1 0.10
cursor: pin S wait on X 47 98 0 10 0.00
latch free 96   0 3 0.00
latch: cache buffers lru chain 7   0 15 0.00
latch: library cache 39   0 3 0.00
latch: row cache objects 6   0 1 0.00
latch: object queue header operation 2   0 1 0.00
latch: library cache lock 1   0 0 0.00
SQL*Net message to client 4,950,742   0 0 220.90
SQL*Net more data to client 1,421,671   0 0 63.43
db file scattered read 735,066   0 0 32.80
db file sequential read 394,848   0 0 17.62
SQL*Net more data from client 198,868   0 0 8.87
read by other session 57,608   0 0 2.57
direct path read 39,866   0 0 1.78
log file parallel write 24,049   0 0 1.07
SQL*Net break/reset to client 5,277   0 0 0.24
control file sequential read 4,092   0 0 0.18
direct path read temp 3,113   0 0 0.14
direct path write temp 2,922   0 0 0.13
control file parallel write 1,839   0 0 0.08
direct path sync 1,522   0 0 0.07
direct path write 1,522   0 0 0.07
log file sequential read 373   0 0 0.02
Log archive I/O 349   0 0 0.02
LGWR wait for redo copy 150   0 0 0.01
db file single write 48   0 0 0.00
os thread startup 48   0 0 0.00
db file parallel read 42   0 0 0.00
log file single write 12   0 0 0.00
log file switch completion 12   0 0 0.00
buffer busy waits 8   0 0 0.00
enq: TX - index contention 4   0 0 0.00
cursor: mutex X 2   0 0 0.00
log buffer space 2   0 0 0.00
cursor: pin S 1   0 0 0.00
jobq slave wait 1,783 98 5,217 2926 0.08
Streams AQ: waiting for time management or cleanup tasks 1 100 4,295 4294957 0.00
Streams AQ: qmn coordinator idle wait 276 50 3,840 13913 0.01
SQL*Net message from client 4,952,341   0 0 220.97
Streams AQ: qmn slave idle wait 137   0 0 0.01

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
events in waitclass Other 155   0 0 0.01
latch: shared pool 1   0 0 0.00
log file parallel write 24,048   0 0 1.07
control file sequential read 3,864   0 0 0.17
db file sequential read 3,536   0 0 0.16
control file parallel write 1,839   0 0 0.08
log file sequential read 373   0 0 0.02
Log archive I/O 349   0 0 0.02
db file scattered read 116   0 0 0.01
db file single write 48   0 0 0.00
os thread startup 48   0 0 0.00
log file single write 12   0 0 0.00
rdbms ipc message 33,841 28 37,784 1117 1.51
pmon timer 2,161 100 6,483 3000 0.10
Streams AQ: waiting for time management or cleanup tasks 1 100 4,295 4294957 0.00
smon timer 13 100 3,900 300000 0.00
Streams AQ: qmn coordinator idle wait 276 50 3,840 13913 0.01
Streams AQ: qmn slave idle wait 137   0 0 0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
AVG_BUSY_TIME 237,561
AVG_IDLE_TIME 147,448
AVG_IOWAIT_TIME 6,464
AVG_SYS_TIME 8,136
AVG_USER_TIME 229,424
BUSY_TIME 1,900,494
IDLE_TIME 1,179,594
IOWAIT_TIME 51,720
SYS_TIME 65,092
USER_TIME 1,835,402
LOAD 1
OS_CPU_WAIT_TIME 4,631,786,400
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 372,903,936
VM_OUT_BYTES 9,707,520
PHYSICAL_MEMORY_BYTES 17,147,654,144
NUM_CPUS 8
NUM_CPU_SOCKETS 8

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
SYS$BACKGROUND 0.00 0.00 4,209 45,501
SYS$USERS 0.00 0.00 1,307 1,101,298
orcl 0.00 0.00 10,952,481 1,614,802,909

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$BACKGROUND 3700 0 49 0 0 0 0 0
SYS$USERS 1425 0 9 0 0 0 614 0
orcl 1231417 0 4535 5 0 0 6562842 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
226 0 1,474 0.15 22614726900.00 a4ban8sfhwt21 his.exe SELECT nurse_cell_code, --门诊护...
134 0 2,747 0.05 13393430400.00 73puy9t6ytvsv his.exe select t.his_code, decode(nvl(...
109 0 66 1.66 10929651600.00 f0cd4708fxcmd sqlservr.exe SELECT "Tbl1005"."ID" "Col1030...
91 0 18 5.06 9107889400.00 5w1dmuc76qhw8 sqlservr.exe SELECT "Tbl1005"."BAH" "Col104...
74 0 164 0.45 7383386700.00 9muj7ycv7zn41 his.exe SELECT nurse_cell_code, --门诊护...
58 0 380 0.15 5838276000.00 c3uw91jm7uz49 his.exe SELECT nurse_cell_code, --门诊护...
58 0 380 0.15 5777461700.00 0sjg41mrajfaz his.exe SELECT nurse_cell_code, --门诊护...
57 0 608 0.09 5659587800.00 f5w65za900wpa his.exe SELECT a.EMPL_CODE, --0员工编码 a....
42 0 128 0.33 4212416900.00 6vngrbb2p57jt sqlservr.exe SELECT * FROM HYHIS.V_HIS_pati...
32 0 66 0.48 3151494700.00 979m6fy3hp8v1 sqlservr.exe SELECT "Tbl1005"."ID" "Col1048...
29 0 190 0.15 2901792400.00 42vvsunnqxywx his.exe SELECT nurse_cell_code, --门诊护...
26 0 381 0.07 2606201800.00 dfr2y4288w5nw his.exe SELECT '', --父级医疗机构编码 '', --本...
26 0 46 0.56 2564679200.00 3hs9jzyd7c0qf pb90.exe SELECT "HYHIS"."VIEW_LIS_ZY"....
26 0 380 0.07 2555922000.00 83b6ruvhvkgsz his.exe SELECT '', --父级医疗机构编码 '', --本...
25 0 127 0.19 2453549200.00 5f4rxd5rk1qfd FX_HIS.exe select hyhis.Interface_Patient...
21 0 67 0.32 2126176700.00 gj50gqh7jrw3m sqlservr.exe SELECT "Tbl1005"."ID" "Col1043...
21 0 202 0.10 2073978800.00 4y302k2hhvb8z his.exe SELECT nurse_cell_code, --门诊护...
19 0 19 0.98 1862400700.00 g1yx0c7rxnuvt sqlservr.exe SELECT "Tbl1005"."ID" "Col1057...
18 0 143 0.12 1785950800.00 0ujgacun3pvmh his.exe SELECT item_code, --编码 item_na...
16 0 1,187,715 0.00 1646709400.00 3rdd3tu3rauq6 his.exe SELECT SPELL_CODE FROM COM_SPE...
15 0 9 1.70 1525901800.00 0dpbbhypdrjq2 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
15 0 24 0.61 1466523400.00 6u4r5zug3qqf2 clab_for_doc.exe SELECT "HYHIS"."VIEW_LIS_ZY"....
14 0 297 0.05 1440459900.00 27yskc6sgmkvk his.exe select t.his_code, decode(nvl(...
14 0 202 0.07 1357437400.00 g2b6ctjfz6t7h his.exe SELECT '', --父级医疗机构编码 '', --本...
12 0 7 1.71 1197324100.00 7kz1q3yrsntm5 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
12 0 7 1.70 1191076100.00 6sp40vhyt9bjk his.exe SELECT qc.ID, qc.FILEID, qc.IN...
12 0 7 1.68 1173987100.00 ba3ptcrc3jqu4 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
11 0 771 0.01 1130336300.00 4yf44gqdjz0qf his.exe select a.item_code from fin_co...
10 0 6 1.69 1014011600.00 cxrdjbq98qzuv his.exe SELECT qc.ID, qc.FILEID, qc.IN...
10 0 190 0.05 1005863300.00 5xhcpv302rahg his.exe select count(*) from met_nuo_a...
8 0 67 0.11 762876900.00 019b2bj8mnpcn sqlservr.exe SELECT "Tbl1005"."ID" "Col1088...
4 0 104,183 0.00 351304900.00 g37zzhdxz360u his.exe Select sysdate from dual
3 0 1 2.72 271802100.00 939gry4aq0svp his.exe SELECT /*+INDEX(r IND_REGISTE...
3 0 1 2.58 258332400.00 angzzfa5jhyw2 his.exe SELECT clinic_code, --门诊号/发票号 ...
3 0 14 0.18 255168200.00 9pjngdtbn7pcw his.exe SELECT nurse_cell_code, --门诊护...
2 0 42 0.05 224752800.00 2xaaasu4wbf4h his.exe SELECT inpatient_no, --0 住院流水...
2 0 1 2.02 202409200.00 8xrfcuy370ht6 sqlplus@HP-RX660 (TNS V1-V3) BEGIN sys.dbms_workload_reposi...
2 0 4 0.44 175934200.00 9csfh2ujt8330 his.exe SELECT nurse_cell_code, --门诊护...
2 0 1 1.69 169188100.00 a4r7sd1gztp79 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 2,227 0.00 168925200.00 g375rvh5yjscc his.exe begin PRC_GET_INVOICENO(Par_In...
2 0 1 1.69 168720900.00 9s4q4ubvf4zw9 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.69 168587100.00 9fm81j22a54zz his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.68 168348700.00 4z8zgx52c9m3u his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.68 168317400.00 4v69m7y6rfbf9 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.68 167716800.00 7gyj6mdwafxn0 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.67 167246700.00 241tjrvbm8zgk his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.66 166487200.00 csj30nc011buq his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.66 166386900.00 dk1wag53fqkxg his.exe SELECT /*+INDEX(r IND_REGISTE...
2 0 1 1.66 166208200.00 8s9u3tcnut0w0 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.66 166195200.00 9p66zr51pndka his.exe SELECT qc.ID, qc.FILEID, qc.IN...
2 0 1 1.65 165097900.00 1kjkuzd6s78mr his.exe SELECT /*+INDEX(r IND_REGISTE...
2 0 3,084 0.00 155229200.00 6mgdxahnj8wgv his.exe select pact_code, pact_name , ...
2 0 33,562 0.00 152031700.00 36rddx9a7zpwu his.exe SELECT control_value --控制参数值 ...
1 0 30,942 0.00 149850200.00 2syvqzbxp4k9z   select u.name, o.name, a.inter...
1 0 10,222 0.00 141684200.00 4m7m0t6fjcs5x   update seq$ set increment$=:2,...
1 0 3 0.42 125073400.00 75qbhutctz90g his.exe SELECT see_no, --看诊序号 sequenc...
1 0 2 0.62 124857300.00 784xhazzz5wwg his.exe insert into emr_courserecord t...
1 0 3 0.42 124854800.00 fgbvy43psza4y his.exe SELECT see_no, --看诊序号 sequenc...
1 0 3 0.41 124484500.00 attkhygd43my0 his.exe SELECT see_no, --看诊序号 sequenc...
1 0 3 0.41 124149200.00 g5avvp7mnhnpu his.exe SELECT see_no, --看诊序号 sequenc...
1 0 2 0.62 123198500.00 fzr13tg9vxcj0 his.exe insert into emr_courserecord t...
1 0 14,184 0.00 106587900.00 d7uyynczr9uaa his.exe SELECT '', --父级医疗机构编码 '', --本...
1 0 1,550 0.00 98970400.00 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
1 0 1 0.98 97779500.00 c64311xp7y7j7 his.exe select * from ( select nvl((de...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total% Total DB Time SQL IdSQL ModuleSQL Text
0 8 67 0.00 0.00 762876900.00 019b2bj8mnpcn sqlservr.exe SELECT "Tbl1005"."ID" "Col1088...
0 0 1 0.00 0.00 2863500.00 01v7wjjwfgmn4 his.exe SELECT drug_flag, sys_class, ...
0 0 1 0.00 0.00 2726100.00 0458gcq8tukkh his.exe SELECT drug_flag, sys_class, ...
0 1 1,982 0.00 0.00 56602800.00 04xtrk7uyhknh   select obj#, type#, ctime, mti...
0 0 7 0.00 0.00 5792300.00 07m6jwwff6dvh his.exe SELECT drug_flag, sys_class, ...
0 0 1 0.00 0.00 2706800.00 0bqgcdhyzutjw clab_for_doc.exe SELECT "HYHIS"."VIEW_LIS_ZYDI...
0 15 9 0.00 0.00 1525901800.00 0dpbbhypdrjq2 his.exe SELECT qc.ID, qc.FILEID, qc.IN...
0 0 76 0.00 0.00 4606100.00 0fr8zhn4ymu3v   select intcol#, type, flags, l...
0 1 4,322 0.00 0.00 68554000.00 0h6b2sajwb74n   select privilege#, level from ...
0 58 380 0.00 0.00 5777461700.00 0sjg41mrajfaz his.exe SELECT nurse_cell_code, --门诊护...

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
28,578,547 66 433,008.29 1.77 0.00 109.30 f0cd4708fxcmd sqlservr.exe SELECT "Tbl1005"."ID" "Col1030...
22,006,217 2,747 8,011.00 1.36 0.00 133.93 73puy9t6ytvsv his.exe select t.his_code, decode(nvl(...
17,645,438 1,474 11,971.12 1.09 0.00 226.15 a4ban8sfhwt21 his.exe SELECT nurse_cell_code, --门诊护...
6,408,938 608 10,541.02 0.40 0.00 56.60 f5w65za900wpa his.exe SELECT a.EMPL_CODE, --0员工编码 a....
5,804,457 164 35,393.03 0.36 0.00 73.83 9muj7ycv7zn41 his.exe SELECT nurse_cell_code, --门诊护...
5,513,147 66 83,532.53 0.34 0.00 31.51 979m6fy3hp8v1 sqlservr.exe SELECT "Tbl1005"."ID" "Col1048...
5,085,210 67 75,898.66 0.31 0.00 21.26 gj50gqh7jrw3m sqlservr.exe SELECT "Tbl1005"."ID" "Col1043...
4,545,943 380 11,963.01 0.28 0.00 57.77 0sjg41mrajfaz his.exe SELECT nurse_cell_code, --门诊护...
4,545,943 380 11,963.01 0.28 0.00 58.38 c3uw91jm7uz49 his.exe SELECT nurse_cell_code, --门诊护...
4,371,641 128 34,153.45 0.27 0.00 42.12 6vngrbb2p57jt sqlservr.exe SELECT * FROM HYHIS.V_HIS_pati...

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
67,899 18 3,772.17 0.62 0.00 91.08 5w1dmuc76qhw8 sqlservr.exe SELECT "Tbl1005"."BAH" "Col104...
303 1 303.00 0.00 0.00 2.02 8xrfcuy370ht6 sqlplus@HP-RX660 (TNS V1-V3) BEGIN sys.dbms_workload_reposi...
287 283 1.01 0.00 0.00 0.86 cvn54b7yz0s8u   select /*+ index(idl_ub1$ i_id...
245 24 10.21 0.00 0.00 14.67 6u4r5zug3qqf2 clab_for_doc.exe SELECT "HYHIS"."VIEW_LIS_ZY"....
64 605 0.11 0.00 0.00 0.59 451q2032pshqm   select owner#, name, namespace...
49 605 0.08 0.00 0.00 0.47 8swypbbr0m372   select order#, columns, types ...
46 1,550 0.03 0.00 0.00 0.99 7ng34ruy5awxq   select i.obj#, i.ts#, i.file#,...
36 1,982 0.02 0.00 0.00 0.57 04xtrk7uyhknh   select obj#, type#, ctime, mti...
36 267 0.13 0.00 0.00 0.35 g3wrkmxkxzhf2   select cols, audit$, textlengt...
29 283 0.10 0.00 0.00 0.50 ga9j9xk5cy9s0   select /*+ index(idl_sb4$ i_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,187,715 1,095,781 0.92 0.00 0.00 3rdd3tu3rauq6 his.exe SELECT SPELL_CODE FROM COM_SPE...
104,183 104,182 1.00 0.00 0.00 g37zzhdxz360u his.exe Select sysdate from dual
33,562 33,562 1.00 0.00 0.00 36rddx9a7zpwu his.exe SELECT control_value --控制参数值 ...
30,942 0 0.00 0.00 0.00 2syvqzbxp4k9z   select u.name, o.name, a.inter...
30,936 0 0.00 0.00 0.00 2xyb5d6xg9srh   select a.default_cpu_cost, a.d...
25,341 25,341 1.00 0.00 0.00 7h35uxf5uhmm1 AutoUpdate.exe select sysdate from dual
19,154 19,154 1.00 0.00 0.00 1mxs8cp3ax62v his.exe SELECT control_value --控制参数值 ...
18,055 18,055 1.00 0.00 0.00 69mwj2abhrxgf his.exe SELECT DISTINCT t.dept_code, ...
14,184 42,552 3.00 0.00 0.00 d7uyynczr9uaa his.exe SELECT '', --父级医疗机构编码 '', --本...
10,602 0 0.00 0.00 0.00 a1yhyd9zv1vdr his.exe set transaction isolation leve...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
104,183 104,183 7.42 g37zzhdxz360u his.exe Select sysdate from dual
33,562 33,562 2.39 36rddx9a7zpwu his.exe SELECT control_value --控制参数值 ...
30,942 30,942 2.20 2syvqzbxp4k9z   select u.name, o.name, a.inter...
30,936 30,936 2.20 2xyb5d6xg9srh   select a.default_cpu_cost, a.d...
25,341 25,341 1.80 7h35uxf5uhmm1 AutoUpdate.exe select sysdate from dual
19,154 19,154 1.36 1mxs8cp3ax62v his.exe SELECT control_value --控制参数值 ...
18,055 18,055 1.29 69mwj2abhrxgf his.exe SELECT DISTINCT t.dept_code, ...
14,184 14,184 1.01 d7uyynczr9uaa his.exe SELECT '', --父级医疗机构编码 '', --本...
10,602 10,602 0.75 a1yhyd9zv1vdr his.exe set transaction isolation leve...
10,222 10,222 0.73 4m7m0t6fjcs5x   update seq$ set increment$=:2,...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Version Count Executions SQL IdSQL ModuleSQL Text
76 7 af80uck5tnjvx pb90.exe SELECT "HYHIS"."HYLOCAL_LIS_U...
46 2 a7bav4g0kcz99 clab_for_doc.exe select dept_code , dept_name f...
25 10 9m7787camwh4m PL/SQL Developer begin :id := sys.dbms_transact...
23 605 8swypbbr0m372   select order#, columns, types ...
22 4 fnj6cnubp1sau PL/SQL Developer begin if :enable = 0 then sys....

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
019b2bj8mnpcn SELECT "Tbl1005"."ID" "Col1088", "Tbl1005"."TIMES" "Col1089", "Tbl1005"."NAME" "Col1090", "Tbl1005"."FB" "Col1091", "Tbl1005"."MARRYCODE" "Col1092", "Tbl1005"."OCCUPATIONCODE" "Col1093", "Tbl1005"."DWNAME" "Col1094", "Tbl1005"."DWADDR" "Col1095", "Tbl1005"."DWTELE" "Col1096", "Tbl1005"."DWPOST" "Col1097", "Tbl1005"."HKADD" "Col1098", "Tbl1005"."HKPOST" "Col1099", "Tbl1005"."LXNAME" "Col1100", "Tbl1005"."RELATIVECODE" "Col1101", "Tbl1005"."LXTELE" "Col1102", "Tbl1005"."LXADDR" "Col1103", "Tbl1005"."RYDATE" "Col1104", "Tbl1005"."RYINFO" "Col1105", "Tbl1005"."SOURCE" "Col1106", "Tbl1005"."INKBCODE" "Col1107", "Tbl1005"."INKSCODE" "Col1108", "Tbl1005"."OUTKSCODE" "Col1109", "Tbl1005"."OUTKBCODE" "Col1110", "Tbl1005"."CYDATE" "Col1111", "Tbl1005"."DAYS" & quot;Col1112", "Tbl1005"."MZICDCODE" "Col1113", "Tbl1005"."MZICDVER" "Col1114", "Tbl1005"."RYICDVER" "Col1115", "Tbl1005"."BLICDCODE" "Col1116", "Tbl1005"."BLOODCODE" "Col1117", "Tbl1005"."ZREMPCODE" "Col1118", "Tbl1005"."ZZEMPCODE" "Col1119", "Tbl1005"."ZYEMPCODE" "Col1120", "Tbl1005"."PHONE" "Col1121", "Tbl1005"."INSERTTIME" "Col1122" FROM "HYHIS"."VIEW_SF_OH_SICKINHOSPITAL_MTH" "Tbl1005" WHERE "Tbl1005"."CYDATE">:1 AND "Tbl1005"."CYDATE"<:2
01v7wjjwfgmn4 SELECT drug_flag, sys_class, fee_code, item_code, item_name, en_name, pack_qty, specs, dose_code, spell_code, wb_code, user_code, cus_name, cus_spell_code, cus_wb_code, cus_user_code, unit_price, child_price, sp_price, pack_unit, min_unit, now_store, exe_dept, gf_flag, usage_code, freq_code, dose_unit, shenxz, shixz, zf, needbespeak, base_dose, CONFIRM_FLAG, split_type, LACK_FLAG, special_check, once_dose, other_name, other_spell, default_sample, unitflag FROM view_cli_itemlist where (dept_code = '6206' OR dept_code = 'undrug') and item_code = 'F00000002542'
0458gcq8tukkh SELECT drug_flag, sys_class, fee_code, item_code, item_name, en_name, pack_qty, specs, dose_code, spell_code, wb_code, user_code, cus_name, cus_spell_code, cus_wb_code, cus_user_code, unit_price, child_price, sp_price, pack_unit, min_unit, now_store, exe_dept, gf_flag, usage_code, freq_code, dose_unit, shenxz, shixz, zf, needbespeak, base_dose, CONFIRM_FLAG, split_type, LACK_FLAG, special_check, once_dose, other_name, other_spell, default_sample, unitflag FROM view_cli_itemlist where (dept_code = '6206' OR dept_code = 'undrug') and item_code = 'F00000006894'
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
07m6jwwff6dvh SELECT drug_flag, sys_class, fee_code, item_code, item_name, en_name, pack_qty, specs, dose_code, spell_code, wb_code, user_code, cus_name, cus_spell_code, cus_wb_code, cus_user_code, unit_price, child_price, sp_price, pack_unit, min_unit, now_store, exe_dept, gf_flag, usage_code, freq_code, dose_unit, shenxz, shixz, zf, needbespeak, base_dose, CONFIRM_FLAG, split_type, LACK_FLAG, special_check, once_dose, other_name, other_spell, default_sample, unitflag FROM view_cli_itemlist where (dept_code = '6206' OR dept_code = 'undrug') and item_code = 'F00000006860'
0bqgcdhyzutjw SELECT "HYHIS"."VIEW_LIS_ZYDIAGNOSE"."住院流水号" , "HYHIS"."VIEW_LIS_ZYDIAGNOSE"."诊断类别编码" , "HYHIS"."VIEW_LIS_ZYDIAGNOSE"."诊断类别名称" , "HYHIS"."VIEW_LIS_ZYDIAGNOSE"."诊断编码" , "HYHIS"."VIEW_LIS_ZYDIAGNOSE"."诊断名称" , "HYHIS"."VIEW_LIS_ZYDIAGNOSE"."诊断日期" FROM "HYHIS"."VIEW_LIS_ZYDIAGNOSE" WHERE ( HYHIS."VIEW_LIS_ZYDIAGNOSE"."住院流水号" = :zy_no )
0dpbbhypdrjq2 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY030000223240' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
0fr8zhn4ymu3vselect intcol#, type, flags, lobcol, objcol, extracol, schemaoid, elemnum from opqtype$ where obj# = :1 order by intcol# asc
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0sjg41mrajfaz SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 Where NURSE_CELL_CODE = '7903'-- VARCHAR2(12) N 队列代码 And QUEUE_DATE >= to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') and QUEUE_DATE < to_date('2013-1-24 23:59:59', 'yyyy-mm-dd HH24:mi:ss') order by sort_id
0ujgacun3pvmh SELECT item_code, --编码 item_name, --名称 sys_class, --系统类别 fee_code, --最小费用代码 input_code, -- 输入码 spell_code, --拼音码 wb_code, -- 五笔码 gb_code, -- 国家编码 international_code, --国际编码 unit_price, --三甲价 stock_unit, --单位 emerg_scale, -- 急诊加成比例 family_plane, -- 计划生育标记 special_item, --特定诊疗项目 item_grade, --甲乙类标志 confirm_flag, --确认标志 1 需要确认 0 不需要确认 valid_state, --有效性标识 0 在用 1 停用 2 废弃 specs, --规格 exedept_code, --执行科室 facility_no, --设备编号 用 | 区分 default_sample, --默认检查部位或标本 operate_code, -- 手术编码 operate_kind, -- 手术分类 operate_type, --手术规模 collate_flag, --是否有物资项目与之对照(1有，0没有) mark , --备注 UNIT_PRICE1, --儿童价 UNIT_PRICE2, --特诊价 SPECIAL_FLAG , --省限制 SPECIAL_FLAG1 , --市限制 SPECIAL_FLAG2 , --自费项目 SPECIAL_FLAG3 , --特殊标识 SPECIAL_FLAG4 , --特殊标识 UNIT_PRICE3, --单价2 UNIT_PRICE4 , --单价2 DISEASE_CLASS, -- 疾病分类 SPECIAL_DEPT , -- 专科名称 MARK1, --病史及检查 MARK2, --检查要求 MARK3, -- 注意事项 CONSENT_FLAG , MARK4 , -- 检查申请单名称 m.needbespeak, -- 是否需要预约 ITEM_AREA, ITEM_NOAREA, UNITFLAG , -- 单位标识(0, 明细; 1, 组套) APPLICABILITYAREA , --有效范围 DEPT_LIST, --允许开立科室 ITEM_PRICETYPE, --物价费用类别 ORDERPRINT_TAG, --医嘱打印标示 oper_code, --申请人 oper_date, --停用时间 ITEM_CASTYPE --病案费用类别 FROM fin_com_undruginfo m WHERE (item_code ='all' Or 'all'='all' ) AND (valid_state ='1' Or 'all'='1') order by fee_code, item_name
1kjkuzd6s78mr SELECT /*+INDEX(r IND_REGISTER5)*/ '', --父级医疗机构编码 '', --本级医疗机构编码 t.clinic_code, --门诊号 t.see_sequence, --看诊序号 t.card_no, --病历号 t.reg_date, --挂号日期 t.name, --患者姓名 t.sex_code, --性别 t.paykind_code, --结算类别 t.ynurg, --1急诊/0普通 t.ynbook, --1预约/0普通---10 t.dept_code, --看诊科室 t.dept_name, --科室名称 t.queue_name, --队列名称 t.room_id, --出诊诊室 t.queue_code, --队列代码 t.room_name, --诊室名称 t.doct_code, --看诊医生 t.see_date, --看诊时间 t.assign_flag, --1分诊/2进诊/3诊出 t.nurse_cell_code, --分诊科室--20 t.triage_date, --分诊时间 t.in_date, --进诊时间 t.out_date, --出诊时间 t.oper_code, --操作员 t.oper_date, --操作时间25 t.console_code, t.console_name, r.birthday, ---出生日期 r.paykind_code, ---患者类别 r.paykind_name, ---患者类别 --30 r.pact_code, ---合同单位 r.pact_name, ---合同单位 r.address, r.rela_phone, r.reglevl_code, --挂号级别 r.reglevl_name, r.doct_code, --医生 r.doct_name, r.is_account, r.OWN_COST, r.YNREGCHRG, r.in_state FROM met_nuo_assignrecord t , fin_opr_register r where t.clinic_code = r.clinic_code and t.reg_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and t.reg_date < to_date('2013-1-25 10:38:03', 'yyyy-mm-dd hh24: mi:ss') + 1 and t.console_code = '994' and t.assign_flag = '2' and r.valid_flag = '1' and r.trans_type = '1' and r.dept_code = '0033' order by t.reg_date , t.see_sequence
1mxs8cp3ax62v SELECT control_value --控制参数值 FROM com_controlargument --控制参数表 WHERE control_code = 'EPR231'
241tjrvbm8zgk SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY080000205274' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
27yskc6sgmkvkselect t.his_code, decode(nvl(t.center_item_grade, '3'), '1', '甲类', '2', '乙类', '3', '自费', 4, '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗项目', '自费') from fin_com_compare t where t.pact_code = '12'
2syvqzbxp4k9zselect u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
2xaaasu4wbf4h SELECT inpatient_no, --0 住院流水号 name, --1 姓名 patient_no, --2 住院号 card_no, --3 就诊卡号 patient_no, --4 病历号 mcard_no, --5 医疗证号 MEDICAL_TYPE, --6 医疗类别 sex_code, --7 性别 M, F, O, U idenno, --8 身份证号 spell_code, --9 拼音10 birthday, --10生日 prof_code, --11职业代码 '', --12 职业名称 work_name, --13工作单位 work_tel, --14工作单位电话15 work_zip, --15单位邮编Memo --home, --16户口或家庭地址 nvl((select bb.XZZSHENG_NAME || bb.XZZSHI_NAME || bb.XZZXIAN_NAME || bb.XZZ_OTHER from hylocal_cas_address bb where bb.inpatient_no = d.inpatient_no and bb.flag = '1' and rownum = 1), ''), home_tel, --17家庭电话 home_zip, --18户口或家庭邮编 '', --19籍贯id20 dist, --20籍贯name birth_area, --21出生地代码 '', --22出生地名称 nation_code, --23民族id '', --24民族名称 '', --25联系人ID linkman_name, --26联系人姓名 linkman_tel, --27联系人电话 linkman_add, --28联系人地址 rela_code, --29联系人关系ID '', --30联系人关系名称 mari, --31婚姻状况id '', --32婚姻状况名称 coun_code, --33国籍id '', --34 height, --35身高30 weight, --36体重 blood_dress, --37血压 blood_code, --38血型编码 hepatitis_flag, --39重大疾病标志 1:有 0:无 anaphy_flag, --40过敏标志 1有 0:无 35 in_date, --41入院日期 dept_code, --42科室代码 dept_name, --43科室名称 paykind_code, --44结算类别 01-自费 02-保险 03-公费在职 04-公费退休 05-公费高干 40 '', --45 pact_code, --46合同代码 pact_name, --47合同单位名称 bed_no, --48床号 nurse_cell_code, --49护理单元代码 nurse_cell_name, --50护理单元名称 house_doc_code, --51医师代码(住院) house_doc_name, --52医师姓名(住院) charge_doc_code, --53医师代码(主治) 50 charge_doc_name, --54医师姓名(主治) chief_doc_code, --55医师代码(主任) chief_doc_name, --56医师姓名(主任) '', --57实习 '', --58实习55 duty_nurse_code, --59护士代码(责任) duty_nurse_name, --60护士姓名(责任) in_circs, --61入院情况ID '', --62入院情况Name in_avenue, --63入院途径ID '', --64入院途径Name in_source, --65入院来源ID 1:门诊，2:急诊，3:转科，4:转院 60 '', --66入院来源Name in_state, --67在院状态 R-住院登记 I 病房接诊 B-出院登记 O-出院结算 P-预约出院, N-无费退院 C 取消 prepay_outdate, --68出院日期(预约) out_date, --69出院日期 in_icu, --70是否在ICU '', --71 icu code '', --72 icu name '', --73楼 '', --74层 '', --75房间 tot_cost, --76费用金额(未结) own_cost, --77自费金额(未结)75 pay_cost, --78自付金额(未结) pub_cost, --79公费金额(未结) free_cost, --80余额(未结)80 eco_cost, --81优惠金额(未结) prepay_cost, --82预交金额(未结) balance_cost, --83费用金额(已结) balance_prepay, --84预交金额(已结) balance_date, --85结算日期(上次) money_alert, --86警戒线 zg, --87转归代号 CHANGE_PREPAYCOST, --88转入预交金 CHANGE_TOTCOST, --89转入费用 (SELECT t.BED_STATE FROM COM_BEDINFO t WHERE t.BED_NO=d.BED_NO ), --病床状态 LIMIT_OVERTOP, --91公费日限额超标部分 Memo, --92特注 DAY_LIMIT, --93日限额 BLOOD_LATEFEE, --94血滞纳金 in_times, --95入院次数 BED_LIMIT, --96床位上限 AIR_LIMIT, --97空调上限 CLINIC_DIAGNOSE, --98门诊诊断 EMPL_CODE, --99收住医生代码 PROCREATE_PCNO, --100生育保险电脑号 BABY_FLAG, --101是否有婴儿 TEND, --102护理级别 fee_interval, --103固定费用间隔天数 prefixfee_date, --104上次固定费用时间 BEDOVERDEAL, --105床费超标处理 0超标不限1超标自理 LIMIT_TOT, --106公费患者日限额累计 CASE_FLAG, --107病案状态: 0 无需病案 1 需要病案 2 医生站形成病案 3 病案室形成病案 4病案封存 ext_flag, --108是否允许日限额超标 0 不同意 1 同意 中山一院需求 ext_flag1, --109扩展标记1 ext_flag2, --110扩展标记2 BOARD_COST, --111膳食花费总额 BOARD_PREPAY, --112膳食预交金额 BOARD_STATE, --113膳食结算状态：0在院 1出院 OWN_RATE, --114自费比例 PAY_RATE, --115自付比例 BURSARY_TOTMEDFEE, --116公费患者公费药品累计(日限额) DIAG_NAME , ---117住院主诊断名称 IS_ENCRYPTNAME, normalname, BALANCE_NO, critical_flag, d.stop_acount, alter_type, ALTER_BEGIN, ALTER_END, Pulse, --脉搏 Breath, --呼吸 NewBabyBirthWeight, --新生儿出生体重 NewBabyInWeight --新生儿入院体重 FROM FIN_IPR_INMAININFO d WHERE NURSE_CELL_CODE ='7036' AND IN_STATE = 'I' ORDER BY (SELECT COM_BEDINFO.SORT_ID FROM COM_BEDINFO WHERE COM_BEDINFO.BED_NO = d.BED_NO), d.BED_NO
2xyb5d6xg9srhselect a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2
36rddx9a7zpwu SELECT control_value --控制参数值 FROM com_controlargument --控制参数表 WHERE control_code = 'EPR201'
3hs9jzyd7c0qf SELECT "HYHIS"."VIEW_LIS_ZY"."住院号" , "HYHIS"."VIEW_LIS_ZY"."姓名" , "HYHIS"."VIEW_LIS_ZY"."性别" , "HYHIS"."VIEW_LIS_ZY"."年龄" , "HYHIS"."VIEW_LIS_ZY"."出生日期" , "HYHIS"."VIEW_LIS_ZY"."病床号" , "HYHIS"."VIEW_LIS_ZY"."住院次数" , "HYHIS"."VIEW_LIS_ZY"."医生姓名" , "HYHIS"."VIEW_LIS_ZY"."医生编码" , "HYHIS"."VIEW_LIS_ZY"."科室名称" , "HYHIS"."VIEW_LIS_ZY"."科室编码" , "HYHIS"."VIEW_LIS_ZY"."病人所在的科室名称" , "HYHIS"."VIEW_LIS_ZY"."病人所在的科室编号" , "HYHIS"."VIEW_LIS_ZY"."电子医嘱编号" , "HYHIS"."VIEW_LIS_ZY"."项目代号" , "HYHIS"."VIEW_LIS_ZY"."项目名称" , "HYHIS"."VIEW_LIS_ZY"."收费时间" , "HYHIS"."VIEW_LIS_ZY"."唯一主键" , "HYHIS"."VIEW_LIS_ZY"."住院流水号" , "HYHIS"."VIEW_LIS_ZY& quot;."是否加急" FROM "HYHIS"."VIEW_LIS_ZY" WH ERE ( HYHIS."VIEW_LIS_ZY"."住院号" = :ls_pat_in_no ) And ( HYHIS."VIEW_LIS_ZY"."收费时间" >= :dt_startDate ) and ( HYHIS."VIEW_LIS_ZY"."收费时间" < :dt_endDate ) and ( HYHIS."VIEW_LIS_ZY"."病人所在的科室编号" = :ls_dept_code ) ORDER BY "HYHIS"."VIEW_LIS_ZY"."唯一主键" DESC
3rdd3tu3rauq6SELECT SPELL_CODE FROM COM_SPELLBASE WHERE NAME = :B1 AND ROWNUM = 1
42vvsunnqxywx SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 WHERE nurse_cell_code='7905' AND queue_date >= to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND queue_date < to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') +1 AND noon_code='1' and valid_flag = '1' order by sort_id, dept_code, waiting_count
451q2032pshqmselect owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
4m7m0t6fjcs5xupdate seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4v69m7y6rfbf9 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227583' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
4y302k2hhvb8z SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 Where NURSE_CELL_CODE = '7904'-- VARCHAR2(12) N 队列代码 And QUEUE_DATE >= to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') and QUEUE_DATE < to_date('2013-1-24 23:59:59', 'yyyy-mm-dd HH24:mi:ss') order by sort_id
4yf44gqdjz0qfselect a.item_code from fin_com_undruginfo a where a.orderprint_tag='1'
4z8zgx52c9m3u SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY050000217451' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
5f4rxd5rk1qfdselect hyhis.Interface_Patient_Mi.*, hyhis.Interface_Patient_Mi."ROWID" from hyhis.Interface_Patient_Mi
5w1dmuc76qhw8SELECT "Tbl1005"."BAH" "Col1049", "Tbl1005"."XM" "Col1050", "Tbl1005"."XB" "Col1051", "Tbl1005"."CSRQ" "Col1052", "Tbl1005"."SFZHM" "Col1053", "Tbl1005"."PHONE" "Col1054", "Tbl1005"."JLYG" "Col1055", "Tbl1005"."JLSJ" "Col1056", "Tbl1005"."TJFL1" "Col1057" FROM "HYHIS"."VIEW_SF_MZ_MZBR" "Tbl1005"
5xhcpv302rahgselect count(*) from met_nuo_assignrecord t where t.triage_date > to_Date('2013/1/24 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and t.triage_date < to_Date('2013/1/25 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and t.console_code = '1077' and t.assign_flag = '2'
69mwj2abhrxgf SELECT DISTINCT t.dept_code, t.dept_name, t.spell_code, t.wb_code, t.dept_ename, t.dept_type, t.regdept_flag, t.tatdept_flag, t.dept_pro, t.valid_state, t.SORT_ID, t.user_code , t.simple_name FROM com_department t WHERE dept_code = '0220'
6mgdxahnj8wgvselect pact_code, pact_name , paykind_code, pub_ratio, pay_ratio, own_ratio, eco_ratio , arr_ratio, baby_flag, mcard_flag, control_flag , flag, day_limit, month_limit, year_limit, once_limit, PRICE_FORM , BED_LIMIT, AIR_LIMIT , SORT_ID , SIMPLE_NAME, DLL_NAME, DLL_DESCRIPTION from fin_com_pactunitinfo /*where pact_code in (select distinct c.pact_code from fin_com_pactunitinfo c , com_dictionary d where c.pact_code =d.code and d.type = 'PACTUNIT' and d.valid_state ='1')*/ order by SORT_ID
6sp40vhyt9bjk SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227787' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
6u4r5zug3qqf2 SELECT "HYHIS"."VIEW_LIS_ZY"."住院号" , "HYHIS"."VIEW_LIS_ZY"."姓名" , "HYHIS"."VIEW_LIS_ZY"."性别" , "HYHIS"."VIEW_LIS_ZY"."年龄" , "HYHIS"."VIEW_LIS_ZY"."出生日期" , "HYHIS"."VIEW_LIS_ZY"."病床号" , "HYHIS"."VIEW_LIS_ZY"."住院次数" , "HYHIS"."VIEW_LIS_ZY"."医生姓名" , "HYHIS"."VIEW_LIS_ZY"."医生编码" , "HYHIS"."VIEW_LIS_ZY"."科室名称" , "HYHIS"."VIEW_LIS_ZY"."科室编码" , "HYHIS"."VIEW_LIS_ZY"."病人所在的科室名称" , "HYHIS"."VIEW_LIS_ZY"."病人所在的科室编号" , "HYHIS"."VIEW_LIS_ZY"."电子医嘱编号" , "HYHIS"."VIEW_LIS_ZY"."项目代号" , "HYHIS"."VIEW_LIS_ZY"."项目名称" , "HYHIS"."VIEW_LIS_ZY"."收费时间" , to_char("HYHIS"."VIEW_LIS_ZY"."收费时间", 'yyyy-MM-dd') as createdate, "HYHIS"."VIEW_LIS_ZY"."唯一主键" FROM " HYHIS"."VIEW_LIS_ZY" WHERE ( HYHIS."VIEW_LIS_ZY".& quot;病人所在的科室编号" = :ls_dept_code ) And ( HYHIS."VIEW_LIS_ZY"."收费时间" >= :ls_sdate ) And ( HYHIS."VIEW_LIS_ZY"."收费时间" < :ls_edate ) ORDER BY "HYHIS"."VIEW_LIS_ZY"."姓名" ASC, "HYHIS"."VIEW_LIS_ZY"."收费时间" ASC
6vngrbb2p57jtSELECT * FROM HYHIS.V_HIS_patientcheck where creation_date> sysdate-1/12
73puy9t6ytvsvselect t.his_code, decode(nvl(t.center_item_grade, '3'), '1', '甲类', '2', '乙类', '3', '自费', 4, '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗项目', '自费') from fin_com_compare t where t.pact_code = '11'
75qbhutctz90g SELECT see_no, --看诊序号 sequence_no, --项目流水号 clinic_code, --门诊号 card_no, --病历号 reg_date, --挂号日期 dept_code, --挂号科室 item_code, --项目代码 item_name, --项目名称 specs, --规格 drug_flag, --1药品，2非药品 class_code, --系统类别 fee_code, --最小费用代码 unit_price, --单价 qty, --开立数量 days, --付数 pack_qty, --包装数量 item_unit, --计价单位 own_cost, --自费金额 pay_cost, --自负金额 pub_cost, --报销金额 base_dose, --基本剂量 self_made, --自制药 drug_quanlity, --药品性质，普药、贵药 once_dose, --每次用量 once_unit, --每次用量单位 dose_model_code, --剂型代码 frequency_code, --频次 frequency_name, --频次名称 usage_code, --使用方法 usage_name, --用法名称 english_ab, --用法英文缩写 exec_dpcd, --执行科室代码 exec_dpnm, --执行科室名称 main_drug, --主药标志 comb_no, --组合号 hypotest, --1不需要皮试/2需要皮试，未做/3皮试阳/4皮试阴 inject_number, --院内注射次数 remark, --备注 doct_code, --开立医生 doct_name, --开立医生名称 doct_dpcd, --医生科室 oper_date, --开立时间 status, --处方状态, 1开立，2收费，3确认，4作废 cancel_userid, --作废人 cancel_date, --作废时间 emc_flag, --加急标记0普通/1加急 lab_type, --样本类型 check_body, --检体 apply_no, --申请单号 subtbl_flag, --0没有附材/1带附材/2是附材 need_confirm, - -是否需要确认，1需要，0不需要 confirm_code, --确认人 confirm_dept, --确认科室 confirm_date, --确认时间 charge_flag, --0未收费/1收费 charge_code, --收费员 charge_date, --收费时间 recipe_no, --处方号 recipe_seq, --处方内流水号 phamarcy_code, --取药药房 MINUNIT_FLAG, --最小单位 (select p.split_type from pha_com_baseinfo p where p.drug_code = met_ord_recipedetail.item_code), ordertype, --医嘱类型 subcombno, RESUMEORDER, RECIPE_FEESEQ, PASS_FLAG, SORT_ID, mark1, mark2, mark3 FROM met_ord_recipedetail where SEQUENCE_NO='14847515'
784xhazzz5wwginsert into emr_courserecord t ( t.data, --内容 t.id, --病程流水号 t.fileid, --病程文件号 t.inpatient_no, --患者流水号 t.name, --患者姓名 t.dept_code, --住院科室编码 t.memo, --查房医师姓名 t.course_type, --记录类型 t.course_name, --记录类型名称 t.doctor_name, --医师签名 t.oper_date, --操作时间 t.oper_code, --操作人员 t.course_date, --病程记录日期 t.course_time, --病程记录时间 t.emr_name, --病历名称 t.sortid, --排列顺序 t.IsStartNewPage ) values( :a, '309240', --病程流水号 '0', --病程文件号 'ZY020000148687', --患者流水号 '符国义', --患者姓名 '0206', --住院科室编码 '', --查房医师姓名 '0002', --记录类型 '主治医师查房', --记录类型名称 '', --医师签名 sysdate, '', --操作人员 to_Date('2013-01-24', 'yyyy-mm-dd'), --病程记录日期 '09:20', --病程记录时间 '病程记录', --病历名称 nvl((select max(sortid) + 1 from emr_courserecord y where y.fileid = '0'), 1), --排列顺序 'False' )
7gyj6mdwafxn0 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227842' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
7h35uxf5uhmm1select sysdate from dual
7kz1q3yrsntm5 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000228002' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
7ng34ruy5awxqselect i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83b6ruvhvkgsz SELECT '', --父级医疗机构编码 '', --本级医疗机构编码 a.clinic_code, --门诊号 a.see_sequence, --看诊序号 a.card_no, --病历号 a.reg_date, --挂号日期 a.name, --患者姓名 a.sex_code, --性别 a.paykind_code, --结算类别 a.ynurg, --1急诊/0普通 a.ynbook, --1预约/0普通 a.dept_code, --看诊科室 a.dept_name, --科室名称 a.queue_name, --队列名称 a.room_id, --出诊诊室 a.queue_code, --队列代码 a.room_name, --诊室名称 a.doct_code, --看诊医生 a.see_date, --看诊时间 a.assign_flag, --1分诊/2进诊/3诊出 a.nurse_cell_code, --分诊科室 a.triage_date, --分诊时间 a.in_date, --进诊时间 a.out_date, --出诊时间 a.oper_code, --操作员 a.oper_date, --操作时间 a.console_code, a.console_name, b.reglevl_code, b.reglevl_name, b.doct_name FROM met_nuo_assignrecord a, fin_opr_register b WHERE a.nurse_cell_code='7903' AND a.triage_date>=to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date<to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 AND a.assign_flag = '2' and b.oper_date > to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') - 10 and b.reg_date>=to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND b.reg_date<to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and b.clinic_code = a.clinic_code and b.trans_type = '1' and b.valid_flag = fun_get_va lid --order by a.reg_date, a.SEE_SEQUENCE order by a.console_code, a.reg_date
8s9u3tcnut0w0 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227694' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
8swypbbr0m372select order#, columns, types from access$ where d_obj#=:1
8xrfcuy370ht6BEGIN sys.dbms_workload_repository.CREATE_SNAPSHOT; END;
939gry4aq0svp SELECT /*+INDEX(r IND_REGISTER5)*/ '', --父级医疗机构编码 '', --本级医疗机构编码 t.clinic_code, --门诊号 t.see_sequence, --看诊序号 t.card_no, --病历号 t.reg_date, --挂号日期 t.name, --患者姓名 t.sex_code, --性别 t.paykind_code, --结算类别 t.ynurg, --1急诊/0普通 t.ynbook, --1预约/0普通---10 t.dept_code, --看诊科室 t.dept_name, --科室名称 t.queue_name, --队列名称 t.room_id, --出诊诊室 t.queue_code, --队列代码 t.room_name, --诊室名称 t.doct_code, --看诊医生 t.see_date, --看诊时间 t.assign_flag, --1分诊/2进诊/3诊出 t.nurse_cell_code, --分诊科室--20 t.triage_date, --分诊时间 t.in_date, --进诊时间 t.out_date, --出诊时间 t.oper_code, --操作员 t.oper_date, --操作时间25 t.console_code, t.console_name, r.birthday, ---出生日期 r.paykind_code, ---患者类别 r.paykind_name, ---患者类别 --30 r.pact_code, ---合同单位 r.pact_name, ---合同单位 r.address, r.rela_phone, r.reglevl_code, --挂号级别 r.reglevl_name, r.doct_code, --医生 r.doct_name, r.is_account, r.OWN_COST, r.YNREGCHRG, r.in_state FROM met_nuo_assignrecord t , fin_opr_register r where t.clinic_code = r.clinic_code and t.reg_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and t.reg_date < to_date('2013-1-25 10:38:13', 'yyyy-mm-dd hh24: mi:ss') + 1 and t.console_code = '1015' and t.assign_flag = '2' and r.valid_flag = '1' and r.trans_type = '1' and r.dept_code = '0012' order by t.reg_date , t.see_sequence
979m6fy3hp8v1SELECT "Tbl1005"."ID" "Col1048", "Tbl1005"."DISTRICTCODE" "Col1049", "Tbl1005"."NATIONCODE" "Col1050", "Tbl1005"."SEXCODE" "Col1051", "Tbl1005"."COUNTRYCODE" "Col1052", "Tbl1005"."NAME" "Col1053", "Tbl1005"."BIRTHDAY" "Col1054", "Tbl1005"."IDCARD" "Col1055", "Tbl1005"."PHONE" "Col1056", "Tbl1005"."DEATH" "Col1057" FROM "HYHIS"."VIEW_SF_OH_SICKBASE" "Tbl1005"
9csfh2ujt8330 SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 Where NURSE_CELL_CODE = '7902'-- VARCHAR2(12) N 队列代码 And QUEUE_DATE >= to_date('2013-1-24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') and QUEUE_DATE < to_date('2013-1-24 23:59:59', 'yyyy-mm-dd HH24:mi:ss') order by sort_id
9fm81j22a54zz SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY020000221499' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
9m7787camwh4mbegin :id := sys.dbms_transaction.local_transaction_id; end;
9muj7ycv7zn41 SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 WHERE nurse_cell_code='7902' AND queue_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND queue_date < to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') +1 AND noon_code='1' and valid_flag = '1' order by sort_id, dept_code, waiting_count
9p66zr51pndka SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227297' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
9pjngdtbn7pcw SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 WHERE nurse_cell_code='7901' AND queue_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND queue_date < to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') +1 AND noon_code='1' and valid_flag = '1' order by sort_id, dept_code, waiting_count
9s4q4ubvf4zw9 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227765' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
a1yhyd9zv1vdrset transaction isolation level read committed
a4ban8sfhwt21 SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 WHERE nurse_cell_code='7903' AND queue_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND queue_date < to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') +1 AND noon_code='1' and valid_flag = '1' order by sort_id, dept_code, waiting_count
a4r7sd1gztp79 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227918' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
a7bav4g0kcz99select dept_code , dept_name from hyhis.hylocal_lis_doctor where empl_code =:1
af80uck5tnjvx SELECT "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT"."USER_CODE" , "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT"."EMPL_NAME" , "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT"."CLASS1_CODE" , "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT"."DEPT_CODE" , "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT"."SEX_CODE" , "HYHIS"."HYLOCAL_LIS_DEPT"."DEPT_NAME" FROM "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT" , "HYHIS"."HYLOCAL_LIS_DEPT" WHERE ( "HYHIS"."HYLOCAL_LIS_USER_VS_DEPT"."DEPT_CODE" = "HYHIS"."HYLOCAL_LIS_DEPT"."DEPT_CODE" ) and ( ( HYHIS."HYLOCAL_LIS_USER_VS_DEPT"."USER_CODE" = :ls_user_code ) )
angzzfa5jhyw2 SELECT clinic_code, --门诊号/发票号 card_no, --就诊卡号 reg_date, --挂号日期 noon_code, --午别 name, --姓名 idenno, --身份证号 sex_code, --性别 birthday, --出生日 paykind_code, --结算类别号 paykind_name, --结算类别名称 pact_code, --合同号 pact_name, --合同单位名称 mcard_no, --医疗证号 reglevl_code, --挂号级别 reglevl_name, --挂号级别名称 dept_code, --科室号 dept_name, --科室名称 seeno, --看诊序号 doct_code, --医师代号 doct_name, --医师姓名 ynbook, --是否预约 ynfr, --1初诊/2复诊 reg_fee, --挂号费 chck_fee, --检查费 diag_fee, --诊察费 oth_fee, --附加费 own_cost, --自费金额 pub_cost, --报销金额 pay_cost, --自付金额 valid_flag, --退号标志 oper_code, --操作员代码 ynsee, --是否看诊 oper_date, --退号时间 trans_type, --交易类型 balance_flag, --日结标志 balance_no, --日结序号 balance_opcd, --日结人 balance_date, --日结时间 rela_phone, --联系电话 address, --地址 ynregchrg, --是否收费 cancel_opcd, --作废人 cancel_date, --作废时间 card_type, --证件类型 begin_time, --开始时间 end_time, --结束时间 see_date, --看诊日期 triage_flag, --分诊标志 triage_opcd, --分诊人 triage_date, --分诊时间 invoice_no, --发票号 recipe_no, --处方号 append_flag, --加急标志 order_no, schema_no, in_source, in_state, --R-留观登记 I-留观接诊 O-留观结束 N-非留观 in _date, --开始留观日期 out_date, --留观结束日期 zg, --转归代号 (select bed_no from com_bedinfo where clinic_no = fin_opr_register.clinic_code) as bed_no, --留观床号 is_account, see_dpcd, --看诊科室 see_docd, --看诊医生 Is_Emergency, mark1, ECO_COST, work_home_id, work_home_name FROM fin_opr_register WHERE see_docd='000075' AND see_date>=to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND see_date<=to_date('2013-1-25 10:38:05', 'yyyy-mm-dd HH24:mi:ss') AND valid_flag='1' AND ynsee='1' order by ynbook desc
attkhygd43my0 SELECT see_no, --看诊序号 sequence_no, --项目流水号 clinic_code, --门诊号 card_no, --病历号 reg_date, --挂号日期 dept_code, --挂号科室 item_code, --项目代码 item_name, --项目名称 specs, --规格 drug_flag, --1药品，2非药品 class_code, --系统类别 fee_code, --最小费用代码 unit_price, --单价 qty, --开立数量 days, --付数 pack_qty, --包装数量 item_unit, --计价单位 own_cost, --自费金额 pay_cost, --自负金额 pub_cost, --报销金额 base_dose, --基本剂量 self_made, --自制药 drug_quanlity, --药品性质，普药、贵药 once_dose, --每次用量 once_unit, --每次用量单位 dose_model_code, --剂型代码 frequency_code, --频次 frequency_name, --频次名称 usage_code, --使用方法 usage_name, --用法名称 english_ab, --用法英文缩写 exec_dpcd, --执行科室代码 exec_dpnm, --执行科室名称 main_drug, --主药标志 comb_no, --组合号 hypotest, --1不需要皮试/2需要皮试，未做/3皮试阳/4皮试阴 inject_number, --院内注射次数 remark, --备注 doct_code, --开立医生 doct_name, --开立医生名称 doct_dpcd, --医生科室 oper_date, --开立时间 status, --处方状态, 1开立，2收费，3确认，4作废 cancel_userid, --作废人 cancel_date, --作废时间 emc_flag, --加急标记0普通/1加急 lab_type, --样本类型 check_body, --检体 apply_no, --申请单号 subtbl_flag, --0没有附材/1带附材/2是附材 need_confirm, - -是否需要确认，1需要，0不需要 confirm_code, --确认人 confirm_dept, --确认科室 confirm_date, --确认时间 charge_flag, --0未收费/1收费 charge_code, --收费员 charge_date, --收费时间 recipe_no, --处方号 recipe_seq, --处方内流水号 phamarcy_code, --取药药房 MINUNIT_FLAG, --最小单位 (select p.split_type from pha_com_baseinfo p where p.drug_code = met_ord_recipedetail.item_code), ordertype, --医嘱类型 subcombno, RESUMEORDER, RECIPE_FEESEQ, PASS_FLAG, SORT_ID, mark1, mark2, mark3 FROM met_ord_recipedetail where SEQUENCE_NO='14847483'
ba3ptcrc3jqu4 SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY030000113256' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
c3uw91jm7uz49 SELECT nurse_cell_code, --门诊护士站代码 queue_code, --队列代码 queue_name, --队列名称 noon_code, --午别 queue_flag, --1医生队列/2自定义队列 sort_id, --显示顺序 valid_flag, --1有效/0无效 remark, --备注 oper_code, --操作员 oper_date, --操作时间 queue_date, --队列日期 doct_code, --看诊医生 ROOM_ID, ROOM_NAME, CONSOLE_CODE, CONSOLE_NAME, EXPERT_FLAG, dept_code, dept_name, --waiting_count (select count(a.console_code) from met_nuo_assignrecord a where a.console_code = met_nuo_queue.console_code AND a.triage_date >= to_date('2013/1/24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date < to_date('2013/1/24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and a.assign_flag = 2 group by a.console_code) as waitingcount FROM met_nuo_queue --门诊护士站分诊队列表 Where NURSE_CELL_CODE = '7905'-- VARCHAR2(12) N 队列代码 And QUEUE_DATE >= to_date('2013/1/24 00:00:00', 'yyyy-mm-dd HH24:mi:ss') and QUEUE_DATE < to_date('2013/1/24 23:59:59', 'yyyy-mm-dd HH24:mi:ss') order by sort_id
c64311xp7y7j7 select * from ( select nvl((decode(a.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费')), '自费') as grade, ---select nvl((decode(a.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费')), '自费') as grade, nvl((decode(a.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7')), '7') as orderNo, c.name, h.gb_code as item_code, a.drug_name as item_name, a.specs, --规格 a.qty, --数量 a.current_unit, -- 当前单位 a.unit_price, -- 单价 0 as limit_price, a.tot_cost, -- 计价金额 a.fee_date, --计费时间 d.empl_name, --操作员 a.si_confirm_flag, a.si_confirm_type from fin_ipb_medicinelist a , com_dictionary c, com_employee d , pha_com_baseinfo h where a.fee_code = c.code and a.drug_code = h.drug_code and a.fee_opercode = d.empl_code and c.type = 'MINFEE' and a.inpatient_no = 'ZY030000186422' union all select nvl((decode(e.center_item_grade, '1', '甲类药品', '2', '乙类药品', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费')), '自费') as grade, ---select nvl((decode(e.center_item_grade, '1', '甲类项目', '2', '乙类项目', '3', '自费', '4', '特殊检查', '5', '特殊治疗', '6', '特殊材料', '7', '普通诊疗', '自费')), '自费') as grade, nvl((decode(e.center_item_grade, '1', '5', '2', '6', '3', '7', '4', '2', '5', '3', '6', '4', '7', '1', '7')), '7') as orderNo, c.name, --最小费用 g.gb_code, --国家编码 e.item_name, g.specs, e.qty, e.current_unit, e.unit_price, nvl((select i.limit_price from fin_com_undruginfolocal i where e.item_code = i.item_code and e.pact_code = i.pact_code), 0) as limit_price, e.tot_cost, e.fee_date, d.empl_name, e.si_confirm_flag, e.si_confirm_type from fin_ipb_itemlist e, com_dictionary c, com_employee d, fin_com_undruginfo g where e.item_code = g.item_code and e.fee_code = c.code and e.fee_opercode = d.empl_code and c.type = 'MINFEE' and e.inpatient_no = 'ZY030000186422') f where f.fee_date >= to_date('2013-1-8 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and f.fee_date <= to_date('2013-1-25 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and f.grade like '乙类药品' and f.name like '%%' order by f.orderNo, f.Grade, f.name, f.item_code
csj30nc011buq SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227686' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
cvn54b7yz0s8uselect /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
cxrdjbq98qzuv SELECT qc.ID, qc.FILEID, qc.INPATIENT_NO, --住院流水号 qc.NAME, --患者姓名 qc.DEPT_CODE, --科室编码 re.COURSE_DATE, --病程日期 re.COURSE_TIME, --病程时间 re.MEMO, --查房医师 re.COURSE_TYPE, --病程记录类型ID、 re.COURSE_NAME, --病历类型名称 qc.STATE, --状态 0 建立 1住院医师签名 2 封存 3 作废 4主治医师签名 5主任（副主任医师签名） qc.CREATEDATE, --建立时间 qc.CREATEOPER_CODE, --建立人 qc.SAVEDATE, --签名日期 qc.SAVEOPER_CODE, --签名操作员 qc.SEALDATE, --封存日期 qc.SEALOPER_CODE, --封存人 qc.DELETEDATE, --删除日期 qc.DELETEOPER_CODE, --删除人 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = DELETEOPER_CODE) DELETEOPER_NAME, --删除人姓名 INTERN_SAVEDATE, --实习生签名日期 INTERN_SAVEOPER_CODE, --实习生签名操作员 SUPER_SAVEDATE, --主治签名日期 SUPER_SAVEOPER_CODE, --上级签名操作员 SENIOR_SAVEDATE, --主任签名日期 SENIOR_SAVEOPER_CODE, --主任签名操作员 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = INTERN_SAVEOPER_CODE) INTERNOPER_NAME, --生习生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SAVEOPER_CODE) SAVEOPER_NAME, --住院医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SUPER_SAVEOPER_CODE) SUPEROPER_NAME, --主治医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SENIOR_SAVEOPER_CODE) SENIORSAVEOPER_NAME, --主任医生签名姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = CREATEOPER_CODE) CREATEOPER_NAME, --添加病程医生姓名 (SELECT EMPL_NAME FROM COM_EMPLOYEE WHERE EMPL_CODE = SEALOPER_CODE) SEALOPER_NAME, --封存医生姓名 re.EMR_NAME, --病历名称 re.SORTID --排序号 FROM EMR_COURSERECORD_QCDATA qc, emr_courserecord re WHERE RE.INPATIENT_NO = 'ZY010000227591' AND RE.ID = QC.ID AND STATE <> 3 ORDER BY RE.COURSE_DATE, to_date(nvl(to_single_byte(RE.Course_Time), '00:00'), 'hh24:mi'), RE.SORTID
d7uyynczr9uaa SELECT '', --父级医疗机构编码 '', --本级医疗机构编码 noon_code, --午别代码 noon_name, --午别名称 begin_time, --起始时间 end_time, --结束时间 urg_flag, --是否急诊 oper_code, --操作员 oper_date --操作时间 FROM fin_opr_noon --午别表
dfr2y4288w5nw SELECT '', --父级医疗机构编码 '', --本级医疗机构编码 a.clinic_code, --门诊号 a.see_sequence, --看诊序号 a.card_no, --病历号 a.reg_date, --挂号日期 a.name, --患者姓名 a.sex_code, --性别 a.paykind_code, --结算类别 a.ynurg, --1急诊/0普通 a.ynbook, --1预约/0普通 a.dept_code, --看诊科室 a.dept_name, --科室名称 a.queue_name, --队列名称 a.room_id, --出诊诊室 a.queue_code, --队列代码 a.room_name, --诊室名称 a.doct_code, --看诊医生 a.see_date, --看诊时间 a.assign_flag, --1分诊/2进诊/3诊出 a.nurse_cell_code, --分诊科室 a.triage_date, --分诊时间 a.in_date, --进诊时间 a.out_date, --出诊时间 a.oper_code, --操作员 a.oper_date, --操作时间 a.console_code, a.console_name, b.reglevl_code, b.reglevl_name, b.doct_name FROM met_nuo_assignrecord a, fin_opr_register b WHERE a.nurse_cell_code='7905' AND a.triage_date>=to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date<to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 AND a.assign_flag = '2' and b.oper_date > to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') - 10 and b.reg_date>=to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND b.reg_date<to_date('2013/1/24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and b.clinic_code = a.clinic_code and b.trans_type = '1' and b.valid_flag = fun_get_va lid --order by a.reg_date, a.SEE_SEQUENCE order by a.console_code, a.reg_date
dk1wag53fqkxg SELECT /*+INDEX(r IND_REGISTER5)*/ '', --父级医疗机构编码 '', --本级医疗机构编码 t.clinic_code, --门诊号 t.see_sequence, --看诊序号 t.card_no, --病历号 t.reg_date, --挂号日期 t.name, --患者姓名 t.sex_code, --性别 t.paykind_code, --结算类别 t.ynurg, --1急诊/0普通 t.ynbook, --1预约/0普通---10 t.dept_code, --看诊科室 t.dept_name, --科室名称 t.queue_name, --队列名称 t.room_id, --出诊诊室 t.queue_code, --队列代码 t.room_name, --诊室名称 t.doct_code, --看诊医生 t.see_date, --看诊时间 t.assign_flag, --1分诊/2进诊/3诊出 t.nurse_cell_code, --分诊科室--20 t.triage_date, --分诊时间 t.in_date, --进诊时间 t.out_date, --出诊时间 t.oper_code, --操作员 t.oper_date, --操作时间25 t.console_code, t.console_name, r.birthday, ---出生日期 r.paykind_code, ---患者类别 r.paykind_name, ---患者类别 --30 r.pact_code, ---合同单位 r.pact_name, ---合同单位 r.address, r.rela_phone, r.reglevl_code, --挂号级别 r.reglevl_name, r.doct_code, --医生 r.doct_name, r.is_account, r.OWN_COST, r.YNREGCHRG, r.in_state FROM met_nuo_assignrecord t , fin_opr_register r where t.clinic_code = r.clinic_code and t.reg_date >= to_date('2013-1-24 0:00:00', 'yyyy-mm-dd hh24:mi:ss') and t.reg_date < to_date('2013-1-25 10:38:29', 'yyyy-mm-dd hh24: mi:ss') + 1 and t.console_code = '1037' and t.assign_flag = '2' and r.valid_flag = '1' and r.trans_type = '1' and r.dept_code = '0004' order by t.reg_date , t.see_sequence
f0cd4708fxcmdSELECT "Tbl1005"."ID" "Col1030", "Tbl1005"."TIMES" "Col1031", "Tbl1005"."SN" "Col1032", "Tbl1005"."DIAGNOSETYPE" "Col1033", "Tbl1005"."STATUSCODE" "Col1034", "Tbl1005"."ICDCODE" "Col1035", "Tbl1005"."ICDVER" "Col1036", "Tbl1005"."NAME" "Col1037", "Tbl1005"."ICDM" "Col1038" FROM "HYHIS"."VIEW_SF_OH_SICKDIAGNOSE" "Tbl1005"
f5w65za900wpaSELECT a.EMPL_CODE, --0员工编码 a.EMPL_NAME, --1员工姓名 a.dept_code, --2医生站编码 a.dept_name, --3医生站名称 a.EMPL_TYPE, --4人员类型 D医生 N护士 a.manager_flag, --5管理员标志 1是 0否 a.nurse_dept_code, --6护士站编码 a.nurse_dept_name, --7护士站名称 a.spell_code, --8拼音码 a.wb_code, --9五笔 a.levl_code, --10职级代号 a.login_name, --11登录用户名 a.login_password, --12登录密码 a.levl_name --13职级名称 FROM VIEW_EMR_EMPLOYEE a WHERE a.empl_type='D' order by empl_code
fgbvy43psza4y SELECT see_no, --看诊序号 sequence_no, --项目流水号 clinic_code, --门诊号 card_no, --病历号 reg_date, --挂号日期 dept_code, --挂号科室 item_code, --项目代码 item_name, --项目名称 specs, --规格 drug_flag, --1药品，2非药品 class_code, --系统类别 fee_code, --最小费用代码 unit_price, --单价 qty, --开立数量 days, --付数 pack_qty, --包装数量 item_unit, --计价单位 own_cost, --自费金额 pay_cost, --自负金额 pub_cost, --报销金额 base_dose, --基本剂量 self_made, --自制药 drug_quanlity, --药品性质，普药、贵药 once_dose, --每次用量 once_unit, --每次用量单位 dose_model_code, --剂型代码 frequency_code, --频次 frequency_name, --频次名称 usage_code, --使用方法 usage_name, --用法名称 english_ab, --用法英文缩写 exec_dpcd, --执行科室代码 exec_dpnm, --执行科室名称 main_drug, --主药标志 comb_no, --组合号 hypotest, --1不需要皮试/2需要皮试，未做/3皮试阳/4皮试阴 inject_number, --院内注射次数 remark, --备注 doct_code, --开立医生 doct_name, --开立医生名称 doct_dpcd, --医生科室 oper_date, --开立时间 status, --处方状态, 1开立，2收费，3确认，4作废 cancel_userid, --作废人 cancel_date, --作废时间 emc_flag, --加急标记0普通/1加急 lab_type, --样本类型 check_body, --检体 apply_no, --申请单号 subtbl_flag, --0没有附材/1带附材/2是附材 need_confirm, - -是否需要确认，1需要，0不需要 confirm_code, --确认人 confirm_dept, --确认科室 confirm_date, --确认时间 charge_flag, --0未收费/1收费 charge_code, --收费员 charge_date, --收费时间 recipe_no, --处方号 recipe_seq, --处方内流水号 phamarcy_code, --取药药房 MINUNIT_FLAG, --最小单位 (select p.split_type from pha_com_baseinfo p where p.drug_code = met_ord_recipedetail.item_code), ordertype, --医嘱类型 subcombno, RESUMEORDER, RECIPE_FEESEQ, PASS_FLAG, SORT_ID, mark1, mark2, mark3 FROM met_ord_recipedetail where SEQUENCE_NO='14847482'
fnj6cnubp1saubegin if :enable = 0 then sys.dbms_output.disable; else sys.dbms_output.enable(:size); end if; end;
fzr13tg9vxcj0insert into emr_courserecord t ( t.data, --内容 t.id, --病程流水号 t.fileid, --病程文件号 t.inpatient_no, --患者流水号 t.name, --患者姓名 t.dept_code, --住院科室编码 t.memo, --查房医师姓名 t.course_type, --记录类型 t.course_name, --记录类型名称 t.doctor_name, --医师签名 t.oper_date, --操作时间 t.oper_code, --操作人员 t.course_date, --病程记录日期 t.course_time, --病程记录时间 t.emr_name, --病历名称 t.sortid, --排列顺序 t.IsStartNewPage ) values( :a, '309490', --病程流水号 '0', --病程文件号 'ZY010000227403', --患者流水号 '谢丽娜', --患者姓名 '0213', --住院科室编码 '', --查房医师姓名 '0001', --记录类型 '病程记录', --记录类型名称 '', --医师签名 sysdate, '', --操作人员 to_Date('2013-01-24', 'yyyy-mm-dd'), --病程记录日期 '10:25', --病程记录时间 '病程记录', --病历名称 nvl((select max(sortid) + 1 from emr_courserecord y where y.fileid = '0'), 1), --排列顺序 'False' )
g1yx0c7rxnuvtSELECT "Tbl1005"."ID" "Col1057", "Tbl1005"."TIMES" "Col1058", "Tbl1005"."SN" "Col1059", "Tbl1005"."ICD_ID" "Col1060", "Tbl1005"."DIAG_TJI" "Col1061", "Tbl1005"."DIAG_NAME" "Col1062", "Tbl1005"."STAT" "Col1063" FROM "HYHIS"."VIEW_SF_MZ_ZDDM" "Tbl1005" ORDER BY "Col1059" ASC
g2b6ctjfz6t7h SELECT '', --父级医疗机构编码 '', --本级医疗机构编码 a.clinic_code, --门诊号 a.see_sequence, --看诊序号 a.card_no, --病历号 a.reg_date, --挂号日期 a.name, --患者姓名 a.sex_code, --性别 a.paykind_code, --结算类别 a.ynurg, --1急诊/0普通 a.ynbook, --1预约/0普通 a.dept_code, --看诊科室 a.dept_name, --科室名称 a.queue_name, --队列名称 a.room_id, --出诊诊室 a.queue_code, --队列代码 a.room_name, --诊室名称 a.doct_code, --看诊医生 a.see_date, --看诊时间 a.assign_flag, --1分诊/2进诊/3诊出 a.nurse_cell_code, --分诊科室 a.triage_date, --分诊时间 a.in_date, --进诊时间 a.out_date, --出诊时间 a.oper_code, --操作员 a.oper_date, --操作时间 a.console_code, a.console_name, b.reglevl_code, b.reglevl_name, b.doct_name FROM met_nuo_assignrecord a, fin_opr_register b WHERE a.nurse_cell_code='7904' AND a.triage_date>=to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND a.triage_date<to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 AND a.assign_flag = '2' and b.oper_date > to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') - 10 and b.reg_date>=to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') AND b.reg_date<to_date('2013-1-24 0:00:00', 'yyyy-mm-dd HH24:mi:ss') + 1 and b.clinic_code = a.clinic_code and b.trans_type = '1' and b.valid_flag = fun_get_va lid --order by a.reg_date, a.SEE_SEQUENCE order by a.console_code, a.reg_date
g375rvh5yjsccbegin PRC_GET_INVOICENO(Par_InvoiceKind=>:Par_InvoiceKind, Par_UserId=>:Par_UserId, Par_NAlarm=>:Par_NAlarm, Par_InviceNo=>:Par_InviceNo, Par_ErrText=>:Par_ErrText, Par_NErrCode=>:Par_NErrCode, Par_GrpId=>:Par_GrpId); end;
g37zzhdxz360uSelect sysdate from dual
g3wrkmxkxzhf2select cols, audit$, textlength, intcols, property, flags, rowid from view$ where obj#=:1
g5avvp7mnhnpu SELECT see_no, --看诊序号 sequence_no, --项目流水号 clinic_code, --门诊号 card_no, --病历号 reg_date, --挂号日期 dept_code, --挂号科室 item_code, --项目代码 item_name, --项目名称 specs, --规格 drug_flag, --1药品，2非药品 class_code, --系统类别 fee_code, --最小费用代码 unit_price, --单价 qty, --开立数量 days, --付数 pack_qty, --包装数量 item_unit, --计价单位 own_cost, --自费金额 pay_cost, --自负金额 pub_cost, --报销金额 base_dose, --基本剂量 self_made, --自制药 drug_quanlity, --药品性质，普药、贵药 once_dose, --每次用量 once_unit, --每次用量单位 dose_model_code, --剂型代码 frequency_code, --频次 frequency_name, --频次名称 usage_code, --使用方法 usage_name, --用法名称 english_ab, --用法英文缩写 exec_dpcd, --执行科室代码 exec_dpnm, --执行科室名称 main_drug, --主药标志 comb_no, --组合号 hypotest, --1不需要皮试/2需要皮试，未做/3皮试阳/4皮试阴 inject_number, --院内注射次数 remark, --备注 doct_code, --开立医生 doct_name, --开立医生名称 doct_dpcd, --医生科室 oper_date, --开立时间 status, --处方状态, 1开立，2收费，3确认，4作废 cancel_userid, --作废人 cancel_date, --作废时间 emc_flag, --加急标记0普通/1加急 lab_type, --样本类型 check_body, --检体 apply_no, --申请单号 subtbl_flag, --0没有附材/1带附材/2是附材 need_confirm, - -是否需要确认，1需要，0不需要 confirm_code, --确认人 confirm_dept, --确认科室 confirm_date, --确认时间 charge_flag, --0未收费/1收费 charge_code, --收费员 charge_date, --收费时间 recipe_no, --处方号 recipe_seq, --处方内流水号 phamarcy_code, --取药药房 MINUNIT_FLAG, --最小单位 (select p.split_type from pha_com_baseinfo p where p.drug_code = met_ord_recipedetail.item_code), ordertype, --医嘱类型 subcombno, RESUMEORDER, RECIPE_FEESEQ, PASS_FLAG, SORT_ID, mark1, mark2, mark3 FROM met_ord_recipedetail where SEQUENCE_NO='14847484'
ga9j9xk5cy9s0select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece#
gj50gqh7jrw3mSELECT "Tbl1005"."ID" "Col1043", "Tbl1005"."TIMES" "Col1044", "Tbl1005"."SN" "Col1045", "Tbl1005"."OPERATIONCODE" "Col1046", "Tbl1005"."EMPID" "Col1047", "Tbl1005"."NAME" "Col1048", "Tbl1005"."OPDATE" "Col1049", "Tbl1005"."QIEKOU" "Col1050", "Tbl1005"."YUHE" "Col1051", "Tbl1005"."MAZUI" "Col1052" FROM "HYHIS"."VIEW_SF_OH_SICKOPERATION" "Tbl1005"

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CR blocks created 13,718 3.56 0.61
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DBWR checkpoint buffers written 148,940 38.68 6.65
DBWR checkpoints 3 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 121 0.03 0.01
DBWR undo block writes 14,247 3.70 0.64
IMU CR rollbacks 1,167 0.30 0.05
IMU Flushes 6,200 1.61 0.28
IMU Redo allocation size 53,376,232 13,863.06 2,381.59
IMU bind flushes 0 0.00 0.00
IMU commits 14,653 3.81 0.65
IMU contention 195 0.05 0.01
IMU ktichg flush 362 0.09 0.02
IMU pool not allocated 2,862 0.74 0.13
IMU recursive-transaction flush 48 0.01 0.00
IMU undo allocation size 104,508,008 27,143.19 4,663.04
IMU- failed to get a private strand 2,862 0.74 0.13
Misses for writing mapping 0 0.00 0.00
Parallel operations downgraded to serial 0 0.00 0.00
RowCR - row contention 297 0.08 0.01
RowCR attempts 12,744 3.31 0.57
RowCR hits 59,020 15.33 2.63
SMON posted for dropping temp segment 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 4,946,685 1,284.77 220.72
active txn count during cleanout 25,929 6.73 1.16
application wait time 6,300 1.64 0.28
background checkpoints completed 3 0.00 0.00
background checkpoints started 3 0.00 0.00
background timeouts 9,770 2.54 0.44
branch node splits 6 0.00 0.00
buffer is not pinned count 512,982,931 133,233.74 22,888.76
buffer is pinned count 1,095,997,481 284,656.33 48,902.26
bytes received via SQL*Net from client 1,150,653,575 298,851.81 51,340.96
bytes sent via SQL*Net to client 4,621,418,978 1,200,291.25 206,202.88
calls to get snapshot scn: kcmgss 5,874,201 1,525.67 262.10
calls to kcmgas 80,141 20.81 3.58
calls to kcmgcs 2,440 0.63 0.11
change write time 610 0.16 0.03
cleanout - number of ktugct calls 14,335 3.72 0.64
cleanouts and rollbacks - consistent read gets 9,534 2.48 0.43
cleanouts only - consistent read gets 432 0.11 0.02
cluster key scan block gets 33,472 8.69 1.49
cluster key scans 14,181 3.68 0.63
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 2,029 0.53 0.09
commit batch/immediate requested 2,029 0.53 0.09
commit cleanout failures: block lost 1,199 0.31 0.05
commit cleanout failures: buffer being written 1 0.00 0.00
commit cleanout failures: callback failure 448 0.12 0.02
commit cleanout failures: cannot pin 68 0.02 0.00
commit cleanouts 227,005 58.96 10.13
commit cleanouts successfully completed 225,289 58.51 10.05
commit immediate performed 2,029 0.53 0.09
commit immediate requested 2,029 0.53 0.09
commit txn count during cleanout 15,952 4.14 0.71
concurrency wait time 530 0.14 0.02
consistent changes 295,038 76.63 13.16
consistent gets 1,613,946,721 419,179.94 72,012.61
consistent gets - examination 332,529,959 86,365.85 14,837.14
consistent gets direct 47,054 12.22 2.10
consistent gets from cache 1,613,899,669 419,167.72 72,010.52
current blocks converted for CR 0 0.00 0.00
cursor authentications 97,779 25.40 4.36
data blocks consistent reads - undo records applied 34,838 9.05 1.55
db block changes 1,761,618 457.53 78.60
db block gets 2,110,406 548.12 94.16
db block gets direct 3,224 0.84 0.14
db block gets from cache 2,107,182 547.28 94.02
deferred (CURRENT) block cleanout applications 103,371 26.85 4.61
dirty buffers inspected 20,809 5.40 0.93
doubling up with imu segment 2 0.00 0.00
enqueue conversions 775 0.20 0.03
enqueue deadlocks 0 0.00 0.00
enqueue releases 402,059 104.42 17.94
enqueue requests 402,068 104.43 17.94
enqueue timeouts 1 0.00 0.00
enqueue waits 14 0.00 0.00
exchange deadlocks 0 0.00 0.00
execute count 4,072,483 1,057.72 181.71
failed probes on index block reclamation 0 0.00 0.00
free buffer inspected 10,964,801 2,847.82 489.24
free buffer requested 10,967,440 2,848.50 489.36
heap block compress 15,418 4.00 0.69
hot buffers moved to head of LRU 1,452,102 377.15 64.79
immediate (CR) block cleanout applications 9,966 2.59 0.44
immediate (CURRENT) block cleanout applications 7,699 2.00 0.34
index crx upgrade (found) 0 0.00 0.00
index crx upgrade (positioned) 40,091 10.41 1.79
index fast full scans (full) 497 0.13 0.02
index fetch by key 105,157,678 27,311.92 4,692.03
index scans kdiixs1 120,269,054 31,236.70 5,366.28
leaf node 90-10 splits 143 0.04 0.01
leaf node splits 797 0.21 0.04
lob reads 141,880 36.85 6.33
lob writes 99,172 25.76 4.42
lob writes unaligned 99,171 25.76 4.42
logons cumulative 1,644 0.43 0.07
messages received 90,474 23.50 4.04
messages sent 90,474 23.50 4.04
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 1,271,650,999 330,277.69 56,739.74
opened cursors cumulative 1,429,819 371.36 63.80
parse count (failures) 445 0.12 0.02
parse count (hard) 273,415 71.01 12.20
parse count (total) 1,404,893 364.88 62.68
physical read IO requests 1,173,086 304.68 52.34
physical read bytes 89,768,312,832 23,314,943.05 4,005,368.23
physical read total IO requests 1,177,631 305.86 52.54
physical read total bytes 90,200,267,776 23,427,131.91 4,024,641.61
physical read total multi block requests 739,901 192.17 33.01
physical reads 10,958,046 2,846.06 488.94
physical reads cache 10,866,600 2,822.31 484.86
physical reads cache prefetch 9,737,278 2,529.00 434.47
physical reads direct 91,446 23.75 4.08
physical reads direct (lob) 46,468 12.07 2.07
physical reads direct temporary tablespace 46,073 11.97 2.06
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 90,596 23.53 4.04
physical write bytes 1,934,221,312 502,362.79 86,302.93
physical write total IO requests 144,263 37.47 6.44
physical write total bytes 3,015,621,632 783,227.89 134,553.88
physical write total multi block requests 53,077 13.79 2.37
physical writes 236,111 61.32 10.54
physical writes direct 47,616 12.37 2.12
physical writes direct (lob) 1,543 0.40 0.07
physical writes direct temporary tablespace 46,073 11.97 2.06
physical writes from cache 188,495 48.96 8.41
physical writes non checkpoint 139,045 36.11 6.20
pinned buffers inspected 3,880 1.01 0.17
prefetch clients - default 0 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
recovery blocks read 0 0.00 0.00
recursive calls 5,040,953 1,309.25 224.92
redo blocks read for recovery 0 0.00 0.00
redo blocks written 305,846 79.44 13.65
redo buffer allocation retries 11 0.00 0.00
redo entries 737,188 191.47 32.89
redo log space requests 12 0.00 0.00
redo log space wait time 34 0.01 0.00
redo ordering marks 12,262 3.18 0.55
redo size 297,424,000 77,248.01 13,270.75
redo subscn max counts 18,587 4.83 0.83
redo synch time 20,432 5.31 0.91
redo synch writes 23,884 6.20 1.07
redo wastage 10,725,792 2,785.74 478.57
redo write time 10,478 2.72 0.47
redo writer latching time 26 0.01 0.00
redo writes 24,048 6.25 1.07
rollback changes - undo records applied 51,213 13.30 2.29
rollbacks only - consistent read gets 4,268 1.11 0.19
root node splits 0 0.00 0.00
rows fetched via callback 65,448,519 16,998.52 2,920.24
session cursor cache hits 645,035 167.53 28.78
session logical reads 1,616,057,035 419,728.04 72,106.77
shared hash latch upgrades - no wait 8,346,839 2,167.87 372.43
shared hash latch upgrades - wait 8 0.00 0.00
sorts (disk) 0 0.00 0.00
sorts (memory) 153,793 39.94 6.86
sorts (rows) 12,826,110 3,331.24 572.29
sql area evicted 269,310 69.95 12.02
sql area purged 445 0.12 0.02
summed dirty queue length 186,055 48.32 8.30
switch current to new buffer 18,224 4.73 0.81
table fetch by rowid 601,680,839 156,270.67 26,846.37
table fetch continued row 8,662,747 2,249.92 386.52
table scan blocks gotten 752,064,061 195,328.73 33,556.31
table scan rows gotten 43,098,220,343 11,193,621.90 1,922,997.52
table scans (long tables) 5,179 1.35 0.23
table scans (rowid ranges) 0 0.00 0.00
table scans (short tables) 236,416 61.40 10.55
total number of times SMON posted 0 0.00 0.00
transaction rollbacks 2,029 0.53 0.09
transaction tables consistent read rollbacks 4 0.00 0.00
transaction tables consistent reads - undo records applied 118 0.03 0.01
undo change vector size 95,526,424 24,810.46 4,262.29
user I/O wait time 0 0.00 0.00
user calls 6,148,538 1,596.92 274.34
user commits 20,662 5.37 0.92
user rollbacks 1,750 0.45 0.08
workarea executions - onepass 8 0.00 0.00
workarea executions - optimal 82,645 21.46 3.69
write clones created in background 0 0.00 0.00
write clones created in foreground 89 0.02 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session pga memory max 7.1E+11 7.1E+11
session cursor cache count 106,681,319 106,711,474
session uga memory 1.5E+15 1.5E+15
opened cursors current 3,912 3,121
workarea memory allocated 0 22,978
logons current 470 398
session uga memory max 5.0E+12 5.0E+12
session pga memory 6.0E+11 6.0E+11

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 3 2.81

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)
HIS_DATA 1,123,525 292 0.00 9.67 64,074 17 57,609 2.30
HIS_INDEX 38,031 10 0.00 1.00 16,311 4 1 0.00
SYSTEM 6,577 2 0.00 1.09 214 0 0 0.00
TEMP 3,149 1 0.00 14.64 2,984 1 0 0.00
UNDOTBS1 6 0 0.00 1.00 4,099 1 6 0.00
EMRLOG 499 0 0.00 1.00 1,837 0 0 0.00
USERS 743 0 0.00 1.01 180 0 0 0.00
SYSAUX 456 0 0.00 1.16 390 0 0 0.00
EMR 42 0 0.00 1.00 506 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)
EMR /u02/orcl/emr01.dbf 42 0 0.00 1.00 506 0 0 0.00
EMRLOG /u02/orcl/emrlog01.dbf 16 0 0.00 1.00 95 0 0 0.00
EMRLOG /u02/orcl/emrlog02.dbf 483 0 0.00 1.00 1,742 0 0 0.00
HIS_DATA /u02/orcl/hisdata01.dbf 376,801 98 0.00 9.97 14,033 4 9,533 2.73
HIS_DATA /u02/orcl/hisdata02.dbf 358,610 93 0.00 10.25 14,422 4 7,325 3.03
HIS_DATA /u02/orcl/hisdata03.dbf 388,114 101 0.00 8.84 35,619 9 40,751 2.06
HIS_INDEX /u02/orcl/his_index01.dbf 19,677 5 0.00 1.00 8,173 2 0 0.00
HIS_INDEX /u02/orcl/his_index02.dbf 18,354 5 0.00 1.00 8,138 2 1 0.00
SYSAUX /u01/orcl/sysaux01.dbf 456 0 0.00 1.16 390 0 0 0.00
SYSTEM /u01/orcl/system01.dbf 6,577 2 0.00 1.09 214 0 0 0.00
TEMP /u01/orcl/temp01.dbf 3,149 1 0.00 14.64 2,984 1 0  
UNDOTBS1 /u01/orcl/undotbs01.dbf 6 0 0.00 1.00 4,099 1 6 0.00
USERS /u01/orcl/users01.dbf 743 0 0.00 1.01 180 0 0 0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

PNumber of BuffersPool Hit%Buffer GetsPhysical ReadsPhysical WritesFree Buff WaitWrit Comp WaitBuffer Busy Waits
D 759,936 99 1,610,755,948 10,866,465 188,495 0 0 57,616


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 21 5339 20317 115892 589770 115892  
E 0 17 2982 10908 78578 589770 78578  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
84.62 5,259 956

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 3,072 2,396 783.35 0.00 0.00 0.00 0.00 314,570
E 3,072 2,455 667.12 22.44 3.36 100.00 0.00 314,570

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 77,825 77,825 0 0
64K 128K 2,096 2,096 0 0
128K 256K 210 210 0 0
256K 512K 158 158 0 0
512K 1024K 1,743 1,743 0 0
1M 2M 139 139 0 0
2M 4M 329 329 0 0
4M 8M 109 109 0 0
16M 32M 36 36 0 0
64M 128M 8 0 8 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

SGA Target Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 57,606 132 2
undo block 5 0 0
undo 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) 11 11 0 11 0 0.00
TX-Transaction (index contention) 700 700 0 3 0 0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Back to Top

Undo Segment Summary

Undo TS#Num Undo Blocks (K)Number of TransactionsMax Qry Len (s)Max Tx ConcurcyMin/Max TR (mins)STO/ OOS uS/uR/uU/ eS/eR/eU
1 14.92 40,504 231 11 17865.1/18610.7 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
24-Jan 11:38 1,119 5,019 53 7 18,026 0/0 0/0/0/0/0/0
24-Jan 11:28 1,134 4,874 42 7 18,073 0/0 0/0/0/0/0/0
24-Jan 11:18 1,523 5,461 59 6 18,095 0/0 0/0/0/0/0/0
24-Jan 11:08 6,200 6,000 155 11 17,865 0/0 0/0/0/0/0/0
24-Jan 10:58 1,814 6,396 78 8 18,495 0/0 0/0/0/0/0/0
24-Jan 10:48 1,463 5,851 231 9 18,593 0/0 0/0/0/0/0/0
24-Jan 10:38 1,663 6,903 135 7 18,611 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,545 0.00   0 0  
Consistent RBA 24,053 0.00 0.00 0 0  
FAL request queue 83 0.00   0 0  
FAL subheap alocation 83 0.00   0 0  
FIB s.o chain latch 30 0.00   0 0  
FOB s.o list latch 8,174 0.00   0 0  
In memory undo latch 203,288 0.00   0 35,490 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 23,010 0.00   0 0  
JS slv state obj latch 283 0.00   0 0  
KMG MMAN ready and startup request latch 1,277 0.00   0 0  
KTF sga latch 4,617 0.00   0 1,271 0.00
KWQMN job cache list latch 1 0.00   0 0  
MQL Tracking Latch 0     0 77 0.00
Memory Management Latch 0     0 1,277 0.00
OS process 5,238 0.00   0 0  
OS process allocation 4,698 0.00   0 0  
OS process: request allocation 3,229 0.00   0 0  
PL/SQL warning settings 5,697 0.00   0 0  
SGA IO buffer pool latch 734,988 0.10 0.09 0 734,988 0.08
SQL memory manager latch 0     0 1,271 0.00
SQL memory manager workarea list latch 104,534 0.00   0 0  
Shared B-Tree 137 0.00   0 0  
active checkpoint queue latch 67,447 0.00   0 0  
active service list 14,247 0.00   0 3,745 0.00
alert log latch 6 0.00   0 0  
archive control 79 0.00   0 0  
archive process latch 1,443 0.00   0 0  
begin backup scn array 1,522 0.00   0 0  
cache buffer handles 45,584 0.00   0 0  
cache buffers lru chain 469,398 0.45 0.00 0 109,165,220 0.29
cache table scan latch 0     0 727,962 0.98
channel handle pool latch 3,229 0.00   0 0  
channel operations parent latch 22,785 0.00   0 0  
checkpoint queue latch 1,084,144 0.00 0.00 0 183,550 0.01
client/application info 10,881 0.00   0 0  
commit callback allocation 2 0.00   0 0  
compile environment latch 1,645 0.00   0 0  
dml lock allocation 112,740 0.01 0.00 0 0  
dummy allocation 3,362 0.00   0 0  
enqueue hash chains 805,025 0.00 0.00 0 0  
enqueues 702,215 0.02 0.04 0 0  
event group latch 1,579 0.00   0 0  
file cache latch 35 0.00   0 0  
global KZLD latch for mem in SGA 1,527 0.00   0 0  
hash table column usage latch 1,602 0.00   0 3,451,376 0.00
instance information 4,794 0.00   0 0  
internal temp table object number allocation latc 36 0.00   0 0  
interrupt manipulation 1 0.00   0 0  
job workq parent latch 0     0 134 0.00
job_queue_processes parameter latch 130 0.00   0 0  
kks stats 1,703,132 0.01 0.12 0 0  
kokc descriptor allocation latch 4,746 0.00   0 0  
ksuosstats global area 4 0.00   0 0  
ktm global data 13 0.00   0 0  
kwqbsn:qsga 137 0.00   0 0  
lgwr LWN SCN 24,192 0.02 0.00 0 0  
library cache 12,959,629 0.06 0.00 0 1,153,333 0.13
library cache load lock 12,706 0.00   0 0  
library cache lock 13,510,062 0.01 0.00 0 0  
library cache lock allocation 31,312 0.00   0 0  
library cache pin 3,280,969 0.00 0.00 0 0  
library cache pin allocation 6,668 0.00   0 0  
list of block allocation 15,325 0.00   0 0  
loader state object freelist 18,366 0.00   0 0  
messages 226,658 0.00 0.00 0 0  
mostly latch-free SCN 25,951 3.35 0.00 0 0  
multiblock read objects 1,667,002 0.03 0.00 0 0  
ncodef allocation latch 103 0.00   0 0  
object queue header heap 1,533 0.00   0 1,724 0.00
object queue header operation 22,493,279 0.00 0.00 0 0  
object stats modification 2 0.00   0 0  
parallel query alloc buffer 508 0.00   0 0  
parameter list 15,204 0.00   0 0  
parameter table management 3,365 0.00   0 0  
policy information 33,558 0.00   0 0  
post/wait queue 36,068 0.00   0 24,398 0.00
process allocation 3,229 0.03 1.00 0 1,579 0.00
process group creation 3,229 0.00   0 0  
qmn task queue latch 548 0.00   0 0  
redo allocation 140,466 0.01 0.00 0 737,286 0.01
redo copy 0     0 737,304 0.03
redo writing 142,442 0.00 0.00 0 0  
resmgr group change latch 1,879 0.00   0 0  
resmgr:active threads 3,364 0.00   0 0  
resmgr:actses change group 1,598 0.00   0 0  
resmgr:free threads list 3,362 0.00   0 0  
resmgr:resource group CPU method 1,669 0.00   0 0  
resmgr:schema config 2 0.00   0 0  
row cache objects 38,134,495 0.14 0.00 0 11,570 0.20
sequence cache 79,775 0.00   0 0  
session allocation 181,759 0.01 0.00 0 0  
session idle bit 12,381,940 0.01 0.00 0 0  
session state list latch 6,887 0.00   0 0  
session switching 8,353 0.00   0 0  
session timer 2,159 0.00   0 0  
shared pool 14,708,186 0.24 0.06 1 0  
sort extent pool 2,048 0.00   0 0  
state object free list 4 0.00   0 0  
statistics aggregation 672 0.00   0 0  
temp lob duration state obj allocation 523 0.00   0 0  
threshold alerts latch 13 0.00   0 0  
transaction allocation 2,818 0.00   0 0  
transaction branch allocation 2,159 0.00   0 0  
undo global data 213,832 0.00   0 475 0.00
user lock 6,415 0.00   0 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
row cache objects 38,134,495 53,775 6 53,769 0 0 0
shared pool 14,708,186 34,693 2,203 32,583 0 0 0
library cache 12,959,629 8,226 39 8,189 0 0 0
cache buffers lru chain 469,398 2,104 7 2,097 0 0 0
library cache lock 13,510,062 1,050 1 1,049 0 0 0
object queue header operation 22,493,279 798 2 796 0 0 0
session idle bit 12,381,940 780 1 779 0 0 0
SGA IO buffer pool latch 734,988 709 66 649 0 0 0
multiblock read objects 1,667,002 541 1 540 0 0 0
kks stats 1,703,132 182 21 162 0 0 0
enqueues 702,215 154 6 148 0 0 0
process allocation 3,229 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
SGA IO buffer pool latch ksfd_alloc_sgabuffer 0 50 0
SGA IO buffer pool latch ksfd_free_sgabuffer 0 16 66
cache buffers lru chain kcbzgws 0 7 0
enqueues ksqgel: create enqueue 0 4 1
enqueues ksqdel 0 2 2
event range base latch No latch 0 5,256 0
kks stats kks stats alloc/free 0 21 21
library cache kgldti: 2child 0 4 2
library cache kglobpn: child: 0 4 6
library cache kglukp: child 0 4 2
library cache kglhdgn: child: 0 2 5
library cache kglpndl: child: after processing 0 2 0
library cache kglhdgc: child: 0 1 0
library cache kglic 0 1 0
library cache kglpin 0 1 0
library cache lock kgllkdl: child: no lock handle 0 10 4
library cache lock kgllkdl: child: cleanup 0 1 0
multiblock read objects kcbzib: normal mbr free 0 1 1
object queue header operation kcbo_switch_cq 0 1 1
object queue header operation kcbo_switch_mq_bg 0 1 1
object queue header operation kcbo_switch_q_bg 0 1 0
object queue header operation kcbw_link_q 0 1 0
process allocation ksucrp 0 1 0
row cache objects kqreqd: reget 0 3 0
row cache objects kqrso 0 2 0
row cache objects kqrpre: find obj 0 1 6
session idle bit ksupuc: clear busy 0 2 2
session idle bit ksupuc: set busy 0 2 2
shared pool kghalo 0 1,713 1,256
shared pool kghupr1 0 181 258
shared pool kghfrunp: alloc: wait 0 143 1
shared pool kghfre 0 96 323
shared pool kghalp 0 62 300
shared pool kghfrunp: clatch: nowait 0 9 0
shared pool kghasp 0 8 65
shared pool kghfrunp: clatch: wait 0 1 18

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

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 8 12.50 0   4 1
dc_database_links 3,057 0.00 0   0 1
dc_global_oids 9,197 0.99 0   0 15
dc_histogram_data 2,022,976 0.18 0   0 1,064
dc_histogram_defs 5,207,054 0.27 0   0 4,434
dc_object_grants 1,080 27.87 0   0 99
dc_object_ids 3,903,728 0.05 0   0 693
dc_objects 560,628 0.35 0   5 423
dc_profiles 1,595 0.00 0   0 1
dc_rollback_segments 3,351 0.00 0   0 214
dc_segments 1,507,260 0.14 0   31 672
dc_sequences 10,224 1.57 0   10,224 26
dc_tablespace_quotas 2 100.00 0   2 0
dc_tablespaces 167,241 0.01 0   0 5
dc_usernames 17,839 0.55 0   0 14
dc_users 635,135 0.02 0   0 51


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 732 4.51 73,815 0.09 30 0
CLUSTER 144 3.47 250 3.20 3 0
INDEX 944 4.13 9,952 0.51 12 0
SQL AREA 1,020,419 47.62 4,790,941 16.51 31,252 515
TABLE/PROCEDURE 78,901 1.23 2,005,440 0.30 2,876 0
TRIGGER 3,936 0.25 14,403 0.17 15 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 543.72   1.14 0.88 11 11 479 479
  Freeable 207.75 0.00 0.78 2.09 34   265 265
  PL/SQL 19.84 11.60 0.04 0.01 0 0 471 471
  SQL 13.18 8.82 0.03 0.03 0 23 462 460
E Other 436.23   1.07 0.94 11 11 406 406
  Freeable 180.63 0.00 0.86 2.33 34   210 210
  SQL 33.63 29.34 0.09 1.14 23 23 390 388
  PL/SQL 16.83 9.77 0.04 0.01 0 0 398 398

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 6,442,450,944  
Fixed Size 2,080,504  
Redo Buffers 14,696,448  
Variable Size 1,526,726,920  

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 304.00 304.00 0.00
large free memory 128.00 128.00 0.00
shared ASH buffers 15.50 15.50 0.00
shared CCursor 98.59 108.42 9.97
shared Cursor Stats 12.21 12.21 0.00
shared PCursor 64.26 71.61 11.42
shared db_block_hash_buckets 45.00 45.00 0.00
shared free memory 65.76 54.12 -17.70
shared library cache 82.03 85.32 4.02
shared private strands 13.84 13.84 0.00
shared sql area 495.30 488.03 -1.47
shared trace buffer 10.52 10.52 0.00
  buffer_cache 6,144.00 6,144.00 0.00
  fixed_sga 1.98 1.98 0.00
  log_buffer 14.02 14.02 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)
_addm_auto_enable FALSE   
_db_block_numa 1   
_enable_NUMA_optimization FALSE   
audit_file_dest /oracle/app/oracle/admin/orcl/adump   
background_dump_dest /oracle/app/oracle/admin/orcl/bdump   
compatible 10.2.0.5.0   
control_files /u01/orcl/control01.ctl, /u01/orcl/control02.ctl, /u01/orcl/control03.ctl   
core_dump_dest /oracle/app/oracle/admin/orcl/cdump   
db_block_size 8192   
db_cache_size 6442450944   
db_create_file_dest /u02/orcl   
db_domain      
db_file_multiblock_read_count 16   
db_name orcl   
java_pool_size 318767104   
job_queue_processes 20   
large_pool_size 134217728   
local_listener (ADDRESS=(PROTOCOL=tcp)(host=10.1.10.26)(port=1521))   
log_archive_dest_1 LOCATION=/u02/archive   
max_dump_file_size 1024   
max_shared_servers 0   
open_cursors 600   
parallel_max_servers 1   
pga_aggregate_target 3221225472   
processes 900   
query_rewrite_enabled FALSE   
remote_login_passwordfile EXCLUSIVE   
sga_target 0   
shared_pool_size 1073741824   
shared_servers 0   
statistics_level BASIC   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /oracle/app/oracle/admin/orcl/udump   


Back to Top

End of Report