Re: How does one find various session parameters

On 31 Mar 2006 17:27:45 -0800, dbaplusplus_at_hotmail.com wrote:

>I am using Oracle 9.2.0.5 on HP UNIX 11i, but this is a general
>question,
>
>To find value of a "init.ora" parameter, one can query v$parameter
>or use show
>Parameter command. But, how does one find session parameters (set using
>alter session or default session parameters). For example, a logon
>trigger is setting create_stored_outlines. I do not have access to the
>code for logon trigger, and I want to find the value of this
>session parameter.
>
>Similar to show all
> I am also interested in setting all the session parameters,
>What is the equivalent command for it?

v$parameter provides session parameters. Ie if you change a parameter, you will see your value, not the system wide.

You are aware of the alter session command?

--
Sybrand Bakker, Senior Oracle DBA