To all who have joined the community I hope you have had occasions to post questions to others in the community. My purpose in creating this was to create a specific forum and meetinplace for those Oracle DBAs who have or wish to attain or improve their skills in OS, storage and networks. Whilst Harald van Bfreederode and myself continue to blog on our own blogs the Message of DBA 2.0 skills is still very important. Please help us all by sharing ideas and knowledge for members of this… Continue
I have started my own blog at http://dbatrain.wordpress.com/ to discuss DBA training, DBA certification and other issues of interest to Modern Oracle DBAs. I will also post my articles and presentations on the site.
I hope you find it useful.
Harald van Breederode, co-author of the DBA 2.0 booklet published last year has started a blog which will be of interest to Oracle DBAs, Unix Administrators and Storage Administrators. You will find his blog at http://prutser.wordpress.com/
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.
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…