Re: x$ksmpp table question

- 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 info

Re: x$ksmpp table question

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$statnam

Re: x$ksmpp table question

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

RE: x$ksmpp table question

dump the heap. -Original Message-From: George Schlossnagle [mailto:[EMAIL PROTECTED]]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

Re: x$ksmpp table question

: 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 M

RE: x$ksmpp table question

[mailto:[EMAIL PROTECTED]]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

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