| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: x$ksmpp table question
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">
dump
the heap.
<FONT face=Tahoma
size=2>-----Original Message-----From: George Schlossnagle [<A
href="mailto:george_at_omniti.com">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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<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_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
 |
 |