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

Thread: Performance

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi all

    How can I measure database performance is good or bad?
    Users keep calling me and say "slow, slow..."
    I am new in Tuning, how can I get started? I ran bstat/estat already. Anything else I should do? I have performance tuning book here and I am following the book step by step but I found myself kind of lost in the jungle......
    any guildline by your experience?

    Thanks,
    Elin@trend

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    On the instance level set the

    alter system set cursor_sharing=FORCE;

    Then check your buffer_cache hit ratio, library_cache_hit ratios and tune those accordingly.


    There are some performance tuning scripts that are available in this forum site which you could make use of, for your tuning.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    THere can be many factors determining performance. It could be query taking a long time to execute, low buffer hit ratio, n/w problems, etc. What did your analysis of report.txt?? What are the users complaining about, exactly??

  4. #4
    Join Date
    Apr 2001
    Posts
    151
    I am eager to geting those scripts you mentioned. Where can I get them?
    Elin@trend

  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    They are on this website on the left, called Oracle Scripts.

  6. #6
    Join Date
    Apr 2001
    Posts
    151
    When I issued "alter system set cursor_sharing=force;

    ERROR at line 1:
    ORA-02065: illegal option for ALTER SYSTEM

    I looked up from metalink,

    Cause: The option specified for ALTER SYSTEM is not supported.
    Action: Refer to for the proper syntax of the ALTER SYSTEM command.

    Do anyone know the command?

    env. oracle 8.0.5.2.1 on NT4.0

    some errors occured when set cursor_sharing=force;
    http://metalink.oracle.com/metalink/...l2_gui.startup

    Any more suggestions?


    Elin@trend

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Yes it is not supported under 8.0.5. This feature had been set in as of 8i. Since you had not mentioned the database version, I had suggested the feature.

    Sorry

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this site which pando had pointed to us earlier. It has a number of useful links that you can make use of.

    http://harbinger.sirma.bg/Oracle/

    Curtesy to pando,

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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