【Oracle Database】Event 10046

[oracle@king01 ~]$ sqlplus / as sysdba
SQL> @user_sessions_all.sql

+------------------------------------------------------------------------+
| Report   : User Sessions (All)                                         |
| Instance : king                                                        |
+------------------------------------------------------------------------+

Instance     SID Serial ID Status    Oracle User        O/S User           O/S PID  Machine    Session Program
-------- ------- --------- --------- ------------------ ------------------ -------- ---------- ------------------------------
king          43        43 INACTIVE  TPCC               oracle             2252     king02     JDBC Thin Client
              49        17 INACTIVE  TPCC               oracle             2250     king02     JDBC Thin Client
              50        41 INACTIVE  TPCC               oracle             2248     king02     JDBC Thin Client
              53      3161 INACTIVE  TPCC               oracle             2246     king02     JDBC Thin Client
              44        29 INACTIVE  TPCC               oracle             2244     king02     JDBC Thin Client
              41        35 INACTIVE  TPCC               oracle             2242     king02     JDBC Thin Client
              30        15 INACTIVE  TPCC               oracle             2240     king02     JDBC Thin Client
              29      1013 INACTIVE  TPCC               oracle             2232     king02     JDBC Thin Client
              48        29 INACTIVE  TPCC               oracle             2238     king02     JDBC Thin Client
              40        25 INACTIVE  TPCC               oracle             2236     king02     JDBC Thin Client
              46        79 INACTIVE  TPCC               oracle             2234     king02     JDBC Thin Client
              20         3 ACTIVE                       oracle             1924     king01     oracle@king01 (ARC0)
              21         1 ACTIVE                       oracle             1926     king01     oracle@king01 (ARC1)
              22         1 ACTIVE                       oracle             1928     king01     oracle@king01 (ARC2)
              23         1 ACTIVE                       oracle             1930     king01     oracle@king01 (ARC3)
              17         9 ACTIVE                       oracle             1956     king01     oracle@king01 (CJQ0)
              12         1 ACTIVE                       oracle             1902     king01     oracle@king01 (CKPT)
               7         1 ACTIVE                       oracle             1892     king01     oracle@king01 (DBRM)
              10         1 ACTIVE                       oracle             1898     king01     oracle@king01 (DBW0)
               8         1 ACTIVE                       oracle             1894     king01     oracle@king01 (DIA0)
               6         1 ACTIVE                       oracle             1890     king01     oracle@king01 (DIAG)
               5         1 ACTIVE                       oracle             1888     king01     oracle@king01 (GEN0)
              11         1 ACTIVE                       oracle             1900     king01     oracle@king01 (LGWR)
               9         1 ACTIVE                       oracle             1896     king01     oracle@king01 (MMAN)
              16         1 ACTIVE                       oracle             1910     king01     oracle@king01 (MMNL)
              15         1 ACTIVE                       oracle             1908     king01     oracle@king01 (MMON)
               2         1 ACTIVE                       oracle             1880     king01     oracle@king01 (PMON)
               3         1 ACTIVE                       oracle             1882     king01     oracle@king01 (PSP0)
              32         1 ACTIVE                       oracle             1936     king01     oracle@king01 (Q000)
              35         1 ACTIVE                       oracle             1940     king01     oracle@king01 (Q002)
              27         1 ACTIVE                       oracle             1932     king01     oracle@king01 (QMNC)
              14         1 ACTIVE                       oracle             1906     king01     oracle@king01 (RECO)
              18         5 ACTIVE                       oracle             1921     king01     oracle@king01 (RVWR)
              34        15 ACTIVE                       oracle             2060     king01     oracle@king01 (SMCO)
              13         1 ACTIVE                       oracle             1904     king01     oracle@king01 (SMON)
               4         1 ACTIVE                       oracle             1884     king01     oracle@king01 (VKTM)
              51       883 ACTIVE                       oracle             2192     king01     oracle@king01 (W000)
               1      2677 ACTIVE    SYS                oracle             2219     king01     sqlplus@king01 (TNS V1-V3)
               
SQL> show parameter user_dump_dest 

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
user_dump_dest                       string                            /u01/app/oracle/diag/rdbms/kin
                                                                       g/king/trace
SQL> exec dbms_monitor.session_trace_enable(49,3,waits=>true,binds=>true);
PL/SQL procedure successfully completed.

SQL> exec dbms_monitor.session_trace_disable(49,3);
PL/SQL procedure successfully completed.

[oracle@king01 ~]$ cd /u01/app/oracle/diag/rdbms/king/king/trace
[oracle@king01 trace]$ tkprof king_ora_1990.trc tpcc01.txt sys=no sort=prsela,exeela,fchela;

SQL>  exec dbms_system.set_ev(46,15,10046,8,'');
PL/SQL procedure successfully completed.

SQL> exec dbms_system.set_ev(46,15,10046,0,'');
PL/SQL procedure successfully completed.

[oracle@king01 ~]$ cd /u01/app/oracle/diag/rdbms/king/king/trace
[oracle@king01 trace]$ tkprof king_ora_1986.trc tpcc02.txt sys=no sort=prsela,exeela,fchela;

SQL> grant alter session to tpcc;
Grant succeeded.

SQL> conn tpcc/tpcc
Connected.

SQL> alter session set events '10046 trace name context forever,level 8';
Session altered.

SQL> alter session set events '10046 trace name context off';
Session altered.

[oracle@king01 ~]$ cd /u01/app/oracle/diag/rdbms/king/king/trace
[oracle@king01 trace]$ tkprof king_ora_2170.trc tpcc03.txt sys=no sort=prsela,exeela,fchela;