-
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';
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|