We help IT Professionals succeed at work.

need to create a report for memory structure of oracle databases

dba1234
dba1234 asked
on
Hi,
I need to create a report for database, host memory structure,memory allocation,  What things should I considere.
Comment
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
I'm not understanding what exactly you are after.

You can get the current allocations of the SGA using the V$ views.

http://www.adp-gmbh.ch/ora/concepts/sga.html

Praveen Kumar ChandrashekatrDatabase Analysist Senior
Commented:
also you can look into this doc for SGA and PGA allocation of your DB.

http://www.dba-oracle.com/art_dbazine_ram.htm