Default block size is 512 bytes if the filesystem is NTFS for W2K. If you happen to use Fat32, it depends on the size of the partition. I believe for a 40G to 60G FAT32 partition it is 32K.
--- Todd Carlson <[EMAIL PROTECTED]> wrote: > If I remember right the default W2K block size is .5K. > The max IO size depends on the RAID controllers used. > > What, you don't like the GUI? ;-) > > > Todd Carlson > Oracle Database Administrator > Tripos, Inc. > (314) 647-8837 Ext.3246 > > -----Original Message----- > Lisa > Sent: Friday, April 26, 2002 3:31 PM > To: Multiple recipients of list ORACLE-L > warehouse? > > Can anyone tell me how to figure out the file system block size and > max > i/o > size of a Windows 2000 system? My sysadmin had no clue. (Gosh, > can't > imagine why, everything's hidden behind that stupid gui) > > Thanks in advance for any replies > > Lisa Koivu > Oracle Database Baby Oven > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > -----Original Message----- > > From: Gaja Krishna Vaidyanatha [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, April 26, 2002 12:49 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: What block size are you using for your new 9i data > > warehouse? > > > > All, > > > > Something to keep in mind regardless of whether you > > are using 9i or not. This issue becomes more relevant > > in 9i with "multiple block sizes" for different > > tablespaces. > > > > You always want to ensure that your DB_BLOCK_SIZE = > > File System Block Size. This is to avoid wasted I/O > > and also the case where the "read ahead algorithm" is > > triggered accidentally, when 1 Database Block results > > in multiple file system blocks being read from disk. > > > > If your application performs range scans, there is a > > high possibility that multiple "single database block" > > read requests to a set of contiguous blocks, may > > result in the "read ahead algorithm" performing 128K > > or 256K pre-fetches, even though your application may > > have not required all 128K or 256K. > > > > This problem is rampant on ufs file systems where the > > default block size is 512 bytes, and with a 8K > > DB_BLOCK_SIZE, it takes 16 file system blocks to store > > 1 DB block on disk. However, even if you have advanced > > file systems and have a 1-is-to-2 ratio of DB block > > is-to FS blocks, you are still in danger of > > overloading your I/O sub-system, "under the right > > conditions". > > > > If you are using a volume manager product such as > > Veritas, and if your version of the volume manager > > supports "dynamic file system block sizing" based on > > size of the file system or the files themselves, > > please pay close attention to that detail and make > > sure that the file system block size does not exceed > > the database block size (based on the size of the file > > system). > > > > Best regards, > > > > Gaja > > > > --- Johnson Poovathummoottil <[EMAIL PROTECTED]> > > wrote: > > > We too have a data warehouse close to 500GB in size. > > > We upgraded the OS solaris 2.8 and our block size is > > > 16K. All our data and index tablespaces datafiles > > > are > > > spread across 20 files systems whose disks are on > > > EMC > > > storage. We too user veritas volume manager. File > > > systems use four 9 GB disks whaich are raid S and > > > software stripe uinit size of 256 KB. > > > > > > reasons > > > 16K block size as we have many full table scan ans > > > sequential reads. > > > 256 KB stripe unit size because we have set the > > > db_file_multi_block_read_count to 64(1MB) > > > > > > we are moving to a sun fire 15K machine soon and > > > then > > > the we will go to 9i 64 bit. > > > > > > --- "Toepke, Kevin M" <[EMAIL PROTECTED]> > > > wrote: > > > > Cherie: > > > > > > > > If you are using Oracle 9i, you can use mutliple > > > > block sizes! You still > > > > create your database with a default block size, > > > but > > > > each tablespace (except > > > > system) can have a block size different from the > > > > default. > > > > > > > > Valid blocksizes are limited by OS, but they range > > > > from 2K to 32k. > > > > > > > > Check out the 9i docs for CREATE TABLESPACE for > > > more > > > > info. > > > > > > > > Caver > > > > > > > > -----Original Message----- > > > > Sent: Thursday, April 25, 2002 11:24 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > > We are building a new version 9.0.1 data warehouse > > > > on Sun Solaris 2.6 > > > > migrating to Solaris 2.8. We will be using > > > striped > > > > disk that is striped > > > > using Veritas Volume Manager on EMC disk. > > > > > > > > The datawarehouse will be about 200 Gig. It will > > > > be written to throughout > > > > the day. > > > > > > > > To this point, almost all of our databases have > > > been > > > > created with an 8k > > > > block size. i'm not sure if that blocksize is > > > > optimal anymore. With 9i, > > > > what block sizes are people using in the field > > > > nowadays for data > > > > warehouses? > > > > > > > > Also, if you use striped disk, what stripe size > > > are > > > > you using and why? > > > > > > > > Thanks for weighing in on this topic. > > > > > > > > Cherie Machler > > > > Oracle DBA > > > > Gelco Information Network > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > > http://www.orafaq.com > > > > -- > > > > Author: > > > > INET: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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: Toepke, Kevin M > > > > INET: [EMAIL PROTECTED] > > > > > > > > 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: [EMAIL PROTECTED] (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). > > > > > > > > > __________________________________________________ > > > Do You Yahoo!? > > > Yahoo! Games - play chess, backgammon, pool and more > > > http://games.yahoo.com/ > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Johnson Poovathummoottil > > > INET: [EMAIL PROTECTED] > > > > > > 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: [EMAIL PROTECTED] (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). > > > > > > ===== > > Gaja Krishna Vaidyanatha > > Director, Storage Management Products, > > Quest Software, Inc. > > Co-author - Oracle Performance Tuning 101 > > http://www.osborne.com/database_erp/0072131454/0072131454.shtml > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Games - play chess, backgammon, pool and more > > http://games.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Gaja Krishna Vaidyanatha > > INET: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Koivu, Lisa > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Todd Carlson > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). ===== Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).