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