Home » Infrastructure » Unix » checking for memory
checking for memory [message #97279] Thu, 21 February 2002 02:12 Go to next message
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 #97281 is a reply to message #97279] Thu, 21 February 2002 05:03 Go to previous messageGo to next message
daeshik
Messages: 5
Registered: February 2002
Junior Member
try 'man pmap'.
Re: checking for memory [message #97286 is a reply to message #97279] Fri, 22 February 2002 10:51 Go to previous message
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 ;
Previous Topic: is it possible to undelete a file in UNIX if so how?
Next Topic: Re: Deleting file named *
Goto Forum:
  


Current Time: Sun Sep 27 02:00:51 CDT 2020