What are the consequences of running out of ram with Oracle DB 10g?

So, the obvious problem is paging to disk and the resulting impact on performance. What other concerns would you worry about?

Regardless of the application, you'll end up with an OOM (Out-Of-Memory) condition and -depending on your system configuration- it may eventually lead to a kernel panic.