Re: Getting the SID setting?

dean wrote:
> 10.1g, Windows.
>
> Hello all, is there a simple way to get the SID from one of the sys
> views?
>
> And I guess a more general question is: What's a good reference book
> or web site for these views?
>
> Thanks
>
> DeanB

SELECT DISTINCT sid FROM gv$mystat;

SELECT sys_context('USERENV', 'SID') FROM dual;

SELECT sid FROM gv_$session;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org