Is there anyway I can tell how much free space is left in SGA area? For example, if I want to increase the size of the buffer cache or the shared pool, I would like to know how much space in sga is available for me.
Thanks for the reply. What I want to find out is how much space is left in sga_max_size. So, if I need to increase the size of a particular cache buffer or the shared pool, I know how much more I can increase the size. Any idea?