Re: x$ksmpp table question

[George Schlossnagle]

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   ----- Original Message ----- From: Khedr, Waleed To: Multiple recipients of list ORACLE-L Sent: Thursday, December 27, 2001 3:50 PM Subject: RE: x$ksmpp table question dump the heap. -----Original Message----- From: George Schlossnagle [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Subject: 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   ----- Original Message ----- From: Khedr, Waleed To: Multiple recipients of list ORACLE-L Sent: Thursday, December 27, 2001 2:20 PM Subject: RE: x$ksmpp table question George,   You can get the PGA information you're looking for from v$sesstat Query v$statname: select * from v$statname where name like '%pga%' get the statistic# and query v$sesstat for that session.   Waleed -----Original Message----- From: George Schlossnagle [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 2:00 PM To: Multiple recipients of list ORACLE-L Subject: 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   --- http://www.pythian.com --  [EMAIL PROTECTED] --  877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more.