direct path read (temp) 31 blocks per event
From: HansP <hans-peter.sloot_at_atosorigin.com>
Date: Tue, 4 Nov 2008 05:05:33 -0800 (PST)
Message-ID: <c737dfd3-d2e5-4693-8646-6ba48189011d@v13g2000pro.googlegroups.com>
Date: Tue, 4 Nov 2008 05:05:33 -0800 (PST)
Message-ID: <c737dfd3-d2e5-4693-8646-6ba48189011d@v13g2000pro.googlegroups.com>
Version 11.1.0.6
Platform: Linux
During a performance test I noticed the that 'direct path read temp' where done with 31 blocks and sometimes with 1 block per wait. The 'db file scattered read' 's where done with 128 blocks per wait (db_file_multiblock_read_count was not set explicitly)
Does someone know why the strange number of 31 is chosen for the
direct path reads (at least for temp).
I think that normal direct path reads were als done with 31 blocks but
I am not completely sure about that.
BTW I looked in v$sesion_wait P3 is the block count.
Any suggestions
Regards Hans-Peter Received on Tue Nov 04 2008 - 07:05:33 CST