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

Thread: Hard Parsing

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Hard Parsing

    Dear Sir I execute the following query

    SELECT NAME, VALUE
    FROM V$SYSSTAT
    WHERE NAME IN ('parse time cpu', 'parse time elapsed',
    'parse count (hard)', 'CPU used by this session' );
    NAME VALUE
    ---------------------------------------------------------------- ----------
    CPU used by this session 0
    parse time cpu 0
    parse time elapsed 0
    parse count (hard) 461305

    Please look at parse count (hard) which is at higher size
    My observations are Application is not using bind variables
    and i also check that cursor_sharing=EXACT so the statements with slight differences are not sharing exectution plans
    Should i change it to Force or Similar?
    Would it be beneficial to reduce hard parsing ultimately causing impact on performance?

    thanx in advance

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    oh dear me...you really impressed me by your questions Shakeel,
    you really are studying hard. just curious, can you tell me what
    book/reference are you reading now?
    Behind The Success And Failure Of A Man Is A Woman

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by yxez
    oh dear me...you really impressed me by your questions Shakeel,
    you really are studying hard. just curious, can you tell me what
    book/reference are you reading now?
    This is not the place to discourage anyone u have really disturb my feelings please try to answer if u can otherwise please not to discourage anybody

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by M.Shakeel Azeem
    This is not the place to discourage anyone u have really disturb my feelings please try to answer if u can otherwise please not to discourage anybody
    dude, read it again and dont jump to conclusions


    anyway to answer your question search asktom for 'bind variables' and you will have your answer, don;t start messing with cursor sharing as you dont know what it does

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Quote Originally Posted by M.Shakeel Azeem
    This is not the place to discourage anyone u have really disturb my feelings please try to answer if u can otherwise please not to discourage anybody
    Of course im not discouraging you dear
    Well, there is a thin line between encourage and discourage though.
    But i'm truly impressed by you learning deep or going into details like
    your questions above. I noted some of your previous questions
    and they look brilliant to me. That's a sign of u becoming a good DBA.
    You can be better than davey someday
    That's why i'm curious what book are u following. Maybe I can read
    it too.
    Last edited by yxez; 11-01-2006 at 11:41 PM.
    Behind The Success And Failure Of A Man Is A Woman

  6. #6
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    My observations are Application is not using bind variables
    Best bet is to change the app to use binds, if you can.
    Cursor_sharing=force is a poor substitute for fixing a bad app

    If you do end up using =force - study up, test it, time it and be prepared to revert back

    Don't get discouraged by replies that have nothing to do with your question, this is just a forum after all...
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you should check stats using delta values and not just read from v$sysstat like that, the values you arte showing us is from instance startup, quite useless if we dont know uptime

    also why you are getting 0 for other statistics?! what is your TIMED_STATISTICS value?

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