Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db file parallel read for prefetching?

Re: db file parallel read for prefetching?

From: zhu chao <zhuchao_at_gmail.com>
Date: Tue, 29 Nov 2005 23:16:59 +0800
Message-ID: <962cf44b0511290716x295cede4q542ab59c70cd477a@mail.gmail.com>


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=

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 29 2005 - 09:22:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US