WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

M012BAND 209747035 m012band 1 31-Aug-15 14:08 11.2.0.4.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
M012BAND	209747035	m012band	1	31-Aug-15 14:08	11.2.0.4.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

dcrrbap3 HP-UX IA (64-bit) 32 16 2 255.88

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
dcrrbap3	HP-UX IA (64-bit)	32	16	2	255.88

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 11150 31-Aug-15 18:30:01 39 5.4

End Snap: 11151 31-Aug-15 18:50:26 38 4.4

Elapsed: 20.42 (mins)

DB Time: 51.69 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	11150	31-Aug-15 18:30:01	39	5.4
End Snap:	11151	31-Aug-15 18:50:26	38	4.4
Elapsed:		20.42 (mins)
DB Time:		51.69 (mins)

Report Summary

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 2.5 0.1 0.00 0.00

DB CPU(s): 1.8 0.1 0.00 0.00

Redo size (bytes): 15,294,111.5 433,450.4

Logical read (blocks): 96,364.8 2,731.1

Block changes: 17,843.8 505.7

Physical read (blocks): 1,427.7 40.5

Physical write (blocks): 2,059.8 58.4

Read IO requests: 1,427.4 40.5

Write IO requests: 472.5 13.4

Read IO (MB): 11.2 0.3

Write IO (MB): 16.1 0.5

User calls: 26,946.1 763.7

Parses (SQL): 934.5 26.5

Hard parses (SQL): 0.0 0.0

SQL Work Area (MB): 0.3 0.0

Logons: 0.0 0.0

Executes (SQL): 25,948.1 735.4

Rollbacks: 0.0 0.0

Transactions: 35.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	2.5	0.1	0.00	0.00
DB CPU(s):	1.8	0.1	0.00	0.00
Redo size (bytes):	15,294,111.5	433,450.4
Logical read (blocks):	96,364.8	2,731.1
Block changes:	17,843.8	505.7
Physical read (blocks):	1,427.7	40.5
Physical write (blocks):	2,059.8	58.4
Read IO requests:	1,427.4	40.5
Write IO requests:	472.5	13.4
Read IO (MB):	11.2	0.3
Write IO (MB):	16.1	0.5
User calls:	26,946.1	763.7
Parses (SQL):	934.5	26.5
Hard parses (SQL):	0.0	0.0
SQL Work Area (MB):	0.3	0.0
Logons:	0.0	0.0
Executes (SQL):	25,948.1	735.4
Rollbacks:	0.0	0.0
Transactions:	35.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 99.97

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

Library Hit %: 100.01 Soft Parse %: 100.00

Execute to Parse %: 96.40 Latch Hit %: 99.99

Parse CPU to Parse Elapsd %: 77.17 % Non-Parse CPU: 99.60

Top 10 Foreground Events by Total Wait Time

Event	Waits	Total Wait Time (sec)	Wait Avg(ms)	% DB time	Wait Class
DB CPU		2195.3		70.8
db file sequential read	1,748,266	751.4	0	24.2	User I/O
log file sync	43,276	161.1	4	5.2	Commit
SQL*Net message to client	33,008,652	20.8	0	.7	Network
log file switch completion	1,155	12.9	11	.4	Configuration
SQL*Net more data from client	283,318	2	0	.1	Network
cursor: pin S	390	1.4	4	.0	Concurrency
undo segment extension	134	1.2	9	.0	Configuration
log file switch (private strand flush incomplete)	98	1	11	.0	Configuration
SQL*Net more data to client	122,893	.9	0	.0	Network

Wait Classes by Total Wait Time

Wait Class	Waits	Total Wait Time (sec)	Avg Wait (ms)	% DB time	Avg Active Sessions
DB CPU		2,195		70.8	1.8
User I/O	1,766,760	759	0	24.5	0.6
System I/O	110,143	611	6	19.7	0.5
Commit	43,276	161	4	5.2	0.1
Network	33,414,908	24	0	.8	0.0
Configuration	1,397	15	11	.5	0.0
Concurrency	1,016	2	2	.1	0.0
Other	3,548	1	0	.0	0.0

Host CPU

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

32 16 2 0.11 0.10 22.6 5.2 4.4 72.2

CPUs	Cores	Sockets	Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
32	16	2	0.11	0.10	22.6	5.2	4.4	72.2

Instance CPU

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

5.8 20.8 0.0

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

IO Profile

Read+Write Per Second Read per Second Write Per Second

Total Requests: 2,027.5 1,462.0 565.6

Database Requests: 1,899.9 1,427.4 472.5

Optimized Requests: 0.0 0.0 0.0

Redo Requests: 73.2 15.9 57.3

Total (MB): 72.3 26.3 45.9

Database (MB): 27.3 11.2 16.1

Optimized Total (MB): 0.0 0.0 0.0

Redo (MB): 29.7 14.8 14.8

Database (blocks): 3,487.5 1,427.7 2,059.8

Via Buffer Cache (blocks): 3,487.4 1,427.7 2,059.8

Direct (blocks): 0.0 0.0 0.0

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	2,027.5	1,462.0	565.6
Database Requests:	1,899.9	1,427.4	472.5
Optimized Requests:	0.0	0.0	0.0
Redo Requests:	73.2	15.9	57.3
Total (MB):	72.3	26.3	45.9
Database (MB):	27.3	11.2	16.1
Optimized Total (MB):	0.0	0.0	0.0
Redo (MB):	29.7	14.8	14.8
Database (blocks):	3,487.5	1,427.7	2,059.8
Via Buffer Cache (blocks):	3,487.4	1,427.7	2,059.8
Direct (blocks):	0.0	0.0	0.0

Memory Statistics

Begin End

Host Mem (MB): 262,025.0 262,025.0

SGA use (MB): 912.0 912.0

PGA use (MB): 241.9 194.0

% Host Mem used for SGA+PGA: 0.44 0.42

	Begin	End
Host Mem (MB):	262,025.0	262,025.0
SGA use (MB):	912.0	912.0
PGA use (MB):	241.9	194.0
% Host Mem used for SGA+PGA:	0.44	0.42

Cache Sizes

Begin End

Buffer Cache: 448M 448M Std Block Size: 8K

Shared Pool Size: 286M 286M Log Buffer: 16,556K

	Begin	End
Buffer Cache:	448M	448M	Std Block Size:	8K
Shared Pool Size:	286M	286M	Log Buffer:	16,556K

Shared Pool Statistics

Begin End

Memory Usage %: 71.90 71.89

% SQL with executions>1: 79.98 84.42

% Memory for SQL w/exec>1: 69.25 75.92

	Begin	End
Memory Usage %:	71.90	71.89
% SQL with executions>1:	79.98	84.42
% Memory for SQL w/exec>1:	69.25	75.92

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): 3101.4s
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	2,462.40	79.40
DB CPU	2,195.25	70.78
parse time elapsed	13.86	0.45
hard parse elapsed time	0.12	0.00
PL/SQL execution elapsed time	0.05	0.00
connection management call elapsed time	0.04	0.00
DB time	3,101.43
background elapsed time	691.80
background cpu time	67.21

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
AVG_BUSY_TIME	33,969
AVG_IDLE_TIME	88,418
AVG_IOWAIT_TIME	5,389
AVG_SYS_TIME	6,312
AVG_USER_TIME	27,601
BUSY_TIME	1,088,977
IDLE_TIME	2,831,254
IOWAIT_TIME	174,434
SYS_TIME	203,851
USER_TIME	885,126
LOAD	0	0
OS_CPU_WAIT_TIME	15,820,900
VM_IN_BYTES	72,142,848
VM_OUT_BYTES	427,573,248
PHYSICAL_MEMORY_BYTES	274,753,093,632
NUM_CPUS	32
NUM_CPU_CORES	16
NUM_CPU_SOCKETS	2
TCP_RECEIVE_SIZE_DEFAULT	32,768
TCP_RECEIVE_SIZE_MAX	1,073,725,440
TCP_RECEIVE_SIZE_MIN	24,576
TCP_SEND_SIZE_DEFAULT	32,768
TCP_SEND_SIZE_MAX	2,147,483,647

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
31-Aug 18:30:01	0.11
31-Aug 18:50:26	0.10	27.78	22.58	5.20	72.22	4.45

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 101.5% of Total DB time 3,101.43 (s)
Total FG Wait Time: 953.21 (s) DB CPU time: 2,195.25 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			2,195		70.78
User I/O	1,749,062	0	752	0	24.23
Commit	43,276	0	161	4	5.19
Network	33,414,863	0	24	0	0.76
Configuration	1,393	9	15	11	0.49
Concurrency	919	0	1	2	0.05
Other	492	0	0	0	0.01
System I/O	525	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	1,748,266	0	751	0	40.45	24.23
log file sync	43,276	0	161	4	1.00	5.19
SQL*Net message to client	33,008,652	0	21	0	763.68	0.67
log file switch completion	1,155	0	13	11	0.03	0.42
SQL*Net more data from client	283,318	0	2	0	6.55	0.07
cursor: pin S	390	0	1	4	0.01	0.04
undo segment extension	134	94	1	9	0.00	0.04
log file switch (private strand flush incomplete)	98	0	1	11	0.00	0.03
SQL*Net more data to client	122,893	0	1	0	2.84	0.03
reliable message	301	0	0	1	0.01	0.01
control file sequential read	525	0	0	0	0.01	0.00
Disk file operations I/O	769	0	0	0	0.02	0.00
buffer busy waits	391	0	0	0	0.01	0.00
db file scattered read	24	0	0	1	0.00	0.00
enq: US - contention	67	0	0	0	0.00	0.00
latch: In memory undo latch	84	0	0	0	0.00	0.00
latch free	97	0	0	0	0.00	0.00
latch: cache buffers chains	54	0	0	0	0.00	0.00
latch: undo global data	23	0	0	0	0.00	0.00
direct path write	1	0	0	1	0.00	0.00
SQL*Net message from client	33,008,652	0	5,304	0	763.68

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
db file async I/O submit	7,544	0	337	45	0.17	48.70
log file parallel write	43,449	0	138	3	1.01	19.93
Log archive I/O	18,457	0	75	4	0.43	10.86
log file sequential read	19,445	0	50	3	0.45	7.18
control file parallel write	5,895	0	6	1	0.14	0.94
control file sequential read	14,433	0	5	0	0.33	0.66
db file single write	7,854	0	3	0	0.18	0.48
db file sequential read	8,057	0	2	0	0.19	0.34
Disk file operations I/O	1,777	0	1	1	0.04	0.19
reliable message	819	0	0	0	0.02	0.05
os thread startup	5	0	0	45	0.00	0.03
log file single write	394	0	0	0	0.01	0.02
enq: CF - contention	6	0	0	11	0.00	0.01
LGWR wait for redo copy	1,863	0	0	0	0.04	0.01
db file scattered read	10	0	0	1	0.00	0.00
buffer busy waits	90	0	0	0	0.00	0.00
latch: cache buffers lru chain	58	0	0	0	0.00	0.00
latch free	69	0	0	0	0.00	0.00
ARCH wait for archivelog lock	200	0	0	0	0.00	0.00
rdbms ipc message	58,414	11	20,041	343	1.35
DIAG idle wait	2,426	100	2,448	1009	0.06
smon timer	582	0	1,305	2242	0.01
Streams AQ: qmn slave idle wait	44	0	1,233	28018	0.00
Streams AQ: qmn coordinator idle wait	84	52	1,233	14676	0.00
Space Manager: slave idle wait	245	100	1,225	5001	0.01
pmon timer	407	100	1,225	3009	0.01
SQL*Net message from client	60	0	0	1	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ARCH wait for archivelog lock	200	100.0
Disk file operations I/O	2540	91.7	.6	6.1	1.7
LGWR wait for redo copy	1863	99.9	.1
Log archive I/O	18.5K	1.1	.2	60.6	37.7	.4	.0
SQL*Net message to client	33M	100.0	.0
SQL*Net more data from client	283.3K	100.0	.0
SQL*Net more data to client	122.9K	100.0	.0
asynch descriptor resize	21	100.0
buffer busy waits	481	99.6	.2		.2
control file parallel write	5896	60.0	36.6	3.3	.2
control file sequential read	15K	97.0	1.6	1.4	.0
cursor: pin S	389	79.9				7.7	12.3
db file async I/O submit	7544	17.8	7.9	3.4	1.5	2.1	9.5	57.8
db file scattered read	34	91.2	2.9	5.9
db file sequential read	1756.3K	98.1	1.4	.3	.1	.0	.0	.0
db file single write	7854	97.0	2.4	.5	.0
direct path write	1		100.0
enq: CF - contention	6				50.0	16.7	33.3
enq: HW - contention	6	100.0
enq: US - contention	67	100.0
latch free	166	100.0
latch: In memory undo latch	85	100.0
latch: cache buffers chains	54	100.0
latch: cache buffers lru chain	59	100.0
latch: call allocation	1	100.0
latch: checkpoint queue latch	2	100.0
latch: messages	6	100.0
latch: object queue header operation	3	100.0
latch: redo allocation	11	100.0
latch: redo writing	4	100.0
latch: shared pool	1	100.0
latch: undo global data	23	100.0
log file parallel write	43.4K	4.0	11.9	64.2	19.8	.1	.0	.0
log file sequential read	19.4K	6.3	.4	93.0	.2	.1
log file single write	394	98.7	1.3
log file switch (private strand flush incomplete)	97	4.1		3.1	27.8	46.4	18.6
log file switch completion	1154	1.2	2.0	4.4	17.9	58.2	16.2	.1
log file sync	43.3K	.2	5.1	64.3	29.1	1.2	.0	.0
os thread startup	5							100.0
read by other session	2	100.0
reliable message	1120	96.8	2.9				.2	.1
undo segment extension	134	52.2				11.2	36.6
DIAG idle wait	2425							100.0
SQL*Net message from client	33M	99.8	.0	.0	.0	.1	.0	.0	.0
Space Manager: slave idle wait	245								100.0
Streams AQ: qmn coordinator idle wait	84	47.6							52.4
Streams AQ: qmn slave idle wait	44								100.0
class slave wait	5	100.0
pmon timer	407								100.0
rdbms ipc message	58.4K	19.0	2.1	3.9	8.1	14.2	17.5	28.7	6.5
smon timer	582	.2		11.2	5.8	2.1	2.4	56.0	22.3

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s
		% of Total Waits
db file async I/O submit	4358	42.2	21.8	35.6	.4	.0
db file sequential read	1	100.0		.0
log file parallel write	1	100.0	.0
log file switch completion	1	99.9	.1
log file sync	3	100.0	.0
os thread startup	5		100.0
reliable message	1	99.9	.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	3,102	2,195	1,748	118,038
SYS$BACKGROUND	0	0	0	10
dc_m012band	0	0	0	0

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Admin Total Wts	Admin Wt Time	Network Total Wts	Network Wt Time
SYS$USERS	1749045	752	919	1	0	0	33415073	24
SYS$BACKGROUND	17698	7	96	0	0	0	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by 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 71.4% of Total DB Time (s): 3,101
Captured PL/SQL account for 0.1% of Total DB Time (s): 3,101

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
468.99	43,216	0.01	15.12	24.37	76.75	0ah3zch2gb7m1	rtsora@tiger (TNS V1-V3)	select /+ FIRST_ROWS / KEY_1...
389.48	43,207	0.01	12.56	83.46	0.00	chgm78zbffau6	rtsora@tiger (TNS V1-V3)	update INVM set NO_OF_TRNS=:b1...
305.57	3,352,918	0.00	9.85	34.05	66.97	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
117.57	3,899,209	0.00	3.79	85.50	5.77	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
116.17	3,903,101	0.00	3.75	84.11	6.52	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
113.01	3,687,115	0.00	3.64	83.96	9.34	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
108.72	342,149	0.00	3.51	19.20	85.89	6gmuypyrg3bn6	rtsora@tiger (TNS V1-V3)	select STMT_CYCLE , STMT_DAY ,...
89.15	3,572,137	0.00	2.87	91.51	0.00	azkycgjdmsrwb	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DTEP DTEP...
80.40	1,558,179	0.00	2.59	88.02	0.03	a4sny3rp6udxn	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DEPP DEPP...
76.23	4,333,411	0.00	2.46	87.59	0.00	194thqv29qqj0	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(PEOD PEOD...
69.11	1,139,980	0.00	2.23	83.66	0.01	a4b3hyn27yz94	rtsora@tiger (TNS V1-V3)	UPDATE INMB SET TYP1_BAL_13 =...
52.95	1,318,203	0.00	1.71	63.66	31.52	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
48.86	990,735	0.00	1.58	82.27	0.01	b2n6f3czbhugm	rtsora@tiger (TNS V1-V3)	update INDC set TYP1_BAL_01=:b...
44.76	1,321,314	0.00	1.44	86.41	0.14	8rz8u2npd6gj8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(BRHM BRHM...
41.80	990,757	0.00	1.35	62.39	33.77	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...

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

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
325.06	43,207	0.01	14.81	389.48	83.46	0.00	chgm78zbffau6	rtsora@tiger (TNS V1-V3)	update INVM set NO_OF_TRNS=:b1...
114.30	43,216	0.00	5.21	468.99	24.37	76.75	0ah3zch2gb7m1	rtsora@tiger (TNS V1-V3)	select /+ FIRST_ROWS / KEY_1...
104.06	3,352,918	0.00	4.74	305.57	34.05	66.97	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
100.52	3,899,209	0.00	4.58	117.57	85.50	5.77	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
97.72	3,903,101	0.00	4.45	116.17	84.11	6.52	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
94.88	3,687,115	0.00	4.32	113.01	83.96	9.34	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
81.58	3,572,137	0.00	3.72	89.15	91.51	0.00	azkycgjdmsrwb	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DTEP DTEP...
70.77	1,558,179	0.00	3.22	80.40	88.02	0.03	a4sny3rp6udxn	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DEPP DEPP...
66.77	4,333,411	0.00	3.04	76.23	87.59	0.00	194thqv29qqj0	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(PEOD PEOD...
57.82	1,139,980	0.00	2.63	69.11	83.66	0.01	a4b3hyn27yz94	rtsora@tiger (TNS V1-V3)	UPDATE INMB SET TYP1_BAL_13 =...
40.20	990,735	0.00	1.83	48.86	82.27	0.01	b2n6f3czbhugm	rtsora@tiger (TNS V1-V3)	update INDC set TYP1_BAL_01=:b...
38.68	1,321,314	0.00	1.76	44.76	86.41	0.14	8rz8u2npd6gj8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(BRHM BRHM...
33.71	1,318,203	0.00	1.54	52.95	63.66	31.52	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
26.08	990,757	0.00	1.19	41.80	62.39	33.77	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
359.93	43,216	0.01	47.45	468.99	24.37	76.75	0ah3zch2gb7m1	rtsora@tiger (TNS V1-V3)	select /+ FIRST_ROWS / KEY_1...
204.64	3,352,918	0.00	26.98	305.57	34.05	66.97	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
93.39	342,149	0.00	12.31	108.72	19.20	85.89	6gmuypyrg3bn6	rtsora@tiger (TNS V1-V3)	select STMT_CYCLE , STMT_DAY ,...
18.62	252,739	0.00	2.46	28.36	35.47	65.67	26f17py8g4cf8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUEV CUEV...
16.69	1,318,203	0.00	2.20	52.95	63.66	31.52	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
16.25	453,325	0.00	2.14	30.31	42.00	53.61	5n85ndhr736sa	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUSVGG CU...
14.12	990,757	0.00	1.86	41.80	62.39	33.77	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...
10.56	3,687,115	0.00	1.39	113.01	83.96	9.34	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
7.57	3,903,101	0.00	1.00	116.17	84.11	6.52	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
6.79	3,899,209	0.00	0.89	117.57	85.50	5.77	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...

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: 118,045,193
Captured SQL account for 99.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
14,858,826	3,687,115	4.03	12.59	113.01	84	9.3	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
13,433,830	3,352,918	4.01	11.38	305.57	34.1	67	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
12,019,043	3,899,209	3.08	10.18	117.57	85.5	5.8	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
11,821,806	3,903,101	3.03	10.01	116.17	84.1	6.5	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
10,717,251	3,572,137	3.00	9.08	89.15	91.5	0	azkycgjdmsrwb	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DTEP DTEP...
10,562,298	43,207	244.46	8.95	389.48	83.5	0	chgm78zbffau6	rtsora@tiger (TNS V1-V3)	update INVM set NO_OF_TRNS=:b1...
6,383,048	43,216	147.70	5.41	468.99	24.4	76.7	0ah3zch2gb7m1	rtsora@tiger (TNS V1-V3)	select /+ FIRST_ROWS / KEY_1...
6,232,848	1,558,179	4.00	5.28	80.40	88	0	a4sny3rp6udxn	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DEPP DEPP...
5,254,368	1,318,203	3.99	4.45	52.95	63.7	31.5	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
4,710,286	1,139,980	4.13	3.99	69.11	83.7	0	a4b3hyn27yz94	rtsora@tiger (TNS V1-V3)	UPDATE INMB SET TYP1_BAL_13 =...
4,334,133	4,333,411	1.00	3.67	76.23	87.6	0	194thqv29qqj0	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(PEOD PEOD...
4,046,685	990,735	4.08	3.43	48.86	82.3	0	b2n6f3czbhugm	rtsora@tiger (TNS V1-V3)	update INDC set TYP1_BAL_01=:b...
3,964,929	990,757	4.00	3.36	41.80	62.4	33.8	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...
3,963,864	1,321,314	3.00	3.36	44.76	86.4	.1	8rz8u2npd6gj8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(BRHM BRHM...
1,571,464	453,325	3.47	1.33	30.31	42	53.6	5n85ndhr736sa	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUSVGG CU...
1,368,588	342,149	4.00	1.16	108.72	19.2	85.9	6gmuypyrg3bn6	rtsora@tiger (TNS V1-V3)	select STMT_CYCLE , STMT_DAY ,...

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: 1,748,867
Captured SQL account for 99.9% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
822,571	43,216	19.03	47.03	468.99	24.37	76.75	0ah3zch2gb7m1	rtsora@tiger (TNS V1-V3)	select /+ FIRST_ROWS / KEY_1...
475,567	3,352,918	0.14	27.19	305.57	34.05	66.97	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
228,729	342,149	0.67	13.08	108.72	19.20	85.89	6gmuypyrg3bn6	rtsora@tiger (TNS V1-V3)	select STMT_CYCLE , STMT_DAY ,...
43,231	453,325	0.10	2.47	30.31	42.00	53.61	5n85ndhr736sa	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUSVGG CU...
42,784	252,739	0.17	2.45	28.36	35.47	65.67	26f17py8g4cf8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUEV CUEV...
34,527	1,318,203	0.03	1.97	52.95	63.66	31.52	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
32,170	990,757	0.03	1.84	41.80	62.39	33.77	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...
28,157	3,687,115	0.01	1.61	113.01	83.96	9.34	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
18,392	3,899,209	0.00	1.05	117.57	85.50	5.77	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
15,699	3,903,101	0.00	0.90	116.17	84.11	6.52	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...

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: 1,748,511
Captured SQL account for 99.9% of Total
Total UnOptimized Read Requests: 1,748,511
Captured SQL account for 99.9% 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
822,555	822,555	43,216	19.03	47.04	0ah3zch2gb7m1	rtsora@tiger (TNS V1-V3)	select /+ FIRST_ROWS / KEY_1...
474,967	474,967	3,352,918	0.14	27.16	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
228,702	228,702	342,149	0.67	13.08	6gmuypyrg3bn6	rtsora@tiger (TNS V1-V3)	select STMT_CYCLE , STMT_DAY ,...
43,226	43,226	453,325	0.10	2.47	5n85ndhr736sa	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUSVGG CU...
42,781	42,781	252,739	0.17	2.45	26f17py8g4cf8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUEV CUEV...
34,518	34,518	1,318,203	0.03	1.97	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
32,167	32,167	990,757	0.03	1.84	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...
28,125	28,125	3,687,115	0.01	1.61	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
18,371	18,371	3,899,209	0.00	1.05	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
15,688	15,688	3,903,101	0.00	0.90	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...

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: 31,785,981
Captured SQL account for 99.9% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
4,333,411	0	0.00	76.23	87.6	0	194thqv29qqj0	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(PEOD PEOD...
3,903,101	3,679	0.00	116.17	84.1	6.5	d8kta41txhr1m	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
3,899,209	212,069	0.05	117.57	85.5	5.8	cp0camudunxfv	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
3,687,115	3,687,715	1.00	113.01	84	9.3	fu9qbqhb93mrk	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(RIGH RIGH...
3,572,137	3,572,200	1.00	89.15	91.5	0	azkycgjdmsrwb	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DTEP DTEP...
3,352,918	3,352,325	1.00	305.57	34.1	67	9txh4q5gk8jhg	rtsora@tiger (TNS V1-V3)	select TYP1_BAL_13 , TYP1_DYS_...
1,558,179	1,558,073	1.00	80.40	88	0	a4sny3rp6udxn	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(DEPP DEPP...
1,321,314	1,321,226	1.00	44.76	86.4	.1	8rz8u2npd6gj8	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(BRHM BRHM...
1,318,203	1,299,729	0.99	52.95	63.7	31.5	1gvb4h50wyzfm	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INCC INCC...
1,139,980	1,139,921	1.00	69.11	83.7	0	a4b3hyn27yz94	rtsora@tiger (TNS V1-V3)	UPDATE INMB SET TYP1_BAL_13 =...
990,757	990,709	1.00	41.80	62.4	33.8	7zq79azufju9v	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(INDC INDC...
990,735	990,672	1.00	48.86	82.3	0	b2n6f3czbhugm	rtsora@tiger (TNS V1-V3)	update INDC set TYP1_BAL_01=:b...
453,325	211,493	0.47	30.31	42	53.6	5n85ndhr736sa	rtsora@tiger (TNS V1-V3)	select /*+ INDEX_ASC(CUSVGG CU...
342,149	342,142	1.00	108.72	19.2	85.9	6gmuypyrg3bn6	rtsora@tiger (TNS V1-V3)	select STMT_CYCLE , STMT_DAY ,...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 1,144,785
Captured SQL account for 100.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
1,139,961	1,139,980	99.58	a4b3hyn27yz94	rtsora@tiger (TNS V1-V3)	UPDATE INMB SET TYP1_BAL_13 =...
3,103	3,103	0.27	86708bvah4akq		select name from undo$ where f...
160	1	0.01	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
160	439	0.01	3c1kubcdjnppq		update sys.col_usage$ set equa...
95	95	0.01	83p014u4c0d8p	sqlplus@dcrrbap3 (TNS V1-V3)	select last_call_et, sid, seri...
85	85	0.01	g00cj285jmgsw		update sys.mon_mods$ set inser...
78	78	0.01	acpc0qs7aghzd	sqlplus@dcrrbap3 (TNS V1-V3)	select last_call_et, sid, seri...
71	71	0.01	3s58mgk0uy2ws		insert into wrm$_snapshot_deta...
60	60	0.01	cm5vu20fhtnq1		select /*+ connect_by_filterin...
58	58	0.01	37u7sjtnk2j46	sqlplus@dcrrbap3 (TNS V1-V3)	select owner\|\|'.'\|\|object_name...

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

0ah3zch2gb7m1 select /*+ FIRST_ROWS */ KEY_1 , NO_OF_TRNS , SYS , BRANCH_NO , CURR_STATUS , ACCT_TYPE , INT_CAT , INV_TYPE , TRAP , CURRENCY , OWNERSHIP_FLAG , BOOKING_NUMBER , MCURR_ACCT_TYPE , CURR_COND , MSGS_PENDING , CUSTOMER_NO , LAST_DIV_DATE , RESERVED_AMOUNT , ATM_LIMIT_FLAG , CR_LIMIT , DAY_CASH_WDL_VALUE , DAY_CASH_DATE , UNCL_NO_INT_VAL , SOP_BAL , CURR_BAL , UNCL_CHQ_VAL , HOLD_VAL , NPB_VAL , TOM_INT_ACR_CR_AMT , STMT_FREQUENCY , STMT_CYCLE , STMT_DAY , EOM_BAL , LAST_DUES_DATE , WDL_FLAG , CSLD_STMT_PROS , INT_BASIS_MONTH , INT_AVAILABLE , INT_INCR , INT_PROJ , FCC_CI_ADJ_ACCR , DIV1 , DIV2 , DIV3 , DIV4 , DIV5 , ACCT_OPEN_DT , LST_FIN_DT , LST_MNT_DT , INT_FRM_DT , INT_TO_DT , NO_DUES , MON_BAS_INT_DAYS , HOLD_DT , LAST_STAT_DT , PREV_PRD_DR_ADJ , PREV_PRD_COMM_ADJ , STOP_ATM , NO_OF_MESSAGES , FCC_CLUS , FCC_NOM_CURR , NO_OF_HOLDS , NO_OF_NPBS , NO_OF_STOPS , OD_STATUS1 , OD_STATUS2 , OD_STATUS3 , OD_STATUS4 , AGENT_CODE , FCC_PRNC_ACCR , TRF_INST , VAR_INT_RATE , ATM_ACCT_FLAG , VI SA_FLAG , FIL11 , DIAMOND , SIGNATURE_NO , MINOR_AC , TRF_ACCT_SYS , TRF_ACCT_NO , ACCT_IND , CAS_CHQ_STOP_IND , VISA_TYPE , PREV_PRD_CR_ADJ , OD_TOM_INT_ACR_AMT , RVAL_IND , LOANSAVER_IND , INT_ADJUSTMENT , INT_OFFS_TDTE , DR_INT_ADJUSTMENT , DR_INT_OFFS_TDTE , COM_INT_ADJUSTMENT , COM_INT_OFFS_TDTE , OD_VISA_AREA , TOTAL_PENALTY , AV_CL_BAL_CH_PER , MIN_BAL_CH_PER , DATE_IND , MON_BAS_INT_SOP_DT , SP_INT_RATE , RD_INSTL_PNLT_CNT , NET_AV_BAL_YTD , NET_AV_NO_YTD , LST_OVR_LIMIT_DATE , LIM_CNTRL_FLAG_CAP , LST_CUST_CR_DT , LST_CUST_DR_DT , NEG_RATES_FLAG , CR_TIER_GRP_ID , CR_STORE_RATE , GL_CLASS_CODE , INTRO_BROKER_INDIC , TERM_PAY_EOFY , CR_RATE_TYPE , TERM_PAY_FREQUENCY , CHR_EXEM_PROFILE , CHR_CNT01 , CHR_VAL01 , CHR_CNT02 , CHR_VAL02 , CHR_CNT03 , CHR_VAL03 , CHR_CNT04 , CHR_VAL04 , CHR_CNT05 , CHR_VAL05 , CHR_CNT06 , CHR_VAL06 , CHR_CNT07 , CHR_VAL07 , CHR_CNT08 , CHR_VAL08 , CHR_CNT09 , CHR_VAL09 , CHR_CNT10 , CHR_VAL10 , SI_HOLD_AMT , ACCT_STMT_CODE , DRAWING_AMOUNT , SECURITY _AMOUNT , PRD_BAL , NO_OF_EXT , INSL_CNT , EXT_FLAG , PEND_TXN_FOR_STMT , OVERDUE_INSC_NO , SAVP_IND , SP_ACTYPE , SP_INT_FREQ , SP_TERM_LEN , SP_TERM_BASIS , TERM_RECEIPT_NO , TERM_DUP_RCPT_NO , EXT_CR_RATING_CODE , CURR_RENEWAL_DT , ACTUAL_RENEWAL_DT , INSTL_DUE_DAY , EXP_INSTL , INSTL_FREQ , PBOOK_LINE_NO , PBOOK_NO , PBOOK_OVERIDE_REQD , MOD_IND , LINK_ACTYPE , LIFO_FIFO_IND , SWEEP_BALANCE , TERM_INT_COMP_FREQ , TRM_INT_CMP_SOP_DT , TRM_INT_CMP_EOP_DT , TERM_INT_COMP_AMT , COLLECTION_AMT , INSTL_RECEIVED , JDCC_NO , SP_INT_CAT , DR_TXN_AMT , CR_TXN_AMT , UNPD_OD_DR_INT , UNPD_OD_PNLTY_INT , UNPD_CHRG_BAL , OD_PNLTY_INT_INCR , OD_PNLTY_INT_ACCR , LENDING_STATUS , OD_LIM_REDUC_AMT , OD_LIM_REDUC_FREQ , NEXT_LIM_REDUC_DT , CC_LINK , IRREG_CNT , IRREG_CORR_CNT , SP_RD_INSTL_DUE_DT , OD_PNLTY_INT_ADJ , SRD_ACCR_PNLT_AMT , TD_RCPT_PREFIX , TD_DUP_RCPT_PREFIX , INSTL_DPST_FOR_DT , LAST_UNDR_LIMIT_DT , LAST_INT_ARR_DT , LAST_NO_INT_ARR_DT , NEW_BAD_DEBT_IND , OLD_BAD_DEBT_IND , ORI_SECURI TY_VAL , LAST_UNDR_SECUR_DT , LAST_OVER_SECUR_DT , EARL_STOK_CREAT_DT , EARL_STOK_EXP_DT , COM_CHRG_FREQ , OD_NO_OF_DEBITS , UNPD_OD_DR_INT_PY , CUST_NARR_FLAG , DR_INT_COMP_AMT , OPEN_POST_DT , DR_PEN_COMP_AMT , TYPE_OF_GOLD , CUST_EVAL_FLAG , DR_INT_NXT_APPL_DT , DR_INT_APPLN_FREQ , BKDT_INT_ADJ_IND , EXTN_COUNTER , FIL21 , rowid from INVM where KEY_1 between :b1 and :b2

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

194thqv29qqj0 select /*+ INDEX_ASC(PEOD PEODPK) */ * into :b1, :b2, :b3 from PEOD where KEY_1=:b4

1gvb4h50wyzfm select /*+ INDEX_ASC(INCC INCCPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34 from INCC where KEY_1=:b35

26f17py8g4cf8 select /*+ INDEX_ASC(CUEV CUEVPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32 from CUEV where (((INST_NO=:b33 and ACCT_NO=:b34) and SYSTEM=:b35) and FIN_YEAR=:b36)

37u7sjtnk2j46 select owner||'.'||object_name obj , oracle_username||' ('||s.status||')' oruser , os_user_name osuser , machine computer , l.process unix , ''''||s.sid||', '||s.serial#||'''' ss , to_char(s.logon_time, 'yyyy/mm/dd hh24:mi:ss') time from v$locked_object l , dba_objects o , v$session s , v$transaction t , v$rollname r where l.object_id = o.object_id and s.sid=l.session_id and s.taddr=t.addr and t.xidusn=r.usn order by osuser, ss, obj

3c1kubcdjnppq update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln

3s58mgk0uy2ws insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)

5n85ndhr736sa select /*+ INDEX_ASC(CUSVGG CUSVGGPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112 from CUSVGG where KEY_1=:b113

6gmuypyrg3bn6 select STMT_CYCLE , STMT_DAY , STMT_FREQUENCY , CK_CUST_LMT_IND into :b1, :b2, :b3, :b4 from CUSM where (CUST_ACCT_NO=:b5 and SOC_NO=:b6)

7zq79azufju9v select /*+ INDEX_ASC(INDC INDCPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28 from INDC where (INST_NO=:b29 and ACCT_NO=:b30)

83p014u4c0d8p select last_call_et, sid, serial#, executions, row_wait_obj#, event, s.sql_id , substr(sql_text, 1, 40) from v$session s, v$sql q where status='ACTIVE' and s.sql_id(+)=q.sql_id and username is not null order by 1

86708bvah4akq select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1

8rz8u2npd6gj8 select /*+ INDEX_ASC(BRHM BRHMPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182 from BRHM where KEY_1=:b183

9txh4q5gk8jhg select TYP1_BAL_13 , TYP1_DYS_13 , TYP2_BAL_13 , TYP2_DYS_13 , TYP3_BAL_13 , TYP3_DYS_13 into :b1, :b2, :b3, :b4, :b5, :b6 from INMB where (INST_NO=:b7 and ACCT_NO=:b8)

a4b3hyn27yz94 UPDATE INMB SET TYP1_BAL_13 = :b1, TYP2_BAL_13 = :b2, TYP3_BAL_13 = :b3, TYP4_BAL_13 = :b4, TYP1_PREV_BAL_13 = :b5, TYP2_PREV_BAL_13 = :b6, TYP3_PREV_BAL_13 = :b7 WHERE ( INST_NO = :b8 AND ACCT_NO = :b9 )

a4sny3rp6udxn select /*+ INDEX_ASC(DEPP DEPPPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182, :b183, :b184, :b185, :b186, :b187, :b188, :b189, :b190, :b191, :b192, :b193, :b194, :b195, :b196, :b197, :b198, :b199, :b200, :b201, :b202, :b203, :b204, :b205, :b206, :b207, :b208, :b209, :b210, :b211, :b212, :b213, :b214, :b215, :b216, :b217, :b218, :b219, :b220, :b221, :b222, :b223, :b224, :b225, :b226, :b227, :b228, :b229, :b230, :b231, :b232, :b233, :b234, :b235, :b236, :b237, :b238, :b239, :b240, :b241, :b242, :b243, :b244, :b245, :b246, :b247, :b248, :b249, :b250, :b251, :b252, :b253, :b254, :b255, :b256, :b257, :b258, :b259, :b260, :b261, :b262, :b263, :b264, :b265, :b266, :b267, :b268, :b269, :b270, :b271, :b272, :b273, :b274, :b275, :b276, :b277, :b278, :b279, :b280, :b281, :b282, :b283, :b284, :b285, :b286, :b287, :b288, :b289, :b290, :b291, :b292, :b293, :b294, :b295, :b296, :b297, :b298, :b299, :b300, :b301, :b302, :b303, :b304, :b305, :b306, :b307, :b308, :b309, :b310, :b311, :b312, :b313, :b314, :b315, :b316, :b317, :b318, :b319, :b320, :b321, :b322, :b323, :b324, :b325, :b326, :b327, :b328, :b329, :b330, :b331, :b332, :b333, :b334, :b335, :b336, :b337, :b338, :b339, :b340, :b341, :b342, :b343, :b344, :b345, :b346, :b347, :b348, :b349, :b350, :b351, :b352, :b353, :b354, :b355, :b356, :b357, :b358, :b359, :b360, :b361, :b362, :b363, :b364, :b365, :b366, :b367, :b368, :b369, :b370, :b371, :b372, :b373, :b374, :b375, :b376, :b377, :b378, :b379, :b380, :b381, :b382, :b383, :b384, :b385, :b386, :b387, :b388, :b389, :b390, :b391, :b392, :b393, :b394, :b395, :b396, :b397, :b398, :b399, :b400, :b401, :b402, :b403, :b404, :b405, :b406, :b407, :b408, :b409, :b410, :b411, :b412, :b413, :b414, :b415, :b416, :b417, :b418, :b419, :b420, :b421, :b422, :b423, :b424, :b425, :b426, :b427, :b428, :b429, :b430, :b431, :b432, :b433, :b434, :b435, :b436 from DEPP whe re (((INST_NO=:b437 and SYS=:b438) and TYPE=:b439) and INT_CAT=:b440)

acpc0qs7aghzd select last_call_et, sid, serial#, executions, row_wait_obj#, event, s.sql_id , substr(sql_text, 1, 40) from v$session s, v$sql q where status='ACTIVE' and s.sql_id(+)=q.sql_id and username is not null order by 1

azkycgjdmsrwb select /*+ INDEX_ASC(DTEP DTEPPK) */ * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23 from DTEP where (((INST_NO=:b24 and SYST=:b25) and DTEP_ID=:b26) and DATE_YYYYMM=:b27)

b2n6f3czbhugm update INDC set TYP1_BAL_01=:b1, TYP1_BAL_02=:b2, TYP1_BAL_03=:b3, TYP1_BAL_04=:b4, TYP1_BAL_05=:b5, TYP1_BAL_06=:b6, TYP1_BAL_07=:b7, TYP1_BAL_08=:b8, TYP1_BAL_09=:b9, TYP1_BAL_10=:b10, TYP1_BAL_11=:b11, TYP1_BAL_12=:b12, TYP1_BAL_13=:b13, TYP2_BAL_01=:b14, TYP2_BAL_02=:b15, TYP2_BAL_03=:b16, TYP2_BAL_04=:b17, TYP2_BAL_05=:b18, TYP2_BAL_06=:b19, TYP2_BAL_07=:b20, TYP2_BAL_08=:b21, TYP2_BAL_09=:b22, TYP2_BAL_10=:b23, TYP2_BAL_11=:b24, TYP2_BAL_12=:b25, TYP2_BAL_13=:b26 where (INST_NO=:b27 and ACCT_NO=:b28)

chgm78zbffau6 update INVM set NO_OF_TRNS=:b1, CURR_STATUS=:b2, MSGS_PENDING=:b3, LAST_DIV_DATE=:b4, RESERVED_AMOUNT=:b5, DAY_CASH_WDL_VALUE=:b6, DAY_CASH_DATE=:b7, UNCL_NO_INT_VAL=:b8, SOP_BAL=:b9, CURR_BAL=:b10, HOLD_VAL=:b11, NPB_VAL=:b12, TOM_INT_ACR_CR_AMT=:b13, LAST_DUES_DATE=:b14, WDL_FLAG=:b15, CSLD_STMT_PROS=:b16, INT_BASIS_MONTH=:b17, INT_AVAILABLE=:b18, INT_INCR=:b19, INT_PROJ=:b20, FCC_CI_ADJ_ACCR=:b21, DIV1=:b22, DIV2=:b23, DIV3=:b24, DIV4=:b25, DIV5=:b26, LST_FIN_DT=:b27, LST_MNT_DT=:b28, INT_FRM_DT=:b29, INT_TO_DT=:b30, NO_DUES=:b31, MON_BAS_INT_DAYS=:b32, HOLD_DT=:b33, PREV_PRD_DR_ADJ=:b34, PREV_PRD_COMM_ADJ=:b35, NO_OF_MESSAGES=:b36, NO_OF_HOLDS=:b37, NO_OF_NPBS=:b38, OD_STATUS1=:b39, OD_STATUS2=:b40, OD_STATUS3=:b41, OD_STATUS4=:b42, AGENT_CODE=:b43, FCC_PRNC_ACCR=:b44, TRF_INST=:b45, VAR_INT_RATE=:b46, MINOR_AC=:b47, PREV_PRD_CR_ADJ=:b48, OD_TOM_INT_ACR_AMT=:b49, RVAL_IND=:b50, INT_ADJUSTMENT=:b51, INT_OFFS_TDTE=:b52, DR_INT_ADJUSTMENT=:b53, DR_INT_OFFS_TDTE=:b54, COM_INT_ADJUSTMEN T=:b55, COM_INT_OFFS_TDTE=:b56, OD_VISA_AREA=:b57, TOTAL_PENALTY=:b58, MIN_BAL_CH_PER=:b59, DATE_IND=:b60, MON_BAS_INT_SOP_DT=:b61, SP_INT_RATE=:b62, RD_INSTL_PNLT_CNT=:b63, NET_AV_BAL_YTD=:b64, NET_AV_NO_YTD=:b65, LST_OVR_LIMIT_DATE=:b66, LIM_CNTRL_FLAG_CAP=:b67, LST_CUST_CR_DT=:b68, LST_CUST_DR_DT=:b69, CR_STORE_RATE=:b70, GL_CLASS_CODE=:b71, CHR_CNT01=:b72, CHR_VAL01=:b73, CHR_CNT02=:b74, CHR_VAL02=:b75, CHR_CNT03=:b76, CHR_VAL03=:b77, CHR_CNT04=:b78, CHR_VAL04=:b79, CHR_CNT05=:b80, CHR_VAL05=:b81, CHR_CNT06=:b82, CHR_VAL06=:b83, CHR_CNT07=:b84, CHR_VAL07=:b85, CHR_CNT08=:b86, CHR_VAL08=:b87, CHR_CNT09=:b88, CHR_VAL09=:b89, CHR_CNT10=:b90, CHR_VAL10=:b91, DRAWING_AMOUNT=:b92, PRD_BAL=:b93, PEND_TXN_FOR_STMT=:b94, OVERDUE_INSC_NO=:b95, EXT_CR_RATING_CODE=:b96, CURR_RENEWAL_DT=:b97, ACTUAL_RENEWAL_DT=:b98, LINK_ACTYPE=:b99, TERM_INT_COMP_FREQ=:b100, TRM_INT_CMP_SOP_DT=:b101, TRM_INT_CMP_EOP_DT=:b102, TERM_INT_COMP_AMT=:b103, COLLECTION_AMT=:b104, SP_INT_CAT=:b105, DR_TXN_AMT=:b106, CR _TXN_AMT=:b107, UNPD_OD_DR_INT=:b108, UNPD_OD_PNLTY_INT=:b109, UNPD_CHRG_BAL=:b110, OD_PNLTY_INT_INCR=:b111, OD_PNLTY_INT_ACCR=:b112, LENDING_STATUS=:b113, OD_LIM_REDUC_AMT=:b114, NEXT_LIM_REDUC_DT=:b115, IRREG_CNT=:b116, IRREG_CORR_CNT=:b117, SP_RD_INSTL_DUE_DT=:b118, OD_PNLTY_INT_ADJ=:b119, SRD_ACCR_PNLT_AMT=:b120, TD_RCPT_PREFIX=:b121, TD_DUP_RCPT_PREFIX=:b122, INSTL_DPST_FOR_DT=:b123, LAST_UNDR_LIMIT_DT=:b124, LAST_INT_ARR_DT=:b125, LAST_NO_INT_ARR_DT=:b126, NEW_BAD_DEBT_IND=:b127, OLD_BAD_DEBT_IND=:b128, ORI_SECURITY_VAL=:b129, LAST_UNDR_SECUR_DT=:b130, LAST_OVER_SECUR_DT=:b131, EARL_STOK_CREAT_DT=:b132, EARL_STOK_EXP_DT=:b133, COM_CHRG_FREQ=:b134, OD_NO_OF_DEBITS=:b135, UNPD_OD_DR_INT_PY=:b136, CUST_NARR_FLAG=:b137, DR_INT_COMP_AMT=:b138, DR_PEN_COMP_AMT=:b139, DR_INT_NXT_APPL_DT=:b140, DR_INT_APPLN_FREQ=:b141, BKDT_INT_ADJ_IND=:b142 where rowid =:b143

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

cp0camudunxfv select /*+ INDEX_ASC(RIGH RIGHPK) */ * from RIGH where ((KEY_1=:b1 and CHNG_DATE>:b2) and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc

d8kta41txhr1m select /*+ INDEX_ASC(RIGH RIGHPK) */ * from RIGH where (((KEY_1=:b1 and CHNG_DATE=:b2) and CHNG_TIME>:b3) and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc

fu9qbqhb93mrk select /*+ INDEX_ASC(RIGH RIGHPK) */ * from RIGH where (KEY_1>:b1 and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc

g00cj285jmgsw update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

SQL Id	SQL Text
0ah3zch2gb7m1	select /+ FIRST_ROWS / KEY_1 , NO_OF_TRNS , SYS , BRANCH_NO , CURR_STATUS , ACCT_TYPE , INT_CAT , INV_TYPE , TRAP , CURRENCY , OWNERSHIP_FLAG , BOOKING_NUMBER , MCURR_ACCT_TYPE , CURR_COND , MSGS_PENDING , CUSTOMER_NO , LAST_DIV_DATE , RESERVED_AMOUNT , ATM_LIMIT_FLAG , CR_LIMIT , DAY_CASH_WDL_VALUE , DAY_CASH_DATE , UNCL_NO_INT_VAL , SOP_BAL , CURR_BAL , UNCL_CHQ_VAL , HOLD_VAL , NPB_VAL , TOM_INT_ACR_CR_AMT , STMT_FREQUENCY , STMT_CYCLE , STMT_DAY , EOM_BAL , LAST_DUES_DATE , WDL_FLAG , CSLD_STMT_PROS , INT_BASIS_MONTH , INT_AVAILABLE , INT_INCR , INT_PROJ , FCC_CI_ADJ_ACCR , DIV1 , DIV2 , DIV3 , DIV4 , DIV5 , ACCT_OPEN_DT , LST_FIN_DT , LST_MNT_DT , INT_FRM_DT , INT_TO_DT , NO_DUES , MON_BAS_INT_DAYS , HOLD_DT , LAST_STAT_DT , PREV_PRD_DR_ADJ , PREV_PRD_COMM_ADJ , STOP_ATM , NO_OF_MESSAGES , FCC_CLUS , FCC_NOM_CURR , NO_OF_HOLDS , NO_OF_NPBS , NO_OF_STOPS , OD_STATUS1 , OD_STATUS2 , OD_STATUS3 , OD_STATUS4 , AGENT_CODE , FCC_PRNC_ACCR , TRF_INST , VAR_INT_RATE , ATM_ACCT_FLAG , VI SA_FLAG , FIL11 , DIAMOND , SIGNATURE_NO , MINOR_AC , TRF_ACCT_SYS , TRF_ACCT_NO , ACCT_IND , CAS_CHQ_STOP_IND , VISA_TYPE , PREV_PRD_CR_ADJ , OD_TOM_INT_ACR_AMT , RVAL_IND , LOANSAVER_IND , INT_ADJUSTMENT , INT_OFFS_TDTE , DR_INT_ADJUSTMENT , DR_INT_OFFS_TDTE , COM_INT_ADJUSTMENT , COM_INT_OFFS_TDTE , OD_VISA_AREA , TOTAL_PENALTY , AV_CL_BAL_CH_PER , MIN_BAL_CH_PER , DATE_IND , MON_BAS_INT_SOP_DT , SP_INT_RATE , RD_INSTL_PNLT_CNT , NET_AV_BAL_YTD , NET_AV_NO_YTD , LST_OVR_LIMIT_DATE , LIM_CNTRL_FLAG_CAP , LST_CUST_CR_DT , LST_CUST_DR_DT , NEG_RATES_FLAG , CR_TIER_GRP_ID , CR_STORE_RATE , GL_CLASS_CODE , INTRO_BROKER_INDIC , TERM_PAY_EOFY , CR_RATE_TYPE , TERM_PAY_FREQUENCY , CHR_EXEM_PROFILE , CHR_CNT01 , CHR_VAL01 , CHR_CNT02 , CHR_VAL02 , CHR_CNT03 , CHR_VAL03 , CHR_CNT04 , CHR_VAL04 , CHR_CNT05 , CHR_VAL05 , CHR_CNT06 , CHR_VAL06 , CHR_CNT07 , CHR_VAL07 , CHR_CNT08 , CHR_VAL08 , CHR_CNT09 , CHR_VAL09 , CHR_CNT10 , CHR_VAL10 , SI_HOLD_AMT , ACCT_STMT_CODE , DRAWING_AMOUNT , SECURITY _AMOUNT , PRD_BAL , NO_OF_EXT , INSL_CNT , EXT_FLAG , PEND_TXN_FOR_STMT , OVERDUE_INSC_NO , SAVP_IND , SP_ACTYPE , SP_INT_FREQ , SP_TERM_LEN , SP_TERM_BASIS , TERM_RECEIPT_NO , TERM_DUP_RCPT_NO , EXT_CR_RATING_CODE , CURR_RENEWAL_DT , ACTUAL_RENEWAL_DT , INSTL_DUE_DAY , EXP_INSTL , INSTL_FREQ , PBOOK_LINE_NO , PBOOK_NO , PBOOK_OVERIDE_REQD , MOD_IND , LINK_ACTYPE , LIFO_FIFO_IND , SWEEP_BALANCE , TERM_INT_COMP_FREQ , TRM_INT_CMP_SOP_DT , TRM_INT_CMP_EOP_DT , TERM_INT_COMP_AMT , COLLECTION_AMT , INSTL_RECEIVED , JDCC_NO , SP_INT_CAT , DR_TXN_AMT , CR_TXN_AMT , UNPD_OD_DR_INT , UNPD_OD_PNLTY_INT , UNPD_CHRG_BAL , OD_PNLTY_INT_INCR , OD_PNLTY_INT_ACCR , LENDING_STATUS , OD_LIM_REDUC_AMT , OD_LIM_REDUC_FREQ , NEXT_LIM_REDUC_DT , CC_LINK , IRREG_CNT , IRREG_CORR_CNT , SP_RD_INSTL_DUE_DT , OD_PNLTY_INT_ADJ , SRD_ACCR_PNLT_AMT , TD_RCPT_PREFIX , TD_DUP_RCPT_PREFIX , INSTL_DPST_FOR_DT , LAST_UNDR_LIMIT_DT , LAST_INT_ARR_DT , LAST_NO_INT_ARR_DT , NEW_BAD_DEBT_IND , OLD_BAD_DEBT_IND , ORI_SECURI TY_VAL , LAST_UNDR_SECUR_DT , LAST_OVER_SECUR_DT , EARL_STOK_CREAT_DT , EARL_STOK_EXP_DT , COM_CHRG_FREQ , OD_NO_OF_DEBITS , UNPD_OD_DR_INT_PY , CUST_NARR_FLAG , DR_INT_COMP_AMT , OPEN_POST_DT , DR_PEN_COMP_AMT , TYPE_OF_GOLD , CUST_EVAL_FLAG , DR_INT_NXT_APPL_DT , DR_INT_APPLN_FREQ , BKDT_INT_ADJ_IND , EXTN_COUNTER , FIL21 , rowid from INVM where KEY_1 between :b1 and :b2
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)
194thqv29qqj0	select /+ INDEX_ASC(PEOD PEODPK) / * into :b1, :b2, :b3 from PEOD where KEY_1=:b4
1gvb4h50wyzfm	select /+ INDEX_ASC(INCC INCCPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34 from INCC where KEY_1=:b35
26f17py8g4cf8	select /+ INDEX_ASC(CUEV CUEVPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32 from CUEV where (((INST_NO=:b33 and ACCT_NO=:b34) and SYSTEM=:b35) and FIN_YEAR=:b36)
37u7sjtnk2j46	select owner\|\|'.'\|\|object_name obj , oracle_username\|\|' ('\|\|s.status\|\|')' oruser , os_user_name osuser , machine computer , l.process unix , ''''\|\|s.sid\|\|', '\|\|s.serial#\|\|'''' ss , to_char(s.logon_time, 'yyyy/mm/dd hh24:mi:ss') time from v$locked_object l , dba_objects o , v$session s , v$transaction t , v$rollname r where l.object_id = o.object_id and s.sid=l.session_id and s.taddr=t.addr and t.xidusn=r.usn order by osuser, ss, obj
3c1kubcdjnppq	update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln
3s58mgk0uy2ws	insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3)
5n85ndhr736sa	select /+ INDEX_ASC(CUSVGG CUSVGGPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112 from CUSVGG where KEY_1=:b113
6gmuypyrg3bn6	select STMT_CYCLE , STMT_DAY , STMT_FREQUENCY , CK_CUST_LMT_IND into :b1, :b2, :b3, :b4 from CUSM where (CUST_ACCT_NO=:b5 and SOC_NO=:b6)
7zq79azufju9v	select /+ INDEX_ASC(INDC INDCPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28 from INDC where (INST_NO=:b29 and ACCT_NO=:b30)
83p014u4c0d8p	select last_call_et, sid, serial#, executions, row_wait_obj#, event, s.sql_id , substr(sql_text, 1, 40) from v$session s, v$sql q where status='ACTIVE' and s.sql_id(+)=q.sql_id and username is not null order by 1
86708bvah4akq	select name from undo$ where file#=:1 and block#=:2 and ts#=:3 and status$ != 1
8rz8u2npd6gj8	select /+ INDEX_ASC(BRHM BRHMPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182 from BRHM where KEY_1=:b183
9txh4q5gk8jhg	select TYP1_BAL_13 , TYP1_DYS_13 , TYP2_BAL_13 , TYP2_DYS_13 , TYP3_BAL_13 , TYP3_DYS_13 into :b1, :b2, :b3, :b4, :b5, :b6 from INMB where (INST_NO=:b7 and ACCT_NO=:b8)
a4b3hyn27yz94	UPDATE INMB SET TYP1_BAL_13 = :b1, TYP2_BAL_13 = :b2, TYP3_BAL_13 = :b3, TYP4_BAL_13 = :b4, TYP1_PREV_BAL_13 = :b5, TYP2_PREV_BAL_13 = :b6, TYP3_PREV_BAL_13 = :b7 WHERE ( INST_NO = :b8 AND ACCT_NO = :b9 )
a4sny3rp6udxn	select /+ INDEX_ASC(DEPP DEPPPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23, :b24, :b25, :b26, :b27, :b28, :b29, :b30, :b31, :b32, :b33, :b34, :b35, :b36, :b37, :b38, :b39, :b40, :b41, :b42, :b43, :b44, :b45, :b46, :b47, :b48, :b49, :b50, :b51, :b52, :b53, :b54, :b55, :b56, :b57, :b58, :b59, :b60, :b61, :b62, :b63, :b64, :b65, :b66, :b67, :b68, :b69, :b70, :b71, :b72, :b73, :b74, :b75, :b76, :b77, :b78, :b79, :b80, :b81, :b82, :b83, :b84, :b85, :b86, :b87, :b88, :b89, :b90, :b91, :b92, :b93, :b94, :b95, :b96, :b97, :b98, :b99, :b100, :b101, :b102, :b103, :b104, :b105, :b106, :b107, :b108, :b109, :b110, :b111, :b112, :b113, :b114, :b115, :b116, :b117, :b118, :b119, :b120, :b121, :b122, :b123, :b124, :b125, :b126, :b127, :b128, :b129, :b130, :b131, :b132, :b133, :b134, :b135, :b136, :b137, :b138, :b139, :b140, :b141, :b142, :b143, :b144, :b145, :b146, :b147, :b148, :b149, :b150, :b151, :b152, :b153, :b154, :b155, :b156, :b157, :b158, :b159, :b160, :b161, :b162, :b163, :b164, :b165, :b166, :b167, :b168, :b169, :b170, :b171, :b172, :b173, :b174, :b175, :b176, :b177, :b178, :b179, :b180, :b181, :b182, :b183, :b184, :b185, :b186, :b187, :b188, :b189, :b190, :b191, :b192, :b193, :b194, :b195, :b196, :b197, :b198, :b199, :b200, :b201, :b202, :b203, :b204, :b205, :b206, :b207, :b208, :b209, :b210, :b211, :b212, :b213, :b214, :b215, :b216, :b217, :b218, :b219, :b220, :b221, :b222, :b223, :b224, :b225, :b226, :b227, :b228, :b229, :b230, :b231, :b232, :b233, :b234, :b235, :b236, :b237, :b238, :b239, :b240, :b241, :b242, :b243, :b244, :b245, :b246, :b247, :b248, :b249, :b250, :b251, :b252, :b253, :b254, :b255, :b256, :b257, :b258, :b259, :b260, :b261, :b262, :b263, :b264, :b265, :b266, :b267, :b268, :b269, :b270, :b271, :b272, :b273, :b274, :b275, :b276, :b277, :b278, :b279, :b280, :b281, :b282, :b283, :b284, :b285, :b286, :b287, :b288, :b289, :b290, :b291, :b292, :b293, :b294, :b295, :b296, :b297, :b298, :b299, :b300, :b301, :b302, :b303, :b304, :b305, :b306, :b307, :b308, :b309, :b310, :b311, :b312, :b313, :b314, :b315, :b316, :b317, :b318, :b319, :b320, :b321, :b322, :b323, :b324, :b325, :b326, :b327, :b328, :b329, :b330, :b331, :b332, :b333, :b334, :b335, :b336, :b337, :b338, :b339, :b340, :b341, :b342, :b343, :b344, :b345, :b346, :b347, :b348, :b349, :b350, :b351, :b352, :b353, :b354, :b355, :b356, :b357, :b358, :b359, :b360, :b361, :b362, :b363, :b364, :b365, :b366, :b367, :b368, :b369, :b370, :b371, :b372, :b373, :b374, :b375, :b376, :b377, :b378, :b379, :b380, :b381, :b382, :b383, :b384, :b385, :b386, :b387, :b388, :b389, :b390, :b391, :b392, :b393, :b394, :b395, :b396, :b397, :b398, :b399, :b400, :b401, :b402, :b403, :b404, :b405, :b406, :b407, :b408, :b409, :b410, :b411, :b412, :b413, :b414, :b415, :b416, :b417, :b418, :b419, :b420, :b421, :b422, :b423, :b424, :b425, :b426, :b427, :b428, :b429, :b430, :b431, :b432, :b433, :b434, :b435, :b436 from DEPP whe re (((INST_NO=:b437 and SYS=:b438) and TYPE=:b439) and INT_CAT=:b440)
acpc0qs7aghzd	select last_call_et, sid, serial#, executions, row_wait_obj#, event, s.sql_id , substr(sql_text, 1, 40) from v$session s, v$sql q where status='ACTIVE' and s.sql_id(+)=q.sql_id and username is not null order by 1
azkycgjdmsrwb	select /+ INDEX_ASC(DTEP DTEPPK) / * into :b1, :b2, :b3, :b4, :b5, :b6, :b7, :b8, :b9, :b10, :b11, :b12, :b13, :b14, :b15, :b16, :b17, :b18, :b19, :b20, :b21, :b22, :b23 from DTEP where (((INST_NO=:b24 and SYST=:b25) and DTEP_ID=:b26) and DATE_YYYYMM=:b27)
b2n6f3czbhugm	update INDC set TYP1_BAL_01=:b1, TYP1_BAL_02=:b2, TYP1_BAL_03=:b3, TYP1_BAL_04=:b4, TYP1_BAL_05=:b5, TYP1_BAL_06=:b6, TYP1_BAL_07=:b7, TYP1_BAL_08=:b8, TYP1_BAL_09=:b9, TYP1_BAL_10=:b10, TYP1_BAL_11=:b11, TYP1_BAL_12=:b12, TYP1_BAL_13=:b13, TYP2_BAL_01=:b14, TYP2_BAL_02=:b15, TYP2_BAL_03=:b16, TYP2_BAL_04=:b17, TYP2_BAL_05=:b18, TYP2_BAL_06=:b19, TYP2_BAL_07=:b20, TYP2_BAL_08=:b21, TYP2_BAL_09=:b22, TYP2_BAL_10=:b23, TYP2_BAL_11=:b24, TYP2_BAL_12=:b25, TYP2_BAL_13=:b26 where (INST_NO=:b27 and ACCT_NO=:b28)
chgm78zbffau6	update INVM set NO_OF_TRNS=:b1, CURR_STATUS=:b2, MSGS_PENDING=:b3, LAST_DIV_DATE=:b4, RESERVED_AMOUNT=:b5, DAY_CASH_WDL_VALUE=:b6, DAY_CASH_DATE=:b7, UNCL_NO_INT_VAL=:b8, SOP_BAL=:b9, CURR_BAL=:b10, HOLD_VAL=:b11, NPB_VAL=:b12, TOM_INT_ACR_CR_AMT=:b13, LAST_DUES_DATE=:b14, WDL_FLAG=:b15, CSLD_STMT_PROS=:b16, INT_BASIS_MONTH=:b17, INT_AVAILABLE=:b18, INT_INCR=:b19, INT_PROJ=:b20, FCC_CI_ADJ_ACCR=:b21, DIV1=:b22, DIV2=:b23, DIV3=:b24, DIV4=:b25, DIV5=:b26, LST_FIN_DT=:b27, LST_MNT_DT=:b28, INT_FRM_DT=:b29, INT_TO_DT=:b30, NO_DUES=:b31, MON_BAS_INT_DAYS=:b32, HOLD_DT=:b33, PREV_PRD_DR_ADJ=:b34, PREV_PRD_COMM_ADJ=:b35, NO_OF_MESSAGES=:b36, NO_OF_HOLDS=:b37, NO_OF_NPBS=:b38, OD_STATUS1=:b39, OD_STATUS2=:b40, OD_STATUS3=:b41, OD_STATUS4=:b42, AGENT_CODE=:b43, FCC_PRNC_ACCR=:b44, TRF_INST=:b45, VAR_INT_RATE=:b46, MINOR_AC=:b47, PREV_PRD_CR_ADJ=:b48, OD_TOM_INT_ACR_AMT=:b49, RVAL_IND=:b50, INT_ADJUSTMENT=:b51, INT_OFFS_TDTE=:b52, DR_INT_ADJUSTMENT=:b53, DR_INT_OFFS_TDTE=:b54, COM_INT_ADJUSTMEN T=:b55, COM_INT_OFFS_TDTE=:b56, OD_VISA_AREA=:b57, TOTAL_PENALTY=:b58, MIN_BAL_CH_PER=:b59, DATE_IND=:b60, MON_BAS_INT_SOP_DT=:b61, SP_INT_RATE=:b62, RD_INSTL_PNLT_CNT=:b63, NET_AV_BAL_YTD=:b64, NET_AV_NO_YTD=:b65, LST_OVR_LIMIT_DATE=:b66, LIM_CNTRL_FLAG_CAP=:b67, LST_CUST_CR_DT=:b68, LST_CUST_DR_DT=:b69, CR_STORE_RATE=:b70, GL_CLASS_CODE=:b71, CHR_CNT01=:b72, CHR_VAL01=:b73, CHR_CNT02=:b74, CHR_VAL02=:b75, CHR_CNT03=:b76, CHR_VAL03=:b77, CHR_CNT04=:b78, CHR_VAL04=:b79, CHR_CNT05=:b80, CHR_VAL05=:b81, CHR_CNT06=:b82, CHR_VAL06=:b83, CHR_CNT07=:b84, CHR_VAL07=:b85, CHR_CNT08=:b86, CHR_VAL08=:b87, CHR_CNT09=:b88, CHR_VAL09=:b89, CHR_CNT10=:b90, CHR_VAL10=:b91, DRAWING_AMOUNT=:b92, PRD_BAL=:b93, PEND_TXN_FOR_STMT=:b94, OVERDUE_INSC_NO=:b95, EXT_CR_RATING_CODE=:b96, CURR_RENEWAL_DT=:b97, ACTUAL_RENEWAL_DT=:b98, LINK_ACTYPE=:b99, TERM_INT_COMP_FREQ=:b100, TRM_INT_CMP_SOP_DT=:b101, TRM_INT_CMP_EOP_DT=:b102, TERM_INT_COMP_AMT=:b103, COLLECTION_AMT=:b104, SP_INT_CAT=:b105, DR_TXN_AMT=:b106, CR _TXN_AMT=:b107, UNPD_OD_DR_INT=:b108, UNPD_OD_PNLTY_INT=:b109, UNPD_CHRG_BAL=:b110, OD_PNLTY_INT_INCR=:b111, OD_PNLTY_INT_ACCR=:b112, LENDING_STATUS=:b113, OD_LIM_REDUC_AMT=:b114, NEXT_LIM_REDUC_DT=:b115, IRREG_CNT=:b116, IRREG_CORR_CNT=:b117, SP_RD_INSTL_DUE_DT=:b118, OD_PNLTY_INT_ADJ=:b119, SRD_ACCR_PNLT_AMT=:b120, TD_RCPT_PREFIX=:b121, TD_DUP_RCPT_PREFIX=:b122, INSTL_DPST_FOR_DT=:b123, LAST_UNDR_LIMIT_DT=:b124, LAST_INT_ARR_DT=:b125, LAST_NO_INT_ARR_DT=:b126, NEW_BAD_DEBT_IND=:b127, OLD_BAD_DEBT_IND=:b128, ORI_SECURITY_VAL=:b129, LAST_UNDR_SECUR_DT=:b130, LAST_OVER_SECUR_DT=:b131, EARL_STOK_CREAT_DT=:b132, EARL_STOK_EXP_DT=:b133, COM_CHRG_FREQ=:b134, OD_NO_OF_DEBITS=:b135, UNPD_OD_DR_INT_PY=:b136, CUST_NARR_FLAG=:b137, DR_INT_COMP_AMT=:b138, DR_PEN_COMP_AMT=:b139, DR_INT_NXT_APPL_DT=:b140, DR_INT_APPLN_FREQ=:b141, BKDT_INT_ADJ_IND=:b142 where rowid =:b143
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cp0camudunxfv	select /+ INDEX_ASC(RIGH RIGHPK) / * from RIGH where ((KEY_1=:b1 and CHNG_DATE>:b2) and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc
d8kta41txhr1m	select /+ INDEX_ASC(RIGH RIGHPK) / * from RIGH where (((KEY_1=:b1 and CHNG_DATE=:b2) and CHNG_TIME>:b3) and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc
fu9qbqhb93mrk	select /+ INDEX_ASC(RIGH RIGHPK) / * from RIGH where (KEY_1>:b1 and ROWNUM<2) order by KEY_1 asc , CHNG_DATE asc , CHNG_TIME asc
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn

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	21,858,399	17,843.84	505.71
execute count	31,785,981	25,948.10	735.40
logons cumulative	20	0.02	0.00
opened cursors cumulative	5,104	4.17	0.12
parse count (total)	1,144,785	934.53	26.49
parse time elapsed	1,130	0.92	0.03
physical reads	1,748,867	1,427.67	40.46
physical writes	2,523,206	2,059.79	58.38
redo size	18,735,026,632	15,294,111.54	433,450.40
session cursor cache hits	357,867	292.14	8.28
session logical reads	118,045,193	96,364.76	2,731.07
user calls	33,008,547	26,946.13	763.68
user commits	43,223	35.28	1.00
user rollbacks	0	0.00	0.00
workarea executions - optimal	1,092	0.89	0.03

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	0	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	0	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	0	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	70	0.06	0.00
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	181,057	147.80	4.19
CPU used when call started	180,943	147.71	4.19
CR blocks created	250	0.20	0.01
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	136	0.11	0.00
DBWR checkpoint buffers written	49,376	40.31	1.14
DBWR checkpoints	197	0.16	0.00
DBWR object drop buffers written	0	0.00	0.00
DBWR revisited being-written buffer	32	0.03	0.00
DBWR thread checkpoint buffers written	49,374	40.31	1.14
DBWR transaction table writes	356	0.29	0.01
DBWR undo block writes	1,347,622	1,100.11	31.18
DFO trees parallelized	0	0.00	0.00
HSC Heap Segment Block Changes	10,202,082	8,328.35	236.03
Heap Segment Array Inserts	89	0.07	0.00
Heap Segment Array Updates	4	0.00	0.00
IMU CR rollbacks	1	0.00	0.00
IMU Flushes	37,258	30.42	0.86
IMU Redo allocation size	2,204,876,568	1,799,924.22	51,011.65
IMU commits	77	0.06	0.00
IMU contention	4,284	3.50	0.10
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	5,888	4.81	0.14
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	2,171,279,912	1,772,498.00	50,234.36
IMU- failed to get a private strand	5,888	4.81	0.14
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
Parallel operations not downgraded	0	0.00	0.00
Requests to/from client	33,008,206	26,945.85	763.67
RowCR - row contention	57	0.05	0.00
RowCR attempts	1,191,144	972.38	27.56
RowCR hits	1,184,848	967.24	27.41
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	580	0.47	0.01
SQL*Net roundtrips to/from client	33,008,192	26,945.84	763.67
SQL*Net roundtrips to/from dblink	0	0.00	0.00
active txn count during cleanout	19,018	15.53	0.44
auto extends on undo tablespace	4	0.00	0.00
background checkpoints completed	189	0.15	0.00
background checkpoints started	197	0.16	0.00
background timeouts	6,935	5.66	0.16
buffer is not pinned count	73,856,856	60,292.15	1,708.74
buffer is pinned count	13,098,861	10,693.10	303.05
bytes received via SQL*Net from client	5,666,839,680	4,626,055.77	131,107.04
bytes received via SQL*Net from dblink	0	0.00	0.00
bytes sent via SQL*Net to client	12,963,555,765	10,582,641.36	299,922.63
bytes sent via SQL*Net to dblink	0	0.00	0.00
calls to get snapshot scn: kcmgss	35,690,947	29,135.87	825.74
calls to kcmgas	74,618	60.91	1.73
calls to kcmgcs	10,968	8.95	0.25
cell physical IO interconnect bytes	92,832,016,384	75,782,289.54	2,147,745.79
change write time	10,114	8.26	0.23
cleanout - number of ktugct calls	19,863	16.21	0.46
cleanouts and rollbacks - consistent read gets	6	0.00	0.00
cleanouts only - consistent read gets	609	0.50	0.01
cluster key scan block gets	513	0.42	0.01
cluster key scans	476	0.39	0.01
commit batch performed	0	0.00	0.00
commit batch requested	0	0.00	0.00
commit batch/immediate performed	0	0.00	0.00
commit batch/immediate requested	0	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	901	0.74	0.02
commit cleanout failures: callback failure	6	0.00	0.00
commit cleanout failures: cannot pin	70	0.06	0.00
commit cleanouts	1,774,234	1,448.37	41.05
commit cleanouts successfully completed	1,773,257	1,447.58	41.03
commit immediate performed	0	0.00	0.00
commit immediate requested	0	0.00	0.00
commit txn count during cleanout	945	0.77	0.02
consistent changes	14	0.01	0.00
consistent gets	104,817,486	85,566.48	2,425.04
consistent gets - examination	78,374,857	63,980.36	1,813.27
consistent gets direct	0	0.00	0.00
consistent gets from cache	104,817,486	85,566.48	2,425.04
cursor authentications	56	0.05	0.00
data blocks consistent reads - undo records applied	9	0.01	0.00
db block gets	13,227,692	10,798.27	306.03
db block gets direct	14	0.01	0.00
db block gets from cache	13,227,678	10,798.25	306.03
deferred (CURRENT) block cleanout applications	956,585	780.90	22.13
dirty buffers inspected	1,059,722	865.09	24.52
drop segment calls in space pressure	3,054	2.49	0.07
enqueue conversions	56,512	46.13	1.31
enqueue releases	341,572	278.84	7.90
enqueue requests	341,580	278.84	7.90
enqueue timeouts	12	0.01	0.00
enqueue waits	79	0.06	0.00
file io service time	1,026,513	837.98	23.75
free buffer inspected	3,366,262	2,748.01	77.88
free buffer requested	3,106,992	2,536.36	71.88
global undo segment hints helped	9	0.01	0.00
global undo segment hints were stale	28	0.02	0.00
heap block compress	634,784	518.20	14.69
hot buffers moved to head of LRU	226,632	185.01	5.24
immediate (CR) block cleanout applications	615	0.50	0.01
immediate (CURRENT) block cleanout applications	105	0.09	0.00
index crx upgrade (positioned)	0	0.00	0.00
index fast full scans (direct read)	0	0.00	0.00
index fast full scans (full)	0	0.00	0.00
index fast full scans (rowid ranges)	0	0.00	0.00
index fetch by key	20,182,352	16,475.62	466.94
index scans kdiixs1	11,562,675	9,439.05	267.51
leaf node 90-10 splits	19	0.02	0.00
leaf node splits	26	0.02	0.00
lob writes	19	0.02	0.00
lob writes unaligned	19	0.02	0.00
local undo segment hints helped	81	0.07	0.00
logical read bytes from cache	967,025,950,720	789,419,894.58	22,372,948.45
max cf enq hold time	5	0.00	0.00
messages received	57,291	46.77	1.33
messages sent	57,291	46.77	1.33
min active SCN optimization applied on CR	15,841	12.93	0.37
no work - consistent read gets	23,651,777	19,307.84	547.20
non-idle wait count	35,390,597	28,890.68	818.79
parse count (describe)	0	0.00	0.00
parse count (failures)	0	0.00	0.00
parse count (hard)	12	0.01	0.00
parse time cpu	872	0.71	0.02
physical read IO requests	1,748,511	1,427.38	40.45
physical read bytes	14,326,718,464	11,695,442.68	331,460.53
physical read total IO requests	1,790,862	1,461.95	41.43
physical read total bytes	33,839,429,632	27,624,407.55	782,903.31
physical read total multi block requests	18,646	15.22	0.43
physical reads cache	1,748,867	1,427.67	40.46
physical reads cache prefetch	356	0.29	0.01
physical reads direct	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	578,798	472.49	13.39
physical write bytes	20,670,103,552	16,873,788.09	478,220.01
physical write total IO requests	692,832	565.58	16.03
physical write total bytes	58,992,586,752	48,157,881.99	1,364,842.49
physical write total multi block requests	152,208	124.25	3.52
physical writes direct	14	0.01	0.00
physical writes from cache	2,523,192	2,059.78	58.38
physical writes non checkpoint	2,453,006	2,002.48	56.75
pinned buffers inspected	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	1	0.00	0.00
queries parallelized	0	0.00	0.00
recursive calls	86,629	70.72	2.00
recursive cpu usage	685	0.56	0.02
redo KB read	18,598,866	15,182.96	430.30
redo blocks checksummed by FG (exclusive)	13,396,358	10,935.95	309.94
redo blocks written	18,620,728	15,200.81	430.81
redo buffer allocation retries	1,281	1.05	0.03
redo entries	8,272,720	6,753.33	191.40
redo log space requests	2,092	1.71	0.05
redo ordering marks	25,992	21.22	0.60
redo size for direct writes	115,248	94.08	2.67
redo subscn max counts	35,494	28.98	0.82
redo synch long waits	58	0.05	0.00
redo synch time	16,142	13.18	0.37
redo synch time (usec)	161,422,313	131,775.15	3,734.64
redo synch time overhead (usec)	1,227,821	1,002.32	28.41
redo synch time overhead count (<128 msec)	0	0.00	0.00
redo synch time overhead count (<2 msec)	43,289	35.34	1.00
redo synch time overhead count (<32 msec)	10	0.01	0.00
redo synch time overhead count (<8 msec)	34	0.03	0.00
redo synch time overhead count (>=128 msec)	0	0.00	0.00
redo synch writes	43,339	35.38	1.00
redo wastage	34,092,368	27,830.89	788.76
redo write info find	43,333	35.37	1.00
redo write time	13,833	11.29	0.32
redo writes	43,449	35.47	1.01
rollback changes - undo records applied	0	0.00	0.00
rollbacks only - consistent read gets	0	0.00	0.00
rows fetched via callback	11,606,378	9,474.73	268.52
session connect time	0	0.00	0.00
shared hash latch upgrades - no wait	3,644,585	2,975.21	84.32
shared hash latch upgrades - wait	1,008	0.82	0.02
sorts (memory)	834	0.68	0.02
sorts (rows)	11,492	9.38	0.27
space was found by tune down	3,052	2.49	0.07
sql area evicted	8	0.01	0.00
sql area purged	0	0.00	0.00
steps of tune down ret. in space pressure	3,052	2.49	0.07
summed dirty queue length	868,808	709.24	20.10
switch current to new buffer	7	0.01	0.00
table fetch by rowid	21,471,821	17,528.26	496.77
table fetch continued row	25,897	21.14	0.60
table scan blocks gotten	24,286	19.83	0.56
table scan rows gotten	2,238,834	1,827.64	51.80
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	3,327	2.72	0.08
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	15,883	12.97	0.37
total number of cf enq holders	1,118	0.91	0.03
total number of times SMON posted	581	0.47	0.01
transaction rollbacks	0	0.00	0.00
tune down retentions in space pressure	3,052	2.49	0.07
undo change vector size	8,943,898,112	7,301,242.64	206,924.51
user logons cumulative	15	0.01	0.00
user logouts cumulative	16	0.01	0.00
write clones created in background	9	0.01	0.00
write clones created in foreground	4,186	3.42	0.10

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	39	38
opened cursors current	211	167
session cursor cache count	112,012	112,102
session pga memory	172,257,240	171,756,320
session pga memory max	189,706,872	190,909,888
session uga memory	5,686,660,488	5,689,222,776
session uga memory max	27,076,060,536	27,091,158,456

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)	197	578.95

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

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

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	18.1G	31.73	15.17M	17.9G	30.93	14.952M	72.8K	1.52
DBWR	0M	0.00	0M	19.3G	472.49	16.092M	7544	44.08
LGWR	25M	2.85	.02M	17.8G	62.16	14.88M	94.7K	2.45
Buffer Cache Reads	13.3G	1427.19	11.152M	0M	0.00	0M	1748.3K	0.03
Direct Writes	0M	0.00	0M	0M	0.00	0M	1	1.00
Streams AQ	0M	0.00	0M	0M	0.00	0M	4	0.00
TOTAL:	31.5G	1461.77	26.342M	54.9G	565.58	45.924M	1923.4K	0.38

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
Log File	17.7G	15.87	14.829M	17.8G	57.33	14.843M	0.00	2.19
Data File	13.4G	1433.73	11.193M	19.3G	478.90	16.139M	0.03	1.67
Archive Log	0M	0.00	0M	17.7G	14.91	14.827M
Control File	381M	12.21	.311M	138M	14.44	.113M	0.01	1.50
Temp File	0M	0.00	0M	0M	0.00	0M	0.00
TOTAL:	31.5G	1461.82	26.333M	54.9G	565.58	45.921M	0.03	2.18

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	18.1G	31.73	15.17M	17.9G	30.93	14.952M	46.7K	0.88
Others (Log File)	17.7G	15.55	14.828M	0M	0.00	0M	19.1K	2.10
Others (Archive Log)	0M	0.00	0M	17.7G	14.91	14.827M	0
Others (Control File)	357M	9.69	.291M	92M	9.61	.075M	11.9K	0.06
Others (Data File)	62M	6.49	.051M	61M	6.41	.05M	15.8K	0.03
DBWR	0M	0.00	0M	19.3G	472.49	16.092M	0
DBWR (Data File)	0M	0.00	0M	19.3G	472.49	16.092M	0
LGWR	25M	2.85	.02M	17.8G	62.16	14.88M	3880	0.00
LGWR (Log File)	0M	0.32	0M	17.8G	57.33	14.843M	788	0.01
LGWR (Control File)	25M	2.52	.02M	46M	4.83	.038M	3092	0.00
Buffer Cache Reads	13.3G	1427.19	11.152M	0M	0.00	0M	1748.3K	0.03
Buffer Cache Reads (Data File)	13.3G	1427.19	11.152M	0M	0.00	0M	1748.3K	0.03
Streams AQ	0M	0.00	0M	0M	0.00	0M	4	0.00
Streams AQ (Data File)	0M	0.00	0M	0M	0.00	0M	4	0.00
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
Direct Writes (Data File)	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	31.5G	1461.76	26.342M	54.9G	565.58	45.924M	1798.9K	0.05

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 avg/s	Buffer Waits	Av Buf Wt(ms)
TBMISC	1,602,635	1,308	0.43	1.00	322,932	1308.29	264	120	0.17
TSUNDO_01	81	0	0.37	1.00	255,407	0.07	208	386	0.08
TBINDX	144,991	118	0.43	1.00	29	118.36	0	0	0.00
SYSAUX	357	0	0.50	1.00	397	0.29	0	0	0.00
SYSTEM	300	0	0.50	2.19	16	0.22	0	0	0.00
TEMP	2	0	0.00	1.00	1	0.00	0	0	0.00

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	Buffer Waits	Av Buf Wt(ms)
SYSAUX	/oradata_m012band/m012band_SYSAUX_001.dbf	357	0	0.50	1.00	0	0.48	397	0	0	0.00
SYSTEM	/oradata_m012band/m012band_SYSTEM_001.dbf	300	0	0.50	2.19	0	0.49	16	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_001.dbf	11,088	9	0.43	1.00	9	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_002.dbf	7,315	6	0.43	1.00	6	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_003.dbf	4,759	4	0.43	1.00	4	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_004.dbf	4,316	4	0.44	1.00	4	0.44	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_005.dbf	6,710	5	0.41	1.00	5	0.41	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_006.dbf	7,986	7	0.40	1.00	7	0.40	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_007.dbf	4,922	4	0.43	1.00	4	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_008.dbf	4,790	4	0.43	1.00	4	0.43	2	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_009.dbf	4,351	4	0.44	1.00	4	0.45	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_010.dbf	4,706	4	0.44	1.00	4	0.44	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_011.dbf	4,850	4	0.42	1.00	4	0.42	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_012.dbf	5,000	4	0.42	1.00	4	0.42	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_013.dbf	4,953	4	0.43	1.00	4	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_014.dbf	5,233	4	0.43	1.00	4	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_015.dbf	5,140	4	0.42	1.00	4	0.41	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_016.dbf	4,357	4	0.44	1.00	4	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_017.dbf	263	0	0.53	1.00	0	0.53	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_018.dbf	5,328	4	0.39	1.00	4	0.39	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_019.dbf	3,176	3	0.39	1.00	3	0.39	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_020.dbf	5,562	5	0.42	1.00	5	0.42	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_021.dbf	7,756	6	0.45	1.00	6	0.45	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_022.dbf	7,027	6	0.43	1.00	6	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_023.dbf	5,196	4	0.41	1.00	4	0.41	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_024.dbf	4,822	4	0.50	1.00	4	0.50	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_025.dbf	6,860	6	0.42	1.00	6	0.42	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_026.dbf	8,525	7	0.43	1.00	7	0.43	1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_027.dbf	0	0			0		1	0	0	0.00
TBINDX	/oradata_m012band/m012band_TBINDX_028.dbf	0	0			0		1	0	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_001.dbf	40,137	33	0.42	1.00	33	0.42	7,597	6	3	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_002.dbf	40,784	33	0.42	1.00	33	0.42	7,955	6	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_003.dbf	41,315	34	0.43	1.00	34	0.43	7,344	6	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_004.dbf	49,755	41	0.43	1.00	41	0.43	10,228	8	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_005.dbf	43,802	36	0.42	1.00	36	0.42	8,992	7	2	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_006.dbf	41,896	34	0.42	1.00	34	0.42	7,541	6	3	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_007.dbf	41,385	34	0.42	1.00	34	0.42	8,328	7	3	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_008.dbf	35,753	29	0.43	1.00	29	0.43	5,808	5	2	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_009.dbf	43,207	35	0.42	1.00	35	0.42	8,504	7	4	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_010.dbf	34,468	28	0.43	1.00	28	0.43	6,043	5	5	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_011.dbf	29,840	24	0.45	1.00	24	0.45	4,594	4	4	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_012.dbf	30,693	25	0.42	1.00	25	0.42	4,829	4	2	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_013.dbf	32,040	26	0.42	1.00	26	0.42	5,419	4	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_014.dbf	31,845	26	0.41	1.00	26	0.41	5,164	4	2	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_015.dbf	31,778	26	0.41	1.00	26	0.41	5,464	4	3	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_016.dbf	33,799	28	0.41	1.00	28	0.41	5,440	4	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_017.dbf	33,325	27	0.41	1.00	27	0.41	5,325	4	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_018.dbf	38,486	31	0.40	1.00	31	0.40	6,054	5	2	5.00
TBMISC	/oradata_m012band/m012band_TBMISC_019.dbf	40,352	33	0.44	1.00	33	0.44	5,833	5	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_020.dbf	39,201	32	0.41	1.00	32	0.41	6,905	6	4	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_021.dbf	38,459	31	0.42	1.00	31	0.42	7,186	6	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_022.dbf	37,417	31	0.43	1.00	31	0.43	6,985	6	4	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_023.dbf	173,424	142	0.43	1.00	142	0.43	42,930	35	8	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_024.dbf	7,212	6	0.43	1.00	6	0.43	1,854	2	12	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_025.dbf	73,169	60	0.42	1.00	60	0.42	17,351	14	14	0.71
TBMISC	/oradata_m012band/m012band_TBMISC_026.dbf	150,542	123	0.42	1.00	123	0.42	41,946	34	12	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_027.dbf	112,016	91	0.41	1.00	91	0.41	30,822	25	5	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_028.dbf	2,998	2	0.50	1.00	2	0.50	65	0	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_029.dbf	11,402	9	0.47	1.00	9	0.47	2,050	2	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_030.dbf	12,754	10	0.45	1.00	10	0.45	1,618	1	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_031.dbf	7,884	6	0.40	1.00	6	0.40	173	0	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_032.dbf	3,917	3	0.40	1.00	3	0.40	190	0	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_033.dbf	11,126	9	0.58	1.00	9	0.58	1,583	1	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_034.dbf	22,252	18	0.58	1.00	18	0.58	2,844	2	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_035.dbf	9,626	8	0.58	1.00	8	0.58	986	1	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_036.dbf	1,491	1	0.44	1.00	1	0.44	44	0	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_037.dbf	10,006	8	0.47	1.00	8	0.47	1,783	1	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_038.dbf	33,401	27	0.47	1.00	27	0.47	5,429	4	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_039.dbf	4,889	4	0.46	1.00	4	0.46	1,022	1	2	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_040.dbf	15,491	13	0.43	1.00	13	0.43	4,248	3	6	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_041.dbf	13,010	11	0.43	1.00	11	0.43	1,695	1	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_042.dbf	11,384	9	0.43	1.00	9	0.43	3,212	3	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_043.dbf	13,003	11	0.41	1.00	11	0.41	1,470	1	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_044.dbf	14,440	12	0.41	1.00	12	0.41	1,929	2	1	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_045.dbf	19,621	16	0.48	1.00	16	0.48	3,413	3	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_046.dbf	14,263	12	0.42	1.00	12	0.42	1,944	2	2	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_047.dbf	16,905	14	0.45	1.00	14	0.45	3,712	3	3	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_048.dbf	0	0			0		1	0	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_049.dbf	0	0			0		1	0	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_050.dbf	6,672	5	0.72	1.00	5	0.72	1,078	1	0	0.00
TBMISC	/oradata_m012band/m012band_TBMISC_051.dbf	0	0			0		1	0	0	0.00
TEMP	/oradata_m012band/m012band_TEMP_001.dbf	2	0	0.00	1.00	0	0.00	1	0	0
TSUNDO_01	/oradata_m012band/m012band_TSUNDO_01_001.dbf	81	0	0.37	1.00	0	0.37	255,407	208	386	0.08

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	55,132	99	118,026,205	1,748,816	2,523,192	0	0	506

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 2,523,206

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	49,374	0	0	2	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	11	431	1175	2183	746496	2183
E	0	47	10929	742472	746496	746496	1125873

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	32	0.07	4	1.21	7,769	1	3207.00
D	64	0.14	8	1.13	7,231	1	2981.00
D	96	0.21	12	1.09	6,992	1	2880.00
D	128	0.29	16	1.07	6,844	1	2818.00
D	160	0.36	20	1.05	6,739	1	2774.00
D	192	0.43	24	1.04	6,662	1	2742.00
D	224	0.50	28	1.03	6,604	1	2717.00
D	256	0.57	32	1.02	6,558	1	2698.00
D	288	0.64	35	1.02	6,520	1	2682.00
D	320	0.71	39	1.01	6,490	1	2669.00
D	352	0.79	43	1.01	6,464	1	2658.00
D	384	0.86	47	1.01	6,441	1	2649.00
D	416	0.93	51	1.00	6,422	1	2641.00
D	448	1.00	55	1.00	6,405	1	2633.00
D	480	1.07	59	1.00	6,389	1	2627.00
D	512	1.14	63	1.00	6,374	1	2621.00
D	544	1.21	67	0.99	6,359	1	2614.00
D	576	1.29	71	0.99	6,346	1	2609.00
D	608	1.36	75	0.99	6,333	1	2603.00
D	640	1.43	79	0.99	6,320	1	2598.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	303	0

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
2K	4K	794	794
64K	128K	4	4
256K	512K	2	2
512K	1024K	221	221
1M	2M	68	68
2M	4M	1	1
4M	8M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

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

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
78	0.13	863.93	32.85	96.00	7	1,344
156	0.25	863.93	32.85	96.00	5	1,344
312	0.50	863.93	0.00	100.00	0	1,294
468	0.75	863.93	0.00	100.00	0	1,294
624	1.00	863.93	0.00	100.00	0	1,294
749	1.20	863.93	0.00	100.00	0	1,294
874	1.40	863.93	0.00	100.00	0	1,294
998	1.60	863.93	0.00	100.00	0	1,294
1,123	1.80	863.93	0.00	100.00	0	1,294
1,248	2.00	863.93	0.00	100.00	0	1,294
1,872	3.00	863.93	0.00	100.00	0	1,294
2,496	4.00	863.93	0.00	100.00	0	1,294
3,744	6.00	863.93	0.00	100.00	0	1,294
4,992	8.00	863.93	0.00	100.00	0	1,294

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)
352	1.00	45	2,548	202,491	1.00	63	1.00	34,617
368	1.05	61	3,550	202,491	1.00	63	1.00	34,617
384	1.09	74	4,279	202,491	1.00	63	1.00	34,617
400	1.14	74	4,279	202,491	1.00	63	1.00	34,617
416	1.18	74	4,279	202,491	1.00	63	1.00	34,617
432	1.23	74	4,279	202,491	1.00	63	1.00	34,617
448	1.27	74	4,279	202,491	1.00	63	1.00	34,617
464	1.32	74	4,279	202,491	1.00	63	1.00	34,617
480	1.36	74	4,279	202,491	1.00	63	1.00	34,617
496	1.41	74	4,279	202,491	1.00	63	1.00	34,617
544	1.55	74	4,279	202,491	1.00	63	1.00	34,617
592	1.68	74	4,279	202,491	1.00	63	1.00	34,617
640	1.82	74	4,279	202,491	1.00	63	1.00	34,617
688	1.95	74	4,279	202,491	1.00	63	1.00	34,617
736	2.09	74	4,279	202,491	1.00	63	1.00	34,617

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
684	0.75	10,603	6,573,907
912	1.00	10,532	6,404,196
1,140	1.25	10,503	6,335,031
1,368	1.50	10,503	6,335,031
1,596	1.75	10,503	6,335,031
1,824	2.00	10,503	6,335,031

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
undo header	365	0	0
data block	120	0	0
file header block	21	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Av Wt Time(ms)
CF-Controlfile Transaction	3,240	3,231	9	6	11.67
US-Undo Segment	51,015	51,015	0	67	0.18
HW-Segment High Water Mark	106,601	106,602	0	6	0.17

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
1	1,350.15	43,969	1,007	9	5.3/5.6	0/0	2/0/0/3096/120952/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
31-Aug 18:47	698,074	22,403	900	9	5	0/0	1/0/0/2298/66056/0
31-Aug 18:37	652,073	21,566	1,007	9	6	0/0	1/0/0/798/54896/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,116	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	19	0.00		0
AWR Alerted Metric Element list	9,844	0.00		0
Change Notification Hash table latch	408	0.00		0
Consistent RBA	43,670	0.01	0.33	0
DML lock allocation	9,049,882	0.00	0.00	0
Event Group Locks	89	0.00		0
FAL Queue	442	0.00		0
FIB s.o chain latch	1,188	0.00		0
FOB s.o list latch	2,722	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	2,186,856	0.01	0.34	43,296	0.00
JS Sh mem access	1	0.00		0
JS queue access latch	1	0.00		0
JS slv state obj latch	1	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	407	0.00		0
KTF sga latch	7	0.00		409	0.00
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			24	0.00
Memory Management Latch	1	0.00		407	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	14	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	253	0.00		0
OS process allocation	2,535	0.08	0.00	0
OS process: request allocation	89	0.00		0
PL/SQL warning settings	100	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	11,360	0.00		0
SGA IO buffer pool latch	17,884	0.02	0.00	17,937	0.06
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	41	0.00		404	0.00
SQL memory manager workarea list latch	27,932	0.00		0
Shared B-Tree	45	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
Undo Hint Latch	0			6,177	0.00
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	15,442	2.31	0.15	0
active service list	863	0.35	0.00	1,322	0.00
alert log latch	394	0.00		0
archive control	612	0.00		0
archive process latch	1,523	0.33	0.80	0
begin backup scn array	1	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	26	0.00		0
cache buffers chains	207,687,996	0.01	0.00	3,107,288	0.00
cache buffers lru chain	2,571,802	0.06	0.04	5,623,461	0.09
cache table scan latch	34	0.00		34	0.00
call allocation	256	2.34	0.17	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	106	0.94	0.00	0
channel operations parent latch	18,666	0.00		0
checkpoint queue latch	3,345,335	0.01	0.00	2,529,538	0.01
client/application info	111	0.00		0
compile environment latch	68	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	19	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	19	0.00		0
dml lock allocation	19	0.00		0
done queue latch	1	0.00		0
dummy allocation	138	2.90	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		336,679	0.00
enqueue hash chains	739,852	0.01	0.00	0
enqueues	106	0.00		0
fifteenth spare latch - children	1	0.00		0
file cache latch	2,658	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 tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	184	0.00		1,621	0.00
hash table modification latch	1	0.00		0
heartbeat check	1	0.00		0
interrupt manipulation	96	3.13	0.00	0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	1	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	197	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	4	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	1	0.00		0
kss move lock	11	0.00		0
ksuosstats global area	125	0.00		0
ksv allocation latch	39	0.00		0
ksv class latch	21	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	89	1.12	0.00	0
ktm global data	2,336	0.00		0
kwqbsn:qsga	44	0.00		0
lgwr LWN SCN	43,716	0.07	0.00	0
list of block allocation	52,985	0.01	0.00	0
loader state object freelist	2	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	5	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	1	0.00		0
logminer local	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
managed standby latch	245	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	3,376	0.00		0
messages	189,804	0.10	0.03	0
mostly latch-free SCN	49,195	9.08	0.02	0
msg queue latch	1	0.00		0
multiblock read objects	72	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	19	0.00		0
nineth spare latch - X parent	1	0.00		0
object queue header heap	121,445	0.00		5,728	0.00
object queue header operation	13,914,301	0.03	0.00	0
object stats modification	44	0.00		0
parallel query alloc buffer	321	0.00		0
parallel query stats	1	0.00		0
parameter list	39	0.00		0
parameter table management	362	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	67,043	0.00	0.00	45,923	0.02
process allocation	94	2.13	0.00	20	0.00
process group creation	89	0.00		0
process queue	49	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	179	5.59	0.70	0
query server freelists	49	0.00		0
query server process	48	0.00		48	0.00
queued dump request	4	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	298,430	0.99	0.00	8,268,999	0.38
redo copy	1	0.00		8,273,637	0.03
redo writing	174,197	0.40	0.01	0
resmgr group change latch	15	0.00		0
resmgr:active threads	138	0.00		0
resmgr:actses change group	21	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	137	2.92	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	1	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	596,249	0.26	0.00	40	0.00
second Audit Vault latch	1	0.00		0
sequence cache	57	0.00		0
session allocation	45,683	0.00		45,554	0.00
session idle bit	66,063,381	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	110	2.73	0.00	0
session switching	89	0.00		0
session timer	407	0.00		0
seventh spare latch - X parent	1	0.00		0
shared pool	43,097	0.17	0.01	0
shared pool sim alloc	1	0.00		0
shared pool simulator	59	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	17,525,753	0.00	0.00	0
simulator lru latch	1,349,683	0.08	0.00	15,833,918	0.93
sixth spare latch - X parent	1	0.00		0
sort extent pool	607	0.00		0
space background state object latch	4	0.00		0
space background task latch	1,310	0.00		815	0.00
state object free list	2	0.00		0
statistics aggregation	336	0.00		0
tablespace key chain	1	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	50	0.00		0
transaction allocation	4,201,500	0.00	0.00	1	0.00
transaction branch allocation	407	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	3,525,850	0.08	0.01	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			43,646	0.00

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	207,687,996	21,965	54	21,911
object queue header operation	13,914,301	4,547	3	4,544
mostly latch-free SCN	49,195	4,467	96	4,371
redo allocation	298,430	2,962	11	2,951
undo global data	3,525,850	2,730	23	2,707
cache buffers lru chain	2,571,802	1,460	59	1,401
simulator lru latch	1,349,683	1,068	4	1,064
redo writing	174,197	692	4	688
checkpoint queue latch	3,345,335	464	2	462
active checkpoint queue latch	15,442	357	54	303
In memory undo latch	2,186,856	253	85	168
messages	189,804	182	6	176
shared pool	43,097	74	1	73
qmn task queue latch	179	10	7	3
call allocation	256	6	1	5
archive process latch	1,523	5	4	1
Consistent RBA	43,670	3	1	2

Back to Latch Statistics
Back to Top

Latch Miss Sources

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

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	ktiFlush: child	80	8
In memory undo latch	ktiFlushMe	8	2
In memory undo latch	kticflush_2	4	0
active checkpoint queue latch	kcbbacq: scan active checkpoints	52	54
active checkpoint queue latch	kcbkcpa: Checkpoint post-processing	2	0
archive process latch	kcrrsarc	4	0
cache buffers chains	kcbgtcr: fast path	67	127
cache buffers chains	kcbnew: new latch again	23	0
cache buffers chains	kcbgtcr_2	18	1
cache buffers chains	kcbgtcr: kslbegin shared	16	0
cache buffers chains	kcbzgb: scan from tail. nowait	2	0
cache buffers chains	kcb_commit	1	0
cache buffers chains	kcbbxsv	1	0
cache buffers chains	kcbrls_2	1	0
cache buffers lru chain	kcbzgws	52	0
cache buffers lru chain	kcbbic2	5	56
cache buffers lru chain	kcbbwlru	1	2
cache buffers lru chain	kcbbxsv: move to being written	1	0
call allocation	ksuxds	1	1
checkpoint queue latch	kcbklbc_cql	1	0
checkpoint queue latch	kcbkubc_4	1	3
lgwr LWN SCN	kcs023	10	0
messages	ksarcv	3	2
messages	ksarcv: after wait	2	4
messages	ksaamb: after wakeup	1	0
mostly latch-free SCN	kcslcu3	86	96
mostly latch-free SCN	kcsnew_scn_rba	1	0
object queue header operation	kcbo_switch_q_bg	4	2
object queue header operation	kcbo_switch_mq_bg	1	0
qmn task queue latch	kwqmnmvtsks: delay to ready list	7	0
redo allocation	kcrfw_redo_gen: redo allocation 1	11	0
redo writing	kcrfw_post: rba scn pair	2	0
redo writing	kcrfwcr	2	4
shared pool	kghalo	1	1
simulator lru latch	kcbs_simulate: simulate set	4	0
undo global data	ktusm_stealext_2	13	6
undo global data	ktusmupst: KSLBEGIN	10	15

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps
Cursor Pin	kksfbc [KKSCHLFSP2]	413
Cursor Pin	kksLockDelete [KKSCHLPIN6]	157
Cursor Pin	kksfbc [KKSCHLPIN1]	2

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: 118,045,193
Captured Segments account for 97.4% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
FNSONLM	TBINDX	RIGHPK	INDEX	34,791,520	29.47
FNSONLM	TBMISC	INVM	TABLE	14,007,248	11.87
FNSONLM	TBINDX	INMBPK	INDEX	13,478,800	11.42
FNSONLM	TBINDX	DTEPPK	INDEX	7,153,184	6.06
FNSONLM	TBINDX	INDCPK	INDEX	5,946,624	5.04

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 1,748,867
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
FNSONLM	TBMISC	INVM	TABLE	804,548	46.00
FNSONLM	TBMISC	INMB	TABLE	460,631	26.34
FNSONLM	TBMISC	CUSM	TABLE	156,978	8.98
FNSONLM	TBINDX	CUSMPK	INDEX	71,775	4.10
FNSONLM	TBMISC	RIGH	TABLE	46,760	2.67

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 1,748,511
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Phys Read Requests	%Total
FNSONLM	TBMISC	INVM	TABLE	804,556	46.01
FNSONLM	TBMISC	INMB	TABLE	460,633	26.34
FNSONLM	TBMISC	CUSM	TABLE	156,978	8.98
FNSONLM	TBINDX	CUSMPK	INDEX	71,775	4.10
FNSONLM	TBMISC	RIGH	TABLE	46,760	2.67

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 1,748,511
Captured Segments account for 99.8% of Total

Owner	Tablespace Name	Object Name	Obj. Type	UnOptimized Reads	%Total
FNSONLM	TBMISC	INVM	TABLE	804,556	46.01
FNSONLM	TBMISC	INMB	TABLE	460,633	26.34
FNSONLM	TBMISC	CUSM	TABLE	156,978	8.98
FNSONLM	TBINDX	CUSMPK	INDEX	71,775	4.10
FNSONLM	TBMISC	RIGH	TABLE	46,760	2.67

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 2,523,206
Captured Segments account for 46.5% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
FNSONLM	TBMISC	INVM		TABLE	853,696	33.83
FNSONLM	TBMISC	INMB		TABLE	258,077	10.23
FNSONLM	TBMISC	CUEV		TABLE	34,969	1.39
FNSONLM	TBMISC	INDC		TABLE	27,225	1.08
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_209747035_0	INDEX PARTITION	87	0.00

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 578,798
Captured Segments account for 55.8% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
FNSONLM	TBMISC	INVM		TABLE	184,779	31.92
FNSONLM	TBMISC	INMB		TABLE	108,244	18.70
FNSONLM	TBMISC	CUEV		TABLE	19,358	3.34
FNSONLM	TBMISC	INDC		TABLE	10,131	1.75
SYS	SYSAUX	WRH$_SQLSTAT_INDEX	WRH$_SQLSTA_209747035_0	INDEX PARTITION	87	0.02

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

Total Direct Physical Writes: 14
Captured Segments account for 100.0% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Direct Writes	%Total
SYS	SYSAUX	WRH$_ACTIVE_SESSION_HISTORY	WRH$_ACTIVE_209747035_0	TABLE PARTITION	14	100.00

Back to Segment Statistics
Back to Top

Segments by Table Scans

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
FNSONLM	TBMISC	INVM		TABLE	7,355,808	89.96
FNSONLM	TBMISC	INDC		TABLE	402,352	4.92
FNSONLM	TBMISC	INMB		TABLE	324,784	3.97
FNSONLM	TBMISC	CUEV		TABLE	93,344	1.14
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_209747035_0	INDEX PARTITION	112	0.00

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

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

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Row Lock Waits	% of Capture
SYS	SYSAUX	WRH$_EVENT_HISTOGRAM_PK	WRH$_EVENT_HISTO_MXDB_MXSN	INDEX PARTITION	4	22.22
SYS	SYSAUX	WRH$_LATCH_PK	WRH$_LATCH_209747035_0	INDEX PARTITION	4	22.22
SYS	SYSAUX	WRH$_PARAMETER_PK	WRH$_PARAME_209747035_0	INDEX PARTITION	4	22.22
SYS	SYSAUX	WRH$_SYSSTAT_PK	WRH$_SYSSTA_209747035_0	INDEX PARTITION	4	22.22
SYS	SYSAUX	WRH$_ROWCACHE_SUMMARY_PK	WRH$_ROWCAC_209747035_0	INDEX PARTITION	2	11.11

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

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

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
FNSONLM	TBMISC	INMB	TABLE	58	49.15
FNSONLM	TBMISC	INDC	TABLE	49	41.53
FNSONLM	TBMISC	CUEV	TABLE	11	9.32

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	24	0.00	2	1
dc_global_oids	3	0.00	0	24
dc_histogram_data	187	35.29	0	2,064
dc_histogram_defs	420	21.90	0	3,778
dc_objects	344	2.62	0	1,154
dc_profiles	30	0.00	0	1
dc_rollback_segments	131,629	0.00	0	140
dc_segments	7,624	0.08	1	377
dc_tablespaces	70,235	0.00	0	7
dc_users	1,306	0.00	0	42
global database name	832	0.00	0	1
outstanding_alerts	10	0.00	0	5

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads
ACCOUNT_STATUS	45	0.00	0		0
BODY	10	0.00	40	0.00	0
CLUSTER	2	0.00	2	0.00	0
DBLINK	30	0.00	0		0
EDITION	18	0.00	33	0.00	0
INDEX	4	0.00	4	25.00	1
SCHEMA	37	0.00	0		0
SQL AREA	752	0.93	29,182,867	-0.01	8
SQL AREA BUILD	15	80.00	0		0
SQL AREA STATS	15	46.67	15	46.67	0
TABLE/PROCEDURE	95	11.58	457	10.07	16

Memory Statistics

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

Memory Dynamic Components

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

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	448.00	448.00	448.00	544.00	SHR/IMM
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	624.00	624.00	624.00	624.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	912.00	912.00	912.00	912.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	48.00	48.00	48.00	48.00	STA/
large pool	32.00	32.00	32.00	32.00	STA/
shared pool	352.00	352.00	224.00	352.00	GRO/IMM
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	223.27		2.57	5.25	27	27	87	87
B	Freeable	16.06	0.00	1.24	1.04	4		13	13
B	SQL	2.13	1.00	0.03	0.12	1	6	69	17
B	PL/SQL	0.49	0.40	0.01	0.03	0	0	87	39
E	Other	174.98		4.60	7.62	28	28	38	38
E	Freeable	17.13	0.00	1.56	1.05	4		11	11
E	SQL	1.52	0.96	0.08	0.17	1	6	20	16
E	PL/SQL	0.43	0.35	0.01	0.04	0	0	38	38

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	469,762,048
Fixed Size	2,209,824
Redo Buffers	16,953,344
Variable Size	2,717,911,008

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	48.00	48.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	24.19	24.19	0.00
shared	ASH buffers	18.24	18.24	0.00
shared	Checkpoint queue	6.27	6.27	0.00
shared	FileOpenBlock	6.00	6.00	0.00
shared	KCB Table Scan Buffer	4.00	4.00	0.00
shared	KGLH0	21.00	21.13	0.64
shared	KGLS	5.43	5.39	-0.79
shared	KGLSG	5.02	5.02	0.00
shared	KSFD SGA I/O b	4.00	4.00	0.00
shared	KTI-UNDO	5.91	5.91	0.00
shared	SQLA	36.32	36.49	0.46
shared	db_block_hash_buckets	5.57	5.57	0.00
shared	dbktb: trace buffer	7.81	7.81	0.00
shared	dbwriter coalesce buffer	16.00	16.00	0.00
shared	dirty object counts array	16.00	16.00	0.00
shared	event statistics per sess	10.03	10.03	0.00
shared	free memory	80.29	80.42	0.17
shared	kglsim hash table bkts	4.00	4.00	0.00
shared	ksunfy : SSO free list	9.55	9.55	0.00
shared	object queue hash buckets	4.50	4.50	0.00
shared	private strands	11.52	11.52	0.00
shared	row cache	8.24	8.24	0.00
	buffer_cache	448.00	448.00	0.00
	fixed_sga	2.11	2.11	0.00
	log_buffer	16.17	16.17	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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams 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

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

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	/db_audit/m012band/
audit_sys_operations	TRUE
audit_trail	OS
compatible	11.2.0.0.0
control_files	/oradata_m012band/m012band_CTRL_01.ctl, /oradata_m012band/m012band_CTRL_02.ctl, /oradata_m012band/m012band_CTRL_03.ctl
core_dump_dest	/oradata_m012band/orabase/m012band/cdump
db_block_size	8192
db_domain
db_name	m012band
db_recovery_file_dest	/oradata_m012band/flashback
db_recovery_file_dest_size	1572864000
db_unique_name	dc_m012band
dg_broker_config_file1
dg_broker_config_file2
diagnostic_dest	/oradata_m012band
filesystemio_options	setall
log_archive_dest_1	LOCATION=/oradata_m012band/oraarch/m012band
log_archive_format	m012band_%t_%s_%r.arc
memory_max_target	3221225472
memory_target	1610612736
open_cursors	500
os_authent_prefix
plsql_warnings	DISABLE:ALL
processes	500
remote_login_passwordfile	EXCLUSIVE
remote_os_authent	TRUE
sec_case_sensitive_logon	FALSE
sessions	800
undo_management	AUTO
undo_tablespace	TSUNDO_01
utl_file_dir	*

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	/oradata_m012band/m012band_CTRL_01.ctl
control_files	/oradata_m012band/m012band_CTRL_02.ctl
control_files	/oradata_m012band/m012band_CTRL_03.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 %:	99.97
Buffer Hit %:	98.52	In-memory Sort %:	100.00
Library Hit %:	100.01	Soft Parse %:	100.00
Execute to Parse %:	96.40	Latch Hit %:	99.99
Parse CPU to Parse Elapsd %:	77.17	% Non-Parse CPU:	99.60