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
more.
Received on Thu Dec 27 2001 - 13:20:05 CST
