Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP in /tmp?

Re: TEMP in /tmp?

From: Ross Mohan <postmaster_at_127.0.0.1>
Date: Thu, 13 May 1999 03:58:59 -0400
Message-ID: <7he031$m7a@dfw-ixnews7.ix.netcom.com>


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.

Chris Hamilton wrote in message <3738fcce.2114343_at_news.erols.com>...
>On Tue, 11 May 1999 23:28:54 -0400, "Ross Mohan"
><postmaster_at_127.0.0.1> wrote:
>
>>Have any of you cowboys or cowgirls out there tried putting the TEMP
>>tspace into the unix /tmp fsystem when the latter was actually memory
>>hosted?
>>
>>If you have direct or solid anecdotal experience, I'd sure like to hear
your
>>tale....
>>
>
>Haven't tried it, but I would think that if the machine was rebooted,
>and the contents of /tmp are automatically cleared at system startup,
>then ... AMF to your temp tablespace.
>
>Chris
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Christopher Hamilton
>Oracle DBA -- Wall Street Sports
>chris_at_wallstreetsports.com
>http://www.wallstreetsports.com/
Received on Thu May 13 1999 - 02:58:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US