RE: db_file_multiblock_read_count + db file scattered read + truss

2003-03-13 Thread Cary Millsap
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

Re: db_file_multiblock_read_count + db file scattered read + truss

2003-03-13 Thread Jonathan Lewis
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