Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PMON unable to acquire latch

Re: PMON unable to acquire latch

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 30 Jan 2001 08:45:07 -0000
Message-ID: <980844114.10128.0.nnrp-12.9e984b29@news.demon.co.uk>

Following your direct email that the system was also hanging when this occurred (so
sometimes I guess wrong ;) I did a search in the metalink bug database for:

    modify parameter values latch

Bug 1386267 showed up in 8.0.4.4 and is still in 8.0.6.1. I didn't read it in detail, but there were comments about shared pool problems.

You might like to take this up with support.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



kiteman wrote in message ...

>Your right! Thanks!
>
>Any idea what all of this means?
>select * from v$latch
> where name like 'modify parameter values'
>
>
>
>
>
>
>ADDR LATCH# LEVEL#
>-------- ---------- ----------
>NAME GETS
>---------------------------------------------------------------- ----------
> MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES WAITERS_WOKEN
>---------- ---------- -------------- ---------------- -------------
>WAITS_HOLDING_LATCH SPIN_GETS SLEEP1 SLEEP2 SLEEP3 SLEEP4
>------------------- ---------- ---------- ---------- ---------- ----------
> SLEEP5 SLEEP6 SLEEP7 SLEEP8 SLEEP9 SLEEP10
SLEEP11
>---------- ---------- ---------- ---------- ---------- ---------- ---------
-
>80001FEC 7 0
>modify parameter values 26676
> 1 1 0 0 0
>
>ADDR LATCH# LEVEL#
>-------- ---------- ----------
>NAME GETS
>---------------------------------------------------------------- ----------
> MISSES SLEEPS IMMEDIATE_GETS IMMEDIATE_MISSES WAITERS_WOKEN
>---------- ---------- -------------- ---------------- -------------
>WAITS_HOLDING_LATCH SPIN_GETS SLEEP1 SLEEP2 SLEEP3 SLEEP4
>------------------- ---------- ---------- ---------- ---------- ----------
> SLEEP5 SLEEP6 SLEEP7 SLEEP8 SLEEP9 SLEEP10
SLEEP11
>---------- ---------- ---------- ---------- ---------- ---------- ---------
-
> 1 0 1 0 0 0
> 0 0 0 0 0 0
0
>
>
>
>
>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:980802025.4244.2.nnrp-14.9e984b29_at_news.demon.co.uk...
>>
>> I don't have 8.0.4 any more, but I think if you
>> select name from v$latch
>> you may find that there is a latch called
>> 'modify parameter values'.
>>
>>
>> I would guess that you don't have a real problem unless
>> >possible holder pid = 28 ospid=24678
>> is always the same.
>>
>>
>> --
>> Jonathan Lewis
>> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>>
>> Practical Oracle 8i: Building Efficient Databases
>>
>> Publishers: Addison-Wesley
>> More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>>
>>
>>
>> kiteman wrote in message ...
>> >I'm getting the error below every 5-6 hours. It mentions something
about
>> >modifying parameter values. Any idea paramters are being referred to?
Any
>> >help would be greatly appreciated.
>> >
>> >Dump file/opt/oracle/admin/win4prod/bdump/win4prod_pmon_26092.trc
>> >Oracle8 EnterpriseEdition Release 8.0.4.3.0 - Production
>> >With the Partitioning option
>> >PL/SQLRelease 8.0.4.3.0 - Production
>> >ORACLE_HOME =/opt/oracle/app/oracle/product/8.0.4
>> >System name: SunOS
>> >Node name:epfwpf03
>> >Release: 5.6
>> >Version: Generic_105181-16
>> >Machine:sun4u
>> >Instance name: win4prod
>> >Redo thread mounted by this instance: 1
>> >Oracleprocess number: 2
>> >Unix process pid: 26092, image: ora_pmon_win4prod
>> >Fri Jan 2613:48:01 2001
>> >*** SESSION ID:(1.1) 2001.01.26.13.48.01.000
>> >PMON unable to acquire latch 80001fec modify parameter values
>> >possible holder pid = 28ospid=24678
>> >Fri Jan 26 13:48:01 2001
>> >
>> >
>> >
>>
>>
>
>
Received on Tue Jan 30 2001 - 02:45:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US