Posted on 2009-04-27
Last Modified: 2013-12-18

I am looking to gain better practical knowledge of using ALTER SYSTEM SET EVENTS.  It has helped me in trapping and ORA-nnnn errors in the past.  For instance, I implemented it using a command given to me by MetaLink to provide more detail on some ORA-2291 errors I was receiving.  Great stuff!  I'd like to really understand what is possible and the different: modes, events and event levels.  Unfortunately it does not seem to be documented very well (or my search criteria was not adequate).

Provide detailed information on using ALTER SYSTEM SET EVENTS.


Question by:michael4606
    1 Comment
    LVL 73

    Accepted Solution

    Here's a site with explanations for many events

    Note, most, of these are not "officially" documented by Oracle
    and, while some like 10046 and 10053 are commonly sited both in Metalink and other sites they all come with the same caveat to not use them unless specified by Oracle support.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now