DBA Hub

📋Steps in this guide1/2

How to Increase MEMORY_TARGET

To  increase memory in oracle database, we must first understand four oracle memory parameters which govern the instance.

oracle configurationintermediate
by OracleDba
13 views
1

Overview

To  increase memory in oracle database, we must first understand four oracle memory parameters which govern the instance. They are as Follows : - SGA_TARGET. SGA_TARGET. - SGA_MAX_SIZE. SGA_MAX_SIZE. - MEMORY_TARGET. - MEMORY_MAX_TARGET MEMORY_MAX_TARGET - SGA_TARGET : The SGA_TARGET defines the total size of SGA.SGA_TARGET parameter is a dynamic parameter. Syntax to check SGA_Target & to reset its vaule is given below :

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
show parameter sga_target;

alter system set sga_target = 10G;

show parameter sga_max_size;

alter system set sga_max_size = 12G scope=spfile;
2

Section 2

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
show parameter memory_target; 
alter system set memory_target = 5G;

show parameter memory_max_target;

alter system set memory_max_target = 7G scope=spfile;

select decode( grouping(nm), 1, 'total', nm ) nm, round(sum(val/1024/1024)) mbfrom(select 'sga' nm, sum(value) valfrom v$sgaunion allselect 'pga', 
sum(a.value)from v$sesstat a, v$statname bwhere b.name = 'session pga memory'and a.statistic# = b.statistic#)group by rollup(nm);

SELECT * FROM v$sgainfo;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!