Re: show session parameter

From: astalavista <nobody_at_nowhere.com>
Date: Tue, 28 Aug 2007 21:50:59 +0200
Message-ID: <46d47ca0$0$404$426a74cc@news.free.fr>

<sybrandb_at_hccnet.nl> a écrit dans le message de news: qek6d31n3tqm3b1r3kpfduubmdjjai7vof_at_4ax.com...
> On Mon, 27 Aug 2007 13:38:21 -0000, eliot06 <p.hirth_at_gmail.com> wrote:
>
>>to eeing what optimizer is used ? whit the session scott.
>
> Ever heard of v$sql_plan?
> Also there is an Oracle provided stored procedure (would need to
> search for it) allowing you to retrieve a parameter value from a
> session, just as you can retrieve event settings from a session.
> You don't need access at all.

DBMS_UTILITY ... Received on Tue Aug 28 2007 - 14:50:59 CDT