WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

SDSLDB 3951945579 SDSLDB1 1 16-Nov-12 20:11 11.2.0.3.0 YES

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
SDSLDB	3951945579	SDSLDB1	1	16-Nov-12 20:11	11.2.0.3.0	YES

Host Name Platform CPUs Cores Sockets Memory (GB)

SDSLDB1 Linux x86 64-bit 160 80 8 504.72

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
SDSLDB1	Linux x86 64-bit	160	80	8	504.72

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 143 22-Nov-12 09:00:30 90 1.5

End Snap: 157 22-Nov-12 23:00:44 73 .7

Elapsed: 840.23 (mins)

DB Time: 703.76 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	143	22-Nov-12 09:00:30	90	1.5
End Snap:	157	22-Nov-12 23:00:44	73	.7
Elapsed:		840.23 (mins)
DB Time:		703.76 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 192,512M 192,512M Std Block Size: 8K

Shared Pool Size: 51,200M 51,200M Log Buffer: 426,124K

	Begin	End
Buffer Cache:	192,512M	192,512M	Std Block Size:	8K
Shared Pool Size:	51,200M	51,200M	Log Buffer:	426,124K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.8 0.3 0.02 0.02

DB CPU(s): 0.4 0.1 0.01 0.01

Redo size: 18,065.1 7,205.6

Logical reads: 5,443.2 2,171.1

Block changes: 149.3 59.6

Physical reads: 1.0 0.4

Physical writes: 6.5 2.6

User calls: 38.9 15.5

Parses: 3.7 1.5

Hard parses: 0.2 0.1

W/A MB processed: 1.1 0.4

Logons: 0.8 0.3

Executes: 48.1 19.2

Rollbacks: 0.0 0.0

Transactions: 2.5

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.8	0.3	0.02	0.02
DB CPU(s):	0.4	0.1	0.01	0.01
Redo size:	18,065.1	7,205.6
Logical reads:	5,443.2	2,171.1
Block changes:	149.3	59.6
Physical reads:	1.0	0.4
Physical writes:	6.5	2.6
User calls:	38.9	15.5
Parses:	3.7	1.5
Hard parses:	0.2	0.1
W/A MB processed:	1.1	0.4
Logons:	0.8	0.3
Executes:	48.1	19.2
Rollbacks:	0.0	0.0
Transactions:	2.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.15 Soft Parse %: 95.50

Execute to Parse %: 92.41 Latch Hit %: 100.00

Parse CPU to Parse Elapsd %: 88.77 % Non-Parse CPU: 95.32

Shared Pool Statistics

Begin End

Memory Usage %: 26.80 27.56

% SQL with executions>1: 95.65 99.17

% Memory for SQL w/exec>1: 93.95 97.53

	Begin	End
Memory Usage %:	26.80	27.56
% SQL with executions>1:	95.65	99.17
% Memory for SQL w/exec>1:	93.95	97.53

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		18,228		43.17
ges inquiry response	49,384,771	13,890	0	32.89	Other
transaction	5,314	5,317	1001	12.59	Other
SQL*Net message from dblink	1,271,667	1,365	1	3.23	Network
PX Nsq: PQ load info query	5,773	1,135	197	2.69	Other

Host CPU (CPUs: 160 Cores: 80 Sockets: 8)

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

1.39 0.02 0.5 0.2 0.1 99.2

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
1.39	0.02	0.5	0.2	0.1	99.2

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

0.5 64.4 0.0

Memory Statistics

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

Begin End

Host Mem (MB): 516,829.8 516,829.8

SGA use (MB): 250,368.0 250,368.0

PGA use (MB): 792.9 650.7

% Host Mem used for SGA+PGA: 48.60 48.57

	Begin	End
Host Mem (MB):	516,829.8	516,829.8
SGA use (MB):	250,368.0	250,368.0
PGA use (MB):	792.9	650.7
% Host Mem used for SGA+PGA:	48.60	48.57

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: 19.16 7.64

Global Cache blocks served: 6.71 2.68

GCS/GES messages received: 1,994.51 795.55

GCS/GES messages sent: 2,015.26 803.83

DBWR Fusion writes: 0.97 0.39

Estd Interconnect traffic (KB) 990.11

	Per Second	Per Transaction
Global Cache blocks received:	19.16	7.64
Global Cache blocks served:	6.71	2.68
GCS/GES messages received:	1,994.51	795.55
GCS/GES messages sent:	2,015.26	803.83
DBWR Fusion writes:	0.97	0.39
Estd Interconnect traffic (KB)	990.11

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

Buffer access - local cache %: 99.64

Buffer access - remote cache %: 0.35

Buffer access - disk %: 0.01

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.1

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

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

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 %: 31.1

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

Avg global cache current block pin time (ms): 1,751.1

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

Global cache log flushes for current blocks served %: 0.3

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

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.0

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

Avg message received queue time (ms): 0.0

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.1

% of direct sent messages: 98.62

% of indirect sent messages: 1.30

% of flow controlled messages: 0.08

Cluster Interconnect

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

Interface	IP Address	Pub	Source	IP	Pub	Src
	Begin			End
eth2:1	169.254.2.43	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): 42225.8s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
DB CPU	18,227.96	43.17
sql execute elapsed time	14,483.49	34.30
parse time elapsed	950.48	2.25
hard parse elapsed time	894.97	2.12
failed parse elapsed time	751.98	1.78
PL/SQL execution elapsed time	246.96	0.58
connection management call elapsed time	50.39	0.12
hard parse (sharing criteria) elapsed time	12.08	0.03
inbound PL/SQL rpc elapsed time	7.47	0.02
PL/SQL compilation elapsed time	4.63	0.01
sequence load elapsed time	3.61	0.01
hard parse (bind mismatch) elapsed time	1.38	0.00
repeated bind elapsed time	0.32	0.00
DB time	42,225.77
background elapsed time	60,585.70
background cpu time	21,078.04

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	6,102,310
IDLE_TIME	802,972,442
IOWAIT_TIME	753,939
NICE_TIME	6
SYS_TIME	1,612,272
USER_TIME	4,198,768
LOAD	1	0
RSRC_MGR_CPU_WAIT_TIME	50
PHYSICAL_MEMORY_BYTES	541,935,366,144
NUM_CPUS	160
NUM_CPU_CORES	80
NUM_CPU_SOCKETS	8
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,586
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
22-Nov 09:00:30	1.39
22-Nov 10:00:01	0.17	1.09	0.79	0.23	98.91	0.03
22-Nov 11:00:33	2.21	0.85	0.57	0.23	99.15	0.16
22-Nov 12:00:08	3.09	1.19	0.84	0.29	98.81	0.26
22-Nov 13:00:42	2.00	1.24	0.89	0.29	98.76	0.25
22-Nov 14:00:15	0.05	0.84	0.57	0.23	99.16	0.20
22-Nov 15:00:52	0.17	0.94	0.67	0.22	99.06	0.03
22-Nov 16:00:27	2.66	1.07	0.77	0.24	98.93	0.04
22-Nov 17:00:00	0.05	1.22	0.84	0.30	98.78	0.24
22-Nov 18:00:35	0.48	0.41	0.25	0.14	99.59	0.02
22-Nov 19:00:09	0.37	0.39	0.24	0.14	99.61	0.02
22-Nov 20:00:46	0.15	0.67	0.46	0.17	99.33	0.02
22-Nov 21:00:24	0.36	0.23	0.13	0.10	99.77	0.02
22-Nov 22:00:02	0.03	0.22	0.12	0.10	99.78	0.02
22-Nov 23:00:44	0.02	0.22	0.12	0.10	99.78	0.01

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 97.7% of Total DB time 42,225.77 (s)
Total FG Wait Time: 23,023.08 (s) DB CPU time: 18,227.96 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
Other	51,187,309	1	21,247	0	50.32
DB CPU			18,228		43.17
Network	3,995,783	0	1,381	0	3.27
Concurrency	23,489	1	165	7	0.39
Cluster	156,954	0	90	1	0.21
Commit	127,456	0	90	1	0.21
System I/O	63,680	0	21	0	0.05
User I/O	20,238	0	21	1	0.05
Application	10,464	0	7	1	0.02
Configuration	61	16	0	3	0.00
Scheduler	1	0	0	1	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
ges inquiry response	49,384,771	0	13,890	0	390.73	32.89
transaction	5,314	100	5,317	1001	0.04	12.59
SQL*Net message from dblink	1,271,667	0	1,365	1	10.06	3.23
PX Nsq: PQ load info query	5,773	96	1,135	197	0.05	2.69
PX Deq: Slave Session Stats	68,333	0	389	6	0.54	0.92
reliable message	93,062	0	222	2	0.74	0.53
library cache lock	2,139	10	155	72	0.02	0.37
DFS lock handle	202,399	0	92	0	1.60	0.22
rdbms ipc reply	369,984	0	92	0	2.93	0.22
log file sync	127,456	0	90	1	1.01	0.21
gc current grant busy	63,406	0	39	1	0.50	0.09
IPC send completion sync	90,702	0	32	0	0.72	0.08
gc cr block 2-way	48,236	0	25	1	0.38	0.06
latch free	48,049	0	25	1	0.38	0.06
control file sequential read	63,672	0	21	0	0.50	0.05
enq: PS - contention	35,295	0	20	1	0.28	0.05
db file sequential read	13,459	0	16	1	0.11	0.04
gc current block 2-way	28,609	0	15	1	0.23	0.04
enq: US - contention	26,301	0	8	0	0.21	0.02
PX Deq: reap credit	575,456	100	7	0	4.55	0.02
row cache lock	16,724	0	7	0	0.13	0.02
enq: TX - row lock contention	3	0	6	2093	0.00	0.01
name-service call wait	75	0	6	81	0.00	0.01
SQL*Net message to dblink	1,271,345	0	6	0	10.06	0.01
gc cr multi block request	6,269	0	5	1	0.05	0.01
SQL*Net message to client	1,406,488	0	4	0	11.13	0.01
PX Deq: Signal ACK RSG	33,171	0	4	0	0.26	0.01
SQL*Net more data to client	43,205	0	3	0	0.34	0.01
KJC: Wait for msg sends to complete	204,576	0	3	0	1.62	0.01
db file scattered read	572	0	3	5	0.00	0.01
enq: TX - contention	5,341	99	3	0	0.04	0.01
SQL*Net more data from client	3,067	0	3	1	0.02	0.01
gc cr disk read	4,775	0	2	0	0.04	0.00
gc cr block busy	1,352	0	2	1	0.01	0.00
buffer busy waits	123	0	1	11	0.00	0.00
Disk file operations I/O	4,054	0	1	0	0.03	0.00
PX Deq: Signal ACK EXT	33,173	0	1	0	0.26	0.00
library cache pin	2,484	6	1	0	0.02	0.00
SQL*Net break/reset to client	10,383	0	1	0	0.08	0.00
os thread startup	10	0	1	79	0.00	0.00
gc cr block congested	1,168	0	1	1	0.01	0.00
direct path read temp	1,526	0	0	0	0.01	0.00
gc current block busy	411	0	0	1	0.00	0.00
gc current grant 2-way	879	0	0	0	0.01	0.00
gc cr grant 2-way	807	0	0	0	0.01	0.00
CSS initialization	64	0	0	5	0.00	0.00
gc current multi block request	473	0	0	1	0.00	0.00
direct path write temp	486	0	0	1	0.00	0.00
gc current block congested	515	0	0	1	0.00	0.00
CSS operation: action	65	0	0	4	0.00	0.00
latch: ges resource hash list	3,912	0	0	0	0.03	0.00
enq: FB - contention	259	0	0	0	0.00	0.00
direct path read	96	0	0	1	0.00	0.00
db file parallel read	19	0	0	6	0.00	0.00
resmgr:internal state change	1	100	0	101	0.00	0.00
log file switch completion	3	0	0	27	0.00	0.00
latch: row cache objects	1,985	0	0	0	0.02	0.00
undo segment extension	11	91	0	7	0.00	0.00
enq: RO - fast object reuse	39	0	0	1	0.00	0.00
CSS operation: query	192	0	0	0	0.00	0.00
enq: TO - contention	68	65	0	0	0.00	0.00
enq: HW - contention	47	0	0	0	0.00	0.00
gc cr grant congested	33	0	0	1	0.00	0.00
enq: TM - contention	32	9	0	0	0.00	0.00
direct path write	25	0	0	1	0.00	0.00
enq: MD - contention	23	0	0	0	0.00	0.00
enq: JS - job run lock - synchronize	14	100	0	1	0.00	0.00
enq: TT - contention	18	0	0	0	0.00	0.00
gc current grant congested	15	0	0	0	0.00	0.00
enq: CR - block range reuse ckpt	4	0	0	2	0.00	0.00
enq: JQ - contention	8	100	0	1	0.00	0.00
enq: CF - contention	13	0	0	0	0.00	0.00
enq: PI - contention	10	100	0	0	0.00	0.00
gc buffer busy acquire	6	0	0	1	0.00	0.00
asynch descriptor resize	806	100	0	0	0.01	0.00
control file parallel write	8	0	0	0	0.00	0.00
latch: undo global data	18	0	0	0	0.00	0.00
enq: AE - lock	7	0	0	0	0.00	0.00
enq: TS - contention	5	0	0	0	0.00	0.00
enq: UL - contention	6	0	0	0	0.00	0.00
cursor: pin S wait on X	1	0	0	1	0.00	0.00
enq: AF - task serialization	2	0	0	1	0.00	0.00
SQL*Net message from client	1,406,497	0	2,092,976	1488	11.13
jobq slave wait	46,801	100	23,420	500	0.37
pipe get	20,293	1	982	48	0.16
PX Deq: Execute Reply	33,258	0	280	8	0.26
PX Deq: Execution Msg	140,663	0	251	2	1.11
PX Deq: Join ACK	33,185	0	42	1	0.26
PX Deq Credit: send blkd	5	0	35	6929	0.00
auto-sqltune: wait graph update	6	83	25	4167	0.00
PX Deq: Parse Reply	33,185	0	19	1	0.26
single-task message	325	0	10	31	0.00
KSV master wait	39	0	0	0	0.00

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
enq: DR - contention	16	0	22,360	1397469	0.00	36.91
SQL*Net message from dblink	36,768	0	16,485	448	0.29	27.21
DFS lock handle	14,391,220	100	4,668	0	113.86	7.70
gc cr block 2-way	801,423	0	336	0	6.34	0.55
log file parallel write	334,307	0	125	0	2.65	0.21
reliable message	7,758	1	117	15	0.06	0.19
db file parallel write	209,922	0	82	0	1.66	0.14
control file sequential read	147,047	0	65	0	1.16	0.11
log file sync	69,295	0	49	1	0.55	0.08
os thread startup	1,069	0	32	30	0.01	0.05
enq: TX - contention	64,849	100	29	0	0.51	0.05
gc current block 2-way	37,212	0	18	0	0.29	0.03
gcs log flush sync	19,026	0	12	1	0.15	0.02
control file parallel write	20,637	0	8	0	0.16	0.01
latch free	3,247	0	8	2	0.03	0.01
gc current grant busy	14,878	0	8	1	0.12	0.01
CGS wait for IPC msg	478,750	100	6	0	3.79	0.01
gc cr block congested	12,898	0	5	0	0.10	0.01
CSS operation: data query	2,517	0	5	2	0.02	0.01
gc current block busy	3,637	0	5	1	0.03	0.01
ASM file metadata operation	17,196	0	5	0	0.14	0.01
PX Nsq: PQ load info query	23	100	5	201	0.00	0.01
latch: ges resource hash list	64,901	0	3	0	0.51	0.00
process diagnostic dump	10	0	2	234	0.00	0.00
ksxr poll remote instances	184,368	100	2	0	1.46	0.00
name-service call wait	37	0	2	60	0.00	0.00
log file sequential read	593	0	2	3	0.00	0.00
row cache process	360,684	0	2	0	2.85	0.00
PX Deq: reap credit	80,156	100	1	0	0.63	0.00
libcache interrupt action by LCK	284,385	0	1	0	2.25	0.00
row cache cleanup	309,003	0	1	0	2.44	0.00
enq: WF - contention	247	0	1	4	0.00	0.00
CSS group membership query	839	0	1	1	0.01	0.00
row cache lock	1,318	0	1	1	0.01	0.00
enq: JS - queue lock	71	0	1	8	0.00	0.00
db file sequential read	188	0	0	2	0.00	0.00
gc current block congested	675	0	0	0	0.01	0.00
db file async I/O submit	209,421	0	0	0	1.66	0.00
enq: CF - contention	586	83	0	0	0.00	0.00
ksdxexeotherwait	10	0	0	22	0.00	0.00
resmgr:internal state change	2	100	0	101	0.00	0.00
enq: PS - contention	269	36	0	1	0.00	0.00
library cache pin	455	0	0	0	0.00	0.00
CSS operation: action	134	0	0	1	0.00	0.00
CSS initialization	32	0	0	5	0.00	0.00
Disk file operations I/O	1,160	0	0	0	0.01	0.00
gc current grant 2-way	445	0	0	0	0.00	0.00
library cache lock	372	1	0	0	0.00	0.00
gc cr block busy	89	0	0	1	0.00	0.00
ADR block file read	224	0	0	1	0.00	0.00
gc cr multi block request	164	0	0	1	0.00	0.00
SQL*Net message to dblink	36,756	0	0	0	0.29	0.00
latch: row cache objects	1,237	0	0	0	0.01	0.00
LGWR wait for redo copy	1,550	0	0	0	0.01	0.00
latch: messages	147	0	0	1	0.00	0.00
gc current multi block request	116	0	0	1	0.00	0.00
enq: TA - contention	156	0	0	0	0.00	0.00
enq: PR - contention	2	0	0	28	0.00	0.00
PX Deq: Slave Session Stats	254	0	0	0	0.00	0.00
asynch descriptor resize	6,752	100	0	0	0.05	0.00
enq: TM - contention	105	82	0	0	0.00	0.00
direct path write	135	0	0	0	0.00	0.00
enq: TD - KTF dump entries	110	0	0	0	0.00	0.00
gc buffer busy release	64	0	0	1	0.00	0.00
db file scattered read	42	0	0	1	0.00	0.00
IPC send completion sync	169	0	0	0	0.00	0.00
PX Deq: Signal ACK RSG	254	0	0	0	0.00	0.00
SQL*Net more data from client	66	0	0	0	0.00	0.00
SQL*Net message to client	15,975	0	0	0	0.13	0.00
buffer busy waits	123	0	0	0	0.00	0.00
CSS operation: query	935	0	0	0	0.01	0.00
KJC: Wait for msg sends to complete	1,256	0	0	0	0.01	0.00
gc cr grant 2-way	60	0	0	0	0.00	0.00
ADR block file write	70	0	0	0	0.00	0.00
enq: TT - contention	37	65	0	0	0.00	0.00
direct path read	2	0	0	6	0.00	0.00
PX Deq: Signal ACK EXT	254	0	0	0	0.00	0.00
enq: MW - contention	24	0	0	0	0.00	0.00
enq: TK - Auto Task Serialization	23	100	0	0	0.00	0.00
enq: AF - task serialization	14	0	0	1	0.00	0.00
enq: HW - contention	18	0	0	0	0.00	0.00
enq: CR - block range reuse ckpt	15	0	0	0	0.00	0.00
log file single write	16	0	0	0	0.00	0.00
kfk: async disk IO	13	0	0	0	0.00	0.00
enq: US - contention	15	0	0	0	0.00	0.00
Log archive I/O	4	0	0	1	0.00	0.00
gc current grant congested	9	0	0	1	0.00	0.00
rdbms ipc reply	1	0	0	4	0.00	0.00
latch: cache buffers chains	6	0	0	1	0.00	0.00
SQL*Net break/reset to client	12	0	0	0	0.00	0.00
gc buffer busy acquire	3	0	0	1	0.00	0.00
Data file init write	1	0	0	2	0.00	0.00
enq: FB - contention	4	0	0	0	0.00	0.00
SQL*Net more data to client	66	0	0	0	0.00	0.00
enq: PI - contention	3	100	0	0	0.00	0.00
enq: WL - contention	2	100	0	1	0.00	0.00
rdbms ipc message	2,346,812	52	2,316,162	987	18.57
gcs remote message	34,176,958	98	352,256	10	270.40
wait for unread message on broadcast channel	101,423	89	100,827	994	0.80
DIAG idle wait	1,230,114	82	99,727	81	9.73
Space Manager: slave idle wait	16,555	97	81,693	4935	0.13
class slave wait	3,360	0	56,521	16822	0.03
PX Idle Wait	35,206	0	55,396	1573	0.28
Streams AQ: qmn slave idle wait	1,759	0	50,434	28672	0.01
Streams AQ: qmn coordinator idle wait	3,518	50	50,434	14336	0.03
PING	17,143	23	50,419	2941	0.14
shared server idle wait	1,680	100	50,418	30011	0.01
ASM background timer	12,008	0	50,411	4198	0.10
dispatcher timer	840	100	50,409	60011	0.01
GCR sleep	10,080	100	50,407	5001	0.08
pmon timer	16,779	100	50,383	3003	0.13
smon timer	636	16	44,424	69849	0.01
ges remote message	98,649,758	0	37,832	0	780.51
VKRM Idle	1	0	14,400	14399760	0.00
SQL*Net message from client	21,312	0	24	1	0.17
KSV master wait	31,686	97	1	0	0.25
PX Deq: Join ACK	254	0	0	2	0.00
single-task message	12	0	0	25	0.00
PX Deq: Parse Reply	254	0	0	1	0.00
heartbeat monitor sleep	22	0	0	3	0.00
Streams AQ: RAC qmn coordinator idle wait	3,560	100	0	0	0.03
PX Deq: Execute Reply	254	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	224	95.1	3.6	.9		.4
ADR block file write	70	100.0
ADR file lock	84	100.0
ARCH wait for archivelog lock	4	100.0
ASM file metadata operation	17.2K	99.4	.1	.1	.0	.0		.4
CGS wait for IPC msg	478.8K	100.0
CSS group membership query	839	34.0	64.2	1.8
CSS initialization	96	50.0				49.0	1.0
CSS operation: action	199	27.1	22.6	47.7	2.5
CSS operation: data query	2517	.1	30.2	69.7
CSS operation: query	1127	98.0	1.6	.4
DFS lock handle	14.6M	99.8	.2	.0	.0	.0	.0	.0
Data file init write	1			100.0
Disk file operations I/O	5214	99.7	.1	.1	.2
IPC send completion sync	90.9K	99.8	.2	.0	.0
KJC: Wait for msg sends to complete	205.8K	100.0
LGWR wait for redo copy	1550	99.9		.1
Log archive I/O	4	50.0	25.0	25.0
PX Deq: Signal ACK EXT	33.4K	100.0	.0
PX Deq: Signal ACK RSG	33.4K	100.0	.0
PX Deq: Slave Session Stats	68.6K	99.2	.3	.0	.0	.0	.0	.2	.2
PX Deq: reap credit	655.6K	100.0	.0	.0
PX Nsq: PQ load info query	5796	.1	.0	.0	.1	.1	.3	99.3
PX qref latch	37	100.0
SQL*Net break/reset to client	10.4K	99.4	.4	.2	.0	.0		.0
SQL*Net break/reset to dblink	1	100.0
SQL*Net message from dblink	1308.3K	68.1	26.6	3.5	.4	.0	.0	1.2	.2
SQL*Net message to client	1422.5K	100.0		.0	.0
SQL*Net message to dblink	1307.9K	100.0		.0
SQL*Net more data from client	3133	90.2	8.0	1.0	.5	.1	.1		.0
SQL*Net more data from dblink	11	100.0
SQL*Net more data to client	43.3K	97.7	.9	1.2	.0	.0	.0	.0
asynch descriptor resize	7558	100.0
buffer busy waits	244	93.4	3.7	.8			.8	1.2
buffer deadlock	4	100.0
control file parallel write	20.6K	99.8	.1	.0	.0	.0	.0
control file sequential read	210.7K	99.9	.0	.0	.0	.0	.0
cursor: pin S wait on X	1		100.0
db file async I/O submit	209.4K	100.0
db file parallel read	19	63.2	10.5			5.3	15.8	5.3
db file parallel write	209.9K	99.7	.2	.1	.0	.0	.0	.0
db file scattered read	614	65.3	9.6	2.9	7.2	5.9	4.9	4.2
db file sequential read	11.6K	85.2	2.2	4.1	6.0	1.7	.6	.2
db file single write	1	100.0
direct path read	98	78.6	1.0	7.1	12.2	1.0
direct path read temp	1526	100.0
direct path write	160	98.8	.6	.6
direct path write temp	486	96.3	3.3			.2		.2
enq: AE - lock	7	100.0
enq: AF - task serialization	16	93.8	6.3
enq: CF - contention	599	99.3	.7
enq: CR - block range reuse ckpt	19	89.5		10.5
enq: CT - state	1	100.0
enq: DL - contention	1	100.0
enq: DR - contention	16	68.8		6.3					25.0
enq: FB - contention	263	99.6		.4
enq: FD - Flashback logical operations	1	100.0
enq: HW - contention	65	98.5	1.5
enq: JQ - contention	9	88.9	11.1
enq: JS - job run lock - synchronize	14	100.0
enq: JS - queue lock	71			1.4	53.5	45.1
enq: JS - wdw op	1	100.0
enq: MD - contention	23	100.0
enq: MW - contention	24	100.0
enq: PE - contention	1	100.0
enq: PI - contention	13	100.0
enq: PR - contention	2						100.0
enq: PS - contention	35.6K	98.6	1.3	.1	.0	.0	.0
enq: RO - fast object reuse	39	66.7	17.9	15.4
enq: SK - contention	1	100.0
enq: TA - contention	156	100.0
enq: TD - KTF dump entries	110	100.0
enq: TK - Auto Task Serialization	23	100.0
enq: TM - contention	150	99.3	.7
enq: TO - contention	68	98.5	1.5
enq: TS - contention	5	100.0
enq: TT - contention	55	98.2	1.8
enq: TX - contention	70.2K	99.4	.3	.1	.1	.0	.0	.0
enq: TX - index contention	1	100.0
enq: TX - row lock contention	3								100.0
enq: UL - contention	6	100.0
enq: US - contention	26.3K	99.8	.2	.0	.0	.0	.0
enq: WF - contention	249	98.0	.8	.4	.4			.4
enq: WL - contention	2	100.0
gc buffer busy acquire	9	77.8	22.2
gc buffer busy release	64	95.3	4.7
gc cr block 2-way	849.6K	99.9	.1	.0	.0
gc cr block busy	1441	1.8	94.9	3.2	.1
gc cr block congested	14.1K	99.9	.1
gc cr disk read	3858	98.9	.9	.2
gc cr grant 2-way	867	99.9	.1
gc cr grant congested	33	97.0	3.0
gc cr multi block request	6407	84.2	13.2	2.1	.5
gc current block 2-way	65.8K	99.0	1.0	.0	.0
gc current block busy	4050	7.3	92.1	.6	.0
gc current block congested	1189	98.3	1.7
gc current grant 2-way	1325	99.7	.3
gc current grant busy	78.2K	96.2	3.7	.0	.0	.0	.0
gc current grant congested	24	100.0
gc current multi block request	590	95.9	3.7	.2		.2
gcs log flush sync	19K	92.3	6.3	1.0	.2	.1
ges inquiry response	49.4M	99.9	.1	.0	.0	.0	.0	.0
kfk: async disk IO	13	100.0
ksdxexeotherwait	10						100.0
ksxr poll remote instances	184.4K	100.0
latch free	51.3K	90.0	.9	1.9	5.1	2.1	.0
latch: active service list	2	100.0
latch: cache buffer handles	1	100.0
latch: cache buffers chains	8	75.0	25.0
latch: checkpoint queue latch	1	100.0
latch: enqueue hash chains	4	100.0
latch: gc element	2	100.0
latch: gcs resource hash	2	100.0
latch: ges resource hash list	68.8K	99.8	.2	.0	.0
latch: messages	149	84.6	15.4
latch: redo allocation	5	100.0
latch: redo writing	3	100.0
latch: row cache objects	3222	99.8	.2
latch: shared pool	1	100.0
latch: undo global data	18	100.0
libcache interrupt action by LCK	284.4K	100.0	.0
library cache lock	2556	98.1	.9	.2	.3	.1	.1	.2	.1
library cache pin	2984	99.2	.5	.1	.1
library cache: mutex X	24	100.0
log file parallel write	334.3K	99.6	.2	.1	.0	.0	.0	.0
log file sequential read	593	30.5	33.9	20.1	8.1	4.0	2.7	.7
log file single write	16	100.0
log file switch completion	3					33.3		66.7
log file sync	196.7K	96.7	3.2	.1	.0	.0	.0	.0
name-service call wait	112	.9	.9		1.8	3.6	15.2	77.7
os thread startup	1079						93.8	6.2
process diagnostic dump	10							100.0
rdbms ipc reply	370K	94.5	5.4	.0	.0	.0	.0	.0
read by other session	1	100.0
reliable message	100.8K	98.0	1.1	.3	.0	.0	.0	.5
resmgr:cpu quantum	1	100.0
resmgr:internal state change	3							100.0
row cache cleanup	309K	100.0
row cache lock	18.1K	96.7	3.1	.1	.0	.0
row cache process	360.7K	100.0
transaction	5314							100.0
undo segment extension	11	54.5				27.3	18.2
ASM background timer	12K	.6	.1	.1	9.4	.2	.1	2.5	87.1
DIAG idle wait	1230.1K	14.9	1.5	.2	.1	8.8	27.0	47.6
GCR sleep	10.1K								100.0
KSV master wait	31.7K	99.9	.0	.1	.0			.0
PING	17.1K	76.7	.0	.0					23.3
PX Deq Credit: need buffer	3	100.0
PX Deq Credit: send blkd	5	40.0							60.0
PX Deq: Execute Reply	33.5K	99.1	.2	.1	.1	.1	.1	.3	.1
PX Deq: Execution Msg	140.7K	78.2	15.9	5.6	.1	.1	.0	.0	.0
PX Deq: Join ACK	33.4K	43.2	49.7	7.0	.0	.0
PX Deq: Parse Reply	33.4K	97.3	1.6	.4	.5	.2	.0	.0
PX Idle Wait	35.2K	.0	.1	.1	.1	.1	.0	46.7	52.9
SQL*Net message from client	1427.8K	32.4	55.9	5.0	1.8	2.0	.7	1.2	1.1
Space Manager: slave idle wait	16.6K			.0	.1	.0	.0	.5	99.3
Streams AQ: RAC qmn coordinator idle wait	3560	100.0
Streams AQ: qmn coordinator idle wait	3518	50.0	.0						50.0
Streams AQ: qmn slave idle wait	1759								100.0
VKRM Idle	1								100.0
auto-sqltune: wait graph update	6	16.7							83.3
class slave wait	3360	39.7	.4	2.7	26.0	.9	.1	.7	29.6
dispatcher timer	840								100.0
gcs remote message	33.7M	.4	.3	.5	.8	98.1	.0	.0
ges remote message	98.6M	99.6	.1	.0	.1	.0	.0	.2
heartbeat monitor sleep	22		13.6	81.8	4.5
jobq slave wait	46.8K		.0	.0			.0	100.0
pipe get	20.3K	79.7	2.2	7.0	6.2	.3	1.2	2.2	1.2
pmon timer	16.8K								100.0
rdbms ipc message	2346.8K	27.5	1.7	3.5	1.9	3.9	1.4	32.5	27.5
shared server idle wait	1680								100.0
single-task message	337		.3	.9			49.6	49.3
smon timer	636	6.0		.8	1.3	1.4	1.4	55.3	33.8
wait for unread message on broadcast channel	101.4K				.0	.6		99.4	.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	62	99.6	.3	.0	.0
DFS lock handle	13	100.0	.0	.0
PX Deq: Slave Session Stats	276	99.5	.0	.0	.0	.1	.1	.2	.1
PX Nsq: PQ load info query	5757	.7	.7	1.3	97.3
SQL*Net break/reset to client	1	100.0	.0
SQL*Net message from dblink	18.2K	98.6	.0	.0			1.2	.2	.0
SQL*Net more data from client	1	100.0						.0
SQL*Net more data to client	6	100.0	.0
buffer busy waits	3	98.8	.4			.4	.4
db file parallel read	1	94.7	5.3
db file parallel write	2	100.0	.0
db file scattered read	26	95.8	3.9	.3
db file sequential read	25	99.8	.2	.0
direct path write temp	1	99.8	.2
enq: TX - contention	1	100.0				.0
enq: TX - row lock contention	2							66.7	33.3
enq: WF - contention	1	99.6					.4
ges inquiry response	2	100.0	.0	.0
library cache lock	6	99.6	.1	.0		.0	.0		.1
log file parallel write	6	100.0	.0
log file sequential read	4	99.3	.7
log file switch completion	2	33.3	66.7
log file sync	4	100.0	.0
name-service call wait	87	22.3	17.0	58.0	2.7
os thread startup	67	93.8	4.0	2.0	.2
process diagnostic dump	10				100.0
rdbms ipc reply	1	100.0	.0
reliable message	472	99.5	.0	.0	.0	.1	.3
resmgr:internal state change	3			100.0
transaction	5314						100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Event	Waits 4s to 2m	<2s	<4s	< 1m
		% of Total Waits
PX Deq: Slave Session Stats	47	99.9	.1
SQL*Net message from dblink	136	100.0	.0
enq: TX - row lock contention	1	66.7	33.3
library cache lock	3	99.9		.1

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	<4m	<8m	<1/4h	<1/2h	< 1h	>=1h
		% of Total Waits
enq: DR - contention	2	75.0				6.3	6.3	12.5

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)
SDSLDB	25,659	15,393	1	27,356
SYS$USERS	16,472	2,758	47	224,228
SYS$BACKGROUND	2	1	0	22,912
SDSLDBXDB	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
SDSLDB	3621	2	7144	4	1447192	13
SYS$USERS	16635	19	16339	161	2548615	1368
SYS$BACKGROUND	1529	1	288956	34	73524	16485

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 31.4% of Total DB Time (s): 42,226
Captured PL/SQL account for 23.2% of Total DB Time (s): 42,226

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
6,957.26	155	44.89	16.48	14.93	0.00	7yaqm2habcbap		DECLARE job BINARY_INTEGER := ...
5,348.59	59,443	0.09	12.67	0.46	0.00	ggu8pr7gjt8h2		UPDATE T_XHD_XHQPMX SET CHANGE...
2,072.32	1	2,072.32	4.91	54.22	0.04	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,426.85	16,304	0.09	3.38	5.25	0.00	7tx50ncu1kxgm		select INST_ID, REFCOUNT from ...
1,201.81	21	57.23	2.85	21.98	0.00	237bzsrftfsb4	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ sel...
1,096.90	433	2.53	2.60	99.26	0.00	df03gsnzb7nvy	Spotlight on Oracle RAC	SELECT l.latch#, l.gets, l.mis...
609.87	216	2.82	1.44	99.44	0.00	dp0m1hgbyytkp	Spotlight on Oracle RAC	SELECT wait_time_milli, SUM (w...
371.15	16	23.20	0.88	98.17	0.00	3zmj35k9fmct6		DECLARE job BINARY_INTEGER := ...
331.30	33,547	0.01	0.78	99.64	0.00	01qhdzwrndw8j		SELECT COUNT(*) FROM ITEM_INTE...
287.42	1	287.42	0.68	52.82	2.48	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...

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 28.2% of Total CPU Time (s): 18,228
Captured PL/SQL account for 14.8% of Total CPU Time (s): 18,228

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
1,123.63	1	1,123.63	6.16	2,072.32	54.22	0.04	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,088.81	433	2.51	5.97	1,096.90	99.26	0.00	df03gsnzb7nvy	Spotlight on Oracle RAC	SELECT l.latch#, l.gets, l.mis...
1,038.39	155	6.70	5.70	6,957.26	14.93	0.00	7yaqm2habcbap		DECLARE job BINARY_INTEGER := ...
606.45	216	2.81	3.33	609.87	99.44	0.00	dp0m1hgbyytkp	Spotlight on Oracle RAC	SELECT wait_time_milli, SUM (w...
364.36	16	22.77	2.00	371.15	98.17	0.00	3zmj35k9fmct6		DECLARE job BINARY_INTEGER := ...
330.12	33,547	0.01	1.81	331.30	99.64	0.00	01qhdzwrndw8j		SELECT COUNT(*) FROM ITEM_INTE...
264.12	21	12.58	1.45	1,201.81	21.98	0.00	237bzsrftfsb4	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ sel...
227.31	29,800	0.01	1.25	233.21	97.47	0.00	0d2swsmcbg95n		UPDATE T_DPLS SET WCXDCS = WCX...
198.19	27,344	0.01	1.09	199.70	99.24	0.00	1q1f0hv3p080r	oracle@xhwldb2 (TNS V1-V3)	SELECT COUNT(*) FROM T_JCZDML ...
189.14	1,817	0.10	1.04	189.46	99.83	0.00	fwzmq24pk0zw0		SELECT COUNT(*) FROM T_WL_CKSJ...

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

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
9.54	1	9.54	43.98	66.43	8.31	14.36	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
7.25	14	0.52	33.43	11.06	18.67	65.59	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
7.14	1	7.14	32.92	287.42	52.82	2.48	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
0.84	1	0.84	3.89	2,072.32	54.22	0.04	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
0.55	5	0.11	2.53	19.74	97.15	2.78	9ghdfn6dm6zr7	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ Sel...
0.22	1	0.22	1.03	17.53	96.01	1.27	6dn5kcc5hk94h	TOAD 11.6.0.43	Select * from table(dbms_workl...
0.16	155	0.00	0.74	6,957.26	14.93	0.00	7yaqm2habcbap		DECLARE job BINARY_INTEGER := ...
0.15	5,342	0.00	0.68	5.44	57.89	2.72	f711myt0q6cma	oracle@SDSLDB2 (TNS V1-V3)	insert into sys.aud$( sessioni...
0.10	1	0.10	0.48	0.41	72.07	25.36	cb1ygw55v3b5t	TOAD 11.6.0.43	Select owner, type_name, typec...
0.08	2	0.04	0.36	2.57	81.50	3.03	dr9j47r6dt02q	oracle@SDMDDB1 (TNS V1-V3)	SELECT "ID", "LASTDHRQ" FROM "...

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: 274,412,624
Captured SQL account for 97.3% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
90,678,629	16	5,667,414.31	33.04	371.15	98.2	0	3zmj35k9fmct6		DECLARE job BINARY_INTEGER := ...
89,855,031	33,547	2,678.48	32.74	331.30	99.6	0	01qhdzwrndw8j		SELECT COUNT(*) FROM ITEM_INTE...
82,795,110	155	534,162.00	30.17	6,957.26	14.9	0	7yaqm2habcbap		DECLARE job BINARY_INTEGER := ...
46,592,423	29,800	1,563.50	16.98	233.21	97.5	0	0d2swsmcbg95n		UPDATE T_DPLS SET WCXDCS = WCX...
46,181,131	1	46,181,131.00	16.83	2,072.32	54.2	0	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
44,049,565	27,344	1,610.94	16.05	199.70	99.2	0	1q1f0hv3p080r	oracle@xhwldb2 (TNS V1-V3)	SELECT COUNT(*) FROM T_JCZDML ...
6,901,256	106	65,106.19	2.51	71.60	99.7	0	bzukgtq3rjr4g		SELECT PCH, JLS, LX, SENDBMBH,...
6,834,004	1,813	3,769.45	2.49	121.10	99.8	0	7cb8tb9z2y1f6		SELECT COUNT(*) FROM T_WL_CKSJ...
6,785,461	1,812	3,744.74	2.47	128.17	99.8	0	gpy0cdsstp964		SELECT FLOWID, ID, DBRQ, PFRQ,...
6,774,298	1,817	3,728.29	2.47	189.46	99.8	0	fwzmq24pk0zw0		SELECT COUNT(*) FROM T_WL_CKSJ...
4,221,199	16,304	258.91	1.54	103.97	85.2	0	6yva4jbyzfky5		select local_tran_id, state, s...
3,425,487	2	1,712,743.50	1.25	26.07	98.8	.2	g5h190q8bx9f5	TOAD 11.6.0.43	Select * from table(dbms_workl...
3,321,816	3	1,107,272.00	1.21	14.46	98.5	0	fwqxchk6kgvdg	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ SEL...
3,318,279	3	1,106,093.00	1.21	12.44	99.9	0	70q9tw6dqd29t	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ SEL...
3,317,968	3	1,105,989.33	1.21	12.49	100	0	c3g0tjz6gaujr	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ SEL...
3,146,286	3,057	1,029.21	1.15	14.92	99.5	0	g7kgt9q98ah65		SELECT ZDQH, ZDXH FROM T_JCZDM...

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: 48,533
Captured SQL account for 47.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
24,868	1	24,868.00	51.24	2,072.32	54.22	0.04	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
18,030	5	3,606.00	37.15	19.74	97.15	2.78	9ghdfn6dm6zr7	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ Sel...
13,015	1	13,015.00	26.82	66.43	8.31	14.36	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
8,229	1	8,229.00	16.96	287.42	52.82	2.48	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
4,113	14	293.79	8.47	11.06	18.67	65.59	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
378	1	378.00	0.78	17.53	96.01	1.27	6dn5kcc5hk94h	TOAD 11.6.0.43	Select * from table(dbms_workl...
344	2	172.00	0.71	2.57	81.50	3.03	dr9j47r6dt02q	oracle@SDMDDB1 (TNS V1-V3)	SELECT "ID", "LASTDHRQ" FROM "...
114	6	19.00	0.23	2.46	82.76	1.09	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
80	1	80.00	0.16	0.41	72.07	25.36	cb1ygw55v3b5t	TOAD 11.6.0.43	Select owner, type_name, typec...
74	1	74.00	0.15	33.29	99.17	0.10	dtnycfh704ua0	TOAD 11.6.0.43	Select * from table(dbms_workl...

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: 15,476
Captured SQL account for 201.9% of Total
Total UnOptimized Read Requests: 15,476
Captured SQL account for 201.9% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Total	SQL Id	SQL Module	SQL Text
17,982	17,982	243	74.00	116.19	aj22x1qd1b243	Spotlight on Oracle RAC	SELECT file_type, ROUND (mb_us...
10,572	10,572	1	10,572.00	68.31	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
8,977	8,977	1	8,977.00	58.01	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
4,113	4,113	14	293.79	26.58	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
4,032	4,032	48	84.00	26.05	8mw2xhnu943jn	Spotlight on Oracle RAC	SELECT ios.filetype_name, df.f...
3,528	3,528	42	84.00	22.80	77nbshknaxk50	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1,647	1,647	1	1,647.00	10.64	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
1,202	1,202	5	240.40	7.77	9ghdfn6dm6zr7	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ Sel...
1,148	1,148	164	7.00	7.42	5k3dxpy9z9ppm	Spotlight on Oracle RAC	SELECT p.name, --CloseCursor (...
1,008	1,008	12	84.00	6.51	cpj1b53snratw	DBMS_SCHEDULER	SELECT PIO.IOSTAT_ID, SUM (IOF...
431	431	1	431.00	2.78	dtnycfh704ua0	TOAD 11.6.0.43	Select * from table(dbms_workl...
364	364	1	364.00	2.35	6dn5kcc5hk94h	TOAD 11.6.0.43	Select * from table(dbms_workl...
364	364	1	364.00	2.35	6vnxpsgfrt9p9	SQL*Plus	select output from table(dbms_...
220	220	2	110.00	1.42	58tt6u6rmanwd	TOAD 11.6.0.43	select summary.name as name, ...
183	183	2	91.50	1.18	dr9j47r6dt02q	oracle@SDMDDB1 (TNS V1-V3)	SELECT "ID", "LASTDHRQ" FROM "...

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: 2,424,299
Captured SQL account for 32.4% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
82,503	82,503	1.00	193.37	19.9	0	57kqz83nkwnwd	DBMS_SCHEDULER	SELECT NVL(SUM(THCS), 0) FROM ...
82,503	82,503	1.00	193.27	19.4	0	cwzszfj2n19mh	DBMS_SCHEDULER	SELECT NVL(SUM(ZYCS), 0) FROM ...
59,443	59,443	1.00	5,348.59	.5	0	ggu8pr7gjt8h2		UPDATE T_XHD_XHQPMX SET CHANGE...
57,102	57,102	1.00	6.70	79.9	0	bh4zwws4vsz3s	oracle@xhwldb2 (TNS V1-V3)	SELECT NVL("A1"."NOFHBJ", '0')...
33,547	33,547	1.00	331.30	99.6	0	01qhdzwrndw8j		SELECT COUNT(*) FROM ITEM_INTE...
29,800	29,800	1.00	233.21	97.5	0	0d2swsmcbg95n		UPDATE T_DPLS SET WCXDCS = WCX...
27,344	27,344	1.00	199.70	99.2	0	1q1f0hv3p080r	oracle@xhwldb2 (TNS V1-V3)	SELECT COUNT(*) FROM T_JCZDML ...
25,490	25,490	1.00	33.18	94.5	.1	379xmtc9vsmcz		INSERT INTO T_FHMX (DBDH, DBRQ...
16,304	0	0.00	103.97	85.2	0	6yva4jbyzfky5		select local_tran_id, state, s...
16,304	0	0.00	1,426.85	5.3	0	7tx50ncu1kxgm		select INST_ID, REFCOUNT from ...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 184,078
Captured SQL account for 58.2% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
50,945	16,304	27.68	7tx50ncu1kxgm		select INST_ID, REFCOUNT from ...
5,636	5,636	3.06	0k8522rmdzg4k		select privilege# from sysauth...
5,636	15,622	3.06	cm5vu20fhtnq1		select /*+ connect_by_filterin...
5,458	5,458	2.97	459f3z9u4fb3u		select value$ from props$ wher...
5,342	5,342	2.90	f711myt0q6cma	oracle@SDSLDB2 (TNS V1-V3)	insert into sys.aud$( sessioni...
5,295	5,295	2.88	0ws7ahf1d78qa		select SYS_CONTEXT('USERENV', ...
5,294	5,294	2.88	5ur69atw3vfhj		select decode(failover_method,...
3,244	3,244	1.76	350f5yrnnmshs		lock table sys.mon_mods$ in ex...
2,313	0	1.26	54rvdwvrhd0wt	oracle@SDMDDB1 (TNS V1-V3)	SELECT /+ FULL(P) +/ * FROM ...
2,070	0	1.12	3z9hhd2tgfqxq	oracle@xhwldb1 (TNS V1-V3)	SELECT /+ FULL(P) +/ * FROM ...
1,946	1,946	1.06	9j7p7w49wmys6	oracle@xhwldb1 (TNS V1-V3)	SELECT "YWBMBH", "ID", "CBNY",...

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
3,138,023	12,172	0.01	azfanj0gxsc3k	oracle@xhwldb2 (TNS V1-V3)	SELECT "A1"."DBDH", "A1"."DJLY...
3,052,377	88	0.01	cf8fyu7n9yc27	PL/SQL Developer	select * from sys.all_objects ...
2,414,468	36	0.00	174bgwj5uujn3	PL/SQL Developer	SELECT /+rule/ OBJECT_TYPE, ...
2,394,109	26	0.00	bctdu4910d43h	PL/SQL Developer	SELECT /+rule/ 1 FROM SYS.AL...
2,162,032	12	0.00	1ujjr5f7n32g1	PL/SQL Developer	select * from sys.all_tables w...
1,997,790	75	0.00	21sh40mz4cdkx	PL/SQL Developer	select text from sys.all_sourc...
1,960,070	2	0.00	bd502nbh9abbs	plsqldev.exe	select s.synonym_name object_n...
1,269,087	209	0.00	f3223cb4ng6hq		select next_run_date, obj#, ru...
1,113,447	168	0.00	7f8f9v6hmpqb5	oracle@xhwldb2 (TNS V1-V3)	INSERT INTO "T_WL_BSJH" "A1" (...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
68	12,172	azfanj0gxsc3k	oracle@xhwldb2 (TNS V1-V3)	SELECT "A1"."DBDH", "A1"."DJLY...
68	12,172	azfanj0gxsc3k	oracle@xhwldb2 (TNS V1-V3)	SELECT "A1"."DBDH", "A1"."DJLY...
68	12,172	azfanj0gxsc3k	oracle@xhwldb2 (TNS V1-V3)	SELECT "A1"."DBDH", "A1"."DJLY...
33	168	7f8f9v6hmpqb5	oracle@xhwldb2 (TNS V1-V3)	INSERT INTO "T_WL_BSJH" "A1" (...
24	168	31g5yw57tgt20	oracle@xhwldb2 (TNS V1-V3)	INSERT INTO "T_WL_CKSJ_HZ" "A1...
22	123	1kz16yhs993h2	DBMS_SCHEDULER	insert into sys.scheduler$_eve...

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): 464
Captured SQL account for 10.8% of Total

Cluster Wait Time (s)	Executions	%Total	Elapsed Time(s)	%Clu	%CPU	%IO	SQL Id	SQL Module	SQL Text
34.10	155	7.36	6,957.26	0.49	14.93	0.00	7yaqm2habcbap		DECLARE job BINARY_INTEGER := ...
17.75	16,304	3.83	103.97	17.07	85.25	0.00	6yva4jbyzfky5		select local_tran_id, state, s...
9.22	1	1.99	287.42	3.21	52.82	2.48	b6usrg82hwsa3	DBMS_SCHEDULER	call dbms_stats.gather_databas...
6.05	16	1.30	371.15	1.63	98.17	0.00	3zmj35k9fmct6		DECLARE job BINARY_INTEGER := ...
5.85	59,443	1.26	5,348.59	0.11	0.46	0.00	ggu8pr7gjt8h2		UPDATE T_XHD_XHQPMX SET CHANGE...
5.45	29,800	1.18	233.21	2.34	97.47	0.00	0d2swsmcbg95n		UPDATE T_DPLS SET WCXDCS = WCX...
3.92	15,367	0.85	80.90	4.85	21.94	0.00	5tn8hvpg71v9p		UPDATE T_XHD_XHQPMX@C_LINK_SL_...
3.81	1	0.82	66.43	5.73	8.31	14.36	6mcpb06rctk0x	DBMS_SCHEDULER	call dbms_space.auto_space_adv...
2.45	14	0.53	11.06	22.12	18.67	65.59	8szmwam7fysa3	DBMS_SCHEDULER	insert into wri$_adv_objspace_...
2.41	5,342	0.52	5.44	44.24	57.89	2.72	f711myt0q6cma	oracle@SDSLDB2 (TNS V1-V3)	insert into sys.aud$( sessioni...
1.95	25,490	0.42	33.18	5.87	94.52	0.13	379xmtc9vsmcz		INSERT INTO T_FHMX (DBDH, DBRQ...
1.31	16,053	0.28	5.83	22.48	78.74	0.00	fhmkap702dx71		UPDATE T_XHD_XHQPMX SET YFCS =...
1.22	1	0.26	2,072.32	0.06	54.22	0.04	5zruc4v6y32f9	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
1.01	15,981	0.22	14.14	7.18	54.57	0.00	0vzqrbbfmnrdd		insert into pending_trans$ (lo...
0.58	5,357	0.13	1.58	36.75	69.17	0.00	3c1kubcdjnppq		update sys.col_usage$ set equa...
0.52	2	0.11	2.57	20.14	81.50	3.03	dr9j47r6dt02q	oracle@SDMDDB1 (TNS V1-V3)	SELECT "ID", "LASTDHRQ" FROM "...
0.50	15,470	0.11	6.45	7.70	49.42	0.01	231r62d3uuf8b	oracle@SDSLDB2 (TNS V1-V3)	UPDATE "T_XHD_XHQPMX" "A1" SET...
0.43	6	0.09	2.46	17.27	82.76	1.09	6ajkhukk78nsr		begin prvt_hdm.auto_execute( :...
0.42	27,344	0.09	199.70	0.21	99.24	0.00	1q1f0hv3p080r	oracle@xhwldb2 (TNS V1-V3)	SELECT COUNT(*) FROM T_JCZDML ...
0.40	16,053	0.09	7.39	5.37	92.10	0.00	d5wgs08uw0g3q		UPDATE T_KCSL SET KCCS = KCCS ...
0.39	283	0.08	0.74	52.68	59.45	0.85	aq8yqxyyb40nn		update sys.job$ set this_date=...
0.38	120	0.08	17.54	2.15	98.18	0.02	ckyt3atda7nsu	oracle@xhwldb2 (TNS V1-V3)	SELECT "DJLY", "ZDQH", "ID", "...
0.31	1	0.07	0.67	46.05	63.74	0.00	4yxsdau4hfh5x	DW110.EXE	select tjdh, dm, zdcs, zdmy, d...
0.29	42	0.06	5.59	5.18	78.28	0.60	77nbshknaxk50	DBMS_SCHEDULER	DECLARE job BINARY_INTEGER := ...
0.28	12,172	0.06	12.70	2.24	95.39	0.01	azfanj0gxsc3k	oracle@xhwldb2 (TNS V1-V3)	SELECT "A1"."DBDH", "A1"."DJLY...
0.25	840	0.05	3.57	7.11	50.26	1.10	fzjz0pm1hztgb	PL/SQL Developer	INSERT INTO T_DHLS_JX (FLOWID_...
0.24	5	0.05	5.43	4.38	97.18	0.31	fxntbyvzhrvbf	PL/SQL Developer	begin -- Call the procedure pk...
0.21	1	0.05	1.54	13.59	87.35	0.03	d8y6dg13wnm77		DECLARE job BINARY_INTEGER := ...
0.20	2,716	0.04	5.95	3.34	96.08	0.00	4y1y43113gv8f		delete from histgrm$ where obj...
0.19	12,715	0.04	7.37	2.58	69.68	0.00	9uha9w749tdcs		update pending_trans$ set reco...
0.19	1	0.04	17.53	1.07	96.01	1.27	6dn5kcc5hk94h	TOAD 11.6.0.43	Select * from table(dbms_workl...
0.18	2,183	0.04	0.66	27.92	64.52	0.68	2y5a2wd9sk3th	oracle@xhwldb1 (TNS V1-V3)	UPDATE "T_SL_YFSJ" "A1" SET "Y...
0.17	26	0.04	35.01	0.48	99.40	0.00	fq2smudhvvsu9	oracle@SDMDDB1 (TNS V1-V3)	SELECT "A1"."ID", "A1"."BB", "...
0.16	255	0.03	3.49	4.60	46.61	0.02	g18j2qz6vx7zd	oracle@xhwldb2 (TNS V1-V3)	UPDATE "T_DPLS" "A1" SET "XDCS...
0.16	331	0.03	0.44	36.25	66.87	0.00	3fc48pu8hybw2	PL/SQL Developer	INSERT INTO T_JCZDML (TIHFS, U...
0.15	5	0.03	9.25	1.63	97.77	0.00	2c5u2nvppufp1	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ sel...
0.14	2	0.03	26.07	0.53	98.83	0.17	g5h190q8bx9f5	TOAD 11.6.0.43	Select * from table(dbms_workl...
0.13	15,251	0.03	19.59	0.66	98.95	0.00	0mqs0wr828n2d		delete from pending_sub_sessio...
0.12	283	0.03	0.30	39.74	63.23	1.43	47a50dvdgnxc2		update sys.job$ set failures=0...
0.12	1	0.02	0.74	15.66	79.55	0.00	ghq5mcnsmd1w4	SQL*Plus	begin declare id number; name ...
0.11	1	0.02	12.83	0.89	98.71	0.26	572fbaj0fdw2b	SQL*Plus	select output from table(dbms_...
0.11	123	0.02	0.20	56.23	50.79	0.30	1kz16yhs993h2	DBMS_SCHEDULER	insert into sys.scheduler$_eve...
0.10	21	0.02	1,201.81	0.01	21.98	0.00	237bzsrftfsb4	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ sel...
0.10	261	0.02	2.77	3.77	94.81	0.00	b2hayn7jmtnd2		INSERT INTO T_DPLS (DBDH, DJLY...
0.10	11,271	0.02	3.55	2.90	89.43	0.00	gcpywabfwjb17		delete from pending_trans$ whe...
0.09	15,251	0.02	15.45	0.59	99.41	0.00	8z8sj9gkkwv1j		delete from pending_sessions$ ...
0.09	5	0.02	12.82	0.69	99.31	0.00	dfnxxyd8x1pb8	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ sel...
0.09	251	0.02	1.39	6.19	85.28	0.36	16xd3hnhj26rw	oracle@SDMDDB1 (TNS V1-V3)	INSERT INTO "TM_JCFYHG" "A1" (...
0.08	10	0.02	1.60	5.14	86.45	1.15	8p908gp3h35z7		DECLARE job BINARY_INTEGER := ...
0.08	1	0.02	0.19	41.00	62.37	0.00	8ctkpag8rwj6u	WebDev.WebServer.EXE	begin PKG_QXSZ.PROC_QXSZ_JE_SA...
0.07	257	0.02	0.14	50.76	63.82	0.00	5rygsj4dbw6jt		insert into sys.mon_mods$ (obj...
0.07	1	0.01	5.05	1.35	98.39	0.02	29yfcawwxtsq8	TOAD 11.6.0.43	Select * from table(dbms_workl...
0.07	32	0.01	0.13	51.16	56.10	0.00	7wwd9zjbvggmh		INSERT INTO SYS.WRI$_ADV_TASKS...
0.06	190	0.01	3.32	1.83	31.58	0.07	f5dvyc8dha2z0		SELECT YSDJH, MIN(DH) AS DH, M...
0.06	1,946	0.01	0.56	10.85	84.88	2.31	9j7p7w49wmys6	oracle@xhwldb1 (TNS V1-V3)	SELECT "YWBMBH", "ID", "CBNY",...
0.06	33,547	0.01	331.30	0.02	99.64	0.00	01qhdzwrndw8j		SELECT COUNT(*) FROM ITEM_INTE...
0.05	4,622	0.01	6.01	0.89	17.80	0.00	4bcutut48s0yd	oracle@SDMDDB1 (TNS V1-V3)	UPDATE "T_XHD_XHQPMX" "A1" SET...
0.05	4,838	0.01	0.77	6.55	87.99	0.00	330q95smuwnv9		update hist_head$ set bucket_c...
0.05	505	0.01	0.22	22.26	80.18	0.00	0v3dvmc22qnam		insert into sys.col_usage$ (ob...
0.04	6	0.01	8.80	0.49	98.96	0.00	5hcrm618qgwt5	DBMS_SCHEDULER	/* SQL Analyze(4033, 1) */ Sel...
0.04	96	0.01	0.87	4.62	16.11	0.06	d3aqtvf72vc9a		SELECT A.CGYJ, A.GHDWH, A.ZK, ...
0.04	106	0.01	71.60	0.05	99.73	0.00	bzukgtq3rjr4g		SELECT PCH, JLS, LX, SENDBMBH,...
0.03	24	0.01	2.06	1.53	22.17	0.00	4t1jrtgaa10m7	oracle@xhwldb2 (TNS V1-V3)	INSERT INTO "T_WL_CKSJ" "A1" (...
0.03	1	0.01	4.20	0.65	99.32	0.10	88kwfynjcu1pk	TOAD 11.6.0.43	Select * from table(dbms_workl...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

ERROR: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 919 ORA-06512: at line 1

SQL Id SQL Text

01qhdzwrndw8j SELECT COUNT(*) FROM ITEM_INTERFACE WHERE WHSE_ID = :B2 AND ITEM_ID = :B1

0d2swsmcbg95n UPDATE T_DPLS SET WCXDCS = WCXDCS + :B3 , PHCS = PHCS + :B3 , ID = :B2 WHERE DBDH = SUBSTR(TRIM(:B1 ) || ' ', 1, 12)

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

0mqs0wr828n2d delete from pending_sub_sessions$ where local_tran_id = :1

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

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.99	In-memory Sort %:	100.00
Library Hit %:	99.15	Soft Parse %:	95.50
Execute to Parse %:	92.41	Latch Hit %:	100.00
Parse CPU to Parse Elapsd %:	88.77	% Non-Parse CPU:	95.32

Buffer access - local cache %:	99.64
Buffer access - remote cache %:	0.35
Buffer access - disk %:	0.01

Avg global enqueue get time (ms):	0.1
Avg global cache cr block receive time (ms):	0.4
Avg global cache current block receive time (ms):	0.6
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 %:	31.1
Avg global cache cr block flush time (ms):	1.5
Avg global cache current block pin time (ms):	1,751.1
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.3
Avg global cache current block flush time (ms):	379.8

Avg message sent queue time (ms):	0.0
Avg message sent queue time on ksxp (ms):	0.2
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.1
% of direct sent messages:	98.62
% of indirect sent messages:	1.30
% of flow controlled messages:	0.08

SQL Id	SQL Text
01qhdzwrndw8j	SELECT COUNT(*) FROM ITEM_INTERFACE WHERE WHSE_ID = :B2 AND ITEM_ID = :B1
0d2swsmcbg95n	UPDATE T_DPLS SET WCXDCS = WCXDCS + :B3 , PHCS = PHCS + :B3 , ID = :B2 WHERE DBDH = SUBSTR(TRIM(:B1 ) \|\| ' ', 1, 12)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0mqs0wr828n2d	delete from pending_sub_sessions$ where local_tran_id = :1
0v3dvmc22qnam	insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time)