Re: Oracle on ram drive with no redo log or other archiving

robertbrown1971_at_yahoo.com wrote:
>
> 3) What other files besides that data files for the tablespaces used by
> tests need to be in RAM drive for fastest performance. In other words,
> if I have a regular oracle account and just execute vanilla updates
> where does Oracle write to besides the redo log and the data files.
>

YMMV, but for my applications the most-written data files are the undo.  The size necessary is based on concurrency requirements and transaction size, among other things.

jg

--
@home.com is bogus.
Metadata finally makes it into the dictionary:
http://news.yahoo.com/s/nm/20051004/od_nm/life_words_dc;_ylt=AvG_ucHXXLrSSAkmgG7eI0.ek3QF;_ylu=X3oDMTA3NW1oMDRpBHNlYwM3NTc-