I had got a error message in PMON_xxxx.trc file,
please see below,
Dump file /data4/db/log/pmon_24007.trc
Oracle7 Server Release 18.104.22.168.0 - Production
With the distributed, replication, parallel query and Spatial Data options
PL/SQL Release 22.214.171.124.0 - Production
ORACLE_HOME = /opt/oracle/app/oracle/product/7.3.4
System name: HP-UX
Node name: aih
Instance name: TRITON
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 24007, image: ora_pmon_TRITON
*** SESSION ID:(1.1) 2000.11.07.10.13.35.516
PMON unable to acquire latch bb505188 library cache
possible holder pid = 1683 ospid=23555
why? and i found it after user complaint system slow down!!!
Those error will cause system slow down?
I faced this problem earlier. I found user has given very big process and it has eaten up all the resources.
You may want to increase the size of Library Casche. You should be OK.
Infact, restarting the DB should be OK. As long as the query is not running same query.
Try and let me know the result