Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: x$ksmpp table question
That was how I spotted the bad processes in the first place. Now I want details on what is swelling their pgas. x$ksmpp will give that for my own session, I want the same information for the sessions in question.
George
On Saturday, December 29, 2001, at 08:10 AM, Deepak Thapliyal wrote:
> george, try using pmap <pid>
>
> hth
> deepak
> --- George Schlossnagle <george_at_omniti.com> wrote:
>> 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:schlossnagle_at_pythian.com]
>> 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
>> -- schlossnagle_at_pythian.com
>> -- 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.
>>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deepak Thapliyal
> INET: deepakthapliyal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Schlossnagle INET: george_at_omniti.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Sat Dec 29 2001 - 11:26:49 CST
![]() |
![]() |