• 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. ORA-38760: This database instance failed to turn on flashback database
  2. How to recreate Control file in Oracle Database
  3. How long does Oracle retain the statistics for
  4. Beginners Guide to Monitoring Oracle Database Restore/Recovery Progress
  5. Oracle GoldenGate: Replicat Sample Parameter File
  6. Oracle Database Storage Architecture – Overview
  7. New Oracle Net features in version 12c
  8. How to convert Linux dd .img to .VDI, VMDK, VHD with VIrtualBox Command
  9. Difference between using srvctl vs using sqlplus for start/stop one or more Oracle Database Instances
  10. How to Trace Dynamic Registration from PMON or LREG (Oracle 12c)

You May Also Like

Primary Sidebar

Recent Posts

  • aws ec2: CLI for AWS EC2 (Command Examples)
  • aws cur – Create, query, and delete AWS usage report definitions (Command Examples)
  • aws configure – Manage configuration for the AWS CLI (Command Examples)
  • aws cognito-idp: Manage Amazon Cognito user pool and its users and groups using the CLI

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright