Arg. There's at least one caveat in that "AUDSID" won't work if you're
logged in as SYSDBA, since it'll be 0, just like the background processes (I
did my testing on 9iR2).
Oh well... :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -----Original Message-----
> From: Jesse, Rich
> Sent: Tuesday, September 17, 2002 3:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: backup controlfile to trace
>
>
> Cool idea, Kirti, but wouldn't it be better to filter the results with
>
> AND s.audsid = USERENV('SESSIONID')
>
> instead of running thru v$mystat? USERENV is available at
> least as far back
> as 8.0.5.
>
> Not that it matters greatly for this particular purpose, but
> I know that
> code around here tends to multiply.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
