From oracle-l-bounce@freelists.org Tue Oct 18 11:09:21 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9IG9Lmn012804 for ; Tue, 18 Oct 2005 11:09:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j9IG9FvX012783 for ; Tue, 18 Oct 2005 11:09:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C70D7206CF2; Tue, 18 Oct 2005 11:08:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29348-09; Tue, 18 Oct 2005 11:08:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33422207A78; Tue, 18 Oct 2005 11:08:10 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=hUQlgczln39q2JSwIpsQlOeA7m7Jig9yk51mIEvgQuHv+uzqlAknHKOW7q0bILXKuj6a2sEUI6Ii8hHReg3Yi5qLsblCMlXnBK18vNMB9ZaID6KY2s/CjMUgb9pPx0MMBETxX6zdoSYKW3UMLuCaugscFgXzphRg5MyxQcBbEQo= Message-ID: Date: Tue, 18 Oct 2005 09:05:51 -0700 From: Jared Still To: makulev@gmx.net Subject: Re: changing session parameters after logon trigger Cc: oracle-l@freelists.org In-Reply-To: <29441.1129218350@www53.gmx.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline References: <29441.1129218350@www53.gmx.net> X-archive-position: 27134 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-3.7 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 On 10/13/05, Milen Kulev 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