The memory advisor gives graphical analysis of SGA and PGA settings, which we can use for what-if planning. The SGA and PGA target initialization parameters determine the amount of physical memory available to the database.

Three memory advisor parameter in Oracle: