I've heard anywhere from 5 to 6 weeks for a hood piercing to heal. I mean think about it, you have an open wound with a piece of metal sticking through it in a very sensitive area. You don't want that to rip, or get infected. And sex would only increase the healing time. You have to give it time.
I would love to get one or two rungs of a "Jacob's Ladder", but the healing time is the same so I don't think I will. At least for now.
For more on healing time and a good message board for piercing issues check out
www.tribalectic.com.