Re: Getting the SID setting?

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 15 Mar 2007 11:18:49 -0700
Message-ID: <1173982728.159018@bubbleator.drizzle.com>

dean wrote:
> 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

A DBA will need to grant access to any gv$ or v$ view.

I'd recommend SYS_CONTEXT to any developer. It can also be used to grab lots of other properties. Check out the page in Morgan's Library at www.psoug.org.

-- 
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

Received on Thu Mar 15 2007 - 13:18:49 CDT