WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

MACLEAN 1694338843 maclean 1 28-7月 -13 19:07 12.1.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MACLEAN	1694338843	maclean	1	28-7月 -13 19:07	12.1.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

XIANGBLI-CN Microsoft Windows x86 64-bit 4 2 1 7.89

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
XIANGBLI-CN	Microsoft Windows x86 64-bit	4	2	1	7.89

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 35 30-7月 -13 15:16:54 51 1.9

End Snap: 36 30-7月 -13 15:20:46 49 2.1

Elapsed: 3.86 (mins)

DB Time: 19.38 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	35	30-7月 -13 15:16:54	51	1.9
End Snap:	36	30-7月 -13 15:20:46	49	2.1
Elapsed:		3.86 (mins)
DB Time:		19.38 (mins)

Report Summary

Top ADDM Findings by Average Active Sessions

Finding Name	Avg active sessions of the task	Percent active sessions of finding	Task Name	Begin Snap Time	End Snap Time
顶级 SQL 语句	5.01	72.07	ADDM:1694338843_1_36	30-7月 -13 15:16	30-7月 -13 15:20
CPU 占用率	5.01	12.78	ADDM:1694338843_1_36	30-7月 -13 15:16	30-7月 -13 15:20
共享池闩锁数	5.01	2.93	ADDM:1694338843_1_36	30-7月 -13 15:16	30-7月 -13 15:20

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 5.0 41.5 0.00 5.59

DB CPU(s): 3.8 31.4 0.00 4.22

Redo size (bytes): 8,841.0 73,169.1

Logical read (blocks): 775,693.1 6,419,746.6

Block changes: 26.4 218.8

Physical read (blocks): 0.0 0.4

Physical write (blocks): 0.4 3.5

Read IO requests: 0.0 0.4

Write IO requests: 0.2 1.2

Read IO (MB): 0.0 0.0

Write IO (MB): 0.0 0.0

User calls: 0.9 7.4

Parses (SQL): 4.1 33.8

Hard parses (SQL): 0.9 7.7

SQL Work Area (MB): 0.2 2.0

Logons: 0.1 0.5

Executes (SQL): 51,716.7 428,014.9

Rollbacks: 0.0 0.0

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	5.0	41.5	0.00	5.59
DB CPU(s):	3.8	31.4	0.00	4.22
Redo size (bytes):	8,841.0	73,169.1
Logical read (blocks):	775,693.1	6,419,746.6
Block changes:	26.4	218.8
Physical read (blocks):	0.0	0.4
Physical write (blocks):	0.4	3.5
Read IO requests:	0.0	0.4
Write IO requests:	0.2	1.2
Read IO (MB):	0.0	0.0
Write IO (MB):	0.0	0.0
User calls:	0.9	7.4
Parses (SQL):	4.1	33.8
Hard parses (SQL):	0.9	7.7
SQL Work Area (MB):	0.2	2.0
Logons:	0.1	0.5
Executes (SQL):	51,716.7	428,014.9
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 170.14 Soft Parse %: 77.14

Execute to Parse %: 99.99 Latch Hit %: 98.05

Parse CPU to Parse Elapsd %: 93.75 % Non-Parse CPU: 99.98

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		877.9		75.5
cursor: pin S	3,206	34	11	2.9	Concurrency
control file sequential read	135	2.4	18	.2	System I/O
db file sequential read	15	.5	31	.0	User I/O
Disk file operations I/O	7	0	0	.0	User I/O
log file sync	2	0	0	.0	Commit
direct path write	1	0	0	.0	User I/O
SQL*Net message to client	117	0	0	.0	Network
db file async I/O submit	0	0		.0	System I/O
db file parallel write	0	0		.0	System I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		878		75.5	3.8
Concurrency	3,206	34	11	2.9	0.1
System I/O	842	15	18	1.3	0.1
User I/O	35	1	19	.1	0.0
Other	252	1	2	.0	0.0
Commit	5	0	0	.0	0.0
Network	117	0	0	.0	0.0

Host CPU

CPUs Cores Sockets Load Average Begin Load Average End %User %System %WIO %Idle

4 2 1 96.8 3.2 0.0

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
4	2	1			96.8	3.2		0.0

Instance CPU

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

94.8 94.8 0.0

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
94.8	94.8	0.0

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 3.9 2.9 1.0

Database Requests: 0.2 0.0 0.2

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 0.2 0.0 0.2

Total (MB): 0.1 0.0 0.0

Database (MB): 0.0 0.0 0.0

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 0.0 0.0 0.0

Database (blocks): 0.5 0.0 0.4

Via Buffer Cache (blocks): 0.5 0.0 0.4

Direct (blocks): 0.0 0.0 0.0

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	3.9	2.9	1.0
Database Requests:	0.2	0.0	0.2
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	0.2	0.0	0.2
Total (MB):	0.1	0.0	0.0
Database (MB):	0.0	0.0	0.0
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	0.0	0.0	0.0
Database (blocks):	0.5	0.0	0.4
Via Buffer Cache (blocks):	0.5	0.0	0.4
Direct (blocks):	0.0	0.0	0.0

Memory Statistics

Begin End

Host Mem (MB): 8,075.2 8,075.2

SGA use (MB): 1,664.0 1,664.0

PGA use (MB): 147.4 146.0

% Host Mem used for SGA+PGA: 22.43 22.41

	Begin	End
Host Mem (MB):	8,075.2	8,075.2
SGA use (MB):	1,664.0	1,664.0
PGA use (MB):	147.4	146.0
% Host Mem used for SGA+PGA:	22.43	22.41

Cache Sizes

Begin End

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

Shared Pool Size: 416M 416M Log Buffer: 6,420K

	Begin	End
Buffer Cache:	1,088M	1,088M	Std Block Size:	8K
Shared Pool Size:	416M	416M	Log Buffer:	6,420K

Shared Pool Statistics

Begin End

Memory Usage %: 92.31 91.94

% SQL with executions>1: 89.29 91.07

% Memory for SQL w/exec>1: 81.17 82.75

	Begin	End
Memory Usage %:	92.31	91.94
% SQL with executions>1:	89.29	91.07
% Memory for SQL w/exec>1:	81.17	82.75

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
Replication Statistics (GoldenGate, XStream)
Streams Statistics
Resource Limit Statistics
Shared Server Statistics
init.ora Parameters
ADDM Reports

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 1162.6s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	1,162.54	99.99
DB CPU	877.86	75.51
PL/SQL execution elapsed time	79.50	6.84
parse time elapsed	4.32	0.37
hard parse elapsed time	4.28	0.37
hard parse (sharing criteria) elapsed time	4.21	0.36
hard parse (bind mismatch) elapsed time	0.06	0.01
PL/SQL compilation elapsed time	0.02	0.00
repeated bind elapsed time	0.00	0.00
sequence load elapsed time	0.00	0.00
DB time	1,162.63
background elapsed time	35.65
background cpu time	0.27

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
FREE_MEMORY_BYTES	2,702,548,992	2,742,288,384
AVG_BUSY_TIME	23,140
AVG_IDLE_TIME	1
AVG_SYS_TIME	731
AVG_USER_TIME	22,398
BUSY_TIME	92,604
IDLE_TIME	12
SYS_TIME	2,975
USER_TIME	89,629
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	8,467,496,960
NUM_CPUS	4
NUM_CPU_CORES	2
NUM_CPU_SOCKETS	1

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
30-7月 15:16:54	0.00
30-7月 15:20:46	0.00	99.99	96.77	3.21	0.01	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 78.7% of Total DB time 1,162.63 (s)
Total FG Wait Time: 36.92 (s) DB CPU time: 877.86 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			878		75.51
Concurrency	3,206	0	34	11	2.93
System I/O	135	0	2	18	0.21
User I/O	23	0	0	20	0.04
Commit	2	0	0	0	0.00
Network	117	0	0	0	0.00
Other	0		0		0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
cursor: pin S	3,206		34	11	114.50	2.93
control file sequential read	135		2	18	4.82	0.21
db file sequential read	15		0	31	0.54	0.04
Disk file operations I/O	7		0	0	0.25	0.00
SQL*Net message from client	117		223	1909	4.18
jobq slave wait	338	99	178	527	12.07

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
control file sequential read	519	0	12	23	18.54	33.58
oracle thread bootstrap	11	0	0	45	0.39	1.39
control file parallel write	77	0	0	4	2.75	0.85
Disk file operations I/O	12	0	0	17	0.43	0.58
log file parallel write	51	0	0	2	1.82	0.22
latch free	219	0	0	0	7.82	0.07
db file parallel write	30	0	0	1	1.07	0.05
db file async I/O submit	30	0	0	0	1.07	0.00
rdbms ipc message	1,194	95	2,721	2278	42.64
Space Manager: slave idle wait	902	0	2,085	2312	32.21
EMON slave idle wait	232	100	1,166	5027	8.29
DIAG idle wait	450	100	464	1031	16.07
Streams AQ: qmn slave idle wait	9	0	252	28035	0.32
Streams AQ: qmn coordinator idle wait	9	100	252	28035	0.32
Streams AQ: emn coordinator idle wait	24	100	241	10023	0.86
dispatcher timer	4	100	240	60031	0.14
lreg timer	77	100	233	3020	2.75
pmon timer	77	100	233	3020	2.75
smon timer	108	0	232	2146	3.86
heartbeat redo informer	227	0	231	1018	8.11
shared server idle wait	7	100	210	30023	0.25
AQPC idle	7	100	210	30023	0.25

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
Disk file operations I/O	17	88.2						11.8
SQL*Net message to client	117	100.0
asynch descriptor resize	11	100.0
control file parallel write	77	27.3	22.1		46.8	1.3	1.3	1.3
control file sequential read	654	32.6	3.8	1.5	1.8	4.0	35.2	21.1
cursor: pin S	3152	44.6	11.4	4.2	4.6	6.8	16.8	11.6
db file async I/O submit	30	100.0
db file parallel write	30	93.3	3.3		3.3
db file sequential read	15					6.7	60.0	33.3
direct path write	1	100.0
latch free	214	100.0
log file parallel write	51	88.2	3.9	2.0	2.0		2.0	2.0
log file sync	5	100.0
oracle thread bootstrap	11				9.1	9.1	18.2	63.6
os thread creation	11	100.0
AQPC idle	7								100.0
DIAG idle wait	449							78.8	21.2
EMON slave idle wait	232								100.0
SQL*Net message from client	117	48.7	.9					37.6	12.8
Space Manager: slave idle wait	875	18.7						3.1	78.2
Streams AQ: emn coordinator idle wait	24								100.0
Streams AQ: qmn coordinator idle wait	9								100.0
Streams AQ: qmn slave idle wait	9								100.0
class slave wait	9	100.0
dispatcher timer	4								100.0
heartbeat redo informer	228							93.9	6.1
jobq slave wait	335							100.0
lreg timer	77								100.0
pmon timer	77								100.0
rdbms ipc message	1195	1.3	.3	.3	.4	.3	.2	34.1	63.1
shared server idle wait	7								100.0
smon timer	108	25.9						2.8	71.3

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s
		% of Total Waits
Disk file operations I/O	2	88.2	5.9		5.9
control file parallel write	1	98.7		1.3
control file sequential read	138	78.9	20.0	1.1
cursor: pin S	367	88.4	11.0	.6	.0
db file sequential read	5	66.7	33.3
log file parallel write	1	98.0	2.0
oracle thread bootstrap	7	36.4	36.4	27.3

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Logical Reads (K)
SYS$USERS	1,168	883	179,658
MACLEAN	0	0	0
MACLEANXDB	0	0	0
SYS$BACKGROUND	0	0	2

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 seconds

Service Name	User I/O Total Wts	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
SYS$USERS	21	3215	34	117
MACLEAN	0	0	0	0
SYS$BACKGROUND	12	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 User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
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
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 61.8% of Total DB Time (s): 1,163
Captured PL/SQL account for 100.3% of Total DB Time (s): 1,163

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
711.87	11,893,050	0.00	61.23	80.47	0.00	2nv8264jgqpqz	sqlplus.exe	SELECT T1 FROM TV WHERE T1=:B1...
232.04	0		19.96	85.01	0.00	0gs2jy6mgja7d	sqlplus.exe	declare vc char(500) :='d'; v...
232.04	0		19.96	86.12	0.00	2873h6j4qyf30	sqlplus.exe	declare vc char(500) :='g'; v...
231.93	0		19.95	61.34	0.00	35vdcf7gbgzun	sqlplus.exe	declare vc char(500) :='c'; v...
230.04	0		19.79	86.67	0.00	0af9jz8dgr1y6	sqlplus.exe	declare vc char(500) :='a'; v...
230.03	0		19.79	60.42	0.00	4xgxq550q3fjr	sqlplus.exe	declare vc char(500) :='b'; v...
7.62	1	7.62	0.66	31.51	5.27	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
1.54	3	0.51	0.13	0.00	0.06	gxuf0knmygd9u		begin prvt_ilm.execute_ilm_sch...
1.51	3	0.50	0.13	0.00	0.06	1kq4ywg3vjywh		SELECT V.TS#, U.TBS_NAME, U.TO...
1.03	1	1.03	0.09	56.19	0.00	f5dqupu2hknzu		WITH a as (SELECT a$.dbid, a$....

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 65.4% of Total CPU Time (s): 878
Captured PL/SQL account for 100.3% of Total CPU Time (s): 878

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
572.87	11,893,050	0.00	65.26	711.87	80.47	0.00	2nv8264jgqpqz	sqlplus.exe	SELECT T1 FROM TV WHERE T1=:B1...
199.84	0		22.76	232.04	86.12	0.00	2873h6j4qyf30	sqlplus.exe	declare vc char(500) :='g'; v...
199.37	0		22.71	230.04	86.67	0.00	0af9jz8dgr1y6	sqlplus.exe	declare vc char(500) :='a'; v...
197.26	0		22.47	232.04	85.01	0.00	0gs2jy6mgja7d	sqlplus.exe	declare vc char(500) :='d'; v...
142.27	0		16.21	231.93	61.34	0.00	35vdcf7gbgzun	sqlplus.exe	declare vc char(500) :='c'; v...
139.00	0		15.83	230.03	60.42	0.00	4xgxq550q3fjr	sqlplus.exe	declare vc char(500) :='b'; v...
2.40	1	2.40	0.27	7.62	31.51	5.27	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
0.58	1	0.58	0.07	1.03	56.19	0.00	f5dqupu2hknzu		WITH a as (SELECT a$.dbid, a$....
0.06	1	0.06	0.01	0.07	88.10	0.00	6wm3n4d7bnddg		SELECT source, (case when tim...
0.05	7	0.01	0.01	0.07	70.97	0.00	5yv7yvjgjxugg		select TIME_WAITED_MICRO from ...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 88.2% of Total User I/O Wait Time (s): 1
Captured PL/SQL account for 90.1% of Total User I/O Wait Time (s): 1

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.40	1	0.40	59.45	7.62	31.51	5.27	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
0.23	1	0.23	33.92	0.24	6.60	97.04	47mm81hm9sggy		SELECT sum(case when a.sessio...
0.21	3	0.07	30.49	0.44	0.00	47.01	4phvdvx32a3mf		begin prvt_ilm.stopjobs(-1, tr...
0.21	3	0.07	30.49	0.44	0.00	47.33	a6ygk0r9s5xuj		SELECT A.JOB_NAME, ( CASE A.ST...
0.16	1	0.16	23.66	0.19	0.00	85.17	4bc30jxu2tnn5		insert into wrh$_tablespace_st...
0.00	3	0.00	0.14	1.51	0.00	0.06	1kq4ywg3vjywh		SELECT V.TS#, U.TBS_NAME, U.TO...
0.00	3	0.00	0.14	1.54	0.00	0.06	gxuf0knmygd9u		begin prvt_ilm.execute_ilm_sch...
0.00	1	0.00	0.02	0.01	233.11	2.47	84u9cfqfk63f9		INSERT INTO WRI$_ADV_ADDM_PDBS...
0.00	34	0.00	0.00	0.00	0.00	0.00	04kug40zbu4dm		select policy#, action# from a...
0.00	1	0.00	0.00	0.08	18.76	0.00	0614tvptjkn2k		WITH awr_evts as (SELECT e.eve...

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 as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 179,752,904
Captured SQL account for 98.2% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
176,567,000	11,893,050	14.85	98.23	711.87	80.5	0	2nv8264jgqpqz	sqlplus.exe	SELECT T1 FROM TV WHERE T1=:B1...
41,500,986	0		23.09	232.04	86.1	0	2873h6j4qyf30	sqlplus.exe	declare vc char(500) :='g'; v...
41,372,900	0		23.02	230.04	86.7	0	0af9jz8dgr1y6	sqlplus.exe	declare vc char(500) :='a'; v...
40,140,739	0		22.33	232.04	85	0	0gs2jy6mgja7d	sqlplus.exe	declare vc char(500) :='d'; v...
28,637,475	0		15.93	231.93	61.3	0	35vdcf7gbgzun	sqlplus.exe	declare vc char(500) :='c'; v...
28,085,853	0		15.62	230.03	60.4	0	4xgxq550q3fjr	sqlplus.exe	declare vc char(500) :='b'; v...
10,935	1	10,935.00	0.01	7.62	31.5	5.3	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
1,131	1	1,131.00	0.00	0.02	173.6	0	84zqd7a3ap5ud		insert into WRH$_SYSSTAT (dbid...
777	3	259.00	0.00	1.54	0	.1	gxuf0knmygd9u		begin prvt_ilm.execute_ilm_sch...
754	1	754.00	0.00	0.03	124.5	0	9hxcwbkfzcg75		UPDATE wrh$_seg_stat_obj ob S...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 10
Captured SQL account for 70.0% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
8	1	8.00	80.00	7.62	31.51	5.27	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
7	1	7.00	70.00	0.24	6.60	97.04	47mm81hm9sggy		SELECT sum(case when a.sessio...
0	34	0.00	0.00	0.00	0.00	0.00	04kug40zbu4dm		select policy#, action# from a...
0	1	0.00	0.00	0.08	18.76	0.00	0614tvptjkn2k		WITH awr_evts as (SELECT e.eve...
0	0		0.00	230.04	86.67	0.00	0af9jz8dgr1y6	sqlplus.exe	declare vc char(500) :='a'; v...
0	1	0.00	0.00	0.00	0.00	0.00	0cn2wm9d7zq8d		SELECT decode(value, 'FATAL', ...
0	0		0.00	232.04	85.01	0.00	0gs2jy6mgja7d	sqlplus.exe	declare vc char(500) :='d'; v...
0	1	0.00	0.00	0.00	0.00	0.00	18c2yb5aj919t		SELECT nvl(e1, 0) as e1, nvl(...
0	4	0.00	0.00	0.00	0.00	0.00	1gfaj4z5hn1kf		delete from dependency$ where ...
0	3	0.00	0.00	1.51	0.00	0.06	1kq4ywg3vjywh		SELECT V.TS#, U.TBS_NAME, U.TO...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 10
Captured SQL account for 800.0% of Total
Total UnOptimized Read Requests: 10
Captured SQL account for 800.0% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
132	132	1	132.00	0.00	1320.00	1uk5m5qbzj1vt	sqlplus.exe	BEGIN dbms_workload_repository...
72	72	3	24.00	0.00	720.00	gxuf0knmygd9u		begin prvt_ilm.execute_ilm_sch...
36	36	1	36.00	0.00	360.00	bnznj24yxuzah		insert into WRH$_IOSTAT_FILETY...
28	28	1	28.00	0.00	280.00	28rx6ccq0j7sa		UPDATE wrh$_tablespace tbs SET...
21	21	3	7.00	0.00	210.00	4phvdvx32a3mf		begin prvt_ilm.stopjobs(-1, tr...
12	12	1	12.00	0.00	120.00	3cksr0218ny42		INSERT INTO wrh$_tempfile (dbi...
4	4	1	4.00	0.00	40.00	9uda0sf1vuzqn		INSERT INTO wrh$_datafile (dbi...
0	0	34	0.00		0.00	04kug40zbu4dm		select policy#, action# from a...
0	0	1	0.00		0.00	0614tvptjkn2k		WITH awr_evts as (SELECT e.eve...
0	0	0			0.00	0af9jz8dgr1y6	sqlplus.exe	declare vc char(500) :='a'; v...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 11,984,417
Captured SQL account for 99.2% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
11,893,050	11,857,101	1.00	711.87	80.5	2nv8264jgqpqz	sqlplus.exe	SELECT T1 FROM TV WHERE T1=:B1...
56	112	2.00	0.01	0	2cpk25dr346vy	SQL Developer	select SQL_ID, SQL_TEXT, execu...
46	0	0.00	0.00	0	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
41	41	1.00	0.00	0	grwydz59pu6mc		select text from view$ where r...
34	0	0.00	0.00	0	04kug40zbu4dm		select policy#, action# from a...
33	494	14.97	0.07	0	7u49y06aqxg1s		select /+ rule / bucket, end...
24	93	3.88	0.00	0	gx4mv66pvj3xz		select con#, type#, condlength...
22	0	0.00	0.00	1487.	ct2g3h4c98fp4		select col#, grantee#, privile...
20	20	1.00	0.00	0	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
18	18	1.00	0.00	1036.	6n2qqv1brfhpp		select ind.type#, ind.property...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 945
Captured SQL account for 40.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
56	56	5.93	2cpk25dr346vy	SQL Developer	select SQL_ID, SQL_TEXT, execu...
46	46	4.87	5ms6rbzdnq16t		select job, nvl2(last_date, 1,...
41	41	4.34	grwydz59pu6mc		select text from view$ where r...
34	34	3.60	04kug40zbu4dm		select policy#, action# from a...
20	20	2.12	f80h0xb1qvbsk		SELECT sys.wri$_adv_seq_msggro...
18	18	1.90	6n2qqv1brfhpp		select ind.type#, ind.property...
16	16	1.69	fs4p95w7yg25b		select pob.parttype from sys.t...
13	13	1.38	fkc81h2686aqc		select pob.parttype from sys.i...
8	8	0.85	6qz82dptj0qr7		select l.col#, l.intcol#, l.lo...
6	6	0.63	2mt126bfb1c5m		SELECT PARAM_VALUE FROM ILM_PA...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,229,780	3	0.28	a6ygk0r9s5xuj		SELECT A.JOB_NAME, ( CASE A.ST...

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

04kug40zbu4dm select policy#, action# from aud_object_opt$ where object# = :1 and type = 2

0614tvptjkn2k WITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count(*) as cnt , a.SQL_ID, a.CON_DBID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_instance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID, a.CON_DBID HAVING count(*) >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret

0af9jz8dgr1y6 declare vc char(500) :='a'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;

0cn2wm9d7zq8d SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'

0gs2jy6mgja7d declare vc char(500) :='d'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;

18c2yb5aj919t SELECT nvl(e1, 0) as e1, nvl(e2, 0) as e2, nvl(e3, 0) as e3, nvl(e4, 0) as e4, nvl(e5, 0) as e5, nvl(e6, 0) as e6 FROM (SELECT e.event_id as event_id, e.event_name as event_name FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid AND e.event_name in ('log file sync', 'gc buffer busy', 'gc buffer busy acquire', 'gc buffer busy release', 'Streams: resolve low memory condition', 'Streams capture: resolve low memory condition') ) PIVOT (max(event_id) FOR event_name IN ('log file sync' as e1, 'gc buffer busy' as e2, 'gc buffer busy acquire' as e3, 'gc buffer busy release' as e4, 'Streams: resolve low memory condition' as e5, 'Streams capture: resolve low memory condition' as e6) )

1gfaj4z5hn1kf delete from dependency$ where d_obj#=:1

1kq4ywg3vjywh SELECT V.TS#, U.TBS_NAME, U.TOTALSIZE, U.MAXSIZE, (U.TOTALSIZE - U.FREESIZE) AS USEDSIZE, CEIL((U.TOTALSIZE-U.FREESIZE)/U.TOTALSIZE*100) AS USED_PCT, CEIL((U.TOTALSIZE - U.FREESIZE)/U.MAXSIZE*100) AS AUTO_USED_PCT FROM (SELECT D.TBS_NAME, D.TOTALSIZE, D.MAXSIZE, (CASE WHEN F.FREESIZE IS NOT NULL THEN F.FREESIZE ELSE 0 END) AS FREESIZE FROM (SELECT TABLESPACE_NAME AS TBS_NAME, SUM(BLOCKS) AS TOTALSIZE, (CASE WHEN AUTOEXTENSIBLE = 'NO' THEN SUM(BLOCKS) ELSE SUM(MAXBLOCKS) END) AS MAXSIZE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME, AUTOEXTENSIBLE) D, (SELECT TABLESPACE_NAME AS TBS_NAME, SUM(BLOCKS) AS FREESIZE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) F WHERE D.TBS_NAME = F.TBS_NAME (+)) U, TS$ V, TABLE(:B1 ) T WHERE T.TBS# = V.TS# AND V.NAME = U.TBS_NAME

1uk5m5qbzj1vt BEGIN dbms_workload_repository.create_snapshot; END;

2873h6j4qyf30 declare vc char(500) :='g'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;

28rx6ccq0j7sa UPDATE wrh$_tablespace tbs SET (snap_id, tsname, contents, segment_space_management, extent_management) = (SELECT /*+ index(ts) */ :lah_snap_id, ts.name tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management FROM (select * from wrh$_tablespace where dbid = :dbid AND con_dbid = :srcdbid ) tb, ts$ ts, v$tablespace t2 WHERE ts.ts# = tb.ts# and ts.ts# = t2.ts# and tb.ts# = tbs.ts# and tb.snap_id < :snap_id ) WHERE dbid = :dbid AND con_dbid = :srcdbid AND snap_id < :snap_id AND ts# in (select ts# from v$tablespace ) AND ts# in (select ts# from ts$ )

2cpk25dr346vy select SQL_ID, SQL_TEXT, executions FROM v$SQL where sql_id='2nv8264jgqpqz'

2mt126bfb1c5m SELECT PARAM_VALUE FROM ILM_PARAM$ WHERE PARAM# = :B1

2nv8264jgqpqz SELECT T1 FROM TV WHERE T1=:B1

35vdcf7gbgzun declare vc char(500) :='c'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;

3cksr0218ny42 INSERT INTO wrh$_tempfile (dbid, con_dbid, snap_id, file#, creation_change#, filename, ts#, tsname, block_size ) SELECT :dbid, :srcdbid con_dbid, :lah_snap_id, tf.file# file#, tf.creation_change# cr_chg#, tf.name name, ts.ts# ts#, ts.name tsname, tf.block_size block_size FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND not exists (SELECT 1 FROM wrh$_tempfile tfh WHERE tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change# AND tfh.dbid = :dbid)

47mm81hm9sggy SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid

4bc30jxu2tnn5 insert into wrh$_tablespace_stat (dbid, con_dbid, snap_id, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup ) select :dbid, :srcdbid con_dbid, :snap_id, :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#

4phvdvx32a3mf begin prvt_ilm.stopjobs(-1, true, true, :1); end;

4xgxq550q3fjr declare vc char(500) :='b'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;

5ms6rbzdnq16t 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) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job

5yv7yvjgjxugg select TIME_WAITED_MICRO from V$SYSTEM_EVENT where event = 'Shared IO Pool Memory'

6n2qqv1brfhpp select ind.type#, ind.property, base_obj.obj#, base_owner.name, base_obj.name from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = :oid and ind.dataobj# = :doid and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#

6qz82dptj0qr7 select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc

6wm3n4d7bnddg SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi. snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC

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

84u9cfqfk63f9 INSERT INTO WRI$_ADV_ADDM_PDBS (CON_DBID, PDB_NAME) SELECT CON_DBID, SUBSTR(X , 20) FROM ( SELECT I.CON_DBID, MAX(TO_CHAR(I.OPEN_TIME, 'YYYY:MM:DD HH24:MI:SS') || I.PDB_NAME) AS X FROM DBA_HIST_PDB_INSTANCE I, DBA_HIST_SNAPSHOT S WHERE S.DBID = :B1 AND S.INSTANCE_NUMBER = I.INSTANCE_NUMBER AND S.SNAP_ID = :B3 AND I.STARTUP_TIME >= S.STARTUP_TIME AND I.STARTUP_TIME <= :B2 AND I.CON_DBID <> 0 AND I.CON_DBID <> :B1 AND I.DBID = :B1 AND I.PDB_NAME IS NOT NULL GROUP BY I.CON_DBID )

84zqd7a3ap5ud insert into WRH$_SYSSTAT (dbid, con_dbid, snap_id, instance_number, stat_id, value) select :dbid, :srcdbid con_dbid, :snap_id, :instance_number, stat_id, value from v$sysstat

9hxcwbkfzcg75 UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, partition_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT snap_id + 1, nvl(ownername_kewrseg, owner), nvl(objname_kewrseg, object_name), nvl(subobjname_kewrseg, subobject_name), nvl(tsname_kewrseg, tablespace_name), decode(objtype_kewrseg, 0, object_type, sys.dbms_swrf_internal.awr_decode_object_type(objtype_kewrseg)), decode(ptype_kewrseg, 0, partition_type, decode(ptype_kewrseg, 0, 'NONE', 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN')), decode(indtype_kewrseg, 0, index_type, decode(indtype_kewrseg, 1, 'NORMAL'|| decode(bitand( iprop_kewrseg, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN')), coalesce(nullif(bobjn_kewrseg, 0), so.base_obj#), case bobjname_kewrseg when NULL then so.base_object_name else case length(bobjname_kewrseg) when 0 then so.base_object_name else bobjname_kewrseg end end, case bowname_kewrseg when NULL then so.base_object_owner else case length(bowname_kewrseg) when 0 then so.base_object_owner else bowname_kewrseg end end FROM wrh$_seg_stat_obj so JOIN x$kewrtsegstat io ON (dbid = :dbid and con_dbid = con_dbid_kewrseg and ts# = tsn_kewrseg and obj# = objn_kewrseg and dataobj# = objd_kewrseg) WHERE ob.dbid = so.dbid AND ob.con_dbid = so.con_dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (ts#, obj#, dataobj#, con_dbid) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg, con_dbid_kewrseg FROM x$kewrtsegstat)

9uda0sf1vuzqn INSERT INTO wrh$_datafile (dbid, con_dbid, snap_id, file#, creation_change#, filename, ts#, tsname, block_size) SELECT /*+ ordered index(f) index(ts) */ :dbid, :srcdbid con_dbid, :lah_snap_id, f.file# file#, f.crscnbas + (f.crscnwrp * power(2, 32)) creation_change#, v.name filename, ts.ts# ts#, ts.name tsname, ts.blocksize block_size FROM v$dbfile v, file$ f, ts$ ts WHERE f.file# = v.file# and f.status$ = 2 and f.ts# = ts.ts# and not exists (SELECT 1 from wrh$_datafile dfh WHERE dfh.file# = f.file# AND dfh.creation_change# = (f.crscnbas + (f.crscnwrp * power(2, 32))) AND dfh.dbid = :dbid)

a6ygk0r9s5xuj SELECT A.JOB_NAME, ( CASE A.STATE WHEN 'SCHEDULED' THEN :B11 WHEN 'DISABLED' THEN :B10 WHEN 'RUNNING' THEN :B9 ELSE :B8 END ) FROM DBA_SCHEDULER_JOBS A, ILM_RESULTS$ B, USER$ C, ILM_EXECUTION$ D WHERE A.JOB_NAME = B.JOBNAME AND (B.EXECUTION_ID = :B7 OR :B7 =:B6 ) AND B.EXECUTION_ID = D.EXECUTION_ID AND (B.JOBTYPE = :B5 OR :B5 = :B3 ) AND (B.JOBTYPE1 = :B4 OR :B4 = :B3 ) AND C.USER# = D.OWNER AND (:B1 = :B2 OR D.FLAG = :B1 )

bnznj24yxuzah insert into WRH$_IOSTAT_FILETYPE (dbid, con_dbid, snap_id, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error ) select :dbid, :srcdbid con_dbid, :snap_id, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large _write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id

ct2g3h4c98fp4 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)), min(bitand(nvl(option$, 0), 4) /4), max(bitand(nvl(option$, 0), 8) /8), max(bitand(nvl(option$, 0), 16) /16) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

f5dqupu2hknzu WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.TIME_MODEL, a$.CON_DBID FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , CON_DBID, PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID FROM ( SELECT count(*) as cnt , a.CON_DBID, a.PLSQL_ENTRY_OBJECT_ID, a.PLSQL_ENTRY_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID > 0 AND a.PLSQL_ENTRY_SUBPROGRAM_ID > 0 GROUP BY CON_DBID, PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID HAVING count(*) >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT x.con_dbid, x.plsql_entry_object_id, x.plsql_entry_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(d ba.overload), x.cnt FROM dba_procedures dba, ash x WHERE x.plsql_entry_object_id = dba.object_id(+) AND x.plsql_entry_subprogram_id = dba.subprogram_id(+) ORDER BY x.cnt DESC, x.plsql_entry_object_id, x.plsql_entry_subprogram_id

f80h0xb1qvbsk SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual

fkc81h2686aqc select pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj# and ip.obj# = :oid

fs4p95w7yg25b select pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# and tp.obj# = :oid

grwydz59pu6mc select text from view$ where rowid=:1

gx4mv66pvj3xz select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1

gxuf0knmygd9u begin prvt_ilm.execute_ilm_sch(:1, :2); end;

SQL Id	SQL Text
04kug40zbu4dm	select policy#, action# from aud_object_opt$ where object# = :1 and type = 2
0614tvptjkn2k	WITH awr_evts as (SELECT e.event_id, e.wait_class FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid) , en as (SELECT event_id, nvl(v.wait_class, awr_evts.wait_class) as wait_class FROM awr_evts FULL OUTER JOIN V$EVENT_NAME v USING(event_id) UNION ALL SELECT 0 as event_id, 'CPU' as wait_class FROM DUAL ) SELECT * FROM ( SELECT count() as cnt , a.SQL_ID, a.CON_DBID, sum(decode(a.wait_time, 0, 0, 1)) as on_cpu, sum(case when a.wait_time = 0 and en.wait_class = 'User I/O' then 1 else 0 end) as io_wait, sum(case when a.wait_time = 0 and en.wait_class = 'Cluster' then 1 else 0 end) as cl_wait, sum(decode(bitand(a.time_model, power(2, 4)), 0, 0, NULL, 0, 1)) as in_parse, sum(decode(bitand(a.time_model, power(2, 14)), 0, 0, NULL, 0, 1)) as in_java, sum(decode(bitand(a.time_model, power(2, 11)+power(2, 12)), NULL, 0, 0, 0, 1)) as in_pls, max(a.sql_opcode) as opcode, sum(case when a.qc_session_id <> 0 and a.qc_session_id <> a.session_id and a.qc_instance_id <> 0 and a.qc_instance_id <> a.instance_number then 1 else 0 end) as pq_cnt, count(distinct nvl(a.sql_plan_hash_value, 0)) as plans, count(distinct decode(nvl(a.sql_plan_hash_value, 0), 0, 1, 0)) as noplan FROM WRH$_ACTIVE_SESSION_HISTORY a , en WHERE a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid AND en.event_id = decode(a.wait_time, 0, a.event_id, 0) AND a.sql_id is NOT NULL AND a.session_type = 1 AND en.wait_class <> 'Idle' GROUP BY a.SQL_ID, a.CON_DBID HAVING count() >= :rowcnt ORDER BY count(*) DESC, a.SQL_ID ASC ) WHERE rownum <= :ret
0af9jz8dgr1y6	declare vc char(500) :='a'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;
0cn2wm9d7zq8d	SELECT decode(value, 'FATAL', 1, 'ERROR', 2, 'WARNING', 3, 'INFORMATION', 4, 'INFORMATION2', 5, 'INFORMATION3', 6, 'INFORMATION4', 7, 'INFORMATION5', 8, 'INFORMATION6', 9, 0) FROM sys.wri$_adv_parameters WHERE task_id = :1 AND name = 'JOURNALING'
0gs2jy6mgja7d	declare vc char(500) :='d'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;
18c2yb5aj919t	SELECT nvl(e1, 0) as e1, nvl(e2, 0) as e2, nvl(e3, 0) as e3, nvl(e4, 0) as e4, nvl(e5, 0) as e5, nvl(e6, 0) as e6 FROM (SELECT e.event_id as event_id, e.event_name as event_name FROM WRH$_EVENT_NAME e WHERE e.dbid = :dbid AND e.event_name in ('log file sync', 'gc buffer busy', 'gc buffer busy acquire', 'gc buffer busy release', 'Streams: resolve low memory condition', 'Streams capture: resolve low memory condition') ) PIVOT (max(event_id) FOR event_name IN ('log file sync' as e1, 'gc buffer busy' as e2, 'gc buffer busy acquire' as e3, 'gc buffer busy release' as e4, 'Streams: resolve low memory condition' as e5, 'Streams capture: resolve low memory condition' as e6) )
1gfaj4z5hn1kf	delete from dependency$ where d_obj#=:1
1kq4ywg3vjywh	SELECT V.TS#, U.TBS_NAME, U.TOTALSIZE, U.MAXSIZE, (U.TOTALSIZE - U.FREESIZE) AS USEDSIZE, CEIL((U.TOTALSIZE-U.FREESIZE)/U.TOTALSIZE100) AS USED_PCT, CEIL((U.TOTALSIZE - U.FREESIZE)/U.MAXSIZE100) AS AUTO_USED_PCT FROM (SELECT D.TBS_NAME, D.TOTALSIZE, D.MAXSIZE, (CASE WHEN F.FREESIZE IS NOT NULL THEN F.FREESIZE ELSE 0 END) AS FREESIZE FROM (SELECT TABLESPACE_NAME AS TBS_NAME, SUM(BLOCKS) AS TOTALSIZE, (CASE WHEN AUTOEXTENSIBLE = 'NO' THEN SUM(BLOCKS) ELSE SUM(MAXBLOCKS) END) AS MAXSIZE FROM DBA_DATA_FILES GROUP BY TABLESPACE_NAME, AUTOEXTENSIBLE) D, (SELECT TABLESPACE_NAME AS TBS_NAME, SUM(BLOCKS) AS FREESIZE FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) F WHERE D.TBS_NAME = F.TBS_NAME (+)) U, TS$ V, TABLE(:B1 ) T WHERE T.TBS# = V.TS# AND V.NAME = U.TBS_NAME
1uk5m5qbzj1vt	BEGIN dbms_workload_repository.create_snapshot; END;
2873h6j4qyf30	declare vc char(500) :='g'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;
28rx6ccq0j7sa	UPDATE wrh$_tablespace tbs SET (snap_id, tsname, contents, segment_space_management, extent_management) = (SELECT /+ index(ts) / :lah_snap_id, ts.name tsname, decode(ts.contents$, 0, (decode(bitand(ts.flags, 16), 16, 'UNDO', 'PERMANENT')), 1, 'TEMPORARY') as contents, decode(bitand(ts.flags, 32), 32, 'AUTO', 'MANUAL') as segspace_mgmt, decode(ts.bitmapped, 0, 'DICTIONARY', 'LOCAL') as extent_management FROM (select * from wrh$_tablespace where dbid = :dbid AND con_dbid = :srcdbid ) tb, ts$ ts, v$tablespace t2 WHERE ts.ts# = tb.ts# and ts.ts# = t2.ts# and tb.ts# = tbs.ts# and tb.snap_id < :snap_id ) WHERE dbid = :dbid AND con_dbid = :srcdbid AND snap_id < :snap_id AND ts# in (select ts# from v$tablespace ) AND ts# in (select ts# from ts$ )
2cpk25dr346vy	select SQL_ID, SQL_TEXT, executions FROM v$SQL where sql_id='2nv8264jgqpqz'
2mt126bfb1c5m	SELECT PARAM_VALUE FROM ILM_PARAM$ WHERE PARAM# = :B1
2nv8264jgqpqz	SELECT T1 FROM TV WHERE T1=:B1
35vdcf7gbgzun	declare vc char(500) :='c'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;
3cksr0218ny42	INSERT INTO wrh$_tempfile (dbid, con_dbid, snap_id, file#, creation_change#, filename, ts#, tsname, block_size ) SELECT :dbid, :srcdbid con_dbid, :lah_snap_id, tf.file# file#, tf.creation_change# cr_chg#, tf.name name, ts.ts# ts#, ts.name tsname, tf.block_size block_size FROM v$tempfile tf, ts$ ts WHERE tf.ts# = ts.ts# AND not exists (SELECT 1 FROM wrh$_tempfile tfh WHERE tfh.file# = tf.file# AND tfh.creation_change# = tf.creation_change# AND tfh.dbid = :dbid)
47mm81hm9sggy	SELECT sum(case when a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgw, sum(case when a.session_type = 1 and a.wait_time <> 0 then 1 else 0 end) as fgc, sum(case when a.session_type <> 1 and a.wait_time = 0 then 1 else 0 end) as bgw, sum(case when a.session_type <> 1 and a.wait_time <> 0 then 1 else 0 end) as bgc, sum(case when v.event_id is not null and a.session_type = 1 and a.wait_time = 0 then 1 else 0 end) as fgi FROM WRH$_ACTIVE_SESSION_HISTORY a , V$EVENT_NAME v WHERE a.event_id = v.event_id(+) AND v.wait_class(+) = 'Idle' AND a.dbid = :dbid AND a.instance_number = :inst AND a.snap_id > :bid AND a.snap_id <= :eid
4bc30jxu2tnn5	insert into wrh$_tablespace_stat (dbid, con_dbid, snap_id, instance_number, ts#, tsname, contents, status, segment_space_management, extent_management, is_backup ) select :dbid, :srcdbid con_dbid, :snap_id, :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#
4phvdvx32a3mf	begin prvt_ilm.stopjobs(-1, true, true, :1); end;
4xgxq550q3fjr	declare vc char(500) :='b'; vb char(500); begin loop select t1 into vb from tv where t1=vc; end loop; end;
5ms6rbzdnq16t	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) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job
5yv7yvjgjxugg	select TIME_WAITED_MICRO from V$SYSTEM_EVENT where event = 'Shared IO Pool Memory'
6n2qqv1brfhpp	select ind.type#, ind.property, base_obj.obj#, base_owner.name, base_obj.name from sys.ind$ ind, sys.user$ base_owner, sys.obj$ base_obj where ind.obj# = :oid and ind.dataobj# = :doid and ind.bo# = base_obj.obj# and base_obj.owner# = base_owner.user#
6qz82dptj0qr7	select l.col#, l.intcol#, l.lobj#, l.ind#, l.ts#, l.file#, l.block#, l.chunk, l.pctversion$, l.flags, l.property, l.retention, l.freepools from lob$ l where l.obj# = :1 order by l.intcol# asc
6wm3n4d7bnddg	SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi. snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER B Y source ASC, time_secs DESC, log_id ASC
7u49y06aqxg1s	select /+ rule / bucket, endpoint, col#, epvalue, epvalue_raw, ep_repeat_count from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
84u9cfqfk63f9	INSERT INTO WRI$_ADV_ADDM_PDBS (CON_DBID, PDB_NAME) SELECT CON_DBID, SUBSTR(X , 20) FROM ( SELECT I.CON_DBID, MAX(TO_CHAR(I.OPEN_TIME, 'YYYY:MM:DD HH24:MI:SS') \|\| I.PDB_NAME) AS X FROM DBA_HIST_PDB_INSTANCE I, DBA_HIST_SNAPSHOT S WHERE S.DBID = :B1 AND S.INSTANCE_NUMBER = I.INSTANCE_NUMBER AND S.SNAP_ID = :B3 AND I.STARTUP_TIME >= S.STARTUP_TIME AND I.STARTUP_TIME <= :B2 AND I.CON_DBID <> 0 AND I.CON_DBID <> :B1 AND I.DBID = :B1 AND I.PDB_NAME IS NOT NULL GROUP BY I.CON_DBID )
84zqd7a3ap5ud	insert into WRH$_SYSSTAT (dbid, con_dbid, snap_id, instance_number, stat_id, value) select :dbid, :srcdbid con_dbid, :snap_id, :instance_number, stat_id, value from v$sysstat
9hxcwbkfzcg75	UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, partition_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT snap_id + 1, nvl(ownername_kewrseg, owner), nvl(objname_kewrseg, object_name), nvl(subobjname_kewrseg, subobject_name), nvl(tsname_kewrseg, tablespace_name), decode(objtype_kewrseg, 0, object_type, sys.dbms_swrf_internal.awr_decode_object_type(objtype_kewrseg)), decode(ptype_kewrseg, 0, partition_type, decode(ptype_kewrseg, 0, 'NONE', 1, 'RANGE', 2, 'HASH', 3, 'SYSTEM', 4, 'LIST', NULL, 'NONE', 'UNKNOWN')), decode(indtype_kewrseg, 0, index_type, decode(indtype_kewrseg, 1, 'NORMAL'\|\| decode(bitand( iprop_kewrseg, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LOB', 9, 'DOMAIN')), coalesce(nullif(bobjn_kewrseg, 0), so.base_obj#), case bobjname_kewrseg when NULL then so.base_object_name else case length(bobjname_kewrseg) when 0 then so.base_object_name else bobjname_kewrseg end end, case bowname_kewrseg when NULL then so.base_object_owner else case length(bowname_kewrseg) when 0 then so.base_object_owner else bowname_kewrseg end end FROM wrh$_seg_stat_obj so JOIN x$kewrtsegstat io ON (dbid = :dbid and con_dbid = con_dbid_kewrseg and ts# = tsn_kewrseg and obj# = objn_kewrseg and dataobj# = objd_kewrseg) WHERE ob.dbid = so.dbid AND ob.con_dbid = so.con_dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (ts#, obj#, dataobj#, con_dbid) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg, con_dbid_kewrseg FROM x$kewrtsegstat)
9uda0sf1vuzqn	INSERT INTO wrh$_datafile (dbid, con_dbid, snap_id, file#, creation_change#, filename, ts#, tsname, block_size) SELECT /+ ordered index(f) index(ts) / :dbid, :srcdbid con_dbid, :lah_snap_id, f.file# file#, f.crscnbas + (f.crscnwrp * power(2, 32)) creation_change#, v.name filename, ts.ts# ts#, ts.name tsname, ts.blocksize block_size FROM v$dbfile v, file$ f, ts$ ts WHERE f.file# = v.file# and f.status$ = 2 and f.ts# = ts.ts# and not exists (SELECT 1 from wrh$_datafile dfh WHERE dfh.file# = f.file# AND dfh.creation_change# = (f.crscnbas + (f.crscnwrp * power(2, 32))) AND dfh.dbid = :dbid)
a6ygk0r9s5xuj	SELECT A.JOB_NAME, ( CASE A.STATE WHEN 'SCHEDULED' THEN :B11 WHEN 'DISABLED' THEN :B10 WHEN 'RUNNING' THEN :B9 ELSE :B8 END ) FROM DBA_SCHEDULER_JOBS A, ILM_RESULTS$ B, USER$ C, ILM_EXECUTION$ D WHERE A.JOB_NAME = B.JOBNAME AND (B.EXECUTION_ID = :B7 OR :B7 =:B6 ) AND B.EXECUTION_ID = D.EXECUTION_ID AND (B.JOBTYPE = :B5 OR :B5 = :B3 ) AND (B.JOBTYPE1 = :B4 OR :B4 = :B3 ) AND C.USER# = D.OWNER AND (:B1 = :B2 OR D.FLAG = :B1 )
bnznj24yxuzah	insert into WRH$_IOSTAT_FILETYPE (dbid, con_dbid, snap_id, instance_number, filetype_id, small_read_megabytes, small_write_megabytes, large_read_megabytes, large_write_megabytes, small_read_reqs, small_write_reqs, small_sync_read_reqs, large_read_reqs, large_write_reqs, small_read_servicetime, small_write_servicetime, small_sync_read_latency, large_read_servicetime, large_write_servicetime, retries_on_error ) select :dbid, :srcdbid con_dbid, :snap_id, :instance_number, filetype_id, sum(small_read_megabytes) small_read_megabytes, sum(small_write_megabytes) small_write_megabytes, sum(large_read_megabytes) large_read_megabytes, sum(large_write_megabytes) large_write_megabytes, sum(small_read_reqs) small_read_reqs, sum(small_write_reqs) small_write_reqs, sum(small_sync_read_reqs) small_sync_read_reqs, sum(large_read_reqs) large_read_reqs, sum(large_write_reqs) large _write_reqs, sum(small_read_servicetime) small_read_servicetime, sum(small_write_servicetime) small_write_servicetime, sum(small_sync_read_latency) small_sync_read_latency, sum(large_read_servicetime) large_read_servicetime, sum(large_write_servicetime) large_write_servicetime, sum(retries_on_error) retries_on_error from v$iostat_file group by filetype_id
ct2g3h4c98fp4	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)), min(bitand(nvl(option$, 0), 4) /4), max(bitand(nvl(option$, 0), 8) /8), max(bitand(nvl(option$, 0), 16) /16) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
f5dqupu2hknzu	WITH a as (SELECT a$.dbid, a$.snap_id, a$.INSTANCE_NUMBER, a$.PLSQL_ENTRY_OBJECT_ID, a$.PLSQL_ENTRY_SUBPROGRAM_ID, a$.TIME_MODEL, a$.CON_DBID FROM WRH$_ACTIVE_SESSION_HISTORY a$ WHERE a$.dbid = :dbid AND a$.instance_number = :inst AND a$.snap_id > :bid AND a$.snap_id <= :eid AND a$.session_type = 1 ) , ash as (SELECT cnt , CON_DBID, PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID FROM ( SELECT count() as cnt , a.CON_DBID, a.PLSQL_ENTRY_OBJECT_ID, a.PLSQL_ENTRY_SUBPROGRAM_ID FROM a WHERE bitand(a.time_model, power(2, 11 )) !=0 AND a.PLSQL_ENTRY_OBJECT_ID > 0 AND a.PLSQL_ENTRY_SUBPROGRAM_ID > 0 GROUP BY CON_DBID, PLSQL_ENTRY_OBJECT_ID, PLSQL_ENTRY_SUBPROGRAM_ID HAVING count() >= :rowcnt ORDER BY 1 DESC, 2 ASC ) WHERE rownum <= :ret) SELECT x.con_dbid, x.plsql_entry_object_id, x.plsql_entry_subprogram_id, dba.object_name, dba.object_type, dba.owner, dba.procedure_name, to_number(d ba.overload), x.cnt FROM dba_procedures dba, ash x WHERE x.plsql_entry_object_id = dba.object_id(+) AND x.plsql_entry_subprogram_id = dba.subprogram_id(+) ORDER BY x.cnt DESC, x.plsql_entry_object_id, x.plsql_entry_subprogram_id
f80h0xb1qvbsk	SELECT sys.wri$_adv_seq_msggroup.nextval FROM dual
fkc81h2686aqc	select pob.parttype from sys.indpart$ ip, sys.partobj$ pob where ip.bo# = pob.obj# and ip.obj# = :oid
fs4p95w7yg25b	select pob.parttype from sys.tabpart$ tp, sys.partobj$ pob where tp.bo# = pob.obj# and tp.obj# = :oid
grwydz59pu6mc	select text from view$ where rowid=:1
gx4mv66pvj3xz	select con#, type#, condlength, intcols, robj#, rcon#, match#, refact, nvl(enabled, 0), rowid, cols, nvl(defer, 0), mtime, nvl(spare1, 0), spare2, spare3 from cdef$ where obj#=:1
gxuf0knmygd9u	begin prvt_ilm.execute_ilm_sch(:1, :2); end;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Key Instance Activity Stats
Other Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	6,125	26.43	218.75
execute count	11,984,417	51,716.71	428,014.89
logons cumulative	13	0.06	0.46
opened cursors cumulative	11,984,421	51,716.73	428,015.04
parse count (total)	945	4.08	33.75
parse time elapsed	16	0.07	0.57
physical reads	10	0.04	0.36
physical writes	99	0.43	3.54
redo size	2,048,736	8,840.97	73,169.14
session logical reads	179,752,904	775,693.06	6,419,746.57
user calls	208	0.90	7.43
user commits	28	0.12	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	314	1.36	11.21

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	5	0.02	0.18
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	15	0.06	0.54
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	10	0.04	0.36
Batched IO single block count	5	0.02	0.18
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	14	0.06	0.50
CCursor + sql area evicted	129	0.56	4.61
CLI BG ENQ	76	0.33	2.71
CLI BG Fls done	0	0.00	0.00
CLI BG attempt Flush	76	0.33	2.71
CLI Flstask create	76	0.33	2.71
CLI Flush	76	0.33	2.71
CLI SGA Alloc	0	0.00	0.00
CLI Thru Wrt	0	0.00	0.00
CLI bytes fls to table	0	0.00	0.00
CPU used by this session	88,092	380.15	3,146.14
CPU used when call started	294	1.27	10.50
CR blocks created	14	0.06	0.50
Cached Commit SCN referenced	102	0.44	3.64
Commit SCN cached	1	0.00	0.04
DBWR checkpoint buffers written	95	0.41	3.39
DBWR checkpoints	0	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	5	0.02	0.18
DBWR undo block writes	57	0.25	2.04
Effective IO time	0	0.00	0.00
HSC Compressed Segment Block Changes	0	0.00	0.00
HSC Heap Segment Block Changes	681	2.94	24.32
HSC IDL Compressed Blocks	0	0.00	0.00
HSC OLTP Compressed Blocks	0	0.00	0.00
HSC OLTP Non Compressible Blocks	0	0.00	0.00
HSC OLTP Space Saving	0	0.00	0.00
HSC OLTP positive compression	0	0.00	0.00
HSC OLTP recursive compression	0	0.00	0.00
Heap Segment Array Inserts	119	0.51	4.25
Heap Segment Array Updates	5	0.02	0.18
Heatmap BlkLevel Flushed	0	0.00	0.00
Heatmap BlkLevel Flushed to BF	0	0.00	0.00
Heatmap BlkLevel Not Updated - Repeat	0	0.00	0.00
Heatmap BlkLevel Ranges Flushed	0	0.00	0.00
Heatmap BlkLevel Tracked	0	0.00	0.00
Heatmap Blklevel Flush Task Count	0	0.00	0.00
Heatmap SegLevel - Flush	0	0.00	0.00
Heatmap SegLevel - Full Table Scan	0	0.00	0.00
Heatmap SegLevel - IndexLookup	0	0.00	0.00
Heatmap SegLevel - Segments flushed	0	0.00	0.00
Heatmap SegLevel - Write	0	0.00	0.00
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	3	0.01	0.11
IMU Redo allocation size	84,132	363.06	3,004.71
IMU commits	16	0.07	0.57
IMU contention	0	0.00	0.00
IMU ktichg flush	1	0.00	0.04
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	92,744	400.22	3,312.29
IMU- failed to get a private strand	0	0.00	0.00
KTFB alloc req	5	0.02	0.18
KTFB alloc space (block)	327,680	1,414.05	11,702.86
KTFB alloc time (ms)	306	1.32	10.93
KTFB apply req	0	0.00	0.00
KTFB apply time (ms)	0	0.00	0.00
KTFB commit req	0	0.00	0.00
KTFB commit time (ms)	0	0.00	0.00
KTFB free req	0	0.00	0.00
KTFB free space (block)	0	0.00	0.00
KTFB free time (ms)	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
Requests to/from client	118	0.51	4.21
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for undo segment shrink	0	0.00	0.00
SQL*Net roundtrips to/from client	117	0.50	4.18
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	93	0.40	3.32
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	1,135	4.90	40.54
branch node splits	0	0.00	0.00
buffer is not pinned count	6,259	27.01	223.54
buffer is pinned count	3,904	16.85	139.43
bytes received via SQL*Net from client	22,883	98.75	817.25
bytes sent via SQL*Net to client	49,177	212.21	1,756.32
calls to get snapshot scn: kcmgss	11,985,712	51,722.30	428,061.14
calls to kcmgas	123	0.53	4.39
calls to kcmgcs	35,949,172	155,132.53	1,283,899.00
cell physical IO interconnect bytes	16,268,800	70,205.24	581,028.57
change write time	1	0.00	0.04
cleanout - number of ktugct calls	105	0.45	3.75
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	11	0.05	0.39
cluster key scan block gets	495	2.14	17.68
cluster key scans	274	1.18	9.79
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: callback failure	17	0.07	0.61
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	445	1.92	15.89
commit cleanouts successfully completed	428	1.85	15.29
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	51	0.22	1.82
consistent changes	117	0.50	4.18
consistent gets	179,746,785	775,666.65	6,419,528.04
consistent gets direct	0	0.00	0.00
consistent gets examination	3,519	15.19	125.68
consistent gets examination (fastpath)	3,391	14.63	121.11
consistent gets from cache	179,746,790	775,666.68	6,419,528.21
consistent gets pin	179,743,264	775,651.46	6,419,402.29
consistent gets pin (fastpath)	179,743,174	775,651.07	6,419,399.07
cursor authentications	82	0.35	2.93
data blocks consistent reads - undo records applied	114	0.49	4.07
db block gets	6,127	26.44	218.82
db block gets direct	0	0.00	0.00
db block gets from cache	6,127	26.44	218.82
db block gets from cache (fastpath)	2,572	11.10	91.86
deferred (CURRENT) block cleanout applications	301	1.30	10.75
dirty buffers inspected	0	0.00	0.00
enqueue conversions	97	0.42	3.46
enqueue releases	5,354	23.10	191.21
enqueue requests	5,355	23.11	191.25
enqueue timeouts	0	0.00	0.00
enqueue waits	0	0.00	0.00
fastpath consistent get quota limit	0	0.00	0.00
file io service time	0	0.00	0.00
free buffer inspected	7	0.03	0.25
free buffer requested	142	0.61	5.07
heap block compress	3	0.01	0.11
hot buffers moved to head of LRU	0	0.00	0.00
immediate (CR) block cleanout applications	11	0.05	0.39
immediate (CURRENT) block cleanout applications	104	0.45	3.71
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fetch by key	1,680	7.25	60.00
index scans kdiixs1	1,406	6.07	50.21
leaf node 90-10 splits	2	0.01	0.07
leaf node splits	42	0.18	1.50
lob reads	0	0.00	0.00
lob writes	0	0.00	0.00
lob writes unaligned	0	0.00	0.00
logical read bytes from cache	1,472,535,838,720	6,354,477,753.27	52,590,565,668.57
max cf enq hold time	0	0.00	0.00
messages received	87	0.38	3.11
messages sent	87	0.38	3.11
min active SCN optimization applied on CR	10	0.04	0.36
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	143,794,152	620,519.19	5,135,505.43
non-idle wait count	4,464	19.26	159.43
parse count (describe)	24	0.10	0.86
parse count (failures)	1	0.00	0.04
parse count (hard)	216	0.93	7.71
parse time cpu	15	0.06	0.54
physical read IO requests	10	0.04	0.36
physical read bytes	81,920	353.51	2,925.71
physical read total IO requests	669	2.89	23.89
physical read total bytes	10,838,016	46,769.61	387,072.00
physical read total multi block requests	0	0.00	0.00
physical reads cache	10	0.04	0.36
physical reads cache prefetch	0	0.00	0.00
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	34	0.15	1.21
physical write bytes	811,008	3,499.77	28,964.57
physical write total IO requests	241	1.04	8.61
physical write total bytes	5,430,784	23,435.62	193,956.57
physical write total multi block requests	6	0.03	0.21
physical writes direct	4	0.02	0.14
physical writes direct (lob)	4	0.02	0.14
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	95	0.41	3.39
physical writes non checkpoint	25	0.11	0.89
pinned buffers inspected	0	0.00	0.00
pinned cursors current	3	0.01	0.11
recursive calls	11,990,981	51,745.04	428,249.32
recursive cpu usage	77,227	333.26	2,758.11
redo blocks checksummed by FG (exclusive)	2,230	9.62	79.64
redo blocks written	4,079	17.60	145.68
redo blocks written (group 0)	0	0.00	0.00
redo blocks written (group 1)	0	0.00	0.00
redo buffer allocation retries	0	0.00	0.00
redo entries	3,075	13.27	109.82
redo log space requests	0	0.00	0.00
redo ordering marks	0	0.00	0.00
redo size for direct writes	0	0.00	0.00
redo subscn max counts	64	0.28	2.29
redo synch long waits	0	0.00	0.00
redo synch time	0	0.00	0.00
redo synch time (usec)	733	3.16	26.18
redo synch time overhead (usec)	123	0.53	4.39
redo synch time overhead count ( 2ms)	6	0.03	0.21
redo synch time overhead count ( 8ms)	0	0.00	0.00
redo synch time overhead count ( 32ms)	0	0.00	0.00
redo synch time overhead count (128ms)	0	0.00	0.00
redo synch time overhead count (inf)	0	0.00	0.00
redo synch writes	6	0.03	0.21
redo wastage	9,988	43.10	356.71
redo write info find	6	0.03	0.21
redo write size count ( 4KB)	40	0.17	1.43
redo write size count ( 8KB)	1	0.00	0.04
redo write size count ( 16KB)	0	0.00	0.00
redo write size count ( 32KB)	1	0.00	0.04
redo write size count ( 128KB)	5	0.02	0.18
redo write size count ( 256KB)	2	0.01	0.07
redo write size count ( 512KB)	1	0.00	0.04
redo write size count (1024KB)	1	0.00	0.04
redo write size count (inf)	0	0.00	0.00
redo write time	8	0.03	0.29
redo writes	51	0.22	1.82
redo writes (group 0)	0	0.00	0.00
redo writes (group 1)	0	0.00	0.00
redo writes adaptive all	51	0.22	1.82
redo writes adaptive worker	0	0.00	0.00
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	14	0.06	0.50
root node splits	0	0.00	0.00
rows fetched via callback	969	4.18	34.61
securefile allocation bytes	32,768	141.40	1,170.29
securefile allocation chunks	4	0.02	0.14
securefile bytes non-transformed	54,720	236.13	1,954.29
securefile direct write bytes	32,768	141.40	1,170.29
securefile direct write ops	4	0.02	0.14
securefile number of non-transformed flushes	30	0.13	1.07
segment cfs allocations	0	0.00	0.00
segment chunks allocation from disepnser	4	0.02	0.14
segment dispenser allocations	4	0.02	0.14
segment dispenser load empty	0	0.00	0.00
segment dispenser load tasks	0	0.00	0.00
segment prealloc bytes	0	0.00	0.00
segment prealloc ops	0	0.00	0.00
segment prealloc tasks	0	0.00	0.00
segment prealloc time (ms)	0	0.00	0.00
segment total chunk allocation	0	0.00	0.00
shared hash latch upgrades - no wait	84	0.36	3.00
shared hash latch upgrades - wait	0	0.00	0.00
shared io pool buffer get success	4	0.02	0.14
sorts (memory)	412	1.78	14.71
sorts (rows)	4,726	20.39	168.79
sql area evicted	214	0.92	7.64
sql area purged	2	0.01	0.07
summed dirty queue length	0	0.00	0.00
switch current to new buffer	7	0.03	0.25
table fetch by rowid	3,622	15.63	129.36
table fetch continued row	5	0.02	0.18
table scan blocks gotten	143,791,353	620,507.11	5,135,405.46
table scan rows gotten	107,950,850	465,843.52	3,855,387.50
table scans (long tables)	0	0.00	0.00
table scans (short tables)	11,982,776	51,709.63	427,956.29
temp space allocated (bytes)	1,048,576	4,524.95	37,449.14
total cf enq hold time	63	0.27	2.25
total number of cf enq holders	1	0.00	0.04
total number of times SMON posted	108	0.47	3.86
transaction rollbacks	0	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	696,364	3,005.04	24,870.14
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
logons current	51	49
opened cursors current	97	101
session cursor cache count	86,367	86,545
session pga memory	80,175,096	80,060,072
session pga memory max	190,613,576	202,229,496
session uga memory	1,318,462,248	1,321,873,728
session uga memory max	14,743,116,960	14,774,867,080

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

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	11M	2.84	.047M	2M	0.66	.009M	736	20.25
LGWR	0M	0.00	0M	3M	0.23	.013M	52	1.56
DBWR	0M	0.00	0M	1M	0.13	.004M	0
Buffer Cache Reads	0M	0.04	0M	0M	0.00	0M	10	30.80
Direct Writes	0M	0.00	0M	0M	0.02	0M	1	0.00
TOTAL:	11M	2.89	.047M	6M	1.04	.026M	799	19.14

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read
Control File	11M	2.86	.047M	3M	0.67	.013M	21.79
Log File	0M	0.00	0M	3M	0.23	.013M
Data File	0M	0.06	0M	1M	0.15	.004M	31.27
TOTAL:	11M	2.92	.047M	7M	1.05	.03M	22.00

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	10M	2.86	.043M	2M	0.66	.009M	663	21.77
Others (Control File)	10M	2.84	.043M	2M	0.66	.009M	658	21.69
Others (Data File)	0M	0.02	0M	0M	0.00	0M	5	32.00
LGWR	0M	0.00	0M	3M	0.22	.013M	0
LGWR (Log File)	0M	0.00	0M	3M	0.22	.013M	0
DBWR	0M	0.00	0M	1M	0.13	.004M	0
DBWR (Data File)	0M	0.00	0M	1M	0.13	.004M	0
Buffer Cache Reads	0M	0.03	0M	0M	0.00	0M	8	30.25
Buffer Cache Reads (Data File)	0M	0.03	0M	0M	0.00	0M	8	30.25
Direct Writes	0M	0.00	0M	0M	0.02	0M	1	0.00
Direct Writes (Data File)	0M	0.00	0M	0M	0.02	0M	1	0.00
TOTAL:	10M	2.90	.043M	6M	1.04	.026M	672	21.84

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rd(ms)	Av Blks/Rd	Av 1-bk Rd(ms)	Writes
SYSAUX	10	31.00	1.00	31.00	9
SYSTEM	0	0.00	0.00	0.00	16
UNDOTBS1	0	0.00	0.00	0.00	10

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Av 1-bk Rd(ms)	Writes
SYSAUX	C:\APP\XIANGBLI\ORADATA\MACLEAN\SYSAUX01.DBF	10	31.00	1.00	31.00	9
SYSTEM	C:\APP\XIANGBLI\ORADATA\MACLEAN\SYSTEM01.DBF	0				16
UNDOTBS1	C:\APP\XIANGBLI\ORADATA\MACLEAN\UNDOTBS01.DBF	0				10

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

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	133,756	100	162,913,620	10	95	0	0	0

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 99

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	95	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
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 RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	29	230	2803	6968	165888	6968
E	0	30	693	4602	11212	165888	11212

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

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 (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	96	0.09	12	1.95	278	1	845.00
D	192	0.18	24	1.50	214	1	562.00
D	288	0.26	35	1.33	190	1	456.00
D	384	0.35	47	1.26	180	1	411.00
D	480	0.44	59	1.20	171	1	372.00
D	576	0.53	71	1.18	168	1	362.00
D	672	0.62	83	1.16	165	1	348.00
D	768	0.71	94	1.10	157	1	312.00
D	864	0.79	106	1.06	151	1	284.00
D	960	0.88	118	1.02	145	1	259.00
D	1,056	0.97	130	1.00	142	1	247.00
D	1,088	1.00	134	1.00	142	1	247.00
D	1,152	1.06	142	1.00	142	1	247.00
D	1,248	1.15	153	1.00	142	1	247.00
D	1,344	1.24	165	1.00	142	1	247.00
D	1,440	1.32	177	1.00	142	1	247.00
D	1,536	1.41	189	1.00	142	1	247.00
D	1,632	1.50	201	1.00	142	1	247.00
D	1,728	1.59	212	1.00	142	1	247.00
D	1,824	1.68	224	1.00	142	1	247.00
D	1,920	1.76	236	1.00	142	1	247.00

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	57	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	550	419	147.39	0.00	0.00	0.00	0.00	102,400
E	550	419	146.04	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	251	251
64K	128K	2	2
128K	256K	2	2
512K	1024K	39	39
1M	2M	20	20

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 Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
69	0.13	17,785.79	1,558.33	92.00	73	16,183,304
138	0.25	17,785.79	557.24	97.00	10	15,345,790
275	0.50	17,785.79	441.76	98.00	0	15,249,178
413	0.75	17,785.79	0.00	100.00	0	14,879,605
550	1.00	17,785.79	0.00	100.00	0	14,879,605
660	1.20	17,785.79	0.00	100.00	0	14,879,605
770	1.40	17,785.79	0.00	100.00	0	14,879,605
880	1.60	17,785.79	0.00	100.00	0	14,879,605
990	1.80	17,785.79	0.00	100.00	0	14,879,605
1,100	2.00	17,785.79	0.00	100.00	0	14,879,605
1,650	3.00	17,785.79	0.00	100.00	0	14,879,605
2,200	4.00	17,785.79	0.00	100.00	0	14,879,605
3,300	6.00	17,785.79	0.00	100.00	0	14,879,605
4,400	8.00	17,785.79	0.00	100.00	0	14,879,605

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 (K)
272	0.65	45	2,222	16,172	0.51	15,500	95.09	1,034
288	0.69	60	2,706	21,201	0.67	10,471	64.24	1,325
304	0.73	76	2,881	23,329	0.74	8,343	51.18	1,637
320	0.77	91	3,032	25,448	0.81	6,224	38.18	1,693
336	0.81	106	3,183	26,683	0.85	4,989	30.61	1,718
352	0.85	121	3,334	28,632	0.91	3,040	18.65	1,745
368	0.88	137	3,841	29,688	0.94	1,984	12.17	1,771
384	0.92	152	4,595	31,062	0.99	610	3.74	1,793
400	0.96	167	5,136	31,356	1.00	316	1.94	1,803
416	1.00	183	5,634	31,509	1.00	163	1.00	1,808
432	1.04	199	6,121	31,514	1.00	158	0.97	1,808
448	1.08	215	6,608	31,515	1.00	157	0.96	1,809
464	1.12	231	7,095	31,516	1.00	156	0.96	1,809
480	1.15	247	7,677	31,518	1.00	154	0.94	1,809
496	1.19	263	8,281	31,520	1.00	152	0.93	1,810
512	1.23	279	8,807	31,523	1.00	149	0.91	1,810
528	1.27	295	9,333	31,531	1.00	141	0.87	1,810
544	1.31	311	9,859	31,531	1.00	141	0.87	1,810
560	1.35	327	10,385	31,531	1.00	141	0.87	1,811
608	1.46	375	11,965	31,533	1.00	139	0.85	1,811
656	1.58	423	13,545	31,535	1.00	137	0.84	1,812
704	1.69	471	15,125	31,539	1.00	133	0.82	1,813
752	1.81	519	16,705	31,542	1.00	130	0.80	1,813
800	1.92	567	18,572	31,542	1.00	130	0.80	1,813
848	2.04	615	20,027	31,542	1.00	130	0.80	1,813

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
832	0.50	4,370	213,820
1,248	0.75	4,156	168,344
1,664	1.00	4,052	142,423
2,080	1.25	4,030	142,409
2,496	1.50	4,030	142,409
2,912	1.75	4,030	142,409
3,328	2.00	4,030	142,409

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

Size for Est (MB)	Size Factor	Est Spill Count	Est Spill Time (s)	Est Unspill Count	Est Unspill Time (s)
16	1.00	0	0	0	0
32	2.00	0	0	0	0
48	3.00	0	0	0	0
64	4.00	0	0	0	0
80	5.00	0	0	0	0
96	6.00	0	0	0	0
112	7.00	0	0	0	0
128	8.00	0	0	0	0
144	9.00	0	0	0	0
160	10.00	0	0	0	0
176	11.00	0	0	0	0
192	12.00	0	0	0	0
208	13.00	0	0	0	0
224	14.00	0	0	0	0
240	15.00	0	0	0	0
256	16.00	0	0	0	0
272	17.00	0	0	0	0
288	18.00	0	0	0	0
304	19.00	0	0	0	0
320	20.00	0	0	0	0

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

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets
JS-Job Scheduler (queue lock)	1,978	1,978
JS-Job Scheduler	1,978	1,978
TM-DML	244	244
CU-Cursor	192	192
JS-Job Scheduler (q mem clnup lck)	188	188
CF-Controlfile Transaction	181	181
SJ-KTSJ Slave Task Cancel (Slave Task Cancel)	157	157
TX-Transaction	99	99
MC-SGA Log Operation (Securefile log)	76	76
MF-SGA Log-Bkt Flush (flush bkgnd periodic)	76	76
JD-Job Queue Date	46	46
TT-Tablespace	23	23
WF-AWR Flush	23	23
SE-Session Migration	21	21
HW-Segment High Water Mark	18	18
AE-Edition Lock (lock)	15	15
PR-Process Startup	11	11
PV-KSV slave startup (syncstart)	9	9
FB-Format Block	8	8
AF-Advisor Framework (task serialization)	7	7
MR-Media Recovery	4	4
TH-Threshold Chain (metric threshold evaluation)	3	3
SQ-Sequence Cache	2	2
TO-Temp Object	2	2
SH-Active Session History Flushing	1	1
TA-Instance Undo	1	1
TD-KTF map table enqueue (KTF dump entries)	1	1
UL-User-defined	1	1

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
Mutex Sleep Summary
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
AQ Background: interrupt command latch	1	0.00		0
AQ Coord jobx_kwsbgsgn latch	7	0.00		0
AQ Sharded master pool latch	7	0.00		0
AQ deq hash table latch	1	0.00		0
ASM db client latch	147	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	4	0.00		0
ASM remote client latch	4	0.00		0
AWR Alerted Metric Element list	1,869	0.00		0
Change Notification Hash table latch	76	0.00		0
Consistent RBA	51	0.00		0
DML lock allocation	500	0.00		0
Event Group Locks	25	0.00		0
FOB s.o list latch	32	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
ILM Stats Stripe Latch	1	0.00		0
ILM Stats main anchor latch	696	0.00		0
ILM access tracking extent	1	0.00		0
ILM activity tracking latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	438	0.00		125	0.00
Init msg cache	1	0.00		0
JS Sh mem access	3	0.00		0
JS mem alloc latch	3	0.00		0
JS queue access latch	4	0.00		0
JS queue state obj latch	3,998	0.00		0
KCNIBR - invalid block range tree	1	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	77	0.00		0
KSFS OFS ctx level parent latch	1	0.00		0
KSFS OFS req layer parent latch	1	0.00		0
KSFS OFS sess layer parent latch	1	0.00		0
KSFS id table parent latch	1	0.00		0
KSFS ksfs_node latch	1	0.00		0
KSFSD name cache parent latch	1	0.00		0
KTF sga latch	1	0.00		70	0.00
KTILM latch	1	0.00		0
KWQMN job cache list latch	1	0.00		0
KWQS pqsubs latch	1	0.00		0
KWQS pqueue ctx latch	9	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			4	0.00
Memory Management Latch	1	0.00		77	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	2	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	106	0.00		0
OS process allocation	476	0.00		0
OS process: request allocation	24	0.00		0
PL/SQL warning settings	34	0.00		0
PX hash array latch	1	0.00		0
Parent latch for dependency tracking	1	0.00		0
QMT	1	0.00		0
Real-time descriptor latch	126	0.00		0
Report Request stats latch	12	0.00		0
Request holder compeltion list latch	23	0.00		0
Retry Ht elm latch	1	0.00		0
Retry bkt latch	1	0.00		0
SGA Blackbox latch	1	0.00		0
SGA Logging Bkt Latch	533	0.00		0
SGA Logging Log Latch	761	0.00		228	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	1	0.00		73	0.00
SQL memory manager workarea list latch	5,513	0.00		0
Sched IM Job latch	5	0.00		0
Sched InMem Job Cache	28	0.00		0
Shared B-Tree	23	0.00		0
Streams Generic	1	0.00		0
Subscriber Ht elm latch	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
Txn Ht elm latch	1	0.00		0
Txn bkt latch	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	106	0.00		0
active service list	985	0.00		1,331	0.00
begin backup scn array	4	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	28	0.00		0
cache buffers chains	359,510,088	2.00	0.00	131	6.87
cache buffers lru chain	112	0.00		254	0.00
call allocation	655	0.00		0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	25	0.00		0
channel operations parent latch	58	0.00		0
checkpoint queue latch	2,238	0.00		561	0.00
client/application info	23	0.00		0
compile environment latch	13	0.00		0
cp handoff latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	4	0.00		0
cp srv type state latch	13	0.00		0
cp srv type wait latch	1	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	4	0.00		0
dispatcher info	2	0.00		0
dml lock allocation	4	0.00		0
done queue latch	1	0.00		0
dtp latch	13	0.00		0
dummy allocation	29	0.00		0
eleventh spare latch - children	1	0.00		0
enqueue freelist latch	1	0.00		10,013	0.00
enqueue hash chains	10,831	0.02	0.00	0
enqueues	3	0.00		0
event stats latch	15	0.00		0
fast space usage latch	4	0.00		0
file cache latch	27	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc bast context freelist	1	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs opaque info freelist	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs resource validate list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges cached resource lists	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	0.00		0
ges timeout list	1	0.00		0
ges value block free list	1	0.00		0
global tx hash mapping	1	0.00		0
granule from data transfer cache	1	0.00		0
granule operation	1	0.00		0
hash table Sql Plan Finding latch	0			8	0.00
hash table column usage latch	0			97,282	0.00
hash table modification latch	6	0.00		0
heartbeat check	1	0.00		0
internal temp table object number allocation latch	15	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule list	8	0.00		0
io pool granule metadata list	17	0.00		0
job workq parent latch	3	0.00		2	0.00
job_queue_processes free list latch	8	0.00		0
job_queue_processes parameter latch	3	0.00		0
k2q lock allocation	1	0.00		0
kcb DW scan objtemp hash table latch	1	0.00		0
kcn buffer chains	1	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kjci objects freelist latch	1	0.00		0
kjci process context latch	1	0.00		329	0.00
kjoedcso state object freelist latch	4	0.00		0
kjoeq omni enqueue hash bucket latch	1	0.00		0
kjoer owner hash bucket	1	0.00		0
kokc descriptor allocation latch	26	0.00		0
krso process latch	7	0.00		0
ksfv messages	1	0.00		0
ksi resource reuse count	1	0.00		0
ksim group membership cache	1	0.00		0
kss move lock	19	0.00		0
ksuosstats global area	31	0.00		0
ksv allocation latch	40	0.00		0
ksv class latch	37	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	24	0.00		0
ktfbn latch	1	0.00		0
ktm global data	377	0.00		0
kwqbsn:qsga	11	0.00		0
kwslbmdl: metadata latch	7	0.00		0
kwslbql: queue latch	1	0.00		0
lgwr LWN SCN	111	0.00		0
list of block allocation	34	0.00		0
lob segment dispenser latch	9	0.00		0
lob segment hash table latch	27	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
log write info	0			51	0.00
log write slave phase	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
managed standby latch	7	0.00		0
mapped buffers lru chain	1	0.00		0
message bitmap latch	1	0.00		0
message pool operations parent latch	1	0.00		0
messages	2,533	0.00		0
mostly latch-free SCN	112	0.00		0
msg queue latch	1	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	4	0.00		0
object queue header freelist	8	0.00		0
object queue header operation	908	0.00		0
object queue memory	1	0.00		0
object stats modification	4	0.00		0
parallel query alloc buffer	33	0.00		0
parallel query stats	1	0.00		0
parameter table management	62	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
pkey global statistics	1	0.00		0
post/wait queue	548	0.00		1,194	0.34
process allocation	35	0.00		11	0.00
process group creation	24	0.00		0
process pkey statistics list	1	0.00		0
process queue	1	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	36	25.00	1.00	0
query server freelists	1	0.00		0
query server process	152	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	524	0.19	0.00	3,051	0.00
redo copy	1	0.00		3,051	0.00
redo writing	413	0.00		0
resmgr group change latch	2	0.00		0
resmgr:active threads	29	0.00		0
resmgr:actses change group	12	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	28	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	13	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	151,429	0.00		127	0.00
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
sequence cache	94	0.00		0
session allocation	41	0.00		28	0.00
session idle bit	434	0.00		0
session queue latch	1	0.00		0
session state list latch	58	0.00		0
session statistics	29	0.00		0
session switching	18	0.00		0
session timer	77	0.00		0
seventh spare latch - X parent	1	0.00		0
sga hash table parent latch	1	0.00		0
shard latch	1	0.00		0
shared pool	27,397	0.00		0
shared pool sim alloc	12	0.00		0
shared pool simulator	1,349	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	10,668,303	0.00		0
simulator lru latch	74	1.35	0.00	10,668,215	12.35
sixth spare latch - X parent	1	0.00		0
sort extent pool	122	0.00		0
space background task latch	2,268	12.92	0.72	157	0.64
state object free list	2	0.00		0
statistics aggregation	140	0.00		0
subscriber Ht bkt	1	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
temporary table state object allocation	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
test excl. parent2 lmid cln	1	0.00		0
threshold alerts latch	4	0.00		0
transaction allocation	52	0.00		0
twelfth spare latch - children	1	0.00		0
twenty-first spare latch - S par	1	0.00		0
twenty-second spare latch - S par	1	0.00		0
undo global data	614	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	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
space background task latch	2,268	293	210	83
qmn task queue latch	36	9	9	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
qmn task queue latch	kwqmnmvtsks: delay to ready list	9	0
space background task latch	ktsj_grab_task	189	210
space background task latch	ktsjCreateTask	20	0
space background task latch	ktsj_detach_task	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kksLockDelete [KKSCHLPIN6]	1,921	18,973
Cursor Pin	kksfbc [KKSCHLFSP2]	1,393	14,646

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 Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 179,752,904
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Logical Reads	%Total
SYS	SYSTEM	TV		TABLE	178,446,064	99.27
SYS	SYSAUX	WRH$_SYSSTAT_PK	WRH$_SYSSTA_1694338843_0	INDEX PARTITION	992	0.00
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_1694338843_0	INDEX PARTITION	752	0.00
SYS	SYSAUX	WRH$_SEG_STAT_OBJ		TABLE	448	0.00
SYS	SYSAUX	WRH$_SYSSTAT	WRH$_SYSSTA_1694338843_0	TABLE PARTITION	416	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 10
Captured Segments account for 70.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1694338843_0	TABLE PARTITION	7	70.00

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 10
Captured Segments account for 70.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1694338843_0	TABLE PARTITION	7	70.00

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 10
Captured Segments account for 70.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1694338843_0	TABLE PARTITION	7	70.00

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 99
Captured Segments account for 9.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SYS	SYSTEM	TV		TABLE	9	9.09

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 34
Captured Segments account for 5.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SYS	SYSTEM	TV		TABLE	2	5.88

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	SYSAUX	WRH$_SYSSTAT_PK	WRH$_SYSSTA_1694338843_0	INDEX PARTITION	528	19.41
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_1694338843_0	INDEX PARTITION	384	14.12
SYS	SYSAUX	WRH$_SEG_STAT_OBJ		TABLE	288	10.59
SYS	SYSAUX	WRH$_SEG_STAT_OBJ_INDEX		INDEX	176	6.47
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_1694338843_0	INDEX PARTITION	160	5.88

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	6	0.00	2	1
dc_files	105	0.00	0	6
dc_global_oids	130	0.00	0	204
dc_histogram_data	5,839	0.57	0	2,611
dc_histogram_defs	12,279	1.94	0	5,818
dc_objects	4,133	0.05	2	2,707
dc_profiles	4	0.00	0	1
dc_props	164	0.00	0	5
dc_rollback_segments	23	0.00	0	12
dc_segments	1,684	0.65	5	1,414
dc_sequences	2	0.00	2	9
dc_tablespaces	14,921	0.00	0	9
dc_users	14,702	0.00	0	183
sch_lj_oids	3	0.00	0	42

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	74	0.00	91	0.00	0	0
CLUSTER	15	0.00	15	0.00	0	0
EDITION	11	0.00	22	0.00	0	0
INDEX	63	0.00	63	0.00	0	0
QUEUE	2	0.00	94	0.00	0	0
SCHEMA	2	0.00	0		0	0
SQL AREA	327	2.14	7,045,010	-70.17	49	2
SQL AREA BUILD	217	33.18	0		0	0
SQL AREA STATS	196	98.98	196	98.98	0	0
TABLE/PROCEDURE	769	0.00	2,295	6.32	126	0
TRIGGER	5	0.00	5	0.00	0	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	1,088.00	1,088.00	1,088.00	1,248.00	SHR/DEF
Data Transfer Cache	0.00	0.00	0.00	0.00	STA/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	560.00	560.00	560.00	560.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	1,664.00	1,664.00	1,664.00	1,664.00	STA/
Shared IO Pool	80.00	80.00	0.00	80.00	GRO/IMM
java pool	16.00	16.00	16.00	16.00	STA/
large pool	32.00	32.00	32.00	144.00	SHR/DEF
shared pool	416.00	416.00	352.00	416.00	GRO/DEF
streams pool	16.00	16.00	0.00	16.00	GRO/IMM

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

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	97.62		1.41	1.30	8	43	69	69
B	Freeable	46.63	0.00	1.87	2.16	8		25	25
B	SQL	1.63	1.07	0.05	0.18	1	25	34	26
B	PL/SQL	1.56	1.39	0.03	0.10	1	1	51	51
E	Other	96.86		1.45	1.33	8	43	67	67
E	Freeable	46.38	0.00	1.86	2.17	8		25	25
E	PL/SQL	1.63	1.46	0.03	0.11	1	1	49	49
E	SQL	1.22	0.62	0.04	0.13	1	25	33	26

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,224,736,768
Fixed Size	2,403,544
Redo Buffers	6,574,080
Variable Size	503,317,288

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	15.00	15.00	0.00
large	free memory	17.00	17.00	0.00
shared	ASH buffers	8.00	8.00	0.00
shared	KGLH0	45.46	41.68	-8.31
shared	KGLHD	9.56	8.97	-6.15
shared	KGLS	11.15	10.77	-3.43
shared	KGLSG	5.03	5.03	0.00
shared	KQR L PO	8.52	8.62	1.12
shared	PLMCD	7.69	7.64	-0.56
shared	SQLA	101.18	104.82	3.60
shared	XDBSC	14.45	14.45	0.00
shared	db_block_hash_buckets	11.00	11.00	0.00
shared	dbktb: trace buffer	4.69	4.69	0.00
shared	event statistics per sess	6.45	6.45	0.00
shared	free memory	32.00	33.53	4.78
shared	ktli log buf s	14.01	14.01	0.00
shared	object queue hash buckets	8.00	8.00	0.00
shared	row cache	8.24	8.24	0.00
shared	write state object	5.93	5.93	0.00
streams	KTG hash buckets	0.63	0.63	0.00
streams	free memory	15.37	15.37	0.00
	buffer_cache	1,088.00	1,088.00	0.00
	fixed_sga	2.29	2.29	0.00
	log_buffer	6.27	6.27	0.00
	shared_io_pool	80.00	80.00	0.00

Back to Memory Statistics
Back to Top

Replication Statistics (GoldenGate, XStream)

Replication System Resource Usage
Replication SGA Usage
GoldenGate Capture
GoldenGate Capture Rate
GoldenGate Apply Reader
GoldenGate Apply Coordinator
GoldenGate Apply Server
GoldenGate Apply Coordinator Rate
GoldenGate Apply Reader and Server Rate
XStream Capture
XStream Capture Rate
XStream Apply Reader
XStream Apply Coordinator
XStream Apply Server
XStream Apply Coordinator Rate
XStream Apply Reader and Server Rate
Table Statistics by DML Operations
Table Statistics by Conflict Resolutions
Replication Large Transaction Statistics
Replication Long Running Transaction Statistics

Replication System Resource Usage

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Replication SGA Usage

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Capture

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Capture Rate

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Apply Reader

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Apply Coordinator

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Apply Server

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Apply Coordinator Rate

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

GoldenGate Apply Reader and Server Rate

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Capture

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Capture Rate

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Apply Reader

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Apply Coordinator

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Apply Server

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Apply Coordinator Rate

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

XStream Apply Reader and Server Rate

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Table Statistics by DML Operations

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Table Statistics by Conflict Resolutions

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Replication Large Transaction Statistics

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Replication Long Running Transaction Statistics

No data exists for this section of the report.

Back to Replication Statistics (GoldenGate, XStream)
Back to Top

Streams Statistics

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

Streams CPU/IO Usage

Streams processes ordered by CPU Time in descending order

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
EMON Coordinator	29-7月 -13 08:16:41	0.00	0.00	0.00
EMON Regular Slave	29-7月 -13 08:16:42	0.00	0.00	0.00
EMON Reliable Slave	29-7月 -13 08:16:42	0.00	0.00	0.00
QMON Coordinator	28-7月 -13 19:52:19	0.00	0.00	0.00
QMON Slave	28-7月 -13 19:52:19	0.00	0.00	0.00

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 Capture Rate

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

Streams Apply Rate

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 Queue 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

Persistent Queues

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps
%Exp Msgs - % of msgs enqueued with expiry
%Delay Msgs - % of msgs enqueued with delay
%Trasf Time - % of Enqueue time spent in transformation
%Eval Time - % of Enqueue time spent in rule evaluation

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.AQ_SRVNTFN_TABLE_Q_1(93161)	0	0			0.00	0.00
SYS.SCHEDULER$_EVENT_QUEUE(16840)	0	0			0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

Ordered by Queue Name
* indicates queue (re)started between Begin/End snaps

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.AQ_SRVNTFN_TABLE_Q_1(93161)	0.00	0.00
SYS.SCHEDULER$_EVENT_QUEUE(16840)	0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

Ordered by Queue Name, Subscriber Name
* indicates Subscriber activity (re)started between Begin/End snaps

Subscriber/Queue	Enqueue Msgs	Dequeue Msgs	Expire Msgs	Enqueue Msgs/sec	Dequeue Msgs/sec	Expire Msgs/sec
ILM_AGENT(1)/SYS.SCHEDULER$_EVENT_QUEUE	0	0	0	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

Only rows with Current or Maximum Utilization > 80% of Limit are shown
For "UNLIMITED" resources, rows whose Current or Maximum Utilization exceeds 2*Initial Allocation are shown
Ordered by Resource Name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
smartio_overhead_memory	0	69,656	0	UNLIMITED
smartio_sessions	0	1	0	UNLIMITED

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
231	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	231	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

init.ora Parameters
init.ora Multi-Valued Parameters

init.ora Parameters

Parameter Name	Begin value	End value (if different)
_flush_ilm_stats	1
audit_file_dest	C:\APP\XIANGBLI\ADMIN\MACLEAN\ADUMP
audit_trail	DB
compatible	12.1.0.0.0
control_files	C:\APP\XIANGBLI\ORADATA\MACLEAN\CONTROL01.CTL, C:\APP\XIANGBLI\FAST_RECOVERY_AREA\MACLEAN\CONTROL02.CTL
db_block_size	8192
db_create_file_dest	C:\APP\XIANGBLI\ORADATA
db_domain
db_name	MACLEAN
db_recovery_file_dest	C:\app\xiangbli\fast_recovery_area
db_recovery_file_dest_size	7266631680
diagnostic_dest	C:\APP\XIANGBLI
dispatchers	(PROTOCOL=TCP) (SERVICE=MACLEANXDB)
heat_map	ON
nls_language	SIMPLIFIED CHINESE
nls_territory	CHINA
open_cursors	300
pga_aggregate_target	576716800
processes	300
remote_login_passwordfile	EXCLUSIVE
sga_target	1744830464
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

This section only displays parameters that have more than one value
'(NULL)' indicates a missing parameter value
A blank in the 'End Snapshot' indicates the same value as the 'Begin Snapshot'

Parameter Name	Begin value	End value (if different)
control_files	C:\APP\XIANGBLI\FAST_RECOVERY_AREA\MACLEAN\CONTROL02.CTL
control_files	C:\APP\XIANGBLI\ORADATA\MACLEAN\CONTROL01.CTL

Back to init.ora Parameters
Back to Top

ADDM Task ADDM:1694338843_1_36

          任务 'ADDM:1694338843_1_36' 的 ADDM 报告
          -----------------------------------

分析时段
----
AWR 快照范围从 35 到 36。
时段从 30-7月 -13 03.16.55 下午 开始
时段在 30-7月 -13 03.20.46 下午 结束

分析目标
----
数据库 'MACLEAN' (DB ID 为 1694338843)。
数据库版本 12.1.0.1.0。
ADDM 对实例 maclean 执行了分析, 该实例的编号为 1 并运行于 XIANGBLI-CN。

分析时段期间的活动
---------
总数据库时间为 1163 秒。
活动会话的平均数量为 5.03。

查找结果概要
------
   说明         活动的会话   建议案
              活动的百分比
   ---------  ------  ---
1  顶级 SQL 语句  3.63 | 72.071
2  CPU 占用率    .64 | 12.782
3  共享池闩锁数     .15 | 2.930


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


          查找结果和建议案
          --------

查找结果 1: 顶级 SQL 语句
受影响的是 3.61 个活动会话, 占总活动的 72.07\%。
--------------------------------
发现 SQL 语句消耗了大量数据库时间。这些语句提供了改善性能的绝佳机会。

   建议案 1: SQL 优化
   估计的收益为 3.4 个活动会话, 占总活动的 67.57\%。
   --------------------------------
   操作
      对 SELECT 语句 (SQL_ID 为 "2nv8264jgqpqz") 运行 SQL 优化指导。
      相关对象
         SQL_ID 为 2nv8264jgqpqz 的 SQL 语句。
         SELECT T1 FROM TV WHERE T1=:B1
   原理
      SQL 在 CPU, I/O 和集群等待上花费的时间占其数据库时间的 93%。这部分数据库时间可通过 SQL 优化指导进行改善。
   原理
      此 SQL 的数据库时间由以下部分构成: SQL 执行占 100%, 语法分析占 0%, PL/SQL 执行占 0%, Java 执行占 0%。
   原理
      SQL_ID 为 "2nv8264jgqpqz" 的 SQL 语句执行了 11893050 次, 每次执行平均用时 0.000059 秒。


查找结果 2: CPU 占用率
受影响的是 .64 个活动会话, 占总活动的 12.78\%。
-------------------------------
主机 CPU 是瓶颈, 实例正在消耗主机 CPU 的 99\%。所有等待时间皆因等待 CPU 而延长。
主机 CPU 开销为 99\%。

   建议案 1: 应用程序分析
   估计的收益为 4.44 个活动会话, 占总活动的 88.29\%。
   ---------------------------------
   操作
      查看 "顶级 SQL 语句" 以找出消耗大量 CPU 时间的 SQL 语句。例如, 在分析期间, SELECT 语句 (SQL_ID 为
      "2nv8264jgqpqz") 占 CPU 占用率的 76%。

   建议案 2: 主机配置
   估计的收益为 .64 个活动会话, 占总活动的 12.78\%。
   --------------------------------
   操作
      考虑在主机中添加更多 CPU, 或添加为其他主机上的数据库提供服务的实例。
   操作
      还可考虑使用 Oracle Database Resource Manager 来区分各种使用者组中工作量的优先级。


查找结果 3: 共享池闩锁数
受影响的是 .15 个活动会话, 占总活动的 2.93\%。
------------------------------
与共享池相关的闩锁争用将消耗大量数据库时间。
等待 "cursor: pin S" 的数据库时间总计为 2\%。

   没有可用的建议案。

   导致查找结果的故障现象:
   ------------
      等待类 "并发" 消耗了大量数据库时间。
      受影响的是 .15 个活动会话, 占总活动的 2.93\%。



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

          附加信息
          ----

各种信息
----
等待类 "应用程序" 并未消耗大量数据库时间。
等待类 "提交" 并未消耗大量数据库时间。
等待类 "配置" 并未消耗大量数据库时间。
等待类 "网络" 并未消耗大量数据库时间。
等待类 "用户 I/O" 并未消耗大量数据库时间。
会话连接和断开连接的调用并未消耗大量数据库时间。
对 SQL 语句的硬语法分析并未消耗大量数据库时间。

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	170.14	Soft Parse %:	77.14
Execute to Parse %:	99.99	Latch Hit %:	98.05
Parse CPU to Parse Elapsd %:	93.75	% Non-Parse CPU:	99.98