bhaskar.pati's Groups (6)

  • SQL*Plus

    96 members Latest Activity: Jan 16, 2013 SQL*Plus the command line. Scripts and tips.

  • 10G database administartion

    64 members Latest Activity: Jun 16, 2012 This group is dedicated to all those , who wants to share there knowledge and latest information to administrate Oracle 10G smoothly including…

  • Performance Tuning

    241 members Latest Activity: May 22, 2013 This group is dedicated to Oracle database performance tuning.

  • Oracle Job's

    214 members Latest Activity: Nov 17, 2013 Find your Oracle Jobs and share your interview Experiences here

  • dba

    36 members Latest Activity: Mar 14 A community that brings you to the top. Don't feel shy to ask anything relating database. We are not just community member.

  • SQL Developer

    79 members Latest Activity: Jun 23, 2012

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

Creating standby database fast and easy

1.PURPOSE AND SCOPE

With 11gR2 rman duplication its really easy to create standby database.

2.PRACTICE

Information

Primary Database SID: PRIM

Primary Database Domain/IP: ABSO

Standby Database SID: PRIM_SBY

Standby Database Domain/IP: CROO…

Continue

Posted by Bugra Canbakal on April 3, 2014 at 10:30pm

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service