Oracle Database Discussions

Dear Experts,

As a DBA, how can I identify the session level parameters. For example, a session modifies initialization parameters at a session level like shown below:

Session 1_

alter session set cursor_sharing=force;

select * from emp where empno = 123;



and the above session is still connected.

Is there a view to look at the modified initialization parameters?

Thanks for working on my question.

Regards