Performance

[elintrend]

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,

[sambavan]

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

[Halo]

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??

[elintrend]

I am eager to geting those scripts you mentioned. Where can I get them?

[Halo]

They are on this website on the left, called Oracle Scripts.

[elintrend]

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?

[sambavan]

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

[sambavan]

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