Re: db file multiblock read count

sushil wrote:
>
> Thanks Mark....but is it limited by max I/O transfer that your hardware
> and OS can support.Recently i set it to 128 for my db (9205 om HP UX)
> and it even supported that as seen from the v$session_wait view.I
> thought of increasing it further but was a bit circumspect on the after
> effects.
> You can see the maximum that is being supported by querying the session
> wait view continously and see the p3 column.
> select p3 from v$session_wait where event like '%scattered%'
>
> sushil

last time i checked oracle had a internal limit of 1m, no matter what your OS could support.

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------