Re: RAM Disks Revisited

In article <92182.084951KML110_at_psuvm.psu.edu>, <KML110_at_psuvm.psu.edu> writes...
>To improve our sort performance, we can either (1) increase the sort area in
>the SGA - already pretty much maxed out and forced into contention with other
>users of the SGA, which is limited in VMS to 32M - or put the temp tablespace
>on the fastest disk possible, a RAM disk. Alter TEMP offline, backup the file
>to the RAM disk, alter online, and the TEMP tablespace is now in its own
>section of memory, ready to fly. The problem, though, is that a node shutdown
>will nuke the temp tablespace file.

 [...]
>DEC of Canada suggested using an ESE50 disk.

That would have been me, speaking for myself NOT my employer, please keep this in mind in future.

How about this, haven't tried it so don't know if it will work, things may blow up trying to rollback any transactions which were active when the crash occurred.

After the crash do a startup nomount, mount only the system tablespace and drop the temp tablespace, shutdown and do a regular startup and recreate the temp tablespace.

Norm

--
    Norman Soley, Specialist, Professional Software Services, ITC District
    Digital Equipment of Canada                   soley_at_trooa.enet.dec.com
    Opinions expressed are mine alone  and do not reflect those of Digital 
    Equipment Corporation or my cat Marge.