Re: Any possible way to view global temp table data for another active session?
Date: Tue, 2 Feb 2010 00:17:55 -0600
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 -- or, perhaps, unbaking the cake, as I don't know how GTT data would be intermingled with other session specific data -- would be left as an exercise for the reader.
On Mon, Feb 1, 2010 at 10:05 PM, Kellyn Pedersen <kjped1313_at_yahoo.com>wrote:
> Unless someone else is aware of magic that I'm not, I agree with Sir
> Baldwin below. I had a few GTT that we used in our old mart code and I
> hated data issues that I couldn't track in the darn things as they happened!
> Kellyn Pedersen
> Multi-Platform DBA
> I-Behavior Inc.
> "Go away before I replace you with a very small and efficient shell
> --- On *Mon, 2/1/10, Steve Baldwin <stbaldwin_at_multiservice.com>* wrote:
> From: Steve Baldwin <stbaldwin_at_multiservice.com>
> Subject: Re: Any possible way to view global temp table data for another
> active session?
> To: brent_day_at_comcast.net
> Cc: oracle-l_at_freelists.org
> Date: Monday, February 1, 2010, 4:31 PM
> I'm almost certain the answer is <NO>. If you want to do this you'll
> need to use a 'regular' table or some other IPC mechanism.
> On Tue, Feb 2, 2010 at 9:00 AM, <brent_day_at_comcast.net<http://us.mc320.mail.yahoo.com/mc/compose?to=brent_day_at_comcast.net>>
> > I am looking for a way to grab a snapshot of data or view the current
> > from another session's global temporary table data?
> > Is this even possible?
> > Thanks
> > Brent
-- Adam Musch ahmusch_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 02 2010 - 00:17:55 CST