Jun,
Wolfgang is correct, and it is covered in Jeff's document. It's the third
point (with example) listed at the bottom of page 1.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic 101, Mar 25-27 Oxford
- Hotsos Clinic 101, Apr 8-10 Chicago
Purely a guess, but looking at the figures
do you think that Oracle is using readv for
values up to 128K, and pread for values
larger than 128K ?
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning