Hello!
To make long story short, Avast seems to make Opera’s RAM usage skyrocket when visiting some websites.
http://www.wilderssecurity.com/showthread.php?t=255664
I use only standard shield with default scanning settings. Version 4.8
Ok, this is caused when Opera is set to accept cookies only from the visited site. The issue isn’t only Avast limited, the same happened with Vipre. So it must be an Opera quirk.
Welcome to the forums, Fuzzfas. 
Thanks for posting the information.
Please come back often and learn more.