It's often used to express:
* Surprise or excitement: "Oo la la, that's a beautiful dress!"
* Pleasure or enjoyment: "Oo la la, this food is delicious!"
* Desire or attraction: "Oo la la, you look so handsome tonight!"
However, while "oo la la" is understood by French speakers, it's not something they would say themselves.