Re: v$session and v$parameter
- From: Andy Klock <andy@xxxxxxxxxxxxxxx>
- To: valpis@xxxxxxxxx
- Date: Thu, 13 Feb 2014 20:55:15 -0500
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:
http://enkitec.tv/2012/06/24/oracle-hacking-session-with-tanel-poder-oracle-parameter-infrastructure/
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@xxxxxxxxx> 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
>
Other related posts:
