Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: changing session parameters after logon trigger

Re: changing session parameters after logon trigger

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 18 Oct 2005 09:05:51 -0700
Message-ID: <bf46380510180905k7e4552f5yc46a92beb37eb915@mail.gmail.com>


On 10/13/05, Milen Kulev <makulev_at_gmx.net> wrote: ...
> alter session set optimizer_mode = first_rows_10;
> alter session set hash_join_enabled = false;
> alter session set "_optimizer_sortmerge_join_enabled" = false;
> alter session set "_optimizer_join_sel_sanity_check" = true;
>

...
>
> When I set "_optimizer_sortmerge_join_enabled" to TRUE AND
> optimizer_dynamic_sampling to 0, then I am getting 0.1 seconds elapsed
> time!
>

Regardless of your testing results or advice you get from this list, you should probably discuss this with Sieble, er, Oracle?, support.

As these are underscore parameters, Oracle doesn't directly support them, Siebel *should* be able to offer some guidance.

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2005 - 11:09:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US