WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

PERA130 3764745463 pera130 1 10.2.0.4.0 NO DB-SERVER

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
PERA130	3764745463	pera130	1	10.2.0.4.0	NO	DB-SERVER

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 5871 01-11月-13 10:17:34 223 .7

End Snap: 5872 01-11月-13 10:21:56 177 .8

Elapsed: 4.38 (mins)

DB Time: 0.63 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	5871	01-11月-13 10:17:34	223	.7
End Snap:	5872	01-11月-13 10:21:56	177	.8
Elapsed:		4.38 (mins)
DB Time:		0.63 (mins)

Report Summary

Cache Sizes

Begin End

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

Shared Pool Size: 688M 688M Log Buffer: 14,356K

	Begin	End
Buffer Cache:	3,360M	3,360M	Std Block Size:	8K
Shared Pool Size:	688M	688M	Log Buffer:	14,356K

Load Profile

Per Second Per Transaction

Redo size: 2,591.71 3,865.50

Logical reads: 7,594.99 11,327.84

Block changes: 75.01 111.88

Physical reads: 0.41 0.61

Physical writes: 1.10 1.65

User calls: 457.07 681.72

Parses: 13.62 20.32

Hard parses: 0.04 0.06

Sorts: 6.10 9.10

Logons: 0.75 1.13

Executes: 14.37 21.44

Transactions: 0.67

	Per Second	Per Transaction
Redo size:	2,591.71	3,865.50
Logical reads:	7,594.99	11,327.84
Block changes:	75.01	111.88
Physical reads:	0.41	0.61
Physical writes:	1.10	1.65
User calls:	457.07	681.72
Parses:	13.62	20.32
Hard parses:	0.04	0.06
Sorts:	6.10	9.10
Logons:	0.75	1.13
Executes:	14.37	21.44
Transactions:	0.67

% Blocks changed per Read: 0.99 Recursive Call %: 13.09

Rollback per transaction %: 36.36 Rows per Sort: 3591.04

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.34 Soft Parse %: 99.72

Execute to Parse %: 5.22 Latch Hit %: 99.95

Parse CPU to Parse Elapsd %: 150.00 % Non-Parse CPU: 99.83

Shared Pool Statistics

Begin End

Memory Usage %: 89.06 88.89

% SQL with executions>1: 99.06 98.54

% Memory for SQL w/exec>1: 97.84 95.62

	Begin	End
Memory Usage %:	89.06	88.89
% SQL with executions>1:	99.06	98.54
% Memory for SQL w/exec>1:	97.84	95.62

Top 5 Timed Events

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

CPU time 36 95.0

SQL*Net more data to client 153,147 3 0 7.2 Network

db file sequential read 91 1 8 1.8 User I/O

control file sequential read 755 0 0 .8 System I/O

SQL*Net message to client 117,864 0 0 .2 Network

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
CPU time		36		95.0
SQL*Net more data to client	153,147	3	0	7.2	Network
db file sequential read	91	1	8	1.8	User I/O
control file sequential read	755	0	0	.8	System I/O
SQL*Net message to client	117,864	0	0	.2	Network

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): 37.8s
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	36.39	96.33
DB CPU	35.90	95.04
PL/SQL execution elapsed time	1.18	3.13
connection management call elapsed time	0.54	1.43
parse time elapsed	0.10	0.27
hard parse elapsed time	0.04	0.10
hard parse (sharing criteria) elapsed time	0.02	0.06
hard parse (bind mismatch) elapsed time	0.02	0.04
PL/SQL compilation elapsed time	0.00	0.00
repeated bind elapsed time	0.00	0.00
DB time	37.78
background elapsed time	0.71
background cpu time	0.45

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	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Network	271,236	3	0	1,541.11
User I/O	116	1	6	0.66
System I/O	1,127	0	0	6.40
Commit	105	0	0	0.60
Application	10	0	0	0.06
Other	14	0	0	0.08
Concurrency	2	0	0	0.01

Back to Wait Events Statistics
Back to Top

Wait Events

s - second
cs - centisecond - 100th of a second
ms - millisecond - 1000th of a second
us - microsecond - 1000000th of a second
ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
SQL*Net more data to client	153,147	0.00	3	0	870.15
db file sequential read	91	0.00	1	8	0.52
control file sequential read	755	0.00	0	0	4.29
SQL*Net message to client	117,864	0.00	0	0	669.68
direct path read	24	0.00	0	2	0.14
log file sync	105	0.00	0	0	0.60
db file parallel write	148	0.00	0	0	0.84
control file parallel write	87	0.00	0	0	0.49
log file parallel write	137	0.00	0	0	0.78
SQL*Net more data from client	225	0.00	0	0	1.28
enq: TX - row lock contention	10	0.00	0	0	0.06
rdbms ipc reply	5	0.00	0	0	0.03
db file scattered read	1	0.00	0	0	0.01
latch: In memory undo latch	1	0.00	0	0	0.01
latch free	9	0.00	0	0	0.05
buffer busy waits	1	0.00	0	0	0.01
SQL*Net message from client	117,911	0.00	78,998	670	669.95
Streams AQ: waiting for time management or cleanup tasks	2	100.00	2,613	1306283	0.01
Streams AQ: qmn slave idle wait	10	0.00	280	28001	0.06
Streams AQ: qmn coordinator idle wait	12	83.33	280	23334	0.07
virtual circuit status	8	100.00	240	30014	0.05

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
db file parallel write	148	0.00	0	0	0.84
control file parallel write	87	0.00	0	0	0.49
log file parallel write	137	0.00	0	0	0.78
control file sequential read	87	0.00	0	0	0.49
events in waitclass Other	14	0.00	0	0	0.08
Streams AQ: waiting for time management or cleanup tasks	2	100.00	2,613	1306283	0.01
rdbms ipc message	962	86.69	2,098	2181	5.47
Streams AQ: qmn slave idle wait	10	0.00	280	28001	0.06
Streams AQ: qmn coordinator idle wait	12	83.33	280	23334	0.07
pmon timer	88	100.00	262	2977	0.50
smon timer	2	0.00	206	103182	0.01

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
AVG_BUSY_TIME	1,527
AVG_IDLE_TIME	24,711
AVG_SYS_TIME	372
AVG_USER_TIME	1,145
BUSY_TIME	6,135
IDLE_TIME	98,879
SYS_TIME	1,523
USER_TIME	4,612
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	###############
VM_OUT_BYTES	###############
PHYSICAL_MEMORY_BYTES	17,169,580,032
NUM_CPUS	4
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	34.80	33.60	83	1,893,698
pera130	2.90	2.20	24	99,697
SYS$BACKGROUND	0.00	0.00	0	248
pera130XDB	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	Network Total Wts	Network Wt Time
SYS$USERS	79	55	1	269998	280
pera130	37	20	1	240	0
SYS$BACKGROUND	0	0	0	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	12	18	0.68	32.52	bkdmbpvxft9d4	JDBC Thin Client	select this_.OID as OID92_0_, ...
12	12	17	0.72	32.33	d13jncf0y817s	JDBC Thin Client	select this_.OID as OID92_0_, ...
6	6	1	5.79	15.32	7haaph0d5sq1a	JDBC Thin Client	SELECT r.OUT_VER_BEGIN_ID data...
1	1	1	1.47	3.89	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
1	1	1	1.44	3.81	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1	1	52	0.02	2.83	54juvpy15uxht	JDBC Thin Client	select count(*) as y0_ from ER...
1	1	1	0.74	1.97	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	1	0.47	1.24	dj62wg39uj9jv	JDBC Thin Client	BEGIN P_DATA_RELA_BATCH_INSERT...
0	0	1	0.47	1.23	8f7hwwhahbuxx	JDBC Thin Client	INSERT INTO DMS_DATA_RELA (REL...
0	0	1	0.23	0.61	7vgmvmy8vvb9s		insert into wrh$_tempstatxs ...

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
12	12	18	0.68	32.52	bkdmbpvxft9d4	JDBC Thin Client	select this_.OID as OID92_0_, ...
12	12	17	0.72	32.33	d13jncf0y817s	JDBC Thin Client	select this_.OID as OID92_0_, ...
6	6	1	5.78	15.32	7haaph0d5sq1a	JDBC Thin Client	SELECT r.OUT_VER_BEGIN_ID data...
1	1	1	1.10	3.89	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
1	1	1	1.09	3.81	1uk5m5qbzj1vt	SQL*Plus	BEGIN dbms_workload_repository...
1	1	52	0.02	2.83	54juvpy15uxht	JDBC Thin Client	select count(*) as y0_ from ER...
1	1	1	0.74	1.97	bunssq950snhf		insert into wrh$_sga_target_ad...
0	0	9	0.02	0.48	292t7nmq0zg2v	JDBC Thin Client	select count(*) as y0_ from ER...
0	0	10	0.01	0.39	d6r3crk75q95b	JDBC Thin Client	select count(*) as y0_ from ER...
0	0	10	0.01	0.24	cbafus0z7aw7r	JDBC Thin Client	SELECT ID, DATA_FIELD_ID, ...
0	0	1	0.00	1.24	dj62wg39uj9jv	JDBC Thin Client	BEGIN P_DATA_RELA_BATCH_INSERT...
0	0	1	0.00	1.23	8f7hwwhahbuxx	JDBC Thin Client	INSERT INTO DMS_DATA_RELA (REL...

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,993,699
Captured SQL account for 100.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
1,473,486	1	1,473,486.00	73.91	5.78	5.79	7haaph0d5sq1a	JDBC Thin Client	SELECT r.OUT_VER_BEGIN_ID data...
167,960	52	3,230.00	8.42	0.86	1.07	54juvpy15uxht	JDBC Thin Client	select count(*) as y0_ from ER...
96,253	1	96,253.00	4.83	1.10	1.47	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
58,176	18	3,232.00	2.92	12.24	12.29	bkdmbpvxft9d4	JDBC Thin Client	select this_.OID as OID92_0_, ...
54,944	17	3,232.00	2.76	12.16	12.21	d13jncf0y817s	JDBC Thin Client	select this_.OID as OID92_0_, ...
32,300	10	3,230.00	1.62	0.13	0.15	d6r3crk75q95b	JDBC Thin Client	select count(*) as y0_ from ER...
29,070	9	3,230.00	1.46	0.15	0.18	292t7nmq0zg2v	JDBC Thin Client	select count(*) as y0_ from ER...
28,152	84	335.14	1.41	0.05	0.05	gs2z9175jqgdf	SQL*Plus	SELECT VALUE FROM DBA_HIST_SYS...
24,306	98	248.02	1.22	0.06	0.06	75u8af95k8whw	JDBC Thin Client	select this_.LOGID as LOGID15_...
17,610	10	1,761.00	0.88	0.09	0.09	cbafus0z7aw7r	JDBC Thin Client	SELECT ID, DATA_FIELD_ID, ...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

Total Disk Reads: 108
Captured SQL account for 113.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	CPU Time (s)	Elapsed Time (s)	SQL Id	SQL Module	SQL Text
65	1	65.00	60.19	0.00	0.47	8f7hwwhahbuxx	JDBC Thin Client	INSERT INTO DMS_DATA_RELA (REL...
65	1	65.00	60.19	0.00	0.47	dj62wg39uj9jv	JDBC Thin Client	BEGIN P_DATA_RELA_BATCH_INSERT...
24	1	24.00	22.22	1.10	1.47	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
10	2	5.00	9.26	0.00	0.11	96gm4b8z5b0wm	JDBC Thin Client	SELECT k.wb_code as pwbCod...
6	1	6.00	5.56	0.00	0.06	2776r5gm8zt5q	JDBC Thin Client	select this_.PK_ID as PK1_142_...
4	1	4.00	3.70	0.03	0.03	2ax2x0u7qygq6	SQL*Plus	select * from (select ...
4	1	4.00	3.70	0.02	0.02	8hnz9qruz94y3	SQL*Plus	select * from (select ...
4	1	4.00	3.70	0.02	0.03	g72t9h4wr2uuz	SQL*Plus	select * from (select ...
4	1	4.00	3.70	0.03	0.08	gkqvbzsfpngvy	SQL*Plus	select * from (select ...
1	6	0.17	0.93	0.00	0.06	4zfa7uyckzk5z	JDBC Thin Client	SELECT RELA_ID, IN_DA...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

Total Executions: 3,773
Captured SQL account for 83.0% of Total

Executions	Rows Processed	Rows per Exec	CPU per Exec (s)	Elap per Exec (s)	SQL Id	SQL Module	SQL Text
1,129	1,128	1.00	0.00	0.00	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
198	4,752	24.00	0.00	0.00	0h6b2sajwb74n		select privilege#, level from ...
198	198	1.00	0.00	0.00	0k8522rmdzg4k		select privilege# from sysauth...
198	198	1.00	0.00	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
198	198	1.00	0.00	0.00	459f3z9u4fb3u		select value$ from props$ wher...
198	198	1.00	0.00	0.00	5ur69atw3vfhj		select decode(failover_method,...
98	98	1.00	0.00	0.00	75u8af95k8whw	JDBC Thin Client	select this_.LOGID as LOGID15_...
93	93	1.00	0.00	0.00	cpt8un92yv1nb	JDBC Thin Client	select this_.USERID as USERID1...
92	445	4.84	0.00	0.00	df0k13knwa30y	JDBC Thin Client	select grantedper0_.RSID as RS...
84	84	1.00	0.00	0.00	81fn3n7gq8hpj	JDBC Thin Client	update ERM_USER_TOKEN set TOKE...
84	84	1.00	0.00	0.00	gs2z9175jqgdf	SQL*Plus	SELECT VALUE FROM DBA_HIST_SYS...
81	81	1.00	0.00	0.00	1w0c0jhzmp1hh	JDBC Thin Client	SELECT 1 from dual
62	200	3.23	0.00	0.00	1md8ayzabysrb	JDBC Thin Client	select grantedper0_.RSID as RS...
58	3,248	56.00	0.00	0.00	28jd9t6qrupa8	JDBC Thin Client	select this_.GROUPID as GROUPI...
52	52	1.00	0.02	0.02	54juvpy15uxht	JDBC Thin Client	select count(*) as y0_ from ER...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 3,576
Captured SQL account for 84.9% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,129	1,129	31.57	7h35uxf5uhmm1	JDBC Thin Client	select sysdate from dual
198	198	5.54	0h6b2sajwb74n		select privilege#, level from ...
198	198	5.54	0k8522rmdzg4k		select privilege# from sysauth...
198	198	5.54	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
198	198	5.54	459f3z9u4fb3u		select value$ from props$ wher...
198	198	5.54	5ur69atw3vfhj		select decode(failover_method,...
98	98	2.74	75u8af95k8whw	JDBC Thin Client	select this_.LOGID as LOGID15_...
93	93	2.60	cpt8un92yv1nb	JDBC Thin Client	select this_.USERID as USERID1...
92	92	2.57	df0k13knwa30y	JDBC Thin Client	select grantedper0_.RSID as RS...
84	84	2.35	81fn3n7gq8hpj	JDBC Thin Client	update ERM_USER_TOKEN set TOKE...
81	81	2.27	1w0c0jhzmp1hh	JDBC Thin Client	SELECT 1 from dual
62	62	1.73	1md8ayzabysrb	JDBC Thin Client	select grantedper0_.RSID as RS...
58	58	1.62	28jd9t6qrupa8	JDBC Thin Client	select this_.GROUPID as GROUPI...
52	52	1.45	54juvpy15uxht	JDBC Thin Client	select count(*) as y0_ from ER...

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

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

0ws7ahf1d78qa select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')

1md8ayzabysrb select grantedper0_.RSID as RSID1_, grantedper0_.OID as OID1_, grantedper0_.OID as OID13_0_, grantedper0_.VERSION as VERSION13_0_, grantedper0_.AUTHORITYCODE as AUTHORIT3_13_0_, grantedper0_.AUTHORITYNAME as AUTHORIT4_13_0_, grantedper0_.AUTHORITYTYPE as AUTHORIT5_13_0_, grantedper0_.RSID as RSID13_0_, grantedper0_.AUTHORITYOID as AUTHORIT7_13_0_, grantedper0_.EXPIREDATE as EXPIREDATE13_0_, grantedper0_.GRANTABLE as GRANTABLE13_0_, grantedper0_.STARRED as STARRED13_0_, grantedper0_.CREATEBY as CREATEBY13_0_, grantedper0_.LASTMODIFYBY as LASTMOD12_13_0_, grantedper0_.AUTHZTIME as AUTHZTIME13_0_, grantedper0_.REMARK as REMARK13_0_ from ERM_FUNCPERMISSION grantedper0_ where grantedper0_.RSID=:1 order by grantedper0_.authorityType asc

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

1w0c0jhzmp1hh SELECT 1 from dual

2776r5gm8zt5q select this_.PK_ID as PK1_142_0_, this_.CREATE_TIME as CREATE2_142_0_, this_.FK_PID as FK3_142_0_, this_.COMPONENT_TYPE as COMPONENT4_142_0_, this_.COMPONENT_KEYWORD as COMPONENT5_142_0_, this_.COMPONENT_SVN_PATH as COMPONENT6_142_0_, this_.COMPONENT_NAME as COMPONENT7_142_0_, this_.COMPONENT_IN_VAR as COMPONENT8_142_0_, this_.COMPONENT_OUT_VAR as COMPONENT9_142_0_, this_.COMPONENT_MEMO as COMPONENT10_142_0_, this_.COMPONENT_FILE_URL as COMPONENT11_142_0_, this_.COMPONENT_RULE_IN_URL as COMPONENT12_142_0_, this_.COMPONENT_RULE_OUT_URL as COMPONENT13_142_0_, this_.CREATE_USER_ID as CREATE14_142_0_, this_.CREATE_USER_NAME as CREATE15_142_0_, this_.COMPONENT_XPDL as COMPONENT16_142_0_, this_.COMPONENT_XPDL64 as COMPONENT17_142_0_, this_.COMPONENT_TMP_OID as COMPONENT18_142_0_, this_.COMPONENT_IMAGE_PATH as COMPONENT19_142_0_, this_.COMPONENT_IMAGE64_PATH as COMPONENT20_142_0_, this_.COMPONENT_STATE as COMPONENT21_142_0_, this_.SOFT_SIZE as SOFT22_142_0_, this_.SOFT_ACTIVATION as SOFT23_142_0_, this_.SOFT_PROCESSIONAL as SOFT24_142_0_, this_.SOFT_UPDATE as SOFT25_142_0_, this_.version as version142_0_, this_.component_tag as component27_142_0_ from PERA_COMPONENT this_ where (lower(this_.COMPONENT_TYPE) like :1 and lower(this_.COMPONENT_IMAGE64_PATH) like :2)

28jd9t6qrupa8 select this_.GROUPID as GROUPID5_0_, this_.VERSION as VERSION5_0_, this_.GROUPNAME as GROUPNAME5_0_, this_.MEMO as MEMO5_0_, this_.PARENTID as PARENTID5_0_, this_.CODE as CODE5_0_, this_.FULLNAME as FULLNAME5_0_, this_.GROUPNUM as GROUPNUM5_0_, this_.GROUPTYPE as GROUPTYPE5_0_, this_.FULLPATH as FULLPATH5_0_, this_.ASMANAGEDOMAIN as ASMANAG11_5_0_, this_.DISPLAYORDER as DISPLAY12_5_0_, this_.STATE as STATE5_0_, this_.ALLOWDOMAINROLE as ALLOWDO14_5_0_, this_.HASCHILD as HASCHILD5_0_, this_.DIRECTOR as DIRECTOR5_0_, this_.GROUPNAMEPATH as GROUPNA17_5_0_ from ERM_GROUP this_ where this_.ASMANAGEDOMAIN=:1

292t7nmq0zg2v select count(*) as y0_ from ERM_TASK_USERTASK0 this_ where this_.STATUS=:1 and this_.TASKTYPE=:2 and (this_.OWNER=:3 or this_.CANDIDATES like :4 or this_.CANDIDATES like :5 or this_.CANDIDATES like :6 or this_.CANDIDATES like :7 or this_.CANDIDATES like :8) order by this_.CREATEDTIME desc

2ax2x0u7qygq6 select * from (select sqt.bget, sqt.exec, decode(sqt.exec, 0, to_number(null), (sqt.bget / sqt.exec)), (100*sqt.bget)/:gets norm_val, nvl((sqt.cput/1000000), to_number(null)), nvl((sqt.elap/1000000), to_number(null)), sqt.sql_id, to_clob(decode(sqt.module, null, null, 'Module: ' || sqt.module)), nvl(st.sql_text, to_clob('** SQL Text Not Available **')) from (select sql_id, max(module) module, sum(buffer_gets_delta) bget, sum(executions_delta) exec, sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid order by nvl(sqt.bget, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or norm_val > :top_pct_sql)

459f3z9u4fb3u select value$ from props$ where name = 'GLOBAL_DB_NAME'

4zfa7uyckzk5z SELECT RELA_ID, IN_DATA_ID, IN_DATA_NAME, IN_DATA_SOURCE_ID, IN_OBJ_CODE, IN_DATA_SOURCE_CODE, IN_VER_BEGIN_ID, OUT_DATA_ID, OUT_DATA_NAME, OUT_DATA_SOURCE_ID, OUT_OBJ_CODE, OUT_DATA_SOURCE_CODE, OUT_VER_BEGIN_ID, RELA_TYPE_CODE, IN_VER_BEGIN_DATA_SOURCE_ID, OUT_VER_BEGIN_DATA_SOURCE_ID, IN_VER_BEGIN_DATA_OBJ_CODE, IN_VER_BEGIN_DATA_SOURCE_CODE, OUT_VER_BEGIN_DATA_OBJ_CODE, OUT_VER_BEGIN_DATA_SOURCE_CODE, MIDDLE_OBJ_CODE , LAST_CURENT_FLAG FROM dms_data_rela t WHERE t.delete_flag = '0' AND t.rela_type_code = :1 AND t.in_data_id = :2 AND t.last_curent_flag = :3 AND T.MIDDLE_OBJ_CODE IS NULL AND LAST_CURENT_FLAG='1' ORDER BY create_time desc

54juvpy15uxht select count(*) as y0_ from ERM_TASK_USERTASK0 this_ where this_.STATUS=:1 and ((this_.TASKTYPE=:2 and this_.OWNER in (:3)) or (this_.TASKTYPE=:4 and this_.OWNER=:5) or this_.CANDIDATES like :6 or this_.CANDIDATES like :7 or this_.CANDIDATES like :8 or this_.CANDIDATES like :9 or this_.CANDIDATES like :10) order by this_.CREATEDTIME desc

572fbaj0fdw2b select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))

5ur69atw3vfhj select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1

75u8af95k8whw select this_.LOGID as LOGID15_0_, this_.TOKEN as TOKEN15_0_, this_.USERNAME as USERNAME15_0_, this_.LASTACCESSEDTIME as LASTACCE4_15_0_, this_.LOGINSUCCEEDTIME as LOGINSUC5_15_0_, this_.REMOTEADDR as REMOTEADDR15_0_, this_.LASTALIVETIME as LASTALIV7_15_0_, this_.USERREALNAME as USERREAL8_15_0_, this_.LOCATION as LOCATION15_0_, this_.AUTHORITIES as AUTHORI10_15_0_, this_.EXTAG as EXTAG15_0_ from ERM_USER_TOKEN this_ where this_.TOKEN=:1

7h35uxf5uhmm1 select sysdate from dual

7haaph0d5sq1a SELECT r.OUT_VER_BEGIN_ID dataID FROM DMS_DATA_RELA r, DMS_OBJ o WHERE r.DELETE_FLAG = '0' AND r.RELA_TYPE_CODE = 'parent' AND r.OUT_OBJ_CODE = o.OBJ_CODE AND o.DELETE_FLAG = '0' AND o.OPEN_STATE = '1' AND r.IN_OBJ_CODE != 'o_in' START WITH r.IN_DATA_ID in ( SELECT d.OUT_DATA_ID FROM DMS_DATA_RELA d where d.OUT_VER_BEGIN_ID=:1 and d.last_curent_flag='1' ) CONNECT BY r.IN_VER_BEGIN_ID = PRIOR r.OUT_VER_BEGIN_ID

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)

81fn3n7gq8hpj update ERM_USER_TOKEN set TOKEN=:1, USERNAME=:2, LASTACCESSEDTIME=:3, LOGINSUCCEEDTIME=:4, REMOTEADDR=:5, LASTALIVETIME=:6, USERREALNAME=:7, LOCATION=:8, AUTHORITIES=:9, EXTAG=:10 where LOGID=:11

8f7hwwhahbuxx INSERT INTO DMS_DATA_RELA (RELA_ID, IN_DATA_ID, IN_DATA_NAME, IN_DATA_SOURCE_ID, IN_DATA_SOURCE_CODE, IN_OBJ_CODE, IN_VER_BEGIN_ID, IN_VER_BEGIN_DATA_SOURCE_ID, IN_VER_BEGIN_DATA_SOURCE_CODE, IN_VER_BEGIN_DATA_OBJ_CODE, OUT_DATA_ID, OUT_DATA_NAME, OUT_DATA_SOURCE_ID, OUT_DATA_SOURCE_CODE, OUT_OBJ_CODE, OUT_VER_BEGIN_ID, OUT_VER_BEGIN_DATA_SOURCE_ID, OUT_VER_BEGIN_DATA_SOURCE_CODE, OUT_VER_BEGIN_DATA_OBJ_CODE, RELA_TYPE_CODE, MIDDLE_OBJ_CODE, LAST_CURENT_FLAG, CREATE_USER_NAME, CREATE_USER_REAL_NAME, CREATE_TIME, UPDATE_USER_NAME, UPDATE_USER_REAL_NAME, UPDATE_TIME, DELETE_FLAG, ORDER_NUM) SELECT * FROM THE (SELECT CAST(:B1 AS T_O_DATA_RELA) FROM DUAL)

8hnz9qruz94y3 select * from (select sqt.dskr, sqt.exec, decode(sqt.exec, 0, to_number(null), (sqt.dskr / sqt.exec)), (100 * sqt.dskr)/:phyr norm_val, nvl((sqt.cput / 1000000), to_number(null)), nvl((sqt.elap / 1000000), to_number(null)), sqt.sql_id, decode(sqt.module, null, null, 'Module: ' || sqt.module), nvl(st.sql_text, to_clob('** SQL Text Not Available **')) from (select sql_id, max(module) module, sum(disk_reads_delta) dskr, sum(executions_delta) exec, sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid and :phyr > 0 order by nvl(sqt.dskr, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or norm_val > :top_pct_sql)

96gm4b8z5b0wm SELECT k.wb_code as pwbCode, k.wb_name pwbName, b.* , a.REALYFLAG "realyflag" , a.RELA_ID "relaId" FROM KM_PROCESSFILE_RELA a, KM_FILE_INFO b, KM_PROCESSDATA_INFO c , KM_PROCESS k WHERE a.FILE_ID = b.FILE_ID and k.WB_ID=c.wb_id AND a.RELA_TABLE_CODE = to_char(c.DATA_ID) AND c.WB_ID = :1 AND c.DATA_TYPE = :2

bkdmbpvxft9d4 select this_.OID as OID92_0_, this_.VERSION as VERSION92_0_, this_.HASATTACHES as HASATTAC3_92_0_, this_.CONTENT as CONTENT92_0_, this_.LINK as LINK92_0_, this_.MSG_FROM as MSG6_92_0_, this_.MSG_TO as MSG7_92_0_, this_.SEND_TIME as SEND8_92_0_, this_.STATE as STATE92_0_, this_.SYS_OF_LINK as SYS10_92_0_, this_.URGENT as URGENT92_0_, this_.WINDOW_SIZE as WINDOW12_92_0_ from MSG_PERSONMSG_11 this_ where this_.MSG_TO=:1 order by this_.SEND_TIME desc

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

cbafus0z7aw7r SELECT ID, DATA_FIELD_ID, USER_NAME, RELATION_ID, PERMISSION_LEVEL FROM DMS_USER_DATAS WHERE PERMISSION_LEVEL = '1' AND DATA_FIELD_ID = :1 AND RELATION_ID in ( :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 )

cpt8un92yv1nb select this_.USERID as USERID1_0_, this_.VERSION as VERSION1_0_, this_.PASSWORD as PASSWORD1_0_, this_.LEADER as LEADER1_0_, this_.EDITTIME as EDITTIME1_0_, this_.STATE as STATE1_0_, this_.LOCKDATE as LOCKDATE1_0_, this_.LOGINFAILURECOUNT as LOGINFAI8_1_0_, this_.FIRST as FIRST1_0_, this_.REALNAME as REALNAME1_0_, this_.EMAIL as EMAIL1_0_, this_.PHONE as PHONE1_0_, this_.SEX as SEX1_0_, this_.BIRTH as BIRTH1_0_, this_.BORNPLACE as BORNPLACE1_0_, this_.NATION as NATION1_0_, this_.CATEGORY as CATEGORY1_0_, this_.PARTY as PARTY1_0_, this_.HEIGHT as HEIGHT1_0_, this_.WEIGHT as WEIGHT1_0_, this_.IDENT as IDENT1_0_, this_.ENTER as ENTER1_0_, this_.TREATMENT as TREATMENT1_0_, this_.MARRIAGE as MARRIAGE1_0_, this_.PAPER as PAPER1_0_, this_.SCHOOL as SCHOOL1_0_, this_.SPECIALTY as SPECIALTY1_0_, this_.DEGREE as DEGREE1_0_, this_.GRADDAY as GRADDAY1_0_, this_.FFLANGUAGE as FFLANGUAGE1_0_, this_.PROFICIENCY as PROFICI31_1_0_, this_.SFLANGUAGE as SFLANGUAGE1_0_, this_.BLOODTYPE as BLOODTYPE1_0_, this_.ADDRESS as ADDRESS1_0_, this_.CODE as CODE1_0_, this_.CITYZONE as CITYZONE1_0_, this_.MARRIAGEDAY as MARRIAG37_1_0_, this_.MATENAME as MATENAME1_0_, this_.MATEBIRTH as MATEBIRTH1_0_, this_.MATENAT as MATENAT1_0_, this_.MATEJOB as MATEJOB1_0_, this_.MATEADD as MATEADD1_0_, this_.MATECODE as MATECODE1_0_, this_.MATETEL as MATETEL1_0_, this_.FATHER as FATHER1_0_, this_.MOTHER as MOTHER1_0_, this_.PARADD as PARADD1_0_, this_.PRTCODE as PRTCODE1_0_, this_.PERSONAL as PERSONAL1_0_, this_.ATTRIBUTE_1 as ATTRIBUTE50_1_0_, this_.ATTRIBUTE_2 as ATTRIBUTE51_1_0_, this_.ATTRIBUTE_3 as ATTRIBUTE52_1_0_, this_.ATTRIBUTE_4 as ATTRIBUTE53_1_0_, this_.ATTRIBUTE_5 as ATTRIBUTE54_1_0_, this_.ATTRIBUTE_6 as ATTRIBUTE55_1_0_, this_.ATTRIBUTE_7 as ATTRIBUTE56_1_0_, this_.ATTRIBUTE_8 as ATTRIBUTE57_1_0_, this_.ATTRIBUTE_9 as ATTRIBUTE58_1_0_, this_.ATTRIBUTE_10 as ATTRIBUTE59_1_0_, this_.ATTRIBUTE_11 as ATTRIBUTE60_1_0_, this_.ATTRIBUTE_12 as ATTRIBUTE61_1_0_, this_.ATTRIBUTE_13 as ATTRIBUTE62_1_0_, this_.ATTRIBUTE_14 as ATTRIBUTE63_1_0_, this_.ATTRIBUTE_15 as ATTRIBUTE64_1_0_, this_.ATTRIBUTE_16 as ATTRIBUTE65_1_0_, this_.ATTRIBUTE_17 as ATTRIBUTE66_1_0_, this_.ATTRIBUTE_18 as ATTRIBUTE67_1_0_, this_.ATTRIBUTE_19 as ATTRIBUTE68_1_0_, this_.ATTRIBUTE_20 as ATTRIBUTE69_1_0_, this_.MAINGROUPID as MAINGRO70_1_0_, this_.USERNAME as USERNAME1_0_, this_.LASTCHPASSWDDATE as LASTCHP72_1_0_, this_.PASSWORD_1 as PASSWORD73_1_0_, this_.PASSWORD_2 as PASSWORD74_1_0_, this_.PASSWORD_3 as PASSWORD75_1_0_, this_.DISPLAYORDER as DISPLAY76_1_0_, this_.JOBLEVELOID as JOBLEVE77_1_0_, this_.LASTLOGINDATE as LASTLOG78_1_0_, this_.SECRETLEVEL as SECRETL79_1_0_, this_.MAJORCODE as MAJORCODE1_0_, this_.MAJORNAME as MAJORNAME1_0_ from ERM_USER this_ where this_.USERNAME=:1

d13jncf0y817s select this_.OID as OID92_0_, this_.VERSION as VERSION92_0_, this_.HASATTACHES as HASATTAC3_92_0_, this_.CONTENT as CONTENT92_0_, this_.LINK as LINK92_0_, this_.MSG_FROM as MSG6_92_0_, this_.MSG_TO as MSG7_92_0_, this_.SEND_TIME as SEND8_92_0_, this_.STATE as STATE92_0_, this_.SYS_OF_LINK as SYS10_92_0_, this_.URGENT as URGENT92_0_, this_.WINDOW_SIZE as WINDOW12_92_0_ from MSG_PERSONMSG_11 this_ where this_.MSG_TO=:1 and this_.STATE=:2 order by this_.SEND_TIME desc

d6r3crk75q95b select count(*) as y0_ from ERM_TASK_USERTASK0 this_ where this_.STATUS=:1 and this_.TASKTYPE=:2 and (this_.OWNER in (:3) or this_.CANDIDATES like :4 or this_.CANDIDATES like :5 or this_.CANDIDATES like :6 or this_.CANDIDATES like :7 or this_.CANDIDATES like :8) order by this_.CREATEDTIME desc

df0k13knwa30y select grantedper0_.RSID as RSID1_, grantedper0_.OID as OID1_, grantedper0_.OID as OID176_0_, grantedper0_.VERSION as VERSION176_0_, grantedper0_.AUTHORITYCODE as AUTHORIT3_176_0_, grantedper0_.AUTHORITYNAME as AUTHORIT4_176_0_, grantedper0_.AUTHORITYTYPE as AUTHORIT5_176_0_, grantedper0_.RSID as RSID176_0_, grantedper0_.AUTHORITYOID as AUTHORIT7_176_0_, grantedper0_.EXPIREDATE as EXPIREDATE176_0_, grantedper0_.GRANTABLE as GRANTABLE176_0_, grantedper0_.STARRED as STARRED176_0_, grantedper0_.CREATEBY as CREATEBY176_0_, grantedper0_.LASTMODIFYBY as LASTMOD12_176_0_, grantedper0_.AUTHZTIME as AUTHZTIME176_0_, grantedper0_.REMARK as REMARK176_0_ from ERM_FUNCPERMISSION grantedper0_ where grantedper0_.RSID=:1 order by grantedper0_.authorityType asc

dj62wg39uj9jv BEGIN P_DATA_RELA_BATCH_INSERT(:1); END;

g72t9h4wr2uuz select * from (select sqt.exec exec, sqt.rowp, sqt.rowp / sqt.exec, sqt.cput / sqt.exec / 1000000, sqt.elap / sqt.exec / 1000000, sqt.sql_id, decode(sqt.module, null, null, 'Module: ' || sqt.module), nvl(st.sql_text, to_clob('** SQL Text Not Available **')) from (select sql_id, max(module) module, sum(executions_delta) exec, sum(rows_processed_delta) rowp, sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid and sqt.exec > 0 order by nvl(sqt.exec, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or (100 * exec) / :exe > :top_pct_sql)

gkqvbzsfpngvy select * from (select nvl((sqt.elap/1000000), to_number(null)), nvl((sqt.cput/1000000), to_number(null)), sqt.exec, decode(sqt.exec, 0, to_number(null), (sqt.elap / sqt.exec / 1000000)), (100 * (sqt.elap / :dbtime)) norm_val, sqt.sql_id, to_clob(decode(sqt.module, null, null, 'Module: ' || sqt.module)), nvl(st.sql_text, to_clob('** SQL Text Not Available **')) from (select sql_id, max(module) module, sum(elapsed_time_delta) elap, sum(cpu_time_delta) cput, sum(executions_delta) exec from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid order by nvl(sqt.elap, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or norm_val > :top_pct_sql)

gs2z9175jqgdf SELECT VALUE FROM DBA_HIST_SYSSTAT WHERE SNAP_ID = :B4 AND DBID = :B3 AND INSTANCE_NUMBER = :B2 AND STAT_NAME = :B1

SQL Id	SQL Text
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
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
1md8ayzabysrb	select grantedper0_.RSID as RSID1_, grantedper0_.OID as OID1_, grantedper0_.OID as OID13_0_, grantedper0_.VERSION as VERSION13_0_, grantedper0_.AUTHORITYCODE as AUTHORIT3_13_0_, grantedper0_.AUTHORITYNAME as AUTHORIT4_13_0_, grantedper0_.AUTHORITYTYPE as AUTHORIT5_13_0_, grantedper0_.RSID as RSID13_0_, grantedper0_.AUTHORITYOID as AUTHORIT7_13_0_, grantedper0_.EXPIREDATE as EXPIREDATE13_0_, grantedper0_.GRANTABLE as GRANTABLE13_0_, grantedper0_.STARRED as STARRED13_0_, grantedper0_.CREATEBY as CREATEBY13_0_, grantedper0_.LASTMODIFYBY as LASTMOD12_13_0_, grantedper0_.AUTHZTIME as AUTHZTIME13_0_, grantedper0_.REMARK as REMARK13_0_ from ERM_FUNCPERMISSION grantedper0_ where grantedper0_.RSID=:1 order by grantedper0_.authorityType asc
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
1w0c0jhzmp1hh	SELECT 1 from dual
2776r5gm8zt5q	select this_.PK_ID as PK1_142_0_, this_.CREATE_TIME as CREATE2_142_0_, this_.FK_PID as FK3_142_0_, this_.COMPONENT_TYPE as COMPONENT4_142_0_, this_.COMPONENT_KEYWORD as COMPONENT5_142_0_, this_.COMPONENT_SVN_PATH as COMPONENT6_142_0_, this_.COMPONENT_NAME as COMPONENT7_142_0_, this_.COMPONENT_IN_VAR as COMPONENT8_142_0_, this_.COMPONENT_OUT_VAR as COMPONENT9_142_0_, this_.COMPONENT_MEMO as COMPONENT10_142_0_, this_.COMPONENT_FILE_URL as COMPONENT11_142_0_, this_.COMPONENT_RULE_IN_URL as COMPONENT12_142_0_, this_.COMPONENT_RULE_OUT_URL as COMPONENT13_142_0_, this_.CREATE_USER_ID as CREATE14_142_0_, this_.CREATE_USER_NAME as CREATE15_142_0_, this_.COMPONENT_XPDL as COMPONENT16_142_0_, this_.COMPONENT_XPDL64 as COMPONENT17_142_0_, this_.COMPONENT_TMP_OID as COMPONENT18_142_0_, this_.COMPONENT_IMAGE_PATH as COMPONENT19_142_0_, this_.COMPONENT_IMAGE64_PATH as COMPONENT20_142_0_, this_.COMPONENT_STATE as COMPONENT21_142_0_, this_.SOFT_SIZE as SOFT22_142_0_, this_.SOFT_ACTIVATION as SOFT23_142_0_, this_.SOFT_PROCESSIONAL as SOFT24_142_0_, this_.SOFT_UPDATE as SOFT25_142_0_, this_.version as version142_0_, this_.component_tag as component27_142_0_ from PERA_COMPONENT this_ where (lower(this_.COMPONENT_TYPE) like :1 and lower(this_.COMPONENT_IMAGE64_PATH) like :2)
28jd9t6qrupa8	select this_.GROUPID as GROUPID5_0_, this_.VERSION as VERSION5_0_, this_.GROUPNAME as GROUPNAME5_0_, this_.MEMO as MEMO5_0_, this_.PARENTID as PARENTID5_0_, this_.CODE as CODE5_0_, this_.FULLNAME as FULLNAME5_0_, this_.GROUPNUM as GROUPNUM5_0_, this_.GROUPTYPE as GROUPTYPE5_0_, this_.FULLPATH as FULLPATH5_0_, this_.ASMANAGEDOMAIN as ASMANAG11_5_0_, this_.DISPLAYORDER as DISPLAY12_5_0_, this_.STATE as STATE5_0_, this_.ALLOWDOMAINROLE as ALLOWDO14_5_0_, this_.HASCHILD as HASCHILD5_0_, this_.DIRECTOR as DIRECTOR5_0_, this_.GROUPNAMEPATH as GROUPNA17_5_0_ from ERM_GROUP this_ where this_.ASMANAGEDOMAIN=:1
292t7nmq0zg2v	select count(*) as y0_ from ERM_TASK_USERTASK0 this_ where this_.STATUS=:1 and this_.TASKTYPE=:2 and (this_.OWNER=:3 or this_.CANDIDATES like :4 or this_.CANDIDATES like :5 or this_.CANDIDATES like :6 or this_.CANDIDATES like :7 or this_.CANDIDATES like :8) order by this_.CREATEDTIME desc
2ax2x0u7qygq6	select * from (select sqt.bget, sqt.exec, decode(sqt.exec, 0, to_number(null), (sqt.bget / sqt.exec)), (100sqt.bget)/:gets norm_val, nvl((sqt.cput/1000000), to_number(null)), nvl((sqt.elap/1000000), to_number(null)), sqt.sql_id, to_clob(decode(sqt.module, null, null, 'Module: ' \|\| sqt.module)), nvl(st.sql_text, to_clob('* SQL Text Not Available **')) from (select sql_id, max(module) module, sum(buffer_gets_delta) bget, sum(executions_delta) exec, sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid order by nvl(sqt.bget, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or norm_val > :top_pct_sql)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4zfa7uyckzk5z	SELECT RELA_ID, IN_DATA_ID, IN_DATA_NAME, IN_DATA_SOURCE_ID, IN_OBJ_CODE, IN_DATA_SOURCE_CODE, IN_VER_BEGIN_ID, OUT_DATA_ID, OUT_DATA_NAME, OUT_DATA_SOURCE_ID, OUT_OBJ_CODE, OUT_DATA_SOURCE_CODE, OUT_VER_BEGIN_ID, RELA_TYPE_CODE, IN_VER_BEGIN_DATA_SOURCE_ID, OUT_VER_BEGIN_DATA_SOURCE_ID, IN_VER_BEGIN_DATA_OBJ_CODE, IN_VER_BEGIN_DATA_SOURCE_CODE, OUT_VER_BEGIN_DATA_OBJ_CODE, OUT_VER_BEGIN_DATA_SOURCE_CODE, MIDDLE_OBJ_CODE , LAST_CURENT_FLAG FROM dms_data_rela t WHERE t.delete_flag = '0' AND t.rela_type_code = :1 AND t.in_data_id = :2 AND t.last_curent_flag = :3 AND T.MIDDLE_OBJ_CODE IS NULL AND LAST_CURENT_FLAG='1' ORDER BY create_time desc
54juvpy15uxht	select count(*) as y0_ from ERM_TASK_USERTASK0 this_ where this_.STATUS=:1 and ((this_.TASKTYPE=:2 and this_.OWNER in (:3)) or (this_.TASKTYPE=:4 and this_.OWNER=:5) or this_.CANDIDATES like :6 or this_.CANDIDATES like :7 or this_.CANDIDATES like :8 or this_.CANDIDATES like :9 or this_.CANDIDATES like :10) order by this_.CREATEDTIME desc
572fbaj0fdw2b	select output from table(dbms_workload_repository.awr_report_html( :dbid, :inst_num, :bid, :eid, :rpt_options ))
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
75u8af95k8whw	select this_.LOGID as LOGID15_0_, this_.TOKEN as TOKEN15_0_, this_.USERNAME as USERNAME15_0_, this_.LASTACCESSEDTIME as LASTACCE4_15_0_, this_.LOGINSUCCEEDTIME as LOGINSUC5_15_0_, this_.REMOTEADDR as REMOTEADDR15_0_, this_.LASTALIVETIME as LASTALIV7_15_0_, this_.USERREALNAME as USERREAL8_15_0_, this_.LOCATION as LOCATION15_0_, this_.AUTHORITIES as AUTHORI10_15_0_, this_.EXTAG as EXTAG15_0_ from ERM_USER_TOKEN this_ where this_.TOKEN=:1
7h35uxf5uhmm1	select sysdate from dual
7haaph0d5sq1a	SELECT r.OUT_VER_BEGIN_ID dataID FROM DMS_DATA_RELA r, DMS_OBJ o WHERE r.DELETE_FLAG = '0' AND r.RELA_TYPE_CODE = 'parent' AND r.OUT_OBJ_CODE = o.OBJ_CODE AND o.DELETE_FLAG = '0' AND o.OPEN_STATE = '1' AND r.IN_OBJ_CODE != 'o_in' START WITH r.IN_DATA_ID in ( SELECT d.OUT_DATA_ID FROM DMS_DATA_RELA d where d.OUT_VER_BEGIN_ID=:1 and d.last_curent_flag='1' ) CONNECT BY r.IN_VER_BEGIN_ID = PRIOR r.OUT_VER_BEGIN_ID
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)
81fn3n7gq8hpj	update ERM_USER_TOKEN set TOKEN=:1, USERNAME=:2, LASTACCESSEDTIME=:3, LOGINSUCCEEDTIME=:4, REMOTEADDR=:5, LASTALIVETIME=:6, USERREALNAME=:7, LOCATION=:8, AUTHORITIES=:9, EXTAG=:10 where LOGID=:11
8f7hwwhahbuxx	INSERT INTO DMS_DATA_RELA (RELA_ID, IN_DATA_ID, IN_DATA_NAME, IN_DATA_SOURCE_ID, IN_DATA_SOURCE_CODE, IN_OBJ_CODE, IN_VER_BEGIN_ID, IN_VER_BEGIN_DATA_SOURCE_ID, IN_VER_BEGIN_DATA_SOURCE_CODE, IN_VER_BEGIN_DATA_OBJ_CODE, OUT_DATA_ID, OUT_DATA_NAME, OUT_DATA_SOURCE_ID, OUT_DATA_SOURCE_CODE, OUT_OBJ_CODE, OUT_VER_BEGIN_ID, OUT_VER_BEGIN_DATA_SOURCE_ID, OUT_VER_BEGIN_DATA_SOURCE_CODE, OUT_VER_BEGIN_DATA_OBJ_CODE, RELA_TYPE_CODE, MIDDLE_OBJ_CODE, LAST_CURENT_FLAG, CREATE_USER_NAME, CREATE_USER_REAL_NAME, CREATE_TIME, UPDATE_USER_NAME, UPDATE_USER_REAL_NAME, UPDATE_TIME, DELETE_FLAG, ORDER_NUM) SELECT * FROM THE (SELECT CAST(:B1 AS T_O_DATA_RELA) FROM DUAL)
8hnz9qruz94y3	select * from (select sqt.dskr, sqt.exec, decode(sqt.exec, 0, to_number(null), (sqt.dskr / sqt.exec)), (100 * sqt.dskr)/:phyr norm_val, nvl((sqt.cput / 1000000), to_number(null)), nvl((sqt.elap / 1000000), to_number(null)), sqt.sql_id, decode(sqt.module, null, null, 'Module: ' \|\| sqt.module), nvl(st.sql_text, to_clob(' SQL Text Not Available ')) from (select sql_id, max(module) module, sum(disk_reads_delta) dskr, sum(executions_delta) exec, sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid and :phyr > 0 order by nvl(sqt.dskr, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or norm_val > :top_pct_sql)
96gm4b8z5b0wm	SELECT k.wb_code as pwbCode, k.wb_name pwbName, b.* , a.REALYFLAG "realyflag" , a.RELA_ID "relaId" FROM KM_PROCESSFILE_RELA a, KM_FILE_INFO b, KM_PROCESSDATA_INFO c , KM_PROCESS k WHERE a.FILE_ID = b.FILE_ID and k.WB_ID=c.wb_id AND a.RELA_TABLE_CODE = to_char(c.DATA_ID) AND c.WB_ID = :1 AND c.DATA_TYPE = :2
bkdmbpvxft9d4	select this_.OID as OID92_0_, this_.VERSION as VERSION92_0_, this_.HASATTACHES as HASATTAC3_92_0_, this_.CONTENT as CONTENT92_0_, this_.LINK as LINK92_0_, this_.MSG_FROM as MSG6_92_0_, this_.MSG_TO as MSG7_92_0_, this_.SEND_TIME as SEND8_92_0_, this_.STATE as STATE92_0_, this_.SYS_OF_LINK as SYS10_92_0_, this_.URGENT as URGENT92_0_, this_.WINDOW_SIZE as WINDOW12_92_0_ from MSG_PERSONMSG_11 this_ where this_.MSG_TO=:1 order by this_.SEND_TIME desc
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
cbafus0z7aw7r	SELECT ID, DATA_FIELD_ID, USER_NAME, RELATION_ID, PERMISSION_LEVEL FROM DMS_USER_DATAS WHERE PERMISSION_LEVEL = '1' AND DATA_FIELD_ID = :1 AND RELATION_ID in ( :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 )
cpt8un92yv1nb	select this_.USERID as USERID1_0_, this_.VERSION as VERSION1_0_, this_.PASSWORD as PASSWORD1_0_, this_.LEADER as LEADER1_0_, this_.EDITTIME as EDITTIME1_0_, this_.STATE as STATE1_0_, this_.LOCKDATE as LOCKDATE1_0_, this_.LOGINFAILURECOUNT as LOGINFAI8_1_0_, this_.FIRST as FIRST1_0_, this_.REALNAME as REALNAME1_0_, this_.EMAIL as EMAIL1_0_, this_.PHONE as PHONE1_0_, this_.SEX as SEX1_0_, this_.BIRTH as BIRTH1_0_, this_.BORNPLACE as BORNPLACE1_0_, this_.NATION as NATION1_0_, this_.CATEGORY as CATEGORY1_0_, this_.PARTY as PARTY1_0_, this_.HEIGHT as HEIGHT1_0_, this_.WEIGHT as WEIGHT1_0_, this_.IDENT as IDENT1_0_, this_.ENTER as ENTER1_0_, this_.TREATMENT as TREATMENT1_0_, this_.MARRIAGE as MARRIAGE1_0_, this_.PAPER as PAPER1_0_, this_.SCHOOL as SCHOOL1_0_, this_.SPECIALTY as SPECIALTY1_0_, this_.DEGREE as DEGREE1_0_, this_.GRADDAY as GRADDAY1_0_, this_.FFLANGUAGE as FFLANGUAGE1_0_, this_.PROFICIENCY as PROFICI31_1_0_, this_.SFLANGUAGE as SFLANGUAGE1_0_, this_.BLOODTYPE as BLOODTYPE1_0_, this_.ADDRESS as ADDRESS1_0_, this_.CODE as CODE1_0_, this_.CITYZONE as CITYZONE1_0_, this_.MARRIAGEDAY as MARRIAG37_1_0_, this_.MATENAME as MATENAME1_0_, this_.MATEBIRTH as MATEBIRTH1_0_, this_.MATENAT as MATENAT1_0_, this_.MATEJOB as MATEJOB1_0_, this_.MATEADD as MATEADD1_0_, this_.MATECODE as MATECODE1_0_, this_.MATETEL as MATETEL1_0_, this_.FATHER as FATHER1_0_, this_.MOTHER as MOTHER1_0_, this_.PARADD as PARADD1_0_, this_.PRTCODE as PRTCODE1_0_, this_.PERSONAL as PERSONAL1_0_, this_.ATTRIBUTE_1 as ATTRIBUTE50_1_0_, this_.ATTRIBUTE_2 as ATTRIBUTE51_1_0_, this_.ATTRIBUTE_3 as ATTRIBUTE52_1_0_, this_.ATTRIBUTE_4 as ATTRIBUTE53_1_0_, this_.ATTRIBUTE_5 as ATTRIBUTE54_1_0_, this_.ATTRIBUTE_6 as ATTRIBUTE55_1_0_, this_.ATTRIBUTE_7 as ATTRIBUTE56_1_0_, this_.ATTRIBUTE_8 as ATTRIBUTE57_1_0_, this_.ATTRIBUTE_9 as ATTRIBUTE58_1_0_, this_.ATTRIBUTE_10 as ATTRIBUTE59_1_0_, this_.ATTRIBUTE_11 as ATTRIBUTE60_1_0_, this_.ATTRIBUTE_12 as ATTRIBUTE61_1_0_, this_.ATTRIBUTE_13 as ATTRIBUTE62_1_0_, this_.ATTRIBUTE_14 as ATTRIBUTE63_1_0_, this_.ATTRIBUTE_15 as ATTRIBUTE64_1_0_, this_.ATTRIBUTE_16 as ATTRIBUTE65_1_0_, this_.ATTRIBUTE_17 as ATTRIBUTE66_1_0_, this_.ATTRIBUTE_18 as ATTRIBUTE67_1_0_, this_.ATTRIBUTE_19 as ATTRIBUTE68_1_0_, this_.ATTRIBUTE_20 as ATTRIBUTE69_1_0_, this_.MAINGROUPID as MAINGRO70_1_0_, this_.USERNAME as USERNAME1_0_, this_.LASTCHPASSWDDATE as LASTCHP72_1_0_, this_.PASSWORD_1 as PASSWORD73_1_0_, this_.PASSWORD_2 as PASSWORD74_1_0_, this_.PASSWORD_3 as PASSWORD75_1_0_, this_.DISPLAYORDER as DISPLAY76_1_0_, this_.JOBLEVELOID as JOBLEVE77_1_0_, this_.LASTLOGINDATE as LASTLOG78_1_0_, this_.SECRETLEVEL as SECRETL79_1_0_, this_.MAJORCODE as MAJORCODE1_0_, this_.MAJORNAME as MAJORNAME1_0_ from ERM_USER this_ where this_.USERNAME=:1
d13jncf0y817s	select this_.OID as OID92_0_, this_.VERSION as VERSION92_0_, this_.HASATTACHES as HASATTAC3_92_0_, this_.CONTENT as CONTENT92_0_, this_.LINK as LINK92_0_, this_.MSG_FROM as MSG6_92_0_, this_.MSG_TO as MSG7_92_0_, this_.SEND_TIME as SEND8_92_0_, this_.STATE as STATE92_0_, this_.SYS_OF_LINK as SYS10_92_0_, this_.URGENT as URGENT92_0_, this_.WINDOW_SIZE as WINDOW12_92_0_ from MSG_PERSONMSG_11 this_ where this_.MSG_TO=:1 and this_.STATE=:2 order by this_.SEND_TIME desc
d6r3crk75q95b	select count(*) as y0_ from ERM_TASK_USERTASK0 this_ where this_.STATUS=:1 and this_.TASKTYPE=:2 and (this_.OWNER in (:3) or this_.CANDIDATES like :4 or this_.CANDIDATES like :5 or this_.CANDIDATES like :6 or this_.CANDIDATES like :7 or this_.CANDIDATES like :8) order by this_.CREATEDTIME desc
df0k13knwa30y	select grantedper0_.RSID as RSID1_, grantedper0_.OID as OID1_, grantedper0_.OID as OID176_0_, grantedper0_.VERSION as VERSION176_0_, grantedper0_.AUTHORITYCODE as AUTHORIT3_176_0_, grantedper0_.AUTHORITYNAME as AUTHORIT4_176_0_, grantedper0_.AUTHORITYTYPE as AUTHORIT5_176_0_, grantedper0_.RSID as RSID176_0_, grantedper0_.AUTHORITYOID as AUTHORIT7_176_0_, grantedper0_.EXPIREDATE as EXPIREDATE176_0_, grantedper0_.GRANTABLE as GRANTABLE176_0_, grantedper0_.STARRED as STARRED176_0_, grantedper0_.CREATEBY as CREATEBY176_0_, grantedper0_.LASTMODIFYBY as LASTMOD12_176_0_, grantedper0_.AUTHZTIME as AUTHZTIME176_0_, grantedper0_.REMARK as REMARK176_0_ from ERM_FUNCPERMISSION grantedper0_ where grantedper0_.RSID=:1 order by grantedper0_.authorityType asc
dj62wg39uj9jv	BEGIN P_DATA_RELA_BATCH_INSERT(:1); END;
g72t9h4wr2uuz	select * from (select sqt.exec exec, sqt.rowp, sqt.rowp / sqt.exec, sqt.cput / sqt.exec / 1000000, sqt.elap / sqt.exec / 1000000, sqt.sql_id, decode(sqt.module, null, null, 'Module: ' \|\| sqt.module), nvl(st.sql_text, to_clob(' SQL Text Not Available ')) from (select sql_id, max(module) module, sum(executions_delta) exec, sum(rows_processed_delta) rowp, sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid and sqt.exec > 0 order by nvl(sqt.exec, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or (100 * exec) / :exe > :top_pct_sql)
gkqvbzsfpngvy	select * from (select nvl((sqt.elap/1000000), to_number(null)), nvl((sqt.cput/1000000), to_number(null)), sqt.exec, decode(sqt.exec, 0, to_number(null), (sqt.elap / sqt.exec / 1000000)), (100 * (sqt.elap / :dbtime)) norm_val, sqt.sql_id, to_clob(decode(sqt.module, null, null, 'Module: ' \|\| sqt.module)), nvl(st.sql_text, to_clob(' SQL Text Not Available ')) from (select sql_id, max(module) module, sum(elapsed_time_delta) elap, sum(cpu_time_delta) cput, sum(executions_delta) exec from dba_hist_sqlstat where dbid = :dbid and instance_number = :inst_num and :bid < snap_id and snap_id <= :eid group by sql_id) sqt, dba_hist_sqltext st where st.sql_id(+) = sqt.sql_id and st.dbid(+) = :dbid order by nvl(sqt.elap, -1) desc, sqt.sql_id) where rownum < :tsql_max and (rownum <= :tsql_min or norm_val > :top_pct_sql)
gs2z9175jqgdf	SELECT VALUE FROM DBA_HIST_SYSSTAT WHERE SNAP_ID = :B4 AND DBID = :B3 AND INSTANCE_NUMBER = :B2 AND STAT_NAME = :B1

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	3,358	12.79	19.08
CPU used when call started	3,359	12.80	19.09
CR blocks created	16	0.06	0.09
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	0	0.00	0.00
DB time	3,665	13.96	20.82
DBWR checkpoint buffers written	290	1.10	1.65
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	21	0.08	0.12
DBWR undo block writes	67	0.26	0.38
IMU CR rollbacks	7	0.03	0.04
IMU Flushes	14	0.05	0.08
IMU Redo allocation size	45,616	173.77	259.18
IMU commits	98	0.37	0.56
IMU contention	11	0.04	0.06
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	364,992	1,390.44	2,073.82
IMU- failed to get a private strand	0	0.00	0.00
SMON posted for undo segment shrink	2	0.01	0.01
SQL*Net roundtrips to/from client	117,290	446.82	666.42
active txn count during cleanout	23	0.09	0.13
application wait time	0	0.00	0.00
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	836	3.18	4.75
branch node splits	0	0.00	0.00
buffer is not pinned count	1,035,029	3,942.94	5,880.85
buffer is pinned count	792,140	3,017.65	4,500.80
bytes received via SQL*Net from client	1,959,890	7,466.19	11,135.74
bytes sent via SQL*Net to client	432,341,277	1,647,001.84	2,456,484.53
calls to get snapshot scn: kcmgss	27,722	105.61	157.51
calls to kcmgas	200	0.76	1.14
calls to kcmgcs	44	0.17	0.25
change write time	3	0.01	0.02
cleanout - number of ktugct calls	26	0.10	0.15
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	2	0.01	0.01
cluster key scan block gets	148	0.56	0.84
cluster key scans	87	0.33	0.49
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	3	0.01	0.02
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	340	1.30	1.93
commit cleanouts successfully completed	337	1.28	1.91
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	22	0.08	0.13
concurrency wait time	0	0.00	0.00
consistent changes	17,866	68.06	101.51
consistent gets	1,938,822	7,385.93	11,016.03
consistent gets - examination	371,812	1,416.42	2,112.57
consistent gets direct	24	0.09	0.14
consistent gets from cache	1,938,798	7,385.84	11,015.90
cursor authentications	8	0.03	0.05
data blocks consistent reads - undo records applied	28	0.11	0.16
db block changes	19,690	75.01	111.88
db block gets	54,877	209.05	311.80
db block gets direct	0	0.00	0.00
db block gets from cache	54,877	209.05	311.80
deferred (CURRENT) block cleanout applications	238	0.91	1.35
dirty buffers inspected	0	0.00	0.00
enqueue conversions	56	0.21	0.32
enqueue releases	2,892	11.02	16.43
enqueue requests	2,892	11.02	16.43
enqueue waits	10	0.04	0.06
execute count	3,773	14.37	21.44
failed probes on index block reclamation	0	0.00	0.00
free buffer inspected	0	0.00	0.00
free buffer requested	4,469	17.02	25.39
heap block compress	9	0.03	0.05
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	2	0.01	0.01
immediate (CURRENT) block cleanout applications	30	0.11	0.17
index crx upgrade (found)	0	0.00	0.00
index crx upgrade (positioned)	259	0.99	1.47
index fast full scans (full)	17	0.06	0.10
index fetch by key	20,754	79.06	117.92
index scans kdiixs1	337,319	1,285.01	1,916.59
leaf node 90-10 splits	7	0.03	0.04
leaf node splits	10	0.04	0.06
lob reads	3,512	13.38	19.95
lob writes	4,858	18.51	27.60
lob writes unaligned	4,858	18.51	27.60
logons cumulative	198	0.75	1.13
messages received	278	1.06	1.58
messages sent	278	1.06	1.58
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	1,558,312	5,936.38	8,854.05
opened cursors cumulative	3,642	13.87	20.69
parse count (failures)	0	0.00	0.00
parse count (hard)	10	0.04	0.06
parse count (total)	3,576	13.62	20.32
parse time cpu	6	0.02	0.03
parse time elapsed	4	0.02	0.02
physical read IO requests	104	0.40	0.59
physical read bytes	884,736	3,370.40	5,026.91
physical read total IO requests	873	3.33	4.96
physical read total bytes	13,377,536	50,961.65	76,008.73
physical read total multi block requests	1	0.00	0.01
physical reads	108	0.41	0.61
physical reads cache	84	0.32	0.48
physical reads cache prefetch	4	0.02	0.02
physical reads direct	24	0.09	0.14
physical reads direct (lob)	24	0.09	0.14
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	205	0.78	1.16
physical write bytes	2,375,680	9,050.14	13,498.18
physical write total IO requests	606	2.31	3.44
physical write total bytes	7,387,136	28,141.26	41,972.36
physical write total multi block requests	148	0.56	0.84
physical writes	290	1.10	1.65
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	290	1.10	1.65
physical writes non checkpoint	151	0.58	0.86
pinned buffers inspected	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
process last non-idle time	263	1.00	1.49
recursive calls	18,075	68.86	102.70
recursive cpu usage	163	0.62	0.93
redo blocks written	1,340	5.10	7.61
redo buffer allocation retries	0	0.00	0.00
redo entries	1,025	3.90	5.82
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	39	0.15	0.22
redo size	680,328	2,591.71	3,865.50
redo subscn max counts	91	0.35	0.52
redo synch time	5	0.02	0.03
redo synch writes	105	0.40	0.60
redo wastage	28,208	107.46	160.27
redo write time	1	0.00	0.01
redo writer latching time	0	0.00	0.00
redo writes	137	0.52	0.78
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	16	0.06	0.09
rows fetched via callback	17,661	67.28	100.35
session connect time	0	0.00	0.00
session cursor cache hits	2,078	7.92	11.81
session logical reads	1,993,699	7,594.99	11,327.84
session uga memory	25,940,320	98,819.51	147,388.18
session uga memory max	49,712,440	189,379.28	282,457.05
shared hash latch upgrades - no wait	299	1.14	1.70
shared hash latch upgrades - wait	0	0.00	0.00
sorts (memory)	1,601	6.10	9.10
sorts (rows)	5,749,252	21,901.75	32,666.20
sql area evicted	72	0.27	0.41
sql area purged	0	0.00	0.00
summed dirty queue length	0	0.00	0.00
switch current to new buffer	0	0.00	0.00
table fetch by rowid	375,481	1,430.39	2,133.41
table fetch continued row	20	0.08	0.11
table scan blocks gotten	554,072	2,110.73	3,148.14
table scan rows gotten	16,591,396	63,204.84	94,269.30
table scans (long tables)	4	0.02	0.02
table scans (short tables)	940	3.58	5.34
total number of times SMON posted	2	0.01	0.01
transaction rollbacks	0	0.00	0.00
undo change vector size	221,928	845.43	1,260.95
user I/O wait time	76	0.29	0.43
user calls	119,982	457.07	681.72
user commits	112	0.43	0.64
user rollbacks	64	0.24	0.36
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	1,440	5.49	8.18
write clones created in background	0	0.00	0.00
write clones created in foreground	0	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	42,290	43,592
opened cursors current	161	135
workarea memory allocated	0	26,821
logons current	223	177

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
DMS	66	6.82	1.00	68	0
SYSAUX	24	2.50	1.00	64	0
UNDOTBS1	0	0.00	0.00	47	0
SYSTEM	0	0.00	0.00	21	0
SYSPRO	10	10.00	1.00	1	0
ERM	1	10.00	1.00	4	1
CFLOW	2	0.00	3.00	0	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
CFLOW	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\CFLOW.DBF	2	0.00	3.00	0	0
DMS	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\DMS.DBF	66	6.82	1.00	68	0
ERM	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\ERM.DBF	1	10.00	1.00	4	1
SYSAUX	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\SYSAUX01.DB	24	2.50	1.00	64	0
SYSPRO	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\SYSPRO.DBF	10	10.00	1.00	1	0
SYSTEM	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\SYSTEM01.DB	0			21	0
UNDOTBS1	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\UNDOTBS01.D	0			47	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	415,589	100	1,993,469	83	290	0	0	1

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	37	381	3283	17552	184320	17552
E	0	37	374	1669	11754	184320	11754

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	336	0.10	41,559	1.53	368,253
D	672	0.20	83,118	1.53	368,147
D	1,008	0.30	124,677	1.52	368,042
D	1,344	0.40	166,236	1.48	356,168
D	1,680	0.50	207,795	1.41	340,614
D	2,016	0.60	249,354	1.33	320,763
D	2,352	0.70	290,913	1.25	300,912
D	2,688	0.80	332,472	1.16	281,061
D	3,024	0.90	374,031	1.08	261,210
D	3,360	1.00	415,590	1.00	241,359
D	3,696	1.10	457,149	0.92	221,508
D	4,032	1.20	498,708	0.84	201,657
D	4,368	1.30	540,267	0.75	181,806
D	4,704	1.40	581,826	0.67	161,955
D	5,040	1.50	623,385	0.59	142,104
D	5,376	1.60	664,944	0.51	122,253
D	5,712	1.70	706,503	0.42	102,402
D	6,048	1.80	748,062	0.34	82,551
D	6,384	1.90	789,621	0.26	62,700
D	6,720	2.00	831,180	0.18	42,806

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	2,067	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	4,096	3,598	193.85	0.00	0.00	0.00	0.00	419,430
E	4,096	3,614	184.76	26.19	14.18	100.00	0.00	419,430

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	1,295	1,295
64K	128K	5	5
512K	1024K	63	63
1M	2M	9	9
16M	32M	68	68

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 %
512	0.13	892,270.15	100.00
1,024	0.25	892,270.15	100.00
2,048	0.50	892,270.15	100.00
3,072	0.75	892,270.15	100.00
4,096	1.00	892,270.15	100.00
4,915	1.20	892,270.15	100.00
5,734	1.40	892,270.15	100.00
6,554	1.60	892,270.15	100.00
7,373	1.80	892,270.15	100.00
8,192	2.00	892,270.15	100.00
12,288	3.00	892,270.15	100.00
16,384	4.00	892,270.15	100.00
24,576	6.00	892,270.15	100.00
32,768	8.00	892,270.15	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
368	0.53	94	7,314	34,526	1.00	82	1.24	815,568
448	0.65	173	13,029	34,531	1.00	77	1.17	817,688
528	0.77	252	19,900	34,537	1.00	71	1.08	819,865
608	0.88	331	31,623	34,542	1.00	66	1.00	822,467
688	1.00	410	38,524	34,542	1.00	66	1.00	822,678
768	1.12	489	46,744	34,542	1.00	66	1.00	822,798
848	1.23	489	46,744	34,542	1.00	66	1.00	822,798
928	1.35	489	46,744	34,542	1.00	66	1.00	822,798
1,008	1.47	489	46,744	34,542	1.00	66	1.00	822,798
1,088	1.58	489	46,744	34,542	1.00	66	1.00	822,798
1,168	1.70	489	46,744	34,542	1.00	66	1.00	822,798
1,248	1.81	489	46,744	34,542	1.00	66	1.00	822,798
1,328	1.93	489	46,744	34,542	1.00	66	1.00	822,798
1,408	2.05	489	46,744	34,542	1.00	66	1.00	822,798

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,024	0.25	13,819	401,259
2,048	0.50	13,785	371,138
3,072	0.75	13,670	306,260
4,096	1.00	13,560	241,359
5,120	1.25	13,445	176,458
6,144	1.50	13,397	133,206
7,168	1.75	13,396	68,329
8,192	2.00	13,396	46,631

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)
data block	1	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)
TX-Transaction (row lock contention)	10	10	0	10	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

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	180	0.00		0
AWR Alerted Metric Element list	1,490	0.00		0
Consistent RBA	137	0.00		0
FOB s.o list latch	29	0.00		0
In memory undo latch	599	0.17	1.00	164	0.00
JS queue state obj latch	1,872	0.00		0
KMG MMAN ready and startup request latch	87	0.00		0
KTF sga latch	0			54	0.00
KWQMN job cache list latch	2	0.00		0
MQL Tracking Latch	0			5	0.00
Memory Management Latch	0			87	0.00
OS process	732	0.00		0
OS process allocation	529	0.19	0.00	0
OS process: request allocation	442	0.00		0
PL/SQL warning settings	230	0.00		0
SGA IO buffer pool latch	1	0.00		1	0.00
SQL memory manager latch	1	0.00		87	0.00
SQL memory manager workarea list latch	6,215	0.00		0
Shared B-Tree	10	0.00		0
active checkpoint queue latch	236	0.00		0
active service list	1,563	0.00		88	0.00
archive control	2	0.00		0
cache buffer handles	26	0.00		0
cache buffers chains	3,657,743	0.06	0.00	3,425	0.00
cache buffers lru chain	4,906	0.00		150,639	0.00
cache table scan latch	0			1	0.00
channel handle pool latch	442	0.00		0
channel operations parent latch	1,884	0.00		0
checkpoint queue latch	4,778	0.00		265	0.00
client/application info	1,188	0.00		0
compile environment latch	198	0.00		0
dml lock allocation	404	0.00		0
dummy allocation	442	0.00		0
enqueue hash chains	5,828	0.00		0
enqueues	5,880	0.00		0
event group latch	198	0.00		0
file cache latch	23	0.00		0
global KZLD latch for mem in SGA	198	0.00		0
hash table column usage latch	0			303	0.00
job_queue_processes parameter latch	4	0.00		0
kks stats	359	0.00		0
kokc descriptor allocation latch	2	0.00		0
ksuosstats global area	20	0.00		0
ktm global data	6	0.00		0
kwqbsn:qsga	10	0.00		0
lgwr LWN SCN	157	0.00		0
library cache	10,310	0.00		57	0.00
library cache load lock	24	0.00		0
library cache lock	9,583	0.02	0.00	0
library cache lock allocation	632	0.00		0
library cache pin	2,266	0.00		0
library cache pin allocation	4	0.00		0
list of block allocation	41	0.00		0
loader state object freelist	48	0.00		0
messages	2,615	0.00		0
mostly latch-free SCN	157	0.00		0
multiblock read objects	2	0.00		0
ncodef allocation latch	4	0.00		0
object queue header heap	474	0.00		0
object queue header operation	10,703	0.00		0
object stats modification	2	0.00		0
parallel query alloc buffer	36	0.00		0
parameter list	2	0.00		0
parameter table allocation management	244	0.00		0
post/wait queue	154	0.00		105	0.00
process allocation	442	0.00		198	0.00
process group creation	442	0.23	0.00	0
qmn task queue latch	40	22.50	1.00	0
redo allocation	779	0.00		971	0.00
redo copy	0			971	0.00
redo writing	830	0.00		0
resmgr group change latch	198	0.00		0
resmgr:active threads	443	0.00		0
resmgr:actses change group	198	0.00		0
resmgr:free threads list	442	0.00		0
resmgr:schema config	1	0.00		0
row cache objects	18,737	0.00		0
sequence cache	600	0.00		0
session allocation	4,630	0.22	0.00	0
session idle bit	240,684	0.00	0.00	0
session state list latch	400	0.00		0
session switching	4	0.00		0
session timer	88	0.00		0
shared pool	7,139	0.25	0.00	0
shared pool sim alloc	1	0.00		0
shared pool simulator	3,549	0.00		0
simulator hash latch	63,327	0.00		0
simulator lru latch	290	0.00		45,251	0.23
sort extent pool	6	0.00		0
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
threshold alerts latch	5	0.00		0
transaction allocation	32	0.00		0
transaction branch allocation	88	0.00		0
undo global data	830	0.00		0
user lock	884	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	Sleep1	Sleep2	Sleep3
qmn task queue latch	40	9	9	0	0	0	0
In memory undo latch	599	1	1	0	0	0	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	NoWait Misses	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	0	1	0
event range base latch	No latch	0	9	9

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,993,699
Captured Segments account for 96.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
DMS	DMS	OUT_VER_BEGIN_ID_INDEX	INDEX	997,728	50.04
DMS	DMS	DMS_DATA_RELA	TABLE	476,368	23.89
ERM	ERM	ERM_TASK_USERTASK0	TABLE	238,784	11.98
PORTAL	PORTAL	MSG_PERSONMSG_11	TABLE	112,912	5.66
ERM	ERM	ERM_USER_TOKEN	TABLE	27,456	1.38

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 108
Captured Segments account for 27.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
DMS	DMS	PK_DMS_DATA_RELA	INDEX	17	15.74
DMS	DMS	OUT_VER_BEGIN_ID_INDEX	INDEX	10	9.26
DMS	DMS	DMS_DATA_RELA	TABLE	1	0.93
ERM	ERM	ERM_TASKRECORD	TABLE	1	0.93
DMS	DMS	OUT_DATA_ID_INDEX	INDEX	1	0.93

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
ERM	ERM	ERM_USER_TOKEN		TABLE	20	100.00

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Buffer Busy Waits	% of Capture
ERM	ERM	ERM_USER_TOKEN		TABLE	1	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	8	0.00	2	1
dc_database_links	396	0.00	0	1
dc_global_oids	78	0.00	0	146
dc_histogram_data	86	4.65	0	3,593
dc_histogram_defs	146	18.49	0	4,943
dc_object_grants	38	0.00	0	276
dc_object_ids	282	3.55	0	2,368
dc_objects	317	0.63	0	2,496
dc_profiles	198	0.00	0	2
dc_rollback_segments	68	0.00	0	67
dc_segments	52	19.23	3	2,289
dc_tablespaces	278	0.00	0	17
dc_usernames	600	0.00	0	57
dc_users	5,215	0.00	0	93

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
BODY	3	0.00	160	0.00	0
INDEX	1	0.00	1	0.00	0
SQL AREA	1,531	0.65	5,207	0.52	2
TABLE/PROCEDURE	23	4.35	534	2.25	7

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	159.27		0.71	0.66	9	10	225	225
	Freeable	32.88	0.00	0.82	0.74	5		40	40
	SQL	1.24	0.58	0.01	0.02	0	26	217	116
	PL/SQL	0.57	0.15	0.00	0.00	0	0	223	223
E	Other	128.43		0.72	0.74	9	10	179	179
	Freeable	28.56	0.00	0.95	0.79	5		30	30
	SQL	27.43	26.78	0.16	2.01	26	26	171	84
	PL/SQL	0.47	0.14	0.00	0.00	0	0	177	177

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	3,523,215,360
Fixed Size	2,075,368
Redo Buffers	14,700,544
Variable Size	2,902,459,672

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	1.03	1.03	0.00
large	free memory	14.97	14.97	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	CCursor	58.83	58.61	-0.36
shared	FileOpenBlock	14.04	14.04	0.00
shared	Heap0: KGL	10.64	10.64	0.00
shared	KTI-UNDO	25.19	25.19	0.00
shared	PCursor	46.55	46.55	0.00
shared	PL/SQL MPCODE	8.04	8.04	0.00
shared	VIRTUAL CIRCUITS	7.61	7.61	0.00
shared	XDB Schema Cac	7.56	7.56	0.00
shared	event statistics per sess	30.22	30.22	0.00
shared	free memory	75.30	76.42	1.50
shared	library cache	37.22	37.23	0.01
shared	private strands	23.80	23.80	0.00
shared	row cache	7.16	7.16	0.00
shared	sessions	17.87	17.87	0.00
shared	sql area	174.80	174.50	-0.17
shared	sql area:PLSQL	9.14	9.12	-0.22
shared	transaction	7.93	7.93	0.00
	buffer_cache	3,360.00	3,360.00	0.00
	fixed_sga	1.98	1.98	0.00
	log_buffer	14.02	14.02	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\PERA130\ADUMP
background_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\PERA130\BDUMP
compatible	10.2.0.3.0
control_files	E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\PERA130\CONTROL03.CTL
core_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\PERA130\CDUMP
db_block_size	8192
db_domain
db_file_multiblock_read_count	16
db_name	pera130
db_recovery_file_dest	E:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size	2147483648
dispatchers	(PROTOCOL=TCP) (SERVICE=pera130XDB)
job_queue_processes	10
open_cursors	300
pga_aggregate_target	4294967296
processes	3100
remote_login_passwordfile	EXCLUSIVE
sessions	3415
sga_max_size	6442450944
sga_target	4294967296
undo_management	AUTO
undo_tablespace	UNDOTBS1
user_dump_dest	E:\ORACLE\PRODUCT\10.2.0\ADMIN\PERA130\UDUMP

End of Report

% Blocks changed per Read:	0.99	Recursive Call %:	13.09
Rollback per transaction %:	36.36	Rows per Sort:	3591.04

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	99.34	Soft Parse %:	99.72
Execute to Parse %:	5.22	Latch Hit %:	99.95
Parse CPU to Parse Elapsd %:	150.00	% Non-Parse CPU:	99.83