|
If the users are happy, then the database performance is fine. If the users are not happy, then you have to find out what operation is performing unacceptably, and the performance goal for that operation. Then, arrange for a test of the operation and trace the database session (using dbms_support in Oracle9i or dbms_monitor in 10g). Format the resulting trace file with tkprof and inspect the output; it will show you where the session is spending its time. Usually you will find that changes to SQL and PL/SQL code, or sometimes the addition of indexes, will be required to improve performance.
Repeat this procedure for each application whose performance is unacceptable.
My point here is that it is not possible to assess database performance in and of itself -- you must consider the response time of applications that use the database.
|
