-
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
-
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!
-
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??
-
I am eager to geting those scripts you mentioned. Where can I get them?
Elin@trend
-
They are on this website on the left, called Oracle Scripts.
-
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
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|