Sizing Doubt

From: H. KARTHIKEYAN <h.karthikeyan_at_tatainfotech.com>
Date: Fri, 14 Jul 2000 14:44:27 +0530 (IST)
Message-Id: <10558.112029@fatcity.com>

Hi group

I have a doubt on sizing SGA. Given a database size say x GB, how do u size SGA(db_block_buffers,Shared_pool_size) & Sort_area_size. Is there a structured way of doing the above sizing?.

What is the impact of these parameters on OLTP system and DW system.

TIA

---

H.Karthikeyan
Tata Infotech Ltd.,
System Integration Division,
80 Feet Road, Indira Nagar, Bangalore.
Ph: (80) 528 4681 (off) Ext: 423
E-mail: h.karthikeyan_at_tatainfotech.com

---

Received on Fri Jul 14 2000 - 04:14:27 CDT