RE: Anyway to accurately predict time for long running queries?

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 10 Feb 2004 15:03:49 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C1928@xchgbrsm1.corp.espn.pvt>

Has anyone (Mladen included) tried this approach or something similar? = How did your management react? How did development react?

Raj

-------------------------------------------------------------------------=

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala Sent: Tuesday, February 10, 2004 12:07 PM To: oracle-l_at_freelists.org
Subject: Re: Anywy to accurately predict time for long running queries?

On 02/10/2004 12:01:30 PM, Cary Millsap wrote:

> If you're *writing* the app yourself, then consider using the Oracle
> long-ops stuff. I can't remember how to access it (and my network
> connection is too slow to look it up right now). For example, if you

One of the dirty tricks is to set up a profile with limited =20 LOGICAL_READS_PER_CALL to, say, 1000 or 1500 and then tune whichever =20 statement fails. Most of modern unix systems can easily execute 1500 =20 LIO's in a second. Big boxes with separate IO buses and "smart I/O" =20 architectures can do many, many LIO's more. I don't know how many LIO requests/sec can IBM "big iron" perform.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Tue Feb 10 2004 - 14:03:49 CST