The most meaningful test(s) would be to identify the important business
functions that the application performs and base your metrics on that.
If your application processes orders, you might ask:
- How quickly (response time) can you create a new order?
- How many new orders can you create in a given time period
(throughput)?
- How long does it take to pull up a particular order

If you want to capture additional information-- Statspack reports,
snapshots of operating system metrics, etc.-- those would be good
supporting information. If you have benchmarks of the things users
consider important, thought, you are in a much better position to
understand reports of performance difficulty and in a much better
position to set user expectations appropriately.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Niki Tragen
[mailto:oracledba-ezmlmshield-x55325389.[Email address protected]
Sent: Friday, October 29, 2004 9:25 AM
To: LazyDBA Discussion
Subject: Performance of new installation

Hi

At the start of putting in a new system. Have been asked to test the
performance of the
new database following base installation.....database plus schemas
relating to application
software.

Any ideas on how to guage performance on a new system and if I'm wanting
to benchmark
from now what and where I should be looking.

cheers
Niki
New dba


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page