From oracle-l-bounce@freelists.org Thu Oct 27 10:12:45 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9RFCYqN013970 for ; Thu, 27 Oct 2005 10:12:44 -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 j9RFCIvX013855 for ; Thu, 27 Oct 2005 10:12:18 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5614A21159F; Thu, 27 Oct 2005 10:12:01 -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 26633-01; Thu, 27 Oct 2005 10:12:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C33122115AD; Thu, 27 Oct 2005 10:12:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 27 Oct 2005 10:10:06 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0A9B0211504 for ; Thu, 27 Oct 2005 10:10:06 -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 25940-08 for ; Thu, 27 Oct 2005 10:10:05 -0500 (EST) Received: from smtp12.singnet.com.sg (smtp12.singnet.com.sg [165.21.6.22]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 56B17211521 for ; Thu, 27 Oct 2005 10:10:05 -0500 (EST) Received: from chitale.singnet.com.sg (bb220-255-250-199.singnet.com.sg [220.255.250.199]) by smtp12.singnet.com.sg (8.13.5/8.13.4) with ESMTP id j9RFA1X1015613; Thu, 27 Oct 2005 23:10:02 +0800 Message-Id: <6.2.1.2.0.20051027230728.01fd0540@pop.singnet.com.sg> Date: Thu, 27 Oct 2005 23:09:56 +0800 To: rjamya@gmail.com, sfaroult@roughsea.com, "Oracle-L (E-mail)" From: Hemant K Chitale Subject: Re: Is this Needed? In-Reply-To: <9177895d0510260933j7aad938bk2ec5619a830090e2@mail.gmail.co m> References: <51327ABA927BEF4B96590554CEA7832C290706@enhbgpri05.pa.lcl> <687bf9c40510260823n32f1a59cs@mail.gmail.com> <1130344211.5352.28.camel@frlinux2.roughsea.com> <9177895d0510260933j7aad938bk2ec5619a830090e2@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/html; charset="us-ascii" X-archive-position: 27683 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: hkchital@singnet.com.sg Precedence: normal Reply-To: hkchital@singnet.com.sg 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=-4.4 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE, MIME_HTML_ONLY autolearn=no version=2.63
Slightly similarly, we had a case where rebuilding the snapshot log helped.

A week ago we had noticed that MV refresh's were taking longer and were occassionally failing
on ORA-1555s. We then redefined the MV to extract a smaller subset of data . We knew
that this was supposed to be faster. Yet, it wasn't any faster and the load that the refresh
was causing was still high. We realised that the snapshot logs on the base tables had
grown inordinately large {as a result of the ORA-1555s in the refresh's}. We dropped
and recreated the snapshot logs. Thereafter, MV refresh's were also much faster.

Hemant

At 12:33 AM Thursday, rjamya wrote:

Just for AQ this script on metalin is also good.

Raj

On 10/26/05, Stephane Faroult <sfaroult@roughsea.com> wrote:

There is something else that may benefit, namely tables that are used

for queues and that had their high-water mark bumped much too high at a

given moment. But copying their contents elsewhere, truncating and

re-inserting the rows definitely don't require reorganizing the full

database ... I agree with the general feeling: waste of time. Great

opportunity to say "told you so".

Stephane Faroult

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

-- http://www.freelists.org/webpage/oracle-l