WORKLOAD REPOSITORY report for

DB NameDB IdInstanceInst numReleaseRACHost
ORCL1303953018orcl110.2.0.4.0NOhisserver

Snap IdSnap TimeSessionsCursors/Session
Begin Snap:1382023-Sep-13 09:00:42336 3.1
End Snap:1382123-Sep-13 10:00:49403 3.3
Elapsed:  60.11 (mins)  
DB Time:  52.39 (mins)  

Report Summary

Cache Sizes

BeginEnd
Buffer Cache: 1,648M 1,552MStd Block Size: 8K
Shared Pool Size: 2,288M 2,384MLog Buffer: 14,340K

Load Profile

Per SecondPer Transaction
Redo size: 14,337.63 3,617.75
Logical reads: 16,041.00 4,047.55
Block changes: 89.44 22.57
Physical reads: 549.94 138.76
Physical writes: 5.25 1.32
User calls: 433.92 109.49
Parses: 116.56 29.41
Hard parses: 4.33 1.09
Sorts: 13.18 3.33
Logons: 0.46 0.12
Executes: 124.10 31.31
Transactions: 3.96 

% Blocks changed per Read: 0.56Recursive Call %: 19.16
Rollback per transaction %: 27.52Rows per Sort: 31.53

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00Redo NoWait %: 99.99
Buffer Hit %: 96.57In-memory Sort %: 100.00
Library Hit %: 96.68Soft Parse %: 96.29
Execute to Parse %: 6.08Latch Hit %: 99.96
Parse CPU to Parse Elapsd %: 3.93% Non-Parse CPU: 91.24

Shared Pool Statistics

BeginEnd
Memory Usage %: 78.20 83.91
% SQL with executions>1: 92.02 68.15
% Memory for SQL w/exec>1: 87.06 66.24

Top 5 Timed Events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
latch: library cache 7,355 798 109 25.4Concurrency
latch: shared pool 7,842 664 85 21.1Concurrency
CPU time  529  16.8 
db file sequential read 63,753 343 5 10.9User I/O
db file scattered read 127,206 257 2 8.2User I/O

Main Report


Back to Top

Wait Events Statistics

Back to Top

Time Model Statistics

Statistic NameTime (s)% of DB Time
parse time elapsed 1,148.45 36.54
sql execute elapsed time 1,026.22 32.65
hard parse elapsed time 581.90 18.51
DB CPU 528.57 16.82
connection management call elapsed time 68.43 2.18
PL/SQL execution elapsed time 60.32 1.92
PL/SQL compilation elapsed time 37.74 1.20
hard parse (sharing criteria) elapsed time 9.76 0.31
failed parse elapsed time 8.53 0.27
sequence load elapsed time 0.75 0.02
repeated bind elapsed time 0.04 0.00
hard parse (bind mismatch) elapsed time 0.03 0.00
DB time 3,143.10  
background elapsed time 638.72  
background cpu time 41.51  

Back to Wait Events Statistics
Back to Top

Wait Class

Wait ClassWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
Concurrency 15,309 0.14 1,466 96 1.07
User I/O 191,436 0.00 603 3 13.39
System I/O 28,693 0.00 282 10 2.01
Commit 10,598 0.08 203 19 0.74
Other 639,825 0.00 13 0 44.76
Network 1,735,519 0.00 9 0 121.42
Application 1,908 0.00 5 3 0.13
Configuration 7 0.00 1 153 0.00

Back to Wait Events Statistics
Back to Top

Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
latch: library cache 7,355 0.00 798 109 0.51
latch: shared pool 7,842 0.00 664 85 0.55
db file sequential read 63,753 0.00 343 5 4.46
db file scattered read 127,206 0.00 257 2 8.90
log file sync 10,598 0.08 203 19 0.74
log file parallel write 10,772 0.00 155 14 0.75
control file parallel write 3,581 0.00 113 31 0.25
control file sequential read 14,170 0.00 11 1 0.99
latch free 113 0.00 10 91 0.01
SQL*Net more data to client 157,087 0.00 5 0 10.99
enq: TX - row lock contention 4 0.00 5 1141 0.00
db file parallel read 146 0.00 4 25 0.01
latch: row cache objects 45 0.00 3 59 0.00
enq: CF - contention 9 0.00 2 249 0.00
ARCH wait on SENDREQ 62 0.00 2 35 0.00
log file sequential read 74 0.00 2 21 0.01
log file switch completion 6 0.00 1 175 0.00
SQL*Net message to client 1,569,644 0.00 1 0 109.81
os thread startup 6 0.00 1 149 0.00
SQL*Net more data from client 8,726 0.00 1 0 0.61
cursor: pin S 639,680 0.00 1 0 44.75
latch: cache buffers chains 22 0.00 0 19 0.00
Log archive I/O 88 0.00 0 5 0.01
SQL*Net break/reset to client 1,904 0.00 0 0 0.13
log file single write 8 0.00 0 31 0.00
cursor: pin S wait on X 22 100.00 0 11 0.00
cursor: mutex X 1 0.00 0 88 0.00
enq: TX - index contention 1 0.00 0 63 0.00
latch: redo allocation 2 0.00 0 15 0.00
latch: redo writing 1 0.00 0 17 0.00
wait list latch free 1 0.00 0 10 0.00
LGWR wait for redo copy 13 0.00 0 1 0.00
read by other session 1 0.00 0 3 0.00
latch: In memory undo latch 5 0.00 0 1 0.00
latch: library cache lock 3 0.00 0 1 0.00
latch: session allocation 2 0.00 0 1 0.00
latch: object queue header operation 2 0.00 0 1 0.00
direct path write 166 0.00 0 0 0.01
buffer busy waits 7 0.00 0 0 0.00
direct path read 164 0.00 0 0 0.01
rdbms ipc reply 2 0.00 0 0 0.00
latch: cache buffers lru chain 1 0.00 0 0 0.00
SQL*Net message from client 1,569,577 0.00 820,037 522 109.81
Streams AQ: waiting for time management or cleanup tasks 9 66.67 5,148 572041 0.00
jobq slave wait 1,213 95.14 3,541 2919 0.08
Streams AQ: qmn slave idle wait 130 0.00 3,529 27146 0.01
Streams AQ: qmn coordinator idle wait 260 50.00 3,529 13573 0.02
virtual circuit status 121 100.00 3,521 29099 0.01
SGA: MMAN sleep for component shrink 24 79.17 0 9 0.00
class slave wait 1 0.00 0 0 0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn
log file parallel write 10,772 0.00 155 14 0.75
control file parallel write 3,581 0.00 113 31 0.25
control file sequential read 13,503 0.00 11 1 0.94
latch: shared pool 49 0.00 9 191 0.00
latch: library cache 27 0.00 4 158 0.00
db file sequential read 463 0.00 3 6 0.03
events in waitclass Other 30 0.00 2 76 0.00
ARCH wait on SENDREQ 62 0.00 2 35 0.00
log file sequential read 74 0.00 2 21 0.01
os thread startup 6 0.00 1 149 0.00
db file scattered read 140 0.00 1 5 0.01
Log archive I/O 88 0.00 0 5 0.01
log file single write 8 0.00 0 31 0.00
latch: redo writing 1 0.00 0 17 0.00
direct path write 165 0.00 0 0 0.01
direct path read 164 0.00 0 0 0.01
buffer busy waits 1 0.00 0 0 0.00
rdbms ipc message 25,890 58.58 47,701 1842 1.81
Streams AQ: waiting for time management or cleanup tasks 9 66.67 5,148 572041 0.00
pmon timer 1,693 100.00 3,543 2093 0.12
Streams AQ: qmn slave idle wait 130 0.00 3,529 27146 0.01
Streams AQ: qmn coordinator idle wait 260 50.00 3,529 13573 0.02
smon timer 13 84.62 3,309 254535 0.00
SGA: MMAN sleep for component shrink 24 79.17 0 9 0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

StatisticTotal
BUSY_TIME 71,996
IDLE_TIME 2,836,915
IOWAIT_TIME 132,171
NICE_TIME 31
SYS_TIME 34,292
USER_TIME 35,301
LOAD 2
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 8,371,568,640
NUM_CPUS 8
NUM_CPU_SOCKETS 2

Back to Wait Events Statistics
Back to Top

Service Statistics

Service NameDB Time (s)DB CPU (s)Physical ReadsLogical Reads
orcl 2,636.50 430.80 1,937,310 52,043,061
SYS$USERS 498.60 97.60 44,038 5,783,951
SYS$BACKGROUND 0.00 0.00 2,029 25,831
orclXDB 0.00 0.00 0 0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Service NameUser I/O Total WtsUser I/O Wt TimeConcurcy Total WtsConcurcy Wt TimeAdmin Total WtsAdmin Wt TimeNetwork Total WtsNetwork Wt Time
orcl 178714 55049 12810 122959 0 0 1587969 618
SYS$USERS 11385 4739 2208 18269 0 0 140045 55
SYS$BACKGROUND 1326 548 88 1449 0 0 62 216

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
159 51 15 10.62 5.07 8h8zgt4mw44w8 infoqry.exe SELECT SUM (outp_bill_items.co...
81 21 4 20.20 2.57 98tvas0zdcq1a stockmgr.exe SELECT 'µ¥¾ÝÈë¿â' action_type,...
54 3 3,368 0.02 1.73 4yffxmsh6n03q doctws.exe BEGIN SYS.DBMS_DESCRIBE.DESCRI...
45 39 541 0.08 1.45 9hk2facr2ba94 doctws.exe SELECT "MR_ON_LINE"."PATIENT...
39 15 1 39.07 1.24 23vm3x08bwmx8 outpapp.exe SELECT "INVOICE_INFO"."RCPT...
25 24 1 25.33 0.81 c2aw4fq306q4k   INSERT /*+ APPEND */ INTO WRH$...
24 1 696 0.03 0.77 dzxr7ym0tkjrw nursws.exe SELECT "ORDERS_COSTS"."ITEM_NA...
16 16 927 0.02 0.51 gnp1u7yqu2skn presdisp.exe SELECT "DRUG_PRESC_MASTER_T...
15 0 1 15.25 0.49 7xtbnp59nxzbt orddisp.exe SELECT "ORDERS"."REPEAT_INDICA...
15 0 1 14.92 0.47 43u3dkn1ytdzx doctws.exe SELECT "PAT_VISIT"."PATIENT...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

CPU Time (s)Elapsed Time (s)Executions CPU per Exec (s)% Total DB Time SQL IdSQL ModuleSQL Text
51 159 15 3.43 5.07 8h8zgt4mw44w8 infoqry.exe SELECT SUM (outp_bill_items.co...
39 45 541 0.07 1.45 9hk2facr2ba94 doctws.exe SELECT "MR_ON_LINE"."PATIENT...
24 25 1 24.16 0.81 c2aw4fq306q4k   INSERT /*+ APPEND */ INTO WRH$...
21 81 4 5.18 2.57 98tvas0zdcq1a stockmgr.exe SELECT 'µ¥¾ÝÈë¿â' action_type,...
16 16 927 0.02 0.51 gnp1u7yqu2skn presdisp.exe SELECT "DRUG_PRESC_MASTER_T...
15 39 1 14.53 1.24 23vm3x08bwmx8 outpapp.exe SELECT "INVOICE_INFO"."RCPT...
6 10 778 0.01 0.31 f2833fsz8gkct odoctor.exe SELECT "CLINIC_MASTER"."NAM...
6 6 9 0.64 0.19 fuj5yvndztbgb XHLisServiceA.exe SELECT pats_in_hospital.patie...
6 6 10 0.55 0.18 6y7zabg9dd4b1 XHLisServiceA.exe SELECT pats_in_hospital.patie...
5 5 9 0.56 0.16 1761d7s6zm057 XHLisServiceA.exe SELECT pats_in_hospital.patie...
3 54 3,368 0.00 1.73 4yffxmsh6n03q doctws.exe BEGIN SYS.DBMS_DESCRIBE.DESCRI...

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
6,367,716 927 6,869.17 11.01 15.80 16.04 gnp1u7yqu2skn presdisp.exe SELECT "DRUG_PRESC_MASTER_T...
3,588,452 10 358,845.20 6.20 5.52 5.66 6y7zabg9dd4b1 XHLisServiceA.exe SELECT pats_in_hospital.patie...
3,229,614 9 358,846.00 5.58 5.04 5.12 1761d7s6zm057 XHLisServiceA.exe SELECT pats_in_hospital.patie...
3,229,413 9 358,823.67 5.58 5.72 6.12 fuj5yvndztbgb XHLisServiceA.exe SELECT pats_in_hospital.patie...
2,870,713 8 358,839.13 4.96 4.45 4.56 g5tzdvbc7cy4z XHLisServiceA.exe SELECT pats_in_hospital.patie...
2,511,663 7 358,809.00 4.34 3.77 3.77 gk2gr6mr59mct XHLisServiceA.exe SELECT pats_in_hospital.patie...
2,511,625 7 358,803.57 4.34 3.92 3.93 2rkp3b0v001wj XHLisServiceA.exe SELECT pats_in_hospital.patie...
2,152,838 6 358,806.33 3.72 3.37 3.39 8gu44f7gj99nz XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,794,010 5 358,802.00 3.10 2.93 2.93 09uzsuu1ndjgu XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,435,403 4 358,850.75 2.48 2.26 2.26 5k2x2nzfu9z4j XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,435,366 4 358,841.50 2.48 2.19 2.21 f0rafhx0gx5mu XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,435,358 4 358,839.50 2.48 2.28 2.29 gpjpp9dpw6fat XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,435,337 4 358,834.25 2.48 2.20 2.20 btrua8nk7zv2c XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,435,244 4 358,811.00 2.48 2.15 2.16 6amh56nxa6n0c XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,158,420 15 77,228.00 2.00 51.40 159.27 8h8zgt4mw44w8 infoqry.exe SELECT SUM (outp_bill_items.co...
1,076,539 3 358,846.33 1.86 1.79 1.79 g6npbj93qprkw XHLisServiceA.exe SELECT pats_in_hospital.patie...
1,062,560 541 1,964.07 1.84 39.15 45.44 9hk2facr2ba94 doctws.exe SELECT "MR_ON_LINE"."PATIENT...
786,588 995 790.54 1.36 3.97 7.69 fubr4x8z5w0t5 nursws.exe SELECT "DOCTOR_ORDERS"."ENT...
761,873 4 190,468.25 1.32 20.72 80.80 98tvas0zdcq1a stockmgr.exe SELECT 'µ¥¾ÝÈë¿â' action_type,...

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
1,083,289 15 72,219.27 54.62 51.40 159.27 8h8zgt4mw44w8 infoqry.exe SELECT SUM (outp_bill_items.co...
489,744 4 122,436.00 24.69 20.72 80.80 98tvas0zdcq1a stockmgr.exe SELECT 'µ¥¾ÝÈë¿â' action_type,...
118,087 1 118,087.00 5.95 2.61 7.87 a8ftqvnxrf7m0 stockmgr.exe SELECT receiver, package_spec,...
70,469 2 35,234.50 3.55 2.66 12.96 13djyagwwyv85 C:\Documents and Settings\dyyy\×ÀÃæ\×ۺϲéѯ.lnk SELECT "OUTP_RCPT_MASTER"."R...
66,965 1 66,965.00 3.38 14.53 39.07 23vm3x08bwmx8 outpapp.exe SELECT "INVOICE_INFO"."RCPT...
55,985 11 5,089.55 2.82 3.48 13.59 c595u73hjzub2 autodisp.exe SELECT DISTINCT "PHARMACY"."...
24,683 2 12,341.50 1.24 1.78 2.93 4axnn4g4t5gwa pb60.exe select * FROM clinic_master wh...
3,398 1 3,398.00 0.17 0.52 9.32 31vjvvsrcna56 JDBC Thin Client select * from ip_orderdetl_vie...
2,441 696 3.51 0.12 1.30 24.11 dzxr7ym0tkjrw nursws.exe SELECT "ORDERS_COSTS"."ITEM_NA...
1,021 67 15.24 0.05 0.25 6.65 7g496d56ma0a0 doctws.exe SELECT "INP_BILL_DETAIL"."I...

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
33,990 33,831 1.00 0.00 0.00 4pwnt0hgg2ghr doctws.exe select administration_code fro...
33,000 6,937 0.21 0.00 0.00 g2tcdkz3sy3h2 doctws.exe Select bed_label From bed_rec ...
32,996 6,937 0.21 0.00 0.00 664crkjw8n47y doctws.exe select dept_code , ward_code ...
29,624 3,565 0.12 0.00 0.00 c69f5n7vyas9s doctws.exe Select bed_no , diagnosis , ...
19,739 19,739 1.00 0.00 0.00 f0wzs9nc663bn sjcj.exe select sysdate from dual
10,584 10,560 1.00 0.00 0.00 4srur5p7sxdu3 doctws.exe select user_name from comm.use...
9,094 14,693 1.62 0.00 0.00 0h6b2sajwb74n   select privilege#, level from ...
5,092 5,047 0.99 0.00 0.00 5h8hkpq3q5g41 doctws.exe SELECT TOPIC , ITEM_CLASS , ...
4,499 4,499 1.00 0.00 0.00 1g8brz25xjs3j examapt.exe SELECT CHARGE_TYPE, INSURANCE...
4,495 4,489 1.00 0.00 0.00 0t691q1kmy9w8 XHLisServiceS.exe UPDATE PATS_IN_HOSPITAL SET TO...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Parse CallsExecutions % Total Parses SQL IdSQL ModuleSQL Text
33,990 33,990 8.09 4pwnt0hgg2ghr doctws.exe select administration_code fro...
33,184 33,000 7.89 g2tcdkz3sy3h2 doctws.exe Select bed_label From bed_rec ...
33,180 32,996 7.89 664crkjw8n47y doctws.exe select dept_code , ward_code ...
29,808 29,624 7.09 c69f5n7vyas9s doctws.exe Select bed_no , diagnosis , ...
19,741 19,739 4.70 f0wzs9nc663bn sjcj.exe select sysdate from dual
10,687 10,584 2.54 4srur5p7sxdu3 doctws.exe select user_name from comm.use...
9,093 9,094 2.16 0h6b2sajwb74n   select privilege#, level from ...
5,220 5,092 1.24 5h8hkpq3q5g41 doctws.exe SELECT TOPIC , ITEM_CLASS , ...
4,047 4,047 0.96 a7w35qskd8cs0 ibilling.exe SELECT MIN ( CLASS_ON_INP_RCPT...
3,798 4,499 0.90 1g8brz25xjs3j examapt.exe SELECT CHARGE_TYPE, INSURANCE...

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
33 778 fccybqqpg4xdj outpapp.exe INSERT INTO "OUTP_BILL_ITEMS" ...
25 2,093 9mrhw217pc809 doctws.exe select MR_CODE , mr_attr , m...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL IdSQL Text
09uzsuu1ndjguSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0306' or pats_in_hospital.ward_code = '0306' )
0h6b2sajwb74nselect privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0t691q1kmy9w8UPDATE PATS_IN_HOSPITAL SET TOTAL_COSTS=DECODE(TOTAL_COSTS, NULL, 0, TOTAL_COSTS)+:B2 , TOTAL_CHARGES=DECODE(TOTAL_CHARGES, NULL, 0, TOTAL_CHARGES)+:B1 WHERE PATIENT_ID=:B4 AND VISIT_ID=:B3
13djyagwwyv85 SELECT "OUTP_RCPT_MASTER"."RCPT_NO", "OUTP_RCPT_MASTER"."NAME", "OUTP_RCPT_MASTER"."PATIENT_ID", "OUTP_RCPT_MASTER"."IDENTITY", "OUTP_ORDER_DESC"."ORDERED_BY_DEPT", "OUTP_ORDER_DESC"."ORDERED_BY_DOCTOR", "OUTP_BILL_ITEMS"."PERFORMED_BY", "OUTP_BILL_ITEMS"."ITEM_CLASS", "OUTP_BILL_ITEMS"."ITEM_NAME", "OUTP_BILL_ITEMS"."COSTS", "OUTP_BILL_ITEMS"."CHARGES", "OUTP_RCPT_MASTER"."VISIT_DATE" FROM "OUTP_BILL_ITEMS", "OUTP_RCPT_MASTER", "OUTP_ORDER_DESC" WHERE ( "OUTP_BILL_ITEMS"."RCPT_NO" = "OUTP_RCPT_MASTER"."RCPT_NO" ) and ( "OUTP_RCPT_MASTER"."RCPT_NO" = "OUTP_ORDER_DESC"."RCPT_NO" ) and ( ( "OUTP_BILL_ITEMS"."VISIT_DATE" between :s and :e ) )
1761d7s6zm057SELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0302' or pats_in_hospital.ward_code = '0302' )
1g8brz25xjs3jSELECT CHARGE_TYPE, INSURANCE_TYPE FROM PAT_VISIT WHERE PATIENT_ID = :B2 AND VISIT_ID = :B1
23vm3x08bwmx8 SELECT "INVOICE_INFO"."RCPT_TYPE" , "INVOICE_INFO"."RCPT_NO" , "INVOICE_INFO"."INVOICE_COSTS" , "INVOICE_INFO"."INVOICE_STATUS" , "OUTP_RCPT_MASTER"."PATIENT_ID" , "OUTP_RCPT_MASTER"."NAME" , "OUTP_RCPT_MASTER"."VISIT_DATE" , "OUTP_RCPT_MASTER"."TOTAL_COSTS" , "OUTP_RCPT_MASTER"."TOTAL_CHARGES" , "OUTP_RCPT_MASTER"."OPERATOR_NO" , "INVOICE_INFO"."INVOICE_NO" FROM "OUTP_RCPT_MASTER" , "INVOICE_INFO" WHERE ( "OUTP_RCPT_MASTER"."RCPT_NO" = "INVOICE_INFO"."RCPT_NO" ) and ( ( "INVOICE_INFO"."DISK_NO" = :v_disk_no ) and ( "INVOICE_INFO"."RCPT_TYPE" = :v_rcpt_type ) and ( "OUTP_RCPT_MASTER"."CHARGE_INDICATOR" = 2 ) and ( "INVOICE_INFO"."INVOICE_STATUS" = '00' ) and ( "OUTP_RCPT_MASTER"."TOTAL_COSTS" > 0 ) )
2rkp3b0v001wjSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0401' or pats_in_hospital.ward_code = '0401' )
31vjvvsrcna56select * from ip_orderdetl_view where cfxh='020902_20130923093643' and patid='H2424'
43u3dkn1ytdzx SELECT "PAT_VISIT"."PATIENT_ID" , "PAT_VISIT"."VISIT_ID" , "PAT_VISIT"."DOCTOR_IN_CHARGE" , "PAT_VISIT"."ADMISSION_DATE_TIME" , "PAT_VISIT"."DISCHARGE_DATE_TIME" , "PAT_VISIT"."DEPT_DISCHARGE_FROM" FROM "PAT_VISIT" where pat_visit.doctor_in_charge = 'ÕŽ¨¾ü' And to_char(pat_visit.discharge_date_time, 'yyyy-mm-dd') >= '2013-04-01' And to_char(pat_visit.discharge_date_time, 'yyyy-mm-dd') <= '2013-07-01'
4axnn4g4t5gwaselect * FROM clinic_master where name like'%•×%'
4pwnt0hgg2ghrselect administration_code from administration_dict where administration_name =:1
4srur5p7sxdu3select user_name from comm.users where DB_USER =:1
4yffxmsh6n03qBEGIN SYS.DBMS_DESCRIBE.DESCRIBE_PROCEDURE(:object_name, :res1, :res2, :overload, :position, :level, :argument, :datatype, :default, :in_out, :length, :precision, :scale, :radix, :spare); END;
5h8hkpq3q5g41SELECT TOPIC , ITEM_CLASS , CODING_SCHM , to_char ( outer_code_length ) , to_char ( text_length ) , to_char ( std_code_length ) , to_char ( last_updt_date_time , 'YYYY-MM-DD' ) , to_char ( last_updt_date_time , 'HH24:MI:SS' ) FROM outer_coding_config WHERE upper ( dict_file_name ) =:1
5k2x2nzfu9z4jSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0409' or pats_in_hospital.ward_code = '0409' )
664crkjw8n47yselect dept_code , ward_code from pats_in_hospital where patient_id =:1 and visit_id =:2
6amh56nxa6n0cSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0420' or pats_in_hospital.ward_code = '0420' )
6y7zabg9dd4b1SELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '040607' or pats_in_hospital.ward_code = '040607' )
7g496d56ma0a0 SELECT "INP_BILL_DETAIL"."ITEM_CLASS" , "INP_BILL_DETAIL"."ITEM_NAME" , "INP_BILL_DETAIL"."ITEM_SPEC" , "INP_BILL_DETAIL"."AMOUNT" , "INP_BILL_DETAIL"."UNITS" , "INP_BILL_DETAIL"."CHARGES" , "INP_BILL_DETAIL"."COSTS" FROM "INP_BILL_DETAIL" WHERE ( patient_id = :pat_id ) and ( visit_id = :vis_id )
7xtbnp59nxzbt SELECT "ORDERS"."REPEAT_INDICATOR", "PAT_MASTER_INDEX"."NAME", "PAT_MASTER_INDEX"."SEX", "PATS_IN_HOSPITAL"."BED_NO", "ORDERS"."ORDER_TEXT", "ORDERS"."DOSAGE", "ORDERS"."DOSAGE_UNITS", "ORDERS"."ADMINISTRATION", "ORDERS"."FREQUENCY", "ORDERS"."START_DATE_TIME", "ORDERS"."STOP_DATE_TIME", "ORDERS"."FREQ_COUNTER", "ORDERS"."FREQ_INTERVAL", "ORDERS"."FREQ_INTERVAL_UNIT", "ORDERS"."PATIENT_ID", "ORDERS"."VISIT_ID", "ORDERS"."ORDER_NO", "ORDERS"."ORDER_SUB_NO", "ORDERS"."ORDER_CODE", "ORDERS"."ORDERING_DEPT", "ORDERS"."ORDER_STATUS", "PATS_IN_HOSPITAL"."DEPT_CODE", "ORDERS"."LAST_PERFORM_DATE_TIME", "PAT_MASTER_INDEX"."CHARGE_TYPE", "ORDERS"."PERFORM_SCHEDULE", ' ' drug_name, ' ' drug_code, ' ' drug_spec, 0 drug_amount, ' ' drug_units, ' ' drug_firm_id, ' ' error_text, "ORDERS"."LAST_PERFORM_DATE_TIME" perform_date_time, SYSDATE, 0 manage_stock_flag, "PATS_IN_HOSPITAL"."PREPAYMENTS" - "PATS_IN_HOSPITAL"."TOTAL_CHARGES" spare_prepayments, "PRE_DISCHGED_PATS"."DISCHARGE_DATE_EXPCTED" FROM "ORDERS", "PAT_MASTER_INDEX", (SELECT drug_code, dispensing_property FROM "DRUG_DISPENS_PROPERTY" WHERE "DRUG_DISPENS_PROPERTY"."DISPENSARY" = '020902') dispensary_class, "PATS_IN_HOSPITAL", "PRE_DISCHGED_PATS" WHERE ("PATS_IN_HOSPITAL"."PATIENT_ID" = "PAT_MASTER_INDEX"."PATIENT_ID") AND ("PATS_IN_HOSPITAL"."PATIENT_ID" = "ORDERS"."PATIENT_ID") AND ("PATS_IN_HOSPITAL"."VISIT_ID" = "ORDERS"."VISIT_ID") AND ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "PRE_DISCHGED_PATS"."PATIENT_ID" (+) ) AND ("ORDERS"."ORDER_CODE" = dispensary_class.drug_code (+)) AND ("PATS_IN_HOSPITAL"."WARD_CODE" = 'H2301') AND ( ("PATS_IN_HOSPITAL"."BED_NO" in (1, 2, 3, 4, 7, 8, 9, 10, 12, 13, 14, 16, 17, 18, 19, 20, 21, 22, 23, 27, 28, 30, 32, 33, 47, 50))) AND ( "PATS_IN_HOSPITAL"."SETTLED_INDICATOR" IS NULL OR "PATS_IN_HOSPITAL"."SETTLED_INDICATOR" = 0 ) AND ("ORDERS"."ORDER_CLASS" = 'A') AND ( "ORDERS"."DRUG_BILLING_ATTR" = 0 OR "ORDERS"."DRUG_BILLING_ATTR" IS NULL ) AND ( (dispensary_class.dispensing_property = '×¢ÉäÀà') OR ('×¢ÉäÀà'='[È«²¿]') OR ( dispensary_class."DISPENSING_PROPERTY" IS NULL AND "ORDERS"."ADMINISTRATION" IN ('¾²µÎ', '¾²ÍÆ', '¾²µÎ*', 'С¶ù¾²µÎ', 'ƤÄÚ×¢Éä', 'ƤÏÂ×¢Éä', 'ƤÊÔ', '¼¡Èâ×¢Éä', '¾²´©', 'ÌåÍâÑ­»·', 'ÐØÇ»×¢Éä', '¸¹Ç»×¢Éä', '¾ÖÂé', 'Ѩλ· â±Õ') ) ) AND ("ORDERS"."REPEAT_INDICATOR" IN (0, 0)) AND ( "ORDERS"."ORDER_STATUS" = '2' OR "ORDERS"."ORDER_STATUS" = '3') AND ( ( "ORDERS"."REPEAT_INDICATOR" = 0 AND "ORDERS"."LAST_PERFORM_DATE_TIME" IS NULL ) OR ("ORDERS"."REPEAT_INDICATOR" = 1) ) AND ( "ORDERS"."LAST_PERFORM_DATE_TIME" IS NULL OR ( "ORDERS"."LAST_PERFORM_DATE_TIME" < TO_DATE('24-Sep-2013 08:00:00', 'DD-MON-YYYY HH24:MI:SS') AND ( ( "ORDERS"."STOP_DATE_TIME" IS NOT NULL AND "ORDERS"."LAST_PERFORM_DATE_TIME" < "ORDERS"."STOP_DATE_TIME" ) OR "ORDERS"."STOP_DATE_TIME" IS NULL ) ) ) AND ( "ORDERS"."STOP_DATE_TIME" IS NULL OR ( "ORDERS"."STOP_DATE_TIME" >= TO_DATE('22-Sep-2013 17:30:00', 'DD-MON-YYYY HH24:MI:SS') AND "ORDERS"."START_DATE_TIME" < TO_DATE('24-Sep-2013 08:00:00', 'DD-MON-YYYY HH24:MI:SS') ) ) ORDER BY "PATS_IN_HOSPITAL"."BED_NO" ASC, "ORDERS"."REPEAT_INDICATOR" ASC, "ORDERS"."ADMINISTRATION" ASC, "ORDERS"."START_DATE_TIME" ASC, "ORDERS"."ORDER_NO" ASC, "ORDERS"."ORDER_SUB_NO" ASC
8gu44f7gj99nzSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0304' or pats_in_hospital.ward_code = '0304' )
8h8zgt4mw44w8SELECT SUM (outp_bill_items.costs) costs, SUM (outp_bill_items.charges) payments, 0 mark, item_class class FROM outp_bill_items, outp_rcpt_master WHERE (outp_rcpt_master.visit_date >= :start_day) AND (outp_rcpt_master.visit_date < :end_day) AND (outp_rcpt_master.rcpt_no = outp_bill_items.rcpt_no) AND charge_indicator=0 GROUP BY item_class
98tvas0zdcq1a SELECT 'µ¥¾ÝÈë¿â' action_type, drug_import_master.document_no document_no, import_date action_date, import_class action_class, supplier linker, firm_id, quantity, quantity*purchase_price amount, operator, '' name, '' patient_id FROM drug_import_master, drug_import_detail WHERE drug_import_master.document_no = drug_import_detail.document_no AND storage = :ls_storage AND account_indicator = 1 AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND import_date >= :ldt_start AND import_date <= :ldt_stop UNION ALL SELECT 'µ¥¾Ý³ö¿â', drug_export_master.document_no, export_date, export_class, receiver, firm_id, quantity, quantity*purchase_price, operator, '' name, '' patient_id FROM drug_export_master, drug_export_detail WHERE drug_export_master.document_no = drug_export_detail.document_no AND storage = :ls_storage AND account_indicator = 1 AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND export_date >= :ldt_start AND export_date <= :ldt_stop UNION ALL SELECT '´¦·½³ö¿â', to_char(drug_presc_master.presc_no), drug_presc_master.presc_date, presc_attr, dept_name, firm_id, quantity, drug_presc_detail.costs, dispensing_provider, name, patient_id FROM drug_presc_master, drug_presc_detail, dept_dict WHERE drug_presc_master.presc_no = drug_presc_detail.presc_no AND drug_presc_master.presc_date = drug_presc_detail.presc_date AND ordered_by = dept_code AND dispensary = :ls_storage AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND drug_presc_master.presc_date >= :ldt_start AND drug_presc_master.presc_date <= :ldt_stop UNION ALL SELECT '°ÚÒ©³ö¿â', '', dispensing_date_time, '', dept_name, firm_id, dispense_amount, costs, dispensing_provider, name, drug_dispense_rec.patient_id FROM drug_dispense_rec, dept_dict, pat_master_index WHERE ordered_by = dept_code AND drug_dispense_rec.patient_id = pat_master_index.patient_id AND dispensary = :ls_storage AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND dispensing_date_time >= :ldt_start AND dispensing_date_time <= :ldt_stop
9hk2facr2ba94 SELECT "MR_ON_LINE"."PATIENT_ID", "MR_ON_LINE"."VISIT_ID", "MR_ON_LINE"."STATUS", "MR_ON_LINE"."REQUEST_DOCTOR_ID", "MR_ON_LINE"."REQUEST_DATE_TIME", "PAT_MASTER_INDEX"."NAME", "PAT_MASTER_INDEX"."NAME_PHONETIC", "PAT_MASTER_INDEX"."DATE_OF_BIRTH" , "PAT_MASTER_INDEX"."SEX" , "PAT_VISIT"."CHARGE_TYPE", '', '', 0, "MR_ON_LINE"."PARENT_DOCTOR_ID", "MR_ON_LINE"."SUPER_DOCTOR_ID" FROM "PAT_MASTER_INDEX" , "PAT_VISIT", "PATS_IN_HOSPITAL", "MR_ON_LINE" WHERE ( "PAT_MASTER_INDEX"."PATIENT_ID" = "MR_ON_LINE"."PATIENT_ID") and (( "MR_ON_LINE"."REQUEST_DOCTOR_ID" = :doctor) OR ( "MR_ON_LINE"."PARENT_DOCTOR_ID" = :doctor) OR ( "MR_ON_LINE"."SUPER_DOCTOR_ID" = :doctor)) AND ( "MR_ON_LINE"."STATUS" = :status) and ( "PAT_VISIT"."PATIENT_ID" = "MR_ON_LINE"."PATIENT_ID" ) and ( "PAT_VISIT"."VISIT_ID" = "MR_ON_LINE"."VISIT_ID" ) and ( "PATS_IN_HOSPITAL"."VISIT_ID" = "MR_ON_LINE"."VISIT_ID") and ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "MR_ON_LINE"."PATIENT_ID") and ( "PATS_IN_HOSPITAL"."DEPT_CODE" = :wardcode) UNION SELECT "MR_ON_LINE"."PATIENT_ID", "MR_ON_LINE"."VISIT_ID", "MR_ON_LINE"."STATUS", "MR_ON_LIN E"."REQUEST_DOCTOR_ID", "MR_ON_LINE"."REQUEST_DATE_TIME", "PAT_MASTER_INDEX"."NAME", "PAT_MASTER_INDEX"."NAME_PHONETIC", "PAT_MASTER_INDEX"."DATE_OF_BIRTH" , "PAT_MASTER_INDEX"."SEX" , "PAT_VISIT"."CHARGE_TYPE" , '', '', 0, "MR_ON_LINE"."PARENT_DOCTOR_ID", "MR_ON_LINE"."SUPER_DOCTOR_ID" FROM "PAT_MASTER_INDEX" , "PAT_VISIT", "ADT_LOG", "MR_ON_LINE" WHERE ( "PAT_MASTER_INDEX"."PATIENT_ID" = "MR_ON_LINE"."PATIENT_ID") and (( "MR_ON_LINE"."REQUEST_DOCTOR_ID" = :doctor) OR ( "MR_ON_LINE"."PARENT_DOCTOR_ID" = :doctor) OR ( "MR_ON_LINE"."SUPER_DOCTOR_ID" = :doctor)) AND ( "MR_ON_LINE"."STATUS" = :status) and ( "PAT_VISIT"."PATIENT_ID" = "MR_ON_LINE"."PATIENT_ID" ) and ( "PAT_VISIT"."VISIT_ID" = "MR_ON_LINE"."VISIT_ID" ) and ( "ADT_LOG"."PATIENT_ID" = "MR_ON_LINE"."PATIENT_ID" ) and ( "ADT_LOG"."VISIT_ID" = "MR_ON_LINE"."VISIT_ID" ) and ((( "ADT_LOG"."ACTION" = 'F' ) and ( "ADT_LOG"."DEPT_CODE" = :wardcode)) OR (( "ADT_LOG"."ACTION" = 'E' ) and ( "ADT_LOG"."DEPT_CODE" = :wardcode)) or (( "ADT_LOG"."ACTION" = 'G' ) and ( "ADT_LOG"."DEPT_CODE" = :wardcode)) OR (( "ADT_LOG"."ACTION" = 'H' ) and ( "ADT_LOG"."DEPT_CODE" = :wardcode)))
9mrhw217pc809select MR_CODE , mr_attr , mr_class from mr_item_index where mr_name =:1 ORDER BY mr_attr desc
a7w35qskd8cs0SELECT MIN ( CLASS_ON_INP_RCPT ) FROM PRICE_LIST WHERE ITEM_CLASS =:1 AND ITEM_CODE =:2
a8ftqvnxrf7m0 SELECT receiver, package_spec, package_units, firm_id, sum(quantity) quantity, sum(purchase_price*quantity) amount FROM drug_export_detail, drug_export_master WHERE drug_export_detail.document_no = drug_export_master.document_no AND account_indicator = 1 AND storage = :ls_storage AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND export_date >= :ldt_start AND export_date <= :ldt_stop GROUP BY receiver, package_spec, package_units, firm_id UNION ALL SELECT dept_name, drug_spec, drug_units, firm_id, sum(dispense_amount), sum(costs) FROM drug_dispense_rec, dept_dict WHERE ordered_by = dept_code(+) AND dispensary = :ls_storage AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND dispensing_date_time >= :ldt_start AND dispensing_date_time <= :ldt_stop GROUP BY dept_name, drug_spec, drug_units, firm_id UNION ALL SELECT dept_name, package_spec, package_units, firm_id, sum(quantity), sum(drug_presc_detail.costs) FROM drug_presc_detail, drug_presc_master, dept_dict WHERE drug_presc_detail.presc_no = drug_presc_master.presc_no AND drug_presc_detail.presc_date = drug_presc_master.presc_date AND ordered_by = dept_code(+) AND dispensary = :ls_storage AND drug_code = :ls_drugcode AND drug_spec = :ls_drugspec AND drug_presc_master.presc_date >= :ldt_start AND drug_presc_master.presc_date <= :ldt_stop GROUP BY dept_name, package_spec, package_units, firm_id
btrua8nk7zv2cSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0419' or pats_in_hospital.ward_code = '0419' )
c2aw4fq306q4k INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
c595u73hjzub2 SELECT DISTINCT "PHARMACY"."PRESCRIPTION"."PRESCRIPTIONNO", "PHARMACY"."PRESCRIPTION"."SEQNO", "PHARMACY"."PRESCRIPTION"."GROUP_NO", "PHARMACY"."PRESCRIPTION"."MACHINENO", "PHARMACY"."PRESCRIPTION"."PROCFLG", "PHARMACY"."PRESCRIPTION"."PATIENTID", "PHARMACY"."PRESCRIPTION"."PATIENTNAME", "PHARMACY"."PRESCRIPTION"."ENGLISHNAME", "PHARMACY"."PRESCRIPTION"."BIRTHDAY", "PHARMACY"."PRESCRIPTION"."SEX", "PHARMACY"."PRESCRIPTION"."IOFLG", "PHARMACY"."PRESCRIPTION"."WARDCD", "PHARMACY"."PRESCRIPTION"."WARDNAME", "PHARMACY"."PRESCRIPTION"."ROOMNO", "PHARMACY"."PRESCRIPTION"."BEDNO", "PHARMACY"."PRESCRIPTION"."DOCTORCD", "PHARMACY"."PRESCRIPTION"."DOCTORNAME", "PHARMACY"."PRESCRIPTION"."PRESCRIPTIONDATE", "PHARMACY"."PRESCRIPTION"."TAKEDATE", "PHARMACY"."PRESCRIPTION"."TAKETIME", "PHARMACY"."PRESCRIPTION"."LASTTIME", "PHARMACY"."PRESCRIPTION"."PRESC_CLASS", "PHARMACY"."PRESCRIPTION"."DRUGCD", "PHARMACY"."PRESCRIPTION"."DRUGNAME", "PHARMACY"."PRESCRIPTION"."DRUGSHAPE", "PHARMACY"."PRESCRIPTION"."PRESCRIPTIONDOSE", "PHARMACY"."PRESCRIPTION"."PRESCRIPTIONUNIT", "PHARMACY"."PRESCRIPTION"."DISPENSEDDOSE", "PHARMACY"."PRESCRIPTION"."DISPENSEDTOTALDOSE", "PHARMACY"."PRESCRIPTION"."DISPENSEDUNIT", "PHARMACY"."PRESCRIPTION"."AMOUNT_PER_PACKAGE", "PHARMACY"."PRESCRIPTION"."FIRM_ID", "PHARMACY"."PRESCRIPTION"."DISPENSE_DAYS", "PHARMACY"."PRESCRIPTION"."FREQ_DESC_CODE", "PHARMACY"."PRESCRIPTION"."FREQ_DESC", "PHARMACY"."PRESCRIPTION"."FREQ_COUNTER", "PHARMACY"."PRESCRIPTION"."FREQ_DESC_DETAIL_CODE", "PHARMACY"."PRESCRIPTION"."FREQ_DESC_DETAIL", "PHARMACY"."PRESCRIPTION"."EXPLANATION_CODE", "PHARMACY"."PRESCRIPTION"."EXPLANATION", "PHARMACY"."PRESCRIPTION"."ADMINISTRATION_NAME", "PHARMACY"."PRESCRIPTION"."DOCTORCOMMENT", "PHARMACY"."PRESCRIPTION"."MAKERECTIME", "PHARMACY"."PRESCRIPTION"."UPDATERECTIME", "PHARMACY"."PRESCRIPTION"."FILLER", "PHARMACY"."PRESCRIPTION"."BAGORDERBY", "PHARMACY"."PRESCRIPTION"."ORDER_NO", "PHARMACY"."PRESCRIPTION"."ORDER_SUB_NO", "PHARMACY"."PRESCRIPTION"."TROCHE_DATA_DATE_TIME", "PHARMACY"."PRESCRIPTION"."TROCHE_DATA_OPERATOR" FROM "PHARMACY"."PRESCRIPTION" WHERE ( PHARMACY."PRESCRIPTION"."PRESCRIPTIONDATE" >= :start_date ) AND ( PHARMACY."PRESCRIPTION"."PRESCRIPTIONDATE" <= :end_date ) AND ( "PHARMACY"."PRESCRIPTION"."TROCHE_DATA_DA TE_TIME" is NULL) AND ( "PHARMACY"."PRESCRIPTION"."TROCHE_DATA_OPERATOR" is NULL ) AND ( ( "PHARMACY"."PRESCRIPTION"."DRUGCD", "PHARMACY"."PRESCRIPTION"."AMOUNT_PER_PACKAGE", "PHARMACY"."PRESCRIPTION"."PRESCRIPTIONUNIT") in ( select troche_dict.drug_code, drug_dict.dose_per_unit, drug_dict.dose_units from troche_dict, drug_dict where troche_dict.drug_code = drug_dict.drug_code and troche_dict.drug_spec = drug_dict.drug_spec ) )
c69f5n7vyas9sSelect bed_no , diagnosis , patient_condition From pats_in_hospital Where Patient_id =:1 And Visit_id =:2
dzxr7ym0tkjrwSELECT "ORDERS_COSTS"."ITEM_NAME", "ORDERS_COSTS"."AMOUNT", "ORDERS_COSTS"."UNITS", "ORDERS_COSTS"."ITEM_CODE", "ORDERS_COSTS"."ITEM_CLASS", "ORDERS_COSTS"."ITEM_NO", "ORDERS_COSTS"."ORDER_SUB_NO", "ORDERS_COSTS"."ORDER_NO", "ORDERS_COSTS"."VISIT_ID", "ORDERS_COSTS"."PATIENT_ID", "ORDERS_COSTS"."COSTS", "ORDERS_COSTS"."ITEM_SPEC" FROM "ORDERS_COSTS" WHERE (PATIENT_ID = :p_id ) AND (VISIT_ID = :v_id )
f0rafhx0gx5muSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0414' or pats_in_hospital.ward_code = '0414' )
f0wzs9nc663bnselect sysdate from dual
f2833fsz8gkct SELECT "CLINIC_MASTER"."NAME" , "CLINIC_MASTER"."PATIENT_ID" , "CLINIC_MASTER"."VISIT_NO" , "CLINIC_MASTER"."VISIT_DATE" , "CLINIC_MASTER"."VISIT_TIME_DESC" , "CLINIC_MASTER"."SERIAL_NO" , "CLINIC_MASTER"."SEX" , "CLINIC_MASTER"."AGE" , "CLINIC_MASTER"."IDENTITY" , "CLINIC_MASTER"."CHARGE_TYPE" , "CLINIC_MASTER"."CLINIC_TYPE" , "CLINIC_MASTER"."VISIT_DEPT" , "CLINIC_MASTER"."VISIT_SPECIAL_CLINIC" , "CLINIC_MASTER"."CLINIC_FEE" , "CLINIC_MASTER"."OPERATOR" , "CLINIC_MASTER"."RETURNED_DATE" , "CLINIC_MASTER"."RETURNED_OPERATOR" , "CLINIC_MASTER"."REGISTRATION_STATUS" , "CLINIC_MASTER"."OUTP_ID" , "CLINIC_MASTER"."NAME_PHONETIC" , "CLINIC_MASTER"."UNIT_IN_CONTRACT" , "CLINIC_MASTER"."REGISTERING_DATE" , "CLINIC_MASTER"."DIAGCODE" , "CLINIC_MASTER"."PAY_WAY" , "CLINIC_MASTER"."CLINIC_LABEL" , "CLINIC_MASTER"."INSURANCE_TYPE" , "CLINIC_MASTER"."INSURANCE_NO" , "CLINIC_MASTER"."FIRST_VISIT_INDICATOR" , "CLINIC_MASTER"."DOCTOR" , "CLINIC_MASTER"."MR_PROVIDE_INDICATOR" , "CLINIC_MASTER"."SYMPTOM" , "CLINIC_MASTER"."REGIST_FEE" , "CLINIC_MASTER"."OTHER_FEE" , "CLINIC_MASTER"."CLINIC_CHARGE" , "CLINIC_MASTER"."DOCT_ REGIST_FEE" , "CLINIC_MASTER"."DOCT_CLINIC_FEE" , "CLINIC_MASTER"."DOCT_OTHER_FEE" , "CLINIC_MASTER"."DOCT_CLINIC_CHARGE" , "CLINIC_MASTER"."CALL_FLAG" FROM "CLINIC_MASTER" WHERE ( "CLINIC_MASTER"."VISIT_DATE" >= :dd ) and ( "CLINIC_MASTER"."VISIT_DEPT" = :dept ) and ( "CLINIC_MASTER"."RETURNED_DATE" is null )
fccybqqpg4xdjINSERT INTO "OUTP_BILL_ITEMS" ( "VISIT_DATE", "VISIT_NO", "RCPT_NO", "ITEM_NO", "ITEM_CLASS", "CLASS_ON_RCPT", "ITEM_CODE", "ITEM_NAME", "ITEM_SPEC", "AMOUNT", "UNITS", "PERFORMED_BY", "COSTS", "CHARGES" ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14 )
fubr4x8z5w0t5 SELECT "DOCTOR_ORDERS"."ENTER_DATE_TIME" , "PAT_MASTER_INDEX"."NAME" , "PATS_IN_HOSPITAL"."BED_NO" , "DOCTOR_ORDERS"."ORDER_TEXT" , "DOCTOR_ORDERS"."DOSAGE" , "DOCTOR_ORDERS"."DOSAGE_UNITS" , "DOCTOR_ORDERS"."ADMINISTRATION" , "DOCTOR_ORDERS"."FREQUENCY" , "DOCTOR_ORDERS"."DOCTOR" , "DOCTOR_ORDERS"."NURSE" , "DOCTOR_ORDERS"."DURATION" , "DOCTOR_ORDERS"."DURATION_UNITS" , "DOCTOR_ORDERS"."FREQ_DETAIL" , "DOCTOR_ORDERS"."ORDER_NO" , "DOCTOR_ORDERS"."ORDER_SUB_NO" , "DOCTOR_ORDERS"."ORDER_STATUS" , "DOCTOR_ORDERS"."PATIENT_ID" , "DOCTOR_ORDERS"."VISIT_ID" , "DOCTOR_ORDERS"."ORDER_CLASS" , "DOCTOR_ORDERS"."REPEAT_INDICATOR" , "DOCTOR_ORDERS"."START_STOP_INDICATOR" , "DOCTOR_ORDERS"."FREQ_INTERVAL" , "DOCTOR_ORDERS"."FREQ_INTERVAL_UNIT" , "DOCTOR_ORDERS"."ORDERING_DEPT" , "DOCTOR_ORDERS"."ORDER_PRINT_INDICATOR" , "DOCTOR_ORDERS"."RELATED_ORDER_NO" , "DOCTOR_ORDERS"."RELATED_ORDER_SUB_NO" , "DOCTOR_ORDERS"."ORDER_CODE" , "DOCTOR_ORDERS"."PROCESSING_DATE_TIME" , "DOCTOR_ORDERS"."BILLING_ATTR" , "PAT_MASTER_INDEX"."NAME_PHONETIC" , "DOCTOR_ORDERS"."START_DATE_TIME" , "DOCTOR_ORDERS"."DRUG_BILLING_ATTR" , "DOCTOR_ORDERS"."FRE Q_COUNTER" , "BED_REC"."BED_LABEL" FROM "DOCTOR_ORDERS" , "PAT_MASTER_INDEX" , "PATS_IN_HOSPITAL" , "BED_REC" WHERE ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "PAT_MASTER_INDEX"."PATIENT_ID" ) and ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "DOCTOR_ORDERS"."PATIENT_ID" ) and ( "PATS_IN_HOSPITAL"."VISIT_ID" = "DOCTOR_ORDERS"."VISIT_ID" ) and ( "PATS_IN_HOSPITAL"."WARD_CODE" = "BED_REC"."WARD_CODE" ) and ( "PATS_IN_HOSPITAL"."BED_NO" = "BED_REC"."BED_NO" ) and ( "PATS_IN_HOSPITAL"."WARD_CODE" = :wardcode ) AND "DOCTOR_ORDERS"."ORDER_STATUS"='1'
fuj5yvndztbgbSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0415' or pats_in_hospital.ward_code = '0415' )
g2tcdkz3sy3h2Select bed_label From bed_rec Where ward_code =:1 And bed_no =:2
g5tzdvbc7cy4zSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0408' or pats_in_hospital.ward_code = '0408' )
g6npbj93qprkwSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0303' or pats_in_hospital.ward_code = '0303' )
gk2gr6mr59mctSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '0403' or pats_in_hospital.ward_code = '0403' )
gnp1u7yqu2skn SELECT "DRUG_PRESC_MASTER_TEMP"."PRESC_NO" , "DRUG_PRESC_MASTER_TEMP"."NAME" , "DRUG_PRESC_MASTER_TEMP"."NAME_PHONETIC" , "DRUG_PRESC_MASTER_TEMP"."PRESC_DATE" , "DRUG_PRESC_MASTER_TEMP"."PAYMENTS" , "DRUG_PRESC_MASTER_TEMP"."PATIENT_ID" FROM "DRUG_PRESC_MASTER_TEMP" WHERE ( drug_PRESC_MASTER_TEMP.PRESC_DATE <= :day1) and ( "DRUG_PRESC_MASTER_TEMP"."DISPENSARY" = :disp )
gpjpp9dpw6fatSELECT pats_in_hospital.patient_id, pats_in_hospital.visit_id , '', pat_master_index.name, pat_master_index.sex, trunc((sysdate-pat_master_index.date_of_birth)/365), '', '', '', pats_in_hospital.dept_code, pats_in_hospital.ward_code, lpad(pats_in_hospital.bed_no, 2, '0'), '', '', '', pats_in_hospital.diagnosis, '', '', pats_in_hospital.ROWID, pat_master_index.ROWID FROM pats_in_hospital , pat_master_index WHERE ( pats_in_hospital.patient_id = pat_master_index.patient_id ) and ( pats_in_hospital.dept_code = '040608' or pats_in_hospital.ward_code = '040608' )

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Back to Top

Instance Activity Stats

StatisticTotalper Secondper Trans
CPU used by this session 47,158 13.07 3.30
CPU used when call started 44,241 12.27 3.10
CR blocks created 4,742 1.31 0.33
Cached Commit SCN referenced 0 0.00 0.00
Commit SCN cached 0 0.00 0.00
DB time 688,127 190.79 48.14
DBWR checkpoint buffers written 16,810 4.66 1.18
DBWR checkpoints 4 0.00 0.00
DBWR object drop buffers written 0 0.00 0.00
DBWR tablespace checkpoint buffers written 0 0.00 0.00
DBWR thread checkpoint buffers written 0 0.00 0.00
DBWR transaction table writes 130 0.04 0.01
DBWR undo block writes 2,621 0.73 0.18
IMU CR rollbacks 403 0.11 0.03
IMU Flushes 2,395 0.66 0.17
IMU Redo allocation size 21,471,444 5,953.15 1,502.13
IMU commits 8,368 2.32 0.59
IMU contention 58 0.02 0.00
IMU ktichg flush 0 0.00 0.00
IMU pool not allocated 6 0.00 0.00
IMU recursive-transaction flush 36 0.01 0.00
IMU undo allocation size 60,244,784 16,703.40 4,214.69
IMU- failed to get a private strand 6 0.00 0.00
Misses for writing mapping 0 0.00 0.00
SMON posted for undo segment recovery 0 0.00 0.00
SMON posted for undo segment shrink 1 0.00 0.00
SQL*Net roundtrips to/from client 1,565,069 433.93 109.49
active txn count during cleanout 6,581 1.82 0.46
application wait time 491 0.14 0.03
background checkpoints completed 4 0.00 0.00
background checkpoints started 4 0.00 0.00
background timeouts 15,248 4.23 1.07
branch node splits 0 0.00 0.00
buffer is not pinned count 10,463,181 2,901.01 732.00
buffer is pinned count 133,493,578 37,012.27 9,339.13
bytes received via SQL*Net from client 201,631,372 55,904.08 14,106.01
bytes sent via SQL*Net to client 483,361,564 134,016.27 33,815.70
calls to get snapshot scn: kcmgss 552,258 153.12 38.64
calls to kcmgas 24,139 6.69 1.69
calls to kcmgcs 1,803 0.50 0.13
change write time 322 0.09 0.02
cleanout - number of ktugct calls 6,060 1.68 0.42
cleanouts and rollbacks - consistent read gets 4,653 1.29 0.33
cleanouts only - consistent read gets 176 0.05 0.01
cluster key scan block gets 12,359 3.43 0.86
cluster key scans 3,675 1.02 0.26
commit batch performed 0 0.00 0.00
commit batch requested 0 0.00 0.00
commit batch/immediate performed 392 0.11 0.03
commit batch/immediate requested 392 0.11 0.03
commit cleanout failures: block lost 0 0.00 0.00
commit cleanout failures: buffer being written 0 0.00 0.00
commit cleanout failures: callback failure 118 0.03 0.01
commit cleanout failures: cannot pin 34 0.01 0.00
commit cleanouts 47,261 13.10 3.31
commit cleanouts successfully completed 47,109 13.06 3.30
commit immediate performed 392 0.11 0.03
commit immediate requested 392 0.11 0.03
commit txn count during cleanout 2,482 0.69 0.17
concurrency wait time 142,945 39.63 10.00
consistent changes 38,714 10.73 2.71
consistent gets 57,492,408 15,940.28 4,022.14
consistent gets - examination 37,775,273 10,473.53 2,642.74
consistent gets direct 1 0.00 0.00
consistent gets from cache 57,492,407 15,940.28 4,022.14
current blocks converted for CR 0 0.00 0.00
cursor authentications 2,861 0.79 0.20
data blocks consistent reads - undo records applied 38,375 10.64 2.68
db block changes 322,599 89.44 22.57
db block gets 363,263 100.72 25.41
db block gets direct 10 0.00 0.00
db block gets from cache 363,253 100.72 25.41
deferred (CURRENT) block cleanout applications 25,437 7.05 1.78
dirty buffers inspected 1,292 0.36 0.09
enqueue conversions 1,934 0.54 0.14
enqueue releases 90,731 25.16 6.35
enqueue requests 90,737 25.16 6.35
enqueue timeouts 1 0.00 0.00
enqueue waits 11 0.00 0.00
exchange deadlocks 0 0.00 0.00
execute count 447,596 124.10 31.31
failed probes on index block reclamation 0 0.00 0.00
frame signature mismatch 0 0.00 0.00
free buffer inspected 2,031,395 563.22 142.12
free buffer requested 1,993,297 552.66 139.45
heap block compress 3,306 0.92 0.23
hot buffers moved to head of LRU 306,166 84.89 21.42
immediate (CR) block cleanout applications 4,829 1.34 0.34
immediate (CURRENT) block cleanout applications 3,543 0.98 0.25
index crx upgrade (positioned) 11,069 3.07 0.77
index fast full scans (full) 195 0.05 0.01
index fetch by key 36,769,268 10,194.60 2,572.36
index scans kdiixs1 353,369 97.97 24.72
leaf node 90-10 splits 46 0.01 0.00
leaf node splits 310 0.09 0.02
lob reads 12 0.00 0.00
lob writes 109 0.03 0.01
lob writes unaligned 109 0.03 0.01
logons cumulative 1,659 0.46 0.12
messages received 24,572 6.81 1.72
messages sent 24,572 6.81 1.72
no buffer to keep pinned count 0 0.00 0.00
no work - consistent read gets 19,568,973 5,425.67 1,369.03
opened cursors cumulative 71,836 19.92 5.03
parse count (failures) 355 0.10 0.02
parse count (hard) 15,610 4.33 1.09
parse count (total) 420,397 116.56 29.41
parse time cpu 4,628 1.28 0.32
parse time elapsed 117,854 32.68 8.24
physical read IO requests 191,917 53.21 13.43
physical read bytes 16,248,823,808 4,505,130.07 1,136,758.35
physical read total IO requests 206,259 57.19 14.43
physical read total bytes 16,592,158,208 4,600,322.57 1,160,777.82
physical read total multi block requests 127,322 35.30 8.91
physical reads 1,983,499 549.94 138.76
physical reads cache 1,983,334 549.90 138.75
physical reads cache prefetch 1,792,167 496.89 125.38
physical reads direct 165 0.05 0.01
physical reads direct (lob) 0 0.00 0.00
physical reads direct temporary tablespace 0 0.00 0.00
physical reads prefetch warmup 0 0.00 0.00
physical write IO requests 15,003 4.16 1.05
physical write bytes 155,066,368 42,993.52 10,848.35
physical write total IO requests 36,657 10.16 2.56
physical write total bytes 441,993,216 122,546.53 30,921.59
physical write total multi block requests 11,741 3.26 0.82
physical writes 18,929 5.25 1.32
physical writes direct 174 0.05 0.01
physical writes direct (lob) 1 0.00 0.00
physical writes direct temporary tablespace 0 0.00 0.00
physical writes from cache 18,755 5.20 1.31
physical writes non checkpoint 9,010 2.50 0.63
pinned buffers inspected 4 0.00 0.00
prefetch warmup blocks aged out before use 0 0.00 0.00
prefetched blocks aged out before use 0 0.00 0.00
process last non-idle time 3,637 1.01 0.25
recursive aborts on index block reclamation 0 0.00 0.00
recursive calls 370,968 102.85 25.95
recursive cpu usage 4,536 1.26 0.32
redo blocks written 110,481 30.63 7.73
redo buffer allocation retries 8 0.00 0.00
redo entries 125,473 34.79 8.78
redo log space requests 8 0.00 0.00
redo log space wait time 106 0.03 0.01
redo ordering marks 1,957 0.54 0.14
redo size 51,712,088 14,337.63 3,617.75
redo subscn max counts 4,491 1.25 0.31
redo synch time 21,089 5.85 1.48
redo synch writes 10,650 2.95 0.75
redo wastage 2,814,020 780.21 196.87
redo write time 16,020 4.44 1.12
redo writer latching time 0 0.00 0.00
redo writes 10,777 2.99 0.75
rollback changes - undo records applied 2,864 0.79 0.20
rollbacks only - consistent read gets 89 0.02 0.01
rows fetched via callback 410,468 113.81 28.72
session connect time 0 0.00 0.00
session cursor cache hits 294,167 81.56 20.58
session logical reads 57,855,671 16,041.00 4,047.55
session pga memory 165,378,544 45,852.66 11,569.79
session pga memory max 636,245,712 176,404.75 44,511.38
session uga memory ############### 75,042,017.05 18,935,000.31
session uga memory max 871,560,472 241,647.85 60,973.87
shared hash latch upgrades - no wait 25,582 7.09 1.79
shared hash latch upgrades - wait 0 0.00 0.00
sorts (memory) 47,532 13.18 3.33
sorts (rows) 1,498,700 415.53 104.85
sql area evicted 5,227 1.45 0.37
sql area purged 357 0.10 0.02
summed dirty queue length 2,148 0.60 0.15
switch current to new buffer 2,237 0.62 0.16
table fetch by rowid 35,673,724 9,890.86 2,495.71
table fetch continued row 17,405 4.83 1.22
table scan blocks gotten 5,321,682 1,475.48 372.30
table scan rows gotten 478,864,878 132,769.52 33,501.11
table scans (direct read) 0 0.00 0.00
table scans (long tables) 52 0.01 0.00
table scans (short tables) 44,699 12.39 3.13
total number of times SMON posted 2 0.00 0.00
transaction rollbacks 392 0.11 0.03
transaction tables consistent read rollbacks 0 0.00 0.00
transaction tables consistent reads - undo records applied 0 0.00 0.00
undo change vector size 17,335,828 4,806.51 1,212.80
user I/O wait time 60,385 16.74 4.22
user calls 1,565,049 433.92 109.49
user commits 10,361 2.87 0.72
user rollbacks 3,933 1.09 0.28
workarea executions - onepass 0 0.00 0.00
workarea executions - optimal 31,693 8.79 2.22
write clones created in background 0 0.00 0.00
write clones created in foreground 10 0.00 0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

StatisticBegin ValueEnd Value
session cursor cache count 1,691,156 1,704,942
opened cursors current 1,051 1,334
logons current 336 403

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

StatisticTotalper Hour
log switches (derived) 4 3.99

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)
TSP_OUTPBILL 86,336 24 2.45 14.43 2,155 1 0 0.00
TSP_PHARMACY 60,944 17 1.61 10.12 1,148 0 1 0.00
TSP_INPBILL 7,751 2 6.59 1.01 2,366 1 1 10.00
TSP_OUTPADM 8,307 2 3.28 3.86 1,130 0 0 0.00
USERS 8,210 2 2.06 6.88 603 0 0 0.00
TSP_ORDADM 6,143 2 10.32 1.00 2,340 1 0 0.00
TSP_MEDREC 5,967 2 9.81 1.23 1,307 0 0 0.00
TSP_CPR 1,060 0 10.72 1.07 831 0 3 0.00
TSP_INSURANCE 1,078 0 9.18 1.62 487 0 0 0.00
TSP_LAB 1,017 0 7.46 1.00 492 0 0 0.00
TSP_EXAM 768 0 11.42 1.00 579 0 0 0.00
SYSTEM 1,158 0 8.32 1.77 144 0 0 0.00
SYSAUX 621 0 6.18 1.08 413 0 0 0.00
TSP_MATERIAL 641 0 9.95 3.11 214 0 0 0.00
TSP_COMM 744 0 16.26 1.09 6 0 0 0.00
TSP_INPADM 500 0 8.40 1.01 189 0 0 0.00
UNDOTBS1 16 0 25.00 1.00 393 0 3 0.00
TSP_MEDADM 259 0 2.63 1.00 22 0 0 0.00
TSP_CARD 146 0 13.15 1.00 83 0 0 0.00
TSP_SURGERY 26 0 10.38 1.54 16 0 0 0.00
TSP_INFO 7 0 8.57 1.00 4 0 0 0.00
TSP_BLDBANK 6 0 5.00 1.00 4 0 0 0.00
TSP_ACCT 4 0 2.50 1.00 4 0 0 0.00
TSP_ASSESS 4 0 7.50 1.00 4 0 0 0.00
TSP_ASSET 4 0 2.50 1.00 4 0 0 0.00
TSP_BACK 4 0 5.00 1.00 4 0 0 0.00
TSP_BADZK 4 0 2.50 1.00 4 0 0 0.00
TSP_ECONSTAT 4 0 7.50 1.00 4 0 0 0.00
TSP_EQUIPMENT 4 0 0.00 1.00 4 0 0 0.00
TSP_HACCOUNT 4 0 2.50 1.00 4 0 0 0.00
TSP_HATEMP 4 0 2.50 1.00 4 0 0 0.00
TSP_HISACCOUNT 4 0 0.00 1.00 4 0 0 0.00
TSP_INFECTION 4 0 7.50 1.00 4 0 0 0.00
TSP_INSURANCE_SUM 4 0 7.50 1.00 4 0 0 0.00
TSP_JS 4 0 7.50 1.00 4 0 0 0.00
TSP_KQMZGL 4 0 0.00 1.00 4 0 0 0.00
TSP_TUMOUR 4 0 7.50 1.00 4 0 0 0.00
TSP_YZYLS 4 0 5.00 1.00 4 0 0 0.00
TSP_ZLBR 4 0 0.00 1.00 4 0 0 0.00
XC 4 0 5.00 1.00 4 0 0 0.00
Z2002_DATA 4 0 2.50 1.00 4 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)
SYSAUX /u02/oradata/orcl/sysaux01.dbf 621 0 6.18 1.08 413 0 0 0.00
SYSTEM /u02/oradata/orcl/system01.dbf 1,158 0 8.32 1.77 144 0 0 0.00
TSP_ACCT /u02/oradata/orcl/APACCT.DBF 4 0 2.50 1.00 4 0 0 0.00
TSP_ASSESS /u02/oradata/orcl/APASSESS.DBF 4 0 7.50 1.00 4 0 0 0.00
TSP_ASSET /u02/oradata/orcl/ASSET.DBF 4 0 2.50 1.00 4 0 0 0.00
TSP_BACK /u02/oradata/orcl/APBACK.DBF 4 0 5.00 1.00 4 0 0 0.00
TSP_BADZK /u02/oradata/orcl/APBADZK.DBF 4 0 2.50 1.00 4 0 0 0.00
TSP_BLDBANK /u02/oradata/orcl/APBLDBANK.DBF 6 0 5.00 1.00 4 0 0 0.00
TSP_CARD /u02/oradata/orcl/APCARD.DBF 146 0 13.15 1.00 83 0 0 0.00
TSP_COMM /u02/oradata/orcl/APCOMM.DBF 744 0 16.26 1.09 6 0 0 0.00
TSP_CPR /u02/oradata/orcl/APCPR.DBF 1,060 0 10.72 1.07 831 0 3 0.00
TSP_ECONSTAT /u02/oradata/orcl/APECONSTAT.DBF 4 0 7.50 1.00 4 0 0 0.00
TSP_EQUIPMENT /u02/oradata/orcl/APEQUIPMENT.DBF 4 0 0.00 1.00 4 0 0 0.00
TSP_EXAM /u02/oradata/orcl/APEXAM.DBF 768 0 11.42 1.00 579 0 0 0.00
TSP_HACCOUNT /u02/oradata/orcl/HACCOUNT.ORA 4 0 2.50 1.00 4 0 0 0.00
TSP_HATEMP /u02/oradata/orcl/HATEMP.ORA 4 0 2.50 1.00 4 0 0 0.00
TSP_HISACCOUNT /u02/oradata/orcl/HISACCOUNT.DBF 4 0 0.00 1.00 4 0 0 0.00
TSP_INFECTION /u02/oradata/ORCLINFECTION.DBF 4 0 7.50 1.00 4 0 0 0.00
TSP_INFO /u02/oradata/orcl/APINFO.DBF 7 0 8.57 1.00 4 0 0 0.00
TSP_INPADM /u02/oradata/orcl/APINPADM.DBF 500 0 8.40 1.01 189 0 0 0.00
TSP_INPBILL /u02/oradata/orcl/APINPBILL.DBF 7,751 2 6.59 1.01 2,366 1 1 10.00
TSP_INSURANCE /u02/oradata/orcl/APINSURANCE.DBF 1,078 0 9.18 1.62 487 0 0 0.00
TSP_INSURANCE_SUM /u02/oradata/orcl/datafile/O1_MF_TSP_INSU_75H7Z9VT_. 4 0 7.50 1.00 4 0 0 0.00
TSP_JS /u02/oradata/orcl/JS.DBF 4 0 7.50 1.00 4 0 0 0.00
TSP_KQMZGL /u02/oradata/orcl/APKQMZGL.DBF 4 0 0.00 1.00 4 0 0 0.00
TSP_LAB /u02/oradata/orcl/APLAB.DBF 1,017 0 7.46 1.00 492 0 0 0.00
TSP_MATERIAL /u02/oradata/orcl/APMATERIAL.DBF 641 0 9.95 3.11 214 0 0 0.00
TSP_MEDADM /u02/oradata/orcl/APMEDADM.DBF 259 0 2.63 1.00 22 0 0 0.00
TSP_MEDREC /u02/oradata/orcl/APMEDREC.DBF 5,967 2 9.81 1.23 1,307 0 0 0.00
TSP_ORDADM /u02/oradata/orcl/APORDADM.DBF 6,143 2 10.32 1.00 2,340 1 0 0.00
TSP_OUTPADM /u02/oradata/orcl/APOUTPADM.DBF 8,307 2 3.28 3.86 1,130 0 0 0.00
TSP_OUTPBILL /u02/oradata/orcl/APOUTPBILL.DBF 86,336 24 2.45 14.43 2,155 1 0 0.00
TSP_PHARMACY /u02/oradata/orcl/APPHARMACY.DBF 60,944 17 1.61 10.12 1,148 0 1 0.00
TSP_SURGERY /u02/oradata/orcl/APSURGERY.DBF 26 0 10.38 1.54 16 0 0 0.00
TSP_TUMOUR /u02/oradata/orcl/APTUMOUR.DBF 4 0 7.50 1.00 4 0 0 0.00
TSP_YZYLS /u02/oradata/orcl/APYZYLS.DBF 4 0 5.00 1.00 4 0 0 0.00
TSP_ZLBR /u02/oradata/orcl/APZLBR.DBF 4 0 0.00 1.00 4 0 0 0.00
UNDOTBS1 /u02/oradata/orcl/undotbs01.dbf 16 0 25.00 1.00 393 0 3 0.00
USERS /u02/oradata/orcl/users01.dbf 8,210 2 2.06 6.88 603 0 0 0.00
XC /u02/oradata/orcl/XC.DBF 4 0 5.00 1.00 4 0 0 0.00
Z2002_DATA /u02/oradata/orcl/DATA01.DBF 4 0 2.50 1.00 4 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 189,907 97 57,849,848 1,983,282 18,755 0 0 8


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 11 1238 6453 33202 184320 33202  
E 0 12 1997 12563 65882 184320 65882  

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

PSize for Est (M)Size FactorBuffers for EstimateEst Phys Read FactorEstimated Physical Reads
D 144 0.09 17,811 1.79 426,571,307
D 288 0.19 35,622 1.65 393,333,532
D 432 0.28 53,433 1.51 359,388,601
D 576 0.37 71,244 1.35 323,430,406
D 720 0.46 89,055 1.23 293,915,562
D 864 0.56 106,866 1.14 273,329,063
D 1,008 0.65 124,677 1.08 258,988,345
D 1,152 0.74 142,488 1.04 249,332,108
D 1,296 0.84 160,299 1.02 243,065,086
D 1,440 0.93 178,110 1.00 239,434,143
D 1,552 1.00 191,963 1.00 238,778,673
D 1,584 1.02 195,921 1.00 238,591,044
D 1,728 1.11 213,732 1.00 237,904,641
D 1,872 1.21 231,543 0.99 237,313,189
D 2,016 1.30 249,354 0.99 236,797,555
D 2,160 1.39 267,165 0.99 236,322,825
D 2,304 1.48 284,976 0.99 235,864,632
D 2,448 1.58 302,787 0.99 235,408,646
D 2,592 1.67 320,598 0.98 234,912,815
D 2,736 1.76 338,409 0.98 234,235,595
D 2,880 1.86 356,220 0.98 233,043,422

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA Cache Hit %W/A MB ProcessedExtra W/A MB Read/Written
100.00 5,401 0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

PGA Aggr Target(M)Auto PGA Target(M)PGA Mem Alloc(M) W/A PGA Used(M) %PGA W/A Mem%Auto W/A Mem%Man W/A MemGlobal Mem Bound(K)
B 1,000 706 590.89 0.00 0.00 0.00 0.00 102,400
E 1,000 663 697.76 0.00 0.00 0.00 0.00 102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Low Optimal High OptimalTotal ExecsOptimal Execs1-Pass ExecsM-Pass Execs
2K 4K 27,035 27,035 0 0
64K 128K 60 60 0 0
128K 256K 175 175 0 0
256K 512K 6 6 0 0
512K 1024K 1,851 1,851 0 0
1M 2M 2,561 2,561 0 0
2M 4M 2 2 0 0

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

PGA Target Est (MB)Size FactrW/A MB ProcessedEstd Extra W/A MB Read/ Written to Disk Estd PGA Cache Hit %Estd PGA Overalloc Count
125 0.13 407,385.04 40,415.78 91.00 4,890
250 0.25 407,385.04 10,993.57 97.00 1,885
500 0.50 407,385.04 648.79 100.00 0
750 0.75 407,385.04 648.79 100.00 0
1,000 1.00 407,385.04 648.79 100.00 0
1,200 1.20 407,385.04 0.00 100.00 0
1,400 1.40 407,385.04 0.00 100.00 0
1,600 1.60 407,385.04 0.00 100.00 0
1,800 1.80 407,385.04 0.00 100.00 0
2,000 2.00 407,385.04 0.00 100.00 0
3,000 3.00 407,385.04 0.00 100.00 0
4,000 4.00 407,385.04 0.00 100.00 0
6,000 6.00 407,385.04 0.00 100.00 0
8,000 8.00 407,385.04 0.00 100.00 0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

Shared Pool Size(M)SP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
944 0.40 276 36,003 1,406,012 0.84 297,524 11.57 83,698,719
1,184 0.50 505 45,250 1,484,735 0.88 218,801 8.51 83,814,167
1,424 0.60 742 54,735 1,552,296 0.93 151,240 5.88 83,908,487
1,664 0.70 981 66,935 1,601,396 0.95 102,140 3.97 83,981,051
1,904 0.80 1,220 80,523 1,636,879 0.98 66,657 2.59 84,038,014
2,144 0.90 1,459 95,213 1,661,449 0.99 42,087 1.64 84,081,866
2,384 1.00 1,698 109,780 1,677,814 1.00 25,722 1.00 84,116,109
2,624 1.10 1,937 124,794 1,688,562 1.01 14,974 0.58 84,143,576
2,864 1.20 2,176 138,261 1,695,742 1.01 7,794 0.30 84,166,520
3,104 1.30 2,415 154,233 1,700,762 1.01 2,774 0.11 84,186,434
3,344 1.40 2,654 168,008 1,704,535 1.02 1 0.00 84,204,392
3,584 1.50 2,893 180,560 1,707,673 1.02 1 0.00 84,221,079
3,824 1.60 3,132 194,627 1,710,593 1.02 1 0.00 84,237,008
4,064 1.70 3,371 207,775 1,713,546 1.02 1 0.00 84,252,424
4,304 1.81 3,610 219,756 1,716,638 1.02 1 0.00 84,267,446
4,544 1.91 3,849 232,496 1,719,855 1.03 1 0.00 84,282,183
4,784 2.01 4,088 245,077 1,723,117 1.03 1 0.00 84,296,654

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)SGA Size FactorEst DB Time (s)Est Physical Reads
2,000 0.50 561,355 259,193,999
3,000 0.75 326,333 243,267,477
4,000 1.00 238,722 238,778,442
5,000 1.25 212,582 237,489,038
6,000 1.50 202,055 233,214,904
7,000 1.75 199,287 233,214,904
8,000 2.00 199,287 233,214,904

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

Java Pool Size(M)JP Size FactrEst LC Size (M)Est LC Mem ObjEst LC Time Saved (s)Est LC Time Saved FactrEst LC Load Time (s)Est LC Load Time FactrEst LC Mem Obj Hits
16 0.50 6 103 2 1.00 25,725 1.00 103
32 1.00 6 103 2 1.00 25,725 1.00 103
48 1.50 6 103 2 1.00 25,725 1.00 103
64 2.00 6 103 2 1.00 25,725 1.00 103

Back to Advisory Statistics
Back to Top

Wait Statistics

Back to Top

Buffer Wait Statistics

ClassWaitsTotal Wait Time (s)Avg Time (ms)
data block 5 0 2
undo block 2 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) 4 4 0 4 5 1,165.00
CF-Controlfile Transaction 4,560 4,559 1 6 2 381.67
TX-Transaction (index contention) 48 48 0 1 0 70.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 3.01 16,968 1,987 6 15/48.1333333333333333333333333333333333333 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
23-Sep 10:03 563 3,153 0 6 15 0/0 0/0/0/0/0/0
23-Sep 09:53 488 2,556 0 6 15 0/0 0/0/0/0/0/0
23-Sep 09:43 597 3,340 1,987 5 48 0/0 0/0/0/0/0/0
23-Sep 09:33 265 1,633 1,386 4 38 0/0 0/0/0/0/0/0
23-Sep 09:23 328 2,055 785 3 28 0/0 0/0/0/0/0/0
23-Sep 09:13 407 2,128 0 4 15 0/0 0/0/0/0/0/0
23-Sep 09:03 365 2,103 0 4 15 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,385 0.00   0 0  
AWR Alerted Metric Element list 42,561 0.00   0 0  
Consistent RBA 10,776 0.00   0 0  
FAL request queue 100 0.00   0 0  
FAL subheap alocation 96 0.00   0 0  
FIB s.o chain latch 46 0.00   0 0  
FOB s.o list latch 2,489 0.04 0.00 0 0  
In memory undo latch 100,810 0.01 0.71 0 12,099 0.00
JS mem alloc latch 7 0.00   0 0  
JS queue access latch 7 0.00   0 0  
JS queue state obj latch 26,242 0.00   0 0  
JS slv state obj latch 22 0.00   0 0  
KMG MMAN ready and startup request latch 1,233 0.00   0 0  
KMG resize request state object freelist 2 0.00   0 0  
KTF sga latch 6 0.00   0 1,156 0.00
KWQMN job cache list latch 20 0.00   0 0  
MQL Tracking Latch 0     0 72 0.00
Memory Management Latch 44 0.00   0 1,233 0.00
OS process 4,623 0.00   0 0  
OS process allocation 4,359 0.02 0.00 0 0  
OS process: request allocation 3,124 0.06 0.00 0 0  
PL/SQL warning settings 8,449 0.00   0 0  
SGA IO buffer pool latch 4 0.00   0 4 0.00
SQL memory manager latch 1 0.00   0 1,191 0.00
SQL memory manager workarea list latch 93,442 0.00   0 0  
Shared B-Tree 130 0.00   0 0  
active checkpoint queue latch 18,534 0.01 0.00 0 0  
active service list 12,831 0.02 0.00 0 1,693 0.00
archive control 208 0.00   0 0  
archive process latch 1,371 0.07 1.00 0 0  
begin backup scn array 2 0.00   0 0  
buffer pool 7 0.00   0 0  
cache buffer handles 11,600 0.00   0 0  
cache buffers chains 80,908,112 0.03 0.00 0 4,048,149 0.00
cache buffers lru chain 54,890 0.07 0.03 0 4,298,461 0.01
cache table scan latch 0     0 127,205 0.00
channel handle pool latch 3,126 0.06 0.00 0 0  
channel operations parent latch 21,567 0.00   0 0  
checkpoint queue latch 166,705 0.00 0.00 0 30,077 0.00
client/application info 10,969 0.00   0 0  
commit callback allocation 16 0.00   0 0  
compile environment latch 1,658 0.00   0 0  
dml lock allocation 43,961 0.00 0.00 0 0  
dummy allocation 3,250 0.03 0.00 0 0  
enqueue hash chains 183,361 0.00 0.00 0 209 0.00
enqueues 132,507 0.02 0.15 0 0  
event group latch 1,595 0.00   0 0  
file cache latch 343 0.00   0 0  
global KZLD latch for mem in SGA 1,595 0.00   0 0  
hash table column usage latch 406 0.00   0 647,835 0.00
hash table modification latch 101 0.00   0 0  
job workq parent latch 0     0 126 0.00
job_queue_processes parameter latch 124 0.00   0 0  
kks stats 62,715 0.06 0.35 0 0  
kokc descriptor allocation latch 38 0.00   0 0  
ksuosstats global area 244 0.00   0 0  
ktm global data 15 0.00   0 0  
kwqbsn:qsga 130 0.00   0 0  
lgwr LWN SCN 10,848 0.02 0.00 0 0  
library cache 2,101,977 0.43 0.81 798 34,532 7.32
library cache load lock 638 0.00   0 0  
library cache lock 1,917,438 0.00 0.04 0 0  
library cache lock allocation 15,459 0.00   0 0  
library cache pin 331,995 0.00 0.00 0 0  
library cache pin allocation 7,991 0.00   0 0  
list of block allocation 1,968 0.00   0 0  
loader state object freelist 56 0.00   0 0  
longop free list parent 13 0.00   0 13 0.00
message pool operations parent latch 2 0.00   0 0  
messages 92,327 0.01 0.00 0 0  
mostly latch-free SCN 10,815 0.00   0 0  
multiblock read objects 275,646 0.00   0 0  
ncodef allocation latch 80 0.00   0 0  
object queue header heap 19,323 0.00   0 1,224 0.00
object queue header operation 4,054,441 0.00 0.67 0 11,714 0.00
object stats modification 3 0.00   0 0  
parallel query alloc buffer 476 0.00   0 0  
parameter list 6,997 0.00   0 0  
parameter table allocation management 1,596 0.13 1.00 1 0  
post/wait queue 16,024 0.00   0 10,619 0.00
process allocation 3,124 0.42 4.85 1 1,594 0.06
process group creation 3,124 0.03 0.00 0 0  
qmn task queue latch 520 0.00   0 0  
redo allocation 57,654 0.01 0.40 0 125,348 0.03
redo copy 0     0 125,366 0.03
redo writing 53,484 0.01 0.33 0 0  
resmgr group change latch 1,929 0.00   0 0  
resmgr:active threads 3,247 0.00   0 0  
resmgr:actses change group 1,623 0.00   0 0  
resmgr:free threads list 3,246 0.09 0.00 0 0  
resmgr:schema config 1 0.00   0 0  
row cache objects 1,765,941 0.03 0.09 3 1,425 1.61
rules engine aggregate statistics 5 0.00   0 0  
rules engine rule set statistics 10 0.00   0 0  
sequence cache 19,937 0.01 0.00 0 0  
session allocation 74,423 0.02 0.14 0 0  
session idle bit 3,157,073 0.00 0.07 0 0  
session state list latch 3,726 0.05 0.00 0 0  
session switching 80 0.00   0 0  
session timer 1,693 0.00   0 0  
shared pool 1,619,595 0.72 0.68 664 0  
shared pool sim alloc 59 0.00   0 0  
shared pool simulator 1,466,414 0.00 0.37 3 0  
simulator hash latch 2,895,731 0.00 0.00 0 0  
simulator lru latch 18,990 0.01 0.00 0 2,628,072 0.02
slave class 2 0.00   0 0  
slave class create 8 12.50 1.00 0 0  
sort extent pool 117 0.00   0 0  
state object free list 2 0.00   0 0  
statistics aggregation 560 0.00   0 0  
temp lob duration state obj allocation 2 0.00   0 0  
threshold alerts latch 1,108 0.00   0 0  
transaction allocation 1,551 0.00   0 0  
transaction branch allocation 1,693 0.00   0 0  
undo global data 82,090 0.00 0.00 0 1 0.00
user lock 7,008 0.23 1.06 5 0  

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

Latch NameGet RequestsMissesSleepsSpin GetsSleep1Sleep2Sleep3
cache buffers chains 80,908,112 21,721 22 21,700 0 0 0
shared pool 1,619,595 11,582 7,842 4,378 0 0 0
library cache 2,101,977 9,041 7,355 2,247 0 0 0
row cache objects 1,765,941 474 45 430 0 0 0
library cache lock 1,917,438 70 3 67 0 0 0
kks stats 62,715 40 14 26 0 0 0
cache buffers lru chain 54,890 39 1 38 0 0 0
shared pool simulator 1,466,414 30 11 19 0 0 0
enqueues 132,507 26 4 22 0 0 0
user lock 7,008 16 17 0 0 0 0
session allocation 74,423 14 2 12 0 0 0
session idle bit 3,157,073 14 1 13 0 0 0
process allocation 3,124 13 63 1 0 0 0
In memory undo latch 100,810 7 5 2 0 0 0
redo allocation 57,654 5 2 3 0 0 0
object queue header operation 4,054,441 3 2 1 0 0 0
redo writing 53,484 3 1 2 0 0 0
parameter table allocation management 1,596 2 2 0 0 0 0
archive process latch 1,371 1 1 0 0 0 0
slave class create 8 1 1 0 0 0 0

Back to Latch Statistics
Back to Top

Latch Miss Sources

Latch NameWhereNoWait Misses SleepsWaiter Sleeps
In memory undo latch ktiFlush: child 0 4 3
In memory undo latch kticmt: child 0 2 2
In memory undo latch kturbk 0 1 0
archive process latch kcrrsarc 0 1 0
cache buffers chains kcbchg: kslbegin: bufs not pinned 0 24 3
cache buffers chains kcbgtcr: kslbegin excl 0 17 14
cache buffers chains kcbgtcr: fast path 0 10 26
cache buffers chains kcbrls: kslbegin 0 3 10
cache buffers chains kcbbxsv 0 1 0
cache buffers lru chain kcbzgws 0 1 0
channel handle pool latch ksrchconnect() 0 2 2
cost function kzulgt: find user res 0 16 12
cost function kzulrl 0 1 5
enqueues ksqdel 0 2 3
enqueues ksqgel: create enqueue 0 2 1
kks stats kks stats alloc/free 0 14 14
library cache kglLockCursor 0 1,474 1,852
library cache kgldti: 2child 0 401 77
library cache kglpndl: child: after processing 0 382 12
library cache kglhdgn: child: 0 302 1,366
library cache kglobpn: child: 0 297 615
library cache kgldte: child 0 0 209 433
library cache kglhdgc: child: 0 80 2
library cache kglnti 0 77 5
library cache kglpnp: child 0 63 246
library cache kglpin 0 54 47
library cache kglukp: child 0 51 86
library cache kglpndl: child: before processing 0 40 263
library cache kglati 0 26 0
library cache kglScanDependency 0 7 0
library cache kglic 0 4 1
library cache kglhdiv: child 0 3 0
library cache kglget: unpin heap 0 0 2 0
library cache kglobld 0 2 26
library cache kgldtld: 2child 0 1 1
library cache kglivl: child 0 1 0
library cache lock kgllkdl: child: no lock handle 0 709 810
library cache lock kgllkal: child: multiinstance 0 2 1
library cache lock kgllkdl: child: cleanup 0 1 2
object queue header operation kcbo_switch_cq 0 1 0
object queue header operation kcbw_unlink_q 0 1 1
parameter table allocation management ksp_param_table_free 0 2 2
process allocation ksuapc 0 45 63
process allocation ksucrp 0 17 0
redo allocation kcrfw_redo_gen: redo allocation 1 0 2 0
redo writing kcrfw_post: rba scn pair 0 1 0
row cache objects kqreqd: reget 0 18 0
row cache objects kqrpre: find obj 0 11 30
row cache objects kqreqd 0 5 4
row cache objects kqrso 0 2 0
session allocation ksucri 0 1 1
session allocation ksucrp 0 1 1
session idle bit ksupuc: set busy 0 1 0
shared pool kghalo 0 3,894 1,735
shared pool kghfrunp: alloc: wait 0 1,739 848
shared pool kghfrunp: clatch: nowait 0 1,671 0
shared pool kghfrunp: clatch: wait 0 1,509 1,524
shared pool kghupr1 0 1,255 4,676
shared pool kghalp 0 439 201
shared pool kghfre 0 291 347
shared pool kghasp 0 136 1
shared pool kgh_next_free 0 41 4
shared pool kghfrh 0 39 1
shared pool kghfree_extents: scan 0 6 20
shared pool kgh: add extent to reserved list 0 2 10
shared pool simulator kglsim_upd_newhp 0 5 0
shared pool simulator kglsim_unpin_simhp 0 4 2
shared pool simulator kglsim_chg_simhp_free 0 1 0
shared pool simulator kglsim_unpin_simhp: fast path 0 1 6
slave class create ksvcreate 0 1 0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Back to Top

Segments by Logical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypeLogical Reads%Total
INPADM TSP_INPADM PK_PATS_IN_HOSPITAL   INDEX 36,367,536 62.86
PHARMACY TSP_PHARMACY DRUG_PRESC_MASTER_TEMP   TABLE 6,276,624 10.85
PHARMACY TSP_PHARMACY PK_DRUG_DISPENSE_REC   INDEX 4,244,816 7.34
PHARMACY TSP_PHARMACY DRUG_DISPENSE_REC   TABLE 1,162,176 2.01
ORDADM TSP_ORDADM DOCTOR_ORDERS   TABLE 987,024 1.71

Back to Segment Statistics
Back to Top

Segments by Physical Reads

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
OUTPBILL TSP_OUTPBILL OUTP_BILL_ITEMS   TABLE 806,927 40.68
PHARMACY TSP_PHARMACY DRUG_DISPENSE_REC   TABLE 590,348 29.76
OUTPBILL TSP_OUTPBILL OUTP_RCPT_MASTER   TABLE 367,528 18.53
PHARMACY USERS PRESCRIPTION   TABLE 55,982 2.82
OUTPBILL TSP_OUTPBILL INVOICE_INFO   TABLE 43,641 2.20

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeRow Lock Waits% of Capture
INPBILL TSP_INPBILL IND_1_INP_BILL_DETAIL   INDEX 14 26.42
HQC TSP_INPBILL IND_ASACCT_STAT   INDEX 12 22.64
INPBILL TSP_INPBILL PK_INP_BILL_DETAIL   INDEX 8 15.09
OUTPBILL TSP_OUTPBILL PK_OUTP_ORDER_DESC   INDEX 3 5.66
OUTPADM TSP_OUTPADM CLINIC_FOR_REGIST   TABLE 2 3.77

Back to Segment Statistics
Back to Top

Segments by ITL Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeITL Waits% of Capture
ORDADM TSP_ORDADM PK_ORDERS_SHEET_IMAGE   INDEX 1 100.00

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

OwnerTablespace NameObject NameSubobject NameObj. TypeBuffer Busy Waits% of Capture
CPR TSP_CPR PK_DOCTOR_ACTION_LOG   INDEX 3 75.00
PHARMACY TSP_PHARMACY PK_IP_ORDER_STATE   INDEX 1 25.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

CacheGet RequestsPct MissScan ReqsPct MissMod ReqsFinal Usage
dc_awr_control 67 0.00 0   2 1
dc_database_links 3,180 0.00 0   0 1
dc_global_oids 252 0.00 0   0 112
dc_histogram_data 207,971 0.06 0   0 8,397
dc_histogram_defs 73,879 0.19 0   0 5,265
dc_object_grants 28,361 0.00 0   0 484
dc_object_ids 92,732 0.03 0   0 2,106
dc_objects 46,639 2.01 0   26 8,143
dc_profiles 1,649 0.00 0   0 1
dc_rollback_segments 663 0.00 0   0 30
dc_segments 47,770 0.04 0   6 1,473
dc_sequences 3,175 0.00 0   3,175 16
dc_table_scns 838 0.00 0   0 5
dc_tablespaces 63,122 0.00 0   0 43
dc_usernames 31,507 0.08 0   0 641
dc_users 163,649 0.02 0   1 1,066
outstanding_alerts 524 0.57 0   5 85


Back to Top

Library Cache Activity

NamespaceGet RequestsPct MissPin RequestsPct MissReloadsInvali- dations
BODY 743 0.00 7,612 0.00 0 0
CLUSTER 126 0.00 247 0.00 0 0
INDEX 21 0.00 87 0.00 0 0
SQL AREA 112,128 23.57 1,180,474 3.85 2,498 183
TABLE/PROCEDURE 11,515 6.91 159,208 0.19 128 0
TRIGGER 1,640 1.04 27,147 0.00 0 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 335.19   0.99 2.87 44 45 338 338
  Freeable 243.94 0.00 0.85 0.38 4   288 288
  PL/SQL 7.68 5.83 0.02 0.02 0 0 336 336
  SQL 4.30 1.98 0.01 0.02 0 13 326 319
E Other 388.53   0.96 2.62 44 45 405 405
  Freeable 295.44 0.00 0.84 0.35 4   350 350
  PL/SQL 9.85 7.35 0.02 0.02 0 0 403 403
  SQL 5.05 2.30 0.01 0.02 0 13 393 385

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regionsBegin Size (Bytes)End Size (Bytes) (if different)
Database Buffers 1,728,053,248 1,627,389,952
Fixed Size 2,089,240  
Redo Buffers 14,684,160  
Variable Size 2,449,477,352 2,550,140,648

Back to Memory Statistics
Back to Top

SGA breakdown difference

PoolNameBegin MBEnd MB% Diff
java free memory 26.72 26.72 0.00
java joxlod exec hp 5.21 5.21 0.00
large PX msg pool 1.03 1.03 0.00
large free memory 14.97 14.97 0.00
shared CCursor 544.64 542.90 -0.32
shared Heap0: KGL 34.80 32.66 -6.17
shared KGH: NO ACCESS 304.15 304.15 0.00
shared PCursor 254.07 262.96 3.50
shared free memory 498.79 383.67 -23.08
shared kglsim object batch 39.17 39.33 0.40
shared library cache 119.67 130.51 9.06
shared sql area 492.23 691.65 40.51
shared sql area:PLSQL 92.63 87.56 -5.47
  buffer_cache 1,648.00 1,552.00 -5.83
  fixed_sga 1.99 1.99 0.00
  log_buffer 14.00 14.00 0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Back to Top

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.


Back to Top

init.ora Parameters

Parameter NameBegin valueEnd value (if different)
archive_lag_target 900   
audit_file_dest /u01/oracle/admin/orcl/adump   
background_dump_dest /u01/oracle/admin/orcl/bdump   
compatible 10.2.0.3.0   
control_files /u02/oradata/orcl/control01.ctl, /u02/oradata/orcl/control02.ctl, /u02/oradata/orcl/control03.ctl   
core_dump_dest /u01/oracle/admin/orcl/cdump   
db_block_size 8192   
db_domain      
db_file_multiblock_read_count 16   
db_name orcl   
db_writer_processes 4   
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)   
fal_client ORCL   
fal_server STDBY   
job_queue_processes 10   
log_archive_config dg_config=(orcl, stdby)   
log_archive_dest_1 location=/u03/archivelog   
log_archive_dest_2 service=STDBY valid_for=(online_logfiles, primary_role) db_unique_name=STDBY   
log_archive_dest_state_2 ENABLE   
open_cursors 300   
optimizer_mode CHOOSE   
pga_aggregate_target 1048576000   
processes 800   
remote_login_passwordfile EXCLUSIVE   
service_names orcl   
sessions 885   
sga_target 4194304000   
standby_file_management AUTO   
undo_management AUTO   
undo_tablespace UNDOTBS1   
user_dump_dest /u01/oracle/admin/orcl/udump   


Back to Top

End of Report