Re: high db hit ratio and a lot of waits on db sequential reads

From: <genegurevich_at_discover.com>
Date: Tue, 25 Sep 2007 17:43:26 -0500
Message-ID: <OF6CA75846.38DC980A-ON86257361.007CA286-86257361.007CD36E@discover.com>

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=

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 25 2007 - 17:43:26 CDT