SQL_TRACE

[Brian Crabtree · Accepted solution]

Denys,

Check in the $ORACLE_HOME/rdbms/log and $ORACLE_HOME/rdbms/trace directory. This is the default directory that is used when oracle can't write to the original directory. Occasionally this does happen.

Thanks,

brian

[Yogeeraj_1]

hi,

have a look at your alert.log. There could be error messages logged about this issue. If you think that you are really facing a bug then you must surely create a TAR on metalink.

best regards
Yogeeraj

[Denys van Kempen]

Indeed, traces were dumped to $ORACLE_HOME/rdbms/log eventhough the UDUMP directory was valid and writable and the alert.log was correctly located at the BDUMP directory indicated. Strange. Whatever, i've got my traces. Thanks everybody.