From oracle-l-bounce@freelists.org Fri Mar 26 08:18:40 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2QEIee23354 for ; Fri, 26 Mar 2004 08:18:40 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2QEIeo23349 for ; Fri, 26 Mar 2004 08:18:40 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 13750390A44; Fri, 26 Mar 2004 09:15:52 -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 13958-35; Fri, 26 Mar 2004 09:15:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5ADC5390B19; Fri, 26 Mar 2004 09:15:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 26 Mar 2004 09:14:43 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3EEAD3907D1 for ; Fri, 26 Mar 2004 09:14:43 -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 13553-40 for ; Fri, 26 Mar 2004 09:14:43 -0500 (EST) Received: from POBOX.corp.rightnow.com (pobox.rightnowtech.com [64.79.34.18]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AB4253909CC for ; Fri, 26 Mar 2004 09:14:42 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message 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 Subject: RE: Timesten Vs. Oracle - Performance Date: Fri, 26 Mar 2004 07:22:10 -0700 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Timesten Vs. Oracle - Performance Thread-Index: AcQS/sYdrO2NiYNxSx2WRHROjT8H8QAPfuDw From: "Orr, Steve" To: X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1886 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sorr@rightnow.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org > I think an analogy I like better is F1 vs B-747. > It probably works on a lot of different levels Yeah, my V-8 SUV is environmentally friendly if you consider mpgpp, miles per gallon per passenger. -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Cary Millsap Sent: Thursday, March 25, 2004 11:49 PM To: oracle-l@freelists.org Subject: RE: Timesten Vs. Oracle - Performance I marvel at the in-memory database vendors' messages, because many of the performance-challenged user actions I see on Oracle databases ARE operating entirely in memory. The reason they're slow is that they perform too many accesses upon the buffer cache. This stuff about TB of Oracle buffer cache making "Oracle tuning a thing of the past" is absolute rubbish. See "Why you should focus on LIOs instead of PIOs" at www.hotsos.com/e-library for details. I don't see how the in-memory guys could be doing any better than a reasonably well-optimized Oracle system, unless they're bypassing all the "horrible serialization operations" that an Oracle instance executes. Thing is, without those serialization operations, a system can't provide, for example, read consistency or recoverability. One aspect of the F1 vs Tank analogy that I really like is that a Formula 1 car is a single-user automobile. I think an analogy I like better is F1 vs B-747. It probably works on a lot of different levels: multi-user-ness, procurement and operational maintenance cost, storage capacity, range, ... :) Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 4/6 Seattle, 5/7 Dallas, 5/18 New Jersey - SQL Optimization 101: 3/29 Dallas, 4/19 Denver, 5/3 Boston, 5/24 San Diego - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] Sent: Friday, March 26, 2004 12:36 AM To: oracle-l@freelists.org; LazyDBA.com Discussion Subject: RE: Timesten Vs. Oracle - Performance It's a bit like comparing the performance of a Formula 1 to the performance of a tank. In-memory databases, in general, will vastly outperform databases that rely on writing to disk, much like the Formula 1 car will vastly outperform traditional databases like Oracle on a smooth track. An in-memory database generally requires that you have enough RAM to hold the entire database and does not have anywhere near the guarantees of durability (the D in ACID) that a traditional database does. Tanks are built to withstand a lot more for a lot longer than a Formula 1 car is. If you have a small, read-only or read-mostly database where you can afford to lose updates, an in-memory database is probably ideal. Otherwise, stick with the traditional database. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of VIVEK_SHARMA Sent: Thursday, March 25, 2004 11:05 PM To: oracle-l@freelists.org; LazyDBA.com Discussion Subject: Timesten Vs. Oracle - Performance How does timesten compare with Oracle Database in performance, availability etc? Timesten in-memory Database - a brief :- The database system needs an inexpensive, plentiful memory, and the dramatic increases in processor speeds relative to the modest increases in disk drive performance.TimesTen produces software that brings real-time database performance to applications. With TimesTen In-Memory Database Technology,throughput is measured in tens of thousands of operations per second, and response times are counted in microseconds. Though internally unique, TimesTen's products are accessed through standards-based interfaces, and designed for easy integration into existing software infrastructures. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------