WARNING: timed_statistics setting was set to 'FALSE' in the snapshot period: TIMINGS ARE INVALID

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: 170 24-Jul-12 11:21:45 48 3.4

End Snap: 173 24-Jul-12 13:05:10 38 4.1

Elapsed: 103.41 (mins)

DB Time: 4,903.54 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	170	24-Jul-12 11:21:45	48	3.4
End Snap:	173	24-Jul-12 13:05:10	38	4.1
Elapsed:		103.41 (mins)
DB Time:		4,903.54 (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: 1,210,308.14 169,264.13

Logical reads: 7,179.30 1,004.04

Block changes: 4,072.47 569.54

Physical reads: 0.50 0.07

Physical writes: 156.66 21.91

User calls: 723.11 101.13

Parses: 694.32 97.10

Hard parses: 0.04 0.01

Sorts: 0.65 0.09

Logons: 0.04 0.01

Executes: 697.05 97.48

Transactions: 7.15

	Per Second	Per Transaction
Redo size:	1,210,308.14	169,264.13
Logical reads:	7,179.30	1,004.04
Block changes:	4,072.47	569.54
Physical reads:	0.50	0.07
Physical writes:	156.66	21.91
User calls:	723.11	101.13
Parses:	694.32	97.10
Hard parses:	0.04	0.01
Sorts:	0.65	0.09
Logons:	0.04	0.01
Executes:	697.05	97.48
Transactions:	7.15

% Blocks changed per Read: 56.73 Recursive Call %: 3.12

Rollback per transaction %: 0.00 Rows per Sort: 217.88

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.98 Redo NoWait %: 100.00

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

Library Hit %: 99.78 Soft Parse %: 99.99

Execute to Parse %: 0.39 Latch Hit %: 57.32

Parse CPU to Parse Elapsd %: % Non-Parse CPU: 100.00

Shared Pool Statistics

Begin End

Memory Usage %: 65.54 64.44

% SQL with executions>1: 99.57 99.44

% Memory for SQL w/exec>1: 99.67 99.49

	Begin	End
Memory Usage %:	65.54	64.44
% SQL with executions>1:	99.57	99.44
% Memory for SQL w/exec>1:	99.67	99.49

Top 5 Timed Events

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

CPU time 601 .2

latch: library cache 703,527 31 0 .0 Concurrency

cursor: pin S wait on X 2,449 10 4 .0 Concurrency

latch: library cache lock 42,916 6 0 .0 Concurrency

latch free 77 0 6 .0 Other

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		601		.2
latch: library cache	703,527	31	0	.0	Concurrency
cursor: pin S wait on X	2,449	10	4	.0	Concurrency
latch: library cache lock	42,916	6	0	.0	Concurrency
latch free	77	0	6	.0	Other

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): 294212.6s
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	292,090.05	99.28
parse time elapsed	790.93	0.27
DB CPU	600.92	0.20
PL/SQL execution elapsed time	4.18	0.00
hard parse elapsed time	2.08	0.00
hard parse (sharing criteria) elapsed time	1.47	0.00
hard parse (bind mismatch) elapsed time	1.47	0.00
connection management call elapsed time	0.25	0.00
sequence load elapsed time	0.03	0.00
failed parse elapsed time	0.02	0.00
repeated bind elapsed time	0.00	0.00
DB time	294,212.63
background elapsed time	13,234.98
background cpu time	0.26

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)	Waits /txn
Concurrency	757,055	0.13	48	17.06
Other	3,895	0.67	0	0.09
Network	10,395,619	0.00	0	234.31
System I/O	224,288	0.00	0	5.06
Commit	74,228	0.00	0	1.67
User I/O	3,646	0.00	0	0.08
Configuration	1,199	0.00	0	0.03
Application	420	0.00	0	0.01

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	703,527	0.00	31	0	15.86
cursor: pin S wait on X	2,449	41.53	10	4	0.06
latch: library cache lock	42,916	0.00	6	0	0.97
latch free	77	0.00	0	6	0.00
latch: cache buffers chains	953	0.00	0	0	0.02
wait list latch free	1	0.00	0	10	0.00
latch: shared pool	3	0.00	0	3	0.00
latch: In memory undo latch	40	0.00	0	0	0.00
latch: object queue header operation	2	0.00	0	0	0.00
latch: checkpoint queue latch	1	0.00	0	0	0.00
SQL*Net more data from client	5,997,049	0.00	0	0	135.17
SQL*Net message to client	4,398,487	0.00	0	0	99.14
db file parallel write	114,916	0.00	0	0	2.59
log file sync	74,228	0.00	0	0	1.67
log file parallel write	45,947	0.00	0	0	1.04
control file sequential read	43,731	0.00	0	0	0.99
Log archive I/O	8,529	0.00	0	0	0.19
log file sequential read	7,904	0.00	0	0	0.18
buffer busy waits	7,075	0.00	0	0	0.16
control file parallel write	3,229	0.00	0	0	0.07
cursor: pin S	2,124	0.00	0	0	0.05
direct path read	1,536	0.00	0	0	0.03
db file sequential read	1,181	0.00	0	0	0.03
LGWR wait for redo copy	896	0.00	0	0	0.02
direct path write	855	0.00	0	0	0.02
enq: HW - contention	845	0.00	0	0	0.02
enq: TX - contention	590	0.00	0	0	0.01
SQL*Net break/reset to client	420	0.00	0	0	0.01
log file switch completion	353	0.00	0	0	0.01
enq: FB - contention	162	0.00	0	0	0.00
SQL*Net more data to client	83	0.00	0	0	0.00
db file scattered read	74	0.00	0	0	0.00
os thread startup	70	0.00	0	0	0.00
log file single write	32	0.00	0	0	0.00
buffer deadlock	26	100.00	0	0	0.00
enq: TX - index contention	22	0.00	0	0	0.00
rdbms ipc reply	16	0.00	0	0	0.00
enq: TX - allocate ITL entry	1	0.00	0	0	0.00
Streams AQ: waiting for time management or cleanup tasks	150	66.67	9,689	64593	0.00
Streams AQ: qmn coordinator idle wait	444	50.00	6,215	13998	0.01
Streams AQ: waiting for messages in the queue	1,242	100.00	6,205	4996	0.03
wait for unread message on broadcast channel	6,202	100.00	6,202	1000	0.14
jobq slave wait	2,067	97.58	6,051	2927	0.05
SQL*Net message from client	4,398,497	0.00	0	0	99.14
Streams AQ: qmn slave idle wait	222	0.00	0	0	0.01
class slave wait	15	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
events in waitclass Other	901	0.00	0	0	0.02
latch: cache buffers chains	2	0.00	0	0	0.00
db file parallel write	114,916	0.00	0	0	2.59
log file parallel write	45,947	0.00	0	0	1.04
Log archive I/O	8,529	0.00	0	0	0.19
log file sequential read	7,904	0.00	0	0	0.18
control file sequential read	6,675	0.00	0	0	0.15
control file parallel write	3,229	0.00	0	0	0.07
direct path read	1,536	0.00	0	0	0.03
direct path write	824	0.00	0	0	0.02
db file scattered read	73	0.00	0	0	0.00
os thread startup	70	0.00	0	0	0.00
db file sequential read	45	0.00	0	0	0.00
log file single write	32	0.00	0	0	0.00
rdbms ipc message	81,870	41.88	105,194	1285	1.85
Streams AQ: waiting for time management or cleanup tasks	150	66.67	9,689	64593	0.00
pmon timer	2,080	100.00	6,240	3000	0.05
Streams AQ: qmn coordinator idle wait	444	50.00	6,215	13998	0.01
smon timer	21	95.24	6,000	285714	0.00
Streams AQ: qmn slave idle wait	222	0.00	0	0	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
NUM_LCPUS	0
NUM_VCPUS	0
AVG_BUSY_TIME	476,206
AVG_IDLE_TIME	143,853
AVG_IOWAIT_TIME	73
AVG_SYS_TIME	3,481
AVG_USER_TIME	472,521
BUSY_TIME	30,490,514
IDLE_TIME	9,219,543
IOWAIT_TIME	21,912
SYS_TIME	235,407
USER_TIME	30,255,107
LOAD	0
OS_CPU_WAIT_TIME	28,779,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	294,182.90	594.90	249	43,198,921
jsdb	29.90	6.20	0	1,311,959
SYS$BACKGROUND	0.00	0.00	2,851	39,860

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	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
SYS$USERS	351	756978	4772	10386438
jsdb	0	5	0	8879
SYS$BACKGROUND	3295	72	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
292,687	1,183			99.48	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
22	0	12	1.80	0.01	dh0fp8p0zgk9d	PL/SQL Developer	select count(*) from tbl_ctjs
7	0	3	2.40	0.00	84qubbrsr0kfn		insert into wrh$_latch (snap...
5	0	3	1.79	0.00	bunssq950snhf		insert into wrh$_sga_target_ad...
4	4	3,714	0.00	0.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
4	4	43,073	0.00	0.00	bunvx480ynf57		SELECT 1 FROM DUAL
3	0	104	0.03	0.00	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
3	0	1	2.71	0.00	bc7gjv3ppdtbz	sqlplus@SXHSDB2 (TNS V1-V3)	BEGIN dbms_workload_repository...
2	0	15	0.15	0.00	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
2	0	1	1.57	0.00	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...

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
1,183	292,687			99.48	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
4	4	3,714	0.00	0.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
4	4	43,073	0.00	0.00	bunvx480ynf57		SELECT 1 FROM DUAL
1	1	207	0.00	0.00	aykvshm7zsabd		select size_for_estimate, ...
1	1	3,714	0.00	0.00	6gh8gj9n09vr7	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
1	1	3,818	0.00	0.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
1	1	645	0.00	0.00	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
0	0	1,238	0.00	0.00	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
0	1	86	0.00	0.00	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
0	0	1,134	0.00	0.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...

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: 44,545,253
Captured SQL account for 3.0% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,246,186	12	103,848.83	2.80	0.00	21.66	dh0fp8p0zgk9d	PL/SQL Developer	select count(*) from tbl_ctjs
36,286	1	36,286.00	0.08	0.00	1.57	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
23,211	104	223.18	0.05	0.19	3.22	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
14,856	3,714	4.00	0.03	4.47	4.47	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
8,113	86	94.34	0.02	0.30	1.04	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
7,361	486	15.15	0.02	0.11	0.11	bsa0wjtftg3uw		select file# from file$ where ...
6,059	645	9.39	0.01	0.58	0.65	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
5,768	206	28.00	0.01	0.12	0.12	2b064ybzkwf1y	OEM.SystemPool	BEGIN EMD_NOTIFICATION.QUEUE_R...
5,293	15	352.87	0.01	0.01	2.31	c2aw4fq306q4k		INSERT /+ APPEND / INTO WRH$...
4,922	2	2,461.00	0.01	0.00	0.79	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 3,100
Captured SQL account for 57.1% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Text
690	1	690.00	22.26	0.00	0.06	cfz686a6qp0kg	select o.obj#, u.name, o.nam...
581	2	290.50	18.74	0.01	0.41	0dwr2vd6vbqzs	SELECT count(*) over () as tot...
581	2	290.50	18.74	0.00	0.79	d92h3rjp0y217	begin prvt_hdm.auto_execute( :...
242	104	2.33	7.81	0.19	3.22	6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := ...
240	86	2.79	7.74	0.30	1.04	abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_...
237	1	237.00	7.65	0.00	0.53	89qyn4bbt03jq	SELECT /+ USE_HASH(f a) / SU...
5	645	0.01	0.16	0.58	0.65	cnf7gzg73rn5w	insert into tbl_ctjs_check (co...
4	10	0.40	0.13	0.00	0.00	cqgv56fmuj63x	select owner#, name, namespace...
3	26	0.12	0.10	0.00	0.00	04xtrk7uyhknh	select obj#, type#, ctime, mti...
3	18	0.17	0.10	0.01	0.01	83taa7kaw59c1	select name, intcol#, segcol#,...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 4,324,966
Captured SQL account for 1.5% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
43,073	43,074	1.00	bunvx480ynf57		SELECT 1 FROM DUAL
3,818	3,818	1.00	089dbukv1aanh	EM_PING	SELECT SYS_EXTRACT_UTC(SYSTIME...
3,714	0	0.00	6gh8gj9n09vr7	OEM.SystemPool	SELECT JOB_ID, EXECUTION_ID, ...
3,714	3,714	1.00	cb75rw3w1tt0s	OEM.SystemPool	begin MGMT_JOB_ENGINE.get_sche...
1,238	104	0.08	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
1,134	1,134	1.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
748	748	1.00	dbjvf9ak4ta94		select tbl_ctjs_check_seq.next...
645	748	1.16	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
486	3,543	7.29	bsa0wjtftg3uw		select file# from file$ where ...
348	348	1.00	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 4,308,060
Captured SQL account for 1.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
4,253,243		98.73	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
43,073	43,073	1.00	bunvx480ynf57		SELECT 1 FROM DUAL
748	748	0.02	dbjvf9ak4ta94		select tbl_ctjs_check_seq.next...
645	645	0.01	cnf7gzg73rn5w		insert into tbl_ctjs_check (co...
486	486	0.01	bsa0wjtftg3uw		select file# from file$ where ...
348	348	0.01	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...
294	294	0.01	0h6b2sajwb74n		select privilege#, level from ...
245	245	0.01	cf06fwacdmgfk	PL/SQL Developer	select 'x' from dual
208	208	0.00	24dkx03u3rj6k		SELECT COUNT(*) FROM MGMT_PARA...
206	206	0.00	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
40,928,496		1.25	4hbfsfnnydqnh		INSERT INTO tbl_ctjs (gsdm, xz...
1,272,989	645	0.04	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
283		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

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

24dkx03u3rj6k SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'

2b064ybzkwf1y BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); 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

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#

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

9qgtwh66xg6nz update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3

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

aykvshm7zsabd select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'

bc7gjv3ppdtbz BEGIN dbms_workload_repository.create_snapshot(); END;

bd502nbh9abbs select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

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

cfz686a6qp0kg select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#

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 )

cqgv56fmuj63x select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

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

dbjvf9ak4ta94 select tbl_ctjs_check_seq.nextval from dual

dh0fp8p0zgk9d select count(*) from tbl_ctjs

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

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
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
24dkx03u3rj6k	SELECT COUNT(*) FROM MGMT_PARAMETERS WHERE PARAMETER_NAME=:B1 AND UPPER(PARAMETER_VALUE)='TRUE'
2b064ybzkwf1y	BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); 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
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#
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
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
aykvshm7zsabd	select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3'
bc7gjv3ppdtbz	BEGIN dbms_workload_repository.create_snapshot(); END;
bd502nbh9abbs	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
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
cfz686a6qp0kg	select o.obj#, u.name, o.name, t.spare1, DECODE(bitand(t.flags, 268435456), 268435456, t.initrans, t.pctfree$) from sys.obj$ o, sys.user$ u, sys.tab$ t where (bitand(t.trigflag, 1048576) = 1048576) and o.obj#=t.obj# and o.owner# = u.user#
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 )
cqgv56fmuj63x	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dbjvf9ak4ta94	select tbl_ctjs_check_seq.nextval from dual
dh0fp8p0zgk9d	select count(*) from tbl_ctjs
g2wr3u7s1gtf3	select count(*) from sys.job$ where (next_date > sysdate) and (next_date < (sysdate+5/86400))

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
CR blocks created	3,376	0.54	0.08
Cached Commit SCN referenced	1,096	0.18	0.02
Commit SCN cached	14	0.00	0.00
DBWR checkpoint buffers written	970,567	156.43	21.88
DBWR checkpoints	8	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	2,605	0.42	0.06
DBWR undo block writes	210,077	33.86	4.74
IMU CR rollbacks	62	0.01	0.00
IMU Flushes	44,006	7.09	0.99
IMU Redo allocation size	377,359,536	60,818.55	8,505.60
IMU commits	1,168	0.19	0.03
IMU contention	7,991	1.29	0.18
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	749	0.12	0.02
IMU recursive-transaction flush	67	0.01	0.00
IMU undo allocation size	91,388,576	14,728.98	2,059.88
IMU- failed to get a private strand	749	0.12	0.02
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	4,397,985	708.82	99.13
active txn count during cleanout	1,780,340	286.94	40.13
background checkpoints completed	8	0.00	0.00
background checkpoints started	8	0.00	0.00
background timeouts	34,422	5.55	0.78
branch node splits	159	0.03	0.00
buffer is not pinned count	71,042	11.45	1.60
buffer is pinned count	98,010	15.80	2.21
bytes received via SQL*Net from client	18,143,665,477	2,924,191.31	408,954.28
bytes sent via SQL*Net to client	233,802,652	37,681.67	5,269.86
calls to get snapshot scn: kcmgss	4,666,515	752.10	105.18
calls to kcmgas	330,671	53.29	7.45
calls to kcmgcs	386,201	62.24	8.70
cleanout - number of ktugct calls	928,676	149.67	20.93
cleanouts and rollbacks - consistent read gets	1,278	0.21	0.03
cleanouts only - consistent read gets	36	0.01	0.00
cluster key scan block gets	9,715	1.57	0.22
cluster key scans	2,064	0.33	0.05
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	47	0.01	0.00
commit batch/immediate requested	47	0.01	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	51	0.01	0.00
commit cleanout failures: callback failure	15,885	2.56	0.36
commit cleanout failures: cannot pin	697	0.11	0.02
commit cleanouts	5,783,069	932.05	130.35
commit cleanouts successfully completed	5,766,436	929.37	129.97
commit immediate performed	47	0.01	0.00
commit immediate requested	47	0.01	0.00
commit txn count during cleanout	178,451	28.76	4.02
concurrency wait time	4,772	0.77	0.11
consistent changes	25,978	4.19	0.59
consistent gets	7,817,502	1,259.94	176.20
consistent gets - examination	2,005,782	323.27	45.21
consistent gets from cache	7,817,502	1,259.94	176.20
cursor authentications	1,738	0.28	0.04
data blocks consistent reads - undo records applied	25,700	4.14	0.58
db block changes	25,268,350	4,072.47	569.54
db block gets	36,727,751	5,919.36	827.84
db block gets direct	614	0.10	0.01
db block gets from cache	36,727,137	5,919.27	827.82
deferred (CURRENT) block cleanout applications	828,065	133.46	18.66
enqueue conversions	3,333	0.54	0.08
enqueue releases	223,489	36.02	5.04
enqueue requests	223,506	36.02	5.04
enqueue timeouts	21	0.00	0.00
enqueue waits	1,250	0.20	0.03
exchange deadlocks	26	0.00	0.00
execute count	4,324,966	697.05	97.48
free buffer inspected	19	0.00	0.00
free buffer requested	656,410	105.79	14.80
heap block compress	47	0.01	0.00
immediate (CR) block cleanout applications	1,314	0.21	0.03
immediate (CURRENT) block cleanout applications	132,311	21.32	2.98
index crx upgrade (positioned)	17,394	2.80	0.39
index fast full scans (full)	6	0.00	0.00
index fetch by key	15,926	2.57	0.36
index scans kdiixs1	34,892	5.62	0.79
leaf node 90-10 splits	149	0.02	0.00
leaf node splits	43,104	6.95	0.97
lob reads	0	0.00	0.00
lob writes	15	0.00	0.00
lob writes unaligned	15	0.00	0.00
logons cumulative	261	0.04	0.01
messages received	162,621	26.21	3.67
messages sent	162,621	26.21	3.67
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,289,380	207.81	29.06
opened cursors cumulative	95,360	15.37	2.15
parse count (failures)	3	0.00	0.00
parse count (hard)	260	0.04	0.01
parse count (total)	4,308,060	694.32	97.10
physical read IO requests	2,482	0.40	0.06
physical read bytes	25,395,200	4,092.91	572.40
physical read total IO requests	54,425	8.77	1.23
physical read total bytes	8,955,580,928	1,443,359.50	201,856.85
physical read total multi block requests	7,910	1.27	0.18
physical reads	3,100	0.50	0.07
physical reads cache	1,564	0.25	0.04
physical reads cache prefetch	618	0.10	0.01
physical reads direct	1,536	0.25	0.03
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	4	0.00	0.00
physical write IO requests	115,786	18.66	2.61
physical write bytes	7,962,664,960	1,283,332.50	179,476.74
physical write total IO requests	311,440	50.19	7.02
physical write total bytes	31,895,309,824	5,140,526.20	718,913.35
physical write total multi block requests	280,372	45.19	6.32
physical writes	972,005	156.66	21.91
physical writes direct	1,438	0.23	0.03
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	970,567	156.43	21.88
physical writes non checkpoint	625,119	100.75	14.09
pinned buffers inspected	0	0.00	0.00
recursive calls	144,676	23.32	3.26
redo blocks written	15,198,065	2,449.45	342.56
redo buffer allocation retries	179	0.03	0.00
redo entries	13,579,161	2,188.54	306.07
redo log space requests	353	0.06	0.01
redo ordering marks	238,359	38.42	5.37
redo size	7,509,572,296	1,210,308.14	169,264.13
redo subscn max counts	650,680	104.87	14.67
redo synch writes	43,983	7.09	0.99
redo wastage	21,702,068	3,497.69	489.16
redo writes	45,947	7.41	1.04
rollback changes - undo records applied	4,644	0.75	0.10
rollbacks only - consistent read gets	1,704	0.27	0.04
rows fetched via callback	8,012	1.29	0.18
session cursor cache hits	2,594,468	418.15	58.48
session logical reads	44,545,253	7,179.30	1,004.04
session pga memory	177,869,872	28,667.06	4,009.15
session pga memory max	217,912,368	35,120.66	4,911.70
session uga memory	###############	71,990,997.34	10,068,091.72
session uga memory max	196,996,664	31,749.70	4,440.26
shared hash latch upgrades - no wait	17,824	2.87	0.40
sorts (memory)	4,027	0.65	0.09
sorts (rows)	877,408	141.41	19.78
sql area evicted	1,121	0.18	0.03
sql area purged	3	0.00	0.00
switch current to new buffer	163	0.03	0.00
table fetch by rowid	61,592	9.93	1.39
table fetch continued row	6	0.00	0.00
table scan blocks gotten	1,232,096	198.58	27.77
table scan rows gotten	27,109,969	4,369.28	611.05
table scans (long tables)	3	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	2,471	0.40	0.06
total number of times SMON posted	1	0.00	0.00
transaction rollbacks	47	0.01	0.00
undo change vector size	1,465,318,412	236,163.49	33,027.96
user calls	4,486,687	723.11	101.13
user commits	44,366	7.15	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	2,171	0.35	0.05
write clones created in background	1	0.00	0.00
write clones created in foreground	98	0.02	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	24,656	27,443
opened cursors current	164	154
logons current	48	38

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

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 Blks/Rd	Writes	Av Writes/s	Buffer Waits
ACT_INDEX	49	1.08	68,331	11	258
ACT_DATA	360	1.00	29,450	5	6,617
UNDOTBS1	55	1.00	16,332	3	199
SYSAUX	601	1.01	827	0	0
SYSTEM	208	3.93	204	0	0
ACT_INDEX_PWUL	26	1.00	8	0	0
ACT_INDEX_PXIA	26	1.00	8	0	0
ACT_INDEX_PXIM	26	1.00	8	0	0
ACT_INDEX_PZHZ	26	1.00	8	0	0
ACT_GINDEX	25	1.00	8	0	0
ACT_INDEX_PWUH	25	1.00	8	0	0
ACT_INDEX_PWUX	25	1.00	8	0	0
ACT_DATA_PHEF	18	1.00	8	0	0
ACT_DATA_PHSY	18	1.00	8	0	0
ACT_DATA_PJIN	18	1.00	8	0	0
ACT_DATA_PKUM	18	1.00	8	0	0
ACT_DATA_PLAZ	18	1.00	8	0	0
ACT_DATA_PNAC	18	1.00	8	0	0
ACT_DATA_PNAJ	18	1.00	8	0	0
ACT_DATA_PNAN	18	1.00	8	0	0
ACT_DATA_PNEM	18	1.00	8	0	0
ACT_DATA_PNIB	18	1.00	8	0	0
ACT_DATA_PNIX	18	1.00	8	0	0
ACT_DATA_PQID	18	1.00	8	0	0
ACT_DATA_PQNH	18	1.00	8	0	0
ACT_DATA_PSHH	18	1.00	8	0	0
ACT_DATA_PTAY	18	1.00	8	0	0
ACT_INDEX_PHSY	18	1.00	8	0	0
ACT_INDEX_PJIN	18	1.00	8	0	0
ACT_INDEX_PKUM	18	1.00	8	0	0
ACT_INDEX_PLAZ	18	1.00	8	0	0
ACT_INDEX_PNAJ	18	1.00	8	0	0
ACT_INDEX_PNAN	18	1.00	8	0	0
ACT_INDEX_PNEM	18	1.00	8	0	0
ACT_INDEX_PSUZ	18	1.00	8	0	0
ACT_INDEX_PTAY	18	1.00	8	0	0
ACT_INDEX_PTIJ	18	1.00	8	0	0
ACT_DATA_PHAN	17	1.00	8	0	0
ACT_DATA_PHAZ	17	1.00	8	0	0
ACT_DATA_PSHZ	17	1.00	8	0	0
ACT_DATA_PSUZ	17	1.00	8	0	0
ACT_INDEX_PHAZ	17	1.00	8	0	0
ACT_INDEX_PHEF	17	1.00	8	0	0
ACT_INDEX_PNAC	17	1.00	8	0	0
ACT_INDEX_PNIB	17	1.00	8	0	0
ACT_INDEX_PNIX	17	1.00	8	0	0
ACT_INDEX_PQID	17	1.00	8	0	0
ACT_INDEX_PQNH	17	1.00	8	0	0
ACT_INDEX_PSHH	17	1.00	8	0	0
ACT_INDEX_PSHJ	17	1.00	8	0	0
ACT_INDEX_PSHZ	17	1.00	8	0	0
ACT_DATA_PSHJ	16	1.00	8	0	0
ACT_DATA_PBEJ	11	1.00	8	0	0
ACT_DATA_PCHC	10	1.00	8	0	0
ACT_DATA_PCHD	10	1.00	8	0	0
ACT_DATA_PCHQ	10	1.00	8	0	0
ACT_DATA_PCHS	10	1.00	8	0	0
ACT_DATA_PCHZ	10	1.00	8	0	0
ACT_DATA_PDAL	10	1.00	8	0	0
ACT_DATA_PGUZ	10	1.00	8	0	0
ACT_DATA_PGYA	10	1.00	8	0	0
ACT_DATA_PHAE	10	1.00	8	0	0
ACT_DATA_PTIJ	10	1.00	8	0	0
ACT_DATA_PWUH	10	1.00	8	0	0
ACT_DATA_PWUL	10	1.00	8	0	0
ACT_DATA_PWUX	10	1.00	8	0	0
ACT_DATA_PXIA	10	1.00	8	0	0
ACT_DATA_PXIM	10	1.00	8	0	0
ACT_DATA_PZHZ	10	1.00	8	0	0
ACT_INDEX_PBEJ	10	1.00	8	0	0
ACT_INDEX_PCHC	10	1.00	8	0	0
ACT_INDEX_PCHD	10	1.00	8	0	0
ACT_INDEX_PCHS	10	1.00	8	0	0
ACT_INDEX_PCHZ	10	1.00	8	0	0
ACT_INDEX_PDAL	10	1.00	8	0	0
ACT_INDEX_PDEFAULT	10	1.00	8	0	0
ACT_INDEX_PFUZ	10	1.00	8	0	0
ACT_INDEX_PGUZ	10	1.00	8	0	0
ACT_INDEX_PGYA	10	1.00	8	0	0
ACT_INDEX_PHAE	10	1.00	8	0	0
ACT_DATA_PDEFAULT	9	1.00	8	0	0
ACT_DATA_PFUZ	9	1.00	8	0	0
ACT_INDEX_PCHQ	9	1.00	8	0	0
ACT_INDEX_PHAN	9	1.00	8	0	0
USERS	9	1.00	8	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_01.dbf	24	1.00	2,087	0	1,483
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_02.dbf	24	1.00	2,107	0	289
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_03.dbf	24	1.00	2,103	0	364
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_04.dbf	24	1.00	2,069	0	283
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_05.dbf	24	1.00	2,636	0	533
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_06.dbf	24	1.00	2,204	0	640
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_07.dbf	24	1.00	1,960	0	526
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_08.dbf	24	1.00	1,957	0	553
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_09.dbf	24	1.00	2,055	0	310
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_10.dbf	24	1.00	1,979	0	297
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_11.dbf	24	1.00	2,033	0	455
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_12.dbf	32	1.00	2,056	0	281
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_13.dbf	32	1.00	2,104	0	282
ACT_DATA	/jsdb/jsdbdat_u01/jsdb/act_data_14.dbf	32	1.00	2,100	0	321
ACT_DATA_PBEJ	/jsdb/jsdbdat_u02/jsdb/act_data_pbej_01.dbf	11	1.00	8	0	0
ACT_DATA_PCHC	/jsdb/jsdbdat_u02/jsdb/act_data_pchc_01.dbf	10	1.00	8	0	0
ACT_DATA_PCHD	/jsdb/jsdbdat_u02/jsdb/act_data_pchd_01.dbf	10	1.00	8	0	0
ACT_DATA_PCHQ	/jsdb/jsdbdat_u02/jsdb/act_data_pchq_01.dbf	10	1.00	8	0	0
ACT_DATA_PCHS	/jsdb/jsdbdat_u02/jsdb/act_data_pchs_01.dbf	10	1.00	8	0	0
ACT_DATA_PCHZ	/jsdb/jsdbdat_u02/jsdb/act_data_pchz_01.dbf	10	1.00	8	0	0
ACT_DATA_PDAL	/jsdb/jsdbdat_u02/jsdb/act_data_pdal_01.dbf	10	1.00	8	0	0
ACT_DATA_PDEFAULT	/jsdb/jsdbdat_u02/jsdb/act_data_pdefault_01.dbf	9	1.00	8	0	0
ACT_DATA_PFUZ	/jsdb/jsdbdat_u02/jsdb/act_data_pfuz_01.dbf	9	1.00	8	0	0
ACT_DATA_PGUZ	/jsdb/jsdbdat_u02/jsdb/act_data_pguz_01.dbf	10	1.00	8	0	0
ACT_DATA_PGYA	/jsdb/jsdbdat_u02/jsdb/act_data_pgya_01.dbf	10	1.00	8	0	0
ACT_DATA_PHAE	/jsdb/jsdbdat_u02/jsdb/act_data_phae_01.dbf	10	1.00	8	0	0
ACT_DATA_PHAN	/jsdb/jsdbdat_u02/jsdb/act_data_phan_01.dbf	17	1.00	8	0	0
ACT_DATA_PHAZ	/jsdb/jsdbdat_u02/jsdb/act_data_phaz_01.dbf	17	1.00	8	0	0
ACT_DATA_PHEF	/jsdb/jsdbdat_u02/jsdb/act_data_phef_01.dbf	18	1.00	8	0	0
ACT_DATA_PHSY	/jsdb/jsdbdat_u02/jsdb/act_data_phsy_01.dbf	18	1.00	8	0	0
ACT_DATA_PJIN	/jsdb/jsdbdat_u02/jsdb/act_data_pjin_01.dbf	18	1.00	8	0	0
ACT_DATA_PKUM	/jsdb/jsdbdat_u02/jsdb/act_data_pkum_01.dbf	18	1.00	8	0	0
ACT_DATA_PLAZ	/jsdb/jsdbdat_u02/jsdb/act_data_plaz_01.dbf	18	1.00	8	0	0
ACT_DATA_PNAC	/jsdb/jsdbdat_u02/jsdb/act_data_pnac_01.dbf	18	1.00	8	0	0
ACT_DATA_PNAJ	/jsdb/jsdbdat_u02/jsdb/act_data_pnaj_01.dbf	18	1.00	8	0	0
ACT_DATA_PNAN	/jsdb/jsdbdat_u02/jsdb/act_data_pnan_01.dbf	18	1.00	8	0	0
ACT_DATA_PNEM	/jsdb/jsdbdat_u02/jsdb/act_data_pnem_01.dbf	18	1.00	8	0	0
ACT_DATA_PNIB	/jsdb/jsdbdat_u02/jsdb/act_data_pnib_01.dbf	18	1.00	8	0	0
ACT_DATA_PNIX	/jsdb/jsdbdat_u02/jsdb/act_data_pnix_01.dbf	18	1.00	8	0	0
ACT_DATA_PQID	/jsdb/jsdbdat_u02/jsdb/act_data_pqid_01.dbf	18	1.00	8	0	0
ACT_DATA_PQNH	/jsdb/jsdbdat_u02/jsdb/act_data_pqnh_01.dbf	18	1.00	8	0	0
ACT_DATA_PSHH	/jsdb/jsdbdat_u02/jsdb/act_data_pshh_01.dbf	18	1.00	8	0	0
ACT_DATA_PSHJ	/jsdb/jsdbdat_u02/jsdb/act_data_pshj_01.dbf	16	1.00	8	0	0
ACT_DATA_PSHZ	/jsdb/jsdbdat_u02/jsdb/act_data_pshz_01.dbf	17	1.00	8	0	0
ACT_DATA_PSUZ	/jsdb/jsdbdat_u02/jsdb/act_data_psuz_01.dbf	17	1.00	8	0	0
ACT_DATA_PTAY	/jsdb/jsdbdat_u02/jsdb/act_data_ptay_01.dbf	18	1.00	8	0	0
ACT_DATA_PTIJ	/jsdb/jsdbdat_u02/jsdb/act_data_ptij_01.dbf	10	1.00	8	0	0
ACT_DATA_PWUH	/jsdb/jsdbdat_u02/jsdb/act_data_pwuh_01.dbf	10	1.00	8	0	0
ACT_DATA_PWUL	/jsdb/jsdbdat_u02/jsdb/act_data_pwul_01.dbf	10	1.00	8	0	0
ACT_DATA_PWUX	/jsdb/jsdbdat_u02/jsdb/act_data_pwux_01.dbf	10	1.00	8	0	0
ACT_DATA_PXIA	/jsdb/jsdbdat_u02/jsdb/act_data_pxia_01.dbf	10	1.00	8	0	0
ACT_DATA_PXIM	/jsdb/jsdbdat_u02/jsdb/act_data_pxim_01.dbf	10	1.00	8	0	0
ACT_DATA_PZHZ	/jsdb/jsdbdat_u02/jsdb/act_data_pzhz_01.dbf	10	1.00	8	0	0
ACT_GINDEX	/jsdb/jsdbidx_u01/jsdb/act_gindex_01.dbf	25	1.00	8	0	0
ACT_INDEX	/jsdb/jsdbidx_u01/jsdb/act_index_01.dbf	25	1.16	34,708	6	108
ACT_INDEX	/jsdb/jsdbidx_u01/jsdb/act_index_02.dbf	24	1.00	33,623	5	150
ACT_INDEX_PBEJ	/jsdb/jsdbidx_u02/jsdb/act_index_pbej_01.dbf	10	1.00	8	0	0
ACT_INDEX_PCHC	/jsdb/jsdbidx_u02/jsdb/act_index_pchc_01.dbf	10	1.00	8	0	0
ACT_INDEX_PCHD	/jsdb/jsdbidx_u02/jsdb/act_index_pchd_01.dbf	10	1.00	8	0	0
ACT_INDEX_PCHQ	/jsdb/jsdbidx_u02/jsdb/act_index_pchq_01.dbf	9	1.00	8	0	0
ACT_INDEX_PCHS	/jsdb/jsdbidx_u02/jsdb/act_index_pchs_01.dbf	10	1.00	8	0	0
ACT_INDEX_PCHZ	/jsdb/jsdbidx_u02/jsdb/act_index_pchz_01.dbf	10	1.00	8	0	0
ACT_INDEX_PDAL	/jsdb/jsdbidx_u02/jsdb/act_index_pdal_01.dbf	10	1.00	8	0	0
ACT_INDEX_PDEFAULT	/jsdb/jsdbidx_u02/jsdb/act_index_pdefault_01.dbf	10	1.00	8	0	0
ACT_INDEX_PFUZ	/jsdb/jsdbidx_u02/jsdb/act_index_pfuz_01.dbf	10	1.00	8	0	0
ACT_INDEX_PGUZ	/jsdb/jsdbidx_u02/jsdb/act_index_pguz_01.dbf	10	1.00	8	0	0
ACT_INDEX_PGYA	/jsdb/jsdbidx_u02/jsdb/act_index_pgya_01.dbf	10	1.00	8	0	0
ACT_INDEX_PHAE	/jsdb/jsdbidx_u02/jsdb/act_index_phae_01.dbf	10	1.00	8	0	0
ACT_INDEX_PHAN	/jsdb/jsdbidx_u02/jsdb/act_index_phan_01.dbf	9	1.00	8	0	0
ACT_INDEX_PHAZ	/jsdb/jsdbidx_u02/jsdb/act_index_phaz_01.dbf	17	1.00	8	0	0
ACT_INDEX_PHEF	/jsdb/jsdbidx_u02/jsdb/act_index_phef_01.dbf	17	1.00	8	0	0
ACT_INDEX_PHSY	/jsdb/jsdbidx_u02/jsdb/act_index_phsy_01.dbf	18	1.00	8	0	0
ACT_INDEX_PJIN	/jsdb/jsdbidx_u02/jsdb/act_index_pjin_01.dbf	18	1.00	8	0	0
ACT_INDEX_PKUM	/jsdb/jsdbidx_u02/jsdb/act_index_pkum_01.dbf	18	1.00	8	0	0
ACT_INDEX_PLAZ	/jsdb/jsdbidx_u02/jsdb/act_index_plaz_01.dbf	18	1.00	8	0	0
ACT_INDEX_PNAC	/jsdb/jsdbidx_u02/jsdb/act_index_pnac_01.dbf	17	1.00	8	0	0
ACT_INDEX_PNAJ	/jsdb/jsdbidx_u02/jsdb/act_index_pnaj_01.dbf	18	1.00	8	0	0
ACT_INDEX_PNAN	/jsdb/jsdbidx_u02/jsdb/act_index_pnan_01.dbf	18	1.00	8	0	0
ACT_INDEX_PNEM	/jsdb/jsdbidx_u02/jsdb/act_index_pnem_01.dbf	18	1.00	8	0	0
ACT_INDEX_PNIB	/jsdb/jsdbidx_u02/jsdb/act_index_pnib_01.dbf	17	1.00	8	0	0
ACT_INDEX_PNIX	/jsdb/jsdbidx_u02/jsdb/act_index_pnix_01.dbf	17	1.00	8	0	0
ACT_INDEX_PQID	/jsdb/jsdbidx_u02/jsdb/act_index_pqid_01.dbf	17	1.00	8	0	0
ACT_INDEX_PQNH	/jsdb/jsdbidx_u02/jsdb/act_index_pqnh_01.dbf	17	1.00	8	0	0
ACT_INDEX_PSHH	/jsdb/jsdbidx_u02/jsdb/act_index_pshh_01.dbf	17	1.00	8	0	0
ACT_INDEX_PSHJ	/jsdb/jsdbidx_u02/jsdb/act_index_pshj_01.dbf	17	1.00	8	0	0
ACT_INDEX_PSHZ	/jsdb/jsdbidx_u02/jsdb/act_index_pshz_01.dbf	17	1.00	8	0	0
ACT_INDEX_PSUZ	/jsdb/jsdbidx_u02/jsdb/act_index_psuz_01.dbf	18	1.00	8	0	0
ACT_INDEX_PTAY	/jsdb/jsdbidx_u02/jsdb/act_index_ptay_01.dbf	18	1.00	8	0	0
ACT_INDEX_PTIJ	/jsdb/jsdbidx_u02/jsdb/act_index_ptij_01.dbf	18	1.00	8	0	0
ACT_INDEX_PWUH	/jsdb/jsdbidx_u02/jsdb/act_index_pwuh_01.dbf	25	1.00	8	0	0
ACT_INDEX_PWUL	/jsdb/jsdbidx_u02/jsdb/act_index_pwul_01.dbf	26	1.00	8	0	0
ACT_INDEX_PWUX	/jsdb/jsdbidx_u02/jsdb/act_index_pwux_01.dbf	25	1.00	8	0	0
ACT_INDEX_PXIA	/jsdb/jsdbidx_u02/jsdb/act_index_pxia_01.dbf	26	1.00	8	0	0
ACT_INDEX_PXIM	/jsdb/jsdbidx_u02/jsdb/act_index_pxim_01.dbf	26	1.00	8	0	0
ACT_INDEX_PZHZ	/jsdb/jsdbidx_u02/jsdb/act_index_pzhz_01.dbf	26	1.00	8	0	0
SYSAUX	/jsdb/jsdbsys_u01/jsdb/sysaux_01.dbf	601	1.01	827	0	0
SYSTEM	/jsdb/jsdbsys_u01/jsdb/system_01.dbf	208	3.93	204	0	0
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_01.dbf	11	1.00	5,325	1	196
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_02.dbf	11	1.00	2,721	0	1
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_03.dbf	11	1.00	3,113	1	0
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_04.dbf	11	1.00	2,806	0	2
UNDOTBS1	/jsdb/jsdbudo_u01/jsdb/undotbs1_05.dbf	11	1.00	2,367	0	0
USERS	/jsdb/jsdbsys_u01/jsdb/users_01.dbf	9	1.00	8	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	3,657,192	100	44,538,329	1,564	970,567	0	0	7,075

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	11	3380	57572	63154	7549740	63154
E	0	65	53923	610415	3802135	7549740	3802135

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

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	109	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,477	158.35	0.00	0.00	0.00	0.00	629,140
E	6,144	5,481	143.49	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	2,014	2,014
64K	128K	11	11
128K	256K	26	26
256K	512K	2	2
512K	1024K	88	88
1M	2M	30	30

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	1,146.23	100.00	1
1,536	0.25	1,146.23	100.00	1
3,072	0.50	1,146.23	100.00	0
4,608	0.75	1,146.23	100.00	0
6,144	1.00	1,146.23	100.00	0
7,373	1.20	1,146.23	100.00	0
8,602	1.40	1,146.23	100.00	0
9,830	1.60	1,146.23	100.00	0
11,059	1.80	1,146.23	100.00	0
12,288	2.00	1,146.23	100.00	0
18,432	3.00	1,146.23	100.00	0
24,576	4.00	1,146.23	100.00	0
36,864	6.00	1,146.23	100.00	0
49,152	8.00	1,146.23	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	342	20,959	4,319,789	1.00	17,859	1.06	394,303,364
896	0.29	660	29,415	4,320,844	1.00	16,804	1.00	394,361,521
1,216	0.39	979	38,160	4,320,867	1.00	16,781	1.00	394,364,111
1,536	0.49	1,298	47,186	4,320,868	1.00	16,780	1.00	394,364,585
1,856	0.59	1,617	55,629	4,320,869	1.00	16,779	1.00	394,364,965
2,176	0.69	1,936	63,700	4,320,870	1.00	16,778	1.00	394,365,317
2,496	0.80	2,255	72,102	4,320,871	1.00	16,777	1.00	394,365,627
2,816	0.90	2,574	80,573	4,320,871	1.00	16,777	1.00	394,365,894
3,136	1.00	2,893	89,196	4,320,871	1.00	16,777	1.00	394,366,255
3,456	1.10	3,211	97,722	4,321,912	1.00	15,736	0.94	394,367,003
3,776	1.20	3,529	106,579	4,322,952	1.00	14,696	0.88	394,367,406
4,096	1.31	3,848	114,889	4,322,952	1.00	14,696	0.88	394,367,545
4,416	1.41	4,167	123,208	4,322,952	1.00	14,696	0.88	394,367,702
4,736	1.51	4,486	131,814	4,322,953	1.00	14,695	0.88	394,368,137
5,056	1.61	4,805	140,395	4,322,954	1.00	14,694	0.88	394,368,738
5,376	1.71	5,124	148,633	4,322,955	1.00	14,693	0.88	394,369,475
5,696	1.82	5,443	157,218	4,323,025	1.00	14,623	0.87	394,370,555
6,016	1.92	5,762	165,627	4,325,667	1.00	11,981	0.71	394,372,850
6,336	2.02	6,336	206,121	4,352,721	1.01	1	0.00	394,380,422

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	334,636	144,232
16,384	0.50	319,126	73,953
24,576	0.75	319,126	73,946
32,768	1.00	319,126	73,946
40,960	1.25	319,126	73,946
49,152	1.50	319,126	73,946
57,344	1.75	319,126	73,946
65,536	2.00	319,126	73,939

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	5,179	0	0
segment header	982	0	0
data block	570	0	0
undo header	195	0	0
2nd level bmb	143	0	0
undo block	4	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits
HW-Segment High Water Mark	2,801	2,797	4	736
TX-Transaction	89,034	89,032	0	382
FB-Format Block	27,313	27,312	0	112
TX-Transaction (index contention)	19	19	0	19
TX-Transaction (allocate ITL entry)	1	1	0	1

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	203.49	84,238	1,549	61	5760/5760	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
24-Jul 12:56	18,318	7,398	0	61	5,760	0/0	0/0/0/0/0/0
24-Jul 12:46	18,775	7,628	0	61	5,760	0/0	0/0/0/0/0/0
24-Jul 12:36	18,459	7,461	0	60	5,760	0/0	0/0/0/0/0/0
24-Jul 12:26	19,523	7,898	0	61	5,760	0/0	0/0/0/0/0/0
24-Jul 12:16	19,278	7,909	0	61	5,760	0/0	0/0/0/0/0/0
24-Jul 12:06	19,610	7,930	0	61	5,760	0/0	0/0/0/0/0/0
24-Jul 11:56	20,935	8,576	0	61	5,760	0/0	0/0/0/0/0/0
24-Jul 11:46	22,937	9,396	1,549	61	5,760	0/0	0/0/0/0/0/0
24-Jul 11:36	22,995	9,475	947	60	5,760	0/0	0/0/0/0/0/0
24-Jul 11:26	22,658	10,567	347	55	5,760	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	4,153	0.00		0	0
AWR Alerted Metric Element list	36,058	0.00		0	0
Consistent RBA	45,980	0.04	0.00	0	0
FAL request queue	141	0.00		0	0
FAL subheap alocation	141	0.00		0	0
FIB s.o chain latch	88	0.00		0	0
FOB s.o list latch	3,919	4.44	0.00	0	0
In memory undo latch	346,215	0.02	0.52	0	49,157	0.00
JS queue state obj latch	37,140	0.00		0	0
JS slv state obj latch	162	0.00		0	0
KMG MMAN ready and startup request latch	2,068	0.00		0	0
KTF sga latch	11	0.00		0	2,078	0.00
KWQMN job cache list latch	251	0.00		0	0
MQL Tracking Latch	0			0	124	0.00
Memory Management Latch	0			0	2,068	0.00
OS process	921	0.00		0	0
OS process allocation	2,672	0.19	0.00	0	0
OS process: request allocation	324	0.93	0.00	0	0
PL/SQL warning settings	790	0.00		0	0
SGA IO buffer pool latch	32	0.00		0	32	0.00
SQL memory manager latch	3	0.00		0	2,065	0.00
SQL memory manager workarea list latch	151,106	0.00		0	0
Shared B-Tree	222	0.00		0	0
active checkpoint queue latch	131,543	0.19	0.00	0	0
active service list	12,144	0.03	0.00	0	2,080	0.00
archive control	142	0.00		0	0
archive process latch	2,363	0.00		0	0
begin backup scn array	46	0.00		0	0
cache buffer handles	596,388	0.18	0.00	0	0
cache buffers chains	148,328,070	0.14	0.00	0	658,708	0.00
cache buffers lru chain	1,941,843	0.05	0.00	0	659,123	0.05
cache table scan latch	0			0	73	0.00
channel handle pool latch	326	0.31	0.00	0	0
channel operations parent latch	37,209	0.00		0	0
checkpoint queue latch	3,729,375	0.01	0.00	0	1,021,701	0.00
client/application info	3,138	0.00		0	0
compile environment latch	261	0.00		0	0
dml lock allocation	112,711	0.02	0.00	0	0
dummy allocation	532	0.00		0	0
enqueue hash chains	453,941	0.08	0.00	0	136	0.00
enqueues	206,587	0.17	0.00	0	0
event group latch	157	0.00		0	0
file cache latch	1,601	0.00		0	0
global KZLD latch for mem in SGA	87	0.00		0	0
hash table column usage latch	292	0.00		0	6,385	0.00
hash table modification latch	100	0.00		0	0
job workq parent latch	0			0	208	0.00
job_queue_processes parameter latch	207	0.00		0	0
kks stats	3,513	0.00		0	0
kokc descriptor allocation latch	50	0.00		0	0
ksuosstats global area	420	0.00		0	0
ktm global data	23	0.00		0	0
kwqbsn:qsga	222	0.00		0	0
lgwr LWN SCN	45,995	0.08	0.00	0	0
library cache	1,400,633,744	75.18	0.00	31	4,701	0.74
library cache load lock	120	0.00		0	0
library cache lock	1,501,975,093	41.79	0.00	6	0
library cache lock allocation	3,063	0.00		0	0
library cache pin	92,478	0.34	0.00	0	0
library cache pin allocation	594	0.00		0	0
list of block allocation	441,541	0.01	0.00	0	0
loader state object freelist	610	0.00		0	0
longop free list parent	2	0.00		0	2	0.00
messages	443,006	0.09	0.00	0	0
mostly latch-free SCN	46,273	0.53	0.00	0	0
multiblock read objects	158	0.00		0	0
ncodef allocation latch	99	0.00		0	0
object queue header heap	532,567	0.00		0	7	0.00
object queue header operation	4,191,114	0.03	0.00	0	0
object stats modification	3	0.00		0	0
parallel query alloc buffer	828	0.00		0	0
parameter list	50	0.00		0	0
parameter table allocation management	277	2.89	0.00	0	0
post/wait queue	96,451	0.01	0.00	0	74,666	0.01
process allocation	324	0.00		0	157	0.00
process group creation	324	1.54	0.00	0	0
qmn task queue latch	888	0.00		0	0
redo allocation	379,441	0.14	0.00	0	13,575,139	0.40
redo copy	0			0	13,579,344	0.02
redo writing	318,254	0.09	0.00	0	0
resmgr group change latch	624	0.00		0	0
resmgr:active threads	503	0.00		0	0
resmgr:actses change group	190	0.00		0	0
resmgr:free threads list	500	0.20	0.00	0	0
resmgr:schema config	3	0.00		0	0
row cache objects	190,291	2.23	0.00	0	0
sequence cache	2,913	0.00		0	0
session allocation	124,306	0.04	0.00	0	0
session idle bit	9,022,422	0.00	0.00	0	0
session state list latch	535	0.00		0	0
session switching	99	0.00		0	0
session timer	2,080	0.00		0	0
shared pool	292,642,998	0.00	0.00	0	0
shared pool simulator	656,090,401	5.96	0.00	0	0
simulator hash latch	3,118,231	0.00	0.00	0	0
simulator lru latch	970,567	0.06	0.00	0	2,066,060	0.02
slave class	16	0.00		0	0
slave class create	64	3.13	1.00	0	0
sort extent pool	150	0.00		0	0
state object free list	6	0.00		0	0
statistics aggregation	1,008	0.00		0	0
threshold alerts latch	3,602	0.00		0	0
trace latch	53	0.00		0	0
transaction allocation	840	0.00		0	0
transaction branch allocation	2,080	0.00		0	0
undo global data	2,344,967	0.00	0.00	0	303	0.00
user lock	576	0.87	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	1,400,633,744	1,052,943,666	703,527	1,052,242,550
library cache lock	1,501,975,093	627,696,935	42,916	627,654,294
shared pool simulator	656,090,401	39,117,959	74	39,117,886
cache buffers chains	148,328,070	212,172	953	211,381
shared pool	292,642,998	2,951	3	2,949
object queue header operation	4,191,114	1,082	2	1,080
simulator lru latch	970,567	536	1	535
checkpoint queue latch	3,729,375	326	1	325
In memory undo latch	346,215	77	40	38
slave class create	64	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	61	23
In memory undo latch	ktichg: child	1	33
active service list	ksws_event: ksws event	1	1
cache buffers chains	kcbgtcr: kslbegin excl	1,490	785
cache buffers chains	kcbgcur: kslbegin	489	353
cache buffers chains	kcbchg: kslbegin: bufs not pinned	471	246
cache buffers chains	kcbzwb	82	86
cache buffers chains	kcbrls: kslbegin	73	984
cache buffers chains	kcbget: exchange rls	34	31
cache buffers chains	kcbget: exchange	25	34
cache buffers chains	kcbchg: kslbegin: call CR func	4	163
cache buffers chains	kcbget: pin buffer	4	1
cache buffers chains	kcbbxsv	1	0
checkpoint queue latch	kcbkubc	1	1
library cache	kglLockCursor	331,390	372,933
library cache	kglhdgn: child:	828	809
library cache	kglobpn: child:	58	1
library cache	kgldti: 2child	5	0
library cache	kglic	5	0
library cache	kglpin	3	0
library cache	kglati	2	0
library cache	kglhdgc: child:	1	0
library cache	kglpndl: child: after processing	1	0
library cache lock	kgllkdl: child: no lock handle	370,911	329,571
library cache lock	kgllkdl: child: cleanup	21,878	21,796
library cache lock	kgllkal: child: multiinstance	20,991	21,080
object queue header operation	kcbo_switch_mq_bg	2	1
object queue header operation	kcbo_switch_q_bg	2	4
shared pool	kghfrunp: clatch: wait	18	0
shared pool	kghupr1	3	3
shared pool simulator	kglsim_unpin_simhp: fast path	51	81
shared pool simulator	kglsim_unpin_simhp	23	22
simulator lru latch	kcbs_simbufseq	1	4
slave class create	ksvcreate	2	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: 44,545,253
Captured Segments account for 94.0% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
ACT	ACT_DATA	TBL_CTJS	TABLE	21,361,200	47.95
ACT	ACT_INDEX	IDX_TBL_CTJS_01	INDEX	20,402,288	45.80
SYS	SYSTEM	I_OBJAUTH1	INDEX	18,272	0.04
SYS	SYSTEM	I_OBJ2	INDEX	10,144	0.02
SYS	SYSTEM	SYS_C00648	INDEX	8,304	0.02

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 3,100
Captured Segments account for 43.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	TAB$		TABLE	767	24.74
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	449946_156	TABLE PARTITION	581	18.74
ACT	ACT_INDEX	IDX_TBL_CTJS_CHECK_01		INDEX	5	0.16
SYS	SYSTEM	HIST_HEAD$		TABLE	3	0.10
SYSMAN	SYSAUX	MGMT_SYSTEM_PERF_LOG_IDX_01		INDEX	2	0.06

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	19	90.48
SYS	SYSTEM	SMON_SCN_TIME		TABLE	2	9.52

Back to Segment Statistics
Back to Top

Segments by ITL Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	ITL Waits	% of Capture
ACT	ACT_INDEX	IDX_TBL_CTJS_01		INDEX	1	100.00

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	6,615	96.25
ACT	ACT_INDEX	IDX_TBL_CTJS_01		INDEX	258	3.75

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	141	0.00	6	1
dc_database_links	178	0.00	0	1
dc_files	103	100.00	0	103
dc_global_oids	8,185	0.00	0	39
dc_histogram_data	407	0.98	0	1,221
dc_histogram_defs	807	11.52	0	3,023
dc_object_ids	9,734	0.20	0	744
dc_objects	1,279	2.81	0	745
dc_profiles	191	0.00	0	1
dc_rollback_segments	4,301	0.00	0	131
dc_segments	996	3.21	349	634
dc_sequences	39	5.13	39	4
dc_tablespace_quotas	307	0.00	0	2
dc_tablespaces	14,846	0.00	0	90
dc_usernames	704	0.00	0	28
dc_users	19,990	0.00	2	46
outstanding_alerts	1,740	0.00	0	172

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	1,199	0.00	9,617	0.00	0
CLUSTER	11	0.00	18	0.00	0
INDEX	24	0.00	146	0.00	0
SQL AREA	1,710,873	0.00	751,577,835	0.22	19
TABLE/PROCEDURE	557	1.80	21,444	0.28	29
TRIGGER	44	0.00	358	0.00	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	109.98		2.29	5.16	22	34	48	48
	Freeable	46.31	0.00	2.32	3.68	12		20	20
	SQL	1.43	0.70	0.04	0.04	0	3	33	31
	PL/SQL	0.64	0.46	0.01	0.02	0	0	48	48
E	Other	94.17		2.48	5.80	22	34	38	38
	Freeable	47.56	0.00	2.64	3.77	12		18	18
	SQL	1.22	0.64	0.05	0.05	0	3	23	21
	PL/SQL	0.55	0.40	0.01	0.02	0	0	38	38

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	CCursor	140.86	138.02	-2.02
shared	Checkpoint queue	125.02	125.02	0.00
shared	PCursor	94.79	91.23	-3.75
shared	db_block_hash_buckets	180.00	180.00	0.00
shared	free memory	1,075.01	1,109.57	3.21
shared	library cache	132.98	130.45	-1.90
shared	sql area	1,095.74	1,068.74	-2.46
	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
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
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
sessions	1105
sga_max_size	34359738368
sga_target	34359738368
timed_statistics	FALSE
undo_management	AUTO
undo_retention	10800
undo_tablespace	UNDOTBS1
user_dump_dest	/u01/oracle/admin/jsdb/udump

End of Report

% Blocks changed per Read:	56.73	Recursive Call %:	3.12
Rollback per transaction %:	0.00	Rows per Sort:	217.88

Buffer Nowait %:	99.98	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.78	Soft Parse %:	99.99
Execute to Parse %:	0.39	Latch Hit %:	57.32
Parse CPU to Parse Elapsd %:		% Non-Parse CPU:	100.00