WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

ORCL 1337911690 orcl 1 10.2.0.1.0 NO ATMSSJK1

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
ORCL	1337911690	orcl	1	10.2.0.1.0	NO	ATMSSJK1

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1978 06-6月 -13 10:01:03 60 4.0

End Snap: 1987 06-6月 -13 19:00:31 62 5.3

Elapsed: 539.47 (mins)

DB Time: 0.73 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1978	06-6月 -13 10:01:03	60	4.0
End Snap:	1987	06-6月 -13 19:00:31	62	5.3
Elapsed:		539.47 (mins)
DB Time:		0.73 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,280M 1,280M Std Block Size: 8K

Shared Pool Size: 240M 240M Log Buffer: 15,160K

	Begin	End
Buffer Cache:	1,280M	1,280M	Std Block Size:	8K
Shared Pool Size:	240M	240M	Log Buffer:	15,160K

Load Profile

Per Second Per Transaction

Redo size: 783.28 7,485.58

Logical reads: 39.77 380.11

Block changes: 4.79 45.75

Physical reads: 0.23 2.21

Physical writes: 0.31 2.95

User calls: 2.00 19.15

Parses: 1.82 17.42

Hard parses: 0.07 0.69

Sorts: 0.67 6.37

Logons: 0.04 0.36

Executes: 3.73 35.69

Transactions: 0.10

	Per Second	Per Transaction
Redo size:	783.28	7,485.58
Logical reads:	39.77	380.11
Block changes:	4.79	45.75
Physical reads:	0.23	2.21
Physical writes:	0.31	2.95
User calls:	2.00	19.15
Parses:	1.82	17.42
Hard parses:	0.07	0.69
Sorts:	0.67	6.37
Logons:	0.04	0.36
Executes:	3.73	35.69
Transactions:	0.10

% Blocks changed per Read: 12.04 Recursive Call %: 90.15

Rollback per transaction %: 0.59 Rows per Sort: 20.75

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 98.68 Soft Parse %: 96.05

Execute to Parse %: 51.18 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 69.76 % Non-Parse CPU: 87.37

Shared Pool Statistics

Begin End

Memory Usage %: 61.74 68.02

% SQL with executions>1: 81.24 88.95

% Memory for SQL w/exec>1: 85.30 89.80

	Begin	End
Memory Usage %:	61.74	68.02
% SQL with executions>1:	81.24	88.95
% Memory for SQL w/exec>1:	85.30	89.80

Top 5 Timed Events

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

CPU time 23 53.3

db file sequential read 6,042 17 3 39.1 User I/O

control file parallel write 10,789 10 1 22.0 System I/O

db file parallel write 7,554 5 1 12.4 System I/O

log file parallel write 6,140 3 0 6.1 System I/O

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		23		53.3
db file sequential read	6,042	17	3	39.1	User I/O
control file parallel write	10,789	10	1	22.0	System I/O
db file parallel write	7,554	5	1	12.4	System I/O
log file parallel write	6,140	3	0	6.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): 43.5s
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	45.61	104.82
DB CPU	23.19	53.30
parse time elapsed	6.28	14.42
hard parse elapsed time	4.67	10.74
PL/SQL execution elapsed time	3.63	8.35
connection management call elapsed time	0.45	1.03
PL/SQL compilation elapsed time	0.25	0.58
failed parse elapsed time	0.03	0.07
repeated bind elapsed time	0.03	0.06
hard parse (sharing criteria) elapsed time	0.02	0.05
hard parse (bind mismatch) elapsed time	0.02	0.05
sequence load elapsed time	0.01	0.02
DB time	43.51
background elapsed time	53.37
background cpu time	31.58

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
System I/O	32,044	0.00	20	1	9.46
User I/O	6,673	0.00	18	3	1.97
Concurrency	540	0.00	2	4	0.16
Network	82,066	0.00	1	0	24.23
Commit	1,256	0.00	1	1	0.37
Other	787	0.25	0	0	0.23
Application	167	0.00	0	0	0.05
Configuration	70	100.00	0	0	0.02

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
db file sequential read	6,042	0.00	17	3	1.78
control file parallel write	10,789	0.00	10	1	3.19
db file parallel write	7,554	0.00	5	1	2.23
log file parallel write	6,140	0.00	3	0	1.81
control file sequential read	7,561	0.00	2	0	2.23
os thread startup	490	0.00	2	4	0.14
SQL*Net more data to client	33,116	0.00	1	0	9.78
db file scattered read	207	0.00	1	5	0.06
log file sync	1,256	0.00	1	1	0.37
direct path read	348	0.00	0	1	0.10
read by other session	29	0.00	0	4	0.01
library cache load lock	16	0.00	0	6	0.00
kksfbc child completion	1	100.00	0	58	0.00
SQL*Net message to client	46,400	0.00	0	0	13.70
SQL*Net more data from client	2,550	0.00	0	0	0.75
latch free	9	0.00	0	2	0.00
row cache lock	21	0.00	0	1	0.01
LGWR wait for redo copy	751	0.13	0	0	0.22
SQL*Net break/reset to client	166	0.00	0	0	0.05
library cache pin	2	0.00	0	2	0.00
local write wait	3	0.00	0	1	0.00
rdbms ipc reply	25	0.00	0	0	0.01
enq: RO - fast object reuse	1	0.00	0	1	0.00
latch: shared pool	2	0.00	0	0	0.00
buffer busy waits	8	0.00	0	0	0.00
reliable message	1	0.00	0	0	0.00
undo segment extension	70	100.00	0	0	0.02
direct path write	44	0.00	0	0	0.01
latch: In memory undo latch	1	0.00	0	0	0.00
SQL*Net message from client	46,398	0.00	321,334	6926	13.70
Streams AQ: qmn slave idle wait	1,155	0.00	32,233	27907	0.34
Streams AQ: qmn coordinator idle wait	2,324	50.30	32,233	13869	0.69
virtual circuit status	1,079	100.00	32,220	29861	0.32
jobq slave wait	10,034	99.44	29,992	2989	2.96
Streams AQ: waiting for time management or cleanup tasks	118	69.49	19,308	163631	0.03
class slave wait	19	100.00	95	4994	0.01

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
control file parallel write	10,789	0.00	10	1	3.19
db file parallel write	7,554	0.00	5	1	2.23
log file parallel write	6,140	0.00	3	0	1.81
os thread startup	490	0.00	2	4	0.14
control file sequential read	1,404	0.00	1	1	0.41
db file sequential read	13	0.00	0	9	0.00
events in waitclass Other	763	0.13	0	0	0.23
buffer busy waits	2	0.00	0	0	0.00
rdbms ipc message	140,775	96.60	381,407	2709	41.56
pmon timer	11,029	100.00	32,354	2934	3.26
Streams AQ: qmn slave idle wait	1,155	0.00	32,233	27907	0.34
Streams AQ: qmn coordinator idle wait	2,324	50.30	32,233	13869	0.69
smon timer	110	95.45	30,475	277043	0.03
Streams AQ: waiting for time management or cleanup tasks	118	69.49	19,308	163631	0.03

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	1,941
AVG_IDLE_TIME	3,233,411
AVG_SYS_TIME	###############
AVG_USER_TIME	920
BUSY_TIME	74,950
IDLE_TIME	103,504,406
SYS_TIME	38,595
USER_TIME	36,355
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	440,246,272
VM_OUT_BYTES	158,269,440
PHYSICAL_MEMORY_BYTES	68,719,095,808
NUM_CPUS	32
NUM_CPU_CORES	4

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	30.00	14.40	4,767	348,971
orcl	13.50	8.80	2,469	798,727
SYS$BACKGROUND	0.00	0.00	290	139,701
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
SYS$USERS	4642	1045	40	13	67143	113
orcl	1314	418	0	0	14318	11
SYS$BACKGROUND	717	375	492	185	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
12	1	498	0.02	28.13	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
10	1	360	0.03	22.17	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
9	1	1	9.18	21.10	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
7	7	9	0.78	16.13	bunssq950snhf		insert into wrh$_sga_target_ad...
5	4	2	2.31	10.62	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
3	0	9	0.33	6.93	350myuyx0t1d6		insert into wrh$_tablespace_st...
3	2	52	0.05	6.42	4c1xvq9ufwcjc	plsqldev.exe	select count(*) from user$ u...
1	1	1	1.46	3.35	2pgqas6suvysu	gsrvr.exe	SELECT AC.owner, AC.table_nam...
1	0	1	1.25	2.88	3ufgtqbyzb1c2	PL/SQL Developer	select /+rule/ object_name,...
1	1	108	0.01	2.37	357naahf3rh3j	w3wp.exe	update t_pda_deviceinfo ...
1	0	9	0.10	2.02	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...
1	1	333	0.00	1.61	3g3k6s95772cr	gsrvr.exe	SELECT points from SDE.F425 WH...
1	0	18	0.04	1.54	514nw2y49qcy7	PL/SQL Developer	select /+rule/ * from sys.a...
1	0	261	0.00	1.32	db78fxqxwxt7r		select /+ rule / bucket, en...
1	1	1	0.53	1.21	0390md5wrbws8	PL/SQL Developer	select /+rule/ * from sys.a...
0	0	5,028	0.00	1.01	5qnfuzkcxvg80	gsrvr.exe	SELECT count(*) FROM ALL_CATAL...

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
7	7	9	0.77	16.13	bunssq950snhf		insert into wrh$_sga_target_ad...
4	5	2	1.78	10.62	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
2	3	52	0.04	6.42	4c1xvq9ufwcjc	plsqldev.exe	select count(*) from user$ u...
1	1	1	1.42	3.35	2pgqas6suvysu	gsrvr.exe	SELECT AC.owner, AC.table_nam...
1	12	498	0.00	28.13	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
1	1	108	0.01	2.37	357naahf3rh3j	w3wp.exe	update t_pda_deviceinfo ...
1	9	1	1.03	21.10	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
1	10	360	0.00	22.17	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
1	1	333	0.00	1.61	3g3k6s95772cr	gsrvr.exe	SELECT points from SDE.F425 WH...
1	1	1	0.52	1.21	0390md5wrbws8	PL/SQL Developer	select /+rule/ * from sys.a...
0	0	5,028	0.00	1.01	5qnfuzkcxvg80	gsrvr.exe	SELECT count(*) FROM ALL_CATAL...
0	1	261	0.00	1.32	db78fxqxwxt7r		select /+ rule / bucket, en...
0	1	18	0.02	1.54	514nw2y49qcy7	PL/SQL Developer	select /+rule/ * from sys.a...
0	1	1	0.22	2.88	3ufgtqbyzb1c2	PL/SQL Developer	select /+rule/ object_name,...
0	3	9	0.02	6.93	350myuyx0t1d6		insert into wrh$_tablespace_st...
0	1	9	0.02	2.02	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...

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,287,434
Captured SQL account for 93.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
272,562	18	15,142.33	21.17	0.35	0.67	514nw2y49qcy7	PL/SQL Developer	select /+rule/ * from sys.a...
243,567	2	121,783.50	18.92	3.56	4.62	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
127,421	498	255.87	9.90	1.34	12.24	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
114,002	108	1,055.57	8.85	1.03	1.03	357naahf3rh3j	w3wp.exe	update t_pda_deviceinfo ...
71,064	1	71,064.00	5.52	0.22	1.25	3ufgtqbyzb1c2	PL/SQL Developer	select /+rule/ object_name,...
53,514	52	1,029.12	4.16	1.97	2.79	4c1xvq9ufwcjc	plsqldev.exe	select count(*) from user$ u...
48,942	360	135.95	3.80	0.82	9.65	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
47,353	5,028	9.42	3.68	0.44	0.44	5qnfuzkcxvg80	gsrvr.exe	SELECT count(*) FROM ALL_CATAL...
33,430	1	33,430.00	2.60	1.03	9.18	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
24,753	18	1,375.17	1.92	0.13	0.15	5f4v2996x0tqf	PL/SQL Developer	select /+rule/ * from sys.a...
23,225	1,949	11.92	1.80	0.22	0.22	0h6b2sajwb74n		select privilege#, level from ...
17,539	52	337.29	1.36	0.39	0.39	fjdh242qfjfr6	plsqldev.exe	select count(*) from xdb.xdb...
15,282	5,094	3.00	1.19	0.20	0.20	2ym6hhaq30r73		select type#, blocks, extents,...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 7,500
Captured SQL account for 139.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
4,339	498	8.71	57.85	1.34	12.24	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
4,311	1	4,311.00	57.48	1.03	9.18	89qyn4bbt03jq		SELECT /+ USE_HASH(f a) / SU...
4,311	360	11.98	57.48	0.82	9.65	abtp0uqvdb1d3		CALL MGMT_ADMIN_DATA.EVALUATE_...
473	2	236.50	6.31	3.56	4.62	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
347	1	347.00	4.63	0.22	1.25	3ufgtqbyzb1c2	PL/SQL Developer	select /+rule/ object_name,...
277	52	5.33	3.69	1.97	2.79	4c1xvq9ufwcjc	plsqldev.exe	select count(*) from user$ u...
75	18	4.17	1.00	0.35	0.67	514nw2y49qcy7	PL/SQL Developer	select /+rule/ * from sys.a...
72	261	0.28	0.96	0.38	0.57	db78fxqxwxt7r		select /+ rule / bucket, en...
56	7	8.00	0.75	0.11	0.40	d92h3rjp0y217		begin prvt_hdm.auto_execute( :...
39	1	39.00	0.52	0.05	0.18	bxywuzvtp6wjg	DBMS_SCHEDULER	call dbms_scheduler.auto_purge...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 120,883
Captured SQL account for 57.9% of Total

Executions	Rows Processed	Rows per Exec	SQL Id	SQL Module	SQL Text
5,759	451	0.08	803b7z0t84sq7		select job, nvl2(last_date, ...
5,308	5,308	1.00	g2wr3u7s1gtf3		select count(*) from sys.job$ ...
5,094	5,094	1.00	2ym6hhaq30r73		select type#, blocks, extents,...
5,028	5,028	1.00	5qnfuzkcxvg80	gsrvr.exe	SELECT count(*) FROM ALL_CATAL...
4,918	4,918	1.00	4fa575nmffndz	giomgr.exe	SELECT MAX(layer_id) FROM SDE....
2,657	2,657	1.00	1cjy8v3c0agny		select sys_nc_oid$ from xdb.xd...
2,657	2,657	1.00	23y48d28wkg2r	plsqldev.exe	select value(p$) from "XDB"."X...
2,572	2,572	1.00	8s40a5xb0dxku	JDBC Thin Client	SELECT COUNT(*) FROM ATMS_EQUI...
2,112	2,112	1.00	190hmmfyqv4x5	gsrvr.exe	SELECT layer_id, ly.descripti...
1,949	18,802	9.65	0h6b2sajwb74n		select privilege#, level from ...
1,296	14,373	11.09	66u1ad2gcjhyw	gsrvr.exe	SELECT /* ESRI GDM_8 */ column...
1,296	1,296	1.00	6xnbjh7ff9q8m	gsrvr.exe	SELECT /* ESRI GDM_6 */ regist...
1,281	905	0.71	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,272	0	0.00	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
1,272	1,254	0.99	g00cj285jmgsw		update sys.mon_mods$ set inser...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 59,010
Captured SQL account for 59.4% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
5,094	5,094	8.63	2ym6hhaq30r73		select type#, blocks, extents,...
4,918	4,918	8.33	4fa575nmffndz	giomgr.exe	SELECT MAX(layer_id) FROM SDE....
2,657	2,657	4.50	1cjy8v3c0agny		select sys_nc_oid$ from xdb.xd...
2,112	2,112	3.58	190hmmfyqv4x5	gsrvr.exe	SELECT layer_id, ly.descripti...
1,949	1,949	3.30	0h6b2sajwb74n		select privilege#, level from ...
1,272	1,272	2.16	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
1,272	1,272	2.16	g00cj285jmgsw		update sys.mon_mods$ set inser...
764	764	1.29	0k8522rmdzg4k		select privilege# from sysauth...
699	738	1.18	5hj807mgq220t	gsrvr.exe	SELECT /*+ LEADING INDEX(S_ S4...
507	507	0.86	47a50dvdgnxc2		update sys.job$ set failures=0...

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

0390md5wrbws8 select /*+rule*/ * from sys.all_objects o where object_type = 'TABLE' and object_name not like 'BIN$%' and not exists (select * from sys.all_tables at where at.table_name = o.object_name and at.owner = o.owner and at.dropped = 'YES') and (owner = user) order by decode(owner, user, 0, 1), owner, object_name

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

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

190hmmfyqv4x5 SELECT layer_id, ly.description, gsize1, gsize2, gsize3, minx, miny, maxx, maxy, minz, minm, maxz, maxm, eflags, layer_mask, database_name, table_name, owner, spatial_column, cdate, layer_config, optimal_array_size, stats_date, minimum_id, base_layer_id, sr.falsex, sr.falsey, sr.xyunits, sr.falsez, sr.zunits, sr.falsem, sr.munits, sr.srtext, ly.srid, sr.object_flags, sr.xycluster_tol, sr.zcluster_tol, sr.mcluster_tol, sr2.falsex, sr2.falsey, sr2.xyunits, sr2.falsez, sr2.zunits, sr2.falsem, sr2.munits, ly.secondary_srid, sr2.object_flags FROM SDE.LAYERS ly LEFT OUTER JOIN SDE.spatial_references sr2 ON ly.secondary_srid = sr2.srid, SDE.spatial_references sr WHERE ly.srid = sr.srid AND ly.table_name = :table_name AND spatial_column = :column_name AND ly.owner = :owner_name

1cjy8v3c0agny select sys_nc_oid$ from xdb.xdb$resource where rowid = :1

23y48d28wkg2r select value(p$) from "XDB"."XDB$RESOURCE" as of snapshot(:2) p$ where SYS_NC_OID$ = :1

2pgqas6suvysu SELECT AC.owner, AC.table_name FROM ALL_CATALOG AC WHERE AC.owner != 'MTSSYS' AND AC.owner != 'SYS' AND AC.owner != 'SYSTEM' AND AC.owner != 'PERFSTAT' AND AC.owner != 'DMSYS' AND AC.owner != 'EXFSYS' AND AC.owner != 'WK_TEST' AND AC.owner != 'PUBLIC' AND AC.owner != 'SYSMAN' AND AC.owner != 'SI_INFORMTN_SCHEMA' AND AC.owner != 'MDSYS' AND AC.owner != 'ORDSYS' AND AC.table_type != 'SEQUENCE' AND AC.table_name != 'RASTER_COLUMNS' AND AC.table_name != 'RECONCILED_STATES' AND AC.table_name != 'SDO_GEOM_METADATA' AND AC.table_name NOT LIKE 'F%_SQL_IX1_%' AND AC.table_name NOT LIKE 'S%_IDX$' AND AC.table_name NOT LIKE 'S%_PX$' AND AC.table_name NOT LIKE '%_IX1_%$' AND AC.table_name NOT LIKE '%_F%$' AND AC.table_name NOT LIKE '%_H%$' AND AC.table_name NOT LIKE '%_RT$%' AND AC.table_name NOT LIKE '%_SDOLAYER' AND AC.table_name NOT LIKE '%_SDODIM' AND AC.table_name NOT LIKE '%_SDOGEOM' AND AC.table_name NOT LIKE '%_SDOINDEX' AND AC.table_name NOT LIKE '%RT_%$' AND AC.table_name NOT LIKE '%QT_%$' AND AC.table_name NOT LIKE '%BIN$%' AND AC.table_name NOT LIKE 'SDE/_%' ESCAPE '/' AND AC.table_name NOT LIKE 'DR$XML%' AND AC.table_name NOT LIKE 'KEYSET_%' AND AC.owner != 'AURORA$JIS$UTILITY$' AND AC.owner != 'OSE$HTTP$ADMIN' AND AC.owner != 'QS' AND AC.owner != 'QS_CBADM' AND AC.owner != 'QS_CS' AND AC.owner != 'QS_ES' AND AC.owner != 'QS_OS' AND AC.owner != 'QS_WS' AND AC.owner != 'WMSYS' AND AC.owner != 'XDB' AND AC.owner != 'WKSYS' AND AC.owner != 'OLAPSYS' AND AC.owner != 'RMAN' AND AC.owner != 'ODM' AND AC.owner != 'ODM_MRT' AND AC.owner != 'DBSNMP' AND AC.owner != 'OUTLN' AND AC.owner != 'CTXSYS' AND NOT (AC.OWNER IN (SELECT instance_name FROM SDE.INSTANCES) AND AC.table_name IN ('COLUMN_REGISTRY', 'GEOMETRY_COLUMNS', 'LAYERS', 'LOCATORS', 'METADATA', 'GCDRULES', 'MVTABLES_MODIFIED', 'SDE_LOGFILES', 'SDE_LOGFILE_DATA', 'SPATIAL_REFERENCES', 'STATE_LINEAGES', 'STATES', 'STATE_ID_GENERATOR', 'TABLE_REGISTRY', 'VERSION', 'VERSIONS', 'DBTUNE', 'LAYER_LOCKS', 'OBJECT_LOCKS', 'PROCESS_INFORMATION', 'SDE_TABLES_MODIFIED', 'STATE_LOCKS', 'TABLE_LOCKS', 'LINEAGES_MODIFIED', 'SERVER_CONFIG', 'SDE_XML_TAGS', 'SDE_XML_INDEX_TAGS', 'SDE_XML_INDEXES', 'SDE_XML_COLUMNS', 'SDE_LOGFILE_POOL', 'INSTANCES', 'ALL_ST_GEOMETRY_COLUMNS_V', 'ST_COORDINATE_SYSTEMS', 'ST_GEOMETRY_COLUMNS', 'ST_GEOMETRY_INDEX', 'ST_SPATIAL_REFERENCES', 'USER_ST_GEOM_INDEX_V', 'USER_ST_GEOMETRY_COLUMNS_V', 'ST_UNITS_OF_MEASURE') ) ORDER BY AC.owner, AC.table_name

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

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

350myuyx0t1d6 insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#

357naahf3rh3j update t_pda_deviceinfo set devicestate=1 where deviceid in ( select deviceid from t_pda_deviceinfo where updatetime is not null and ceil((sysdate-updatetime) * 24 * 60)>5)

3g3k6s95772cr SELECT points from SDE.F425 WHERE ROWID = :fid_rowid

3ufgtqbyzb1c2 select /*+rule*/ object_name, owner object_owner, status, object_type, created, last_ddl_time from sys.all_objects o where object_type = 'TABLE' and object_name not like 'BIN$%' order by decode(owner, user, 0, 1), owner, object_name

47a50dvdgnxc2 update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4

4c1xvq9ufwcjc select count(*) from user$ u, xdb.xdb$schema s where u.user# = :1 and u.name = s.xmldata.schema_owner and (xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :2)

4fa575nmffndz SELECT MAX(layer_id) FROM SDE.LAYERS

514nw2y49qcy7 select /*+rule*/ * from sys.all_constraints where table_name = :object_name and owner = :object_owner and constraint_type in ('P', 'U', 'R', 'C') order by decode(constraint_type, 'P', 0, 'U', 1, 'R', 2, 3), constraint_name

5f4v2996x0tqf select /*+rule*/ * from sys.all_tab_partitions where table_name = :object_name and table_owner = :object_owner and trim(composite) in ('NO', 'N0') order by partition_position

5hj807mgq220t SELECT /*+ LEADING INDEX(S_ S425_IX1) INDEX(SHAPE F425_UK1) INDEX(滨州市界 A425_IX1) */ SDE.滨州市界.OBJECTID, SDE.滨州市界.OBJECTID, SDE.滨州市界.FLDM, SDE.滨州市界.GBDM, SDE.滨州市界.MC, SDE.滨州市界.GXSJ, SDE.滨州市界.ZXZQDM, SDE.滨州市界.YXZQDM, SDE.滨州市界.SHAPE , S_.eminx, S_.eminy, S_.emaxx, S_.emaxy , SHAPE.fid, SHAPE.numofpts, SHAPE.entity, SHAPE.points, SHAPE.rowid FROM (SELECT /*+ INDEX(SP_ S425_IX1) */ DISTINCT sp_fid, eminx, eminy, emaxx, emaxy FROM SDE.S425 SP_ WHERE SP_.gx >= :1 AND SP_.gx <= :2 AND SP_.gy >= :3 AND SP_.gy <= :4 AND SP_.eminx <= :5 AND SP_.eminy <= :6 AND SP_.emaxx >= :7 AND SP_.emaxy >= :8) S_ , SDE.滨州市界 , SDE.F425 SHAPE WHERE S_.sp_fid = SHAPE.fid AND S_.sp_fid = SDE.滨州市界.SHAPE

5qnfuzkcxvg80 SELECT count(*) FROM ALL_CATALOG WHERE owner = :owner AND table_name = :table_name

66u1ad2gcjhyw SELECT /* ESRI GDM_8 */ column_name, sde_type, column_size, decimal_digits, object_flags, object_id, description FROM SDE.column_registry WHERE owner = :owner AND table_name = :table_name

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;

6xnbjh7ff9q8m SELECT /* ESRI GDM_6 */ registration_id, table_name, owner, rowid_column, description, object_flags, registration_date, config_keyword, minimum_id, imv_view_name FROM SDE.table_registry WHERE owner = :owner AND table_name = :table_name

7vgmvmy8vvb9s insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)

803b7z0t84sq7 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

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

8s40a5xb0dxku SELECT COUNT(*) FROM ATMS_EQUIPMENT_DICT WHERE ID=:B2 AND TYPE=:B1

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

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

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

bxywuzvtp6wjg call dbms_scheduler.auto_purge ( )

c8khjbn635s3c select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) 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')

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

db78fxqxwxt7r select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket

fjdh242qfjfr6 select count(*) from xdb.xdb$schema s where bitand(to_number(s.xmldata.flags, 'xxxxxxxx'), 16) = 16 and xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :1 and s.xmldata.schema_url not in (select s2.xmldata.schema_url from xdb.xdb$schema s2, user$ u2 where u2.user# = :2 and u2.name = s.xmldata.schema_owner)

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
0390md5wrbws8	select /+rule/ * from sys.all_objects o where object_type = 'TABLE' and object_name not like 'BIN$%' and not exists (select * from sys.all_tables at where at.table_name = o.object_name and at.owner = o.owner and at.dropped = 'YES') and (owner = user) order by decode(owner, user, 0, 1), owner, object_name
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
190hmmfyqv4x5	SELECT layer_id, ly.description, gsize1, gsize2, gsize3, minx, miny, maxx, maxy, minz, minm, maxz, maxm, eflags, layer_mask, database_name, table_name, owner, spatial_column, cdate, layer_config, optimal_array_size, stats_date, minimum_id, base_layer_id, sr.falsex, sr.falsey, sr.xyunits, sr.falsez, sr.zunits, sr.falsem, sr.munits, sr.srtext, ly.srid, sr.object_flags, sr.xycluster_tol, sr.zcluster_tol, sr.mcluster_tol, sr2.falsex, sr2.falsey, sr2.xyunits, sr2.falsez, sr2.zunits, sr2.falsem, sr2.munits, ly.secondary_srid, sr2.object_flags FROM SDE.LAYERS ly LEFT OUTER JOIN SDE.spatial_references sr2 ON ly.secondary_srid = sr2.srid, SDE.spatial_references sr WHERE ly.srid = sr.srid AND ly.table_name = :table_name AND spatial_column = :column_name AND ly.owner = :owner_name
1cjy8v3c0agny	select sys_nc_oid$ from xdb.xdb$resource where rowid = :1
23y48d28wkg2r	select value(p$) from "XDB"."XDB$RESOURCE" as of snapshot(:2) p$ where SYS_NC_OID$ = :1
2pgqas6suvysu	SELECT AC.owner, AC.table_name FROM ALL_CATALOG AC WHERE AC.owner != 'MTSSYS' AND AC.owner != 'SYS' AND AC.owner != 'SYSTEM' AND AC.owner != 'PERFSTAT' AND AC.owner != 'DMSYS' AND AC.owner != 'EXFSYS' AND AC.owner != 'WK_TEST' AND AC.owner != 'PUBLIC' AND AC.owner != 'SYSMAN' AND AC.owner != 'SI_INFORMTN_SCHEMA' AND AC.owner != 'MDSYS' AND AC.owner != 'ORDSYS' AND AC.table_type != 'SEQUENCE' AND AC.table_name != 'RASTER_COLUMNS' AND AC.table_name != 'RECONCILED_STATES' AND AC.table_name != 'SDO_GEOM_METADATA' AND AC.table_name NOT LIKE 'F%_SQL_IX1_%' AND AC.table_name NOT LIKE 'S%_IDX$' AND AC.table_name NOT LIKE 'S%_PX$' AND AC.table_name NOT LIKE '%_IX1_%$' AND AC.table_name NOT LIKE '%_F%$' AND AC.table_name NOT LIKE '%_H%$' AND AC.table_name NOT LIKE '%_RT$%' AND AC.table_name NOT LIKE '%_SDOLAYER' AND AC.table_name NOT LIKE '%_SDODIM' AND AC.table_name NOT LIKE '%_SDOGEOM' AND AC.table_name NOT LIKE '%_SDOINDEX' AND AC.table_name NOT LIKE '%RT_%$' AND AC.table_name NOT LIKE '%QT_%$' AND AC.table_name NOT LIKE '%BIN$%' AND AC.table_name NOT LIKE 'SDE/_%' ESCAPE '/' AND AC.table_name NOT LIKE 'DR$XML%' AND AC.table_name NOT LIKE 'KEYSET_%' AND AC.owner != 'AURORA$JIS$UTILITY$' AND AC.owner != 'OSE$HTTP$ADMIN' AND AC.owner != 'QS' AND AC.owner != 'QS_CBADM' AND AC.owner != 'QS_CS' AND AC.owner != 'QS_ES' AND AC.owner != 'QS_OS' AND AC.owner != 'QS_WS' AND AC.owner != 'WMSYS' AND AC.owner != 'XDB' AND AC.owner != 'WKSYS' AND AC.owner != 'OLAPSYS' AND AC.owner != 'RMAN' AND AC.owner != 'ODM' AND AC.owner != 'ODM_MRT' AND AC.owner != 'DBSNMP' AND AC.owner != 'OUTLN' AND AC.owner != 'CTXSYS' AND NOT (AC.OWNER IN (SELECT instance_name FROM SDE.INSTANCES) AND AC.table_name IN ('COLUMN_REGISTRY', 'GEOMETRY_COLUMNS', 'LAYERS', 'LOCATORS', 'METADATA', 'GCDRULES', 'MVTABLES_MODIFIED', 'SDE_LOGFILES', 'SDE_LOGFILE_DATA', 'SPATIAL_REFERENCES', 'STATE_LINEAGES', 'STATES', 'STATE_ID_GENERATOR', 'TABLE_REGISTRY', 'VERSION', 'VERSIONS', 'DBTUNE', 'LAYER_LOCKS', 'OBJECT_LOCKS', 'PROCESS_INFORMATION', 'SDE_TABLES_MODIFIED', 'STATE_LOCKS', 'TABLE_LOCKS', 'LINEAGES_MODIFIED', 'SERVER_CONFIG', 'SDE_XML_TAGS', 'SDE_XML_INDEX_TAGS', 'SDE_XML_INDEXES', 'SDE_XML_COLUMNS', 'SDE_LOGFILE_POOL', 'INSTANCES', 'ALL_ST_GEOMETRY_COLUMNS_V', 'ST_COORDINATE_SYSTEMS', 'ST_GEOMETRY_COLUMNS', 'ST_GEOMETRY_INDEX', 'ST_SPATIAL_REFERENCES', 'USER_ST_GEOM_INDEX_V', 'USER_ST_GEOMETRY_COLUMNS_V', 'ST_UNITS_OF_MEASURE') ) ORDER BY AC.owner, AC.table_name
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
350f5yrnnmshs	lock table sys.mon_mods$ in exclusive mode nowait
350myuyx0t1d6	insert into wrh$_tablespace_stat (snap_id, dbid, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup) select :snap_id, :dbid, :instance_number, ts.ts#, ts.name as tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(ts.online$, 1, 'ONLINE', 2, 'OFFLINE', 4, 'READ ONLY', 'UNDEFINED') as status, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management, (case when b.active_count > 0 then 'TRUE' else 'FALSE' end) as is_backup from sys.ts$ ts, (select dfile.ts#, sum( case when bkup.status = 'ACTIVE' then 1 else 0 end ) as active_count from v$backup bkup, file$ dfile where bkup.file# = dfile.file# and dfile.status$ = 2 group by dfile.ts#) b where ts.online$ != 3 and bitand(ts.flags, 2048) != 2048 and ts.ts# = b.ts#
357naahf3rh3j	update t_pda_deviceinfo set devicestate=1 where deviceid in ( select deviceid from t_pda_deviceinfo where updatetime is not null and ceil((sysdate-updatetime) * 24 * 60)>5)
3g3k6s95772cr	SELECT points from SDE.F425 WHERE ROWID = :fid_rowid
3ufgtqbyzb1c2	select /+rule/ object_name, owner object_owner, status, object_type, created, last_ddl_time from sys.all_objects o where object_type = 'TABLE' and object_name not like 'BIN$%' order by decode(owner, user, 0, 1), owner, object_name
47a50dvdgnxc2	update sys.job$ set failures=0, this_date=null, flag=:1, last_date=:2, next_date = greatest(:3, sysdate), total=total+(sysdate-nvl(this_date, sysdate)) where job=:4
4c1xvq9ufwcjc	select count(*) from user$ u, xdb.xdb$schema s where u.user# = :1 and u.name = s.xmldata.schema_owner and (xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :2)
4fa575nmffndz	SELECT MAX(layer_id) FROM SDE.LAYERS
514nw2y49qcy7	select /+rule/ * from sys.all_constraints where table_name = :object_name and owner = :object_owner and constraint_type in ('P', 'U', 'R', 'C') order by decode(constraint_type, 'P', 0, 'U', 1, 'R', 2, 3), constraint_name
5f4v2996x0tqf	select /+rule/ * from sys.all_tab_partitions where table_name = :object_name and table_owner = :object_owner and trim(composite) in ('NO', 'N0') order by partition_position
5hj807mgq220t	SELECT /+ LEADING INDEX(S_ S425_IX1) INDEX(SHAPE F425_UK1) INDEX(滨州市界 A425_IX1) / SDE.滨州市界.OBJECTID, SDE.滨州市界.OBJECTID, SDE.滨州市界.FLDM, SDE.滨州市界.GBDM, SDE.滨州市界.MC, SDE.滨州市界.GXSJ, SDE.滨州市界.ZXZQDM, SDE.滨州市界.YXZQDM, SDE.滨州市界.SHAPE , S_.eminx, S_.eminy, S_.emaxx, S_.emaxy , SHAPE.fid, SHAPE.numofpts, SHAPE.entity, SHAPE.points, SHAPE.rowid FROM (SELECT /+ INDEX(SP_ S425_IX1) / DISTINCT sp_fid, eminx, eminy, emaxx, emaxy FROM SDE.S425 SP_ WHERE SP_.gx >= :1 AND SP_.gx <= :2 AND SP_.gy >= :3 AND SP_.gy <= :4 AND SP_.eminx <= :5 AND SP_.eminy <= :6 AND SP_.emaxx >= :7 AND SP_.emaxy >= :8) S_ , SDE.滨州市界 , SDE.F425 SHAPE WHERE S_.sp_fid = SHAPE.fid AND S_.sp_fid = SDE.滨州市界.SHAPE
5qnfuzkcxvg80	SELECT count(*) FROM ALL_CATALOG WHERE owner = :owner AND table_name = :table_name
66u1ad2gcjhyw	SELECT /* ESRI GDM_8 */ column_name, sde_type, column_size, decimal_digits, object_flags, object_id, description FROM SDE.column_registry WHERE owner = :owner AND table_name = :table_name
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;
6xnbjh7ff9q8m	SELECT /* ESRI GDM_6 */ registration_id, table_name, owner, rowid_column, description, object_flags, registration_date, config_keyword, minimum_id, imv_view_name FROM SDE.table_registry WHERE owner = :owner AND table_name = :table_name
7vgmvmy8vvb9s	insert into wrh$_tempstatxs (snap_id, dbid, instance_number, file#, creation_change#, phyrds, phywrts, singleblkrds, readtim, writetim, singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time) select :snap_id, :dbid, :instance_number, tf.tfnum, to_number(tf.tfcrc_scn) creation_change#, ts.kcftiopyr, ts.kcftiopyw, ts.kcftiosbr, ts.kcftioprt, ts.kcftiopwt, ts.kcftiosbt, ts.kcftiopbr, ts.kcftiopbw, fw.count, fw.time from x$kcftio ts, x$kcctf tf, x$kcbfwait fw where tf.tfdup != 0 and tf.tfnum = ts.kcftiofno and fw.indx+1 = (ts.kcftiofno + :db_files)
803b7z0t84sq7	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
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
8s40a5xb0dxku	SELECT COUNT(*) FROM ATMS_EQUIPMENT_DICT WHERE ID=:B2 AND TYPE=:B1
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
abtp0uqvdb1d3	CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:tguid, :mguid, :result)
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
bxywuzvtp6wjg	call dbms_scheduler.auto_purge ( )
c8khjbn635s3c	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) 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')
d92h3rjp0y217	begin prvt_hdm.auto_execute( :db_id, :inst_id, :end_snap ); end;
db78fxqxwxt7r	select /+ rule / bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
fjdh242qfjfr6	select count(*) from xdb.xdb$schema s where bitand(to_number(s.xmldata.flags, 'xxxxxxxx'), 16) = 16 and xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :1 and s.xmldata.schema_url not in (select s2.xmldata.schema_url from xdb.xdb$schema s2, user$ u2 where u2.user# = :2 and u2.name = s.xmldata.schema_owner)
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	2,804	0.09	0.83
CPU used when call started	2,450	0.08	0.72
CR blocks created	334	0.01	0.10
DB time	3,004,672	92.83	887.12
DBWR checkpoint buffers written	9,956	0.31	2.94
DBWR checkpoints	1	0.00	0.00
DBWR object drop buffers written	4	0.00	0.00
DBWR transaction table writes	570	0.02	0.17
DBWR undo block writes	1,821	0.06	0.54
IMU CR rollbacks	252	0.01	0.07
IMU Flushes	503	0.02	0.15
IMU Redo allocation size	7,601,456	234.84	2,244.30
IMU commits	2,900	0.09	0.86
IMU contention	2	0.00	0.00
IMU recursive-transaction flush	2	0.00	0.00
IMU undo allocation size	14,655,108	452.76	4,326.87
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	45,795	1.41	13.52
active txn count during cleanout	271	0.01	0.08
application wait time	1	0.00	0.00
background timeouts	135,986	4.20	40.15
buffer is not pinned count	827,497	25.56	244.32
buffer is pinned count	733,610	22.66	216.60
bytes received via SQL*Net from client	15,779,359	487.49	4,658.80
bytes sent via SQL*Net to client	87,331,634	2,698.05	25,784.36
calls to get snapshot scn: kcmgss	172,696	5.34	50.99
calls to kcmgas	12,034	0.37	3.55
calls to kcmgcs	532	0.02	0.16
change write time	55	0.00	0.02
cleanout - number of ktugct calls	335	0.01	0.10
cleanouts and rollbacks - consistent read gets	36	0.00	0.01
cleanouts only - consistent read gets	11	0.00	0.00
cluster key scan block gets	75,125	2.32	22.18
cluster key scans	28,595	0.88	8.44
commit batch/immediate performed	3	0.00	0.00
commit batch/immediate requested	3	0.00	0.00
commit cleanout failures: callback failure	35	0.00	0.01
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	17,841	0.55	5.27
commit cleanouts successfully completed	17,806	0.55	5.26
commit immediate performed	3	0.00	0.00
commit immediate requested	3	0.00	0.00
commit txn count during cleanout	170	0.01	0.05
concurrency wait time	197	0.01	0.06
consistent changes	315	0.01	0.09
consistent gets	1,175,821	36.33	347.16
consistent gets - examination	543,701	16.80	160.53
consistent gets direct	365	0.01	0.11
consistent gets from cache	1,175,456	36.31	347.05
cursor authentications	613	0.02	0.18
data blocks consistent reads - undo records applied	315	0.01	0.09
db block changes	154,950	4.79	45.75
db block gets	111,613	3.45	32.95
db block gets direct	17	0.00	0.01
db block gets from cache	111,596	3.45	32.95
deferred (CURRENT) block cleanout applications	10,454	0.32	3.09
enqueue conversions	6,539	0.20	1.93
enqueue releases	294,714	9.10	87.01
enqueue requests	294,749	9.11	87.02
enqueue timeouts	34	0.00	0.01
enqueue waits	1	0.00	0.00
execute count	120,883	3.73	35.69
free buffer requested	9,155	0.28	2.70
heap block compress	247	0.01	0.07
immediate (CR) block cleanout applications	47	0.00	0.01
immediate (CURRENT) block cleanout applications	3,749	0.12	1.11
index fast full scans (full)	8	0.00	0.00
index fetch by key	297,998	9.21	87.98
index scans kdiixs1	190,163	5.87	56.14
leaf node 90-10 splits	68	0.00	0.02
leaf node splits	125	0.00	0.04
lob reads	653	0.02	0.19
lob writes	106	0.00	0.03
lob writes unaligned	106	0.00	0.03
logons cumulative	1,234	0.04	0.36
messages received	13,468	0.42	3.98
messages sent	13,468	0.42	3.98
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	411,913	12.73	121.62
opened cursors cumulative	61,735	1.91	18.23
parse count (failures)	83	0.00	0.02
parse count (hard)	2,333	0.07	0.69
parse count (total)	59,010	1.82	17.42
parse time cpu	293	0.01	0.09
parse time elapsed	420	0.01	0.12
physical read IO requests	6,087	0.19	1.80
physical read bytes	61,440,000	1,898.15	18,139.95
physical read total IO requests	14,152	0.44	4.18
physical read total bytes	189,448,192	5,852.87	55,933.92
physical read total multi block requests	206	0.01	0.06
physical reads	7,500	0.23	2.21
physical reads cache	7,135	0.22	2.11
physical reads cache prefetch	1,413	0.04	0.42
physical reads direct	365	0.01	0.11
physical reads direct (lob)	348	0.01	0.10
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	227	0.01	0.07
physical write IO requests	7,570	0.23	2.24
physical write bytes	81,756,160	2,525.80	24,138.22
physical write total IO requests	46,089	1.42	13.61
physical write total bytes	640,283,648	19,781.12	189,041.53
physical write total multi block requests	6,345	0.20	1.87
physical writes	9,980	0.31	2.95
physical writes direct	17	0.00	0.01
physical writes direct (lob)	17	0.00	0.01
physical writes from cache	9,963	0.31	2.94
physical writes non checkpoint	1,406	0.04	0.42
process last non-idle time	32,338	1.00	9.55
recovery blocks read	0	0.00	0.00
recursive calls	593,347	18.33	175.18
recursive cpu usage	1,705	0.05	0.50
redo blocks read for recovery	0	0.00	0.00
redo blocks written	55,130	1.70	16.28
redo entries	66,638	2.06	19.67
redo ordering marks	314	0.01	0.09
redo size	25,353,672	783.28	7,485.58
redo synch time	81	0.00	0.02
redo synch writes	16,615	0.51	4.91
redo wastage	1,796,816	55.51	530.50
redo write time	167	0.01	0.05
redo writer latching time	1	0.00	0.00
redo writes	6,140	0.19	1.81
rollback changes - undo records applied	6	0.00	0.00
rollbacks only - consistent read gets	278	0.01	0.08
rows fetched via callback	205,695	6.35	60.73
session connect time	0	0.00	0.00
session cursor cache hits	30,078	0.93	8.88
session logical reads	1,287,434	39.77	380.11
session pga memory	498,170,696	15,390.64	147,083.17
session pga memory max	593,722,184	18,342.64	175,294.42
session uga memory	###############	69,928,727.73	668,285,376.17
session uga memory max	579,324,048	17,897.82	171,043.42
shared hash latch upgrades - no wait	194,766	6.02	57.50
sorts (memory)	21,561	0.67	6.37
sorts (rows)	447,286	13.82	132.06
sql area purged	15	0.00	0.00
switch current to new buffer	931	0.03	0.27
table fetch by rowid	452,252	13.97	133.53
table fetch continued row	11,707	0.36	3.46
table scan blocks gotten	83,206	2.57	24.57
table scan rows gotten	3,010,220	93.00	888.76
table scans (long tables)	0	0.00	0.00
table scans (short tables)	8,173	0.25	2.41
total number of times SMON posted	5	0.00	0.00
transaction rollbacks	3	0.00	0.00
undo change vector size	8,579,876	265.07	2,533.18
user I/O wait time	1,842	0.06	0.54
user calls	64,853	2.00	19.15
user commits	3,367	0.10	0.99
user rollbacks	20	0.00	0.01
workarea executions - optimal	11,552	0.36	3.41
write clones created in background	3	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session cursor cache count	1,607	11,970
opened cursors current	237	330
logons current	60	62

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)	0	0.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	Av Buf Wt(ms)
SYSAUX	241	5.93	1.99	4,718	0	0.00
SDE	2,761	1.76	1.02	95	0	0.00
SYSTEM	864	4.36	1.12	1,378	8	6.25
UNDOTBS1	2	5.00	1.00	1,171	8	0.00
EHL_ITGS	998	1.57	1.00	0	0	0.00
USERS	643	4.06	2.61	206	21	4.29
EHL_WEB	38	4.21	1.00	0	0	0.00
INDEX12	35	3.43	1.00	0	0	0.00
INDEX01	30	3.67	1.00	0	0	0.00
INDEX02	30	3.33	1.00	0	0	0.00
INDEX03	30	3.00	1.00	0	0	0.00
INDEX04	30	3.67	1.00	0	0	0.00
INDEX05	30	3.00	1.00	0	0	0.00
INDEX06	30	3.00	1.00	0	0	0.00
INDEX07	30	3.33	1.00	0	0	0.00
INDEX08	30	2.67	1.00	0	0	0.00
INDEX09	30	3.33	1.00	0	0	0.00
INDEX10	30	3.33	1.00	0	0	0.00
INDEX11	30	3.67	1.00	0	0	0.00
GPS5	11	5.45	1.00	0	0	0.00
GPS4	10	2.00	1.00	0	0	0.00
GPS1	7	2.86	1.00	0	0	0.00
GPS2	7	2.86	1.00	0	0	0.00
GPS3	7	4.29	1.00	0	0	0.00
TFWTAB12	7	1.43	1.00	0	0	0.00
TPCTAB12	7	5.71	1.00	0	0	0.00
TFWTAB01	6	3.33	1.00	0	0	0.00
TFWTAB02	6	3.33	1.00	0	0	0.00
TFWTAB03	6	3.33	1.00	0	0	0.00
TFWTAB04	6	3.33	1.00	0	0	0.00
TFWTAB05	6	5.00	1.00	0	0	0.00
TFWTAB06	6	1.67	1.00	0	0	0.00
TFWTAB07	6	6.67	1.00	0	0	0.00
TFWTAB08	6	3.33	1.00	0	0	0.00
TFWTAB09	6	3.33	1.00	0	0	0.00
TFWTAB10	6	3.33	1.00	0	0	0.00
TFWTAB11	6	3.33	1.00	0	0	0.00
TPCTAB01	6	5.00	1.00	0	0	0.00
TPCTAB02	6	3.33	1.00	0	0	0.00
TPCTAB03	6	3.33	1.00	0	0	0.00
TPCTAB04	6	3.33	1.00	0	0	0.00
TPCTAB05	6	6.67	1.00	0	0	0.00
TPCTAB06	6	3.33	1.00	0	0	0.00
TPCTAB07	6	3.33	1.00	0	0	0.00
TPCTAB08	6	3.33	1.00	0	0	0.00
TPCTAB09	6	3.33	1.00	0	0	0.00
TPCTAB10	6	3.33	1.00	0	0	0.00
TPCTAB11	6	3.33	1.00	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
EHL_ITGS	D:\ORACLE\ORADATA\ORCL\EHL_ITGS.DBF	998	1.57	1.00	0	0	0.00
EHL_WEB	D:\ORACLE\ORADATA\ORCL\EHL_WEB.DBF	38	4.21	1.00	0	0	0.00
GPS1	D:\ORACLE\ORADATA\ORCL\GPS1.DBF	7	2.86	1.00	0	0	0.00
GPS2	D:\ORACLE\ORADATA\ORCL\GPS2.DBF	7	2.86	1.00	0	0	0.00
GPS3	D:\ORACLE\ORADATA\ORCL\GPS3.DBF	7	4.29	1.00	0	0	0.00
GPS4	D:\ORACLE\ORADATA\ORCL\GPS4.DBF	10	2.00	1.00	0	0	0.00
GPS5	D:\ORACLE\ORADATA\ORCL\GPS5.DBF	11	5.45	1.00	0	0	0.00
INDEX01	D:\ORACLE\ORADATA\ORCL\INDEX01.DBF	30	3.67	1.00	0	0	0.00
INDEX02	D:\ORACLE\ORADATA\ORCL\INDEX02.DBF	30	3.33	1.00	0	0	0.00
INDEX03	D:\ORACLE\ORADATA\ORCL\INDEX03.DBF	30	3.00	1.00	0	0	0.00
INDEX04	D:\ORACLE\ORADATA\ORCL\INDEX04.DBF	30	3.67	1.00	0	0	0.00
INDEX05	D:\ORACLE\ORADATA\ORCL\INDEX05.DBF	30	3.00	1.00	0	0	0.00
INDEX06	D:\ORACLE\ORADATA\ORCL\INDEX06.DBF	30	3.00	1.00	0	0	0.00
INDEX07	D:\ORACLE\ORADATA\ORCL\INDEX07.DBF	30	3.33	1.00	0	0	0.00
INDEX08	D:\ORACLE\ORADATA\ORCL\INDEX08.DBF	30	2.67	1.00	0	0	0.00
INDEX09	D:\ORACLE\ORADATA\ORCL\INDEX09.DBF	30	3.33	1.00	0	0	0.00
INDEX10	D:\ORACLE\ORADATA\ORCL\INDEX10.DBF	30	3.33	1.00	0	0	0.00
INDEX11	D:\ORACLE\ORADATA\ORCL\INDEX11.DBF	30	3.67	1.00	0	0	0.00
INDEX12	D:\ORACLE\ORADATA\ORCL\INDEX12.DBF	35	3.43	1.00	0	0	0.00
SDE	D:\ORACLE\ORADATA\ORCL\SDE.DBF	2,761	1.76	1.02	95	0	0.00
SYSAUX	D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF	241	5.93	1.99	4,718	0	0.00
SYSTEM	D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF	864	4.36	1.12	1,378	8	6.25
TFWTAB01	D:\ORACLE\ORADATA\ORCL\TFWTAB01.DBF	6	3.33	1.00	0	0	0.00
TFWTAB02	D:\ORACLE\ORADATA\ORCL\TFWTAB02.DBF	6	3.33	1.00	0	0	0.00
TFWTAB03	D:\ORACLE\ORADATA\ORCL\TFWTAB03.DBF	6	3.33	1.00	0	0	0.00
TFWTAB04	D:\ORACLE\ORADATA\ORCL\TFWTAB04.DBF	6	3.33	1.00	0	0	0.00
TFWTAB05	D:\ORACLE\ORADATA\ORCL\TFWTAB05.DBF	6	5.00	1.00	0	0	0.00
TFWTAB06	D:\ORACLE\ORADATA\ORCL\TFWTAB06.DBF	6	1.67	1.00	0	0	0.00
TFWTAB07	D:\ORACLE\ORADATA\ORCL\TFWTAB07.DBF	6	6.67	1.00	0	0	0.00
TFWTAB08	D:\ORACLE\ORADATA\ORCL\TFWTAB08.DBF	6	3.33	1.00	0	0	0.00
TFWTAB09	D:\ORACLE\ORADATA\ORCL\TFWTAB09.DBF	6	3.33	1.00	0	0	0.00
TFWTAB10	D:\ORACLE\ORADATA\ORCL\TFWTAB10.DBF	6	3.33	1.00	0	0	0.00
TFWTAB11	D:\ORACLE\ORADATA\ORCL\TFWTAB11.DBF	6	3.33	1.00	0	0	0.00
TFWTAB12	D:\ORACLE\ORADATA\ORCL\TFWTAB12.DBF	7	1.43	1.00	0	0	0.00
TPCTAB01	D:\ORACLE\ORADATA\ORCL\TPCTAB01.DBF	6	5.00	1.00	0	0	0.00
TPCTAB02	D:\ORACLE\ORADATA\ORCL\TPCTAB02.DBF	6	3.33	1.00	0	0	0.00
TPCTAB03	D:\ORACLE\ORADATA\ORCL\TPCTAB03.DBF	6	3.33	1.00	0	0	0.00
TPCTAB04	D:\ORACLE\ORADATA\ORCL\TPCTAB04.DBF	6	3.33	1.00	0	0	0.00
TPCTAB05	D:\ORACLE\ORADATA\ORCL\TPCTAB05.DBF	6	6.67	1.00	0	0	0.00
TPCTAB06	D:\ORACLE\ORADATA\ORCL\TPCTAB06.DBF	6	3.33	1.00	0	0	0.00
TPCTAB07	D:\ORACLE\ORADATA\ORCL\TPCTAB07.DBF	6	3.33	1.00	0	0	0.00
TPCTAB08	D:\ORACLE\ORADATA\ORCL\TPCTAB08.DBF	6	3.33	1.00	0	0	0.00
TPCTAB09	D:\ORACLE\ORADATA\ORCL\TPCTAB09.DBF	6	3.33	1.00	0	0	0.00
TPCTAB10	D:\ORACLE\ORADATA\ORCL\TPCTAB10.DBF	6	3.33	1.00	0	0	0.00
TPCTAB11	D:\ORACLE\ORADATA\ORCL\TPCTAB11.DBF	6	3.33	1.00	0	0	0.00
TPCTAB12	D:\ORACLE\ORADATA\ORCL\TPCTAB12.DBF	7	5.71	1.00	0	0	0.00
UNDOTBS1	D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF	2	5.00	1.00	1,171	8	0.00
USERS	D:\ORACLE\ORADATA\ORCL\USERS01.DBF	643	4.06	2.61	206	21	4.29

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	160,000	99	1,287,077	7,138	9,963	0	0	37

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	317	2877	24756	552960	24756
E	0	7	260	1108	2366	552960	2366

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	128	0.10	16,000	1.18	30,478
D	256	0.20	32,000	1.00	25,762
D	384	0.30	48,000	1.00	25,762
D	512	0.40	64,000	1.00	25,762
D	640	0.50	80,000	1.00	25,762
D	768	0.60	96,000	1.00	25,762
D	896	0.70	112,000	1.00	25,762
D	1,024	0.80	128,000	1.00	25,762
D	1,152	0.90	144,000	1.00	25,762
D	1,280	1.00	160,000	1.00	25,762
D	1,408	1.10	176,000	1.00	25,762
D	1,536	1.20	192,000	1.00	25,762
D	1,664	1.30	208,000	1.00	25,762
D	1,792	1.40	224,000	1.00	25,762
D	1,920	1.50	240,000	1.00	25,762
D	2,048	1.60	256,000	1.00	25,762
D	2,176	1.70	272,000	1.00	25,762
D	2,304	1.80	288,000	1.00	25,762
D	2,432	1.90	304,000	1.00	25,762
D	2,560	2.00	320,000	1.00	25,762

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	284	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	500	427	50.86	0.00	0.00	0.00	0.00	102,400
E	500	422	53.13	0.00	0.00	0.00	0.00	102,400

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	11,120	11,120
64K	128K	55	55
128K	256K	74	74
256K	512K	2	2
512K	1024K	288	288
1M	2M	11	11
2M	4M	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 %
63	0.13	336.61	100.00
125	0.25	336.61	100.00
250	0.50	336.61	100.00
375	0.75	336.61	100.00
500	1.00	336.61	100.00
600	1.20	336.61	100.00
700	1.40	336.61	100.00
800	1.60	336.61	100.00
900	1.80	336.61	100.00
1,000	2.00	336.61	100.00
1,500	3.00	336.61	100.00
2,000	4.00	336.61	100.00
3,000	6.00	336.61	100.00
4,000	8.00	336.61	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
144	0.60	26	3,334	1,597	0.99	25	1.56	381,906
168	0.70	48	5,476	1,606	1.00	16	1.00	384,421
192	0.80	71	8,118	1,606	1.00	16	1.00	384,483
216	0.90	84	9,675	1,606	1.00	16	1.00	384,486
240	1.00	84	9,675	1,606	1.00	16	1.00	384,486
264	1.10	84	9,675	1,606	1.00	16	1.00	384,486
288	1.20	84	9,675	1,606	1.00	16	1.00	384,486
312	1.30	84	9,675	1,606	1.00	16	1.00	384,486
336	1.40	84	9,675	1,606	1.00	16	1.00	384,486
360	1.50	84	9,675	1,606	1.00	16	1.00	384,486
384	1.60	84	9,675	1,606	1.00	16	1.00	384,486
408	1.70	84	9,675	1,606	1.00	16	1.00	384,486
432	1.80	84	9,675	1,606	1.00	16	1.00	384,486
456	1.90	84	9,675	1,606	1.00	16	1.00	384,486
480	2.00	84	9,675	1,606	1.00	16	1.00	384,486

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
388	0.25	89	25,759
776	0.50	89	25,759
1,164	0.75	89	25,759
1,552	1.00	89	25,759
1,940	1.25	89	25,759
2,328	1.50	89	25,759
2,716	1.75	89	25,759
3,104	2.00	89	25,759

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	Avg Time (ms)
data block	25	4
segment header	4	10
undo header	8	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)	9	9	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	1.32	6,071	3,096	3	15/62.6	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 Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
06-6月 19:08	58	195	3	15	0/0	0/0/0/0/0/0
06-6月 18:58	17	175	2	15	0/0	0/0/0/0/0/0
06-6月 18:48	14	59	2	15	0/0	0/0/0/0/0/0
06-6月 18:38	11	75	1	15	0/0	0/0/0/0/0/0
06-6月 18:28	10	46	1	15	0/0	0/0/0/0/0/0
06-6月 18:18	14	143	1	15	0/0	0/0/0/0/0/0
06-6月 18:08	61	121	3	15	0/0	0/0/0/0/0/0
06-6月 17:58	9	51	1	15	0/0	0/0/0/0/0/0
06-6月 17:48	10	58	1	15	0/0	0/0/0/0/0/0
06-6月 17:38	12	81	2	15	0/0	0/0/0/0/0/0
06-6月 17:28	12	51	1	15	0/0	0/0/0/0/0/0
06-6月 17:18	13	121	3	15	0/0	0/0/0/0/0/0
06-6月 17:08	64	117	3	15	0/0	0/0/0/0/0/0
06-6月 16:58	12	78	1	15	0/0	0/0/0/0/0/0
06-6月 16:48	10	52	1	15	0/0	0/0/0/0/0/0
06-6月 16:38	13	69	1	15	0/0	0/0/0/0/0/0
06-6月 16:28	10	54	1	15	0/0	0/0/0/0/0/0
06-6月 16:18	16	164	1	15	0/0	0/0/0/0/0/0
06-6月 16:08	66	134	3	15	0/0	0/0/0/0/0/0
06-6月 15:58	11	85	1	15	0/0	0/0/0/0/0/0
06-6月 15:48	9	45	1	15	0/0	0/0/0/0/0/0
06-6月 15:38	15	96	3	15	0/0	0/0/0/0/0/0
06-6月 15:28	13	56	2	15	0/0	0/0/0/0/0/0
06-6月 15:18	15	156	1	15	0/0	0/0/0/0/0/0
06-6月 15:08	51	124	3	15	0/0	0/0/0/0/0/0
06-6月 14:58	16	140	1	15	0/0	0/0/0/0/0/0
06-6月 14:48	10	66	1	15	0/0	0/0/0/0/0/0
06-6月 14:38	12	87	1	15	0/0	0/0/0/0/0/0
06-6月 14:28	14	53	3	15	0/0	0/0/0/0/0/0
06-6月 14:18	12	149	1	15	0/0	0/0/0/0/0/0
06-6月 14:08	68	153	2	15	0/0	0/0/0/0/0/0
06-6月 13:58	20	111	3	15	0/0	0/0/0/0/0/0
06-6月 13:48	18	82	1	15	0/0	0/0/0/0/0/0
06-6月 13:38	19	246	1	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
AWR Alerted Metric Element list	156,005	0.00		0
Consistent RBA	6,140	0.00		0
FOB s.o list latch	1,444	0.00		0
In memory undo latch	59,163	0.00	1.00	16,863	0.00
JS mem alloc latch	45	0.00		0
JS queue access latch	45	0.00		0
JS queue state obj latch	234,088	0.00		0
JS slv state obj latch	1,513	0.00		0
KMG MMAN ready and startup request latch	10,790	0.00		0
KTF sga latch	13,920	0.00		10,011	0.00
KWQMN job cache list latch	476	0.00		0
MQL Tracking Latch	0			637	0.00
Memory Management Latch	0			10,790	0.00
NLS data objects	2	0.00		0
OS process	5,055	0.00		0
OS process allocation	14,162	0.00		0
OS process: request allocation	1,412	0.00		0
PL/SQL warning settings	3,493	0.00		0
QMT	1	0.00		0
SGA IO buffer pool latch	206	0.00		206	0.00
SQL memory manager latch	9	0.00		10,789	0.00
SQL memory manager workarea list latch	744,648	0.00	0.00	0
Shared B-Tree	1,155	0.00		0
active checkpoint queue latch	50,832	0.24	0.00	0
active service list	70,534	0.00	0.50	11,029	0.00
archive control	72	0.00		0
begin backup scn array	16	0.00		0
cache buffer handles	664	0.00		0
cache buffers chains	2,407,891	0.00	0.00	10,445	0.01
cache buffers lru chain	37,444	0.02	0.00	11,176	0.01
cache table scan latch	0			144	0.00
channel handle pool latch	1,416	0.00		0
channel operations parent latch	154,735	0.00		0
checkpoint queue latch	3,555,039	0.00		9,823	0.00
client/application info	14,434	0.00		0
commit callback allocation	572	0.00		0
compile environment latch	4,761	0.00		0
dictionary lookup	29	0.00		0
dml lock allocation	26,822	0.00		0
dummy allocation	2,466	0.00		0
enqueue hash chains	596,010	0.00		0
enqueues	553,830	0.00	0.00	0
event group latch	707	0.00		0
file cache latch	3,944	0.00		0
global KZLD latch for mem in SGA	217	0.00		0
hash table column usage latch	1,236	0.00		40,509	0.00
hash table modification latch	598	0.00		0
job workq parent latch	0			1,054	0.00
job_queue_processes parameter latch	1,066	0.00		0
kks stats	4,249	0.00		0
kmcptab latch	2	0.00		0
kmcpvec latch	0			2	0.00
ksuosstats global area	2,176	0.00		0
ktm global data	118	0.00		0
kwqbsn:qsga	1,155	0.00		0
lgwr LWN SCN	14,926	0.00		0
library cache	1,065,206	0.00	0.00	3,127	0.00
library cache load lock	2,156	0.00		2	0.00
library cache lock	345,317	0.00	0.00	0
library cache lock allocation	12,977	0.00		0
library cache pin	613,097	0.00		0
library cache pin allocation	5,034	0.00		0
list of block allocation	1,431	0.00		0
loader state object freelist	88	0.00		0
message pool operations parent latch	5	0.00		0
messages	304,801	0.15	0.00	0
mostly latch-free SCN	14,927	0.01	0.00	0
multiblock read objects	478	0.00		2	0.00
ncodef allocation latch	526	0.00		0
object queue header heap	4,959	0.00		134	0.00
object queue header operation	251,366	0.00	0.00	0
object stats modification	204	0.00		4	0.00
parallel query alloc buffer	3,940	0.00		0
parameter list	1,819	0.00		0
parameter table allocation management	1,252	0.08	0.00	0
post/wait queue	2,004	0.00		1,257	0.00
process allocation	1,412	0.00		707	0.00
process group creation	1,412	0.00		0
qm_init_sga	1	0.00		0
qmn task queue latch	4,620	0.00		0
redo allocation	69,732	0.02	0.00	66,624	0.05
redo copy	0			66,631	1.13
redo writing	91,926	0.34	0.00	0
resmgr group change latch	2,923	0.00		0
resmgr:actses active list	2,437	0.00		0
resmgr:actses change group	744	0.00		0
resmgr:free threads list	2,428	0.00		0
resmgr:schema config	9	0.00		0
row cache objects	1,514,171	0.00	0.00	28	0.00
rules engine aggregate statistics	286	0.00		0
rules engine evaluation context statistics	0			2	0.00
rules engine rule set statistics	572	0.00		0
sequence cache	1,426	0.00		0
session allocation	306,343	0.00	0.00	0
session idle bit	133,233	0.00		0
session state list latch	2,691	0.00		0
session switching	526	0.00		0
session timer	11,029	0.00		0
shared pool	623,556	0.00	0.08	0
simulator hash latch	63,948	0.00		0
simulator lru latch	63,045	0.00	0.00	483	0.00
slave class	19	0.00		0
slave class create	76	10.53	1.00	0
sort extent pool	798	0.00		0
state object free list	18	0.00		0
statistics aggregation	1,260	0.00		0
threshold alerts latch	13,436	0.00		0
trace latch	5	0.00		0
transaction allocation	1,374	0.00		0
transaction branch allocation	526	0.00		0
undo global data	70,569	0.00		0
user lock	1,918	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
shared pool	623,556	26	2	24
slave class create	76	8	8	0
active service list	70,534	2	1	1
In memory undo latch	59,163	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 service list	ksws_event: ksws event	1	0
shared pool	kghalo	2	1
slave class create	ksvcreate	8	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,287,434
Captured Segments account for 83.1% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	OBJ$	TABLE	160,320	12.45
SYS	SYSTEM	I_OBJAUTH1	INDEX	145,808	11.33
SYS	SYSTEM	I_OBJ1	INDEX	101,568	7.89
ATMS	USERS	T_PDA_DEVICEINFO	TABLE	76,720	5.96
SYS	SYSTEM	CDEF$	TABLE	47,088	3.66

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 7,500
Captured Segments account for 10.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
SYS	SYSTEM	I_OBJ2	INDEX	320	4.27
SYS	SYSTEM	I_OBJAUTH1	INDEX	71	0.95
XDB	SYSAUX	XDB$H_INDEX	TABLE	56	0.75
SYS	SYSTEM	CDEF$	TABLE	30	0.40
SYS	SYSTEM	I_OBJAUTH2	INDEX	25	0.33

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

No data exists for this section of the report.

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	573	0.00	18	1
dc_files	56	0.00	0	56
dc_global_oids	124,386	0.08	0	138
dc_histogram_data	10,890	2.43	0	2,427
dc_histogram_defs	16,206	11.67	0	4,713
dc_object_grants	489	13.70	0	115
dc_object_ids	142,891	0.59	24	2,129
dc_objects	7,551	6.03	149	1,629
dc_profiles	764	0.00	0	1
dc_rollback_segments	5,850	0.00	0	22
dc_segments	8,337	9.86	50	2,192
dc_sequences	50	12.00	50	9
dc_tablespace_quotas	22	4.55	22	1
dc_tablespaces	27,408	0.00	0	57
dc_usernames	2,933	0.07	0	14
dc_users	159,126	0.00	0	49
outstanding_alerts	6,564	2.18	286	115

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	5,945	0.10	8,260	0.10	1	0
CLUSTER	91	0.00	186	1.08	2	0
INDEX	12	0.00	14	0.00	0	0
PIPE	26	3.85	26	3.85	0	0
SQL AREA	1,305	99.54	144,218	1.95	202	3
TABLE/PROCEDURE	10,687	3.19	145,110	0.78	270	0
TRIGGER	971	0.31	2,584	0.12	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	49.65		0.80	1.11	9	17	62	62
	SQL	1.29	0.48	0.03	0.03	0	2	51	42
	PL/SQL	0.71	0.47	0.01	0.01	0	0	60	60
E	Other	50.58		0.79	1.10	9	17	64	64
	SQL	2.40	0.92	0.05	0.04	0	2	53	48
	PL/SQL	0.86	0.59	0.01	0.01	0	0	62	62

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,342,177,280
Fixed Size	1,251,632
Redo Buffers	15,523,840
Variable Size	268,437,200

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	8.00	8.00	0.00
large	PX msg pool	1.02	1.02	0.00
large	free memory	6.98	6.98	0.00
shared	ASH buffers	31.04	31.04	0.00
shared	CCursor	4.59	5.53	20.44
shared	Heap0: KGL		2.90
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGLS heap	9.01	3.46	-61.61
shared	KQR M PO	3.62	4.21	16.15
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	PCursor	2.75	3.45	25.60
shared	PL/SQL MPCODE	2.64	2.29	-13.11
shared	XDB Schema Cac		5.06
shared	db_block_hash_buckets	4.26	4.26	0.00
shared	dbwriter coalesce buffer	4.00	4.00	0.00
shared	free memory	91.83	76.76	-16.41
shared	library cache	6.80	9.12	34.09
shared	row cache	3.57	3.57	0.00
shared	sql area	14.92	24.21	62.24
	buffer_cache	1,280.00	1,280.00	0.00
	fixed_sga	1.19	1.19	0.00
	log_buffer	14.80	14.80	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	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
compatible	10.2.0.1.0
control_files	D:\ORACLE\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\ORADATA\ORCL\CONTROL03.CTL
core_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	orcl
db_recovery_file_dest	E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes	100
open_cursors	300
optimizer_index_caching	90
optimizer_index_cost_adj	20
pga_aggregate_target	524288000
processes	150
remote_login_passwordfile	EXCLUSIVE
sga_max_size	1627389952
sga_target	1627389952
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP

End of Report

% Blocks changed per Read:	12.04	Recursive Call %:	90.15
Rollback per transaction %:	0.59	Rows per Sort:	20.75

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.47	In-memory Sort %:	100.00
Library Hit %:	98.68	Soft Parse %:	96.05
Execute to Parse %:	51.18	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	69.76	% Non-Parse CPU:	87.37