Home » RDBMS Server » Performance Tuning » how to measure the Performance improvement
how to measure the Performance improvement [message #221484] Tue, 27 February 2007 02:41 Go to next message
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
Member
Hello,

i did an export from Oracle8.1.7 to 10GR2. The 10GR2 is on a new Server, so the 8.1.7 is still running.

I would like to measure the improvement.

I thought about just to make something like this:

NEW SERVER:

SQL> set timing on
SQL> select count(*) from trans;

 COUNT(*)
---------
  1034319

Executed in 0.437 seconds

------------------------------------------------------
OLD SERVER:

SQL> set timing on
SQL> select count(*) from trans;

 COUNT(*)
---------
  1035552

Executed in 1.766 seconds



So one possibly conclusion could be that the new DB is 4x faster than the old one.

But i'm guessing there must be some more sophisticated testing procedure?!

Does someone has any idea how i could prove and test the performance of the new DB?

thanks very much.
Re: how to measure the Performance improvement [message #221517 is a reply to message #221484] Tue, 27 February 2007 04:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
the sql you used is very simple.
It may work better in 8i if you reset the HWM and recollect the statistics.

You must be having other sql/procedure/apps/batch jobs that work on 8i?
to start with, Just compare it against 10g (after collecting stats).
Re: how to measure the Performance improvement [message #221526 is a reply to message #221484] Tue, 27 February 2007 05:38 Go to previous messageGo to next message
habibsh
Messages: 1
Registered: February 2007
Location: Pakistan
Junior Member

configure statspack on both DBS then compare the two reports in peak hours then you can easily judge the performance i think its the most accurate way
Re: how to measure the Performance improvement [message #221549 is a reply to message #221484] Tue, 27 February 2007 07:21 Go to previous messageGo to next message
buck444
Messages: 80
Registered: January 2006
Location: Luxembourg
Member
thank you both for pointing me in the correct direction.
As i haven't done anything within these parts of Oracle i'm gonna check the docu for some help how to get started with "statspack".
Re: how to measure the Performance improvement [message #221552 is a reply to message #221549] Tue, 27 February 2007 07:34 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
It will help you.
http://www.akadia.com/services/ora_statspack_survival_guide.html

also check SPDOC.TXT on your system.

regards
Taj
Previous Topic: Slow Performance of query
Next Topic: Reduce the number of Datafiles
Goto Forum:
  


Current Time: Mon Dec 02 07:23:25 CST 2024