| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 'Event Group Latch'
Tom Kyte (asktom.oracle.com) kindly posted me a reply to my question on the above latch. For anyone interested, the description is below
Cheers
Connor
Usage
This latch is used during the following operations :
An "alter system set events.." command.
During process startup where the process copies the
events stored in the
System event group to its Process event group.
Event Groups
Events are considered to exist in either the process,
session or system group.
The differences are outlined below :
System Group
The event tree is built in the SGA and is derived from
the settings of the
instance parameter "event". It can also be modified by
using the command "alter
system set events...".
Process Group
These are initialised at process startup time via the
instance parameter
"event". When the process starts up we copy the event
tree that we have stored
in the System Group. The event tree is built in the
PGA.
Session Group
These are events that are modified dynamically via the
"alter session" command.
When we perform event checking we check the session
group events before those of
the process group. The event tree is built in the UGA.
"Some days you're the pigeon, some days you're the statue"
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Mar 28 2001 - 03:10:15 CST
 |
 |