Re: How does one find various session parameters

On 1 Apr 2006 06:51:05 -0800, dbaplusplus_at_hotmail.com wrote:

>I do know parameters set using
>alter system
>can be seen from v$parameter, but whar about parameters set using
>alter session, e.,g., in logon trigger,
>
>There does not seem a way to find them. Is there a UNIX equivalent of
>:env command to find all session pramaters once I am connected to a
>database using sqlplus, jdbc etc.

Did you actually read my answer at all?
Please read it again, or change your nick to dbaminmin

--
Sybrand Bakker, Senior Oracle DBA