【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 laterInformation 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:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>>
>
>
>
>
>
>
>
>
>