Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: 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: 4 Sep 2001 03:09:14 -0700
Message-ID: <2a6e94ef.0109040209.4e3d3d16@posting.google.com>


Guess you meant
> ...
> AND s.audsid = SYS_CONTEXT('USERENV', 'SESSION_USER')

rather than
> AND s.sid = (SELECT value
> FROM v$mystat
> WHERE rownum =1)

didn't you ?

Thanks a lot anyway !
Beste groeten,
Spendius

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tp7or1pf6dnnb5_at_news.demon.nl>...
> "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.sid = (select value from v$mystat where rownum = 1)
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Tue Sep 04 2001 - 05:09:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US