Re: Temporary tables in memory

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0309021519.1dec21ff_at_posting.google.com>...
> chris_jack_at_msn.com (Chris Jack) wrote in message
> > If there is a method of storing the Oracle temporary tablespace in
> > memory, then I would agree it was similar to Sybase and similarly
> > efficient - however I have been unable to find a way of putting the
> > Oracle temporary tablespace in memory in the Oracle manual. Based in
> > the replies to date, it would appear it is not possible.
>
> It is not in the Oracle manuals, because it is done in the OS. If you
> are on Linux, and some other unix, there are built-in devices (perhaps
> /tmp) that are in-memory disklike devices. On hp-ux, it is used to
> build the system but not in normal usage, I posted the (untested by
> me) general instructions for building such a beast a while back. In
> general, you would have to add the tablespace after bringing up
> Oracle, and be prepared to deal with the consequences of restarting
> after a crash. It's not too tough, although it might be for a novice
> using sybase-think.
>
> There are also hardware devices that substitute memory for disks,
> which of course have their own idiosyncracies. http://www.desdbx.com/
> "The New Rules of Deployment" on oaktable.net
> http://metalink.oracle.com/cgi-bin/cr/getfile.cgi?p_attid=76413.1:219101

This sounds promising - I will investigate further. Thank you for your help,

Regards
Chris Received on Wed Sep 03 2003 - 10:40:44 CDT