Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I check the value of a session parameter ?
Hi,
v$parameter reflects the current settings of both the database and your
session, whichever is more current.
If you change the sort_area_size of your session, v$parameter will show the
new value while all other sessions will see the the database default value.
Stephan
"Harry Sheng" <hsheng_at_innovance.com> wrote in message
news:b2Bo9.14968$H67.68002_at_tor-nn1.netcom.ca...
> I set the max_dump_file_size parameter for one long running session to
> 100MB.
> But how can I check that the parameter for that specific session do have
> been set to 100MB ?
>
>
Received on Tue Oct 08 2002 - 08:35:04 CDT