WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

MDM 1564977302 mdm 1 18-6月 -13 15:06 11.2.0.3.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
MDM	1564977302	mdm	1	18-6月 -13 15:06	11.2.0.3.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

hq13ydyygldb141 AIX-Based Systems (64-bit) 16 8 32.00

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
hq13ydyygldb141	AIX-Based Systems (64-bit)	16	8		32.00

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1580 22-6月 -13 15:00:26 45 4.8

End Snap: 1581 22-6月 -13 16:00:31 44 5.0

Elapsed: 60.09 (mins)

DB Time: 137.60 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	1580	22-6月 -13 15:00:26	45	4.8
End Snap:	1581	22-6月 -13 16:00:31	44	5.0
Elapsed:		60.09 (mins)
DB Time:		137.60 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 13,440M 13,440M Std Block Size: 8K

Shared Pool Size: 2,752M 2,752M Log Buffer: 21,208K

	Begin	End
Buffer Cache:	13,440M	13,440M	Std Block Size:	8K
Shared Pool Size:	2,752M	2,752M	Log Buffer:	21,208K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.3 0.1 0.01 0.01

DB CPU(s): 1.3 0.1 0.01 0.01

Redo size: 33,744.0 1,465.9

Logical reads: 7,295.6 316.9

Block changes: 187.2 8.1

Physical reads: 0.0 0.0

Physical writes: 3.1 0.1

User calls: 245.4 10.7

Parses: 156.3 6.8

Hard parses: 5.2 0.2

W/A MB processed: 1.2 0.1

Logons: 12.1 0.5

Executes: 160.3 7.0

Rollbacks: 12.0 0.5

Transactions: 23.0

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.3	0.1	0.01	0.01
DB CPU(s):	1.3	0.1	0.01	0.01
Redo size:	33,744.0	1,465.9
Logical reads:	7,295.6	316.9
Block changes:	187.2	8.1
Physical reads:	0.0	0.0
Physical writes:	3.1	0.1
User calls:	245.4	10.7
Parses:	156.3	6.8
Hard parses:	5.2	0.2
W/A MB processed:	1.2	0.1
Logons:	12.1	0.5
Executes:	160.3	7.0
Rollbacks:	12.0	0.5
Transactions:	23.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.99 Redo NoWait %: 100.00

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

Library Hit %: 95.12 Soft Parse %: 96.70

Execute to Parse %: 2.51 Latch Hit %: 99.49

Parse CPU to Parse Elapsd %: 55.44 % Non-Parse CPU: 98.93

Shared Pool Statistics

Begin End

Memory Usage %: 74.72 73.60

% SQL with executions>1: 98.50 64.57

% Memory for SQL w/exec>1: 89.85 61.96

	Begin	End
Memory Usage %:	74.72	73.60
% SQL with executions>1:	98.50	64.57
% Memory for SQL w/exec>1:	89.85	61.96

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		4,647		56.28
resmgr:cpu quantum	64,689	2,678	41	32.44	Scheduler
log file sync	89,557	255	3	3.09	Commit
buffer busy waits	3,726	236	63	2.86	Concurrency
SQL*Net more data to client	176,325	23	0	0.28	Network

Host CPU (CPUs: 16 Cores: 8 Sockets: )

Load Average Begin Load Average End %User %System %WIO %Idle

0.07 0.07 13.5 9.7 0.1 76.8

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.07	0.07	13.5	9.7	0.1	76.8

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

8.1 34.8 32.8

Memory Statistics

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

Begin End

Host Mem (MB): 32,768.0 32,768.0

SGA use (MB): 16,384.0 16,384.0

PGA use (MB): 174.3 174.0

% Host Mem used for SGA+PGA: 50.53 50.53

	Begin	End
Host Mem (MB):	32,768.0	32,768.0
SGA use (MB):	16,384.0	16,384.0
PGA use (MB):	174.3	174.0
% Host Mem used for SGA+PGA:	50.53	50.53

Main Report

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

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): 8256.3s
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
DB CPU	4,647.01	56.28
sql execute elapsed time	4,326.57	52.40
connection management call elapsed time	546.52	6.62
parse time elapsed	91.42	1.11
hard parse elapsed time	49.23	0.60
PL/SQL execution elapsed time	6.07	0.07
sequence load elapsed time	2.88	0.03
hard parse (sharing criteria) elapsed time	1.70	0.02
failed parse elapsed time	0.16	0.00
repeated bind elapsed time	0.08	0.00
PL/SQL compilation elapsed time	0.03	0.00
DB time	8,256.28
background elapsed time	202.14
background cpu time	24.86

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
AVG_BUSY_TIME	83,664
AVG_IDLE_TIME	276,820
AVG_IOWAIT_TIME	262
AVG_SYS_TIME	35,035
AVG_USER_TIME	48,503
BUSY_TIME	1,340,940
IDLE_TIME	4,431,698
IOWAIT_TIME	5,097
SYS_TIME	562,702
USER_TIME	778,238
LOAD	0	0
OS_CPU_WAIT_TIME	1,484,200
RSRC_MGR_CPU_WAIT_TIME	270,790
VM_IN_BYTES	819,200
VM_OUT_BYTES	788,492,288
PHYSICAL_MEMORY_BYTES	34,359,738,368
NUM_CPUS	16
NUM_CPU_CORES	8
NUM_LCPUS	16
NUM_VCPUS	8
GLOBAL_RECEIVE_SIZE_MAX	1,048,576
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	16,384
TCP_RECEIVE_SIZE_MAX	9,223,372,036,854,775,807
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	9,223,372,036,854,775,807
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
22-6月 15:00:26	0.07
22-6月 16:00:31	0.07	23.23	13.48	9.75	76.77	0.09

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 95.1% of Total DB time 8,256.28 (s)
Total FG Wait Time: 3,206.11 (s) DB CPU time: 4,647.01 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			4,647		56.28
Scheduler	64,689	0	2,678	41	32.44
Commit	89,557	0	255	3	3.09
Concurrency	16,300	0	243	15	2.94
Network	587,119	0	24	0	0.29
Application	1,994	0	5	2	0.05
Other	937	4	1	1	0.01
Configuration	94	0	0	3	0.00
User I/O	1,634	0	0	0	0.00
System I/O	457	0	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
resmgr:cpu quantum	64,689	0	2,678	41	0.78	32.44
log file sync	89,557	0	255	3	1.08	3.09
buffer busy waits	3,726	0	236	63	0.04	2.86
SQL*Net more data to client	176,325	0	23	0	2.12	0.28
library cache: mutex X	11,587	0	6	1	0.14	0.08
SQL*Net break/reset to client	1,990	0	4	2	0.02	0.05
SQL*Net message to client	410,730	0	1	0	4.95	0.02
latch free	734	0	0	1	0.01	0.01
latch: cache buffers chains	471	0	0	1	0.01	0.00
enq: TX - contention	7	0	0	41	0.00	0.00
enq: SQ - contention	62	0	0	4	0.00	0.00
cursor: pin S wait on X	10	0	0	23	0.00	0.00
latch: In memory undo latch	218	0	0	1	0.00	0.00
latch: shared pool	243	0	0	0	0.00	0.00
Data file init write	6	0	0	18	0.00	0.00
Disk file operations I/O	1,620	0	0	0	0.02	0.00
latch: enqueue hash chains	2	0	0	38	0.00	0.00
enq: TX - row lock contention	4	0	0	14	0.00	0.00
ADR block file read	35	0	0	1	0.00	0.00
log file switch (private strand flush incomplete)	3	0	0	8	0.00	0.00
enq: HW - contention	29	0	0	1	0.00	0.00
cursor: pin S	9	0	0	1	0.00	0.00
latch: call allocation	102	0	0	0	0.00	0.00
ADR block file write	5	0	0	2	0.00	0.00
control file sequential read	451	0	0	0	0.01	0.00
control file parallel write	6	0	0	1	0.00	0.00
SQL*Net more data from client	64	0	0	0	0.00	0.00
rdbms ipc reply	2	0	0	1	0.00	0.00
latch: row cache objects	7	0	0	0	0.00	0.00
SQL*Net message from client	410,729	0	331,970	808	4.95
jobq slave wait	7,562	100	3,776	499	0.09
Streams AQ: waiting for messages in the queue	722	100	3,603	4990	0.01
wait for unread message on broadcast channel	3,647	99	3,600	987	0.04

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
log file parallel write	123,547	0	129	1	1.49	63.82
SQL*Net more data from client	43,234	0	25	1	0.52	12.27
os thread startup	134	0	23	168	0.00	11.14
db file parallel write	3,413	0	3	1	0.04	1.65
SQL*Net more data to client	43,253	0	2	0	0.52	1.15
control file parallel write	1,554	0	2	1	0.02	1.01
latch free	156	0	1	8	0.00	0.63
LGWR wait for redo copy	1,678	0	0	0	0.02	0.22
asynch descriptor resize	43,353	100	0	0	0.52	0.07
latch: call allocation	538	0	0	0	0.01	0.06
SQL*Net message to client	86,645	0	0	0	1.04	0.06
db file async I/O submit	3,413	0	0	0	0.04	0.03
control file sequential read	2,796	0	0	0	0.03	0.02
ADR block file read	15	0	0	2	0.00	0.02
latch: shared pool	61	0	0	0	0.00	0.01
reliable message	3	0	0	1	0.00	0.00
log file sync	2	0	0	1	0.00	0.00
direct path sync	2	0	0	1	0.00	0.00
ADR block file write	5	0	0	0	0.00	0.00
direct path write	4	0	0	0	0.00	0.00
log file single write	4	0	0	0	0.00	0.00
Disk file operations I/O	56	0	0	0	0.00	0.00
latch: active service list	37	0	0	0	0.00	0.00
rdbms ipc message	143,181	13	46,673	326	1.73
DIAG idle wait	7,195	100	7,196	1000	0.09
Space Manager: slave idle wait	1,146	98	5,667	4945	0.01
smon timer	18	61	3,902	216793	0.00
shared server idle wait	121	100	3,630	30001	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,612	14001	0.00
Streams AQ: qmn slave idle wait	129	0	3,612	28001	0.00
pmon timer	1,210	99	3,605	2979	0.01
dispatcher timer	60	100	3,600	60002	0.00
Streams AQ: waiting for time management or cleanup tasks	7	43	2,859	408373	0.00
SQL*Net message from client	129,963	0	386	3	1.57
class slave wait	16	0	0	0	0.00

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
ADR block file read	50	80.0	2.0	2.0	12.0	4.0
ADR block file write	10	90.0				10.0
ADR file lock	12	100.0
Data file init write	6					33.3	66.7
Disk file operations I/O	1675	99.9	.1	.1
LGWR wait for redo copy	1678	97.7	.9	.5	.4	.5		.1
SQL*Net break/reset to client	1990	70.1	10.7	6.3	6.2	4.2	1.7	.9
SQL*Net message to client	497.3K	100.0		.0		.0
SQL*Net more data from client	43.3K	98.2	.5	.3	.3	.2	.1	.4
SQL*Net more data to client	219.6K	99.6	.1	.1	.1	.1	.0	.0
asynch descriptor resize	43.4K	100.0
buffer busy waits	3731	91.3	1.2	1.1	.8	.6	.5	2.9	1.6
buffer deadlock	12	100.0
control file parallel write	1561	82.9	9.0	3.0	2.8	1.6	.4	.2
control file sequential read	3247	100.0
cursor: mutex S	1	100.0
cursor: mutex X	28	100.0
cursor: pin S	9	88.9				11.1
cursor: pin S wait on X	10	10.0				60.0		30.0
db file async I/O submit	3414	100.0
db file parallel write	3414	81.7	13.6	1.5	1.4	1.3	.4	.1
db file sequential read	11	100.0
db file single write	2	100.0
direct path sync	2	50.0	50.0
direct path write	4	100.0
direct path write temp	1	100.0
enq: HW - contention	29	82.8	13.8		3.4
enq: SQ - contention	62	62.9	25.8	3.2	3.2		1.6	3.2
enq: TX - contention	7		14.3	14.3			28.6	42.9
enq: TX - row lock contention	4					75.0	25.0
latch free	890	74.9	3.5	1.9	15.6	3.4	.7
latch: In memory undo latch	218	94.0	1.4	.5	1.4	.9	1.4	.5
latch: active service list	44	100.0
latch: cache buffers chains	471	94.3	1.5	1.3	1.1	1.1	.4	.4
latch: call allocation	640	97.0	1.4	.5	.9	.2
latch: enqueue hash chains	2	50.0						50.0
latch: row cache objects	7	100.0
latch: shared pool	304	94.1	2.0	1.0	1.3	1.3	.3
library cache: mutex X	11.6K	94.9	.1	.0	.0	4.9	.1
log file parallel write	123.5K	86.9	6.2	2.8	2.2	1.5	.3	.0
log file sequential read	4	100.0
log file single write	4	100.0
log file switch (private strand flush incomplete)	3	33.3			33.3	33.3
log file sync	89.5K	66.5	12.4	7.2	5.9	4.5	2.5	.9
os thread startup	134							100.0
rdbms ipc reply	2	100.0
reliable message	3	33.3	66.7
resmgr:cpu quantum	64.7K	4.2	2.4	3.8	7.6	20.9	21.8	39.3
DIAG idle wait	7195							100.0
SQL*Net message from client	540.7K	14.3	49.2	17.3	6.4	6.3	2.4	1.4	2.8
Space Manager: slave idle wait	1144		.1					.7	99.2
Streams AQ: qmn coordinator idle wait	258	46.9	1.6	.4	.4	.8			50.0
Streams AQ: qmn slave idle wait	129								100.0
Streams AQ: waiting for messages in the queue	722							.1	99.9
Streams AQ: waiting for time management or cleanup tasks	7	28.6						14.3	57.1
class slave wait	16	81.3	18.8
dispatcher timer	60								100.0
jobq slave wait	7552			.1	.0			99.9
pmon timer	1210	.3						.2	99.4
rdbms ipc message	143.2K	16.2	8.5	14.8	10.4	17.8	14.6	9.9	7.8
shared server idle wait	120								100.0
smon timer	20	5.0	5.0					10.0	80.0
wait for unread message on broadcast channel	3647			.0	.4	.6	.2	98.8

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	<1/2s	<1s	<2s	>=2s
		% of Total Waits
LGWR wait for redo copy	2	99.9	.1	.1
SQL*Net break/reset to client	18	99.1	.4	.5
SQL*Net more data from client	168	99.6	.1	.1	.2
SQL*Net more data to client	97	100.0	.0	.0	.0	.0
buffer busy waits	126	95.5	.2	.5	1.2	.4	.6	.5	1.1
control file parallel write	3	99.8	.1	.1
cursor: pin S wait on X	3	70.0	20.0	10.0
db file parallel write	3	99.9	.1
enq: SQ - contention	2	96.8		3.2
enq: TX - contention	3	57.1	14.3	28.6
latch: In memory undo latch	1	99.5	.5
latch: cache buffers chains	2	99.6	.2		.2
latch: enqueue hash chains	1	50.0		50.0
log file parallel write	56	100.0	.0	.0	.0
log file sync	822	99.1	.6	.3	.1	.0	.0
os thread startup	134				98.5	1.5
resmgr:cpu quantum	25.5K	60.7	19.4	14.2	5.0	.7	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: s is 1024 milliseconds (approximately 1 second) m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes)
% 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 4s to 2m	<2s	<4s	<8s	<16s	<32s	< 1m	< 2m	>=2m
		% of Total Waits
buffer busy waits	42	98.9	.8	.3

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)
mdm	8,223	4,617	26,181
SYS$USERS	33	30	101
SYS$BACKGROUND	0	0	20
mdmXDB	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
mdm	1604	16277	243	583995	24
SYS$USERS	30	2	0	3124	0
SYS$BACKGROUND	68	139	23	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 50.1% of Total DB Time (s): 8,256
Captured PL/SQL account for 0.1% of Total DB Time (s): 8,256

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
3,440.11	28,140	0.12	41.67	36.03	0.00	cbyqa39u1xbzr	httpd@JQYX107 (TNS V1-V3)	select a.* from tracking.cpic_...
410.30	1,003	0.41	4.97	36.57	0.00	3nn75rut43vff	httpd@JQYX107 (TNS V1-V3)	select * from (SELECT rownum, ...
116.12	43,302	0.00	1.41	8.83	0.12	f711myt0q6cma	plsqldev.exe	insert into sys.aud$( sessioni...
24.57	43,367	0.00	0.30	61.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
17.08	43,284	0.00	0.21	63.57	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
12.98	133,305	0.00	0.16	62.39	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
11.14	15,081	0.00	0.13	59.24	0.06	7y0h4hc80xgb2	httpd@JQYX107 (TNS V1-V3)	INSERT INTO tracking.calltrack...
10.52	1,016	0.01	0.13	40.80	0.00	1vxp08xfkwwmj	httpd@JQYX107 (TNS V1-V3)	SELECT d.psk , d.udid as udid,...
9.86	43,303	0.00	0.12	62.61	0.00	459f3z9u4fb3u		select value$ from props$ wher...
8.79	1,003	0.01	0.11	38.75	0.01	108a5cdjfp1y5	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET user...

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 32.2% of Total CPU Time (s): 4,647
Captured PL/SQL account for 0.1% of Total CPU Time (s): 4,647

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,239.42	28,140	0.04	26.67	3,440.11	36.03	0.00	cbyqa39u1xbzr	httpd@JQYX107 (TNS V1-V3)	select a.* from tracking.cpic_...
150.05	1,003	0.15	3.23	410.30	36.57	0.00	3nn75rut43vff	httpd@JQYX107 (TNS V1-V3)	select * from (SELECT rownum, ...
15.12	43,367	0.00	0.33	24.57	61.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
10.86	43,284	0.00	0.23	17.08	63.57	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
10.26	43,302	0.00	0.22	116.12	8.83	0.12	f711myt0q6cma	plsqldev.exe	insert into sys.aud$( sessioni...
8.10	133,305	0.00	0.17	12.98	62.39	0.00	cm5vu20fhtnq1		select /*+ connect_by_filterin...
6.60	15,081	0.00	0.14	11.14	59.24	0.06	7y0h4hc80xgb2	httpd@JQYX107 (TNS V1-V3)	INSERT INTO tracking.calltrack...
6.17	43,303	0.00	0.13	9.86	62.61	0.00	459f3z9u4fb3u		select value$ from props$ wher...
4.45	28,166	0.00	0.10	7.00	63.53	0.00	657p8c495ganv	httpd@JQYX107 (TNS V1-V3)	select count(*) as num from tr...
4.38	102	0.04	0.09	6.09	72.00	0.00	d5xxfguffwpxh	Realtime Connection	select end_time, wait_class#, ...

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 76.4% of Total User I/O Wait Time (s): 0
Captured PL/SQL account for 0.2% of Total User I/O Wait Time (s): 0

User I/O Time (s)	Executions	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.14	43,302	70.14	116.12	8.83	0.12	f711myt0q6cma	plsqldev.exe	insert into sys.aud$( sessioni...
0.01	15,081	3.50	11.14	59.24	0.06	7y0h4hc80xgb2	httpd@JQYX107 (TNS V1-V3)	INSERT INTO tracking.calltrack...
0.00	1,003	1.17	1.15	26.85	0.21	gk7p12df3ff29	httpd@JQYX107 (TNS V1-V3)	INSERT INTO tracking.log (psk,...
0.00	1,003	0.40	2.13	13.82	0.04	dzyw2j77mngw5	httpd@JQYX107 (TNS V1-V3)	INSERT INTO accounts.session_n...
0.00	1,003	0.37	1.60	17.21	0.05	3w1yjpkz80avf	httpd@JQYX107 (TNS V1-V3)	INSERT INTO devices.device (ps...
0.00	1,790	0.32	0.94	46.65	0.07	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
0.00	1,003	0.25	8.79	38.75	0.01	108a5cdjfp1y5	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET user...
0.00	59	0.22	1.63	81.09	0.03	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0.00	17,607	0.14	4.60	43.76	0.01	f6y2jkunad8p6	httpd@JQYX107 (TNS V1-V3)	SELECT tracking.CPIC_LOG_PSK_S...
0.00	1,003	0.06	8.44	41.39	0.00	90vj6mc17n14u	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET name...

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: 26,303,002
Captured SQL account for 97.1% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
14,274,736	28,140	507.28	54.27	3,440.11	36	cbyqa39u1xbzr	httpd@JQYX107 (TNS V1-V3)	select a.* from tracking.cpic_...
7,060,515	1,003	7,039.40	26.84	410.30	36.6	3nn75rut43vff	httpd@JQYX107 (TNS V1-V3)	select * from (SELECT rownum, ...
639,288	1,016	629.22	2.43	10.52	40.8	1vxp08xfkwwmj	httpd@JQYX107 (TNS V1-V3)	SELECT d.psk , d.udid as udid,...
638,519	1,003	636.61	2.43	8.79	38.8	108a5cdjfp1y5	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET user...
632,898	1,003	631.00	2.41	8.44	41.4	90vj6mc17n14u	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET name...
514,343	1,003	512.80	1.96	7.84	38.8	bhw6avypfkwqu	httpd@JQYX107 (TNS V1-V3)	SELECT * FROM (SELECT rownum, ...
306,591	43,367	7.07	1.17	24.57	61.5	0k8522rmdzg4k		select privilege# from sysauth...
271,170	133,305	2.03	1.03	12.98	62.4	cm5vu20fhtnq1		select /*+ connect_by_filterin...
215,645	1,003	215.00	0.82	3.92	58.9	fyha3mk7nk4ub	httpd@JQYX107 (TNS V1-V3)	select * from (SELECT rownum, ...
199,221	28,166	7.07	0.76	7.00	63.5	657p8c495ganv	httpd@JQYX107 (TNS V1-V3)	select count(*) as num from tr...

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: 13
Captured SQL account for 0.0% of Total

Executions	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,003	0.14	32.15	0.00	0bhkmb66gfdby	httpd@JQYX107 (TNS V1-V3)	SELECT logindisplaymessage, ps...
3,701	1.18	68.46	0.00	0cgzckwfnkaby	httpd@JQYX107 (TNS V1-V3)	SELECT * FROM devices.deviceli...
43,367	24.57	61.53	0.00	0k8522rmdzg4k		select privilege# from sysauth...
1,003	2.45	2.42	0.00	0sff27kbh5t42	httpd@JQYX107 (TNS V1-V3)	select * from (SELECT rownum, ...
1	0.00	98.87	0.00	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
43,284	17.08	63.57	0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
1,003	8.79	38.75	0.01	108a5cdjfp1y5	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET user...
3	0.01	94.03	0.00	11y3zqvxv1f3a	OEM.BoundedPool	UPDATE MGMT_CURRENT_VIOLATION ...
185	0.05	81.79	0.21	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
9	0.01	94.72	0.00	19x1189chq3xd		SELECT LOCKID FROM DBMS_LOCK_A...

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: 13
Captured SQL account for 0.0% of Total
Total UnOptimized Read Requests: 13
Captured SQL account for 0.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
12	12	59	0.20	0.00	92.31	6gvch1xu9ca3g		DECLARE job BINARY_INTEGER := ...
0	0	1,003	0.00		0.00	0bhkmb66gfdby	httpd@JQYX107 (TNS V1-V3)	SELECT logindisplaymessage, ps...
0	0	3,701	0.00		0.00	0cgzckwfnkaby	httpd@JQYX107 (TNS V1-V3)	SELECT * FROM devices.deviceli...
0	0	43,367	0.00		0.00	0k8522rmdzg4k		select privilege# from sysauth...
0	0	1,003	0.00		0.00	0sff27kbh5t42	httpd@JQYX107 (TNS V1-V3)	select * from (SELECT rownum, ...
0	0	1	0.00		0.00	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
0	0	43,284	0.00		0.00	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
0	0	1,003	0.00		0.00	108a5cdjfp1y5	httpd@JQYX107 (TNS V1-V3)	UPDATE devices.device SET user...
0	0	3	0.00		0.00	11y3zqvxv1f3a	OEM.BoundedPool	UPDATE MGMT_CURRENT_VIOLATION ...
0	0	185	0.00		0.00	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...

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: 578,052
Captured SQL account for 83.8% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
133,305	4,712	0.04	12.98	62.4	0	cm5vu20fhtnq1		select /*+ connect_by_filterin...
43,367	133,284	3.07	24.57	61.5	0	0k8522rmdzg4k		select privilege# from sysauth...
43,303	43,281	1.00	9.86	62.6	0	459f3z9u4fb3u		select value$ from props$ wher...
43,302	43,269	1.00	5.02	64.6	0	5ur69atw3vfhj		select decode(failover_method,...
43,302	43,302	1.00	116.12	8.8	.1	f711myt0q6cma	plsqldev.exe	insert into sys.aud$( sessioni...
43,284	43,222	1.00	17.08	63.6	0	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
28,166	28,155	1.00	7.00	63.5	0	657p8c495ganv	httpd@JQYX107 (TNS V1-V3)	select count(*) as num from tr...
28,140	1,033,482	36.73	3,440.11	36	0	cbyqa39u1xbzr	httpd@JQYX107 (TNS V1-V3)	select a.* from tracking.cpic_...
17,607	17,605	1.00	4.60	43.8	0	f6y2jkunad8p6	httpd@JQYX107 (TNS V1-V3)	SELECT tracking.CPIC_LOG_PSK_S...
15,081	15,081	1.00	11.14	59.2	.1	7y0h4hc80xgb2	httpd@JQYX107 (TNS V1-V3)	INSERT INTO tracking.calltrack...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 563,561
Captured SQL account for 68.7% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
43,367	133,305	7.70	cm5vu20fhtnq1		select /*+ connect_by_filterin...
43,302	43,284	7.68	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
43,301	43,302	7.68	f711myt0q6cma	plsqldev.exe	insert into sys.aud$( sessioni...
43,299	43,303	7.68	459f3z9u4fb3u		select value$ from props$ wher...
43,295	43,302	7.68	5ur69atw3vfhj		select decode(failover_method,...
43,267	43,367	7.68	0k8522rmdzg4k		select privilege# from sysauth...
28,163	28,166	5.00	657p8c495ganv	httpd@JQYX107 (TNS V1-V3)	select count(*) as num from tr...
28,140	28,140	4.99	cbyqa39u1xbzr	httpd@JQYX107 (TNS V1-V3)	select a.* from tracking.cpic_...
17,606	17,607	3.12	f6y2jkunad8p6	httpd@JQYX107 (TNS V1-V3)	SELECT tracking.CPIC_LOG_PSK_S...
15,081	15,081	2.68	7y0h4hc80xgb2	httpd@JQYX107 (TNS V1-V3)	INSERT INTO tracking.calltrack...

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,856,154	1	0.06	6wm3n4d7bnddg		SELECT source, (case when tim...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
22	185	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0bhkmb66gfdby SELECT logindisplaymessage, psk, supportemail FROM accounts.organization_nj WHERE psk = :org

0cgzckwfnkaby SELECT * FROM devices.devicelist WHERE devicesn = :devicesn and status =1

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

0sff27kbh5t42 select * from (SELECT rownum, psk, websessiondata, user_nj FROM accounts.session_nj WHERE token = :token) where rownum < 2

0v3dvmc22qnam insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)

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

108a5cdjfp1y5 UPDATE devices.device SET user_nj = :user_nj WHERE udid = :udid

11y3zqvxv1f3a UPDATE MGMT_CURRENT_VIOLATION SET COLLECTION_TIMESTAMP = NVL(:B23 , COLLECTION_TIMESTAMP), VIOLATION_GUID = NVL(:B22 , VIOLATION_GUID), VIOLATION_LEVEL = NVL(:B21 , VIOLATION_LEVEL), VIOLATION_TYPE = NVL(:B20 , VIOLATION_TYPE), ANNOTATED_FLAG = NVL(:B19 , ANNOTATED_FLAG), VALUE = NVL(:B18 , VALUE), STRING_VALUE = NVL(:B17 , STRING_VALUE), MESSAGE = NVL(:B16 , MESSAGE), MESSAGE_NLSID = NVL(:B15 , MESSAGE_NLSID), MESSAGE_PARAMS = NVL(:B14 , MESSAGE_PARAMS), ACTION_MESSAGE = NVL(:B13 , ACTION_MESSAGE), ACTION_MESSAGE_NLSID = NVL(:B12 , ACTION_MESSAGE_NLSID), ACTION_MESSAGE_PARAMS = NVL(:B11 , ACTION_MESSAGE_PARAMS), ADVISORY_ID = NVL(:B10 , ADVISORY_ID), EXEMPT_CODE = NVL(:B9 , EXEMPT_CODE), EXEMPT_UNTIL = NVL(:B8 , EXEMPT_UNTIL), EXEMPT_BY = NVL(:B7 , EXEMPT_BY), CFG_COLL_NAME=NVL(:B6 , CFG_COLL_NAME), CFG_KEY_VALUE=NVL(:B5 , CFG_KEY_VALUE), CFG_KEY_OPERATOR=NVL(:B4 , CFG_KEY_OPERATOR) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1

18naypzfmabd6 INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))

19x1189chq3xd SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE

1vxp08xfkwwmj SELECT d.psk , d.udid as udid, d.operatingsystem , d.formfactor , d.user_nj , d.name , d.manufacturer , d.model , d.osname , d.osver, d.totalram , d.freeram , d.totalstorage , d.freestorage , d.camera , d.frontcamera , d.flash , d.mdm_id , d.mdm_user_id , d.mdm_status , d.mdm_status_update_date AS "mdm_update_date", d.created , d.jailbreak_status , d.controllablestatus , d.pairingstatus , d.apnstoken FROM devices.device d WHERE d.udid = :udid

3nn75rut43vff select * from (SELECT rownum, psk, token, sessionpsk FROM accounts.USERSESSION WHERE lower(user_id)=lower(:userId) AND password=:password ORDER BY lastupdate DESC) where rownum < 2

3w1yjpkz80avf INSERT INTO devices.device (psk, udid, name, manufacturer, model, osname, osver, totalram, freeram, totalstorage, freestorage, camera, frontcamera, flash, operatingsystem, formfactor, jailbreak_status, pairingstatus) VALUES (devices.device_psk_seq.nextval, :udid, :name, :manufacturer, :model, :osname, :osver, :totalram, :freeram, :totalstorage, :freestorage, :camera, :frontcamera, :flash, :operatingsystem, :formfactor, :jailbreak_status, :pairingstatus)

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

4m7m0t6fjcs5x update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1

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

657p8c495ganv select count(*) as num from tracking.cpic_log

6gvch1xu9ca3g DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

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 BY source ASC, time_secs DESC, log_id ASC

7y0h4hc80xgb2 INSERT INTO tracking.calltracking (psk, clienttype, ip, created, method) VALUES (tracking.calltracking_psk_seq.nextval, :pdo1, :pdo2, TO_DATE(:pdo3, 'yyyy-mm-dd hh24:mi:ss'), :pdo4)

90vj6mc17n14u UPDATE devices.device SET name = :name, manufacturer = :manufacturer, model = :model, osname = :osname, osver = :osver, totalram = :totalram, freeram = :freeram, totalstorage = :totalstorage, freestorage = :freestorage, camera = :camera, frontcamera = :frontcamera, flash = :flash, operatingsystem = :operatingsystem, formfactor = :formfactor, jailbreak_status = :jailbreak_status WHERE udid = :udid

bhw6avypfkwqu SELECT * FROM (SELECT rownum, psk as "psk", user_nj as "user_nj" FROM devices.device WHERE udid = :udid) where rownum < 2

cbyqa39u1xbzr select a.* from tracking.cpic_log a right join (select deviceip from tracking.cpic_log group by deviceip) b on b.deviceip = a.deviceip and a.logmsg like '%com.apperian.easesdk.authenticate%' order by a.logdate asc

cm5vu20fhtnq1 select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0

d5xxfguffwpxh select end_time, wait_class#, (time_waited_fg)/(intsize_csec/100), (time_waited)/(intsize_csec/100), 0 from v$waitclassmetric union all select fg.end_time, -1, fg.value, bg.value, dbtime.value from v$sysmetric fg, v$sysmetric bg, v$sysmetric dbtime where bg.metric_name = 'Background CPU Usage Per Sec' and bg.group_id = 2 and fg.metric_name = 'CPU Usage Per Sec' and fg.group_id = 2 and dbtime.metric_name = 'Average Active Sessions' and dbtime.group_id = 2 and bg.end_time = fg.end_time and fg.end_time = dbtime.end_time order by end_time, wait_class#

dzyw2j77mngw5 INSERT INTO accounts.session_nj (psk, user_nj, token, sessionrandom, devicesn , lastupdate, prune) VALUES (accounts.session_psk_seq.nextval, :userpsk, :token, :sessionrandom, :devicesn, sysdate, (sysdate + TO_NUMBER(:time)))

f6y2jkunad8p6 SELECT tracking.CPIC_LOG_PSK_SEQ.nextval FROM DUAL

f711myt0q6cma insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)

fyha3mk7nk4ub select * from (SELECT rownum, userorg.organization_nj orgpsk, organization_nj.isappdeleteenabled isappdeleteenabled, organization_nj.isemailprovisionenabled FROM devices.DEVICEBYUSER devuser, accounts.userorganization userorg, accounts.organization_nj organization_nj WHERE devuser.udid = :udid AND userorg.user_nj = devuser.user_nj AND organization_nj.psk = userorg.organization_nj )where rownum < 2

gk7p12df3ff29 INSERT INTO tracking.log (psk, interface, module, action, success, ipaddress, user_nj, device, appid, app_psk, app_name, org_psk, version_psk, version_number, session_token, certificate, provisionprofile, credentialsdesc) VALUES (tracking.log_psk_seq.nextval, :interface, :module, :action, :success, :ip, :user_nj, :device, :appId, :app_psk, :app_name, :org_psk, :version_psk, :version_number, :session_token, :certificate, :provisionprofile, :credentialsdesc)

SQL Id	SQL Text
0bhkmb66gfdby	SELECT logindisplaymessage, psk, supportemail FROM accounts.organization_nj WHERE psk = :org
0cgzckwfnkaby	SELECT * FROM devices.devicelist WHERE devicesn = :devicesn and status =1
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0sff27kbh5t42	select * from (SELECT rownum, psk, websessiondata, user_nj FROM accounts.session_nj WHERE token = :token) where rownum < 2
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
108a5cdjfp1y5	UPDATE devices.device SET user_nj = :user_nj WHERE udid = :udid
11y3zqvxv1f3a	UPDATE MGMT_CURRENT_VIOLATION SET COLLECTION_TIMESTAMP = NVL(:B23 , COLLECTION_TIMESTAMP), VIOLATION_GUID = NVL(:B22 , VIOLATION_GUID), VIOLATION_LEVEL = NVL(:B21 , VIOLATION_LEVEL), VIOLATION_TYPE = NVL(:B20 , VIOLATION_TYPE), ANNOTATED_FLAG = NVL(:B19 , ANNOTATED_FLAG), VALUE = NVL(:B18 , VALUE), STRING_VALUE = NVL(:B17 , STRING_VALUE), MESSAGE = NVL(:B16 , MESSAGE), MESSAGE_NLSID = NVL(:B15 , MESSAGE_NLSID), MESSAGE_PARAMS = NVL(:B14 , MESSAGE_PARAMS), ACTION_MESSAGE = NVL(:B13 , ACTION_MESSAGE), ACTION_MESSAGE_NLSID = NVL(:B12 , ACTION_MESSAGE_NLSID), ACTION_MESSAGE_PARAMS = NVL(:B11 , ACTION_MESSAGE_PARAMS), ADVISORY_ID = NVL(:B10 , ADVISORY_ID), EXEMPT_CODE = NVL(:B9 , EXEMPT_CODE), EXEMPT_UNTIL = NVL(:B8 , EXEMPT_UNTIL), EXEMPT_BY = NVL(:B7 , EXEMPT_BY), CFG_COLL_NAME=NVL(:B6 , CFG_COLL_NAME), CFG_KEY_VALUE=NVL(:B5 , CFG_KEY_VALUE), CFG_KEY_OPERATOR=NVL(:B4 , CFG_KEY_OPERATOR) WHERE TARGET_GUID = :B3 AND POLICY_GUID = :B2 AND KEY_VALUE = :B1
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
19x1189chq3xd	SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE
1vxp08xfkwwmj	SELECT d.psk , d.udid as udid, d.operatingsystem , d.formfactor , d.user_nj , d.name , d.manufacturer , d.model , d.osname , d.osver, d.totalram , d.freeram , d.totalstorage , d.freestorage , d.camera , d.frontcamera , d.flash , d.mdm_id , d.mdm_user_id , d.mdm_status , d.mdm_status_update_date AS "mdm_update_date", d.created , d.jailbreak_status , d.controllablestatus , d.pairingstatus , d.apnstoken FROM devices.device d WHERE d.udid = :udid
3nn75rut43vff	select * from (SELECT rownum, psk, token, sessionpsk FROM accounts.USERSESSION WHERE lower(user_id)=lower(:userId) AND password=:password ORDER BY lastupdate DESC) where rownum < 2
3w1yjpkz80avf	INSERT INTO devices.device (psk, udid, name, manufacturer, model, osname, osver, totalram, freeram, totalstorage, freestorage, camera, frontcamera, flash, operatingsystem, formfactor, jailbreak_status, pairingstatus) VALUES (devices.device_psk_seq.nextval, :udid, :name, :manufacturer, :model, :osname, :osver, :totalram, :freeram, :totalstorage, :freestorage, :camera, :frontcamera, :flash, :operatingsystem, :formfactor, :jailbreak_status, :pairingstatus)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
657p8c495ganv	select count(*) as num from tracking.cpic_log
6gvch1xu9ca3g	DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
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 BY source ASC, time_secs DESC, log_id ASC
7y0h4hc80xgb2	INSERT INTO tracking.calltracking (psk, clienttype, ip, created, method) VALUES (tracking.calltracking_psk_seq.nextval, :pdo1, :pdo2, TO_DATE(:pdo3, 'yyyy-mm-dd hh24:mi:ss'), :pdo4)
90vj6mc17n14u	UPDATE devices.device SET name = :name, manufacturer = :manufacturer, model = :model, osname = :osname, osver = :osver, totalram = :totalram, freeram = :freeram, totalstorage = :totalstorage, freestorage = :freestorage, camera = :camera, frontcamera = :frontcamera, flash = :flash, operatingsystem = :operatingsystem, formfactor = :formfactor, jailbreak_status = :jailbreak_status WHERE udid = :udid
bhw6avypfkwqu	SELECT * FROM (SELECT rownum, psk as "psk", user_nj as "user_nj" FROM devices.device WHERE udid = :udid) where rownum < 2
cbyqa39u1xbzr	select a.* from tracking.cpic_log a right join (select deviceip from tracking.cpic_log group by deviceip) b on b.deviceip = a.deviceip and a.logmsg like '%com.apperian.easesdk.authenticate%' order by a.logdate asc
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
d5xxfguffwpxh	select end_time, wait_class#, (time_waited_fg)/(intsize_csec/100), (time_waited)/(intsize_csec/100), 0 from v$waitclassmetric union all select fg.end_time, -1, fg.value, bg.value, dbtime.value from v$sysmetric fg, v$sysmetric bg, v$sysmetric dbtime where bg.metric_name = 'Background CPU Usage Per Sec' and bg.group_id = 2 and fg.metric_name = 'CPU Usage Per Sec' and fg.group_id = 2 and dbtime.metric_name = 'Average Active Sessions' and dbtime.group_id = 2 and bg.end_time = fg.end_time and fg.end_time = dbtime.end_time order by end_time, wait_class#
dzyw2j77mngw5	INSERT INTO accounts.session_nj (psk, user_nj, token, sessionrandom, devicesn , lastupdate, prune) VALUES (accounts.session_psk_seq.nextval, :userpsk, :token, :sessionrandom, :devicesn, sysdate, (sysdate + TO_NUMBER(:time)))
f6y2jkunad8p6	SELECT tracking.CPIC_LOG_PSK_SEQ.nextval FROM DUAL
f711myt0q6cma	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22)
fyha3mk7nk4ub	select * from (SELECT rownum, userorg.organization_nj orgpsk, organization_nj.isappdeleteenabled isappdeleteenabled, organization_nj.isemailprovisionenabled FROM devices.DEVICEBYUSER devuser, accounts.userorganization userorg, accounts.organization_nj organization_nj WHERE devuser.udid = :udid AND userorg.user_nj = devuser.user_nj AND organization_nj.psk = userorg.organization_nj )where rownum < 2
gk7p12df3ff29	INSERT INTO tracking.log (psk, interface, module, action, success, ipaddress, user_nj, device, appid, app_psk, app_name, org_psk, version_psk, version_number, session_token, certificate, provisionprofile, credentialsdesc) VALUES (tracking.log_psk_seq.nextval, :interface, :module, :action, :success, :ip, :user_nj, :device, :appId, :app_psk, :app_name, :org_psk, :version_psk, :version_number, :session_token, :certificate, :provisionprofile, :credentialsdesc)

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
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	0	0.00	0.00
Batched IO single block count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	33	0.01	0.00
CCursor + sql area evicted	17	0.00	0.00
CPU used by this session	169,161	46.92	2.04
CPU used when call started	167,503	46.46	2.02
CR blocks created	15,803	4.38	0.19
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	36	0.01	0.00
DB time	1,598,776	443.45	19.26
DBWR checkpoint buffers written	11,208	3.11	0.14
DBWR checkpoints	2	0.00	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR transaction table writes	124	0.03	0.00
DBWR undo block writes	4,183	1.16	0.05
Effective IO time	0	0.00	0.00
HSC Heap Segment Block Changes	148,426	41.17	1.79
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	113	0.03	0.00
Heap Segment Array Updates	155	0.04	0.00
IMU CR rollbacks	1,883	0.52	0.02
IMU Flushes	4,951	1.37	0.06
IMU Redo allocation size	5,086,508	1,410.83	61.29
IMU commits	35,454	9.83	0.43
IMU contention	1,037	0.29	0.01
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	249	0.07	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	45,911,344	12,734.32	553.19
IMU- failed to get a private strand	249	0.07	0.00
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
Requests to/from client	367,482	101.93	4.43
RowCR - row contention	0	0.00	0.00
RowCR attempts	546	0.15	0.01
RowCR hits	546	0.15	0.01
SMON posted for undo segment shrink	2	0.00	0.00
SQL*Net roundtrips to/from client	410,730	113.92	4.95
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	4,266	1.18	0.05
application wait time	451	0.13	0.01
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	2	0.00	0.00
background checkpoints started	2	0.00	0.00
background timeouts	18,727	5.19	0.23
branch node splits	0	0.00	0.00
buffer is not pinned count	987,512	273.90	11.90
buffer is pinned count	1,092,498	303.02	13.16
bytes received via SQL*Net from client	130,918,455	36,312.54	1,577.44
bytes sent via SQL*Net to client	479,234,895	132,924.22	5,774.33
calls to get snapshot scn: kcmgss	605,960	168.07	7.30
calls to kcmgas	150,194	41.66	1.81
calls to kcmgcs	1,005,607	278.92	12.12
cell physical IO interconnect bytes	370,470,912	102,756.62	4,463.83
change write time	1,712	0.47	0.02
cleanout - number of ktugct calls	7,051	1.96	0.08
cleanouts and rollbacks - consistent read gets	2,005	0.56	0.02
cleanouts only - consistent read gets	570	0.16	0.01
cluster key scan block gets	2,590	0.72	0.03
cluster key scans	2,211	0.61	0.03
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	15	0.00	0.00
commit batch/immediate requested	15	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	27	0.01	0.00
commit cleanout failures: cannot pin	3,273	0.91	0.04
commit cleanouts	176,783	49.03	2.13
commit cleanouts successfully completed	173,483	48.12	2.09
commit immediate performed	15	0.00	0.00
commit immediate requested	15	0.00	0.00
commit txn count during cleanout	4,113	1.14	0.05
concurrency wait time	26,538	7.36	0.32
consistent changes	36,391	10.09	0.44
consistent gets	25,589,774	7,097.77	308.33
consistent gets - examination	390,397	108.28	4.70
consistent gets direct	0	0.00	0.00
consistent gets from cache	25,589,774	7,097.77	308.33
consistent gets from cache (fastpath)	23,648,537	6,559.34	284.94
cursor authentications	72	0.02	0.00
data blocks consistent reads - undo records applied	34,994	9.71	0.42
db block changes	674,926	187.20	8.13
db block gets	713,228	197.83	8.59
db block gets direct	25	0.01	0.00
db block gets from cache	713,203	197.82	8.59
db block gets from cache (fastpath)	104,497	28.98	1.26
deferred (CURRENT) block cleanout applications	97,695	27.10	1.18
enqueue conversions	743	0.21	0.01
enqueue releases	383,244	106.30	4.62
enqueue requests	383,246	106.30	4.62
enqueue timeouts	1	0.00	0.00
enqueue waits	102	0.03	0.00
exchange deadlocks	12	0.00	0.00
execute count	578,052	160.33	6.96
failed probes on index block reclamation	6	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	3,393,381	941.21	40.89
free buffer inspected	4	0.00	0.00
free buffer requested	21,765	6.04	0.26
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	2,684	0.74	0.03
immediate (CR) block cleanout applications	2,575	0.71	0.03
immediate (CURRENT) block cleanout applications	1,600	0.44	0.02
in call idle wait time	8,810,520	2,443.75	106.16
index crx upgrade (positioned)	5,534	1.53	0.07
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	28,244	7.83	0.34
index fetch by key	46,919	13.01	0.57
index scans kdiixs1	294,478	81.68	3.55
leaf node 90-10 splits	76	0.02	0.00
leaf node splits	127	0.04	0.00
lob reads	1	0.00	0.00
lob writes	5	0.00	0.00
lob writes unaligned	5	0.00	0.00
logical read bytes from cache	215,473,897,472	59,765,473.91	2,596,258.74
logons cumulative	43,504	12.07	0.52
max cf enq hold time	6	0.00	0.00
messages received	129,901	36.03	1.57
messages sent	129,901	36.03	1.57
min active SCN optimization applied on CR	0	0.00	0.00
no buffer to keep pinned count	0	0.00	0.00
no work - consistent read gets	24,284,716	6,735.79	292.61
non-idle wait count	1,038,052	287.92	12.51
non-idle wait time	336,362	93.30	4.05
opened cursors cumulative	675,522	187.37	8.14
parse count (describe)	0	0.00	0.00
parse count (failures)	872	0.24	0.01
parse count (hard)	18,584	5.15	0.22
parse count (total)	563,561	156.31	6.79
parse time cpu	4,954	1.37	0.06
parse time elapsed	8,936	2.48	0.11
physical read IO requests	13	0.00	0.00
physical read bytes	106,496	29.54	1.28
physical read total IO requests	3,274	0.91	0.04
physical read total bytes	53,389,312	14,808.46	643.29
physical read total multi block requests	0	0.00	0.00
physical reads	13	0.00	0.00
physical reads cache	1	0.00	0.00
physical reads cache prefetch	0	0.00	0.00
physical reads direct	12	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	3,430	0.95	0.04
physical write bytes	92,119,040	25,550.84	1,109.95
physical write total IO requests	130,204	36.11	1.57
physical write total bytes	317,081,600	87,948.16	3,820.54
physical write total multi block requests	426	0.12	0.01
physical writes	11,245	3.12	0.14
physical writes direct	37	0.01	0.00
physical writes direct (lob)	1	0.00	0.00
physical writes direct temporary tablespace	1	0.00	0.00
physical writes from cache	11,208	3.11	0.14
physical writes non checkpoint	3,848	1.07	0.05
pinned cursors current	2	0.00	0.00
prefetch clients - default	1,648	0.46	0.02
prefetch warmup blocks flushed out before use	0	0.00	0.00
process last non-idle time	11,728	3.25	0.14
recursive calls	5,624,126	1,559.95	67.77
recursive cpu usage	15,118	4.19	0.18
redo blocks checksummed by FG (exclusive)	25,061	6.95	0.30
redo blocks written	298,544	82.81	3.60
redo buffer allocation retries	3	0.00	0.00
redo entries	268,174	74.38	3.23
redo log space requests	3	0.00	0.00
redo log space wait time	2	0.00	0.00
redo ordering marks	3,555	0.99	0.04
redo size	121,658,116	33,744.02	1,465.87
redo size for direct writes	208	0.06	0.00
redo subscn max counts	5,944	1.65	0.07
redo synch long waits	413	0.11	0.00
redo synch poll writes	31,403	8.71	0.38
redo synch polls	52,906	14.67	0.64
redo synch time	45,557	12.64	0.55
redo synch time (usec)	501,979,575	139,232.86	6,048.38
redo synch writes	126,757	35.16	1.53
redo wastage	26,416,632	7,327.12	318.30
redo write time	13,016	3.61	0.16
redo writes	123,547	34.27	1.49
rollback changes - undo records applied	40	0.01	0.00
rollbacks only - consistent read gets	13,679	3.79	0.16
root node splits	0	0.00	0.00
rows fetched via callback	25,084	6.96	0.30
scheduler wait time	267,824	74.29	3.23
session connect time	0	0.00	0.00
session cursor cache hits	46,658	12.94	0.56
session logical reads	26,303,002	7,295.60	316.93
shared hash latch upgrades - no wait	16,207	4.50	0.20
shared hash latch upgrades - wait	1	0.00	0.00
sorts (memory)	311,983	86.53	3.76
sorts (rows)	746,980,273	207,188.11	9,000.41
sql area evicted	15,518	4.30	0.19
sql area purged	872	0.24	0.01
switch current to new buffer	2,106	0.58	0.03
table fetch by rowid	827,965	229.65	9.98
table fetch continued row	24	0.01	0.00
table scan blocks gotten	23,177,651	6,428.73	279.27
table scan rows gotten	610,185,598	169,245.70	7,352.17
table scans (long tables)	0	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	166,742	46.25	2.01
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	484	0.13	0.01
total number of cf enq holders	99	0.03	0.00
total number of times SMON posted	9	0.00	0.00
transaction rollbacks	11	0.00	0.00
undo change vector size	31,116,100	8,630.60	374.92
user I/O wait time	21	0.01	0.00
user calls	884,817	245.42	10.66
user commits	39,739	11.02	0.48
user rollbacks	43,255	12.00	0.52
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	74,250	20.59	0.89
write clones created in foreground	1	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
opened cursors current	216	219
workarea memory allocated	0	410
logons current	45	44
session uga memory max	406,919,066,912	437,057,048,960
session pga memory	15,035,552,448	15,186,517,216
session pga memory max	17,908,929,888	18,063,368,064
session cursor cache count	5,013,574	5,514,596
session uga memory	27,915,274,326,600	28,205,266,217,032

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)	2	2.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)
LGWR	1M	0.01	.000277	147M	34.30	.040773	123.6K	0.50
Others	50M	0.89	.013868	68M	0.86	.018860	4750	0.23
DBWR	0M	0.00	0M	87M	0.95	.024130	10	0.00
Buffer Cache Reads	0M	0.00	0M	0M	0.00	0M	1	0.00
Direct Reads	0M	0.00	0M	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	51M	0.91	.014145	302M	36.12	.083765	128.4K	0.49

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
Log File	0M	0.00	0M	146M	34.29	.040495
Control File	50M	0.90	.013868	49M	0.87	.013591
Data File	0M	0.01	0M	87M	0.95	.024130
Temp File	0M	0.00	0M	0M	0.00	0M
TOTAL:	50M	0.91	.013868	282M	36.11	.078217

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)
LGWR	1M	0.01	.000277	147M	34.30	.040773	48	0.00
LGWR (Log File)	0M	0.00	0M	146M	34.29	.040495	8	0.00
LGWR (Control File)	1M	0.01	.000277	1M	0.01	.000277	40	0.00
Others	50M	0.89	.013868	68M	0.86	.018860	3209	0.00
Others (Control File)	50M	0.89	.013868	48M	0.85	.013313	3197	0.00
Others (Data File)	0M	0.00	0M	20M	0.01	.005547	12	0.00
DBWR	0M	0.00	0M	87M	0.95	.024130	10	0.00
DBWR (Data File)	0M	0.00	0M	87M	0.95	.024130	0
DBWR (Control File)	0M	0.00	0M	0M	0.00	0M	10	0.00
Buffer Cache Reads	0M	0.00	0M	0M	0.00	0M	1	0.00
Buffer Cache Reads (Data File)	0M	0.00	0M	0M	0.00	0M	1	0.00
Direct Reads	0M	0.00	0M	0M	0.00	0M	0
Direct Reads (Data File)	0M	0.00	0M	0M	0.00	0M	0
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	51M	0.91	.014145	302M	36.12	.083765	3268	0.00

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
MDM	4	1.00	1,562	877	1.23
SYSAUX	2	1.00	1,162	0	0.00
UNDOTBS1	2	1.00	450	269	1.49
SYSTEM	2	1.00	253	2,759	84.99
USERS	2	1.00	2	0	0.00
TEMP	1	1.00	1	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Blks/Rd	Writes	Buffer Waits	Av Buf Wt(ms)
MDM	/mdm/mdm/mdm_01.dbf	2	1.00	1,389	862	1.25
MDM	/mdm/mdm/mdm_02.dbf	2	1.00	173	15	0.00
SYSAUX	/mdm/mdm/sysaux01.dbf	2	1.00	1,162	0	0.00
SYSTEM	/mdm/mdm/system01.dbf	2	1.00	253	2,759	84.99
TEMP	/mdm/mdm/temp01.dbf	1	1.00	1	0
UNDOTBS1	/mdm/mdm/undotbs01.dbf	2	1.00	450	269	1.49
USERS	/mdm/mdm/users01.dbf	2	1.00	2	0	0.00

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	1,656,480	100	26,271,040	1	11,208	0	0	3,905

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 11,245

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	11,208	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	15	606	2642	4126	849285	4126
E	0	15	341	1554	45817	849285	45817

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	1,344	0.10	166	1.10	78	1	65.00
D	2,688	0.20	331	1.00	71	1	51.00
D	4,032	0.30	497	1.00	71	1	51.00
D	5,376	0.40	663	1.00	71	1	51.00
D	6,720	0.50	828	1.00	71	1	51.00
D	8,064	0.60	994	1.00	71	1	51.00
D	9,408	0.70	1,160	1.00	71	1	51.00
D	10,752	0.80	1,325	1.00	71	1	51.00
D	12,096	0.90	1,491	1.00	71	1	51.00
D	13,440	1.00	1,656	1.00	71	1	51.00
D	14,784	1.10	1,822	1.00	71	1	51.00
D	16,128	1.20	1,988	1.00	71	1	51.00
D	17,472	1.30	2,153	1.00	71	1	51.00
D	18,816	1.40	2,319	1.00	71	1	51.00
D	20,160	1.50	2,485	1.00	71	1	51.00
D	21,504	1.60	2,650	1.00	71	1	51.00
D	22,848	1.70	2,816	1.00	71	1	51.00
D	24,192	1.80	2,982	1.00	71	1	51.00
D	25,536	1.90	3,147	1.00	71	1	51.00
D	26,880	2.00	3,313	1.00	71	1	51.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	5,335	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

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

	PGA Aggr Target(M)	Auto PGA Target(M)	PGA Mem Alloc(M)	W/A PGA Used(M)	%PGA W/A Mem	%Auto W/A Mem	%Man W/A Mem	Global Mem Bound(K)
B	4,096	3,582	174.33	0.00	0.00	0.00	0.00	419,430
E	4,096	3,582	174.03	0.40	0.23	100.00	0.00	419,430

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	63,274	63,274
64K	128K	1,232	1,232
128K	256K	2,464	2,464
256K	512K	1,394	1,394
512K	1024K	5,808	5,808
1M	2M	65	65
2M	4M	6	6
4M	8M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
512	0.13	149,745.59	9,106.68	94.00	224	6,526,402
1,024	0.25	149,745.59	3,455.84	98.00	45	6,294,239
2,048	0.50	149,745.59	995.72	99.00	0	6,193,165
3,072	0.75	149,745.59	995.72	99.00	0	6,193,165
4,096	1.00	149,745.59	0.00	100.00	0	6,152,256
4,915	1.20	149,745.59	0.00	100.00	0	6,152,256
5,734	1.40	149,745.59	0.00	100.00	0	6,152,256
6,554	1.60	149,745.59	0.00	100.00	0	6,152,256
7,373	1.80	149,745.59	0.00	100.00	0	6,152,256
8,192	2.00	149,745.59	0.00	100.00	0	6,152,256
12,288	3.00	149,745.59	0.00	100.00	0	6,152,256
16,384	4.00	149,745.59	0.00	100.00	0	6,152,256
24,576	6.00	149,745.59	0.00	100.00	0	6,152,256
32,768	8.00	149,745.59	0.00	100.00	0	6,152,256

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)
1,600	0.58	200	38,690	116,781	0.69	57,097	13.09	14,103
1,888	0.69	487	61,721	153,467	0.91	20,411	4.68	17,686
2,176	0.79	773	78,310	162,837	0.96	11,041	2.53	18,556
2,432	0.88	1,029	96,897	166,183	0.98	7,695	1.76	18,865
2,464	0.90	1,061	99,080	166,589	0.98	7,289	1.67	18,903
2,496	0.91	1,093	101,558	167,041	0.99	6,837	1.57	18,947
2,528	0.92	1,125	104,032	167,427	0.99	6,451	1.48	18,985
2,560	0.93	1,157	106,383	167,775	0.99	6,103	1.40	19,017
2,592	0.94	1,188	108,659	168,112	0.99	5,766	1.32	19,049
2,624	0.95	1,220	110,938	168,489	0.99	5,389	1.24	19,084
2,656	0.97	1,252	113,210	168,742	1.00	5,136	1.18	19,109
2,688	0.98	1,284	115,490	169,011	1.00	4,867	1.12	19,133
2,720	0.99	1,316	117,613	169,324	1.00	4,554	1.04	19,161
2,752	1.00	1,347	119,824	169,516	1.00	4,362	1.00	19,182
2,784	1.01	1,379	122,413	169,516	1.00	4,362	1.00	19,182
2,816	1.02	1,411	125,002	169,516	1.00	4,362	1.00	19,182
2,848	1.03	1,443	127,591	169,516	1.00	4,362	1.00	19,182
2,880	1.05	1,475	130,377	169,516	1.00	4,362	1.00	19,183
2,912	1.06	1,507	133,332	169,516	1.00	4,362	1.00	19,183
2,944	1.07	1,539	136,287	169,516	1.00	4,362	1.00	19,183
2,976	1.08	1,571	139,242	169,516	1.00	4,362	1.00	19,183
3,008	1.09	1,603	142,028	169,516	1.00	4,362	1.00	19,183
3,040	1.10	1,635	143,596	169,516	1.00	4,362	1.00	19,183
3,328	1.21	1,923	158,152	169,521	1.00	4,357	1.00	19,183
3,616	1.31	2,211	180,083	169,523	1.00	4,355	1.00	19,183
3,904	1.42	2,499	202,128	169,525	1.00	4,353	1.00	19,184
4,192	1.52	2,787	224,245	169,525	1.00	4,353	1.00	19,184
4,480	1.63	3,075	246,362	169,525	1.00	4,353	1.00	19,184
4,768	1.73	3,363	268,479	169,525	1.00	4,353	1.00	19,184
5,056	1.84	3,650	290,512	169,529	1.00	4,349	1.00	19,184
5,344	1.94	3,938	312,487	169,529	1.00	4,349	1.00	19,184
5,632	2.05	4,226	334,462	169,529	1.00	4,349	1.00	19,184

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
4,096	0.25	87,232	78,125
6,144	0.38	86,190	70,708
8,192	0.50	86,181	70,708
10,240	0.63	86,181	70,708
12,288	0.75	86,181	70,708
14,336	0.88	86,181	70,708
16,384	1.00	86,181	70,708
18,432	1.13	86,181	70,708
20,480	1.25	86,181	70,708
22,528	1.38	86,181	70,708
24,576	1.50	86,181	70,708
26,624	1.63	86,181	70,708
28,672	1.75	86,181	70,708
30,720	1.88	86,181	70,708
32,768	2.00	86,181	70,708

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)
32	1.00	0	0	0	0
64	2.00	0	0	0	0
96	3.00	0	0	0	0
128	4.00	0	0	0	0
160	5.00	0	0	0	0
192	6.00	0	0	0	0
224	7.00	0	0	0	0
256	8.00	0	0	0	0
288	9.00	0	0	0	0
320	10.00	0	0	0	0
352	11.00	0	0	0	0
384	12.00	0	0	0	0
416	13.00	0	0	0	0
448	14.00	0	0	0	0
480	15.00	0	0	0	0
512	16.00	0	0	0	0
544	17.00	0	0	0	0
576	18.00	0	0	0	0
608	19.00	0	0	0	0
640	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

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	3,087	236	76
undo header	241	0	1
undo block	28	0	5
segment header	545	0	0
1st level bmb	4	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Waits	Av Wt Time(ms)
TX-Transaction	128,637	128,630	7	40.86
SQ-Sequence Cache	1,852	1,852	62	4.05
TX-Transaction (row lock contention)	4	4	4	14.25
HW-Segment High Water Mark	595	595	29	0.69

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	4.12	128,678	940	5	20.6/30.7	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
22-6月 15:59	23	200	935	2	31	0/0	0/0/0/0/0/0
22-6月 15:49	16	129	336	2	21	0/0	0/0/0/0/0/0
22-6月 15:39	998	24,430	939	5	31	0/0	0/0/0/0/0/0
22-6月 15:29	1,276	42,288	337	5	21	0/0	0/0/0/0/0/0
22-6月 15:19	1,088	39,593	940	4	31	0/0	0/0/0/0/0/0
22-6月 15:09	719	22,038	338	3	21	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
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	Wait Time (s)	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	58	0.00		0	0
AQ deq log cmt cbk chunk latch	4	0.00		0	0
AQ deq log statistics latch	2	0.00		0	0
AQ dequeue txn counter latch	3,128	0.00		0	0
AQ ht cmt cbk chunk latch	8	0.00		0	0
ASM db client latch	2,405	0.00		0	0
ASM map operation hash table	1	0.00		0	0
ASM network state latch	69	0.00		0	0
AWR Alerted Metric Element list	26,727	0.00		0	0
Change Notification Hash table latch	1,202	0.00		0	0
Consistent RBA	123,551	0.00	0.00	0	0
DML lock allocation	317,480	0.00	0.00	0	0
Event Group Locks	86,935	0.01	0.00	0	0
FIB s.o chain latch	4	0.00		0	0
FOB s.o list latch	3,345	0.00		0	0
File State Object Pool Parent Latch	1	0.00		0	0
I/O Staticstics latch	1	0.00		0	0
IPC stats buffer allocation latch	1	0.00		0	0
In memory undo latch	215,281	0.13	0.78	0	42,299	0.08
JS Sh mem access	7	0.00		0	0
JS mem alloc latch	17	0.00		0	0
JS queue access latch	18	0.00		0	0
JS queue state obj latch	26,080	0.00		0	0
JS slv state obj latch	227	0.00		0	0
KFC FX Hash Latch	1	0.00		0	0
KFC Hash Latch	1	0.00		0	0
KFCL LE Freelist	1	0.00		0	0
KGNFS-NFS:SHM structure	1	0.00		0	0
KGNFS-NFS:SVR LIST	1	0.00		0	0
KJC message pool free list	1	0.00		0	0
KJCT flow control latch	1	0.00		0	0
KMG MMAN ready and startup request latch	1,202	0.00		0	0
KTF sga latch	20	0.00		0	1,083	0.00
KWQMN job cache list latch	18	0.00		0	0
KWQP Prop Status	2	0.00		0	0
KWQS pqsubs latch	9	0.00		0	0
KWQS pqueue ctx latch	101	0.00		0	0
Locator state objects pool parent latch	1	0.00		0	0
Lsod array latch	1	0.00		0	0
MQL Tracking Latch	0			0	72	0.00
Memory Management Latch	1	0.00		0	1,202	0.00
Memory Queue	1	0.00		0	0
Memory Queue Message Subscriber #1	1	0.00		0	0
Memory Queue Message Subscriber #2	1	0.00		0	0
Memory Queue Message Subscriber #3	1	0.00		0	0
Memory Queue Message Subscriber #4	1	0.00		0	0
Memory Queue Subscriber	1	0.00		0	0
MinActiveScn Latch	40	0.00		0	0
Mutex	1	0.00		0	0
Mutex Stats	1	0.00		0	0
OS process	174,426	0.00		0	0
OS process allocation	94,593	0.44	0.00	0	0
OS process: request allocation	86,877	0.35	0.01	0	0
PL/SQL warning settings	44,925	0.01	0.00	0	0
PX hash array latch	1	0.00		0	0
QMT	1	0.00		0	0
Real-time plan statistics latch	960	0.00		0	0
SGA blob parent	1	0.00		0	0
SGA bucket locks	1	0.00		0	0
SGA heap locks	1	0.00		0	0
SGA pool locks	1	0.00		0	0
SQL memory manager latch	1	0.00		0	1,200	0.00
SQL memory manager workarea list latch	203,483	0.00	0.00	0	0
Shared B-Tree	414	0.00		0	0
Streams Generic	1	0.00		0	0
Testing	1	0.00		0	0
Token Manager	1	0.00		0	0
WCR: sync	1	0.00		0	0
Write State Object Pool Parent Latch	1	0.00		0	0
X$KSFQP	1	0.00		0	0
XDB NFS Security Latch	1	0.00		0	0
XDB unused session pool	1	0.00		0	0
XDB used session pool	1	0.00		0	0
active checkpoint queue latch	5,834	0.02	0.00	0	0
active service list	282,250	0.14	0.11	0	2,200	0.00
begin backup scn array	4	0.00		0	0
buffer pool	1	0.00		0	0
business card	1	0.00		0	0
cache buffer handles	481	0.00		0	0
cache buffers chains	53,787,777	0.64	0.00	0	19,247	0.02
cache buffers lru chain	15,439	0.00		0	48,905	0.10
call allocation	174,336	0.76	0.50	0	0
cas latch	1	0.00		0	0
change notification client cache latch	1	0.00		0	0
channel handle pool latch	86,892	0.29	0.00	0	0
channel operations parent latch	152,088	0.06	0.01	0	0
checkpoint queue latch	476,491	0.00		0	10,853	0.00
client/application info	305,048	0.01	0.00	0	0
compile environment latch	43,498	0.01	0.00	0	0
corrupted undo seg latch	131	0.00		0	0
cp cmon/server latch	1	0.00		0	0
cp pool latch	1	0.00		0	0
cp server hash latch	1	0.00		0	0
cp sga latch	69	0.00		0	0
cvmap freelist lock	1	0.00		0	0
deferred cleanup latch	69	0.00		0	0
dml lock allocation	69	0.00		0	0
done queue latch	1	0.00		0	0
dummy allocation	87,010	0.23	0.00	0	0
enqueue freelist latch	1	0.00		0	187,587	0.02
enqueue hash chains	767,298	0.08	0.00	0	0
enqueues	2	0.00		0	0
fifth spare latch	1	0.00		0	0
file cache latch	160	0.00		0	0
flashback copy	1	0.00		0	0
fourth Audit Vault latch	1	0.00		0	0
gc element	1	0.00		0	0
gcs commit scn state	1	0.00		0	0
gcs partitioned table hash	1	0.00		0	0
gcs pcm hashed value bucket hash	1	0.00		0	0
gcs resource freelist	1	0.00		0	0
gcs resource hash	1	0.00		0	0
gcs resource scan list	1	0.00		0	0
gcs shadows freelist	1	0.00		0	0
ges domain table	1	0.00		0	0
ges enqueue table freelist	1	0.00		0	0
ges group table	1	0.00		0	0
ges process hash list	1	0.00		0	0
ges process parent latch	1	0.00		0	0
ges resource hash list	1	0.00		0	0
ges resource scan list	1	0.00		0	0
ges resource table freelist	1	0.00		0	0
ges value block free list	1	0.00		0	0
global KZLD latch for mem in SGA	43,303	0.01	0.00	0	0
global ctx hash table latch	6	0.00		0	0
global tx hash mapping	1	0.00		0	0
granule operation	1	0.00		0	0
hash table column usage latch	297	0.00		0	51,254	0.00
hash table modification latch	94	0.00		0	0
heartbeat check	1	0.00		0	0
intra txn parallel recovery	1	0.00		0	0
io pool granule metadata list	1	0.00		0	0
job workq parent latch	68	0.00		0	67	0.00
job_queue_processes free list latch	140	0.00		0	0
job_queue_processes parameter latch	847	0.00		0	0
k2q lock allocation	1	0.00		0	0
kcbtsemkid latch	2	0.00		0	0
kdlx hb parent latch	1	0.00		0	0
kgb parent	1	0.00		0	0
kgnfs mount latch	1	0.00		0	0
kokc descriptor allocation latch	806	0.00		0	0
ksfv messages	1	0.00		0	0
ksim group membership cache	1	0.00		0	0
kss move lock	33	0.00		0	0
ksuosstats global area	367	0.00		0	0
ksv allocation latch	133	0.00		0	0
ksv class latch	65	0.00		0	0
ksv msg queue latch	1	0.00		0	0
ksz_so allocation latch	86,877	0.50	0.00	0	0
ktm global data	69	0.00		0	0
kwqbsn:qsga	191	0.00		0	0
lgwr LWN SCN	126,881	0.01	0.00	0	0
list of block allocation	87,212	0.01	0.00	0	0
loader state object freelist	32	0.00		0	0
lob segment dispenser latch	1	0.00		0	0
lob segment hash table latch	13	0.00		0	0
lob segment query latch	1	0.00		0	0
lock DBA buffer during media recovery	1	0.00		0	0
logical standby cache	1	0.00		0	0
logminer context allocation	2	0.00		0	0
logminer work area	1	0.00		0	0
longop free list parent	1	0.00		0	0
mapped buffers lru chain	1	0.00		0	0
message pool operations parent latch	116	0.00		0	0
messages	478,035	0.02	0.00	0	0
mostly latch-free SCN	127,701	0.40	0.00	0	0
msg queue latch	1	0.00		0	0
name-service namespace bucket	1	0.00		0	0
ncodef allocation latch	69	0.00		0	0
object queue header heap	46,638	0.00		0	10	0.00
object queue header operation	86,562	0.00	0.00	0	0
object stats modification	5	0.00		0	0
parallel query alloc buffer	465	0.00		0	0
parallel query stats	1	0.00		0	0
parameter list	390,756	0.11	0.00	0	0
parameter table management	793,746	0.18	0.41	0	0
peshm	1	0.00		0	0
pesom_free_list	1	0.00		0	0
pesom_hash_node	1	0.00		0	0
post/wait queue	100,885	0.00	0.00	0	67,448	0.03
process allocation	87,011	0.67	0.26	1	43,119	0.74
process group creation	86,877	0.05	0.00	0	0
process queue	1	0.00		0	0
process queue reference	1	0.00		0	0
qmn task queue latch	525	0.00		0	0
query server freelists	1	0.00		0	0
queued dump request	12	0.00		0	0
queuing load statistics	1	0.00		0	0
recovery domain hash list	1	0.00		0	0
redo allocation	463,012	0.03	0.00	0	268,047	0.06
redo copy	1	0.00		0	268,121	1.07
redo writing	379,092	0.00	0.00	0	0
resmgr group change latch	760,511	0.02	0.00	0	0
resmgr:active threads	88,349	0.06	1.00	0	1,783	0.22
resmgr:actses change group	43,420	0.00		0	0
resmgr:actses change state	112	0.00		0	0
resmgr:free threads list	87,031	0.38	0.02	0	0
resmgr:plan CPU method	1	0.00		0	0
resmgr:resource group CPU method	164,951	1.12	0.01	0	0
resmgr:schema config	719,844	0.11	0.20	0	61	0.00
resmgr:session queuing	1	0.00		0	0
rm cas latch	1	0.00		0	0
row cache objects	4,323,061	0.67	0.00	0	646	0.00
rules engine aggregate statistics	2	0.00		0	0
rules engine rule set statistics	104	0.00		0	0
second Audit Vault latch	1	0.00		0	0
second spare latch	1	0.00		0	0
sequence cache	240,870	0.02	0.00	0	0
session allocation	435,581	0.03	0.00	0	348,602	0.00
session idle bit	2,074,733	0.00	0.00	0	0
session queue latch	1	0.00		0	0
session state list latch	468	0.00		0	0
session switching	43,508	0.01	0.00	0	2	0.00
session timer	1,210	0.00		0	0
shared pool	3,952,946	0.22	0.03	0	0
shared pool sim alloc	1	0.00		0	0
shared pool simulator	133,582	0.02	0.00	0	0
sim partition latch	1	0.00		0	0
simulator hash latch	1,766,973	0.00	0.00	0	0
simulator lru latch	6,970	0.00		0	1,759,727	0.90
sort extent pool	123	0.00		0	0
space background state object latch	10	0.00		0	0
space background task latch	4,727	0.21	0.00	0	2,410	0.00
state object free list	2	0.00		0	0
statistics aggregation	560	0.00		0	0
tablespace key chain	1	0.00		0	0
temp lob duration state obj allocation	4	0.00		0	0
test excl. parent l0	1	0.00		0	0
test excl. parent2 l0	1	0.00		0	0
third spare latch	1	0.00		0	0
threshold alerts latch	133	0.00		0	0
transaction allocation	157,994	0.01	0.00	0	0
undo global data	492,583	0.02	0.00	0	0
virtual circuit buffers	1	0.00		0	0
virtual circuit holder	1	0.00		0	0
virtual circuit queues	1	0.00		0	0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	53,787,777	343,817	491	343,399
row cache objects	4,323,061	28,886	7	28,879
shared pool	3,952,946	8,875	310	8,574
resmgr:resource group CPU method	164,951	1,841	10	1,831
parameter table management	793,746	1,396	571	825
call allocation	174,336	1,330	661	690
resmgr:schema config	719,844	784	153	695
enqueue hash chains	767,298	618	2	616
process allocation	87,011	579	151	428
OS process allocation	94,593	416	1	415
active service list	282,250	386	44	342
resmgr:free threads list	87,031	335	8	327
OS process: request allocation	86,877	305	3	302
In memory undo latch	215,281	279	219	61
channel operations parent latch	152,088	94	1	93
resmgr:active threads	88,349	56	56	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	kticmt: child	111	89
In memory undo latch	ktiFlush: child	107	69
In memory undo latch	ktichg: child	17	2
In memory undo latch	ktiFlushMe	2	0
In memory undo latch	kturbk	1	77
OS process allocation	kso_delete_process:1	1	0
OS process: request allocation	ksoreqholder_delete	2	3
OS process: request allocation	kso_new_process	1	0
active service list	kswslogon: session logout	98	58
active service list	kswsite: service iterator	2	0
active service list	kswsgsnp: get service name ptr	1	25
cache buffers chains	kcbgtcr: fast path	352	6
cache buffers chains	kcbgtcr: fast path (cr pin)	284	34
cache buffers chains	kcbgcur_2	103	32
cache buffers chains	kcbchg1: mod cr pin	84	39
cache buffers chains	kcbgtcr: kslbegin excl	59	98
cache buffers chains	kcbget: fast exchange	26	15
cache buffers chains	kcbgcur: fast path (shr)	15	12
cache buffers chains	kcbrls: fast release	6	75
cache buffers chains	kcbget: pin buffer	5	1
cache buffers chains	kcbzwb	2	1
cache buffers chains	kcbgcur_4	1	147
cache buffers chains	kcbrls_2	1	168
call allocation	ksuxds	574	260
call allocation	ksudlp: top call	79	206
call allocation	ksucrp: top call	4	93
call allocation	ksuinfos_modact	4	102
channel handle pool latch	ksrchconnect()	1	1
channel operations parent latch	ksrsubscribe()	1	0
enqueue hash chains	ksqrcl	2	1
parameter table management	ksp_param_table_free	384	5
parameter table management	kspcpy	345	4
parameter table management	kspptval	1	721
process allocation	ksucrp:1	122	0
process allocation	ksudlp	29	5
resmgr:active threads	kskdynthreshact	31	0
resmgr:active threads	kgsksimsetup1	21	0
resmgr:active threads	kgskclassinfo2	2	0
resmgr:active threads	kgskmetricupd	2	0
resmgr:free threads list	kskthrsod	6	6
resmgr:free threads list	kskthrcreate	2	2
resmgr:resource group CPU method	kgkprraddtorl	6	9
resmgr:resource group CPU method	kgkprrpicknext	4	2
resmgr:schema config	kgskclassinfo1	64	0
resmgr:schema config	kgskgasi1	45	0
resmgr:schema config	kgskgmaxdop1	23	153
resmgr:schema config	kgskscscb	13	0
resmgr:schema config	kgskmetricupd	7	0
resmgr:schema config	kgskgtwt	1	0
row cache objects	kqreqd: reget	5	1
row cache objects	kqrpre: find obj	2	3
shared pool	kghalo	175	166
shared pool	kghalp	114	15
shared pool	kghfre	14	70
shared pool	kghupr1	4	56
shared pool	kghasp	2	0
shared pool	kgh_heap_sizes	1	3

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Library Cache	kglhdgn2 106	6,544
Library Cache	kglhdgn1 62	3,356
Library Cache	kgllkdl1 85	1,188
Library Cache	kgllkc1 57	987
Library Cache	kglpndl1 95	518
Library Cache	kglpin1 4	399
Library Cache	kglget1 1	302
Library Cache	kglpnal1 90	234
Library Cache	kglobpn1 71	168
Cursor Pin	kkslce [KKSCHLPIN2]	48
Library Cache	kgldtin1 42	32
Library Cache	kglhdgh1 64	30
Cursor Parent	kkscsAddChildNode [KKSPRTLOC34]	28
Library Cache	kglget2 2	6
Library Cache	kglrfcl1 79	3
Cursor Pin	kksfbc [KKSCHLFSP2]	3
Cursor Pin	kksfbc [KKSCHLPIN1]	2
Cursor Parent	kkscsPruneChild [KKSPRTLOC35]	1

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: 26,303,002
Captured Segments account for 100.2% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
TRACKING	MDM	CPIC_LOG	TABLE	14,251,360	54.18
ACCOUNTS	MDM	USER_NJ	TABLE	6,661,408	25.33
DEVICES	MDM	DEVICE	TABLE	2,635,648	10.02
SYS	SYSTEM	AUD$	TABLE	734,304	2.79
SYS	SYSTEM	I_SYSAUTH1	INDEX	708,096	2.69

Back to Segment Statistics
Back to Top

Segments by Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

No data exists for this section of the report.

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: 11,245
Captured Segments account for 44.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
SYS	SYSTEM	AUD$	TABLE	2,044	18.18
TRACKING	MDM	CPIC_LOG	TABLE	734	6.53
TRACKING	MDM	CALLTRACKING	TABLE	463	4.12
ACCOUNTS	MDM	USER_NJ	TABLE	333	2.96
TRACKING	MDM	IDX_TR_LOG_DE	INDEX	300	2.67

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 3,430
Captured Segments account for 54.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
TRACKING	MDM	CPIC_LOG	TABLE	408	11.90
ACCOUNTS	MDM	USER_NJ	TABLE	275	8.02
TRACKING	MDM	CALLTRACKING	TABLE	264	7.70
DEVICES	MDM	DEVICE	TABLE	192	5.60
SYS	SYSTEM	AUD$	TABLE	180	5.25

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 37
Captured Segments account for 64.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_1564977302_1566	TABLE PARTITION	23	62.16
SYS	SYSAUX	SYS_LOB0000006339C00038$$		LOB	1	2.70

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 28,244
Captured Segments account for 99.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Table Scans	%Total
TRACKING	MDM	SYS_C0013330	INDEX	28,155	99.68
SYS	SYSTEM	I_SYSAUTH1	INDEX	48	0.17
SYS	SYSTEM	I_OBJ2	INDEX	12	0.04

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	Obj. Type	DB Block Changes	% of Capture
SYS	SYSTEM	AUD$	TABLE	698,864	86.41
TRACKING	MDM	SYS_C0013330	INDEX	53,584	6.63
TRACKING	MDM	CPIC_LOG	TABLE	42,464	5.25
ACCOUNTS	MDM	USER_NJ	TABLE	7,376	0.91
TRACKING	MDM	LOG	TABLE	1,520	0.19

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Row Lock Waits	% of Capture
TRACKING	MDM	SYS_C0013421	INDEX	5	33.33
TRACKING	MDM	CPIC_LOG	TABLE	4	26.67
TRACKING	MDM	IDX_TR_LOG_DE	INDEX	2	13.33
TRACKING	MDM	SYS_C0013423	INDEX	2	13.33
TRACKING	MDM	IDX_TR_LOG_AC	INDEX	1	6.67

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	AUD$	TABLE	2,758	75.85
TRACKING	MDM	CPIC_LOG	TABLE	514	14.14
TRACKING	MDM	SYS_C0013330	INDEX	243	6.68
TRACKING	MDM	SYS_C0013421	INDEX	50	1.38
DEVICES	MDM	DEVICE	TABLE	36	0.99

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	65	0.00	2	1
dc_files	6	0.00	0	6
dc_global_oids	4,115	0.00	0	256
dc_histogram_data	2,621	0.08	0	3,158
dc_histogram_defs	11,071	0.84	0	6,262
dc_object_grants	153	0.00	0	158
dc_objects	123,626	0.00	9	6,061
dc_profiles	43,424	0.00	0	2
dc_rollback_segments	1,076	0.00	0	26
dc_segments	71,401	0.00	11	2,210
dc_sequences	1,790	0.00	1,790	31
dc_tablespace_quotas	4	0.00	0	7
dc_tablespaces	66,067	0.00	0	8
dc_users	1,416,387	0.00	0	184
global database name	45,783	0.00	0	1
outstanding_alerts	27	3.70	2	5
sch_lj_oids	5	0.00	0	32

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	86,606	0.00	0		0	0
APP CONTEXT	4	0.00	140	0.00	0	0
BODY	1,103	0.00	8,615	0.00	0	0
CLUSTER	21	0.00	21	0.00	0	0
DBLINK	86,608	0.00	0		0	0
EDITION	43,381	0.00	86,751	0.00	0	0
INDEX	1	0.00	1	100.00	1	0
QUEUE	75	0.00	9,976	0.00	0	0
RULESET	0		2	0.00	0	0
SCHEMA	43,397	0.00	0		0	0
SQL AREA	561,898	3.14	1,100,607	4.98	889	872
SQL AREA BUILD	18,583	95.17	0		0	0
SQL AREA STATS	18,580	95.26	18,580	95.26	0	0
SUBSCRIPTION	6	0.00	6	0.00	0	0
TABLE/PROCEDURE	100,408	0.01	264,799	0.05	110	0
TRIGGER	76	0.00	292	1.03	3	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	13,440.00	13,440.00	13,440.00	13,696.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	4,096.00	4,096.00	4,096.00	4,096.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	16,384.00	16,384.00	16,384.00	16,384.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	32.00	32.00	32.00	32.00	STA/
large pool	32.00	32.00	32.00	32.00	STA/
shared pool	2,752.00	2,752.00	2,496.00	2,752.00	GRO/IMM
streams pool	32.00	32.00	32.00	32.00	STA/

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	111.56		2.37	2.44	12	25	47	47
B	Freeable	39.13	0.00	1.26	1.67	9		31	31
B	PL/SQL	21.88	6.91	0.49	0.74	3	4	45	45
B	SQL	1.81	0.10	0.06	0.06	0	20	32	25
E	Other	112.25		2.44	2.46	12	25	46	46
E	Freeable	38.00	0.00	1.31	1.71	9		29	29
E	PL/SQL	21.80	6.78	0.50	0.75	3	4	44	44
E	SQL	2.14	0.66	0.07	0.11	1	20	31	27

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	14,092,861,440
Fixed Size	2,238,616
Redo Buffers	21,716,992
Variable Size	2,986,346,344

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	32.00	32.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	24.19	24.19	0.00
shared	ASH buffers	32.00	32.00	0.00
shared	KGLDA	29.84	29.24	-2.02
shared	KGLH0	600.27	588.67	-1.93
shared	KGLHD	128.51	127.47	-0.81
shared	SQLA	715.69	714.29	-0.20
shared	db_block_hash_buckets	89.00	89.00	0.00
shared	event statistics per sess	28.36	28.36	0.00
shared	free memory	695.62	726.40	4.42
shared	kglsim heap	28.67	28.67	0.00
shared	kglsim object batch	50.71	50.71	0.00
shared	private strands	32.34	32.34	0.00
streams	KTG hash buckets	1.26	1.26	0.00
streams	free memory	30.73	30.73	-0.00
	buffer_cache	13,440.00	13,440.00	0.00
	fixed_sga	2.13	2.13	0.00
	log_buffer	20.71	20.71	0.00

Back to Memory Statistics
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, descending

Session Type	First Logon	CPU time(s)	User IO Wait time(s)	SYS IO Wait time(s)
QMON Slaves	0618 15:59:35	0.08	0.00	0.00
QMON Coordinator	0618 15:59:25	0.03	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

Rule Sets ordered by Evaluations
* indicates Rule Set activity (re)started between Begin/End snaps
SQL per Eval - average # of SQL statements executed for non-SQL free evals
CPU(s),Ela(s) per Eval - avg CPU and Elapsed time per evaluation includes both SQL free and non-SQL free evals

Rule	Evals	No-SQL Eval%	SQL Execs	CPU(s)	Ela(s)	Eval /Sec	SQL per Eval	Ela(s) per Eval	CPU(s) per Eval	Reloads
SYS.ALERT_QUE_R	2	0.00	0	0.00	0.00	0.00	0.00	0.00	0.00	0

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.ALERT_QUE(12733)	2	2	100.00	0.00	0.00	2.64	0.00	24.48
SYSMAN.MGMT_NOTIFY_Q(69041)	0	0			0.00	0.00
SYSMAN.MGMT_TASK_Q(68711)	51	51	0.00	0.00	0.01	0.05	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.ALERT_QUE(12733)	0.00	0.00	0.00	1.32
SYSMAN.MGMT_NOTIFY_Q(69041)	0.00	0.00
SYSMAN.MGMT_TASK_Q(68711)	0.01	0.01	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
HAE_SUB(1)/SYS.ALERT_QUE	0	0	0
HQ13YDYYGLDB1_3938_MDM(41)/SYS.ALERT_QUE	2	2	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
ordered by resource name

Resource Name	Current Utilization	Maximum Utilization	Initial Allocation	Limit
processes	47	1,464	1500	1500

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 %
3,605	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	3,605	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)
audit_file_dest	/u01/oracle/admin/mdm/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/mdm/mdm/control01.ctl, /mdm/mdm/control02.ctl
db_block_size	8192
db_domain
db_name	mdm
diagnostic_dest	/u01/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=mdmXDB)
open_cursors	300
pga_aggregate_target	4294967296
processes	1500
remote_login_passwordfile	EXCLUSIVE
sessions	2272
sga_target	17179869184
undo_tablespace	UNDOTBS1

Back to init.ora Parameters
Back to Top

init.ora Multi-Valued Parameters

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

Parameter Name	Begin value	End value (if different)
control_files	/mdm/mdm/control01.ctl
control_files	/mdm/mdm/control02.ctl

Back to init.ora Parameters
Back to Top

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	99.99	Redo NoWait %:	100.00
Buffer Hit %:	100.00	In-memory Sort %:	100.00
Library Hit %:	95.12	Soft Parse %:	96.70
Execute to Parse %:	2.51	Latch Hit %:	99.49
Parse CPU to Parse Elapsd %:	55.44	% Non-Parse CPU:	98.93