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
Received on Thu Sep 01 2005 - 08:40:50 CDT
