Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Measuring performance gains
anupcomp_at_giasbm01.vsnl.net.in wrote:
>
> Hi!!
>
> We have been asked to tune an Oracle Database on Unix.
>
> We are also required to generate statistics before and after the tuning to
> show the difference in the overall performance of the system due to
> tuning.
>
> What statistics would you suggest to measure the overall system
> performance? The response time for users is a crucial factor. How do we
> measure it? Is someone doing something like this?
>
> We have thought of running some batch jobs, doing a TKPROF on them, and
> comparing the results. Is this a correct way? If yes, which statistics
> from TKPROF are most relevant?
>
> Any ideas??
>
> Anup.
>
> ----------------------------------------------------------------------
> Anup Jalan
>
> Anup Computers Tel : 91-22-364 7992
> 33, Shankar Sagar Fax : 91-22-363 6176
> Sophia College Road
> Bombay 400 026 email : anupcomp_at_giasbm01.vsnl.net.in
> INDIA
> ----------------------------------------------------------------------
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
SQL scripts utlbstat.sql and utlestat.sql are provided in the
$ORACLE_HOME/rdbms/admin directory for the purpose of capturing an
instance's performance over a period of time. I suggest you review them
and Oracle's Performance Tuning Guide for Unix for considerably more
info.
-- Rich Woods Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.Received on Sun Jan 12 1997 - 00:00:00 CST