Re: direct read is much faster than scattered read, is it reasonable?
- From: zhuchao@xxxxxxxxx
- To: staywithpin@xxxxxxxxx,"oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 28 May 2008 12:39:42 +0000
R29vZCBxdWVzdGlvbi4NCk1vc3QgbGlrZWx5LCBkaXJlY3QgcGF0aCByZWFkIGlzIGFzeW5jIHJl
YWQsIHdoaWxlIGFsbCBvdGhlciBhcmUgc3luYyByZWFkLiBTbyByaWdodCBhZnRlciBvcmFjbGUg
aXNzdWUgdGhlIHJlYWQgcmVxdWVzdCwgaXQgaXMgYWJsZSB0byBkbyBzb21ldGhpbmcgZWxzZS4N
ClRydXNzIC1wICRwaWQgc2hvdWxkIHNlZSBrYWlvIGZvciBkaXJlY3QgcGF0aCByZWFkLCBhbmQg
cHJlYWQgZm9yIGRiIGZpbGUgeHh4IHJlYWQuDQpKdXN0IG15IGd1ZXNzIHRob3VnaA0KU2VudCB2
aWEgQmxhY2tCZXJyeSBieSBBVCZUDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9t
OiAicWlodWEgd3UiIDxzdGF5d2l0aHBpbkBnbWFpbC5jb20+DQoNCkRhdGU6IFdlZCwgMjggTWF5
IDIwMDggMTc6NDU6NTkgDQpUbzpvcmFjbGUtbCA8b3JhY2xlLWxAZnJlZWxpc3RzLm9yZz4NClN1
YmplY3Q6IGRpcmVjdCByZWFkIGlzIG11Y2ggZmFzdGVyIHRoYW4gc2NhdHRlcmVkIHJlYWQsIGlz
IGl0IHJlYXNvbmFibGU/DQoNCg0KSSBleGVjdXRlZCB0aGVzZSBzcWwgb24gbXkgZGF0YWJhc2U6
CgpTUUw+oCBzZWxlY3QgdGltZV93YWl0ZWRfbWljcm8vdG90YWxfd2FpdHMvMTAwMDAwMCBmcm9t
IHYkc3lzdGVtX2V2ZW50oCB3aGVyZSBldmVudF9pZCBpbiAoc2VsZWN0IGV2ZW50X2lkIGZyb20g
diRldmVudF9uYW1lIHdoZXJlIG5hbWU9J2RpcmVjdCBwYXRoIHJlYWQnKTsKClRJTUVfV0FJVEVE
X01JQ1JPL1RPVEFMX1dBSVRTLzEwMDAwMDAKIC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0KoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgLjAwMDUwMzM0MgoKU1FMPiBzZWxl
Y3QgdGltZV93YWl0ZWRfbWljcm8vdG90YWxfd2FpdHMvMTAwMDAwMCBmcm9tIHYkc3lzdGVtX2V2
ZW50oCB3aGVyZSBldmVudF9pZCBpbiAoc2VsZWN0IGV2ZW50X2lkIGZyb20gdiRldmVudF9uYW1l
IHdoZXJlIG5hbWU9J2RiIGZpbGUgc2NhdHRlcmVkIHJlYWQnKTsKIApUSU1FX1dBSVRFRF9NSUNS
Ty9UT1RBTF9XQUlUUy8xMDAwMDAwCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0KoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgLjAwMTgxODgwMwoKCgpXZSBjb3VsZCBzZWU6
oCB0byBhY2Nlc3Mgb25lIGJsb2NrIHVzaW5nIHNjYXR0ZXJlcmQgcmVhZCygIGl0IHdpbGwgdGFr
ZSAxLjggbXMsoCBidXQgd2hlbiBhY2Nlc3Mgb25lIGJsb2NrIHVzaW5nICJkaXJlY3QgcGF0aCBy
ZWFkIiwgaXQgb25seSB0YWtlcyAwLjVtcy6gIEhvdyBjb3VsZCBkaXJlY3QgcGF0aCByZWFkIG11
Y2ggbXVjaCBxdWlja2VyIHRoYW4gc2NhdHRlcmVyIHJlYWQ/IElzbid0IHRoZSBzY2F0dGVyZWQg
cmVhZCB0aGUgZmFzdGVzdCBtZXRob2QgdG8gYWNjZXNzIGRhdGEgYmxvY2s/oCBPdXIgc3lzdGVt
IHVzZXMgU0FOIHN0b3JhZ2UsIGFuZCBTQU4gY291bGQgcHJlLWZldGNoIHRvIHNwZWVkLXVwIHRo
ZSBibG9jayBhY2Nlc3MuIEJ1dCBJIHRoaW5rIGl0IHByZS1mZXRjaCB3aWxsIGhlbHAgYm90aCBz
Y2F0dGVyZWQgcmVhZCBhbmQgZGlyZWN0IHBhdGggcmVhZCwgYW0gSSByaWdodD8KIApUaGFua3Ms
ClFpaHVhCiA=
--
//www.freelists.org/webpage/oracle-l
Other related posts:
