Re: Any possible way to view global temp table data for another active session?

From: Adam Musch <ahmusch_at_gmail.com>
Date: Tue, 2 Feb 2010 00:17:55 -0600
Message-ID: <516d05a1002012217n345c6a44mf381a40218e636b8_at_mail.gmail.com>

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.
> http://www.linkedin.com/in/kellynpedersen
> www.dbakevlar.blogspot.com
>
> "Go away before I replace you with a very small and efficient shell
> script..."
>
>
> --- 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>>
> wrote:
> > I am looking for a way to grab a snapshot of data or view the current
> data
> > from another session's global temporary table data?
> > Is this even possible?
> > Thanks
> > Brent
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

-- 
Adam Musch
ahmusch_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 02 2010 - 00:17:55 CST