Re: TEMP in /tmp?

From: <larionov_at_yahoo.com>
Date: Thu, 13 May 1999 21:09:46 GMT
Message-ID: <7hff2o$t0j$1@nnrp1.deja.com>

In article <7he031$m7a_at_dfw-ixnews7.ix.netcom.com>, "Ross Mohan" <postmaster_at_127.0.0.1> wrote:
> Right.....an orderly shutdown would include an oracle shutdown
> that dropped it. A disorderly shutdown might require some kind
> of oddball recovery, but....probably straightforward stuff....just
think
> of the sorting benefits, etc.

Just wondering, why would somebody put the temporary tablespace in /tmp where you can just increase the parameter sort_area_size and reap the benefits of sorting in the memory. If sort area in the memory is not enough it will be complemented with the temp tablespace ( which you can put on raw devices to improve performance ).

Misha.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 13 1999 - 16:09:46 CDT