Re: how to find out the SID???

Thomas Miskiewicz < thomas.miskiewicz_at_ecrc.de> wrote: : any idea?

        Yes

select sid from v$mystat where rownum = 1;

SELECT sid,serial#
FROM v$session
WHERE audsid = userenv('SESSIONID');

        The first one is better I think.

        Starous Received on Thu Oct 05 2000 - 06:36:08 CDT