SGA Utilization

From: amit <amit.shivpuri_at_gmail.com>
Date: 20 Dec 2006 17:24:56 -0800
Message-ID: <1166664296.110890.62830@80g2000cwy.googlegroups.com>

Hi all,

Please, can anyone put some light on how we can check the SGA utilzation.

Scenario-

---

Database: Oracle 9i
SGA_MAX_SIZE: 2gb Initially
Total SGA allocated size: 1gb Initially

Now how can we check that out of 1GB how much SGA is getting utilitzed. If 1gb is sufficient or we need to increase the size.

Thank
amit Received on Wed Dec 20 2006 - 19:24:56 CST