Re: PMON unable to acquire latch

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 Mon Jan 29 2001 - 16:42:34 CST