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:
Post Comments (Atom)
The Database is not accessible after creating Always On Availability Group
Having created a fully functional SQL Server Always On Availability Group, I connect using SSMS. Upon trying to expand the database, I get ...
-
Most of what we're going to want to look at when you're having production issues are available through DMV's. If granti...
-
BibleGateway.com - Passage Lookup: John 10:7, 9-10 9I am the gate; whoever enters through me will be saved.[a] He will come in and go out, a...
-
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...
No comments:
Post a Comment