WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ORCL 1302581403 ykchr 1 10.2.0.4.0 NO localhost.localdomain

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1302581403	ykchr	1	10.2.0.4.0	NO	localhost.localdomain

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 3409 14-Aug-12 14:00:03 148 4.9

End Snap: 3413 14-Aug-12 18:00:09 135 5.4

Elapsed: 240.10 (mins)

DB Time: 46.91 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	3409	14-Aug-12 14:00:03	148	4.9
End Snap:	3413	14-Aug-12 18:00:09	135	5.4
Elapsed:		240.10 (mins)
DB Time:		46.91 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 7,152M 7,152M Std Block Size: 8K

Shared Pool Size: 976M 976M Log Buffer: 14,332K

	Begin	End
Buffer Cache:	7,152M	7,152M	Std Block Size:	8K
Shared Pool Size:	976M	976M	Log Buffer:	14,332K

Load Profile

Per Second Per Transaction

Redo size: 4,644.40 20,226.11

Logical reads: 107.70 469.01

Block changes: 25.61 111.54

Physical reads: 0.34 1.48

Physical writes: 1.00 4.36

User calls: 9.30 40.48

Parses: 4.80 20.91

Hard parses: 0.39 1.68

Sorts: 2.54 11.08

Logons: 0.04 0.15

Executes: 6.57 28.61

Transactions: 0.23

	Per Second	Per Transaction
Redo size:	4,644.40	20,226.11
Logical reads:	107.70	469.01
Block changes:	25.61	111.54
Physical reads:	0.34	1.48
Physical writes:	1.00	4.36
User calls:	9.30	40.48
Parses:	4.80	20.91
Hard parses:	0.39	1.68
Sorts:	2.54	11.08
Logons:	0.04	0.15
Executes:	6.57	28.61
Transactions:	0.23

% Blocks changed per Read: 23.78 Recursive Call %: 84.54

Rollback per transaction %: 0.57 Rows per Sort: 14.60

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 91.42 Soft Parse %: 91.95

Execute to Parse %: 26.93 Latch Hit %: 99.98

Parse CPU to Parse Elapsd %: 0.01 % Non-Parse CPU: 80.58

Shared Pool Statistics

Begin End

Memory Usage %: 52.38 55.81

% SQL with executions>1: 93.45 97.78

% Memory for SQL w/exec>1: 86.79 93.90

	Begin	End
Memory Usage %:	52.38	55.81
% SQL with executions>1:	93.45	97.78
% Memory for SQL w/exec>1:	86.79	93.90

Top 5 Timed Events

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

SQL*Net break/reset to client 1,166 1,839 1,577 65.4 Application

cursor: pin S wait on X 90,453 981 11 34.9 Concurrency

CPU time 38 1.3

ARCH wait on SENDREQ 88 3 37 .1 Network

control file parallel write 12,233 3 0 .1 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
SQL*Net break/reset to client	1,166	1,839	1,577	65.4	Application
cursor: pin S wait on X	90,453	981	11	34.9	Concurrency
CPU time		38		1.3
ARCH wait on SENDREQ	88	3	37	.1	Network
control file parallel write	12,233	3	0	.1	System I/O

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Time Model Statistics

Total time in database user-calls (DB Time): 2814.4s
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
parse time elapsed	2,781.54	98.83
failed parse elapsed time	2,774.02	98.57
DB CPU	37.79	1.34
sql execute elapsed time	33.80	1.20
hard parse elapsed time	6.24	0.22
PL/SQL execution elapsed time	1.06	0.04
connection management call elapsed time	0.61	0.02
repeated bind elapsed time	0.17	0.01
inbound PL/SQL rpc elapsed time	0.09	0.00
hard parse (sharing criteria) elapsed time	0.08	0.00
PL/SQL compilation elapsed time	0.01	0.00
sequence load elapsed time	0.00	0.00
hard parse (bind mismatch) elapsed time	0.00	0.00
DB time	2,814.36
background elapsed time	46.87
background cpu time	20.82

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
Application	2,150	0.00	1,840	856	0.65
Concurrency	90,487	99.96	982	11	27.35
System I/O	79,152	0.00	5	0	23.93
Network	124,282	0.00	4	0	37.57
User I/O	6,058	0.00	1	0	1.83
Commit	2,077	0.00	0	0	0.63
Other	1,054	0.00	0	0	0.32
Configuration	4	0.00	0	0	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
SQL*Net break/reset to client	1,166	0.00	1,839	1577	0.35
cursor: pin S wait on X	90,453	100.00	981	11	27.34
ARCH wait on SENDREQ	88	0.00	3	37	0.03
control file parallel write	12,233	0.00	3	0	3.70
log file parallel write	10,817	0.00	1	0	3.27
control file sequential read	55,830	0.00	1	0	16.88
enq: RO - fast object reuse	969	0.00	0	0	0.29
db file sequential read	2,616	0.00	0	0	0.79
local write wait	1,252	0.00	0	0	0.38
log file sync	2,077	0.00	0	0	0.63
reliable message	840	0.00	0	0	0.25
SQL*Net message to client	117,718	0.00	0	0	35.59
os thread startup	9	0.00	0	18	0.00
Log archive I/O	144	0.00	0	1	0.04
db file scattered read	17	0.00	0	6	0.01
latch free	23	0.00	0	3	0.01
SQL*Net more data to client	5,641	0.00	0	0	1.71
log file sequential read	112	0.00	0	0	0.03
SQL*Net more data from client	378	0.00	0	0	0.11
SQL*Net more data from dblink	149	0.00	0	0	0.05
SGA: allocation forcing component growth	1	0.00	0	11	0.00
rdbms ipc reply	62	0.00	0	0	0.02
direct path read	2,065	0.00	0	0	0.62
LGWR wait for redo copy	124	0.00	0	0	0.04
log file single write	16	0.00	0	0	0.00
SQL*Net message to dblink	308	0.00	0	0	0.09
buffer busy waits	19	0.00	0	0	0.01
direct path write	108	0.00	0	0	0.03
SQL*Net break/reset to dblink	15	0.00	0	0	0.00
latch: library cache	2	0.00	0	0	0.00
latch: redo writing	4	0.00	0	0	0.00
latch: In memory undo latch	1	0.00	0	0	0.00
latch: object queue header operation	4	0.00	0	0	0.00
latch: cache buffers chains	3	0.00	0	0	0.00
SQL*Net message from client	117,717	0.00	145,427	1235	35.59
SQL*Net message from dblink	318	0.00	19,510	61352	0.10
jobq slave wait	4,808	94.82	14,063	2925	1.45
virtual circuit status	481	100.00	14,051	29213	0.15
Streams AQ: qmn slave idle wait	514	0.00	14,011	27259	0.16
Streams AQ: qmn coordinator idle wait	1,031	50.15	14,011	13590	0.31
Streams AQ: waiting for time management or cleanup tasks	3	100.00	8,798	2932804	0.00
single-task message	16	0.00	0	20	0.00
class slave wait	7	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
ARCH wait on SENDREQ	88	0.00	3	37	0.03
control file parallel write	12,233	0.00	3	0	3.70
log file parallel write	10,817	0.00	1	0	3.27
control file sequential read	50,874	0.00	0	0	15.38
os thread startup	9	0.00	0	18	0.00
Log archive I/O	144	0.00	0	1	0.04
log file sequential read	112	0.00	0	0	0.03
events in waitclass Other	205	0.00	0	0	0.06
log file single write	16	0.00	0	0	0.00
buffer busy waits	12	0.00	0	0	0.00
db file sequential read	1	0.00	0	0	0.00
latch: redo writing	4	0.00	0	0	0.00
direct path read	48	0.00	0	0	0.01
direct path write	49	0.00	0	0	0.01
latch: cache buffers chains	3	0.00	0	0	0.00
rdbms ipc message	70,144	72.93	164,125	2340	21.20
pmon timer	4,898	99.16	14,061	2871	1.48
Streams AQ: qmn slave idle wait	514	0.00	14,011	27259	0.16
Streams AQ: qmn coordinator idle wait	1,031	50.15	14,011	13590	0.31
smon timer	631	5.86	13,795	21862	0.19
Streams AQ: waiting for time management or cleanup tasks	3	100.00	8,798	2932804	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	6,821
IDLE_TIME	17,276,261
IOWAIT_TIME	174
NICE_TIME	0
SYS_TIME	1,193
USER_TIME	5,281
LOAD	0
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	16,826,368,000
NUM_CPUS	12
NUM_CPU_SOCKETS	2

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
orcl	2,783.80	9.90	62	294,752
SYS$USERS	30.60	27.90	4,719	1,172,064
SYS$BACKGROUND	0.00	0.00	100	84,760
orclXDB	0.00	0.00	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
orcl	56	3	90457	98140	9993	4
SYS$USERS	5820	69	6	0	113323	24
SYS$BACKGROUND	182	9	25	17	88	325

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
4	4	3	1.46	0.16	f5yun5dynkskv	plsqldev.exe	select s.synonym_name as obje...
4	4	4	1.09	0.15	bunssq950snhf		insert into wrh$_sga_target_ad...
3	3	85	0.04	0.11	7g12qa7spuf0x	JDBC Thin Client	select (case when (sysdate-i.n...
2	2	1	1.68	0.06	5jvf84zg4c49n	plsqldev.exe	select s.synonym_name as obje...
1	1	1,544	0.00	0.05	dv2k4js02p2vc	JDBC Thin Client	SELECT NULL AS table_cat, ...
1	1	240	0.01	0.05	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
1	1	3,899	0.00	0.03	60uw2vh6q9vn2		insert into col$(obj#, name, i...
1	1	501	0.00	0.03	cn1gtsav2d5jh	JDBC Thin Client	BEGIN BEGIN IF (xdb.DBMS...
1	1	1,548	0.00	0.02	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, ...
0	0	3	0.14	0.01	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...

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
4	4	3	1.46	0.16	f5yun5dynkskv	plsqldev.exe	select s.synonym_name as obje...
4	4	4	1.09	0.15	bunssq950snhf		insert into wrh$_sga_target_ad...
3	3	85	0.03	0.11	7g12qa7spuf0x	JDBC Thin Client	select (case when (sysdate-i.n...
2	2	1	1.66	0.06	5jvf84zg4c49n	plsqldev.exe	select s.synonym_name as obje...
1	1	1,544	0.00	0.05	dv2k4js02p2vc	JDBC Thin Client	SELECT NULL AS table_cat, ...
1	1	240	0.01	0.05	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
1	1	3,899	0.00	0.03	60uw2vh6q9vn2		insert into col$(obj#, name, i...
1	1	501	0.00	0.03	cn1gtsav2d5jh	JDBC Thin Client	BEGIN BEGIN IF (xdb.DBMS...
1	1	1,548	0.00	0.02	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, ...
0	0	1,002	0.00	0.01	78m9ryygp65v5	JDBC Thin Client	SELECT /+ ALL_ROWS / COUNT(*...

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: 1,551,473
Captured SQL account for 57.7% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
208,945	1,544	135.33	13.47	1.34	1.34	dv2k4js02p2vc	JDBC Thin Client	SELECT NULL AS table_cat, ...
170,130	3	56,710.00	10.97	4.39	4.39	f5yun5dynkskv	plsqldev.exe	select s.synonym_name as obje...
97,131	1,548	62.75	6.26	0.63	0.63	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, ...
83,166	501	166.00	5.36	0.76	0.76	cn1gtsav2d5jh	JDBC Thin Client	BEGIN BEGIN IF (xdb.DBMS...
56,897	1	56,897.00	3.67	1.66	1.68	5jvf84zg4c49n	plsqldev.exe	select s.synonym_name as obje...
54,108	1,002	54.00	3.49	0.33	0.33	78m9ryygp65v5	JDBC Thin Client	SELECT /+ ALL_ROWS / COUNT(*...
48,312	3,899	12.39	3.11	0.86	0.86	60uw2vh6q9vn2		insert into col$(obj#, name, i...
39,810	240	165.88	2.57	1.27	1.27	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
20,957	4	5,239.25	1.35	0.31	0.31	1ng6v39qb5hxg	plsqldev.exe	/* The name + type results o...
15,695	1	15,695.00	1.01	0.09	0.09	1sgh2rc44ud3q	JDBC Thin Client	UPDATE temp_HrpWarn SET (temp_...
15,692	3	5,230.67	1.01	0.28	0.28	4687ck9ww1w1c	PL/SQL Developer	select object_name, owner obj...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 4,881
Captured SQL account for 28.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
598	1	598.00	12.25	0.11	0.11	amnasvyg7jjyr	sqlplus@localhost.localdomain (TNS V1-V3)	select dbms_metadata.get_ddl('...
598	1	598.00	12.25	0.11	0.11	bb765fkaau5my	sqlplus@localhost.localdomain (TNS V1-V3)	select dbms_metadata.get_ddl('...
109	2	54.50	2.23	0.04	0.16	fjm2cnz8zpdap	java.exe	SELECT DBMS_WM.getVersion from...
47	4	11.75	0.96	0.05	0.05	cvn54b7yz0s8u		select /*+ index(idl_ub1$ i_id...
34	3	11.33	0.70	0.31	0.42	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
25	4	6.25	0.51	0.03	0.03	39m4sx9k63ba2		select /*+ index(idl_ub2$ i_id...
14	1	14.00	0.29	0.04	0.06	0dwr2vd6vbqzs		SELECT count(*) over () as tot...
5	7	0.71	0.10	0.00	0.02	0sxrub8cckxb7		INSERT INTO sys.wri$_adv_actio...
5	22	0.23	0.10	0.03	0.03	cqgv56fmuj63x		select owner#, name, namespace...
3	3,899	0.00	0.06	0.86	0.86	60uw2vh6q9vn2		insert into col$(obj#, name, i...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 94,643
Captured SQL account for 50.2% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
3,899	3,899	1.00	60uw2vh6q9vn2		insert into col$(obj#, name, i...
3,869	254	0.07	96g93hntrzjtr		select /+ rule / bucket_cnt,...
2,160	180	0.08	6ssrk2dqj7jbx		select job, nvl2(last_date, ...
1,782	1,782	1.00	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...
1,548	2,415	1.56	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, ...
1,544	35,307	22.87	dv2k4js02p2vc	JDBC Thin Client	SELECT NULL AS table_cat, ...
1,320	1,320	1.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
1,222	1,222	1.00	5fbmafvm27kfm		insert into obj$(owner#, name,...
1,023	1,023	1.00	27xdav1rg5g14		select u.name, o.name, o.nam...
1,022	7,184	7.03	0h6b2sajwb74n		select privilege#, level from ...
1,009	442	0.44	5ngzsfstg8tmy		select o.owner#, o.name, o.nam...
1,002	1,002	1.00	78m9ryygp65v5	JDBC Thin Client	SELECT /+ ALL_ROWS / COUNT(*...
996	996	1.00	c1z51t90s24ns		insert into con$(owner#, name,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 69,156
Captured SQL account for 47.1% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,782	1,782	2.58	9qgtwh66xg6nz		update seg$ set type#=:4, bloc...
1,548	1,548	2.24	c3m2v78k06wvy	JDBC Thin Client	SELECT NULL AS table_cat, ...
1,544	1,544	2.23	dv2k4js02p2vc	JDBC Thin Client	SELECT NULL AS table_cat, ...
1,222	1,222	1.77	5fbmafvm27kfm		insert into obj$(owner#, name,...
1,023	1,023	1.48	27xdav1rg5g14		select u.name, o.name, o.nam...
1,022	1,022	1.48	0h6b2sajwb74n		select privilege#, level from ...
913	913	1.32	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
913	913	1.32	g00cj285jmgsw		update sys.mon_mods$ set inser...
863	863	1.25	bsa0wjtftg3uw		select file# from file$ where ...
847	847	1.22	9p1um1wd886xb		select o.owner#, u.name, ...
821	821	1.19	aq4js2gkfjru8		update tsq$ set blocks=:3, max...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

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

0sxrub8cckxb7 INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15) RETURNING rowid INTO :16

1ng6v39qb5hxg /* The name + type results of these queries will be used by the Code Assistant if the "Describe Context" option is enabled. After typing 3 or more characters the Code Assistant will show a list of matching names. Separate multiple queries with semi-colons and use the :schema bind variable to restrict names to the currently connected user. In case of an error the query results will be omitted. No error message will be displayed. Place this file in the PL/SQL Developer installation directory for all users, or in the "%APPDATA%\PLSQL Developer" directory for a specific user. */ select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

1sgh2rc44ud3q UPDATE temp_HrpWarn SET (temp_HrpWarn.a0111)=(SELECT UsrA01.a0111 FROM UsrA01 WHERE temp_HrpWarn.A0100=UsrA01.A0100)

27xdav1rg5g14 select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1) from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#

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

39m4sx9k63ba2 select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#

4687ck9ww1w1c select object_name, owner object_owner, status, object_type, created, last_ddl_time from sys.all_objects o where object_type = 'VIEW' and object_name not like 'BIN$%' and subobject_name is null and (owner = user) order by decode(owner, user, 0, 1), owner, object_name

5fbmafvm27kfm insert into obj$(owner#, name, namespace, obj#, type#, ctime, mtime, stime, status, remoteowner, linkname, subname, dataobj#, flags, oid$, spare1, spare2)values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)

5jvf84zg4c49n select s.synonym_name as object_name, o.object_type from sys.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')

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

60uw2vh6q9vn2 insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/*DTYIYM*/, :7, 183/*DTYIDS*/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/*MAXSB1MINAL*/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)

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

78m9ryygp65v5 SELECT /*+ ALL_ROWS */ COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1

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

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

9p1um1wd886xb select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#

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

amnasvyg7jjyr select dbms_metadata.get_ddl('VIEW', 'BO_HC_RS_ZZSQ', 'YKSOFT') from dual

aq4js2gkfjru8 update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2

bb765fkaau5my select dbms_metadata.get_ddl('VIEW', 'BO_RS_EDUCATION', 'YKSOFT') from dual

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

c1z51t90s24ns insert into con$(owner#, name, con#)values(:1, :2, :3)

c3m2v78k06wvy SELECT NULL AS table_cat, c.owner AS table_schem, c.table_name, c.column_name, c.position AS key_seq, c.constraint_name AS pk_name FROM all_cons_columns c, all_constraints k WHERE k.constraint_type = 'P' AND k.table_name = :1 AND k.owner like :2 escape '/' AND k.constraint_name = c.constraint_name AND k.table_name = c.table_name AND k.owner = c.owner ORDER BY column_name

cn1gtsav2d5jh BEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;

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#

cvn54b7yz0s8u select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#

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

dv2k4js02p2vc SELECT NULL AS table_cat, t.owner AS table_schem, t.table_name AS table_name, t.column_name AS column_name, DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3, 'LONG', -1, 'DATE', 91, 'RAW', -3, 'LONG RAW', -4, 'BLOB', 2004, 'CLOB', 2005, 'BFILE', -13, 'FLOAT', 6, 'TIMESTAMP(6)', 93, 'TIMESTAMP(6) WITH TIME ZONE', -101, 'TIMESTAMP(6) WITH LOCAL TIME ZONE', -102, 'INTERVAL YEAR(2) TO MONTH', -103, 'INTERVAL DAY(2) TO SECOND(6)', -104, 'BINARY_FLOAT', 100, 'BINARY_DOUBLE', 101, 1111) AS data_type, t.data_type AS type_name, DECODE (t.data_precision, null, DECODE (t.data_type, 'CHAR', t.char_length, 'VARCHAR', t.char_length, 'VARCHAR2', t.char_length, t.data_length), t.data_precision) AS column_size, 0 AS buffer_length, t.data_scale AS decimal_digits, 10 AS num_prec_radix, DECODE (t.nullable, 'N', 0, 1) AS nullable, NULL AS remarks, t.data_default AS column_def, 0 AS sql_data_type, 0 AS sql_datetime_sub, t.data_length AS char_octet_length, t.column_id AS ordinal_position, DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable FROM all_tab_columns t WHERE t.owner LIKE :1 ES CAPE '/' AND t.table_name LIKE :2 ESCAPE '/' AND t.column_name LIKE :3 ESCAPE '/' ORDER BY table_schem, table_name, ordinal_position

f5yun5dynkskv select s.synonym_name as 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')

fjm2cnz8zpdap SELECT DBMS_WM.getVersion 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))

SQL Id	SQL Text
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
0sxrub8cckxb7	INSERT INTO sys.wri$_adv_actions (id, task_id, obj_id, command, msg_id, flags, attr1, attr2, attr3, attr4, attr5, attr6, num_attr1, num_attr2, num_attr3, num_attr4, num_attr5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, ' ', ' ', :11, :12, :13, :14, :15) RETURNING rowid INTO :16
1ng6v39qb5hxg	/* The name + type results of these queries will be used by the Code Assistant if the "Describe Context" option is enabled. After typing 3 or more characters the Code Assistant will show a list of matching names. Separate multiple queries with semi-colons and use the :schema bind variable to restrict names to the currently connected user. In case of an error the query results will be omitted. No error message will be displayed. Place this file in the PL/SQL Developer installation directory for all users, or in the "%APPDATA%\PLSQL Developer" directory for a specific user. */ select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
1sgh2rc44ud3q	UPDATE temp_HrpWarn SET (temp_HrpWarn.a0111)=(SELECT UsrA01.a0111 FROM UsrA01 WHERE temp_HrpWarn.A0100=UsrA01.A0100)
27xdav1rg5g14	select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1) from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
39m4sx9k63ba2	select /+ index(idl_ub2$ i_idl_ub21) +/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece#
4687ck9ww1w1c	select object_name, owner object_owner, status, object_type, created, last_ddl_time from sys.all_objects o where object_type = 'VIEW' and object_name not like 'BIN$%' and subobject_name is null and (owner = user) order by decode(owner, user, 0, 1), owner, object_name
5fbmafvm27kfm	insert into obj$(owner#, name, namespace, obj#, type#, ctime, mtime, stime, status, remoteowner, linkname, subname, dataobj#, flags, oid$, spare1, spare2)values(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17)
5jvf84zg4c49n	select s.synonym_name as object_name, o.object_type from sys.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')
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
60uw2vh6q9vn2	insert into col$(obj#, name, intcol#, segcol#, type#, length, precision#, scale, null$, offset, fixedstorage, segcollength, deflength, default$, col#, property, charsetid, charsetform, spare1, spare2, spare3)values(:1, :2, :3, :4, :5, :6, decode(:5, 182/DTYIYM/, :7, 183/DTYIDS/, :7, decode(:7, 0, null, :7)), decode(:5, 2, decode(:8, -127/MAXSB1MINAL/, null, :8), 178, :8, 179, :8, 180, :8, 181, :8, 182, :8, 183, :8, 231, :8, null), :9, 0, :10, :11, decode(:12, 0, null, :12), :13, :14, :15, :16, :17, :18, :19, :20)
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
78m9ryygp65v5	SELECT /+ ALL_ROWS / COUNT(*) FROM ALL_POLICIES V WHERE V.OBJECT_OWNER = :B3 AND V.OBJECT_NAME = :B2 AND (POLICY_NAME LIKE '%xdbrls%' OR POLICY_NAME LIKE '%$xd_%') AND V.FUNCTION = :B1
7g12qa7spuf0x	select (case when (sysdate-i.next_time)2460-h.delay_mins<60 then '0' else '<font color='\|\|''''\|\|'blue'\|\|''''\|\|'>��ʱ'\|\|h.dest_id\|\|'>'\|\|round((sysdate-i.next_time)2460-h.delay_mins)\|\|'m</font>' end) from (select b.DEST_ID, b.status, b.type, b.archived_seq#, b.applied_seq#, b.error, a.delay_mins from V$ARCHIVE_DEST a, V$ARCHIVE_DEST_STATUS b where a.dest_id=b.dest_id and a.target='STANDBY') h, v$archived_log i where h.dest_id=i.dest_id and h.applied_seq#=i.sequence# and i.name='mis_std'
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9p1um1wd886xb	select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#
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
amnasvyg7jjyr	select dbms_metadata.get_ddl('VIEW', 'BO_HC_RS_ZZSQ', 'YKSOFT') from dual
aq4js2gkfjru8	update tsq$ set blocks=:3, maxblocks=:4, grantor#=:5, priv1=:6, priv2=:7, priv3=:8 where ts#=:1 and user#=:2
bb765fkaau5my	select dbms_metadata.get_ddl('VIEW', 'BO_RS_EDUCATION', 'YKSOFT') from dual
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
c1z51t90s24ns	insert into con$(owner#, name, con#)values(:1, :2, :3)
c3m2v78k06wvy	SELECT NULL AS table_cat, c.owner AS table_schem, c.table_name, c.column_name, c.position AS key_seq, c.constraint_name AS pk_name FROM all_cons_columns c, all_constraints k WHERE k.constraint_type = 'P' AND k.table_name = :1 AND k.owner like :2 escape '/' AND k.constraint_name = c.constraint_name AND k.table_name = c.table_name AND k.owner = c.owner ORDER BY column_name
cn1gtsav2d5jh	BEGIN BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner)) THEN xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; BEGIN IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name); END IF; EXCEPTION WHEN OTHERS THEN null; END; END;
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#
cvn54b7yz0s8u	select /+ index(idl_ub1$ i_idl_ub11) +/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece#
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
dv2k4js02p2vc	SELECT NULL AS table_cat, t.owner AS table_schem, t.table_name AS table_name, t.column_name AS column_name, DECODE (t.data_type, 'CHAR', 1, 'VARCHAR2', 12, 'NUMBER', 3, 'LONG', -1, 'DATE', 91, 'RAW', -3, 'LONG RAW', -4, 'BLOB', 2004, 'CLOB', 2005, 'BFILE', -13, 'FLOAT', 6, 'TIMESTAMP(6)', 93, 'TIMESTAMP(6) WITH TIME ZONE', -101, 'TIMESTAMP(6) WITH LOCAL TIME ZONE', -102, 'INTERVAL YEAR(2) TO MONTH', -103, 'INTERVAL DAY(2) TO SECOND(6)', -104, 'BINARY_FLOAT', 100, 'BINARY_DOUBLE', 101, 1111) AS data_type, t.data_type AS type_name, DECODE (t.data_precision, null, DECODE (t.data_type, 'CHAR', t.char_length, 'VARCHAR', t.char_length, 'VARCHAR2', t.char_length, t.data_length), t.data_precision) AS column_size, 0 AS buffer_length, t.data_scale AS decimal_digits, 10 AS num_prec_radix, DECODE (t.nullable, 'N', 0, 1) AS nullable, NULL AS remarks, t.data_default AS column_def, 0 AS sql_data_type, 0 AS sql_datetime_sub, t.data_length AS char_octet_length, t.column_id AS ordinal_position, DECODE (t.nullable, 'N', 'NO', 'YES') AS is_nullable FROM all_tab_columns t WHERE t.owner LIKE :1 ES CAPE '/' AND t.table_name LIKE :2 ESCAPE '/' AND t.column_name LIKE :3 ESCAPE '/' ORDER BY table_schem, table_name, ordinal_position
f5yun5dynkskv	select s.synonym_name as 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')
fjm2cnz8zpdap	SELECT DBMS_WM.getVersion 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))

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	4,821	0.33	1.46
CPU used when call started	4,394	0.31	1.33
CR blocks created	4,181	0.29	1.26
Cached Commit SCN referenced	99	0.01	0.03
Commit SCN cached	1	0.00	0.00
DB time	9,978,323	692.64	3,016.42
DBWR checkpoint buffers written	8,352	0.58	2.52
DBWR checkpoints	947	0.07	0.29
DBWR object drop buffers written	4,712	0.33	1.42
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	475	0.03	0.14
DBWR undo block writes	4,147	0.29	1.25
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	150	0.01	0.05
IMU Redo allocation size	2,190,692	152.07	662.24
IMU commits	2,479	0.17	0.75
IMU contention	3	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	1	0.00	0.00
IMU undo allocation size	11,915,392	827.10	3,601.99
IMU- failed to get a private strand	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
SMON posted for undo segment recovery	13	0.00	0.00
SMON posted for undo segment shrink	6	0.00	0.00
SQL*Net roundtrips to/from client	116,898	8.11	35.34
SQL*Net roundtrips to/from dblink	308	0.02	0.09
active txn count during cleanout	13,487	0.94	4.08
application wait time	183,964	12.77	55.61
background checkpoints completed	8	0.00	0.00
background checkpoints started	8	0.00	0.00
background timeouts	51,172	3.55	15.47
branch node splits	0	0.00	0.00
buffer is not pinned count	583,761	40.52	176.47
buffer is pinned count	675,030	46.86	204.06
bytes received via SQL*Net from client	16,584,276	1,151.19	5,013.38
bytes received via SQL*Net from dblink	384,535	26.69	116.24
bytes sent via SQL*Net to client	35,866,521	2,489.67	10,842.36
bytes sent via SQL*Net to dblink	104,762	7.27	31.67
calls to get snapshot scn: kcmgss	208,307	14.46	62.97
calls to kcmgas	27,746	1.93	8.39
calls to kcmgcs	16,518	1.15	4.99
change write time	305	0.02	0.09
cleanout - number of ktugct calls	13,560	0.94	4.10
cleanouts and rollbacks - consistent read gets	57	0.00	0.02
cleanouts only - consistent read gets	33	0.00	0.01
cluster key scan block gets	207,881	14.43	62.84
cluster key scans	55,649	3.86	16.82
commit batch performed	24	0.00	0.01
commit batch requested	24	0.00	0.01
commit batch/immediate performed	47	0.00	0.01
commit batch/immediate requested	47	0.00	0.01
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: callback failure	85	0.01	0.03
commit cleanout failures: cannot pin	1	0.00	0.00
commit cleanouts	25,785	1.79	7.79
commit cleanouts successfully completed	25,699	1.78	7.77
commit immediate performed	23	0.00	0.01
commit immediate requested	23	0.00	0.01
commit txn count during cleanout	645	0.04	0.19
concurrency wait time	98,151	6.81	29.67
consistent changes	11,861	0.82	3.59
consistent gets	1,209,114	83.93	365.51
consistent gets - examination	400,697	27.81	121.13
consistent gets direct	2,185	0.15	0.66
consistent gets from cache	1,206,929	83.78	364.85
cursor authentications	321	0.02	0.10
data blocks consistent reads - undo records applied	11,218	0.78	3.39
db block changes	368,986	25.61	111.54
db block gets	342,359	23.76	103.49
db block gets direct	107	0.01	0.03
db block gets from cache	342,252	23.76	103.46
deferred (CURRENT) block cleanout applications	17,024	1.18	5.15
enqueue conversions	8,113	0.56	2.45
enqueue releases	172,986	12.01	52.29
enqueue requests	172,976	12.01	52.29
enqueue timeouts	3	0.00	0.00
enqueue waits	884	0.06	0.27
execute count	94,643	6.57	28.61
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	1	0.00	0.00
free buffer requested	15,761	1.09	4.76
heap block compress	21,593	1.50	6.53
immediate (CR) block cleanout applications	90	0.01	0.03
immediate (CURRENT) block cleanout applications	4,866	0.34	1.47
index crx upgrade (positioned)	13,074	0.91	3.95
index fast full scans (full)	99	0.01	0.03
index fetch by key	218,128	15.14	65.94
index scans kdiixs1	225,493	15.65	68.17
leaf node 90-10 splits	103	0.01	0.03
leaf node splits	574	0.04	0.17
lob reads	2,765	0.19	0.84
lob writes	1,047	0.07	0.32
lob writes unaligned	1,043	0.07	0.32
logons cumulative	505	0.04	0.15
messages received	51,737	3.59	15.64
messages sent	51,737	3.59	15.64
no buffer to keep pinned count	350	0.02	0.11
no work - consistent read gets	734,247	50.97	221.96
opened cursors cumulative	78,306	5.44	23.67
parse count (failures)	530	0.04	0.16
parse count (hard)	5,567	0.39	1.68
parse count (total)	69,156	4.80	20.91
parse time cpu	734	0.05	0.22
parse time elapsed	8,530,135	592.12	2,578.64
physical read IO requests	4,674	0.32	1.41
physical read bytes	39,985,152	2,775.56	12,087.41
physical read total IO requests	60,720	4.21	18.36
physical read total bytes	1,783,525,376	123,803.06	539,155.19
physical read total multi block requests	1,416	0.10	0.43
physical reads	4,881	0.34	1.48
physical reads cache	2,648	0.18	0.80
physical reads cache prefetch	66	0.00	0.02
physical reads direct	2,233	0.16	0.68
physical reads direct (lob)	2,158	0.15	0.65
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	44	0.00	0.01
physical write IO requests	6,287	0.44	1.90
physical write bytes	118,046,720	8,194.19	35,685.22
physical write total IO requests	54,013	3.75	16.33
physical write total bytes	863,287,808	59,924.95	260,969.71
physical write total multi block requests	10,729	0.74	3.24
physical writes	14,410	1.00	4.36
physical writes direct	155	0.01	0.05
physical writes direct (lob)	77	0.01	0.02
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	14,255	0.99	4.31
physical writes non checkpoint	9,656	0.67	2.92
prefetch warmup blocks flushed out before use	0	0.00	0.00
process last non-idle time	14,941	1.04	4.52
recursive calls	732,526	50.85	221.44
recursive cpu usage	2,137	0.15	0.65
redo blocks written	140,637	9.76	42.51
redo buffer allocation retries	0	0.00	0.00
redo entries	193,755	13.45	58.57
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	6,058	0.42	1.83
redo size	66,907,964	4,644.40	20,226.11
redo subscn max counts	9,667	0.67	2.92
redo synch time	30	0.00	0.01
redo synch writes	2,703	0.19	0.82
redo wastage	2,769,160	192.22	837.11
redo write time	107	0.01	0.03
redo writer latching time	0	0.00	0.00
redo writes	10,817	0.75	3.27
rollback changes - undo records applied	1,030	0.07	0.31
rollbacks only - consistent read gets	2,785	0.19	0.84
rows fetched via callback	98,241	6.82	29.70
session connect time	0	0.00	0.00
session cursor cache hits	34,327	2.38	10.38
session logical reads	1,551,473	107.70	469.01
session pga memory	393,262,048	27,298.21	118,882.12
session pga memory max	1,779,120,416	123,497.29	537,823.58
session uga memory	###############	74,236,335.09	323,294,953.02
session uga memory max	618,756,776	42,950.88	187,048.60
shared hash latch upgrades - no wait	17,104	1.19	5.17
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	36,637	2.54	11.08
sorts (rows)	534,939	37.13	161.71
sql area evicted	2,213	0.15	0.67
sql area purged	2,221	0.15	0.67
switch current to new buffer	751	0.05	0.23
table fetch by rowid	172,692	11.99	52.20
table fetch continued row	497	0.03	0.15
table scan blocks gotten	115,454	8.01	34.90
table scan rows gotten	5,062,012	351.38	1,530.23
table scans (long tables)	2	0.00	0.00
table scans (rowid ranges)	2	0.00	0.00
table scans (short tables)	16,676	1.16	5.04
total number of times SMON posted	596	0.04	0.18
transaction rollbacks	47	0.00	0.01
undo change vector size	23,497,264	1,631.06	7,103.16
user I/O wait time	82	0.01	0.02
user calls	133,916	9.30	40.48
user commits	3,289	0.23	0.99
user rollbacks	19	0.00	0.01
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	22,804	1.58	6.89
write clones created in background	1,252	0.09	0.38

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	138,554	145,094
opened cursors current	719	735
workarea memory allocated	2,815	2,815
logons current	148	135

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	2.00

Back to Instance Activity Statistics
Back to Top

IO Stats

Tablespace IO Stats
File IO Stats

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits
YKSPACE	3,370	0.08	1.03	2,870	0
SYSTEM	1,241	0.16	1.07	891	3
SYSAUX	47	2.13	1.34	1,295	0
UNDOTBS1	8	0.00	1.00	1,223	16
USERS	8	0.00	1.00	8	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits
SYSAUX	/oracle/oradata/ykchr/sysaux01.dbf	47	2.13	1.34	1,295	0
SYSTEM	/oracle/oradata/ykchr/system01.dbf	1,241	0.16	1.07	891	3
UNDOTBS1	/oracle/oradata/ykchr/undotbs01.dbf	8	0.00	1.00	1,223	16
USERS	/oracle/oradata/ykchr/users01.dbf	8	0.00	1.00	8	0
YKSPACE	/oracle/oradata/ykchr/ykchr01.dbf	2,875	0.10	1.03	2,521	0
YKSPACE	/oracle/oradata/ykchr/ykchr02.dbf	495	0.00	1.03	349	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	884,613	100	1,549,199	2,648	14,255	0	0	19

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	7	207	604	1933	184320	1933
E	0	7	178	731	943	184320	943

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	704	0.10	87,076	1.25	749,550
D	1,408	0.20	174,152	1.00	598,589
D	2,112	0.30	261,228	1.00	598,589
D	2,816	0.39	348,304	1.00	598,589
D	3,520	0.49	435,380	1.00	598,589
D	4,224	0.59	522,456	1.00	598,589
D	4,928	0.69	609,532	1.00	598,589
D	5,632	0.79	696,608	1.00	598,589
D	6,336	0.89	783,684	1.00	598,589
D	7,040	0.98	870,760	1.00	598,589
D	7,152	1.00	884,613	1.00	598,589
D	7,744	1.08	957,836	1.00	598,589
D	8,448	1.18	1,044,912	1.00	598,589
D	9,152	1.28	1,131,988	1.00	598,589
D	9,856	1.38	1,219,064	1.00	598,589
D	10,560	1.48	1,306,140	1.00	598,589
D	11,264	1.57	1,393,216	1.00	598,589
D	11,968	1.67	1,480,292	1.00	598,589
D	12,672	1.77	1,567,368	1.00	598,589
D	13,376	1.87	1,654,444	1.00	598,589
D	14,080	1.97	1,741,520	0.86	514,904

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	362	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

B: Begin snap E: End snap (rows dentified with B or E contain data which is absolute i.e. not diffed over the interval)
Auto PGA Target - actual workarea memory target
W/A PGA Used - amount of memory used for all Workareas (manual + auto)
%PGA W/A Mem - percentage of PGA memory allocated to workareas
%Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
%Man W/A Mem - percentage of workarea memory under manual control

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	2,048	1,736	262.63	2.75	1.05	100.00	0.00	209,710
E	2,048	1,737	256.53	0.00	0.00	0.00	0.00	209,710

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	22,297	22,297
64K	128K	215	215
128K	256K	20	20
256K	512K	11	11
512K	1024K	177	177
1M	2M	70	70
2M	4M	12	12
8M	16M	2	2

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 %
256	0.13	8,452.32	100.00
512	0.25	8,452.32	100.00
1,024	0.50	8,452.32	100.00
1,536	0.75	8,452.32	100.00
2,048	1.00	8,452.32	100.00
2,458	1.20	8,452.32	100.00
2,867	1.40	8,452.32	100.00
3,277	1.60	8,452.32	100.00
3,686	1.80	8,452.32	100.00
4,096	2.00	8,452.32	100.00
6,144	3.00	8,452.32	100.00
8,192	4.00	8,452.32	100.00
12,288	6.00	8,452.32	100.00
16,384	8.00	8,452.32	100.00

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
304	0.31	125	13,923	143,951	0.92	15,439	5.34	1,906,397
416	0.43	232	29,975	152,005	0.97	7,385	2.56	1,909,907
528	0.54	343	48,544	154,824	0.99	4,566	1.58	1,911,021
640	0.66	453	57,676	154,825	0.99	4,565	1.58	1,911,329
752	0.77	518	63,680	156,501	1.00	2,889	1.00	1,911,382
864	0.89	518	63,680	156,501	1.00	2,889	1.00	1,911,382
976	1.00	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,088	1.11	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,200	1.23	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,312	1.34	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,424	1.46	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,536	1.57	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,648	1.69	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,760	1.80	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,872	1.92	518	63,680	156,501	1.00	2,889	1.00	1,911,382
1,984	2.03	518	63,680	156,501	1.00	2,889	1.00	1,911,382

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,048	0.25	3,749	749,432
4,096	0.50	3,739	598,588
6,144	0.75	3,739	598,588
8,192	1.00	3,739	598,588
10,240	1.25	3,739	598,588
12,288	1.50	3,739	598,588
14,336	1.75	3,734	514,905
16,384	2.00	3,734	514,905

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	13	0	0
data block	3	0	0
undo block	3	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	8,451	8,451	0	884	1	0.58

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	3.72	10,476	1,799	17	15/41.9833333333333333333333333333333333333	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
14-Aug 18:09	52	184	0	5	15	0/0	0/0/0/0/0/0
14-Aug 17:59	10	93	0	4	15	0/0	0/0/0/0/0/0
14-Aug 17:49	5	53	0	4	15	0/0	0/0/0/0/0/0
14-Aug 17:39	1	78	0	3	15	0/0	0/0/0/0/0/0
14-Aug 17:29	5	60	0	3	15	0/0	0/0/0/0/0/0
14-Aug 17:19	3	148	0	3	15	0/0	0/0/0/0/0/0
14-Aug 17:09	59	112	0	5	15	0/0	0/0/0/0/0/0
14-Aug 16:59	1	102	0	3	15	0/0	0/0/0/0/0/0
14-Aug 16:49	526	347	0	5	15	0/0	0/0/0/0/0/0
14-Aug 16:39	525	417	0	5	15	0/0	0/0/0/0/0/0
14-Aug 16:29	551	396	0	5	15	0/0	0/0/0/0/0/0
14-Aug 16:19	580	437	0	3	15	0/0	0/0/0/0/0/0
14-Aug 16:09	55	265	0	4	15	0/0	0/0/0/0/0/0
14-Aug 15:59	3	56	0	2	15	0/0	0/0/0/0/0/0
14-Aug 15:49	6	72	0	2	15	0/0	0/0/0/0/0/0
14-Aug 15:39	3	56	0	1	15	0/0	0/0/0/0/0/0
14-Aug 15:29	7	95	0	1	15	0/0	0/0/0/0/0/0
14-Aug 15:19	4	52	0	1	15	0/0	0/0/0/0/0/0
14-Aug 15:09	69	297	0	3	15	0/0	0/0/0/0/0/0
14-Aug 14:59	15	60	0	2	15	0/0	0/0/0/0/0/0
14-Aug 14:49	26	113	1,799	4	42	0/0	0/0/0/0/0/0
14-Aug 14:39	12	197	1,199	8	32	0/0	0/0/0/0/0/0
14-Aug 14:29	7	154	599	6	22	0/0	0/0/0/0/0/0
14-Aug 14:19	532	3,695	0	17	15	0/0	0/0/0/0/0/0
14-Aug 14:09	662	2,937	0	16	15	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

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

Latch Activity

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

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
ASM db client latch	11,547	0.00		0
AWR Alerted Metric Element list	80,578	0.00		0
Consistent RBA	10,825	0.00		0
FAL request queue	343	0.00		0
FAL subheap alocation	335	0.00		0
FIB s.o chain latch	104	0.00		0
FOB s.o list latch	1,024	0.00		0
In memory undo latch	25,738	0.00	1.00	6,439	0.00
JS mem alloc latch	29	0.00		0
JS queue access latch	29	0.00		0
JS queue state obj latch	104,192	0.00		0
JS slv state obj latch	45	0.00		0
KMG MMAN ready and startup request latch	4,801	0.00		0
KMG resize request state object freelist	2	0.00		0
KTF sga latch	28	0.00		4,523	0.00
KWQMN job cache list latch	3	0.00		0
MQL Tracking Latch	0			288	0.00
Memory Management Latch	17	0.00		4,801	0.00
OS process	861	0.00		0
OS process allocation	5,361	0.02	0.00	0
OS process: request allocation	525	0.00		0
PL/SQL warning settings	4,731	0.00		0
SGA IO buffer pool latch	2	0.00		2	0.00
SQL memory manager latch	4	0.00		4,800	0.00
SQL memory manager workarea list latch	500,436	0.00		0
Shared B-Tree	514	0.00		0
active checkpoint queue latch	54,977	0.31	0.01	0
active service list	30,893	0.00		4,896	0.00
archive control	1,655	0.00		0
archive process latch	5,446	0.29	1.00	0
begin backup scn array	82	0.00		0
cache buffer handles	10,267	0.00		0
cache buffers chains	3,520,337	0.01	0.01	14,826	0.01
cache buffers lru chain	40,363	0.07	0.00	22,753	0.06
cache table scan latch	0			6	0.00
channel handle pool latch	1,024	0.00		0
channel operations parent latch	87,635	0.00	0.00	0
checkpoint queue latch	1,068,398	0.01	0.00	14,103	0.01
client/application info	7,768	0.00		0
commit callback allocation	1,342	0.00		0
compile environment latch	505	0.00		0
constraint object allocation	32	0.00		0
dictionary lookup	1,151	0.00		0
dml lock allocation	39,251	0.00		0
dummy allocation	1,123	0.00		0
enqueue hash chains	356,064	0.00	0.00	2	0.00
enqueues	291,161	0.00	0.00	0
event group latch	256	0.00		0
file cache latch	1,292	0.00		0
global KZLD latch for mem in SGA	239	0.00		0
global tx hash mapping	551	0.00		0
hash table column usage latch	1,019	0.00		110,673	0.00
hash table modification latch	450	0.00		0
job workq parent latch	0			498	0.00
job_queue_processes parameter latch	489	0.00		0
kks stats	19,933	0.00		0
kmcptab latch	1	0.00		0
kmcpvec latch	0			1	0.00
kokc descriptor allocation latch	162	0.00		0
ksuosstats global area	968	0.00		0
ktm global data	665	0.00		0
kwqbsn:qsga	514	0.00		0
lgwr LWN SCN	14,851	0.01	0.00	0
library cache	506,355	0.01	0.06	870	0.00
library cache load lock	1,874	0.00		0
library cache lock	319,422	0.00	0.00	0
library cache lock allocation	10,701	0.00		0
library cache pin	151,138	0.00		0
library cache pin allocation	1,740	0.00		0
list of block allocation	878	0.00		0
loader state object freelist	4,534	0.00		0
message pool operations parent latch	3,980	0.00		0
messages	227,914	0.09	0.00	0
mostly latch-free SCN	14,893	0.13	0.00	0
multiblock read objects	34	0.00		0
ncodef allocation latch	265	0.00		0
object queue header heap	157,418	0.01	0.00	4,924	0.02
object queue header operation	360,115	0.06	0.02	0
object stats modification	1,314	3.12	0.00	0
parallel query alloc buffer	1,752	0.00		0
parameter list	561	0.00		0
parameter table allocation management	602	0.00		0
post/wait queue	3,187	0.16	0.00	2,112	0.00
process allocation	525	0.00		256	0.00
process group creation	525	0.19	0.00	0
qmn task queue latch	2,056	0.00		0
redo allocation	54,452	0.10	0.00	193,708	0.05
redo copy	0			193,739	0.06
redo writing	93,674	0.15	0.03	0
resmgr group change latch	1,526	0.00		0
resmgr:active threads	1,065	0.00		0
resmgr:actses change group	493	0.00		0
resmgr:actses change state	28	0.00		0
resmgr:free threads list	1,005	0.00		0
resmgr:resource group CPU method	28	0.00		0
resmgr:schema config	4	0.00		0
resmgr:vc list latch	28	0.00		0
row cache objects	1,226,773	0.01	0.00	0
sequence cache	1,746	0.00		0
session allocation	90,593	0.00	0.00	0
session idle bit	273,401	0.00		0
session state list latch	1,188	0.00		0
session switching	18,538	0.02	0.00	0
session timer	4,896	0.00		0
shared pool	342,244	0.04	0.00	0
shared pool sim alloc	165	0.00		0
shared pool simulator	152,572	0.00		0
simulator hash latch	115,184	0.00	0.00	0
simulator lru latch	14,256	0.03	0.00	99,954	0.00
slave class	9	0.00		0
slave class create	36	11.11	1.25	0
sort extent pool	986	0.00		0
state object free list	8	0.00		0
statistics aggregation	2,240	0.00		0
temp lob duration state obj allocation	5	0.00		0
threshold alerts latch	618	0.00		0
trace latch	9	0.00		0
transaction allocation	41,465	0.00		0
transaction branch allocation	5,491	0.00		0
undo global data	67,705	0.00	0.00	616	0.00
user lock	1,662	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	3,520,337	307	3	304
object queue header operation	360,115	209	4	205
active checkpoint queue latch	54,977	168	2	166
redo writing	93,674	139	4	135
library cache	506,355	34	2	32
archive process latch	5,446	16	16	0
slave class create	36	4	5	0
In memory undo latch	25,738	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	1	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	1	1
active checkpoint queue latch	kcbkcpa: Checkpoint post-processing	1	10
archive process latch	kcrrsarc	16	0
cache buffers chains	kcbbxsv	7	5
cache buffers chains	kcbbic2	2	0
cache buffers chains	kcbbic1	1	0
cache buffers chains	kcbgcur: kslbegin	1	0
cache buffers chains	kcbgtcr: fast path	1	0
cache buffers chains	kcbgtcr: kslbegin excl	1	0
library cache	kglScanDependency	2	0
object queue header operation	kcbo_write_q	10	1
object queue header operation	kcbw_link_q	6	0
object queue header operation	kcbo_swap_buf_bg	1	6
object queue header operation	kcbo_switch_q_bg	1	11
redo writing	kcrfwcr	3	4
redo writing	kcrfw_post: rba scn pair	1	0
slave class create	ksvcreate	5	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: 1,551,473
Captured Segments account for 71.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	I_OBJAUTH1	INDEX	202,832	13.07
SYS	SYSTEM	COLTYPE$	TABLE	114,368	7.37
SYS	SYSTEM	I_OBJ2	INDEX	84,800	5.47
SYS	SYSTEM	OBJ$	TABLE	64,416	4.15
SYS	SYSTEM	COL$	TABLE	55,232	3.56

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 4,881
Captured Segments account for 3.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
YKSOFT	YKSPACE	SYS_LOB0000103173C00002$$	LOB	137	2.81
YKSOFT	YKSPACE	USRA58	TABLE	8	0.16
SYS	SYSTEM	I_COL2	INDEX	2	0.04
YKSOFT	YKSPACE	SALARYHISTORY	TABLE	2	0.04
YKSOFT	YKSPACE	SALARYSET	TABLE	2	0.04

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

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
SYS	SYSTEM	USER$		TABLE	3	100.00

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	260	0.00	8	1
dc_constraints	2,120	50.00	2,120	5,685
dc_database_links	694	0.00	0	2
dc_files	6	0.00	0	6
dc_global_oids	785	0.00	0	176
dc_histogram_data	10,179	0.42	0	7,042
dc_histogram_defs	30,736	13.81	0	54,295
dc_object_grants	1,243	1.53	0	170
dc_object_ids	37,185	3.37	623	3,970
dc_objects	24,474	6.51	4,075	13,153
dc_profiles	493	0.00	0	1
dc_rollback_segments	2,148	0.00	6	22
dc_segments	23,390	2.77	2,409	9,534
dc_sequences	16	12.50	16	7
dc_table_scns	48	0.00	0	3
dc_tablespace_quotas	821	0.00	821	1
dc_tablespaces	120,208	0.00	0	7
dc_usernames	8,075	0.02	0	56
dc_users	151,157	0.00	1	81
outstanding_alerts	168	0.00	0	7

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	3,491	0.03	8,511	0.01	0	0
CLUSTER	40	0.00	74	0.00	0	0
INDEX	1,254	28.63	3,473	29.89	338	0
JAVA RESOURCE	1	100.00	1	100.00	0	0
JAVA SOURCE	1	100.00	1	100.00	0	0
SQL AREA	44,463	13.86	144,043	10.14	2,981	2,362
TABLE/PROCEDURE	5,366	12.21	42,270	5.87	595	0
TRIGGER	7,122	0.01	13,028	0.01	0	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	197.64		1.32	4.31	44	45	150	150
	Freeable	59.81	0.00	0.91	0.84	7		66	66
	SQL	4.18	3.30	0.03	0.17	1	22	139	128
	PL/SQL	1.06	0.63	0.01	0.01	0	1	148	148
E	Other	195.00		1.42	4.54	44	45	137	137
	Freeable	59.56	0.00	0.93	0.84	7		64	64
	SQL	1.19	0.45	0.01	0.02	0	22	126	120
	PL/SQL	0.84	0.48	0.01	0.01	0	1	135	135

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	7,499,415,552
Fixed Size	2,097,696
Redo Buffers	14,675,968
Variable Size	1,073,745,376

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	32.00	32.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	22.50	22.50	0.00
shared	CCursor	70.81	77.17	8.99
shared	KGLS heap	10.31	10.56	2.47
shared	KQR L PO	11.88	12.84	8.17
shared	KQR M PO	33.29	36.04	8.28
shared	PCursor	23.81	25.89	8.72
shared	free memory	464.74	431.30	-7.20
shared	library cache	35.34	38.30	8.38
shared	object queue	18.01	18.03	0.09
shared	sql area	167.82	183.84	9.55
	buffer_cache	7,152.00	7,152.00	0.00
	fixed_sga	2.00	2.00	0.00
	log_buffer	14.00	14.00	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Apply
Buffered Queues
Buffered Subscribers
Rule Set

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

init.ora Parameters

Parameter Name	Begin value	End value (if different)
archive_lag_target	1800
audit_file_dest	/oracle/admin/ykchr/adump
background_dump_dest	/oracle/admin/ykchr/bdump
compatible	10.2.0.3.0
control_files	/oracle/oradata/ykchr/control01.ctl, /oracle/oradata/ykchr/control02.ctl, /oracle/oradata/ykchr/control03.ctl
core_dump_dest	/oracle/admin/ykchr/cdump
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	orcl
db_recovery_file_dest	/oracle/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
fal_client	ykchr_pri
fal_server	ykchr_std
job_queue_processes	10
log_archive_dest_1	location=/oracle/arch_dest/ykchr
log_archive_dest_2	SERVICE=ykchr_std
log_archive_format	%t_%s_%r.dbf
open_cursors	300
pga_aggregate_target	2147483648
processes	300
remote_login_passwordfile	EXCLUSIVE
sga_max_size	8589934592
sga_target	8589934592
shared_pool_size	0	83886080
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	/oracle/admin/ykchr/udump

End of Report

% Blocks changed per Read:	23.78	Recursive Call %:	84.54
Rollback per transaction %:	0.57	Rows per Sort:	14.60

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.97	In-memory Sort %:	100.00
Library Hit %:	91.42	Soft Parse %:	91.95
Execute to Parse %:	26.93	Latch Hit %:	99.98
Parse CPU to Parse Elapsd %:	0.01	% Non-Parse CPU:	80.58