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: 10388 03-May-13 09:00:44 325 3.0

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

Elapsed: 60.18 (mins)

DB Time: 143.29 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	10388	03-May-13 09:00:44	325	3.0
End Snap:	10389	03-May-13 10:00:55	358	3.0
Elapsed:		60.18 (mins)
DB Time:		143.29 (mins)

Report Summary

Cache Sizes

Begin End

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

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

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

Load Profile

Per Second Per Transaction

Redo size: 13,012.69 3,654.11

Logical reads: 14,705.05 4,129.35

Block changes: 84.25 23.66

Physical reads: 2,492.35 699.88

Physical writes: 5.35 1.50

User calls: 559.38 157.08

Parses: 152.61 42.86

Hard parses: 3.97 1.12

Sorts: 11.93 3.35

Logons: 0.41 0.12

Executes: 148.81 41.79

Transactions: 3.56

	Per Second	Per Transaction
Redo size:	13,012.69	3,654.11
Logical reads:	14,705.05	4,129.35
Block changes:	84.25	23.66
Physical reads:	2,492.35	699.88
Physical writes:	5.35	1.50
User calls:	559.38	157.08
Parses:	152.61	42.86
Hard parses:	3.97	1.12
Sorts:	11.93	3.35
Logons:	0.41	0.12
Executes:	148.81	41.79
Transactions:	3.56

% Blocks changed per Read: 0.57 Recursive Call %: 14.65

Rollback per transaction %: 21.03 Rows per Sort: 33.08

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 97.77 Soft Parse %: 97.40

Execute to Parse %: -2.56 Latch Hit %: 99.92

Parse CPU to Parse Elapsd %: 1.35 % Non-Parse CPU: 96.71

Shared Pool Statistics

Begin End

Memory Usage %: 69.70 74.27

% SQL with executions>1: 88.01 61.89

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

	Begin	End
Memory Usage %:	69.70	74.27
% SQL with executions>1:	88.01	61.89
% Memory for SQL w/exec>1:	87.60	67.24

Top 5 Timed Events

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

latch: shared pool 26,600 1,949 73 22.7 Concurrency

latch: library cache 18,951 1,906 101 22.2 Concurrency

CPU time 1,249 14.5

db file sequential read 51,895 854 16 9.9 User I/O

log file sync 10,283 812 79 9.4 Commit

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
latch: shared pool	26,600	1,949	73	22.7	Concurrency
latch: library cache	18,951	1,906	101	22.2	Concurrency
CPU time		1,249		14.5
db file sequential read	51,895	854	16	9.9	User I/O
log file sync	10,283	812	79	9.4	Commit

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): 8597.3s
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,020.58	35.13
parse time elapsed	3,000.68	34.90
DB CPU	1,249.27	14.53
hard parse elapsed time	766.77	8.92
connection management call elapsed time	125.68	1.46
PL/SQL execution elapsed time	101.32	1.18
PL/SQL compilation elapsed time	45.96	0.53
failed parse elapsed time	28.54	0.33
hard parse (sharing criteria) elapsed time	26.05	0.30
sequence load elapsed time	4.42	0.05
repeated bind elapsed time	0.03	0.00
hard parse (bind mismatch) elapsed time	0.03	0.00
DB time	8,597.32
background elapsed time	1,615.09
background cpu time	11.20

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	45,938	0.02	3,872	84	3.57
User I/O	629,198	0.00	1,479	2	48.93
Commit	10,283	0.97	812	79	0.80
System I/O	27,260	0.00	748	27	2.12
Application	1,119	3.04	105	94	0.09
Other	279	6.81	40	143	0.02
Network	2,163,490	0.00	4	0	168.25
Configuration	2	0.00	0	59	0.00

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: shared pool	26,600	0.00	1,949	73	2.07
latch: library cache	18,951	0.00	1,906	101	1.47
db file sequential read	51,895	0.00	854	16	4.04
log file sync	10,283	0.97	812	79	0.80
db file scattered read	576,927	0.00	607	1	44.87
log file parallel write	10,033	0.00	461	46	0.78
control file parallel write	3,485	0.00	277	80	0.27
enq: TX - row lock contention	39	87.18	104	2678	0.00
enq: CF - contention	55	3.64	23	414	0.00
read by other session	201	0.00	17	86	0.02
latch: row cache objects	219	0.00	12	57	0.02
latch free	166	0.00	9	54	0.01
control file sequential read	13,611	0.00	9	1	1.06
buffer exterminate	8	100.00	8	978	0.00
os thread startup	5	20.00	1	279	0.00
ARCH wait on SENDREQ	46	0.00	1	28	0.00
SQL*Net message to client	2,018,959	0.00	1	0	157.01
enq: TX - index contention	8	0.00	1	141	0.00
SQL*Net more data to client	136,398	0.00	1	0	10.61
log file sequential read	52	0.00	1	14	0.00
buffer busy waits	29	0.00	1	25	0.00
SQL*Net more data from client	8,087	0.00	1	0	0.63
log file single write	4	0.00	0	78	0.00
SQL*Net break/reset to client	1,080	0.00	0	0	0.08
db file parallel read	9	0.00	0	14	0.00
Log archive I/O	75	0.00	0	2	0.01
log file switch completion	1	0.00	0	118	0.00
LGWR wait for redo copy	27	33.33	0	4	0.00
cursor: pin S wait on X	6	100.00	0	11	0.00
wait list latch free	2	0.00	0	11	0.00
latch: cache buffers chains	69	0.00	0	0	0.01
row cache lock	29	0.00	0	0	0.00
latch: library cache lock	6	0.00	0	1	0.00
latch: library cache pin	8	0.00	0	0	0.00
latch: session allocation	9	0.00	0	0	0.00
latch: In memory undo latch	8	0.00	0	0	0.00
direct path read	82	0.00	0	0	0.01
latch: cache buffers lru chain	4	0.00	0	0	0.00
direct path write	84	0.00	0	0	0.01
latch: redo writing	1	0.00	0	0	0.00
latch: enqueue hash chains	1	0.00	0	0	0.00
latch: object queue header operation	5	0.00	0	0	0.00
cursor: pin S	1	0.00	0	0	0.00
latch: messages	1	0.00	0	0	0.00
SQL*Net message from client	2,018,931	0.00	724,184	359	157.01
Streams AQ: waiting for time management or cleanup tasks	6	66.67	3,924	654070	0.00
Streams AQ: qmn slave idle wait	129	0.00	3,526	27333	0.01
Streams AQ: qmn coordinator idle wait	260	50.38	3,526	13561	0.02
virtual circuit status	121	100.00	3,525	29130	0.01
jobq slave wait	1,199	95.00	3,491	2912	0.09
SGA: MMAN sleep for component shrink	212	87.74	2	10	0.02
class slave wait	2	0.00	0	47	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	10,033	0.00	461	46	0.78
control file parallel write	3,485	0.00	277	80	0.27
events in waitclass Other	90	12.22	23	255	0.01
latch: shared pool	130	0.00	14	111	0.01
db file sequential read	194	0.00	11	58	0.02
latch: library cache	63	0.00	10	160	0.00
control file sequential read	12,934	0.00	9	1	1.01
os thread startup	5	20.00	1	279	0.00
ARCH wait on SENDREQ	46	0.00	1	28	0.00
log file sequential read	52	0.00	1	14	0.00
log file single write	4	0.00	0	78	0.00
db file scattered read	4	0.00	0	69	0.00
Log archive I/O	75	0.00	0	2	0.01
direct path read	82	0.00	0	0	0.01
direct path write	83	0.00	0	0	0.01
latch: redo writing	1	0.00	0	0	0.00
rdbms ipc message	24,710	60.39	47,459	1921	1.92
Streams AQ: waiting for time management or cleanup tasks	6	66.67	3,924	654070	0.00
pmon timer	1,679	99.94	3,538	2107	0.13
Streams AQ: qmn slave idle wait	129	0.00	3,526	27333	0.01
Streams AQ: qmn coordinator idle wait	260	50.38	3,526	13561	0.02
smon timer	12	100.00	3,495	291213	0.00
SGA: MMAN sleep for component shrink	212	87.74	2	10	0.02
class slave wait	1	0.00	0	94	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	138,475
IDLE_TIME	2,784,020
IOWAIT_TIME	189,304
NICE_TIME	33
SYS_TIME	23,828
USER_TIME	110,585
LOAD	7
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	5,637.00	280.30	214,721	35,469,706
SYS$USERS	2,689.10	950.30	8,616,463	17,363,609
SYS$BACKGROUND	0.00	0.00	438	20,721
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	51554	71822	36187	304422	1979715	244
SYS$USERS	575337	73874	9030	74103	174219	37
SYS$BACKGROUND	563	1188	200	2493	46	131

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
220	123	12	18.35	2.56	2xfrf3uqhvx2y	JDBC Thin Client	select * from ip_orderdetl_vie...
212	123	12	17.66	2.47	5nrzd228xgq35	JDBC Thin Client	select * from ip_orderdetl_vie...
140	93	9	15.52	1.62	15rv2nngx7a0y	JDBC Thin Client	select * from ip_orderdetl_vie...
122	82	8	15.22	1.42	6v9vt1b3z196n	JDBC Thin Client	select * from ip_orderdetl_vie...
95	33	489	0.19	1.11	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
95	95	48	1.98	1.11	917rb37awppcz	JDBC Thin Client	select * from ip_order_state w...
85	2	2,204	0.04	0.99	4yffxmsh6n03q	doctws.exe	BEGIN SYS.DBMS_DESCRIBE.DESCRI...
77	0	30	2.56	0.89	cu9pakb7aj79g	nursws.exe	INSERT INTO "INP_BILL_DETAIL" ...
36	21	2	17.75	0.41	bpx8gjpujp9am	JDBC Thin Client	select * from ip_orderdetl_vie...
35	1	602	0.06	0.40	dzxr7ym0tkjrw	nursws.exe	SELECT "ORDERS_COSTS"."ITEM_NA...

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
123	220	12	10.29	2.56	2xfrf3uqhvx2y	JDBC Thin Client	select * from ip_orderdetl_vie...
123	212	12	10.28	2.47	5nrzd228xgq35	JDBC Thin Client	select * from ip_orderdetl_vie...
95	95	48	1.98	1.11	917rb37awppcz	JDBC Thin Client	select * from ip_order_state w...
93	140	9	10.32	1.62	15rv2nngx7a0y	JDBC Thin Client	select * from ip_orderdetl_vie...
82	122	8	10.28	1.42	6v9vt1b3z196n	JDBC Thin Client	select * from ip_orderdetl_vie...
33	95	489	0.07	1.11	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
21	36	2	10.27	0.41	bpx8gjpujp9am	JDBC Thin Client	select * from ip_orderdetl_vie...
19	22	1,122	0.02	0.26	gnp1u7yqu2skn	C:\Documents and Settings\dyyy\��\��ҩ.lnk	SELECT "DRUG_PRESC_MASTER_T...
10	17	1	10.37	0.20	0fb5qvk8zsv8h	JDBC Thin Client	select * from ip_orderdetl_vie...
10	16	1	10.36	0.18	1fq2rgtgpzp9q	JDBC Thin Client	select * from ip_orderdetl_vie...

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: 53,099,318
Captured SQL account for 36.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
6,959,160	1,122	6,202.46	13.11	18.60	22.11	gnp1u7yqu2skn	C:\Documents and Settings\dyyy\��\��ҩ.lnk	SELECT "DRUG_PRESC_MASTER_T...
1,321,766	12	110,147.17	2.49	123.31	211.96	5nrzd228xgq35	JDBC Thin Client	select * from ip_orderdetl_vie...
1,321,644	12	110,137.00	2.49	123.44	220.20	2xfrf3uqhvx2y	JDBC Thin Client	select * from ip_orderdetl_vie...
1,120,368	48	23,341.00	2.11	95.09	95.09	917rb37awppcz	JDBC Thin Client	select * from ip_order_state w...
1,078,026	489	2,204.55	2.03	32.93	95.10	9hk2facr2ba94	doctws.exe	SELECT "MR_ON_LINE"."PATIENT...
991,200	9	110,133.33	1.87	92.85	139.70	15rv2nngx7a0y	JDBC Thin Client	select * from ip_orderdetl_vie...
935,798	816	1,146.81	1.76	4.34	26.86	fubr4x8z5w0t5	nursws.exe	SELECT "DOCTOR_ORDERS"."ENT...
881,024	8	110,128.00	1.66	82.25	121.79	6v9vt1b3z196n	JDBC Thin Client	select * from ip_orderdetl_vie...
298,924	3	99,641.33	0.56	0.99	25.52	52t34yqvavrgs	chglst.exe	SELECT "INP_BILL_DETAIL"."ITEM...
220,181	2	110,090.50	0.41	20.54	35.50	bpx8gjpujp9am	JDBC Thin Client	select * from ip_orderdetl_vie...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 8,999,780
Captured SQL account for 83.2% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,301,063	12	108,421.92	14.46	123.44	220.20	2xfrf3uqhvx2y	JDBC Thin Client	select * from ip_orderdetl_vie...
1,299,342	12	108,278.50	14.44	123.31	211.96	5nrzd228xgq35	JDBC Thin Client	select * from ip_orderdetl_vie...
988,833	9	109,870.33	10.99	92.85	139.70	15rv2nngx7a0y	JDBC Thin Client	select * from ip_orderdetl_vie...
878,615	8	109,826.88	9.76	82.25	121.79	6v9vt1b3z196n	JDBC Thin Client	select * from ip_orderdetl_vie...
215,550	2	107,775.00	2.40	20.54	35.50	bpx8gjpujp9am	JDBC Thin Client	select * from ip_orderdetl_vie...
135,609	3	45,203.00	1.51	4.36	31.81	23vm3x08bwmx8	outpapp.exe	SELECT "INVOICE_INFO"."RCPT...
110,552	1	110,552.00	1.23	2.99	31.28	98tvas0zdcq1a	stockmgr.exe	SELECT '��' action_type,...
110,056	1	110,056.00	1.22	10.28	17.42	9ctypd1z0mm86	JDBC Thin Client	select * from ip_orderdetl_vie...
110,055	1	110,055.00	1.22	10.33	16.45	23f73vvxghmwf	JDBC Thin Client	select * from ip_orderdetl_vie...
110,054	1	110,054.00	1.22	10.32	13.76	6vgw0rwvyy1at	JDBC Thin Client	select * from ip_orderdetl_vie...
110,053	1	110,053.00	1.22	10.33	19.30	16atqwybj8krv	JDBC Thin Client	select * from ip_orderdetl_vie...
110,053	1	110,053.00	1.22	10.34	14.97	dhfzf5mz6davp	JDBC Thin Client	select * from ip_orderdetl_vie...
110,051	1	110,051.00	1.22	10.32	14.48	bdauc734ntfwu	JDBC Thin Client	select * from ip_orderdetl_vie...
110,050	1	110,050.00	1.22	10.32	15.58	8bb6z82ga6xjt	JDBC Thin Client	select * from ip_orderdetl_vie...
110,050	1	110,050.00	1.22	10.34	15.20	ckh0wnzbb382g	JDBC Thin Client	select * from ip_orderdetl_vie...
110,049	1	110,049.00	1.22	10.28	17.94	6w7jw6pz8tgtg	JDBC Thin Client	select * from ip_orderdetl_vie...
110,046	1	110,046.00	1.22	10.30	14.50	9wf2ayf99qr4u	JDBC Thin Client	select * from ip_orderdetl_vie...
110,045	1	110,045.00	1.22	10.32	14.21	1k1rnyd006d28	JDBC Thin Client	select * from ip_orderdetl_vie...
110,028	1	110,028.00	1.22	10.32	17.20	b28c3w7vfj8ja	JDBC Thin Client	select * from ip_orderdetl_vie...
110,023	1	110,023.00	1.22	10.36	15.60	1fq2rgtgpzp9q	JDBC Thin Client	select * from ip_orderdetl_vie...
110,022	1	110,022.00	1.22	10.32	15.68	ffqn6432btzs2	JDBC Thin Client	select * from ip_orderdetl_vie...
110,016	1	110,016.00	1.22	10.35	19.10	20vak9pyv6bux	JDBC Thin Client	select * from ip_orderdetl_vie...
110,016	1	110,016.00	1.22	10.34	15.23	gc6yu383b2k8z	JDBC Thin Client	select * from ip_orderdetl_vie...
110,015	1	110,015.00	1.22	10.37	17.32	0fb5qvk8zsv8h	JDBC Thin Client	select * from ip_orderdetl_vie...
110,010	1	110,010.00	1.22	10.32	16.57	8kqtg0wu0q3zm	JDBC Thin Client	select * from ip_orderdetl_vie...
110,009	1	110,009.00	1.22	10.28	17.77	g7x6164st8ad7	JDBC Thin Client	select * from ip_orderdetl_vie...
110,004	1	110,004.00	1.22	10.28	15.53	cg9gf3hspcn6j	JDBC Thin Client	select * from ip_orderdetl_vie...
107,572	1	107,572.00	1.20	10.30	16.08	bv1qvv3f7wwhz	JDBC Thin Client	select * from ip_orderdetl_vie...
107,106	1	107,106.00	1.19	10.31	17.56	ak0wm8cwnx292	JDBC Thin Client	select * from ip_orderdetl_vie...
105,084	1	105,084.00	1.17	10.32	18.14	79qcfdt9245s8	JDBC Thin Client	select * from ip_orderdetl_vie...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 537,338
Captured SQL account for 66.2% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
65,045	8,077	0.12	g2tcdkz3sy3h2	doctws.exe	Select bed_label From bed_rec ...
65,043	8,078	0.12	664crkjw8n47y	doctws.exe	select dept_code , ward_code ...
61,550	4,562	0.07	c69f5n7vyas9s	doctws.exe	Select bed_no , diagnosis , ...
34,103	34,088	1.00	4srur5p7sxdu3	doctws.exe	select user_name from comm.use...
25,354	25,209	0.99	4pwnt0hgg2ghr	doctws.exe	select administration_code fro...
16,634	16,634	1.00	f0wzs9nc663bn	odoctor.exe	select sysdate from dual
8,494	15,727	1.85	0h6b2sajwb74n		select privilege#, level from ...
4,997	4,907	0.98	5h8hkpq3q5g41	doctws.exe	SELECT TOPIC , ITEM_CLASS , ...
4,184	4,184	1.00	a7w35qskd8cs0	C:\Documents and Settings\dyyy.JW\��\��.	SELECT MIN ( CLASS_ON_INP_RCPT...
3,189	3,188	1.00	1g8brz25xjs3j	examapt.exe	SELECT CHARGE_TYPE, INSURANCE...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 551,079
Captured SQL account for 70.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
74,464	65,043	13.51	664crkjw8n47y	doctws.exe	select dept_code , ward_code ...
74,462	65,045	13.51	g2tcdkz3sy3h2	doctws.exe	Select bed_label From bed_rec ...
70,911	61,550	12.87	c69f5n7vyas9s	doctws.exe	Select bed_no , diagnosis , ...
38,238	34,103	6.94	4srur5p7sxdu3	doctws.exe	select user_name from comm.use...
25,354	25,354	4.60	4pwnt0hgg2ghr	doctws.exe	select administration_code fro...
16,680	16,634	3.03	f0wzs9nc663bn	odoctor.exe	select sysdate from dual
8,494	8,494	1.54	0h6b2sajwb74n		select privilege#, level from ...
5,381	4,997	0.98	5h8hkpq3q5g41	doctws.exe	SELECT TOPIC , ITEM_CLASS , ...
4,184	4,184	0.76	a7w35qskd8cs0	C:\Documents and Settings\dyyy.JW\��\��.	SELECT MIN ( CLASS_ON_INP_RCPT...
3,160	3,160	0.57	ckkhf45yaan6w	C:\Documents and Settings\dyyy\��\ҽ��סԺ�Ǽ�	select to_char ( sysdate , 'yy...

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	878	1y01fm6rm9vff	doctws.exe	INSERT INTO "DOCTOR_ORDERS" ( ...
44	3,189	1g8brz25xjs3j	examapt.exe	SELECT CHARGE_TYPE, INSURANCE...
30	1,489	9mrhw217pc809	doctws.exe	select MR_CODE , mr_attr , m...
30	30	cu9pakb7aj79g	nursws.exe	INSERT INTO "INP_BILL_DETAIL" ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0fb5qvk8zsv8h select * from ip_orderdetl_view where cfxh='020910_20130503094921' and patid='H2424'

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

15rv2nngx7a0y select * from ip_orderdetl_view where cfxh='020902_20130503094429' and patid='H2275'

16atqwybj8krv select * from ip_orderdetl_view where cfxh='020902_20130503094024' and patid='H2273'

1fq2rgtgpzp9q select * from ip_orderdetl_view where cfxh='020910_20130503094801' and patid='H2301'

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

1k1rnyd006d28 select * from ip_orderdetl_view where cfxh='020910_20130503094237' and patid='H2426'

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 )

20vak9pyv6bux select * from ip_orderdetl_view where cfxh='020902_20130503095101' and patid='H2251'

23f73vvxghmwf select * from ip_orderdetl_view where cfxh='020902_20130503093849' and patid='H2426'

23vm3x08bwmx8 SELECT "INVOICE_INFO"."RCPT_TYPE" , "INVOICE_INFO"."RCPT_NO" , "INVOICE_INFO"."INVOICE_COSTS" , "INVOICE_INFO"."INVOICE_STATUS" , "OUTP_RCPT_MASTER"."PATIENT_ID" , "OUTP_RCPT_MASTER"."NAME" , "OUTP_RCPT_MASTER"."VISIT_DATE" , "OUTP_RCPT_MASTER"."TOTAL_COSTS" , "OUTP_RCPT_MASTER"."TOTAL_CHARGES" , "OUTP_RCPT_MASTER"."OPERATOR_NO" , "INVOICE_INFO"."INVOICE_NO" FROM "OUTP_RCPT_MASTER" , "INVOICE_INFO" WHERE ( "OUTP_RCPT_MASTER"."RCPT_NO" = "INVOICE_INFO"."RCPT_NO" ) and ( ( "INVOICE_INFO"."DISK_NO" = :v_disk_no ) and ( "INVOICE_INFO"."RCPT_TYPE" = :v_rcpt_type ) and ( "OUTP_RCPT_MASTER"."CHARGE_INDICATOR" = 2 ) and ( "INVOICE_INFO"."INVOICE_STATUS" = '00' ) and ( "OUTP_RCPT_MASTER"."TOTAL_COSTS" > 0 ) )

2xfrf3uqhvx2y select * from ip_orderdetl_view where cfxh='020902_20130503095403' and patid='H2251'

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;

52t34yqvavrgs SELECT "INP_BILL_DETAIL"."ITEM_CLASS", "INP_BILL_DETAIL"."ITEM_NAME", "INP_BILL_DETAIL"."ITEM_CODE", "INP_BILL_DETAIL"."ITEM_SPEC", "INP_BILL_DETAIL"."UNITS", SUM("INP_BILL_DETAIL"."AMOUNT"), SUM("INP_BILL_DETAIL"."COSTS"), SUM("INP_BILL_DETAIL"."CHARGES"), 0.00 FROM "INP_BILL_DETAIL" WHERE (1=1) and inp_bill_detail.patient_id='YB300772' and inp_bill_detail.billing_date_time>=to_date('2013-04-22', 'yyyy-mm-dd') and inp_bill_detail.billing_date_time<=to_date('2013-05-03', 'yyyy-mm-dd')+1 AND EXISTS (SELECT * FROM PRICE_LIST WHERE INP_BILL_DETAIL.ITEM_CLASS=ITEM_CLASS AND INP_BILL_DETAIL.ITEM_CODE=ITEM_CODE AND CLASS_ON_INP_RCPT='A') GROUP BY "INP_BILL_DETAIL"."ITEM_CLASS", "INP_BILL_DETAIL"."ITEM_NAME", "INP_BILL_DETAIL"."ITEM_CODE", "INP_BILL_DETAIL"."ITEM_SPEC", "INP_BILL_DETAIL"."UNITS"

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

5nrzd228xgq35 select * from ip_orderdetl_view where cfxh='020902_20130503095305' and patid='H2423'

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

6v9vt1b3z196n select * from ip_orderdetl_view where cfxh='020902_20130503094433' and patid='H2423'

6vgw0rwvyy1at select * from ip_orderdetl_view where cfxh='020902_20130503093502' and patid='H2273'

6w7jw6pz8tgtg select * from ip_orderdetl_view where cfxh='020910_20130503094020' and patid='H2281'

79qcfdt9245s8 select * from ip_orderdetl_view where cfxh='020902_20130503094448' and patid='H2351'

8bb6z82ga6xjt select * from ip_orderdetl_view where cfxh='020902_20130503094409' and patid='H2275'

8kqtg0wu0q3zm select * from ip_orderdetl_view where cfxh='020902_20130503094929' and patid='H2422'

917rb37awppcz select * from ip_order_state where (id>0 or id in ('')) and to_char(sysdate, 'yyyy-mm-dd')=to_char(intime, 'yyyy-mm-dd') and intime<sysdate-(5/24/60/60) order by id

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

9ctypd1z0mm86 select * from ip_orderdetl_view where cfxh='020902_20130503093814' 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)))

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

9wf2ayf99qr4u select * from ip_orderdetl_view where cfxh='020910_20130503094100' and patid='H2430'

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

ak0wm8cwnx292 select * from ip_orderdetl_view where cfxh='020902_20130503094519' and patid='H2422'

b28c3w7vfj8ja select * from ip_orderdetl_view where cfxh='020910_20130503094436' and patid='H2275'

bdauc734ntfwu select * from ip_orderdetl_view where cfxh='020902_20130503094254' and patid='H2426'

bpx8gjpujp9am select * from ip_orderdetl_view where cfxh='020910_20130503094458' and patid='H2275'

bv1qvv3f7wwhz select * from ip_orderdetl_view where cfxh='020910_20130503095257' and patid='H2322'

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

cg9gf3hspcn6j select * from ip_orderdetl_view where cfxh='020902_20130503095057' and patid='H2351'

ckh0wnzbb382g select * from ip_orderdetl_view where cfxh='020902_20130503094014' and patid='H2426'

ckkhf45yaan6w select to_char ( sysdate , 'yyyymmddhh24miss' ) from dual

cu9pakb7aj79g INSERT INTO "INP_BILL_DETAIL" ( "PATIENT_ID", "VISIT_ID", "ITEM_NO", "ITEM_CLASS", "ITEM_NAME", "ITEM_CODE", "ITEM_SPEC", "AMOUNT", "UNITS", "CHARGES", "COSTS", "ORDERED_BY", "PERFORMED_BY", "OPERATOR_NO", "BILLING_DATE_TIME" ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 )

dhfzf5mz6davp select * from ip_orderdetl_view where cfxh='020902_20130503093911' and patid='H2421'

dzxr7ym0tkjrw SELECT "ORDERS_COSTS"."ITEM_NAME", "ORDERS_COSTS"."AMOUNT", "ORDERS_COSTS"."UNITS", "ORDERS_COSTS"."ITEM_CODE", "ORDERS_COSTS"."ITEM_CLASS", "ORDERS_COSTS"."ITEM_NO", "ORDERS_COSTS"."ORDER_SUB_NO", "ORDERS_COSTS"."ORDER_NO", "ORDERS_COSTS"."VISIT_ID", "ORDERS_COSTS"."PATIENT_ID", "ORDERS_COSTS"."COSTS", "ORDERS_COSTS"."ITEM_SPEC" FROM "ORDERS_COSTS" WHERE (PATIENT_ID = :p_id ) AND (VISIT_ID = :v_id )

f0wzs9nc663bn select sysdate from dual

ffqn6432btzs2 select * from ip_orderdetl_view where cfxh='020902_20130503094913' and patid='H2275'

fubr4x8z5w0t5 SELECT "DOCTOR_ORDERS"."ENTER_DATE_TIME" , "PAT_MASTER_INDEX"."NAME" , "PATS_IN_HOSPITAL"."BED_NO" , "DOCTOR_ORDERS"."ORDER_TEXT" , "DOCTOR_ORDERS"."DOSAGE" , "DOCTOR_ORDERS"."DOSAGE_UNITS" , "DOCTOR_ORDERS"."ADMINISTRATION" , "DOCTOR_ORDERS"."FREQUENCY" , "DOCTOR_ORDERS"."DOCTOR" , "DOCTOR_ORDERS"."NURSE" , "DOCTOR_ORDERS"."DURATION" , "DOCTOR_ORDERS"."DURATION_UNITS" , "DOCTOR_ORDERS"."FREQ_DETAIL" , "DOCTOR_ORDERS"."ORDER_NO" , "DOCTOR_ORDERS"."ORDER_SUB_NO" , "DOCTOR_ORDERS"."ORDER_STATUS" , "DOCTOR_ORDERS"."PATIENT_ID" , "DOCTOR_ORDERS"."VISIT_ID" , "DOCTOR_ORDERS"."ORDER_CLASS" , "DOCTOR_ORDERS"."REPEAT_INDICATOR" , "DOCTOR_ORDERS"."START_STOP_INDICATOR" , "DOCTOR_ORDERS"."FREQ_INTERVAL" , "DOCTOR_ORDERS"."FREQ_INTERVAL_UNIT" , "DOCTOR_ORDERS"."ORDERING_DEPT" , "DOCTOR_ORDERS"."ORDER_PRINT_INDICATOR" , "DOCTOR_ORDERS"."RELATED_ORDER_NO" , "DOCTOR_ORDERS"."RELATED_ORDER_SUB_NO" , "DOCTOR_ORDERS"."ORDER_CODE" , "DOCTOR_ORDERS"."PROCESSING_DATE_TIME" , "DOCTOR_ORDERS"."BILLING_ATTR" , "PAT_MASTER_INDEX"."NAME_PHONETIC" , "DOCTOR_ORDERS"."START_DATE_TIME" , "DOCTOR_ORDERS"."DRUG_BILLING_ATTR" , "DOCTOR_ORDERS"."FRE Q_COUNTER" , "BED_REC"."BED_LABEL" FROM "DOCTOR_ORDERS" , "PAT_MASTER_INDEX" , "PATS_IN_HOSPITAL" , "BED_REC" WHERE ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "PAT_MASTER_INDEX"."PATIENT_ID" ) and ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "DOCTOR_ORDERS"."PATIENT_ID" ) and ( "PATS_IN_HOSPITAL"."VISIT_ID" = "DOCTOR_ORDERS"."VISIT_ID" ) and ( "PATS_IN_HOSPITAL"."WARD_CODE" = "BED_REC"."WARD_CODE" ) and ( "PATS_IN_HOSPITAL"."BED_NO" = "BED_REC"."BED_NO" ) and ( "PATS_IN_HOSPITAL"."WARD_CODE" = :wardcode ) AND "DOCTOR_ORDERS"."ORDER_STATUS"='1'

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

g7x6164st8ad7 select * from ip_orderdetl_view where cfxh='020902_20130503094947' and patid='H2275'

gc6yu383b2k8z select * from ip_orderdetl_view where cfxh='020910_20130503095037' and patid='H2421'

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 )

SQL Id	SQL Text
0fb5qvk8zsv8h	select * from ip_orderdetl_view where cfxh='020910_20130503094921' and patid='H2424'
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
15rv2nngx7a0y	select * from ip_orderdetl_view where cfxh='020902_20130503094429' and patid='H2275'
16atqwybj8krv	select * from ip_orderdetl_view where cfxh='020902_20130503094024' and patid='H2273'
1fq2rgtgpzp9q	select * from ip_orderdetl_view where cfxh='020910_20130503094801' and patid='H2301'
1g8brz25xjs3j	SELECT CHARGE_TYPE, INSURANCE_TYPE FROM PAT_VISIT WHERE PATIENT_ID = :B2 AND VISIT_ID = :B1
1k1rnyd006d28	select * from ip_orderdetl_view where cfxh='020910_20130503094237' and patid='H2426'
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 )
20vak9pyv6bux	select * from ip_orderdetl_view where cfxh='020902_20130503095101' and patid='H2251'
23f73vvxghmwf	select * from ip_orderdetl_view where cfxh='020902_20130503093849' and patid='H2426'
23vm3x08bwmx8	SELECT "INVOICE_INFO"."RCPT_TYPE" , "INVOICE_INFO"."RCPT_NO" , "INVOICE_INFO"."INVOICE_COSTS" , "INVOICE_INFO"."INVOICE_STATUS" , "OUTP_RCPT_MASTER"."PATIENT_ID" , "OUTP_RCPT_MASTER"."NAME" , "OUTP_RCPT_MASTER"."VISIT_DATE" , "OUTP_RCPT_MASTER"."TOTAL_COSTS" , "OUTP_RCPT_MASTER"."TOTAL_CHARGES" , "OUTP_RCPT_MASTER"."OPERATOR_NO" , "INVOICE_INFO"."INVOICE_NO" FROM "OUTP_RCPT_MASTER" , "INVOICE_INFO" WHERE ( "OUTP_RCPT_MASTER"."RCPT_NO" = "INVOICE_INFO"."RCPT_NO" ) and ( ( "INVOICE_INFO"."DISK_NO" = :v_disk_no ) and ( "INVOICE_INFO"."RCPT_TYPE" = :v_rcpt_type ) and ( "OUTP_RCPT_MASTER"."CHARGE_INDICATOR" = 2 ) and ( "INVOICE_INFO"."INVOICE_STATUS" = '00' ) and ( "OUTP_RCPT_MASTER"."TOTAL_COSTS" > 0 ) )
2xfrf3uqhvx2y	select * from ip_orderdetl_view where cfxh='020902_20130503095403' and patid='H2251'
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;
52t34yqvavrgs	SELECT "INP_BILL_DETAIL"."ITEM_CLASS", "INP_BILL_DETAIL"."ITEM_NAME", "INP_BILL_DETAIL"."ITEM_CODE", "INP_BILL_DETAIL"."ITEM_SPEC", "INP_BILL_DETAIL"."UNITS", SUM("INP_BILL_DETAIL"."AMOUNT"), SUM("INP_BILL_DETAIL"."COSTS"), SUM("INP_BILL_DETAIL"."CHARGES"), 0.00 FROM "INP_BILL_DETAIL" WHERE (1=1) and inp_bill_detail.patient_id='YB300772' and inp_bill_detail.billing_date_time>=to_date('2013-04-22', 'yyyy-mm-dd') and inp_bill_detail.billing_date_time<=to_date('2013-05-03', 'yyyy-mm-dd')+1 AND EXISTS (SELECT * FROM PRICE_LIST WHERE INP_BILL_DETAIL.ITEM_CLASS=ITEM_CLASS AND INP_BILL_DETAIL.ITEM_CODE=ITEM_CODE AND CLASS_ON_INP_RCPT='A') GROUP BY "INP_BILL_DETAIL"."ITEM_CLASS", "INP_BILL_DETAIL"."ITEM_NAME", "INP_BILL_DETAIL"."ITEM_CODE", "INP_BILL_DETAIL"."ITEM_SPEC", "INP_BILL_DETAIL"."UNITS"
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
5nrzd228xgq35	select * from ip_orderdetl_view where cfxh='020902_20130503095305' and patid='H2423'
664crkjw8n47y	select dept_code , ward_code from pats_in_hospital where patient_id =:1 and visit_id =:2
6v9vt1b3z196n	select * from ip_orderdetl_view where cfxh='020902_20130503094433' and patid='H2423'
6vgw0rwvyy1at	select * from ip_orderdetl_view where cfxh='020902_20130503093502' and patid='H2273'
6w7jw6pz8tgtg	select * from ip_orderdetl_view where cfxh='020910_20130503094020' and patid='H2281'
79qcfdt9245s8	select * from ip_orderdetl_view where cfxh='020902_20130503094448' and patid='H2351'
8bb6z82ga6xjt	select * from ip_orderdetl_view where cfxh='020902_20130503094409' and patid='H2275'
8kqtg0wu0q3zm	select * from ip_orderdetl_view where cfxh='020902_20130503094929' and patid='H2422'
917rb37awppcz	select * from ip_order_state where (id>0 or id in ('')) and to_char(sysdate, 'yyyy-mm-dd')=to_char(intime, 'yyyy-mm-dd') and intime<sysdate-(5/24/60/60) order by id
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
9ctypd1z0mm86	select * from ip_orderdetl_view where cfxh='020902_20130503093814' 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)))
9mrhw217pc809	select MR_CODE , mr_attr , mr_class from mr_item_index where mr_name =:1 ORDER BY mr_attr desc
9wf2ayf99qr4u	select * from ip_orderdetl_view where cfxh='020910_20130503094100' and patid='H2430'
a7w35qskd8cs0	SELECT MIN ( CLASS_ON_INP_RCPT ) FROM PRICE_LIST WHERE ITEM_CLASS =:1 AND ITEM_CODE =:2
ak0wm8cwnx292	select * from ip_orderdetl_view where cfxh='020902_20130503094519' and patid='H2422'
b28c3w7vfj8ja	select * from ip_orderdetl_view where cfxh='020910_20130503094436' and patid='H2275'
bdauc734ntfwu	select * from ip_orderdetl_view where cfxh='020902_20130503094254' and patid='H2426'
bpx8gjpujp9am	select * from ip_orderdetl_view where cfxh='020910_20130503094458' and patid='H2275'
bv1qvv3f7wwhz	select * from ip_orderdetl_view where cfxh='020910_20130503095257' and patid='H2322'
c69f5n7vyas9s	Select bed_no , diagnosis , patient_condition From pats_in_hospital Where Patient_id =:1 And Visit_id =:2
cg9gf3hspcn6j	select * from ip_orderdetl_view where cfxh='020902_20130503095057' and patid='H2351'
ckh0wnzbb382g	select * from ip_orderdetl_view where cfxh='020902_20130503094014' and patid='H2426'
ckkhf45yaan6w	select to_char ( sysdate , 'yyyymmddhh24miss' ) from dual
cu9pakb7aj79g	INSERT INTO "INP_BILL_DETAIL" ( "PATIENT_ID", "VISIT_ID", "ITEM_NO", "ITEM_CLASS", "ITEM_NAME", "ITEM_CODE", "ITEM_SPEC", "AMOUNT", "UNITS", "CHARGES", "COSTS", "ORDERED_BY", "PERFORMED_BY", "OPERATOR_NO", "BILLING_DATE_TIME" ) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15 )
dhfzf5mz6davp	select * from ip_orderdetl_view where cfxh='020902_20130503093911' and patid='H2421'
dzxr7ym0tkjrw	SELECT "ORDERS_COSTS"."ITEM_NAME", "ORDERS_COSTS"."AMOUNT", "ORDERS_COSTS"."UNITS", "ORDERS_COSTS"."ITEM_CODE", "ORDERS_COSTS"."ITEM_CLASS", "ORDERS_COSTS"."ITEM_NO", "ORDERS_COSTS"."ORDER_SUB_NO", "ORDERS_COSTS"."ORDER_NO", "ORDERS_COSTS"."VISIT_ID", "ORDERS_COSTS"."PATIENT_ID", "ORDERS_COSTS"."COSTS", "ORDERS_COSTS"."ITEM_SPEC" FROM "ORDERS_COSTS" WHERE (PATIENT_ID = :p_id ) AND (VISIT_ID = :v_id )
f0wzs9nc663bn	select sysdate from dual
ffqn6432btzs2	select * from ip_orderdetl_view where cfxh='020902_20130503094913' and patid='H2275'
fubr4x8z5w0t5	SELECT "DOCTOR_ORDERS"."ENTER_DATE_TIME" , "PAT_MASTER_INDEX"."NAME" , "PATS_IN_HOSPITAL"."BED_NO" , "DOCTOR_ORDERS"."ORDER_TEXT" , "DOCTOR_ORDERS"."DOSAGE" , "DOCTOR_ORDERS"."DOSAGE_UNITS" , "DOCTOR_ORDERS"."ADMINISTRATION" , "DOCTOR_ORDERS"."FREQUENCY" , "DOCTOR_ORDERS"."DOCTOR" , "DOCTOR_ORDERS"."NURSE" , "DOCTOR_ORDERS"."DURATION" , "DOCTOR_ORDERS"."DURATION_UNITS" , "DOCTOR_ORDERS"."FREQ_DETAIL" , "DOCTOR_ORDERS"."ORDER_NO" , "DOCTOR_ORDERS"."ORDER_SUB_NO" , "DOCTOR_ORDERS"."ORDER_STATUS" , "DOCTOR_ORDERS"."PATIENT_ID" , "DOCTOR_ORDERS"."VISIT_ID" , "DOCTOR_ORDERS"."ORDER_CLASS" , "DOCTOR_ORDERS"."REPEAT_INDICATOR" , "DOCTOR_ORDERS"."START_STOP_INDICATOR" , "DOCTOR_ORDERS"."FREQ_INTERVAL" , "DOCTOR_ORDERS"."FREQ_INTERVAL_UNIT" , "DOCTOR_ORDERS"."ORDERING_DEPT" , "DOCTOR_ORDERS"."ORDER_PRINT_INDICATOR" , "DOCTOR_ORDERS"."RELATED_ORDER_NO" , "DOCTOR_ORDERS"."RELATED_ORDER_SUB_NO" , "DOCTOR_ORDERS"."ORDER_CODE" , "DOCTOR_ORDERS"."PROCESSING_DATE_TIME" , "DOCTOR_ORDERS"."BILLING_ATTR" , "PAT_MASTER_INDEX"."NAME_PHONETIC" , "DOCTOR_ORDERS"."START_DATE_TIME" , "DOCTOR_ORDERS"."DRUG_BILLING_ATTR" , "DOCTOR_ORDERS"."FRE Q_COUNTER" , "BED_REC"."BED_LABEL" FROM "DOCTOR_ORDERS" , "PAT_MASTER_INDEX" , "PATS_IN_HOSPITAL" , "BED_REC" WHERE ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "PAT_MASTER_INDEX"."PATIENT_ID" ) and ( "PATS_IN_HOSPITAL"."PATIENT_ID" = "DOCTOR_ORDERS"."PATIENT_ID" ) and ( "PATS_IN_HOSPITAL"."VISIT_ID" = "DOCTOR_ORDERS"."VISIT_ID" ) and ( "PATS_IN_HOSPITAL"."WARD_CODE" = "BED_REC"."WARD_CODE" ) and ( "PATS_IN_HOSPITAL"."BED_NO" = "BED_REC"."BED_NO" ) and ( "PATS_IN_HOSPITAL"."WARD_CODE" = :wardcode ) AND "DOCTOR_ORDERS"."ORDER_STATUS"='1'
g2tcdkz3sy3h2	Select bed_label From bed_rec Where ward_code =:1 And bed_no =:2
g7x6164st8ad7	select * from ip_orderdetl_view where cfxh='020902_20130503094947' and patid='H2275'
gc6yu383b2k8z	select * from ip_orderdetl_view where cfxh='020910_20130503095037' and patid='H2421'
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 )

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	118,736	32.88	9.23
CPU used when call started	118,908	32.93	9.25
CR blocks created	11,741	3.25	0.91
Cached Commit SCN referenced	48	0.01	0.00
Commit SCN cached	1	0.00	0.00
DB time	1,228,263	340.15	95.52
DBWR checkpoint buffers written	18,522	5.13	1.44
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	112	0.03	0.01
DBWR undo block writes	2,290	0.63	0.18
IMU CR rollbacks	860	0.24	0.07
IMU Flushes	2,169	0.60	0.17
IMU Redo allocation size	19,470,180	5,391.97	1,514.13
IMU commits	8,143	2.26	0.63
IMU contention	97	0.03	0.01
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	8	0.00	0.00
IMU recursive-transaction flush	33	0.01	0.00
IMU undo allocation size	60,534,752	16,764.19	4,707.58
IMU- failed to get a private strand	8	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	0	0.00	0.00
SQL*Net roundtrips to/from client	2,018,658	559.04	156.98
active txn count during cleanout	15,031	4.16	1.17
application wait time	10,469	2.90	0.81
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	15,174	4.20	1.18
branch node splits	1	0.00	0.00
buffer is not pinned count	10,582,366	2,930.63	822.95
buffer is pinned count	115,872,786	32,089.22	9,011.03
bytes received via SQL*Net from client	244,017,718	67,577.02	18,976.41
bytes sent via SQL*Net to client	486,649,731	134,770.29	37,845.07
calls to get snapshot scn: kcmgss	643,224	178.13	50.02
calls to kcmgas	29,239	8.10	2.27
calls to kcmgcs	1,707	0.47	0.13
change write time	286	0.08	0.02
cleanout - number of ktugct calls	12,817	3.55	1.00
cleanouts and rollbacks - consistent read gets	11,537	3.19	0.90
cleanouts only - consistent read gets	127	0.04	0.01
cluster key scan block gets	23,770	6.58	1.85
cluster key scans	6,732	1.86	0.52
commit batch/immediate performed	161	0.04	0.01
commit batch/immediate requested	161	0.04	0.01
commit cleanout failures: block lost	7	0.00	0.00
commit cleanout failures: buffer being written	1	0.00	0.00
commit cleanout failures: callback failure	88	0.02	0.01
commit cleanout failures: cannot pin	68	0.02	0.01
commit cleanouts	43,991	12.18	3.42
commit cleanouts successfully completed	43,827	12.14	3.41
commit immediate performed	161	0.04	0.01
commit immediate requested	161	0.04	0.01
commit txn count during cleanout	2,076	0.57	0.16
concurrency wait time	389,839	107.96	30.32
consistent changes	118,020	32.68	9.18
consistent gets	52,765,843	14,612.70	4,103.42
consistent gets - examination	29,837,988	8,263.18	2,320.40
consistent gets direct	0	0.00	0.00
consistent gets from cache	52,765,842	14,612.70	4,103.42
current blocks converted for CR	2	0.00	0.00
cursor authentications	2,451	0.68	0.19
data blocks consistent reads - undo records applied	117,391	32.51	9.13
db block changes	304,217	84.25	23.66
db block gets	333,477	92.35	25.93
db block gets direct	23	0.01	0.00
db block gets from cache	333,454	92.35	25.93
deferred (CURRENT) block cleanout applications	23,489	6.50	1.83
dirty buffers inspected	42	0.01	0.00
enqueue conversions	1,900	0.53	0.15
enqueue releases	86,210	23.87	6.70
enqueue requests	86,233	23.88	6.71
enqueue timeouts	7	0.00	0.00
enqueue waits	53	0.01	0.00
exchange deadlocks	0	0.00	0.00
execute count	537,338	148.81	41.79
failed probes on index block reclamation	2	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	9,009,781	2,495.12	700.66
free buffer requested	9,015,510	2,496.71	701.11
heap block compress	3,779	1.05	0.29
hot buffers moved to head of LRU	14,010	3.88	1.09
immediate (CR) block cleanout applications	11,664	3.23	0.91
immediate (CURRENT) block cleanout applications	4,069	1.13	0.32
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	10,127	2.80	0.79
index fast full scans (full)	379	0.10	0.03
index fetch by key	28,652,022	7,934.74	2,228.17
index scans kdiixs1	298,116	82.56	23.18
leaf node 90-10 splits	42	0.01	0.00
leaf node splits	237	0.07	0.02
lob reads	2	0.00	0.00
lob writes	27	0.01	0.00
lob writes unaligned	27	0.01	0.00
logons cumulative	1,485	0.41	0.12
messages received	25,275	7.00	1.97
messages sent	25,275	7.00	1.97
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	22,778,988	6,308.30	1,771.44
opened cursors cumulative	62,194	17.22	4.84
parse count (failures)	344	0.10	0.03
parse count (hard)	14,348	3.97	1.12
parse count (total)	551,079	152.61	42.86
parse time cpu	4,106	1.14	0.32
parse time elapsed	303,368	84.01	23.59
physical read IO requests	638,793	176.90	49.68
physical read bytes	73,726,197,760	20,417,356.88	5,733,431.66
physical read total IO requests	652,638	180.74	50.75
physical read total bytes	74,038,556,672	20,503,859.97	5,757,722.74
physical read total multi block requests	586,138	162.32	45.58
physical reads	8,999,780	2,492.35	699.88
physical reads cache	8,999,698	2,492.33	699.88
physical reads cache prefetch	8,361,012	2,315.46	650.21
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,247	4.22	1.19
physical write bytes	158,130,176	43,791.76	12,297.24
physical write total IO requests	36,171	10.02	2.81
physical write total bytes	424,865,792	117,660.16	33,040.34
physical write total multi block requests	11,196	3.10	0.87
physical writes	19,303	5.35	1.50
physical writes direct	105	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	19,198	5.32	1.49
physical writes non checkpoint	7,161	1.98	0.56
pinned buffers inspected	11	0.00	0.00
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	1	0.00	0.00
process last non-idle time	3,645	1.01	0.28
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	346,834	96.05	26.97
recursive cpu usage	4,018	1.11	0.31
redo blocks written	100,599	27.86	7.82
redo buffer allocation retries	1	0.00	0.00
redo entries	123,373	34.17	9.59
redo log space requests	1	0.00	0.00
redo log space wait time	12	0.00	0.00
redo ordering marks	1,560	0.43	0.12
redo size	46,988,260	13,012.69	3,654.11
redo subscn max counts	4,567	1.26	0.36
redo synch time	85,617	23.71	6.66
redo synch writes	10,274	2.85	0.80
redo wastage	2,843,892	787.57	221.16
redo write time	48,043	13.30	3.74
redo writer latching time	12	0.00	0.00
redo writes	10,074	2.79	0.78
rollback changes - undo records applied	5,498	1.52	0.43
rollbacks only - consistent read gets	216	0.06	0.02
rows fetched via callback	487,480	135.00	37.91
session connect time	0	0.00	0.00
session cursor cache hits	433,393	120.02	33.70
session logical reads	53,099,318	14,705.05	4,129.35
session pga memory	128,852,840	35,683.85	10,020.44
session pga memory max	242,640,392	67,195.59	18,869.30
session uga memory	###############	73,760,048.57	20,712,680.90
session uga memory max	937,161,272	259,532.66	72,879.79
shared hash latch upgrades - no wait	21,388	5.92	1.66
shared hash latch upgrades - wait	11	0.00	0.00
sorts (memory)	43,062	11.93	3.35
sorts (rows)	1,424,703	394.55	110.79
sql area evicted	1,072	0.30	0.08
sql area purged	344	0.10	0.03
summed dirty queue length	44	0.01	0.00
switch current to new buffer	2,021	0.56	0.16
table fetch by rowid	34,736,104	9,619.64	2,701.31
table fetch continued row	16,191	4.48	1.26
table scan blocks gotten	12,852,885	3,559.41	999.52
table scan rows gotten	1,046,622,641	289,846.33	81,392.23
table scans (cache partitions)	0	0.00	0.00
table scans (long tables)	98	0.03	0.01
table scans (short tables)	42,846	11.87	3.33
total number of times SMON posted	0	0.00	0.00
transaction rollbacks	161	0.04	0.01
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,324,580	4,243.91	1,191.74
user I/O wait time	153,592	42.53	11.94
user calls	2,019,906	559.38	157.08
user commits	10,155	2.81	0.79
user rollbacks	2,704	0.75	0.21
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	28,811	7.98	2.24
write clones created in background	0	0.00	0.00
write clones created in foreground	26	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,415,823	1,428,067
opened cursors current	971	1,089
workarea memory allocated	0	312
logons current	325	358

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	1.99

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	567,418	157	1.07	15.17	1,015	0	29	61.03
TSP_OUTPBILL	33,385	9	3.53	4.61	2,159	1	0	0.00
TSP_MEDREC	5,556	2	30.75	1.11	2,584	1	99	94.44
TSP_INPBILL	5,378	1	23.50	1.00	2,454	1	12	0.83
TSP_ORDADM	3,222	1	38.11	1.00	2,121	1	0	0.00
USERS	4,076	1	9.40	8.44	463	0	0	0.00
TSP_OUTPADM	1,876	1	41.66	1.01	1,074	0	0	0.00
TSP_EXAM	1,268	0	9.32	2.15	347	0	0	0.00
TSP_CPR	463	0	66.05	1.00	702	0	4	0.00
TSP_INSURANCE	454	0	42.69	1.00	522	0	0	0.00
SYSTEM	796	0	40.94	1.18	117	0	3	250.00
TSP_INPADM	476	0	28.28	1.03	255	0	74	88.92
SYSAUX	248	0	42.62	1.01	383	0	0	0.00
TSP_LAB	182	0	40.11	1.00	409	0	0	0.00
TSP_COMM	570	0	62.70	1.13	14	0	1	20.00
UNDOTBS1	10	0	58.00	1.00	288	0	7	1.43
TSP_CARD	110	0	70.18	1.00	90	0	0	0.00
TSP_ECONSTAT	77	0	8.31	1.00	75	0	0	0.00
TSP_MATERIAL	107	0	91.68	3.50	23	0	0	0.00
TSP_INFO	64	0	20.94	2.56	11	0	0	0.00
TSP_MEDADM	32	0	16.25	1.00	2	0	0	0.00
TSP_EQUIPMENT	21	0	10.48	4.24	2	0	0	0.00
TSP_SURGERY	8	0	81.25	1.00	14	0	0	0.00
TSP_BLDBANK	7	0	67.14	1.14	2	0	0	0.00
TSP_ACCT	2	0	10.00	1.00	2	0	0	0.00
TSP_ASSESS	2	0	135.00	1.00	2	0	0	0.00
TSP_ASSET	2	0	10.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	60.00	1.00	2	0	0	0.00
TSP_HACCOUNT	2	0	55.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	20.00	1.00	2	0	0	0.00
TSP_INFECTION	2	0	110.00	1.00	2	0	0	0.00
TSP_INSURANCE_SUM	2	0	105.00	1.00	2	0	0	0.00
TSP_JS	2	0	65.00	1.00	2	0	0	0.00
TSP_KQMZGL	2	0	50.00	1.00	2	0	0	0.00
TSP_TUMOUR	2	0	55.00	1.00	2	0	0	0.00
TSP_YZYLS	2	0	60.00	1.00	2	0	0	0.00
TSP_ZLBR	2	0	50.00	1.00	2	0	0	0.00
XC	2	0	55.00	1.00	2	0	0	0.00
Z2002_DATA	2	0	55.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	248	0	42.62	1.01	383	0	0	0.00
SYSTEM	/u02/oradata/orcl/system01.dbf	796	0	40.94	1.18	117	0	3	250.00
TSP_ACCT	/u02/oradata/orcl/APACCT.DBF	2	0	10.00	1.00	2	0	0	0.00
TSP_ASSESS	/u02/oradata/orcl/APASSESS.DBF	2	0	135.00	1.00	2	0	0	0.00
TSP_ASSET	/u02/oradata/orcl/ASSET.DBF	2	0	10.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	60.00	1.00	2	0	0	0.00
TSP_BLDBANK	/u02/oradata/orcl/APBLDBANK.DBF	7	0	67.14	1.14	2	0	0	0.00
TSP_CARD	/u02/oradata/orcl/APCARD.DBF	110	0	70.18	1.00	90	0	0	0.00
TSP_COMM	/u02/oradata/orcl/APCOMM.DBF	570	0	62.70	1.13	14	0	1	20.00
TSP_CPR	/u02/oradata/orcl/APCPR.DBF	463	0	66.05	1.00	702	0	4	0.00
TSP_ECONSTAT	/u02/oradata/orcl/APECONSTAT.DBF	77	0	8.31	1.00	75	0	0	0.00
TSP_EQUIPMENT	/u02/oradata/orcl/APEQUIPMENT.DBF	21	0	10.48	4.24	2	0	0	0.00
TSP_EXAM	/u02/oradata/orcl/APEXAM.DBF	1,268	0	9.32	2.15	347	0	0	0.00
TSP_HACCOUNT	/u02/oradata/orcl/HACCOUNT.ORA	2	0	55.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	20.00	1.00	2	0	0	0.00
TSP_INFECTION	/u02/oradata/ORCLINFECTION.DBF	2	0	110.00	1.00	2	0	0	0.00
TSP_INFO	/u02/oradata/orcl/APINFO.DBF	64	0	20.94	2.56	11	0	0	0.00
TSP_INPADM	/u02/oradata/orcl/APINPADM.DBF	476	0	28.28	1.03	255	0	74	88.92
TSP_INPBILL	/u02/oradata/orcl/APINPBILL.DBF	5,378	1	23.50	1.00	2,454	1	12	0.83
TSP_INSURANCE	/u02/oradata/orcl/APINSURANCE.DBF	454	0	42.69	1.00	522	0	0	0.00
TSP_INSURANCE_SUM	/u02/oradata/orcl/datafile/O1_MF_TSP_INSU_75H7Z9VT_.	2	0	105.00	1.00	2	0	0	0.00
TSP_JS	/u02/oradata/orcl/JS.DBF	2	0	65.00	1.00	2	0	0	0.00
TSP_KQMZGL	/u02/oradata/orcl/APKQMZGL.DBF	2	0	50.00	1.00	2	0	0	0.00
TSP_LAB	/u02/oradata/orcl/APLAB.DBF	182	0	40.11	1.00	409	0	0	0.00
TSP_MATERIAL	/u02/oradata/orcl/APMATERIAL.DBF	107	0	91.68	3.50	23	0	0	0.00
TSP_MEDADM	/u02/oradata/orcl/APMEDADM.DBF	32	0	16.25	1.00	2	0	0	0.00
TSP_MEDREC	/u02/oradata/orcl/APMEDREC.DBF	5,556	2	30.75	1.11	2,584	1	99	94.44
TSP_ORDADM	/u02/oradata/orcl/APORDADM.DBF	3,222	1	38.11	1.00	2,121	1	0	0.00
TSP_OUTPADM	/u02/oradata/orcl/APOUTPADM.DBF	1,876	1	41.66	1.01	1,074	0	0	0.00
TSP_OUTPBILL	/u02/oradata/orcl/APOUTPBILL.DBF	33,385	9	3.53	4.61	2,159	1	0	0.00
TSP_PHARMACY	/u02/oradata/orcl/APPHARMACY.DBF	567,418	157	1.07	15.17	1,015	0	29	61.03
TSP_SURGERY	/u02/oradata/orcl/APSURGERY.DBF	8	0	81.25	1.00	14	0	0	0.00
TSP_TUMOUR	/u02/oradata/orcl/APTUMOUR.DBF	2	0	55.00	1.00	2	0	0	0.00
TSP_YZYLS	/u02/oradata/orcl/APYZYLS.DBF	2	0	60.00	1.00	2	0	0	0.00
TSP_ZLBR	/u02/oradata/orcl/APZLBR.DBF	2	0	50.00	1.00	2	0	0	0.00
UNDOTBS1	/u02/oradata/orcl/undotbs01.dbf	10	0	58.00	1.00	288	0	7	1.43
USERS	/u02/oradata/orcl/users01.dbf	4,076	1	9.40	8.44	463	0	0	0.00
XC	/u02/oradata/orcl/XC.DBF	2	0	55.00	1.00	2	0	0	0.00
Z2002_DATA	/u02/oradata/orcl/DATA01.DBF	2	0	55.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	211,820	83	53,003,825	8,936,504	19,173	0	0	232

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	2140	11865	38372	184320	38372
E	0	12	1845	13082	63487	184320	63487

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	160	0.09	19,790	1.27	496,357,731
D	320	0.18	39,580	1.18	461,079,566
D	480	0.28	59,370	1.12	436,883,069
D	640	0.37	79,160	1.08	421,355,997
D	800	0.46	98,950	1.05	410,985,334
D	960	0.55	118,740	1.03	403,743,544
D	1,120	0.64	138,530	1.02	398,683,561
D	1,280	0.73	158,320	1.01	395,262,141
D	1,440	0.83	178,110	1.01	393,028,116
D	1,600	0.92	197,900	1.00	391,581,551
D	1,744	1.00	215,711	1.00	390,703,912
D	1,760	1.01	217,690	1.00	390,606,372
D	1,920	1.10	237,480	1.00	389,920,486
D	2,080	1.19	257,270	1.00	389,375,523
D	2,240	1.28	277,060	1.00	388,923,789
D	2,400	1.38	296,850	0.99	388,519,604
D	2,560	1.47	316,640	0.99	388,126,206
D	2,720	1.56	336,430	0.99	387,724,363
D	2,880	1.65	356,220	0.99	387,306,556
D	3,040	1.74	376,010	0.99	386,872,378
D	3,200	1.83	395,800	0.99	386,426,776

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,863	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	711	563.83	0.00	0.00	0.00	0.00	102,400
E	1,000	688	625.87	0.30	0.05	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	24,367	24,367
64K	128K	84	84
128K	256K	202	202
256K	512K	42	42
512K	1024K	1,900	1,900
1M	2M	2,189	2,189
2M	4M	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	302,549.97	29,556.26	91.00	4,421
250	0.25	302,549.97	4,921.90	98.00	1,035
500	0.50	302,549.97	379.42	100.00	0
750	0.75	302,549.97	379.42	100.00	0
1,000	1.00	302,549.97	379.42	100.00	0
1,200	1.20	302,549.97	114.55	100.00	0
1,400	1.40	302,549.97	114.55	100.00	0
1,600	1.60	302,549.97	114.55	100.00	0
1,800	1.80	302,549.97	114.55	100.00	0
2,000	2.00	302,549.97	114.55	100.00	0
3,000	3.00	302,549.97	114.55	100.00	0
4,000	4.00	302,549.97	114.55	100.00	0
6,000	6.00	302,549.97	114.55	100.00	0
8,000	8.00	302,549.97	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
864	0.39	258	25,833	1,902,691	0.82	455,973	10.86	71,089,432
1,088	0.49	474	35,509	2,047,950	0.88	310,714	7.40	71,209,915
1,312	0.59	697	48,378	2,157,462	0.93	201,202	4.79	71,305,022
1,536	0.70	920	60,312	2,227,931	0.96	130,733	3.11	71,374,439
1,760	0.80	1,143	72,659	2,272,222	0.98	86,442	2.06	71,427,468
1,984	0.90	1,366	84,072	2,299,643	0.99	59,021	1.41	71,469,872
2,208	1.00	1,589	96,639	2,316,674	1.00	41,990	1.00	71,504,502
2,432	1.10	1,812	110,513	2,327,664	1.00	31,000	0.74	71,533,097
2,656	1.20	2,035	123,913	2,335,377	1.01	23,287	0.55	71,557,221
2,880	1.30	2,258	138,045	2,340,417	1.01	18,247	0.43	71,578,076
3,104	1.41	2,481	150,583	2,343,372	1.01	15,292	0.36	71,596,505
3,328	1.51	2,704	163,500	2,345,459	1.01	13,205	0.31	71,613,338
3,552	1.61	2,927	177,044	2,347,281	1.01	11,383	0.27	71,629,212
3,776	1.71	3,150	189,571	2,349,022	1.01	9,642	0.23	71,644,626
4,000	1.81	3,373	202,447	2,350,748	1.01	7,916	0.19	71,659,856
4,224	1.91	3,596	217,117	2,352,473	1.02	6,191	0.15	71,675,016
4,448	2.01	3,819	231,599	2,354,197	1.02	4,467	0.11	71,690,119

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	456,964	420,340,806
3,000	0.75	261,054	402,800,563
4,000	1.00	199,035	390,651,307
5,000	1.25	178,156	389,010,572
6,000	1.50	169,578	387,994,878
7,000	1.75	161,616	386,393,208
8,000	2.00	157,437	385,494,710

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	222	18	83
undo block	7	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)	5	5	0	5	107	21,388.00
CF-Controlfile Transaction	4,393	4,386	7	38	23	613.42
TX-Transaction (index contention)	8	8	0	8	1	143.75

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.64	16,312	2,442	9	15/51.7	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 10:03	505	2,796	83	9	15	0/0	0/0/0/0/0/0
03-May 09:53	468	2,840	33	7	15	0/0	0/0/0/0/0/0
03-May 09:43	382	2,625	22	5	15	0/0	0/0/0/0/0/0
03-May 09:33	258	2,285	2,442	6	52	0/0	0/0/0/0/0/0
03-May 09:23	233	1,422	1,841	3	42	0/0	0/0/0/0/0/0
03-May 09:13	347	2,003	1,627	4	38	0/0	0/0/0/0/0/0
03-May 09:03	450	2,341	1,027	5	28	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,321	0.00		0	0
AWR Alerted Metric Element list	33,130	0.00		0	0
Consistent RBA	10,036	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	36	0.00		0	0
FOB s.o list latch	1,830	0.00		0	0
In memory undo latch	104,235	0.01	0.89	0	11,590	0.00
JS mem alloc latch	4	0.00		0	0
JS queue access latch	4	0.00		0	0
JS queue state obj latch	26,170	0.00		0	0
JS slv state obj latch	16	0.00		0	0
KMG MMAN ready and startup request latch	1,408	0.00		0	0
KMG resize request state object freelist	8	0.00		0	0
KTF sga latch	7	0.00		0	1,167	0.00
KWQMN job cache list latch	17	0.00		0	0
MQL Tracking Latch	0			0	73	0.00
Memory Management Latch	292	0.00		0	1,408	0.00
OS process	4,170	0.00		0	0
OS process allocation	4,023	0.00		0	0
OS process: request allocation	2,799	0.00		0	0
PL/SQL warning settings	6,029	0.00		0	0
SGA IO buffer pool latch	1	0.00		0	1	0.00
SQL memory manager latch	1	0.00		0	1,160	0.00
SQL memory manager workarea list latch	95,435	0.00		0	0
Shared B-Tree	129	0.00		0	0
active checkpoint queue latch	19,654	0.00		0	0
active service list	12,234	0.02	0.50	0	1,681	0.00
archive control	194	0.00		0	0
archive process latch	1,322	0.08	1.00	0	0
begin backup scn array	4	0.00		0	0
buffer pool	27	0.00		0	0
cache buffer handles	12,142	0.00		0	0
cache buffers chains	86,035,553	0.04	0.00	0	18,064,141	0.00
cache buffers lru chain	88,634	0.05	0.09	0	18,751,550	0.01
cache table scan latch	0			0	578,657	0.00
channel handle pool latch	2,798	0.00		0	0
channel operations parent latch	20,781	0.00		0	0
checkpoint queue latch	165,529	0.00	0.00	0	63,103	0.00
client/application info	9,935	0.00		0	0
commit callback allocation	18	0.00		0	0
compile environment latch	1,479	0.00		0	0
dml lock allocation	41,625	0.01	0.00	0	0
dummy allocation	2,923	0.00		0	0
enqueue hash chains	173,809	0.01	0.07	0	816	0.00
enqueues	127,172	0.08	0.15	0	0
event group latch	1,416	0.00		0	0
file cache latch	341	0.00		0	0
global KZLD latch for mem in SGA	1,416	0.00		0	0
hash table column usage latch	355	0.00		0	450,943	0.00
hash table modification latch	111	0.00		0	0
job workq parent latch	0			0	124	0.00
job_queue_processes parameter latch	123	0.00		0	0
kks stats	32,954	0.26	1.07	5	0
kokc descriptor allocation latch	50	0.00		0	0
ksuosstats global area	244	0.00		0	0
ktm global data	12	0.00		0	0
kwqbsn:qsga	129	0.00		0	0
lgwr LWN SCN	10,105	0.05	0.00	0	0
library cache	2,599,612	0.88	0.83	1915	8,566	1.48
library cache load lock	1,060	0.00		0	0
library cache lock	2,749,737	0.02	0.01	0	0
library cache lock allocation	12,233	0.01	0.00	0	0
library cache pin	304,795	0.02	0.12	0	0
library cache pin allocation	7,353	0.01	0.00	0	0
list of block allocation	1,550	0.00		0	0
loader state object freelist	26	0.00		0	0
longop free list parent	81	0.00		0	82	0.00
messages	92,462	0.01	0.10	0	0
mostly latch-free SCN	10,083	0.02	0.00	0	0
multiblock read objects	1,221,942	0.00	0.00	0	0
ncodef allocation latch	80	0.00		0	0
object queue header heap	20,082	0.00		0	346	0.00
object queue header operation	17,858,733	0.00	0.10	0	45,240	0.00
object stats modification	4	0.00		0	0
parallel query alloc buffer	468	0.00		0	0
parameter list	6,312	0.00		0	0
parameter table allocation management	1,458	0.27	0.75	1	0
post/wait queue	15,324	0.00		0	10,292	0.00
process allocation	2,798	0.18	1.00	0	1,416	0.00
process group creation	2,798	0.00		0	0
qmn task queue latch	516	0.00		0	0
redo allocation	54,145	0.00	0.00	0	123,199	0.11
redo copy	0			0	123,258	0.04
redo writing	52,522	0.00	1.00	0	0
resmgr group change latch	1,750	0.00		0	0
resmgr:active threads	2,923	0.00		0	0
resmgr:actses change group	1,462	0.00		0	0
resmgr:actses change state	1	0.00		0	0
resmgr:free threads list	2,920	0.00		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,738,212	0.15	0.08	13	1,225	0.65
rules engine aggregate statistics	7	0.00		0	0
rules engine rule set statistics	14	0.00		0	0
sequence cache	21,953	0.02	0.00	0	0
session allocation	68,746	0.06	0.20	0	0
session idle bit	4,058,932	0.00	0.00	0	0
session state list latch	3,334	0.00		0	0
session switching	91	0.00		0	0
session timer	1,681	0.00		0	0
shared pool	1,604,653	2.69	0.62	1956	0
shared pool sim alloc	187	0.00		0	0
shared pool simulator	1,497,240	0.00	0.18	0	0
simulator hash latch	4,352,518	0.00	0.00	0	0
simulator lru latch	20,048	0.03	0.50	0	3,208,274	0.06
slave class	2	0.00		0	0
slave class create	8	12.50	1.00	0	0
sort extent pool	110	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
threshold alerts latch	1,110	0.00		0	0
transaction allocation	1,176	0.00		0	0
transaction branch allocation	1,681	0.00		0	0
undo global data	95,041	0.00	0.00	0	87	0.00
user lock	5,980	0.57	1.00	3	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,604,653	43,113	26,635	19,929
cache buffers chains	86,035,553	33,700	69	33,632
library cache	2,599,612	22,858	18,987	5,253
row cache objects	1,738,212	2,653	220	2,441
library cache lock	2,749,737	447	6	441
enqueues	127,172	105	16	89
kks stats	32,954	85	91	14
library cache pin	304,795	66	8	58
shared pool simulator	1,497,240	60	11	49
object queue header operation	17,858,733	50	5	45
cache buffers lru chain	88,634	47	4	43
session allocation	68,746	44	9	35
user lock	5,980	34	34	1
enqueue hash chains	173,809	15	1	14
messages	92,462	10	1	9
In memory undo latch	104,235	9	8	1
simulator lru latch	20,048	6	3	3
process allocation	2,798	5	5	0
parameter table allocation management	1,458	4	3	1
active service list	12,234	2	1	1
archive process latch	1,322	1	1	0
redo writing	52,522	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	5	5
In memory undo latch	kticmt: child	3	2
In memory undo latch	ktichg: child	1	2
active service list	ksws_event: ksws event	1	1
archive process latch	kcrrsarc	1	0
cache buffers chains	kcbgtcr: kslbegin excl	84	80
cache buffers chains	kcbrls: kslbegin	21	33
cache buffers chains	kcbchg: kslbegin: bufs not pinned	13	9
cache buffers chains	kcbgcur: kslbegin	11	9
cache buffers chains	kcbgtcr: fast path	11	5
cache buffers chains	kcbgtcr: kslbegin shared	9	7
cache buffers chains	kcbzwb	4	2
cache buffers chains	kcbzgb: scan from tail. nowait	1	0
cache buffers chains	kcbzib: multi-block read: nowait	1	0
cache buffers lru chain	kcbzgws	4	0
cost function	kzulrl	18	20
cost function	kzulgt: find user res	16	14
enqueue hash chains	ksqgtl3	1	1
enqueues	ksqgel: create enqueue	12	3
enqueues	ksqdel	3	11
enqueues	ksqies	1	2
kks stats	kks stats alloc/free	91	91
library cache	kglLockCursor	5,248	5,142
library cache	kgldti: 2child	3,093	446
library cache	kglobpn: child:	2,370	2,671
library cache	kglpndl: child: after processing	1,942	36
library cache	kglhdgn: child:	979	4,270
library cache	kglhdgc: child:	849	45
library cache	kgldte: child 0	728	1,518
library cache	kglpin	392	222
library cache	kglnti	282	40
library cache	kglpndl: child: before processing	124	1,273
library cache	kglpnp: child	107	431
library cache	kglati	93	13
library cache	kglukp: child	88	158
library cache	kglobld	50	420
library cache	kglScanDependency	10	1
library cache	kglic	3	8
library cache	kglini: child	2	5
library cache	kglpur: child	1	3
library cache lock	kgllkdl: child: no lock handle	2,511	2,220
library cache lock	kgllkal: child: multiinstance	3	2
library cache lock	kgllkdl: child: cleanup	3	4
library cache pin	kglpnal: child: alloc space	5	4
library cache pin	kglpndl	3	6
messages	ksaamb: after wakeup	1	0
object queue header operation	kcbo_switch_cq	17	0
parameter table allocation management	ksp_param_table_free	3	3
process allocation	ksucrp	5	0
redo writing	kcrfwcr	1	1
row cache objects	kqreqd: reget	128	0
row cache objects	kqrpre: find obj	61	202
row cache objects	kqreqd	16	5
row cache objects	kqrso	6	3
row cache objects	kqrpre: init complete	3	3
session allocation	ksuxds: KSUSFCLC not set	7	3
session allocation	ksudlp	1	0
session allocation	ksuxds: not user session	1	3
shared pool	kghalo	17,607	8,411
shared pool	kghupr1	4,264	15,485
shared pool	kghalp	3,954	1,562
shared pool	kghfre	549	1,038
shared pool	kghasp	85	20
shared pool	kghfrunp: alloc: wait	76	28
shared pool	kgh_next_free	75	28
shared pool	kghfrunp: clatch: wait	68	72
shared pool	kghfrunp: clatch: nowait	56	0
shared pool	kghfree_extents: scan	11	52
shared pool	kghfrh	10	0
shared pool	kgh: add extent to reserved list	6	12
shared pool	kgh: sim resz update	1	2
shared pool simulator	kglsim_upd_newhp	9	0
shared pool simulator	kglsim_unpin_simhp	1	5
shared pool simulator	kglsim_unpin_simhp: fast path	1	6
simulator lru latch	kcbs_shrink_pool	2	0
simulator lru latch	kcbs_resize_pool : interpolation	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: 53,099,318
Captured Segments account for 96.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
INPADM	TSP_INPADM	PK_PATS_IN_HOSPITAL	INDEX	28,310,464	53.32
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	8,642,048	16.28
PHARMACY	TSP_PHARMACY	DRUG_PRESC_MASTER_TEMP	TABLE	6,331,696	11.92
PHARMACY	TSP_PHARMACY	IP_ORDER_STATE	TABLE	1,153,824	2.17
ORDADM	TSP_ORDADM	DOCTOR_ORDERS	TABLE	975,792	1.84

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 8,999,780
Captured Segments account for 97.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
PHARMACY	TSP_PHARMACY	DRUG_DISPENSE_REC	TABLE	8,561,437	95.13
OUTPBILL	TSP_OUTPBILL	INVOICE_INFO	TABLE	100,222	1.11
OUTPBILL	TSP_OUTPBILL	OUTP_RCPT_MASTER	TABLE	48,830	0.54
PHARMACY	USERS	PRESCRIPTION	TABLE	34,166	0.38
INPBILL	TSP_INPBILL	INP_BILL_DETAIL	TABLE	3,947	0.04

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
HQC	TSP_INPBILL	IND_ASACCT_STAT	INDEX	4	33.33
INPBILL	TSP_INPBILL	PK_INP_BILL_DETAIL	INDEX	4	33.33
CPR	TSP_CPR	PK_DOCTOR_ACTION_LOG	INDEX	2	16.67
PHARMACY	TSP_PHARMACY	PK_IP_ORDER_STATE	INDEX	2	16.67

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	12	54.55
CPR	TSP_CPR	PK_DOCTOR_ACTION_LOG	INDEX	4	18.18
SYS	SYSTEM	SEQ$	TABLE	3	13.64
PHARMACY	TSP_PHARMACY	PK_IP_ORDER_STATE	INDEX	2	9.09
INPADM	TSP_INPADM	PATS_IN_HOSPITAL	TABLE	1	4.55

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	66	0.00	2	1
dc_database_links	2,832	0.00	0	1
dc_global_oids	330	0.00	0	35
dc_histogram_data	194,616	0.29	0	11,001
dc_histogram_defs	66,070	0.50	0	5,463
dc_object_grants	20,713	0.00	0	445
dc_object_ids	89,388	0.05	0	1,499
dc_objects	48,951	2.79	5	8,316
dc_profiles	1,476	0.00	0	1
dc_rollback_segments	619	0.00	0	28
dc_segments	44,479	0.14	9	1,335
dc_sequences	2,557	0.08	2,557	15
dc_table_scns	941	0.00	0	4
dc_tablespace_quotas	3	100.00	2	3
dc_tablespaces	70,528	0.00	0	43
dc_usernames	31,794	0.07	0	559
dc_users	166,880	0.02	0	848
outstanding_alerts	523	0.76	7	85

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	759	0.00	5,282	0.00	0	0
CLUSTER	230	0.00	368	0.00	0	0
INDEX	3	0.00	17	0.00	0	0
SQL AREA	109,895	23.62	1,723,726	2.43	1,339	38
TABLE/PROCEDURE	15,770	7.93	151,415	0.31	134	0
TRIGGER	1,251	0.40	22,347	0.06	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	328.79		1.01	2.92	44	45	327	327
	Freeable	223.31	0.00	0.85	0.39	5		262	262
	PL/SQL	7.25	5.54	0.02	0.02	0	0	325	325
	SQL	4.69	2.18	0.01	0.02	0	9	314	310
E	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

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	2,214,592,512	1,828,716,544
Fixed Size	2,089,240
Redo Buffers	14,684,160
Variable Size	1,962,938,088	2,348,814,056

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	342.51	419.19	22.39
shared	KGH: NO ACCESS	770.04	770.04	0.00
shared	PCursor	116.23	149.26	28.42
shared	free memory	557.60	568.06	1.88
shared	kglsim object batch	28.60		-100.00
shared	library cache	77.88	93.26	19.75
shared	sql area	438.36	664.55	51.60
shared	sql area:PLSQL	57.08	61.43	7.61
	buffer_cache	2,112.00	1,744.00	-17.42
	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.57	Recursive Call %:	14.65
Rollback per transaction %:	21.03	Rows per Sort:	33.08

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	83.05	In-memory Sort %:	100.00
Library Hit %:	97.77	Soft Parse %:	97.40
Execute to Parse %:	-2.56	Latch Hit %:	99.92
Parse CPU to Parse Elapsd %:	1.35	% Non-Parse CPU:	96.71