Latest Activity

Mohammaed Shaniaz Islam is now a member of Oracle Community
7 hours ago
Anar Godjaev posted a blog post
7 hours ago
Focusthread Ltd posted events
yesterday
Profile IconMahendra Keshavrao Dere and Rakesh C joined Oracle Community
Friday
Focusthread Ltd posted events
Friday
Chaitanya Rebbana is now a member of Oracle Community
Thursday
Focusthread Ltd posted events
Thursday
Veysi Gunay posted a status
Wednesday
Focusthread Ltd posted events
Tuesday
Satyanarayana Kotipatruni is attending Focusthread Ltd's event

Focusthread- Online Oracle BPM 11g Development Training Weekend Batch- 19 April 2014 at Focusthread- Online Oracle BPM 11g Development Training Weekend Batch- 19 April 2014

April 19, 2014 to April 27, 2014
This is a course tailor made for you keeping in mind the latest in the world of Oracle. Commencement Date: 19 April 2014 Training Schedule : 19, 20, 26 & 27 April 2014 Training Duration: 4 Days Timings: 12:00 Noon GMT | 8:00AM EST | 5:00AM PST | 7:00AM CST | 6:00AM MST | 5:30PM IST  | 01:00PM GMT+1 Course Fee: USD 399 Please click on the below link to view course contents & schedule details :…See More
Tuesday
Kirill Loifman posted a blog post

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…See More
Tuesday
Kirill Loifman posted a status
"My Twitter on databases, Oracle and IT trends http://lnkd.in/dpQN_W8"
Tuesday
Profile IconSatyanarayana Kotipatruni, Mohamed_B and Monte Friesen joined Oracle Community
Tuesday
Kirill Loifman posted a status
"Databases hang troubleshooting caused by massive Row Cache Lock contention using ASH, Systemstate dump & SQL | DaDBm: http://t.co/Lu7HJsMI20"
Apr 14
Focusthread Ltd posted events
Apr 14
Focusthread Ltd posted events
Apr 13
Profile IconKarnail Jeet Singh, Jignesh Makwana and Rakesh Reddy joined Oracle Community
Apr 12
Focusthread Ltd posted events
Apr 11
Veysi Gunay posted a status
"Data Recovery Advisor Oracle 11g ( My best Bro RMAN :)…"
Apr 10
Kirill Loifman posted a status
"Oracle Enterprise Manager (OEM) Cloud Control 12c Release 4 is planned to be released by end of June"
Apr 10
 
 
 

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Database hang and Row Cache Lock concurrency troubleshooting

This post will help to analyze Oracle database instance slowdown that can happen due to considerable row cache lock (enqueue) wait events. It’s is based on a real case of a database hang that I worked on recently. I must admit this type of situation does not appear often but it’s very dangerous since it can considerably slow down a database instance or even freeze it for a short period of time. In most cases SQL against ASH view and Systemstate dumps can help to nail down the problem unless…

Continue

Posted by Kirill Loifman on April 15, 2014 at 12:53am

Disclaimer

OracleCommunity.net is not affiliated with or supported by Oracle Corporation.

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service