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