|
|
| Re: Calculating average memory used by oracle connections [message #59281 is a reply to message #59269] |
Sat, 08 November 2003 05:38  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
It depends on the OS and whether you are using Dedicated or Shared servers.
In Dedicated config,each user session is associated with a single Oracle Server process and hence its the size allocated to the Server process.
In MTS(ie Shared), multiple user sessions can use the same Shared server and the same user session can be serverd by multiple Shared servers.
On Solaris for eg, at the OS level, you can use ps ,pmap etc to determine the process sizes. But make sure to subtract the SGA and TEXT size from the reported value, becos its the shared memory and thats included with every process size.
From within Oracle,you can determine how much memory each session is consuming using the following query:
select value, n.name|| '('||s.statistic#||')' , sid
from v$sesstat s , v$statname n
where s.statistic# = n.statistic#
and n.name like '%ga memory%'
order by value;
Yes,Inactive sessions too consume memory,although it could vary .
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
