Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem Linux vs. Solaris
MH wrote:
>
> Hi,
>
> I have a problem with Oracle 8.1.7. I installed it on a 2 processors
> Intel linux machine. The database I use is not at all optimized, means
> I did not spread any datafiles across disks and I have only one tablespace.
>
> The application working on that database produces around 2500
> transactions per minute on that machine. When I install the same
> database on a sunfire V280, the transaction rate goes down to 400
> transactions per minute. The sunfire also has two processors, and a lot
> more real memory (4 Gigabytes). When I look at the cache hit ratios,
> there's no hint of contention, all ratios are above 90%. In addition,
> there apear no wait events in the system.
>
> I think that there is perhaps a problem with Solaris 2.7 and Oracle
> that I don't know. Does anybody know about a certain parameter to adjust
> in Oracle or Solaris, or can anybody give m an idea of what I can
> exmaine to solve the problem?
>
> Thank you for every hint
> Markus
Try
select * from v$system_event
select * from v$session_event
on each and take some deltas. This should assist informing you where the delays are occuring
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Mon May 27 2002 - 15:16:32 CDT