Re: Anywy to accurately predict time for long running queries?

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Tue, 10 Feb 2004 13:06:55 -0500
Message-ID: <20040210180655.GA2763@mladen.wangtrading.com>

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 LOGICAL_READS_PER_CALL to, say, 1000 or 1500 and then tune whichever statement fails. Most of modern unix systems can easily execute 1500 LIO's in a second. Big boxes with separate IO buses and "smart I/O" 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 - 12:06:55 CST