WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

JSDB 3066449946 jsdb 1 10.2.0.4.0 NO SXHSDB2

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
JSDB	3066449946	jsdb	1	10.2.0.4.0	NO	SXHSDB2

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 201 25-Jul-12 11:30:46 116 1.8

End Snap: 202 25-Jul-12 12:01:22 116 1.8

Elapsed: 30.60 (mins)

DB Time: 2,145.19 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	201	25-Jul-12 11:30:46	116	1.8
End Snap:	202	25-Jul-12 12:01:22	116	1.8
Elapsed:		30.60 (mins)
DB Time:		2,145.19 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 29,568M 29,568M Std Block Size: 8K

Shared Pool Size: 3,120M 3,120M Log Buffer: 47,052K

	Begin	End
Buffer Cache:	29,568M	29,568M	Std Block Size:	8K
Shared Pool Size:	3,120M	3,120M	Log Buffer:	47,052K

Load Profile

Per Second Per Transaction

Redo size: 944,445.40 14,814.59

Logical reads: 5,402.25 84.74

Block changes: 3,163.17 49.62

Physical reads: 0.39 0.01

Physical writes: 145.91 2.29

User calls: 536.87 8.42

Parses: 515.49 8.09

Hard parses: 0.03 0.00

Sorts: 0.59 0.01

Logons: 0.02 0.00

Executes: 518.25 8.13

Transactions: 63.75

	Per Second	Per Transaction
Redo size:	944,445.40	14,814.59
Logical reads:	5,402.25	84.74
Block changes:	3,163.17	49.62
Physical reads:	0.39	0.01
Physical writes:	145.91	2.29
User calls:	536.87	8.42
Parses:	515.49	8.09
Hard parses:	0.03	0.00
Sorts:	0.59	0.01
Logons:	0.02	0.00
Executes:	518.25	8.13
Transactions:	63.75

% Blocks changed per Read: 58.55 Recursive Call %: 12.89

Rollback per transaction %: 0.00 Rows per Sort: 277.78

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 99.91 Soft Parse %: 100.00

Execute to Parse %: 0.53 Latch Hit %: 55.35

Parse CPU to Parse Elapsd %: 3.34 % Non-Parse CPU: 99.95

Shared Pool Statistics

Begin End

Memory Usage %: 19.59 19.71

% SQL with executions>1: 75.59 85.56

% Memory for SQL w/exec>1: 82.72 91.71

	Begin	End
Memory Usage %:	19.59	19.71
% SQL with executions>1:	75.59	85.56
% Memory for SQL w/exec>1:	82.72	91.71

Top 5 Timed Events

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

CPU time 27,119 21.1

latch: library cache 673,413 12,698 19 9.9 Concurrency

log file sync 120,827 1,480 12 1.1 Commit

latch: library cache lock 67,892 1,214 18 .9 Concurrency

log file parallel write 98,259 706 7 .5 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		27,119		21.1
latch: library cache	673,413	12,698	19	9.9	Concurrency
log file sync	120,827	1,480	12	1.1	Commit
latch: library cache lock	67,892	1,214	18	.9	Concurrency
log file parallel write	98,259	706	7	.5	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): 128711.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	126,273.28	98.11
DB CPU	27,119.17	21.07
parse time elapsed	499.94	0.39
PL/SQL execution elapsed time	1.80	0.00
hard parse elapsed time	1.03	0.00
hard parse (bind mismatch) elapsed time	0.27	0.00
hard parse (sharing criteria) elapsed time	0.27	0.00
sequence load elapsed time	0.02	0.00
connection management call elapsed time	0.01	0.00
repeated bind elapsed time	0.00	0.00
DB time	128,711.26
background elapsed time	3,444.42
background cpu time	34.97

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	746,367	0.43	13,957	19	6.38
Commit	120,827	0.00	1,480	12	1.03
System I/O	149,110	0.00	956	6	1.27
Network	2,281,747	0.00	309	0	19.50
Other	204,764	0.00	7	0	1.75
Configuration	118	0.00	1	11	0.00
User I/O	1,035	0.00	1	1	0.01
Application	122	0.00	0	1	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: library cache	673,413	0.00	12,698	19	5.75
log file sync	120,827	0.00	1,480	12	1.03
latch: library cache lock	67,892	0.00	1,214	18	0.58
log file parallel write	98,259	0.00	706	7	0.84
SQL*Net more data from client	1,315,720	0.00	304	0	11.24
db file parallel write	31,249	0.00	218	7	0.27
cursor: pin S wait on X	3,419	92.95	40	12	0.03
Log archive I/O	2,127	0.00	23	11	0.02
control file parallel write	937	0.00	7	7	0.01
SQL*Net message to client	965,946	0.00	4	0	8.25
cursor: pin S	200,790	0.00	4	0	1.72
LGWR wait for redo copy	3,529	0.06	3	1	0.03
log file sequential read	1,968	0.00	2	1	0.02
os thread startup	11	0.00	2	218	0.00
buffer busy waits	1,446	0.00	2	1	0.01
log file switch completion	112	0.00	1	12	0.00
latch: cache buffers chains	78	0.00	1	11	0.00
db file sequential read	406	0.00	1	2	0.00
wait list latch free	32	0.00	0	10	0.00
control file sequential read	14,562	0.00	0	0	0.12
direct path write	241	0.00	0	1	0.00
latch: In memory undo latch	107	0.00	0	1	0.00
latch free	371	0.00	0	0	0.00
enq: TX - contention	22	0.00	0	4	0.00
SQL*Net break/reset to client	122	0.00	0	1	0.00
latch: enqueue hash chains	6	0.00	0	8	0.00
direct path read	378	0.00	0	0	0.00
enq: HW - contention	6	0.00	0	2	0.00
rdbms ipc reply	6	0.00	0	1	0.00
enq: TX - index contention	1	0.00	0	8	0.00
db file scattered read	10	0.00	0	1	0.00
SQL*Net more data to client	81	0.00	0	0	0.00
enq: FB - contention	5	0.00	0	1	0.00
latch: redo allocation	1	0.00	0	3	0.00
log file single write	8	0.00	0	0	0.00
buffer deadlock	2	100.00	0	0	0.00
SQL*Net message from client	965,952	0.00	23,749	25	8.25
wait for unread message on broadcast channel	1,838	99.84	1,792	975	0.02
jobq slave wait	611	96.07	1,788	2927	0.01
Streams AQ: waiting for messages in the queue	367	99.18	1,787	4870	0.00
Streams AQ: qmn slave idle wait	66	0.00	1,768	26788	0.00
Streams AQ: qmn coordinator idle wait	132	50.00	1,768	13394	0.00
Streams AQ: waiting for time management or cleanup tasks	66	63.64	1,760	26672	0.00
class slave wait	4	0.00	0	2	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	98,256	0.00	706	7	0.84
db file parallel write	31,249	0.00	218	7	0.27
Log archive I/O	2,127	0.00	23	11	0.02
control file parallel write	937	0.00	7	7	0.01
events in waitclass Other	3,530	0.06	3	1	0.03
log file sequential read	1,968	0.00	2	1	0.02
os thread startup	11	0.00	2	218	0.00
direct path write	206	0.00	0	0	0.00
db file sequential read	10	0.00	0	8	0.00
control file sequential read	1,916	0.00	0	0	0.02
direct path read	378	0.00	0	0	0.00
log file single write	8	0.00	0	0	0.00
latch: cache buffers chains	1	0.00	0	0	0.00
rdbms ipc message	96,463	10.13	28,715	298	0.82
pmon timer	613	100.00	1,787	2915	0.01
Streams AQ: qmn slave idle wait	66	0.00	1,768	26788	0.00
Streams AQ: qmn coordinator idle wait	132	50.00	1,768	13394	0.00
Streams AQ: waiting for time management or cleanup tasks	66	63.64	1,760	26672	0.00
smon timer	6	83.33	1,443	240422	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	177,619
AVG_IDLE_TIME	5,827
AVG_IOWAIT_TIME	0
AVG_SYS_TIME	1,123
AVG_USER_TIME	176,434
BUSY_TIME	11,371,554
IDLE_TIME	376,585
IOWAIT_TIME	1,795
SYS_TIME	75,811
USER_TIME	11,295,743
LOAD	0
OS_CPU_WAIT_TIME	11,509,000
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	68,719,476,736
NUM_CPUS	64
NUM_CPU_CORES	32

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	128,717.90	27,119.40	342	9,904,802
jsdb	3.60	3.10	0	6,601
SYS$BACKGROUND	0.00	0.00	388	9,194

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	430	72	746384	1395481	2278870	30852
jsdb	0	0	0	0	2858	1
SYS$BACKGROUND	604	22	13	239	0	0

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
126,529	27,078			98.30	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
10	5	1	9.94	0.01	391m7rjabxj2m	sqlplus@SXHSDB2 (TNS V1-V3)	BEGIN dbms_workload_repository...
4	2	1	3.90	0.00	84qubbrsr0kfn		insert into wrh$_latch (snap...
3	2	1	3.44	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
2	2	1,092	0.00	0.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
2	1	30	0.06	0.00	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
1	1	9,454	0.00	0.00	bunvx480ynf57		SELECT 1 FROM DUAL
1	0	25	0.04	0.00	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
1	0	6	0.15	0.00	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
1	0	1	0.86	0.00	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...

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
27,078	126,529			98.30	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
5	10	1	5.35	0.01	391m7rjabxj2m	sqlplus@SXHSDB2 (TNS V1-V3)	BEGIN dbms_workload_repository...
2	4	1	2.31	0.00	84qubbrsr0kfn		insert into wrh$_latch (snap...
2	3	1	2.02	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
2	2	1,092	0.00	0.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
1	1	9,454	0.00	0.00	bunvx480ynf57		SELECT 1 FROM DUAL
1	2	30	0.03	0.00	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	1	302	0.00	0.00	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
0	1	6	0.08	0.00	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
0	1	25	0.02	0.00	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...

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: 9,917,772
Captured SQL account for 0.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
10,796	30	359.87	0.11	0.84	1.79	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
7,801	1	7,801.00	0.08	5.35	9.94	391m7rjabxj2m	sqlplus@SXHSDB2 (TNS V1-V3)	BEGIN dbms_workload_repository...
6,007	25	240.28	0.06	0.48	1.04	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
4,958	1	4,958.00	0.05	0.33	0.86	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
4,368	1,092	4.00	0.04	1.86	1.86	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
3,096	302	10.25	0.03	0.49	0.61	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
2,108	6	351.33	0.02	0.48	0.89	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
2,102	1	2,102.00	0.02	0.07	0.16	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
1,708	62	27.55	0.02	0.47	0.47	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
1,101	367	3.00	0.01	0.12	0.12	6ssrk2dqj7jbx		select job, nvl2(last_date, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 714
Captured SQL account for 58.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
169	30	5.63	23.67	0.84	1.79	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
168	25	6.72	23.53	0.48	1.04	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
160	1	160.00	22.41	0.33	0.86	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
146	1	146.00	20.45	5.35	9.94	391m7rjabxj2m	sqlplus@SXHSDB2 (TNS V1-V3)	BEGIN dbms_workload_repository...
68	1	68.00	9.52	0.07	0.16	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
67	1	67.00	9.38	0.03	0.07	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
12	4	3.00	1.68	0.05	0.16	0gkq5s6hqx8hy		insert into wrh$_sessmetric_hi...
5	1	5.00	0.70	0.01	0.04	gnpgr4vkwkx1r		insert into TBL_CTJC_1 (gsdm, ...
1	18	0.06	0.14	0.00	0.00	04xtrk7uyhknh		select obj#, type#, ctime, mti...
1	1	1.00	0.14	0.03	0.05	agpd044zj368m		insert into wrh$_system_event ...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 951,437
Captured SQL account for 1.7% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
9,454	9,455	1.00	bunvx480ynf57		SELECT 1 FROM DUAL
1,122	1,122	1.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
1,092	0	0.00	6gh8gj9n09vr7	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
1,092	1,092	1.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
388	388	1.00	dbjvf9ak4ta94		select tbl_ctjs_check_seq.next...
367	30	0.08	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
337	337	1.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
302	388	1.28	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
125	319	2.55	bsa0wjtftg3uw		select file# from file$ where ...
108	108	1.00	cf06fwacdmgfk	plsqldev.exe	select 'x' from dual

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 946,362
Captured SQL account for 1.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
932,961		98.58	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
9,456	9,454	1.00	bunvx480ynf57		SELECT 1 FROM DUAL
388	388	0.04	dbjvf9ak4ta94		select tbl_ctjs_check_seq.next...
302	302	0.03	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
125	125	0.01	bsa0wjtftg3uw		select file# from file$ where ...
108	108	0.01	cf06fwacdmgfk	plsqldev.exe	select 'x' from dual
103	103	0.01	19g6x6d7nh669		select blocks, NVL(ts#, -1), s...
72	72	0.01	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
72	72	0.01	g00cj285jmgsw		update sys.mon_mods$ set inser...
62	62	0.01	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
36,706,176		1.12	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
1,907,709	302	0.06	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...

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
247		4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

089dbukv1aanh SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL

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

0gkq5s6hqx8hy insert into wrh$_sessmetric_history (snap_id, dbid, instance_number, begin_time, end_time, sessid, serial#, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, eid, eidsq, intsize_csec, groupid, metricid, value from x$kewmdrmv where groupid = 4

19g6x6d7nh669 select blocks, NVL(ts#, -1), status$, NVL(relfile#, 0), maxextend, inc, crscnwrp, crscnbas, NVL(spare1, 0) from file$ where file#=:1

2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;

350f5yrnnmshs lock table sys.mon_mods$ in exclusive mode nowait

391m7rjabxj2m BEGIN dbms_workload_repository.CREATE_SNAPSHOT; END;

4hbfsfnnydqnh INSERT INTO tbl_ctjs (gsdm, xzdm, gappno, bdh, ryxh, datasrc, rowid_from, flag, bbrxb, bdzt, jffs, jfqx, sjjfqx, bxqx, lqfs, lqnl, tbnl, cbrq, ksrq, tzrq, bdztbhrq, xcjfqx, zjqx, cjrq, jfcs, jfl, jfbz, fs, ljjnbf, dqje, yjbf, cbzjf, zhye, swrq, swgfje, dqtbje, sum_dispay, sum_surpay, sum_mq, xsqd, bdjgnf, dnbf, dnpgbf, prem_flag, kqx, sxsjbf, basres, pdres, cv, zbj, sxminus, swzbj, tbzbj, zbjjsbzw, ylwlje, ypwpje, wjzbj, wjzbjbzw, pvpension, initialpay, njjs_flag, dqjnbf, dqjfzrqq, zjjfrq, xbbf, dnjfcs, dnjfbf, ydfy, zjyj, jjyj, glf, fyjsbzw, fy_adjust, fy_adjust_flag, zrswbe, ywswbe, ywscbe, yxbe, bejsbzw, living_p1, death_p1, living_p2, death_p2, living_p3, death_p3, living_fp, living_flag, jfxbe, yqswgf, cfnled, dqyn, yqswjsbzw, lqnx, lpgfrq, dnlqje, int_expect, expect_flag, snwzbj, dqylje, yqswgfcb, sum_sc, sum_medpay, gpolicyno, tb_cv, snmbdztbhrq, bmdm, ibnr, dnlpje, dntbje, dqmqje, dqnjlqje, dqqtje, deptno_cw, kxqydfy, kxqdnpgbf, pgfy, yqscgf, fa_sp, snmbdzt, errortype, estres, recalcflag, div_add, xcjfrq, res0, bdzt0, stopdate, begdate, zjfxrq, reljfqx, xzdm8, grace_bf) 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, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, : 82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132)

6gh8gj9n09vr7 SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :B1

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;

6ssrk2dqj7jbx select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job

84qubbrsr0kfn insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

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

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

agpd044zj368m insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro from v$system_event order by event_id

bsa0wjtftg3uw select file# from file$ where ts#=: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

bunvx480ynf57 SELECT 1 FROM DUAL

c2aw4fq306q4k INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)

cb75rw3w1tt0s begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;

cf06fwacdmgfk select 'x' from dual

cnf7gzg73rn5w insert into tbl_ctjs_check (codeid, gsdm, xzdm, gappno, bdh, ryxh, datasrc, rowid_from, flag, bdzt, jffs, jfqx, sjjfqx, bxqx, lqfs, lqnl, tbnl, cbrq, ksrq, tzrq, bdztbhrq, xcjfqx, zjqx, sjcjrq, jfcs, jfl, jfbz, fs, ljjnbf, dqje, yjbf, cbzjf, zhye, swrq, swgfje, dqtbje, sum_dispay, sum_surpay, sum_mq, xsqd, bdjgnf, dnbf, dnpgbf, prem_flag, kqx, sxsjbf, basres, pdres, cv, zbj, sxminus, swzbj, tbzbj, zbjjsbzw, ylwlje, ypwpje, wjzbj, wjzbjbzw, pvpension, initialpay, njjs_flag, dqjnbf, dqjfzrqq, zjjfrq, dqxbbf, dnjfcs, dnjfbf, ydfy, zjyj, jjyj, glf, fyjsbzw, fy_adjust, fy_adjust_flag, zrswbe, ywswbe, ywscbe, yxbe, bejsbzw, living_p1, death_p1, living_p2, death_p2, living_p3, death_p3, living_fp, living_flag, jfxbe, yqswgf, cfnled, dqyn, yqswjsbzw, lqnx, lpgfrq, dnlqje, int_expect, expect_flag, snwzbj, dqylje, yqswgfcb, sum_sc, sum_medpay, gpolicyno, tb_cv, snmbdztbhrq, bmdm, ibnr, dnlpje, dntbje, dqmqje, dqnjlqje, dqqtje, deptno_cw, kxqydfy, kxqdnpgfy, pgfy, yqscgf, fa_sp, snmbdzt, error_type, bbrxb, zbj_exception, fy_exception, be_exception, swzbj_exception, wj_exception, yqsw_exception, scgf_exception, hlzbj_exception, prem_exception, reljfqx, zjfxrq, begdate, stopdate, xcjfrq, res0, bdzt0, div_add, kxqdnpgbf, cjrq, xbbf, xzmc, jfzrzzrq, isflag, grace_bf, deptno, xzdm8 ) 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, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, : 43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147 )

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

dbjvf9ak4ta94 select tbl_ctjs_check_seq.nextval from dual

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

g2wr3u7s1gtf3 select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

gnpgr4vkwkx1r insert into TBL_CTJC_1 (gsdm, bdh, ryxh, id, tbnl, bbrxb, cbrq, jfzrzzrq, begdate, stopdate, jffs, jfqx, reljfqx, xzdm, xzmc, lqfs, ljjnbf, xbbf, dqjnbf, yjbf, cbzjf, zjjfrq, dqjfzrqq, xcjfrq, jfcs, lqnl, bdzt, fs, jfbz, jfl, bdztbhrq, zjfxrq, njlqje, sum_surpay, sum_dispay, sum_medpay, ylwlje, ypwpje, cv, scgfrq, dnlqje, dqtbje, dnlpje, lqyy, swyy, hs, xyzk, zyzk, swrq, lpgfrq, dnjbje, djje, zhye, dqkf, sum_mq, sum_sc, dqnjlqje, dqylwlje, dqmqje, dqqtje, swgfje, dqylje, xsqd, deptno, cjrq, chk_flag, chk_flag1, lqnx, apid, aprela, apsex, apbirth, apjob, apmarri, chklevel, stdrate, unstdrate, addrate, waivdate, padsign, paddate, gpolicyno, grace_bf, direct_yj, deptno_cw, empno, degreeno, ibnr, job_version, res0, bdzt0, ischeck, isflag, isxb, islqfs, isjffs, isjfqx, istbnl, islqnl, isbdzt, isxcjfrq, iscbrq, isbdztbhrq, isjfbz, xzdm8, bxqx, wjres0) values ('XIM', '310311114731760', 0, '37010220081014008X', 0, '2', to_date('2011-08-17', 'yyyy-mm-dd'), to_date('2011-08-24', 'yyyy-mm-dd'), to_date('2011-08-19', 'yyyy-mm-dd'), to_date('2011-08-24', 'yyyy-mm-dd'), '01', 0, 1, 'EA4601', '��ͻ��Բ��', '1', 1.8, 0, 0, 0, 0, to_date('2011-10-11', 'yyyy-mm-dd'), to_date('2011-08-19', 'yyyy-mm-dd'), null, 1, 99, '2', 3, 0.6, 1, null, null, 0, 0, 0, 0, null, 0, 0, null, 0, 0, 0, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '32', null, to_ date('2011-12 -31', 'yyyy-mm-dd'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '310311114731760', 0, 0, null, null, null, null, null, 0, '2', '0', null, null, null, null, null, null, null, null, null, null, null, null, '26460100', '0', 0)

SQL Id	SQL Text
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
089dbukv1aanh	SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL
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
0gkq5s6hqx8hy	insert into wrh$_sessmetric_history (snap_id, dbid, instance_number, begin_time, end_time, sessid, serial#, intsize, group_id, metric_id, value) select :snap_id, :dbid, :instance_number, begtime, endtime, eid, eidsq, intsize_csec, groupid, metricid, value from x$kewmdrmv where groupid = 4
19g6x6d7nh669	select blocks, NVL(ts#, -1), status$, NVL(relfile#, 0), maxextend, inc, crscnwrp, crscnbas, NVL(spare1, 0) from file$ where file#=:1
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END;
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
391m7rjabxj2m	BEGIN dbms_workload_repository.CREATE_SNAPSHOT; END;
4hbfsfnnydqnh	INSERT INTO tbl_ctjs (gsdm, xzdm, gappno, bdh, ryxh, datasrc, rowid_from, flag, bbrxb, bdzt, jffs, jfqx, sjjfqx, bxqx, lqfs, lqnl, tbnl, cbrq, ksrq, tzrq, bdztbhrq, xcjfqx, zjqx, cjrq, jfcs, jfl, jfbz, fs, ljjnbf, dqje, yjbf, cbzjf, zhye, swrq, swgfje, dqtbje, sum_dispay, sum_surpay, sum_mq, xsqd, bdjgnf, dnbf, dnpgbf, prem_flag, kqx, sxsjbf, basres, pdres, cv, zbj, sxminus, swzbj, tbzbj, zbjjsbzw, ylwlje, ypwpje, wjzbj, wjzbjbzw, pvpension, initialpay, njjs_flag, dqjnbf, dqjfzrqq, zjjfrq, xbbf, dnjfcs, dnjfbf, ydfy, zjyj, jjyj, glf, fyjsbzw, fy_adjust, fy_adjust_flag, zrswbe, ywswbe, ywscbe, yxbe, bejsbzw, living_p1, death_p1, living_p2, death_p2, living_p3, death_p3, living_fp, living_flag, jfxbe, yqswgf, cfnled, dqyn, yqswjsbzw, lqnx, lpgfrq, dnlqje, int_expect, expect_flag, snwzbj, dqylje, yqswgfcb, sum_sc, sum_medpay, gpolicyno, tb_cv, snmbdztbhrq, bmdm, ibnr, dnlpje, dntbje, dqmqje, dqnjlqje, dqqtje, deptno_cw, kxqydfy, kxqdnpgbf, pgfy, yqscgf, fa_sp, snmbdzt, errortype, estres, recalcflag, div_add, xcjfrq, res0, bdzt0, stopdate, begdate, zjfxrq, reljfqx, xzdm8, grace_bf) 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, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, : 82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132)
6gh8gj9n09vr7	SELECT JOB_ID, EXECUTION_ID, STEP_ID, STEP_NAME, STEP_TYPE, ITERATE_PARAM, ITERATE_PARAM_INDEX, COMMAND_TYPE, TIMEZONE_REGION FROM MGMT_JOB_EXECUTION J WHERE STEP_TYPE IN (:B7 , :B6 , :B5 ) AND STEP_STATUS = :B4 AND COMMAND_TYPE = :B3 AND STEP_NAME LIKE :B2 AND START_TIME <= SYS_EXTRACT_UTC(SYSTIMESTAMP) AND ROWNUM <= :B1
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;
6ssrk2dqj7jbx	select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) order by next_date, job
84qubbrsr0kfn	insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash
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
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
agpd044zj368m	insert into wrh$_system_event (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select :snap_id, :dbid, :instance_number, event_id, total_waits, total_timeouts, time_waited_micro from v$system_event order by event_id
bsa0wjtftg3uw	select file# from file$ where ts#=: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
bunvx480ynf57	SELECT 1 FROM DUAL
c2aw4fq306q4k	INSERT /+ APPEND / INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_hash, session_type, flags , sql_opcode, plsql_entry_object_id, plsql_entry_subprogram_id, plsql_object_id, plsql_subprogram_id, blocking_session, blocking_session_serial#, qc_session_id, qc_instance_id, xid, current_obj#, current_file#, current_block#, event_id, seq#, p1, p2, p3, wait_time, time_waited, program, module, action, client_id ) (SELECT :snap_id, :dbid, :instance_number, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.user_id, a.sql_id, a.sql_child_number, a.sql_plan_hash_value, a.force_matching_signature, a.service_hash, a.session_type, decode(a.flags, 0, to_number(NULL), a.flags), a.sql_opcode, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.blocking_session, a.blocking_session_serial#, a.qc_session_id, a.qc_instance_id, a.xid, a.current_obj#, a.current_file#, a.current_block#, a.event_id, a.seq#, a.p1, a.p2, a.p3, a.wait_time, a.time_waited, substrb(a.program, 1, 64), a.module, a.action, a.client_id FROM x$ash a, (SELECT h.sample_addr, h.sample_id FROM x$kewash h WHERE ( (h.sample_id >= :begin_flushing) and (h.sample_id < :latest_sample_id) ) and (MOD(h.sample_id, :disk_filter_ratio) = 0) ) shdr WHERE shdr.sample_addr = a.sample_addr and shdr.sample_id = a.sample_id)
cb75rw3w1tt0s	begin MGMT_JOB_ENGINE.get_scheduled_steps(:1, :2, :3, :4); end;
cf06fwacdmgfk	select 'x' from dual
cnf7gzg73rn5w	insert into tbl_ctjs_check (codeid, gsdm, xzdm, gappno, bdh, ryxh, datasrc, rowid_from, flag, bdzt, jffs, jfqx, sjjfqx, bxqx, lqfs, lqnl, tbnl, cbrq, ksrq, tzrq, bdztbhrq, xcjfqx, zjqx, sjcjrq, jfcs, jfl, jfbz, fs, ljjnbf, dqje, yjbf, cbzjf, zhye, swrq, swgfje, dqtbje, sum_dispay, sum_surpay, sum_mq, xsqd, bdjgnf, dnbf, dnpgbf, prem_flag, kqx, sxsjbf, basres, pdres, cv, zbj, sxminus, swzbj, tbzbj, zbjjsbzw, ylwlje, ypwpje, wjzbj, wjzbjbzw, pvpension, initialpay, njjs_flag, dqjnbf, dqjfzrqq, zjjfrq, dqxbbf, dnjfcs, dnjfbf, ydfy, zjyj, jjyj, glf, fyjsbzw, fy_adjust, fy_adjust_flag, zrswbe, ywswbe, ywscbe, yxbe, bejsbzw, living_p1, death_p1, living_p2, death_p2, living_p3, death_p3, living_fp, living_flag, jfxbe, yqswgf, cfnled, dqyn, yqswjsbzw, lqnx, lpgfrq, dnlqje, int_expect, expect_flag, snwzbj, dqylje, yqswgfcb, sum_sc, sum_medpay, gpolicyno, tb_cv, snmbdztbhrq, bmdm, ibnr, dnlpje, dntbje, dqmqje, dqnjlqje, dqqtje, deptno_cw, kxqydfy, kxqdnpgfy, pgfy, yqscgf, fa_sp, snmbdzt, error_type, bbrxb, zbj_exception, fy_exception, be_exception, swzbj_exception, wj_exception, yqsw_exception, scgf_exception, hlzbj_exception, prem_exception, reljfqx, zjfxrq, begdate, stopdate, xcjfrq, res0, bdzt0, div_add, kxqdnpgbf, cjrq, xbbf, xzmc, jfzrzzrq, isflag, grace_bf, deptno, xzdm8 ) 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, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, : 43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147 )
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dbjvf9ak4ta94	select tbl_ctjs_check_seq.nextval from dual
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))
gnpgr4vkwkx1r	insert into TBL_CTJC_1 (gsdm, bdh, ryxh, id, tbnl, bbrxb, cbrq, jfzrzzrq, begdate, stopdate, jffs, jfqx, reljfqx, xzdm, xzmc, lqfs, ljjnbf, xbbf, dqjnbf, yjbf, cbzjf, zjjfrq, dqjfzrqq, xcjfrq, jfcs, lqnl, bdzt, fs, jfbz, jfl, bdztbhrq, zjfxrq, njlqje, sum_surpay, sum_dispay, sum_medpay, ylwlje, ypwpje, cv, scgfrq, dnlqje, dqtbje, dnlpje, lqyy, swyy, hs, xyzk, zyzk, swrq, lpgfrq, dnjbje, djje, zhye, dqkf, sum_mq, sum_sc, dqnjlqje, dqylwlje, dqmqje, dqqtje, swgfje, dqylje, xsqd, deptno, cjrq, chk_flag, chk_flag1, lqnx, apid, aprela, apsex, apbirth, apjob, apmarri, chklevel, stdrate, unstdrate, addrate, waivdate, padsign, paddate, gpolicyno, grace_bf, direct_yj, deptno_cw, empno, degreeno, ibnr, job_version, res0, bdzt0, ischeck, isflag, isxb, islqfs, isjffs, isjfqx, istbnl, islqnl, isbdzt, isxcjfrq, iscbrq, isbdztbhrq, isjfbz, xzdm8, bxqx, wjres0) values ('XIM', '310311114731760', 0, '37010220081014008X', 0, '2', to_date('2011-08-17', 'yyyy-mm-dd'), to_date('2011-08-24', 'yyyy-mm-dd'), to_date('2011-08-19', 'yyyy-mm-dd'), to_date('2011-08-24', 'yyyy-mm-dd'), '01', 0, 1, 'EA4601', '��ͻ��Բ��', '1', 1.8, 0, 0, 0, 0, to_date('2011-10-11', 'yyyy-mm-dd'), to_date('2011-08-19', 'yyyy-mm-dd'), null, 1, 99, '2', 3, 0.6, 1, null, null, 0, 0, 0, 0, null, 0, 0, null, 0, 0, 0, null, null, null, null, null, null, null, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '32', null, to_ date('2011-12 -31', 'yyyy-mm-dd'), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '310311114731760', 0, 0, null, null, null, null, null, 0, '2', '0', null, null, null, null, null, null, null, null, null, null, null, null, '26460100', '0', 0)

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	2,709,607	1,475.93	23.15
CPU used when call started	2,709,200	1,475.71	23.15
CR blocks created	62	0.03	0.00
Cached Commit SCN referenced	321	0.17	0.00
Commit SCN cached	2	0.00	0.00
DB time	13,751,393	7,490.43	117.50
DBWR checkpoint buffers written	267,367	145.64	2.28
DBWR checkpoints	2	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	444	0.24	0.00
DBWR undo block writes	48,956	26.67	0.42
IMU CR rollbacks	18	0.01	0.00
IMU Flushes	45,450	24.76	0.39
IMU Redo allocation size	210,037,452	114,408.15	1,794.61
IMU commits	71,056	38.70	0.61
IMU contention	1,980	1.08	0.02
IMU pool not allocated	983	0.54	0.01
IMU recursive-transaction flush	58	0.03	0.00
IMU undo allocation size	128,997,824	70,265.57	1,102.19
IMU- failed to get a private strand	983	0.54	0.01
SQL*Net roundtrips to/from client	965,615	525.97	8.25
active txn count during cleanout	442,153	240.84	3.78
application wait time	8	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	10,177	5.54	0.09
branch node splits	30	0.02	0.00
buffer is not pinned count	12,851	7.00	0.11
buffer is pinned count	26,692	14.54	0.23
bytes received via SQL*Net from client	3,981,938,034	2,168,975.77	34,022.61
bytes sent via SQL*Net to client	51,720,266	28,172.21	441.91
calls to get snapshot scn: kcmgss	1,138,419	620.10	9.73
calls to kcmgas	176,560	96.17	1.51
calls to kcmgcs	88,255	48.07	0.75
change write time	10,331	5.63	0.09
cleanout - number of ktugct calls	288,176	156.97	2.46
cleanouts and rollbacks - consistent read gets	18	0.01	0.00
cleanouts only - consistent read gets	3	0.00	0.00
cluster key scan block gets	3,303	1.80	0.03
cluster key scans	1,147	0.62	0.01
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: buffer being written	25	0.01	0.00
commit cleanout failures: callback failure	2,924	1.59	0.02
commit cleanout failures: cannot pin	191	0.10	0.00
commit cleanouts	1,451,295	790.53	12.40
commit cleanouts successfully completed	1,448,155	788.82	12.37
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	39,082	21.29	0.33
concurrency wait time	1,395,743	760.27	11.93
consistent changes	55	0.03	0.00
consistent gets	1,496,351	815.07	12.79
consistent gets - examination	488,798	266.25	4.18
consistent gets direct	0	0.00	0.00
consistent gets from cache	1,496,351	815.07	12.79
cursor authentications	339	0.18	0.00
data blocks consistent reads - undo records applied	55	0.03	0.00
db block changes	5,807,133	3,163.17	49.62
db block gets	8,421,399	4,587.17	71.95
db block gets direct	293	0.16	0.00
db block gets from cache	8,421,106	4,587.01	71.95
deferred (CURRENT) block cleanout applications	382,669	208.44	3.27
enqueue conversions	984	0.54	0.01
enqueue releases	267,569	145.75	2.29
enqueue requests	267,575	145.75	2.29
enqueue timeouts	6	0.00	0.00
enqueue waits	33	0.02	0.00
exchange deadlocks	2	0.00	0.00
execute count	951,437	518.25	8.13
free buffer inspected	0	0.00	0.00
free buffer requested	139,957	76.24	1.20
heap block compress	39	0.02	0.00
immediate (CR) block cleanout applications	21	0.01	0.00
immediate (CURRENT) block cleanout applications	29,710	16.18	0.25
index crx upgrade (positioned)	5,094	2.77	0.04
index fast full scans (full)	3	0.00	0.00
index fetch by key	6,258	3.41	0.05
index scans kdiixs1	6,016	3.28	0.05
leaf node 90-10 splits	61	0.03	0.00
leaf node splits	9,694	5.28	0.08
lob reads	0	0.00	0.00
lob writes	29	0.02	0.00
lob writes unaligned	29	0.02	0.00
logons cumulative	42	0.02	0.00
messages received	129,747	70.67	1.11
messages sent	129,747	70.67	1.11
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	10,647	5.80	0.09
opened cursors cumulative	22,048	12.01	0.19
parse count (failures)	0	0.00	0.00
parse count (hard)	46	0.03	0.00
parse count (total)	946,362	515.49	8.09
parse time cpu	1,308	0.71	0.01
parse time elapsed	39,211	21.36	0.34
physical read IO requests	679	0.37	0.01
physical read bytes	5,849,088	3,186.02	49.98
physical read total IO requests	17,330	9.44	0.15
physical read total bytes	2,292,028,928	1,248,476.29	19,583.63
physical read total multi block requests	1,962	1.07	0.02
physical reads	714	0.39	0.01
physical reads cache	336	0.18	0.00
physical reads cache prefetch	35	0.02	0.00
physical reads direct	378	0.21	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	31,549	17.18	0.27
physical write bytes	2,194,358,272	1,195,274.74	18,749.11
physical write total IO requests	275,940	150.31	2.36
physical write total bytes	7,929,855,488	4,319,420.42	67,754.54
physical write total multi block requests	262,570	143.02	2.24
physical writes	267,866	145.91	2.29
physical writes direct	499	0.27	0.00
physical writes direct (lob)	23	0.01	0.00
physical writes from cache	267,367	145.64	2.28
physical writes non checkpoint	141,781	77.23	1.21
pinned buffers inspected	0	0.00	0.00
recursive calls	145,821	79.43	1.25
recursive cpu usage	1,483	0.81	0.01
redo blocks written	3,557,606	1,937.84	30.40
redo buffer allocation retries	59	0.03	0.00
redo entries	2,984,094	1,625.45	25.50
redo log space requests	112	0.06	0.00
redo log space wait time	123	0.07	0.00
redo ordering marks	49,413	26.92	0.42
redo size	1,733,870,476	944,445.40	14,814.59
redo subscn max counts	135,280	73.69	1.16
redo synch time	145,222	79.10	1.24
redo synch writes	116,925	63.69	1.00
redo wastage	29,315,244	15,968.12	250.48
redo write time	71,992	39.21	0.62
redo writer latching time	277	0.15	0.00
redo writes	98,217	53.50	0.84
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	37	0.02	0.00
rows fetched via callback	2,742	1.49	0.02
session cursor cache hits	502,709	273.83	4.30
session logical reads	9,917,772	5,402.25	84.74
session pga memory	61,194,896	33,333.08	522.86
session pga memory max	127,272,240	69,325.64	1,087.44
session uga memory	###############	70,186,226.58	1,100,942.91
session uga memory max	48,314,936	26,317.32	412.81
shared hash latch upgrades - no wait	5,249	2.86	0.04
sorts (memory)	1,080	0.59	0.01
sorts (rows)	300,003	163.41	2.56
sql area evicted	0	0.00	0.00
sql area purged	0	0.00	0.00
switch current to new buffer	44	0.02	0.00
table fetch by rowid	15,521	8.45	0.13
table fetch continued row	0	0.00	0.00
table scan blocks gotten	3,820	2.08	0.03
table scan rows gotten	94,664	51.56	0.81
table scans (long tables)	0	0.00	0.00
table scans (short tables)	704	0.38	0.01
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	0	0.00	0.00
undo change vector size	331,964,548	180,822.27	2,836.38
user I/O wait time	92	0.05	0.00
user calls	985,624	536.87	8.42
user commits	117,038	63.75	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	560	0.31	0.00
write clones created in background	0	0.00	0.00
write clones created in foreground	66	0.04	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	3,643	4,306
opened cursors current	210	211
logons current	116	116

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	3.92

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 Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
ACT_INDEX	10	0.00	1.00	20,149	11	21	2.38
ACT_DATA	70	0.57	1.00	7,186	4	1,396	1.02
UNDOTBS1	25	2.40	1.00	3,545	2	29	1.38
SYSAUX	188	2.55	1.02	393	0	0	0.00
SYSTEM	28	0.36	2.14	62	0	0	0.00
ACT_DATA_PTIJ	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PWUH	7	1.43	1.00	2	0	0	0.00
ACT_DATA_PWUL	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PWUX	7	1.43	1.00	2	0	0	0.00
ACT_DATA_PXIA	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PXIM	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PZHZ	7	0.00	1.00	2	0	0	0.00
ACT_GINDEX	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PBEJ	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHC	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHD	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHQ	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PCHS	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHZ	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PDAL	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PDEFAULT	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PFUZ	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PGUZ	7	2.86	1.00	2	0	0	0.00
ACT_INDEX_PGYA	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PHAE	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PHAN	7	1.43	1.00	2	0	0	0.00
ACT_DATA_PHAN	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PHAZ	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PHEF	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PHSY	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PJIN	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PKUM	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PLAZ	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNAC	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNAJ	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNAN	5	4.00	1.00	2	0	0	0.00
ACT_DATA_PNEM	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PNIB	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNIX	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PQID	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PQNH	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PSHH	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PSHJ	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PSHZ	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PSUZ	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PTAY	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PWUH	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PWUL	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PWUX	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PXIA	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PXIM	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PZHZ	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PBEJ	4	2.50	1.00	2	0	0	0.00
ACT_DATA_PCHC	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHD	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHQ	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHS	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHZ	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PDAL	3	6.67	1.00	2	0	0	0.00
ACT_DATA_PDEFAULT	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PFUZ	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PGUZ	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PGYA	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PHAE	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PHAZ	3	3.33	1.00	2	0	0	0.00
ACT_INDEX_PHEF	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PHSY	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PJIN	3	6.67	1.00	2	0	0	0.00
ACT_INDEX_PKUM	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PLAZ	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNAC	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNAJ	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNAN	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNEM	3	3.33	1.00	2	0	0	0.00
ACT_INDEX_PNIB	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNIX	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PQID	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PQNH	3	3.33	1.00	2	0	0	0.00
ACT_INDEX_PSHH	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PSHJ	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PSHZ	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PSUZ	3	6.67	1.00	2	0	0	0.00
ACT_INDEX_PTAY	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PTIJ	3	0.00	1.00	2	0	0	0.00
USERS	3	3.33	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 Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_01.dbf	6	3.33	1.00	715	0	128	1.33
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_02.dbf	6	1.67	1.00	743	0	115	0.78
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_03.dbf	6	1.67	1.00	625	0	138	0.51
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_04.dbf	4	0.00	1.00	858	0	85	0.94
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_05.dbf	4	0.00	1.00	784	0	94	0.43
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_06.dbf	4	0.00	1.00	606	0	232	1.34
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_07.dbf	4	0.00	1.00	618	0	241	1.37
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_08.dbf	6	0.00	1.00	3	0	64	0.94
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_09.dbf	4	0.00	1.00	2	0	70	0.43
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_10.dbf	4	0.00	1.00	66	0	0	0.00
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_11.dbf	4	0.00	1.00	39	0	0	0.00
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_12.dbf	6	0.00	1.00	693	0	59	1.69
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_13.dbf	6	0.00	1.00	698	0	76	1.18
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_14.dbf	6	0.00	1.00	736	0	94	0.64
ACT_DATA_PBEJ	/jsdb/jsdbdat_u02/jsdb/act_data_pbej_01.dbf	4	2.50	1.00	2	0	0	0.00
ACT_DATA_PCHC	/jsdb/jsdbdat_u02/jsdb/act_data_pchc_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHD	/jsdb/jsdbdat_u02/jsdb/act_data_pchd_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHQ	/jsdb/jsdbdat_u02/jsdb/act_data_pchq_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHS	/jsdb/jsdbdat_u02/jsdb/act_data_pchs_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PCHZ	/jsdb/jsdbdat_u02/jsdb/act_data_pchz_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PDAL	/jsdb/jsdbdat_u02/jsdb/act_data_pdal_01.dbf	3	6.67	1.00	2	0	0	0.00
ACT_DATA_PDEFAULT	/jsdb/jsdbdat_u02/jsdb/act_data_pdefault_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PFUZ	/jsdb/jsdbdat_u02/jsdb/act_data_pfuz_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_DATA_PGUZ	/jsdb/jsdbdat_u02/jsdb/act_data_pguz_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PGYA	/jsdb/jsdbdat_u02/jsdb/act_data_pgya_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PHAE	/jsdb/jsdbdat_u02/jsdb/act_data_phae_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_DATA_PHAN	/jsdb/jsdbdat_u02/jsdb/act_data_phan_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PHAZ	/jsdb/jsdbdat_u02/jsdb/act_data_phaz_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PHEF	/jsdb/jsdbdat_u02/jsdb/act_data_phef_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PHSY	/jsdb/jsdbdat_u02/jsdb/act_data_phsy_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PJIN	/jsdb/jsdbdat_u02/jsdb/act_data_pjin_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PKUM	/jsdb/jsdbdat_u02/jsdb/act_data_pkum_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PLAZ	/jsdb/jsdbdat_u02/jsdb/act_data_plaz_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNAC	/jsdb/jsdbdat_u02/jsdb/act_data_pnac_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNAJ	/jsdb/jsdbdat_u02/jsdb/act_data_pnaj_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNAN	/jsdb/jsdbdat_u02/jsdb/act_data_pnan_01.dbf	5	4.00	1.00	2	0	0	0.00
ACT_DATA_PNEM	/jsdb/jsdbdat_u02/jsdb/act_data_pnem_01.dbf	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PNIB	/jsdb/jsdbdat_u02/jsdb/act_data_pnib_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PNIX	/jsdb/jsdbdat_u02/jsdb/act_data_pnix_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PQID	/jsdb/jsdbdat_u02/jsdb/act_data_pqid_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PQNH	/jsdb/jsdbdat_u02/jsdb/act_data_pqnh_01.dbf	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PSHH	/jsdb/jsdbdat_u02/jsdb/act_data_pshh_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PSHJ	/jsdb/jsdbdat_u02/jsdb/act_data_pshj_01.dbf	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PSHZ	/jsdb/jsdbdat_u02/jsdb/act_data_pshz_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PSUZ	/jsdb/jsdbdat_u02/jsdb/act_data_psuz_01.dbf	5	2.00	1.00	2	0	0	0.00
ACT_DATA_PTAY	/jsdb/jsdbdat_u02/jsdb/act_data_ptay_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_DATA_PTIJ	/jsdb/jsdbdat_u02/jsdb/act_data_ptij_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PWUH	/jsdb/jsdbdat_u02/jsdb/act_data_pwuh_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_DATA_PWUL	/jsdb/jsdbdat_u02/jsdb/act_data_pwul_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PWUX	/jsdb/jsdbdat_u02/jsdb/act_data_pwux_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_DATA_PXIA	/jsdb/jsdbdat_u02/jsdb/act_data_pxia_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PXIM	/jsdb/jsdbdat_u02/jsdb/act_data_pxim_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_DATA_PZHZ	/jsdb/jsdbdat_u02/jsdb/act_data_pzhz_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_GINDEX	/jsdb/jsdbidx_u01/jsdb/act_gindex_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_INDEX	/jsdb/jsdbidx_u01/jsdb/act_index_01.dbf	6	0.00	1.00	10,359	6	8	1.25
ACT_INDEX	/jsdb/jsdbidx_u01/jsdb/act_index_02.dbf	4	0.00	1.00	9,790	5	13	3.08
ACT_INDEX_PBEJ	/jsdb/jsdbidx_u02/jsdb/act_index_pbej_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHC	/jsdb/jsdbidx_u02/jsdb/act_index_pchc_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHD	/jsdb/jsdbidx_u02/jsdb/act_index_pchd_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHQ	/jsdb/jsdbidx_u02/jsdb/act_index_pchq_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PCHS	/jsdb/jsdbidx_u02/jsdb/act_index_pchs_01.dbf	7	0.00	1.00	2	0	0	0.00
ACT_INDEX_PCHZ	/jsdb/jsdbidx_u02/jsdb/act_index_pchz_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PDAL	/jsdb/jsdbidx_u02/jsdb/act_index_pdal_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PDEFAULT	/jsdb/jsdbidx_u02/jsdb/act_index_pdefault_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PFUZ	/jsdb/jsdbidx_u02/jsdb/act_index_pfuz_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PGUZ	/jsdb/jsdbidx_u02/jsdb/act_index_pguz_01.dbf	7	2.86	1.00	2	0	0	0.00
ACT_INDEX_PGYA	/jsdb/jsdbidx_u02/jsdb/act_index_pgya_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PHAE	/jsdb/jsdbidx_u02/jsdb/act_index_phae_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PHAN	/jsdb/jsdbidx_u02/jsdb/act_index_phan_01.dbf	7	1.43	1.00	2	0	0	0.00
ACT_INDEX_PHAZ	/jsdb/jsdbidx_u02/jsdb/act_index_phaz_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_INDEX_PHEF	/jsdb/jsdbidx_u02/jsdb/act_index_phef_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PHSY	/jsdb/jsdbidx_u02/jsdb/act_index_phsy_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PJIN	/jsdb/jsdbidx_u02/jsdb/act_index_pjin_01.dbf	3	6.67	1.00	2	0	0	0.00
ACT_INDEX_PKUM	/jsdb/jsdbidx_u02/jsdb/act_index_pkum_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PLAZ	/jsdb/jsdbidx_u02/jsdb/act_index_plaz_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNAC	/jsdb/jsdbidx_u02/jsdb/act_index_pnac_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNAJ	/jsdb/jsdbidx_u02/jsdb/act_index_pnaj_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNAN	/jsdb/jsdbidx_u02/jsdb/act_index_pnan_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNEM	/jsdb/jsdbidx_u02/jsdb/act_index_pnem_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_INDEX_PNIB	/jsdb/jsdbidx_u02/jsdb/act_index_pnib_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PNIX	/jsdb/jsdbidx_u02/jsdb/act_index_pnix_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PQID	/jsdb/jsdbidx_u02/jsdb/act_index_pqid_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PQNH	/jsdb/jsdbidx_u02/jsdb/act_index_pqnh_01.dbf	3	3.33	1.00	2	0	0	0.00
ACT_INDEX_PSHH	/jsdb/jsdbidx_u02/jsdb/act_index_pshh_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PSHJ	/jsdb/jsdbidx_u02/jsdb/act_index_pshj_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PSHZ	/jsdb/jsdbidx_u02/jsdb/act_index_pshz_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PSUZ	/jsdb/jsdbidx_u02/jsdb/act_index_psuz_01.dbf	3	6.67	1.00	2	0	0	0.00
ACT_INDEX_PTAY	/jsdb/jsdbidx_u02/jsdb/act_index_ptay_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PTIJ	/jsdb/jsdbidx_u02/jsdb/act_index_ptij_01.dbf	3	0.00	1.00	2	0	0	0.00
ACT_INDEX_PWUH	/jsdb/jsdbidx_u02/jsdb/act_index_pwuh_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PWUL	/jsdb/jsdbidx_u02/jsdb/act_index_pwul_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PWUX	/jsdb/jsdbidx_u02/jsdb/act_index_pwux_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PXIA	/jsdb/jsdbidx_u02/jsdb/act_index_pxia_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PXIM	/jsdb/jsdbidx_u02/jsdb/act_index_pxim_01.dbf	5	0.00	1.00	2	0	0	0.00
ACT_INDEX_PZHZ	/jsdb/jsdbidx_u02/jsdb/act_index_pzhz_01.dbf	5	0.00	1.00	2	0	0	0.00
SYSAUX	/jsdb/jsdbsys_u01/jsdb/sysaux_01.dbf	188	2.55	1.02	393	0	0	0.00
SYSTEM	/jsdb/jsdbsys_u01/jsdb/system_01.dbf	28	0.36	2.14	62	0	0	0.00
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_01.dbf	5	2.00	1.00	1,027	1	29	1.38
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_02.dbf	5	4.00	1.00	575	0	0	0.00
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_03.dbf	5	2.00	1.00	645	0	0	0.00
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_04.dbf	5	2.00	1.00	728	0	0	0.00
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_05.dbf	5	2.00	1.00	570	0	0	0.00
USERS	/jsdb/jsdbsys_u01/jsdb/users_01.dbf	3	3.33	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	3,657,192	100	9,916,467	340	267,321	0	0	1,445

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	56	41961	633716	3981219	7549740	3981219
E	0	56	44549	575047	3501460	7549740	3501460

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	2,944	0.10	364,136	1.00	7,631
D	5,888	0.20	728,272	1.00	7,620
D	8,832	0.30	1,092,408	1.00	7,620
D	11,776	0.40	1,456,544	1.00	7,620
D	14,720	0.50	1,820,680	1.00	7,620
D	17,664	0.60	2,184,816	1.00	7,620
D	20,608	0.70	2,548,952	1.00	7,620
D	23,552	0.80	2,913,088	1.00	7,620
D	26,496	0.90	3,277,224	1.00	7,620
D	29,440	1.00	3,641,360	1.00	7,620
D	29,568	1.00	3,657,192	1.00	7,620
D	32,384	1.10	4,005,496	1.00	7,620
D	35,328	1.19	4,369,632	1.00	7,620
D	38,272	1.29	4,733,768	1.00	7,620
D	41,216	1.39	5,097,904	1.00	7,620
D	44,160	1.49	5,462,040	1.00	7,620
D	47,104	1.59	5,826,176	1.00	7,620
D	50,048	1.69	6,190,312	1.00	7,620
D	52,992	1.79	6,554,448	1.00	7,620
D	55,936	1.89	6,918,584	1.00	7,620
D	58,880	1.99	7,282,720	1.00	7,620

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	47	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	6,144	5,430	273.28	0.00	0.00	0.00	0.00	629,140
E	6,144	5,424	270.69	0.00	0.00	0.00	0.00	629,140

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	492	492
64K	128K	4	4
128K	256K	12	12
512K	1024K	41	41
1M	2M	11	11

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 PGA Cache Hit %	Estd PGA Overalloc Count
768	0.13	194.98	100.00	1
1,536	0.25	194.98	100.00	1
3,072	0.50	194.98	100.00	0
4,608	0.75	194.98	100.00	0
6,144	1.00	194.98	100.00	0
7,373	1.20	194.98	100.00	0
8,602	1.40	194.98	100.00	0
9,830	1.60	194.98	100.00	0
11,059	1.80	194.98	100.00	0
12,288	2.00	194.98	100.00	0
18,432	3.00	194.98	100.00	0
24,576	4.00	194.98	100.00	0
36,864	6.00	194.98	100.00	0
49,152	8.00	194.98	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
576	0.18	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
896	0.29	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
1,216	0.39	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
1,536	0.49	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
1,856	0.59	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
2,176	0.69	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
2,496	0.80	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
2,816	0.90	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
3,136	1.00	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
3,456	1.10	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
3,776	1.20	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
4,096	1.31	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
4,416	1.41	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
4,736	1.51	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
5,056	1.61	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
5,376	1.71	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
5,696	1.82	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
6,016	1.92	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405
6,336	2.02	84	4,096	3,356,259	1.00	1,095	1.00	268,626,405

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
8,192	0.25	310,480	7,611
16,384	0.50	310,535	7,611
24,576	0.75	310,599	7,611
32,768	1.00	310,416	7,611
40,960	1.25	310,662	7,651
49,152	1.50	310,726	7,651
57,344	1.75	310,790	7,651
65,536	2.00	310,851	7,651

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)
1st level bmb	1,362	1	1
data block	33	0	2
undo header	29	0	1
2nd level bmb	12	0	3
segment header	10	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	Waits	Av Wt Time(ms)
TX-Transaction	127,027	127,014	21	4.62
HW-Segment High Water Mark	490	490	6	2.17
TX-Transaction (index contention)	1	1	1	8.00
FB-Format Block	5,721	5,721	5	1.20

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	48.72	127,627	1,535	73	2050.55/2110.83333333333333333333333333333333333	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
25-Jul 11:53	15,561	41,080	488	72	2,111	0/0	0/0/0/0/0/0
25-Jul 11:43	16,250	42,510	323	71	2,079	0/0	0/0/0/0/0/0
25-Jul 11:33	16,909	44,037	1,535	73	2,051	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	1,226	0.00		0	0
AWR Alerted Metric Element list	11,664	0.00		0	0
Consistent RBA	98,296	0.02	0.00	0	0
FAL request queue	41	0.00		0	0
FAL subheap alocation	41	0.00		0	0
FIB s.o chain latch	20	0.00		0	0
FOB s.o list latch	403	0.00		0	0
In memory undo latch	609,475	0.03	0.52	0	118,455	0.00
JS queue state obj latch	11,010	0.00		0	0
JS slv state obj latch	18	0.00		0	0
KMG MMAN ready and startup request latch	612	0.00		0	0
KTF sga latch	3	0.00		0	615	0.00
KWQMN job cache list latch	114	0.00		0	0
MQL Tracking Latch	0			0	36	0.00
Memory Management Latch	0			0	612	0.00
OS process	102	0.00		0	0
OS process allocation	680	0.00		0	0
OS process: request allocation	24	0.00		0	0
PL/SQL warning settings	282	0.00		0	0
SQL memory manager latch	1	0.00		0	609	0.00
SQL memory manager workarea list latch	41,546	0.00		0	0
Shared B-Tree	66	0.00		0	0
active checkpoint queue latch	36,174	0.12	0.00	0	0
active service list	3,432	0.00		0	613	0.00
archive control	41	0.00		0	0
archive process latch	695	0.00		0	0
begin backup scn array	40	0.00		0	0
cache buffer handles	125,326	0.10	0.00	0	0
cache buffers chains	34,360,279	0.15	0.00	1	156,915	0.00
cache buffers lru chain	534,494	0.03	0.00	0	140,125	0.03
cache table scan latch	0			0	10	0.00
channel handle pool latch	26	0.00		0	0
channel operations parent latch	10,896	0.00		0	0
checkpoint queue latch	1,057,413	0.01	0.00	0	270,848	0.00
client/application info	799	0.00		0	0
commit callback allocation	12	0.00		0	0
compile environment latch	42	0.00		0	0
dml lock allocation	241,171	0.21	0.00	0	0
dummy allocation	84	0.00		0	0
enqueue hash chains	536,258	0.08	0.01	0	417	0.00
enqueues	158,491	0.12	0.00	0	0
event group latch	12	0.00		0	0
file cache latch	413	0.00		0	0
global KZLD latch for mem in SGA	1	0.00		0	0
hash table column usage latch	132	0.00		0	5,656	0.00
hash table modification latch	8	0.00		0	0
job workq parent latch	0			0	60	0.00
job_queue_processes parameter latch	60	0.00		0	0
kks stats	59	0.00		0	0
kokc descriptor allocation latch	12	0.00		0	0
ksuosstats global area	125	0.00		0	0
ktm global data	6	0.00		0	0
kwqbsn:qsga	66	0.00		0	0
lgwr LWN SCN	98,358	0.06	0.00	0	0
library cache	388,047,047	84.54	0.00	12698	0
library cache load lock	74	0.00		0	0
library cache lock	419,924,181	37.54	0.00	1213	0
library cache lock allocation	784	0.00		0	0
library cache pin	28,012	0.16	0.00	0	0
library cache pin allocation	159	0.00		0	0
list of block allocation	89,932	0.01	0.00	0	0
loader state object freelist	216	0.00		0	0
message pool operations parent latch	8	0.00		0	0
messages	388,273	0.06	0.00	0	0
mostly latch-free SCN	98,870	0.45	0.00	0	0
multiblock read objects	34	0.00		0	0
ncodef allocation latch	29	0.00		0	0
object queue header heap	145,606	0.00		0	0
object queue header operation	1,108,311	0.02	0.00	0	0
object stats modification	7	0.00		0	0
parallel query alloc buffer	244	0.00		0	0
parameter list	3	0.00		0	0
parameter table allocation management	42	0.00		0	0
post/wait queue	163,952	0.00	0.00	0	120,866	0.07
process allocation	24	0.00		0	12	0.00
process group creation	24	0.00		0	0
qmn task queue latch	264	0.00		0	0
redo allocation	756,145	0.11	0.00	0	2,977,560	0.78
redo copy	0			0	2,984,170	0.12
redo writing	353,889	0.02	0.00	0	0
resmgr group change latch	159	0.00		0	0
resmgr:active threads	75	0.00		0	0
resmgr:actses change group	31	0.00		0	0
resmgr:free threads list	74	0.00		0	0
resmgr:schema config	1	0.00		0	0
row cache objects	45,250	0.00		0	0
rules engine aggregate statistics	3	0.00		0	0
rules engine rule set statistics	6	0.00		0	0
sequence cache	1,332	0.00		0	0
session allocation	248,902	0.22	0.00	0	0
session idle bit	2,090,148	0.00	0.00	0	0
session state list latch	84	0.00		0	0
session switching	29	0.00		0	0
session timer	614	0.00		0	0
shared pool	80,848,537	0.00	0.00	0	0
shared pool sim alloc	4	0.00		0	0
shared pool simulator	186,303,096	7.85	0.00	0	0
simulator hash latch	749,501	0.00	0.00	0	0
simulator lru latch	267,223	0.03	0.00	0	464,829	0.02
slave class	5	0.00		0	0
slave class create	20	0.00		0	0
sort extent pool	44	0.00		0	0
state object free list	2	0.00		0	0
statistics aggregation	336	0.00		0	0
threshold alerts latch	1,083	0.00		0	0
transaction allocation	115	0.00		0	0
transaction branch allocation	614	0.00		0	0
undo global data	1,089,533	0.01	0.00	0	5,200	0.04
user lock	64	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
library cache	388,047,047	328,053,586	673,122	327,382,059
library cache lock	419,924,181	157,649,768	67,825	157,582,001
shared pool simulator	186,303,096	14,618,913	364	14,618,549
cache buffers chains	34,360,279	50,839	78	50,764
redo allocation	756,145	850	1	849
enqueue hash chains	536,258	433	6	427
In memory undo latch	609,475	206	107	101

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	78	73
In memory undo latch	kticmt: child	70	32
cache buffers chains	kcbgcur: kslbegin	93	68
cache buffers chains	kcbgtcr: kslbegin excl	68	55
cache buffers chains	kcbrls: kslbegin	18	53
cache buffers chains	kcbchg: kslbegin: call CR func	3	79
cache buffers chains	kcbget: exchange rls	3	2
cache buffers chains	kcbget: pin buffer	1	0
cache buffers chains	kcbzwb	1	0
enqueue hash chains	ksqrcl	4	2
enqueue hash chains	ksqgtl3	2	4
library cache	kglLockCursor	315,490	361,042
library cache	kglhdgn: child:	1,207	903
library cache	kglobpn: child:	3	0
library cache	kglic	2	0
library cache	kglpin	2	0
library cache	kgldti: 2child	1	0
library cache	kglpndl: child: before processing	1	0
library cache lock	kgllkdl: child: no lock handle	356,387	311,163
library cache lock	kgllkdl: child: cleanup	34,050	34,866
library cache lock	kgllkal: child: multiinstance	33,766	32,951
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
shared pool simulator	kglsim_unpin_simhp: fast path	233	287
shared pool simulator	kglsim_unpin_simhp	131	77

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: 9,917,772
Captured Segments account for 90.5% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
ACT	ACT_INDEX	IDX_TBL_CTJS_01	INDEX	4,492,608	45.30
ACT	ACT_DATA	TBL_CTJS	TABLE	4,453,328	44.90
SYS	SYSTEM	SYS_C00648	INDEX	2,416	0.02
SYS	SYSTEM	TAB$	TABLE	2,160	0.02
SYS	SYSTEM	SMON_SCN_TIME	TABLE	1,520	0.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 714
Captured Segments account for 23.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	449946_189	TABLE PARTITION	67	9.38
SYS	SYSAUX	WRH$_SQL_PLAN		TABLE	27	3.78
SYS	SYSAUX	WRH$_SQL_PLAN_PK		INDEX	16	2.24
SYS	SYSAUX	WRH$_SQLTEXT		TABLE	8	1.12
SYS	SYSAUX	WRH$_SESSMETRIC_HISTORY_INDEX		INDEX	7	0.98

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
ACT	ACT_INDEX	IDX_TBL_CTJS_01		INDEX	1	100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
ACT	ACT_DATA	TBL_CTJS		TABLE	1,396	98.52
ACT	ACT_INDEX	IDX_TBL_CTJS_01		INDEX	21	1.48

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	48	0.00	2	1
dc_database_links	3	0.00	0	1
dc_files	103	100.00	0	103
dc_global_oids	2,383	0.00	0	43
dc_histogram_data	137	0.00	0	1,376
dc_histogram_defs	233	12.02	0	3,570
dc_object_ids	2,939	0.37	0	680
dc_objects	346	6.36	0	1,005
dc_profiles	31	0.00	0	1
dc_rollback_segments	1,468	0.00	0	131
dc_segments	115	4.35	33	778
dc_sequences	21	0.00	21	7
dc_tablespace_quotas	20	0.00	0	2
dc_tablespaces	2,179	0.00	0	89
dc_usernames	101	0.00	0	17
dc_users	4,555	0.00	0	39
outstanding_alerts	525	0.57	3	176

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss
BODY	341	0.00	2,902	0.00
CLUSTER	6	0.00	10	0.00
INDEX	6	0.00	60	0.00
SQL AREA	442,925	0.00	209,928,880	0.09
TABLE/PROCEDURE	150	6.00	6,205	0.60
TRIGGER	10	0.00	106	0.00

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	204.34		1.76	3.33	22	34	116	116
	Freeable	63.63	0.00	0.77	1.95	12		83	83
	SQL	4.65	2.75	0.05	0.10	1	3	101	97
	PL/SQL	0.64	0.33	0.01	0.01	0	0	116	116
E	Other	203.25		1.75	3.33	22	34	116	116
	Freeable	62.19	0.00	0.73	1.94	12		85	85
	SQL	4.63	2.68	0.05	0.11	1	4	101	98
	PL/SQL	0.66	0.34	0.01	0.01	0	0	116	116

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	31,004,295,168
Fixed Size	2,147,144
Redo Buffers	48,181,248
Variable Size	3,305,114,808

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	68.00	68.00	0.00
shared	Checkpoint queue	125.02	125.02	0.00
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	free memory	2,508.92	2,504.95	-0.16
shared	sql area	57.07	60.33	5.71
	buffer_cache	29,568.00	29,568.00	0.00
	fixed_sga	2.05	2.05	0.00
	log_buffer	45.95	45.95	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)
audit_file_dest	/u01/oracle/admin/jsdb/adump
background_dump_dest	/u01/oracle/admin/jsdb/bdump
compatible	10.2.0.3.0
control_files	/jsdb/jsdbsys_u01/jsdb/control01.ctl, /jsdb/jsdbrdo_u01/jsdb/control02.ctl, /jsdb/jsdbudo_u01/jsdb/control03.ctl
core_dump_dest	/u01/oracle/admin/jsdb/cdump
cursor_sharing	EXACT
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_files	4000
db_flashback_retention_target	4320
db_name	jsdb
db_recovery_file_dest	/jsdb/jsdbdbarc/jsdb
db_recovery_file_dest_size	187904819200
event	10503 trace name context forever, level 4000
job_queue_processes	10
log_archive_dest_1	LOCATION=/jsdb/jsdbdbarc/jsdb
log_archive_format	%t_%s_%r.arc
open_cursors	300
pga_aggregate_target	6442450944
processes	1000
remote_login_passwordfile	EXCLUSIVE
session_cached_cursors	150
sessions	1105
sga_max_size	34359738368
sga_target	34359738368
shared_pool_size	3221225472
timed_statistics	TRUE
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/oracle/admin/jsdb/udump

End of Report

% Blocks changed per Read:	58.55	Recursive Call %:	12.89
Rollback per transaction %:	0.00	Rows per Sort:	277.78

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.91	Soft Parse %:	100.00
Execute to Parse %:	0.53	Latch Hit %:	55.35
Parse CPU to Parse Elapsd %:	3.34	% Non-Parse CPU:	99.95