Orace timeouts
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Orace timeouts

  1. #1
    Join Date
    Nov 2006
    Posts
    3

    Orace timeouts

    Oracle instance is upgraded to 9.2.0.8 from 9.2.0.7.. getting time out exception when the traffice is even medium.

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Please post the exact error message you are getting.
    Assistance is Futile...

  3. #3
    Join Date
    Nov 2006
    Posts
    3
    When the user logs into our application, we call some stored procedures to get some data from the database, during that time the user request is not getting fullfilled and time outs.

    Instance A in MMK was upgraded to 9.2.0.8, the one in B instance is still ver. 9.2.0.7.

    Instance A without traffic shows minimum time per Oracle statement ~250 ms, spiking up to 2500 ms time to time (average at around 300 - 400 ms). If we bring traffic in, the time starts increasing constantly and when it reaches 10 - 14 seconds we start seeing timeouts. (That's not a surprise: new transactions have to wait for the executing ones).

    B instance shows timing of 55 - 290 ms with or without traffic closer to the lower end - averaging at ~ 100 ms.

    But no errors thrown by the database.

    Thanks

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    trace the query, see what is going on - make sure your stats are up to date

  5. #5
    Join Date
    Nov 2006
    Posts
    3
    Do you mean to say that query which is running properly in Instance B (Oracle 9.2.0.7) will create problem in 9.2.0.8.

    We tested the querys, only one statement took more cpu cycles, it's been fine tuned to take lesse cpu, but we are facing the same issue.

    Will it be any driver incompaitable issues?.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    how about tracing the session and see where the time is being taken?

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by jayavardhanan
    Instance A in MMK was upgraded to 9.2.0.8, the one in B instance is still ver. 9.2.0.7.
    Not 100% sure what you are saying here... Do you have different versions of Oracle for each instance in a RAC cluster?
    Assistance is Futile...

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