How to obtain session-specific memory dumps?
Date: Mon, 17 Aug 2009 11:34:54 -0500 (CDT)
In 10.1, we have a recurring situation where a user (or users) will attempt 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 down 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 thin-client 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 perhaps the UGA may hold some key information about the user that's not immediately 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 for the data stored within the chunks. There is of course little information on the undocumented oradebug tool.
I realize that there may be security implications with this, but thought the question deserved posting anyway. Feel free to reply privately if a public posting isn't desirable.