1) What tables/columns can I look at to find out how much memory each user connection is using and also to sum them.

2) Is memory used for client connections taken from the shared_pool?

3) What does boosting the FIXED_SGA affect?

4) In the following query does "free memory" refer to what's available in the shared pool???


select NAME "PARAMETER",
to_char(BYTES, '999,999,999,999') "VALUE"
from v$sgastat
where name = 'free memory';