From oracle-l-bounce@freelists.org Sun Oct 23 21:49:59 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9O2nmWu015996 for ; Sun, 23 Oct 2005 21:49:58 -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 j9O2nWvX015973 for ; Sun, 23 Oct 2005 21:49:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3B51A20BADA; Sun, 23 Oct 2005 21:49:12 -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 31912-08; Sun, 23 Oct 2005 21:49:12 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B845C20A4CF; Sun, 23 Oct 2005 21:49:11 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=wxkbgxcRHS8wjQrUXFWuUD/Q40quW+oF5saAjj5yNBv3zC0+FzPqXofKFh95BM7YEzSD9o/J336802UZvau0N5aePdKukkllyQ4v8yOeeUrNlfkHaIzstsGX3XYRcaC9ALGLO2+qDFAStcuILDlilLOf2EEOqIN5c7iSimsqxcc= ; Message-ID: <20051024024715.15586.qmail@web60715.mail.yahoo.com> Date: Sun, 23 Oct 2005 19:47:15 -0700 (PDT) From: A Joshi Subject: ** to outline or not to To: oracle-l@freelists.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1022321939-1130122035=:15383" X-archive-position: 27402 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ajoshi977@yahoo.com Precedence: normal Reply-To: ajoshi977@yahoo.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=-1.7 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD,FROM_ENDS_IN_NUMS,HTML_MESSAGE autolearn=no version=2.63 --0-1022321939-1130122035=:15383 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I looked at metalink note 122812.1 How to Tune a Query that Cannot be Modified. And that led to manipulate of stored outline note : @ Note 92202.1 Manipulating Stored Outlines – this is NOT supported It says not supported but can I assume it to be safe? Anyone had any surprises? About outline itself if it is set to be used systemwide I am sure it will have a overhead since all queries will be checked in outline. I want to know to what extent is this overhead (rough percentage?). Any other issues? Maybe a user can have stored outlines used by a onlogon trigger. Info/experience on this appreciated. Thanks --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. --0-1022321939-1130122035=:15383 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi,
   I looked at metalink note 122812.1 How to Tune a Query that Cannot be Modified. And that led to manipulate of stored outline note :
 
@ Note 92202.1 Manipulating Stored Outlines – this is NOT supported
 
It says not supported but can I assume it to be safe? Anyone had any surprises? About outline itself if it is set to be used systemwide I am sure it will have a overhead since all queries will be checked in outline. I want to know to what extent is this overhead (rough percentage?). Any other issues? Maybe a user can have stored outlines used by a onlogon trigger. Info/experience on this appreciated. Thanks 
 

Yahoo! FareChase - Search multiple travel sites in one click. --0-1022321939-1130122035=:15383-- -- http://www.freelists.org/webpage/oracle-l