| Performance tuning of Oracle 8i [message #161757] |
Tue, 07 March 2006 01:04  |
Vamshee
Messages: 32
Registered: February 2005
|
Member |
|
|
Can anyone please provide me some links/notes on Performance Tuning of Oracle 8i/Win NT (that also provides solutions on improving the performance).
So far, i dealt with
Database Buffer Hit Ratio,
Redolog Buffer Ratio,
Buffer Cache Hit Ratio,
Library Cache Hit Ratio,
Data Dictionary Cache Hit Ratio.
I would like to know other issues that i can deal with, regaring Tuning of Oracle 8i (Win NT OS ).
Thanks in Advance.
Vamshee
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Performance tuning of Oracle 8i [message #161878 is a reply to message #161757] |
Tue, 07 March 2006 12:03  |
Vamshee
Messages: 32
Registered: February 2005
|
Member |
|
|
We dont have any potential issues at this moment, expect that a few Oracle applications are working very slow.
For which, i was checking for the queries that are taking along time along with these indexes.
I was curious to know if there are other things that i can look at apart from the hit ratios that i specified.
Thanks
Vamshee.
|
|
|
|
| Re: Performance tuning of Oracle 8i [message #161882 is a reply to message #161878] |
Tue, 07 March 2006 12:38 |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
Hi,
In a previous post, we said HIT RATIO'S are not a reliable measure for tuning. Sure they do indicate something. But, it is NOT a factor to be be considered for performance issues.
I would compare LIO's/explain plan output/statspack/trace output etc before and after doing something.
Look into the Performance tuning Guide.
Read the sticky.
http://www.orafaq.com/forum/t/51267/0/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
