跟踪某个用户一段时间的所有操作

1。alter_sid.log  2。后台跟踪文件bdump 3。用户跟踪文件udump

 

一。首先查找sid 和serial
/SQL> @/u01/app/oracle/script/logon.sql

       SID    SERIAL# MACHINE              USERNAME
---------- ---------- -------------------- ------------------------------
       117        258 www.nick.net         SYS
       118        160 node63.sina.com      SYSTEM
       124        363 fly.founder.com      SYS
       128        267 static57.cluster.com SYS
       131        131 emrep.uplooking.com  SYS
       159        346 www.hello.com        SCOTT

6 rows selected.
二。通过对应的实例号，和序列号 找到其进程
SQL> exec dbms_system.set_sql_trace_in_session(159,346,true);

PL/SQL procedure successfully completed.


select spid,pid from v$process
 where addr=(
 select paddr from v$session where sid=159);

SPID                PID
------------ ----------
27953                38

 

三。将指定的用户后台跟踪文件转换为可读的txt文件
[oracle@emrep ~]$ tkprof  $ORACLE_BASE/admin/pod/udump/pod_ora_27953.trc aaa.txt

more aaa.txt
四。关闭会话
SQL> exec dbms_system.set_sql_trace_in_session(159,346,false); --->关闭跟踪会话

PL/SQL procedure successfully completed.