Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: September 15, 2016 - 11:20 am UTC

Last updated: September 17, 2016 - 2:18 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi team,

Can you pls brief me regarding this wait event because i have continuously and every time getting this event.

So pls let me know what is the meaning of this event and how to resolve this what is the solution of this event.


EVENT
------------------------
read by other session
buffer busy waits
enq: SQ - contention
db file sequential read
enq: HW - contention


Thanks

and Connor said...

in a nutshell

read by other session
- 'n' people wanted a block.
- the block wasn't in memory so we need to read it off disk
- it doesnt make sense for 'n' people to read the disk
- so 1 will read it into memory, the others will wait

buffer busy waits
- i've got a block in memory
- 'n' people want to access/modify that block in way that may be incompatible with others
- someone has to wait

enq: SQ - contention
- lots of people accessing a sequence
- at some point, several of them want to update the dictionary table that holds the last number cached

db file sequential read
- i want to read a single block from disk.
- that takes time

enq: HW - contention
- a table is growing
- 'n' people are all adding data to it
- at some point we need to shift the high watermark for the table
- people need to wait whilst one of them does that.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Capture wait event

A reader, September 16, 2016 - 6:42 am UTC

How to capture all wait event occurred during a specific time like from 16-09-2016 morning to 16-09-2016 night for all users in standard edition of 11g.
Connor McDonald
September 17, 2016 - 2:18 am UTC

love it!

Paul Muller, September 16, 2016 - 9:10 pm UTC

I love these natural language descriptions of wait events!!
You've really made these somewhat difficult concepts easy to intuitively understand.

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.