One problem is that many Flash plugins seem to trigger Java when they do not need such functionality. As the whole Java framework is loaded into memory, this can inflate Opera's memory use.
To test if this has happened you can use Process Explorer to see which DLLs Opera has loaded. If Java is loaded you will see something like:
As a test to see if Java loads, try this page (the embedded Flash uses LiveConnect):