DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Events

  1. #1
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi all,

    Does anybody know where could I find documentation about the event parameter in the init.ora ?

    Thanks in advance and best regards

    Angel

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    there are no official docos on this :(
    but with some intuition and $ORACLE_HOME/rdbms/mesg/oraus.msg you can more or less set events, the problem is with level settings, I cant find a single documents about what level is what


    You can find some on Metalink but few, mostly 10046, 10053, dumping redo logs, datafile headers but not many more


  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Thanks Pando

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Some information about Database Events you can find in:

    Oracle9i Application Developer's Guide - Fundamentals (A88876-02)
    Chapter 16 (Working with System Events)



  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I think he is referring events in the database not the startup, logon kind of events etc etc

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

    dbms_system PACKAGE (for read/set events)


    PROCEDURE READ_EV

    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    IEV BINARY_INTEGER IN
    OEV BINARY_INTEGER OUT

    PROCEDURE SET_EV

    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    SI BINARY_INTEGER IN - sid
    SE BINARY_INTEGER IN - serial id (for session)
    EV BINARY_INTEGER IN - event #
    LE BINARY_INTEGER IN - event level
    NM VARCHAR2 IN - comment (name of event)

    (like : execute sys.dbms_system.set_ev(&Sid, &Serial, &Event, &Level, '')


    PROCEDURE WAIT_FOR_EVENT

    Argument Name Type In/Out Default?
    ------------------------------ ----------------------- ------ --------
    EVENT VARCHAR2 IN
    EXTENDED_ID BINARY_INTEGER IN -- ??? i don't now wat is this
    TIMEOUT BINARY_INTEGER IN


    -- ---------------------------------------------------------------------------
    -- list of event's level
    -- ---------------------------------------------------------------------------
    set serveroutput on size 20000

    declare
    event_level number;
    begin
    for event_number in 1..10000 loop
    sys.dbms_system.read_ev(event_number, event_level);
    sys.dbms_output.put_line(
    'Event ' || to_char(event_number) || ' is set at level ' || to_char(event_level));
    end loop;
    end;
    /


  7. #7
    Join Date
    Oct 2000
    Posts
    139
    Hi Shestakov

    Do those procedures show me how to set events nd the meaning of the these? I have tried it but nothing is showed although I have events 4020 set in my init.ora :(

  8. #8
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Try read event name and parameter's types :

    select * from V$EVENT_NAME where event# = 4020;

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Shestakov I think you are missunderstanding the events we are talking about here, v$event_name shows the system events not the database events, these are such as

    Code:
    10046, 00000, "enable SQL statement timing"
    10053, 00000, "CBO Enable optimizer trace"
    10061, 00000, "disable SMON from cleaning temp segment"
    10064, 00000, "thread enable debug crash level %s, thread %s"
    // *Cause:
    // *Action: level 1 - after new current log header written
    //          level 2 - after current log  committed
    //          level 3 - after redo generation complete
    10065, 00000, "limit library cache dump information for state object dump"
    // *Cause:
    // *Action: level 1 - minimal (only the address of state objects)
    //          level 2 - little more (no object details)
    //          level 3 - normal
    10066, 00000, "simulate failure to verify file"
    // *Cause:
    // *Action: level is file number to fail verification
    10067, 00000, "force redo log checksum errors - block number"
    // *Cause:
    // *Action: level is block number to corrupt
    10068, 00000, "force redo log checksum errors - file number"
    // *Cause:
    // *Action: level is file number to corrupt
    10069, 00000, "Trusted Oracle test event"
    // *Cause:
    // *Action: Should never be enabled by customers.  Used to prevent diffs in
    //          regression testing by making Trusted behave like Oracle in
    //          specific events.
    //          level > 1  - handle 254 column tables without error
    //          level = 20 - implicitly include ROWLABEL in views
    etc etc

    There are thousands of these events


  10. #10
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by pando
    there are no official docos on this :(
    but with some intuition and $ORACLE_HOME/rdbms/mesg/oraus.msg you can more or less set events, the problem is with level settings, I cant find a single documents about what level is what


    You can find some on Metalink but few, mostly 10046, 10053, dumping redo logs, datafile headers but not many more

    Yes, I'm answering about startup events. Another question, today i'm trying to oepen the oraus.msg file. How can I read this file? It's not legible in notepad ... in windows, and in Unix I'm going to try in vi.

    Thanks in advance

    Angel

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