Block Reads per second
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: "Oracle L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 Feb 2005 20:51:19 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
