RE: db_file_multiblock_read_count and performance
- From: ryan_gaffuri@xxxxxxxxxxx
- To: Waleed.Khedr@xxxxxxx, <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 06 Dec 2004 19:51:59 +0000
the maximum possible db_file_multiblock_read_count is 128. if you set it to
this value and do a full tablescan then read the trace file you can get your
'actual' max readcount.
look at db file scattered reads p3 values. look for the max value.
> I have been testing this extensively over the last few months. I do a
> full table scan with a db_file_multiblock_read_count =3D 1 and then one =
> =3D
--
//www.freelists.org/webpage/oracle-l
Other related posts:
