RE: Tablespace block size limit / Windows
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: 'Jan Benjamins' <j.benjamins@xxxxxxx>,"'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Feb 2004 15:37:52 -0600
Jan - Zhu's message came through fine for me. Maybe you don't receive text
only? Your comment was funny anyway.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@xxxxxxxxxxxxx
From: zhu chao [mailto:chao_ping@xxxxxxxxxxx]
Sent: Tuesday, February 03, 2004 3:16 PM
To: oracle-l@xxxxxxxxxxxxx; DENNIS WILLIAMS
Subject: Re: Tablespace block size limit / Windows
Hi, lisa:
On linux/win, you simply cannot create tablespace with 32k blocksize, it
is documented in oracle doc.
Instead, you can use more datafiles/large db_file_multiblock_read_count
to enhance your multiblock read performance.
Regards
Zhu Chao.
-----Original Message-----
From: Jan Benjamins [mailto:j.benjamins@xxxxxxx]
Sent: Tuesday, February 03, 2004 3:34 PM
To: oracle-l@xxxxxxxxxxxxx; DENNIS WILLIAMS
Subject: Re: Tablespace block size limit / Windows
I really appreciate you wish to share this with all of us, it must have been
a tough day :)
----- Original Message -----
From: "zhu chao" <chao_ping@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; <dwilliams@xxxxxxxxxxxxx>
Sent: Tuesday, February 03, 2004 10:16 PM
Subject: Re: Tablespace block size limit / Windows
SGksIGxpc2E6DQogICAgT24gbGludXgvd2luLCB5b3Ugc2ltcGx5IGNhbm5vdCBjcmVhdGUgdGFi
bGVzcGFjZSB3aXRoIDMyayBibG9ja3NpemUsIGl0IGlzIGRvY3VtZW50ZWQgaW4gb3JhY2xlIGRv
Yy4NCiAgICBJbnN0ZWFkLCB5b3UgY2FuIHVzZSBtb3JlIGRhdGFmaWxlcy9sYXJnZSBkYl9maWxl
X211bHRpYmxvY2tfcmVhZF9jb3VudCB0byBlbmhhbmNlIHlvdXIgbXVsdGlibG9jayByZWFkIHBl
cmZvcm1hbmNlLg0KICAgIFJlZ2FyZHMNClpodSBDaGFvLg0KDQotLS0tLSBPcmlnaW5hbCBNZXNz
YWdlIC0tLS0tIA0KRnJvbTogIktvaXZ1LCBMaXNhIiA8TGlzYS5Lb2l2dUBDZW5kYW50LVRSRy5j
b20+DQpUbzogPG9yYWNsZS1sQGZyZWVsaXN0cy5vcmc+OyA8ZHdpbGxpYW1zQGxpZmV0b3VjaC5j
b20+DQpTZW50OiBXZWRuZXNkYXksIEZlYnJ1YXJ5IDA0LCAyMDA0IDQ6MDUgQU0NClN1YmplY3Q6
IFJFOiBUYWJsZXNwYWNlIGJsb2NrIHNpemUgbGltaXQgLyBXaW5kb3dzDQoNCg0KPiBIaSBEZW5u
aXMsPTIwDQo+IA0KPiBJdCB0aHJvd3MgYSBkaWZmZXJlbnQgZXJyb3Igd2hlbiB5b3UgdHJ5IHRv
IGNyZWF0ZSBhIHRhYmxlc3BhY2Ugd2l0aCBhDQo+IGJsb2NrIHNpemUgdGhhdCBoYXNuJ3QgYmVl
biBhY2NvdW50ZWQgZm9yIGluIHRoZSBpbnN0YW5jZS4gIE1ldGFsaW5rDQo+IGJsYXRhbnRseSBz
YXlzICIxNmsgaXMgYSBsaW1pdGF0aW9uIG9mIFdpbmRvd3MiLiAgQWxsIEkgY2FuIGhvcGUsIGhv
cGUsDQo+IGhvcGUgZm9yIGlzIHRoYXQgZXZlbnR1YWxseSB0aGlzIHdpbGwgYmUgb25lIGxldmVy
IHdlIGNhbiB1c2UgdG8gcHVzaA0KPiB0aGlzIGRhdGFiYXNlIG9mZiBvZiBXaW5kb3dzIGFuZCBv
bnRvIExpbnV4Lg0KPiANCj4gSSd2ZSBiZWVuIGFibGUgdG8gZG8gdGhpcyBvbiBteSBkZXYgZW52
aXJvbm1lbnQsIHdoZXJlIEkgaGF2ZQ0KPiB0YWJsZXNwYWNlcyB0aGF0IGFyZSA4ayBhbmQgMTZr
LiAgSSBjb3VsZCBub3QgY3JlYXRlIDMyaysgdGFibGVzcGFjZXMNCj4gdGhlcmUsIGVpdGhlciAo
c3VycHJpc2UpLg0KPiANCj4gU3RheSB3YXJtIHVwIHRoZXJlISENCj4gTGlzYQ0KPiANCj4gLS0t
LS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTogREVOTklTIFdJTExJQU1TIFttYWlsdG86
RFdJTExJQU1TQExJRkVUT1VDSC5DT01dPTIwDQo+IFNlbnQ6IFR1ZXNkYXksIEZlYnJ1YXJ5IDAz
LCAyMDA0IDI6NDMgUE0NCj4gVG86ICdvcmFjbGUtbEBmcmVlbGlzdHMub3JnJw0KPiBTdWJqZWN0
OiBSRTogVGFibGVzcGFjZSBibG9jayBzaXplIGxpbWl0IC8gV2luZG93cw0KPiANCj4gTGlzYQ0K
PiAgICBQbGVhc2UgZXhjdXNlIHRoZSBkdW1iIHF1ZXN0aW9uLCBidXQgSSdsbCBhc2sganVzdCB0
byBiZSBzYWZlLiBBcmUNCj4geW91DQo+IHRyeWluZyB0byBjcmVhdGUgYSB0YWJsZXNwYWNlIHdp
dGggYSBibG9jayBzaXplIGRpZmZlcmVudCBmcm9tIHlvdXINCj4gaW5zdGFuY2UncyBibG9jayBz
aXplPyBBcmUgeW91IGFibGUgdG8gY3JlYXRlIGEgdGFibGVzcGFjZSB3aXRoIGFueQ0KPiBkaWZm
ZXJlbnQgc2l6ZT8gSSBhbHNvIGRpbWx5IHJlY2FsbCBzb21ldGhpbmcgYWJvdXQgV2luZG93cyBh
bmQgYmxvY2sNCj4gc2l6ZSwNCj4gYnV0IHNpbmNlIEkgZG9uJ3QgdXNlIE9yYWNsZSBvbiBXaW5k
b3dzIHNvIEkgcHJvbXB0bHkgZm9yZ290IGl0Lg0KPiANCj4gRGVubmlzIFdpbGxpYW1zDQo+IERC
QQ0KPiBMaWZldG91Y2gsIEluYy4NCj4gZHdpbGxpYW1zQGxpZmV0b3VjaC5jb209MjANCj4gDQo+
IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+IEZyb206IEtvaXZ1LCBMaXNhIFttYWlsdG86
TGlzYS5Lb2l2dUBDZW5kYW50LVRSRy5jb21dDQo+IFNlbnQ6IFR1ZXNkYXksIEZlYnJ1YXJ5IDAz
LCAyMDA0IDExOjM3IEFNDQo+IFRvOiBvcmFjbGUtbEBmcmVlbGlzdHMub3JnDQo+IFN1YmplY3Q6
IFRhYmxlc3BhY2UgYmxvY2sgc2l6ZSBsaW1pdCAvIFdpbmRvd3MNCj4gDQo+IA0KPiBIaSBldmVy
eW9uZSw9M0QyMA0KPiANCj4gV2luZG93cyAyMDAzIFNlcnZlciBFbnRlcnByaXNlIEVkaXRpb24s
IDkyMDQsIHdpdGggZGlza3MgYWxsb2NhdGVkIGZyb20NCj4gMiBDbGFyaWlvbiBTQU5zDQo+IA0K
PiBTZXZlcmFsIG9mIHRoZXNlIGRpc2tzIHdlcmUgZm9ybWF0dGVkIGF0IDMyayBhbmQgNjRrIGJs
b2NrIHNpemUuICBJIHdhcw0KPiB1bmRlciB0aGUgaW1wcmVzc2lvbiB0aGUgbGltaXRhdGlvbiBv
biB0YWJsZXNwYWNlIGJsb2NrIHNpemUgY2FtZSBmcm9tDQo+IHRoZSBvcyBibG9jayBzaXplLiAg
SSBjYW4ndCBjcmVhdGUgYSB0YWJsZXNwYWNlIHdpdGggYSBibG9jayBzaXplDQo+IGdyZWF0ZXIg
dGhhbiAxNmssIGl0IGZhaWxzLiA9M0QyMA0KPiANCj4gTWV0YWxpbmsgc2F5cyB0aGlzIGlzIGEg
bGltaXRhdGlvbiBvZiBXaW5kb3dzLj0zRDIwDQo+IA0KPiBBbnlvbmUgcnVuIGludG8gdGhpcywg
YW5kIGlmIHNvLCBhcmUgdGhlcmUgYW55IGNyZWF0aXZlIHdheXMgYXJvdW5kIHRoaXMNCj4gbGlt
aXQ/ICBJIGNhbid0IGV2ZW4gb3BlbiBhIFRBUi4gIEl0IGtlZXBzIGtpY2tpbmcgbWUgb3V0LiAg
R29vZ2xpbmcNCj4gdGhpcyByZXR1cm5zIG5vdGhpbmcgdXNlZnVsLg0KPiANCj4gVGhhbmtzDQo+
IA0KPiBMaXNhIEtvaXZ1DQo+IGRlc2s6IDQwNy0yNDgtNDI3Nw0KPiBjZWxsOiA5NTQtNjgzLTQ0
NTk9M0QyMA0KPiANCj4gDQo+IA0KPiAiVGhlIHNlbmRlciBiZWxpZXZlcyB0aGF0IHRoaXMgRS1N
YWlsIGFuZCBhbnkgYXR0YWNobWVudHMgd2VyZSBmcmVlIG9mID0NCj4gPTNEDQo+IGFueSB2aXJ1
cywgd29ybSwgVHJvamFuIGhvcnNlLCBhbmQvb3IgbWFsaWNpb3VzIGNvZGUgd2hlbiBzZW50LiBU
aGlzID0zRA0KPiBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMgY291bGQgaGF2ZSBiZWVuIGlu
ZmVjdGVkIGR1cmluZyA9M0QNCj4gdHJhbnNtaXNzaW9uLiAgQnkgcmVhZGluZyB0aGUgbWVzc2Fn
ZSBhbmQgb3BlbmluZyBhbnkgYXR0YWNobWVudHMsIHRoZSA9DQo+ID0zRA0KPiByZWNpcGllbnQg
YWNjZXB0cyBmdWxsIHJlc3BvbnNpYmlsaXR5IGZvciB0YWtpbmcgcHJvYWN0aXZlIGFuZCByZW1l
ZGlhbA0KPiA9M0QNCj4gYWN0aW9uIGFib3V0IHZpcnVzZXMgYW5kIG90aGVyIGRlZmVjdHMuIFRo
ZSBzZW5kZXIncyBidXNpbmVzcyBlbnRpdHkgaXMNCj4gPTNEDQo+IG5vdCBsaWFibGUgZm9yIGFu
eSBsb3NzIG9yIGRhbWFnZSBhcmlzaW5nIGluIGFueSB3YXkgZnJvbSB0aGlzIG1lc3NhZ2UgPQ0K
PiA9M0QNCj4gb3IgaXRzIGF0dGFjaG1lbnRzLiINCj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gUGxlYXNlIHNl
ZSB0aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5jb20NCj4gLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLQ0KPiBUbyB1bnN1YnNjcmliZSBzZW5kIGVtYWlsIHRvOiAgb3JhY2xlLWwtcmVxdWVzdEBm
cmVlbGlzdHMub3JnDQo+IHB1dCAndW5zdWJzY3JpYmUnIGluIHRoZSBzdWJqZWN0IGxpbmUuDQo+
IC0tDQo+IEFyY2hpdmVzIGFyZSBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvYXJjaGl2ZXMv
b3JhY2xlLWwvDQo+IEZBUSBpcyBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvaGVscC9mb20t
c2VydmUvY2FjaGUvMS5odG1sDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gUGxlYXNlIHNlZSB0
aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5jb20NCj4gLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LQ0KPiBUbyB1bnN1YnNjcmliZSBzZW5kIGVtYWlsIHRvOiAgb3JhY2xlLWwtcmVxdWVzdEBmcmVl
bGlzdHMub3JnDQo+IHB1dCAndW5zdWJzY3JpYmUnIGluIHRoZSBzdWJqZWN0IGxpbmUuDQo+IC0t
DQo+IEFyY2hpdmVzIGFyZSBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvYXJjaGl2ZXMvb3Jh
Y2xlLWwvDQo+IEZBUSBpcyBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvaGVscC9mb20tc2Vy
dmUvY2FjaGUvMS5odG1sDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IA0KPiAiVGhlIHNlbmRlciBiZWxpZXZlcyB0
aGF0IHRoaXMgRS1NYWlsIGFuZCBhbnkgYXR0YWNobWVudHMgd2VyZSBmcmVlIG9mID0NCj4gYW55
IHZpcnVzLCB3b3JtLCBUcm9qYW4gaG9yc2UsIGFuZC9vciBtYWxpY2lvdXMgY29kZSB3aGVuIHNl
bnQuIFRoaXMgPQ0KPiBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMgY291bGQgaGF2ZSBiZWVu
IGluZmVjdGVkIGR1cmluZyA9DQo+IHRyYW5zbWlzc2lvbi4gIEJ5IHJlYWRpbmcgdGhlIG1lc3Nh
Z2UgYW5kIG9wZW5pbmcgYW55IGF0dGFjaG1lbnRzLCB0aGUgPQ0KPiByZWNpcGllbnQgYWNjZXB0
cyBmdWxsIHJlc3BvbnNpYmlsaXR5IGZvciB0YWtpbmcgcHJvYWN0aXZlIGFuZCByZW1lZGlhbCA9
DQo+IGFjdGlvbiBhYm91dCB2aXJ1c2VzIGFuZCBvdGhlciBkZWZlY3RzLiBUaGUgc2VuZGVyJ3Mg
YnVzaW5lc3MgZW50aXR5IGlzID0NCj4gbm90IGxpYWJsZSBmb3IgYW55IGxvc3Mgb3IgZGFtYWdl
IGFyaXNpbmcgaW4gYW55IHdheSBmcm9tIHRoaXMgbWVzc2FnZSA9DQo+IG9yIGl0cyBhdHRhY2ht
ZW50cy4iDQo+IA0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQo+IFBsZWFzZSBzZWUgdGhlIG9mZmljaWFsIE9SQUNMRS1M
IEZBUTogaHR0cDovL3d3dy5vcmFmYXEuY29tDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gVG8gdW5zdWJzY3JpYmUg
c2VuZCBlbWFpbCB0bzogIG9yYWNsZS1sLXJlcXVlc3RAZnJlZWxpc3RzLm9yZw0KPiBwdXQgJ3Vu
c3Vic2NyaWJlJyBpbiB0aGUgc3ViamVjdCBsaW5lLg0KPiAtLQ0KPiBBcmNoaXZlcyBhcmUgYXQg
aHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL2FyY2hpdmVzL29yYWNsZS1sLw0KPiBGQVEgaXMgYXQg
aHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL2hlbHAvZm9tLXNlcnZlL2NhY2hlLzEuaHRtbA0KPiAt
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLQ0KPiANCj4g
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
