OraFAQ Forum: Performance Tuning » how to measure the Performance improvement

Home » RDBMS Server » Performance Tuning » how to measure the Performance improvement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to measure the Performance improvement [message #221484]

Tue, 27 February 2007 02:41

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.

Report message to a moderator

Re: how to measure the Performance improvement [message #221517 is a reply to message #221484]

Tue, 27 February 2007 04:44

Mahesh Rajendran
Messages: 10707
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).

Report message to a moderator

Re: how to measure the Performance improvement [message #221526 is a reply to message #221484]

Tue, 27 February 2007 05:38

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

Report message to a moderator

Re: how to measure the Performance improvement [message #221549 is a reply to message #221484]

Tue, 27 February 2007 07:21

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".

Report message to a moderator

Re: how to measure the Performance improvement [message #221552 is a reply to message #221549]

Tue, 27 February 2007 07:34

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

Report message to a moderator

Previous Topic:	Slow Performance of query
Next Topic:	Reduce the number of Datafiles

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 15:01:49 CDT 2024