Oracle Server - Solaris 9 and Orcale Performance Question

Author

Solaris 9 and Orcale Performance Question

Johne_uk

2005-05-24, 7:23 am

Hi,

I have 2 Sparc e250 boxes running Oracle 8.1.7.4. Both Oracle
installations are identical and each box has 1GB RAM and an identical
setup.

One box is running Solaris 7 and the other Solaris 9. When running
identical queries on box boxes I've noticed that the Solaris 9 box is
taking 50% longer that the Solaris 7 box.

Before I start looking at lots of unix performance stats (I'm not that
experienced at these things), would the lack of RAM and reduced
overheads of Solaris 9 over 7 account for the slower performance?

regards
John

chao_ping

2005-05-24, 9:23 am

First, you should check the num_rows,table size, execution plan is
identical in both servers, to confirm it is solaris problem, not oracle
problem.
SQL*Plus autotrace will be great for this.

Second, in both case, you should be able to re-produce the problem. For
example, run the same query multiple times in both server.

I don't know how much more memory solaris 9 use than solaris 7, but if
oracle sga is not pagedout, then performance should not be different.

Johne_uk

2005-05-25, 11:23 am

Hi,

Yes I checked Oracle execution and it was identical over a number of
cycles. Using iostat and vmstat I noticed that one of the disks on
Solaris 9 runs at almost 100% utilisation when the query is executing,
whilst the Solaris 7 box barely registers. Also, the Sol 9 box is
paging memory more heavily. I believe the disk setup on each server is
different - the Solaris 9 box has the OS / Oracle apps files on a pair
of mirrored disks and the Oracle datafiles are on RAID 5 (4 x 9GB
disks).

Solaris 9 is reserving 200MB RAM for the OS whereas Sol 7 is only
grabbing 100MB.

Thanks for the reply
John

Sponsored Links