alter session set db_file_multiblock_read_count =
32768;
enable event 10046 at level 8
do a large full scan
check the trace file, 'p3' tells you the max mb count
it could use, and thus the max io (from oracle's
perspective)
hth
connor
- "Koivu, Lisa" <lisa.koivu_at_efairfield.com> wrote: >
Um.... that was something I relied upon my trusty
> SA to tell me.
> I can't answer that. Sorry. Anyone know? I do
> know how to determine this
> is different between platforms.
>
> Lisa
>
> > -----Original Message-----
> > From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]
> > Sent: Monday, June 25, 2001 11:12 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: db_file_multiblock_read_count
> >
> > How do you tell for sure what the max i/o size is
> set to?
> >
> > -----Original Message-----
> > Sent: Monday, June 25, 2001 9:23 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > Hi Liam,
> >
> > 1. Setting db_file_multiblock_count to a number
> that when multiplied by
> > your block size is greater than your max i/o size
> on your host will
> > encourage full table scans. I also read somewhere
> else about the effects
> > of
> > doing this, I know there's more to it than what
> I've stated, but I don't
> > remember off the top of my head (pre-coffee and
> post-run this am)
> >
> > 2. vmstat - look at the two columns that start
> with pg. Read the man
> > page
> > and it will explain it to you in detail. Also,
> when you use vmstat be sure
> > to give it an interval (like vmstat 2 10 - this
> means display stats once
> > every 2 seconds for a duration of 10 seconds).
> The first line returned by
> > vmstat will always be garbage (same with iostat).
> >
> > HTH
> > Lisa Koivu
> > Petite Clumsy Ninja-ette
> > Ft. Lauderdale, FL, USA
> >
> > -----Original Message-----
> > Sent: Monday, June 25, 2001 8:36 AM
> > To: Multiple recipients of list ORACLE-L
> >
> > Listers,
> >
> > I am attempting to tune a 7.3.4 OLTP database and
> I have a couple of
> >
> > questions.
> >
> > 1. The db_file_multiblock_count is 64 which seems
> way too high to
> > me. What
> > are the consequences, if any, of setting this
> parameter too high?
> >
> > 2. I want to increase the SGA to be 20% of the
> available memory
> > (currently
> > about 10%). Once I've made the change how can I
> tell if the Unix machine
> > is
> > paging memory without a fancy GUI tool?
> >
> > Many thanks in advance,
> > Liam
> >
>
>
> > Get Your Private, Free E-mail from MSN Hotmail at
> http://www.hotmail.com
> > <http://www.hotmail.com> .
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > <http://www.orafaq.com>
> > --
> > Author: Liam Morrin
> > INET: dba37_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
>
> > 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: Smith, Ron L.
> > INET: rlsmith_at_kmg.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> > San Diego, California -- Public Internet
> access / Mailing Lists
> >
>
> > 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).
>
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Mon Jun 25 2001 - 12:14:09 CDT
