This article is just to remember some links that I found while working on some database issues. Maybe they will help someone else:
Viewing the Large Pool Size (from here):
SELECT name, SUM(bytes) FROM V$SGASTAT WHERE pool='large pool' GROUP BY ROLLUP(name);
Here are the command to view the different memory related settings/parameters (from here):
show parameter sga_target show sga show parameter pool
Flushing cache, etc. (from here)
alter system flush buffer_cache; alter system flush shared_pool; alter system switch log_file;