From: Rodrick R. Brown (rrbrown@dcas.nyc.gov)
Date: Tue Apr 15 2003 - 14:11:18 EDT
The application is actually PeopleSoft we have a similar environment
running on a 6800 (4cpu 16gig memory) and everything seems to run
smooth, we later bought a new box now running on a sf15k (8cpu 24gig of
memory) and a job that use to run 8 hours now runs 13-14 hours while
doing some troubling shooting with my DBA's we notice a lot of memory
locking issues I'm not really sure how to tune memory bottle necks we
tried using different SGA size for oracle.. no difference I'm pretty
confident that its not an Oracle issue since we have many test systems
running on non SF15k boxes which is running circles around this machine.
I'm using QFS with qwrite/forcedirectio were pretty sure its not disk
I/O lock attepmts goes way up to about 800/900 locks per second it's the
only real sign of a bottle neck when monitoring this system while the
batch job runs.
I did notice a slight performance gain when bumping up seminfo_semmni to
4096 seems queries ran a lot faster but the over all job still took much
longer than expected.. What puzzles me is the 6800 was using an old
version of Solaris kernel 15 and less memory/cpu but yet the application
runs very solid.. if you can give me any tips or anything else I Can
look at I Would really appreciate it.
I'm pretty sure the locking lies in the Block buffers/db lock hash
latches.
-----Original Message-----
From: Fintan Ryan [mailto:fintan.ryan@sun.com]
Sent: Tuesday, April 15, 2003 1:25 PM
To: Rodrick R. Brown
Cc: fintan.ryan@sun.com; damien.farnham@sun.com
Subject: Re: Muxtex Contention (was Re: sunmanagers digest, Vol 1 #2093
- 13 msgs)
Hi Rodrick,
>
> Hello all anyone have any insight or performance tuning tips I can use
> to trouble shoot a mutex contention issue I'm having?? I'm getting
about
> 500 -> 700 lock attempts per second. I have tuned a lot of kernel
> parameters looked at paging vm stats but now that I have found my
bottle
> neck how can I resolve this issue??
>
> System: SF15k
> OS: Solaris 8 - Kernel 19
> CPU: 8x900mhz
> MEm: 24GIG
> Application: Oracle 8.1.7
> SGA size is about 1.2G
>
Would it be possible to get some more details on the configuration that
you have set up and on the application that is accessing the database?
Can't promise anything, but we can take a look and see if anything
stands out.
regards,
Fintan
-- Fintan Ryan fintanr@sun.com http://www.sun.com -- Unsubscribe mailto:sam-managers-request@list.ee.ethz.ch?subject=unsubscribe Help mailto:sam-managers-request@list.ee.ethz.ch?subject=help Archive http://www.ee.ethz.ch/~slist/sam-managers _______________________________________________ sunmanagers mailing list sunmanagers@sunmanagers.org http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:12 EDT