| 10g Why sga_target is not being used. [message #145551] |
Thu, 03 November 2005 14:49  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Oracle version 10.1.0.2 (10g) on a Solaris 9 Sun Server V880 64 bit with 8 processors and 32 gigs RAM.
Why does it not want to use any more memory??? We have about 1000 users on.
The sga_target initlization parameter is set to 8 gigs.
The sga_max_size initlization parameter is set to 10 gigs.
The PGA_target initlization parameter is set to 3 gigs.
This server is running one instance and no other software.
It is only using about 2 gigs??? And another 2 for PGA. Why would it not want more memory? I thought it was supposed to morph itself to use more or less memory when needed.
|
|
|
|
|
|
|
|
| Re: 10g Why sga_target is not being used. [message #145915 is a reply to message #145551] |
Mon, 07 November 2005 11:43  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Oracle support insists that if the instance wants more it will take it up to the SGA_MAX_SIZE. Also the PGA will alocate more if it wants. I guess at some point more memory is does not help the bottle neck.
The bottle neck is, on this system, flushing dirty blocks to disk. It can only write to disk at a set speed and having more memory does not help that. I have increased the number of dbwr, lgwr, and arc processes.
Thanks for the help!
[Updated on: Mon, 07 November 2005 11:45] Report message to a moderator |
|
|
|
 Re: 10g Why sga_target is not being used. [message #146345 is a reply to message #145551] |
Wed, 09 November 2005 23:45 |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
I believe you must also be running a spfile rather than a pfile.
Create spfile from pfile = '$ORACLE_HOME/dbs/init<sid>.ora';
then rename $ORACLE_HOME/dbs/init<sid>.ora
then bounce the db
Don't ever edit or otherwise touch the spfile!!!
You alter it via the alter database, alter system, and other indirect methods. I think you need to use the V$parameter file to view the settings?
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
