Re: buffer cache -once again

Just a throwaway idea - if you set a 128K extent size (minimum extent length, or initial = next) on an 8K block size, then oracle would round up to the next multiple of 5 blocks - which would be 160K - viz 20 blocks.

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr

One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____Denmark__May 21-23rd
____Sweden___June
____Finland__September
____Norway___September

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html

____UK_(Manchester)_May x 2
____Estonia___June 4th - 6th
____Australia_June 18th - 20th (Perth)
____Australia_June 23rd - 25th (t.b.a)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 12 May 2003 17:27

>
> This is on several SAP systems with DD managed extents.
>
> Std extent size? What's that? ;)
>
> I'll run it again to be sure, I could be misrembering the results.
>
> Jared
>
> On Sunday 11 May 2003 02:16, Niall Litchfield wrote:
> > No.
> >
> > On a SAN attached Compaq box at work I get 128, which with an 8k
block
> > size, is = 1mb or SSTIOMAX. My box at home has a max effective and
> > achieved MBRC of 64 (or 512k). 20 blocks isn't a standard extent
size
> > for you by any chance?
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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).