Oracle Application (EBS 10.5.7, 11.0.3, 11.5.10, 12.0.4, 12.1.2), Financials (GL, AP, AR, CE, CM, FA), Financial Reporting, FSG, ADI, EBTax, MultiOrg, Advanced Global Intercompany System. Order Management, Inventory, CRM (Service Contracts), HRMS, Java / JSP based Web apps Development, Oracle Developer Suit, SQL, PL/SQL, Data migration to and from Oracle Applications using APIs, Data loads, software methodologies, AIMs (Application Implementation Methodology) for process, AIM 3.0, UML, Rapid Application Development, BPEL (Business Process Re-Engineering), Process Engineering (CMM, Oracle Tutor based processes, Oracle Reports Builder, Integration of Oracle Applications with third party software, Legacy Systems Management)
You need to be a member of Oracle Community to add comments!
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…