-
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 ??
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|