RE: x$ksmpp table question

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Thu, 27 Dec 2001 13:08:17 -0800
Message-ID: <F001.003E352D.20011227125022@fatcity.com>

dump
the heap.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: George Schlossnagle   [mailto:george_at_omniti.com]Sent: Thursday, December 27, 2001 3:35   PMTo: Multiple recipients of list ORACLE-LSubject: Re:   x$ksmpp table question
  I want access to the fll heap structure   though.   My process pga is huge, I want to see what the allocations   are.
   
  George
   
  <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: Khedr, Waleed To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

    Sent: Thursday, December 27, 2001 2:20     PM
    Subject: RE: x$ksmpp table
    question     

<FONT face=Arial color=#0000ff

    size=2>George,
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>You can get the PGA information you're looking for from     v$sesstat
<FONT face=Arial color=#0000ff

    size=2>Query v$statname: select * from v$statname where name like     '%pga%'
<FONT face=Arial color=#0000ff

    size=2>get the statistic# and query v$sesstat for that     session.
<FONT face=Arial color=#0000ff

    size=2> 
<FONT face=Arial color=#0000ff

    size=2>Waleed     

      <FONT face=Tahoma 
      size=2>-----Original Message-----From: George Schlossnagle [<A 
      href="mailto:schlossnagle_at_pythian.com">mailto:schlossnagle_at_pythian.com]Sent: 
      Thursday, December 27, 2001 2:00 PMTo: Multiple recipients of 
      list ORACLE-LSubject: x$ksmpp table 
      question
      I have a question about the x$ksmpp 
      table.  Supposedly (according to Steve Adams' internals book) is 
      the reference table for the heap allocation for a processes 
      pga.  I assume this means for a processes own pga.  If so, is it 
      possible  (and if so how) to access the same data for an arbitrary 
      shadow process (in particular, not the one associated with the ssession 
      running the query).
       
      Thanks,
       
      George
       
      --- <A 
      href="http://www.pythian.com">http://www.pythian.com --  <A 
      href="mailto:schlossnagle_at_pythian.com">schlossnagle_at_pythian.com 
      --  877-PYTHIANSmarter than adding another team member, 
      Pythian has new services forsupplementing DBAs: get our help with 
      monitoring, 24x7 on-call, dailyverifications, storage management, 
      performance and 

more. Received on Thu Dec 27 2001 - 15:08:17 CST