Wednesday, November 27, 2019
Changing SGA & PGA memory for Oracle
The following can give good info on target memory advice after your system has been running for some time. It is cleared during restart
select * from V$MEMORY_TARGET_ADVICE ;
BACKUP your SPFILE before doing any radical changes.
Example location ~ D:\oracle\product\12.1.0\dbhome_1\database
To set pga to 1 gb and sga to 3 g, enter the following commands:
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE = SPFILE;
ALTER SYSTEM SET sga_target=3G SCOPE = SPFILE;
You will need to restart your Oracle database.
And, Bob's your uncle, you should have your PGA and SGA set to the new target values.
Subscribe to:
Posts (Atom)
DBT-50000 when using DBCA.bat on Windows (Oracle 19.11)
I’ve been having some trouble getting DBCA to run in order to create databases. Thought I’d share it with you, and thus document it for la...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
I was not able to find what I considered a good, clear reference for this when I recently encountered it at a customer installation. I fou...
-
I spent a lot of time on this one, and it wasn't clear from examples precisely how the various items should be used together. The form...