<dominica_at_gmail.com> wrote in message
news:1114671664.006447.261040_at_g14g2000cwa.googlegroups.com...
> Hi All,
>
> Has anyone heard about this problem before?
>
> Apparently, my production database server
> has "mutex contention on database server", it is reported by "Virtual
> Adrian"(some kind of
> tools).
>
> This server is a SUN v440 , 4 CPU , running solaris 5.9.
>
> It has only one instance running oracle 8.1.7.4 and
> the database is around 140 Gig in size. It is a pretty fast OLTP.
>
> My question is how to solve this problem ?
> It is related to those /etc/system kernel parameter for Oracle, like
> semaphore.
>
> I am going to search in the oracle metalink FORUM now.
>
> Thanks,
>
>
> Dominica
>
Just guessing here - as soon as you go to 3rd party
tools the warnings and messages won't necessarily
mean much to an Oracle person - this looks like
the sort of generic warning you would get from the
operating system if Oracle were doing a lot of work
on latches. So I would check to see if you have
excessive misses, spin_gets, and sleeps in v$latch,
and try to decide whether they were having enough
of an effect on performance to be a problem.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005
Received on Thu Apr 28 2005 - 03:34:00 CDT
