Shulou(Shulou.com)05/31 Report--

Oracle all diagnostic event list events is how, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

Oracle list of all Diagnostic events events

You can get a list of all diagnostic events through the following script:

Under the UNIX system, the message file is located in the directory $ORACLE_HOME/rdbms/mesg/oraus.msg.

Under the NT system, the message file is located in the directory $ORACLE_HOME/rdbms/mesg/oraus.msg.

The oraus.msg file is a text file and can be opened and viewed directly.

Diagnostic events can be queried using the oerr command like normal ORA errors, as shown below:

Event= "10248 trace name context forever, level 10"

Event= "10249 trace name context forever, level 10"

Another way is to use the alter session set events command during the session, which only affects the current session. The format is as follows:

Alter session | system set events'[eventnumber | immediate] trace name eventname [forever] [, level levelnumber]:.

Through the: symbol, you can set multiple events sequentially, or you can set multiple events by using alter session set events in succession.

SQL > show parameter event---SQL > alter system set event='10046 trace name context forever,level 12' * ORA-02095: specified initialization parameter cannot be modifiedSystem altered.Database closed.ORACLE instance shut down.ORA-32004: obsolete and/or deprecated parameter (s) specifiedTotal System Global Area 1157627904 bytesVariable Size 402654536 bytesRedo Buffers 31457280 bytesDatabase opened.NAME TYPE VALUEevent string 10046 trace name context forevSQL > System altered.System altered.SQL > ALTER system SET event='1461 trace name errorstack level 3 strategies: ORARAIL 02095: specified initialization parameter cannot be modifiedSQL > ALTER system SET event='1461 trace name errorstack level 3 'scope=spfile Verify that you have successfully changed the method: File created. [oracle@rac01 ~] $grep event 1.ora, you need to restart DB. The following parameter Rollback changes System altered.File created. [oracle@rac01 ~] $grep event 2.ora2. Alter system set events: this method works for memory, but not for spfile >! [oracle@rac01 ~] $tail-N1 / oracle/admin/strm1/bdump/alert_strm1.log parameter change is not reflected in spfile File created. [oracle@rac01 ~] $grep event 3.ora is actually a BUG 6085625 metalink. For more information, please see NOTE: 461911.1.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.