From schlossnagle@pythian.com Thu, 27 Dec 2001 13:45:25 -0800
From: "George Schlossnagle" <schlossnagle@pythian.com>
Date: Thu, 27 Dec 2001 13:45:25 -0800
Subject: Re: x$ksmpp table question
Message-ID: <F001.003E35E2.20011227132026@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Ok...  but that doesn't answer my original 
question either and I also then have to post-process it.  If I could query 
x$ksmpp for it, then I could get the info online.  
 
'You can't do it' is a fine answer as 
well....
 
 
george
 
<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: 
  Khedr, 
  Waleed 
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Thursday, December 27, 2001 3:50 
  PM
  Subject: RE: x$ksmpp table question
  
  dump 
  the heap.
  
    <FONT face=Tahoma 
    size=2>-----Original Message-----From: George Schlossnagle [<A 
    href="mailto:george@omniti.com">mailto:george@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="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: 
      Khedr, 
      Waleed 
      To: <A 
      href="mailto:ORACLE-L@fatcity.com" title=ORACLE-L@fatcity.com>Multiple 
      recipients of list ORACLE-L 
      Sent: Thursday, December 27, 2001 
      2:20 PM
      Subject: RE: x$ksmpp table 
      question
      
      <FONT color=#0000ff face=Arial 
      size=2>George,
      <FONT color=#0000ff face=Arial 
      size=2> 
      <FONT color=#0000ff face=Arial 
      size=2>You can get the PGA information you're looking for from 
      v$sesstat
      <FONT color=#0000ff face=Arial 
      size=2>Query v$statname: select * from v$statname where name like 
      '%pga%'
      <FONT color=#0000ff face=Arial 
      size=2>get the statistic# and query v$sesstat for that 
      session.
      <FONT color=#0000ff face=Arial 
      size=2> 
      <FONT color=#0000ff face=Arial 
      size=2>Waleed
      
        <FONT face=Tahoma 
        size=2>-----Original Message-----From: George Schlossnagle 
        [<A 
        href="mailto:schlossnagle@pythian.com">mailto:schlossnagle@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@pythian.com">schlossnagle@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.