【MOS】关于events的几篇MOS(75713.1、160178.1、436036.1、1051056.6)

---

---

How To List All The Named Events Set For A Database (文档 ID 436036.1)

In this Document

Goal

Solution

References

---

APPLIES TO:

Oracle Database - Enterprise Edition - Version 8.0.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2016***

GOAL

Oracle Internal Events, both named event (eg: ERRORSTACK) as numeric events (eg 10046) can be set at the session level. This document outlines how DataBase Administrators can verify which events have been set in a specific session or in the entire system.

SOLUTION

This can be achieved through the ORADEBUG functionality. The exact syntax to use depends on the Oracle version you are using. 

If you want to retrieve the events set in a specific session, then use the following oradebug commands to identify the session:

     

   >      
              
             


       

   >    
   >    
     
   >    
   

> 
> 

 

 

>    

         
         
             

 

>    

       
       
          

            

>      

       
         
           

 

 

  

 

      

  

 

 

 

 

 

 

---

---

   

•   

          

 

   

 

  

 

  

  

      

 

---

---

>>

---

---

 

 

 

 

 

     
     

 

    
   

 

 

     

 

 

   

 

 

 

     

 

 

     

 

   

 

 

 

 
          

 

   

 

 
 

 

 

 

       

 

 
   

 
 
 
 

---

---

---