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: So how big is your buffer cache ?

RE: So how big is your buffer cache ?

From: Zhu, Chao <chzhu_at_ebay.com>
Date: Sun, 29 Aug 2004 12:54:24 +0800
Message-ID: <51613FB99DC6E54FAA12ED6A22281B84101FE8@sha-exm-01.corp.ebay.com>


V2UgYXJlIGJpZyBmYW4gb2YgYmlnIERhdGEgQnVmZmVyLg0KSW5jcmVhc2UgdGhlIGRhdGEgYnVm ZmVyIGdyZWF0bHkgcmVkdWNlIHRoZSBsb2FkIG9uIHRoZSBkaXNrIHN1YnN5c3RlbS4gRXZlcnl0 aW1lIHdlIGluY3JlYXNlIHRoZSBTR0EsIHdlIHNlZSBodWdlIGRlY3JlYXNlIG9uIGRpc2sgcmVh ZCwgYW5kIGdyZWF0bHkgcmVkdWNlZCB0aGUgbG9hZCBvbiAgdGhlIGRpc2sgc3Vic3lzdGVtLCBh bmQgcmVkdWNlZCB0aGUgSU9XQUlUJSBpbiB1bml4Lg0KQW5kIHdlIGNhbiBzdXBwb3J0IHRoZSBh cHBsaWNhdGlvbiB3aXRoIGEgbWlkLWxldmVsIHN0b3JhZ2UgZm9yIG91ciBidXN5IGRhdGFiYXNl Lg0KTm93IHdlIGFyZSB1c2luZyAxMEcgYnVmZmVyIGNhY2hlICwgZm9yIGEgMTZnIHJhbSBzZXJ2 ZXIsIGFuZCA4MDArIGNvbm5lY3Rpb25zLg0KIA0KUmVnYXJkcw0KWmh1IENoYW8uDQogDQoNCgkt LS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBvcmFjbGUtbC1ib3VuY2VAZnJlZWxp c3RzLm9yZyDku6PooaggQm9iYWssIE1hcmsgDQoJU2VudDogMjAwNC04LTI4ICjmmJ/mnJ/lha0p IDIzOjM5IA0KCVRvOiBvcmFjbGUtbEBmcmVlbGlzdHMub3JnIA0KCUNjOiANCglTdWJqZWN0OiBS RTogU28gaG93IGJpZyBpcyB5b3VyIGJ1ZmZlciBjYWNoZSA/DQoJDQoJDQoNCglXb3csIDMwIEdC IHBsdXMhPyE/IQ0KCVdlbGwsIHdlIGRvbid0IGhhdmUgYW55IFNHQXMgdGhhdCBjdXJyZW50bHkg YnJlYWsgdGhlIDRHQiBiYXJycmllci4NCglPdXIgcGxhdGZvcm0gaXMgMzItYml0IE9yYWNsZSBv biBTb2xhcmlzLiAgQXMgd2UgYXJlIG1vdmluZyB0byA5aSwNCgl3ZSBhcmUgZ29pbmcgdG8gNjQt Yml0IE9yYWNsZSwgYW5kIG1heSBiZSBqdWRpY2lvdXNseSBpbmNyZWFzaW5nIHRoZQ0KCVNHQSBz aXplcy4gIFdlIGFyZSBiaWcgYmVsaWV2ZXJzIGluIEtFRVAsIFJFQ1lDTEUsIGFuZCBERUZBVUxU IGJ1ZmZlcg0KCXBvb2xzIHdoaWNoIGRlZmluaXRlbHkgaGVscCBtYWtlIHRoZSBtb3N0IG9mIHRo ZSBidWZmZXIgY2FjaGUuICBPdXIgbGFyZ2VzdA0KCXN5c3RlbSBjdXJyZW50bHkgcnVucyBvbiBh IDY4MDAsIGNvbmZpZ3VyZWQgd2l0aCA4IENQVXMgYW5kIDEyIEdCIG9mIFJBTQ0KCWluIHRoZSBw cmltYXJ5IGRvbWFpbi4gIFBHQXMgYWNjb3VudCBmb3IgYWJvdXQgNy41R0IsIHRoZSB0b3RhbCBT R0EgaXMNCglhYm91dCAyLjVHQiwgb2Ygd2hpY2ggdGhlIGJ1ZmZlciBjYWNoZSBpcyAyR0IuIA0K CQ0KCS1NYXJrDQoJDQoJDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCglGcm9tOiAgIG9y YWNsZS1sLWJvdW5jZUBmcmVlbGlzdHMub3JnIG9uIGJlaGFsZiBvZiBSaWNoYXJkIEZvb3RlDQoJ U2VudDogICBTYXQgOC8yOC8yMDA0IDc6NTYgQU0NCglUbzogICAgIG9yYWNsZS1sQGZyZWVsaXN0 cy5vcmcNCglDYzogICAgDQoJU3ViamVjdDogICAgICAgIFNvIGhvdyBiaWcgaXMgeW91ciBidWZm ZXIgY2FjaGUgPw0KCUhpIEFsbCwNCgkNCglJbiBhbiBpbnRlcmVzdGluZyBpbnNpZ2h0IGludG8g aG93IERvbiBCdXJsZXNvbiBwZXJmb3JtcyB0dW5pbmcgYXQgdGhlDQoJYy5kLm8ucyBuZXdzZ3Jv dXANCgkoaHR0cDovL2dyb3Vwcy5nb29nbGUuY29tL2dyb3Vwcz9kcT0maGw9ZW4mbHI9JmllPVVU Ri04JnRoPTczZjYwNmVlZjVlN2U5OWYpDQoJLiBEb24gc3VnZ2VzdHMgaGUgaGFzICJubyBwcm9i bGVtIHRocm93aW5nIGhhcmR3YXJlIGF0IGNyYXBweSBjb2RlIHdoZW4gdGhlDQoJY2xpZW50IGRv ZXNuJ3Qgd2FudCB0byB0dW5lIGl0Ii4gSGUncyBhbHNvIGJhc2ljYWxseSByZWNvbW1lbmRpbmcg dXNpbmcgQVdFDQoJYW5kIHV0aWxpc2luZyBhbGwgYXZhaWxhYmxlIFJBTSBvbiAzMmJpdCB3aW5k b3dzLCB3aGV0aGVyIHlvdSBuZWVkIHRvIG9yDQoJbm90LiBJIG1lYW4sIEFXRSBoYXMgbm8gZGlz YWR2YW50YWdlcyByaWdodCAuLi4gOikNCgkNCglIb3dldmVyLCBoZSBhbHNvIG1ha2VzIHRoZSBj bGFpbSB0aGF0ICJJdCdzIG5vdCB1bmNvbW1vbiB0byBzZWUgd29ya2luZyBzZXRzDQoJb2YgZnJl cXVlbnRseS1yZWZlcmVuY2VkIGRhdGEgb2YgZm9yIHRoYW4gMzAtZ2lnIGZvciBhIGxhcmdlIGRh dGFiYXNlLiBBV0UNCglpcyBhIGdyZWF0IHRlY2huaXF1ZXMgZm9yIDMyLWJpdCBXaW5kb3dzIGRh dGFiYXNlcyBhbmQgIEkgZG8gaXQgZm9yIGRvemVucw0KCW9mIGRhdGFiYXNlcyBldmVyeSB5ZWFy LCBBTFdBWVMgd2l0aCBncmVhdCByZXN1bHRzLiINCgkNCglTbyBteSBxdWVzdGlvbiB0byB5b3Ug YWxsIGlzIGhvdyBsYXJnZSBhcmUgeW91ciBsYXJnZXN0IGJ1ZmZlciBjYWNoZXMgPyBIb3cNCglt YW55IG9mIHlvdSBoYXZlIGEgYnVmZmVyIGNhY2hlIHRoYXQgaXMgMzBHKyA/IEFuZCBvbiAzMmJp dCB3aW5kb3dzID8NCgkNCglMb3ZlIHRvIGtub3cgISENCgkNCglDaGVlcnMNCgkNCglSaWNoYXJk DQoJDQoJDQoJLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQ0KCVBsZWFzZSBzZWUgdGhlIG9mZmljaWFsIE9SQUNMRS1MIEZBUTog aHR0cDovL3d3dy5vcmFmYXEuY29tDQoJLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCVRvIHVuc3Vic2NyaWJlIHNlbmQgZW1h aWwgdG86ICBvcmFjbGUtbC1yZXF1ZXN0QGZyZWVsaXN0cy5vcmcNCglwdXQgJ3Vuc3Vic2NyaWJl JyBpbiB0aGUgc3ViamVjdCBsaW5lLg0KCS0tDQoJQXJjaGl2ZXMgYXJlIGF0IGh0dHA6Ly93d3cu ZnJlZWxpc3RzLm9yZy9hcmNoaXZlcy9vcmFjbGUtbC8NCglGQVEgaXMgYXQgaHR0cDovL3d3dy5m cmVlbGlzdHMub3JnL2hlbHAvZm9tLXNlcnZlL2NhY2hlLzEuaHRtbA0KCS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJDQoJ DQoJDQoJLS0gQmluYXJ5L3Vuc3VwcG9ydGVkIGZpbGUgc3RyaXBwZWQgYnkgRWNhcnRpcyAtLQ0K CS0tIFR5cGU6IGFwcGxpY2F0aW9uL21zLXRuZWYNCgktLSBGaWxlOiB3aW5tYWlsLmRhdA0KCQ0K CQ0KCS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0NCglQbGVhc2Ugc2VlIHRoZSBvZmZpY2lhbCBPUkFDTEUtTCBGQVE6IGh0dHA6 Ly93d3cub3JhZmFxLmNvbQ0KCS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCglUbyB1bnN1YnNjcmliZSBzZW5kIGVtYWlsIHRv OiAgb3JhY2xlLWwtcmVxdWVzdEBmcmVlbGlzdHMub3JnDQoJcHV0ICd1bnN1YnNjcmliZScgaW4g dGhlIHN1YmplY3QgbGluZS4NCgktLQ0KCUFyY2hpdmVzIGFyZSBhdCBodHRwOi8vd3d3LmZyZWVs aXN0cy5vcmcvYXJjaGl2ZXMvb3JhY2xlLWwvDQoJRkFRIGlzIGF0IGh0dHA6Ly93d3cuZnJlZWxp c3RzLm9yZy9oZWxwL2ZvbS1zZXJ2ZS9jYWNoZS8xLmh0bWwNCgktLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCQ0KDQo=



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Sat Aug 28 2004 - 23:50:09 CDT

Original text of this message

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