v$session and v$parameter

From: Johan Eriksson <valpis_at_gmail.com>
Date: Thu, 13 Feb 2014 22:44:07 +0100
Message-ID: <CABz5TyCauuLbBFZG1toGwU01i6PYHvD3fnFs6_dKHQhJdJDsjw_at_mail.gmail.com>



Hi

I was just reading the docs about the v$parameter and it says

"V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the V$SYSTEM_PARAMETER  view."

 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-l
Received on Thu Feb 13 2014 - 22:44:07 CET

Original text of this message