Database Time Spent Waiting (%): Wait Class Other - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

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

  1. #21
    Join Date
    May 2008
    Posts
    95

    Exclamation

    Dear Malay,

    Please tel me, hw to provide bind variable and where.

    Regards,

  2. #22
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    You can do a simple google search and find out what a bind variable is. I'm now confused what your role is and who is supposed to Tune this DB?
    http://www.perf-engg.com
    A performance engineering forum

  3. #23
    Join Date
    May 2008
    Posts
    95

    Exclamation

    Dear Malay,

    Sorry, I know abt Bind Variable but I confuse u had send that script, I thought it will show some output.

    any hw ur suggestion is have to increase db buffer cache size & i will checkit out which quiery taking more time then i will let you now.

    Thanks & Regards,
    DBA

  4. #24
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Fine. Yes that's the query you need to consider. Only concentrate on tuning that query and after tuning if does not help then you can incraese the buffer acache and verify. Why i'm not strongly recommending to increase buffer cache is the advisory report in statspack report says, it'll not help much.
    http://www.perf-engg.com
    A performance engineering forum

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