maxphys in solaris is what I my DB_FILE_MULTI_BLOCK_READ_COUNT * BLOCK_SIZE should be correct?
wher do I found the maxphys parameter in solaris?
>
> From: "zhu chao" <chao_ping_at_vip.163.com>
> Date: 2003/05/08 Thu AM 04:36:57 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: buffer cache -once again
>
> Hi,
> With db file scattered read, if it is not a datawarehouse db, you must tune your SQL. It means there is a lot of full table scan/full index scan.
> If the full table scan is necessary, then increasing db_file_multiblock_read_count is good. Though it is still the no.1 wait event, pay attention to the ratio of this event waited.If the ratio decreased, it means you are doing good.right?
> Tune some os parameter like stripe size, maxphys(in solaris, not knowing the corresponding parameter in aix) will also help.
>
> Regards
> zhu chao
> msn:chao_ping_at_163.com
> www.cnoug.org(China Oracle User Group)
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 08, 2003 2:36 PM
>
>
> > Dennis,
> >
> > earlier my buffer cache was 300MB that time the cache hit ratio was 81%
> > ,so i thought to increase the size by 100mb and incresed .but again the
> > cache hit ratio is 81%.means the problem
> > is not the buffer cache.
> >
> > the top wait event is 'db file scattered read' ,i increased the
> > db_file_multiblock_read_count from 16 to 64 but still this the top one wait
> > event.
> >
> > db version is 8.0.5 ,OS is AIX 4.3 on RS/6000.
> >
> >
> > pls suggest if need to correct something ...
> >
> > Thanks
> >
> >
> > Arvind
> >
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, May 06, 2003 7:42 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Arvind
> > What makes you suspect you've configured your buffer cache too large? A
> > better question might be "how can I tell if my buffer cache is properly
> > sized?". Start by checking your wait times. What are your top 3 waits? Also,
> > what is your (cough, cough) average buffer hit ratio?
> >
> > Dennis Williams
> > DBA, 60%OCP, 100% DBA
> > Lifetouch, Inc.
> > dwilliams_at_lifetouch.com
> >
> >
> > -----Original Message-----
> > Sent: Tuesday, May 06, 2003 4:37 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Dear All,
> >
> > how can i check if my buffer cache is bigger than necessary ?oracle db
> > version is 8.1.7.
> >
> >
> > Thanks
> >
> >
> > Arvind
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Arvind Kumar
> > INET: arvindk_at_sqlstarintl.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.net
> > --
> > Author: DENNIS WILLIAMS
> > INET: DWILLIAMS_at_LIFETOUCH.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.net
> > --
> > Author: Arvind Kumar
> > INET: arvindk_at_sqlstarintl.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.net
> --
> Author: zhu chao
> 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).
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net
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).
Received on Thu May 08 2003 - 07:46:37 CDT
