Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: show session parameter
<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
![]() |
![]() |