WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

MIS 2159653444 mis 1 10.2.0.4.0 NO 100-10

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
MIS	2159653444	mis	1	10.2.0.4.0	NO	100-10

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 22807 14-Aug-12 14:00:22 252 1.7

End Snap: 22825 14-Aug-12 18:30:29 197 .4

Elapsed: 270.13 (mins)

DB Time: 30.17 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	22807	14-Aug-12 14:00:22	252	1.7
End Snap:	22825	14-Aug-12 18:30:29	197	.4
Elapsed:		270.13 (mins)
DB Time:		30.17 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 3,104M 3,104M Std Block Size: 8K

Shared Pool Size: 1,456M 1,456M Log Buffer: 14,340K

	Begin	End
Buffer Cache:	3,104M	3,104M	Std Block Size:	8K
Shared Pool Size:	1,456M	1,456M	Log Buffer:	14,340K

Load Profile

Per Second Per Transaction

Redo size: 3,409.11 1,632.92

Logical reads: 1,861.99 891.87

Block changes: 18.12 8.68

Physical reads: 5.42 2.60

Physical writes: 2.36 1.13

User calls: 124.15 59.47

Parses: 50.10 24.00

Hard parses: 4.17 2.00

Sorts: 35.16 16.84

Logons: 1.54 0.74

Executes: 57.10 27.35

Transactions: 2.09

	Per Second	Per Transaction
Redo size:	3,409.11	1,632.92
Logical reads:	1,861.99	891.87
Block changes:	18.12	8.68
Physical reads:	5.42	2.60
Physical writes:	2.36	1.13
User calls:	124.15	59.47
Parses:	50.10	24.00
Hard parses:	4.17	2.00
Sorts:	35.16	16.84
Logons:	1.54	0.74
Executes:	57.10	27.35
Transactions:	2.09

% Blocks changed per Read: 0.97 Recursive Call %: 86.02

Rollback per transaction %: 36.12 Rows per Sort: 88.09

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 85.97 Soft Parse %: 91.68

Execute to Parse %: 12.26 Latch Hit %: 99.96

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

Shared Pool Statistics

Begin End

Memory Usage %: 82.78 72.03

% SQL with executions>1: 90.44 97.12

% Memory for SQL w/exec>1: 90.09 96.61

	Begin	End
Memory Usage %:	82.78	72.03
% SQL with executions>1:	90.44	97.12
% Memory for SQL w/exec>1:	90.09	96.61

Top 5 Timed Events

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

cursor: pin S wait on X 3,433,709 37,217 11 2,056.0 Concurrency

CPU time 639 35.3

inactive session 466 456 978 25.2 Other

enq: DX - contention 158 433 2,741 23.9 Other

log file parallel write 21,800 328 15 18.1 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
cursor: pin S wait on X	3,433,709	37,217	11	2,056.0	Concurrency
CPU time		639		35.3
inactive session	466	456	978	25.2	Other
enq: DX - contention	158	433	2,741	23.9	Other
log file parallel write	21,800	328	15	18.1	System 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): 1810.2s
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
DB CPU	638.61	35.28
parse time elapsed	555.68	30.70
hard parse elapsed time	522.22	28.85
sql execute elapsed time	464.69	25.67
failed parse elapsed time	417.27	23.05
connection management call elapsed time	53.30	2.94
PL/SQL execution elapsed time	2.07	0.11
repeated bind elapsed time	0.49	0.03
hard parse (sharing criteria) elapsed time	0.39	0.02
PL/SQL compilation elapsed time	0.32	0.02
sequence load elapsed time	0.02	0.00
DB time	1,810.19
background elapsed time	796.18
background cpu time	49.68

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	3,437,185	99.90	37,221	11	101.58
Other	1,738	35.44	904	520	0.05
System I/O	123,420	0.00	537	4	3.65
Commit	19,692	0.00	310	16	0.58
Network	2,315,582	0.00	8	0	68.43
Application	5,163	0.00	6	1	0.15
User I/O	88,184	0.00	4	0	2.61
Configuration	15	93.33	0	7	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
cursor: pin S wait on X	3,433,709	100.00	37,217	11	101.48
inactive session	466	100.00	456	978	0.01
enq: DX - contention	158	90.51	433	2741	0.00
log file parallel write	21,800	0.00	328	15	0.64
log file sync	19,692	0.00	310	16	0.58
control file parallel write	13,902	0.00	206	15	0.41
latch free	596	0.17	6	11	0.02
SQL*Net break/reset to client	5,156	0.00	6	1	0.15
rdbms ipc reply	19	10.53	5	275	0.00
db file sequential read	87,891	0.00	4	0	2.60
inactive transaction branch	4	100.00	4	978	0.00
SQL*Net more data to client	303,582	0.00	3	0	8.97
SQL*Net message to client	2,008,430	0.00	3	0	59.36
latch: shared pool	1,952	0.92	3	1	0.06
control file sequential read	87,427	0.00	2	0	2.58
ARCH wait on SENDREQ	87	0.00	1	15	0.00
os thread startup	36	0.00	1	19	0.00
latch: library cache	530	0.94	0	1	0.02
latch: library cache lock	53	0.00	0	6	0.00
latch: session allocation	427	0.00	0	1	0.01
log file single write	36	0.00	0	7	0.00
latch: row cache objects	665	0.00	0	0	0.02
Log archive I/O	105	0.00	0	1	0.00
log file switch completion	1	0.00	0	112	0.00
db file scattered read	24	0.00	0	4	0.00
SQL*Net more data from client	335	0.00	0	0	0.01
log file sequential read	150	0.00	0	0	0.00
enq: CF - contention	3	0.00	0	15	0.00
latch: cache buffers chains	223	0.00	0	0	0.01
SQL*Net more data from dblink	501	0.00	0	0	0.01
SQL*Net message to dblink	2,626	0.00	0	0	0.08
row cache lock	7	0.00	0	0	0.00
LGWR wait for redo copy	54	0.00	0	0	0.00
latch: enqueue hash chains	2	0.00	0	0	0.00
direct path write	170	0.00	0	0	0.01
cursor: pin S	7	0.00	0	0	0.00
SQL*Net more data to dblink	21	0.00	0	0	0.00
buffer busy waits	8	0.00	0	0	0.00
direct path read	99	0.00	0	0	0.00
latch: In memory undo latch	2	0.00	0	0	0.00
SQL*Net break/reset to dblink	6	0.00	0	0	0.00
enq: TX - row lock contention	1	0.00	0	0	0.00
undo segment extension	14	100.00	0	0	0.00
latch: cache buffers lru chain	1	0.00	0	0	0.00
SGA: allocation forcing component growth	1	0.00	0	0	0.00
SQL*Net message from client	2,008,386	0.00	2,426,285	1208	59.35
virtual circuit status	541	100.00	15,787	29181	0.02
jobq slave wait	5,669	89.98	15,781	2784	0.17
Streams AQ: qmn slave idle wait	576	0.00	15,755	27352	0.02
Streams AQ: qmn coordinator idle wait	1,183	51.31	15,755	13318	0.03
Streams AQ: waiting for time management or cleanup tasks	4	100.00	15,330	3832551	0.00
SQL*Net message from dblink	2,628	0.00	9,852	3749	0.08
single-task message	39	0.00	1	21	0.00
class slave wait	32	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	21,800	0.00	328	15	0.64
control file parallel write	13,902	0.00	206	15	0.41
ARCH wait on SENDREQ	87	0.00	1	15	0.00
os thread startup	36	0.00	1	19	0.00
control file sequential read	57,497	0.00	1	0	1.70
log file single write	36	0.00	0	7	0.00
Log archive I/O	105	0.00	0	1	0.00
latch: shared pool	26	69.23	0	5	0.00
log file sequential read	150	0.00	0	0	0.00
latch: library cache	8	62.50	0	5	0.00
events in waitclass Other	91	1.10	0	0	0.00
db file sequential read	4	0.00	0	5	0.00
direct path read	99	0.00	0	0	0.00
direct path write	98	0.00	0	0	0.00
buffer busy waits	4	0.00	0	0	0.00
rdbms ipc message	77,378	74.08	186,770	2414	2.29
pmon timer	6,319	96.31	15,822	2504	0.19
Streams AQ: qmn slave idle wait	576	0.00	15,755	27352	0.02
Streams AQ: qmn coordinator idle wait	1,183	51.31	15,755	13318	0.03
smon timer	69	69.57	15,497	224597	0.00
Streams AQ: waiting for time management or cleanup tasks	4	100.00	15,330	3832551	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	165,172
IDLE_TIME	19,279,027
IOWAIT_TIME	90,496
NICE_TIME	165
SYS_TIME	53,437
USER_TIME	107,169
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	8,366,489,600
NUM_CPUS	12
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	1,315.70	556.20	1,174	12,928,894
mis	494.50	82.40	86,620	16,342,432
SYS$BACKGROUND	0.00	0.00	112	906,885
misXDB	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	1145	287	3368	314	2177625	597
mis	86595	135	3433705	3721664	63259	21
SYS$BACKGROUND	444	3	74	85	87	128

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
72	72	12	5.99	3.97	923qpwfhc47nt	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
53	53	23,501	0.00	2.94	3f751tsaf2j02	JDBC Thin Client	SELECT VALUE FROM NLS_INSTANCE...
25	25	130	0.20	1.41	bj8xr519anj8w	perl@localhost.localdomain (TNS V1-V3)	SELECT ...
25	25	1,113	0.02	1.38	0991dakcyuaya	JDBC Thin Client	select system from v_org_profe...
24	24	4	5.99	1.32	9j3kb9pkdu670	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
16	16	96	0.17	0.90	7g12qa7spuf0x	JDBC Thin Client	select (case when (sysdate-i.n...
14	13	80,717	0.00	0.75	0h6b2sajwb74n		select privilege#, level from ...
13	13	18	0.72	0.72	bunssq950snhf		insert into wrh$_sga_target_ad...
13	13	10	1.27	0.70	4dxk37n7vknqt	JDBC Thin Client	SELECT * FROM SYSFLOWSTEPBINDF...
10	10	24,940	0.00	0.54	0k8522rmdzg4k		select privilege# from sysauth...

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
72	72	12	5.99	3.97	923qpwfhc47nt	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
53	53	23,501	0.00	2.94	3f751tsaf2j02	JDBC Thin Client	SELECT VALUE FROM NLS_INSTANCE...
25	25	130	0.19	1.41	bj8xr519anj8w	perl@localhost.localdomain (TNS V1-V3)	SELECT ...
25	25	1,113	0.02	1.38	0991dakcyuaya	JDBC Thin Client	select system from v_org_profe...
24	24	4	5.99	1.32	9j3kb9pkdu670	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
16	16	96	0.17	0.90	7g12qa7spuf0x	JDBC Thin Client	select (case when (sysdate-i.n...
13	14	80,717	0.00	0.75	0h6b2sajwb74n		select privilege#, level from ...
13	13	18	0.72	0.72	bunssq950snhf		insert into wrh$_sga_target_ad...
13	13	10	1.27	0.70	4dxk37n7vknqt	JDBC Thin Client	SELECT * FROM SYSFLOWSTEPBINDF...
10	10	24,940	0.00	0.54	0k8522rmdzg4k		select privilege# from sysauth...

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: 30,178,277
Captured SQL account for 73.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
9,844,246	130	75,724.97	32.62	25.21	25.44	bj8xr519anj8w	perl@localhost.localdomain (TNS V1-V3)	SELECT ...
2,933,652	12	244,471.00	9.72	71.84	71.84	923qpwfhc47nt	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
975,714	4	243,928.50	3.23	23.98	23.98	9j3kb9pkdu670	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
797,171	80,717	9.88	2.64	13.48	13.53	0h6b2sajwb74n		select privilege#, level from ...
640,281	1,113	575.27	2.12	24.97	25.06	0991dakcyuaya	JDBC Thin Client	select system from v_org_profe...
517,779	129,462	4.00	1.72	3.03	3.03	96g93hntrzjtr		select /+ rule / bucket_cnt,...
503,975	10	50,397.50	1.67	12.70	12.70	4dxk37n7vknqt	JDBC Thin Client	SELECT * FROM SYSFLOWSTEPBINDF...
409,260	136,436	3.00	1.36	4.19	4.20	2ym6hhaq30r73		select type#, blocks, extents,...
244,476	1	244,476.00	0.81	6.04	6.04	g1nsyvn3kqmwb	JDBC Thin Client	select * from v_bo_hc_fm_dyl...
244,464	1	244,464.00	0.81	5.98	5.98	c7d9jwzrazukn	JDBC Thin Client	select * from v_bo_hc_fm_dyl...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 87,906
Captured SQL account for 96.4% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
83,330	130	641.00	94.79	25.21	25.44	bj8xr519anj8w	perl@localhost.localdomain (TNS V1-V3)	SELECT ...
641	180	3.56	0.73	1.76	1.77	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
641	1	641.00	0.73	0.50	0.50	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
641	14	45.79	0.73	0.55	0.55	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
72	2	36.00	0.08	0.41	0.56	4tsw81tmyyy3q	oracle@100-10 (TNS V1-V3)	SELECT "A1"."BEGINTIME", "A1"....
14	3	4.67	0.02	0.13	0.14	9xacj6q3yp1gs	JDBC Thin Client	select * from wf_task_log wher...
9	1	9.00	0.01	0.06	0.06	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
9	2	4.50	0.01	0.64	0.81	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
7	1	7.00	0.01	0.13	0.18	0bab26fz66hbf	JDBC Thin Client	select * from v_zcly where 1=1...
4	1	4.00	0.00	0.30	0.32	5zk9y67py7uxb	JDBC Thin Client	select bindid, count(*) times,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 925,409
Captured SQL account for 73.6% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
136,436	136,388	1.00	2ym6hhaq30r73		select type#, blocks, extents,...
129,462	128,377	0.99	96g93hntrzjtr		select /+ rule / bucket_cnt,...
80,717	582,634	7.22	0h6b2sajwb74n		select privilege#, level from ...
27,004	0	0.00	03758aqnq5ct6	JDBC Thin Client	SELECT * FROM "TEST_CONN"
24,940	80,717	3.24	0k8522rmdzg4k		select privilege# from sysauth...
23,501	23,500	1.00	3f751tsaf2j02	JDBC Thin Client	SELECT VALUE FROM NLS_INSTANCE...
20,392	20,392	1.00	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
20,020	20,178	1.01	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
19,346	141,988	7.34	83taa7kaw59c1		select name, intcol#, segcol#,...
19,129	19,544	1.02	6769wyy3yf66f		select pos#, intcol#, col#, sp...
18,915	75	0.00	2q93zsrvbdw48		select grantee#, privilege#, n...
18,913	0	0.00	6aq34nj2zb2n7		select col#, grantee#, privi...
18,813	10	0.00	f8pavn1bvsj7t		select con#, obj#, rcon#, enab...
18,729	18,926	1.01	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
18,699	20,217	1.08	a73wbv1yu8x5c		select con#, type#, condlength...
18,034	17,906	0.99	04xtrk7uyhknh		select obj#, type#, ctime, mti...
17,231	17,221	1.00	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 811,964
Captured SQL account for 68.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
136,436	136,436	16.80	2ym6hhaq30r73		select type#, blocks, extents,...
80,717	80,717	9.94	0h6b2sajwb74n		select privilege#, level from ...
27,004	27,004	3.33	03758aqnq5ct6	JDBC Thin Client	SELECT * FROM "TEST_CONN"
24,940	24,940	3.07	0k8522rmdzg4k		select privilege# from sysauth...
23,501	23,501	2.89	3f751tsaf2j02	JDBC Thin Client	SELECT VALUE FROM NLS_INSTANCE...
22,235	129,462	2.74	96g93hntrzjtr		select /+ rule / bucket_cnt,...
20,283	20,392	2.50	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
19,113	19,346	2.35	83taa7kaw59c1		select name, intcol#, segcol#,...
18,786	18,915	2.31	2q93zsrvbdw48		select grantee#, privilege#, n...
18,784	18,913	2.31	6aq34nj2zb2n7		select col#, grantee#, privi...
18,750	19,129	2.31	6769wyy3yf66f		select pos#, intcol#, col#, sp...
18,687	18,813	2.30	f8pavn1bvsj7t		select con#, obj#, rcon#, enab...
18,601	18,729	2.29	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
18,582	18,699	2.29	a73wbv1yu8x5c		select con#, type#, condlength...
18,537	20,020	2.28	53saa2zkr6wc3		select intcol#, nvl(pos#, 0), ...
17,391	18,034	2.14	04xtrk7uyhknh		select obj#, type#, ctime, mti...
12,044	17,231	1.48	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...

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

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

03758aqnq5ct6 SELECT * FROM "TEST_CONN"

04xtrk7uyhknh select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null

0991dakcyuaya select system from v_org_profession where userid=:1 and part=0 and system is not null

0bab26fz66hbf select * from v_zcly where 1=1 and apllyuserid like '��%' order by bindid desc

0dwr2vd6vbqzs SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id

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

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

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

2ym6hhaq30r73 select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3

3f751tsaf2j02 SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'

4dxk37n7vknqt SELECT * FROM SYSFLOWSTEPBINDFIELD ORDER BY ID DESC

4tsw81tmyyy3q SELECT "A1"."BEGINTIME", "A1"."ENDTIME", "A1"."COMPANY", "A1"."POSITION", "A1"."PROVER", "A1"."PROVETEL", "A2"."EMPID", "A2"."BINDID" FROM "BO_HC_RS_RZTZ" "A2", "BO_RS_EXPERIENCE" "A1" WHERE "A2"."BINDID"="A1"."BINDID"

53saa2zkr6wc3 select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1

5ngzsfstg8tmy select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1

5zk9y67py7uxb select bindid, count(*) times, max(audittime) audittime, style, title, isend, '' as isagree, '' as auditdesc from v_task_done where audituser='��1' and title like '%��%' and style like '%��%' group by bindid, style, title, isend order by audittime desc

6769wyy3yf66f select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

7g12qa7spuf0x select (case when (sysdate-i.next_time)*24*60-h.delay_mins<60 then '0' else '<font color='||''''||'blue'||''''||'>��ʱ'||h.dest_id||'>'||round((sysdate-i.next_time)*24*60-h.delay_mins)||'m</font>' end) from (select b.DEST_ID, b.status, b.type, b.archived_seq#, b.applied_seq#, b.error, a.delay_mins from V$ARCHIVE_DEST a, V$ARCHIVE_DEST_STATUS b where a.dest_id=b.dest_id and a.target='STANDBY') h, v$archived_log i where h.dest_id=i.dest_id and h.applied_seq#=i.sequence# and i.name='mis_std'

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

89qyn4bbt03jq SELECT /*+ USE_HASH(f a) */ SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME

923qpwfhc47nt select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and ('��ҵ��'='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc

96g93hntrzjtr select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2

9j3kb9pkdu670 select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and ('��ҵ��'='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc

9xacj6q3yp1gs select * from wf_task_log where target='��ǿ' and WF_STYLE='IT�ʲ��' and from_point>0 order by id desc

a73wbv1yu8x5c select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1

abtp0uqvdb1d3 CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)

bj8xr519anj8w SELECT a.tablespace_name "Tablespace", b.status "Status", b.contents "Type", b.extent_management "Extent Mgmt", a.bytes bytes, a.maxbytes bytes_max, c.bytes_free + NVL(d.bytes_expired, 0) bytes_free FROM ( -- belegter und maximal verfuegbarer platz pro datafile -- nach tablespacenamen zusammengefasst -- => bytes -- => maxbytes SELECT a.tablespace_name, SUM(a.bytes) bytes, SUM(DECODE(a.autoextensible, 'YES', a.maxbytes, 'NO', a.bytes)) maxbytes FROM dba_data_files a GROUP BY tablespace_name ) a, sys.dba_tablespaces b, ( -- freier platz pro tablespace -- => bytes_free SELECT a.tablespace_name, SUM(a.bytes) bytes_free FROM dba_free_space a GROUP BY tablespace_name ) c, ( -- freier platz durch expired extents -- speziell fuer undo tablespaces -- => bytes_expired SELECT a.tablespace_name, SUM(a.bytes) bytes_expired FROM dba_undo_extents a WHERE status = 'EXPIRED' GROUP BY tablespace_name ) d WHERE a.tablespace_name = c.tablespace_name (+) AND a.tablespace_name = b.tablespace_name AND a.tablespace_name = d.tablespace_name (+) UNION ALL SELECT d.tablespace_name "Tablespace", b.status "Status", b.contents "Type", b.extent_management "Extent Mgmt", sum(a.bytes_free + a.bytes_used) bytes, -- allocated SUM(DECODE(d.autoextensible, 'YES', d.maxbytes, 'NO', d.bytes)) bytes_max, SUM(a.bytes_free + a.bytes_used - NVL(c.bytes_used, 0)) bytes_free FROM sys.v_$TEMP_SPACE_HEADER a, sys.dba_tablespaces b, sys.v_$Temp_extent_pool c, dba_temp_files d WHERE c.file_id(+) = a.file_id and c.tablespace_name(+) = a.tablespace_name and d.file_id = a.file_id and d.tablespace_name = a.tablespace_name and b.tablespace_name = a.tablespace_name GROUP BY b.status, b.contents, b.extent_management, d.tablespace_name ORDER BY 1

bunssq950snhf insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice

c7d9jwzrazukn select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and ('��ҵ��'='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc

d92h3rjp0y217 begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;

f8pavn1bvsj7t select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1

g1nsyvn3kqmwb select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and (''='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc

SQL Id	SQL Text
03758aqnq5ct6	SELECT * FROM "TEST_CONN"
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0991dakcyuaya	select system from v_org_profession where userid=:1 and part=0 and system is not null
0bab26fz66hbf	select * from v_zcly where 1=1 and apllyuserid like '��%' order by bindid desc
0dwr2vd6vbqzs	SELECT count() over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash., evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe., nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff, nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap. FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number = :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count() as cnt FROM (SELECT t1. FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
3f751tsaf2j02	SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'
4dxk37n7vknqt	SELECT * FROM SYSFLOWSTEPBINDFIELD ORDER BY ID DESC
4tsw81tmyyy3q	SELECT "A1"."BEGINTIME", "A1"."ENDTIME", "A1"."COMPANY", "A1"."POSITION", "A1"."PROVER", "A1"."PROVETEL", "A2"."EMPID", "A2"."BINDID" FROM "BO_HC_RS_RZTZ" "A2", "BO_RS_EXPERIENCE" "A1" WHERE "A2"."BINDID"="A1"."BINDID"
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5zk9y67py7uxb	select bindid, count(*) times, max(audittime) audittime, style, title, isend, '' as isagree, '' as auditdesc from v_task_done where audituser='��1' and title like '%��%' and style like '%��%' group by bindid, style, title, isend order by audittime desc
6769wyy3yf66f	select pos#, intcol#, col#, spare1, bo#, spare2 from icol$ where obj#=:1
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
7g12qa7spuf0x	select (case when (sysdate-i.next_time)2460-h.delay_mins<60 then '0' else '<font color='\|\|''''\|\|'blue'\|\|''''\|\|'>��ʱ'\|\|h.dest_id\|\|'>'\|\|round((sysdate-i.next_time)2460-h.delay_mins)\|\|'m</font>' end) from (select b.DEST_ID, b.status, b.type, b.archived_seq#, b.applied_seq#, b.error, a.delay_mins from V$ARCHIVE_DEST a, V$ARCHIVE_DEST_STATUS b where a.dest_id=b.dest_id and a.target='STANDBY') h, v$archived_log i where h.dest_id=i.dest_id and h.applied_seq#=i.sequence# and i.name='mis_std'
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
89qyn4bbt03jq	SELECT /+ USE_HASH(f a) / SUM(NVL(F.BYTES - NVL(A.BYTES, 0), 0)/1024/1024), SUM(NVL(F.BYTES, 0)/1024/1024) FROM (SELECT DISTINCT TABLESPACE_NAME FROM USER_TABLES) U, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME) F, (SELECT TABLESPACE_NAME, SUM(BYTES) BYTES FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) A WHERE A.TABLESPACE_NAME = U.TABLESPACE_NAME AND F.TABLESPACE_NAME = U.TABLESPACE_NAME
923qpwfhc47nt	select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and ('��ҵ��'='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9j3kb9pkdu670	select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and ('��ҵ��'='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc
9xacj6q3yp1gs	select * from wf_task_log where target='��ǿ' and WF_STYLE='IT�ʲ��' and from_point>0 order by id desc
a73wbv1yu8x5c	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0) from cdef$ where obj#=:1
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
bj8xr519anj8w	SELECT a.tablespace_name "Tablespace", b.status "Status", b.contents "Type", b.extent_management "Extent Mgmt", a.bytes bytes, a.maxbytes bytes_max, c.bytes_free + NVL(d.bytes_expired, 0) bytes_free FROM ( -- belegter und maximal verfuegbarer platz pro datafile -- nach tablespacenamen zusammengefasst -- => bytes -- => maxbytes SELECT a.tablespace_name, SUM(a.bytes) bytes, SUM(DECODE(a.autoextensible, 'YES', a.maxbytes, 'NO', a.bytes)) maxbytes FROM dba_data_files a GROUP BY tablespace_name ) a, sys.dba_tablespaces b, ( -- freier platz pro tablespace -- => bytes_free SELECT a.tablespace_name, SUM(a.bytes) bytes_free FROM dba_free_space a GROUP BY tablespace_name ) c, ( -- freier platz durch expired extents -- speziell fuer undo tablespaces -- => bytes_expired SELECT a.tablespace_name, SUM(a.bytes) bytes_expired FROM dba_undo_extents a WHERE status = 'EXPIRED' GROUP BY tablespace_name ) d WHERE a.tablespace_name = c.tablespace_name (+) AND a.tablespace_name = b.tablespace_name AND a.tablespace_name = d.tablespace_name (+) UNION ALL SELECT d.tablespace_name "Tablespace", b.status "Status", b.contents "Type", b.extent_management "Extent Mgmt", sum(a.bytes_free + a.bytes_used) bytes, -- allocated SUM(DECODE(d.autoextensible, 'YES', d.maxbytes, 'NO', d.bytes)) bytes_max, SUM(a.bytes_free + a.bytes_used - NVL(c.bytes_used, 0)) bytes_free FROM sys.v_$TEMP_SPACE_HEADER a, sys.dba_tablespaces b, sys.v_$Temp_extent_pool c, dba_temp_files d WHERE c.file_id(+) = a.file_id and c.tablespace_name(+) = a.tablespace_name and d.file_id = a.file_id and d.tablespace_name = a.tablespace_name and b.tablespace_name = a.tablespace_name GROUP BY b.status, b.contents, b.extent_management, d.tablespace_name ORDER BY 1
bunssq950snhf	insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice
c7d9jwzrazukn	select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and ('��ҵ��'='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
f8pavn1bvsj7t	select con#, obj#, rcon#, enabled, nvl(defer, 0) from cdef$ where robj#=:1
g1nsyvn3kqmwb	select * from v_bo_hc_fm_dyloan12 where 1=1 and (1=1) and (borrower='��' or (costno in (select costno from v_org_user where userid='��' ) and (''='��ҵ��' or '��ҵ��'='��ҵ��'))) order by bindid desc

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	64,557	3.98	1.91
CPU used when call started	63,074	3.89	1.86
CR blocks created	172	0.01	0.01
Cached Commit SCN referenced	276	0.02	0.01
Commit SCN cached	1	0.00	0.00
DB time	5,159,003	318.31	152.47
DBWR checkpoint buffers written	37,923	2.34	1.12
DBWR checkpoints	11	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	668	0.04	0.02
DBWR transaction table writes	786	0.05	0.02
DBWR undo block writes	3,455	0.21	0.10
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	890	0.05	0.03
IMU Redo allocation size	3,073,836	189.65	90.84
IMU commits	20,717	1.28	0.61
IMU contention	9	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	1	0.00	0.00
IMU recursive-transaction flush	8	0.00	0.00
IMU undo allocation size	72,539,464	4,475.66	2,143.79
IMU- failed to get a private strand	1	0.00	0.00
Misses for writing mapping	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment recovery	15	0.00	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	1,933,943	119.32	57.15
SQL*Net roundtrips to/from dblink	2,626	0.16	0.08
active txn count during cleanout	1,205	0.07	0.04
application wait time	8	0.00	0.00
background checkpoints completed	11	0.00	0.00
background checkpoints started	11	0.00	0.00
background timeouts	57,479	3.55	1.70
branch node splits	0	0.00	0.00
buffer is not pinned count	16,206,272	999.92	478.95
buffer is pinned count	20,748,722	1,280.19	613.20
bytes received via SQL*Net from client	173,615,701	10,712.04	5,130.94
bytes received via SQL*Net from dblink	3,351,293	206.77	99.04
bytes sent via SQL*Net to client	908,665,468	56,064.39	26,854.20
bytes sent via SQL*Net to dblink	343,834	21.21	10.16
calls to get snapshot scn: kcmgss	1,618,529	99.86	47.83
calls to kcmgas	120,109	7.41	3.55
calls to kcmgcs	3,989	0.25	0.12
change write time	237	0.01	0.01
cleanout - number of ktugct calls	1,335	0.08	0.04
cleanouts and rollbacks - consistent read gets	1	0.00	0.00
cleanouts only - consistent read gets	71	0.00	0.00
cluster key scan block gets	10,152,122	626.38	300.03
cluster key scans	10,089,080	622.49	298.17
commit batch performed	43	0.00	0.00
commit batch requested	43	0.00	0.00
commit batch/immediate performed	68	0.00	0.00
commit batch/immediate requested	68	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	146	0.01	0.00
commit cleanout failures: cannot pin	4	0.00	0.00
commit cleanouts	81,568	5.03	2.41
commit cleanouts successfully completed	81,418	5.02	2.41
commit immediate performed	25	0.00	0.00
commit immediate requested	25	0.00	0.00
commit txn count during cleanout	500	0.03	0.01
concurrency wait time	3,721,922	229.64	110.00
consistent changes	148	0.01	0.00
consistent gets	29,873,450	1,843.18	882.86
consistent gets - examination	3,676,467	226.84	108.65
consistent gets direct	0	0.00	0.00
consistent gets from cache	29,873,450	1,843.18	882.86
cursor authentications	19,103	1.18	0.56
data blocks consistent reads - undo records applied	132	0.01	0.00
db block changes	293,656	18.12	8.68
db block gets	304,827	18.81	9.01
db block gets direct	211	0.01	0.01
db block gets from cache	304,616	18.79	9.00
deferred (CURRENT) block cleanout applications	38,547	2.38	1.14
dirty buffers inspected	0	0.00	0.00
enqueue conversions	11,496	0.71	0.34
enqueue releases	425,448	26.25	12.57
enqueue requests	425,700	26.27	12.58
enqueue timeouts	267	0.02	0.01
enqueue waits	22	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	925,409	57.10	27.35
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1,880	0.12	0.06
free buffer requested	93,555	5.77	2.76
heap block compress	1,045	0.06	0.03
hot buffers moved to head of LRU	5,990	0.37	0.18
immediate (CR) block cleanout applications	72	0.00	0.00
immediate (CURRENT) block cleanout applications	16,246	1.00	0.48
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	68,376	4.22	2.02
index fast full scans (full)	1,184	0.07	0.03
index fetch by key	2,442,076	150.68	72.17
index scans kdiixs1	1,535,715	94.75	45.39
leaf node 90-10 splits	193	0.01	0.01
leaf node splits	312	0.02	0.01
lob reads	481	0.03	0.01
lob writes	343	0.02	0.01
lob writes unaligned	343	0.02	0.01
logons cumulative	24,981	1.54	0.74
messages received	50,487	3.12	1.49
messages sent	50,487	3.12	1.49
no buffer to keep pinned count	24	0.00	0.00
no work - consistent read gets	25,446,298	1,570.03	752.03
opened cursors cumulative	888,690	54.83	26.26
parse count (failures)	236	0.01	0.01
parse count (hard)	67,532	4.17	2.00
parse count (total)	811,964	50.10	24.00
parse time cpu	13,847	0.85	0.41
parse time elapsed	3,411,966	210.52	100.84
physical read IO requests	87,852	5.42	2.60
physical read bytes	720,125,952	44,431.56	21,282.20
physical read total IO requests	175,668	10.84	5.19
physical read total bytes	5,383,326,208	332,149.64	159,095.85
physical read total multi block requests	3,605	0.22	0.11
physical reads	87,906	5.42	2.60
physical reads cache	87,807	5.42	2.59
physical reads cache prefetch	54	0.00	0.00
physical reads direct	99	0.01	0.00
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	30,482	1.88	0.90
physical write bytes	313,204,736	19,324.64	9,256.28
physical write total IO requests	115,909	7.15	3.43
physical write total bytes	1,192,025,600	73,547.63	35,228.47
physical write total multi block requests	44,864	2.77	1.33
physical writes	38,233	2.36	1.13
physical writes direct	310	0.02	0.01
physical writes direct (lob)	57	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	37,923	2.34	1.12
physical writes non checkpoint	2,872	0.18	0.08
pinned buffers inspected	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetch warmup blocks flushed out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	16,197	1.00	0.48
recovery blocks read	0	0.00	0.00
recursive calls	12,380,658	763.88	365.89
recursive cpu usage	18,595	1.15	0.55
redo blocks read for recovery	0	0.00	0.00
redo blocks written	124,755	7.70	3.69
redo buffer allocation retries	1	0.00	0.00
redo entries	116,528	7.19	3.44
redo log space requests	1	0.00	0.00
redo log space wait time	11	0.00	0.00
redo ordering marks	1,861	0.11	0.05
redo size	55,253,208	3,409.11	1,632.92
redo subscn max counts	9,546	0.59	0.28
redo synch time	31,868	1.97	0.94
redo synch writes	19,471	1.20	0.58
redo wastage	6,576,752	405.78	194.37
redo write time	33,805	2.09	1.00
redo writer latching time	0	0.00	0.00
redo writes	21,801	1.35	0.64
rollback changes - undo records applied	54	0.00	0.00
rollbacks only - consistent read gets	127	0.01	0.00
rows fetched via callback	129,158	7.97	3.82
session connect time	0	0.00	0.00
session cursor cache hits	373,577	23.05	11.04
session logical reads	30,178,277	1,861.99	891.87
session pga memory	873,630,584	53,902.75	25,818.80
session pga memory max	53,007,567,064	3,270,551.23	1,566,556.35
session uga memory	###############	150,561,536.48	72,117,240.62
session uga memory max	17,235,236,544	1,063,409.01	509,360.66
shared hash latch upgrades - no wait	70,386	4.34	2.08
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	0	0.00	0.00
sorts (memory)	569,860	35.16	16.84
sorts (rows)	50,199,218	3,097.28	1,483.56
sql area evicted	72,565	4.48	2.14
sql area purged	260	0.02	0.01
summed dirty queue length	0	0.00	0.00
switch current to new buffer	3,329	0.21	0.10
table fetch by rowid	10,496,601	647.64	310.21
table fetch continued row	341,234	21.05	10.08
table scan blocks gotten	8,651,514	533.80	255.68
table scan rows gotten	594,312,184	36,668.89	17,563.97
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	205,741	12.69	6.08
total number of times SMON posted	23	0.00	0.00
transaction rollbacks	68	0.00	0.00
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	18,087,016	1,115.96	534.53
user I/O wait time	424	0.03	0.01
user calls	2,012,185	124.15	59.47
user commits	21,615	1.33	0.64
user rollbacks	12,222	0.75	0.36
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	493,299	30.44	14.58
write clones created in background	0	0.00	0.00
write clones created in foreground	5	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	79,634,945	79,825,162
opened cursors current	416	72
logons current	252	197

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)	9	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
MIS	87,778	5	0.05	1.00	22,277	1	2
SYSAUX	20	0	0.00	1.00	5,405	0	0
UNDOTBS1	11	0	0.00	1.00	1,694	0	6
SYSTEM	20	0	2.00	1.00	1,051	0	0
USERS	12	0	0.83	1.00	44	0	0
EXCHANGE	11	0	0.00	1.00	11	0	0

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
EXCHANGE	/oracle/oradata/mis/exchange.dbf	11	0	0.00	1.00	11	0	0
MIS	/oracle/oradata/mis/mis01.dbf	1,717	0	0.28	1.00	3,746	0	0
MIS	/oracle/oradata/mis/mis02.dbf	82,442	5	0.03	1.00	8,161	1	0
MIS	/oracle/oradata/mis/mis03.dbf	1,766	0	0.36	1.00	5,369	0	0
MIS	/oracle/oradata/mis/mis04.dbf	1,853	0	0.26	1.01	5,001	0	2
SYSAUX	/oracle/oradata/mis/sysaux01.dbf	20	0	0.00	1.00	5,405	0	0
SYSTEM	/oracle/oradata/mis/system01.dbf	20	0	2.00	1.00	1,051	0	0
UNDOTBS1	/oracle/oradata/mis/undotbs01.dbf	11	0	0.00	1.00	1,694	0	6
USERS	/oracle/oradata/mis/users01.dbf	12	0	0.83	1.00	44	0	0

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	383,926	100	30,178,049	87,807	37,923	0	0	8

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	10	495	2247	17953	737280	17953
E	0	10	398	1026	10393	737280	10393

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	304	0.10	37,601	20.37	713,437,080
D	608	0.20	75,202	8.72	305,552,949
D	912	0.29	112,803	6.29	220,321,972
D	1,216	0.39	150,404	4.86	170,390,175
D	1,520	0.49	188,005	3.34	116,830,279
D	1,824	0.59	225,606	2.22	77,616,887
D	2,128	0.69	263,207	1.61	56,379,604
D	2,432	0.78	300,808	1.27	44,520,266
D	2,736	0.88	338,409	1.10	38,534,755
D	3,040	0.98	376,010	1.01	35,409,610
D	3,104	1.00	383,926	1.00	35,031,390
D	3,344	1.08	413,611	0.97	33,836,747
D	3,648	1.18	451,212	0.94	33,027,854
D	3,952	1.27	488,813	0.93	32,569,573
D	4,256	1.37	526,414	0.91	32,035,748
D	4,560	1.47	564,015	0.90	31,482,850
D	4,864	1.57	601,616	0.89	31,099,610
D	5,168	1.66	639,217	0.88	30,799,444
D	5,472	1.76	676,818	0.87	30,532,406
D	5,776	1.86	714,419	0.87	30,354,966
D	6,080	1.96	752,020	0.56	19,590,634

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	126,814	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	2,000	1,684	329.36	0.00	0.00	0.00	0.00	204,800
E	2,000	1,704	296.41	0.00	0.00	0.00	0.00	204,800

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	376,750	376,750
64K	128K	2,782	2,782
128K	256K	20,895	20,895
256K	512K	150	150
512K	1024K	1,071	1,071
1M	2M	91,576	91,576
2M	4M	74	74

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
250	0.13	11,304,057.59	1,198.59	100.00	14
500	0.25	11,304,057.59	70.52	100.00	0
1,000	0.50	11,304,057.59	70.52	100.00	0
1,500	0.75	11,304,057.59	70.52	100.00	0
2,000	1.00	11,304,057.59	70.52	100.00	0
2,400	1.20	11,304,057.59	0.00	100.00	0
2,800	1.40	11,304,057.59	0.00	100.00	0
3,200	1.60	11,304,057.59	0.00	100.00	0
3,600	1.80	11,304,057.59	0.00	100.00	0
4,000	2.00	11,304,057.59	0.00	100.00	0
6,000	3.00	11,304,057.59	0.00	100.00	0
8,000	4.00	11,304,057.59	0.00	100.00	0
12,000	6.00	11,304,057.59	0.00	100.00	0
16,000	8.00	11,304,057.59	0.00	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
512	0.35	179	21,127	4,385,668	0.95	266,009	11.79	163,574,751
672	0.46	335	31,151	4,437,244	0.96	214,433	9.50	164,607,538
832	0.57	494	51,810	4,492,700	0.97	158,977	7.05	165,076,864
992	0.67	653	74,176	4,569,644	0.99	82,033	3.64	165,415,787
1,152	0.78	812	96,054	4,602,020	0.99	49,657	2.20	165,673,690
1,312	0.89	971	111,447	4,615,498	1.00	36,179	1.60	165,864,253
1,472	1.00	1,130	126,179	4,629,116	1.00	22,561	1.00	166,064,865
1,632	1.11	1,289	136,434	4,646,400	1.00	5,277	0.23	166,217,391
1,792	1.22	1,448	148,450	4,694,341	1.01	1	0.00	166,386,996
1,952	1.33	1,607	159,135	4,752,328	1.03	1	0.00	166,545,285
2,112	1.43	1,766	170,677	4,824,975	1.04	1	0.00	166,714,720
2,272	1.54	1,925	183,119	4,862,358	1.05	1	0.00	166,862,978
2,432	1.65	2,084	194,431	4,915,335	1.06	1	0.00	167,006,038
2,592	1.76	2,243	207,049	4,945,449	1.07	1	0.00	167,153,424
2,752	1.87	2,402	218,423	4,978,432	1.08	1	0.00	167,278,752
2,912	1.98	2,561	229,802	4,998,627	1.08	1	0.00	167,391,702
3,072	2.09	2,720	240,808	5,009,743	1.08	1	0.00	167,511,604

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,152	0.25	542,290	277,774,401
2,304	0.50	252,711	277,774,401
3,456	0.75	230,496	106,208,168
4,608	1.00	223,717	35,031,390
5,760	1.25	223,202	29,608,531
6,912	1.50	223,046	28,000,590
8,064	1.75	222,084	17,809,959
9,216	2.00	222,084	17,809,959

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)
undo header	6	0	0
data block	2	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)
DX-Distributed Transaction	12,968	12,700	267	18	443	24,636.11
CF-Controlfile Transaction	19,855	19,855	0	3	0	16.67
TX-Transaction (row lock contention)	7	7	0	1	0	0.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.71	27,321	1,681	9	15/39.0166666666666666666666666666666666667	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
14-Aug 18:34	54	153	0	5	15	0/0	0/0/0/0/0/0
14-Aug 18:24	92	770	0	5	15	0/0	0/0/0/0/0/0
14-Aug 18:14	32	504	0	4	15	0/0	0/0/0/0/0/0
14-Aug 18:04	147	1,421	0	5	15	0/0	0/0/0/0/0/0
14-Aug 17:54	105	891	0	5	15	0/0	0/0/0/0/0/0
14-Aug 17:44	82	1,130	0	5	15	0/0	0/0/0/0/0/0
14-Aug 17:34	88	654	0	5	15	0/0	0/0/0/0/0/0
14-Aug 17:24	80	671	0	5	15	0/0	0/0/0/0/0/0
14-Aug 17:14	63	1,205	0	4	15	0/0	0/0/0/0/0/0
14-Aug 17:04	92	601	0	5	15	0/0	0/0/0/0/0/0
14-Aug 16:54	108	1,500	0	4	15	0/0	0/0/0/0/0/0
14-Aug 16:44	242	1,205	0	4	15	0/0	0/0/0/0/0/0
14-Aug 16:34	100	993	0	5	15	0/0	0/0/0/0/0/0
14-Aug 16:24	93	869	0	4	15	0/0	0/0/0/0/0/0
14-Aug 16:14	51	929	0	2	15	0/0	0/0/0/0/0/0
14-Aug 16:04	126	1,147	1,681	4	39	0/0	0/0/0/0/0/0
14-Aug 15:54	95	955	1,081	3	29	0/0	0/0/0/0/0/0
14-Aug 15:44	59	1,054	479	3	19	0/0	0/0/0/0/0/0
14-Aug 15:34	85	876	0	3	15	0/0	0/0/0/0/0/0
14-Aug 15:24	108	1,095	0	4	15	0/0	0/0/0/0/0/0
14-Aug 15:14	25	435	0	3	15	0/0	0/0/0/0/0/0
14-Aug 15:04	115	1,046	0	4	15	0/0	0/0/0/0/0/0
14-Aug 14:54	90	494	0	4	15	0/0	0/0/0/0/0/0
14-Aug 14:44	66	1,217	158	5	15	0/0	0/0/0/0/0/0
14-Aug 14:34	182	2,181	0	7	15	0/0	0/0/0/0/0/0
14-Aug 14:24	144	1,172	0	9	15	0/0	0/0/0/0/0/0
14-Aug 14:14	73	1,377	0	7	15	0/0	0/0/0/0/0/0
14-Aug 14:04	112	776	0	7	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	Wait Time (s)	NoWait Requests	Pct NoWait Miss
ASM db client latch	10,761	0.00		0	0
AWR Alerted Metric Element list	94,766	0.00		0	0
Consistent RBA	21,809	0.00		0	0
FAL request queue	387	0.00		0	0
FAL subheap alocation	378	0.00		0	0
FIB s.o chain latch	170	0.00		0	0
FOB s.o list latch	6,924	0.00		0	0
In memory undo latch	156,412	0.00	1.00	0	31,815	0.00
JS mem alloc latch	28	0.00		0	0
JS queue access latch	28	0.00		0	0
JS queue state obj latch	117,204	0.00		0	0
JS slv state obj latch	50	0.00		0	0
KMG MMAN ready and startup request latch	5,401	0.00		0	0
KMG resize request state object freelist	2	0.00		0	0
KTF sga latch	34	0.00		0	4,155	0.00
KWQMN job cache list latch	4	0.00		0	0
MQL Tracking Latch	0			0	324	0.00
Memory Management Latch	17	0.00		0	5,401	0.00
OS process	73,599	0.00		0	0
OS process allocation	54,419	0.05	0.00	0	0
OS process: request allocation	48,875	0.12	0.00	0	0
PL/SQL warning settings	28,049	0.00		0	0
SQL memory manager latch	18	0.00		0	5,367	0.00
SQL memory manager workarea list latch	867,315	0.00	0.00	0	0
Shared B-Tree	576	0.00		0	0
active checkpoint queue latch	40,550	0.00		0	0
active service list	110,089	0.05	0.13	0	6,303	0.00
archive control	3,409	0.00		0	0
archive process latch	6,096	0.26	1.00	0	0
begin backup scn array	73	0.00		0	0
cache buffer handles	65,019	0.00		0	0
cache buffers chains	57,815,686	0.01	0.05	0	9,389	0.00
cache buffers lru chain	84,275	0.00	0.25	0	183,090	0.00
cache table scan latch	0			0	24	0.00
channel handle pool latch	48,878	0.02	0.38	0	0
channel operations parent latch	149,098	0.04	0.00	0	0
checkpoint queue latch	953,616	0.00		0	35,983	0.00
client/application info	154,601	0.00		0	0
commit callback allocation	84	0.00		0	0
compile environment latch	24,981	0.00		0	0
constraint object allocation	36	0.00		0	0
dictionary lookup	64	0.00		0	0
dml lock allocation	74,755	0.00		0	0
dummy allocation	50,021	0.02	0.18	0	0
enqueue hash chains	862,809	0.00	0.08	0	815	0.00
enqueues	999,433	0.01	0.10	0	0
event group latch	24,414	0.00		0	0
file cache latch	632	0.00		0	0
global KZLD latch for mem in SGA	24,358	0.00		0	0
global tx hash mapping	4,693	0.00		0	331	0.00
hash table column usage latch	2,611	0.00		0	433,139	0.00
hash table modification latch	836	0.00		0	0
job workq parent latch	0			0	1,136	0.00
job_queue_processes parameter latch	838	0.00		0	0
kks stats	399,112	0.00	0.62	0	0
kmcptab latch	1	0.00		0	0
kmcpvec latch	0			0	1	0.00
kokc descriptor allocation latch	238	0.00		0	0
ksuosstats global area	1,116	0.00		0	0
ktm global data	103	0.00		0	0
kwqbsn:qsga	576	0.00		0	0
lgwr LWN SCN	22,757	0.00		0	0
library cache	3,803,269	0.10	0.14	0	292,030	0.33
library cache load lock	140,364	0.00	0.00	0	0
library cache lock	2,538,947	0.28	0.01	0	0
library cache lock allocation	106,018	0.02	0.11	0	0
library cache pin	688,340	0.01	0.00	0	0
library cache pin allocation	7,908	0.00		0	0
list of block allocation	7,727	0.00		0	0
loader state object freelist	330	0.00		0	0
message pool operations parent latch	5	0.00		0	0
messages	261,466	0.00	0.00	0	0
mostly latch-free SCN	22,757	0.00	0.00	0	0
multiblock read objects	128	0.00		0	0
ncodef allocation latch	511	0.00		0	0
object queue header heap	2,085	0.00		0	1,410	0.00
object queue header operation	304,055	0.00		0	0
object stats modification	82	0.00		0	0
parallel query alloc buffer	2,148	0.00		0	0
parameter list	8,837	0.00		0	0
parameter table allocation management	25,178	3.37	0.04	0	0
post/wait queue	30,720	0.00		0	19,692	0.01
process allocation	48,875	1.12	0.77	5	24,318	0.39
process group creation	48,875	0.03	0.00	0	0
qmn task queue latch	2,304	0.00		0	0
redo allocation	133,018	0.00	0.00	0	116,514	0.00
redo copy	0			0	116,516	0.05
redo writing	117,515	0.00		0	0
resmgr group change latch	26,406	0.00		0	0
resmgr:active threads	51,589	0.00		0	0
resmgr:actses change group	24,945	0.00		0	0
resmgr:actses change state	813	0.00		0	0
resmgr:free threads list	49,945	0.27	0.03	0	0
resmgr:resource group CPU method	813	0.00		0	0
resmgr:schema config	18	0.00		0	0
resmgr:vc list latch	813	0.00		0	0
row cache objects	13,053,596	0.06	0.08	0	35,758	2.32
sequence cache	76,027	0.06	0.00	0	0
session allocation	1,063,526	0.37	0.11	0	0
session idle bit	4,330,100	0.00	0.01	0	0
session state list latch	53,023	0.04	0.04	0	0
session switching	43,766	0.15	0.00	0	0
session timer	6,302	0.00		0	0
shared pool	6,620,137	0.12	0.25	3	0
shared pool simulator	4,990,909	0.00	0.02	0	0
simulator hash latch	1,399,451	0.00		0	0
simulator lru latch	37,933	0.00		0	1,361,338	0.00
slave class	36	0.00		0	0
slave class create	144	2.78	1.00	0	0
sort extent pool	939	0.00		0	0
state object free list	36	0.00		0	0
statistics aggregation	10,080	0.00		0	0
temp lob duration state obj allocation	2	0.00		0	0
threshold alerts latch	750	0.00		0	0
transaction allocation	114,578	0.00		0	0
transaction branch allocation	10,712	0.00		0	0
undo global data	141,665	0.00		0	0
user lock	98,702	1.28	0.06	1	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	13,053,596	8,243	665	7,835
shared pool	6,620,137	7,927	1,952	6,158
library cache lock	2,538,947	7,017	53	6,966
cache buffers chains	57,815,686	4,172	223	3,956
session allocation	1,063,526	3,897	427	3,492
library cache	3,803,269	3,729	530	3,302
user lock	98,702	1,264	80	1,191
parameter table allocation management	25,178	849	34	815
process allocation	48,875	549	425	126
resmgr:free threads list	49,945	133	4	129
shared pool simulator	4,990,909	125	2	124
session idle bit	4,330,100	74	1	73
enqueues	999,433	67	7	60
active service list	110,089	56	7	50
enqueue hash chains	862,809	25	2	23
session state list latch	53,023	23	1	22
library cache lock allocation	106,018	19	2	17
archive process latch	6,096	16	16	0
kks stats	399,112	13	8	7
dummy allocation	50,021	11	2	9
channel handle pool latch	48,878	8	3	5
cache buffers lru chain	84,275	4	1	3
slave class create	144	4	4	0
In memory undo latch	156,412	2	2	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	1
In memory undo latch	kticmt: child	1	1
active service list	ksws_event: ksws event	9	9
active service list	kswsgsnp: get service name ptr	2	2
archive process latch	kcrrsarc	16	0
cache buffers chains	kcbgtcr: kslbegin excl	801	397
cache buffers chains	kcbgtcr: fast path	161	0
cache buffers chains	kcbrls: kslbegin	68	632
cache buffers chains	kcbget: pin buffer	1	0
cache buffers lru chain	kcbgtcr:CR Scan:KCBRSKIP	1	0
channel handle pool latch	ksrchconnect()	3	3
cost function	kzulrl	68	69
cost function	kzulgt: find user res	12	11
dummy allocation	ktcscnfy	2	2
enqueue hash chains	ksqgtl3	2	1
enqueues	ksqgel: create enqueue	4	3
enqueues	ksqdel	3	2
kks stats	kks stats alloc/free	8	8
library cache	kglukp: child	23	85
library cache	kgldte: child 0	21	31
library cache	kglobpn: child:	17	10
library cache	kglpndl: child: after processing	15	15
library cache	kglhdgn: child:	13	64
library cache	kglLockCursor	9	13
library cache	kglpndl: child: before processing	8	5
library cache	kgldti: 2child	7	5
library cache	kglhdgc: child:	3	1
library cache	kglobld	3	19
library cache	kglic	2	0
library cache	kglini: child	2	1
library cache	kglpin	1	10
library cache lock	kgllkdl: child: cleanup	46	46
library cache lock	kgllkdl: child: no lock handle	11	18
library cache lock	kgllkal: child: multiinstance	7	7
library cache lock allocation	kgllkget	2	2
parameter table allocation management	ksp_param_table_free	34	34
process allocation	ksucrp	328	0
process allocation	ksudlp	95	70
process allocation	ksuapc	2	355
resmgr:free threads list	kgskthrsod	3	3
resmgr:free threads list	kgskthrcreate	1	1
row cache objects	kqrpre: find obj	72	162
row cache objects	kqreqd: reget	46	101
row cache objects	kqrpre: init complete	27	136
row cache objects	kqreqd	21	69
row cache objects	kqrso	6	2
session allocation	ksuxds: KSUSFCLC not set	318	15
session allocation	ksudlp	68	208
session allocation	ksucri	24	105
session allocation	ksufap: active sessions	9	0
session allocation	ksuxds: not user session	8	95
session idle bit	ksupuc: set busy	1	1
session state list latch	kpseqa	1	1
shared pool	kghfrunp: alloc: session dur	1,193	771
shared pool	kghfrunp: clatch: wait	820	448
shared pool	kghalo	552	473
shared pool	kghupr1	95	488
shared pool	kghfre	77	131
shared pool	kghfrunp: clatch: nowait	68	0
shared pool	kghalp	18	85
shared pool	kghfrunp: alloc: cursor dur	11	0
shared pool	kghasp	3	3
shared pool	kghfrunp: alloc: wait	2	0
shared pool	kghfen: not perm alloc class	1	1
shared pool simulator	kglsim_unpin_simhp	2	0
slave class create	ksvcreate	4	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: 30,178,277
Captured Segments account for 95.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	UET$	TABLE	9,848,592	32.63
HOMENEW	MIS	MEET_ORDER_INFO	TABLE	5,138,992	17.03
HC365	MIS	ORGDEPARTMENT	TABLE	3,730,976	12.36
HC365	MIS	SYS_C008598	INDEX	1,768,224	5.86
HC365	MIS	WF_MESSAGEOPINION	TABLE	1,225,152	4.06

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 87,906
Captured Segments account for 0.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
HC365	MIS	I_WF_TASK_LOG_10390		INDEX	18	0.02
HC365	MIS	WF_TASK_LOG		TABLE	14	0.02
HC365	MIS	I_WF_TASK_LOG_19436		INDEX	9	0.01
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	3444_22651	TABLE PARTITION	9	0.01
HC365	MIS	I_WF_TASK_FROM_POINT		INDEX	6	0.01

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	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSAUX	WRH$_LATCH_MISSES_SUMMARY_PK	3444_22651	INDEX PARTITION	8	12.90
SYS	SYSAUX	WRH$_PARAMETER_PK	3444_22651	INDEX PARTITION	8	12.90
SYS	SYSAUX	WRH$_SERVICE_STAT_PK	3444_22651	INDEX PARTITION	8	12.90
SYS	SYSAUX	WRH$_SYSSTAT_PK	3444_22651	INDEX PARTITION	6	9.68
HC365	MIS	BO_HC_FM_EXESCONTROL		TABLE	2	3.23

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	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
HC365	MIS	USER_SESSION		TABLE	2	100.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	333	0.00	36	1
dc_constraints	144	51.39	144	10
dc_database_links	49,486	0.00	0	2
dc_files	1,224	0.74	0	9
dc_global_oids	1,495	1.07	0	18
dc_histogram_data	813,391	0.40	0	4,286
dc_histogram_defs	523,292	25.28	0	27,548
dc_object_grants	579	21.07	0	82
dc_object_ids	1,503,441	1.18	52	11,550
dc_objects	160,456	11.28	110	6,919
dc_profiles	24,936	0.02	0	1
dc_rollback_segments	2,975	0.00	0	28
dc_segments	341,882	13.38	117	9,299
dc_sequences	29	34.48	29	7
dc_tablespace_quotas	49	6.12	49	1
dc_tablespaces	368,121	0.00	0	7
dc_usernames	171,371	0.12	0	44
dc_users	1,047,455	0.00	0	83
global database name	36	0.00	0	1
outstanding_alerts	216	3.24	0	7

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	4,431	0.02	7,508	0.35	25	0
CLUSTER	69	2.90	141	2.13	1	0
INDEX	65	70.77	221	22.17	3	0
JAVA RESOURCE	7	71.43	10	50.00	0	0
JAVA SOURCE	7	71.43	10	50.00	0	0
SQL AREA	609,657	18.74	1,578,307	12.65	9,936	87
TABLE/PROCEDURE	42,799	26.96	336,375	20.86	11,023	0
TRIGGER	339	2.65	1,109	1.35	6	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	274.67		1.08	3.30	44	45	254	254
	Freeable	52.19	0.00	1.93	5.43	28		27	27
	SQL	1.61	0.70	0.01	0.02	0	67	243	40
	PL/SQL	1.00	0.33	0.00	0.01	0	0	252	252
E	Other	238.08		1.15	3.65	44	45	207	207
	Freeable	56.31	0.00	2.01	5.27	28		28	28
	SQL	1.20	0.58	0.01	0.02	0	67	196	37
	PL/SQL	0.90	0.38	0.00	0.01	0	0	205	205

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	3,254,779,904
Fixed Size	2,090,464
Redo Buffers	14,684,160
Variable Size	1,560,283,680

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	ASH buffers	22.50	22.50	0.00
shared	CCursor	148.43	124.90	-15.85
shared	Cursor Stats	19.42	19.42	0.00
shared	Heap0: KGL		17.03
shared	KGLS heap		28.11
shared	KQR M PO		23.83
shared	PCursor	126.50	93.11	-26.40
shared	db_block_hash_buckets	22.50	22.50	0.00
shared	free memory	250.77	407.29	62.41
shared	kglsim heap	23.67	23.67	0.00
shared	kglsim object batch	40.63	40.63	0.00
shared	library cache	79.87	69.60	-12.85
shared	sql area	567.47	425.41	-25.03
	buffer_cache	3,104.00	3,104.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)
_column_tracking_level	1
archive_lag_target	1800
audit_file_dest	/oracle/admin/mis/adump
background_dump_dest	/oracle/admin/mis/bdump
compatible	10.2.0.3.0
control_files	/oracle/oradata/mis/control01.ctl, /oracle/oradata/mis/control02.ctl, /oracle/oradata/mis/control03.ctl
core_dump_dest	/oracle/admin/mis/cdump
cursor_sharing	EXACT
db_block_size	8192
db_cache_size	3204448256
db_domain
db_file_multiblock_read_count	16
db_name	mis
db_recovery_file_dest	/oracle/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=misXDB)
fal_client	mis_pri
fal_server	mis_std
job_queue_processes	10
log_archive_dest_1	location=/oracle/arch_dest/mis
log_archive_dest_2	SERVICE=mis_std REOPEN=300 VALID_FOR=(ONLINE_LOGFILES, PRIMARY_ROLES) db_unique_name=mis_std
log_archive_dest_state_2	ENABLE
log_archive_format	%t_%s_%r.dbf
open_cursors	300
optimizer_index_caching	88
optimizer_index_cost_adj	30
optimizer_mode	FIRST_ROWS_10
pga_aggregate_target	2097152000
processes	500
remote_login_passwordfile	EXCLUSIVE
sga_target	4831838208
shared_pool_size	0	83886080
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/mis/udump

End of Report

% Blocks changed per Read:	0.97	Recursive Call %:	86.02
Rollback per transaction %:	36.12	Rows per Sort:	88.09

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.71	In-memory Sort %:	100.00
Library Hit %:	85.97	Soft Parse %:	91.68
Execute to Parse %:	12.26	Latch Hit %:	99.96
Parse CPU to Parse Elapsd %:	0.41	% Non-Parse CPU:	78.32