Predicting trace filenames (again)...

From: Kevin Grant <K.Grant_at_nowhere.com.au>
Date: 2 Oct 2000 00:56:27 GMT
Message-ID: <8FC162988KGRANTBNEQLDAU@132.234.250.31>

I know this went around only just recently, but I was after a bit more information. I can get the trace filename using the following query:

select a.value || '/' || lower('$ORACLE_SID') || '_ora_' || p.spid || '.trc'

from v$parameter a,
     v$session s,
     v$process p

where s.paddr = p.addr
and s.audsid = userenv('sessionid')
and a.name = 'user_dump_dest';

What I need to know is:

1. The format for the trace file name seems to be 'SID_ora_spid.trc' (on Solaris). Is this defined anywhere? Can I change it?
2. In the above query I have to insert '/'. On NT this would be '\'. Is there anyway from within the database of getting this other than saying 'if NT use \, if Unix use /'

Kev. Received on Sun Oct 01 2000 - 19:56:27 CDT