Performance -> Memory

Memory Summary displays how much memory is dedicated to PGA and SGA (in megabytes):

• Inst - instance id for which data is displayed
• SGA BC - amount of memory dedicated to Buffer Cache
• SGA Other - amount of memory dedicated to all other parts of SGA
• PGA Used - amount of PGA memory used
• PGA Free - amount of PGA memory free

Table bellow displays amount of PGA memory occupied by session

• Session - session id for which the data is displayed. It contains a link to session details.
• Username - database username for this session
• Program - program name for session
• PGA Used MB - amount of PGA currently used
• PGA Alloc MB - amount of PGA memory currently allocated
• PGA Max MB - amount of PGA memory allocated at the peak point of the session.

Buffer Cache Contents

This view displays contents of Buffer Cache. It is based on gv$bh view.

• Inst ID - instance ID for which data is displayed
• Class Name - Name of class (type/what is cached)
• Object Owner - Owner of the table/object which is cached
• Object Name - Name of the table/object which is cached
• Block Size - Block size of the tablespace for the segment of this table/object
• Block Count - Amount of blocks cached
• Usage MB - amount of MB cached for this object