select name,value, ISSYS_MODIFIABLE from v$parameter where name like'%sga%'; 查看参数更改是否立即生效
select sid, SERIAL#,username from v$session; 查看会话
select sid, SERIAL#,username from v$session;
153 15 SCOTT
desc dbms_systems
execute dbms_system.SET_SQL_TRACE_IN_SESSION(153,15,true); 启动sq跟踪
select s.sid,s.serial#,s.username,p.spid 根据sid, SERIAL#查询spid
from v$session s,v$process p
where s.paddr=p.ADDR
/
根据显示的spid到C:/oracle/product/10.2.0/admin/orcl/udump中找文件orcl_ora_2020.trc
C:/Documents and Settings/Administrator>tkprof
C:/Documents and Settings/Administrator>tkprof C:/oracle/product/10.2.0/admin/orcl/udump/orcl_ora_2020.trc c:/t1.txt 利用tkprof反编译跟踪文件