Re: Performance base line

Replying to my own question :-)

I have already tried to query some v$ views (don't remember which now), but I was discouraged by the fact that many applications
(written by external contractors) use PL/SQL with lots of variables
and statements transform into an unreadable code inside Oracle when they run.

I think that one would need more than just sqlplus and plain vanilla SQL statements to deal with the issue of a performance base line. Perhaps some tool out there... The question of performance of an Oracle DB in general is being addressed so intensive (including courses about "Performance Tuning" by Oracle itself) that I would assume that there is some standard way to assess the impact of tuning changes in a time-effective fashion.

I mean, if I change the optimizer mode from Cost to Rule, or if I change the parameter db_file_multiblock_read count from 8 to 64, or if I mount the file systems with the directio option (no OS buffering), there should be indicators of how successful the changes are (for most applications) without having to write benchmarks scripts (I can't afford spending time for that).

And considering that I have almost no clue about which queries are used/written by whom, and how often they run etc., I am forced to consider the overall effect instead of the impact to particular queries anyway.

But the more I assume that this question is a solved-in-ancient-times one, the less I believe that there is an easy way to do it. I would buy a tool if it is not too expensive (and if it REALLY WORKS).

Thanks again
Rick Denoire

(who is going to attend a one week course "Oracle 9i Performance
Tuning" next month). Received on Mon Sep 15 2003 - 08:09:31 CDT