WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

LQSI 2184274693 lqsi2 2 04-Nov-13 14:11 11.2.0.2.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
LQSI	2184274693	lqsi2	2	04-Nov-13 14:11	11.2.0.2.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

lqsb02 Linux x86 64-bit 32 32 4 125.91

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
lqsb02	Linux x86 64-bit	32	32	4	125.91

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 14923 06-Nov-13 09:00:37 201 1.8

End Snap: 14924 06-Nov-13 10:00:04 206 2.7

Elapsed: 59.44 (mins)

DB Time: 220.12 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	14923	06-Nov-13 09:00:37	201	1.8
End Snap:	14924	06-Nov-13 10:00:04	206	2.7
Elapsed:		59.44 (mins)
DB Time:		220.12 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 10,368M 10,368M Std Block Size: 8K

Shared Pool Size: 7,552M 7,552M Log Buffer: 24,132K

	Begin	End
Buffer Cache:	10,368M	10,368M	Std Block Size:	8K
Shared Pool Size:	7,552M	7,552M	Log Buffer:	24,132K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 3.7 22.5 0.01 0.31

DB CPU(s): 0.1 0.6 0.00 0.01

Redo size: 4,218.6 25,630.5

Logical reads: 7,922.2 48,131.9

Block changes: 30.3 183.8

Physical reads: 1.3 8.0

Physical writes: 1.5 9.4

User calls: 12.1 73.7

Parses: 8.0 48.3

Hard parses: 0.8 5.1

W/A MB processed: 0.2 1.3

Logons: 0.1 0.5

Executes: 432.1 2,625.3

Rollbacks: 0.0 0.0

Transactions: 0.2

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	3.7	22.5	0.01	0.31
DB CPU(s):	0.1	0.6	0.00	0.01
Redo size:	4,218.6	25,630.5
Logical reads:	7,922.2	48,131.9
Block changes:	30.3	183.8
Physical reads:	1.3	8.0
Physical writes:	1.5	9.4
User calls:	12.1	73.7
Parses:	8.0	48.3
Hard parses:	0.8	5.1
W/A MB processed:	0.2	1.3
Logons:	0.1	0.5
Executes:	432.1	2,625.3
Rollbacks:	0.0	0.0
Transactions:	0.2

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.28 Soft Parse %: 89.44

Execute to Parse %: 98.16 Latch Hit %: 99.85

Parse CPU to Parse Elapsd %: 0.45 % Non-Parse CPU: 95.03

Shared Pool Statistics

Begin End

Memory Usage %: 45.26 47.03

% SQL with executions>1: 97.35 94.80

% Memory for SQL w/exec>1: 97.16 93.92

	Begin	End
Memory Usage %:	45.26	47.03
% SQL with executions>1:	97.35	94.80
% Memory for SQL w/exec>1:	97.16	93.92

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
enq: TX - row lock contention	68	8,987	132157	68.04	Application
SQL*Net message from dblink	806	3,847	4773	29.13	Network
DB CPU		350		2.65
db file sequential read	3,854	21	5	0.16	User I/O
PX Deq: Slave Session Stats	98	4	43	0.03	Other

Host CPU (CPUs: 32 Cores: 32 Sockets: 4)

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

0.34 0.58 0.5 0.1 0.1 99.5

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.34	0.58	0.5	0.1	0.1	99.5

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

0.3 62.4 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 128,934.6 128,934.6

SGA use (MB): 18,432.0 18,432.0

PGA use (MB): 475.7 519.8

% Host Mem used for SGA+PGA: 14.66 14.70

	Begin	End
Host Mem (MB):	128,934.6	128,934.6
SGA use (MB):	18,432.0	18,432.0
PGA use (MB):	475.7	519.8
% Host Mem used for SGA+PGA:	14.66	14.70

RAC Statistics

Begin End

Number of Instances: 2 2

	Begin	End
Number of Instances:	2	2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 1.00 6.09

Global Cache blocks served: 37.79 229.58

GCS/GES messages received: 66.30 402.83

GCS/GES messages sent: 10.34 62.82

DBWR Fusion writes: 0.11 0.67

Estd Interconnect traffic (KB) 325.29

	Per Second	Per Transaction
Global Cache blocks received:	1.00	6.09
Global Cache blocks served:	37.79	229.58
GCS/GES messages received:	66.30	402.83
GCS/GES messages sent:	10.34	62.82
DBWR Fusion writes:	0.11	0.67
Estd Interconnect traffic (KB)	325.29

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.97

Buffer access - remote cache %: 0.01

Buffer access - disk %: 0.02

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 147.8

Avg global cache cr block receive time (ms): 0.4

Avg global cache current block receive time (ms): 0.4

Avg global cache cr block build time (ms): 0.0

Avg global cache cr block send time (ms): 0.0

Global cache log flushes for cr blocks served %: 96.7

Avg global cache cr block flush time (ms): 2.8

Avg global cache current block pin time (ms): 0.0

Avg global cache current block send time (ms): 0.0

Global cache log flushes for current blocks served %: 0.0

Avg global cache current block flush time (ms): 7.3

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

Avg message sent queue time on ksxp (ms): 0.4

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 85.21

% of indirect sent messages: 14.74

% of flow controlled messages: 0.06

Cluster Interconnect

if IP/Public/Source at End snap is different a '*' is displayed

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
eth1:1	169.254.41.2	N

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

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	13,185.00	99.83
parse time elapsed	3,843.62	29.10
DB CPU	349.67	2.65
PL/SQL execution elapsed time	25.29	0.19
hard parse elapsed time	16.69	0.13
hard parse (sharing criteria) elapsed time	1.25	0.01
sequence load elapsed time	0.69	0.01
PL/SQL compilation elapsed time	0.62	0.00
connection management call elapsed time	0.32	0.00
repeated bind elapsed time	0.04	0.00
failed parse elapsed time	0.00	0.00
DB time	13,207.28
background elapsed time	144.43
background cpu time	35.96

Back to Wait Events Statistics
Back to Top

Operating System Statistics

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

Statistic	Value	End Value
BUSY_TIME	61,825
IDLE_TIME	11,349,894
IOWAIT_TIME	13,929
NICE_TIME	30
SYS_TIME	8,433
USER_TIME	52,413
LOAD	0	1
RSRC_MGR_CPU_WAIT_TIME	0
VM_IN_BYTES	263,831,552
VM_OUT_BYTES	727,053,312
PHYSICAL_MEMORY_BYTES	135,197,683,712
NUM_CPUS	32
NUM_CPU_CORES	32
NUM_CPU_SOCKETS	4
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,576
TCP_RECEIVE_SIZE_DEFAULT	87,380
TCP_RECEIVE_SIZE_MAX	4,194,304
TCP_RECEIVE_SIZE_MIN	4,096
TCP_SEND_SIZE_DEFAULT	16,384
TCP_SEND_SIZE_MAX	4,194,304
TCP_SEND_SIZE_MIN	4,096

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
06-Nov 09:00:37	0.34
06-Nov 10:00:04	0.58	0.54	0.46	0.07	99.46	0.12

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 100.1% of Total DB time 13,207.28 (s)
Total FG Wait Time: 12,866.59 (s) DB CPU time: 349.67 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Application	811	0	8,987	11081	68.04
Network	43,053	0	3,851	89	29.16
DB CPU			350		2.65
User I/O	4,117	0	21	5	0.16
Other	4,614	82	5	1	0.04
Cluster	3,817	0	1	0	0.01
Commit	456	0	1	2	0.01
Concurrency	1,299	0	0	0	0.00
System I/O	14	0	0	1	0.00
Configuration	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
enq: TX - row lock contention	68	3	8,987	132157	0.12	68.04
SQL*Net message from dblink	806	0	3,847	4773	1.37	29.13
db file sequential read	3,854	0	21	5	6.57	0.16
PX Deq: Slave Session Stats	98	0	4	43	0.17	0.03
SQL*Net more data from dblink	6,095	0	4	1	10.38	0.03
log file sync	456	0	1	2	0.78	0.01
gc current block 2-way	1,688	0	1	0	2.88	0.00
name-service call wait	8	0	1	63	0.01	0.00
gc cr grant 2-way	958	0	0	0	1.63	0.00
row cache lock	1,155	0	0	0	1.97	0.00
db file scattered read	108	0	0	2	0.18	0.00
gc current grant busy	539	0	0	0	0.92	0.00
gc current grant 2-way	352	0	0	0	0.60	0.00
latch: enqueue hash chains	29	0	0	3	0.05	0.00
gc cr block 2-way	199	0	0	0	0.34	0.00
IPC send completion sync	269	0	0	0	0.46	0.00
SQL*Net break/reset to client	720	0	0	0	1.23	0.00
PX Deq: reap credit	3,658	100	0	0	6.23	0.00
rdbms ipc reply	231	0	0	0	0.39	0.00
SQL*Net message to client	35,101	0	0	0	59.80	0.00
enq: PS - contention	83	11	0	0	0.14	0.00
gc cr multi block request	48	0	0	1	0.08	0.00
library cache pin	70	0	0	0	0.12	0.00
enq: JQ - contention	33	100	0	1	0.06	0.00
Disk file operations I/O	155	0	0	0	0.26	0.00
DFS lock handle	36	0	0	0	0.06	0.00
library cache lock	42	0	0	0	0.07	0.00
cursor: pin S	2	0	0	6	0.00	0.00
control file sequential read	14	0	0	1	0.02	0.00
gc cr block busy	2	0	0	4	0.00	0.00
enq: TM - contention	17	0	0	0	0.03	0.00
reliable message	26	0	0	0	0.04	0.00
gc current block congested	13	0	0	0	0.02	0.00
gc current multi block request	6	0	0	1	0.01	0.00
global enqueue expand wait	1	0	0	4	0.00	0.00
enq: FB - contention	6	0	0	0	0.01	0.00
gc cr grant congested	8	0	0	0	0.01	0.00
gc buffer busy acquire	3	0	0	1	0.01	0.00
SQL*Net more data to client	137	0	0	0	0.23	0.00
buffer busy waits	14	0	0	0	0.02	0.00
SQL*Net more data from client	67	0	0	0	0.11	0.00
SQL*Net more data to dblink	70	0	0	0	0.12	0.00
PX Deq: Signal ACK RSG	18	0	0	0	0.03	0.00
latch: cache buffers chains	11	0	0	0	0.02	0.00
SQL*Net message from client	35,098	0	490,275	13969	59.79
jobq slave wait	6,419	100	3,214	501	10.94
PX Deq: Execution Msg	319	0	2	6	0.54
PX Deq Credit: send blkd	1,404	0	2	1	2.39
single-task message	29	0	1	26	0.05
PX Deq: Execute Reply	18	0	0	5	0.03
PX Deq: Parse Reply	18	0	0	1	0.03
PX Deq: Join ACK	18	0	0	1	0.03

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	16,591	0	30	2	28.26	20.78
gcs log flush sync	16,433	2	29	2	27.99	20.32
os thread startup	141	0	4	31	0.24	3.01
control file sequential read	13,734	0	3	0	23.40	2.04
db file parallel write	4,011	0	2	1	6.83	1.55
reliable message	148	1	2	15	0.25	1.51
control file parallel write	1,303	0	1	1	2.22	0.72
ges inquiry response	2,451	0	1	0	4.18	0.71
name-service call wait	5	0	0	71	0.01	0.25
CGS wait for IPC msg	33,953	100	0	0	57.84	0.24
ASM file metadata operation	1,073	0	0	0	1.83	0.18
gc cr block 2-way	713	0	0	0	1.21	0.14
gc current block 2-way	524	0	0	0	0.89	0.11
gc current block busy	21	0	0	6	0.04	0.09
DFS lock handle	462	96	0	0	0.79	0.08
db file sequential read	54	0	0	2	0.09	0.07
ksxr poll remote instances	6,540	100	0	0	11.14	0.04
gc buffer busy release	8	0	0	8	0.01	0.04
row cache lock	148	0	0	0	0.25	0.04
row cache process	3,739	0	0	0	6.37	0.04
gc current grant busy	175	0	0	0	0.30	0.03
ADR block file write	5	0	0	6	0.01	0.02
row cache cleanup	10,619	0	0	0	18.09	0.02
ADR block file read	26	0	0	1	0.04	0.02
CSS initialization	6	0	0	4	0.01	0.02
CSS operation: action	12	0	0	2	0.02	0.01
gc cr block busy	4	0	0	4	0.01	0.01
PX Deq: reap credit	1,725	100	0	0	2.94	0.01
enq: TM - contention	8	75	0	1	0.01	0.01
direct path write	3	0	0	3	0.01	0.01
enq: PS - contention	18	33	0	0	0.03	0.01
gc current grant 2-way	29	0	0	0	0.05	0.01
enq: WF - contention	18	0	0	0	0.03	0.00
Disk file operations I/O	205	0	0	0	0.35	0.00
libcache interrupt action by LCK	8,341	0	0	0	14.21	0.00
PX Deq: Slave Session Stats	18	0	0	0	0.03	0.00
enq: CF - contention	10	80	0	0	0.02	0.00
enq: TD - KTF dump entries	7	0	0	0	0.01	0.00
log file sync	4	0	0	1	0.01	0.00
LGWR wait for redo copy	142	0	0	0	0.24	0.00
gc cr multi block request	6	0	0	0	0.01	0.00
enq: TA - contention	12	0	0	0	0.02	0.00
enq: PI - contention	5	100	0	0	0.01	0.00
PX Deq: Signal ACK RSG	18	0	0	0	0.03	0.00
CSS operation: query	18	0	0	0	0.03	0.00
asynch descriptor resize	186	100	0	0	0.32	0.00
gc cr block congested	6	0	0	0	0.01	0.00
SQL*Net more data from client	1	0	0	2	0.00	0.00
enq: PW - flush prewarm buffers	3	100	0	0	0.01	0.00
PX Deq: Signal ACK EXT	18	0	0	0	0.03	0.00
rdbms ipc message	99,309	62	78,409	790	169.18
gcs remote message	1,038,749	95	10,643	10	1,769.59
wait for unread message on broadcast channel	7,129	90	7,132	1000	12.14
DIAG idle wait	86,127	75	7,102	82	146.72
Space Manager: slave idle wait	961	99	4,767	4961	1.64
PING	1,332	21	3,572	2681	2.27
shared server idle wait	119	100	3,571	30005	0.20
ASM background timer	713	0	3,567	5003	1.21
class slave wait	109	0	3,566	32719	0.19
GCR sleep	713	100	3,566	5001	1.21
Streams AQ: qmn slave idle wait	124	0	3,566	28756	0.21
Streams AQ: qmn coordinator idle wait	248	50	3,566	14378	0.42
smon timer	719	0	3,565	4959	1.22
pmon timer	1,192	100	3,565	2991	2.03
ges remote message	40,214	84	3,565	89	68.51
dispatcher timer	59	100	3,540	60003	0.10
PX Idle Wait	85	0	3,528	41505	0.14
SQL*Net message from client	94	0	0	4	0.16
PX Deq: Join ACK	18	0	0	1	0.03
KSV master wait	2,167	99	0	0	3.69
PX Deq: Parse Reply	18	0	0	1	0.03
Streams AQ: RAC qmn coordinator idle wait	251	100	0	0	0.43
PX Deq: Execute Reply	18	0	0	0	0.03

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	26	80.8		7.7	11.5
ADR block file write	5				80.0	20.0
ADR file lock	6	100.0
ASM file metadata operation	1073	99.6					.1	.3
CGS wait for IPC msg	34K	100.0
CSS initialization	6	50.0			16.7	33.3
CSS operation: action	12	50.0		50.0
CSS operation: query	18	100.0
DFS lock handle	498	100.0
Disk file operations I/O	339	100.0
IPC send completion sync	281	100.0
KJC: Wait for msg sends to complete	36	100.0
LGWR wait for redo copy	142	100.0
PX Deq: Signal ACK EXT	36	100.0
PX Deq: Signal ACK RSG	36	100.0
PX Deq: Slave Session Stats	116	98.3							1.7
PX Deq: reap credit	5383	100.0
SQL*Net break/reset to client	720	99.7				.3
SQL*Net break/reset to dblink	6	100.0
SQL*Net message from dblink	806	33.5	3.5	26.3	17.9	5.2	2.7	9.9	1.0
SQL*Net message to client	35.1K	100.0
SQL*Net message to dblink	777	100.0
SQL*Net more data from client	68	98.5	1.5
SQL*Net more data from dblink	6095	92.0	1.1	1.5	4.5	.7	.0	.1
SQL*Net more data to client	137	100.0
SQL*Net more data to dblink	70	100.0
asynch descriptor resize	253	100.0
buffer busy waits	17	100.0
control file parallel write	1304	97.9	.2		.2	1.2	.3	.2
control file sequential read	13.8K	99.7	.0	.0	.1	.1	.0	.0
cursor: pin S	2	50.0				50.0
db file parallel write	4011	95.5	.2	.3	2.4	1.6	.0
db file scattered read	103	75.7	1.0	2.9	16.5	2.9	1.0
db file sequential read	3877	29.3	1.2	9.5	37.6	19.4	2.4	.5
direct path write	3	66.7				33.3
enq: AF - task serialization	1	100.0
enq: CF - contention	10	100.0
enq: CR - block range reuse ckpt	4	100.0
enq: DR - contention	2	100.0
enq: FB - contention	6	100.0
enq: HW - contention	7	85.7	14.3
enq: JQ - contention	33	97.0	3.0
enq: KO - fast object checkpoint	1	100.0
enq: MW - contention	2	100.0
enq: PI - contention	5	100.0
enq: PS - contention	101	100.0
enq: PW - flush prewarm buffers	3	100.0
enq: TA - contention	12	100.0
enq: TD - KTF dump entries	7	100.0
enq: TM - contention	25	96.0				4.0
enq: TX - row lock contention	68				4.4	10.3	1.5	52.9	30.9
enq: US - contention	1	100.0
enq: WF - contention	18	100.0
gc buffer busy acquire	3	100.0
gc buffer busy release	5	20.0	20.0		40.0		20.0
gc cr block 2-way	930	100.0
gc cr block busy	8	25.0	50.0		12.5	12.5
gc cr block congested	6	100.0
gc cr grant 2-way	955	99.9		.1
gc cr grant congested	8	100.0
gc cr multi block request	53	84.9	15.1
gc current block 2-way	2210	99.9	.0	.0
gc current block busy	16	25.0	50.0	6.3	12.5			6.3
gc current block congested	15	100.0
gc current grant 2-way	381	100.0
gc current grant busy	711	99.9		.1
gc current grant congested	1	100.0
gc current multi block request	13	100.0
gcs log flush sync	16.4K	72.7	1.8	3.7	18.8	3.1
ges inquiry response	2451	99.5	.4	.0
global enqueue expand wait	1			100.0
ksxr poll remote instances	6483	100.0
latch free	10	100.0
latch: cache buffers chains	11	100.0
latch: enqueue hash chains	29	6.9	10.3	82.8
latch: gc element	1	100.0
latch: ges resource hash list	1	100.0
libcache interrupt action by LCK	8285	100.0
library cache lock	44	97.7	2.3
library cache pin	73	98.6	1.4
library cache: mutex X	5	100.0
log file parallel write	16.6K	73.6	1.1	3.4	18.8	2.6	.4	.1
log file sync	462	62.6	21.9	1.5	5.8	6.1	1.5	.6
name-service call wait	13					15.4	7.7	76.9
os thread startup	141					15.6	43.3	41.1
rdbms ipc reply	231	99.6	.4
reliable message	174	97.7	.6					1.7
row cache cleanup	10.5K	100.0
row cache lock	1272	99.4	.5	.1
row cache process	3682	100.0
ASM background timer	713								100.0
DIAG idle wait	86.1K	8.4	.7	.5	.3	19.3	17.9	52.9
GCR sleep	713								100.0
KSV master wait	2169	100.0
PING	1332	78.5	.2	.1					21.2
PX Deq Credit: send blkd	1404	99.9						.1	.1
PX Deq: Execute Reply	36	66.7	11.1	11.1	5.6	2.8		2.8
PX Deq: Execution Msg	319	86.5	3.4	1.6	7.8			.3	.3
PX Deq: Join ACK	36	41.7	41.7	16.7
PX Deq: Parse Reply	36	80.6	16.7		2.8
PX Idle Wait	80	1.3	6.3	1.3	1.3	7.5	3.8	15.0	63.8
SQL*Net message from client	35.2K	80.3	2.4	3.4	2.8	2.1	1.9	2.6	4.5
Space Manager: slave idle wait	965				.1		.2	.6	99.1
Streams AQ: RAC qmn coordinator idle wait	251	100.0
Streams AQ: qmn coordinator idle wait	248	48.8	1.2						50.0
Streams AQ: qmn slave idle wait	124								100.0
class slave wait	109	46.8		17.4		.9	1.8	6.4	26.6
dispatcher timer	59								100.0
gcs remote message	1038.2K	2.0	.7	1.0	1.3	94.9	.0
ges remote message	40.2K	9.4	.6	.4	.5	.7	1.2	87.2
jobq slave wait	6423	.0						100.0
pmon timer	1192						.1	.3	99.7
rdbms ipc message	99.3K	28.3	1.3	.8	1.1	1.0	.6	45.3	21.5
shared server idle wait	119								100.0
single-task message	29					3.4	58.6	37.9
smon timer	722				.1		.1	.7	99.0
wait for unread message on broadcast channel	7130				.0			100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s	<1s	<2s	>=2s
		% of Total Waits
ASM file metadata operation	3	99.7	.3
PX Deq: Slave Session Stats	1	98.3						.9	.9
SQL*Net message from dblink	83	89.1	3.6	2.6	1.7	.9	1.1	.4	.6
SQL*Net more data from dblink	5	99.9	.1
control file parallel write	2	99.8	.2
control file sequential read	2	100.0	.0
db file sequential read	18	99.5	.4	.0
enq: TX - row lock contention	36	16.2	11.8		16.2	25.0			30.9
gc current block busy	1	93.8	6.3
log file parallel write	12	99.9	.1	.0
log file sync	3	99.4	.4	.2
name-service call wait	10	23.1	15.4	61.5
os thread startup	58	58.9	37.6	3.5
reliable message	3	98.3			.6		1.1

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	< 1m	< 2m	>=2m
		% of Total Waits
PX Deq: Slave Session Stats	1	99.1	.9
SQL*Net message from dblink	1	99.4	.1			.5
enq: TX - row lock contention	7	69.1		5.9	4.4	20.6

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: m is 64*1024 milliseconds (approximately 67 seconds or 1.1 minutes) h is 4096*1024 milliseconds (approximately 70 minutes or 1.17 hours)
% 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 4m to 1h	<2m	<8m	<1/4h
		% of Total Waits
SQL*Net message from dblink	4	99.5		.5
enq: TX - row lock contention	14	79.4	8.8	11.8

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)
lqsi	13,192	333	5	27,814
SYS$USERS	15	17	0	261
SYS$BACKGROUND	0	0	0	179
lqsiXDB	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	Network Total Wts	Network Wt Time
lqsi	4053	21	1087	0	41988	3851
SYS$USERS	64	0	212	0	1065	0
SYS$BACKGROUND	262	0	8640	4	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
SQL ordered by Cluster Wait Time
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 98.5% of Total DB Time (s): 13,207
Captured PL/SQL account for 30.6% of Total DB Time (s): 13,207

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Text
8,867.02	97	91.41	67.14	0.00	0.00	4yu8rhan7b7fa	update AC01 set AAB001=:1, EAC...
2,881.45	36	80.04	21.82	0.02	0.01	98h9y8qdznwqs	BEGIN PKG_YBJK.p_Ac01(:1, :2, ...
2,868.36	35	81.95	21.72	0.00	0.00	8rqjzu3ymdqs3	INSERT INTO F_AC01_ERR@YLBXDB ...
1,029.48	20	51.47	7.79	6.13	0.00	0d5uau8pjgfqh	BEGIN tbcbcheck(:1, :2, :3) ; ...
1,029.46	20	51.47	7.79	6.12	0.00	d5pfxagb5v6uy	SELECT COUNT(*) FROM ( SELECT ...
120.87	9	13.43	0.92	0.35	0.19	84cvfffpphf9g	BEGIN glog.dbrol(:1, :2); END;
120.18	2	60.09	0.91	0.01	0.00	67jh7macwp54s	Update AC02 Set AAC031= '2', A...
14.87	9	1.65	0.11	99.99	0.00	a96tt00s8p238	select nvl(a.aae140, ' ') aae1...
9.52	496,056	0.00	0.07	98.42	0.00	5ufbf5v4shvh7	SELECT MOD(12 - MOD((SUBSTR(:B...
8.08	5	1.62	0.06	99.90	0.12	5jrtazrvscxyy	select nvl(a.aae140, ' ') aae1...

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 54.7% of Total CPU Time (s): 350
Captured PL/SQL account for 18.6% of Total CPU Time (s): 350

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
63.06	20	3.15	18.04	1,029.48	6.13	0.00	0d5uau8pjgfqh		BEGIN tbcbcheck(:1, :2, :3) ; ...
63.05	20	3.15	18.03	1,029.46	6.12	0.00	d5pfxagb5v6uy		SELECT COUNT(*) FROM ( SELECT ...
14.86	9	1.65	4.25	14.87	99.99	0.00	a96tt00s8p238		select nvl(a.aae140, ' ') aae1...
9.37	496,056	0.00	2.68	9.52	98.42	0.00	5ufbf5v4shvh7		SELECT MOD(12 - MOD((SUBSTR(:B...
8.07	5	1.61	2.31	8.08	99.90	0.12	5jrtazrvscxyy		select nvl(a.aae140, ' ') aae1...
6.30	495,840	0.00	1.80	6.07	103.83	0.00	35m78h1ywpcju		SELECT SUBSTR(:B2 , 1, 6)\|\|'19...
5.70	9	0.63	1.63	5.70	100.01	0.00	825fvttgrm3bh		select /+rule/ opseno, aae00...
5.60	496,055	0.00	1.60	5.60	99.95	0.00	0vm5ju1vzcycd		SELECT UPPER(RTRIM(:B2 )\|\|RTRI...
5.02	3	1.67	1.44	5.02	99.98	0.00	2n21p975xyvpt		select nvl(a.aae140, ' ') aae1...
4.90	3	1.63	1.40	4.91	99.78	0.21	fmn92gwtc51h4		select nvl(a.aae140, ' ') aae1...
4.88	3	1.63	1.39	4.89	99.77	0.11	9ns7wbhnz7m75		select nvl(a.aae140, ' ') aae1...
4.84	3	1.61	1.38	4.85	99.72	0.22	4by1rhfw5g05u		select nvl(a.aae140, ' ') aae1...
4.82	3	1.61	1.38	4.83	99.85	0.12	ahwysj8zsd30w		select nvl(a.aae140, ' ') aae1...
4.70	4	1.18	1.35	4.71	99.96	0.00	19g0mtxsn2v70	PL/SQL Developer	select names.name, stats.stati...
4.00	13	0.31	1.14	4.00	99.88	0.00	admybmxruwxkz	PL/SQL Developer	select * from v$open_cursor wh...
3.51	2	1.75	1.00	3.51	99.98	0.00	6728s1z0ks8kd		select nvl(a.aae140, ' ') aae1...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
0.41	36	0.01	1.90	2,881.45	0.02	0.01	98h9y8qdznwqs	BEGIN PKG_YBJK.p_Ac01(:1, :2, ...
0.24	9	0.03	1.10	120.87	0.35	0.19	84cvfffpphf9g	BEGIN glog.dbrol(:1, :2); END;
0.09	97	0.00	0.40	8,867.02	0.00	0.00	4yu8rhan7b7fa	update AC01 set AAB001=:1, EAC...
0.05	151	0.00	0.25	0.48	82.34	11.19	8xx97wgpayb3u	insert into SBDS_USERLOG (FUNC...
0.04	214	0.00	0.19	0.07	26.26	57.81	46669m6rqsgk8	INSERT INTO SBDS_SYSLOGDT VALU...
0.01	3	0.00	0.05	4.85	99.72	0.22	4by1rhfw5g05u	select nvl(a.aae140, ' ') aae1...
0.01	3	0.00	0.05	4.91	99.78	0.21	fmn92gwtc51h4	select nvl(a.aae140, ' ') aae1...
0.01	5	0.00	0.04	8.08	99.90	0.12	5jrtazrvscxyy	select nvl(a.aae140, ' ') aae1...
0.01	2	0.00	0.04	3.28	99.64	0.25	6pzg9zb7k1hkn	select nvl(a.aae140, ' ') aae1...
0.01	2	0.00	0.03	3.25	99.77	0.21	dm0d8ptk9513r	select nvl(a.aae140, ' ') aae1...

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: 28,253,450
Captured SQL account for 35.9% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
1,753,506	9	194,834.00	6.21	5.70	100.01	0.00	825fvttgrm3bh	select /+rule/ opseno, aae00...
974,149	5	194,829.80	3.45	3.13	99.67	0.00	5c22tux2023f1	select /+rule/ opseno, aae00...
974,121	5	194,824.20	3.45	3.07	99.90	0.00	1sykps60snxch	select /+rule/ opseno, aae00...
676,544	9	75,171.56	2.39	14.87	99.99	0.00	a96tt00s8p238	select nvl(a.aae140, ' ') aae1...
584,550	3	194,850.00	2.07	1.86	100.01	0.00	d21gu7zzgf215	select /+rule/ opseno, aae00...
584,532	3	194,844.00	2.07	1.88	100.03	0.00	dbvwzm2n8dta6	select /+rule/ opseno, aae00...
584,528	3	194,842.67	2.07	1.90	99.92	0.00	an9d6xg6fbtmj	select /+rule/ opseno, aae00...
584,460	3	194,820.00	2.07	1.86	100.03	0.00	2ay2vbw8xvc6j	select /+rule/ opseno, aae00...
584,406	3	194,802.00	2.07	2.00	99.87	0.00	cwdgkwfmp0y16	select /+rule/ opseno, aae00...
375,930	5	75,186.00	1.33	8.08	99.90	0.12	5jrtazrvscxyy	select nvl(a.aae140, ' ') aae1...

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: 4,705
Captured SQL account for 0.8% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
49	36	1.36	1.04	2,881.45	0.02	0.01	98h9y8qdznwqs		BEGIN PKG_YBJK.p_Ac01(:1, :2, ...
36	9	4.00	0.77	120.87	0.35	0.19	84cvfffpphf9g		BEGIN glog.dbrol(:1, :2); END;
13	97	0.13	0.28	8,867.02	0.00	0.00	4yu8rhan7b7fa		update AC01 set AAB001=:1, EAC...
6	151	0.04	0.13	0.48	82.34	11.19	8xx97wgpayb3u		insert into SBDS_USERLOG (FUNC...
4	214	0.02	0.09	0.07	26.26	57.81	46669m6rqsgk8		INSERT INTO SBDS_SYSLOGDT VALU...
1	178	0.01	0.02	0.07	73.01	4.96	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
1	3	0.33	0.02	5.02	99.98	0.00	2n21p975xyvpt		select nvl(a.aae140, ' ') aae1...
1	2	0.50	0.02	3.41	99.86	0.01	3sb1wnct1bv2u		select nvl(a.aae140, ' ') aae1...
1	3	0.33	0.02	4.85	99.72	0.22	4by1rhfw5g05u		select nvl(a.aae140, ' ') aae1...
1	5	0.20	0.02	8.08	99.90	0.12	5jrtazrvscxyy		select nvl(a.aae140, ' ') aae1...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 3,991
Captured SQL account for 0.7% of Total
Total UnOptimized Read Requests: 3,991
Captured SQL account for 0.7% 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 Text
49	49	36	1.36	1.23	98h9y8qdznwqs	BEGIN PKG_YBJK.p_Ac01(:1, :2, ...
36	36	9	4.00	0.90	84cvfffpphf9g	BEGIN glog.dbrol(:1, :2); END;
13	13	97	0.13	0.33	4yu8rhan7b7fa	update AC01 set AAB001=:1, EAC...
3	3	214	0.01	0.08	46669m6rqsgk8	INSERT INTO SBDS_SYSLOGDT VALU...
1	1	3	0.33	0.03	2n21p975xyvpt	select nvl(a.aae140, ' ') aae1...
1	1	2	0.50	0.03	3sb1wnct1bv2u	select nvl(a.aae140, ' ') aae1...
1	1	3	0.33	0.03	4by1rhfw5g05u	select nvl(a.aae140, ' ') aae1...
1	1	5	0.20	0.03	5jrtazrvscxyy	select nvl(a.aae140, ' ') aae1...
1	1	2	0.50	0.03	6728s1z0ks8kd	select nvl(a.aae140, ' ') aae1...
1	1	2	0.50	0.03	67jh7macwp54s	Update AC02 Set AAC031= '2', A...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 1,541,039
Captured SQL account for 97.6% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Text
496,056	496,044	1.00	9.52	98.42	0.00	5ufbf5v4shvh7	SELECT MOD(12 - MOD((SUBSTR(:B...
496,055	496,032	1.00	5.60	99.95	0.00	0vm5ju1vzcycd	SELECT UPPER(RTRIM(:B2 )\|\|RTRI...
495,840	495,831	1.00	6.07	103.83	0.00	35m78h1ywpcju	SELECT SUBSTR(:B2 , 1, 6)\|\|'19...
3,363	3,363	1.00	0.10	102.36	0.00	gnkrt49h24x8a	select pctfree_stg, pctused_st...
1,467	6,195	4.22	0.15	93.74	0.00	cm5vu20fhtnq1	select /*+ connect_by_filterin...
1,246	1,246	1.00	0.07	90.66	0.00	ftj9uawt4wwzb	select condition from cdef$ wh...
1,039	1,026	0.99	0.18	89.42	0.00	3c1kubcdjnppq	update sys.col_usage$ set equa...
883	883	1.00	0.41	81.09	0.00	fhw2qjm168nwy	SELECT SB_PRSENO.NEXTVAL FROM ...
822	822	1.00	0.29	85.36	0.12	4m7m0t6fjcs5x	update seq$ set increment$=:2,...
520	451	0.87	0.05	93.39	0.00	chan796pg4jm2	select opseno, ordnum from sbd...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 28,345
Captured SQL account for 38.6% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Text
1,467	1,467	5.18	cm5vu20fhtnq1	select /*+ connect_by_filterin...
1,246	1,246	4.40	ftj9uawt4wwzb	select condition from cdef$ wh...
793	822	2.80	4m7m0t6fjcs5x	update seq$ set increment$=:2,...
655	883	2.31	fhw2qjm168nwy	SELECT SB_PRSENO.NEXTVAL FROM ...
520	520	1.83	chan796pg4jm2	select opseno, ordnum from sbd...
506	506	1.79	2syvqzbxp4k9z	select u.name, o.name, a.inter...
506	506	1.79	2xyb5d6xg9srh	select a.default_cpu_cost, a.d...
409	409	1.44	11qxbug0797dh	select opseno, ordnum from sbd...
388	388	1.37	5vsu32fudzpz7	update sbds_log set ordnum = a...
370	3,363	1.31	gnkrt49h24x8a	select pctfree_stg, pctused_st...
363	1,039	1.28	3c1kubcdjnppq	update sys.col_usage$ set equa...
345	345	1.22	g00cj285jmgsw	update sys.mon_mods$ set inser...
316	316	1.11	4cjj9adqzvwuk	update sbds_log set ordnum = a...
314	314	1.11	cc6c2x538r8ka	select opseno, ordnum from sbd...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
1,984,635	1	0.03	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
1,185,304	4	0.01	64jvrsys6ybn5	PL/SQL Developer	select l.*, o.owner object_own...

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

SQL ordered by Cluster Wait Time

%Total - Cluster Time as a percentage of Total Cluster Wait Time
%Clu - Cluster Time as a percentage of Elapsed Time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Only SQL with Cluster Wait Time > .005 seconds is reported
Total Cluster Wait Time (s): 2
Captured SQL account for 8.2% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
0.05	822	2.32	0.29	15.69	85.36	0.12	4m7m0t6fjcs5x		update seq$ set increment$=:2,...
0.05	154	2.31	0.53	8.60	85.86	0.06	05qqsnmj8mqy0		BEGIN glog.cutab; END;
0.03	97	1.60	8,867.02	0.00	0.00	0.00	4yu8rhan7b7fa		update AC01 set AAB001=:1, EAC...
0.03	9	1.47	120.87	0.02	0.35	0.19	84cvfffpphf9g		BEGIN glog.dbrol(:1, :2); END;
0.02	1,039	1.08	0.18	12.13	89.42	0.00	3c1kubcdjnppq		update sys.col_usage$ set equa...
0.02	151	0.82	0.48	3.37	82.34	11.19	8xx97wgpayb3u		insert into SBDS_USERLOG (FUNC...
0.01	178	0.62	0.07	17.53	73.01	4.96	18naypzfmabd6	EM_PING	INSERT INTO MGMT_SYSTEM_PERFOR...
0.01	36	0.53	2,881.45	0.00	0.02	0.01	98h9y8qdznwqs		BEGIN PKG_YBJK.p_Ac01(:1, :2, ...
0.01	1	0.39	0.51	1.51	99.21	0.00	c8khjbn635s3c	plsqldev.exe	select s.synonym_name object_n...
0.01	883	0.31	0.41	1.51	81.09	0.00	fhw2qjm168nwy		SELECT SB_PRSENO.NEXTVAL FROM ...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

05qqsnmj8mqy0 BEGIN glog.cutab; END;

0d5uau8pjgfqh BEGIN tbcbcheck(:1, :2, :3) ; END;

0vm5ju1vzcycd SELECT UPPER(RTRIM(:B2 )||RTRIM(:B1 )) FROM DUAL

11qxbug0797dh select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$0A07013D0002'

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

19g0mtxsn2v70 select names.name, stats.statistic#, stats.value from v$sesstat stats, v$statname names where stats.sid = :sid and names.Statistic# = stats.Statistic# order by stats.statistic#

1sykps60snxch select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500285467' order by aae036

2ay2vbw8xvc6j select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020262860' order by aae036

2n21p975xyvpt select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500357430' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

2syvqzbxp4k9z select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#

2xyb5d6xg9srh select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2

35m78h1ywpcju SELECT SUBSTR(:B2 , 1, 6)||'19'||SUBSTR(:B1 , 7, 9) FROM DUAL

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

3sb1wnct1bv2u select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020264069' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

46669m6rqsgk8 INSERT INTO SBDS_SYSLOGDT VALUES(:B3 , :B2 , 'AAE035', TO_CHAR(:B1 , 'YYYY-MM-DD HH24:MI:SS'), '3')

4by1rhfw5g05u select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020274129' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

4cjj9adqzvwuk update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$0A07013D0002'

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

4yu8rhan7b7fa update AC01 set AAB001=:1, EAC012=:2, EAC109=:3, AAC002=:4, AAC003=:5, AAC004=:6, AAC006=:7, AAC009=:8, AAC012=:9, AAC013=:10, AAC020=:11, EAB009=:12, EAB010=:13, EAC013=:14, EAC014=:15, EKC002=:16, AAE116=:17, EAC019=:18, ELC001=:19, EJC001=:20, EAC015=:21, EAC016=:22, AAC008=:23, AAE036=:24, AAE011=:25, AAE035=:26 where AAC001=:27

5c22tux2023f1 select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500065843' order by aae036

5jrtazrvscxyy select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500065843' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

5ufbf5v4shvh7 SELECT MOD(12 - MOD((SUBSTR(:B1 , 1, 1)*7+ SUBSTR(:B1 , 2, 1)*9+ SUBSTR(:B1 , 3, 1)*10+ SUBSTR(:B1 , 4, 1)*5+ SUBSTR(:B1 , 5, 1)*8+ SUBSTR(:B1 , 6, 1)*4+ SUBSTR(:B1 , 7, 1)*2+ SUBSTR(:B1 , 8, 1)*1+ SUBSTR(:B1 , 9, 1)*6+ SUBSTR(:B1 , 10, 1)*3+ SUBSTR(:B1 , 11, 1)*7+ SUBSTR(:B1 , 12, 1)*9+ SUBSTR(:B1 , 13, 1)*10+ SUBSTR(:B1 , 14, 1)*5+ SUBSTR(:B1 , 15, 1)*8+ SUBSTR(:B1 , 16, 1)*4+ SUBSTR(:B1 , 17, 1)*2), 11), 11) FROM DUAL

5vsu32fudzpz7 update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$05F400190002'

64jvrsys6ybn5 select l.*, o.owner object_owner, o.object_Name from sys.all_objects o, v$lock l where l.sid = :sid and l.type = 'TM' and o.object_id = l.id1

6728s1z0ks8kd select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500149227' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

67jh7macwp54s Update AC02 Set AAC031= '2', AAE035= to_date('2006-11-28 11:24:48', 'YYYY-MM-DD HH24:MI:SS'), EAC017= to_date('2006-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), EAC018= to_number(800), EAC020= to_date('2006-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') where prseno=129705809

6pzg9zb7k1hkn select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020250001' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

825fvttgrm3bh select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020254260' order by aae036

84cvfffpphf9g BEGIN glog.dbrol(:1, :2); END;

8rqjzu3ymdqs3 INSERT INTO F_AC01_ERR@YLBXDB VALUES (: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 )

8xx97wgpayb3u insert into SBDS_USERLOG (FUNCTIONID, AAE002, AAC001, AAB001, PRCOL1, PRCOL2, PRCOL3, PRCOL4, PRCOL5, PRCOL6, PRCOL7, PRCOL8, AAE011, AAE036, AAB034, AAE013, EAE024, OPSENO) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)

98h9y8qdznwqs BEGIN PKG_YBJK.p_Ac01(:1, :2, :3, :4, :5, :6, :7); END;

9ns7wbhnz7m75 select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500095173' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

a96tt00s8p238 select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020254260' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

admybmxruwxkz select * from v$open_cursor where sid = :sid

ahwysj8zsd30w select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020262860' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

an9d6xg6fbtmj select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500357430' order by aae036

c8khjbn635s3c select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

cc6c2x538r8ka select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$06B1000F0002'

chan796pg4jm2 select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$05F400190002'

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

cwdgkwfmp0y16 select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500095173' order by aae036

d21gu7zzgf215 select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500219500' order by aae036

d5pfxagb5v6uy SELECT COUNT(*) FROM ( SELECT ISCODE FROM LQTB_SBDB_GDARCH WHERE UPISCODE(DOWNISCODE1(ISCODE))=:B1 AND STATUS IN(1, 2, 6) UNION ALL SELECT ISCODE FROM LQTB2_SBDB_GDARCH WHERE UPISCODE(DOWNISCODE1(ISCODE))=:B1 AND STATUS IN(1, 2, 6))

dbvwzm2n8dta6 select /*+rule*/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020274129' order by aae036

dm0d8ptk9513r select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500337196' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

fhw2qjm168nwy SELECT SB_PRSENO.NEXTVAL FROM DUAL

fmn92gwtc51h4 select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500219500' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno

ftj9uawt4wwzb select condition from cdef$ where rowid=:1

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

gnkrt49h24x8a select pctfree_stg, pctused_stg, size_stg, initial_stg, next_stg, minext_stg, maxext_stg, maxsiz_stg, lobret_stg, mintim_stg, pctinc_stg, initra_stg, maxtra_stg, optimal_stg, maxins_stg, frlins_stg, flags_stg, bfp_stg, enc_stg, cmpflag_stg, cmplvl_stg from deferred_stg$ where obj# =:1

SQL Id	SQL Text
05qqsnmj8mqy0	BEGIN glog.cutab; END;
0d5uau8pjgfqh	BEGIN tbcbcheck(:1, :2, :3) ; END;
0vm5ju1vzcycd	SELECT UPPER(RTRIM(:B2 )\|\|RTRIM(:B1 )) FROM DUAL
11qxbug0797dh	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$0A07013D0002'
18naypzfmabd6	INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256))
19g0mtxsn2v70	select names.name, stats.statistic#, stats.value from v$sesstat stats, v$statname names where stats.sid = :sid and names.Statistic# = stats.Statistic# order by stats.statistic#
1sykps60snxch	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500285467' order by aae036
2ay2vbw8xvc6j	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020262860' order by aae036
2n21p975xyvpt	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500357430' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
2syvqzbxp4k9z	select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner#
2xyb5d6xg9srh	select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2
35m78h1ywpcju	SELECT SUBSTR(:B2 , 1, 6)\|\|'19'\|\|SUBSTR(:B1 , 7, 9) FROM DUAL
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
3sb1wnct1bv2u	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020264069' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
46669m6rqsgk8	INSERT INTO SBDS_SYSLOGDT VALUES(:B3 , :B2 , 'AAE035', TO_CHAR(:B1 , 'YYYY-MM-DD HH24:MI:SS'), '3')
4by1rhfw5g05u	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020274129' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
4cjj9adqzvwuk	update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$0A07013D0002'
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4yu8rhan7b7fa	update AC01 set AAB001=:1, EAC012=:2, EAC109=:3, AAC002=:4, AAC003=:5, AAC004=:6, AAC006=:7, AAC009=:8, AAC012=:9, AAC013=:10, AAC020=:11, EAB009=:12, EAB010=:13, EAC013=:14, EAC014=:15, EKC002=:16, AAE116=:17, EAC019=:18, ELC001=:19, EJC001=:20, EAC015=:21, EAC016=:22, AAC008=:23, AAE036=:24, AAE011=:25, AAE035=:26 where AAC001=:27
5c22tux2023f1	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500065843' order by aae036
5jrtazrvscxyy	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500065843' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
5ufbf5v4shvh7	SELECT MOD(12 - MOD((SUBSTR(:B1 , 1, 1)7+ SUBSTR(:B1 , 2, 1)9+ SUBSTR(:B1 , 3, 1)10+ SUBSTR(:B1 , 4, 1)5+ SUBSTR(:B1 , 5, 1)8+ SUBSTR(:B1 , 6, 1)4+ SUBSTR(:B1 , 7, 1)2+ SUBSTR(:B1 , 8, 1)1+ SUBSTR(:B1 , 9, 1)6+ SUBSTR(:B1 , 10, 1)3+ SUBSTR(:B1 , 11, 1)7+ SUBSTR(:B1 , 12, 1)9+ SUBSTR(:B1 , 13, 1)10+ SUBSTR(:B1 , 14, 1)5+ SUBSTR(:B1 , 15, 1)8+ SUBSTR(:B1 , 16, 1)4+ SUBSTR(:B1 , 17, 1)*2), 11), 11) FROM DUAL
5vsu32fudzpz7	update sbds_log set ordnum = abs(ordnum) + 1 where userflag = 'ORA$PIPE$05F400190002'
64jvrsys6ybn5	select l.*, o.owner object_owner, o.object_Name from sys.all_objects o, v$lock l where l.sid = :sid and l.type = 'TM' and o.object_id = l.id1
6728s1z0ks8kd	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500149227' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
67jh7macwp54s	Update AC02 Set AAC031= '2', AAE035= to_date('2006-11-28 11:24:48', 'YYYY-MM-DD HH24:MI:SS'), EAC017= to_date('2006-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), EAC018= to_number(800), EAC020= to_date('2006-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') where prseno=129705809
6pzg9zb7k1hkn	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020250001' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
825fvttgrm3bh	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020254260' order by aae036
84cvfffpphf9g	BEGIN glog.dbrol(:1, :2); END;
8rqjzu3ymdqs3	INSERT INTO F_AC01_ERR@YLBXDB VALUES (: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 )
8xx97wgpayb3u	insert into SBDS_USERLOG (FUNCTIONID, AAE002, AAC001, AAB001, PRCOL1, PRCOL2, PRCOL3, PRCOL4, PRCOL5, PRCOL6, PRCOL7, PRCOL8, AAE011, AAE036, AAB034, AAE013, EAE024, OPSENO) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18)
98h9y8qdznwqs	BEGIN PKG_YBJK.p_Ac01(:1, :2, :3, :4, :5, :6, :7); END;
9ns7wbhnz7m75	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500095173' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
a96tt00s8p238	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020254260' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
admybmxruwxkz	select * from v$open_cursor where sid = :sid
ahwysj8zsd30w	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0020262860' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
an9d6xg6fbtmj	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500357430' order by aae036
c8khjbn635s3c	select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', user) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
cc6c2x538r8ka	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$06B1000F0002'
chan796pg4jm2	select opseno, ordnum from sbds_log where userflag = 'ORA$PIPE$05F400190002'
cm5vu20fhtnq1	select /+ connect_by_filtering / privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cwdgkwfmp0y16	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500095173' order by aae036
d21gu7zzgf215	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0500219500' order by aae036
d5pfxagb5v6uy	SELECT COUNT(*) FROM ( SELECT ISCODE FROM LQTB_SBDB_GDARCH WHERE UPISCODE(DOWNISCODE1(ISCODE))=:B1 AND STATUS IN(1, 2, 6) UNION ALL SELECT ISCODE FROM LQTB2_SBDB_GDARCH WHERE UPISCODE(DOWNISCODE1(ISCODE))=:B1 AND STATUS IN(1, 2, 6))
dbvwzm2n8dta6	select /+rule/ opseno, aae002, aac001, aab001, functionid, functiondesc, eae024, aae011, aae036 from v_oplog where aac001='0020274129' order by aae036
dm0d8ptk9513r	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500337196' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
fhw2qjm168nwy	SELECT SB_PRSENO.NEXTVAL FROM DUAL
fmn92gwtc51h4	select nvl(a.aae140, ' ') aae140, decode(eae027, '0', '��', '1', '��ж�', '2', '��ֹ', '3', '��ת��', '4', '��Ϣ��', '��') eae027, nvl(a.eac045, ' ') eac045 , nvl(b.aab001, ' ') eab026 , nvl((select aab004 from ab01 where aab001=b.aab001), ' ') aab004, aac050, aae160, b.aae002, b.aab101, a.eac020, b.aae036, b.aae013 from aca9 a, ac05 b, sbds_syslog c where b.aae074 =a.aae074(+) and a.prseno=c.prseno(+) and b.aac001='0500219500' and b.aac001=a.aac001(+) and b.aab001 =a.aab001(+) and b.eae024 =0 order by aae140 , a.prseno
ftj9uawt4wwzb	select condition from cdef$ where rowid=:1
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
gnkrt49h24x8a	select pctfree_stg, pctused_stg, size_stg, initial_stg, next_stg, minext_stg, maxext_stg, maxsiz_stg, lobret_stg, mintim_stg, pctinc_stg, initra_stg, maxtra_stg, optimal_stg, maxins_stg, frlins_stg, flags_stg, bfp_stg, enc_stg, cmpflag_stg, cmplvl_stg from deferred_stg$ where obj# =:1

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	8	0.00	0.01
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	58	0.02	0.10
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	2	0.00	0.00
Batched IO same unit count	32	0.01	0.05
Batched IO single block count	5	0.00	0.01
Batched IO slow jump count	0	0.00	0.00
Batched IO vector block count	20	0.01	0.03
Batched IO vector read count	5	0.00	0.01
Block Cleanout Optim referenced	59	0.02	0.10
CCursor + sql area evicted	0	0.00	0.00
CPU used by this session	36,838	10.33	62.76
CPU used when call started	34,540	9.68	58.84
CR blocks created	39,118	10.97	66.64
Cached Commit SCN referenced	374	0.10	0.64
Clusterwide global transactions	58	0.02	0.10
Clusterwide global transactions spanning RAC nodes	0	0.00	0.00
Commit SCN cached	171	0.05	0.29
DB time	1,638,104	459.32	2,790.64
DBWR checkpoint buffers written	5,125	1.44	8.73
DBWR checkpoints	1	0.00	0.00
DBWR fusion writes	395	0.11	0.67
DBWR object drop buffers written	0	0.00	0.00
DBWR tablespace checkpoint buffers written	24	0.01	0.04
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	158	0.04	0.27
DBWR undo block writes	800	0.22	1.36
DFO trees parallelized	21	0.01	0.04
DX/BB enqueue lock background get time	2	0.00	0.00
DX/BB enqueue lock background gets	116	0.03	0.20
DX/BB enqueue lock foreground requests	2,316	0.65	3.95
DX/BB enqueue lock foreground wait time	9	0.00	0.02
Effective IO time	0	0.00	0.00
GTX processes spawned by autotune	0	0.00	0.00
GTX processes stopped by autotune	0	0.00	0.00
HSC Heap Segment Block Changes	12,585	3.53	21.44
HSC IDL Compressed Blocks	0	0.00	0.00
Heap Segment Array Inserts	336	0.09	0.57
Heap Segment Array Updates	21	0.01	0.04
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	0	0.00	0.00
PX local messages recv'd	60	0.02	0.10
PX local messages sent	60	0.02	0.10
PX remote messages recv'd	172	0.05	0.29
PX remote messages sent	1,575	0.44	2.68
Parallel operations not downgraded	21	0.01	0.04
RowCR - row contention	142	0.04	0.24
RowCR attempts	1,114	0.31	1.90
RowCR hits	992	0.28	1.69
SMON posted for instance recovery	0	0.00	0.00
SMON posted for undo segment recovery	0	0.00	0.00
SMON posted for undo segment shrink	1	0.00	0.00
SQL*Net roundtrips to/from client	35,091	9.84	59.78
SQL*Net roundtrips to/from dblink	777	0.22	1.32
active txn count during cleanout	41,851	11.73	71.30
application wait time	898,673	251.99	1,530.96
background checkpoints completed	0	0.00	0.00
background checkpoints started	0	0.00	0.00
background timeouts	27,901	7.82	47.53
branch node splits	0	0.00	0.00
buffer is not pinned count	18,608,225	5,217.73	31,700.55
buffer is pinned count	150,244,627	42,128.46	255,953.37
bytes received via SQL*Net from client	8,057,656	2,259.36	13,726.84
bytes received via SQL*Net from dblink	12,520,151	3,510.64	21,329.05
bytes sent via SQL*Net to client	10,093,945	2,830.33	17,195.82
bytes sent via SQL*Net to dblink	305,798	85.75	520.95
calls to get snapshot scn: kcmgss	1,539,568	431.69	2,622.77
calls to kcmgas	48,264	13.53	82.22
calls to kcmgcs	23,413	6.56	39.89
cell physical IO interconnect bytes	394,090,496	110,502.63	671,363.71
change write time	86	0.02	0.15
cleanout - number of ktugct calls	39,931	11.20	68.03
cleanouts and rollbacks - consistent read gets	39,072	10.96	66.56
cleanouts only - consistent read gets	275	0.08	0.47
cluster key scan block gets	29,163	8.18	49.68
cluster key scans	28,507	7.99	48.56
cluster wait time	195	0.05	0.33
commit batch performed	21	0.01	0.04
commit batch requested	21	0.01	0.04
commit batch/immediate performed	80	0.02	0.14
commit batch/immediate requested	80	0.02	0.14
commit cleanout failures: block lost	22	0.01	0.04
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	197	0.06	0.34
commit cleanout failures: cannot pin	4	0.00	0.01
commit cleanouts	8,774	2.46	14.95
commit cleanouts successfully completed	8,551	2.40	14.57
commit immediate performed	59	0.02	0.10
commit immediate requested	59	0.02	0.10
commit txn count during cleanout	993	0.28	1.69
concurrency wait time	471	0.13	0.80
consistent changes	142,017	39.82	241.94
consistent gets	28,173,978	7,899.96	47,996.56
consistent gets - examination	624,588	175.13	1,064.03
consistent gets direct	0	0.00	0.00
consistent gets from cache	28,173,978	7,899.96	47,996.56
consistent gets from cache (fastpath)	27,515,267	7,715.26	46,874.39
cursor authentications	821	0.23	1.40
data blocks consistent reads - undo records applied	141,985	39.81	241.88
db block changes	107,886	30.25	183.79
db block gets	79,471	22.28	135.39
db block gets direct	48	0.01	0.08
db block gets from cache	79,423	22.27	135.30
db block gets from cache (fastpath)	22,365	6.27	38.10
deferred (CURRENT) block cleanout applications	4,114	1.15	7.01
dirty buffers inspected	6	0.00	0.01
enqueue conversions	807	0.23	1.37
enqueue deadlocks	0	0.00	0.00
enqueue releases	51,520	14.45	87.77
enqueue requests	51,551	14.45	87.82
enqueue timeouts	29	0.01	0.05
enqueue waits	304	0.09	0.52
exchange deadlocks	0	0.00	0.00
execute count	1,541,039	432.11	2,625.28
failed probes on index block reclamation	0	0.00	0.00
file io wait time	23,753,909	6,660.58	40,466.63
free buffer inspected	10,605	2.97	18.07
free buffer requested	50,110	14.05	85.37
gc blocks compressed	23,146	6.49	39.43
gc cr block flush time	7,692	2.16	13.10
gc cr block receive time	50	0.01	0.09
gc cr blocks received	1,268	0.36	2.16
gc cr blocks served	28,104	7.88	47.88
gc current block flush time	16	0.00	0.03
gc current block pin time	0	0.00	0.00
gc current block receive time	83	0.02	0.14
gc current blocks received	2,306	0.65	3.93
gc current blocks served	106,662	29.91	181.71
gc kbytes saved	74,194	20.80	126.40
gc kbytes sent	1,003,936	281.50	1,710.28
gc local grants	4,025	1.13	6.86
gc remote grants	2,560	0.72	4.36
gcs messages sent	30,563	8.57	52.07
ges messages sent	6,311	1.77	10.75
global enqueue get time	898,771	252.01	1,531.13
global enqueue gets async	1,403	0.39	2.39
global enqueue gets sync	59,415	16.66	101.22
global enqueue releases	56,655	15.89	96.52
heap block compress	117	0.03	0.20
hot buffers moved to head of LRU	656	0.18	1.12
immediate (CR) block cleanout applications	39,348	11.03	67.03
immediate (CURRENT) block cleanout applications	932	0.26	1.59
index crx upgrade (positioned)	416	0.12	0.71
index fast full scans (full)	63	0.02	0.11
index fetch by key	357,692	100.30	609.36
index scans kdiixs1	263,279	73.82	448.52
leaf node 90-10 splits	53	0.01	0.09
leaf node splits	85	0.02	0.14
lob reads	0	0.00	0.00
lob writes	181	0.05	0.31
lob writes unaligned	181	0.05	0.31
logons cumulative	271	0.08	0.46
max cf enq hold time	10	0.00	0.02
messages received	24,424	6.85	41.61
messages sent	24,424	6.85	41.61
min active SCN optimization applied on CR	11	0.00	0.02
no buffer to keep pinned count	16	0.00	0.03
no work - consistent read gets	27,476,679	7,704.44	46,808.65
non-idle wait count	274,839	77.06	468.21
non-idle wait time	1,294,155	362.88	2,204.69
opened cursors cumulative	1,525,213	427.67	2,598.32
parse count (describe)	48	0.01	0.08
parse count (failures)	47	0.01	0.08
parse count (hard)	2,994	0.84	5.10
parse count (total)	28,345	7.95	48.29
parse time cpu	1,738	0.49	2.96
parse time elapsed	384,317	107.76	654.71
physical read IO requests	3,991	1.12	6.80
physical read bytes	38,543,360	10,807.52	65,661.60
physical read total IO requests	17,771	4.98	30.27
physical read total bytes	264,006,656	74,027.23	449,755.80
physical read total multi block requests	13	0.00	0.02
physical reads	4,705	1.32	8.02
physical reads cache	4,705	1.32	8.02
physical reads cache prefetch	714	0.20	1.22
physical reads direct	0	0.00	0.00
physical reads direct (lob)	0	0.00	0.00
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	4,133	1.16	7.04
physical write bytes	45,056,000	12,633.66	76,756.39
physical write total IO requests	39,937	11.20	68.04
physical write total bytes	130,083,840	36,475.39	221,607.90
physical write total multi block requests	87	0.02	0.15
physical writes	5,500	1.54	9.37
physical writes direct	48	0.01	0.08
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	5,452	1.53	9.29
physical writes non checkpoint	2,336	0.66	3.98
pinned buffers inspected	1	0.00	0.00
pinned cursors current	3	0.00	0.01
prefetch clients - default	0	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	4,912	1.38	8.37
queries parallelized	21	0.01	0.04
recovery blocks read	0	0.00	0.00
recursive calls	1,622,920	455.07	2,764.77
recursive cpu usage	9,201	2.58	15.67
redo KB read	0	0.00	0.00
redo blocks checksummed by FG (exclusive)	4,883	1.37	8.32
redo blocks read for recovery	0	0.00	0.00
redo blocks written	41,339	11.59	70.42
redo buffer allocation retries	0	0.00	0.00
redo entries	79,572	22.31	135.56
redo k-bytes read for recovery	0	0.00	0.00
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	427	0.12	0.73
redo size	15,045,080	4,218.63	25,630.46
redo size for direct writes	416	0.12	0.71
redo subscn max counts	1,016	0.28	1.73
redo synch long waits	72	0.02	0.12
redo synch time	116	0.03	0.20
redo synch time (usec)	1,159,124	325.02	1,974.66
redo synch writes	497	0.14	0.85
redo wastage	5,470,336	1,533.88	9,319.14
redo write broadcast ack count	13,213	3.70	22.51
redo write broadcast ack time	2,956,322	828.95	5,036.32
redo write broadcast lgwr post count	0	0.00	0.00
redo write time	3,158	0.89	5.38
redo writes	16,595	4.65	28.27
remote Oradebug requests	0	0.00	0.00
rollback changes - undo records applied	1,635	0.46	2.79
rollbacks only - consistent read gets	47	0.01	0.08
rows fetched via callback	46,060	12.92	78.47
session connect time	0	0.00	0.00
session cursor cache hits	199,593	55.97	340.02
session logical reads	28,253,450	7,922.24	48,131.94
shared hash latch upgrades - no wait	9,881	2.77	16.83
shared hash latch upgrades - wait	23	0.01	0.04
sorts (memory)	9,996	2.80	17.03
sorts (rows)	886,452	248.56	1,510.14
sql area evicted	0	0.00	0.00
sql area purged	47	0.01	0.08
summed dirty queue length	6	0.00	0.01
switch current to new buffer	1,826	0.51	3.11
table fetch by rowid	84,233,212	23,618.92	143,497.81
table fetch continued row	216	0.06	0.37
table scan blocks gotten	8,350,366	2,341.44	14,225.50
table scan rows gotten	1,838,458,841	515,502.24	3,131,957.14
table scans (direct read)	0	0.00	0.00
table scans (long tables)	10	0.00	0.02
table scans (short tables)	10,751	3.01	18.32
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	300	0.08	0.51
total number of cf enq holders	49	0.01	0.08
total number of times SMON posted	720	0.20	1.23
transaction lock background gets	0	0.00	0.00
transaction lock foreground requests	0	0.00	0.00
transaction lock foreground wait time	0	0.00	0.00
transaction rollbacks	73	0.02	0.12
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	3,777,112	1,059.10	6,434.60
user I/O wait time	2,143	0.60	3.65
user calls	43,237	12.12	73.66
user commits	565	0.16	0.96
user rollbacks	22	0.01	0.04
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	7,003	1.96	11.93
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
session uga memory	4,879,643,999,776	5,012,820,648,960
opened cursors current	367	549
logons current	201	206
session uga memory max	6,871,346,312	7,198,027,416
session pga memory	4,383,297,000	4,521,707,240
session pga memory max	5,153,182,504	5,331,783,368
session cursor cache count	113,298	116,560

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	0	0.00

Back to Instance Activity Statistics
Back to Top

IO Stats

IOStat by Function summary
IOStat by Filetype summary
IOStat by Function/Filetype summary
Tablespace IO Stats
File IO Stats

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	215M	3.86	.060285	41M	0.73	.011496	15.1K	0.05
DBWR	0M	0.00	0M	43M	1.16	.012057	0
LGWR	0M	0.00	0M	40M	9.30	.011215	16.6K	1.42
Buffer Cache Reads	35M	1.12	.009813	0M	0.00	0M	3980	4.96
Direct Writes	0M	0.00	0M	0M	0.00	0M	0
TOTAL:	250M	4.97	.070099	124M	11.19	.034769	35.6K	1.24

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
Control File	215M	3.86	.060285	41M	0.73	.011496	0.03
Data File	40M	1.12	.011215	42M	1.16	.011776	4.97	2.62
Log File	0M	0.00	0M	40M	9.30	.011215
TOTAL:	255M	4.97	.071501	123M	11.19	.034489	1.14	2.62

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	215M	3.86	.060285	41M	0.73	.011496	13.7K	0.03
Others (Control File)	215M	3.86	.060285	41M	0.73	.011496	13.7K	0.03
Others (Data File)	0M	0.00	0M	0M	0.00	0M	0
DBWR	0M	0.00	0M	43M	1.16	.012057	0
DBWR (Data File)	0M	0.00	0M	43M	1.16	.012057	0
LGWR	0M	0.00	0M	40M	9.30	.011215	0
LGWR (Log File)	0M	0.00	0M	40M	9.30	.011215	0
Buffer Cache Reads	35M	1.12	.009813	0M	0.00	0M	3980	4.96
Buffer Cache Reads (Data File)	35M	1.12	.009813	0M	0.00	0M	3980	4.96
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:	250M	4.97	.070099	124M	11.19	.034769	17.7K	1.14

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits
US_DATA	2,870	1	4.64	1.25	1,579	14
US_INDX	996	0	7.24	1.00	1,080	0
SYSAUX	29	0	2.76	1.00	862	0
UNDOTBS2	0	0	0.00	0.00	378	6
USERS	32	0	9.06	1.00	129	0
SYSTEM	48	0	6.88	1.00	104	6
ZJJB2_DATA	15	0	8.67	1.00	0	0

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Rd(ms)	Av Blks/Rd	Writes	Buffer Waits
SYSAUX	+DATADG/lqsi/datafile/sysaux.271.775320273	29	2.76	1.00	862	0
SYSTEM	+DATADG/lqsi/datafile/system.270.775320269	48	6.88	1.00	104	6
UNDOTBS2	+DATADG/lqsi/datafile/undotbs2.274.775320391	0			378	6
USERS	+DATADG/lqsi/datafile/users.281.775320781	32	9.06	1.00	129	0
US_DATA	+DATADG/lqsi/datafile/us_data.278.775320605	803	4.98	1.33	439	6
US_DATA	+DATADG/lqsi/datafile/us_data.292.775323177	825	4.23	1.25	191	0
US_DATA	+DATADG/lqsi/datafile/us_data.293.775323261	708	4.41	1.11	227	8
US_DATA	+DATADG/lqsi/datafile/us_data.294.775416033	534	5.06	1.31	722	0
US_INDX	+DATADG/lqsi/datafile/us_indx.279.775320689	567	6.88	1.00	484	0
US_INDX	+DATADG/lqsi/datafile/us_indx.291.775322997	235	7.57	1.00	325	0
US_INDX	+DATADG/lqsi/datafile/us_indx.295.775416279	194	7.89	1.00	271	0
ZJJB2_DATA	+DATADG/lqsi/datafile/zjjb2_data.285.775320827	15	8.67	1.00	0	0

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	1,224,882	100	28,247,950	4,705	5,452	0	0	26

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 5,500

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	5,101	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	0	745	3455	7888	331776	7888			0
E	0	0	697	18301	28212	331776	28212			0

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

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

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	1,024	0.10	121	4.16	30,713	1	9581.00
D	2,048	0.20	242	1.24	9,147	1	2132.00
D	3,072	0.30	363	1.12	8,256	1	1824.00
D	4,096	0.40	484	1.08	7,968	1	1724.00
D	5,120	0.49	605	1.05	7,776	1	1658.00
D	6,144	0.59	726	1.04	7,656	1	1616.00
D	7,168	0.69	847	1.03	7,587	1	1593.00
D	8,192	0.79	968	1.02	7,559	1	1583.00
D	9,216	0.89	1,089	1.01	7,472	1	1553.00
D	10,240	0.99	1,210	1.00	7,394	1	1526.00
D	10,368	1.00	1,225	1.00	7,389	1	1524.00
D	11,264	1.09	1,331	1.00	7,361	1	1514.00
D	12,288	1.19	1,452	0.99	7,345	1	1509.00
D	13,312	1.28	1,573	0.99	7,341	1	1508.00
D	14,336	1.38	1,694	0.99	7,341	1	1508.00
D	15,360	1.48	1,815	0.99	7,341	1	1508.00
D	16,384	1.58	1,936	0.99	7,341	1	1508.00
D	17,408	1.68	2,057	0.99	7,341	1	1508.00
D	18,432	1.78	2,178	0.99	7,341	1	1508.00
D	19,456	1.88	2,299	0.99	7,341	1	1508.00
D	20,480	1.98	2,420	0.98	7,261	1	1480.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	775	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	6,318	6,318
64K	128K	48	48
128K	256K	4	4
256K	512K	4	4
512K	1024K	536	536
1M	2M	76	76
2M	4M	6	6
4M	8M	6	6
8M	16M	10	10
32M	64M	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 Time
4,144	0.13	28,619.92	90.17	100.00	3,245,691
8,288	0.25	28,619.92	90.17	100.00	3,245,691
16,576	0.50	28,619.92	90.17	100.00	3,245,691
24,864	0.75	28,619.92	90.17	100.00	3,245,691
33,152	1.00	28,619.92	90.17	100.00	3,245,691
39,782	1.20	28,619.92	0.00	100.00	3,235,498
46,413	1.40	28,619.92	0.00	100.00	3,235,498
53,043	1.60	28,619.92	0.00	100.00	3,235,498
59,674	1.80	28,619.92	0.00	100.00	3,235,498
66,304	2.00	28,619.92	0.00	100.00	3,235,498
99,456	3.00	28,619.92	0.00	100.00	3,235,498
132,608	4.00	28,619.92	0.00	100.00	3,235,498
198,912	6.00	28,619.92	0.00	100.00	3,235,498

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)
2,304	0.30	211	12,393	36,961	1.00	18,495	1.00	3,551
3,072	0.40	988	52,354	36,970	1.00	18,486	1.00	13,120
3,840	0.50	1,617	72,257	36,997	1.00	18,459	1.00	13,125
4,608	0.60	1,803	78,206	36,997	1.00	18,459	1.00	13,125
5,376	0.70	1,803	78,206	36,997	1.00	18,459	1.00	13,125
6,144	0.80	1,803	78,206	36,997	1.00	18,459	1.00	13,125
6,912	0.90	1,803	78,206	36,997	1.00	18,459	1.00	13,125
7,680	1.00	1,803	78,206	36,997	1.00	18,459	1.00	13,125
8,448	1.10	1,803	78,206	36,997	1.00	18,459	1.00	13,125
9,216	1.20	1,803	78,206	36,997	1.00	18,459	1.00	13,125
9,984	1.30	1,803	78,206	36,997	1.00	18,459	1.00	13,125
10,752	1.40	1,803	78,206	36,997	1.00	18,459	1.00	13,125
11,520	1.50	1,803	78,206	36,997	1.00	18,459	1.00	13,125
12,288	1.60	1,803	78,206	36,997	1.00	18,459	1.00	13,125
13,056	1.70	1,803	78,206	36,997	1.00	18,459	1.00	13,125
13,824	1.80	1,803	78,206	36,997	1.00	18,459	1.00	13,125
14,592	1.90	1,803	78,206	36,997	1.00	18,459	1.00	13,125
15,360	2.00	1,803	78,206	36,997	1.00	18,459	1.00	13,125

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
6,912	0.38	51,518	8,020,428
9,216	0.50	51,411	7,705,640
11,520	0.63	51,349	7,520,906
13,824	0.75	51,308	7,408,587
16,128	0.88	51,267	7,393,070
18,432	1.00	51,267	7,389,375
20,736	1.13	51,267	7,389,375
23,040	1.25	51,267	7,308,092
25,344	1.38	51,241	7,308,092
27,648	1.50	51,241	7,308,092
29,952	1.63	51,241	7,308,092
32,256	1.75	51,241	7,308,092
34,560	1.88	51,241	7,308,092
36,864	2.00	51,241	7,308,092

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	18	0	0
undo block	6	0	0
segment header	2	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

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

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
TX-Transaction (row lock contention)	68	66	2	68	8,985	132,136.18
JQ-Job Queue	57	33	24	33	0	0.91
TM-DML	6,486	6,486	0	25	0	1.20
WF-AWR Flush	23	23	0	18	0	0.56
CF-Controlfile Transaction	7,736	7,736	0	10	0	1.00
PS-PX Process Reservation	192	192	0	101	0	0.00
TA-Instance Undo	24	24	0	12	0	0.00
FB-Format Block	26	26	0	7	0	0.00
TD-KTF map table enqueue (KTF dump entries)	11	11	0	7	0	0.00
PI-Remote PX Process Spawn Status	5	5	0	5	0	0.00
CR-Reuse Block Range (block range reuse ckpt)	20	20	0	4	0	0.00
HW-Segment High Water Mark	1,389	1,389	0	3	0	0.00
PW-Buffer Cache PreWarm (flush prewarm buffers)	3	0	3	3	0	0.00
DR-Distributed Recovery	2	2	0	2	0	0.00
MW-MWIN Schedule	2	2	0	2	0	0.00
AF-Advisor Framework (task serialization)	13	13	0	1	0	0.00
KO-Multiple Object Checkpoint (fast object checkpoint)	4	4	0	1	0	0.00
US-Undo Segment	1	1	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

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

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
4	0.59	2,299	2,226	15	26.3/51.1	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
06-Nov 09:51	125	513	903	15	29	0/0	0/0/0/0/0/0
06-Nov 09:41	94	479	302	12	34	0/0	0/0/0/0/0/0
06-Nov 09:31	47	205	739	5	26	0/0	0/0/0/0/0/0
06-Nov 09:21	92	413	2,226	2	51	0/0	0/0/0/0/0/0
06-Nov 09:11	28	354	743	3	26	0/0	0/0/0/0/0/0
06-Nov 09:01	205	335	1,023	4	35	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
AQ dequeue txn counter latch	832	0.00		0
ASM Keyed state latch	320	0.00		0
ASM allocation	58	0.00		0
ASM db client latch	2,448	0.00		0
ASM map operation freelist	70	0.00		0
ASM map operation hash table	115,429	0.00	0.00	0
ASM network background latch	1,479	0.00		0
ASM network state latch	160	0.00		0
AWR Alerted Metric Element list	36,065	0.00		0
Change Notification Hash table latch	1,190	0.00		0
Consistent RBA	16,595	0.00		0
DML lock allocation	16,855,308	0.00		0
Event Group Locks	164	0.00		0
FIB s.o chain latch	12	0.00		0
FOB s.o list latch	621	0.00		0
File State Object Pool Parent Latch	1	0.00		0
I/O Staticstics latch	1	0.00		0
IPC other latch	31	0.00		0
IPC stats buffer allocation latch	643	0.00		697	0.00
In memory undo latch	1	0.00		0
JS Sh mem access	9	0.00		0
JS broadcast add buf latch	818	0.00		0
JS broadcast drop buf latch	818	0.00		0
JS broadcast load blnc latch	716	0.00		0
JS queue access latch	1	0.00		0
JS queue state obj latch	25,776	0.00		0
JS slv state obj latch	227	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
KFK SGA Libload latch	714	0.00		0
KFMD SGA	3	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,118	0.18	0.50	87	0.00
KJCT flow control latch	57,238	0.00		0
KMG MMAN ready and startup request latch	1,188	0.00		0
KSXR large replies	2	0.00		0
KTF sga latch	34	0.00		1,000	0.00
KWQMN job cache list latch	252	0.00		0
KWQS pqsubs latch	2	0.00		0
KWQS pqueue ctx latch	47	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	2,100	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,188	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	2,451	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	1,318	0.00		0
OS process allocation	7,980	0.00		0
OS process: request allocation	320	0.00		0
PL/SQL warning settings	1,014	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	9,027	0.00		0
SGA IO buffer pool latch	1	0.00		1	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	119	0.00		1,187	0.00
SQL memory manager workarea list latch	87,213	0.00		0
Shared B-Tree	266	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	3	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	9,007	0.43	0.00	0
active service list	268,754	0.00	0.33	50,049	0.00
begin backup scn array	8	0.00		0
buffer pool	1	0.00		0
business card	43	0.00		0
cache buffer handles	7,577	0.00		0
cache buffers chains	56,716,756	0.24	0.00	94,301	0.00
cache buffers lru chain	11,942	0.01	0.00	246,783	0.00
cache table scan latch	108	0.00		108	0.00
call allocation	1,643	0.12	0.00	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	367	0.00		0
channel operations parent latch	537,063	0.00	0.00	0
checkpoint queue latch	1,108,348	0.00		5,752	0.00
client/application info	1,510	0.00		0
compile environment latch	275	0.00		0
corrupted undo seg latch	4,978	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	62	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	62	0.00		0
dml lock allocation	62	0.00		0
done queue latch	1	0.00		0
dummy allocation	546	0.00		0
enqueue hash chains	122,001	0.04	0.58	13,789	0.01
enqueues	83,789	0.00	0.00	0
error message lists	93	0.00		0
fifth spare latch	1	0.00		0
file cache latch	634	0.00		0
flashback copy	1	0.00		0
fourth Audit Vault latch	1	0.00		0
gc element	248,525	0.00	0.50	127	0.00
gcs commit scn state	1	0.00		0
gcs opaque info freelist	113,774	0.51	0.01	0
gcs partitioned table hash	5,491,045	0.01	0.00	3,636	0.00
gcs pcm hashed value bucket hash	1	0.00		0
gcs remaster request queue	1	0.00		0
gcs remastering latch	146,011	0.01	0.00	0
gcs resource freelist	57,682	0.00		9,981	0.00
gcs resource hash	322,144	0.00	0.00	3	0.00
gcs resource scan list	8	0.00		0
gcs shadows freelist	65,919	0.00		64,842	0.00
ges caches resource lists	29,550	0.00		41,353	0.00
ges deadlock list	410	0.00		3,316	0.00
ges domain table	120,432	0.00		0
ges enqueue table freelist	114,548	0.00		0
ges group table	116,001	0.00		0
ges process hash list	1,232,830	0.00	0.11	0
ges process parent latch	236,854	0.00		0
ges process table freelist	320	0.00		0
ges resource hash list	208,014	0.01	0.09	3,615	0.00
ges resource scan list	231	0.00		0
ges resource table freelist	2,119	0.00		0
ges timeout list	894	0.00		1,384	0.00
ges value block free list	2,599	0.00		0
global KZLD latch for mem in SGA	19	0.00		0
global tx hash mapping	1,008	0.00		0
granule operation	1	0.00		0
hash table column usage latch	465	0.00		266,532	0.00
hash table modification latch	140	0.00		0
heartbeat check	1	0.00		3,339	0.00
heartbeat structure management	0			713	0.00
internal temp table object number allocation latch	77	0.00		0
interrupt manipulation	670	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	58	0.00		57	0.00
job_queue_processes free list latch	114	0.00		0
job_queue_processes parameter latch	806	0.00		0
k2q global data latch	2,622	0.00		0
k2q lock allocation	1,661	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	256	0.00		0
ksfv messages	1	0.00		0
ksim group membership cache	197	0.00		0
ksim membership request latch	0			1,659	0.00
kss move lock	45	0.00		0
ksuosstats global area	240	0.00		0
ksv allocation latch	150	0.00		0
ksv class latch	6,780	0.01	0.00	0
ksv instance latch	16	0.00		0
ksv msg queue latch	1	0.00		0
ksxp shared latch	320	0.00		0
ksxp so latch	320	0.00		0
ksz_so allocation latch	320	0.00		0
ktm global data	1,482	0.00		0
kwqbsn:qsga	124	0.00		0
lgwr LWN SCN	17,746	0.06	0.00	0
list of block allocation	430	0.00		0
loader state object freelist	6	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	5,062	0.00		0
messages	231,864	0.02	0.00	0
mostly latch-free SCN	18,387	3.08	0.00	0
msg queue latch	1	0.00		0
multiblock read objects	788	0.00		0
name-service memory objects	3,944	0.00		0
name-service namespace bucket	27,200	0.00		0
name-service namespace objects	7	0.00		0
name-service pending queue	1,854	0.00		0
name-service request	26	0.00		0
name-service request queue	36,861	0.00		0
ncodef allocation latch	62	0.00		0
object queue header heap	73,030	0.00		945	0.00
object queue header operation	178,191	0.00	0.00	0
object stats modification	136	0.00		0
parallel query alloc buffer	1,338	0.00		0
parallel query stats	144	0.00		0
parallel txn reco latch	20,376	0.00		0
parameter list	325	0.00		0
parameter table management	1,735	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	27,394	0.01	0.00	16,896	0.00
process allocation	17,649	0.00		163	0.00
process group creation	320	0.00		0
process queue	400	0.00		0
process queue reference	16,678	0.00		2,020	0.00
qmn task queue latch	505	0.00		0
query server freelists	305	0.00		0
query server process	5	0.00		4	0.00
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	52,065	0.04	0.00	79,499	0.02
redo copy	1	0.00		79,513	0.20
redo writing	61,284	0.04	0.00	0
resmgr group change latch	377	0.00		0
resmgr:active threads	546	0.00		0
resmgr:actses change group	156	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	545	0.18	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	21	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	1,625,204	0.00	0.00	0
rules engine aggregate statistics	1	0.00		0
rules engine rule set statistics	2	0.00		0
second Audit Vault latch	1	0.00		0
second spare latch	1	0.00		0
sequence cache	5,408	0.00		0
session allocation	3,276	0.00		2,779	0.00
session idle bit	88,993	0.00		0
session queue latch	1	0.00		0
session state list latch	616	0.00		0
session switching	848	0.00		0
session timer	1,192	0.00		0
shared pool	235,375	0.00	0.00	0
shared pool sim alloc	198	0.00		0
shared pool simulator	8,002	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	1,747,443	0.00		0
simulator lru latch	1	0.00		1,746,780	0.47
sort extent pool	847	0.00		0
space background state object latch	10	0.00		0
space background task latch	3,134	0.06	0.00	2,380	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	2	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	317	0.00		0
transaction allocation	4,187,728	0.00		0
transaction branch allocation	1,444	0.00		0
undo global data	95,686	0.00		0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	56,716,756	138,625	12	138,613
gcs opaque info freelist	113,774	578	4	574
mostly latch-free SCN	18,387	567	1	566
enqueue hash chains	122,001	50	29	21
ges process hash list	1,232,830	27	3	24
ges resource hash list	208,014	11	1	10
gc element	248,525	4	2	2
active service list	268,754	3	1	2
KJC message pool free list	1,118	2	1	1

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
KJC message pool free list	kjcsmpav: allocate a msg buffer	1	2
active service list	kswsite: service iterator	1	0
cache buffers chains	kcbgtcr: fast path	5	0
cache buffers chains	kcbgcur_2	4	0
cache buffers chains	kcbgtcr: fast path (cr pin)	2	2
cache buffers chains	kcbchg1: kslbegin: call CR func	1	1
cache buffers chains	kcbgtcr_2	1	3
cache buffers chains	kcbrls_2	1	5
cache buffers chains	kcbzwb	1	0
enqueue hash chains	ksqgtl3	19	25
enqueue hash chains	ksqexpandres	8	0
enqueue hash chains	ksqcmi: if lk mode not requested	1	0
enqueue hash chains	ksqexpandwait	1	0
gc element	kclchkping	1	0
gc element	kclnfndnewm	1	0
gcs opaque info freelist	kjbrcvt save opaque info	4	3
ges process hash list	kjakiqa: set inquiry response	3	0
ges resource hash list	kjrmas1: lookup master node	1	0
lgwr LWN SCN	kcs023	1	0

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Cursor Pin	kksfbc [KKSCHLFSP2]	4	11
Library Cache	kgllkdl1 85	3	0
Library Cache	kgllkc1 57	2	0
Library Cache	kglhdgn1 62	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received

Segments by Logical Reads

Total Logical Reads: 28,253,450
Captured Segments account for 98.6% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
LQSI	US_DATA	SBDS_USERLOG	TABLE	18,319,088	64.84
LQSI	US_DATA	SBDS_SYSLOG	TABLE	6,841,728	24.22
LQSI	US_INDX	IDX_SBDS_USERLOG	INDEX	717,520	2.54
LQSI	US_DATA	AC01	TABLE	403,552	1.43
LQSI	US_DATA	ABC3	TABLE	295,296	1.05

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.28	Soft Parse %:	89.44
Execute to Parse %:	98.16	Latch Hit %:	99.85
Parse CPU to Parse Elapsd %:	0.45	% Non-Parse CPU:	95.03

Buffer access - local cache %:	99.97
Buffer access - remote cache %:	0.01
Buffer access - disk %:	0.02

Avg global enqueue get time (ms):	147.8
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.4
Avg global cache cr block build time (ms):	0.0
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	96.7
Avg global cache cr block flush time (ms):	2.8
Avg global cache current block pin time (ms):	0.0
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.0
Avg global cache current block flush time (ms):	7.3

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.4
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	85.21
% of indirect sent messages:	14.74
% of flow controlled messages:	0.06

Owner	Tablespace Name	Object Name	Obj. Type	Physical Reads	%Total
LQSI	US_DATA	ACA6	TABLE	1,511	32.11
LQSI	US_DATA	AB09	TABLE	92	1.96
LQSI	US_DATA	DB04	TABLE	75	1.59
LQSI	US_INDX	PK_AAA040	INDEX	38	0.81
LQSI	US_DATA	MLOG$_IC02	TABLE	18	0.38

Owner	Tablespace Name	Object Name	Obj. Type	Physical Writes	%Total
LQSI	US_DATA	BIN$6n++nmSxO8zgQBCsC6A8Dg==$0	TABLE	358	6.51
LQSI	US_INDX	IDX_SBDS_USERLOG	INDEX	122	2.22
SYSMAN	SYSAUX	MGMT_METRICS_RAW_PK	INDEX	109	1.98
LQSI	US_DATA	AC02	TABLE	99	1.80
LQSI	US_INDX	PK_AAA040	INDEX	90	1.64

Owner	Tablespace Name	Object Name	Obj. Type	DB Block Changes	% of Capture
LQSI	US_DATA	SBDS_LOG	TABLE	177,536	88.12
LQSI	US_DATA	SBDS_SYSLOG	TABLE	3,792	1.88
LQSI	US_INDX	PK_SBDS_LOG	INDEX	3,600	1.79
LQSI	US_INDX	PK_SBDS_SYSLOGDT	INDEX	1,856	0.92
LQSI	US_DATA	SBDS_SYSLOGDT	TABLE	1,744	0.87

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	68	1.47	1	1
dc_files	26	0.00	0	26
dc_global_oids	505	0.00	0	148
dc_histogram_data	167,448	0.18	0	11,343
dc_histogram_defs	91,411	0.41	0	9,917
dc_object_grants	2	0.00	0	103
dc_objects	213,441	0.02	0	6,886
dc_profiles	50	0.00	0	1
dc_rollback_segments	43,877	0.00	0	851
dc_segments	35,127	0.02	7	3,378
dc_sequences	822	1.09	822	17
dc_table_scns	369	0.81	0	26
dc_tablespaces	39,497	0.00	0	23
dc_users	52,292	0.00	0	201
global database name	4,479	0.00	0	2
outstanding_alerts	110	93.64	1	19

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
ACCOUNT_STATUS	38	0.00	0		0	0
BODY	884	0.00	7,258	0.00	0	0
CLUSTER	45	0.00	45	0.00	0	0
DBLINK	519	0.00	0		0	0
EDITION	70	0.00	120	0.00	0	0
INDEX	158	0.00	158	0.00	0	0
QUEUE	748	0.00	917	0.00	0	0
RULESET	0		1	0.00	0	0
SCHEMA	83	0.00	0		0	0
SQL AREA	9,515	27.17	1,558,413	0.56	126	47
SQL AREA BUILD	2,952	87.74	0		0	0
SQL AREA STATS	2,952	95.73	2,952	95.73	0	0
SUBSCRIPTION	9	0.00	9	0.00	0	0
TABLE/PROCEDURE	7,192	0.19	33,712	0.25	4	0
TRANSFORMATION	357	0.00	357	0.00	0	0
TRIGGER	835	1.20	3,048	0.33	0	0

Namespace	GES Lock Requests	GES Pin Requests	GES Pin Releases
ACCOUNT_STATUS	38	0	0
BODY	0	7,179	7,179
CLUSTER	45	45	45
DBLINK	519	0	0
EDITION	70	70	70
INDEX	158	158	158
QUEUE	357	917	917
RULESET	0	1	1
SCHEMA	50	0	0
SUBSCRIPTION	0	9	9
TABLE/PROCEDURE	10,611	21,190	21,190
TRANSFORMATION	357	357	357
TRIGGER	0	3,048	3,048

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	10,368.00	10,368.00	10,368.00	10,368.00	INI/
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	33,152.00	33,152.00	33,152.00	33,152.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	18,432.00	18,432.00	18,432.00	18,432.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	128.00	128.00	128.00	128.00	STA/
large pool	128.00	128.00	128.00	128.00	STA/
shared pool	7,552.00	7,552.00	7,552.00	7,552.00	STA/
streams pool	0.00	0.00	0.00	0.00	STA/

	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	418.84		2.06	3.78	27	27	203	203
	Freeable	48.69	0.00	1.80	4.27	22		27	27
	PL/SQL	5.09	4.08	0.03	0.12	1	1	201	201
	SQL	3.36	1.57	0.02	0.03	0	51	172	167
E	Other	449.90		2.15	3.74	27	27	209	209
	Freeable	54.44	0.00	1.47	3.68	22		37	37
	PL/SQL	10.75	8.93	0.05	0.17	1	1	207	206
	SQL	4.76	1.82	0.03	0.04	0	49	177	170

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	10,871,635,968
Fixed Size	2,239,232
Redo Buffers	24,711,168
Variable Size	42,949,674,240

Pool	Name	Begin MB	End MB	% Diff
java	free memory	128.00	128.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	119.81	119.81	0.00
shared	KGLH0	591.13	625.38	5.79
shared	KGLHD	101.27	106.83	5.49
shared	SQLA	1,478.12	1,567.52	6.05
shared	db_block_hash_buckets	89.00	89.00	0.00
shared	free memory	4,134.11	4,000.26	-3.24
shared	gcs resources	214.85	214.85	0.00
shared	gcs shadows	158.31	158.31	0.00
	buffer_cache	10,368.00	10,368.00	0.00
	fixed_sga	2.14	2.14	0.00
	log_buffer	23.57	23.57	0.00

Name	Total Disp Time (s)	%Busy	%Idle
D000	3,566	0.00	100.00
D000	3,566	0.00	100.00
D000	3,566	0.00	100.00
D000	3,566	0.00	100.00
Sum
Avg		0.00	100.00
Std		0.00	0.00

Parameter Name	Begin value	End value (if different)
_dbms_sql_security_level	384
_external_scn_rejection_threshold_hours	24
audit_file_dest	/oracle/product/admin/lqsi/adump
audit_trail	DB
cluster_database	TRUE
compatible	11.2.0.0.0
control_files	+DATADG/lqsi/controlfile/current.267.775320265, +FRADG/lqsi/controlfile/current.259.775320265
db_block_size	8192
db_create_file_dest	+DATADG
db_domain
db_name	lqsi
db_recovery_file_dest	+FRADG
db_recovery_file_dest_size	1604321280000
diagnostic_dest	/oracle/product
dispatchers	(PROTOCOL=TCP) (SERVICE=lqsiXDB)
instance_number	2
local_listener	(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.160.14)(PORT=1521))))
memory_target	54089744384
nls_language	AMERICAN
nls_territory	AMERICA
open_cursors	300
processes	2000
remote_listener	lqsb-scan:1521
remote_login_passwordfile	EXCLUSIVE
resource_limit	TRUE
sec_case_sensitive_logon	FALSE
sessions	3040
spfile	+DATADG/lqsi/spfilelqsi.ora
thread	2
undo_tablespace	UNDOTBS2

Parameter Name	Begin value	End value (if different)
control_files	+DATADG/lqsi/controlfile/current.267.775320265
	+FRADG/lqsi/controlfile/current.259.775320265

Statistic	Total	per Second	per Trans
acks for commit broadcast(actual)	3,457	0.97	5.89
acks for commit broadcast(logical)	3,509	0.98	5.98
broadcast msgs on commit(actual)	13,233	3.71	22.54
broadcast msgs on commit(logical)	16,551	4.64	28.20
broadcast msgs on commit(wasted)	273	0.08	0.47
dynamically allocated gcs resources	0	0.00	0.00
dynamically allocated gcs shadows	0	0.00	0.00
flow control messages received	0	0.00	0.00
flow control messages sent	0	0.00	0.00
gcs apply delta	0	0.00	0.00
gcs assume cvt	0	0.00	0.00
gcs assume no cvt	55,071	15.44	93.82
gcs ast xid	0	0.00	0.00
gcs blocked converts	997	0.28	1.70
gcs blocked cr converts	963	0.27	1.64
gcs compatible basts	28	0.01	0.05
gcs compatible cr basts (global)	83	0.02	0.14
gcs compatible cr basts (local)	56,087	15.73	95.55
gcs cr basts to PIs	0	0.00	0.00
gcs cr serve without current lock	0	0.00	0.00
gcs dbwr flush pi msgs	294	0.08	0.50
gcs dbwr write request msgs	247	0.07	0.42
gcs delta msgs sent	0	0.00	0.00
gcs delta push aborted by cancel	0	0.00	0.00
gcs delta push aborted by remastering	0	0.00	0.00
gcs delta push cancelled	0	0.00	0.00
gcs delta push cancelled at master	0	0.00	0.00
gcs delta push cancelled by close	0	0.00	0.00
gcs delta push cancelled by consign	0	0.00	0.00
gcs delta push cancelled by cvt ping	0	0.00	0.00
gcs delta push cancelled by dwncvt	0	0.00	0.00
gcs delta push create pi	0	0.00	0.00
gcs delta update master msgs sent	0	0.00	0.00
gcs delta wait aborted by remastering	0	0.00	0.00
gcs delta wait cancelled	0	0.00	0.00
gcs error msgs	0	0.00	0.00
gcs force cr block only	1	0.00	0.00
gcs force cr grant	0	0.00	0.00
gcs force cr no current	0	0.00	0.00
gcs forward cr to pinged instance	0	0.00	0.00
gcs immediate (compatible) converts	397	0.11	0.68
gcs immediate (null) converts	1,099	0.31	1.87
gcs immediate cr (compatible) converts	0	0.00	0.00
gcs immediate cr (null) converts	10,566	2.96	18.00
gcs indirect ast	5,990	1.68	10.20
gcs indirect bidless ast	0	0.00	0.00
gcs indirect fg ast	5,990	1.68	10.20
gcs lms flush pi msgs	0	0.00	0.00
gcs lms write request msgs	90	0.03	0.15
gcs msgs process time(ms)	7,785	2.18	13.26
gcs msgs received	230,165	64.54	392.10
gcs new served by master	562	0.16	0.96
gcs out-of-order msgs	0	0.00	0.00
gcs pings refused	1	0.00	0.00
gcs pkey conflicts retry	0	0.00	0.00
gcs push delta	0	0.00	0.00
gcs queued converts	2	0.00	0.00
gcs reader bypass N->Xw ping local	0	0.00	0.00
gcs reader bypass N->Xw ping remote	0	0.00	0.00
gcs reader bypass grant X on assume	0	0.00	0.00
gcs reader bypass grant ast	0	0.00	0.00
gcs reader bypass grant fg ast	0	0.00	0.00
gcs reader bypass grant immediate	0	0.00	0.00
gcs recovery claim msgs	0	0.00	0.00
gcs refuse xid	0	0.00	0.00
gcs regular cr	0	0.00	0.00
gcs retry convert request	0	0.00	0.00
gcs share recovery bast	0	0.00	0.00
gcs side channel msgs actual	1,096	0.31	1.87
gcs side channel msgs logical	5,245	1.47	8.94
gcs stale cr	0	0.00	0.00
gcs undo cr	2	0.00	0.00
gcs write notification msgs	6	0.00	0.01
gcs writes refused	0	0.00	0.00
ges msgs process time(ms)	286	0.08	0.49
ges msgs received	6,298	1.77	10.73
global posts dropped	0	0.00	0.00
global posts queue time	84	0.02	0.14
global posts queued	47	0.01	0.08
global posts requested	47	0.01	0.08
global posts sent	47	0.01	0.08
implicit batch messages received	5,167	1.45	8.80
implicit batch messages sent	95	0.03	0.16
lmd msg send time(ms)	3	0.00	0.01
lms(s) msg send time(ms)	0	0.00	0.00
messages flow controlled	15	0.00	0.03
messages queue sent actual	6,233	1.75	10.62
messages queue sent logical	268	0.08	0.46
messages received actual	65,125	18.26	110.95
messages received logical	236,464	66.30	402.83
messages sent directly	22,072	6.19	37.60
messages sent indirectly	3,817	1.07	6.50
messages sent not implicit batched	1	0.00	0.00
messages sent pbatched	11,401	3.20	19.42
msgs causing lmd to send msgs	2,429	0.68	4.14
msgs causing lms(s) to send msgs	1,011	0.28	1.72
msgs received queue time (ms)	1,191	0.33	2.03
msgs received queued	236,463	66.30	402.83
msgs sent queue time (ms)	219	0.06	0.37
msgs sent queue time on ksxp (ms)	13,079	3.67	22.28
msgs sent queued	6,339	1.78	10.80
msgs sent queued on ksxp	32,246	9.04	54.93
number of broadcasted resources	0	0.00	0.00
number of ges deadlock detected	0	0.00	0.00
process batch messages received	27,561	7.73	46.95
process batch messages sent	6,874	1.93	11.71
	0	0.00	0.00

Statistic	Total
CR Block Requests	28,026
CURRENT Block Requests	66
Data Block Requests	28,026
Undo Block Requests	2
TX Block Requests	20
Current Results	946
Private results	26,915
Zero Results	231
Disk Read Results	0
Fail Results	0
Fairness Down Converts	513
Fairness Clears	85
Free GC Elements	0
Flushes	27,183
Flushes Queued	0
Flush Queue Full	0
Flush Max Time (us)	0
Light Works	4
Errors	0

Statistic	Total	% <1ms	% <10ms	% <100ms	% <1s	% <10s
Pins	3	100.00	0.00	0.00	0.00	0.00
Flushes	22	31.82	50.00	18.18	0.00	0.00
Writes	395	59.75	36.96	1.52	0.25	1.52

WORKLOAD REPOSITORY report for

Report Summary

RAC Statistics

Main Report

More RAC Statistics

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

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

SQL ordered by Cluster Wait Time

Complete List of SQL Text

Instance Activity Statistics

Instance Activity Stats

Instance Activity Stats - Absolute Values

Instance Activity Stats - Thread Activity

IO Stats

IOStat by Function summary

IOStat by Filetype summary

IOStat by Function/Filetype summary

Tablespace IO Stats

File IO Stats

Buffer Pool Statistics

Buffer Pool Statistics

Checkpoint Activity

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

Wait Statistics

Buffer Wait Statistics

Enqueue Activity

Undo Statistics

Undo Segment Summary

Undo Segment Stats

Latch Statistics

Latch Activity

Latch Sleep Breakdown

Latch Miss Sources

Mutex Sleep Summary

Parent Latch Statistics

Child Latch Statistics

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

Inst No	Block Class	Blocks Received	% Immed	% Busy	% Congst	Blocks Received	% Immed	% Busy	% Congst
		CR				Current
1	data block	893	93.95	0.67	5.38	2,193	97.95	0.68	1.37
1	undo header	317	98.11	0.95	0.95	7	85.71	14.29	0.00
1	Others	69	98.55	0.00	1.45	86	98.84	1.16	0.00

Inst No	Block Class	All	Immed	Busy	Congst	All	Immed	Busy	Congst
		CR Avg Time (ms)				Current Avg Time (ms)
1	data block	0.55	0.50	4.28	0.98	0.40	0.36	4.79	0.88
1	undo header	0.22	0.20	1.48	0.30	1.13	0.30	6.08
1	others	0.35	0.35		0.32	0.26	0.25	0.91
1	undo block

Used By	Send Mbytes/sec	Receive Mbytes/sec
Global Cache	0.27	0.01
Parallel Query	0.01	0.00
DB Locks	0.00	0.02
DB Streams	0.00	0.00
Other	0.01	0.00