Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to use the event set up for the query system. Many people may not know much about it. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

-Test environment

Test content

1. View events at the session level

2. Query session-level events

Set event-Special event 10046

Alter session set events' 10510 trace name context forever,level 4'

Alter session set events' 10046 trace name context forever,level 12'

Alter system set events' 60025 trace name context forever'

Alter system set events' 10513 trace name context forever,level 2'

Session level query

Set serveroutput on size 1000000

Declare

Event_level number

Begin

For i in 1..100000 loop

Sys.dbms_system.read_ev (iPert eventual level)

If (event_level > 0) then

Dbms_output.put_line ('Event' | | to_char (I) | | 'set at level' | |

To_char (event_level))

End if

End loop

End

/

As you can see, you can get session and system-level events using dbms_system.read_ev (iquotient eventual level), but not 10046 events.

-oradebug implementation

Oradebug SETMYPID

Session level

Oradebug eventdump session

System level

Oradebug eventdump system

After reading the above, do you have any further understanding of how to use the event set up by the query system? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.