| From: | Steve Adams |
| Date: | 18-Dec-2000 12:18 |
| Subject: | PMON unable to acquire latch |
|
|
The trace file shows that PMON has twice given up on an attempt to acquire the modify parameter values latch. It was being held firstly by process 111 and later by process 19. User processes need this latch to read the parameter values in the SGA on process startup. The fact that it being held for a long time suggests that you have a performance problem that is causing process startup to take a long time. The problem could be an Oracle issue such as library cache latch contention, or a Solaris issue such as virtual memory thrashing, or it could just be that there were too many simultaneous connection attempts.
|
![]() |
Can you tell me what this message means?
Dump file /oracle/app/oracle/admin/WEB01/bdump/web01_pmon_16405.trc Oracle8 Enterprise Edition Release 8.0.6.1.0 - Production With the Partitioning, Objects and Parallel Server options PL/SQL Release 8.0.6.1.0 - Production ORACLE_HOME = /oracle/app/oracle/product/806 System name: SunOS Node name: db1 Release: 5.6 Version: Generic_105181-23 Machine: sun4u Instance name: WEB01 Redo thread mounted by this instance: 1 Oracle process number: 2 Unix process pid: 16405, image: ora_pmon_WEB01 *** 2000-12-17 05:34:52.109 *** SESSION ID:(1.1) 2000-12-17 05:34:52.090 PMON unable to acquire latch 80002c4c modify parameter values possible holder pid = 111 ospid=15220 *** 2000-12-17 05:34:52.109 *** 2000-12-17 05:55:19.770 PMON unable to acquire latch 80002c4c modify parameter values possible holder pid = 19 ospid=15915 *** 2000-12-17 05:55:19.770 *** 2000-12-17 06:22:16.374
|