Received: (qmail 29946 invoked from network); 12 Dec 2011 11:48:49 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.ip-pool.com with SMTP; 12 Dec 2011 11:48:47 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53459E68B52; Mon, 12 Dec 2011 12:48:45 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1323712125; bh=u4QcDxRio7Cx0DBfeNJBmrHB1KGBa7DBW82s59o0 M6Y=; h=From:To:Date:Subject:Message-ID:In-Reply-To:Content-type: Content-Transfer-Encoding:MIME-Version:Sender:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=sER6o3ZdN3e2MKTdUWY7EpkECcYOx75AiNE1AO5a5DtCBMMKaT ldcHRIj0+9aAeVaCejFJpCIbF3On+s+O6WVjMIhMwPbIton4H7667Sbyk9SUC9eUs+C RkYNADeYPeAu2YI/pTPXJrK4YD5f89vBUh1b5ZUxpIAIv73vXM92SI= X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id DszdPyz6z0lL; Mon, 12 Dec 2011 12:48:45 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F665E68AC3; Mon, 12 Dec 2011 12:48:02 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Dec 2011 12:47:20 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 860BEE68947 for ; Mon, 12 Dec 2011 12:47:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Bthwzfe6pkjU for ; Mon, 12 Dec 2011 12:47:20 -0500 (EST) Received: from mail.onecall.com (smtp0.onecall.com [65.61.126.100]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 220D0E68AA1 for ; Mon, 12 Dec 2011 12:47:18 -0500 (EST) Received: from EXCH07MBX1.ocint.com ([192.168.11.106]) by exch07-hub1.ocint.com ([192.168.10.148]) with mapi; Mon, 12 Dec 2011 09:47:17 -0800 From: Anthony Ballo To: "'oracle-l@freelists.org'" Date: Mon, 12 Dec 2011 09:47:15 -0800 Subject: Mat View - used by? Thread-Topic: Mat View - used by? Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.13.0.110805 acceptlanguage: en-US Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 X-archive-position: 40598 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: anthony.ballo@onecall.com Precedence: normal Reply-To: anthony.ballo@onecall.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 Hello, I'm trying to determine if we can lengthen the time to refresh on a particular Mat View in 10.2.0.4. Is there a way to see (via SQL?) what other code utilizes this Materialized View (like a "used by")? It is currently on a 1/48 (every half hour) refresh which seems excessive to me. The naming of the view would suggest that it is used in Discoverer reporting. Thanks, Anthony -- http://www.freelists.org/webpage/oracle-l