Re: Poll: How fast is YOUR database in rows per second, on a full bore table scan???

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 09 Jan 2008 06:25:14 -0800
Message-ID: <1199888696.407895@bubbleator.drizzle.com>


Helma wrote:
> if you're interested in I/O, this unsupported tool may interest you:
>
> http://www.oracle.com/technology/software/tech/orion/index.html
>
> i'm going to play around with it too, to see the I/O difference
> between machines.
>
> H.

Or, of coures, you can just move to 11gR1 where calibrate_io is now built-in functionality.
http://www.psoug.org/reference/dbms_res_mgr.html

SELECT * FROM gv$io_calibration_status;

SELECT * FROM dba_rsrc_io_calibrate;

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jan 09 2008 - 08:25:14 CST

Original text of this message