Determine what system events are set
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Determine what system events are set

  1. #1
    Join Date
    Jan 2002
    Posts
    12
    Does anyone know of a query or what system table(s) or view(s) that will tell me what system events have been set for an instance ??

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    If you use dbms_system.read_ev:

    Code:
    set serveroutput on
    declare
    event       binary_integer:=0;
    statistics  binary_integer:=0;
    begin	
    for event in 10000..10999 loop
    sys.dbms_system.read_ev(event,statistics);
    if statistics=1 then
    dbms_output.put_line('Event :'||event||' Value :'||statistics);
    end if;
    end loop;
    end;
    /
    Is that of any help?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Julian.

    I use procedure like ur. Sometimes it works, sometimes not.
    I tried to reserch why it happendd, but i could not, without stabe results.
    This is possible problem with this script.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by Shestakov
    Julian.

    I use procedure like ur. Sometimes it works, sometimes not.
    I tried to reserch why it happendd, but i could not, without stabe results.
    This is possible problem with this script.
    I see. Some events might be out of the range 10000..10999, which is not very common. I suggest that events stay in the init.ora so you (the DBA) can determine what is set based on the init file. I personally would set an even only after the recommendation of Oracle support.


    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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