WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ORCL 1303953018 orcl 1 10.2.0.4.0 NO hisserver

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1303953018	orcl	1	10.2.0.4.0	NO	hisserver

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 10389 03-May-13 10:00:55 358 3.0

End Snap: 10390 03-May-13 11:00:39 381 3.0

Elapsed: 59.73 (mins)

DB Time: 471.67 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10389	03-May-13 10:00:55	358	3.0
End Snap:	10390	03-May-13 11:00:39	381	3.0
Elapsed:		59.73 (mins)
DB Time:		471.67 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,744M 1,936M Std Block Size: 8K

Shared Pool Size: 2,208M 2,016M Log Buffer: 14,340K

	Begin	End
Buffer Cache:	1,744M	1,936M	Std Block Size:	8K
Shared Pool Size:	2,208M	2,016M	Log Buffer:	14,340K

Load Profile

Per Second Per Transaction

Redo size: 13,714.16 4,097.71

Logical reads: 20,077.44 5,999.01

Block changes: 92.36 27.60

Physical reads: 6,472.04 1,933.80

Physical writes: 5.27 1.57

User calls: 438.12 130.91

Parses: 125.46 37.49

Hard parses: 4.00 1.20

Sorts: 10.87 3.25

Logons: 0.36 0.11

Executes: 122.12 36.49

Transactions: 3.35

	Per Second	Per Transaction
Redo size:	13,714.16	4,097.71
Logical reads:	20,077.44	5,999.01
Block changes:	92.36	27.60
Physical reads:	6,472.04	1,933.80
Physical writes:	5.27	1.57
User calls:	438.12	130.91
Parses:	125.46	37.49
Hard parses:	4.00	1.20
Sorts:	10.87	3.25
Logons:	0.36	0.11
Executes:	122.12	36.49
Transactions:	3.35

% Blocks changed per Read: 0.46 Recursive Call %: 17.17

Rollback per transaction %: 21.75 Rows per Sort: 39.65

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 99.98

Buffer Hit %: 67.76 In-memory Sort %: 100.00

Library Hit %: 97.21 Soft Parse %: 96.81

Execute to Parse %: -2.74 Latch Hit %: 99.91

Parse CPU to Parse Elapsd %: 0.41 % Non-Parse CPU: 98.17

Shared Pool Statistics

Begin End

Memory Usage %: 74.27 75.88

% SQL with executions>1: 61.89 69.16

% Memory for SQL w/exec>1: 67.24 76.34

	Begin	End
Memory Usage %:	74.27	75.88
% SQL with executions>1:	61.89	69.16
% Memory for SQL w/exec>1:	67.24	76.34

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

latch: library cache 40,076 12,913 322 45.6 Concurrency

latch: shared pool 39,362 6,466 164 22.8 Concurrency

CPU time 2,552 9.0

log file sync 9,574 1,896 198 6.7 Commit

db file sequential read 182,531 1,620 9 5.7 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch: library cache	40,076	12,913	322	45.6	Concurrency
latch: shared pool	39,362	6,466	164	22.8	Concurrency
CPU time		2,552		9.0
log file sync	9,574	1,896	198	6.7	Commit
db file sequential read	182,531	1,620	9	5.7	User I/O

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 28300.4s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
parse time elapsed	11,074.32	39.13
sql execute elapsed time	7,337.45	25.93
hard parse elapsed time	3,634.29	12.84
DB CPU	2,551.87	9.02
PL/SQL execution elapsed time	725.33	2.56
connection management call elapsed time	648.38	2.29
PL/SQL compilation elapsed time	231.51	0.82
hard parse (sharing criteria) elapsed time	228.39	0.81
failed parse elapsed time	146.51	0.52
sequence load elapsed time	16.70	0.06
hard parse (bind mismatch) elapsed time	10.93	0.04
repeated bind elapsed time	0.04	0.00
DB time	28,300.42
background elapsed time	4,088.88
background cpu time	14.56

Back to Wait Events Statistics
Back to Top

Wait Class

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Concurrency	81,241	1.40	19,548	241	6.77
User I/O	1,833,698	0.00	3,263	2	152.87
Commit	9,574	1.19	1,896	198	0.80
System I/O	25,044	0.00	1,749	70	2.09
Application	1,160	4.91	178	153	0.10
Other	662	0.60	145	218	0.06
Configuration	26	53.85	17	638	0.00
Network	1,713,088	0.00	4	0	142.82

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
latch: library cache	40,076	0.00	12,913	322	3.34
latch: shared pool	39,362	0.00	6,466	164	3.28
log file sync	9,574	1.19	1,896	198	0.80
db file sequential read	182,531	0.00	1,620	9	15.22
db file scattered read	1,647,340	0.00	1,618	1	137.34
log file parallel write	8,615	0.00	1,057	123	0.72
control file parallel write	3,346	0.00	651	194	0.28
enq: TX - row lock contention	66	86.36	177	2687	0.01
latch: row cache objects	307	0.00	144	469	0.03
latch free	473	0.00	102	215	0.04
enq: CF - contention	105	0.95	41	393	0.01
control file sequential read	12,895	0.00	40	3	1.08
read by other session	3,660	0.00	25	7	0.31
cursor: pin S wait on X	1,128	100.00	12	11	0.09
os thread startup	15	46.67	11	705	0.00
log file switch (private strand flush incomplete)	15	53.33	9	619	0.00
log file switch completion	11	54.55	7	665	0.00
enq: TX - index contention	17	0.00	2	117	0.00
log file sequential read	71	0.00	2	25	0.01
ARCH wait on SENDREQ	64	0.00	2	26	0.01
buffer exterminate	2	50.00	2	795	0.00
SQL*Net more data to client	131,291	0.00	1	0	10.95
SQL*Net message to client	1,575,987	0.00	1	0	131.39
log file single write	4	0.00	1	141	0.00
SQL*Net more data from client	5,746	0.00	0	0	0.48
db file parallel read	1	0.00	0	281	0.00
latch: cache buffers chains	177	0.00	0	1	0.01
SQL*Net break/reset to client	1,094	0.00	0	0	0.09
Log archive I/O	113	0.00	0	2	0.01
latch: In memory undo latch	20	0.00	0	4	0.00
kksfbc child completion	1	100.00	0	49	0.00
wait list latch free	3	0.00	0	11	0.00
row cache lock	54	0.00	0	0	0.00
latch: library cache lock	11	0.00	0	1	0.00
buffer busy waits	72	0.00	0	0	0.01
latch: session allocation	14	0.00	0	0	0.00
latch: cache buffers lru chain	20	0.00	0	0	0.00
latch: object queue header operation	24	0.00	0	0	0.00
latch: library cache pin	2	0.00	0	1	0.00
latch: enqueue hash chains	3	0.00	0	0	0.00
rdbms ipc reply	1	0.00	0	0	0.00
buffer deadlock	1	100.00	0	0	0.00
LGWR wait for redo copy	12	0.00	0	0	0.00
direct path read	82	0.00	0	0	0.01
latch: redo allocation	1	0.00	0	0	0.00
direct path write	84	0.00	0	0	0.01
cursor: pin S	2	0.00	0	0	0.00
SQL*Net message from client	1,575,957	0.00	744,483	472	131.38
Streams AQ: qmn slave idle wait	128	0.00	3,510	27425	0.01
Streams AQ: qmn coordinator idle wait	261	50.96	3,510	13450	0.02
virtual circuit status	119	100.00	3,486	29297	0.01
jobq slave wait	1,173	95.31	3,384	2885	0.10
Streams AQ: waiting for time management or cleanup tasks	5	80.00	1,826	365276	0.00
SGA: MMAN sleep for component shrink	179	91.06	2	10	0.01
class slave wait	2	0.00	0	51	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
log file parallel write	8,616	0.00	1,057	123	0.72
control file parallel write	3,347	0.00	651	194	0.28
latch: library cache	100	0.00	113	1127	0.01
latch: shared pool	213	0.00	106	498	0.02
events in waitclass Other	145	0.69	41	285	0.01
control file sequential read	12,015	0.00	39	3	1.00
os thread startup	15	46.67	11	705	0.00
db file sequential read	165	0.00	5	31	0.01
log file sequential read	71	0.00	2	25	0.01
ARCH wait on SENDREQ	64	0.00	2	26	0.01
latch: row cache objects	1	0.00	1	746	0.00
log file single write	4	0.00	1	141	0.00
db file scattered read	28	0.00	0	17	0.00
Log archive I/O	113	0.00	0	2	0.01
latch: cache buffers chains	1	0.00	0	125	0.00
direct path read	82	0.00	0	0	0.01
direct path write	82	0.00	0	0	0.01
rdbms ipc message	21,956	64.53	44,012	2005	1.83
Streams AQ: qmn slave idle wait	128	0.00	3,510	27425	0.01
Streams AQ: qmn coordinator idle wait	261	50.96	3,510	13450	0.02
pmon timer	1,748	100.00	3,496	2000	0.15
smon timer	12	83.33	3,226	268859	0.00
Streams AQ: waiting for time management or cleanup tasks	5	80.00	1,826	365276	0.00
SGA: MMAN sleep for component shrink	179	91.06	2	10	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	292,867
IDLE_TIME	2,558,057
IOWAIT_TIME	351,754
NICE_TIME	38
SYS_TIME	57,967
USER_TIME	227,504
LOAD	4
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

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
orcl	21,579.10	262.00	1,019,622	35,429,604
SYS$USERS	6,963.90	2,301.60	22,309,101	36,679,474
SYS$BACKGROUND	0.00	0.00	724	31,672
orclXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
orcl	126192	146324	67222	1647454	1507316	205
SYS$USERS	1707537	175809	12534	257721	203192	41
SYS$BACKGROUND	811	4980	619	25566	64	164

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
958	635	62	15.45	3.38	0057pbug4j6g8	JDBC Thin Client	select * from ip_orderdetl_vie...
941	632	62	15.18	3.33	gb6bmvqrgutd0	JDBC Thin Client	select * from ip_orderdetl_vie...
666	3	2,148	0.31	2.35	4yffxmsh6n03q	doctws.exe	BEGIN SYS.DBMS_DESCRIBE.DESCRI...
392	262	26	15.08	1.39	7qjuwmr8y9js5	JDBC Thin Client	select * from ip_orderdetl_vie...
386	227	22	17.55	1.36	1pdh7xz7fyswg	JDBC Thin Client	select * from ip_orderdetl_vie...
384	255	26	14.79	1.36	1rf56qnwp6ck8	JDBC Thin Client	select * from ip_orderdetl_vie...
358	216	21	17.05	1.26	7gbf3s6tr8s9k	JDBC Thin Client	select * from ip_orderdetl_vie...
216	1	0		0.76	gyhmjhna0kum7	pb60.exe	select performed_by, sum(costs...
186	1	1,254	0.15	0.66	0k8522rmdzg4k		select privilege# from sysauth...
164	1	2,592	0.06	0.58	c3uk2whs1zv6u	obilling.exe	select bussiness_id.nextval fr...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)	Elapsed Time (s)	Executions	CPU per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
635	958	62	10.25	3.38	0057pbug4j6g8	JDBC Thin Client	select * from ip_orderdetl_vie...
632	941	62	10.19	3.33	gb6bmvqrgutd0	JDBC Thin Client	select * from ip_orderdetl_vie...
262	392	26	10.06	1.39	7qjuwmr8y9js5	JDBC Thin Client	select * from ip_orderdetl_vie...
255	384	26	9.80	1.36	1rf56qnwp6ck8	JDBC Thin Client	select * from ip_orderdetl_vie...
227	386	22	10.30	1.36	1pdh7xz7fyswg	JDBC Thin Client	select * from ip_orderdetl_vie...
216	358	21	10.30	1.26	7gbf3s6tr8s9k	JDBC Thin Client	select * from ip_orderdetl_vie...
32	32	1,861	0.02	0.11	gnp1u7yqu2skn	C:\Documents and Settings\dyyy\��\��ҩ.lnk	SELECT "DRUG_PRESC_MASTER_T...
26	79	504	0.05	0.28	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
10	15	1	10.31	0.05	29m8s3140fhzw	JDBC Thin Client	select * from ip_orderdetl_vie...
10	18	0		0.06	gjx48dpm1xthj	JDBC Thin Client	select * from ip_orderdetl_vie...
3	666	2,148	0.00	2.35	4yffxmsh6n03q	doctws.exe	BEGIN SYS.DBMS_DESCRIBE.DESCRI...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
Total Buffer Gets: 71,958,157
Captured SQL account for 76.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
11,847,555	1,861	6,366.23	16.46	31.77	31.92	gnp1u7yqu2skn	C:\Documents and Settings\dyyy\��\��ҩ.lnk	SELECT "DRUG_PRESC_MASTER_T...
6,827,917	62	110,127.69	9.49	635.20	957.96	0057pbug4j6g8	JDBC Thin Client	select * from ip_orderdetl_vie...
6,827,870	62	110,126.94	9.49	631.54	941.12	gb6bmvqrgutd0	JDBC Thin Client	select * from ip_orderdetl_vie...
4,005,676	13	308,128.92	5.57	6.95	7.06	gst1kbkqmybq3	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
3,389,047	11	308,095.18	4.71	5.82	5.90	g6npbj93qprkw	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
2,862,242	26	110,086.23	3.98	261.57	392.20	7qjuwmr8y9js5	JDBC Thin Client	select * from ip_orderdetl_vie...
2,752,155	26	105,852.12	3.82	254.83	384.48	1rf56qnwp6ck8	JDBC Thin Client	select * from ip_orderdetl_vie...
2,464,591	8	308,073.88	3.43	4.20	4.93	09uzsuu1ndjgu	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
2,423,799	22	110,172.68	3.37	226.58	386.05	1pdh7xz7fyswg	JDBC Thin Client	select * from ip_orderdetl_vie...
2,313,584	21	110,170.67	3.22	216.32	357.95	7gbf3s6tr8s9k	JDBC Thin Client	select * from ip_orderdetl_vie...
1,848,893	6	308,148.83	2.57	3.21	3.22	gpjpp9dpw6fat	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
1,232,389	4	308,097.25	1.71	2.14	2.31	fuj5yvndztbgb	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
924,539	3	308,179.67	1.28	1.62	1.70	2rkp3b0v001wj	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
924,236	3	308,078.67	1.28	1.66	5.62	f0rafhx0gx5mu	XHLisServiceA.exe	SELECT pats_in_hospital.patie...
850,276	504	1,687.06	1.18	25.74	79.12	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 23,195,981
Captured SQL account for 98.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
6,316,362	62	101,876.81	27.23	635.20	957.96	0057pbug4j6g8	JDBC Thin Client	select * from ip_orderdetl_vie...
6,220,059	62	100,323.53	26.82	631.54	941.12	gb6bmvqrgutd0	JDBC Thin Client	select * from ip_orderdetl_vie...
2,418,250	22	109,920.45	10.43	226.58	386.05	1pdh7xz7fyswg	JDBC Thin Client	select * from ip_orderdetl_vie...
2,395,198	26	92,123.00	10.33	254.83	384.48	1rf56qnwp6ck8	JDBC Thin Client	select * from ip_orderdetl_vie...
2,352,003	26	90,461.65	10.14	261.57	392.20	7qjuwmr8y9js5	JDBC Thin Client	select * from ip_orderdetl_vie...
2,308,370	21	109,922.38	9.95	216.32	357.95	7gbf3s6tr8s9k	JDBC Thin Client	select * from ip_orderdetl_vie...
178,831	2	89,415.50	0.77	4.45	23.16	9m4tcjfb7jnfs	orddisp.exe	SELECT "ORDERS"."REPEAT_IND...
175,622	2	87,811.00	0.76	5.42	26.35	a8ftqvnxrf7m0	stockmgr.exe	SELECT receiver, package_spec,...
151,005	2	75,502.50	0.65	5.00	29.14	98tvas0zdcq1a	stockmgr.exe	SELECT '��' action_type,...
150,992	2	75,496.00	0.65	4.47	16.71	1qa9kta6216cx	orddisp.exe	SELECT "DRUG_DISPENSE_REC"."...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 437,668
Captured SQL account for 63.7% of Total

Executions	Rows Processed	Rows per Exec	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
50,515	9,731	0.19	0.00	664crkjw8n47y	doctws.exe	select dept_code , ward_code ...
50,451	9,717	0.19	0.00	g2tcdkz3sy3h2	doctws.exe	Select bed_label From bed_rec ...
44,579	3,781	0.08	0.00	c69f5n7vyas9s	doctws.exe	Select bed_no , diagnosis , ...
20,445	20,432	1.00	0.00	4srur5p7sxdu3	doctws.exe	select user_name from comm.use...
11,842	11,692	0.99	0.00	4pwnt0hgg2ghr	doctws.exe	select administration_code fro...
9,847	9,847	1.00	0.00	a7w35qskd8cs0	C:\Documents and Settings\dyyy.JW\��\��.	SELECT MIN ( CLASS_ON_INP_RCPT...
9,183	9,183	1.00	0.01	f0wzs9nc663bn	odoctor.exe	select sysdate from dual
7,818	16,373	2.09	0.01	0h6b2sajwb74n		select privilege#, level from ...
5,757	5,655	0.98	0.00	5h8hkpq3q5g41	doctws.exe	SELECT TOPIC , ITEM_CLASS , ...
3,746	3,457	0.92	0.00	0t691q1kmy9w8	XHLisServiceS.exe	UPDATE PATS_IN_HOSPITAL SET TO...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 449,668
Captured SQL account for 68.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
59,202	50,515	13.17	664crkjw8n47y	doctws.exe	select dept_code , ward_code ...
59,139	50,451	13.15	g2tcdkz3sy3h2	doctws.exe	Select bed_label From bed_rec ...
53,212	44,579	11.83	c69f5n7vyas9s	doctws.exe	Select bed_no , diagnosis , ...
24,129	20,445	5.37	4srur5p7sxdu3	doctws.exe	select user_name from comm.use...
11,843	11,842	2.63	4pwnt0hgg2ghr	doctws.exe	select administration_code fro...
9,847	9,847	2.19	a7w35qskd8cs0	C:\Documents and Settings\dyyy.JW\��\��.	SELECT MIN ( CLASS_ON_INP_RCPT...
9,234	9,183	2.05	f0wzs9nc663bn	odoctor.exe	select sysdate from dual
7,819	7,818	1.74	0h6b2sajwb74n		select privilege#, level from ...
6,141	5,757	1.37	5h8hkpq3q5g41	doctws.exe	SELECT TOPIC , ITEM_CLASS , ...
3,313	3,493	0.74	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

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
73	556	1y01fm6rm9vff	doctws.exe	INSERT INTO "DOCTOR_ORDERS" ( ...
44	3,493	1g8brz25xjs3j	examapt.exe	SELECT CHARGE_TYPE, INSURANCE...
30	1,295	9mrhw217pc809	doctws.exe	select MR_CODE , mr_attr , m...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0057pbug4j6g8 select * from ip_orderdetl_view where cfxh='020902_20130503095940' and patid='H2322'

09uzsuu1ndjgu SELECT 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' )

0h6b2sajwb74n select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

0k8522rmdzg4k select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0

0t691q1kmy9w8 UPDATE 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

1g8brz25xjs3j SELECT CHARGE_TYPE, INSURANCE_TYPE FROM PAT_VISIT WHERE PATIENT_ID = :B2 AND VISIT_ID = :B1

1pdh7xz7fyswg select * from ip_orderdetl_view where cfxh='020910_20130503095452' and patid='H2321'

1qa9kta6216cx SELECT "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME", "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER", "DEPT_VS_WARD"."WARD_CODE" , count(*) order_count FROM "DRUG_DISPENSE_REC", "DEPT_VS_WARD" WHERE ( drug_dispense_rec.ordered_by = dept_vs_ward.dept_code (+)) and ( "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" >= TO_DATE('3-May-2013 00:00:00', 'DD-MON-YYYY HH24:MI:SS') ) AND ( "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" < TO_DATE('4-May-2013 00:00:00', 'DD-MON-YYYY HH24:MI:SS') ) AND ("DEPT_VS_WARD"."WARD_CODE" = 'H2251' OR 'H2251' IS NULL ) GROUP BY "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME", "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER", "DEPT_VS_WARD"."WARD_CODE"

1rf56qnwp6ck8 select * from ip_orderdetl_view where cfxh='020902_20130503100224' and patid='H2275'

1y01fm6rm9vff INSERT INTO "DOCTOR_ORDERS" ( "ORDER_TEXT", "DOSAGE", "DOSAGE_UNITS", "ADMINISTRATION", "DURATION", "DURATION_UNITS", "FREQUENCY", "FREQ_COUNTER", "FREQ_INTERVAL", "FREQ_INTERVAL_UNIT", "DOCTOR", "NURSE", "START_STOP_INDICATOR", "ORDER_CLASS", "REPEAT_INDICATOR", "ORDER_CODE", "ORDER_STATUS", "ENTER_DATE_TIME", "FREQ_DETAIL", "PATIENT_ID", "VISIT_ID", "ORDER_NO", "ORDER_SUB_NO", "ORDERING_DEPT", "ORDER_PRINT_INDICATOR", "RELATED_ORDER_NO", "RELATED_ORDER_SUB_NO", "BILLING_ATTR", "START_DATE_TIME", "DRUG_BILLING_ATTR" ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30 )

29m8s3140fhzw select * from ip_orderdetl_view where cfxh='020902_20130503095822' and patid='H2424'

2rkp3b0v001wj SELECT 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' )

4pwnt0hgg2ghr select administration_code from administration_dict where administration_name =:1

4srur5p7sxdu3 select user_name from comm.users where DB_USER =:1

4yffxmsh6n03q BEGIN SYS.DBMS_DESCRIBE.DESCRIBE_PROCEDURE(:object_name, :res1, :res2, :overload, :position, :level, :argument, :datatype, :default, :in_out, :length, :precision, :scale, :radix, :spare); END;

5h8hkpq3q5g41 SELECT 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

664crkjw8n47y select dept_code , ward_code from pats_in_hospital where patient_id =:1 and visit_id =:2

7gbf3s6tr8s9k select * from ip_orderdetl_view where cfxh='020902_20130503095504' and patid='H2274'

7qjuwmr8y9js5 select * from ip_orderdetl_view where cfxh='020910_20130503100212' and patid='H2251'

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)))

9m4tcjfb7jnfs SELECT "ORDERS"."REPEAT_INDICATOR" , "PAT_MASTER_INDEX"."NAME" , "PAT_MASTER_INDEX"."SEX" , "ORDERS"."ORDER_TEXT" , "ORDERS"."DOSAGE" , "ORDERS"."DOSAGE_UNITS" , "ORDERS"."ADMINISTRATION" , "ORDERS"."FREQUENCY" , "ORDERS"."START_DATE_TIME" , "ORDERS"."STOP_DATE_TIME" , "ORDERS"."PATIENT_ID" , "ORDERS"."VISIT_ID" , "ORDERS"."ORDER_NO" , "ORDERS"."ORDER_SUB_NO" , "ORDERS"."ORDER_CODE" , "ORDERS"."ORDERING_DEPT" , "ORDERS"."LAST_PERFORM_DATE_TIME" , "PAT_MASTER_INDEX"."CHARGE_TYPE" , "ORDERS"."PERFORM_SCHEDULE" , "DRUG_DISPENSE_REC"."DRUG_CODE" , "DRUG_DISPENSE_REC"."DRUG_SPEC" , "DRUG_DISPENSE_REC"."DISPENSE_AMOUNT" , "DRUG_DISPENSE_REC"."DRUG_UNITS" , "DRUG_DISPENSE_REC"."FIRM_ID" , "DRUG_DISPENSE_REC"."COSTS" , "DRUG_DISPENSE_REC"."CHARGES" , nvl("PATS_IN_HOSPITAL"."BED_NO", 0) bed_no, "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" , "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER" , "ORDERS"."DOCTOR" FROM "ORDERS" , "PAT_MASTER_INDEX" , "DRUG_DISPENSE_REC" , "PATS_IN_HOSPITAL" WHERE ( "DRUG_DISPENSE_REC"."VISIT_ID" = "PATS_IN_HOSPITAL"."VISIT_ID" (+)) and ( "DRUG_DISPENSE_REC"."PATIENT_ID" = "PATS_IN_HOSPITAL"."PATIENT_I D" (+)) and ( "DRUG_DISPENSE_REC"."PATIENT_ID" = "PAT_MASTER_INDEX"."PATIENT_ID" ) and ( "DRUG_DISPENSE_REC"."PATIENT_ID" = "ORDERS"."PATIENT_ID" ) and ( "DRUG_DISPENSE_REC"."VISIT_ID" = "ORDERS"."VISIT_ID" ) and ( "DRUG_DISPENSE_REC"."ORDER_NO" = "ORDERS"."ORDER_NO" ) and ( "DRUG_DISPENSE_REC"."ORDER_SUB_NO" = "ORDERS"."ORDER_SUB_NO" ) and ( ( "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" = TO_DATE('3-May-2013 10:26:32', 'DD-MON-YYYY HH24:MI:SS') ) and ( "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER" = '��' ) ) ORDER BY 27 ASC, "ORDERS"."REPEAT_INDICATOR" ASC, "ORDERS"."ADMINISTRATION" ASC, "ORDERS"."START_DATE_TIME" ASC, "ORDERS"."ORDER_NO" ASC, "ORDERS"."ORDER_SUB_NO" ASC

9mrhw217pc809 select MR_CODE , mr_attr , mr_class from mr_item_index where mr_name =:1 ORDER BY mr_attr desc

a7w35qskd8cs0 SELECT 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

c3uk2whs1zv6u select bussiness_id.nextval from dual

c69f5n7vyas9s Select bed_no , diagnosis , patient_condition From pats_in_hospital Where Patient_id =:1 And Visit_id =:2

f0rafhx0gx5mu SELECT 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' )

f0wzs9nc663bn select sysdate from dual

fuj5yvndztbgb SELECT 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' )

g2tcdkz3sy3h2 Select bed_label From bed_rec Where ward_code =:1 And bed_no =:2

g6npbj93qprkw SELECT 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' )

gb6bmvqrgutd0 select * from ip_orderdetl_view where cfxh='020910_20130503095901' and patid='H2351'

gjx48dpm1xthj select * from ip_orderdetl_view where cfxh='020902_20130503095500' and patid='H2274'

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 )

gpjpp9dpw6fat SELECT 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' )

gst1kbkqmybq3 SELECT 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 = '0404' or pats_in_hospital.ward_code = '0404' )

gyhmjhna0kum7 select performed_by, sum(costs) from inp_bill_Detail where billing_Date_Time>=to_Date('01-apr-13') and billing_Date_Time<to_Date('01-may-13') and performed_by like '0206%' and costs=charges group by performed_by

SQL Id	SQL Text
0057pbug4j6g8	select * from ip_orderdetl_view where cfxh='020902_20130503095940' and patid='H2322'
09uzsuu1ndjgu	SELECT 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' )
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0t691q1kmy9w8	UPDATE 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
1g8brz25xjs3j	SELECT CHARGE_TYPE, INSURANCE_TYPE FROM PAT_VISIT WHERE PATIENT_ID = :B2 AND VISIT_ID = :B1
1pdh7xz7fyswg	select * from ip_orderdetl_view where cfxh='020910_20130503095452' and patid='H2321'
1qa9kta6216cx	SELECT "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME", "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER", "DEPT_VS_WARD"."WARD_CODE" , count(*) order_count FROM "DRUG_DISPENSE_REC", "DEPT_VS_WARD" WHERE ( drug_dispense_rec.ordered_by = dept_vs_ward.dept_code (+)) and ( "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" >= TO_DATE('3-May-2013 00:00:00', 'DD-MON-YYYY HH24:MI:SS') ) AND ( "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" < TO_DATE('4-May-2013 00:00:00', 'DD-MON-YYYY HH24:MI:SS') ) AND ("DEPT_VS_WARD"."WARD_CODE" = 'H2251' OR 'H2251' IS NULL ) GROUP BY "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME", "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER", "DEPT_VS_WARD"."WARD_CODE"
1rf56qnwp6ck8	select * from ip_orderdetl_view where cfxh='020902_20130503100224' and patid='H2275'
1y01fm6rm9vff	INSERT INTO "DOCTOR_ORDERS" ( "ORDER_TEXT", "DOSAGE", "DOSAGE_UNITS", "ADMINISTRATION", "DURATION", "DURATION_UNITS", "FREQUENCY", "FREQ_COUNTER", "FREQ_INTERVAL", "FREQ_INTERVAL_UNIT", "DOCTOR", "NURSE", "START_STOP_INDICATOR", "ORDER_CLASS", "REPEAT_INDICATOR", "ORDER_CODE", "ORDER_STATUS", "ENTER_DATE_TIME", "FREQ_DETAIL", "PATIENT_ID", "VISIT_ID", "ORDER_NO", "ORDER_SUB_NO", "ORDERING_DEPT", "ORDER_PRINT_INDICATOR", "RELATED_ORDER_NO", "RELATED_ORDER_SUB_NO", "BILLING_ATTR", "START_DATE_TIME", "DRUG_BILLING_ATTR" ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30 )
29m8s3140fhzw	select * from ip_orderdetl_view where cfxh='020902_20130503095822' and patid='H2424'
2rkp3b0v001wj	SELECT 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' )
4pwnt0hgg2ghr	select administration_code from administration_dict where administration_name =:1
4srur5p7sxdu3	select user_name from comm.users where DB_USER =:1
4yffxmsh6n03q	BEGIN SYS.DBMS_DESCRIBE.DESCRIBE_PROCEDURE(:object_name, :res1, :res2, :overload, :position, :level, :argument, :datatype, :default, :in_out, :length, :precision, :scale, :radix, :spare); END;
5h8hkpq3q5g41	SELECT 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
664crkjw8n47y	select dept_code , ward_code from pats_in_hospital where patient_id =:1 and visit_id =:2
7gbf3s6tr8s9k	select * from ip_orderdetl_view where cfxh='020902_20130503095504' and patid='H2274'
7qjuwmr8y9js5	select * from ip_orderdetl_view where cfxh='020910_20130503100212' and patid='H2251'
98tvas0zdcq1a	SELECT '��' action_type, drug_import_master.document_no document_no, import_date action_date, import_class action_class, supplier linker, firm_id, quantity, quantitypurchase_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, quantitypurchase_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)))
9m4tcjfb7jnfs	SELECT "ORDERS"."REPEAT_INDICATOR" , "PAT_MASTER_INDEX"."NAME" , "PAT_MASTER_INDEX"."SEX" , "ORDERS"."ORDER_TEXT" , "ORDERS"."DOSAGE" , "ORDERS"."DOSAGE_UNITS" , "ORDERS"."ADMINISTRATION" , "ORDERS"."FREQUENCY" , "ORDERS"."START_DATE_TIME" , "ORDERS"."STOP_DATE_TIME" , "ORDERS"."PATIENT_ID" , "ORDERS"."VISIT_ID" , "ORDERS"."ORDER_NO" , "ORDERS"."ORDER_SUB_NO" , "ORDERS"."ORDER_CODE" , "ORDERS"."ORDERING_DEPT" , "ORDERS"."LAST_PERFORM_DATE_TIME" , "PAT_MASTER_INDEX"."CHARGE_TYPE" , "ORDERS"."PERFORM_SCHEDULE" , "DRUG_DISPENSE_REC"."DRUG_CODE" , "DRUG_DISPENSE_REC"."DRUG_SPEC" , "DRUG_DISPENSE_REC"."DISPENSE_AMOUNT" , "DRUG_DISPENSE_REC"."DRUG_UNITS" , "DRUG_DISPENSE_REC"."FIRM_ID" , "DRUG_DISPENSE_REC"."COSTS" , "DRUG_DISPENSE_REC"."CHARGES" , nvl("PATS_IN_HOSPITAL"."BED_NO", 0) bed_no, "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" , "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER" , "ORDERS"."DOCTOR" FROM "ORDERS" , "PAT_MASTER_INDEX" , "DRUG_DISPENSE_REC" , "PATS_IN_HOSPITAL" WHERE ( "DRUG_DISPENSE_REC"."VISIT_ID" = "PATS_IN_HOSPITAL"."VISIT_ID" (+)) and ( "DRUG_DISPENSE_REC"."PATIENT_ID" = "PATS_IN_HOSPITAL"."PATIENT_I D" (+)) and ( "DRUG_DISPENSE_REC"."PATIENT_ID" = "PAT_MASTER_INDEX"."PATIENT_ID" ) and ( "DRUG_DISPENSE_REC"."PATIENT_ID" = "ORDERS"."PATIENT_ID" ) and ( "DRUG_DISPENSE_REC"."VISIT_ID" = "ORDERS"."VISIT_ID" ) and ( "DRUG_DISPENSE_REC"."ORDER_NO" = "ORDERS"."ORDER_NO" ) and ( "DRUG_DISPENSE_REC"."ORDER_SUB_NO" = "ORDERS"."ORDER_SUB_NO" ) and ( ( "DRUG_DISPENSE_REC"."DISPENSING_DATE_TIME" = TO_DATE('3-May-2013 10:26:32', 'DD-MON-YYYY HH24:MI:SS') ) and ( "DRUG_DISPENSE_REC"."DISPENSING_PROVIDER" = '��' ) ) ORDER BY 27 ASC, "ORDERS"."REPEAT_INDICATOR" ASC, "ORDERS"."ADMINISTRATION" ASC, "ORDERS"."START_DATE_TIME" ASC, "ORDERS"."ORDER_NO" ASC, "ORDERS"."ORDER_SUB_NO" ASC
9mrhw217pc809	select MR_CODE , mr_attr , mr_class from mr_item_index where mr_name =:1 ORDER BY mr_attr desc
a7w35qskd8cs0	SELECT 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
c3uk2whs1zv6u	select bussiness_id.nextval from dual
c69f5n7vyas9s	Select bed_no , diagnosis , patient_condition From pats_in_hospital Where Patient_id =:1 And Visit_id =:2
f0rafhx0gx5mu	SELECT 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' )
f0wzs9nc663bn	select sysdate from dual
fuj5yvndztbgb	SELECT 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' )
g2tcdkz3sy3h2	Select bed_label From bed_rec Where ward_code =:1 And bed_no =:2
g6npbj93qprkw	SELECT 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' )
gb6bmvqrgutd0	select * from ip_orderdetl_view where cfxh='020910_20130503095901' and patid='H2351'
gjx48dpm1xthj	select * from ip_orderdetl_view where cfxh='020902_20130503095500' and patid='H2274'
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 )
gpjpp9dpw6fat	SELECT 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' )
gst1kbkqmybq3	SELECT 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 = '0404' or pats_in_hospital.ward_code = '0404' )
gyhmjhna0kum7	select performed_by, sum(costs) from inp_bill_Detail where billing_Date_Time>=to_Date('01-apr-13') and billing_Date_Time<to_Date('01-may-13') and performed_by like '0206%' and costs=charges group by performed_by

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Statistic	Total	per Second	per Trans
CPU used by this session	255,360	71.25	21.29
CPU used when call started	254,320	70.96	21.20
CR blocks created	27,933	7.79	2.33
Cached Commit SCN referenced	648	0.18	0.05
Commit SCN cached	1	0.00	0.00
DB time	3,241,309	904.38	270.22
DBWR checkpoint buffers written	18,569	5.18	1.55
DBWR checkpoints	2	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	125	0.03	0.01
DBWR undo block writes	2,279	0.64	0.19
IMU CR rollbacks	2,780	0.78	0.23
IMU Flushes	1,896	0.53	0.16
IMU Redo allocation size	15,260,068	4,257.79	1,272.20
IMU commits	7,709	2.15	0.64
IMU contention	188	0.05	0.02
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	16	0.00	0.00
IMU recursive-transaction flush	44	0.01	0.00
IMU undo allocation size	50,783,928	14,169.50	4,233.76
IMU- failed to get a private strand	16	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,569,071	437.80	130.81
active txn count during cleanout	33,016	9.21	2.75
application wait time	17,754	4.95	1.48
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	14,525	4.05	1.21
branch node splits	0	0.00	0.00
buffer is not pinned count	19,609,589	5,471.38	1,634.81
buffer is pinned count	158,478,850	44,218.05	13,212.08
bytes received via SQL*Net from client	196,551,047	54,840.78	16,386.08
bytes sent via SQL*Net to client	432,493,504	120,672.37	36,056.15
calls to get snapshot scn: kcmgss	533,796	148.94	44.50
calls to kcmgas	47,009	13.12	3.92
calls to kcmgcs	1,493	0.42	0.12
change write time	470	0.13	0.04
cleanout - number of ktugct calls	28,638	7.99	2.39
cleanouts and rollbacks - consistent read gets	27,480	7.67	2.29
cleanouts only - consistent read gets	145	0.04	0.01
cluster key scan block gets	25,782	7.19	2.15
cluster key scans	6,488	1.81	0.54
commit batch performed	1	0.00	0.00
commit batch requested	1	0.00	0.00
commit batch/immediate performed	231	0.06	0.02
commit batch/immediate requested	231	0.06	0.02
commit cleanout failures: block lost	4	0.00	0.00
commit cleanout failures: buffer being written	3	0.00	0.00
commit cleanout failures: callback failure	95	0.03	0.01
commit cleanout failures: cannot pin	102	0.03	0.01
commit cleanouts	40,196	11.22	3.35
commit cleanouts successfully completed	39,992	11.16	3.33
commit immediate performed	230	0.06	0.02
commit immediate requested	230	0.06	0.02
commit txn count during cleanout	1,609	0.45	0.13
concurrency wait time	1,921,983	536.26	160.23
consistent changes	253,947	70.86	21.17
consistent gets	71,611,109	19,980.61	5,970.08
consistent gets - examination	24,817,620	6,924.50	2,069.00
consistent gets direct	0	0.00	0.00
consistent gets from cache	71,611,109	19,980.61	5,970.08
current blocks converted for CR	0	0.00	0.00
cursor authentications	2,371	0.66	0.20
data blocks consistent reads - undo records applied	252,501	70.45	21.05
db block changes	331,021	92.36	27.60
db block gets	347,041	96.83	28.93
db block gets direct	81	0.02	0.01
db block gets from cache	346,960	96.81	28.93
deferred (CURRENT) block cleanout applications	21,838	6.09	1.82
dirty buffers inspected	7	0.00	0.00
enqueue conversions	1,790	0.50	0.15
enqueue releases	82,758	23.09	6.90
enqueue requests	82,764	23.09	6.90
enqueue timeouts	18	0.01	0.00
enqueue waits	88	0.02	0.01
exchange deadlocks	1	0.00	0.00
execute count	437,668	122.12	36.49
failed probes on index block reclamation	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	23,196,038	6,472.05	1,933.81
free buffer requested	23,229,132	6,481.29	1,936.57
heap block compress	3,518	0.98	0.29
hot buffers moved to head of LRU	60,271	16.82	5.02
immediate (CR) block cleanout applications	27,625	7.71	2.30
immediate (CURRENT) block cleanout applications	3,102	0.87	0.26
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	7,322	2.04	0.61
index fast full scans (full)	351	0.10	0.03
index fetch by key	23,519,777	6,562.38	1,960.80
index scans kdiixs1	344,026	95.99	28.68
leaf node 90-10 splits	47	0.01	0.00
leaf node splits	252	0.07	0.02
lob reads	6	0.00	0.00
lob writes	159	0.04	0.01
lob writes unaligned	159	0.04	0.01
logons cumulative	1,290	0.36	0.11
messages received	23,890	6.67	1.99
messages sent	23,890	6.67	1.99
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	46,640,405	13,013.39	3,888.32
opened cursors cumulative	62,179	17.35	5.18
parse count (failures)	292	0.08	0.02
parse count (hard)	14,352	4.00	1.20
parse count (total)	449,668	125.46	37.49
parse time cpu	4,658	1.30	0.39
parse time elapsed	1,127,689	314.64	94.01
physical read IO requests	1,823,655	508.83	152.03
physical read bytes	###############	53,018,926.55	15,841,723.75
physical read total IO requests	1,836,715	512.47	153.12
physical read total bytes	###############	53,116,523.99	15,870,885.25
physical read total multi block requests	1,641,524	458.01	136.85
physical reads	23,195,981	6,472.04	1,933.80
physical reads cache	23,195,899	6,472.01	1,933.80
physical reads cache prefetch	21,372,312	5,963.21	1,781.77
physical reads direct	82	0.02	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,152	4.23	1.26
physical write bytes	154,615,808	43,140.20	12,890.02
physical write total IO requests	34,323	9.58	2.86
physical write total bytes	432,521,728	120,680.24	36,058.50
physical write total multi block requests	9,935	2.77	0.83
physical writes	18,874	5.27	1.57
physical writes direct	163	0.05	0.01
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	18,711	5.22	1.56
physical writes non checkpoint	6,139	1.71	0.51
pinned buffers inspected	7,190	2.01	0.60
prefetch clients - default	2	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,566	0.99	0.30
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	325,578	90.84	27.14
recursive cpu usage	4,698	1.31	0.39
redo blocks written	103,890	28.99	8.66
redo buffer allocation retries	15	0.00	0.00
redo entries	149,605	41.74	12.47
redo log space requests	31	0.01	0.00
redo log space wait time	1,712	0.48	0.14
redo ordering marks	1,490	0.42	0.12
redo size	49,151,992	13,714.16	4,097.71
redo subscn max counts	3,968	1.11	0.33
redo synch time	192,645	53.75	16.06
redo synch writes	9,518	2.66	0.79
redo wastage	2,348,856	655.37	195.82
redo write time	107,598	30.02	8.97
redo writer latching time	0	0.00	0.00
redo writes	8,582	2.39	0.72
rollback changes - undo records applied	12,498	3.49	1.04
rollbacks only - consistent read gets	470	0.13	0.04
rows fetched via callback	484,234	135.11	40.37
session connect time	0	0.00	0.00
session cursor cache hits	342,568	95.58	28.56
session logical reads	71,958,157	20,077.44	5,999.01
session pga memory	115,435,816	32,208.38	9,623.66
session pga memory max	236,381,160	65,953.99	19,706.64
session uga memory	###############	71,913,170.35	21,487,205.66
session uga memory max	883,921,944	246,627.87	73,690.87
shared hash latch upgrades - no wait	21,931	6.12	1.83
shared hash latch upgrades - wait	4	0.00	0.00
sorts (memory)	38,975	10.87	3.25
sorts (rows)	1,545,218	431.14	128.82
sql area evicted	22,669	6.33	1.89
sql area purged	287	0.08	0.02
summed dirty queue length	11	0.00	0.00
switch current to new buffer	3,660	1.02	0.31
table fetch by rowid	65,048,638	18,149.57	5,422.98
table fetch continued row	76,750	21.41	6.40
table scan blocks gotten	27,457,091	7,660.95	2,289.04
table scan rows gotten	2,165,178,143	604,118.14	180,506.72
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	261	0.07	0.02
table scans (short tables)	37,182	10.37	3.10
total number of times SMON posted	2	0.00	0.00
transaction rollbacks	231	0.06	0.02
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	15,035,956	4,195.26	1,253.52
user I/O wait time	321,413	89.68	26.80
user calls	1,570,249	438.12	130.91
user commits	9,386	2.62	0.78
user rollbacks	2,609	0.73	0.22
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	26,741	7.46	2.23
write clones created in background	0	0.00	0.00
write clones created in foreground	34	0.01	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	1,428,067	1,440,487
opened cursors current	1,089	1,133
workarea memory allocated	312	518
logons current	358	381

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	2	2.01

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
TSP_PHARMACY	1,760,119	491	0.93	13.09	1,498	0	1,979	3.16
TSP_OUTPBILL	29,569	8	7.29	5.09	1,836	1	0	0.00
TSP_INPBILL	10,551	3	38.00	1.00	4,053	1	18	0.00
TSP_MEDREC	10,252	3	29.40	1.46	1,286	0	1,682	11.58
TSP_OUTPADM	9,651	3	12.83	4.23	921	0	0	0.00
USERS	3,443	1	12.25	14.66	456	0	2	95.00
TSP_ORDADM	1,659	0	105.88	1.00	1,775	0	0	0.00
TSP_CPR	374	0	146.74	1.00	761	0	21	0.48
TSP_INSURANCE	692	0	68.68	7.99	428	0	0	0.00
TSP_EXAM	751	0	59.37	1.09	349	0	0	0.00
SYSAUX	444	0	101.64	1.02	480	0	0	0.00
TSP_LAB	264	0	139.89	1.00	442	0	0	0.00
TSP_INPADM	365	0	52.22	1.00	244	0	4	0.00
SYSTEM	446	0	90.52	1.09	132	0	0	0.00
UNDOTBS1	8	0	92.50	1.00	301	0	26	0.77
TSP_COMM	172	0	164.19	1.02	12	0	0	0.00
TSP_ECONSTAT	82	0	13.17	1.00	81	0	0	0.00
TSP_CARD	79	0	191.39	1.00	73	0	0	0.00
TSP_MEDADM	136	0	23.24	13.67	2	0	0	0.00
TSP_MATERIAL	46	0	79.57	1.59	6	0	0	0.00
TSP_SURGERY	7	0	180.00	1.00	14	0	0	0.00
TSP_INFO	7	0	135.71	1.14	2	0	0	0.00
TSP_ACCT	4	0	47.50	1.00	2	0	0	0.00
TSP_ASSESS	4	0	82.50	1.00	2	0	0	0.00
TSP_ASSET	4	0	117.50	1.00	2	0	0	0.00
TSP_BACK	4	0	62.50	1.00	2	0	0	0.00
TSP_BADZK	4	0	82.50	1.00	2	0	0	0.00
TSP_BLDBANK	4	0	87.50	1.00	2	0	0	0.00
TSP_EQUIPMENT	4	0	82.50	1.00	2	0	0	0.00
TSP_HACCOUNT	4	0	102.50	1.00	2	0	0	0.00
TSP_HATEMP	4	0	82.50	1.00	2	0	0	0.00
TSP_HISACCOUNT	4	0	67.50	1.00	2	0	0	0.00
TSP_INFECTION	4	0	52.50	1.00	2	0	0	0.00
TSP_INSURANCE_SUM	4	0	85.00	1.00	2	0	0	0.00
TSP_JS	4	0	90.00	1.00	2	0	0	0.00
TSP_KQMZGL	4	0	110.00	1.00	2	0	0	0.00
TSP_TUMOUR	4	0	35.00	1.00	2	0	0	0.00
TSP_YZYLS	4	0	37.50	1.00	2	0	0	0.00
TSP_ZLBR	4	0	57.50	1.00	2	0	0	0.00
XC	4	0	37.50	1.00	2	0	0	0.00
Z2002_DATA	4	0	52.50	1.00	2	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/u02/oradata/orcl/sysaux01.dbf	444	0	101.64	1.02	480	0	0	0.00
SYSTEM	/u02/oradata/orcl/system01.dbf	446	0	90.52	1.09	132	0	0	0.00
TSP_ACCT	/u02/oradata/orcl/APACCT.DBF	4	0	47.50	1.00	2	0	0	0.00
TSP_ASSESS	/u02/oradata/orcl/APASSESS.DBF	4	0	82.50	1.00	2	0	0	0.00
TSP_ASSET	/u02/oradata/orcl/ASSET.DBF	4	0	117.50	1.00	2	0	0	0.00
TSP_BACK	/u02/oradata/orcl/APBACK.DBF	4	0	62.50	1.00	2	0	0	0.00
TSP_BADZK	/u02/oradata/orcl/APBADZK.DBF	4	0	82.50	1.00	2	0	0	0.00
TSP_BLDBANK	/u02/oradata/orcl/APBLDBANK.DBF	4	0	87.50	1.00	2	0	0	0.00
TSP_CARD	/u02/oradata/orcl/APCARD.DBF	79	0	191.39	1.00	73	0	0	0.00
TSP_COMM	/u02/oradata/orcl/APCOMM.DBF	172	0	164.19	1.02	12	0	0	0.00
TSP_CPR	/u02/oradata/orcl/APCPR.DBF	374	0	146.74	1.00	761	0	21	0.48
TSP_ECONSTAT	/u02/oradata/orcl/APECONSTAT.DBF	82	0	13.17	1.00	81	0	0	0.00
TSP_EQUIPMENT	/u02/oradata/orcl/APEQUIPMENT.DBF	4	0	82.50	1.00	2	0	0	0.00
TSP_EXAM	/u02/oradata/orcl/APEXAM.DBF	751	0	59.37	1.09	349	0	0	0.00
TSP_HACCOUNT	/u02/oradata/orcl/HACCOUNT.ORA	4	0	102.50	1.00	2	0	0	0.00
TSP_HATEMP	/u02/oradata/orcl/HATEMP.ORA	4	0	82.50	1.00	2	0	0	0.00
TSP_HISACCOUNT	/u02/oradata/orcl/HISACCOUNT.DBF	4	0	67.50	1.00	2	0	0	0.00
TSP_INFECTION	/u02/oradata/ORCLINFECTION.DBF	4	0	52.50	1.00	2	0	0	0.00
TSP_INFO	/u02/oradata/orcl/APINFO.DBF	7	0	135.71	1.14	2	0	0	0.00
TSP_INPADM	/u02/oradata/orcl/APINPADM.DBF	365	0	52.22	1.00	244	0	4	0.00
TSP_INPBILL	/u02/oradata/orcl/APINPBILL.DBF	10,551	3	38.00	1.00	4,053	1	18	0.00
TSP_INSURANCE	/u02/oradata/orcl/APINSURANCE.DBF	692	0	68.68	7.99	428	0	0	0.00
TSP_INSURANCE_SUM	/u02/oradata/orcl/datafile/O1_MF_TSP_INSU_75H7Z9VT_.	4	0	85.00	1.00	2	0	0	0.00
TSP_JS	/u02/oradata/orcl/JS.DBF	4	0	90.00	1.00	2	0	0	0.00
TSP_KQMZGL	/u02/oradata/orcl/APKQMZGL.DBF	4	0	110.00	1.00	2	0	0	0.00
TSP_LAB	/u02/oradata/orcl/APLAB.DBF	264	0	139.89	1.00	442	0	0	0.00
TSP_MATERIAL	/u02/oradata/orcl/APMATERIAL.DBF	46	0	79.57	1.59	6	0	0	0.00
TSP_MEDADM	/u02/oradata/orcl/APMEDADM.DBF	136	0	23.24	13.67	2	0	0	0.00
TSP_MEDREC	/u02/oradata/orcl/APMEDREC.DBF	10,252	3	29.40	1.46	1,286	0	1,682	11.58
TSP_ORDADM	/u02/oradata/orcl/APORDADM.DBF	1,659	0	105.88	1.00	1,775	0	0	0.00
TSP_OUTPADM	/u02/oradata/orcl/APOUTPADM.DBF	9,651	3	12.83	4.23	921	0	0	0.00
TSP_OUTPBILL	/u02/oradata/orcl/APOUTPBILL.DBF	29,569	8	7.29	5.09	1,836	1	0	0.00
TSP_PHARMACY	/u02/oradata/orcl/APPHARMACY.DBF	1,760,119	491	0.93	13.09	1,498	0	1,979	3.16
TSP_SURGERY	/u02/oradata/orcl/APSURGERY.DBF	7	0	180.00	1.00	14	0	0	0.00
TSP_TUMOUR	/u02/oradata/orcl/APTUMOUR.DBF	4	0	35.00	1.00	2	0	0	0.00
TSP_YZYLS	/u02/oradata/orcl/APYZYLS.DBF	4	0	37.50	1.00	2	0	0	0.00
TSP_ZLBR	/u02/oradata/orcl/APZLBR.DBF	4	0	57.50	1.00	2	0	0	0.00
UNDOTBS1	/u02/oradata/orcl/undotbs01.dbf	8	0	92.50	1.00	301	0	26	0.77
USERS	/u02/oradata/orcl/users01.dbf	3,443	1	12.25	14.66	456	0	2	95.00
XC	/u02/oradata/orcl/XC.DBF	4	0	37.50	1.00	2	0	0	0.00
Z2002_DATA	/u02/oradata/orcl/DATA01.DBF	4	0	52.50	1.00	2	0	0	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	235,558	68	72,008,486	23,240,317	18,729	0	0	3,730

Advisory Statistics

Instance Recovery Stats
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin snapshot, E: End snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual Redo Blks	Target Redo Blks	Log File Size Redo Blks	Log Ckpt Timeout Redo Blks	Log Ckpt Interval Redo Blks
B	0	12	1845	13082	63487	184320	63487
E	0	12	1393	8817	51594	184320	51594

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers for Estimate	Est Phys Read Factor	Estimated Physical Reads
D	192	0.10	23,748	1.24	514,082,098
D	384	0.20	47,496	1.15	476,075,571
D	576	0.30	71,244	1.09	452,257,424
D	768	0.40	94,992	1.06	437,712,866
D	960	0.50	118,740	1.03	428,411,542
D	1,152	0.60	142,488	1.02	422,375,331
D	1,344	0.69	166,236	1.01	418,578,382
D	1,536	0.79	189,984	1.01	416,274,992
D	1,728	0.89	213,732	1.00	414,878,664
D	1,920	0.99	237,480	1.00	414,002,612
D	1,936	1.00	239,459	1.00	413,948,687
D	2,112	1.09	261,228	1.00	413,355,177
D	2,304	1.19	284,976	1.00	412,832,937
D	2,496	1.29	308,724	1.00	412,352,199
D	2,688	1.39	332,472	1.00	411,869,368
D	2,880	1.49	356,220	0.99	411,369,596
D	3,072	1.59	379,968	0.99	410,824,773
D	3,264	1.69	403,716	0.99	410,197,713
D	3,456	1.79	427,464	0.99	409,575,660
D	3,648	1.88	451,212	0.99	408,949,351
D	3,840	1.98	474,960	0.99	408,236,735

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	4,936	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	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 Mem	Global Mem Bound(K)
B	1,000	688	625.87	0.30	0.05	100.00	0.00	102,400
E	1,000	679	651.80	0.51	0.08	100.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	22,196	22,196
64K	128K	118	118
128K	256K	245	245
256K	512K	18	18
512K	1024K	2,044	2,044
1M	2M	2,133	2,133
2M	4M	3	3
4M	8M	1	1
8M	16M	1	1

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count
125	0.13	307,487.28	30,284.52	91.00	4,603
250	0.25	307,487.28	4,921.90	98.00	1,035
500	0.50	307,487.28	379.42	100.00	0
750	0.75	307,487.28	379.42	100.00	0
1,000	1.00	307,487.28	379.42	100.00	0
1,200	1.20	307,487.28	114.55	100.00	0
1,400	1.40	307,487.28	114.55	100.00	0
1,600	1.60	307,487.28	114.55	100.00	0
1,800	1.80	307,487.28	114.55	100.00	0
2,000	2.00	307,487.28	114.55	100.00	0
3,000	3.00	307,487.28	114.55	100.00	0
4,000	4.00	307,487.28	114.55	100.00	0
6,000	6.00	307,487.28	114.55	100.00	0
8,000	8.00	307,487.28	114.55	100.00	0

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits
768	0.38	212	28,270	1,929,263	0.81	492,799	9.28	71,873,409
976	0.48	417	38,015	2,061,058	0.87	361,004	6.80	71,984,910
1,184	0.59	623	47,109	2,181,105	0.92	240,957	4.54	72,087,408
1,392	0.69	830	56,618	2,256,635	0.95	165,427	3.12	72,159,149
1,600	0.79	1,037	69,112	2,308,997	0.97	113,065	2.13	72,215,844
1,808	0.90	1,244	81,023	2,344,768	0.99	77,294	1.46	72,261,712
2,016	1.00	1,451	91,781	2,368,977	1.00	53,085	1.00	72,299,536
2,224	1.10	1,658	102,973	2,385,355	1.01	36,707	0.69	72,331,196
2,432	1.21	1,865	114,584	2,396,526	1.01	25,536	0.48	72,358,047
2,640	1.31	2,072	127,014	2,404,209	1.01	17,853	0.34	72,381,147
2,848	1.41	2,279	139,640	2,409,478	1.02	12,584	0.24	72,401,350
3,056	1.52	2,486	153,024	2,413,057	1.02	9,005	0.17	72,419,359
3,264	1.62	2,693	164,524	2,415,540	1.02	6,522	0.12	72,435,777
3,472	1.72	2,900	175,337	2,417,442	1.02	4,620	0.09	72,451,100
3,680	1.83	3,107	188,761	2,419,117	1.02	2,945	0.06	72,465,764
3,888	1.93	3,314	200,870	2,420,724	1.02	1,338	0.03	72,480,010
4,096	2.03	3,521	212,364	2,422,327	1.02	1	0.00	72,494,175

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,000	0.25	1,047,927	508,429,635
2,000	0.50	494,616	447,287,267
3,000	0.75	296,660	423,691,363
4,000	1.00	227,326	413,963,227
5,000	1.25	203,275	409,368,235
6,000	1.50	192,932	408,788,687
7,000	1.75	182,952	403,738,335
8,000	2.00	175,723	403,738,335

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

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	3,706	26	7
undo block	26	0	1

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	8	8	0	8	182	22,696.25
CF-Controlfile Transaction	4,097	4,081	16	66	42	639.39
TX-Transaction (index contention)	16	16	0	16	2	127.50

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	2.69	16,280	2,487	11	15/52.45	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
03-May 11:03	347	1,750	881	7	26	0/0	0/0/0/0/0/0
03-May 10:53	358	2,253	280	8	16	0/0	0/0/0/0/0/0
03-May 10:43	343	1,846	2,487	10	52	0/0	0/0/0/0/0/0
03-May 10:33	337	1,947	1,886	8	42	0/0	0/0/0/0/0/0
03-May 10:23	369	2,847	1,286	11	32	0/0	0/0/0/0/0/0
03-May 10:13	433	2,841	684	8	22	0/0	0/0/0/0/0/0
03-May 10:03	505	2,796	83	9	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	2,183	0.00		0	0
AWR Alerted Metric Element list	34,420	0.00		0	0
Consistent RBA	8,616	0.00		0	0
FAL request queue	91	0.00		0	0
FAL subheap alocation	88	0.00		0	0
FIB s.o chain latch	62	0.00		0	0
FOB s.o list latch	1,858	0.05	0.00	0	0
In memory undo latch	113,709	0.02	1.00	0	10,943	0.02
JS mem alloc latch	7	0.00		0	0
JS queue access latch	7	0.00		0	0
JS queue state obj latch	25,018	0.00		0	0
JS slv state obj latch	28	0.00		0	0
KMG MMAN ready and startup request latch	1,294	0.00		0	0
KMG resize request state object freelist	15	0.00		0	0
KTF sga latch	8	0.00		0	1,121	0.00
KWQMN job cache list latch	20	0.00		0	0
MQL Tracking Latch	0			0	71	0.00
Memory Management Latch	339	0.00		0	1,294	0.00
OS process	3,687	0.00		0	0
OS process allocation	3,673	0.05	0.00	0	0
OS process: request allocation	2,448	0.08	0.00	0	0
PL/SQL warning settings	6,035	0.00		0	0
SQL memory manager latch	1	0.00		0	1,091	0.00
SQL memory manager workarea list latch	88,251	0.00		0	0
Shared B-Tree	128	0.00		0	0
active checkpoint queue latch	19,695	0.01	0.00	0	0
active service list	11,493	0.07	0.38	0	1,746	0.00
alert log latch	2	0.00		0	0
archive control	198	0.00		0	0
archive process latch	1,257	0.08	1.00	0	0
begin backup scn array	10	0.00		0	0
buffer pool	1,212	0.00		0	0
cache buffer handles	8,802	0.00		0	0
cache buffers chains	144,054,441	0.05	0.00	0	50,373,328	0.00
cache buffers lru chain	114,567	0.21	0.08	0	54,242,735	0.02
cache table scan latch	0			0	1,645,818	0.00
channel handle pool latch	2,450	0.57	0.07	0	0
channel operations parent latch	19,497	0.02	0.00	0	0
checkpoint queue latch	162,944	0.00	0.00	0	46,248	0.01
client/application info	8,769	0.00		0	0
commit callback allocation	28	0.00		0	0
compile environment latch	1,294	0.00		0	0
dml lock allocation	39,151	0.03	0.00	0	0
dummy allocation	2,566	0.16	0.00	0	0
enqueue hash chains	167,969	0.01	0.13	0	2,338	0.00
enqueues	122,137	0.18	0.14	0	0
event group latch	1,236	0.00		0	0
file cache latch	348	0.00		0	0
global KZLD latch for mem in SGA	1,226	0.00		0	0
hash table column usage latch	438	0.00		0	518,667	0.00
hash table modification latch	86	0.00		0	0
job workq parent latch	0			0	122	0.00
job_queue_processes parameter latch	118	0.00		0	0
kks stats	49,317	0.44	0.93	25	0
kokc descriptor allocation latch	50	0.00		0	0
ksuosstats global area	241	0.00		0	0
ktm global data	14	0.00		0	0
kwqbsn:qsga	128	0.00		0	0
lgwr LWN SCN	8,685	0.23	0.00	0	0
library cache	2,205,831	2.18	0.83	12905	47,354	44.45
library cache load lock	652	0.00		0	0
library cache lock	2,127,768	0.04	0.01	0	0
library cache lock allocation	11,627	0.02	0.00	0	0
library cache pin	301,399	0.04	0.02	0	0
library cache pin allocation	8,405	0.00		0	0
list of block allocation	1,742	0.00		0	0
loader state object freelist	26	0.00		0	0
longop free list parent	239	0.00		0	239	0.00
message pool operations parent latch	2	0.00		0	0
messages	87,164	0.02	0.00	0	0
mostly latch-free SCN	8,660	0.01	0.00	0	0
multiblock read objects	3,610,871	0.00	0.00	0	0
ncodef allocation latch	84	0.00		0	0
object queue header heap	19,950	0.00		0	191	0.00
object queue header operation	46,606,554	0.00	0.22	0	28,746	0.00
object stats modification	1	0.00		0	0
parallel query alloc buffer	448	0.00		0	0
parameter list	5,714	0.04	0.00	0	0
parameter table allocation management	1,298	0.62	0.38	0	0
post/wait queue	13,484	0.01	0.00	0	9,601	0.01
process allocation	2,448	2.29	1.61	1	1,235	0.08
process group creation	2,448	0.04	0.00	0	0
qmn task queue latch	512	0.00		0	0
redo allocation	48,820	0.01	0.17	0	149,514	0.16
redo copy	0			0	149,616	0.05
redo writing	48,395	0.00	0.00	0	0
resmgr group change latch	1,554	0.00		0	0
resmgr:active threads	2,563	0.00		0	0
resmgr:actses change group	1,270	0.00		0	0
resmgr:free threads list	2,562	0.31	0.00	0	0
resmgr:schema config	1	0.00		0	0
row cache objects	1,661,918	0.27	0.07	144	4,780	0.44
rules engine aggregate statistics	13	0.00		0	0
rules engine rule set statistics	26	0.00		0	0
sequence cache	21,152	0.10	0.00	0	0
session allocation	66,313	0.16	0.13	0	0
session idle bit	3,171,746	0.00	0.03	0	0
session state list latch	3,100	0.23	0.00	0	0
session switching	84	0.00		0	0
session timer	1,746	0.00		0	0
shared pool	1,542,999	4.23	0.60	6459	0
shared pool sim alloc	645	0.78	1.00	0	0
shared pool simulator	1,680,990	0.01	0.11	0	0
simulator hash latch	9,703,950	0.00	0.00	0	0
simulator lru latch	19,656	0.01	0.50	0	6,542,672	0.08
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	1	0
sort extent pool	120	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,114	0.00		0	0
transaction allocation	1,224	0.00		0	0
transaction branch allocation	1,746	0.00		0	0
undo global data	129,409	0.01	0.00	0	52	0.00
user lock	5,408	2.27	0.92	73	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	144,054,441	78,517	177	78,351
shared pool	1,542,999	65,316	39,327	30,465
library cache	2,205,831	48,034	40,040	11,324
row cache objects	1,661,918	4,406	306	4,108
library cache lock	2,127,768	840	11	829
cache buffers lru chain	114,567	241	20	221
enqueues	122,137	223	32	191
kks stats	49,317	219	204	53
shared pool simulator	1,680,990	151	17	134
library cache pin	301,399	125	2	123
user lock	5,408	123	113	13
object queue header operation	46,606,554	109	24	86
session allocation	66,313	105	14	91
session idle bit	3,171,746	90	3	87
process allocation	2,448	56	90	0
enqueue hash chains	167,969	23	3	20
In memory undo latch	113,709	20	20	1
channel handle pool latch	2,450	14	1	13
active service list	11,493	8	3	5
parameter table allocation management	1,298	8	3	5
redo allocation	48,820	6	1	5
shared pool sim alloc	645	5	5	0
simulator lru latch	19,656	2	1	1
archive process latch	1,257	1	1	0
slave class create	8	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	16	10
In memory undo latch	kticmt: child	3	6
In memory undo latch	ktichg: child	1	2
active service list	ksws_event: ksws event	5	4
archive process latch	kcrrsarc	1	0
cache buffers chains	kcbgtcr: kslbegin excl	268	216
cache buffers chains	kcbrls: kslbegin	96	147
cache buffers chains	kcbchg: kslbegin: bufs not pinned	61	56
cache buffers chains	kcbgcur: kslbegin	31	25
cache buffers chains	kcbgtcr: fast path	17	5
cache buffers chains	kcbget: pin buffer	6	3
cache buffers chains	kcbget: exchange	1	2
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
cache buffers lru chain	kcbzgws	19	0
cache buffers lru chain	kcbzar: KSLNBEGIN	1	0
channel handle pool latch	ksrchconnect()	11	11
cost function	kzulgt: find user res	68	70
cost function	kzulrl	45	43
enqueue hash chains	ksqgtl3	3	2
enqueues	ksqgel: create enqueue	17	8
enqueues	ksqdel	13	16
enqueues	ksqies	2	8
kks stats	kks stats alloc/free	204	204
library cache	kglLockCursor	9,437	8,136
library cache	kgldti: 2child	4,092	656
library cache	kglpndl: child: after processing	3,413	86
library cache	kglobpn: child:	3,002	4,338
library cache	kglhdgn: child:	1,939	8,328
library cache	kgldte: child 0	1,803	3,325
library cache	kglhdgc: child:	893	75
library cache	kglpin	641	350
library cache	kglnti	289	77
library cache	kglpnp: child	259	921
library cache	kglukp: child	257	329
library cache	kglpndl: child: before processing	241	2,020
library cache	kglati	194	30
library cache	kglobld	60	485
library cache	kglic	23	12
library cache	kglScanDependency	6	2
library cache	kglini: child	3	3
library cache	kglalt: child	1	1
library cache	kglpur: child	1	4
library cache lock	kgllkdl: child: no lock handle	4,979	4,746
library cache lock	kgllkal: child: multiinstance	6	4
library cache lock	kgllkdl: child: cleanup	5	7
library cache pin	kglpndl	2	2
object queue header operation	kcbo_switch_cq	36	4
object queue header operation	kcbw_unlink_q	4	33
object queue header operation	kcbw_link_q	2	1
parameter table allocation management	ksp_param_table_free	3	3
process allocation	ksucrp	80	0
process allocation	ksuapc	9	87
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
row cache objects	kqreqd: reget	191	2
row cache objects	kqrpre: find obj	67	282
row cache objects	kqreqd	15	3
row cache objects	kqrso	6	7
session allocation	ksuxds: KSUSFCLC not set	11	2
session allocation	ksucri	1	6
session allocation	ksudlp	1	1
session allocation	ksuxds: not user session	1	5
session idle bit	ksupuc: set busy	3	2
session idle bit	ksuxds	1	0
shared pool	kghalo	20,508	11,381
shared pool	kghupr1	7,954	21,121
shared pool	kghfrunp: alloc: wait	5,127	2,843
shared pool	kghfrunp: clatch: wait	4,775	6,121
shared pool	kghalp	4,099	2,025
shared pool	kghfrunp: clatch: nowait	3,745	0
shared pool	kghfre	1,136	1,767
shared pool	kgh_next_free	249	63
shared pool	kghasp	162	16
shared pool	kgh: quiesce extents	31	1
shared pool	kgh: add extent to quiesced list	20	3
shared pool	kghfree_extents: scan	20	92
shared pool	kghfrh	14	2
shared pool	kghquiesce: clatch: nowait	7	0
shared pool	kghfen: not perm alloc class	3	2
shared pool	kgh: add extent to reserved list	1	7
shared pool sim alloc	kglsim_chk_objlist: alloc	4	5
shared pool sim alloc	kglsim_chk_heaplist: alloc	1	0
shared pool simulator	kglsim_upd_newhp	8	0
shared pool simulator	kglsim_unpin_simhp	5	4
shared pool simulator	kglsim_unpin_simhp: fast path	2	12
shared pool simulator	kglsim_chk_heaplist: extend	1	0
shared pool simulator	kglsim_scan_lru: scan	1	1
simulator lru latch	kcbs_free_granule_sim_buffers	1	0
slave class create	ksvcreate	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

Segments by Logical Reads
Segments by Physical Reads
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 71,958,157
Captured Segments account for 97.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	25,205,136	35.03
INPADM	TSP_INPADM	PK_PATS_IN_HOSPITAL	INDEX	23,144,288	32.16
PHARMACY	TSP_PHARMACY	DRUG_PRESC_MASTER_TEMP	TABLE	10,761,440	14.96
INPBILL	TSP_INPBILL	INP_BILL_DETAIL	TABLE	4,450,816	6.19
PHARMACY	TSP_PHARMACY	PK_DRUG_PRESC_MASTER_TEMP	INDEX	1,038,272	1.44

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 23,195,981
Captured Segments account for 100.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	23,053,108	99.38
OUTPBILL	TSP_OUTPBILL	INVOICE_INFO	TABLE	100,178	0.43
PHARMACY	USERS	PRESCRIPTION	TABLE	50,323	0.22
OUTPBILL	TSP_OUTPBILL	OUTP_RCPT_MASTER	TABLE	42,860	0.18
OUTPADM	TSP_OUTPADM	CLINIC_MASTER	TABLE	38,147	0.16

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

% of Capture shows % of row lock waits for each top segment compared
with total row lock waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
CPR	TSP_CPR	PK_DOCTOR_ACTION_LOG	INDEX	10	37.04
INPBILL	TSP_INPBILL	PK_INP_BILL_DETAIL	INDEX	7	25.93
HQC	TSP_INPBILL	IND_ASACCT_STAT	INDEX	6	22.22
INPBILL	TSP_INPBILL	INP_BILL_DETAIL	TABLE	2	7.41
INPADM	TSP_INPADM	PATS_IN_HOSPITAL	TABLE	2	7.41

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

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
CPR	TSP_CPR	PK_DOCTOR_ACTION_LOG	INDEX	21	45.65
HQC	TSP_INPBILL	IND_ASACCT_STAT	INDEX	18	39.13
INPADM	TSP_INPADM	PATS_IN_HOSPITAL	TABLE	4	8.70
PHARMACY	TSP_PHARMACY	PK_IP_ORDER_STATE	INDEX	2	4.35
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	1	2.17

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	64	0.00	2	1
dc_database_links	2,454	0.00	0	1
dc_files	41	0.00	0	41
dc_global_oids	330	0.00	0	20
dc_histogram_data	160,143	0.09	0	7,274
dc_histogram_defs	57,048	0.17	0	3,641
dc_object_grants	21,801	0.00	0	374
dc_object_ids	87,003	0.01	0	1,192
dc_objects	45,607	2.02	5	6,888
dc_profiles	1,285	0.00	0	1
dc_rollback_segments	608	0.00	4	28
dc_segments	45,800	0.03	18	1,226
dc_sequences	3,103	0.00	3,103	12
dc_table_scns	731	0.00	0	4
dc_tablespaces	81,444	0.00	0	43
dc_usernames	29,891	0.05	0	559
dc_users	151,339	0.01	0	828
outstanding_alerts	531	1.13	13	84

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	743	0.00	5,319	0.00	0	0
CLUSTER	181	0.00	311	0.00	0	0
INDEX	7	0.00	38	0.00	0	0
SQL AREA	98,855	26.62	1,327,444	3.15	1,235	73
TABLE/PROCEDURE	12,724	6.74	150,171	0.18	128	0
TRIGGER	1,142	0.09	22,711	0.03	5	0

Memory Statistics

Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Process Memory Summary

B: Begin snap E: End snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	351.37		0.98	2.78	44	45	360	360
	Freeable	261.25	0.00	0.85	0.37	5		307	307
	PL/SQL	8.29	6.32	0.02	0.02	0	0	358	358
	SQL	5.23	2.64	0.02	0.03	0	9	347	341
E	Other	367.12		0.96	2.70	44	45	383	383
	Freeable	270.50	0.00	0.85	0.36	5		319	319
	PL/SQL	8.44	6.38	0.02	0.02	0	0	381	381
	SQL	5.60	2.86	0.02	0.03	1	9	370	365

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,828,716,544	2,030,043,136
Fixed Size	2,089,240
Redo Buffers	14,684,160
Variable Size	2,348,814,056	2,147,487,464

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	CCursor	419.19	469.68	12.04
shared	KGH: NO ACCESS	770.04	770.04	0.00
shared	PCursor	149.26	157.99	5.85
shared	free memory	568.06	486.33	-14.39
shared	kglsim object batch		30.70
shared	library cache	93.26	95.88	2.81
shared	sql area	664.55	513.83	-22.68
shared	sql area:PLSQL	61.43	49.32	-19.70
	buffer_cache	1,744.00	1,936.00	11.01
	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

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

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.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
archive_lag_target	1800
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

End of Report

% Blocks changed per Read:	0.46	Recursive Call %:	17.17
Rollback per transaction %:	21.75	Rows per Sort:	39.65

Buffer Nowait %:	99.99	Redo NoWait %:	99.98
Buffer Hit %:	67.76	In-memory Sort %:	100.00
Library Hit %:	97.21	Soft Parse %:	96.81
Execute to Parse %:	-2.74	Latch Hit %:	99.91
Parse CPU to Parse Elapsd %:	0.41	% Non-Parse CPU:	98.17