Block Reads per second

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Tue, 8 Feb 2005 20:51:19 -0500
Message-ID: <f09dd6280502081751214f76e2@mail.gmail.com>

Hi All,

This may be a silly question, but I am trying to estimate the time it would take to execute a query which joins two tables (range partitioned) and both of them have more than 100 million records.

Software/Hardware Specification:
9i R2, 4 CPU, 2 Node RAC, Sun Solaris, BLOCK_SIZE=8K, m db_file_multiblock_read_count=32

Question:
What would be the normal count of Block Reads per second ?

Thanks in advance,
--

Sami Seerangan
Oracle DBA
--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 08 2005 - 20:54:02 CST