RE: MULTI-LOCK IO
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle.tutorials@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 25 Aug 2007 13:55:17 -0400
What version of Oracle?
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxxxxx <mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com <http://www.proquest.com>
www.csa.com <http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DBA Deepak
Sent: Saturday, August 25, 2007 1:04 PM
To: oracle-l
Subject: MULTI-LOCK IO
Hi All,
I have few doubts on Multiblock IO.
I have a DB which runs on mixed load i.e., OLTP & DSS. We have few big
tables which require FTS for
reporting and other relatively smaller tables need indexed access. Our
DB block size is 8K.
My queries are:
1> If I set db_file_multiblock_read_count=128 (MAX_IO_SIZE=1M) then the
optimizer may choose FTS
for the other queries as well. Can I set optimizer_index_cost_adj=10 to
influence/override the FTS
decission?
2> Is it a good idea to set db_file_multiblock_read_count=128 at the
session level wherever FTS is
required?
3> Will the system statistics override the db_file_multiblock_read_count
settings?
Please help me on this.
--
Regards,
Deepak
Oracle DBA
Other related posts:
