Re: ALTER DB BKP CTL FILE TO TRACE: how do you retrieve the trace file number in the dictionary ?

"Spendius" <spendius_at_MailAndNews.com> wrote in message news:2a6e94ef.0109030701.37e77ca9_at_posting.google.com...
> Hi,
> I'd like to know if someone knows *exactly* where I can find the
> number Oracle is going to give to my trace file once I've run the
> command ALTER DATABASE BACKUP CONTROLFILE TO TRACE.
>
> I just did it a few minutes ago: it created the file mySid_ora_12864.trc
> in $ORACLE_BASE/admin/mySid/udump. What I'd like to find somewhere
> in the V$ views is this very figure, '12864', from the same session
> as from that where I've executed the ALTER DB command. I thought it was
> V$SESSION.PROCESS + 1, but I've noticed this VARCHAR field can contain a
> colon -':'-, so...
>
> Any idea ?
>
> Thanks a lot !
> Spendius

select spid
from v$process p, v$session s
where p.addr = s.paddr
and s.sd = (select value from v$mystat where rownum = 1)

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Mon Sep 03 2001 - 14:50:33 CDT