RE: Combined SGA size and Total Memory

  • From: "Thomas Biju" <BThomas@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 23 Jun 2004 19:04:03 -0500

R3JhZW1lLA0KTm8sIEknbSBub3QgdGFsa2luZyBhYm91dCBpbmNyZWFzaW5nIHRoZSBzaXplIG9m
IFNHQSBzaW1wbHkgYmVjYXVzZSB3ZSBoYXZlIG1lbW9yeS4gVGhlIHJlYXNvbiBmb3IgdGhlIHF1
ZXN0aW9uIHdhcyBiYXNpY2FsbHkgZGlmZmVyZW50LiBXZQ0KdHlwaWNhbGx5IGNyZWF0ZSBuZXcg
ZGF0YWJhc2VzIG9uIHRoZSBzYW1lIEhQIG9yIFN1biBzZXJ2ZXIgd2hpY2ggY3VycmVudGx5IGhv
c3QgYW55d2hlcmUgZnJvbSA2IHRvIDIzIGRhdGFiYXNlcy4uLiBBdCB3aGF0IHBvaW50IHNob3Vs
ZCB3ZQ0KYWxlcnQgdGhlIG1hbmFnZW1lbnQgZm9yIGEgbWVtb3J5IHVwZ3JhZGU/IE15IHBvaW50
IHdhcyB0aGVyZSBzaG91bGQgbm90IGJlIGFueSBydWxlIG9mIHRodW1iIHN1Y2ggYXMgU0dBIHNo
b3VsZCBiZSBsZXNzIHRoYW4gMzAlIG9mIHRvdGFsDQpSQU0sIG1vcmUgbWVtb3J5IHJlcXVpcmVt
ZW50IHNob3VsZCBiZSBiYXNlZCBvbiB0aGUgbG9hZCBvbiB0aGUgc2VydmVyLi4uLg0KVGhhbmtz
LA0KQmlqdQ0KIA0KDQoJLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0gDQoJRnJvbTogR3JhZW1l
IEZhcm1lciBbbWFpbHRvOmdyYWVtZS5mYXJtZXJAbWluY29tLmNvbV0gDQoJU2VudDogV2VkIDYv
MjMvMjAwNCA2OjUyIFBNIA0KCVRvOiAnb3JhY2xlLWxAZnJlZWxpc3RzLm9yZycgDQoJQ2M6IA0K
CVN1YmplY3Q6IFJFOiBDb21iaW5lZCBTR0Egc2l6ZSBhbmQgVG90YWwgTWVtb3J5DQoJDQoJDQoN
CglJIHdvdWxkIGhhdmUgdGhvdWdodCB0aGF0IHRoZSBTR0Egc2hvdWxkIGJlIGFzIGJpZyBhcyBp
dCBuZWVkcyB0byBiZSBhbmQgbm8NCgliaWdnZXIhIQ0KCQ0KCU5lZWRsZXNzbHkgYWxsb2NhdGlu
ZyBleHRyYSBtZW1vcnkgdG8gdGhlIFNHQSBqdXN0IGJlY2F1c2UgeW91IGhhdmUgY2FuIG1ha2UN
CglPcmFjbGUgd29yayBoYXJkZXIgYXMgaXQgaGFzIG1vcmUgbWVtb3J5IHRvIG1hbmFnZS4gQnVm
ZmVyIGNoYWluIGxlbmd0aHMNCgl3aWxsIGluY3JlYXNlIGFuZCBzY2FubmluZyBhbmQgY2FjaGUg
Y2hhaW5zIGxhdGNoIGNvbnRlbnRpb24gaGFzIHRoZQ0KCXBvdGVudGlhbCB0byBpbmNyZWFzZSBv
biBhY3RpdmUgc3lzdGVtcy4NCgkNCglUaGUgc2l6ZSBvZiB0aGUgU0dBIHNob3VsZCBhbHNvIGRl
cGVuZCBvbiBvdGhlciBwcm9jZXNzZXMgb24gdGhlIHN5c3RlbSBhbmQNCgl0aGVpciB1c2FnZSAo
aW5jbHVkaW5nIE9yYWNsZSBwcm9jZXNzZXMgdGhhdCBwZXJoYXBzIHJlcXVpcmUgYSBsYXJnZSBz
b3J0DQoJYnVmZmVyKS4NCgkNCglDaGVlcnMsDQoJR3JhZW1lLg0KCQ0KCS0tLS0tT3JpZ2luYWwg
TWVzc2FnZS0tLS0tDQoJRnJvbTogdGJvc3NAYm9zc2NvbnN1bHRpbmcuY29tIFttYWlsdG86dGJv
c3NAYm9zc2NvbnN1bHRpbmcuY29tXQ0KCVNlbnQ6IFRodXJzZGF5LCAyNCBKdW5lIDIwMDQgODoz
MyBBTQ0KCVRvOiBvcmFjbGUtbEBmcmVlbGlzdHMub3JnDQoJU3ViamVjdDogUmU6IENvbWJpbmVk
IFNHQSBzaXplIGFuZCBUb3RhbCBNZW1vcnkNCgkNCglVZ2gsIDMwJSBvZiBtZW1vcnkgd291bGQg
YmUgc3VjaCBhIHdhc3RlIG9mIGV4cGVuc2l2ZSBwaHlzaWNhbCBSYW0uDQoJDQoJNzAtNzUlIG9m
IHlvdXIgcGh5c2ljYWwgcmFtIGZvciBPcmFjbGUgaXMgZmluZSwgYXNzdW1pbmcgeW91J3ZlDQoJ
Z290IGFtcGxlIHN3YXAgc3BhY2UgYW5kIG5vIG90aGVyIGFwcGxpY2F0aW9ucyBvbiB0aGUgbWFj
aGluZS4NCgkNCglJZiB5b3UgbGV0IDlpIGRiY2EgZGVmYXVsdCBhbGwgaXRzIHZhbHVlcywgaXQg
YXNzdW1lcyA3MCUgYXMgYSB0YXJnZXQuDQoJVGhpcyBpcyBhcyBnb29kIG9mIGEgInJ1bGUgb2Yg
dGh1bWIiIGFzIGFueS4NCgkNCglUb2RkDQoJDQoJPg0KCT4gSGVsbG8sDQoJPg0KCT4gQSBmZWxs
b3cgREJBIHRlbGxzIG1lIHRoYXQgdGhlIHRvdGFsIFNHQSBzaXplIG9mIGFsbCBpbnN0YW5jZXMg
b24gdGhlDQoJc2VydmU9DQoJPiByIChIUCwgU3VuKSBzaG91bGQgbm90IGV4Y2VlZCAzMCUgb2Yg
dGhlIHNlcnZlcidzIHRvdGFsIG1lbW9yeS4gSQ0KCT4gY291bGQgbm90IGZpbmQgYW55IGRvY3Vt
ZW50YXRpb24gc3VwcG9ydGluZyB0aGlzIGFyZ3VtZW50IGluIE1ldGFsaW5rPyBJcw0KCXQ9DQoJ
PiBoZXJlIGlzIGFueSBzdWNoIGd1aWRlbGluZT8gTXkgaW1wcmVzc2lvbiB3YXMgdG8gbW9uaXRv
ciB0aGUNCgk+IHBhZ2luZy9zd2FwIG9uIHRoZSBzZXJ2ZXIgYmVmb3JlIGFkZGluZyBtb3JlIG1l
bW9yeSByYXRoZXIgdGhhbiBnb2luZyBieQ0KCXRoPQ0KCT4gZSBydWxlIG9mIHRodW1iLi4uLj0y
MA0KCT4NCgk+IFRoYW5rcyBpbiBhZHZhbmNlIGZvciB5b3VyIGlucHV0Lg0KCT4NCgk+IEJpanUg
VGhvbWFzDQoJPg0KCT4NCgk+DQoJX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fPQ0KCT4gX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fXw0KCT4NCgk+IFRoaXMgZWxlY3Ryb25pYyB0cmFuc21pc3Np
b24gYW5kIGFueSBhdHRhY2hlZCBmaWxlcyBhcmUgaW50ZW5kZWQgc29sZWx5DQoJZm9yPQ0KCT4g
IHRoZSBwZXJzb24gb3IgZW50aXR5IHRvIHdoaWNoIHRoZXkgYXJlIGFkZHJlc3NlZCBhbmQgbWF5
IGNvbnRhaW4NCglpbmZvcm1hdGk9DQoJPiBvbiB0aGF0IGlzIHByaXZpbGVnZWQsIGNvbmZpZGVu
dGlhbCBvciBvdGhlcndpc2UgcHJvdGVjdGVkIGZyb20NCglkaXNjbG9zdXJlLj0NCgk+ICBBbnkg
cmV2aWV3LCByZXRyYW5zbWlzc2lvbiwgZGlzc2VtaW5hdGlvbiBvciBvdGhlciB1c2UsIGluY2x1
ZGluZyB0YWtpbmcNCglhPQ0KCT4gbnkgYWN0aW9uIGNvbmNlcm5pbmcgdGhpcyBpbmZvcm1hdGlv
biBieSBhbnlvbmUgb3RoZXIgdGhhbiB0aGUgbmFtZWQNCglyZWNpcGk9DQoJPiBlbnQsIGlzIHN0
cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBhcmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQg
b3IgaGF2ZQ0KCT0NCgk+IHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxl
YXNlIGltbWVkaWF0ZWx5IG5vdGlmeSB0aGUgc2VuZGVyDQoJPQ0KCT4gYW5kIGRlc3Ryb3kgdGhp
cyBjb21tdW5pY2F0aW9uLg0KCT4gLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCT4gUGxlYXNlIHNlZSB0aGUgb2ZmaWNpYWwg
T1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5jb20NCgk+IC0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCgk+IFRvIHVu
c3Vic2NyaWJlIHNlbmQgZW1haWwgdG86ICBvcmFjbGUtbC1yZXF1ZXN0QGZyZWVsaXN0cy5vcmcN
Cgk+IHB1dCAndW5zdWJzY3JpYmUnIGluIHRoZSBzdWJqZWN0IGxpbmUuDQoJPiAtLQ0KCT4gQXJj
aGl2ZXMgYXJlIGF0IGh0dHA6Ly93d3cuZnJlZWxpc3RzLm9yZy9hcmNoaXZlcy9vcmFjbGUtbC8N
Cgk+IEZBUSBpcyBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvaGVscC9mb20tc2VydmUvY2Fj
aGUvMS5odG1sDQoJPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KCT4NCgkNCgktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJUGxlYXNlIHNlZSB0aGUg
b2ZmaWNpYWwgT1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5jb20NCgktLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJ
VG8gdW5zdWJzY3JpYmUgc2VuZCBlbWFpbCB0bzogIG9yYWNsZS1sLXJlcXVlc3RAZnJlZWxpc3Rz
Lm9yZw0KCXB1dCAndW5zdWJzY3JpYmUnIGluIHRoZSBzdWJqZWN0IGxpbmUuDQoJLS0NCglBcmNo
aXZlcyBhcmUgYXQgaHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL2FyY2hpdmVzL29yYWNsZS1sLw0K
CUZBUSBpcyBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvaGVscC9mb20tc2VydmUvY2FjaGUv
MS5odG1sDQoJLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0NCgkNCgkNCgktLQ0KCVRoaXMgdHJhbnNtaXNzaW9uIGlzIGZvciB0
aGUgaW50ZW5kZWQgYWRkcmVzc2VlIG9ubHkgYW5kIGlzIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlv
bi4gSWYgeW91IGhhdmUgcmVjZWl2ZWQgdGhpcyB0cmFuc21pc3Npb24gaW4NCmVycm9yLCBwbGVh
c2Ugbm90aWZ5IHRoZSBzZW5kZXIgYW5kIGRlbGV0ZSB0aGUgdHJhbnNtaXNzaW9uLiBUaGUgY29u
dGVudHMgb2YgdGhpcyBlLW1haWwgYXJlIHRoZSBvcGluaW9uIG9mIHRoZSB3cml0ZXIgb25seSBh
bmQgYXJlIG5vdA0KZW5kb3JzZWQgYnkgdGhlIE1pbmNvbSBMaW1pdGVkIHVubGVzcyBleHByZXNz
bHkgc3RhdGVkIG90aGVyd2lzZS4NCgkNCgktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJUGxlYXNlIHNlZSB0aGUgb2ZmaWNp
YWwgT1JBQ0xFLUwgRkFROiBodHRwOi8vd3d3Lm9yYWZhcS5jb20NCgktLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoJVG8gdW5z
dWJzY3JpYmUgc2VuZCBlbWFpbCB0bzogIG9yYWNsZS1sLXJlcXVlc3RAZnJlZWxpc3RzLm9yZw0K
CXB1dCAndW5zdWJzY3JpYmUnIGluIHRoZSBzdWJqZWN0IGxpbmUuDQoJLS0NCglBcmNoaXZlcyBh
cmUgYXQgaHR0cDovL3d3dy5mcmVlbGlzdHMub3JnL2FyY2hpdmVzL29yYWNsZS1sLw0KCUZBUSBp
cyBhdCBodHRwOi8vd3d3LmZyZWVsaXN0cy5vcmcvaGVscC9mb20tc2VydmUvY2FjaGUvMS5odG1s
DQoJLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0NCgkNCgkNCg0KDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fDQoNClRoaXMgZWxlY3Ryb25pYyB0cmFuc21pc3Npb24gYW5kIGFu
eSBhdHRhY2hlZCBmaWxlcyBhcmUgaW50ZW5kZWQgc29sZWx5IGZvciB0aGUgcGVyc29uIG9yIGVu
dGl0eSB0byB3aGljaCB0aGV5IGFyZSBhZGRyZXNzZWQgYW5kIG1heSBjb250YWluIGluZm9ybWF0
aW9uIHRoYXQgaXMgcHJpdmlsZWdlZCwgY29uZmlkZW50aWFsIG9yIG90aGVyd2lzZSBwcm90ZWN0
ZWQgZnJvbSBkaXNjbG9zdXJlLiBBbnkgcmV2aWV3LCByZXRyYW5zbWlzc2lvbiwgZGlzc2VtaW5h
dGlvbiBvciBvdGhlciB1c2UsIGluY2x1ZGluZyB0YWtpbmcgYW55IGFjdGlvbiBjb25jZXJuaW5n
IHRoaXMgaW5mb3JtYXRpb24gYnkgYW55b25lIG90aGVyIHRoYW4gdGhlIG5hbWVkIHJlY2lwaWVu
dCwgaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gSWYgeW91IGFyZSBub3QgdGhlIGludGVuZGVkIHJl
Y2lwaWVudCBvciBoYXZlIHJlY2VpdmVkIHRoaXMgY29tbXVuaWNhdGlvbiBpbiBlcnJvciwgcGxl
YXNlIGltbWVkaWF0ZWx5IG5vdGlmeSB0aGUgc2VuZGVyIGFuZCBkZXN0cm95IHRoaXMgY29tbXVu
aWNhdGlvbi4=

----------------------------------------------------------------
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: