| checking for memory [message #97279] |
Thu, 21 February 2002 02:12  |
Srinivas.ch
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
hello
please help me
How can i check oracle processes(sessions) are taking how much memory(RAM) in the unix (sun solaris)Database Server?
Srinivas.ch
|
|
|
|
|
|
| Re: checking for memory [message #97286 is a reply to message #97279] |
Fri, 22 February 2002 10:51  |
Jaosn
Messages: 3
Registered: February 2002
|
Junior Member |
|
|
Since most processes will have their own PGA you'll have to query the database to find the amount of memory they are using:
select i.sid sid,
i.username username,
s.value value
from v$sesstat s,
v$statname n,
v$session i
where s.statistic# = n.statistic# and
s.sid = i.sid and
n.name = 'session uga memory max' and
i.username is not null
order by value ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
