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.
No comments:
Post a Comment