Disable and Enable trace event on a particular Database - Oralce

Disable trace event on dbname database.

SQL> select * from v$instance;

SQL> show parameter event

NAME                                 TYPE

------------------------------------ --------------------------------

VALUE

------------------------------

event                                string

xml_db_events                        string

enable

SQL> set serveroutput on

DECLARE

lev BINARY_INTEGER;

BEGIN

dbms_system.read_ev(10795, lev);

dbms_output.put_line(lev);

END;

/

SQL>   2    3    4    5    6    7  0

PL/SQL procedure successfully completed.

SQL>

Enable Trace Event:

SQL> select * from v$instance;

SQL> alter system set event="10795 trace name context forever, level 2" scope=spfile;

System altered.

SQL> shut immediate

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1.3366E+11 bytes
Fixed Size 2198192 bytes
Variable Size 1.9327E+10 bytes
Database Buffers 1.1382E+11 bytes
Redo Buffers 512286720 bytes
Database mounted.
Database opened.

show parameter event

SQL> SQL>

NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
event string
10795 trace name context forev
er, level 2
xml_db_events string
enable