Oracle Wait by Wait class

Posted on 2011-05-02
Last Modified: 2012-06-21

I am working on Oracle 11g Release 2 and a Java Web Application.

After about a few days intervals, I am getting the following error in Oracle after which I am required to restart Oracle.

[Warning] Waits by Wait Class Database Time Spent Waiting (%) Metrics "Database Time Spent Waiting (%)" is at 48.38406 for event class "Concurrency"

I am absolutely clueless as to the origin of the error. How do I rectify / diagnose this? What else is required to diagnose this error?

Thanks in advance.
Question by:achitaley
    LVL 23

    Accepted Solution

    - check the wait statistics by querying to V$SESSION_WAIT. from there you need to identify the SQL that waiting the most in your session. most commonly wait classes among others is commit, idle and concurrency. i would suggest you to read further the following articles to understand the wait class and how to analyze the wait event then determine which client session that causes it and take necessary action to correct the problems :
    LVL 15

    Expert Comment

    by:Franck Pachot
    This is not an error ! Just a message about a potential performance issue.

    Author Closing Comment

    Thank you for the direction provided.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
    This video shows how to recover a database from a user managed backup

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now