Wednesday, April 30, 2008

10046 trace

Oracle Extended Trace => 10046 event

Example : /oracle/oracle_home/admin/orcl2/bdump/orcl2_ora_10040.trc

/oracle/oracle_home/admin/orcl2/bdump/orcl2_ora_10040.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /oracle/oracle_home
System name:    HP-UX
Node name:      hpoce104
Release:        B.11.23
Version:        U
Machine:        9000/800
Instance name: orcl2
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 10040, image: oracle@hpoce104

Ioctl ASYNC_CONFIG error, errno = 1

alter session set events '10046 trace name context forever,level 12';

No comments:

Post a Comment