Received: (qmail 26173 invoked from network); 9 Sep 2009 13:19:01 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 9 Sep 2009 13:18:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 586A9CAE027; Wed, 9 Sep 2009 14:18:49 -0400 (EDT) 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 t3-ptRRpOVUX; Wed, 9 Sep 2009 14:18:49 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CE26FCADF92; Wed, 9 Sep 2009 14:18:11 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 09 Sep 2009 14:17:30 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5EFEFCADD96 for ; Wed, 9 Sep 2009 14:17:30 -0400 (EDT) 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 KONWqlIbKizU for ; Wed, 9 Sep 2009 14:17:30 -0400 (EDT) Received: from mars.pcnet.com.pl (mars.pcnet.com.pl [195.117.92.28]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E43CCCADF3E for ; Wed, 9 Sep 2009 14:17:29 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by mars.pcnet.com.pl (Postfix) with ESMTP id DA2FB7E8CD; Wed, 9 Sep 2009 20:17:26 +0200 (CEST) Received: from 105-75.echostar.pl (105-75.echostar.pl [213.156.105.75]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mars.pcnet.com.pl (Postfix) with ESMTP id E3C157E8CB; Wed, 9 Sep 2009 20:17:23 +0200 (CEST) From: Jakub Wartak To: oracle-l@freelists.org, Rob.Dempsey@5one.co.uk Subject: Re: RAMSAN Experience Date: Wed, 9 Sep 2009 20:17:23 +0200 User-Agent: KMail/1.9.4 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Content-Disposition: inline Message-Id: <200909092017.23696.vnulllists@pcnet.com.pl> X-archive-position: 20684 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: vnulllists@pcnet.com.pl Precedence: normal Reply-to: vnulllists@pcnet.com.pl 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 Dnia środa, 9 września 2009 17:29, Rob Dempsey napisał: > We use EMC storage however the latest idea is to use RAMSAM for the > temporary files. I always thought it might be a good idea for the redo logs > but I am not sure about the TEMP files. > > Like I said we have a number of constraints, but any help would be welcome. Ron, You raw need numbers. Enable SAR statistics collection for this LUN/fs with only temporary datafiles. Let it run for min 3 days with 5 minute resolution to collect data. Then you could grep SAR output for exact LUN/fs for these 3 days (using -f switch) and you would end up with data something like reads/s, writes/s, Kbs/s, avwait and avserv. Based on that values then you would decide what to do next... Also you can look at this data in real-time: iostat -x is your friend. How big is your PGA and SGA? What does PGA advisor tells you? What is your OS platform? -- Jakub Wartak http://vnull.pcnet.com.pl -- http://www.freelists.org/webpage/oracle-l