Why is the multiblock_read_count 16K? This indicates to the optimizer the
number of database pages that will be read per IO operation when a scan is
being performed. This setting will bias queries into using full scans rather
than indexes and could severely degrade real performance.

You should set probably this to 16 and NOT 16K.

Also you should look at setting system statistics (if you are running on 9i
or 10G) as this will set some real values from your running system that the
optimizer can use for query plans.

John.

-----Original Message-----
From: kidambi
[mailto:oracledba-ezmlmshield-x94665116.[Email address protected]
Sent: 04 April 2007 11:55
To: LazyDBA Discussion
Subject: RE: gcs remote message event

Hi,

Yes . DB_BLOCK_SIZE is 8k and the value for parameter
DB_FILE_MULTIBLOCK_READ_COUNT is 16k, erroneously I have mentioned the
size as mb. And, on quering the view GV$CACHE_TRANSFER there are a couple
of objects with xnc more than 1500. Is it advisible to increase the
DB_FILE_MULTIBLOCK_READ_COUNT or is any other action warranted.


Kind regards,
Raj



This e-Mail may contain proprietary and confidential information and is sent
for the intended recipient(s) only. If by an addressing or transmission
error this mail has been misdirected to you, you are requested to delete
this mail immediately. You are also hereby notified that any use, any form
of reproduction, dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or its
attachment other than by its intended recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page