Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Why PMON Method set to LOCK

  1. #1
    Oracle Administrator
    Join Date
    Oct 2011

    Why PMON Method set to LOCK

    When there is need to have CONC_PMON method set to LOCK?

    select profile_option_id , profile_option_value from FND_PROFILE_OPTION_VALUES
    where profile_option_id= (select profile_option_id from FND_PROFILE_OPTIONS
    where profile_option_name='CONC_PMON_METHOD');

    OR Why the CONC_PMON_METHOD should be LOCK?

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    New Delhi, India
    The PMON method is the method that the ICM uses to detect if the Concurrent manager is running or not.
    It can be set to three possible choices:

    OS = The Internal Concurrent Manager determines whether or not a process is still running by
    sending a kill -0 to the process. This is merely a test to see if the process is still here.

    RDBMS = The Internal Concurrent Manager queries against v$process to retrieve the session id
    (the one that started the request) and the operating system process id.
    The reason it needs to query against both columns and not just the OS process id (pid)
    is because if there are concurrent managers running on two different clients against the
    same RDBMS then two requests could have the same OS pid.

    LOCK = The internal concurrent manager tries to get a lock on the process it is monitoring.
    The name of the lock is determined by a sequence (which is the id of the individual managers)
    and the program in question. Once the manager is able to get the lock, then it knows the process
    is no longer running. Two installs in one RDBMS share the lock method because if the two managers
    get the same sequence id (one in each instance) then the second manager will never be able to start
    because the ICM will always think its already running.

    The recommended method is to use LOCK , ie try to obtain a lock on the CM process that needs to be monitored.

+ Reply to Thread

Similar Threads

  1. Lock and Unlock the User in Oracle 8i,9i, and 10g
    By Shahnawaz in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 06-19-2013, 08:05 PM
  2. Oracle Goldengate 11g Initial Load Using Direct Load Method.
    By ajaychandi in forum Oracle Golden Gate
    Replies: 0
    Last Post: 11-14-2012, 10:12 PM
  3. BEA-141281 unable to get file lock, will retry on starting admin/managed servers
    By Hemant in forum Oracle Fusion Middleware 11G - OIM , OAM , ODS , Weblogic , Webgate ..
    Replies: 0
    Last Post: 04-25-2012, 02:04 PM
  4. Script to check blocking lock in DB (9i and earlier)
    By RohitB in forum Database Scripts
    Replies: 0
    Last Post: 01-10-2012, 06:33 PM
  5. Script to find lock object
    By Amit in forum Database Scripts
    Replies: 0
    Last Post: 11-04-2011, 12:46 PM

Tags for this Thread

Posting Permissions

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

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training

Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics