From oracle-l-bounce@freelists.org  Mon Dec 12 10:15:29 2005
Return-Path: <oracle-l-bounce@freelists.org>
Received: from air891.startdedicated.com (root@localhost)
 by orafaq.com (8.12.10/8.12.10) with ESMTP id jBCGFSN4010938
 for <oracle-l@orafaq.com>; Mon, 12 Dec 2005 10:15:28 -0600
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 jBCGFRAX010929
 for <oracle-l@orafaq.com>; Mon, 12 Dec 2005 10:15:27 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8C181252AE4;
 Mon, 12 Dec 2005 11:15:24 -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 06968-08; Mon, 12 Dec 2005 11:15:24 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 08846252B35;
 Mon, 12 Dec 2005 11:15:23 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 12 Dec 2005 11:15:22 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99E06252AE6
 for <oracle-l@freelists.org>; Mon, 12 Dec 2005 11:15:22 -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 06968-06 for <oracle-l@freelists.org>;
 Mon, 12 Dec 2005 11:15:22 -0500 (EST)
Received: from agminet01.oracle.com (agminet01.oracle.com [141.146.126.228])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5D467252AD9
 for <oracle-l@freelists.org>; Mon, 12 Dec 2005 11:15:22 -0500 (EST)
Received: from rgmgw2.us.oracle.com (rgmgw2.us.oracle.com [138.1.186.111])
 by agminet01.oracle.com (Switch-3.1.7/Switch-3.1.7) with ESMTP id jBCGXCR6013131;
 Mon, 12 Dec 2005 10:33:12 -0600
Received: from localhost (localhost [127.0.0.1])
 by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with SMTP id jBCGFJDP025624;
 Mon, 12 Dec 2005 09:15:19 -0700
Received: from us.oracle.com (dhcp-amer-whq-csvpn-gw3-141-144-81-115.vpn.oracle.com [141.144.81.115])
 by rgmgw2.us.oracle.com (Switch-3.1.4/Switch-3.1.0) with ESMTP id jBCGF1is024006;
 Mon, 12 Dec 2005 09:15:04 -0700
From: "Pete Sharman" <peter.sharman@oracle.com>
To: "tomday2@gmail.com" <tomday2@gmail.com>,
        "Marquez, Chris" <cmarquez@collegeboard.org>
Cc: "mark.brinsmead@shaw.ca" <mark.brinsmead@shaw.ca>,
        "oracle-l@freelists.org" <oracle-l@freelists.org>,
        "Peter Ross Sharman" <PETER.SHARMAN@oracle.com>
Subject: RE: Dell-Oracle-Linux: Anyone else run this...because its not
 working for us!
Date: Tue, 13 Dec 2005 03:14:29 +1100
Message-ID: <20051213031429500.00000003828@psharman-au>
In-Reply-To: <a8c504590512111201o43b1abc7rdc2a9fbacea1c0e3@mail.gmail.com>
X-Accept-Language: en-au, en
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis
X-Brightmail-Tracker: AAAAAQAAAAIX-Whitelist: TRUE
X-archive-position: 29100
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-To: oracle-l-bounce@freelists.org
X-original-sender: peter.sharman@oracle.com
Precedence: normal
Reply-To: peter.sharman@oracle.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: Not scanned: please contact your Internet E-Mail Service Provider for details
X-MailScanner-From: oracle-l-bounce@freelists.org

If memory serves me correctly (which ain't guaranteed at 3 in the morning!) that heartbeat is once every three seconds isn't it?  If so, you would need a database with a HUGE number of datafiles before that should cause any problems to a controller surely?  Of course, I could be misunderstanding your point, in which case you're free to ignore me.  :)

 
Pete
 
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
 
"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Thomas Day
Sent: Monday, 12 December 2005 7:02 AM
To: Marquez, Chris
Cc: mark.brinsmead@shaw.ca; oracle-l@freelists.org
Subject: Re: Dell-Oracle-Linux: Anyone else run this...because its not working for us!

We have a non-clustered, RAID 0 development machine.  We have 5
databases up on it but only 6 or 7 uses access any of the databases.

One of the databases was under a heavy performance test, but it was
not the database that had the problem.

The problem was not with the storage media.  A 10 hour surface scan
produced no errors.

My opinion is that the controller is not up to the task of keeping all
of the datafiles updated with Oracle's point-in-time requirement.  My
understanding is that Oracle updates the controlfiles and the
datafiles with a "heartbeat" counter so that Oracle will know that the
datafiles are good.  Under certain circumstances, this seems to be
beyond the ability of the controller (to get all these counters
written in a timely manner).

That's just my understanding of the problem.  I'm certainly open to
enlightenment.  If there's a way to ensure that this problem can be
prevented I'd love to learn it.  Dell didn't offer any encouragement.
--
http://www.freelists.org/webpage/oracle-l




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


