Re: Benchmarking scripts for 9i/10g

Tarby777 wrote:
> Hi all,
>
> Are there any freebie scripts out there that can be used to generate
> benchmarks for an Oracle instance? Doesn't have to be too detailed,
> doesn't have to be perfect... just looking for something that does a
> fair chunk of work so that I can get an idea of the performance of our
> in-house testing rig relative to what our customers have...
>
> TIA
> Tarby

• Statspack (ships with Oracle)
• AWR (additional cost feature for 10g Enterprise, turned on by default even in the Standard Edition of 10g R2 - but can't be licensed for use with that version)
• 10046 trace at level 8 or 12 (see "Optimizing Oracle Performance" book by Cary Millsap)
• 10053 trace (see "Cost-Based Oracle Fundamental" by Jonathan Lewis)
• Directly query the performance views in Oracle

I have previously posted either in this group or the comp.databases.oracle.server group the performance view names. Basically, capture the starting values, capture the ending values, find the difference, and then look up what each statistic indicates.

Each method has strengths and weaknesses.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Nov 17 2006 - 10:15:34 CST