| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace block size limit / Windows
Lisa,
Tried creating a windoze db some years ago, Oracle 7.3.4. The app = vendor recommended 32k or larger block size for performance reasons. = Oracle barfed all over the place because of the 32K block size. The = vendor's tech support told us to use 2K block size because of windoze. = So I guess that limitation has been known about for a while.
Also shows that the sales & post sales tech droids don't always know = what their talking about.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Koivu, Lisa [mailto:Lisa.Koivu_at_Cendant-TRG.com]
Sent: Tuesday, February 03, 2004 12:37 PM
To: oracle-l_at_freelists.org
Subject: Tablespace block size limit / Windows
Hi everyone,=3D20
Windows 2003 Server Enterprise Edition, 9204, with disks allocated from 2 Clariion SANs
Several of these disks were formatted at 32k and 64k block size. I was under the impression the limitation on tablespace block size came from the os block size. I can't create a tablespace with a block size greater than 16k, it fails. =3D20
Metalink says this is a limitation of Windows.=3D20
Anyone run into this, and if so, are there any creative ways around this limit? I can't even open a TAR. It keeps kicking me out. Googling this returns nothing useful.
Thanks
Lisa Koivu
desk: 407-248-4277
cell: 954-683-4459=3D20
"The sender believes that this E-Mail and any attachments were free of =
=3D
any virus, worm, Trojan horse, and/or malicious code when sent. This =3D
message and its attachments could have been infected during =3D
transmission. By reading the message and opening any attachments, the =
=3D
recipient accepts full responsibility for taking proactive and remedial =
=3D
action about viruses and other defects. The sender's business entity is =
=3D
not liable for any loss or damage arising in any way from this message =
=3D
or its attachments."
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Feb 03 2004 - 12:51:21 CST
 |
 |