RE: optimal tablespace blocksize

This method may work well if you don't know much about the application tables or want a sledgehammer approach, but if you know the tables involved, and know how they are used, you will get more performance gains out of the pctfree, pctused, initrans and initial/next extent settings.

-----Original Message-----
Sent: Tuesday, April 22, 2003 9:47 AM
To: Multiple recipients of list ORACLE-L

I got this off a recent presentation:

    Marks out of 10 anyone ?

<<quote>>
The database block size is determined once the database is created.

Larger blocksize is better for reading

Smaller blocksize reduces contention on
update intensive systems.

So what is the optimal blocksize for you ?

    Larger is better

<<end quote>>

The bit I really don't understand is what is so good about increasing the contention on my update intensive system ;)

(Warning to OP - don't take this seriously)

Regards

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

____UK_______April 22nd
____USA_(FL)_May 2nd
____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 (provisional)
____Australia_June (provisional)
____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: 22 April 2003 16:36

> Dead easy, same as the database block size should be identified.
Different
> block sizes are designed only for transporting tablespaces from an
OLTP
> system to a staging database before summarization into a data
warehouse.
> There is so little in the way of performance gains in using
different block
> sizes for different objects that there are far more important tuning
efforts
> to be done before even considering this as a tuning tool.
>
> Pete

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nick Wagner
  INET: Nick.Wagner_at_quest.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).