if the table is accessed frequently, it will likely be in memory ,
especially if you create it with the CACHE option -- of course you'll have
the RAC associated overhead, but since you'd have to contend with RAC issues
anyway it makes sense to let Oracle handle it rather than come up with a
custom solution using pipes or alerts or such.
"gdb_dsr" <ge_2000_2001_at_yahoo.com> wrote in message
news:6299d152.0310302339.1eb23027_at_posting.google.com...
> Mark,
> Thanks for your response.
>
> I am actually looking for some entity that resides in memory (no, well!
> minimal disk activity is ok as I am not interested in *any* log data)
> and can be seen across RAC instances just like table and changes made
> to it should reflect both sides. My sessions generate data/change/access
> finally discard the data and free the resources.
> I am considering to use regular table with "_disable_logging" at least
> to turn off redo, undo log, I know the down side of it but I dont know
> any better option.
>
> Thanks
> Raju
>
>
> "mcstock" <mcstockx_at_xenquery.com> wrote in message
news:<o5mdncx9K5DAMDyiRVn-iA_at_comcast.com>...
> > oracle temporary tables are designed to hold session-specific data
> >
> > if you need to see data from other sessions, the data must be committed
in
> > standard oracle tables
> >
> > if the data that needs to be seen across sessions must be cleaned up at
the
> > end of the session, create a BEFORE LOGOFF trigger to do the clean-up
> >
> > --
> > ----------------------------------------
> > Mark C. Stock
> > www.enquery.com
> > (888) 512-2048
> >
> >
> > "gdb_dsr" <ge_2000_2001_at_yahoo.com> wrote in message
> > news:6299d152.0310301547.1ac25287_at_posting.google.com...
> > > Hi,
> > >
> > > Is it possiable to see the data of other sessions
> > > and their updates. I need a temporary table to be
> > > accessesed (I see the name but no data from other
> > > session connected to second instance) from two
> > > different sessions in 9i RAC environment. I can
> > > not find it in oracle docs. Wondering if you
> > > have gonethrough this.
> > >
> > > Thanks, Raju
Received on Fri Oct 31 2003 - 05:44:05 CST
