| Tune SGA urgent [message #65808] |
Thu, 30 December 2004 19:39  |
Raj
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  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
See chapter chapter 19: "Tuning Memory Allocation" in the "Oracle8i Designing and Tuning for Performance" guide.
Best regards.
Frank
|
|
|
|
| Re: Tune SGA urgent [message #65845 is a reply to message #65808] |
Tue, 11 January 2005 19:26 |
jp
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.
thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
