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>
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.orgReceived on Wed Jan 09 2008 - 08:25:14 CST