Re: How can I check the value of a session parameter ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 8 Oct 2002 23:45:08 +1000
Message-ID: <68Bo9.48705$g9.140451@newsfeeds.bigpond.com>

Hi Harry,

You can either query V$PARAMETER where name = 'max_dump_file_size' or SHOW PARAMETER max_dump_file_size.

Cheers

Richard
"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:45:08 CDT