Tasks of Oracle background processes
                                                 Last update (2012-06-22 20:16:11)
                                                                                                                   Date added (2012-06-22 10:09:03)

Summary
You can find whats tasks every oracle background process (for example oracle 10.2.0.5) is handling with the query:
SQL> SELECT * FROM x$messages 
  2  --where description like '%KEWA%' 
  3  ORDER BY DEST;

ADDR                   INDX    INST_ID DESCRIPTION                                                      DEST
---------------- ---------- ---------- -------------------------------------------------------------
4000000001AD29F0          0          1 Monitor Cleanup                                                  *
4000000001AD2A10          1          1 KSB action for X-instance calls                                  *
4000000001AD2A30          2          1 generic shutdown background                                      *
4000000001AD32D0         71          1 database close in progress                                       *
4000000001AD31F0         64          1 Scumnt mount lock                                                *
4000000001AD3210         65          1 Poll system events broadcast channel                             *
4000000001AD2D70         28          1 svr actn for shrd grp reg/dereg                                  *
4000000001AD2A50          3          1 run all timeout and interrupt actions for this background
4000000001AD3EB0        166          1 ASM to slave BG msg                                              ARB*
4000000001AD2FD0         47          1 Archiver wakeup                                                  ARC*
4000000001AD2FF0         48          1 Archiver shutdown                                                ARCH
4000000001AD39B0        126          1 Job Queue Interupt                                               CJQ*
4000000001AD3990        125          1 Job Queue Timout                                                 CJQ*
4000000001AD3970        124          1 Shutdown Job Queue Process                                       CJQ*
4000000001AD45D0        223          1 Job Queue Interupt                                               CJQ*
4000000001AD45F0        224          1 Job Queue Interupt                                               CJQ*
4000000001AD4530        218          1 Check for async messages from other instances                    CJQ0
4000000001AD4570        220          1 Coordinator send broadcast timeout                               CJQ0
4000000001AD2F10         41          1 CKPT reuse call continuation                                     CKPT
4000000001AD2F30         42          1 CKPT reuse range call continuation                               CKPT
4000000001AD2F50         43          1 CKPT reuse call completion action                                CKPT
4000000001AD2F70         44          1 CKPT stat update timeout action                                  CKPT
4000000001AD2FB0         46          1 CKPT reuse range call continuation                               CKPT
4000000001AD3350         75          1 get (XR,4,0) enqueue                                             CKPT
4000000001AD33B0         78          1 update recovery-based i/o statistics                             CKPT
4000000001AD33D0         79          1 Db Checkpt Request check                                         CKPT
4000000001AD33F0         80          1 Db Checkpt Compl check                                           CKPT
4000000001AD3410         81          1 Get Proxy Lock                                                   CKPT
4000000001AD34B0         86          1 subscribe to quiesce channel                                     CKPT
4000000001AD34D0         87          1 unsubscribe to quiesce channel                                   CKPT
4000000001AD34F0         88          1 unquiesce the instance during database close                     CKPT
4000000001AD3510         89          1 check for quiesce messages                                       CKPT
4000000001AD3570         92          1 start change tracking in ckpt                                    CKPT
4000000001AD35B0         94          1 hold alert level                                                 CKPT
4000000001AD35D0         95          1 Flashback barrier                                                CKPT
4000000001AD35F0         96          1 subscribe/unsubscribe to flashback broadcast channel             CKPT
4000000001AD3950        123          1 KKX: drop ncomp dll action                                       CKPT
4000000001AD3A30        130          1 free PX memory chunks in background                              CKPT
4000000001AD3A50        131          1 SQL Memory Management Calculation                                CKPT
4000000001AD3A90        133          1 Compile Environment Monitor                                      CKPT
4000000001AD3E50        163          1 kfc CKPT mount disk group                                        CKPT
4000000001AD3E70        164          1 kfc CKPT dismount disk group                                     CKPT
4000000001AD3F10        169          1 ASM-DB communication interupt action                             CKPT
4000000001AD2ED0         39          1 CKPT subscribe object channel                                    CKPT
4000000001AD2EB0         38          1 release (XR,4,0) enqueue                                         CKPT
4000000001AD2E90         37          1 close control file                                               CKPT
4000000001AD2E70         36          1 identify control file                                            CKPT
4000000001AD2C70         20          1 check for service operations from other instances                CKPT
4000000001AD2B70         12          1 perform RM action in CKPT                                        CKPT
4000000001AD2B10          9          1 check for parameters from other instances                        CKPT
4000000001AD2B30         10          1 CPU dynamic reconfiguration                                      CKPT
4000000001AD3530         90          1 change tracking message                                          CTWR
4000000001AD3550         91          1 change tracking timeout action                                   CTWR
4000000001AD3390         77          1 get/release open thread enqueue                                  DBW*
4000000001AD3290         69          1 mount/dismount all db files                                      DBW*
4000000001AD2EF0         40          1 DBWR write buffers                                               DBW*
4000000001AD2DD0         31          1 SGA memory tuning parameter update - DBW0                        DBW0
4000000001AD3430         82          1 recovery db file verification                                    DBW0
4000000001AD3E10        161          1 kfcb force dismount disk group                                   DBW0
4000000001AD3DF0        160          1 kfc mount disk group                                             DBW0
4000000001AD3DD0        159          1 kfc dismount disk group                                          DBW0
4000000001AD3DB0        158          1 kfc invalidate file extent                                       DBW0
4000000001AD3D90        157          1 Reserve lock name space lock                                     DBW0
4000000001AD3D70        156          1 Release lock name space lock                                     DBW0
4000000001AD3690        101          1 complete Release space call                                      DBW0
4000000001AD3450         83          1 verify/invalidate all db files                                   DBW0
4000000001AD3E30        162          1 kfcb Poke DBW0                                                   DBW0
4000000001AD30D0         55          1 Message to flush IMU txns                                        DBW0
4000000001AD3190         61          1 Db Instance Lock Mgmt                                            DBW0
4000000001AD31B0         62          1 Db File check                                                    DBW0
4000000001AD31D0         63          1 Db mount lock                                                    DBW0
4000000001AD3230         66          1 offline db file                                                  DBW0
4000000001AD3250         67          1 identify db file                                                 DBW0
4000000001AD3270         68          1 lock db file                                                     DBW0
4000000001AD32B0         70          1 close and unlock db file                                         DBW0
4000000001AD2D10         25          1 poradebug commands                                               DIAG
4000000001AD2D30         26          1 Clusterwise dump request                                         DIAG
4000000001AD2D50         27          1 hanganalyze request                                              DIAG
4000000001AD3C50        147          1 Metadata file available                                          DMON
4000000001AD3C30        146          1 DMON rcv NS status                                               DMON
4000000001AD3C10        145          1 DMON Receive Message                                             DMON
4000000001AD3B30        138          1 DMON Interrupt Routine                                           DMON
4000000001AD3B50        139          1 DMON shutdown                                                    DMON
4000000001AD3B70        140          1 DMON Verify Standby shutdown for PM violation                    DMON
4000000001AD3B10        137          1 DMON Wakeup                                                      DMON
4000000001AD3D50        155          1 FSFP Shutdown Message                                            FSFP
4000000001AD3D30        154          1 FSFP Wakeup                                                      FSFP
4000000001AD3FD0        175          1 update PST                                                       GMON
4000000001AD3FF0        176          1 update PST status                                                GMON
4000000001AD4010        177          1 check PST                                                        GMON
4000000001AD4030        178          1 query PST                                                        GMON
4000000001AD4050        179          1 set partners_kfdsk                                               GMON
4000000001AD4070        180          1 PST dismount disk group                                          GMON
4000000001AD4150        187          1 emulate i/o errors on a disk                                     GMON
4000000001AD40B0        182          1 sense a heartbeat                                                GMON
4000000001AD40D0        183          1 timeout                                                          GMON
4000000001AD40F0        184          1 force asynchronous dismount of disk group                        GMON
4000000001AD4110        185          1 shutdown process                                                 GMON
4000000001AD4130        186          1 Run self test on group                                           GMON
4000000001AD4090        181          1 set heartbeat sensing                                            GMON
4000000001AD3CD0        151          1 INSV Receive Message                                             INSV
4000000001AD3D10        153          1 INSV Shutdown Message                                            INSV
4000000001AD3CF0        152          1 INSV Interrupt                                                   INSV
4000000001AD2A70          4          1 ksim LCK0 functions                                              LCK0
4000000001AD4290        197          1 kea signal recv function                                         LCK0
4000000001AD2AB0          6          1 ksim query instance group                                        LCK0
4000000001AD2AD0          7          1 ksim polling interrupt action                                    LCK0
4000000001AD2AF0          8          1 ksim get value                                                   LCK0
4000000001AD2B90         13          1 KSXP look for slow sends                                         LCK0
4000000001AD2BF0         16          1 Cross-instance broadcast message                                 LCK0
4000000001AD2C10         17          1 KSXR remote instance died                                        LCK0
4000000001AD2C30         18          1 KSXR finialize                                                   LCK0
4000000001AD2E50         35          1 Check SCN adjust                                                 LCK0
4000000001AD32F0         72          1 KCL glru timeout                                                 LCK0
4000000001AD3310         73          1 KCL affinity timeout                                             LCK0
4000000001AD3330         74          1 KCL affinity interrupt                                           LCK0
4000000001AD3470         84          1 get quiesce enqueue                                              LCK0
4000000001AD3490         85          1 release quiesce enqueue                                          LCK0
4000000001AD36B0        102          1 get TS enq for sort segment                                      LCK0
4000000001AD36D0        103          1 release TS enq for sort segment                                  LCK0
4000000001AD37F0        112          1 sequence bckgrnd instance lock                                   LCK0
4000000001AD3810        113          1 KQR get instance lock                                            LCK0
4000000001AD3830        114          1 KQR timeout action                                               LCK0
4000000001AD3850        115          1 KQLM pin instance lock operation                                 LCK0
4000000001AD3870        116          1 KQLM invalidation instance lock operation                        LCK0
4000000001AD3890        117          1 KQLM interrupt action                                            LCK0
4000000001AD38B0        118          1 SMON purge object number cache                                   LCK0
4000000001AD38D0        119          1 perform a user instance lock operation                           LCK0
4000000001AD39F0        128          1 get and hold global enqueue                                      LCK0
4000000001AD3A10        129          1 kxfp signal recv function                                        LCK0
4000000001AD2A90          5          1 ksim reg/dereg instance group                                    LCK0
4000000001AD3010         49          1 LGWR failure                                                     LGWR
4000000001AD3030         50          1 LGWR Set DCON bit                                                LGWR
4000000001AD3050         51          1 LGWR re-eval standby locks                                       LGWR
4000000001AD30F0         56          1 Redo writer IO's                                                 LGWR
4000000001AD3110         57          1 Redo writer post action                                          LGWR
4000000001AD3130         58          1 Redo writer log switch operations                                LGWR
4000000001AD3150         59          1 Redo writer generate offline immed marker                        LGWR
4000000001AD3170         60          1 Cache all logfiles                                               LGWR
4000000001AD3370         76          1 Open/close/mount/dismount thread                                 LGWR
4000000001AD3670        100          1 dml_locks = 0 global enforcement                                 LGWR
4000000001AD3710        105          1 get KTU instance lock                                            LGWR
4000000001AD3730        106          1 convert KTU instance lock                                        LGWR
4000000001AD3750        107          1 free KTU instance lock                                           LGWR
4000000001AD3AF0        136          1 LGWR to Start DMON                                               LGWR
4000000001AD3F30        170          1 kfr mount disk group                                             LGWR
4000000001AD3F50        171          1 kfr Dismount disk group                                          LGWR
4000000001AD3F70        172          1 kfr Poke LGWR                                                    LGWR
4000000001AD3F90        173          1 kfr Incr Ckpt                                                    LGWR
4000000001AD3FB0        174          1 kfr ACD relocation                                               LGWR
4000000001AD3070         52          1 Network Server wakeup                                            LNS*
4000000001AD30B0         54          1 Network Server shutdown                                          LNS*
4000000001AD3090         53          1 Network Server forced                                            LNS*
4000000001AD2D90         29          1 Memory Management                                                MMAN
4000000001AD2BB0         14          1 lock memory at startup                                           MMAN
4000000001AD2F90         45          1 Reset advisory pool when advisory turned ON                      MMAN
4000000001AD2E10         33          1 Handle sga_target resize                                         MMAN
4000000001AD2BD0         15          1 lock memory timeout action                                       MMAN
4000000001AD2DF0         32          1 Complete deferred initialization of components                   MMAN
4000000001AD4250        195          1 ASH Sampler (KEWA)                                               MMNL
4000000001AD37B0        110          1 tune undo retention                                              MMNL
4000000001AD37D0        111          1 MMNL Periodic MQL Selector                                       MMNL
4000000001AD43F0        208          1 MMNL DB close                                                    MMNL
4000000001AD4410        209          1 AWR Raw Metrics Capture                                          MMNL
4000000001AD39D0        127          1 Compute cache stats in background                                MMON
4000000001AD3A70        132          1 PGA Max Size (QESMM)                                             MMON
4000000001AD3AB0        134          1 MMON TSM Cleanup                                                 MMON
4000000001AD4190        189          1 alert message cleanup                                            MMON
4000000001AD41B0        190          1 alert message purge                                              MMON
4000000001AD41D0        191          1 AWR Auto Flush Task                                              MMON
4000000001AD41F0        192          1 AWR Auto Purge Task                                              MMON
4000000001AD4610        225          1 Job Autostart action force                                       MMON
4000000001AD4230        194          1 AWR Auto CPU USAGE Task                                          MMON
4000000001AD4270        196          1 ASH Emergency Flusher (KEWA)                                     MMON
4000000001AD42B0        198          1 Advisor delete expired tasks                                     MMON
4000000001AD42D0        199          1 MMON Remote action Listener                                      MMON
4000000001AD42F0        200          1 MMON Local action Listener                                       MMON
4000000001AD4310        201          1 MMON Completion Callback Dispatcher                              MMON
4000000001AD4330        202          1 MMON ping action                                                 MMON
4000000001AD4350        203          1 MMON testing slave                                               MMON
4000000001AD4370        204          1 run-once action driver                                           MMON
4000000001AD4390        205          1 shutdown MMON                                                    MMON
4000000001AD43B0        206          1 MMON DB open                                                     MMON
4000000001AD43D0        207          1 MMON DB close                                                    MMON
4000000001AD4430        210          1 metrics monitoring                                               MMON
4000000001AD4450        211          1 threshold reconciliation                                         MMON
4000000001AD4470        212          1 ADDM (KEH)                                                       MMON
4000000001AD4490        213          1 WCR: Record Action Switcher                                      MMON
4000000001AD44B0        214          1 WCR: Record State Check                                          MMON
4000000001AD44D0        215          1 WCR: Record SharedDir Check                                      MMON
4000000001AD44F0        216          1 WCR: Capture Stats Update                                        MMON
4000000001AD4510        217          1 WCR: Abort capture on IO error                                   MMON
4000000001AD4550        219          1 Check for sync messages from other instances                     MMON
4000000001AD4590        221          1 Check for autostart messages from other instances                MMON
4000000001AD45B0        222          1 Coordinator autostart timeout                                    MMON
4000000001AD38F0        120          1 OLS Cleanup                                                      MMON
4000000001AD3790        109          1 UNDO MMON ACTION                                                 MMON
4000000001AD3770        108          1 undo usage                                                       MMON
4000000001AD36F0        104          1 tablespace alert monitor                                         MMON
4000000001AD3610         97          1 Flashback Marker                                                 MMON
4000000001AD3590         93          1 recovery area alert action                                       MMON
4000000001AD2E30         34          1 SGA memory tuning                                                MMON
4000000001AD2DB0         30          1 SGA memory tuning parameter update                               MMON
4000000001AD2CB0         22          1 reconfiguration MMON action                                      MMON
4000000001AD2C90         21          1 reload failed KSPD callbacks                                     MMON
4000000001AD2C50         19          1 MMON request for RLB metrics                                     MMON
4000000001AD4210        193          1 AWR Auto DBFUS Task                                              MMON
4000000001AD3BB0        142          1 NetSlave Wakeup Message                                          NSV*
4000000001AD3BF0        144          1 NetSlave General Command                                         NSV*
4000000001AD3BD0        143          1 NetSlave Shutdown Message                                        NSV*
4000000001AD2CF0         24          1 scrub for timedout processes                                     PSP0
4000000001AD2CD0         23          1 fork new processes                                               PSP0
4000000001AD3AD0        135          1 Shutdown Q Monitor Coord                                         QMNC
4000000001AD3E90        165          1 ASM to master BG msg                                             RBAL
4000000001AD3EF0        168          1 ASM to BG mesg                                                   RBAL|GMON
4000000001AD3ED0        167          1 BG load lib msg                                                  RBAL|PSP0
4000000001AD3910        121          1 distributed recovery wakeup                                      RECO
4000000001AD3930        122          1 distributed recovery shutdown                                    RECO
4000000001AD3C90        149          1 RSM Receive Message                                              RSM*
4000000001AD3B90        141          1 RSM Wakeup                                                       RSM*
4000000001AD3C70        148          1 RSM Receive Message Response                                     RSM*
4000000001AD3CB0        150          1 RSM Set Parameter                                                RSM0
4000000001AD3650         99          1 RVWR IO's                                                        RVWR
4000000001AD3630         98          1 Open/close flashback thread                                      RVWR
4000000001AD4170        188          1 ASM instance recovery                                            SMON
4000000001AD2B50         11          1 Reliable Test Dummy Call                                         TEST

226 rows selected.
Reviews
Filters
Search