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: 8277 04-Feb-13 10:00:43 383 3.1

End Snap: 8278 04-Feb-13 11:00:49 395 2.8

Elapsed: 60.11 (mins)

DB Time: 93.61 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	8277	04-Feb-13 10:00:43	383	3.1
End Snap:	8278	04-Feb-13 11:00:49	395	2.8
Elapsed:		60.11 (mins)
DB Time:		93.61 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,552M 1,552M Std Block Size: 8K

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

	Begin	End
Buffer Cache:	1,552M	1,552M	Std Block Size:	8K
Shared Pool Size:	2,384M	2,384M	Log Buffer:	14,340K

Load Profile

Per Second Per Transaction

Redo size: 11,961.70 3,778.90

Logical reads: 20,896.59 6,601.58

Block changes: 79.98 25.27

Physical reads: 3,370.89 1,064.92

Physical writes: 4.43 1.40

User calls: 411.18 129.90

Parses: 131.38 41.51

Hard parses: 2.81 0.89

Sorts: 13.85 4.38

Logons: 0.39 0.12

Executes: 122.08 38.57

Transactions: 3.17

	Per Second	Per Transaction
Redo size:	11,961.70	3,778.90
Logical reads:	20,896.59	6,601.58
Block changes:	79.98	25.27
Physical reads:	3,370.89	1,064.92
Physical writes:	4.43	1.40
User calls:	411.18	129.90
Parses:	131.38	41.51
Hard parses:	2.81	0.89
Sorts:	13.85	4.38
Logons:	0.39	0.12
Executes:	122.08	38.57
Transactions:	3.17

% Blocks changed per Read: 0.38 Recursive Call %: 19.24

Rollback per transaction %: 23.16 Rows per Sort: 30.61

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.95

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

Library Hit %: 97.55 Soft Parse %: 97.86

Execute to Parse %: -7.62 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 6.48 % Non-Parse CPU: 97.55

Shared Pool Statistics

Begin End

Memory Usage %: 61.75 59.99

% SQL with executions>1: 61.81 68.36

% Memory for SQL w/exec>1: 68.77 71.61

	Begin	End
Memory Usage %:	61.75	59.99
% SQL with executions>1:	61.81	68.36
% Memory for SQL w/exec>1:	68.77	71.61

Top 5 Timed Events

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

CPU time 1,751 31.2

db file scattered read 791,033 1,046 1 18.6 User I/O

log file sync 9,023 1,038 115 18.5 Commit

latch: library cache 2,086 612 293 10.9 Concurrency

db file sequential read 37,635 574 15 10.2 User I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		1,751		31.2
db file scattered read	791,033	1,046	1	18.6	User I/O
log file sync	9,023	1,038	115	18.5	Commit
latch: library cache	2,086	612	293	10.9	Concurrency
db file sequential read	37,635	574	15	10.2	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): 5616.7s
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
sql execute elapsed time	3,452.29	61.46
DB CPU	1,750.70	31.17
parse time elapsed	668.82	11.91
hard parse elapsed time	312.22	5.56
connection management call elapsed time	50.52	0.90
PL/SQL execution elapsed time	43.25	0.77
PL/SQL compilation elapsed time	25.55	0.45
hard parse (sharing criteria) elapsed time	7.77	0.14
failed parse elapsed time	4.45	0.08
hard parse (bind mismatch) elapsed time	0.71	0.01
sequence load elapsed time	0.60	0.01
repeated bind elapsed time	0.05	0.00
DB time	5,616.70
background elapsed time	2,076.15
background cpu time	23.31

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
User I/O	829,797	0.00	1,624	2	72.68
System I/O	24,786	0.00	1,043	42	2.17
Commit	9,023	1.39	1,038	115	0.79
Concurrency	5,305	12.93	897	169	0.46
Application	1,943	4.27	250	129	0.17
Other	402	3.23	43	107	0.04
Configuration	35	60.00	26	741	0.00
Network	1,705,505	0.00	14	0	149.38

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
db file scattered read	791,033	0.00	1,046	1	69.29
log file sync	9,023	1.39	1,038	115	0.79
latch: library cache	2,086	0.00	612	293	0.18
db file sequential read	37,635	0.00	574	15	3.30
log file parallel write	8,525	0.00	515	60	0.75
control file parallel write	3,298	0.00	401	122	0.29
latch: shared pool	2,399	0.00	269	112	0.21
enq: TX - row lock contention	87	95.40	249	2867	0.01
control file sequential read	12,788	0.00	118	9	1.12
enq: CF - contention	76	1.32	32	415	0.01
log file switch (private strand flush incomplete)	35	60.00	26	741	0.00
SQL*Net more data to client	214,395	0.00	10	0	18.78
latch free	232	0.00	8	33	0.02
cursor: pin S wait on X	682	100.00	7	11	0.06
log file sequential read	66	0.00	6	94	0.01
os thread startup	9	44.44	6	631	0.00
read by other session	967	0.00	4	5	0.08
ARCH wait on c/f tx acquire 2	3	100.00	3	978	0.00
latch: row cache objects	49	0.00	2	45	0.00
Log archive I/O	105	0.00	2	19	0.01
ARCH wait on SENDREQ	60	0.00	2	32	0.01
SQL*Net message to client	1,485,715	0.00	1	0	130.13
latch: cache buffers chains	49	0.00	1	16	0.00
SQL*Net break/reset to client	1,856	0.00	1	0	0.16
log file single write	4	0.00	1	136	0.00
SQL*Net more data from client	5,335	0.00	0	0	0.47
library cache load lock	7	0.00	0	56	0.00
latch: enqueue hash chains	2	0.00	0	176	0.00
rdbms ipc reply	21	0.00	0	9	0.00
LGWR wait for redo copy	29	31.03	0	4	0.00
latch: session allocation	18	0.00	0	4	0.00
latch: library cache lock	4	0.00	0	13	0.00
enq: TX - index contention	1	0.00	0	20	0.00
latch: object queue header operation	11	0.00	0	1	0.00
buffer busy waits	16	0.00	0	0	0.00
latch: cache buffers lru chain	8	0.00	0	0	0.00
row cache lock	2	0.00	0	0	0.00
direct path read	80	0.00	0	0	0.01
direct path write	82	0.00	0	0	0.01
cursor: pin S	2	0.00	0	0	0.00
latch: In memory undo latch	1	0.00	0	0	0.00
SQL*Net message from client	1,485,703	0.00	833,139	561	130.13
Streams AQ: qmn slave idle wait	129	0.00	3,515	27246	0.01
Streams AQ: qmn coordinator idle wait	258	50.00	3,515	13623	0.02
virtual circuit status	120	100.00	3,488	29069	0.01
jobq slave wait	1,195	95.06	3,475	2908	0.10
Streams AQ: waiting for time management or cleanup tasks	17	64.71	2,298	135189	0.00
class slave wait	2	0.00	0	0	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,525	0.00	515	60	0.75
control file parallel write	3,298	0.00	401	122	0.29
control file sequential read	12,118	0.00	118	10	1.06
events in waitclass Other	119	10.92	34	290	0.01
latch: library cache	17	0.00	19	1090	0.00
log file sequential read	66	0.00	6	94	0.01
os thread startup	9	44.44	6	631	0.00
db file sequential read	53	0.00	3	62	0.00
latch: shared pool	21	0.00	3	122	0.00
Log archive I/O	105	0.00	2	19	0.01
ARCH wait on SENDREQ	60	0.00	2	32	0.01
log file single write	4	0.00	1	136	0.00
direct path read	80	0.00	0	0	0.01
direct path write	81	0.00	0	0	0.01
buffer busy waits	1	0.00	0	0	0.00
rdbms ipc message	22,784	64.62	45,607	2002	2.00
pmon timer	1,656	99.82	3,520	2126	0.15
Streams AQ: qmn slave idle wait	129	0.00	3,515	27246	0.01
Streams AQ: qmn coordinator idle wait	258	50.00	3,515	13623	0.02
smon timer	15	66.67	3,342	222788	0.00
Streams AQ: waiting for time management or cleanup tasks	17	64.71	2,298	135189	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	219,281
IDLE_TIME	2,666,900
IOWAIT_TIME	312,417
NICE_TIME	30
SYS_TIME	83,104
USER_TIME	131,584
LOAD	1
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
SYS$USERS	2,826.50	1,446.00	11,743,695	39,029,407
orcl	2,790.40	304.70	414,020	36,309,756
SYS$BACKGROUND	0.00	0.00	498	31,040
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
SYS$USERS	789828	117657	1265	18653	301153	99
orcl	39369	42984	3914	67709	1398509	1087
SYS$BACKGROUND	598	1739	48	2676	60	194

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
404	286	24	16.85	7.20	bypnnm362j4xm	JDBC Thin Client	select * from ip_orderdetl_vie...
404	279	23	17.56	7.19	1unbgjfg781rp	JDBC Thin Client	select * from ip_orderdetl_vie...
228	0	24	9.50	4.06	cvbpcq9vqujwa	C:\Documents and Settings\dyyy\��\�ֹ�.lnk	INSERT INTO INP_SETTLE_MASTER ...
50	31	3	16.62	0.89	0kk8f5msx1zcr	JDBC Thin Client	select * from ip_orderdetl_vie...
47	2	2,567	0.02	0.84	4yffxmsh6n03q	doctws.exe	BEGIN SYS.DBMS_DESCRIBE.DESCRI...
46	8	5	9.17	0.82	13djyagwwyv85	hisquery.exe	SELECT "OUTP_RCPT_MASTER"."R...
44	33	3	14.75	0.79	6397cu0zs2xgj	JDBC Thin Client	select * from ip_orderdetl_vie...
43	15	1	43.37	0.77	gsdx8vz824gup	JDBC Thin Client	select * from ip_orderdetl_vie...
40	32	402	0.10	0.71	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
35	35	2,352	0.02	0.63	gnp1u7yqu2skn	C:\Documents and Settings\dyyy.JW\��\ҩ�ִ��.	SELECT "DRUG_PRESC_MASTER_T...

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
286	404	24	11.92	7.20	bypnnm362j4xm	JDBC Thin Client	select * from ip_orderdetl_vie...
279	404	23	12.14	7.19	1unbgjfg781rp	JDBC Thin Client	select * from ip_orderdetl_vie...
35	35	2,352	0.01	0.63	gnp1u7yqu2skn	C:\Documents and Settings\dyyy.JW\��\ҩ�ִ��.	SELECT "DRUG_PRESC_MASTER_T...
33	44	3	10.87	0.79	6397cu0zs2xgj	JDBC Thin Client	select * from ip_orderdetl_vie...
32	40	402	0.08	0.71	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
31	50	3	10.22	0.89	0kk8f5msx1zcr	JDBC Thin Client	select * from ip_orderdetl_vie...
19	26	1	18.86	0.46	38v06d1jpsu8j	JDBC Thin Client	select * from ip_orderdetl_vie...
18	25	1	18.40	0.45	64bgpa5anz3kb	JDBC Thin Client	select * from ip_orderdetl_vie...
18	25	1	17.93	0.44	7pbcadvmmyyuv	JDBC Thin Client	select * from ip_orderdetl_vie...
17	18	493	0.04	0.33	c9upy0ncw29a2	obilling.exe	SELECT OWNER, SYNONYM_NAME FR...
0	228	24	0.00	4.06	cvbpcq9vqujwa	C:\Documents and Settings\dyyy\��\�ֹ�.lnk	INSERT INTO INP_SETTLE_MASTER ...

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: 75,370,216
Captured SQL account for 33.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
12,697,251	2,352	5,398.49	16.85	34.77	35.39	gnp1u7yqu2skn	C:\Documents and Settings\dyyy.JW\��\ҩ�ִ��.	SELECT "DRUG_PRESC_MASTER_T...
2,514,571	24	104,773.79	3.34	286.00	404.42	bypnnm362j4xm	JDBC Thin Client	select * from ip_orderdetl_vie...
2,409,892	23	104,777.91	3.20	279.11	403.94	1unbgjfg781rp	JDBC Thin Client	select * from ip_orderdetl_vie...
800,530	2	400,265.00	1.06	1.67	1.95	1uy75r85n5a09	pb60.exe	SELECT SYNONYM_NAME FROM SYS.A...
799,911	402	1,989.83	1.06	31.88	40.02	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
451,588	493	916.00	0.60	14.78	14.99	6d6gz2jf8vjrj	obilling.exe	SELECT TABLE_OWNER, TABLE_NAM...
451,588	493	916.00	0.60	17.35	18.33	c9upy0ncw29a2	obilling.exe	SELECT OWNER, SYNONYM_NAME FR...
400,273	1	400,273.00	0.53	0.83	0.90	c00cukh3367c4	pb60.exe	SELECT SYNONYM_NAME FROM SYS.A...
400,267	1	400,267.00	0.53	0.84	0.96	3w371ssx9wtn8	pb60.exe	SELECT SYNONYM_NAME FROM SYS.A...
400,232	1	400,232.00	0.53	0.84	1.00	4cxagqfvnxbrk	pb60.exe	SELECT SYNONYM_NAME FROM SYS.A...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 12,158,207
Captured SQL account for 64.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
2,345,192	24	97,716.33	19.29	286.00	404.42	bypnnm362j4xm	JDBC Thin Client	select * from ip_orderdetl_vie...
2,337,239	23	101,619.09	19.22	279.11	403.94	1unbgjfg781rp	JDBC Thin Client	select * from ip_orderdetl_vie...
312,835	3	104,278.33	2.57	30.67	49.86	0kk8f5msx1zcr	JDBC Thin Client	select * from ip_orderdetl_vie...
312,829	3	104,276.33	2.57	32.62	44.26	6397cu0zs2xgj	JDBC Thin Client	select * from ip_orderdetl_vie...
104,323	1	104,323.00	0.86	18.40	25.18	64bgpa5anz3kb	JDBC Thin Client	select * from ip_orderdetl_vie...
104,322	1	104,322.00	0.86	14.53	19.14	ayzqx6c0zbtnk	JDBC Thin Client	select * from ip_orderdetl_vie...
104,322	1	104,322.00	0.86	15.32	43.37	gsdx8vz824gup	JDBC Thin Client	select * from ip_orderdetl_vie...
104,321	1	104,321.00	0.86	16.37	23.44	d4z68q3kg7qqn	JDBC Thin Client	select * from ip_orderdetl_vie...
104,320	1	104,320.00	0.86	18.86	26.00	38v06d1jpsu8j	JDBC Thin Client	select * from ip_orderdetl_vie...
104,320	1	104,320.00	0.86	17.93	24.84	7pbcadvmmyyuv	JDBC Thin Client	select * from ip_orderdetl_vie...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 440,332
Captured SQL account for 57.4% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
48,321	5,659	0.12	664crkjw8n47y	doctws.exe	select dept_code , ward_code ...
48,321	5,659	0.12	g2tcdkz3sy3h2	doctws.exe	Select bed_label From bed_rec ...
45,249	2,587	0.06	c69f5n7vyas9s	doctws.exe	Select bed_no , diagnosis , ...
19,404	19,397	1.00	4srur5p7sxdu3	doctws.exe	select user_name from comm.use...
11,384	11,369	1.00	4pwnt0hgg2ghr	doctws.exe	select administration_code fro...
9,046	9,046	1.00	f0wzs9nc663bn	doctws.exe	select sysdate from dual
8,466	12,523	1.48	0h6b2sajwb74n		select privilege#, level from ...
6,315	6,315	1.00	a7w35qskd8cs0	chglst.exe	SELECT MIN ( CLASS_ON_INP_RCPT...
4,733	4,639	0.98	5h8hkpq3q5g41	doctws.exe	SELECT TOPIC , ITEM_CLASS , ...
3,903	3,903	1.00	dfkbzk7xnk7hv	aspnet_wp.exe	SELECT dept_name FROM comm.dep...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 473,873
Captured SQL account for 66.3% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
64,812	48,321	13.68	664crkjw8n47y	doctws.exe	select dept_code , ward_code ...
64,812	48,321	13.68	g2tcdkz3sy3h2	doctws.exe	Select bed_label From bed_rec ...
61,661	45,249	13.01	c69f5n7vyas9s	doctws.exe	Select bed_no , diagnosis , ...
28,366	19,404	5.99	4srur5p7sxdu3	doctws.exe	select user_name from comm.use...
11,384	11,384	2.40	4pwnt0hgg2ghr	doctws.exe	select administration_code fro...
9,171	9,046	1.94	f0wzs9nc663bn	doctws.exe	select sysdate from dual
8,464	8,466	1.79	0h6b2sajwb74n		select privilege#, level from ...
6,315	6,315	1.33	a7w35qskd8cs0	chglst.exe	SELECT MIN ( CLASS_ON_INP_RCPT...
5,533	4,733	1.17	5h8hkpq3q5g41	doctws.exe	SELECT TOPIC , ITEM_CLASS , ...
3,903	3,903	0.82	dfkbzk7xnk7hv	aspnet_wp.exe	SELECT dept_name FROM comm.dep...

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
25	1,978	1g8brz25xjs3j	nursws.exe	SELECT CHARGE_TYPE, INSURANCE...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

0kk8f5msx1zcr select * from ip_orderdetl_view where cfxh='020902_20130204100532' and patid='H2321'

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

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

1unbgjfg781rp select * from ip_orderdetl_view where cfxh='020902_20130204101302' and patid='H2426'

1uy75r85n5a09 SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_BILL_ITEMS' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'VISIT_NO'

38v06d1jpsu8j select * from ip_orderdetl_view where cfxh='020902_20130204103533' and patid='H2430'

3w371ssx9wtn8 SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_ORDER_DESC' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'PATIENT_ID'

4cxagqfvnxbrk SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_BILL_ITEMS' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'OUTP_ID'

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

6397cu0zs2xgj select * from ip_orderdetl_view where cfxh='020902_20130204100536' and patid='H2253'

64bgpa5anz3kb select * from ip_orderdetl_view where cfxh='020902_20130204103406' and patid='H2421'

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

6d6gz2jf8vjrj SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'PRICE_ITEM_NAME_DICT' AND (DB_LINK IS NULL OR DB_LINK = '')

7pbcadvmmyyuv select * from ip_orderdetl_view where cfxh='020902_20130204103412' and patid='H2421'

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

a7w35qskd8cs0 SELECT MIN ( CLASS_ON_INP_RCPT ) FROM PRICE_LIST WHERE ITEM_CLASS =:1 AND ITEM_CODE =:2

ayzqx6c0zbtnk select * from ip_orderdetl_view where cfxh='020902_20130204103331' and patid='H2271'

bypnnm362j4xm select * from ip_orderdetl_view where cfxh='020902_20130204101302' and patid='H2301'

c00cukh3367c4 SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_BILL_ITEMS' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'ITEM_BASE'

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

c9upy0ncw29a2 SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'PRICE_ITEM_NAME_DICT'

cvbpcq9vqujwa INSERT INTO INP_SETTLE_MASTER ( RCPT_NO , PATIENT_ID , VISIT_ID , SETTLING_DATE , COSTS , CHARGES , PAYMENTS , REDUCED_CAUSE , TRANSACT_TYPE , OPERATOR_NO ) VALUES ( :1 , :2 , :3 , :4 , :5 , :6 , :7 , '' , '��' , :8 )

d4z68q3kg7qqn select * from ip_orderdetl_view where cfxh='020902_20130204103511' and patid='H2281'

dfkbzk7xnk7hv SELECT dept_name FROM comm.dept_dict WHERE dept_code='040607'

f0wzs9nc663bn select sysdate from dual

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

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 )

gsdx8vz824gup select * from ip_orderdetl_view where cfxh='020902_20130204103538' and patid='H2273'

SQL Id	SQL Text
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0kk8f5msx1zcr	select * from ip_orderdetl_view where cfxh='020902_20130204100532' and patid='H2321'
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 ) )
1g8brz25xjs3j	SELECT CHARGE_TYPE, INSURANCE_TYPE FROM PAT_VISIT WHERE PATIENT_ID = :B2 AND VISIT_ID = :B1
1unbgjfg781rp	select * from ip_orderdetl_view where cfxh='020902_20130204101302' and patid='H2426'
1uy75r85n5a09	SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_BILL_ITEMS' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'VISIT_NO'
38v06d1jpsu8j	select * from ip_orderdetl_view where cfxh='020902_20130204103533' and patid='H2430'
3w371ssx9wtn8	SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_ORDER_DESC' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'PATIENT_ID'
4cxagqfvnxbrk	SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_BILL_ITEMS' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'OUTP_ID'
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
6397cu0zs2xgj	select * from ip_orderdetl_view where cfxh='020902_20130204100536' and patid='H2253'
64bgpa5anz3kb	select * from ip_orderdetl_view where cfxh='020902_20130204103406' and patid='H2421'
664crkjw8n47y	select dept_code , ward_code from pats_in_hospital where patient_id =:1 and visit_id =:2
6d6gz2jf8vjrj	SELECT TABLE_OWNER, TABLE_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'PRICE_ITEM_NAME_DICT' AND (DB_LINK IS NULL OR DB_LINK = '')
7pbcadvmmyyuv	select * from ip_orderdetl_view where cfxh='020902_20130204103412' and patid='H2421'
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)))
a7w35qskd8cs0	SELECT MIN ( CLASS_ON_INP_RCPT ) FROM PRICE_LIST WHERE ITEM_CLASS =:1 AND ITEM_CODE =:2
ayzqx6c0zbtnk	select * from ip_orderdetl_view where cfxh='020902_20130204103331' and patid='H2271'
bypnnm362j4xm	select * from ip_orderdetl_view where cfxh='020902_20130204101302' and patid='H2301'
c00cukh3367c4	SELECT SYNONYM_NAME FROM SYS.ALL_SYNONYMS S, SYS.ALL_TAB_COLUMNS T WHERE S.OWNER IN ('SYSTEM', 'PUBLIC') AND S.SYNONYM_NAME = 'OUTP_BILL_ITEMS' AND S.TABLE_OWNER = T.OWNER AND S.TABLE_NAME = T.TABLE_NAME AND T.COLUMN_NAME = 'ITEM_BASE'
c69f5n7vyas9s	Select bed_no , diagnosis , patient_condition From pats_in_hospital Where Patient_id =:1 And Visit_id =:2
c9upy0ncw29a2	SELECT OWNER, SYNONYM_NAME FROM SYS.ALL_SYNONYMS WHERE OWNER = 'PUBLIC' AND SYNONYM_NAME = 'PRICE_ITEM_NAME_DICT'
cvbpcq9vqujwa	INSERT INTO INP_SETTLE_MASTER ( RCPT_NO , PATIENT_ID , VISIT_ID , SETTLING_DATE , COSTS , CHARGES , PAYMENTS , REDUCED_CAUSE , TRANSACT_TYPE , OPERATOR_NO ) VALUES ( :1 , :2 , :3 , :4 , :5 , :6 , :7 , '' , '��' , :8 )
d4z68q3kg7qqn	select * from ip_orderdetl_view where cfxh='020902_20130204103511' and patid='H2281'
dfkbzk7xnk7hv	SELECT dept_name FROM comm.dept_dict WHERE dept_code='040607'
f0wzs9nc663bn	select sysdate from dual
g2tcdkz3sy3h2	Select bed_label From bed_rec Where ward_code =:1 And bed_no =:2
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 )
gsdx8vz824gup	select * from ip_orderdetl_view where cfxh='020902_20130204103538' and patid='H2273'

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	174,829	48.47	15.31
CPU used when call started	174,500	48.38	15.28
CR blocks created	2,563	0.71	0.22
Cached Commit SCN referenced	180	0.05	0.02
Commit SCN cached	1	0.00	0.00
DB time	932,847	258.63	81.71
DBWR checkpoint buffers written	15,862	4.40	1.39
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 thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	122	0.03	0.01
DBWR undo block writes	2,341	0.65	0.21
IMU CR rollbacks	508	0.14	0.04
IMU Flushes	1,849	0.51	0.16
IMU Redo allocation size	16,493,580	4,572.89	1,444.65
IMU commits	7,231	2.00	0.63
IMU contention	43	0.01	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	38	0.01	0.00
IMU recursive-transaction flush	38	0.01	0.00
IMU undo allocation size	58,907,744	16,332.33	5,159.65
IMU- failed to get a private strand	38	0.01	0.00
Misses for writing mapping	0	0.00	0.00
SMON posted for undo segment shrink	3	0.00	0.00
SQL*Net roundtrips to/from client	1,481,686	410.80	129.78
active txn count during cleanout	3,278	0.91	0.29
application wait time	25,000	6.93	2.19
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	14,915	4.14	1.31
branch node splits	0	0.00	0.00
buffer is not pinned count	29,530,497	8,187.41	2,586.54
buffer is pinned count	164,117,055	45,501.88	14,374.80
bytes received via SQL*Net from client	199,806,883	55,396.98	17,500.82
bytes sent via SQL*Net to client	612,435,424	169,799.32	53,642.41
calls to get snapshot scn: kcmgss	541,056	150.01	47.39
calls to kcmgas	18,901	5.24	1.66
calls to kcmgcs	1,721	0.48	0.15
change write time	647	0.18	0.06
cleanout - number of ktugct calls	3,359	0.93	0.29
cleanouts and rollbacks - consistent read gets	2,431	0.67	0.21
cleanouts only - consistent read gets	116	0.03	0.01
cluster key scan block gets	59,505	16.50	5.21
cluster key scans	17,319	4.80	1.52
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	339	0.09	0.03
commit batch/immediate requested	339	0.09	0.03
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	3	0.00	0.00
commit cleanout failures: callback failure	68	0.02	0.01
commit cleanout failures: cannot pin	24	0.01	0.00
commit cleanouts	35,383	9.81	3.10
commit cleanouts successfully completed	35,288	9.78	3.09
commit immediate performed	339	0.09	0.03
commit immediate requested	339	0.09	0.03
commit txn count during cleanout	1,453	0.40	0.13
concurrency wait time	89,039	24.69	7.80
consistent changes	13,683	3.79	1.20
consistent gets	75,045,161	20,806.47	6,573.11
consistent gets - examination	37,939,485	10,518.82	3,323.07
consistent gets direct	0	0.00	0.00
consistent gets from cache	75,045,161	20,806.47	6,573.11
current blocks converted for CR	5	0.00	0.00
cursor authentications	5,924	1.64	0.52
data blocks consistent reads - undo records applied	13,347	3.70	1.17
db block changes	288,473	79.98	25.27
db block gets	325,055	90.12	28.47
db block gets direct	18	0.00	0.00
db block gets from cache	325,037	90.12	28.47
deferred (CURRENT) block cleanout applications	19,406	5.38	1.70
dirty buffers inspected	25	0.01	0.00
doubling up with imu segment	0	0.00	0.00
enqueue conversions	1,865	0.52	0.16
enqueue deadlocks	0	0.00	0.00
enqueue releases	75,299	20.88	6.60
enqueue requests	75,314	20.88	6.60
enqueue timeouts	15	0.00	0.00
enqueue waits	54	0.01	0.00
exchange deadlocks	0	0.00	0.00
execute count	440,332	122.08	38.57
failed probes on index block reclamation	1	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	12,164,592	3,372.66	1,065.48
free buffer requested	12,164,950	3,372.76	1,065.51
heap block compress	5,743	1.59	0.50
hot buffers moved to head of LRU	46,740	12.96	4.09
immediate (CR) block cleanout applications	2,547	0.71	0.22
immediate (CURRENT) block cleanout applications	3,207	0.89	0.28
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	7,310	2.03	0.64
index fast full scans (full)	272	0.08	0.02
index fetch by key	33,007,471	9,151.41	2,891.08
index scans kdiixs1	1,956,547	542.46	171.37
leaf node 90-10 splits	36	0.01	0.00
leaf node splits	214	0.06	0.02
lob reads	93	0.03	0.01
lob writes	138	0.04	0.01
lob writes unaligned	138	0.04	0.01
logons cumulative	1,404	0.39	0.12
messages received	20,425	5.66	1.79
messages sent	20,425	5.66	1.79
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	36,929,772	10,238.88	3,234.63
opened cursors cumulative	65,955	18.29	5.78
parse count (failures)	386	0.11	0.03
parse count (hard)	10,143	2.81	0.89
parse count (total)	473,873	131.38	41.51
parse time cpu	4,281	1.19	0.37
parse time elapsed	66,072	18.32	5.79
physical read IO requests	828,700	229.76	72.58
physical read bytes	99,600,031,744	27,614,369.27	8,723,835.66
physical read total IO requests	841,655	233.35	73.72
physical read total bytes	99,925,133,312	27,704,504.53	8,752,310.88
physical read total multi block requests	791,147	219.35	69.30
physical reads	12,158,207	3,370.89	1,064.92
physical reads cache	12,158,127	3,370.87	1,064.91
physical reads cache prefetch	11,329,507	3,141.14	992.34
physical reads direct	80	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	11,891	3.30	1.04
physical write bytes	130,965,504	36,310.53	11,471.10
physical write total IO requests	30,432	8.44	2.67
physical write total bytes	397,446,144	110,192.98	34,811.78
physical write total multi block requests	9,560	2.65	0.84
physical writes	15,987	4.43	1.40
physical writes direct	98	0.03	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	15,889	4.41	1.39
physical writes non checkpoint	4,268	1.18	0.37
pinned buffers inspected	356	0.10	0.03
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	18	0.00	0.00
process last non-idle time	3,587	0.99	0.31
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	353,257	97.94	30.94
recursive cpu usage	4,042	1.12	0.35
redo blocks written	91,517	25.37	8.02
redo buffer allocation retries	25	0.01	0.00
redo entries	106,302	29.47	9.31
redo log space requests	48	0.01	0.00
redo log space wait time	2,656	0.74	0.23
redo ordering marks	1,491	0.41	0.13
redo size	43,143,688	11,961.70	3,778.90
redo subscn max counts	3,822	1.06	0.33
redo synch time	106,934	29.65	9.37
redo synch writes	8,947	2.48	0.78
redo wastage	2,146,964	595.25	188.05
redo write time	52,693	14.61	4.62
redo writer latching time	12	0.00	0.00
redo writes	8,524	2.36	0.75
rollback changes - undo records applied	7,928	2.20	0.69
rollbacks only - consistent read gets	138	0.04	0.01
rows fetched via callback	4,473,280	1,240.23	391.81
session connect time	0	0.00	0.00
session cursor cache hits	375,707	104.17	32.91
session logical reads	75,370,216	20,896.59	6,601.58
session pga memory	116,157,360	32,204.93	10,174.07
session pga memory max	261,444,368	72,486.13	22,899.57
session uga memory	###############	73,841,850.98	23,327,861.18
session uga memory max	975,833,784	270,552.47	85,472.00
shared hash latch upgrades - no wait	61,024	16.92	5.35
shared hash latch upgrades - wait	2	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	49,955	13.85	4.38
sorts (rows)	1,529,141	423.96	133.94
sql area evicted	9,265	2.57	0.81
sql area purged	176	0.05	0.02
summed dirty queue length	28	0.01	0.00
switch current to new buffer	2,606	0.72	0.23
table fetch by rowid	66,495,346	18,436.01	5,824.24
table fetch continued row	53,916	14.95	4.72
table scan blocks gotten	15,498,334	4,296.95	1,357.48
table scan rows gotten	1,252,508,184	347,261.17	109,705.54
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	154	0.04	0.01
table scans (short tables)	40,943	11.35	3.59
total number of times SMON posted	5	0.00	0.00
transaction rollbacks	339	0.09	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	14,365,948	3,983.00	1,258.29
user I/O wait time	162,380	45.02	14.22
user calls	1,483,069	411.18	129.90
user commits	8,773	2.43	0.77
user rollbacks	2,644	0.73	0.23
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	37,172	10.31	3.26
write clones created in background	0	0.00	0.00
write clones created in foreground	16	0.00	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	7,802,168	7,815,112
opened cursors current	1,176	1,121
logons current	383	395

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.00

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	777,688	216	1.29	15.42	1,010	0	965	4.84
TSP_OUTPBILL	27,101	8	2.81	2.50	1,539	0	0	0.00
TSP_OUTPADM	6,352	2	12.62	6.98	785	0	0	0.00
TSP_MEDREC	5,830	2	24.15	1.32	1,227	0	0	0.00
TSP_INPBILL	4,590	1	18.49	1.00	2,088	1	2	0.00
USERS	2,847	1	9.09	14.30	340	0	0	0.00
TSP_ORDADM	1,272	0	47.22	1.00	1,787	0	0	0.00
SYSTEM	1,128	0	43.27	1.00	134	0	1	0.00
TSP_CPR	321	0	82.06	1.00	779	0	3	16.67
SYSAUX	367	0	35.64	1.06	528	0	0	0.00
TSP_LAB	128	0	93.36	1.00	433	0	0	0.00
TSP_INSURANCE	257	0	50.00	1.03	269	0	0	0.00
TSP_INPADM	310	0	25.55	1.00	178	0	1	0.00
TSP_EXAM	216	0	50.74	2.44	253	0	0	0.00
UNDOTBS1	2	0	10.00	1.00	302	0	11	0.00
TSP_MATERIAL	83	0	53.37	3.73	127	0	0	0.00
TSP_COMM	120	0	94.58	1.72	29	0	0	0.00
TSP_CARD	37	0	77.84	1.00	24	0	0	0.00
TSP_SURGERY	14	0	52.14	1.00	13	0	0	0.00
TSP_MEDADM	3	0	100.00	1.00	2	0	0	0.00
TSP_ACCT	2	0	55.00	1.00	2	0	0	0.00
TSP_ASSET	2	0	60.00	1.00	2	0	0	0.00
TSP_BACK	2	0	50.00	1.00	2	0	0	0.00
TSP_BADZK	2	0	50.00	1.00	2	0	0	0.00
TSP_BLDBANK	2	0	55.00	1.00	2	0	0	0.00
TSP_ECONSTAT	2	0	55.00	1.00	2	0	0	0.00
TSP_EQUIPMENT	2	0	55.00	1.00	2	0	0	0.00
TSP_HACCOUNT	2	0	60.00	1.00	2	0	0	0.00
TSP_HATEMP	2	0	50.00	1.00	2	0	0	0.00
TSP_HISACCOUNT	2	0	45.00	1.00	2	0	0	0.00
TSP_INFECTION	2	0	130.00	1.00	2	0	0	0.00
TSP_INFO	2	0	60.00	1.00	2	0	0	0.00
TSP_INSURANCE_SUM	2	0	100.00	1.00	2	0	0	0.00
TSP_JS	2	0	55.00	1.00	2	0	0	0.00
TSP_KQMZGL	2	0	65.00	1.00	2	0	0	0.00
TSP_TUMOUR	2	0	25.00	1.00	2	0	0	0.00
TSP_YZYLS	2	0	0.00	1.00	2	0	0	0.00
TSP_ZLBR	2	0	10.00	1.00	2	0	0	0.00
XC	2	0	5.00	1.00	2	0	0	0.00
Z2002_DATA	2	0	15.00	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	367	0	35.64	1.06	528	0	0	0.00
SYSTEM	/u02/oradata/orcl/system01.dbf	1,128	0	43.27	1.00	134	0	1	0.00
TSP_ACCT	/u02/oradata/orcl/APACCT.DBF	2	0	55.00	1.00	2	0	0	0.00
TSP_ASSET	/u02/oradata/orcl/ASSET.DBF	2	0	60.00	1.00	2	0	0	0.00
TSP_BACK	/u02/oradata/orcl/APBACK.DBF	2	0	50.00	1.00	2	0	0	0.00
TSP_BADZK	/u02/oradata/orcl/APBADZK.DBF	2	0	50.00	1.00	2	0	0	0.00
TSP_BLDBANK	/u02/oradata/orcl/APBLDBANK.DBF	2	0	55.00	1.00	2	0	0	0.00
TSP_CARD	/u02/oradata/orcl/APCARD.DBF	37	0	77.84	1.00	24	0	0	0.00
TSP_COMM	/u02/oradata/orcl/APCOMM.DBF	120	0	94.58	1.72	29	0	0	0.00
TSP_CPR	/u02/oradata/orcl/APCPR.DBF	321	0	82.06	1.00	779	0	3	16.67
TSP_ECONSTAT	/u02/oradata/orcl/APECONSTAT.DBF	2	0	55.00	1.00	2	0	0	0.00
TSP_EQUIPMENT	/u02/oradata/orcl/APEQUIPMENT.DBF	2	0	55.00	1.00	2	0	0	0.00
TSP_EXAM	/u02/oradata/orcl/APEXAM.DBF	216	0	50.74	2.44	253	0	0	0.00
TSP_HACCOUNT	/u02/oradata/orcl/HACCOUNT.ORA	2	0	60.00	1.00	2	0	0	0.00
TSP_HATEMP	/u02/oradata/orcl/HATEMP.ORA	2	0	50.00	1.00	2	0	0	0.00
TSP_HISACCOUNT	/u02/oradata/orcl/HISACCOUNT.DBF	2	0	45.00	1.00	2	0	0	0.00
TSP_INFECTION	/u02/oradata/ORCLINFECTION.DBF	2	0	130.00	1.00	2	0	0	0.00
TSP_INFO	/u02/oradata/orcl/APINFO.DBF	2	0	60.00	1.00	2	0	0	0.00
TSP_INPADM	/u02/oradata/orcl/APINPADM.DBF	310	0	25.55	1.00	178	0	1	0.00
TSP_INPBILL	/u02/oradata/orcl/APINPBILL.DBF	4,590	1	18.49	1.00	2,088	1	2	0.00
TSP_INSURANCE	/u02/oradata/orcl/APINSURANCE.DBF	257	0	50.00	1.03	269	0	0	0.00
TSP_INSURANCE_SUM	/u02/oradata/orcl/datafile/O1_MF_TSP_INSU_75H7Z9VT_.	2	0	100.00	1.00	2	0	0	0.00
TSP_JS	/u02/oradata/orcl/JS.DBF	2	0	55.00	1.00	2	0	0	0.00
TSP_KQMZGL	/u02/oradata/orcl/APKQMZGL.DBF	2	0	65.00	1.00	2	0	0	0.00
TSP_LAB	/u02/oradata/orcl/APLAB.DBF	128	0	93.36	1.00	433	0	0	0.00
TSP_MATERIAL	/u02/oradata/orcl/APMATERIAL.DBF	83	0	53.37	3.73	127	0	0	0.00
TSP_MEDADM	/u02/oradata/orcl/APMEDADM.DBF	3	0	100.00	1.00	2	0	0	0.00
TSP_MEDREC	/u02/oradata/orcl/APMEDREC.DBF	5,830	2	24.15	1.32	1,227	0	0	0.00
TSP_ORDADM	/u02/oradata/orcl/APORDADM.DBF	1,272	0	47.22	1.00	1,787	0	0	0.00
TSP_OUTPADM	/u02/oradata/orcl/APOUTPADM.DBF	6,352	2	12.62	6.98	785	0	0	0.00
TSP_OUTPBILL	/u02/oradata/orcl/APOUTPBILL.DBF	27,101	8	2.81	2.50	1,539	0	0	0.00
TSP_PHARMACY	/u02/oradata/orcl/APPHARMACY.DBF	777,688	216	1.29	15.42	1,010	0	965	4.84
TSP_SURGERY	/u02/oradata/orcl/APSURGERY.DBF	14	0	52.14	1.00	13	0	0	0.00
TSP_TUMOUR	/u02/oradata/orcl/APTUMOUR.DBF	2	0	25.00	1.00	2	0	0	0.00
TSP_YZYLS	/u02/oradata/orcl/APYZYLS.DBF	2	0	0.00	1.00	2	0	0	0.00
TSP_ZLBR	/u02/oradata/orcl/APZLBR.DBF	2	0	10.00	1.00	2	0	0	0.00
UNDOTBS1	/u02/oradata/orcl/undotbs01.dbf	2	0	10.00	1.00	302	0	11	0.00
USERS	/u02/oradata/orcl/users01.dbf	2,847	1	9.09	14.30	340	0	0	0.00
XC	/u02/oradata/orcl/XC.DBF	2	0	5.00	1.00	2	0	0	0.00
Z2002_DATA	/u02/oradata/orcl/DATA01.DBF	2	0	15.00	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	188,755	84	75,364,452	12,158,126	15,889	0	0	983

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	13	1696	12347	58610	184320	58610
E	0	12	1231	6360	37251	184320	37251

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	144	0.09	17,811	1.22	3,398,214,437
D	288	0.19	35,622	1.18	3,288,976,442
D	432	0.28	53,433	1.15	3,200,764,815
D	576	0.37	71,244	1.12	3,123,242,191
D	720	0.46	89,055	1.09	3,054,196,669
D	864	0.56	106,866	1.07	2,992,513,856
D	1,008	0.65	124,677	1.05	2,936,953,385
D	1,152	0.74	142,488	1.03	2,886,550,455
D	1,296	0.84	160,299	1.02	2,840,477,340
D	1,440	0.93	178,110	1.00	2,798,001,722
D	1,552	1.00	191,963	1.00	2,789,660,895
D	1,584	1.02	195,921	1.00	2,787,283,511
D	1,728	1.11	213,732	1.00	2,777,357,530
D	1,872	1.21	231,543	0.99	2,768,088,080
D	2,016	1.30	249,354	0.99	2,759,392,687
D	2,160	1.39	267,165	0.99	2,751,142,266
D	2,304	1.48	284,976	0.98	2,743,217,337
D	2,448	1.58	302,787	0.98	2,735,495,622
D	2,592	1.67	320,598	0.98	2,727,818,991
D	2,736	1.76	338,409	0.98	2,719,874,161
D	2,880	1.86	356,220	0.97	2,710,112,849

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	10,480	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	681	640.91	0.00	0.00	0.00	0.00	102,400
E	1,000	670	669.94	0.00	0.00	0.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	29,113	29,113
64K	128K	82	82
128K	256K	209	209
256K	512K	56	56
512K	1024K	1,863	1,863
1M	2M	5,828	5,828
2M	4M	12	12
4M	8M	4	4
8M	16M	4	4

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	1,829,892.16	190,518.17	91.00	25,223
250	0.25	1,829,892.16	25,392.02	99.00	780
500	0.50	1,829,892.16	10,011.51	99.00	0
750	0.75	1,829,892.16	10,011.51	99.00	0
1,000	1.00	1,829,892.16	9,818.20	99.00	0
1,200	1.20	1,829,892.16	6,683.24	100.00	0
1,400	1.40	1,829,892.16	6,683.24	100.00	0
1,600	1.60	1,829,892.16	6,683.24	100.00	0
1,800	1.80	1,829,892.16	6,683.24	100.00	0
2,000	2.00	1,829,892.16	6,683.24	100.00	0
3,000	3.00	1,829,892.16	6,683.24	100.00	0
4,000	4.00	1,829,892.16	6,683.24	100.00	0
6,000	6.00	1,829,892.16	6,683.24	100.00	0
8,000	8.00	1,829,892.16	6,683.24	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
704	0.30	267	24,064	11,547,739	0.92	1,135,090	8.23	323,600,125
944	0.40	497	37,036	11,733,390	0.94	949,439	6.89	323,805,568
1,184	0.50	732	50,527	11,901,455	0.95	781,374	5.67	323,986,953
1,424	0.60	970	64,825	12,052,796	0.96	630,033	4.57	324,156,767
1,664	0.70	1,209	78,719	12,193,086	0.97	489,743	3.55	324,313,125
1,904	0.80	1,448	93,039	12,322,947	0.98	359,882	2.61	324,456,543
2,144	0.90	1,687	107,610	12,440,153	0.99	242,676	1.76	324,588,584
2,384	1.00	1,926	123,070	12,544,969	1.00	137,860	1.00	324,709,620
2,624	1.10	2,165	135,821	12,639,086	1.01	43,743	0.32	324,820,776
2,864	1.20	2,404	149,246	12,723,872	1.01	1	0.00	324,923,063
3,104	1.30	2,643	161,650	12,800,689	1.02	1	0.00	325,017,632
3,344	1.40	2,882	175,414	12,870,598	1.03	1	0.00	325,104,921
3,584	1.50	3,121	188,914	12,934,545	1.03	1	0.00	325,185,992
3,824	1.60	3,360	202,277	12,993,346	1.04	1	0.00	325,261,448
4,064	1.70	3,599	217,319	13,047,891	1.04	1	0.00	325,332,265
4,304	1.81	3,838	231,234	13,099,058	1.04	1	0.00	325,399,407
4,544	1.91	4,077	245,280	13,147,783	1.05	1	0.00	325,463,827
4,784	2.01	4,316	259,580	13,195,031	1.05	1	0.00	325,526,634

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,000	0.50	2,342,300	2,842,923,999
3,000	0.75	1,650,163	2,789,641,840
4,000	1.00	1,154,525	2,789,641,840
5,000	1.25	927,892	2,753,376,496
6,000	1.50	927,892	2,712,368,761
7,000	1.75	927,892	2,712,368,761
8,000	2.00	927,892	2,712,368,761

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 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
16	0.50	8	128	4	1.00	137,860	1.00	128
32	1.00	8	128	4	1.00	137,860	1.00	128
48	1.50	8	128	4	1.00	137,860	1.00	128
64	2.00	8	128	4	1.00	137,860	1.00	128

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	972	5	5
undo block	7	0	0
undo header	4	0	0

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)	4	4	0	4	255	63,847.50
CF-Controlfile Transaction	4,160	4,145	15	49	33	666.73
TX-Transaction (index contention)	1	1	0	1	0	20.00

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.56	13,562	2,217	7	16.4166666666666666666666666666666666667/49.95	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
04-Feb 11:09	368	1,418	2,217	4	50	0/0	0/0/0/0/0/0
04-Feb 10:59	244	1,651	1,616	3	41	0/0	0/0/0/0/0/0
04-Feb 10:49	264	1,721	1,015	5	31	0/0	0/0/0/0/0/0
04-Feb 10:39	338	1,790	1,765	4	43	0/0	0/0/0/0/0/0
04-Feb 10:29	367	1,969	600	6	24	0/0	0/0/0/0/0/0
04-Feb 10:19	397	1,912	563	5	23	0/0	0/0/0/0/0/0
04-Feb 10:09	581	3,101	145	7	16	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,295	0.00		0	0
AWR Alerted Metric Element list	42,612	0.00		0	0
Consistent RBA	8,526	0.00		0	0
FAL request queue	86	0.00		0	0
FAL subheap alocation	84	0.00		0	0
FIB s.o chain latch	20	0.00		0	0
FOB s.o list latch	1,391	0.00		0	0
In memory undo latch	91,143	0.00	1.00	0	10,432	0.00
JS mem alloc latch	8	0.00		0	0
JS queue access latch	8	0.00		0	0
JS queue state obj latch	25,918	0.00		0	0
JS slv state obj latch	19	0.00		0	0
KMG MMAN ready and startup request latch	1,201	0.00		0	0
KTF sga latch	9	0.00		0	1,127	0.00
KWQMN job cache list latch	39	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	0			0	1,201	0.00
OS process	4,017	0.00		0	0
OS process allocation	3,891	0.28	0.27	0	0
OS process: request allocation	2,670	0.45	0.00	0	0
PL/SQL warning settings	7,287	0.00		0	0
SQL memory manager latch	1	0.00		0	1,135	0.00
SQL memory manager workarea list latch	228,490	0.00		0	0
Shared B-Tree	129	0.00		0	0
active checkpoint queue latch	16,506	0.06	0.00	0	0
active service list	11,938	0.05	0.33	0	1,655	0.00
archive control	194	0.00		0	0
archive process latch	1,297	0.08	1.00	0	0
begin backup scn array	5	0.00		0	0
cache buffer handles	12,888	0.00		0	0
cache buffers chains	125,806,514	0.00	0.01	1	24,343,747	0.00
cache buffers lru chain	37,259	0.12	0.17	0	25,490,749	0.02
cache table scan latch	0			0	791,030	0.00
channel handle pool latch	2,672	1.20	0.09	0	0
channel operations parent latch	20,455	0.03	0.14	0	0
checkpoint queue latch	150,955	0.00		0	14,519	0.00
client/application info	9,473	0.00		0	0
commit callback allocation	32	0.00		0	0
compile environment latch	1,404	0.00		0	0
dml lock allocation	34,464	0.01	0.00	0	0
dummy allocation	2,797	0.18	0.40	0	0
enqueue hash chains	152,678	0.01	0.17	0	895	0.00
enqueues	118,626	0.04	0.02	0	0
event group latch	1,341	0.15	1.00	0	0
file cache latch	333	0.00		0	0
global KZLD latch for mem in SGA	1,345	0.00		0	0
hash table column usage latch	565	0.00		0	354,497	0.00
hash table modification latch	103	0.00		0	0
job workq parent latch	0			0	124	0.00
job_queue_processes parameter latch	122	0.00		0	0
kks stats	58,406	0.02	0.55	0	0
kokc descriptor allocation latch	60	0.00		0	0
ksuosstats global area	243	0.00		0	0
ktm global data	21	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	8,596	0.09	0.00	0	0
library cache	1,597,751	0.20	0.67	612	43,763	1.66
library cache load lock	2,565	0.04	0.00	0	38	0.00
library cache lock	1,543,149	0.01	0.05	0	0
library cache lock allocation	13,258	0.02	1.00	0	0
library cache pin	253,367	0.01	0.00	0	0
library cache pin allocation	6,012	0.00		0	0
list of block allocation	1,653	0.00		0	0
loader state object freelist	26	0.00		0	0
longop free list parent	122	0.00		0	122	0.00
message pool operations parent latch	2	0.00		0	0
messages	80,849	0.04	0.00	0	0
mostly latch-free SCN	8,575	0.00		0	0
multiblock read objects	1,632,520	0.00	0.00	0	0
ncodef allocation latch	80	0.00		0	0
object queue header heap	4,875	0.00		0	162	0.00
object queue header operation	24,378,435	0.00	0.18	0	0
object stats modification	1	0.00		0	0
parallel query alloc buffer	456	0.00		0	0
parameter list	5,656	0.05	0.00	0	0
parameter table allocation management	1,394	0.36	0.60	0	0
post/wait queue	13,046	0.00		0	9,072	0.00
process allocation	2,670	4.27	1.43	2	1,339	0.15
process group creation	2,670	0.26	0.14	0	0
qmn task queue latch	516	0.00		0	0
redo allocation	47,083	0.00	0.00	0	106,335	0.04
redo copy	0			0	106,355	0.05
redo writing	44,660	0.02	0.00	0	0
resmgr group change latch	1,692	0.00		0	0
resmgr:active threads	2,795	0.00		0	0
resmgr:actses change group	1,374	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	2,792	0.36	0.30	0	0
resmgr:resource group CPU method	1	0.00		0	0
resmgr:schema config	1	0.00		0	0
resmgr:vc list latch	1	0.00		0	0
row cache objects	1,878,313	0.05	0.06	2	3,962	0.25
rules engine aggregate statistics	10	0.00		0	0
rules engine rule set statistics	20	0.00		0	0
sequence cache	13,618	0.08	0.00	0	0
session allocation	87,336	0.08	0.25	0	0
session idle bit	2,994,374	0.00	0.04	0	0
session state list latch	3,174	0.06	0.00	0	0
session switching	99	0.00		0	0
session timer	1,655	0.00		0	0
shared pool	1,043,874	0.51	0.45	269	0
shared pool simulator	1,271,849	0.00	0.36	4	0
simulator hash latch	6,029,879	0.00	0.04	0	0
simulator lru latch	15,890	0.01	0.50	0	4,470,245	0.03
slave class	2	0.00		0	0
slave class create	8	0.00		0	0
sort extent pool	119	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,089	0.00		0	0
transaction allocation	24,609	0.00		0	0
transaction branch allocation	1,655	0.00		0	0
undo global data	63,232	0.00		0	0
user lock	5,472	0.73	0.60	1	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
shared pool	1,043,874	5,373	2,399	3,111
cache buffers chains	125,806,514	5,149	49	5,101
library cache	1,597,751	3,116	2,086	1,133
row cache objects	1,878,313	881	49	833
process allocation	2,670	114	163	3
library cache lock	1,543,149	86	4	82
session allocation	87,336	72	18	54
object queue header operation	24,378,435	60	11	49
cache buffers lru chain	37,259	46	8	38
enqueues	118,626	42	1	41
user lock	5,472	40	24	16
shared pool simulator	1,271,849	33	12	21
channel handle pool latch	2,672	32	3	29
session idle bit	2,994,374	24	1	23
simulator hash latch	6,029,879	23	1	22
enqueue hash chains	152,678	12	2	10
OS process allocation	3,891	11	3	8
kks stats	58,406	11	6	6
resmgr:free threads list	2,792	10	3	7
channel operations parent latch	20,455	7	1	6
process group creation	2,670	7	1	6
active service list	11,938	6	2	4
dummy allocation	2,797	5	2	3
parameter table allocation management	1,394	5	3	2
event group latch	1,341	2	2	0
library cache lock allocation	13,258	2	2	0
simulator lru latch	15,890	2	1	1
In memory undo latch	91,143	1	1	0
archive process latch	1,297	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	1	0
OS process allocation	kso_new_process:2	3	3
active service list	ksws_event: ksws event	6	6
archive process latch	kcrrsarc	1	0
cache buffers chains	kcbgtcr: kslbegin excl	46	49
cache buffers chains	kcbgtcr: fast path	31	5
cache buffers chains	kcbrls: kslbegin	6	29
cache buffers chains	kcbzib: multi-block read: nowait	5	0
cache buffers chains	kcbchg: kslbegin: bufs not pinned	3	3
cache buffers chains	kcbgcur: kslbegin	1	1
cache buffers chains	kcbnew: new latch again	1	0
cache buffers chains	kcbzwb	1	0
cache buffers lru chain	kcbzgws	8	0
channel handle pool latch	ksrchconnect()	25	25
channel operations parent latch	ksrchdelete()	3	3
cost function	kzulgt: find user res	19	18
cost function	kzulrl	5	6
dummy allocation	ktcscnfy	2	2
enqueue hash chains	ksqcmi: get hash chain latch after wait	1	0
enqueue hash chains	ksqrcl	1	1
enqueues	ksqgel: create enqueue	1	0
event group latch	ksdegi	2	2
kks stats	kks stats alloc/free	6	6
library cache	kglLockCursor	328	446
library cache	kglpndl: child: after processing	197	5
library cache	kglhdgn: child:	80	459
library cache	kgldte: child 0	70	124
library cache	kglobpn: child:	62	257
library cache	kgldti: 2child	44	12
library cache	kglati	36	4
library cache	kglpndl: child: before processing	31	71
library cache	kglpin	30	22
library cache	kglpnp: child	19	72
library cache	kglukp: child	19	21
library cache	kglsca: parent	15	0
library cache	kglnti	13	1
library cache	kglScanDependency	12	0
library cache	kglhdgc: child:	2	0
library cache	kglini: child	2	0
library cache	kglobld	1	2
library cache lock	kgllkdl: child: no lock handle	264	214
library cache lock	kgllkal: child: multiinstance	4	2
library cache lock allocation	kgllkget	2	1
object queue header operation	kcbo_switch_cq	22	0
parameter table allocation management	ksp_param_table_free	3	3
process allocation	ksucrp	139	0
process allocation	ksuapc	24	162
process group creation	ksupgpadd	1	1
resmgr:free threads list	kgskthrcreate	2	3
resmgr:free threads list	kgskthrsod	1	0
row cache objects	kqreqd: reget	22	1
row cache objects	kqrpre: find obj	14	38
row cache objects	kqreqd	4	6
row cache objects	kqrso	1	1
session allocation	ksuxds: KSUSFCLC not set	10	4
session allocation	ksucri	7	8
session allocation	ksuxds: not user session	1	4
session idle bit	ksupuc: set busy	1	0
shared pool	kghalo	1,409	661
shared pool	kghfrunp: clatch: nowait	644	0
shared pool	kghupr1	424	1,418
shared pool	kghfrunp: alloc: wait	370	95
shared pool	kghfrunp: clatch: wait	224	378
shared pool	kghfre	84	134
shared pool	kgh_next_free	62	4
shared pool	kghalp	32	78
shared pool	kghasp	14	4
shared pool	kghfree_extents: scan	2	5
shared pool	kghfrh	2	0
shared pool simulator	kglsim_unpin_simhp	5	2
shared pool simulator	kglsim_chg_simhp_free	2	0
shared pool simulator	kglsim_unpin_simhp: fast path	2	10
shared pool simulator	kglsim_upd_newhp	2	0
shared pool simulator	kglsim_scan_lru: scan	1	0
simulator hash latch	kcbsacc: lookup dba	1	0
simulator lru latch	kcbs_simulate: simulate set	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: 75,370,216
Captured Segments account for 97.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
INPADM	TSP_INPADM	PK_PATS_IN_HOSPITAL	INDEX	26,654,208	35.36
PHARMACY	TSP_PHARMACY	DRUG_PRESC_MASTER_TEMP	TABLE	12,485,808	16.57
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	12,367,952	16.41
SYS	SYSTEM	OBJ$	TABLE	4,834,224	6.41
SYS	SYSTEM	I_SYN1	INDEX	3,784,880	5.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 12,158,207
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	11,987,976	98.60
OUTPBILL	TSP_OUTPBILL	OUTP_RCPT_MASTER	TABLE	54,082	0.44
OUTPADM	TSP_OUTPADM	CLINIC_MASTER	TABLE	43,857	0.36
PHARMACY	USERS	PRESCRIPTION	TABLE	40,620	0.33
OUTPBILL	TSP_OUTPBILL	OUTP_ORDER_DESC	TABLE	13,199	0.11

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
INPBILL	TSP_INPBILL	PK_INP_BILL_DETAIL	INDEX	3	60.00
HQC	TSP_INPBILL	IND_ASACCT_STAT	INDEX	1	20.00
INPBILL	TSP_INPBILL	PK_INP_SETTLE_MASTER	INDEX	1	20.00

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
HQC	TSP_INPBILL	IND_ASACCT_STAT	INDEX	2	40.00
CPR	TSP_CPR	PK_DOCTOR_ACTION_LOG	INDEX	2	40.00
INPADM	TSP_INPADM	PATS_IN_HOSPITAL	TABLE	1	20.00

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	68	0.00	2	1
dc_database_links	2,674	0.00	0	1
dc_global_oids	383	0.00	0	10
dc_histogram_data	148,418	0.64	0	5,507
dc_histogram_defs	54,659	0.92	0	2,243
dc_object_grants	26,448	0.05	0	541
dc_object_ids	75,633	0.16	0	821
dc_objects	37,370	2.94	5	4,836
dc_profiles	1,393	0.00	0	1
dc_rollback_segments	394	0.00	0	20
dc_segments	30,729	0.33	11	1,759
dc_sequences	1,712	0.06	1,712	13
dc_table_scns	599	0.00	0	5
dc_tablespace_quotas	1	0.00	0	2
dc_tablespaces	132,350	0.00	0	41
dc_usernames	24,989	0.17	0	404
dc_users	228,064	0.01	0	973
outstanding_alerts	516	0.97	10	82

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	812	0.00	6,180	0.02	1	0
CLUSTER	220	0.00	480	0.00	0	0
INDEX	14	0.00	63	9.52	6	0
SQL AREA	91,681	18.43	1,084,487	2.67	1,562	10
TABLE/PROCEDURE	11,290	8.09	130,335	0.92	616	0
TRIGGER	1,144	0.61	13,981	0.12	10	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	369.36		0.96	2.69	44	45	385	385
	Freeable	258.00	0.00	0.82	0.37	4		313	313
	PL/SQL	8.38	6.36	0.02	0.02	0	0	383	383
	SQL	5.40	2.54	0.01	0.03	0	16	373	367
E	Other	379.41		0.96	2.65	44	45	397	397
	Freeable	277.06	0.00	0.84	0.35	4		328	328
	PL/SQL	8.69	6.62	0.02	0.02	0	0	395	395
	SQL	5.03	2.31	0.01	0.02	0	18	385	377

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,627,389,952
Fixed Size	2,089,240
Redo Buffers	14,684,160
Variable Size	2,550,140,648

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	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	367.57	338.91	-7.80
shared	KGH: NO ACCESS	791.46	791.46	0.00
shared	PCursor	156.59	148.70	-5.04
shared	free memory	911.99	953.80	4.58
shared	kglsim object batch	45.27	45.27	0.00
shared	library cache	88.99	88.55	-0.49
shared	sql area	527.81	544.38	3.14
shared	sql area:PLSQL	59.37	44.50	-25.04
	buffer_cache	1,552.00	1,552.00	0.00
	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.38	Recursive Call %:	19.24
Rollback per transaction %:	23.16	Rows per Sort:	30.61

Buffer Nowait %:	100.00	Redo NoWait %:	99.95
Buffer Hit %:	83.87	In-memory Sort %:	100.00
Library Hit %:	97.55	Soft Parse %:	97.86
Execute to Parse %:	-7.62	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	6.48	% Non-Parse CPU:	97.55