The conditioned soul is attached to the bodily conception of the self, and therefore he is in ignorance. Culture of self-knowledge can bring about detachment from material affection, and without such detachment there is no meaning to knowledge. The most stubborn attachment for material enjoyment is sex life. One who is attached to sex life is to be understood as devoid of knowledge. Knowledge must be followed by detachment. That is the way of self-realization. These two essentials for self-realization—knowledge and detachment—become manifest very quickly if one performs devotional service to the lotus feet of the Lord. The word dhīra is very significant in this connection. A person who is not disturbed even in the presence of cause of disturbance is called dhīra. Śrī Yāmunācārya says, "Since my heart has been overwhelmed by the devotional service of Lord Kṛṣṇa, I cannot even think of sex life, and if thoughts of sex come upon me I at once feel disgust." A devotee of the Lord becomes an elevated dhīra by the simple process of meditating in eagerness on the lotus feet of the Lord.
(Srimad Bhagavatam-------3:5:42-------purport).

There are many learned sages, philosophers and transcendentalists who try to conquer the senses, but in spite of their endeavors, even the greatest of them sometimes fall victim to material sense enjoyment due to the agitated mind. Even Viśvāmitra, a great sage and perfect yogī, was misled by Menakā into sex enjoyment, although the yogī was endeavoring for sense control with severe types of penance and yoga practice. And, of course, there are so many similar instances in the history of the world. Therefore, it is very difficult to control the mind and senses without being fully Kṛṣṇa conscious. Without engaging the mind in Kṛṣṇa, one cannot cease such material engagements. A practical example is given by Śrī Yāmunācārya, a great saint and devotee, who says:
yad-avadhi mama cetaḥ kṛṣṇa-pādāravinde
nava-nava-rasa-dhāmany udyataṁ rantum āsīt
tad-avadhi bata nārī-saṅgame smaryamāne
bhavati mukha-vikāraḥ suṣṭhu niṣṭhīvanaṁ ca
"Since my mind has been engaged in the service of the lotus feet of Lord Kṛṣṇa, and I have been enjoying an ever new transcendental humor, whenever I think of sex life with a woman, my face at once turns from it, and I spit at the thought."

Kṛṣṇa consciousness is such a transcendentally nice thing that automatically material enjoyment becomes distasteful. It is as if a hungry man had satisfied his hunger by a sufficient quantity of nutritious eatables. Mahārāja Ambarīṣa also conquered a great yogī, Durvāsā Muni, simply because his mind was engaged in Kṛṣṇa consciousness (sa vai manaḥ kṛṣṇa-padāravindayor vacāṁsi vaikuṇṭha-guṇānuvarṇane).
(Bhagavad-Gita-------2:60-------purport).

The best way to compensate for one's sinful acts is to give up one's body at once, and Brahmā, the leader of the living entities, showed this by his personal example. Brahmā has a fabulous duration of life, but he was obliged to give up his body due to his grievous sin, even though he had merely contemplated it in his mind without having actually done it. This is a lesson for the living entities, showing how sinful an act it is to indulge in unrestricted sex life. Even to think of abominable sex life is sinful, and to compensate for such acts, one has to give up his body. In other words, one's duration of life, blessings, opulence, etc., are decreased by sinful acts, and the most dangerous type of sinful act is unrestricted sex.
(Srimad Bhagavatam-------3:12:33-------purport).

I am the strength of the strong, devoid of passion and desire. I am sex life which is not contrary to religious principles, O lord of the Bhāratas [Arjuna]. The strong man's strength should be applied to protect the weak, not for personal aggression. Similarly, sex life, according to religious principles (dharma), should be for the propagation of children, not otherwise. The responsibility of parents is then to make their offspring Kṛṣṇa conscious.
(Bhagavad-Gita-------7:11-------translation and purport).

Śrīla Viśvanātha Cakravartī Ṭhākura specifically deals with the original and pure sex psychology (ādi-rasa), devoid of all mundane inebriety. The whole material creation is moving under the principle of sex life. In modern civilization, sex life is the focal point for all activities. Wherever one turns his face, he sees sex life predominant. Therefore, sex life is not unreal. Its reality is experienced in the spiritual world. The material sex life is but a perverted reflection of the original fact. The original fact is in the Absolute Truth, and thus the Absolute Truth cannot be impersonal. It is not possible to be impersonal and contain pure sex life. Consequently, the impersonalist philosophers have given indirect impetus to the abominable mundane sex life because they have overstressed the impersonality of the ultimate truth. Consequently, man without information of the actual spiritual form of sex has accepted perverted material sex life as the all in all. There is a distinction between sex life in the diseased material condition and spiritual sex life.
(Srimad Bhagavatam-------1:1:1-------purport).

The acts of yogamāyā make it possible for the Lord and the gopīs, in loving ecstasy, to sometimes meet and sometimes separate. These transcendental loving affairs of the Lord are unimaginable to empiricists involved in the impersonal feature of the Absolute Truth. Therefore the Lord Himself appears before the mundaners to bestow upon them the highest form of spiritual realization and also personally relish its essence. The Lord is so merciful that He Himself descends to take the fallen souls back home to the kingdom of Godhead, where the erotic principles of Godhead are eternally relished in their real form, distinct from the perverted sexual love so much adored and indulged in by the fallen souls in their diseased condition. The reason the Lord displays the rāsa-līlā is essentially to induce all the fallen souls to give up their diseased morality and religiosity, and to attract them to the kingdom of God to enjoy the reality. A person who actually understands what the rāsa-līlā is will certainly hate to indulge in mundane sex life. For the realized soul, hearing the Lord’s rāsa-līlā through the proper channel will result in complete abstinence from material sexual pleasure.
(Sri Caitanya Caritamrta--------1:4:30--------purport).