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:

1.  Shared Pool Advisor
2.  Buffer Cache Advisor
3.  PGA Advisor