Dependent on platform, but it almost always contains
the OS process id which you can get from v$process.
So something like
select c.value || '/' ||
'appropriate_format_string'||
a.spid || '.trc'
from v$process a, v$session b, v$parameter c
where a.addr = b.paddr
and b.sid = ( select sid
from v$mystat
where rownum = 1)
and c.name = 'user_dump_dest'
hth
connor
- Kevin Lange <kgel_at_ppoone.com> wrote: > The way we
do it is not 100% but it seems close
> enough. We run the backup
> command and then do a descending order listing by
> date from the trace
> directory. The first file is the one containing
> the trace.
>
> If anyone has a beter idea, I am all ears.
>
> Kevin
>
> -----Original Message-----
> Sent: Tuesday, September 17, 2002 1:13 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 8.1.7
>
> For scripting purposes, what is the logic for
> finding the trc file from
> alter database backup controlfile to trace cmd?
> This seems really
> stupid not being able to direct the output.
>
> Ray Stell stellr_at_vt.edu (540) 231-4109
> KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ray Stell
> INET: stellr_at_cns.vt.edu
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Sep 17 2002 - 18:03:20 CDT