Id1, Id2 Combination Meanings
mosid:34631.1
Oracle 12.1 Id1 Meaning ~~~ ~~~~~~ 0 to 112 *Same as 11.2.0.3 113 Oracle Label Security install 114 Oracle Label Security enforce 115 Oracle Database Vault config 117 Invalidate DB Props cache CIC 118 OBSOLETE 119 Propagate final ODPS 120 Post for cleanup of Audit 121 Assist offline from the DB side 122 Assist offline from the ASM side 123 Nuke ILM file stats 124 12.1 RM CIC in RMON Oracle 11.2.0.3 Id1 Meaning ~~~ ~~~~~~ 101 to 111 *Same as 11.2.0.2 112 ASM map lock message for AVD Oracle 11.2.0.2 Id1 Meaning ~~~ ~~~~~~ 73 to 78 *Same as 11.1 101 ASM disk error emulation 102 Audit Management operations 103 invalidate sql profile cursors 104 Misc RMAN CIC 105 standby role change 106 Voting file refresh CIC 107 LGWR miscellaneous 108 Invalidate ASM spfile xmap CIC 109 load new system statistics 110 sync datafile move state 111 KSB Rolling Migration Test1 Oracle 11.1 Id1 Meaning ~~~ ~~~~~~ 63 to 71 *Same as 10gR1 73 readable stby: metadata flush 74 slave dskm message 75 update sysaux state sga variable 76 notify storage server reg/dereg 77 ASM ACD relocation xtnt info 78 Misc LogMiner CIC Oracle 10gR1 Id1 Meaning ~~~ ~~~~~~ 27 to 29 *Same as 9i R2 30 process waiters after row cache requeue 31 Active Change Directory extent relocation 32 block change tracking state change 33 kgl mulitversion obsolete 34 set previous resetlogs data 35 set recovery destination pointer 36 fast object reuse request 37 test ksbcic() 38 ASM diskgroup discovery wait 39 ASM diskgroup release 40 ASM push DB updates 41 ASM add ACD chunk 42 ASM map resize message 43 ASM map lock message 44 ASM map unlock message (phase 1) 45 ASM map unlock message (phase 2) 46 ASM generate add disk redo marker 47 ASM check of PST validity 48 ASM offline disk CIC 49 Logical Standby Sync Point SCN 50 update SQL Tuning Base existence bitvector 51 PQ induced Checkpointing 52 ASM F1X0 relocation 53 Scheduler autostart 54 KZS increment grant/revoke counter 55 ASM disk operation message 56 ASM I/O error emulation 57 DB Supp log cursor invalidation 58 Cache global range invalidation 59 Cache global object invalidation 60 ASM Pre-Existing Extent Lock wait 61 Perform a ksk action through DBWR 62 ASM diskgroup refresh wait Oracle 10gR2 Id1 Meaning ~~~ ~~~~~~ 30 to 62 *Same as 10gR1 63 KCBO object checkpoint 64 KCBO object pq checkpoint 65 global health check event 66 Oracle Label Security refresh 67 thread internal enable 68 cross-instance registration 69 KGL purge unused subheaps 70 clear pin instance flag 71 Rolling operations CIC Oracle 9iR2 Id1 Meaning ~~~ ~~~~~~ 25 to 26 *Same as 9i R1 27 set Database Force Logging mode 28 invalidate cached file address translations 29 Cursor Unauthorize Mode 30 snapshot too old diagnosis 31 process waiters after row cache requeue Oracle 9iR1 Id1 Meaning ~~~ ~~~~~~~~ 18 to 24 *Same as Oracle 8i 25 Update Dscn Tracking (ktcndt) 26 Purge dictionary Object number Cache Oracle 8i Id1 Meaning ~~~ ~~~~~~~ 0 to 17 *Same as Oracle 8(please see "Oracle8*" for the Meaning) 18 Object reuse request 19 Rolling release checks 20 Propagate begin backup scn for a file 21 Refresh top plan (for db scheduler) 22 Clear checkpoint progress record 23 Drop temp file 24 Quiesce database Restricted Id2 Meaning ~~~ ~~~~~~~ 0x01 Used to pass in parameters 0x02 Used to invoke the function in backgroud process 0x03 Used to indicate the foreground has not returned 0x04 Mounted excl, use to allocate mechanism 0x05 Used to queue up interested clients Oracle 8* Id1 Meaning ~~~ ~~~~~~~ 0 Checkpoint block range 1 Reuse (checkpoint and invalidate) block range 2 LGWR Checkpointing and Hot Backup 3 DBWR syncronization of SGA with control file 4 Log file add/drop/rename notification 5 Write buffer for CR read 6 Test call 7 Invalidate KCK cache in all instances 8 Alter rollback segment optimal 9 Signal Query Servers/coordinator 10 Create Remote parallel query Server 11 Set Global Partitions 12 Stop Disk Writes 13 Drop Sort Segments 14 Release unused space from Sort Segments 15 Instance Recovery for Parallel operation Group 16 Validate parallel slave Lock Value 17 Check transaction state objects 18 Flush blocks in object 19 Rolling release checks 20 Propagate begin backup scn for a file 21 Clear checkpoint progress record Oracle 7 Id1 Meaning ~~~ ~~~~~~~ 0 Flush buffers for reuse as new class 1 LGWR checkpointing and Hot Backup 2 DBWR synchronization of SGA with control file 3 Log file add/drop/rename notification 4 Write buffer for CR read 5 Test Call 6 Invalidate KCK cache in all instances 7 Alter rollback segment optimal 8 Signal Query Servers/coordinator 9 Create Remote Parallel Query Server 10 Set Global Partitions 11 Stop Disk Writes 12 Drop Sort Segments 13 Release unused space from Sort Segments 14 Instance Recovery for Parallel operation Group 15 Validate parallel slave Lock Value 16 Check Transaction State Objects Id2 Meaning ~~~ ~~~~~~~ 1 Pass in Parameters 2 Invoke the call in background process 3 Foreground has not returned yet 4 Used to allocate the CI call 5 Used to queue up interested clients