Re: memory usage

From: Bjorn Naessens <bnaessens_at_roularta.be>
Date: Tue, 20 Feb 2001 02:11:00 -0800
Message-ID: <F001.002B8792.20010220021528@fatcity.com>

solution :
 

select <FONT color=#000000

size=2>a.<FONT color=#000000 
size=2>username,<FONT color=#000000 
size=2> b.<FONT color=#000000 
size=2>value from<FONT color=#000000 
size=2> v$session a,<FONT color=#000000 
size=2> v$sesstat b,<FONT color=#000000 
size=2> v$statname c 

w<FONT

color=#0000f0 size=2>here a<FONT 
color=#0000f0 size=2>.sid <FONT 
color=#0000f0 size=2>= b<FONT 
color=#0000f0 size=2>.sid <FONT 
color=#0000f0 size=2>and b<FONT 
color=#0000f0 size=2>.statistic<FONT 
color=#0000f0 size=2># <FONT 
color=#0000f0 size=2>= c.<FONT 
color=#000000 size=2>STATISTIC# 

and a<FONT color=#0000f0
size=2>.username<FONT color=#0000f0
size=2>!='SYSTEM'
 
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Bjorn Naessens To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  Sent: Monday, February 19, 2001 3:25
  PM   

  hello dba's ( again )
 

  i'm looking for a way to do a manual
  "top-session" on a database. According to TopSession from Oracle, the   information should be located in v$sessions. Anyone an idea how to read the   memory usage out of this table? In v$sess_io i'm able to get the amount of   physical reads, but I need the memory usage.
 

  thanks for any help
 

  Bjorn Naessens
  Roularta IT Solutions
 
Received on Tue Feb 20 2001 - 04:11:00 CST