WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

TOPPROD 2076476065 topprod 1 10-7月 -17 17:07 11.2.0.4.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
TOPPROD	2076476065	topprod	1	10-7月 -17 17:07	11.2.0.4.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

ERPDB Linux x86 64-bit 16 16 2 23.47

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
ERPDB	Linux x86 64-bit	16	16	2	23.47

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 31808 17-1月 -18 02:00:47 52 4.8

End Snap: 31809 17-1月 -18 03:00:51 51 4.9

Elapsed: 60.06 (mins)

DB Time: 55.92 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	31808	17-1月 -18 02:00:47	52	4.8
End Snap:	31809	17-1月 -18 03:00:51	51	4.9
Elapsed:		60.06 (mins)
DB Time:		55.92 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.9 12.8 0.00 0.05

DB CPU(s): 0.5 7.1 0.00 0.03

Redo size (bytes): 330,552.0 4,528,900.7

Logical read (blocks): 5,576.0 76,397.1

Block changes: 1,522.9 20,865.8

Physical read (blocks): 1,955.8 26,796.7

Physical write (blocks): 138.1 1,891.7

Read IO requests: 1,092.5 14,968.6

Write IO requests: 43.8 599.9

Read IO (MB): 15.3 209.4

Write IO (MB): 1.1 14.8

User calls: 19.6 267.8

Parses (SQL): 118.8 1,627.4

Hard parses (SQL): 9.7 132.2

SQL Work Area (MB): 1.4 19.7

Logons: 0.0 0.3

Executes (SQL): 353.3 4,840.2

Rollbacks: 0.0 0.0

Transactions: 0.1

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.9	12.8	0.00	0.05
DB CPU(s):	0.5	7.1	0.00	0.03
Redo size (bytes):	330,552.0	4,528,900.7
Logical read (blocks):	5,576.0	76,397.1
Block changes:	1,522.9	20,865.8
Physical read (blocks):	1,955.8	26,796.7
Physical write (blocks):	138.1	1,891.7
Read IO requests:	1,092.5	14,968.6
Write IO requests:	43.8	599.9
Read IO (MB):	15.3	209.4
Write IO (MB):	1.1	14.8
User calls:	19.6	267.8
Parses (SQL):	118.8	1,627.4
Hard parses (SQL):	9.7	132.2
SQL Work Area (MB):	1.4	19.7
Logons:	0.0	0.3
Executes (SQL):	353.3	4,840.2
Rollbacks:	0.0	0.0
Transactions:	0.1

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 91.47 Soft Parse %: 91.88

Execute to Parse %: 66.38 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 69.18 % Non-Parse CPU: 98.41

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		1858		55.4
db file sequential read	3,852,093	1215.9	0	36.2	User I/O
log file sync	32,756	143.2	4	4.3	Commit
db file scattered read	38,465	139.5	4	4.2	User I/O
direct path write temp	12,827	21.8	2	.6	User I/O
enq: CR - block range reuse ckpt	204	21.1	104	.6	Other
enq: RO - fast object reuse	1	14.5	14529	.4	Application
log file switch (private strand flush incomplete)	2	3.6	1805	.1	Configuration
direct path read	607	1.4	2	.0	User I/O
direct path read temp	41,839	.8	0	.0	User I/O

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		1,858		55.4	0.5
User I/O	3,951,263	1,382	0	41.2	0.4
System I/O	82,081	352	4	10.5	0.1
Commit	32,758	143	4	4.3	0.0
Other	883	21	24	.6	0.0
Application	51	15	286	.4	0.0
Configuration	14	4	314	.1	0.0
Concurrency	73	1	9	.0	0.0
Network	36,862	0	0	.0	0.0

Host CPU

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

16 16 2 1.01 0.15 3.5 0.5 2.6 96.0

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
16	16	2	1.01	0.15	3.5	0.5	2.6	96.0

Instance CPU

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

3.3 83.2 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 1,178.6 1,095.4 83.2

Database Requests: 1,136.3 1,092.5 43.8

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 38.4 0.4 38.0

Total (MB): 17.8 15.7 2.1

Database (MB): 16.4 15.3 1.1

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 1.0 0.4 0.7

Database (blocks): 2,093.9 1,955.8 138.1

Via Buffer Cache (blocks): 1,903.3 1,850.5 52.8

Direct (blocks): 190.6 105.3 85.3

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	1,178.6	1,095.4	83.2
Database Requests:	1,136.3	1,092.5	43.8
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	38.4	0.4	38.0
Total (MB):	17.8	15.7	2.1
Database (MB):	16.4	15.3	1.1
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	1.0	0.4	0.7
Database (blocks):	2,093.9	1,955.8	138.1
Via Buffer Cache (blocks):	1,903.3	1,850.5	52.8
Direct (blocks):	190.6	105.3	85.3

Memory Statistics

Begin End

Host Mem (MB): 24,030.1 24,030.1

SGA use (MB): 4,000.0 4,000.0

PGA use (MB): 321.0 318.2

% Host Mem used for SGA+PGA: 17.98 17.97

	Begin	End
Host Mem (MB):	24,030.1	24,030.1
SGA use (MB):	4,000.0	4,000.0
PGA use (MB):	321.0	318.2
% Host Mem used for SGA+PGA:	17.98	17.97

Cache Sizes

Begin End

Buffer Cache: 1,520M 2,000M Std Block Size: 8K

Shared Pool Size: 2,159M 1,726M Log Buffer: 18,840K

	Begin	End
Buffer Cache:	1,520M	2,000M	Std Block Size:	8K
Shared Pool Size:	2,159M	1,726M	Log Buffer:	18,840K

Shared Pool Statistics

Begin End

Memory Usage %: 59.71 49.10

% SQL with executions>1: 80.72 98.93

% Memory for SQL w/exec>1: 97.82 94.94

	Begin	End
Memory Usage %:	59.71	49.10
% SQL with executions>1:	80.72	98.93
% Memory for SQL w/exec>1:	97.82	94.94

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): 3355.2s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	3,186.56	94.97
DB CPU	1,858.02	55.38
parse time elapsed	43.40	1.29
hard parse elapsed time	35.60	1.06
repeated bind elapsed time	1.23	0.04
PL/SQL compilation elapsed time	0.62	0.02
connection management call elapsed time	0.56	0.02
hard parse (sharing criteria) elapsed time	0.46	0.01
PL/SQL execution elapsed time	0.14	0.00
failed parse elapsed time	0.01	0.00
DB time	3,355.19
background elapsed time	408.54
background cpu time	54.70

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
BUSY_TIME	229,767
IDLE_TIME	5,494,435
IOWAIT_TIME	148,706
NICE_TIME	0
SYS_TIME	27,078
USER_TIME	201,837
LOAD	1	0
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	84,881,408
VM_OUT_BYTES	5,947,392
PHYSICAL_MEMORY_BYTES	25,197,383,680
NUM_CPUS	16
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
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
17-1月 02:00:47	1.01
17-1月 03:00:51	0.15	4.01	3.53	0.47	95.99	2.60

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 102.0% of Total DB time 3,355.19 (s)
Total FG Wait Time: 1,563.05 (s) DB CPU time: 1,858.02 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			1,858		55.38
User I/O	3,946,229	0	1,380	0	41.12
Commit	32,756	0	143	4	4.27
Other	481	2	21	44	0.63
Application	43	0	15	339	0.43
Configuration	14	14	4	314	0.13
Network	36,716	0	0	0	0.00
Concurrency	46	0	0	1	0.00
System I/O	3,415	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
db file sequential read	3,852,093	0	1,216	0	14,646.74	36.24
log file sync	32,756	0	143	4	124.55	4.27
db file scattered read	38,465	0	139	4	146.25	4.16
direct path write temp	12,827	0	22	2	48.77	0.65
enq: CR - block range reuse ckpt	204	0	21	104	0.78	0.63
enq: RO - fast object reuse	1	0	15	14529	0.00	0.43
log file switch (private strand flush incomplete)	2	0	4	1805	0.01	0.11
direct path read	607	0	1	2	2.31	0.04
direct path read temp	41,839	0	1	0	159.08	0.02
log buffer space	8	0	1	73	0.03	0.02
log file switch completion	2	0	0	95	0.01	0.01
ADR block file read	36	0	0	2	0.14	0.00
reliable message	209	0	0	0	0.79	0.00
SQL*Net message to client	36,687	0	0	0	139.49	0.00
enq: KO - fast object checkpoint	4	0	0	15	0.02	0.00
db file parallel read	13	0	0	4	0.05	0.00
latch: shared pool	38	0	0	1	0.14	0.00
control file sequential read	3,415	0	0	0	12.98	0.00
Disk file operations I/O	385	0	0	0	1.46	0.00
undo segment extension	2	100	0	5	0.01	0.00
SQL*Net break/reset to client	38	0	0	0	0.14	0.00
ADR block file write	5	0	0	1	0.02	0.00
SQL*Net message from client	36,687	0	24,913	679	139.49
jobq slave wait	122	98	60	496	0.46

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	67,734	0	212	3	257.54	51.81
db file async I/O submit	1,419	0	134	94	5.40	32.70
control file parallel write	1,675	0	4	2	6.37	0.98
db file sequential read	2,858	0	2	1	10.87	0.55
log file sequential read	1,361	0	2	1	5.17	0.42
Log archive I/O	1,331	0	1	1	5.06	0.24
os thread startup	21	0	1	29	0.08	0.15
db file scattered read	1,210	0	0	0	4.60	0.08
db file parallel write	87	0	0	3	0.33	0.06
db file single write	225	0	0	1	0.86	0.04
control file sequential read	5,044	0	0	0	19.18	0.03
change tracking file synchronous write	61	0	0	1	0.23	0.01
Parameter File I/O	128	0	0	0	0.49	0.01
rdbms ipc reply	2	0	0	23	0.01	0.01
log file single write	12	0	0	3	0.05	0.01
ADR block file read	16	0	0	2	0.06	0.01
Disk file operations I/O	618	0	0	0	2.35	0.00
latch: shared pool	3	0	0	5	0.01	0.00
reliable message	20	0	0	0	0.08	0.00
log file sync	2	0	0	3	0.01	0.00
latch: row cache objects	3	0	0	1	0.01	0.00
direct path sync	1	0	0	2	0.00	0.00
LGWR wait for redo copy	157	0	0	0	0.60	0.00
ADR block file write	5	0	0	0	0.02	0.00
SQL*Net break/reset to client	8	0	0	0	0.03	0.00
change tracking file synchronous read	61	0	0	0	0.23	0.00
rdbms ipc message	89,241	22	64,459	722	339.32
EMON slave idle wait	3,601	100	18,008	5001	13.69
DIAG idle wait	7,194	100	7,201	1001	27.35
Space Manager: slave idle wait	846	99	4,206	4972	3.22
Streams AQ: qmn coordinator idle wait	258	50	3,613	14004	0.98
Streams AQ: qmn slave idle wait	129	0	3,613	28009	0.49
Streams AQ: emn coordinator idle wait	361	100	3,611	10003	1.37
pmon timer	1,201	100	3,605	3002	4.57
smon timer	15	73	3,577	238464	0.06
SGA: MMAN sleep for component shrink	191	99	2	11	0.73
SQL*Net message from client	191	0	0	1	0.73
class slave wait	19	0	0	0	0.07

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	52	71.2	1.9	17.3	5.8	1.9	1.9
ADR block file write	10	100.0
ADR file lock	12	100.0
ARCH wait for archivelog lock	3	100.0
Disk file operations I/O	1003	99.6		.4
LGWR wait for redo copy	157	100.0
Log archive I/O	1331	96.5	3.5
Parameter File I/O	128	96.1	2.3	.8	.8
SQL*Net break/reset to client	46	100.0
SQL*Net message to client	36.8K	100.0
SQL*Net more data to client	29	100.0
asynch descriptor resize	75	100.0
change tracking file synchronous read	61	100.0
change tracking file synchronous write	61	93.4	3.3		3.3
control file parallel write	1674	11.5	74.2	9.1	1.3	2.0	1.1	.7
control file sequential read	8455	99.9		.0	.1	.0	.0
db file async I/O submit	1419	23.9	17.5	15.5	9.4	12.8	10.4	7.9	2.7
db file parallel read	14	50.0	7.1	14.3		21.4	7.1
db file parallel write	87	36.8	29.9	20.7	4.6	4.6	3.4
db file scattered read	39.7K	44.0	1.7	35.1	7.4	7.7	3.7	.4
db file sequential read	3854.5K	94.6	.7	2.2	2.3	.2	.0	.0
db file single write	225	87.6	8.9	3.6
direct path read	607	75.6	1.6	5.6	5.8	8.4	2.8	.2
direct path read temp	41.8K	100.0
direct path sync	1			100.0
direct path write	2	100.0
direct path write temp	12.8K	23.8	69.1	4.0	1.0	1.5	.6	.1
enq: CR - block range reuse ckpt	204		.5	46.1	32.8	10.3	5.9	2.9	1.5
enq: KO - fast object checkpoint	4	25.0	25.0		25.0			25.0
enq: RO - fast object reuse	1								100.0
latch free	11	100.0
latch: cache buffers lru chain	3	100.0
latch: redo allocation	3	100.0
latch: row cache objects	10	90.0		10.0
latch: shared pool	41	78.0	2.4	9.8	7.3	2.4
library cache: mutex X	1	100.0
log buffer space	8				12.5	25.0		62.5
log file parallel write	67.7K	29.5	35.7	13.3	15.7	4.0	1.3	.4
log file sequential read	1361	71.1	1.5	23.7	3.1	.4	.2
log file single write	12	66.7			16.7	16.7
log file switch (private strand flush incomplete)	2						50.0		50.0
log file switch completion	2							100.0
log file sync	32.8K	10.9	47.2	9.6	16.1	13.7	1.9	.6
os thread startup	21					38.1	42.9	19.0
rdbms ipc reply	2					50.0		50.0
reliable message	229	99.6					.4
undo segment extension	2	50.0				50.0
DIAG idle wait	7195							100.0
EMON slave idle wait	3604								100.0
SGA: MMAN sleep for component shrink	191	.5				99.5
SQL*Net message from client	36.9K	97.6	1.2	.1	.0	.0	.0	.0	1.1
Space Manager: slave idle wait	846						.1	.5	99.4
Streams AQ: emn coordinator idle wait	361								100.0
Streams AQ: qmn coordinator idle wait	258	50.0							50.0
Streams AQ: qmn slave idle wait	129								100.0
class slave wait	19	100.0
jobq slave wait	122							100.0
pmon timer	1201								100.0
rdbms ipc message	89.2K	22.3	23.1	19.6	5.3	3.6	1.8	10.1	14.2
smon timer	15								100.0

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
control file parallel write	12	99.3	.5	.1	.1
db file async I/O submit	119	89.4	5.1	1.5	.9	.3	.1	.5	2.2
db file scattered read	145	99.6	.3	.0	.0
db file sequential read	173	100.0	.0	.0	.0	.0
direct path read	1	99.8	.2
direct path write temp	11	99.9	.1	.0
enq: CR - block range reuse ckpt	7	95.6	2.5	.5				.5	1.0
enq: KO - fast object checkpoint	1	75.0	25.0
log buffer space	5	37.5	25.0	25.0		12.5
log file parallel write	272	99.6	.3	.1	.0	.0
log file switch completion	2		50.0		50.0
log file sync	198	99.4	.4	.1	.0	.0
os thread startup	4	81.0	14.3		4.8
rdbms ipc reply	1	50.0	50.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
		% of Total Waits
db file async I/O submit	31	97.8	1.9	.3
enq: CR - block range reuse ckpt	2	99.0		.5	.5
enq: RO - fast object reuse	1				100.0
log file switch (private strand flush incomplete)	1	50.0	50.0

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)	Physical Reads (K)	Logical Reads (K)
topprod	3,344	1,850	6,835	19,658
SYS$USERS	11	8	67	145
SYS$BACKGROUND	0	0	146	287

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	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
topprod	3943656	1376	35	0	35633
SYS$USERS	2577	3	11	0	1086
SYS$BACKGROUND	5035	3	27	1	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 3.4% of Total DB Time (s): 3,355
Captured PL/SQL account for 0.1% of Total DB Time (s): 3,355

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
23.21	326,071	0.00	0.69	97.36	2.25	330q95smuwnv9		update hist_head$ set bucket_c...
13.08	1	13.08	0.39	93.86	3.51	1hxa21sh2kwdw	fglrun-bin@PAYERP-AP (TNS V1-V3)	delete from tc_btx_file WHERE ...
11.28	34,490	0.00	0.34	34.36	61.46	6q42j0018w7t8		insert into sys.wri$_optstat_i...
11.20	326,748	0.00	0.33	56.64	36.79	96g93hntrzjtr		select /+ rule / bucket_cnt,...
5.67	6	0.94	0.17	70.73	31.78	1q39a3p6hzp7t	SQL*Plus	select 'analyze table ', TABLE...
4.18	16,906	0.00	0.12	57.05	23.40	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
4.05	204	0.02	0.12	98.86	0.00	0hhmdwwgxbw0r		select obj#, type#, flags, rel...
3.27	34,537	0.00	0.10	90.69	0.61	3d40u5r2jfcsd		update ind$ set ts#=:2, file#=...
2.59	1	2.59	0.08	96.13	14.96	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2.45	16,611	0.00	0.07	29.66	77.54	6aq34nj2zb2n7		select col#, grantee#, privile...

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 4.6% of Total CPU Time (s): 1,858
Captured PL/SQL account for 0.2% of Total CPU Time (s): 1,858

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
22.60	326,071	0.00	1.22	23.21	97.36	2.25	330q95smuwnv9		update hist_head$ set bucket_c...
12.28	1	12.28	0.66	13.08	93.86	3.51	1hxa21sh2kwdw	fglrun-bin@PAYERP-AP (TNS V1-V3)	delete from tc_btx_file WHERE ...
6.34	326,748	0.00	0.34	11.20	56.64	36.79	96g93hntrzjtr		select /+ rule / bucket_cnt,...
4.01	6	0.67	0.22	5.67	70.73	31.78	1q39a3p6hzp7t	SQL*Plus	select 'analyze table ', TABLE...
4.01	204	0.02	0.22	4.05	98.86	0.00	0hhmdwwgxbw0r		select obj#, type#, flags, rel...
3.87	34,490	0.00	0.21	11.28	34.36	61.46	6q42j0018w7t8		insert into sys.wri$_optstat_i...
2.97	34,537	0.00	0.16	3.27	90.69	0.61	3d40u5r2jfcsd		update ind$ set ts#=:2, file#=...
2.49	1	2.49	0.13	2.59	96.13	14.96	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
2.39	16,906	0.00	0.13	4.18	57.05	23.40	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
2.16	17,047	0.00	0.12	2.39	90.16	1.82	83taa7kaw59c1		select name, intcol#, segcol#,...

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 1.7% of Total User I/O Wait Time (s): 1,382
Captured PL/SQL account for 0.1% of Total User I/O Wait Time (s): 1,382

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
6.93	34,490	0.00	0.50	11.28	34.36	61.46	6q42j0018w7t8		insert into sys.wri$_optstat_i...
4.12	326,748	0.00	0.30	11.20	56.64	36.79	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1.90	16,611	0.00	0.14	2.45	29.66	77.54	6aq34nj2zb2n7		select col#, grantee#, privile...
1.80	6	0.30	0.13	5.67	70.73	31.78	1q39a3p6hzp7t	SQL*Plus	select 'analyze table ', TABLE...
1.53	16,615	0.00	0.11	2.39	36.82	63.81	2q93zsrvbdw48		select grantee#, privilege#, n...
0.98	16,906	0.00	0.07	4.18	57.05	23.40	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
0.73	8	0.09	0.05	0.90	19.88	81.58	bqfx5q2jas08u	emagent_SQL_oracle_database	SELECT TASK_LIST.TASK_ID FROM ...
0.61	14,854	0.00	0.04	1.08	27.27	56.84	7tt3tfgb57599		delete /+ index(mm) / from s...
0.58	4	0.15	0.04	0.85	32.18	68.82	aujtsaq37rkrh	emagent_SQL_oracle_database	DECLARE instance_number NUMBE...
0.53	1	0.53	0.04	1.84	74.34	29.00	833wvjbwufzfa	SQL*Plus	delete from sys.aud$ where NTI...

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: 20,092,446
Captured SQL account for 34.5% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,333,560	326,071	4.09	6.64	23.21	97.4	2.2	330q95smuwnv9		update hist_head$ set bucket_c...
1,304,649	326,748	3.99	6.49	11.20	56.6	36.8	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,167,528	1	1,167,528.00	5.81	13.08	93.9	3.5	1hxa21sh2kwdw	fglrun-bin@PAYERP-AP (TNS V1-V3)	delete from tc_btx_file WHERE ...
387,392	34,490	11.23	1.93	11.28	34.4	61.5	6q42j0018w7t8		insert into sys.wri$_optstat_i...
238,981	6	39,830.17	1.19	5.67	70.7	31.8	1q39a3p6hzp7t	SQL*Plus	select 'analyze table ', TABLE...
232,447	1	232,447.00	1.16	2.59	96.1	15	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
227,632	1	227,632.00	1.13	1.84	74.3	29	833wvjbwufzfa	SQL*Plus	delete from sys.aud$ where NTI...
164,642	1	164,642.00	0.82	1.50	99	12.4	7g4rxwbvhdh3q		SELECT startsn.stat_id, smap....
160,535	17,820	9.01	0.80	0.86	61.6	8.6	38243c4tqrkxm		select u.name, o.name, o.names...
160,344	17,816	9.00	0.80	0.70	88.6	0	3qt0dku301xw0		select u.name, o.name, o.obj#,...

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: 7,047,541
Captured SQL account for 2.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
143,357	1	143,357.00	2.03	2.59	96.13	14.96	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
82,302	1	82,302.00	1.17	1.50	99.03	12.41	7g4rxwbvhdh3q		SELECT startsn.stat_id, smap....
52,345	6	8,724.17	0.74	5.67	70.73	31.78	1q39a3p6hzp7t	SQL*Plus	select 'analyze table ', TABLE...
21,868	1	21,868.00	0.31	13.08	93.86	3.51	1hxa21sh2kwdw	fglrun-bin@PAYERP-AP (TNS V1-V3)	delete from tc_btx_file WHERE ...
21,832	1	21,832.00	0.31	1.84	74.34	29.00	833wvjbwufzfa	SQL*Plus	delete from sys.aud$ where NTI...
7,259	34,490	0.21	0.10	11.28	34.36	61.46	6q42j0018w7t8		insert into sys.wri$_optstat_i...
4,094	326,748	0.01	0.06	11.20	56.64	36.79	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,193	16,611	0.07	0.02	2.45	29.66	77.54	6aq34nj2zb2n7		select col#, grantee#, privile...
896	17,820	0.05	0.01	0.86	61.58	8.63	38243c4tqrkxm		select u.name, o.name, o.names...
813	14,267	0.06	0.01	0.84	49.29	12.13	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...

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: 3,936,745
Captured SQL account for 1.1% of Total
Total UnOptimized Read Requests: 3,936,745
Captured SQL account for 1.1% 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	%Total	SQL Id	SQL Module	SQL Text
21,868	21,868	1	21,868.00	0.56	1hxa21sh2kwdw	fglrun-bin@PAYERP-AP (TNS V1-V3)	delete from tc_btx_file WHERE ...
11,123	11,123	6	1,853.83	0.28	1q39a3p6hzp7t	SQL*Plus	select 'analyze table ', TABLE...
4,094	4,094	326,748	0.01	0.10	96g93hntrzjtr		select /+ rule / bucket_cnt,...
1,445	1,445	1	1,445.00	0.04	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
1,193	1,193	16,611	0.07	0.03	6aq34nj2zb2n7		select col#, grantee#, privile...
827	827	1	827.00	0.02	833wvjbwufzfa	SQL*Plus	delete from sys.aud$ where NTI...
813	813	14,267	0.06	0.02	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...
695	695	16,615	0.04	0.02	2q93zsrvbdw48		select grantee#, privilege#, n...
667	667	1	667.00	0.02	7g4rxwbvhdh3q		SELECT startsn.stat_id, smap....
485	485	4	121.25	0.01	0bjbaw9270kjv	emagent_SQL_oracle_database	DECLARE l_last_full_time VARC...

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: 1,272,963
Captured SQL account for 94.3% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
326,748	321,101	0.98	11.20	56.6	36.8	96g93hntrzjtr		select /+ rule / bucket_cnt,...
326,071	326,071	1.00	23.21	97.4	2.2	330q95smuwnv9		update hist_head$ set bucket_c...
34,537	0	0.00	0.92	88.2	0	3axxxnjp5jjwj		delete from ind_stats$ where o...
34,537	34,537	1.00	3.27	90.7	.6	3d40u5r2jfcsd		update ind$ set ts#=:2, file#=...
34,490	34,490	1.00	11.28	34.4	61.5	6q42j0018w7t8		insert into sys.wri$_optstat_i...
32,915	42	0.00	1.03	93.9	0	9gkq7rruycsjp		select parttype, partcnt, part...
32,176	32,176	1.00	1.60	115.4	0	9dzjush42kmfs	fglrun-bin@PAYERP-AP (TNS V1-V3)	select spare4 from sys.optstat...
32,176	0	0.00	1.42	102.8	0	fcwg2b0rszakk		select p.valchar from sys.opts...
19,128	50,220	2.63	0.94	56.1	31.9	5n1fs4m2n2y0r		select pos#, intcol#, col#, sp...
17,963	633	0.04	1.20	35.6	36.4	3ktacv9r56b51		select owner#, name, namespace...
17,963	565	0.03	0.83	32.5	45.1	8swypbbr0m372		select order#, columns, types ...
17,820	17,820	1.00	0.86	61.6	8.6	38243c4tqrkxm		select u.name, o.name, o.names...
17,816	17,816	1.00	0.70	88.6	0	3qt0dku301xw0		select u.name, o.name, o.obj#,...
17,816	17,816	1.00	0.50	94.6	0	c2tgzxvda0vfn		select type# from ind$ where o...
17,096	17,095	1.00	0.92	58.9	48.1	9tgj4g8y4rwy8		select type#, blocks, extents,...
17,047	379,387	22.26	2.39	90.2	1.8	83taa7kaw59c1		select name, intcol#, segcol#,...
16,906	19,128	1.13	4.18	57	23.4	7ng34ruy5awxq		select i.obj#, i.ts#, i.file#,...
16,615	112,667	6.78	2.39	36.8	63.8	2q93zsrvbdw48		select grantee#, privilege#, n...
16,611	0	0.00	2.45	29.7	77.5	6aq34nj2zb2n7		select col#, grantee#, privile...
15,056	15,056	1.00	0.48	98.8	0	0a7q9v9nd2qc1		select count(*) from associati...
14,854	0	0.00	0.33	96.5	0	3kywng531fcxu		delete from tab_stats$ where o...
14,854	289	0.02	1.08	27.3	56.8	7tt3tfgb57599		delete /+ index(mm) / from s...
14,854	14,854	1.00	1.90	93.1	0	b5cr4hhndmbuf		update tab$ set ts#=:2, file#=...
14,854	11	0.00	0.51	40.2	0	cpr1yyzpfkw2a		delete /+ index(m) / from sy...
14,854	0	0.00	0.40	89.7	0	gsfnqdfcvy33q		delete from superobj$ where su...
14,853	14,853	1.00	0.54	94.4	0	9nxs1sq5jyyf1		select count(i.obj#) from ind$...
14,853	14,853	1.00	0.41	94.9	0	gtfzbk4ajr15q		select count(*) from associati...
14,360	16,763	1.17	0.70	100.8	0	5hajs402v7dqg		select i.obj# from ind$ i wher...
14,267	14,267	1.00	0.84	49.3	12.1	1gu8t96d0bdmu		select t.ts#, t.file#, t.block...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 428,017
Captured SQL account for 89.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
34,537	34,537	8.07	3axxxnjp5jjwj		delete from ind_stats$ where o...
34,490	34,490	8.06	6q42j0018w7t8		insert into sys.wri$_optstat_i...
32,915	32,915	7.69	9gkq7rruycsjp		select parttype, partcnt, part...
32,176	32,176	7.52	9dzjush42kmfs	fglrun-bin@PAYERP-AP (TNS V1-V3)	select spare4 from sys.optstat...
32,176	32,176	7.52	fcwg2b0rszakk		select p.valchar from sys.opts...
17,963	17,963	4.20	3ktacv9r56b51		select owner#, name, namespace...
17,963	17,963	4.20	8swypbbr0m372		select order#, columns, types ...
17,820	17,820	4.16	38243c4tqrkxm		select u.name, o.name, o.names...
17,816	17,816	4.16	3qt0dku301xw0		select u.name, o.name, o.obj#,...
17,816	17,816	4.16	c2tgzxvda0vfn		select type# from ind$ where o...
15,056	15,056	3.52	0a7q9v9nd2qc1		select count(*) from associati...
14,854	14,854	3.47	3kywng531fcxu		delete from tab_stats$ where o...
14,854	14,854	3.47	7tt3tfgb57599		delete /+ index(mm) / from s...
14,854	14,854	3.47	cpr1yyzpfkw2a		delete /+ index(m) / from sy...
14,854	14,854	3.47	gsfnqdfcvy33q		delete from superobj$ where su...
14,853	14,853	3.47	9nxs1sq5jyyf1		select count(i.obj#) from ind$...
14,853	14,853	3.47	gtfzbk4ajr15q		select count(*) from associati...
14,360	14,360	3.36	5hajs402v7dqg		select i.obj# from ind$ i wher...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

0a7q9v9nd2qc1 select count(*) from association$ where obj# = :1

0bjbaw9270kjv DECLARE l_last_full_time VARCHAR2(64); l_last_full_age NUMBER; l_last_full_size NUMBER; l_last_exec_full_time VARCHAR2(64); l_last_exec_full_status VARCHAR2(23); l_last_incr_time VARCHAR2(64); l_last_incr_age NUMBER; l_last_incr_size NUMBER; l_last_exec_incr_time VARCHAR2(64); l_last_exec_incr_status VARCHAR2(23); l_last_arch_time VARCHAR2(64); l_last_arch_age NUMBER; l_last_arch_size NUMBER; l_last_exec_arch_time VARCHAR2(64); l_last_exec_arch_status VARCHAR2(23); l_last_complete_backup VARCHAR2(64); l_recovery_window NUMBER; l_unprotected_data_window NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_121 CONSTANT VARCHAR2(10) := '12.1.0.0.0'; BEGIN SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), ROUND((sysdate-end_time)*24, 2), input_bytes INTO l_last_full_time, l_last_full_age, l_last_full_size FROM (SELECT end_time, input_bytes FROM v$rma n_backup_job_details WHERE status LIKE 'COMPLETED%' AND input_type='DB FULL' AND output_device_type IN ('DISK', '*') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_full_time := NULL; l_last_full_age := NULL; l_last_full_size := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), status INTO l_last_exec_full_time, l_last_exec_full_status FROM (SELECT end_time, status FROM v$rman_backup_job_details WHERE status NOT LIKE 'RUNNING%' AND input_type='DB FULL' AND output_device_type IN ('DISK', '*') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_exec_full_time := NULL; l_last_exec_full_status := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), ROUND((sysdate-end_time)*24, 2), input_bytes INTO l_last_incr_time, l_last_incr_age, l_last_incr_size FROM (SELECT end_time, input_bytes FRO M v$rman_backup_job_details WHERE status LIKE 'COMPLETED%' AND input_type='DB INCR' AND output_device_type IN ('DISK', '*') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_incr_time := NULL; l_last_incr_age := NULL; l_last_incr_size := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), status INTO l_last_exec_incr_time, l_last_exec_incr_status FROM (SELECT end_time, status FROM v$rman_backup_job_details WHERE status NOT LIKE 'RUNNING%' AND input_type='DB INCR' AND output_device_type IN ('DISK', '*') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_exec_incr_time := NULL; l_last_exec_incr_status := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), ROUND((sysdate-end_time)*24*60, 2), input_bytes INTO l_last_arch_time, l_last_arch_age, l_last_arch_size FROM (SELECT end_time, inpu t_bytes FROM v$rman_backup_job_details WHERE status LIKE 'COMPLETED%' AND input_type='ARCHIVELOG' AND output_device_type IN ('DISK', '*') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_arch_time := NULL; l_last_arch_age := NULL; l_last_arch_size := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), status INTO l_last_exec_arch_time, l_last_exec_arch_status FROM (SELECT end_time, status FROM v$rman_backup_job_details WHERE status NOT LIKE 'RUNNING%' AND input_type='ARCHIVELOG' AND output_device_type IN ('DISK', '*') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_exec_arch_time := NULL; l_last_exec_arch_status := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN IF (v_db_version >= db_version_121) THEN EXECUTE IMMEDIATE 'SELECT to_char(low_time, ''YYYY-MM-DD HH24:MI:SS'') as last_complete_backup, ROUND((high_time-low_time)*24*6 0*60, 2) as recovery_window, ROUND((sysdate-high_time)*24*60*60, 2) as unprotected_data_window FROM v$disk_restore_range rr1 WHERE rr1.high_time = (SELECT max(rr2.high_time) FROM v$disk_restore_range rr2 WHERE rr1.db_id = rr2.db_id)' INTO l_last_complete_backup, l_recovery_window, l_unprotected_data_window; END IF; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_complete_backup := NULL; l_recovery_window := NULL; l_unprotected_data_window := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; OPEN data_cursor FOR SELECT l_last_full_time, l_last_full_age, l_last_full_size, l_last_exec_full_time, l_last_exec_full_status, l_last_incr_time, l_last_incr_age, l_last_incr_size, l_last_exec_incr_time, l_last_exec_incr_status, l_last_arch_time, l_last_arch_age, l_last_arch_size, l_last_exec_arch_time, l_last_exec_arch_status, l_last_complete_backup, l_recovery_window, l_unprotected_data_window FROM dual; :1 := data_cursor; END;

0hhmdwwgxbw0r select obj#, type#, flags, related, bo, purgeobj, con# from RecycleBin$ where ts#=:1 and to_number(bitand(flags, 16)) = 16 order by dropscn

1gu8t96d0bdmu select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)

1hxa21sh2kwdw delete from tc_btx_file WHERE EXISTS(SELECT 1 FROM ima_file WHERE ima01 = tc_btx02 AND ima08 = 'P' AND ima1010 = '1' AND 1 = 1)

1q39a3p6hzp7t select 'analyze table ', TABLE_NAME, ' compute statistics;' from user_tables where TABLE_NAME like '%\_FILE' escape '\'

2q93zsrvbdw48 select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#

330q95smuwnv9 update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5, null_cnt=:6, timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10, distcnt=:11, lowval=:12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18 where obj#=:1 and intcol#=:2

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

3axxxnjp5jjwj delete from ind_stats$ where obj#=:1

3d40u5r2jfcsd update ind$ set ts#=:2, file#=:3, block#=:4, intcols=:5, type#=:6, flags=:7, property=:8, pctfree$=:9, initrans=:10, maxtrans=:11, blevel=:12, leafcnt=:13, distkey=:14, lblkkey=:15, dblkkey=:16, clufac=:17, cols=:18, analyzetime=:19, samplesize=:20, dataobj#=:21, degree=decode(:22, 1, null, :22), instances=decode(:23, 1, null, :23), rowcnt=:24, pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27, spare4=:29, spare2=:30, spare6=:32where obj#=:1

3ktacv9r56b51 select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#

3kywng531fcxu delete from tab_stats$ where obj#=:1

3qt0dku301xw0 select u.name, o.name, o.obj#, o.type# from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#

5hajs402v7dqg select i.obj# from ind$ i where i.bo#=:1 order by i.obj# desc

5n1fs4m2n2y0r select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1

6ajkhukk78nsr begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;

6aq34nj2zb2n7 select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#

6q42j0018w7t8 insert into sys.wri$_optstat_ind_history(obj#, rowcnt, leafcnt, distkey, lblkkey, dblkkey, clufac, blevel, analyzetime, samplesize, guessq, cachedblk, cachehit, logicalread, savtime, flags) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)

7g4rxwbvhdh3q SELECT startsn.stat_id, smap.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYSSTAT startsn , WRH$_SYSSTAT endsn , X$KEHSYSMAP smap WHERE startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash and endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid and endsn.instance_number = :inst GROUP BY startsn.stat_id, smap.keh_id ORDER BY startsn.stat_id ASC

7ng34ruy5awxq select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#

7tt3tfgb57599 delete /*+ index(mm) */ from sys.mon_mods_all$ mm where obj# = :1

833wvjbwufzfa delete from sys.aud$ where NTIMESTAMP# < to_date(sysdate-30)

83taa7kaw59c1 select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#

8swypbbr0m372 select order#, columns, types from access$ where d_obj#=:1

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

9dzjush42kmfs select spare4 from sys.optstat_hist_control$ where sname=:1

9gkq7rruycsjp select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1

9nxs1sq5jyyf1 select count(i.obj#) from ind$ i where i.bo#=:1

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

aujtsaq37rkrh DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (select * from dba_advisor_tasks order by task_id desc) T, dba_advisor_parameters_proj P1, dba_advisor_parameters_proj P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (sysdate - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = to_char(db_id) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1; BEGIN SELECT dbid INTO db_id from v$database; OPEN get_latest_task_id; FETCH get_latest_task_id INTO latest_task_id; CLOSE get_latest_task_id; FOR param_info IN (SELECT parameter_v alue, parameter_name FROM dba_advisor_parameters_proj WHERE task_id= latest_task_id AND (parameter_name='START_TIME' OR parameter_name='END_TIME') ORDER BY 2) LOOP IF param_info.parameter_name = 'END_TIME' THEN end_time := param_info.parameter_value; ELSIF param_info.parameter_name = 'START_TIME' THEN start_time := param_info.parameter_value; END IF; END LOOP; OPEN data_cursor FOR WITH recInfo AS ( SELECT /*+ NO_MERGE */ finding_id, count(r.rec_id) recCount, r.type FROM DBA_ADVISOR_RECOMMENDATIONS r WHERE task_id=latest_task_id GROUP BY r.finding_id, r.type ), f_curr AS ( SELECT /*+ NO_MERGE */ DISTINCT finding_name FROM DBA_ADVISOR_FINDINGS WHERE task_id=latest_task_id ), tasks AS ( SELECT /*+ NO_MERGE */ t.task_id, i.local_task_id, t.end_time, t.begin_time FROM DBA_ADDM_TASKS t, DBA_ADDM_INSTANCES i WHERE t.end_time>sysdate -1 AND t.task_id=i.task_id AND i.instance_number=SYS_CONTEXT('USERENV', 'INSTANCE') AND t.requested_analysis='INSTANCE' ), f_all AS ( SELECT /*+ NO_MERG E */ COUNT(fa.task_id) finding_count, fa.finding_name FROM tasks, DBA_ADVISOR_FINDINGS fa WHERE fa.task_id=tasks.task_id AND fa.type<>'INFORMATION' AND fa.type<>'WARNING' AND fa.parent=0 GROUP BY fa.finding_name ), history AS ( SELECT /*+ NO_MERGE */ finding_name, finding_count FROM f_all JOIN f_curr USING (finding_name) ) SELECT latest_task_id task_id, f.finding_id finding_id, DECODE(recInfo.type, null, 'Uncategorized', recInfo.type) rec_type, recInfo.recCount rec_count, f.perc_active_sess impact_pct, f.message message, TO_CHAR(TO_DATE(start_time , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') start_time, TO_CHAR(TO_DATE(end_time, 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') end_time, history.finding_count finding_count, f.finding_name finding_name, f.active_sessions active_sessions FROM DBA_ADDM_FINDINGS f, recInfo, history WHERE f.task_id=latest_task_id AND f.type<>'INFORMATION' AND f.type<>'WARNING' AND f.filtered<>'Y' AND f .parent=0 AND f.finding_id=recInfo.finding_id (+) AND f.finding_name=history.finding_name ORDER BY f.finding_id; :1 := data_cursor; END;

b5cr4hhndmbuf update tab$ set ts#=:2, file#=:3, block#=:4, bobj#=decode(:5, 0, null, :5), tab#=decode(:6, 0, null, :6), intcols=:7, kernelcols=:8, clucols=decode(:9, 0, null, :9), audit$=:10, flags=:11, pctfree$=:12, pctused$=:13, initrans=:14, maxtrans=:15, rowcnt=:16, blkcnt=:17, empcnt=:18, avgspc=:19, chncnt=:20, avgrln=:21, analyzetime=:22, samplesize=:23, cols=:24, property=:25, degree=decode(:26, 1, null, :26), instances=decode(:27, 1, null, :27), dataobj#=:28, avgspc_flb=:29, flbcnt=:30, trigflag=:31, spare1=:32, spare2=decode(:33, 0, null, :33), spare4=:34, spare6=:35 where obj#=:1

bqfx5q2jas08u SELECT TASK_LIST.TASK_ID FROM (SELECT /*+ NO_MERGE(T) ORDERED */ T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1

c2tgzxvda0vfn select type# from ind$ where obj# = :1

cpr1yyzpfkw2a delete /*+ index(m) */ from sys.mon_mods$ m where obj# = :1

fcwg2b0rszakk select p.valchar from sys.optstat_user_prefs$ p where p.obj#=:1 and p.pname=:2

gsfnqdfcvy33q delete from superobj$ where subobj# = :1

gtfzbk4ajr15q select count(*) from association$ a, coltype$ c, obj$ o where c.obj#= :1 AND c.toid = o.oid$ and o.obj# = a.obj#

SQL Id	SQL Text
0a7q9v9nd2qc1	select count(*) from association$ where obj# = :1
0bjbaw9270kjv	DECLARE l_last_full_time VARCHAR2(64); l_last_full_age NUMBER; l_last_full_size NUMBER; l_last_exec_full_time VARCHAR2(64); l_last_exec_full_status VARCHAR2(23); l_last_incr_time VARCHAR2(64); l_last_incr_age NUMBER; l_last_incr_size NUMBER; l_last_exec_incr_time VARCHAR2(64); l_last_exec_incr_status VARCHAR2(23); l_last_arch_time VARCHAR2(64); l_last_arch_age NUMBER; l_last_arch_size NUMBER; l_last_exec_arch_time VARCHAR2(64); l_last_exec_arch_status VARCHAR2(23); l_last_complete_backup VARCHAR2(64); l_recovery_window NUMBER; l_unprotected_data_window NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; v_db_version VARCHAR2(10); db_version_121 CONSTANT VARCHAR2(10) := '12.1.0.0.0'; BEGIN SELECT LPAD(version, 10, '0') INTO v_db_version FROM v$instance; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), ROUND((sysdate-end_time)24, 2), input_bytes INTO l_last_full_time, l_last_full_age, l_last_full_size FROM (SELECT end_time, input_bytes FROM v$rma n_backup_job_details WHERE status LIKE 'COMPLETED%' AND input_type='DB FULL' AND output_device_type IN ('DISK', '') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_full_time := NULL; l_last_full_age := NULL; l_last_full_size := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), status INTO l_last_exec_full_time, l_last_exec_full_status FROM (SELECT end_time, status FROM v$rman_backup_job_details WHERE status NOT LIKE 'RUNNING%' AND input_type='DB FULL' AND output_device_type IN ('DISK', '') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_exec_full_time := NULL; l_last_exec_full_status := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), ROUND((sysdate-end_time)24, 2), input_bytes INTO l_last_incr_time, l_last_incr_age, l_last_incr_size FROM (SELECT end_time, input_bytes FRO M v$rman_backup_job_details WHERE status LIKE 'COMPLETED%' AND input_type='DB INCR' AND output_device_type IN ('DISK', '') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_incr_time := NULL; l_last_incr_age := NULL; l_last_incr_size := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), status INTO l_last_exec_incr_time, l_last_exec_incr_status FROM (SELECT end_time, status FROM v$rman_backup_job_details WHERE status NOT LIKE 'RUNNING%' AND input_type='DB INCR' AND output_device_type IN ('DISK', '') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_exec_incr_time := NULL; l_last_exec_incr_status := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), ROUND((sysdate-end_time)2460, 2), input_bytes INTO l_last_arch_time, l_last_arch_age, l_last_arch_size FROM (SELECT end_time, inpu t_bytes FROM v$rman_backup_job_details WHERE status LIKE 'COMPLETED%' AND input_type='ARCHIVELOG' AND output_device_type IN ('DISK', '') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_arch_time := NULL; l_last_arch_age := NULL; l_last_arch_size := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN SELECT to_char(end_time, 'YYYY-MM-DD HH24:MI:SS'), status INTO l_last_exec_arch_time, l_last_exec_arch_status FROM (SELECT end_time, status FROM v$rman_backup_job_details WHERE status NOT LIKE 'RUNNING%' AND input_type='ARCHIVELOG' AND output_device_type IN ('DISK', '') ORDER BY end_time DESC) WHERE rownum = 1; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_exec_arch_time := NULL; l_last_exec_arch_status := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; BEGIN IF (v_db_version >= db_version_121) THEN EXECUTE IMMEDIATE 'SELECT to_char(low_time, ''YYYY-MM-DD HH24:MI:SS'') as last_complete_backup, ROUND((high_time-low_time)246 060, 2) as recovery_window, ROUND((sysdate-high_time)246060, 2) as unprotected_data_window FROM v$disk_restore_range rr1 WHERE rr1.high_time = (SELECT max(rr2.high_time) FROM v$disk_restore_range rr2 WHERE rr1.db_id = rr2.db_id)' INTO l_last_complete_backup, l_recovery_window, l_unprotected_data_window; END IF; EXCEPTION WHEN NO_DATA_FOUND THEN l_last_complete_backup := NULL; l_recovery_window := NULL; l_unprotected_data_window := NULL; WHEN OTHERS THEN dbms_output.put_line(SQLERRM); END; OPEN data_cursor FOR SELECT l_last_full_time, l_last_full_age, l_last_full_size, l_last_exec_full_time, l_last_exec_full_status, l_last_incr_time, l_last_incr_age, l_last_incr_size, l_last_exec_incr_time, l_last_exec_incr_status, l_last_arch_time, l_last_arch_age, l_last_arch_size, l_last_exec_arch_time, l_last_exec_arch_status, l_last_complete_backup, l_recovery_window, l_unprotected_data_window FROM dual; :1 := data_cursor; END;
0hhmdwwgxbw0r	select obj#, type#, flags, related, bo, purgeobj, con# from RecycleBin$ where ts#=:1 and to_number(bitand(flags, 16)) = 16 order by dropscn
1gu8t96d0bdmu	select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+)
1hxa21sh2kwdw	delete from tc_btx_file WHERE EXISTS(SELECT 1 FROM ima_file WHERE ima01 = tc_btx02 AND ima08 = 'P' AND ima1010 = '1' AND 1 = 1)
1q39a3p6hzp7t	select 'analyze table ', TABLE_NAME, ' compute statistics;' from user_tables where TABLE_NAME like '%\_FILE' escape '\'
2q93zsrvbdw48	select grantee#, privilege#, nvl(col#, 0), max(mod(nvl(option$, 0), 2))from objauth$ where obj#=:1 group by grantee#, privilege#, nvl(col#, 0) order by grantee#
330q95smuwnv9	update hist_head$ set bucket_cnt=:3, row_cnt=:4, cache_cnt=:5, null_cnt=:6, timestamp#=:7, sample_size=:8, minimum=:9, maximum=:10, distcnt=:11, lowval=:12, hival=:13, density=:14, spare1=:15, spare2=:16, avgcln=:17, col#=:18 where obj#=:1 and intcol#=:2
38243c4tqrkxm	select u.name, o.name, o.namespace, o.type#, decode(bitand(i.property, 1024), 0, 0, 1), o.obj# from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
3axxxnjp5jjwj	delete from ind_stats$ where obj#=:1
3d40u5r2jfcsd	update ind$ set ts#=:2, file#=:3, block#=:4, intcols=:5, type#=:6, flags=:7, property=:8, pctfree$=:9, initrans=:10, maxtrans=:11, blevel=:12, leafcnt=:13, distkey=:14, lblkkey=:15, dblkkey=:16, clufac=:17, cols=:18, analyzetime=:19, samplesize=:20, dataobj#=:21, degree=decode(:22, 1, null, :22), instances=decode(:23, 1, null, :23), rowcnt=:24, pctthres$=:31*256+:25, indmethod#=:26, trunccnt=:27, spare4=:29, spare2=:30, spare6=:32where obj#=:1
3ktacv9r56b51	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3kywng531fcxu	delete from tab_stats$ where obj#=:1
3qt0dku301xw0	select u.name, o.name, o.obj#, o.type# from ind$ i, obj$ o, user$ u where i.obj#=:1 and o.obj#=i.bo# and o.owner#=u.user#
5hajs402v7dqg	select i.obj# from ind$ i where i.bo#=:1 order by i.obj# desc
5n1fs4m2n2y0r	select pos#, intcol#, col#, spare1, bo#, spare2, spare3 from icol$ where obj#=:1
6ajkhukk78nsr	begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end;
6aq34nj2zb2n7	select col#, grantee#, privilege#, max(mod(nvl(option$, 0), 2)) from objauth$ where obj#=:1 and col# is not null group by privilege#, col#, grantee# order by col#, grantee#
6q42j0018w7t8	insert into sys.wri$_optstat_ind_history(obj#, rowcnt, leafcnt, distkey, lblkkey, dblkkey, clufac, blevel, analyzetime, samplesize, guessq, cachedblk, cachehit, logicalread, savtime, flags) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
7g4rxwbvhdh3q	SELECT startsn.stat_id, smap.keh_id, sum(GREATEST( 0, (endsn.value - startsn.value) )) as value_diff FROM WRH$_SYSSTAT startsn , WRH$_SYSSTAT endsn , X$KEHSYSMAP smap WHERE startsn.stat_id = endsn.stat_id and startsn.stat_id = smap.statistic_hash and endsn.dbid = :dbid AND endsn.instance_number = :inst AND endsn.snap_id = :eid AND startsn.dbid = :dbid AND startsn.instance_number = endsn.instance_number AND startsn.snap_id = :bid and endsn.instance_number = :inst GROUP BY startsn.stat_id, smap.keh_id ORDER BY startsn.stat_id ASC
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7tt3tfgb57599	delete /+ index(mm) / from sys.mon_mods_all$ mm where obj# = :1
833wvjbwufzfa	delete from sys.aud$ where NTIMESTAMP# < to_date(sysdate-30)
83taa7kaw59c1	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/MAXSB1MINAL/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol#
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
96g93hntrzjtr	select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2
9dzjush42kmfs	select spare4 from sys.optstat_hist_control$ where sname=:1
9gkq7rruycsjp	select parttype, partcnt, partkeycols, flags, defts#, defpctfree, defpctused, definitrans, defmaxtrans, deftiniexts, defextsize, defminexts, defmaxexts, defextpct, deflists, defgroups, deflogging, spare1, mod(spare2, 256) subparttype, mod(trunc(spare2/256), 256) subpartkeycols, mod(trunc(spare2/65536), 65536) defsubpartcnt, mod(trunc(spare2/4294967296), 256) defhscflags, mod(spare3, 256) interval_dty, rowid, defmaxsize from partobj$ where obj# = :1
9nxs1sq5jyyf1	select count(i.obj#) from ind$ i where i.bo#=:1
9tgj4g8y4rwy8	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
aujtsaq37rkrh	DECLARE instance_number NUMBER; latest_task_id NUMBER; start_time VARCHAR2(1024); end_time VARCHAR2(1024); db_id NUMBER; TYPE data_cursor_type IS REF CURSOR; data_cursor data_cursor_type; CURSOR get_latest_task_id IS SELECT TASK_LIST.TASK_ID FROM (SELECT /+ NO_MERGE(T) ORDERED / T.TASK_ID FROM (select * from dba_advisor_tasks order by task_id desc) T, dba_advisor_parameters_proj P1, dba_advisor_parameters_proj P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (sysdate - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = to_char(db_id) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1; BEGIN SELECT dbid INTO db_id from v$database; OPEN get_latest_task_id; FETCH get_latest_task_id INTO latest_task_id; CLOSE get_latest_task_id; FOR param_info IN (SELECT parameter_v alue, parameter_name FROM dba_advisor_parameters_proj WHERE task_id= latest_task_id AND (parameter_name='START_TIME' OR parameter_name='END_TIME') ORDER BY 2) LOOP IF param_info.parameter_name = 'END_TIME' THEN end_time := param_info.parameter_value; ELSIF param_info.parameter_name = 'START_TIME' THEN start_time := param_info.parameter_value; END IF; END LOOP; OPEN data_cursor FOR WITH recInfo AS ( SELECT /+ NO_MERGE / finding_id, count(r.rec_id) recCount, r.type FROM DBA_ADVISOR_RECOMMENDATIONS r WHERE task_id=latest_task_id GROUP BY r.finding_id, r.type ), f_curr AS ( SELECT /+ NO_MERGE / DISTINCT finding_name FROM DBA_ADVISOR_FINDINGS WHERE task_id=latest_task_id ), tasks AS ( SELECT /+ NO_MERGE / t.task_id, i.local_task_id, t.end_time, t.begin_time FROM DBA_ADDM_TASKS t, DBA_ADDM_INSTANCES i WHERE t.end_time>sysdate -1 AND t.task_id=i.task_id AND i.instance_number=SYS_CONTEXT('USERENV', 'INSTANCE') AND t.requested_analysis='INSTANCE' ), f_all AS ( SELECT /+ NO_MERG E / COUNT(fa.task_id) finding_count, fa.finding_name FROM tasks, DBA_ADVISOR_FINDINGS fa WHERE fa.task_id=tasks.task_id AND fa.type<>'INFORMATION' AND fa.type<>'WARNING' AND fa.parent=0 GROUP BY fa.finding_name ), history AS ( SELECT /+ NO_MERGE / finding_name, finding_count FROM f_all JOIN f_curr USING (finding_name) ) SELECT latest_task_id task_id, f.finding_id finding_id, DECODE(recInfo.type, null, 'Uncategorized', recInfo.type) rec_type, recInfo.recCount rec_count, f.perc_active_sess impact_pct, f.message message, TO_CHAR(TO_DATE(start_time , 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') start_time, TO_CHAR(TO_DATE(end_time, 'MM-DD-YYYY HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') end_time, history.finding_count finding_count, f.finding_name finding_name, f.active_sessions active_sessions FROM DBA_ADDM_FINDINGS f, recInfo, history WHERE f.task_id=latest_task_id AND f.type<>'INFORMATION' AND f.type<>'WARNING' AND f.filtered<>'Y' AND f .parent=0 AND f.finding_id=recInfo.finding_id (+) AND f.finding_name=history.finding_name ORDER BY f.finding_id; :1 := data_cursor; END;
b5cr4hhndmbuf	update tab$ set ts#=:2, file#=:3, block#=:4, bobj#=decode(:5, 0, null, :5), tab#=decode(:6, 0, null, :6), intcols=:7, kernelcols=:8, clucols=decode(:9, 0, null, :9), audit$=:10, flags=:11, pctfree$=:12, pctused$=:13, initrans=:14, maxtrans=:15, rowcnt=:16, blkcnt=:17, empcnt=:18, avgspc=:19, chncnt=:20, avgrln=:21, analyzetime=:22, samplesize=:23, cols=:24, property=:25, degree=decode(:26, 1, null, :26), instances=decode(:27, 1, null, :27), dataobj#=:28, avgspc_flb=:29, flbcnt=:30, trigflag=:31, spare1=:32, spare2=decode(:33, 0, null, :33), spare4=:34, spare6=:35 where obj#=:1
bqfx5q2jas08u	SELECT TASK_LIST.TASK_ID FROM (SELECT /+ NO_MERGE(T) ORDERED / T.TASK_ID FROM (SELECT * FROM DBA_ADVISOR_TASKS ORDER BY TASK_ID DESC) T, DBA_ADVISOR_PARAMETERS_PROJ P1, DBA_ADVISOR_PARAMETERS_PROJ P2 WHERE T.ADVISOR_NAME='ADDM' AND T.STATUS = 'COMPLETED' AND T.EXECUTION_START >= (SYSDATE - 1) AND T.HOW_CREATED = 'AUTO' AND T.TASK_ID = P1.TASK_ID AND P1.PARAMETER_NAME = 'INSTANCE' AND P1.PARAMETER_VALUE = SYS_CONTEXT('USERENV', 'INSTANCE') AND T.TASK_ID = P2.TASK_ID AND P2.PARAMETER_NAME = 'DB_ID' AND P2.PARAMETER_VALUE = TO_CHAR(:B1 ) ORDER BY T.TASK_ID DESC) TASK_LIST WHERE ROWNUM = 1
c2tgzxvda0vfn	select type# from ind$ where obj# = :1
cpr1yyzpfkw2a	delete /+ index(m) / from sys.mon_mods$ m where obj# = :1
fcwg2b0rszakk	select p.valchar from sys.optstat_user_prefs$ p where p.obj#=:1 and p.pname=:2
gsfnqdfcvy33q	delete from superobj$ where subobj# = :1
gtfzbk4ajr15q	select count(*) from association$ a, coltype$ c, obj$ o where c.obj#= :1 AND c.toid = o.oid$ and o.obj# = a.obj#

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Key Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
db block changes	5,487,701	1,522.94	20,865.78
execute count	1,272,963	353.27	4,840.16
logons cumulative	68	0.02	0.26
opened cursors cumulative	1,236,787	343.23	4,702.61
parse count (total)	428,017	118.78	1,627.44
parse time elapsed	4,257	1.18	16.19
physical reads	7,047,541	1,955.82	26,796.73
physical writes	497,503	138.07	1,891.65
redo size	1,191,100,884	330,552.02	4,528,900.70
session cursor cache hits	240,274	66.68	913.59
session logical reads	20,092,446	5,576.02	76,397.13
user calls	70,431	19.55	267.80
user commits	263	0.07	1.00
user rollbacks	0	0.00	0.00
workarea executions - multipass	1	0.00	0.00
workarea executions - onepass	46	0.01	0.17
workarea executions - optimal	116,665	32.38	443.59

Back to Instance Activity Statistics
Back to Top

Other Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	12	0.00	0.05
Batched IO (full) vector count	0	0.00	0.00
Batched IO (space) vector count	0	0.00	0.00
Batched IO block miss count	60	0.02	0.23
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	4	0.00	0.02
Batched IO same unit count	32	0.01	0.12
Batched IO single block count	9	0.00	0.03
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	19	0.01	0.07
Batched IO vector read count	7	0.00	0.03
Block Cleanout Optim referenced	240	0.07	0.91
CCursor + sql area evicted	9	0.00	0.03
CPU used by this session	186,497	51.76	709.11
CPU used when call started	185,666	51.53	705.95
CR blocks created	2	0.00	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	789	0.22	3.00
DBWR checkpoint buffers written	163,910	45.49	623.23
DBWR checkpoints	8	0.00	0.03
DBWR object drop buffers written	3,778	1.05	14.37
DBWR revisited being-written buffer	1,267	0.35	4.82
DBWR tablespace checkpoint buffers written	6	0.00	0.02
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	724	0.20	2.75
DBWR undo block writes	68,679	19.06	261.14
HSC Heap Segment Block Changes	1,452,327	403.05	5,522.16
Heap Segment Array Inserts	44,149	12.25	167.87
Heap Segment Array Updates	410	0.11	1.56
IMU CR rollbacks	0	0.00	0.00
IMU Flushes	242	0.07	0.92
IMU Redo allocation size	215,056	59.68	817.70
IMU commits	20	0.01	0.08
IMU contention	2	0.00	0.01
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	2	0.00	0.01
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	387,544	107.55	1,473.55
IMU- failed to get a private strand	2	0.00	0.01
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	607	0.17	2.31
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Requests to/from client	36,687	10.18	139.49
RowCR - row contention	0	0.00	0.00
RowCR attempts	0	0.00	0.00
RowCR hits	0	0.00	0.00
SMON posted for dropping temp segment	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	3	0.00	0.01
SQL*Net roundtrips to/from client	36,687	10.18	139.49
SQL*Net roundtrips to/from dblink	0	0.00	0.00
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,782	1.33	18.18
auto extends on undo tablespace	0	0.00	0.00
background checkpoints completed	3	0.00	0.01
background checkpoints started	3	0.00	0.01
background timeouts	20,022	5.56	76.13
branch node splits	0	0.00	0.00
buffer is not pinned count	2,945,499	817.43	11,199.62
buffer is pinned count	10,538,258	2,924.56	40,069.42
bytes received via SQL*Net from client	11,027,490	3,060.33	41,929.62
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	7,338,821	2,036.66	27,904.26
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	1,309,230	363.33	4,978.06
calls to kcmgas	184,676	51.25	702.19
calls to kcmgcs	215,400	59.78	819.01
cell physical IO interconnect bytes	67,298,329,600	18,676,502.35	255,887,184.79
change write time	2,551	0.71	9.70
cleanout - number of ktugct calls	8,694	2.41	33.06
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	3,232	0.90	12.29
cluster key scan block gets	172,159	47.78	654.60
cluster key scans	150,131	41.66	570.84
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	6	0.00	0.02
commit batch/immediate requested	6	0.00	0.02
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	1,192	0.33	4.53
commit cleanout failures: callback failure	254	0.07	0.97
commit cleanout failures: cannot pin	0	0.00	0.00
commit cleanouts	215,969	59.94	821.17
commit cleanouts successfully completed	214,523	59.53	815.68
commit immediate performed	6	0.00	0.02
commit immediate requested	6	0.00	0.02
commit txn count during cleanout	4,708	1.31	17.90
consistent changes	13	0.00	0.05
consistent gets	14,802,838	4,108.05	56,284.56
consistent gets - examination	2,501,202	694.13	9,510.27
consistent gets direct	72,008	19.98	273.79
consistent gets from cache	14,730,830	4,088.07	56,010.76
consistent gets from cache (fastpath)	8,303,427	2,304.35	31,571.97
cursor authentications	739	0.21	2.81
data blocks consistent reads - undo records applied	2	0.00	0.01
db block gets	5,289,606	1,467.96	20,112.57
db block gets direct	16	0.00	0.06
db block gets from cache	5,289,590	1,467.96	20,112.51
db block gets from cache (fastpath)	1,198,053	332.48	4,555.33
deferred (CURRENT) block cleanout applications	157,562	43.73	599.10
dirty buffers inspected	18,560	5.15	70.57
enqueue conversions	2,439	0.68	9.27
enqueue deadlocks	0	0.00	0.00
enqueue releases	300,368	83.36	1,142.08
enqueue requests	300,366	83.36	1,142.08
enqueue timeouts	0	0.00	0.00
enqueue waits	209	0.06	0.79
exchange deadlocks	0	0.00	0.00
failed probes on index block reclamation	55	0.02	0.21
file io service time	0	0.00	0.00
frame signature mismatch	0	0.00	0.00
free buffer inspected	6,770,531	1,878.94	25,743.46
free buffer requested	6,794,535	1,885.61	25,834.73
global undo segment hints helped	0	0.00	0.00
global undo segment hints were stale	0	0.00	0.00
heap block compress	15,854	4.40	60.28
hot buffers moved to head of LRU	187,567	52.05	713.18
immediate (CR) block cleanout applications	3,232	0.90	12.29
immediate (CURRENT) block cleanout applications	15,339	4.26	58.32
index crx upgrade (positioned)	9,456	2.62	35.95
index crx upgrade (prefetch)	0	0.00	0.00
index fast full scans (full)	22	0.01	0.08
index fetch by key	487,644	135.33	1,854.16
index scans kdiixs1	884,224	245.39	3,362.07
leaf node 90-10 splits	126	0.03	0.48
leaf node splits	135	0.04	0.51
lob reads	0	0.00	0.00
lob writes	17	0.00	0.06
lob writes unaligned	17	0.00	0.06
logical read bytes from cache	164,007,280,640	45,514,983.52	623,601,827.53
max cf enq hold time	0	0.00	0.00
messages received	80,398	22.31	305.70
messages sent	80,398	22.31	305.70
min active SCN optimization applied on CR	86	0.02	0.33
no buffer to keep pinned count	4	0.00	0.02
no work - consistent read gets	9,402,012	2,609.23	35,749.10
non-idle wait count	4,137,135	1,148.13	15,730.55
parse count (describe)	14	0.00	0.05
parse count (failures)	21	0.01	0.08
parse count (hard)	34,764	9.65	132.18
parse time cpu	2,945	0.82	11.20
physical read IO requests	3,936,745	1,092.52	14,968.61
physical read bytes	57,733,455,872	16,022,077.08	219,518,843.62
physical read total IO requests	3,946,972	1,095.36	15,007.50
physical read total bytes	59,270,789,632	16,448,714.98	225,364,219.13
physical read total multi block requests	25,051	6.95	95.25
physical reads cache	6,668,137	1,850.53	25,354.13
physical reads cache prefetch	2,773,914	769.81	10,547.20
physical reads direct	379,404	105.29	1,442.60
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	307,396	85.31	1,168.81
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	157,766	43.78	599.87
physical write bytes	4,075,544,576	1,131,037.25	15,496,367.21
physical write total IO requests	299,894	83.23	1,140.28
physical write total bytes	8,027,539,968	2,227,787.38	30,522,965.66
physical write total multi block requests	14,524	4.03	55.22
physical writes direct	307,412	85.31	1,168.87
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	307,396	85.31	1,168.81
physical writes from cache	190,091	52.75	722.78
physical writes non checkpoint	429,017	119.06	1,631.24
pinned buffers inspected	2,904	0.81	11.04
pinned cursors current	0	0.00	0.00
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	267	0.07	1.02
process last non-idle time	3,465	0.96	13.17
recursive aborts on index block reclamation	0	0.00	0.00
recursive calls	4,064,222	1,127.90	15,453.32
recursive cpu usage	179,754	49.88	683.48
redo KB read	1,357,443	376.71	5,161.38
redo blocks checksummed by FG (exclusive)	466,121	129.36	1,772.32
redo blocks written	2,439,585	677.03	9,275.99
redo buffer allocation retries	15	0.00	0.06
redo entries	2,829,238	785.16	10,757.56
redo log space requests	44	0.01	0.17
redo ordering marks	22	0.01	0.08
redo size for direct writes	131,648	36.53	500.56
redo subscn max counts	32,778	9.10	124.63
redo synch long waits	42	0.01	0.16
redo synch poll writes	0	0.00	0.00
redo synch polls	0	0.00	0.00
redo synch time	14,348	3.98	54.56
redo synch time (usec)	143,511,298	39,826.98	545,670.33
redo synch time overhead (usec)	1,037,095,058	287,812.62	3,943,327.22
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	32,787	9.10	124.67
redo synch time overhead count (<32 msec)	3	0.00	0.01
redo synch time overhead count (<8 msec)	9	0.00	0.03
redo synch time overhead count (>=128 msec)	1	0.00	0.00
redo synch writes	32,811	9.11	124.76
redo wastage	17,841,536	4,951.35	67,838.54
redo write info find	32,800	9.10	124.71
redo write info find fail	0	0.00	0.00
redo write time	21,211	5.89	80.65
redo writes	67,734	18.80	257.54
rollback changes - undo records applied	5	0.00	0.02
rollbacks only - consistent read gets	2	0.00	0.01
root node splits	0	0.00	0.00
rows fetched via callback	65,353	18.14	248.49
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	51,339	14.25	195.21
shared hash latch upgrades - wait	0	0.00	0.00
sorts (disk)	47	0.01	0.18
sorts (memory)	149,451	41.48	568.25
sorts (rows)	2,707,980,010	751,513.38	10,296,501.94
sql area evicted	49,677	13.79	188.89
sql area purged	32,693	9.07	124.31
summed dirty queue length	38,328	10.64	145.73
switch current to new buffer	18,030	5.00	68.56
table fetch by rowid	5,664,497	1,572.00	21,538.01
table fetch continued row	138,652	38.48	527.19
table scan blocks gotten	965,574	267.96	3,671.38
table scan rows gotten	96,254,523	26,712.37	365,986.78
table scans (direct read)	4	0.00	0.02
table scans (long tables)	1	0.00	0.00
table scans (rowid ranges)	0	0.00	0.00
table scans (short tables)	33,321	9.25	126.70
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	1,350	0.37	5.13
total number of cf enq holders	225	0.06	0.86
total number of times SMON posted	4	0.00	0.02
transaction rollbacks	6	0.00	0.02
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	511,696,604	142,005.05	1,945,614.46
user logons cumulative	45	0.01	0.17
user logouts cumulative	46	0.01	0.17
write clones created in background	3	0.00	0.01
write clones created in foreground	32,792	9.10	124.68

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
logons current	52	51
opened cursors current	251	248
session cursor cache count	54,149,126	54,150,573
session pga memory	2,930,802,520	2,933,933,536
session pga memory max	9,092,579,832	9,100,691,584
session uga memory	115,736,750,792	115,741,677,352
session uga memory max	4,348,713,994,192	4,349,187,444,576
workarea memory allocated	2,188	2,188

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)	3	3.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)
Buffer Cache Reads	50.9G	1080.65	14.455M	0M	0.00	0M	3893.9K	0.24
Direct Reads	2.9G	11.78	.823M	428M	0.82	.119M	42.4K	0.03
Others	1.4G	2.74	.406M	1.4G	1.44	.384M	14.9K	0.54
LGWR	5M	0.10	.001M	2.3G	38.00	.662M	135.9K	2.58
Direct Writes	0M	0.00	0M	1.9G	2.74	.548M	12.8K	1.17
DBWR	0M	0.00	0M	1.5G	40.22	.412M	1419	93.55
Streams AQ	0M	0.01	0M	0M	0.00	0M	26	1.38
TOTAL:	55.2G	1095.27	15.685M	7.5G	83.23	2.125M	4101.5K	0.35

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	51.4G	1080.91	14.61M	1.4G	40.30	.411M	0.21	5.17
Temp File	2.3G	11.61	.666M	2.3G	3.56	.667M	0.00	0.00
Log File	1.3G	0.38	.368M	2.3G	37.99	.662M	0.17	0.88
Archive Log	0M	0.00	0M	1.3G	0.37	.368M
Control File	138M	2.35	.038M	52M	0.93	.014M	0.00	9.67
Other	0M	0.03	0M	7M	0.10	.002M	0.05
TOTAL:	55.2G	1095.27	15.683M	7.5G	83.24	2.123M	0.21	4.68

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)
Buffer Cache Reads	50.9G	1080.65	14.455M	0M	0.00	0M	3893.9K	0.24
Buffer Cache Reads (Data File)	50.9G	1080.65	14.455M	0M	0.00	0M	3893.9K	0.24
Direct Reads	2.9G	11.78	.823M	428M	0.82	.119M	0
Direct Reads (Data File)	2.9G	11.78	.823M	428M	0.82	.119M	0
Others	1.4G	2.71	.405M	1.3G	1.34	.383M	9991	0.14
Others (Archive Log)	0M	0.00	0M	1.3G	0.37	.368M	0
Others (Log File)	1.3G	0.37	.368M	0M	0.00	0M	1349	0.87
Others (Control File)	133M	2.25	.037M	52M	0.91	.014M	8117	0.01
Others (Data File)	3M	0.08	.001M	2M	0.06	.001M	525	0.24
LGWR	5M	0.10	.001M	2.3G	38.00	.662M	362	0.11
LGWR (Log File)	0M	0.00	0M	2.3G	37.99	.662M	24	1.42
LGWR (Control File)	5M	0.09	.001M	1M	0.02	0M	338	0.01
Direct Writes	0M	0.00	0M	1.9G	2.74	.548M	0
Direct Writes (Data File)	0M	0.00	0M	1.9G	2.74	.548M	0
DBWR	0M	0.00	0M	1.5G	40.24	.412M	0
DBWR (Data File)	0M	0.00	0M	1.5G	40.24	.412M	0
Streams AQ	0M	0.01	0M	0M	0.00	0M	26	1.38
Streams AQ (Data File)	0M	0.01	0M	0M	0.00	0M	26	1.38
TOTAL:	55.2G	1095.24	15.684M	7.5G	83.14	2.123M	3904.3K	0.24

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s
DBS1	3,852,700	1,069	0.35	1.67	73,463	1061.41	0	20
TEMP	41,839	12	0.00	7.35	12,828	0.14	0	4
UNDOTBS1	437	0	0.62	1.00	50,134	0.12	1	14
SYSTEM	30,189	8	0.54	2.17	6,233	5.56	1	2
SYSAUX	9,858	3	0.92	15.46	7,452	2.39	1	2
TEMPTABS	410	0	1.66	1.00	5,642	0.11	2	2
AUDIT	1,434	0	0.38	60.04	2,011	0.17	1	1

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rds/s	Av Rd(ms)	Av Blks/Rd	1-bk Rds/s	Av 1-bk Rd(ms)	Writes	Writes avg/s	Av Buf Wt(ms)
AUDIT	/u2/oradb/oradata/topprod/aud01.dbf	1,434	0	0.38	60.04	0	0.78	2,011	1	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-01.dbf	93,773	26	0.41	1.79	26	0.37	12	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-02.dbf	79,739	22	0.40	1.73	22	0.37	12	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-03.dbf	177,284	49	0.38	1.61	49	0.35	37	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-04.dbf	158,698	44	0.38	1.67	44	0.34	35	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-05.dbf	148,409	41	0.39	1.84	41	0.34	474	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-06.dbf	186,696	52	0.40	1.64	51	0.36	498	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-07.dbf	223,094	62	0.37	1.64	61	0.33	463	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-08.dbf	170,396	47	0.34	1.64	47	0.30	23	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-09.dbf	170,800	47	0.36	1.64	47	0.32	15	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-10.dbf	115,479	32	0.35	1.49	32	0.32	27	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-11.dbf	185,820	52	0.35	1.57	51	0.32	46	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-12.dbf	123,990	34	0.34	1.52	34	0.31	25	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-13.dbf	159,143	44	0.29	1.66	44	0.26	29	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-14.dbf	180,556	50	0.33	1.66	50	0.30	21	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-15.dbf	122,696	34	0.34	1.55	34	0.31	27	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-16.dbf	81,710	23	0.32	1.44	23	0.29	47	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-17.dbf	108,887	30	0.31	1.95	30	0.27	18	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-18.dbf	114,931	32	0.31	1.87	32	0.28	18	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-19.dbf	120,107	33	0.30	1.60	33	0.27	34	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-20.dbf	104,883	29	0.30	1.82	29	0.27	34	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-21.dbf	51,525	14	0.34	1.60	14	0.31	20	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-22.dbf	44,753	12	0.34	1.76	12	0.30	3,240	1	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-23.dbf	150,543	42	0.38	1.46	42	0.35	3,243	1	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-24.dbf	89,353	25	0.37	1.33	25	0.35	9,438	3	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-25.dbf	116,585	32	0.34	1.72	32	0.31	9,342	3	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-26.dbf	68,746	19	0.30	1.88	19	0.26	6,864	2	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-27.dbf	70,192	19	0.30	1.86	19	0.26	7,041	2	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-28.dbf	54,211	15	0.29	1.78	15	0.25	7,146	2	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-29.dbf	48,524	13	0.30	1.78	13	0.27	9,846	3	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-30.dbf	43,919	12	0.33	1.79	12	0.30	10,097	3	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-31.dbf	43,819	12	0.27	1.84	12	0.23	514	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-32.dbf	49,830	14	0.27	1.96	14	0.23	503	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-33.dbf	38,026	11	0.29	1.93	10	0.24	915	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-34.dbf	48,148	13	0.49	1.34	13	0.47	6	0	0.00
DBS1	/u2/oradb/oradata/topprod/dbs1-35.dbf	2,594	1	0.42	2.29	1	0.36	2	0	0.00
DBS1	/u2/oradb/oradata2/topprod/dbs1-34.dbf	104,841	29	0.33	1.86	29	0.29	3,351	1	0.00
SYSAUX	/u2/oradb/oradata/topprod/sysaux01.dbf	9,858	3	0.92	15.46	2	1.01	7,452	2	0.00
SYSTEM	/u2/oradb/oradata/topprod/system01.dbf	30,189	8	0.54	2.17	6	0.75	6,233	2	0.00
TEMP	/u2/oradb/oradata/topprod/temp01.dbf	41,839	12	0.00	7.35	0	0.00	12,828	4
TEMPTABS	/u2/oradb/oradata/topprod/temptabs.dbf	410	0	1.66	1.00	0	1.66	5,642	2	0.00
UNDOTBS1	/u2/oradb/oradata/topprod/undotbs01.dbf	437	0	0.62	1.00	0	0.62	50,134	14	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	246,043	67	20,018,931	6,668,207	190,091	0	0	0

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 497,503

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	162,786	0	0	1,118	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	125	11	759	29262	27188	2488320	27188		76173
E	122	10	326	1330	502717	2488320	502717		78242

Back to Advisory Statistics
Back to Top

MTTR Advisory

Only rows at end snap are displayed
Estimated Writes and I/Os are in thousands

Size for Est (s)	Dirty Limit	Est Cache Writes	Est Cache Write Fctr	Est Total Writes	Est Total Write Fctr
13	1,860	672,065	2.78	749,164	2.35
52	29,375	260,369	1.08	337,468	1.06
92	57,463	246,029	1.02	323,128	1.01
132	85,551	242,584	1.00	319,683	1.00
172	113,478	241,461	1.00	318,560	1.00

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	192	0.10	24	3.77	7,342,190	1	2124845.00
D	384	0.19	47	3.30	6,414,793	1	1804483.00
D	576	0.29	71	2.87	5,584,991	1	1517834.00
D	768	0.38	95	2.49	4,849,697	1	1263833.00
D	960	0.48	118	2.16	4,197,090	1	1038396.00
D	1,152	0.58	142	1.86	3,619,910	1	839013.00
D	1,344	0.67	165	1.60	3,116,992	1	665285.00
D	1,536	0.77	189	1.38	2,689,821	1	517722.00
D	1,728	0.86	213	1.20	2,336,557	1	395690.00
D	1,920	0.96	236	1.05	2,048,450	1	296165.00
D	2,000	1.00	246	1.00	1,946,732	1	261028.00
D	2,112	1.06	260	0.93	1,811,788	1	214413.00
D	2,304	1.15	284	0.83	1,614,920	1	146406.00
D	2,496	1.25	307	0.74	1,445,460	1	87868.00
D	2,688	1.34	331	0.67	1,296,154	1	49232.00
D	2,880	1.44	354	0.59	1,155,275	1	49195.00
D	3,072	1.54	378	0.52	1,016,998	1	49159.00
D	3,264	1.63	402	0.45	879,159	1	49123.00
D	3,456	1.73	425	0.38	741,345	1	49087.00
D	3,648	1.82	449	0.31	603,531	1	49050.00
D	3,840	1.92	473	0.24	465,715	1	49014.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
53.89	5,224	4,469

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

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	1-Pass Execs	M-Pass Execs
2K	4K	115,249	115,249	0	0
64K	128K	498	498	0	0
128K	256K	123	123	0	0
256K	512K	81	81	0	0
512K	1024K	164	164	0	0
1M	2M	346	346	0	0
2M	4M	64	63	1	0
4M	8M	77	61	16	0
8M	16M	59	43	16	0
16M	32M	11	5	6	0
32M	64M	12	11	1	0
64M	128M	5	2	3	0
128M	256M	4	2	2	0
256M	512M	1	0	1	0
512M	1024M	1	0	0	1

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
268	0.13	648,415,337.65	46,235,483.34	93.00	241,232	82,119,166,408
536	0.25	648,415,337.65	8,885,230.10	99.00	2,227	77,703,751,398
1,072	0.50	648,415,337.65	7,523,978.42	99.00	0	77,542,829,033
1,608	0.75	648,415,337.65	7,510,363.02	99.00	0	77,541,219,468
2,144	1.00	648,415,337.65	112,163.85	100.00	0	76,666,630,494
2,573	1.20	648,415,337.65	77,205.02	100.00	0	76,662,497,785
3,002	1.40	648,415,337.65	77,205.02	100.00	0	76,662,497,785
3,430	1.60	648,415,337.65	77,205.02	100.00	0	76,662,497,785
3,859	1.80	648,415,337.65	77,205.02	100.00	0	76,662,497,785
4,288	2.00	648,415,337.65	77,205.02	100.00	0	76,662,497,785
6,432	3.00	648,415,337.65	77,205.02	100.00	0	76,662,497,785
8,576	4.00	648,415,337.65	77,205.02	100.00	0	76,662,497,785
12,864	6.00	648,415,337.65	77,205.02	100.00	0	76,662,497,785
17,152	8.00	648,415,337.65	77,205.02	100.00	0	76,662,497,785

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,696	0.90	188	31,002	31,776,383	0.70	13,757,917	45.87	3,764,505
1,728	0.92	219	34,937	34,314,234	0.76	11,220,066	37.41	3,915,522
1,744	0.92	234	36,614	35,463,211	0.78	10,071,089	33.58	3,978,308
1,760	0.93	250	38,772	36,604,828	0.81	8,929,472	29.77	4,037,178
1,776	0.94	265	40,412	37,696,508	0.83	7,837,792	26.13	4,093,796
1,792	0.95	281	41,164	38,793,631	0.86	6,740,669	22.47	4,148,668
1,808	0.96	296	42,439	39,869,659	0.88	5,664,641	18.89	4,202,937
1,824	0.97	311	44,271	40,954,897	0.91	4,579,403	15.27	4,255,571
1,840	0.97	327	46,198	42,026,214	0.93	3,508,086	11.70	12,976
1,856	0.98	343	47,972	43,108,317	0.95	2,425,983	8.09	65,011
1,872	0.99	357	48,737	44,166,123	0.98	1,368,177	4.56	115,493
1,888	1.00	373	49,395	45,234,366	1.00	299,934	1.00	166,074
1,904	1.01	388	50,266	45,237,049	1.00	297,251	0.99	166,691
1,920	1.02	404	51,015	45,239,437	1.00	294,863	0.98	167,216
1,936	1.03	420	51,786	45,241,581	1.00	292,719	0.98	167,698
1,952	1.03	436	52,607	45,243,430	1.00	290,870	0.97	168,117
1,968	1.04	452	53,416	45,245,920	1.00	288,380	0.96	168,741
1,984	1.05	468	54,226	45,247,692	1.00	286,608	0.96	169,215
2,000	1.06	484	54,990	45,249,287	1.00	285,013	0.95	169,599
2,016	1.07	500	55,693	45,250,712	1.00	283,588	0.95	169,963
2,032	1.08	515	56,496	45,251,869	1.00	282,431	0.94	170,240
2,080	1.10	563	59,010	45,256,622	1.00	277,678	0.93	171,450
2,272	1.20	755	68,886	45,268,101	1.00	266,199	0.89	174,754
2,464	1.31	947	78,652	45,281,571	1.00	252,729	0.84	179,056
2,656	1.41	1,138	88,297	45,283,759	1.00	250,541	0.84	180,180
2,848	1.51	1,329	100,261	45,285,477	1.00	248,823	0.83	181,064
3,040	1.61	1,520	111,741	45,286,851	1.00	247,449	0.83	181,733
3,232	1.71	1,712	126,662	45,288,096	1.00	246,204	0.82	182,332
3,424	1.81	1,904	141,596	45,289,269	1.00	245,031	0.82	182,870
3,616	1.92	2,096	156,066	45,290,392	1.00	243,908	0.81	183,374
3,808	2.02	2,288	169,700	45,291,406	1.00	242,894	0.81	183,848

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
2,000	0.50	20,345,123	7,889,130,490
3,000	0.75	5,643,571	4,509,604,141
4,000	1.00	4,823,977	1,946,731,768
5,000	1.25	4,625,712	1,392,691,907
6,000	1.50	4,605,451	1,392,691,907
7,000	1.75	4,602,074	944,554,254
8,000	2.00	4,602,074	500,310,064

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

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

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

No data exists for this section of the report.

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with 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	Wt Time (s)	Av Wt Time(ms)
CR-Reuse Block Range (block range reuse ckpt)	2,160	2,160	204	21	103.48
RO-Multiple Object Reuse (fast object reuse)	10	10	1	15	14,520.00
KO-Multiple Object Checkpoint (fast object checkpoint)	40	40	4	0	15.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	66.91	71,218	1,165	5	1440/1440	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
17-1月 02:55	11,415	47,079	1,125	4	1,440	0/0	0/0/0/0/0/0
17-1月 02:45	399	5,951	1,165	4	1,440	0/0	0/0/0/0/0/0
17-1月 02:35	23	165	1,129	2	1,440	0/0	0/0/0/0/0/0
17-1月 02:25	685	2,356	527	4	1,440	0/0	0/0/0/0/0/0
17-1月 02:15	51,409	2,033	1,130	5	1,440	0/0	0/0/0/0/0/0
17-1月 02:05	2,981	13,634	560	4	1,440	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	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	2,839	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	57	0.00		0
AWR Alerted Metric Element list	29,784	0.00		0
Change Notification Hash table latch	1,201	0.00		0
Consistent RBA	67,744	0.00	0.00	0
DML lock allocation	393,836	0.00		0
Event Group Locks	135	0.00		0
FAL Queue	150	0.00		0
FIB s.o chain latch	62	0.00		0
FOB s.o list latch	1,964	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	3,465	0.00		1,052	0.00
JS Sh mem access	5	0.00		0
JS mem alloc latch	8	0.00		0
JS queue access latch	9	0.00		0
JS queue state obj latch	21,748	0.00		0
JS slv state obj latch	5	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	1,391	0.00		0
KMG resize request state object freelist	16	0.00		0
KTF sga latch	20	0.00		1,108	0.00
KWQMN job cache list latch	3	0.00		0
KWQP Prop Status	2	0.00		0
KWQS pqsubs latch	3	0.00		0
KWQS pqueue ctx latch	9	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	376	0.00		1,391	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	40	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	373	0.00		0
OS process allocation	7,389	0.00		0
OS process: request allocation	133	0.00		0
PL/SQL warning settings	640	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	460,083	0.00		0
Reserved Space Latch	12	0.00		0
SGA IO buffer pool latch	1,799	0.00		15,440	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	121	0.00		1,200	0.00
SQL memory manager workarea list latch	117,824	0.00	0.00	0
Shared B-Tree	145	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	255,126	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	15,680	0.23	0.00	0
active service list	6,985	0.00		2,163	0.00
alert log latch	6	0.00		0
archive control	193	0.00		0
archive process latch	453	0.00		0
begin backup scn array	2	0.00		0
buffer pool	49	0.00		0
business card	1	0.00		0
cache buffer handles	9,042	0.00		0
cache buffers chains	54,192,886	0.00	0.00	12,374,113	0.00
cache buffers lru chain	376,505	0.02	0.05	9,666,186	0.00
cache table scan latch	39,675	0.00		39,675	0.00
call allocation	3,868	0.00		0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	146	0.00		0
channel operations parent latch	22,883	0.00		0
checkpoint queue latch	1,003,723	0.00	0.00	199,105	0.00
client/application info	494	0.00		0
compile environment latch	68	0.00		0
corrupted undo seg latch	21	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	57	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	57	0.00		0
dml lock allocation	59	0.00		0
done queue latch	1	0.00		0
dummy allocation	138	0.00		0
eighth spare latch - X parent	1	0.00		0
eleventh spare latch - children	1	0.00		0
enqueue freelist latch	1	0.00		68,475	0.00
enqueue hash chains	603,545	0.00		12	0.00
fifteenth spare latch - children	1	0.00		0
file cache latch	2,064	0.00		0
first Audit Vault latch	41	0.00		0
flashback copy	1	0.00		0
fourteenth spare latch - children	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs resource validate list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	0.00		0
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	41	0.00		0
global tx hash mapping	387	0.00		0
granule operation	1	0.00		0
hash table column usage latch	591	0.00		176,545	0.00
hash table modification latch	103	0.00		0
heartbeat check	1	0.00		0
internal temp table object number allocation latch	21	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	3	0.00		2	0.00
job_queue_processes free list latch	8	0.00		0
job_queue_processes parameter latch	784	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	3	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kgnfs mount latch	1	0.00		0
kokc descriptor allocation latch	8	0.00		0
krbmrosl	100	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1	0.00		0
kss move lock	39	0.00		0
ksuosstats global area	364	0.00		0
ksv allocation latch	133	0.00		0
ksv class latch	77	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	133	0.00		0
ktm global data	58	0.00		0
kwqbsn:qsga	131	0.00		0
lgwr LWN SCN	68,484	0.00	0.00	0
list of block allocation	5,711	0.00		0
loader state object freelist	110	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	2	0.00		0
logminer local	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	3	0.00		2	0.00
managed standby latch	147	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	688	0.00		0
messages	287,112	0.02	0.00	0
mostly latch-free SCN	69,038	0.62	0.02	0
msg queue latch	1	0.00		0
multiblock read objects	99,814	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	57	0.00		0
nineth spare latch - X parent	1	0.00		0
object queue header heap	97,478	0.00		71,156	0.00
object queue header operation	14,216,674	0.00	0.00	9,711	0.00
object stats modification	70,479	0.00		0
parallel query alloc buffer	481	0.00		0
parallel query stats	1	0.00		0
parameter list	245	0.00		0
parameter table management	544	0.00		0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	76,493	0.00	0.00	38,035	0.00
process allocation	154	0.00		66	0.00
process group creation	133	0.00		0
process queue	1	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	525	0.00		0
query server freelists	1	0.00		0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	218,210	0.11	0.01	2,829,195	0.00
redo copy	1	0.00		2,829,232	0.01
redo writing	221,064	0.01	0.00	0
reservation so alloc latch	6	0.00		0
resmgr group change latch	46	0.00		0
resmgr:active threads	138	0.00		0
resmgr:actses change group	63	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	137	0.00		0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	81	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	5,355,741	0.01	0.02	12,349	0.05
rules engine rule set statistics	100	0.00		0
second Audit Vault latch	1	0.00		0
sequence cache	250	0.00		0
session allocation	33,826	0.00		33,452	0.00
session idle bit	174,249	0.00		0
session queue latch	1	0.00		0
session state list latch	86	0.00		0
session switching	125	0.00		0
session timer	1,201	0.00		0
seventh spare latch - X parent	1	0.00		0
shared pool	2,527,257	0.00	0.57	3,076	0.03
shared pool sim alloc	1	0.00		0
shared pool simulator	164,571	0.00		0
sim partition latch	2	0.00		2,169	0.00
simulator hash latch	2,810,456	0.00		0
simulator lru latch	118,603	0.02	0.05	1,858,700	0.00
sixth spare latch - X parent	1	0.00		0
sort extent pool	2,354	0.00		0
space background state object latch	8	0.00		0
space background task latch	4,115	0.12	0.00	2,403	0.00
state object free list	12	0.00		0
statistics aggregation	336	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
tenth spare latch - X parent	1	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
thirteenth spare latch - children	1	0.00		0
threshold alerts latch	216	0.00		0
transaction allocation	1,190	0.00		0
transaction branch allocation	1,585	0.00		0
twelfth spare latch - children	1	0.00		0
twenty-fifth spare latch - S par	1	0.00		0
twenty-first spare latch - S par	1	0.00		0
twenty-fourth spare latch - S par	1	0.00		0
twenty-second spare latch - S par	1	0.00		0
twenty-third spare latch - S par	1	0.00		0
undo global data	285,068	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0
write info latch	0			67,737	0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
row cache objects	5,355,741	515	10	505
mostly latch-free SCN	69,038	431	10	421
redo allocation	218,210	241	3	238
shared pool	2,527,257	83	47	43
cache buffers lru chain	376,505	60	3	57
simulator lru latch	118,603	20	1	19

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
cache buffers lru chain	kcbzgws	3	0
lgwr LWN SCN	kcs023	10	0
object queue header operation	kcbo_link_q	1	0
redo allocation	kcrfw_redo_gen: redo allocation 1	3	0
row cache objects	kqreqd: reget	4	0
row cache objects	kqrpre: find obj	2	4
row cache objects	kqreqd	1	0
shared pool	kghalo	43	23
shared pool	kghfrunp: clatch: nowait	2	0
shared pool	kgh_heap_sizes	1	0
shared pool	kghfrunp: alloc: wait	1	0
shared pool	kghfrunp: clatch: wait	1	3
shared pool	kghquiesce_extent choose ds	1	0
shared pool	kghquiesce_extent quiesced if free	1	0
simulator lru latch	kcbs_simulate: simulate set	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kgllkdl1 85	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by 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: 20,092,446
Captured Segments account for 61.9% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
NLPM01	DBS1	TPC_BTX_PK	INDEX	2,825,104	14.06
SYS	SYSTEM	I_HH_OBJ#_INTCOL#	INDEX	1,959,888	9.75
NLPM01	DBS1	TC_BTX_FILE	TABLE	1,162,432	5.79
SYS	SYSTEM	HIST_HEAD$	TABLE	662,496	3.30
SYS	SYSTEM	ICOL$	TABLE	475,600	2.37

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 7,047,541
Captured Segments account for 24.1% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SYS	AUDIT	AUD$		TABLE	85,632	1.22
SYS	SYSAUX	WRH$_SYSSTAT	WRH$_SYSSTA_2076476065_0	TABLE PARTITION	82,308	1.17
SYS	SYSAUX	WRH$_PARAMETER	WRH$_PARAME_2076476065_0	TABLE PARTITION	60,705	0.86
SYS	SYSTEM	ICOL$		TABLE	54,633	0.78
NLPM01	DBS1	TC_BTX_FILE		TABLE	30,727	0.44

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 3,936,745
Captured Segments account for 1.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
SYS	SYSTEM	ICOL$	TABLE	19,445	0.49
NLPM01	DBS1	TC_BTX_FILE	TABLE	15,162	0.39
NLPM01	DBS1	TPC_BTX_PK	INDEX	7,059	0.18
SYS	SYSAUX	I_WRI$_OPTSTAT_IND_OBJ#_ST	INDEX	6,699	0.17
SYS	SYSTEM	HIST_HEAD$	TABLE	2,765	0.07

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 3,936,745
Captured Segments account for 1.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
SYS	SYSTEM	ICOL$	TABLE	19,445	0.49
NLPM01	DBS1	TC_BTX_FILE	TABLE	15,162	0.39
NLPM01	DBS1	TPC_BTX_PK	INDEX	7,059	0.18
SYS	SYSAUX	I_WRI$_OPTSTAT_IND_OBJ#_ST	INDEX	6,699	0.17
SYS	SYSTEM	HIST_HEAD$	TABLE	2,765	0.07

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

Total Direct Physical Reads: 379,404
Captured Segments account for 16.9% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Reads	%Total
SYS	AUDIT	AUD$		TABLE	63,951	16.86

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 497,503
Captured Segments account for 23.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
NLPM01	DBS1	TC_BTX_FILE	TABLE	52,891	10.63
NLPM01	DBS1	TPC_BTX_PK	INDEX	26,178	5.26
NLPM01	TEMPTABS	BIN$YumsyWl7fl3gU6A8qMDOGw==$0	TABLE	11,189	2.25
SYS	SYSAUX	I_WRI$_OPTSTAT_IND_OBJ#_ST	INDEX	9,847	1.98
SYS	SYSTEM	ICOL$	TABLE	8,439	1.70

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 157,766
Captured Segments account for 58.7% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Write Requests	%Total
NLPM01	DBS1	TC_BTX_FILE	TABLE	48,445	30.71
NLPM01	DBS1	TPC_BTX_PK	INDEX	23,896	15.15
SYS	SYSAUX	I_WRI$_OPTSTAT_IND_OBJ#_ST	INDEX	6,464	4.10
NLPM01	TEMPTABS	BIN$YumsyWl7fl3gU6A8qMDOGw==$0	TABLE	5,403	3.42
SYS	SYSTEM	ICOL$	TABLE	3,918	2.48

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 307,412
Captured Segments account for 0.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_2076476065_0	TABLE PARTITION	16	0.01

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 23
Captured Segments account for 95.7% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ1		INDEX	21	91.30
NLPM01	TEMPTABS	BIN$YumsyWl7fl3gU6A8qMDOGw==$0		TABLE	1	4.35

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
NLPM01	DBS1	TC_BTX_FILE	TABLE	1,059,232	39.75
NLPM01	DBS1	TPC_BTX_PK	INDEX	956,128	35.88
SYS	SYSTEM	HIST_HEAD$	TABLE	330,688	12.41
SYS	SYSTEM	ICOL$	TABLE	54,400	2.04
SYS	AUDIT	AUD$	TABLE	53,168	2.00

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

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

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_constraints	1,093	100.00	1,093	1
dc_global_oids	78	2.56	0	21
dc_histogram_data	5,068	0.57	0	346
dc_histogram_defs	430,030	75.79	326,071	127,714
dc_object_grants	174	1.15	0	239
dc_objects	419,436	4.48	211	50,029
dc_profiles	128	0.00	0	2
dc_rollback_segments	3,863	0.00	0	89
dc_segments	115,286	14.73	616	18,355
dc_sequences	5	60.00	5	0
dc_table_scns	202	100.00	0	0
dc_tablespaces	45,602	0.00	0	12
dc_users	203,831	0.02	0	59
global database name	2,460	0.00	0	2
outstanding_alerts	62	16.13	0	10
sch_lj_oids	6	66.67	0	2

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	123	5.69	0		0	0
BODY	87	16.09	367	10.08	21	0
CLUSTER	352	0.28	353	0.28	0	0
DBLINK	129	0.00	0		0	0
EDITION	58	0.00	99	4.04	4	0
INDEX	89,082	20.00	89,084	40.02	13	0
OBJECT ID	1	100.00	0		0	0
QUEUE	2	0.00	723	0.28	2	0
SCHEMA	9,913	0.01	0		0	0
SQL AREA	113,479	5.19	1,561,338	4.67	28,500	45,486
SQL AREA BUILD	1,289	50.04	0		0	0
SQL AREA STATS	33,025	17.60	33,025	17.60	0	0
TABLE/PROCEDURE	90,060	10.92	186,957	25.77	9,713	0
TRIGGER	33,493	0.00	33,493	0.02	6	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)	Oper Count	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	0	STA/
DEFAULT buffer cache	1,520.00	2,000.00	1,520.00	3,120.00	8	SHR/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	0	STA/
PGA Target	2,144.00	2,144.00	2,144.00	2,144.00	0	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	0	STA/
SGA Target	4,000.00	4,000.00	4,000.00	4,000.00	0	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	0	STA/
java pool	16.00	16.00	16.00	64.00	0	SHR/DEF
large pool	32.00	32.00	32.00	32.00	0	STA/
shared pool	2,368.00	1,888.00	720.00	2,368.00	8	GRO/DEF
streams pool	16.00	16.00	16.00	16.00	0	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

Resizes, Grows, Shrinks - Operations captured by AWR if there are operations on the same component for the same operation_type, target_size, and with the same start_time only one operation is captured
ordered by Component

Component	Min Size (Mb)	Max Size (Mb)	Avg Size (Mb)	Re- Sizes	Grows	Shrinks
DEFAULT buffer cache	1,600.00	2,080.00	1,860.00	8	7	1
shared pool	1,808.00	2,288.00	2,028.00	8	1	7

Back to Memory Statistics
Back to Top

Memory Resize Ops

Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred Delta : change in size of the component Target Delta: displayed only if final size <> target_size
Status: COMplete/CANcelled/INActive/PENding/ERRor
ordered by start_time desc,component

Start	Ela (s)	Component	Oper Typ/Mod	Init Size (M)	Delta	Final (M)	Sta
01/17 02:55:46	2	bufcache	SHR/DEF	2,080	-80	2,000	COM
01/17 02:55:46	2	shared	GRO/DEF	1,808	80	1,888	COM
01/17 02:47:46	0	bufcache	GRO/DEF	2,000	80	2,080	COM
01/17 02:47:46	0	shared	SHR/DEF	1,888	-80	1,808	COM
01/17 02:43:16	0	bufcache	GRO/DEF	1,920	80	2,000	COM
01/17 02:43:16	0	shared	SHR/DEF	1,968	-80	1,888	COM
01/17 02:38:46	0	bufcache	GRO/DEF	1,840	80	1,920	COM
01/17 02:38:46	0	shared	SHR/DEF	2,048	-80	1,968	COM
01/17 02:30:45	0	bufcache	GRO/DEF	1,760	80	1,840	COM
01/17 02:30:45	0	shared	SHR/DEF	2,128	-80	2,048	COM
01/17 02:25:45	0	bufcache	GRO/DEF	1,680	80	1,760	COM
01/17 02:25:45	0	shared	SHR/DEF	2,208	-80	2,128	COM
01/17 02:13:14	0	bufcache	GRO/DEF	1,600	80	1,680	COM
01/17 02:13:14	0	shared	SHR/DEF	2,288	-80	2,208	COM
01/17 02:08:43	1	bufcache	GRO/DEF	1,520	80	1,600	COM
01/17 02:08:43	1	shared	SHR/DEF	2,368	-80	2,288	COM

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	231.88		4.46	6.68	27	28	52	52
B	Freeable	84.19	0.00	2.28	5.52	25		37	37
B	PL/SQL	3.07	1.66	0.06	0.19	1	1	52	52
B	SQL	1.89	0.54	0.05	0.06	0	54	36	32
E	Other	230.39		4.52	6.73	27	28	51	51
E	Freeable	82.94	0.00	2.24	5.52	25		37	37
E	PL/SQL	3.04	1.64	0.06	0.19	1	1	51	51
E	SQL	1.87	0.51	0.05	0.06	0	54	35	31

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,593,835,520	2,097,152,000
Fixed Size	2,265,224
Redo Buffers	19,292,160
Variable Size	4,798,287,736	4,294,971,256

Back to Memory Statistics
Back to Top

SGA breakdown difference

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

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	CTWR dba buffer	2.36	2.36	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	17.86	17.86	0.00
large	krcc extent chunk	3.96	3.96	0.00
shared	ASH buffers	32.00	32.00	0.00
shared	KGH: NO ACCESS	95.55	95.55	0.00
shared	KGLH0	323.23	329.64	1.98
shared	KGLHD	45.16	43.10	-4.57
shared	KGLS	145.55	98.11	-32.59
shared	KQR L PO	40.12	48.90	21.90
shared	KQR M PO	59.42	71.51	20.35
shared	SQLA	509.28	44.39	-91.28
shared	db_block_hash_buckets		22.25
shared	free memory	869.80	878.64	1.02
shared	kglsim heap		23.45
shared	kglsim object batch	38.71	38.71	0.00
streams	KTG hash buckets	0.63	0.63	0.00
streams	free memory	15.37	15.37	0.00
	buffer_cache	1,520.00	2,000.00	31.58
	fixed_sga	2.16	2.16	0.00
	log_buffer	18.40	18.40	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	0710 17:16:07	0.08	0.00	0.00
QMON Coordinator	0710 17:15:57	0.06	0.00	0.00

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

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

Queue Name	Enq Msgs	Deq Msgs	%Exp Msgs	%Delay Msgs	Enq Time(s)	Deq Time(s)	%Transf Time	%Eval Time
SYS.ALERT_QUE(13069)	0	0			0.00	0.00
SYS.AQ$_ALERT_QT_E(13068)	0	0			0.00	0.00

Back to Streams Statistics
Back to Top

Persistent Queues Rate

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

Queue Name	Enqueue Msgs/sec	Dequeue Msgs/sec	Avg Enqueue sec / msg	Avg Dequeue sec / msg
SYS.ALERT_QUE(13069)	0.00	0.00
SYS.AQ$_ALERT_QT_E(13068)	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/sec	Dequeue Msgs/sec	Expire Msgs/sec
HAE_SUB(1)/SYS.ALERT_QUE
NGERPDB_3872ITOPPROD(24)/SYS.ALERT_QUE	0.00	0.00	0.00
NGERPDB_3872_ITOPPROD(4)/SYS.ALERT_QUE	0.00	0.00	0.00

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

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

No data exists for this section of the report.

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

No data exists for this section of the report.

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	/u2/oradb/admin/topprod/adump
audit_trail	DB
compatible	11.2.0.4.0
control_files	/u2/oradb/oradata/topprod/control01.ctl, /u2/oradb/oradata/topprod/control02.ctl
db_block_size	8192
db_domain
db_flash_cache_size	0
db_name	topprod
db_recovery_file_dest	/u2/archivelog
db_recovery_file_dest_size	214748364800
deferred_segment_creation	FALSE
diagnostic_dest	/u2/oradb
fast_start_mttr_target	3600
log_archive_dest
log_checkpoints_to_alert	TRUE
memory_target	6442450944
open_cursors	300
plsql_warnings	DISABLE:ALL
processes	900
remote_login_passwordfile	EXCLUSIVE
sessions	1376
undo_retention	86400
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	/u2/oradb/oradata/topprod/control01.ctl
control_files	/u2/oradb/oradata/topprod/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 %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	66.69	In-memory Sort %:	99.97
Library Hit %:	91.47	Soft Parse %:	91.88
Execute to Parse %:	66.38	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	69.18	% Non-Parse CPU:	98.41