RE: So how big is your buffer cache ?
- From: "Zhu, Chao" <chzhu@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 29 Aug 2004 12:54:24 +0800
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
