The profile folder is where Opera stores its (basically yours) data such as history, passwords, extensions, settings and so on.
To find the path to the profile directory go to Menu > About Opera or type opera://about in address bar