|
Category :
Database
Resources -> Database Administration
DB Version
:
Oracle 8i /
Oracle 9i
OS Details :
Sun Solaris9
What
is an EVENT ?
An EVENT is a special item used by the Oracle server to do one of the
following: Change behavior, Enable collection of trace or debug
information or Enable additional error checking or similar.
Events can be set at the session
or the instance level but Please be advised to check with oracle
support before setting events at the session or at the instance level.
Example of setting and disabling events:
-- Set permanently for the
database within the init file
EVENT="10046 trace name
context forever, level 12"
-- At the instance level for the
duration of the instance
ALTER SYSTEM SET EVENTS '10046
trace name context forever, level 12';
-- At the session level for
the duration of the session
ALTER SESSION SET EVENTS
'10046 trace name context forever, level 12';
-- Disable permanently for the
database within the init file
EVENT="10046 trace name
context off"
-- Disabling the event at the
instance level for the duration of the instance
ALTER SYSTEM SET EVENTS '10046
trace name context off'
-- Disabling the event at the
session level
ALTER SESSION SET EVENTS
'10046 trace name context off'
You can get the listing of all
events that are available for a particular version of oracle by
looking at the oraus.msg file. On unix, this file can be
found under $ORACLE_HOME/rdbms/mesg directory. The events are all
listed under the heading "Pseudo-error debugging events" within the oraus.msg file.
|
