• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to Set Multiple Events in INIT.ORA file

by admin

Question: If you have to set more than one event in the init.ora, how can you specify multiple events on the same line?

The syntax to specify multiple events in the init.ora is:

event="[event 1]:[event 2]: [event 3]: [event n]"

you can also split the events on multiple lines by using the continuation “\” backslash character at the end of each event and continue the next event on the next line. Such As:

event="[event 1]:\
[event 2]:\
[event 3]: \
[event n]"

For Example:

event="\
10210 trace name context forever, level 10:\
10211 trace name context forever, level 10:\
10231 trace name context forever, level 10:\
10232 trace name context forever, level 10"

After setting the events, bounce the instance and be sure to check the alert.log and verify if the events are in effect. The alert.log should show the events that are in effect, for example:

System parameters with non-default values:
...
event = "10210 trace name context forever, level 10:10211 trace name 
context forever, level 10:10231 trace name context forever, level 
10:10232 trace name context forever, level 10"
...

It is also possible to set multiple events in multiple subsequent lines in the init.ora, e.g.

event="10210 trace name context forever, level 10"
event="10211 trace name context forever, level 10"
event="10231 trace name context forever, level 10"

Note that using the separate lines it is essential to set the events on subsequent lines. Otherwise, only the last event will be used due to the generic parsing of the init.ora values.

NOTE:

For current Oracle versions. e.g. 11g, you can also use the next commands to list the set event in a trace file:

SQL> alter session set events 'immediate eventdump(session)';
SQL> alter system set events 'immediate eventdump(system)';
Please note that from 11g the alter system set events also affects all current sessions, and not only the new ones.

Filed Under: oracle

Some more articles you might also be interested in …

  1. How to Use DBMS_METADATA To Get The DDL For Objects
  2. Basics of client connectivity in Oracle Data Guard configuration
  3. How to install and configure Oracle ASMLIB on Native Linux multipath mapper devices
  4. How to convert Linux dd .img to .VDI, VMDK, VHD with VIrtualBox Command
  5. Oracle 19c New Feature – Real-Time Statistics
  6. RMAN backup Concepts for Oracle RAC
  7. How To Shrink A Temporary Tablespace in Oracle Database
  8. Log file locations for Enterprise Manager Cloud Control 13c (OMS)
  9. How to Install and configure OSWatcher Black Box (OSWbb)
  10. Substitution variable in PL/SQL

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright