Home » RDBMS Server » Server Administration » Dynamic Memory Allocation Question
Dynamic Memory Allocation Question [message #250461] Tue, 10 July 2007 02:29 Go to next message
Messages: 6
Registered: March 2002
Junior Member
Hello, I am used to using Oracle 8i and understood how to set SGA sizes etc. However, not so with Oracle 9i! please help.

My situation:
- I have a 'data warehouse' Style app running on Oracle 9i - I do not need to dynamically change any memory settings (ever). I am happy to re-analyse the situation every 4-6 months and make changes then (with or without bouncing the DB)

- I want to allocate a third of my physical memory to Oracle (FYI the remaining 2/3 will be given to 2 other apps - 1/3 each)
Machine has 3 Gigs of RAM on it

- In Oracle 8i I had simply set:
buffer cache (db_block_buffers * db_block_size) = 0.5 GB
shared_pool = 0.5 GB
I realise that means the SGA will actually be a bit bigger than 1 GB because of Java_pool etc. etc. but that's OK... I want to allocate approx 1GB to the database

How do I achieve the same in 9i?
Specifically I dont understand the diff between Sga_max_size and Total SGA...??

Thanks very much!
Re: Dynamic Memory Allocation Question [message #250604 is a reply to message #250461] Tue, 10 July 2007 11:04 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess this might help you.

Previous Topic: Process associated with Database
Next Topic: Statpack Error
Goto Forum:

Current Time: Sat Aug 19 02:38:13 CDT 2017

Total time taken to generate the page: 0.02357 seconds