Re: high db hit ratio and a lot of waits on db sequential reads
- From: genegurevich@xxxxxxxxxxxx
- To: Andrey.Kriushin@xxxxxxxx
- Date: Tue, 25 Sep 2007 17:43:26 -0500
QW5kcmV5LA0KDQpUaGFua3MgZm9yIHlvdXIgcG9zdC4gVGhlcmUgYXJlIG5vIFBML1NRTCBwcm9j
ZWR1cmVzIGFmYWlrLiBPbmx5IFNRTA0KY29tbWFuZHMuIFN0aWxsICB3aGF0IHlvdSBhcmUgc3Vn
Z2VzdGluZw0KbWF5IGJlIGFwcGxpY2FibGUuIFdlIGhhdmUgYmVlbiBsb29raW5nIGF0IHRoZSBl
bnZpcm9ubWVudCBzbyBmYXIgYmVjYXVzZQ0KdGhlIGV4cGxhaW4gcGxhbnMgZm9yIHRoZSBTUUxz
IGRpZA0KbG9vayByZWFzb25hYmxlLiBNYXkgYmUgaXQgaXMgdGltZSB0byByZXZpc2l0IHRoZW0N
Cg0KdGhhbmsgeW91DQoNCkdlbmUgR3VyZXZpY2gNCg0KDQoNCiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K
ICAgICAgICAgICAgIEFuZHJleSBLcml1c2hpbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgPEFuZHJleS5Lcml1c2hpbkAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICByZHRl
eC5ydT4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFRv
IA0KICAgICAgICAgICAgIFNlbnQgYnk6ICAgICAgICAgICAgICAgICAgZ2VuZWd1cmV2aWNoQGRp
c2NvdmVyLmNvbSAgICAgICAgICAgDQogICAgICAgICAgICAgb3JhY2xlLWwtYm91bmNlQGYgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjYyANCiAgICAgICAgICAgICBy
ZWVsaXN0cy5vcmcgICAgICAgICAgICAgIG9yYWNsZS1sIDxvcmFjbGUtbEBmcmVlbGlzdHMub3Jn
PiAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIFN1YmplY3QgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICBSZTogaGlnaCBkYiBoaXQgcmF0aW8gYW5kIGEgbG90IG9mICANCiAgICAgICAgICAg
ICAwOS8yNS8yMDA3IDAzOjU1ICAgICAgICAgIHdhaXRzIG9uIGRiIHNlcXVlbnRpYWwgcmVhZHMg
ICAgICAgIA0KICAgICAgICAgICAgIFBNICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgIA0KICAgICAgICAgICAgIFBsZWFzZSByZXNwb25kIHRvICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgQW5kcmV5LktyaXVz
aGluQHIgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAg
ICAgICAgICAgICAgIGR0ZXgucnUgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCg0K
DQoNCg0KICAgIEhpLA0KDQpCZWluZyBzaWduZWQgZm9yIEJBQUcsICBJJ20gbm90IGluIHBvc2l0
aW9uIHRvIHByb3ZpZGUgQW55IEd1ZXNzZXMgOy0pLg0KSG93ZXZlciAoSU1ITykgdGhlcmUgaXMg
c3RpbGwgYSByb29tIGZvciBpbnZlc3RpZ2F0aW9uIGh5cG90aGVzaXMuDQoNCkknZCBsb29rIGZv
ciB0aGUgInNsb3ctYnktc2xvdyIgKFRvbSBLeXRlKSwgd2hpY2ggaXMgcm93IGJ5IHJvdyBhY2Nl
c3MuDQpVc3VhbGx5IHRoaXMgaGFwcGVucyB3aGVuIHRoZSBjb2RlciBhdm9pZHMgdGhlIGpvaW5z
IGluIHRoZSBTUUwgYW5kDQppbXBsZW1lbnRzIHRoZSBzYW1lIGZ1bmN0aW9uYWxpdHkgaW4gUEwv
U1FMLiBTYXkgYnkgZmV0Y2hpbmcgYSByb3dzIGluIGENCm1haW4gY3Vyc29yIGxvb3AgYW5kIHRo
ZW4gZmV0Y2hpbmcgdGhlIHJvd3MgZnJvbSB0aGUgb3RoZXIgdGFibGUgYSByb3cNCmJ5IHJvdyBi
eSBpdHMgUEssIGZvciBleGFtcGxlLiBBcyBhIHJlc3VsdCB5b3UgbWF5IGhhdmUgdGhlIHdvcnN0
DQpwb3NzaWJsZSAicGxhbiIgKHVzdWFsbHkpIHdpdGggYSBsb3Qgb2YgdGhyb3dhd2F5IHJvd3Ms
IHdoaWNoIGlzIG1hc2tlZA0KYnkgUEwvU1FMLiBJbiB0aGUgdXN1YWwgc2l0dWF0aW9uIHlvdSds
bCBzZWUganVzdCBhIGJhZCBTUUwsIHRodXMgdGhlcmUNCndvdWxkIGJlIG5vIHF1ZXN0aW9uIHdo
ZXJlIHRob3NlIGV4dHJhIExJTyBjb21lcyBmcm9tLg0KDQpMb29rIGZvciB0aGUgUEwvU1FMIHBy
b2NlZHVyZSB3aXRoIGEgbG90IG9mIExJTywgdGhlbiBjaGVjayBpdHMgY29kZSBmb3INCnRoZSBw
cmVzZW5jZSBvZiBTUUwgd2l0aCB0aGUgYWNjZXNzIHRvIHRoZSBzaW5nbGUgcm93IGluIHRoZSBs
b29wLiBXZWxsLA0KSSBwcmVzdW1lIHRoYXQgeW91J3ZlIG1lYW50IHNvbWV0aGluZyBsaWtlIFVO
SVFVRSBhY2Nlc3MgcGF0aCBhbmQgTk9UDQp0aGUgUkFOR0UgU0NBTiBldGMgb24geW91ciBQSy4N
Cg0KLS0gQW5kcmV5DQoNCmdlbmVndXJldmljaEBkaXNjb3Zlci5jb20g0MnbxdQ6DQo+IEhpIGFs
bDoNCj4NCj4gSSBhbSB3b3JraW5nIG9uIHR1bmluZyBhbiBhcHAgcnVubmluZyBhZ2FpbnN0IG9y
YWNsZSAxMC4yLjAuMyBXZSBoYXZlIDQ4Rw0KPiBvbiB0aGUgc2VydmVyOyBteSBkYl9jYWNoZSBp
cyAxOEcuIFdoZW4gSQ0KPiBsb29rIGF0IHRoZSBhd3IgcmVwb3J0cywgSSBzZWUgZGIgaGl0IHJh
dGlvIGJlaW5nIG92ZXIgOTklIGFuZCBhIGxvdCBvZg0KPiB3YWl0cyBmb3IgZGIgc2VxdWVudGlh
bCByZWFkcy4gQmFzZWQgb24gdGhlIFNRTA0KPiB0aGVyZSBhcmUgYSBsb3Qgb2YgdGFibGUgcmVh
ZHMgYmFzZWQgb24gdGhlIHByaW1hcnkga2V5cyBzbyB0aGF0IGtpbmQgb2YNCj4gd2FpdHMgaXMg
cmVhc29uYWJsZS4gQnV0IHRoZSBxdWVzdGlvbiBpcw0KPiBpZiB0aGUgaGl0IHJhdGlvIGlzIHRo
YXQgaGlnaCAsIGlmIHdlIHJlYWQgbW9zdGx5IGZvciB0aGUgY2FjaGUsIHdoeSBkbw0Kd2UNCj4g
ZG8gdGhhdCBtYW55IHJlYWRzLiBJcyB0aGVyZSBhbiBleHBsYW5hdGlvbiBmb3IgdGhhdD8NCj4N
Cj4gdGhhbmsgeW91DQo+DQo+IEdlbmUgR3VyZXZpY2gNCj4NCj4NCj4gLS0NCj4gaHR0cDovL3d3
dy5mcmVlbGlzdHMub3JnL3dlYnBhZ2Uvb3JhY2xlLWwNCj4NCj4NCj4NCg0KLS0NCmh0dHA6Ly93
d3cuZnJlZWxpc3RzLm9yZy93ZWJwYWdlL29yYWNsZS1sDQoNCg0KDQo=
--
//www.freelists.org/webpage/oracle-l
Other related posts:
