Re: RE: db file sequential read

VIVEK_SHARMA,

		Hi, did you have benchmark result or other whitepaper talking about this thoery?
		For db file sequential read, it is single block read to index and then to table, so i think enlarge the maxio size of the os won't help?(I just guess, did not test it).
		Enableing AIO or using raw device maybe will help io performance, thus give reduced io wait, i think.
	Good luck

Regards
zhu chao
Eachnet DBA
86-21-32174588-667
chao_ping_at_vip.163.com
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)

• 2002-11-19 23:34:00 ,you wrote£º=======

>For "db file sequential read wait" Add Following to /etc/system
>On UFS
>Setting maxphys=8388608
>On VXFS
>set vxio:vol_maxio = 16384 ( implies 8MB )
>
>-----Original Message-----
>[mailto:Charlie_Mengler_at_HomeDepot.com]
>Sent: Tuesday, November 19, 2002 8:24 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>I'm search of perfection in an imperfect world.
>This problem involves a V7.3.4.5 DB on V2.6 Solaris.
>
>As part of our nightwork batch processing, a bunch of reports are run
>against the DB.
>I have a DBMS_JOB which reports when processes are waiting for events like
>"db file sequential read". I typically get an email showing about 2 dozen
>sessions
>with wait times of 3 - 15 seconds all of which are doing one block reads
>against
>P_INVLOC; which is the Primary Key for the Inventory_Location table. This
>index
>has INITRANS=31 & FREELISTS=31. This is a decent sized index at about
>128MB.
>
>I'm open for suggestion WRT what else can & could be done to eliminate or
>reduce these waits.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: Charlie_Mengler_at_HomeDepot.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infosys.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

• = = = = = = = = = = = = = = = = = = =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).