FWIW, I set all the Opera cacheing to zero, have it clear all the history on exit, etc. I've run it for several hours at a time (512 M, no swap file) without it blowing.
On the other hand, large downloads will freeze the box unless you direct them to disk or USB. The default download area is in memory and I got stuck a couple of times.
edit: I use the tcz Opera extension.