Home » RDBMS Server » Performance Tuning » Tune SGA urgent
Tune SGA urgent [message #65808] Thu, 30 December 2004 19:39 Go to next message
Messages: 411
Registered: November 1998
Senior Member
i have installed oracle 8i (1.7) on windows2000 advance server.
It has Intel Xeon Processor and 2 GB RAM.
we are running one instance .
and total database size is about 100gb..
we are having around 100 active connections

Now i want to tune the server parameter ,specially SGA

please help
Re: Tune SGA urgent [message #65810 is a reply to message #65808] Thu, 30 December 2004 23:08 Go to previous messageGo to next message
Frank Naude
Messages: 4578
Registered: April 1998
Senior Member

See chapter chapter 19: "Tuning Memory Allocation" in the "Oracle8i Designing and Tuning for Performance" guide.

Best regards.

Re: Tune SGA urgent [message #65845 is a reply to message #65808] Tue, 11 January 2005 19:26 Go to previous message
Messages: 11
Registered: August 2000
Junior Member
Thanks Frank. Raj please go through the Oracle Manual. It's really helps.

Just for quick understanding, Please let us know which type of database you are using. Is it OLTP or DW Type?

Depend upon the behaviour of the database SGA will be allocated.

Based on your table nature, you can split Buffer Cache in
1. Default buffer cache (as general)
2. KEEP buffer pool (For small like master/lookup type of tables)
3. RECYCLE buffer pool (Purging in nature table)

Your tablespace should be designed effectively if required, to restrict fragmentation for purging tables.

Previous Topic: checking fragmentation
Next Topic: Execution stats shown on Toad
Goto Forum:

Current Time: Sun Feb 25 22:13:49 CST 2024