Login to sqlplus as a DBA, and run the command "show sga", this will give you idea of how much memory the database is using. The individual processes are actually using a portion of the SGA. You should also take a look at the parameter "sort_area_size" that defines how much memory an individual connection will use for sorting. This could be pushing up the total memory used if it's set too high.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.