SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable SQL Monitor trace

Paramasivan Krishnamoorthy-OracleJan 18 2023 — edited Jan 18 2023

Hi,

Recently I have enabled sql monitor for one of the queries in the database using the below command.

ALTER SYSTEM SET EVENTS 'sql_monitor [5us18nyt8v935] force=true'

Can this be disabled? I searched in few posts but couldn't get any command on how to disable the trace.

This post has been answered by Mohamed Houri on Jan 18 2023

Jump to Answer

Added on Jan 18 2023

2 comments

1,103 views