Re: How to obtain session-specific memory dumps?
Date: Tue, 18 Aug 2009 16:40:56 +0100
If you can enable trace then they'll be in the 10046. As for dumping the uga I *think* there's an event for that, I'll look it up when I get back. If not I expect Tanel Poder has something on his site.
On 8/18/09, Rich Jesse <rjoralist_at_society.servebeer.com> wrote:
> No takers? How's about this: Can I get the bind variable values for a
> specific statement as run by a specific process? I can see the statement in
> an ORADEBUG DUMP PROCESSSTATE, but not sure how to go about getting the bind
> values for it as it was run (v$sql_bind_capture will not work as it's very
> unlikely that this process will have executed that statement last).
> So close...
>> In 10.1, we have a recurring situation where a user (or users) will
>> to pull large tables through a Websphere v5 app. The Websphere "node" (I
>> think it's called) will heapdump from the large amount of data, taking
>> every user connected to that node. The dump contains no identifiable
>> information in it to tie the query back to the offending user. And since
>> the connection to Oracle uses generic DB logins and is made via
>> or JDBC, which lacks client information, I can't tell from the DB who the
>> user is.
>> Upgrading any component is not currently possible. My hope is that
>> the UGA may hold some key information about the user that's not
>> apparent nor available. For example, application login information.
>> I've been experimenting with using "oradebug dump heapdump" from SQL*Plus,
>> but all it returns is information about the memory chunks. I'm looking
>> the data stored within the chunks. There is of course little information
>> the undocumented oradebug tool.
-- Sent from Google Mail for mobile | mobile.google.com Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 18 2009 - 10:40:56 CDT