RE: memory usage

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Tue, 20 Feb 2001 08:42:47 -0800
Message-ID: <F001.002B8B25.20010220075550@fatcity.com>

Am I
the only one who gets garbage out of this query? There's a mismatch on v$statname. Which statistic are you suggesting to display, uga or pga memory?

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Bjorn Naessens   [mailto:bnaessens_at_roularta.be]Sent: Tuesday, February 20, 2001 5:15   AMTo: Multiple recipients of list ORACLE-LSubject: Re:   memory usage
  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=#0000f0 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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Bjorn Naessens To: <A href="mailto:ORACLE-L_at_fatcity.com" title=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 - 10:42:47 CST