RE: Anyone using multi-block sizes for their databases

  • From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
  • To: <ArnoldS@xxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 21 Jul 2005 18:42:55 +0200

Hi Sandra,
 
... and the immediate counter-question is: *why* are you thinking about this?
 
by the way, the answer to your question is:
"yes. to start with, you have to configure a segmented buffer cache"


kind regards,

Lex.

------------------------------------------------------------------
Steve Adams Seminar  <http://www.naturaljoin.nl/events/seminars.html>
http://www.naturaljoin.nl/events/seminars.html
------------------------------------------------------------------ 

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Arnold, Sandra
Sent: Thursday, July 21, 2005 18:00
To: oracle-l@xxxxxxxxxxxxx
Subject: Anyone using multi-block sizes for their databases



I am thinking about using multi-block sizes for my different tablespaces in my
10g database that will be used for data warehouse type applications.  Has anyone
used this in 9i and/or 10g?  If so, is there anything special you have to do
with any of the init.ora parameters?  Or, anything else special?

 

Thanks,

Sandra Arnold

Principal DBA

NCI Information Systems

Oak Ridge, TN

BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583 
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD

Other related posts: