I'm giving all it's got captain... (in my worst scotty impersonation) 
DB_FILE_MULTIBLOCK_READ_COUNT = 128 (is the maximum my os can handle)
Incidently, I just re-ran the test's again and they return in the following:
8K - Elapsed: 00:00:31.17
32K - Elapsed: 00:00:40.37
The DB is pretty quiet, but the server get's a bit of a hammering from time to time from other DB's. So, I'm still not convinced of a better read performance on larger non-default blocks sizes.
I was also testing indexes and tables in larger non-default DB's this morning... which was also eyebrow raising, with the blocks of an index scan going into the default db_cache... not the db_32k_cache as I'd have expected.... more testing to go on that one.
Last edited by grjohnson; 08-12-2003 at 12:01 PM.
OCP 8i, 9i DBA
Brisbane Australia
Reply With Quote