WORKLOAD REPOSITORY report for

skillfulwolverineSoftware and s/w Development

Dec 2, 2013 (3 years and 9 months ago)

538 views

WORKLOAD REPOSITORY report for

DB Name

DB Id

Instance

Inst num

Startup Time

Release

RAC

PROSSC

231287585

PROSSC
1

1

29
-
Dec
-
12 08:12

11.2.0.3.0

YES

Host Name

Platform

CPUs

Cores

Sockets

Memory (GB)

tst
-
SSC
-
7

Linux x86 64
-
bit

8

8

2

94.22


Snap Id

Snap

Time

Sessions

Cursors/Session

Begin Snap:

67891

30
-
Dec
-
12 01:00:00

133

2.3

End Snap:

67893

30
-
Dec
-
12 03:00:10

106

2.5

Elapsed:


120.17 (mins)



DB Time:


1,087.49 (mins)



Report Summary

Cache Sizes


Begin

End



Buffer Cache:

5,696M

5,696M

Std
Block Size:

8K

Shared Pool Size:

2,048M

2,048M

Log Buffer:

11,844K

Load Profile


Per Second

Per Transaction

Per Exec

Per Call

DB Time(s):

9.1

0.6

0.02

0.03

DB CPU(s):

1.4

0.1

0.00

0.00

Redo size:

8,470,792.9

601,048.3



Logical reads:

100,685.1

7,144.2



Block changes:

34,290.3

2,433.1



Physical reads:

7,021.3

498.2



Physical writes:

2,221.4

157.6



User calls:

356.0

25.3



Parses:

11.8

0.8



Hard parses:

2.3

0.2



W/A MB processed:

26.1

1.9



Logons:

1.3

0.1



Executes:

422.5

30.0



Rollbacks:

0.0

0.0



Transactions:

14.1




Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:

100.00

Redo NoWait %:

99.77

Buffer Hit %:

97.62

In
-
memory Sort %:

100.00

Library Hit %:

98.02

Soft Parse %:

80.96

Execute to Parse %:

97.20

Latch Hit %:

98.62

Parse CPU to Parse Elapsd %:

10.61

% Non
-
Parse CPU:

99.55

Shared Pool Statistics


Begin

End

Memory Usage %:

87.67

81.12

% SQL with executions>1:

75.60

93.16

% Memory for SQL w/exec>1:

69.83

87.73

Top 5 Timed Foreground Events

Event

Waits

Time(s)

Avg wait (ms)

% DB time

Wait Class

db file sequential read

4,188,672

12,155

3

18.63

User I/O

DB CPU


10,339


15.85


log file switch (archiving needed)

59

8,481

143742

13.00

Configuration

direct path read

1,334,462

7,759

6

11.89

User

I/O

db file scattered read

704,398

3,940

6

6.04

User I/O

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

Load Average Begin

Load Average End

%User

%System

%WIO

%Idle

10.39

4.75

20.7

3.2

24.3

74.5

Instance CPU

%Total CPU

%Busy CPU

%DB time waiting for CPU
(Resource Manager)

20.9

81.8

0.0

Memory Statistics


Begin

End

Host Mem (MB):

96,476.4

96,476.4

SGA use (MB):

8,192.0

8,192.0

PGA use (MB):

4,703.3

2,487.0

% Host Mem used for SGA+PGA:

13.37

11.07

RAC Statistics


Begin

End

Number of Instances:

4

4

Global Cache Load Profile


Per Second

Per Transaction

Global Cache blocks received:

415.21

29.46

Global Cache blocks served:

365.64

25.94

GCS/GES messages received:

5,308.10

376.64

GCS/GES messages sent:

5,377.75

381.58

DBWR Fusion writes:

13.89

0.99

Estd Interconnect traffic (KB)

8,333.88


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

Buffer access
-

local cache %:

97.19

Buffer access
-

remote cache %:

0.43

Buffer access
-

disk %:

2.38

Global Cache and Enqueue Services
-

Workload Characteristics

Avg global enqueue get time (ms):

0.6

Avg global cache cr block receive time (ms):

4.0

Avg global cache current block receive time (ms):

1.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 %:

1.3

Avg global cache cr block flush time (ms):

61.5

Avg global cache current block pin time (ms):

0.7

Avg global cache current block send time (ms):

0.0

Global cache log flushes for current blocks served %:

0.2

Avg global cache current block flush time (ms):

31.8

Global Cache and Enqueue Services
-

Messaging Statistics

Avg message sent queue time (ms):

0.0

Avg message sent queue time on ksxp (ms):

1.2

Avg message received queue time (ms):

0.1

Avg GCS message process time (ms):

0.0

Avg GES message process time (ms):

0.0

% of direct sent messages:

20.80

% of indirect sent messages:

77.99

% of flow controlled messages:

1.21


Cluster Interconnect



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


Begin

End

Interface

IP Address

Pub

Source

IP

Pub

Src

eth1

10.101.160.148

N

cluster_interconnects parameter




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


More RAC Statistics



RAC Report Summary




Global Messaging Statistics




Global CR Served Stats




Global CURRENT Served Stats




Global Cache Transfer Stats




Interconnect Stats




Dynamic Remastering Statistics



Back to Top



Wait Events Statistics



Time Model Statistics




Operating System Statistics




Operating System Statistics
-

Detail




Foreground Wait Class




Foreground Wait Ev
ents




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


Back to Top


Time Model Statistics



Total time in database user
-
calls (DB Time): 65249.5s



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

54,632.04

83.73

DB
CPU

10,338.94

15.85

connection management call elapsed time

4,385.67

6.72

sequence load elapsed time

585.29

0.90

parse time elapsed

455.95

0.70

PL/SQL execution elapsed time

217.08

0.33

hard parse elapsed time

100.94

0.15

failed parse elapsed time

13.50

0.02

hard parse (sharing criteria) elapsed time

3.50

0.01

PL/SQL compilation elapsed time

2.96

0.00

Java execution elapsed time

0.38

0.00

repeated bind elapsed time

0.26

0.00

inbound PL/SQL rpc elapsed time

0.25

0.00

hard parse (bind mismatch)
elapsed time

0.13

0.00

DB time

65,249.46


background elapsed time

32,892.74


background cpu time

1,819.44


Back to Wait Events Statistics


Back to Top


Operating System Statistics



*TIME statistic values are diffed. All others displa
y 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

1,485,569


IDLE_TIME

4,340,569


IOWAIT_TIME

1,413,231


SYS_TIME

186,045


USER_TIME

1,207,877


LOAD

10

5

PHYSICAL_MEMORY_BYTES

101,162,786,816


NUM_CPUS

8


NUM_CPU_CORES

8


NUM_CPU_SOCKETS

2


GLOBAL_RECEIVE_SIZE_MAX

4,194,304


GLOBAL_SEND_SIZE_MAX

2,097,152


TCP_RECEIVE_SIZE_DEFAULT

262,143


TCP_RECEIVE_SIZE_MAX

524,288


TCP_RECEIVE_SIZE_MIN

4,096


TCP_SEND_SIZE_DEFAULT

262,143


TCP_SEND_SIZE_MAX

524,288


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

%iowa
it

30
-
Dec 01:00:00

10.39






30
-
Dec 02:00:04

13.01

26.72

22.30

2.98

73.28

21.43

30
-
Dec 03:00:10

4.75

24.02

18.84

3.45

75.98

27.67

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 85.5% of Total DB time 65,249.46 (s)



Total FG Wait Time: 45,440.52 (s) DB CPU time: 10,338.94 (s)

Wait Class

Waits

%Time
-
outs

Total Wait Time (s)

Avg
wait (ms)

%DB time

User I/O

6,614,376

0

27,916

4

42.78

DB CPU



10,339


15.85

Configuration

12,365

0

9,678

783

14.83

Cluster

3,870,783

0

4,871

1

7.47

Commit

20,904

0

1,191

57

1.83

Network

5,016,518

0

672

0

1.03

System I/O

305,723

0

511

2

0.78

Other

75,945,851

100

226

0

0.35

Concurrency

60,903

0

217

4

0.33

Administrative

36

92

123

3406

0.19

Application

9,164

4

37

4

0.06

Back to Wait Events Statistics


Back to Top


Foreground Wait Events



s
-

second, ms
-

millisecond
-

1000th of a second



Only events with Total Wait Time (s) >= .001 are shown



ordered by wait time desc, waits desc (idle events last)



%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event

Waits

%Time
-
outs

Total Wait Time
(s)

Avg wait
(ms)

Waits
/txn

% DB
time

db file sequential read

4,188,672

0

12,155

3

41.22

18.63

log file switch (archiving needed)

59

0

8,481

143742

0.00

13.00

direct path read

1,334,462

0

7,759

6

13.13

11.89

db file scattered read

704,398

0

3,940

6

6.93

6.04

gc buffer busy release

298

0

3,553

11924

0.00

5.45

direct path read temp

211,514

0

1,862

9

2.08

2.85

log file sync

20,904

0

1,191

57

0.21

1.83

log buffer space

11,336

0

1,114

98

0.11

1.71

db file parallel read

48,399

0

871

18

0.48

1.34

direct path write temp

60,696

0

673

11

0.60

1.03

local write wait

6,372

0

528

83

0.06

0.81

control file sequential read

305,723

0

511

2

3.01

0.78

gc cr multi block request

630,039

0

488

1

6.20

0.75

SQL*Net more data from dblink

676,668

0

408

1

6.66

0.63

gc current grant 2
-
way

1,149,405

0

245

0

11.31

0.37

SQL*Net message from dblink

5,979

0

226

38

0.06

0.35

gc cr grant 2
-
way

1,312,118

0

214

0

12.91

0.33

buffer busy waits

1,091

0

149

136

0.01

0.23

direct path write

13,848

0

110

8

0.14

0.17

switch logfile command

3

0

98

32726

0.00

0.15

gc cr block busy

4,965

0

89

18

0.05

0.14

gc
current block 3
-
way

289,765

0

88

0

2.85

0.14

gc current block 2
-
way

365,043

0

83

0

3.59

0.13

PX qref latch

75,807,485

100

74

0

746.00

0.11

log file switch completion

295

0

48

161

0.00

0.07

gc current block busy

4,901

0

37

8

0.05

0.06

reliable message

5,453

0

34

6

0.05

0.05

enq: ST
-

contention

281

0

33

119

0.00

0.05

enq: FB
-

contention

41,660

0

32

1

0.41

0.05

gc current multi block request

38,349

0

29

1

0.38

0.05

latch: cache buffers chains

16,855

0

27

2

0.17

0.04

JS kgl get object wait

33

100

24

741

0.00

0.04

gc buffer busy acquire

9,748

0

24

2

0.10

0.04

SQL*Net more data to client

883,396

0

22

0

8.69

0.03

name
-
service call wait

322

0

21

64

0.00

0.03

enq: RO
-

fast object reuse

781

0

19

24

0.01

0.03

PX Deq: Slave Session Stats

12,792

0

17

1

0.13

0.03

enq: KO
-

fast object checkpoint

5,351

0

15

3

0.05

0.02

os thread startup

130

0

14

110

0.00

0.02

SQL*Net more data from client

1,094,053

0

14

0

10.77

0.02

DFS lock handle

5,890

7

10

2

0.06

0.02

row cache lock

32,602

0

10

0

0.32

0.01

read by

other session

2,590

0

10

4

0.03

0.01

enq: CR
-

block range reuse ckpt

586

0

9

15

0.01

0.01

gcs drm freeze in enter server mode

125

0

8

62

0.00

0.01

Disk file operations I/O

43,425

0

7

0

0.43

0.01

gc cr block 2
-
way

27,351

0

6

0

0.27

0.01

cursor: pin S

wait on X

191

0

5

27

0.00

0.01

library cache load lock

244

0

5

20

0.00

0.01

latch free

638

0

3

5

0.01

0.01

gc current grant busy

4,770

0

3

1

0.05

0.00

latch: object queue header operation

5,554

0

3

1

0.05

0.00

PX Deq: reap credit

18,432

100

3

0

0.18

0.00

PX Deq: Table Q Get Keys

115

0

3

22

0.00

0.00

IPC send completion sync

4,398

0

2

1

0.04

0.00

library cache: mutex X

2,986

0

2

1

0.03

0.00

library cache lock

2,405

2

2

1

0.02

0.00

gc remaster

77

0

2

24

0.00

0.00

gc cr disk read

12,869

0

2

0

0.13

0.00

gc cr block 3
-
way

5,195

0

2

0

0.05

0.00

SQL*Net message to client

2,350,479

0

2

0

23.13

0.00

gc current grant congested

5,588

0

2

0

0.05

0.00

CSS initialization

140

0

1

11

0.00

0.00

enq: TX
-

row lock contention

33

0

1

44

0.00

0.00

gc current
block congested

4,161

0

1

0

0.04

0.00

enq: TM
-

contention

1,372

26

1

1

0.01

0.00

enq: PS
-

contention

2,245

21

1

1

0.02

0.00

library cache pin

3,094

0

1

0

0.03

0.00

gc cr grant congested

5,963

0

1

0

0.06

0.00

enq: TX
-

allocate ITL entry

18

0

1

53

0.00

0.00

enq: TX
-

index contention

44

0

1

21

0.00

0.00

gc current split

14

0

1

62

0.00

0.00

latch: shared pool

703

0

1

1

0.01

0.00

latch: gc element

2,395

0

1

0

0.02

0.00

PX Deq: Signal ACK EXT

6,147

0

1

0

0.06

0.00

latch: redo allocation

1,055

0

1

1

0.01

0.00

SQL*Net break/reset to client

1,618

0

1

0

0.02

0.00

latch: cache buffers lru chain

816

0

0

1

0.01

0.00

rdbms ipc reply

970

0

0

0

0.01

0.00

CSS operation: action

138

0

0

2

0.00

0.00

undo segment extension

16

94

0

17

0.00

0.00

latch: row
cache objects

548

0

0

0

0.01

0.00

kksfbc child completion

6

83

0

43

0.00

0.00

PX Deq: Signal ACK RSG

6,119

0

0

0

0.06

0.00

enq: HW
-

contention

324

8

0

1

0.00

0.00

ADR block file read

72

0

0

2

0.00

0.00

latch: undo global data

86

0

0

2

0.00

0.00

asynch descriptor resize

9,280

100

0

0

0.09

0.00

SGA: allocation forcing component growth

2

0

0

56

0.00

0.00

enq: TX
-

contention

22

0

0

5

0.00

0.00

KJC: Wait for msg sends to complete

10,540

0

0

0

0.10

0.00

latch: call allocation

7

0

0

11

0.00

0.00

latch: parallel query alloc buffer

157

0

0

0

0.00

0.00

enq: TS
-

contention

97

1

0

1

0.00

0.00

wait list latch free

29

0

0

2

0.00

0.00

latch: ges resource hash list

426

0

0

0

0.00

0.00

enq: TT
-

contention

122

0

0

0

0.00

0.00

gc cr block congested

157

0

0

0

0.00

0.00

write complete waits

4

0

0

9

0.00

0.00

latch: gcs resource hash

93

0

0

0

0.00

0.00

ADR block file write

10

0

0

4

0.00

0.00

enq: DL
-

contention

80

100

0

0

0.00

0.00

enq: PR
-

contention

2

0

0

14

0.00

0.00

enq: TO
-

contention

73

48

0

0

0.00

0.00

latch: checkpoint queue latch

35

0

0

0

0.00

0.00

enq: CF
-

contention

20

0

0

1

0.00

0.00

cursor: pin S

8

0

0

2

0.00

0.00

cr request retry

1

100

0

11

0.00

0.00

gc current retry

5

0

0

2

0.00

0.00

SQL*Net message to dblink

5,941

0

0

0

0.06

0.00

enq: JQ
-

contention

17

100

0

0

0.00

0.00

latch: enqueue hash chains

23

0

0

0

0.00

0.00

PX Deq: Table Q qref

959

0

0

0

0.01

0.00

latch: redo writing

32

0

0

0

0.00

0.00

enq: JI
-

contention

18

44

0

0

0.00

0.00

enq: MD
-

contention

23

0

0

0

0.00

0.00

latch: active service list

4

0

0

1

0.00

0.00

buffer deadlock

30

100

0

0

0.00

0.00

enq: PI
-

contention

7

100

0

1

0.00

0.00

CSS group membership query

2

0

0

2

0.00

0.00

gc cr failure

2

0

0

1

0.00

0.00

CSS operation: query

12

0

0

0

0.00

0.00

enq:

MS
-

contention

3

0

0

1

0.00

0.00

enq: JS
-

job run lock
-

synchronize

6

100

0

0

0.00

0.00

enq: AE
-

lock

4

0

0

0

0.00

0.00

enq: UL
-

contention

6

33

0

0

0.00

0.00

lock deadlock retry

2

100

0

1

0.00

0.00

latch: messages

4

0

0

0

0.00

0.00

SQL*Net
message from client

2,350,483

0

297,798

127

23.13


PX Deq: Execution Msg

86,374

0

21,172

245

0.85


PX Deq: Table Q Normal

1,663,860

0

13,922

8

16.37


PL/SQL lock timer

50

100

13,738

274767

0.00


Streams AQ: waiting for messages in the
queue

729

100

7,293

10004

0.01


PX Deq Credit: send blkd

285,525

0

5,825

20

2.81


jobq slave wait

2,386

99

1,191

499

0.02


PX Deq: Execute Reply

100,154

0

1,104

11

0.99


PX Deq Credit: need buffer

18,845

0

131

7

0.19


PX Deq: Join ACK

6,355

0

2

0

0.06


PX Deq:
Parse Reply

6,123

0

2

0

0.06


single
-
task message

35

0

1

34

0.00


PX Deq: Table Q Sample

189

0

1

3

0.00


PX Deq: Msg Fragment

50

0

0

0

0.00


PX Deq: Metadata Update

12

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

Log archive I/O

26,343

0

3,558

135

0.26

10.82

log file switch (archiving needed)

11

0

3,101

281886

0.00

9.43

log file parallel write

155,939

0

2,334

15

1.53

7.09

db file parallel write

482,091

0

1,068

2

4.74

3.25

db file sequential read

309,959

0

1,026

3

3.05

3.12

control file sequential read

486,755

0

492

1

4.79

1.50

row cache lock

2,206

6

417

189

0.02

1.27

ARCH wait on SENDREQ

25,246

0

417

17

0.25

1.27

gc buffer busy release

24

0

306

12753

0.00

0.93

gcs log flush sync

195,837

4

272

1

1.93

0.83

log file sequential read

30,551

0

219

7

0.30

0.67

gc cr multi block request

82,372

0

202

2

0.81

0.61

db file scattered read

41,956

0

196

5

0.41

0.60

LNS wait on SENDREQ

78,434

0

194

2

0.77

0.59

enq: WF
-

contention

43

0

156

3627

0.00

0.47

db file async I/O submit

67,304

0

156

2

0.66

0.47

enq: CF
-

contention

6,515

12

112

17

0.06

0.34

Disk file
operations I/O

75,800

0

91

1

0.75

0.28

reliable message

1,129

8

90

80

0.01

0.27

control file parallel write

12,062

0

84

7

0.12

0.26

gc cr grant 2
-
way

115,767

0

16

0

1.14

0.05

name
-
service call wait

143

0

13

93

0.00

0.04

ges lms sync during dynamic
remastering and
reconfig

1,217

38

12

10

0.01

0.04

PX Deq: reap credit

48,163

100

8

0

0.47

0.03

enq: KO
-

fast object checkpoint

10,398

0

7

1

0.10

0.02

db file parallel read

1,117

0

6

5

0.01

0.02

gc current grant 2
-
way

27,460

0

5

0

0.27

0.02

log buffer

space

77

0

5

62

0.00

0.01

ges inquiry response

7,158

0

4

1

0.07

0.01

LGWR wait for redo copy

8,149

0

4

0

0.08

0.01

latch free

2,722

0

4

1

0.03

0.01

os thread startup

121

0

4

29

0.00

0.01

DFS lock handle

9,080

44

3

0

0.09

0.01

gc current block busy

3,544

0

3

1

0.03

0.01

gc current block 2
-
way

15,806

0

3

0

0.16

0.01

gcs drm freeze in enter server mode

49

0

3

57

0.00

0.01

gc cr block busy

151

0

3

17

0.00

0.01

latch: object queue header operation

4,911

0

2

0

0.05

0.01

enq: TM
-

contention

159

81

2

12

0.00

0.01

ARCH wait on ATTACH

3

0

2

625

0.00

0.01

row cache process

336,220

0

2

0

3.31

0.00

direct path read

285

0

1

4

0.00

0.00

latch: shared pool

482

0

1

2

0.00

0.00

gc object scan

893,389

100

1

0

8.79

0.00

enq: XR
-

database force logging

2,386

0

1

0

0.02

0.00

gc cr block 2
-
way

5,634

0

1

0

0.06

0.00

log file single write

264

0

1

4

0.00

0.00

enq: RO
-

fast object reuse

1,784

0

1

1

0.02

0.00

latch: cache buffers lru chain

2,925

0

1

0

0.03

0.00

ges generic event

92

89

1

9

0.00

0.00

direct
path write

109

0

1

8

0.00

0.00

libcache interrupt action by LCK

172,015

0

1

0

1.69

0.00

CSS operation: action

285

0

1

3

0.00

0.00

latch: redo allocation

396

0

1

2

0.00

0.00

log file sync

6

0

1

121

0.00

0.00

latch: gc element

3,578

0

1

0

0.04

0.00

ksxr poll remote instances

138,397

100

1

0

1.36

0.00

gc current block 3
-
way

2,173

0

1

0

0.02

0.00

kjbdrmcvtq lmon drm quiesce: ping completion

128

0

1

5

0.00

0.00

buffer busy waits

41

0

1

15

0.00

0.00

CGS wait for IPC msg

79,967

100

0

0

0.79

0.00

latch: redo writing

32

0

0

14

0.00

0.00

row cache cleanup

231,378

0

0

0

2.28

0.00

ARCH wait for archivelog lock

13,797

0

0

0

0.14

0.00

CSS operation: data query

291

0

0

1

0.00

0.00

gc remaster

11

0

0

27

0.00

0.00

latch: ges resource hash list

3,535

0

0

0

0.03

0.00

library cache pin

1,113

0

0

0

0.01

0.00

enq: PR
-

contention

2

0

0

87

0.00

0.00

latch: gcs resource hash

1,066

0

0

0

0.01

0.00

ADR block file read

58

0

0

3

0.00

0.00

latch: checkpoint queue latch

446

0

0

0

0.00

0.00

SQL*Net break/reset
to client

16

0

0

9

0.00

0.00

latch: cache buffers chains

857

0

0

0

0.01

0.00

enq: WR
-

contention

27

100

0

5

0.00

0.00

latch: call allocation

290

0

0

0

0.00

0.00

enq: TT
-

contention

310

95

0

0

0.00

0.00

gc cr grant congested

498

0

0

0

0.00

0.00

latch: undo global data

2

0

0

44

0.00

0.00

enq: PS
-

contention

135

40

0

1

0.00

0.00

log file switch completion

3

0

0

25

0.00

0.00

undo segment extension

4

100

0

19

0.00

0.00

CSS group membership query

97

0

0

1

0.00

0.00

ges2 LMON to wake up LMD
-

mrcvr

167

0

0

0

0.00

0.00

gc cr block 3
-
way

212

0

0

0

0.00

0.00

gc quiesce

6

100

0

10

0.00

0.00

PX Deq: Signal ACK EXT

95

0

0

1

0.00

0.00

gc current grant busy

178

0

0

0

0.00

0.00

library cache lock

159

11

0

0

0.00

0.00

enq: TX
-

index contention

1

0

0

43

0.00

0.00

ARCH wait on DETACH

1

0

0

42

0.00

0.00

ADR block file write

15

0

0

2

0.00

0.00

enq: PI
-

contention

13

100

0

2

0.00

0.00

ges LMON to get to FTDONE

2

50

0

12

0.00

0.00

read by other session

5

0

0

5

0.00

0.00

enq: WL
-

contention

53

100

0

0

0.00

0.00

gc current grant congested

133

0

0

0

0.00

0.00

wait list latch free

17

0

0

1

0.00

0.00

gc current block congested

65

0

0

0

0.00

0.00

CSS initialization

3

0

0

6

0.00

0.00

asynch descriptor resize

2,302

100

0

0

0.02

0.00

enq: TA
-

contention

32

0

0

0

0.00

0.00

enq: TD
-

KTF dump entries

20

0

0

1

0.00

0.00

gc cr disk read

59

0

0

0

0.00

0.00

IPC send completion sync

81

0

0

0

0.00

0.00

enq: JQ
-

contention

28

100

0

0

0.00

0.00

gc buffer busy acquire

6

0

0

1

0.00

0.00

gc cr block
congested

30

0

0

0

0.00

0.00

enq: TS
-

contention

12

100

0

1

0.00

0.00

SQL*Net more data from client

71

0

0

0

0.00

0.00

PX Deq: Signal ACK RSG

95

0

0

0

0.00

0.00

SQL*Net message to client

6,957

0

0

0

0.07

0.00

enq: CR
-

block range reuse ckpt

8

0

0

1

0.00

0.00

latch: messages

22

0

0

0

0.00

0.00

latch: active service list

16

0

0

0

0.00

0.00

PX Deq: Slave Session Stats

95

0

0

0

0.00

0.00

SQL*Net more data to client

71

0

0

0

0.00

0.00

gc current retry

1

0

0

2

0.00

0.00

latch: row cache objects

21

0

0

0

0.00

0.00

KJC: Wait for msg sends to complete

95

0

0

0

0.00

0.00

enq: DR
-

contention

4

0

0

0

0.00

0.00

enq: PE
-

contention

2

100

0

1

0.00

0.00

enq: FB
-

contention

1

0

0

1

0.00

0.00

rdbms ipc message

581,274

21

181,413

312

5.72


PX Idle Wait

7,024

0

89,572

12752

0.07


Streams AQ: waiting for time management or
cleanup tasks

15

67

76,615

5107657

0.00


Space Manager: slave idle wait

14,637

70

59,001

4031

0.14


EMON slave idle wait

7,285

100

36,434

5001

0.07


gcs remote message

13,349,659

7

28,200

2

131.37


DIAG idle wait

214,935

58

14,534

68

2.12


PING

3,476

16

7,295

2099

0.03


GCR sleep

1,458

100

7,292

5001

0.01


wait for unread message on broadcast channel

7,252

100

7,289

1005

0.07


pmon timer

2,505

96

7,286

2909

0.02


Streams AQ:
emn coordinator idle wait

728

100

7,283

10004

0.01


Streams AQ: qmn coordinator idle wait

508

50

7,276

14322

0.00


Streams AQ: qmn slave idle wait

255

0

7,275

28531

0.00


ges remote message

335,510

14

7,274

22

3.30


smon timer

342

1

7,108

20783

0.00


LNS ASYNC end of log

53,452

1

3,251

61

0.53


class slave wait

76

0

2,510

33023

0.00


JOX Jit Process Sleep

42

100

315

7503

0.00


SQL*Net message from client

8,978

0

26

3

0.09


PX Deq: Join ACK

95

0

0

3

0.00


PX Deq: Parse Reply

95

0

0

1

0.00


heartbeat monitor sleep

13

0

0

2

0.00


PX Deq: Execute Reply

95

0

0

0

0.00


KSV master wait

4,391

100

0

0

0.04


Streams AQ: RAC qmn coordinator idle wait

514

100

0

0

0.01


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)



% of Waits

Event

Total
Waits

<1ms

<2ms

<4ms

<8ms

<16ms

<32ms

<=1s

>1s

ADR block file read

130

67.7

2.3

5.4

16.2

7.7

.8



ADR block file write

25

68.0

4.0


12.0

12.0

4.0



ADR file lock

30

100.0








ARCH wait for archivelog lock

13.8K

100.0

.0



.0




ARCH wait on ATTACH

3







100.0


ARCH wait on DETACH

1







100.0


ARCH wait on SENDREQ

25.2K

99.2

.0



.0


.2

.5

ASM file metadata operation

2

100.0








CGS wait for IPC msg

79.9K

100.0

.0







CSS group membership query

99

92.9

3.0

4.0






CSS initialization

143



11.2

37.8

30.8

19.6

.7


CSS operation: action

423

21.5

31.4

39.5

4.0

1.4

1.9

.2


CSS operation: data query

291

35.7

63.9

.3






CSS operation: query

109

99.1

.9







DFS lock handle

14.9K

88.4

8.5

1.9

.6

.2

.1

.3

.0

Disk file operations I/O

118K

96.6

1.4

.6

.6

.3

.2

.4

.0

IPC send completion sync

4470

97.4

1.3

.4

.5

.1

.1

.2


JS kgl get object wait

33







69.7

30.3

KJC: Wait for msg sends to complete

10.6K

100.0


.0






LGWR wait for redo copy

8148

95.3

2.1

1.3

.8

.2

.1

.2


LNS wait on SENDREQ

78.4K

99.6

.0

.0




.3

.0

Log archive I/O

26.3K

1.0

.4

.6

1.6

7.0

15.0

74.1

.4

PX Deq Credit: free buffer

76

100.0








PX Deq: Signal ACK EXT

6230

99.4

.3

.1

.0


.0

.1


PX Deq: Signal ACK RSG

6202

99.3

.5

.2

.0





PX Deq: Slave Session Stats

12.9K

73.1

17.1

8.0

1.3

.0

.0

.4


PX Deq: Table Q Get Keys

115

32.2

24.3

10.4

12.2

9.6

7.0

4.3


PX Deq: Table Q qref

959

99.8

.2







PX Deq: reap credit

66.4K

99.9

.0

.0

.0

.0

.0

.0

.0

PX qref latch

75.8M

100.0

.0

.0

.0


.0

.0


SGA: allocation forcing component growth

2







100.0


SQL*Net break/reset to client

1634

98.7

.6

.1

.2

.1

.1

.2


SQL*Net break/reset to dblink

3

100.0








SQL*Net message from dblink

5974

76.6

7.0

3.3

2.0

2.4

1.4

7.0

.3

SQL*Net message to client

2353.5K

100.0

.0

.0






SQL*Net message to dblink

5936

100.0








SQL*Net more data from client

1094.1K

99.9

.0

.0

.0

.0

.0

.0


SQL*Net more data from dblink

675.8K

97.8

.5

.5

.4

.4

.2

.3

.0

SQL*Net more data to client

883.5K

100.0

.0

.0

.0

.0

.0

.0


SQL*Net more data to dblink

2

100.0








asynch descriptor resize

11.6K

99.8

.1

.1

.0


.0

.0


buffer busy waits

1132

83.5

4.2

3.0

1.8

1.8

1.3

4.4

.1

buffer deadlock

30

96.7

3.3







control file parallel write

12.1K

51.5

21.7

10.7

5.4

4.5

2.1

4.1


control file sequential read

792.5K

87.6

6.1

2.6

1.5

1.3

.5

.5


cr request retry

1





100.0




cursor: mutex S

1

100.0








cursor: mutex X

1

100.0








cursor: pin S

8

75.0

12.5



12.5




cursor: pin S wait on X

191

1.6

1.6

7.3

6.8

49.2

9.9

23.6


db file async I/O submit

67.4K

81.1

7.0

5.5

3.1

.9

.7

1.7

.0

db file parallel read

49.5K

16.1

24.7

18.3

10.5

8.5

6.4

15.4


db file parallel write

482.1K

67.9

17.5

8.0

3.1

1.5

.9

1.2

.0

db file scattered read

744K

3.9

42.9

24.6

15.3

8.2

2.9

2.2

.0

db file sequential read

4493.5K

61.6

16.1

8.6

7.3

3.9

1.2

1.3

.0

direct path read

1335.2K

21.8

32.6

21.9

12.9

5.7

2.3

2.8

.0

direct path read temp

211.5K

31.6

14.7

13.5

14.6

13.3

7.3

5.1

.0

direct path write

14K

20.5

16.0

23.0

19.7

11.0

5.8

4.1


direct path write temp

60.7K

23.9

13.3

17.5

17.7

14.6

6.0

7.0

.0

enq: AE
-

lock

4

100.0








enq: AF
-

task serialization

3

100.0








enq: CF
-

contention

6534

14.2

1.4

1.0

1.2

54.7

19.0

8.4

.1

enq: CR
-

block range reuse ckpt

594

10.8

5.4

32.2

28.3

12.8

5.2

5.4


enq: DL
-

contention

80

90.0

7.5

1.3

1.3





enq: DR
-

contention

4

100.0








enq:
FB
-

contention

41.7K

91.5

4.8

2.0

.9

.3

.1

.3


enq: HW
-

contention

325

91.7

4.6

2.2

.9

.3

.3



enq: JI
-

contention

18

94.4

5.6







enq: JQ
-

contention

45

97.8

2.2







enq: JS
-

job run lock
-

synchronize

6

100.0








enq: KO
-

fast object
checkpoint

15.7K

93.3

4.6

1.0

.4

.2

.1

.5

.0

enq: MD
-

contention

22

100.0








enq: MS
-

contention

3

66.7

33.3







enq: MW
-

contention

2

100.0








enq: PE
-

contention

2

100.0








enq: PI
-

contention

20

90.0

5.0




5.0



enq: PR
-

contention

4





25.0

25.0

50.0


enq: PS
-

contention

2365

93.2

4.1

1.5

.8

.2

.1

.1


enq: RO
-

fast object reuse

2565

84.1

6.2

1.9

1.4

2.4

1.6

2.4

.1

enq: SR
-

contention

2

100.0








enq: ST
-

contention

281

82.2

3.6

1.1

2.1

5.3

1.4

3.6

.7

enq: TA
-

contention

32

100.0








enq: TD
-

KTF dump entries

20

85.0

15.0







enq: TM
-

contention

1529

93.1

4.3

1.6

.4

.3


.2

.1

enq: TO
-

contention

73

98.6


1.4






enq: TQ
-

DDL contention

2

100.0








enq: TQ
-

TM contention

1

100.0








enq:
TS
-

contention

109

92.7

2.8

2.8


.9

.9



enq: TT
-

contention

432

93.5

5.3

.9

.2





enq: TX
-

allocate ITL entry

18

44.4




11.1


44.4


enq: TX
-

contention

22

40.9

9.1

4.5

18.2

27.3




enq: TX
-

index contention

45

17.8


6.7

6.7

24.4

11.1

33.3


enq: TX
-

row lock contention

33

60.6

6.1

6.1

3.0

3.0


21.2


enq: UL
-

contention

6

100.0








enq: US
-

contention

4

100.0








enq: WF
-

contention

43

88.4

4.7

2.3


2.3



2.3

enq: WL
-

contention

53

92.5

3.8

3.8






enq: WP
-

contention

1

100.0








enq: WR
-

contention

27

85.2


3.7

7.4



3.7


enq: XR
-

database force logging

2385

94.1

4.0

1.0

.5

.3

.1

.0


gc buffer busy acquire

9754

82.7

10.7

3.0

1.3

1.0

.3

.9


gc buffer busy release

322

5.3

4.3

6.2

11.5

11.8

8.7

43.2

9.0

gc cr block
2
-
way

33K

99.2

.5

.2

.1

.0


.0


gc cr block 3
-
way

5406

97.3

1.9

.5

.2

.1




gc cr block busy

5116

27.6

28.8

20.0

5.2

4.1

3.5

10.8

.0

gc cr block congested

187

97.9

1.1

1.1






gc cr disk read

12.9K

99.3

.5

.1

.0

.0




gc cr failure

2

50.0


50.0






gc cr grant 2
-
way

1425.5K

99.0

.6

.2

.1

.0

.0

.0


gc cr grant congested

6449

98.5

1.0

.2

.1

.1


.0


gc cr multi block request

711.2K

88.6

5.8

2.7

1.6

.8

.3

.2

.0

gc current block 2
-
way

380.9K

99.0

.7

.2

.1

.0

.0

.0


gc current block 3
-
way

291.9K

99.0

.7

.2

.1

.0

.0

.0


gc current block busy

8427

48.5

19.3

19.6

7.7

2.5

1.2

1.2

.0

gc current block congested

4231

98.6

.9

.3

.1

.0


.0


gc current grant 2
-
way

1177.2K

98.2

1.1

.5

.2

.1

.0

.0


gc current grant busy

4948

95.7

2.3

.8

.5

.3

.3

.2


gc
current grant congested

5723

97.3

1.5

.6

.4

.1

.1

.1


gc current multi block request

38.3K

95.6

2.4

1.0

.4

.2

.1

.3


gc current retry

6

66.7

16.7



16.7




gc current split

15

66.7


6.7

13.3

6.7


6.7


gc object scan

892.8K

100.0



.0





gc quiesce

6





100.0




gc remaster

88

9.1

1.1

3.4

15.9

23.9

23.9

22.7


gcs drm freeze in enter server mode

174

12.1

.6

1.1

1.7

4.6

9.2

70.7


gcs log flush sync

195.8K

69.1

12.2

8.9

5.2

4.5




ges LMON to get to FTDONE

2



50.0



50.0



ges generic event

92

10.9




89.1




ges inquiry response

7158

93.2

5.1

1.0

.3

.2

.0

.2


ges lms sync during dynamic remastering and
reconfig

1217

6.5

7.5

18.2

23.5

28.9

13.1

2.2


ges2 LMON to wake up LMD
-

mrcvr

167

88.0

9.6

1.2

1.2





global enqueue expand wait

5

100.0








kjbdrmcvtq lmon drm quiesce: ping completion

128

36.7

7.8

18.0

18.8

10.2

8.6



kksfbc child completion

6

16.7






83.3


ksxr poll remote instances

138.3K

100.0

.0







latch free

3359

96.4

1.2

.7

.5

.3

.0

.8

.0

latch: active service list

20

80.0

20.0







latch: cache buffer handles

3

100.0








latch: cache buffers chains

17.7K

70.9

10.0

8.8

5.9

3.3

1.0

.1


latch: cache buffers lru chain

3737

92.7

3.6

2.5

.9

.1

.1

.1


latch: call allocation

297

90.2

7.1

1.7



1.0



latch: checkpoint queue

latch

481

91.3

4.8

2.9

.8

.2




latch: enqueue hash chains

33

90.9

9.1







latch: gc element

5965

95.9

2.4

.9

.6

.1

.0

.0


latch: gcs resource hash

1161

97.8

1.3

.3

.2

.3

.1



latch: ges resource hash list

3959

99.6

.3

.0

.0

.0




latch: messages

26

96.2

3.8







latch: object queue header operation

10.5K

91.5

4.8

2.3

1.1

.3

.1

.1


latch: parallel query alloc buffer

159

85.5

12.6


1.9





latch: redo allocation

1451

89.0

5.6

3.2

1.7

.3

.1

.2


latch: redo writing

64

90.6


6.3


1.6


1.6


latch:

row cache objects

569

91.2

4.6

2.3

1.2

.7




latch: shared pool

1185

67.0

16.7

6.5

4.8

3.3

1.1

.6


latch: undo global data

88

89.8

3.4

1.1

2.3

1.1


2.3


libcache interrupt action by LCK

171.9K

100.0








library cache load lock

244

22.1

24.2

13.9

4.1

19.3

3.7

12.7


library cache lock

2562

93.9

3.8

1.3

.3

.3

.2

.2


library cache pin

4203

95.6

3.2

.7

.4

.1


.0


library cache: mutex X

2988

79.1

13.9

3.9

.9

2.2

.0



local write wait

6372

1.1

7.2

10.7

10.8

13.2

11.6

45.2

.3

lock deadlock retry

2

50.0

50.0







log buffer space

11.4K

.7

.8

1.8

3.9

8.2

15.5

68.1

.9

log file parallel write

155.9K

21.9

18.0

14.1

13.9

13.1

10.8

8.2

.0

log file sequential read

30.5K

87.5

3.0

1.1

1.7

1.1

1.9

3.8

.1

log file single write

264

71.6

13.6

5.7

3.4

1.5

1.1

3.0


log file switch (archiving needed)

70







8.6

91.4

log file switch completion

298


.3

.7

.7

5.0

17.4

74.5

1.3

log file sync

20.9K

22.2

16.2

12.8

11.0

9.3

6.7

21.3

.6

name
-
service call wait

465

16.3

1.7

1.1

1.3

1.3

7.1

71.2


os thread startup

251





11.2

31.9

57.0


rdbms ipc reply

970

94.8

3.0

1.3

.6

.1


.1


read by other session

2595

40.1

31.6

11.1

7.9

5.2

2.2

1.8


reliable message

6565

61.1

11.3

19.9

2.8

.9

.5

3.6


row cache cleanup

231.2K

100.0


.0


.0




row cache lock

34.8K

95.4

2.7

.9

.4

.1

.1

.1

.4

row cache process

336K

100.0



.0





switch logfile command

3








100.0

undo segment extension

20

30.0


5.0


25.0

20.0

20.0


wait list latch free

46

41.3

43.5

8.7

2.2

4.3




write complete waits

4


50.0



25.0

25.0



DIAG idle
wait

214.8K

23.0

1.6

1.0

.8

10.4

24.7

38.6


EMON slave idle wait

7284








100.0

GCR sleep

1457








100.0

JOX Jit Process Sleep

42







7.1

92.9

KSV master wait

4391

100.0








LNS ASYNC end of log

53.5K

19.5

9.3

7.8

7.2

8.7

8.6

38.8


PING

3467

82.7

.6

.1

.0

.0

.1


16.5

PL/SQL lock timer

50







6.0

94.0

PX Deq Credit: need buffer

18.8K

62.5

13.2

10.5

6.6

3.3

1.6

2.3

.1

PX Deq Credit: send blkd

285.5K

9.3

4.6

25.3

20.9

19.3

7.3

13.2

.1

PX Deq: Execute Reply

100.2K

78.1

4.4

5.0

4.1

2.9

2.0

3.4

.1

PX Deq: Execution Msg

86.4K

61.5

8.5

8.9

5.7

4.2

2.9

6.0

2.3

PX Deq: Join ACK

6436

95.4

3.2

1.0

.1

.2

.1

.1


PX Deq: Metadata Update

12

91.7


8.3






PX Deq: Msg Fragment

47

97.9


2.1






PX Deq: Parse Reply

6206

96.8

1.7

.7

.3

.3

.1

.1


PX Deq: Table Q Normal

1661.5K

61.4

10.9

11.0

9.3

4.4

1.6

1.5

.1

PX Deq: Table Q Sample

189

54.0

19.6

9.0

11.6

2.1

1.6

2.1


PX Idle Wait

6851

.7

3.8

2.8

18.1

27.3

6.8

18.9

21.6

SQL*Net message from client

2355.6K

62.0

20.2

10.3

1.1

.5

.5

4.3

.9

Space
Manager: slave idle wait

14.6K

.4

.5

1.0

1.1

1.3

1.0

7.8

87.0

Streams AQ: RAC qmn coordinator idle wait

514

100.0








Streams AQ: emn coordinator idle wait

728








100.0

Streams AQ: qmn coordinator idle wait

508

49.2

.4


.2


.2


50.0

Streams AQ:
qmn slave idle wait

255

.4







99.6

Streams AQ: waiting for messages in the queue

728








100.0

Streams AQ: waiting for time management or
cleanup tasks

15

6.7






33.3

60.0

class slave wait

77

80.5


1.3





18.2

gcs remote message

13.3M

56.0

12.9

13.4

9.3

8.4

.0

.0


ges remote message

335.3K

49.5

6.8

5.5

5.4

5.6

5.1

22.0


heartbeat monitor sleep

13

53.8


38.5

7.7





jobq slave wait

2386


.0




.0

99.9


pmon timer

2504

.8

.2

.5

.2

.2

.2

.6

97.2

rdbms ipc message

581K

44.5

4.3

3.7

4.5

5.1

3.1

30.4

4.5

single
-
task message

35





8.6

82.9

8.6


smon timer

342

1.5

2.0

2.6

3.8

5.0

3.8

19.6

61.7

wait for unread message on broadcast channel

7249







99.2

.8

Back to Wait Events Statistics


Back to Top


Wait Event Histogram Detail (64 msec to 2 sec)



Units for Total Waits column: K i
s 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)



% of Total Waits

Event

Waits 64ms to
2s

<32ms

<64ms

<1/8s

<1/4s

<1/2s

<1s

<2s

>=2s

ARCH wait on ATTACH

3





33.3

66.7



ARCH wait on DETACH

1


100.0







ARCH
wait on SENDREQ

87

99.3

.0

.0

.0

.1

.1

.1

.4

CSS initialization

1

99.3

.7







CSS operation: action

1

99.8

.2







DFS lock handle

39

99.7

.1

.1

.0

.0


.0


Disk file operations I/O

422

99.6

.1

.1

.0

.0

.0

.0


IPC send completion sync

11

99.8

.0

.1

.1





JS kgl get object wait

33



12.1

9.1

18.2

30.3

30.3


LGWR wait for redo copy

20

99.8

.0

.2

.0

.0




LNS wait on SENDREQ

256

99.7

.1

.0

.0

.1

.1

.0

.0

Log archive I/O

19.6K

25.5

21.6

22.5

16.5

9.4

4.1

.4

.0

PX Deq: Signal ACK EXT

4

99.9

.0

.0

.0





PX Deq: Slave Session Stats

46

99.6

.0

.2

.1

.0

.0



PX Deq: Table Q Get Keys

5

95.7

1.7



.9

1.7



PX Deq: reap credit

14

100.0

.0

.0

.0

.0


.0

.0

PX qref latch

2

100.0


.0

.0





SGA: allocation forcing component growth

2


50.0

50.0






SQL*Net break/reset to client

4

99.8

.1

.1


.1




SQL*Net message from dblink

424

92.7

2.9

2.9

.9

.2

.2

.1

.3

SQL*Net more data from client

4

100.0

.0

.0






SQL*Net more data from dblink

1891

99.7

.1

.1

.1

.0

.0

.0

.0

SQL*Net more data to client

21

100.0

.0

.0

.0





asynch descriptor resize

1

100.0

.0







buffer busy waits

50

95.5

1.4

1.9

.5

.4

.1


.1

control file parallel write

499

95.9

1.8

1.2

.8

.3

.0



control file sequential read

3808

99.5

.3

.2

.1

.0

.0



cursor: pin S wait on X

45

76.4

12.6

11.0






db file async I/O submit

1152

98.3

.9

.6

.2

.0

.0

.0


db file parallel read

7643

84.6

6.8

6.4

1.9

.4

.0