From oracle-l-bounce@freelists.org Wed Sep 28 08:15:00 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8SDExCh018490 for ; Wed, 28 Sep 2005 08:14:59 -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 j8SDEr6H018462 for ; Wed, 28 Sep 2005 08:14:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9FAD71EFF66; Wed, 28 Sep 2005 08:14:41 -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 25529-01; Wed, 28 Sep 2005 08:14:41 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1F1DC1EFDF4; Wed, 28 Sep 2005 08:14:41 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=WIolsfIbLO4cAPFSYmJvcKxKYzgP9NAscfT5Btotnv72Q+eXvXz7M2atl2dt8iSrbDk0Sat4Cw9zFPcIxDisI9vZ6rV0frKpPn6JycWltgd3mZTBUwxRytFmyzc094HWuQaniY2PEqNgSLyC1aB8p/hvjwpo5dAWL5m3T2RkaoQ= Message-ID: <9177895d05092806125201912e@mail.gmail.com> Date: Wed, 28 Sep 2005 09:12:41 -0400 From: rjamya To: manoj.gurnani@polaris.co.in Subject: Re: PL/SQL question Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3081_27091095.1127913161832" References: X-archive-position: 26009 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@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-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.9 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_3081_27091095.1127913161832 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline You don't show us the code, you don't tell us what version,platform, you don't tell us how much time it takes and you don't tell us how much time ti should take. Sorry, the crystal ball is broken, come back in 3 weeks. ps: 1 lakh is one hundred thousand. Raj On 9/28/05, manoj.gurnani@polaris.co.in wrote= : > > > Hi, > I've a cursor which retrieves about 3 lakh recs from a table.(master) > based on column value retrieved from cursor for each rec,there are other > tables (detail) to be updated. > The detail tables have large volumes of data. > the question is how can the performance be improved to achieve the desire= d > result. > ------=_Part_3081_27091095.1127913161832 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline You don't show us the code, you don't tell us what version,platform, you don't tell us how much time it takes and you don't tell us how much time ti should take.

Sorry, the crystal ball is broken, come back in 3 weeks.

ps: 1 lakh is one hundred thousand.
Raj

On 9/28/05, manoj.gurnani@pol= aris.co.in <manoj= .gurnani@polaris.co.in > wrote:

Hi,
      I've a cursor which ret= rieves about 3 lakh recs from a table.(master)
based on column value retrieved from cursor for each rec,there are othe= r
tables (detail) to be updated.
The detail tables have large volumes= of data.
the question is how can the performance be improved to achieve= the desired
result.

------=_Part_3081_27091095.1127913161832-- -- http://www.freelists.org/webpage/oracle-l