Re: How does one find various session parameters

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. Received on Sat Apr 01 2006 - 08:51:05 CST