Re: Any possible way to view global temp table data for another active session?
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: kjped1313@xxxxxxxxx
- 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@xxxxxxxxx>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@xxxxxxxxxxxxxxxx>* wrote:
>
>
> From: Steve Baldwin <stbaldwin@xxxxxxxxxxxxxxxx>
> Subject: Re: Any possible way to view global temp table data for another
> active session?
> To: brent_day@xxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxx<http://us.mc320.mail.yahoo.com/mc/compose?to=brent_day@xxxxxxxxxxx>>
> 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
> >
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
--
Adam Musch
ahmusch@xxxxxxxxx
Other related posts:
