-
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
-
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
-
-
Some information about Database Events you can find in:
Oracle9i Application Developer's Guide - Fundamentals (A88876-02)
Chapter 16 (Working with System Events)
-
I think he is referring events in the database not the startup, logon kind of events etc etc
-
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;
/
-
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 :(
-
Try read event name and parameter's types :
select * from V$EVENT_NAME where event# = 4020;
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|