Re: Checking value set via "set transaction" or "alter session"

From: Jack <jreid_at_stirlingonline.com>
Date: Sat, 8 Mar 2008 11:39:07 -0800 (PST)
Message-ID: <38ba65ed-9ce1-47c9-9eb4-cc94dc2ddcda@f47g2000hsd.googlegroups.com>


On Mar 8, 4:16 am, vitalis..._at_gmail.com wrote:
> On 8 mar, 07:16, Jack <jr..._at_stirlingonline.com> wrote:
>
> > This seemed like it would be a simple question to answer, but I can't
> > find anything on either.
>
> > Can anyone shed some light on how to determine the value I have used
> > for "set transaction" (say to "read only") and for "alter
> > session" (say to change the NLS_DATE_FORMAT)?
>
> > Lots of info on setting, haven't been able to find anything about
> > checking these once they've been set.
>
> > Thank you, Jack
>
> Which Oracle version?
> When and from where do you want to check those parameter values?

Sorry, my bad. DB version 10.2, I'd like to find these out through PL/ SQL. Received on Sat Mar 08 2008 - 13:39:07 CST

Original text of this message