Re: Any possible way to view global temp table data for another active session?
Date: Tue, 2 Feb 2010 09:09:36 -0800 (PST)
> From: Adam Musch <ahmusch_at_xxxxxxxxx>
> The only way I can think of is with a block dumps of the temporary
> segments in use by the other session, assuming *that's* even
> possible. It might get the data, but unscrambling the egg ...
I agree. The data is there except you don't know the starting and ending offsets. You can easily test this by
alter system dump tempfile [tempfile#] block min  block max 
where [tempfile#] is segfile# in v$tempseg_usage minus db_files,  is [segblk#] and  is a few numbers above it. (You may narrow it down to one single block.)
oradebug dump heapdump 1025
also gives you the data mingled with other things.
The only use of this dump (from file or memory) is when you already know most of the data and miss just a little. E.g, you know the data is the string '1-800-123-4?67' except the single digit marked as ?.
Yong HuangReceived on Tue Feb 02 2010 - 11:09:36 CST