Топ-100
 

ORACLE SESSION EVENT

2

batched allocate scn lock request

3

BFILE check if exists

4

BFILE check if open

5

BFILE closure

6

BFILE get length

7

BFILE get name object

8

BFILE get path object

9

BFILE internal seek

10

BFILE open

11

BFILE read

12

broadcast mesg queue transition

13

broadcast mesg recovery queue transition

14

buffer busy waits

15

buffer deadlock

16

buffer for checkpoint

17

buffer latch

18

buffer read retry

19

checkpoint completed

20

cleanup of aborted processes

21

control file parallel write

22

control file sequential read

23

control file single write

24

cursor: mutex S

25

cursor: mutex X

26

cursor: pin S

27

cursor: pin S wait on X

28

cursor: pin X

29

Data Guard: process clean up

30

Data Guard: process exit

31

Data Guard Broker: single instance

32

db file parallel read

33

db file parallel write

34

db file scattered read

35

db file sequential read

36

db file single write

37

DFS db file lock

38

DFS lock handle

39

direct path read

40

direct path sync

41

direct path write

42

Disk file operations I/O

43

dispatcher shutdown

44

dispatcher timer

45

duplicate cluster key

46

enq: OW – initialization

47

enq: OW – termination

48

enqueue

49

flashback buf free by RVWR

50

flashback logfile sync

51

free buffer waits

52

free global transaction table entry

53

free process state object

54

gc recovery quiesce

55

GCS lock open S

56

GCS lock open X

57

gcs remastering wait for drop pkey

58

global cache busy

59

global cache lock cleanup

60

global cache freelist

61

inactive session

62

inactive transaction branch

63

index block split

64

instance state change

65

io done

66

kcl bg acks

67

ksxr wait for mount shared

68

ktm: instance recovery

69

latch activity

70

latch free

71

latch: cache buffers chains

72

library cache load lock

73

library cache lock

74

library cache pin

75

library cache shutdown

76

LMON global data update

77

lock manager wait for remote message

78

Log archive I/O

79

log buffer space

80

log file parallel write

81

log file sequential read

82

log file single write

83

log file switch (archiving needed)

84

log file switch (checkpoint incomplete)

85

log file switch (clearing log file)

86

log file switch (private strand flush incomplete)

87

log file switch completion

88

log file sync

89

log switch/archive

90

optimizer stats update retry

91

parallel recovery change buffer free

92

parallel recovery control message reply

93

parallel recovery coord send blocked

94

parallel recovery coord wait for reply

95

parallel recovery coordinator waits for slave cleanup

96

parallel recovery read buffer free

97

parallel recovery slave next change

98

pending global transaction(s)

99

pipe get

100

pipe put

101

PL/SQL lock timer

102

pmon timer

103

prewarm transfer retry

104

prior process spawner to be cleaned up

105

process startup

106

PX Deque wait

107

PX qref latch

108

PX server shutdown

109

PX signal server

110

rdbms ipc message

111

rdbms ipc message block

112

rdbms ipc reply

113

read by other session

114

recovery read

115

resmgr: become active

116

resmgr: cpu quantum

117

resmgr: pq queued

118

rolling migration: cluster quiesce

119

row cache lock

120

RVWR wait for flashback copy

121

sbtbufinfo

122

sbtgetbuf

123

sbtmapbuf

124

sbtrelbuf

125

scginq AST call

126

SGA: allocation forcing component growth

127

SGA: MMAN sleep for component shrink

128

SGA: sga_target resize

129

Shared IO Pool Memory

130

single-task message

131

shared server idle wait

132

smon timer

133

SQL*Net break/reset to client

134

SQL*Net break/reset to dblink

135

SQL*Net message from client

136

SQL*Net message from dblink

137

SQL*Net message to client

138

SQL*Net message to dblink

139

SQL*Net more data from client

140

SQL*Net more data from dblink

141

SQL*Net more data to client

142

SQL*Net more data to dblink

143

Streams AQ: waiting for messages in the queue

144

switch logfile command

145

TCP Socket (KGAS)

146

timer in sksawat

147

transaction

148

unbound tx

149

undo_retention publish retry

150

undo segment extension

151

undo segment recovery

152

undo segment tx slot

153

virtual circuit status

154

virtual circuit wait

155

WCR: replay client notify

156

WCR: replay clock

157

WCR: replay lock order

158

WCR: replay paused

159

WCR: Sync context busy

160

WMON goes to sleep

161

write complete waits

162

writes stopped by instance recovery or database suspension