On Thu, 22 May 2003 05:42:12 +0000, BillR wrote:
> Sorry, I forgot to mention this is 8.1.7.4 on Solaris 6
> BRob <member29599_at_dbforums.com> wrote in message
> news:2901151.1053441440_at_dbforums.com...
>>
>> I thought that db_multiblock_read_count established a max on the
>> number of blocks read during a full table scan. However, I'm seeing p3
>> values much higher than the parameter setting of 8. Can someone
>> clarify this for me?
>>
>> WAIT #3: nam='db file scattered read' ela= 1 p1=9 p2=21117 p3=6
>> WAIT #3: nam='db file scattered read' ela= 0 p1=9 p2=21124 p3=5
>> WAIT #3: nam='db file scattered read' ela= 0 p1=8 p2=23817 p3=4
>> WAIT #3: nam='db file scattered read' ela= 1 p1=8 p2=23822 p3=16
>> WAIT #3: nam='db file scattered read' ela= 1 p1=8 p2=23839 p3=51
>> WAIT #3: nam='db file scattered read' ela= 3 p1=8 p2=23891 p3=19
>> WAIT #3: nam='db file scattered read' ela= 1 p1=8 p2=23911 p3=34
>> WAIT #3: nam='db file scattered read' ela= 0 p1=9 p2=21129 p3=13
>> WAIT #3: nam='db file scattered read' ela= 1 p1=9 p2=21143 p3=21
>> WAIT #3: nam='db file scattered read' ela= 2 p1=9 p2=21165 p3=77
>> WAIT #3: nam='db file scattered read' ela= 0 p1=9 p2=21243 p3=7
>>
>> --
>> Posted via http://dbforums.com
>>
also post your db_multiblock_read_count from sqlplus prompt .
Received on Thu May 22 2003 - 06:53:50 CDT