Is it normal to have awful night sweat a lot?

Perhaps it's the temperature of where you sleep. Or maybe you're having graphic dreams that you can't remember.