From oracle-l-bounce@freelists.org Fri Nov 18 12:17:49 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jAIIHnae011360 for ; Fri, 18 Nov 2005 12:17:49 -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 jAIIHcAX011325 for ; Fri, 18 Nov 2005 12:17:39 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A206E23098E; Fri, 18 Nov 2005 12:16:21 -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 15823-01; Fri, 18 Nov 2005 12:16:21 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0F23D23097D; Fri, 18 Nov 2005 12:16:21 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 18 Nov 2005 12:14:26 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E39022307C3 for ; Fri, 18 Nov 2005 12:14:25 -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 15412-07 for ; Fri, 18 Nov 2005 12:14:25 -0500 (EST) Received: from mail75.messagelabs.com (mail75.messagelabs.com [216.82.255.83]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 1F3D6230782 for ; Fri, 18 Nov 2005 12:14:24 -0500 (EST) X-VirusChecked: Checked X-Env-Sender: BSpears@Limitedbrands.com X-Msg-Ref: server-7.tower-75.messagelabs.com!1132334032!67545270!1 X-StarScan-Version: 5.5.9.1; banners=-,-,- X-Originating-IP: [63.72.208.114] Received: (qmail 7127 invoked from network); 18 Nov 2005 17:13:53 -0000 Received: from exchusmail2.limitedbrands.com (HELO exchusmail2.limitedbrands.com) (63.72.208.114) by server-7.tower-75.messagelabs.com with SMTP; 18 Nov 2005 17:13:53 -0000 Received: from EXCHUSGTWY2.Limited.brands.com ([192.168.5.2]) by exchusmail2.limitedbrands.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 18 Nov 2005 12:13:24 -0500 Received: from EXCHSERV2.Limited.brands.com ([10.8.5.116]) by EXCHUSGTWY2.Limited.brands.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 18 Nov 2005 12:14:02 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5EC63.729A668B" Subject: RE: How to generate a lot of load on an Oracle database? Date: Fri, 18 Nov 2005 12:13:51 -0500 Message-ID: <50938E6468CFED40AE0FD7A507D96D340207D057@EXCHSERV2.Limited.brands.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: How to generate a lot of load on an Oracle database? Thread-Index: AcXsUGRF66XkmDKMTCK1E9bdU5Sm7QAEpdiQ From: "Spears, Brian" To: , X-OriginalArrivalTime: 18 Nov 2005 17:14:02.0482 (UTC) FILETIME=[78EFB520:01C5EC63] X-archive-position: 28498 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: BSpears@Limitedbrands.com Precedence: normal Reply-To: BSpears@Limitedbrands.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-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5EC63.729A668B Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable I made script which showed me meg per second per mount point... and I = just thrash the SAN and check the numbers.=20 =20 I noticed over the years the meg per second on these SAN have increased significantly. I am told that most of the io just just written to = memory (cache) so that the speed of the underlying disk is not an issue. =20 Let me know if you would want that. =20 Brian ________________________________ From: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] On Behalf Of Daiminger, Helmut Sent: Friday, November 18, 2005 9:57 AM To: oracle-l@freelists.org Subject: How to generate a lot of load on an Oracle database? Hi!=20 We need to test the maximum I/O throughput of our SAN storage system and therefore need an Oracle database to generate so much load that there is = an I/O bottleneck. Does anybody out there have open source tools or Oracle scripts for that? This is 9.2 on HP-UX 11i and EMC Clariion.=20 Thanks,=20 Helmut=20 ------_=_NextPart_001_01C5EC63.729A668B Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable How to generate a lot of load on an Oracle = database?
I made script  which showed me meg per = second per=20 mount point... and I just thrash the SAN and check the numbers.=20
 
 I noticed over the years the meg per = second on these=20 SAN have increased significantly.  I am told that most of the io = just just=20 written to memory (cache) so that the speed of the underlying disk is = not an=20 issue.
 
Let me know if you would want = that.
 
Brian

From: oracle-l-bounce@freelists.org=20 [mailto:oracle-l-bounce@freelists.org] On Behalf Of Daiminger,=20 Helmut
Sent: Friday, November 18, 2005 9:57 AM
To:=20 oracle-l@freelists.org
Subject: How to generate a lot of load = on an=20 Oracle database?

Hi!

We need to test the maximum I/O = throughput of our SAN=20 storage system and therefore need an Oracle database to generate so much = load=20 that there is an I/O bottleneck. Does anybody out there have open source = tools=20 or Oracle scripts for that?

This is 9.2 on HP-UX 11i and EMC = Clariion.=20

Thanks,
Helmut


------_=_NextPart_001_01C5EC63.729A668B-- -- http://www.freelists.org/webpage/oracle-l