Re: db file parallel read for prefetching?
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: Joze.Senegacnik@xxxxxx, tanel.poder.003@xxxxxxx
- Date: Tue, 29 Nov 2005 23:16:59 +0800
VGhhbmtzIEpvemUgYW5kIFRhbmVsIGZvciB5b3VyIGdyZWF0IGRvY3VtZW50IQoKSSBjb25maXJt
ZWQgd2l0aCAxMDI5OSB0aGF0IGZvciB0aGUgZmFzdCBkYXRhYmFzZSwgb3JhY2xlIGlzIHVzaW5n
CnByZWZldGNoICwgYnV0IGZvciB0aGUgc2xvdyBkYXRhYmFzZSwgaXQgaXMgbm90IHVzaW5nIHBy
ZWZldGNoLgoKVGhlIGN1cnJlbnQgcHJvYmxlbSBpcywgaG93IGRvIEkgZm9yY2Ugc2Vzc2lvbiB0
byB1c2UgcHJlZmV0Y2gsIHNpbmNlCml0IGRvZXMgaGVscCBpbXByb3ZlIHBlcmZvcm1hbmNlIG9m
IG15IGFwcGxpY2F0aW9uLgoKSSB0cmllZCA6CmFsdGVyIHNlc3Npb24gc2V0ICJfaW5kZXhfcHJl
ZmV0Y2hfZmFjdG9yIj0xOwpidXQgaXQgZGlkIG5vdCBoZWxwLgoKVGhhbmtzIHlvdSEKClRyYWNl
IGZpbGUgbG9vayBsaWtlOgpXQUlUICMxOiBuYW09J2RiIGZpbGUgc2VxdWVudGlhbCByZWFkJyBl
bGE9IDQ1MjE3IHAxPTU5MyBwMj02ODM5NCBwMz0xCkZFVENIICMxOmM9MTAwMDAsZT0xMTAzODU3
LHA9NTUsY3I9NTYsY3U9MCxtaXM9MCxyPTE1LGRlcD0wLG9nPTQsdGltPTQwMjMyMTUwODU3MTcK
V0FJVCAjMTogbmFtPSdTUUwqTmV0IG1lc3NhZ2UgZnJvbSBjbGllbnQnIGVsYT0gMTEyNCBwMT0x
NjUwODE1MjMyIHAyPTEgcDM9MApvbGRfcmVhZGluZz05MCBuZXdfcmVhZGluZz0xMDQKUHJlZmV0
Y2hpbmcgMTUgYmxvY2tzCldBSVQgIzE6IG5hbT0nZGIgZmlsZSBwYXJhbGxlbCByZWFkJyBlbGE9
IDExMDc1NiBwMT0xNCBwMj0xNSBwMz0xNQpXQUlUICMxOiBuYW09J1NRTCpOZXQgbWVzc2FnZSB0
byBjbGllbnQnIGVsYT0gNSBwMT0xNjUwODE1MjMyIHAyPTEgcDM9MApQcmVmZXRjaGluZyAwIGJs
b2NrcwpXQUlUICMxOiBuYW09J2RiIGZpbGUgc2VxdWVudGlhbCByZWFkJyBlbGE9IDQ4MjEyIHAx
PTU1NiBwMj0yNTAxNDAgcDM9MQpGRVRDSCAjMTpjPTEwMDAwLGU9MTk5NDg1LHA9MTYsY3I9MTcs
Y3U9MCxtaXM9MCxyPTE1LGRlcD0wLG9nPTQsdGltPTQwMjMyMTUyODY1NDAKV0FJVCAjMTogbmFt
PSdTUUwqTmV0IG1lc3NhZ2UgZnJvbSBjbGllbnQnIGVsYT0gOTI1IHAxPTE2NTA4MTUyMzIgcDI9
MSBwMz0wCm9sZF9yZWFkaW5nPTYwIG5ld19yZWFkaW5nPTc0ClByZWZldGNoaW5nIDE1IGJsb2Nr
cwoKCgpPbiAxMS8yNi8wNSwgSm++ZSBTZW5lZ2HobmlrIDxKb3plLlNlbmVnYWNuaWtAc250LnNp
PiB3cm90ZToKPiBBZGRpdGlvbmFseSB0byBUYW5lbHMgcmVzcG9uZCBJIHdvdWxkIGxpa2UgdG8g
YWRkIG15IHR3byBjZW50cy4gT25lIHllYXIgYWdvIEkgZm91bmQgaW4gb25lIG9mIG15IHRyYWNl
IGZpbGVzIHRoYXQgT3JhY2xlIHBlcmZvcm1zIGEgJ2RiIGZpbGUgc2NhdHRlcmVkIHJlYWQnIC0g
bXVsdGlibG9jayByZWFkIGZvciBJTkRFWCBVTklRVUUgU0NBTiBvcGVyYXRpb24gdGhhdCBpcyB0
eXBpY2FsbHkgYSBzaW5nbGUgYmxvY2sgcmVhZCBvcGVyYXRpb24uIEkgbG9va2VkIGEgbGl0dGxl
IGJpdCBjbG9zZXIgdG8gdGhpcyBwcm9ibGVtIGFuZCBmb3VuZCBzb21lIGludGVyZXN0aW5nIGRl
dGFpbHMuCj4KPiBJIHR1cm5lZCBvbiBldmVudCAxMDI5OSBhcyB3ZWxsIHRvIHRyYWNlIHByZWZl
dGNoZWQgYmxvY2tzIGFuZCBiZWxvdyB5b3UgY2FuIHNlZSB0aGUgZXhjZXJwdCBmcm9tIGV2ZW50
IDEwMDQ2KzEwMjk5IHRyYWNlIGZpbGUuIEF0IHRoYXQgdGltZSBJIHdhcyB1c2luZyAxMC4xLjAu
My4gSW5zdGVhZCBvZiByZWFkaW5nIDEgYmxvY2sgYXQgYSB0aW1lIE9yYWNsZSByZWFkcyAxMyBi
bG9ja3MgaW4gb25lIG11bHRpYmxvY2sgcmVhZCBhbmQgMTIgb2YgdGhlbSBhcmUgcHJlZmV0Y2hl
ZC4gT2YgY291cnNlIHRoZXJlIGFyZSBhbHNvIHNvbWUgc2luZ2xlIGJsb2NrIHJlYWRzLgo+Cj4g
QmVsb3cgYXJlIHRoZSBkZXRhaWxzLiBUaGUgc3RhdGVtZW50IGlzIGEgc2ltcGxlIHVwZGF0ZSBz
dGF0ZW1lbnQgdGhhdCB1cGRhdGVzIGlzdW5nIHByaW1hcnkga2V5IHByaW1hcnkga2V5Lgo+Cj4K
PiBSb3cgU291cmNlIE9wZXJhdGlvbgo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQo+ICBVUERBVEUgIChjcj0xNzUg
cj0xNTkgdz0wIHRpbWU9NDI1MzExNyB1cykKPiAgSU5ERVggVU5JUVVFIFNDQU4gU19FTVBfSURf
UEsgKGNyPTE2NCByPTc4IHc9MCB0aW1lPTEyNTkxMzggdXMpCj4KPgo+IFJlc3BvbnNlIFRpbWUg
Q29tcG9uZW50ICAgICAgICAgICAgICAgICAgICBUaW1lIGVsYS4gICAgUGN0Cj4gLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSAtLS0tLS0tLS0tLSAtLS0tLS0tLQo+IGRi
IGZpbGUgc2NhdHRlcmVkIHJlYWQgICAgICAgICAgICAgICAgICAgICAgICAgMS41NnMgICA2Mi44
MiUKPiBkYiBmaWxlIHNlcXVlbnRpYWwgcmVhZCAgICAgICAgICAgICAgICAgICAgICAgIDAuNzBz
ICAgMjguMzIlCj4gQ1BVIHNlcnZpY2UgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAwLjIycyAgICA4Ljg2JQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0gLS0tLS0tLS0tLS0gLS0tLS0tLS0KPiAgICAgICAgICAgICAgICAgICAgICAgICAgUmVzcG9u
c2UgdGltZTogICAgICAgMi40OXMgIDEwMC4wMCUKPiAgICAgICAgICAgICAgICAgICAgICAgICAg
IFNlcnZpY2UgdGltZTogICAgICAgMC4yMnMgICAgOC44NiUKPiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgIFdhaXQgdGltZTogICAgICAgMi4yN3MgICA5MS4xNCUKPgo+Cj4gU3RhdGVtZW50
IFJlYWQgU3RhdGlzdGljcwo+Cj4gQmxrcy9SZWFkICAgICAgQ291bnQgTnVtIG9mIGJsawo+IC0t
LS0tLS0tLSAtLS0tLS0tLS0tIC0tLS0tLS0tLS0KPiAgICAgICAgMSAgICAgICAgIDE5ICAgICAg
ICAgMTkKPiAgICAgICAgMiAgICAgICAgICAxICAgICAgICAgIDIKPiAgICAgICAgMyAgICAgICAg
ICAzICAgICAgICAgIDkKPiAgICAgICAgNSAgICAgICAgICAyICAgICAgICAgMTAKPiAgICAgICAg
NiAgICAgICAgICAyICAgICAgICAgMTIKPiAgICAgICAgNyAgICAgICAgICAyICAgICAgICAgMTQK
PiAgICAgICAgOCAgICAgICAgICAxICAgICAgICAgIDgKPiAgICAgICAxMCAgICAgICAgICAxICAg
ICAgICAgMTAKPiAgICAgICAxMSAgICAgICAgICAyICAgICAgICAgMjIKPiAgICAgICAxMiAgICAg
ICAgICAxICAgICAgICAgMTIKPiAgICAgICAxMyAgICAgICAgICAyICAgICAgICAgMjYKPiAgICAg
ICAxNSAgICAgICAgICAxICAgICAgICAgMTUKPiAtLS0tLS0tLS0gLS0tLS0tLS0tLSAtLS0tLS0t
LS0tCj4gICBTVU0gICAgICAgICAgICAzNyAgICAgICAgMTU5Cj4KPgo+IEV2ZW50IDEwMDQ2ICsg
RVZFTlQgMTAyOTkgVHJhY2UgRXhjZXJwdDoKPgo+IEVYRUMgIzI0OmM9MCxlPTkzNjEscD0wLGNy
PTAsY3U9MSxtaXM9MCxyPTAsZGVwPTEsb2c9MSx0aW09MTA2ODk4ODk2NTU2MAo+IEVYRUMgIzI2
OmM9MCxlPTgzNTQscD0wLGNyPTIsY3U9MCxtaXM9MCxyPTAsZGVwPTEsb2c9MSx0aW09MTA2ODk4
ODk3NjYwNgo+IEVYRUMgIzI1OmM9MCxlPTIzNDUscD0wLGNyPTAsY3U9MCxtaXM9MCxyPTAsZGVw
PTEsb2c9MSx0aW09MTA2ODk4ODk4MTIzMAo+IFByZWZldGNoaW5nIDYgYmxvY2tzCj4gV0FJVCAj
Mjg6IG5hbT0nZGIgZmlsZSBzY2F0dGVyZWQgcmVhZCcgZWxhPSA2NTEwMCBwMT04IHAyPTU4MTMg
cDM9Nwo+IFByZWZldGNoaW5nIDEyIGJsb2Nrcwo+IFdBSVQgIzI4OiBuYW09J2RiIGZpbGUgc2Nh
dHRlcmVkIHJlYWQnIGVsYT0gNDUxNjgxIHAxPTggcDI9MTgwMCBwMz0xMyBFWEVDICMyNzpjPTAs
ZT0yNjg3LHA9MCxjcj0wLGN1PTIsbWlzPTAscj0xLGRlcD0yLG9nPTEsdGltPTEwNjg5ODk1NjM1
MDUKPiBFWEVDICMyODpjPTEwMDE0LGU9NTg5MzUyLHA9MjAsY3I9MixjdT04LG1pcz0wLHI9MSxk
ZXA9MSxvZz0xLHRpbT0xMDY4OTg5NTc0MzM5Cj4KPiBSZWdhcmRzLAo+IEpvemUKPgo+IC0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tCj4gRnJvbTogb3JhY2xlLWwtYm91bmNlQGZyZWVsaXN0cy5v
cmcgW21haWx0bzpvcmFjbGUtbC1ib3VuY2VAZnJlZWxpc3RzLm9yZ10gT24gQmVoYWxmIE9mIHpo
dSBjaGFvCj4gU2VudDogTW9uZGF5LCBOb3ZlbWJlciAyMSwgMjAwNSAxMDowNSBBTQo+IFRvOiBv
cmFjbGUtbEBmcmVlbGlzdHMub3JnCj4gU3ViamVjdDogZGIgZmlsZSBwYXJhbGxlbCByZWFkIGZv
ciBwcmVmZXRjaGluZz8KPgo+IGhpLCBhbGwsCj4gICBEb2VzIGFueW9uZSBoYXMgZG9jdW1lbnQv
bm90ZSB0YWxraW5nIGFib3V0IHRoZSBpbmRleCBwcmVmZXRjaGluZz8KPiBJIHNhdyBhIGZldyBk
b2MgdGFsa2luZyBhYm91dCBvcmFjbGUgOWkgaW50cm9kdWNlZCB0aGlzIGZlYXR1cmUsIGJ1dCBu
byBkb2MgcmVhbGx5IHRhbGtlZCwgIGhvdyBpdCB3b3JrcywgYW5kIGhvdyB0byBlbmFibGUvaGlu
dCB0aGUgcHJlZmV0Y2ggZm9yIHRoZSBvcHRpbWl6ZXIsIGFuZCBob3cgdG8gdmVyaWZ5IGl0IGlz
IHdvcmtpbmcuCj4gICBJIGhhdmUgdHdvIGRhdGFiYXNlIHdpdGggaWRlbnRpY2FsIGhhcmR3YXJl
L3NjaGVtYSwgYW5kIHNvbWUgU1FMIHdpdGggaWRlbnRpY2FsIHBsYW4gKGFuZCBuZWFybHkgc2Ft
ZSBkYXRhIHZvbHVtZSksIFNRTCBpbiBvbmUgZGF0YWJhc2UgYWx3YXlzIHJ1biBhdCAxLzIgdGlt
ZSBvZiB0aGUgb3RoZXIgZGF0YWJhc2UuCj4gICBJIGNoZWNrZWQgdGhlIDEwMDQ2IHRyYWNlIGFu
ZCBmb3VuZCB0aGUgZGF0YWJhc2UgZmFzdGVyIGhhcyBwcmV0dHkgbXVjaCAiZGIgZmlsZSBwYXJh
bGxlbCByZWFkIiBhbmQgdGhlIG90aGVyIGluc3RhbmNlIGlzIGFsbCAiZGIgZmlsZSBzZXF1ZW50
aWFsIHJlYWQiLiBJIGd1ZXNzIGl0IGlzIHJlbGF0ZWQgdG8gdGhlIHByZWZldGNoLCBidXQgZG8g
bm90IGhhdmUgbXVjaCBkZXRhaWwgYWJvdXQgaXQuCj4KPiBJZiBzb21lb25lIGhhcyBzb21lIGV4
cGVyaWVuY2UgaXQsIGNhbiB5b3Ugc2hhcmU/Cj4KPiAtLQo+IFJlZ2FyZHMKPiBaaHUgQ2hhbwo+
IHd3dy5jbm91Zy5vcmcKPiAtLQo+IGh0dHA6Ly93d3cuZnJlZWxpc3RzLm9yZy93ZWJwYWdlL29y
YWNsZS1sCj4KPgo+Cj4gLS0KPiBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvd2VicGFnZS9vcmFj
bGUtbAo+Cj4KPgoKCi0tClJlZ2FyZHMKWmh1IENoYW8Kd3d3LmNub3VnLm9yZwo=
--
//www.freelists.org/webpage/oracle-l
Other related posts:
