Additional info. I found out that this latch is acquired when an 'alter
system/session' command is issued.
"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 - 16:32:21 CST
