DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: Database Time Spent Waiting (%): Wait Class Other

  1. #1
    Join Date
    May 2008
    Posts
    95

    Exclamation Database Time Spent Waiting (%): Wait Class Other

    Dear Friends,

    Please help me out to find in my prod db EM below issues.

    Sep 25, 2008 9:07:59 AM Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other" -
    Sep 25, 2008 9:02:50 AM Metrics "Database Time Spent Waiting (%)" is at 22.76449 for event class "Other" -
    Sep 25, 2008 9:01:50 AM Metrics "Database Time Spent Waiting (%)" is at 33.72828 for event class "Other" -
    Sep 25, 2008 8:58:44 AM Metrics "Database Time Spent Waiting (%)" is at 20.37493 for event class "Other" -
    Sep 25, 2008 8:57:41 AM Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other" -
    Sep 25, 2008 8:46:17 AM Metrics "Database Time Spent Waiting (%)" is at 25.87486 for event class "Other" -
    Sep 25, 2008 8:45:17 AM Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other" -
    Sep 25, 2008 8:33:50 AM Metrics "Database Time Spent Waiting (%)" is at 21.14679 for event class "Other" -
    Sep 25, 2008 8:32:47 AM Metrics "Database Time Spent Waiting (%)" is at 100 for event class "Other" -
    Sep 25, 2008 8:17:14 AM Metrics "Database Time Spent Waiting (%)" is at 25.62567 for event class "Other"


    Kindly advice/suggestion.

    Thanks in advance.

    Best Regards,
    DBA

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    It looks to me your alerts are a mess, you can find the truth running this...
    Code:
    select  * 
    from    v$system_event 
    where   event like '%wait%'
    order by time_waited_micro DESC
    ;
    ... at least, the big picture.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    May 2008
    Posts
    95

    Exclamation

    please find attached file of output system events.

    Please give your valuable suggestion.

    Regards,
    DBA

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    where is the attached file?
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    May 2008
    Posts
    95

    Exclamation

    Please check now.

    Regards,
    DBA
    Attached Files Attached Files

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    If some of my guys comes to me with that report I would say... Can't read it, would you mind in formatting the output properly?

    ... at least do
    set linesize 180
    set pagesize 999
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    May 2008
    Posts
    95

    Exclamation

    find attached file in HTML format.

    waiting for your valuable suggestion.

    Regards,
    DBA

  8. #8
    Join Date
    May 2008
    Posts
    95

    Exclamation

    Please find Zip file for the same.

    Sorry for inconvenient.

    Best Regards,
    DBA
    Attached Files Attached Files

  9. #9
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    I do not see any issue from wait events. BTW what's your problem in D/B exactly you are facing?
    http://www.perf-engg.com
    A performance engineering forum

  10. #10
    Join Date
    May 2008
    Posts
    95

    Exclamation

    some time is going hung & I have to restart the db.

    some time its working fine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width