What events are set in the system
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: What events are set in the system

  1. #1
    Join Date
    Feb 2003
    Posts
    63

    What events are set in the system

    Is there a way to find out what events are set in the system?

    I have seen and tried this

    declare
    event_level number;
    begin
    for i in 100..10999 loop
    sys.dbms_system.read_ev(i,event_level);
    if (event_level > 0) then
    dbms_output.put_line('Event '||to_char(i)||' set at level '||
    to_char(event_level));
    end if;
    end loop;
    end;
    /

    But I know there is an event 472 set via alter system but it is not showing that?

    Thanks in advance

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Talking Show it?

    Did you try:

    SHOW PARAMETER EVENT?

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    that only works for system level events, not sessions level ones (or the other way round, can't remember)

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    The following should provide all the current system events set:

    Code:
    SQL> oradebug setmypid 
    SQL> oradebug dump events 4
    SQL> oradebug tracefile_name <file_name>
    If you want just session events you could use 1 above instead of 4.
    Last edited by ebrian; 01-14-2009 at 09:00 PM. Reason: Fixed formatting on file_name

  5. #5
    Join Date
    Feb 2003
    Posts
    63

    Thanks

    Thanks very much to all that replied

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width