1 Reply Latest reply on Jul 31, 2019 4:22 AM by Kanda-Oracle

    Manager Identifiers Oracle

    happy10319

      Hi,

      In Setup guide p 4-164:

      Manager Identifiers Oracle:

      This field displays the ORACLE process ID associated with the manager process. This

      field cannot be updated.

       

      My question:

      Is there any corresponding row in v$session or other oracle table for Manager Identifiers Oracle?

       

      Thanks.

        • 1. Re: Manager Identifiers Oracle
          Kanda-Oracle

          Hi

           

          You may try this.

          1. To locate the Standard Manager process (FNDLIBR) from the back-end.
            1. Sysadmin > Concurrent > Manager > Administer Screen > Process > note down the column 'System'
            2. Go to the OS prompt of Concurrent Manager tier
              1. ps -ef | grep <pid from step a.>
          2. To know the corresponding session details (at DB tier)

                    SQL> SELECT sid, process,machine, program, MODULE FROM v$session s

                              WHERE s.process IN ('&client_pid fndlibr');

           

          Thanks!