Re: Getting the SID setting?

From: dean <deanbrown3d_at_yahoo.com>
Date: 15 Mar 2007 09:20:48 -0700
Message-ID: <1173975648.401532.309130@n59g2000hsh.googlegroups.com>

On Mar 15, 10:52 am, DA Morgan <damor..._at_psoug.org> wrote:
> 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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Only the three then!

Thanks for that. Is there something special about the first view?

grant select on gv$mystat to up_feb07

                *

ERROR at line 1:
ORA-02030: can only select from fixed tables/views Received on Thu Mar 15 2007 - 11:20:48 CDT