Advice

How does Oracle determine SGA and PGA size?

by Author

How does Oracle determine SGA and PGA size?

The Oracle DBA can use math to determine the optimal RAM allocation for a MS-Windows server….The total RAM SGA and PGA estimates for Oracle are as follows:

  1. OS RAM : 20 percent of total RAM for MS-Windows, 10\% of RAM for UNIX.
  2. Oracle SGA RAM : determined with the show sga command.

How do you change SGA and PGA size in Oracle 11g?

Connect to the database sysdba sqlplus sys/oracle@op as sysdba 2. Increase sga_max_size to 6 GB as below SQL> ALTER SYSTEM SET sga_max_size=6144m scope=spfile; System altered. 3. Increase pga_aggregate_targe to 3 GB as below SQL> ALTER SYSTEM SET pga_aggregate_target= 3072MB SCOPE=spfile; 4.

READ ALSO:   Where can you live if you only speak English?

What is SGA and PGA in Oracle 11g?

The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. A PGA is a nonshared memory region that contains data and control information exclusively for use by an Oracle process.

How are PGA and SGA related?

The PGA is memory specific to an operating process or thread that is not shared by other processes or threads on the system. Because the PGA is process-specific, it is never allocated in the SGA. The PGA is a memory heap that contains session-dependent variables required by a dedicated or shared server process.

What is difference between SGA and PGA Oracle?

1 Answer. The SGA is a memory structure on the server that contains pools to hold code, SQL, classes, cursors, etc. and caches to hold data. The PGA is a shared memory area for a user server process and is used for temporary storage and work areas.

READ ALSO:   Why is toothpaste not safe to swallow?

What is difference between SGA and PGA in Oracle?

What is a PGA in Oracle?

A Program Global Area (PGA) is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process.

https://www.youtube.com/watch?v=9JwcP36T9AI