RE: Rebuilding database to change block size

--openmail-part-09477f44-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

> Okay, we finally got enough storage space to hold an export of our
> datawarehouse so I'm going to change the block size from 4 to 16.

Jay,

If you size up your block size you may need to downsize your number of DB Block buffers (and other related parameters). If not, you may end up using much more memory for your SGA...

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-09477f44-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+ImoYAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABAC0AAABSRTogUmVidWlsZGluZyBkYXRh YmFzZSB0byBjaGFuZ2UgYmxvY2sgc2l6ZQDaDwEDkAYADAAAAAEAAAALAAIAAQAAAA8AAQOQ BgAQAAAAAQAAAEAAOQAQaaXx6dC/AQIFAQOQBgAkAAAAAQAAAB4AQgABAAAAEgAAAEpvaG4g Si4gS2FuYWdhcmFqAAAAOwYBA5AGABAAAAABAAAAQABIADAQpvLp0L8B2gQBA5AGAEAAAAAB AAAAHgBwAAEAAAAtAAAAUkU6IFJlYnVpbGRpbmcgZGF0YWJhc2UgdG8gY2hhbmdlIGJsb2Nr IHNpemUAAAAAlxABA5AGACgAAAABAAAAAgFxAAEAAAAWAAAAAb/Q6fGifRhmDjzJEdSTVABg l5kRswAAxgoBA5AGAAwAAAABAAAAAwAGEBU/lszQAQEDkAYADAAAAAEAAAADAAcQygEAAOYA AQOQBgB4AAAAAQAAAB4ACBABAAAAZQAAAE9LQVksV0VGSU5BTExZR09URU5PVUdIU1RPUkFH RVNQQUNFVE9IT0xEQU5FWFBPUlRPRk9VUkRBVEFXQVJFSE9VU0VTT0lNR09JTkdUT0NIQU5H RVRIRUJMT0NLU0laRUZST00AAAAAHB4BA5AGAAwAAAABAAAAAwAQEAEAAAAlAAEDkAYADAAA AAEAAAADABEQAAAAACUAAQOQBgAQAAAAAQAAAEAABzCQcBB96dC/AX4EAQOQBgAQAAAAAQAA AEAACDCQcBB96dC/AX8EAQOQBgAgAAAAAQAAAAIBCzABAAAAEAAAAAxmGH3JPNQRk1QAYJeZ EbN8BgEDkAYADAAAAAEAAAADAN4/r28AAD8CAQOQBgAkAAAAAQAAAAMAHYYIIAYAAAAAAMAA AAAAAABGAAAAABCFAAAAAAAAcAIBA5AGACQAAAABAAAAAwAehgggBgAAAAAAwAAAAAAAAEYA AAAAAYUAAAAAAABiAgEDkAYAJAAAAAEAAAADAB+GCCAGAAAAAADAAAAAAAAARgAAAAARhQAA AAAAAHMCAQOQBgAkAAAAAQAAAAMAIIYIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADjFQAArQMB A5AGACwAAAABAAAAHgAhhgggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AHMD AQOQBgAkAAAAAQAAAAsAIoYIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAcwIBA5AGACQA AAABAAAACwAjhgggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAB8AgEDkAYAJAAAAAEAAAAD ACSGCCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAH8CAQOQBgAsAAAAAQAAAB4AJYYIIAYA AAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAC7AgEDkAYALAAAAAEAAAAeACaGCCAG AAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAvQIBA5AGACwAAAABAAAAHgAnhggg BgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAL8CAQOQBgAkAAAAAQAAAAsAKIYL IAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAAeQIBA5AGACQAAAABAAAACwAphgsgBgAAAAAA wAAAAAAAAEYAAAAABYgAAAAAAAB/AgEDkAYAFAAAAAEAAAAeAD0AAQAAAAEAAAAAAAAAXgAB A5AGAAwAAAABAAAAAwCAEP////+QBAEJAAQAAgAAAAAAAAABA5AGAAwAAAABAAAACwAjAAAA AAAvAAEDkAYADAAAAAEAAAALACkAAAAAADUAAQSQBgA8BAAAAgAAABIAAAADAAAwBAAAAAsA Dw4AAAAAAgH/DwEAAABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAT1JBQ0xFLUxAZmF0 Y2l0eS5jb20AU01UUABPUkFDTEUtTEBmYXRjaXR5LmNvbQAAHgACMAEAAAAFAAAAU01UUAAA AAAeAAMwAQAAABUAAABPUkFDTEUtTEBmYXRjaXR5LmNvbQAAAAADABUMAQAAAAIB+Q8BAAAA RwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABEE9SQUNMRS1MQGZhdGNpdHkuY29tAFNNVFAA T1JBQ0xFLUxAZmF0Y2l0eS5jb20AAAMA/g8GAAAAHgABMAEAAAAXAAAAJ09SQUNMRS1MQGZh dGNpdHkuY29tJwAAAgELMAEAAAAaAAAAU01UUDpPUkFDTEUtTEBGQVRDSVRZLkNPTQAAAAMA ADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8BAAAAFQAAAE9SQUNMRS1MQGZhdGNpdHkuY29t AAAAAAIB918BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAE9SQUNMRS1MQGZhdGNp dHkuY29tAFNNVFAAT1JBQ0xFLUxAZmF0Y2l0eS5jb20AAAMA/V8BAAAAAwD/XwAAAAACAfYP AQAAAAQAAAAAAAAEEgAAAAMAADAFAAAACwAPDgAAAAACAf8PAQAAAFMAAAAAAAAAgSsfpL6j EBmdbgDdAQ9UAgAAAQBKYXlNaWxsZXJAVERXYXRlcmhvdXNlLmNvbQBTTVRQAEpheU1pbGxl ckBURFdhdGVyaG91c2UuY29tAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAGwAAAEph eU1pbGxlckBURFdhdGVyaG91c2UuY29tAAADABUMAQAAAAIB+Q8BAAAAUwAAAAAAAACBKx+k vqMQGZ1uAN0BD1QCAAABEEpheU1pbGxlckBURFdhdGVyaG91c2UuY29tAFNNVFAASmF5TWls bGVyQFREV2F0ZXJob3VzZS5jb20AAAMA/g8GAAAAHgABMAEAAAAdAAAAJ0pheU1pbGxlckBU RFdhdGVyaG91c2UuY29tJwAAAAACAQswAQAAACAAAABTTVRQOkpBWU1JTExFUkBURFdBVEVS SE9VU0UuQ09NAAMAADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8BAAAAGwAAAEpheU1pbGxl ckBURFdhdGVyaG91c2UuY29tAAACAfdfAQAAAFMAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAA AQBKYXlNaWxsZXJAVERXYXRlcmhvdXNlLmNvbQBTTVRQAEpheU1pbGxlckBURFdhdGVyaG91 c2UuY29tAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABVru Received on Wed Jun 07 2000 - 20:36:21 CDT