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

Home -> Community -> Usenet -> c.d.o.misc -> ALTER DB BKP CTL FILE TO TRACE: how do you retrieve the trace file number in the dictionary ?

From: Spendius <spendius_at_MailAndNews.com>
Date: 3 Sep 2001 08:01:41 -0700
Message-ID: <2a6e94ef.0109030701.37e77ca9@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 Received on Mon Sep 03 2001 - 10:01:41 CDT