Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find out those parameters set in session leve
chuan wrote:
> Hi, All,
>
> Is there any way to find out the parameters setting in session
> level? These parameters are not the initialization parameters.
> For example, if alter session set use_stored_outlines=true; how could
> I find out the use_stored_outlines value later on?
>
> TIA
SELECT name, value
FROM v$parameter;
Daniel Morgan Received on Mon Sep 23 2002 - 10:57:20 CDT