hr@ORCL> alter session set timed_statistics=true;
Session altered.
hr@ORCL> alter session set events '10046 trace name context forever,level 12';
Session altered.
hr@ORCL> SELECT COUNT(*) FROM t_big;
SELECT COUNT(*) FROM t_big
*
ERROR at line 1:
ORA-00942: table or view does not exist
hr@ORCL> SELECT COUNT(*) FROM tbig;
COUNT(*)
----------
72495
hr@ORCL> SELECT * FROM tbig
2 WHERE owner='SYS'
3 AND object_type='PACKAGE'
4 AND object_name LIKE 'F%';
no rows selected
--获取跟踪文件的文件名
hr@ORCL> column trace new_val TRACE
hr@ORCL>
hr@ORCL> select c.value || '/' || d.instance_name || '_ora_' || a.spid || '.trc' trace
2 from v$process a, v$session b, v$parameter c, v$instance d
3 where a.addr = b.paddr
4 and b.audsid = userenv('sessionid')
5 and c.name = 'user_dump_dest';
TRACE
----------------------------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_29506.trc