Re: v$session and v$parameter
From: Andy Klock <andy_at_oracledepot.com>
Date: Thu, 13 Feb 2014 20:55:15 -0500
Message-ID: <CADo_RaP-fd=WCNDa=oEBNkmYO=BqLhqvNHdYsPNE6wOSc1CV7w_at_mail.gmail.com>
There isn't one. If you are trying to determine the parameter values of another session then v$ses_optimizer_env is the way to go. It doesn't have all of the parameters but it does have the ones that affect the optimizer. If you haven't run across it before Tanel has a great hacking session talk that covers a lot of this:
Date: Thu, 13 Feb 2014 20:55:15 -0500
Message-ID: <CADo_RaP-fd=WCNDa=oEBNkmYO=BqLhqvNHdYsPNE6wOSc1CV7w_at_mail.gmail.com>
There isn't one. If you are trying to determine the parameter values of another session then v$ses_optimizer_env is the way to go. It doesn't have all of the parameters but it does have the ones that affect the optimizer. If you haven't run across it before Tanel has a great hacking session talk that covers a lot of this:
Is this just research or are you trying to solve a problem?
Andy
On Thu, Feb 13, 2014 at 4:44 PM, Johan Eriksson <valpis_at_gmail.com> wrote:
>
> I know there is a connection between v$session and v$ses_optimizer_env, but
> I can't find any connection between v$parameter and v$session.
>
> Anyone who knows?
>
> /johan
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 14 2014 - 02:55:15 CET