| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to determine the values for database events that have bee n set?
Even I have tried to find a way to find the same on 9i, but was unable to. I
think the only way to find it is via the alert log file, since events set
via ALTER SYSTEM will get logged there.
If the events have been set via init.ora then you can see them in V$PARAMETER Maybe someone out here knows a better way.
Naveen
>-----Original Message-----
>From: Kaing, Leng [mailto:Leng.Kaing_at_team.telstra.com]
>Sent: Monday, March 01, 2004 11:51 AM
>To: oracle-l_at_freelists.org
>Subject: How to determine the values for database events that have been
>set?
>Importance: High
>
>
>Hello again, everyone,
>
>Can someone please tell me how to determine the values for
>events that have been set for the database?
>
>eg. if I had issued this statement on one of my databases, how
>would I confirm at a later date that it has been set?
>alter system set events '32333 trace name context forever, level 8';
>
>Can't find it in v$parameter or the likes. Interested in 8i,
>but would also be interested to see if it becomes available in
>later version too.
>
>TIA,
>
>Leng.
>
>
>
>----------------------------------------------------------
>Leng Kaing
>Email: leng.kaing_at_team.telstra.com
>Phone: +61-3-9203-7589
>Mobile: +61-417-371-348
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Mar 01 2004 - 00:40:19 CST
 |
 |