Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2007
    Posts
    9

    Question Unanswered: Parse to Execute Ratio > Oracle 9 tuning

    Hello to all the learned folks,

    In toad under Tuning > Server Stat I am getting a red mark on "high parse to execute ratio". Although it doesnt seem to retard the performance of the database too much but still i feel that if this red mark could be removed then may be it will perform even better.

    I tried increasing the session_cache but enterprise manager did not allow it.

    Any idea if some one had faced similar problems and resolved it.

    A screen shot is included

    Thanks a lot.
    Attached Thumbnails Attached Thumbnails serverstats.GIF  

Tags for this Thread

Posting Permissions

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