Re: Lot of Latch Free and Enqueue Hash Chain Wait Events

From: Ravi Teja Bellamkonda <raviteja.bellamkonda7@xxxxxxxxx>
To: Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
Date: Tue, 3 Oct 2017 11:39:53 -0700

Hi Hans,

Platform_Name - Linux x86 64-bit
cpu_count - 40
Host Memory - 160 GB

Version Details:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE 11.2.0.4.0 Production"
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

Patch:

PSU PSU 11.2.0.4.160119

4000 - 5000 VUsers.

On Tue, Oct 3, 2017 at 11:33 AM, Hans Forbrich <fuzzy.graybeard@xxxxxxxxx>
wrote:

Now would be a good time to provide some details:

- Operating System & relevant details (version, memory)?
- Oracle Version, Edition, Patch level?
- Some load information (Users/Threads/Connection, Connection style) ?

to start.
/Hans

On 2017-10-03 9:47 AM, Ravi Teja Bellamkonda wrote:

Hi,

I started my analysis based on the AWR Report, which is stating high wait
events on Latch Free.

[image: Inline image 1]

On Tue, Oct 3, 2017 at 8:08 AM, bhavani d <bhavani021@xxxxxxxxx> wrote:

Dont assume.

Just take the AWR report and verify in top wait event section

On Tue, Oct 3, 2017 at 10:59 AM, Ravi Teja Bellamkonda <
raviteja.bellamkonda7@xxxxxxxxx> wrote:

Hi,

Thanks for your time.

Some slowness was reported on the database calls, but that could be
because of the load on the database.

I am assuming that there might be a problem based on the observations.

Thanks.

On Oct 3, 2017 7:55 AM, "Hans Forbrich" <fuzzy.graybeard@xxxxxxxxx>
wrote:

Are you actually experiencing a problem? Or are you assuming there is a
problem because of your observations?

/Hans

On 2017-10-03 8:38 AM, Ravi Teja Bellamkonda wrote:

Hi List,

First of all, thank you for all the time and support.

Problem Statement is that under load we are observing a lot of Latch
Free wait events which are followed by Enqueue Hash Chains.
...

--
Thanks & Regards,
Ravi Teja Bellamkonda

--
Thanks,
Bhavani Prasad.

--
Thanks & Regards,
Ravi Teja Bellamkonda
Ph: (816)-905-7577 <(816)%20905-7577>.

--
Thanks & Regards,
Ravi Teja Bellamkonda
Ph: (816)-905-7577.

Follow-Ups:
- Re: Lot of Latch Free and Enqueue Hash Chain Wait Events
  - From: Hans Forbrich

References:
- RE: Lot of Latch Free and Enqueue Hash Chain Wait Events
  - From: Ravi Teja Bellamkonda
- Re: Lot of Latch Free and Enqueue Hash Chain Wait Events
  - From: Hans Forbrich
- Re: Lot of Latch Free and Enqueue Hash Chain Wait Events
  - From: Ravi Teja Bellamkonda
- Re: Lot of Latch Free and Enqueue Hash Chain Wait Events
  - From: Ravi Teja Bellamkonda
- Re: Lot of Latch Free and Enqueue Hash Chain Wait Events
  - From: Hans Forbrich

Re: Lot of Latch Free and Enqueue Hash Chain Wait Events

Other related posts: