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
>
Received on Thu May 22 2003 - 00:42:12 CDT
