DBA Hub

📋Steps in this guide1/1

How to Check Oracle Instance Size

Show parameter memory_target;

oracle configurationintermediate
by OracleDba
14 views
1

Overview

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
Show parameter memory_target;

show parameter memory_max_target;

show parameter sga_target;
show parameter sga_max_size;

show parameter pga_aggregate_target;

show parameter pga_aggregate_limit;

so, Instance Size=SGA_TARGET+PGA_AGGREGATE_TARGET

Comments (0)

Please to add comments

No comments yet. Be the first to comment!