Is celibacy effective?

Multiple years without any sex? Singer Lenny Kravitz says he did it! But how does a regular person navigate celibacy?