重庆思庄Oracle、Redhat认证学习论坛

标题: oracle 跟踪当前用户会话 [打印本页]

作者: jiawang 时间: 2021-1-10 10:23
标题: oracle 跟踪当前用户会话
SQL> show parameter sql_trace
NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
sql_trace                         boolean    FALSE

指定跟踪文件名
SQL> alter session set tracefile_identifier='wangjia';
Session altered

开启跟踪
SQL> alter session set sql_trace=true;
Session altered

SQL> show parameter user_dump_dest
NAME                               TYPE       VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                      string    /u01/app/oracle/diag/rdbms/orcl/orcl/trace

[oracle@localhost trace]$ pwd
/u01/app/oracle/diag/rdbms/orcl/orcl/trace

[oracle@localhost trace]$ ll -rth
......
-rw-r----- 1 oracle oinstall  346 06-01 13:33 orcl_ora_27268_wangjia.trm
-rw-r----- 1 oracle oinstall 136K 06-01 13:33 orcl_ora_27268_wangjia.trc

关闭跟踪
SQL> alter session set sql_trace=false;

Session altered

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)