Re: Backup Controlfile to Trace

From: <oratune_at_aol.com>
Date: Tue, 19 Sep 2000 00:46:07 GMT
Message-ID: <8q6d09$t7p$1@nnrp1.deja.com>

In article <39c6af07_at_news.iprimus.com.au>, "Howard J. Rogers" <howardjr_at_www.com> wrote:
> I'm trying to work out a way of determining the name (before the
event) that
> Oracle will give the trace file after issuing the backup controlfile
to
> trace command.
>
> (Windows 2000, 8.1.6)
>
> The trace file helpfully points out when you read it that the Windows
Thread
> ID was 12345 (say!), and hence the tracefile name of ORA12345.TRC.
But I'd
> like to know this in advance, and was wondering whether there's some
V$ I
> don't know about that would tell me (V$PROCESS doesn't, as far as I
can
> tell), or is there some Windows-specific thing I should know about
that I
> can interrogate with some clever bit of C?
>
> Hope you can help,
> Regards
> HJR
> --
> ----------------------------------------------------------------------

> Opinions expressed are my own, and not those of Oracle Corporation
> Oracle DBA Resources:

http://www.geocities.com/howardjr2000
> ----------------------------------------------------------------------

>
>

I believe that the SPID column in V$PROCESS will provide the Windows Thread ID (it supplies the UNIX process id, and since Windows operates with threads rather than processes this is the first place I would consider). You can link that to a session via the ADDR column in V$PROCESS and the PADDR column in V$SESSION.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Mon Sep 18 2000 - 19:46:07 CDT