DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PMON error!!!!

Hybrid View

  1. #1
    Join Date
    Jul 2000
    Posts
    5

    Exclamation

    Dear all,

    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 7.3.4.1.0 - Production
    With the distributed, replication, parallel query and Spatial Data options
    PL/SQL Release 2.3.4.1.0 - Production
    ORACLE_HOME = /opt/oracle/app/oracle/product/7.3.4
    System name: HP-UX
    Node name: aih
    Release: B.11.00
    Version: U
    Machine: 9000/800
    Instance name: TRITON
    Redo thread mounted by this instance: 1
    Oracle process number: 2
    Unix process pid: 24007, image: ora_pmon_TRITON

    *** 2000.11.07.10.13.35.601
    *** 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
    *** 2000.11.07.10.13.35.601

    why? and i found it after user complaint system slow down!!!
    Those error will cause system slow down?


  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    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
    Thanks
    Kishore Kumar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width