Admin/11i

Concurrent manager 상태 확인

Qhtlr 2007. 8. 17. 09:12

Application 으로 접속해서 확인해 볼수도 있으나 SQL로 확인해 볼 수 있다.

logon as apps 유저

@$FND_TOP/sql/afcmstat.sql

          ------------------------------------------------------------
           Managers with their defined capacities for the current shift
           ------------------------------------------------------------

Appl ID  Q ID Manager                     Node       Running  Max  Buf D
------- ----- --------------------------- ---------- ------- ---- ---- -
      0     4 Conflict Resolution Manager                  1    1      N
      0     1 Internal Manager                             1    1      N
      0     5 Scheduler/Prereleaser Manager                1    1      N
      0   223 Transaction Manager ( Inter                  0    0
              nal use only )
      0     0 Standard Manager                            20   20   40 N

      ----------------------------------------------------------------
       Managers with their corresponding Oracle and System Process Id's
       ----------------------------------------------------------------

         Oracle System
    Cpid Pid    Pid        Manager            Node      Started at
-------- ------ ---------- ------------------ --------- -------------------
   31752     63 100078     INV Remote Procedu xxxxxxxxx 08-12-07 04:27:59AM
                           re Manager
   31721     38 101058     Standard Manager   xxxxxxxxx 08-12-07 04:27:58AM
   31729     46 103738     Standard Manager   xxxxxxxxx 08-12-07 04:27:58AM
   31723     40 104282     Standard Manager   xxxxxxxxx 08-12-07 04:27:58AM
   31727     44 105280     Standard Manager   xxxxxxxxx 08-12-07 04:27:58AM
   31731     48 105548     Standard Manager   xxxxxxxxx 08-12-07 04:27:58AM