Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 8945 invoked from network); 11 Feb 2007 01:35:38 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 11 Feb 2007 01:35:38 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7BC385EA0E8; Sun, 11 Feb 2007 02:34:23 -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 05468-05; Sun, 11 Feb 2007 02:34:23 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F180B5E3E65; Sun, 11 Feb 2007 02:34:22 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 11 Feb 2007 01:59:31 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A5EA65E97A0 for ; Sun, 11 Feb 2007 01:59:31 -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 01521-03 for ; Sun, 11 Feb 2007 01:59:31 -0500 (EST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4A24B5E8EF2 for ; Sun, 11 Feb 2007 01:59:31 -0500 (EST) Received: by ug-out-1314.google.com with SMTP id a2so1108426ugf for ; Sat, 10 Feb 2007 23:00:45 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=U8y8fW3u2Wv+vJ489PN2CIabDcFKOLmAzTe5SgbZvvVhdK04bpJj+1zdBXri65pYFuI2ifZHbzDf8TroNRipUTAAayGcpUt+/oVSdQsoDh1UzM2fqwNQpGB1yyt+0GRWHhlvPihGg9ILe9enkuQf29vn4cqVOPLLgeLSaxTJK+o= Received: by 10.67.117.18 with SMTP id u18mr13438671ugm.1171177245509; Sat, 10 Feb 2007 23:00:45 -0800 (PST) Received: by 10.67.102.12 with HTTP; Sat, 10 Feb 2007 23:00:45 -0800 (PST) Message-ID: <3b0f44a10702102300h3b9120dh139c030da47878e@mail.gmail.com> Date: Sun, 11 Feb 2007 02:00:45 -0500 From: "K Gopalakrishnan" To: info@go-faster.co.uk Subject: Re: kksfbc child completion Cc: ORACLE-L In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Disposition: inline References: X-archive-position: 45439 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: kaygopal@gmail.com Precedence: normal Reply-to: kaygopal@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net David, kks is Kompilation Layer function to Find the Bounded Cursor. Typically related to parsing (hard) which sometimes calls kksscl to scan the child list on those cursors when the cursors are shared. What is your cursor_sharing set to and do you see excessive waits? Or the question is just acadamic? -- Best Regards, K Gopalakrishnan Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ Author: Oracle Database 10g RAC Handbook, Oracle Press 2006 http://www.amazon.com/gp/product/007146509X/ -- http://www.freelists.org/webpage/oracle-l