A sexual dream may be about physical pleasure but it may also be about power, control, manipulation, virility, and effectiveness. It may be a form of wish-fulfillment or a memory. In most cases it is not a prediction of things to come in the near future. Freud believed that experiencing sexual pleasure in your dreams is always desire or wish-fulfillment.
If you are watching other people having sex it may be a reflection on your emotional and mental concerns about sexual performance or interaction.
The meaning depends on your emotional reactions to what is going on and on the general mood in the dream. ... The Bedside Dream Dictionary
The image of one’s own personal physical sexuality that often points to sex as an end in itself. What is addressed here is not only sexual lust, vitality, and depth, but also a challenge to find your “self,” which is only possible through intense communication with the Other. Symbolic meaning of sexual climax reveals (not only in dreams) how we can become centered and engage our personal strength and passions. Other interpretations, as in alchemy and analytical psychology, include a sign of contradictions acknowledged and overcome.... Little Giant Encyclopedia
Vision: Dreaming about having intercourse with a lover: the prospects are good for a love relationship. Having intercourse with several people: your way of life may be lax or your sexual desires extreme and this could harm you!
Depth Psychology: Intercourse indicates sexual desires that you sometimes don’t want to acknowledge, even to yourself.
The dream might also symbolize a new beginning, a new project. See Bed.... Dreamers Dictionary
If intercourse is interrupted we may have inhibitions of which we are not consciously aware. Often intercourse in a dream can mark the integration of a particular part of our personality.
If a child is then born in the dream that integration has been successful.... Dream Meanings of Versatile
A maiden who dreams of nestling in the arms of a man she does not know will find that she will shortly be strenously wooed by one whom she had never previously regarded as a possibility for a lover.
Petting dreams, under circumstances that may be regarded as suitable, are always omens of excellent luck in matters pertaining to the heart.
A man who dreams of having each arm around a different girl should beware of careless proposals.... The Complete Dream Book
If a poor person sees such a dream, it means that he will fall sick, or attract an incurable disease.
To have sexual intercourse with a male in a dream also means falling into sin, committing the unlawful, or engaging in sexual intercourse with a female member of one’s own family, a blood relation, or a consanguineous person whom one is forbidden to marry. Molesting a child in a dream means suffering from a great affliction. Fornication with a young servant in a dream means suffering from continuous stress and a lasting depression. Sleeping with a beautiful woman one recognizes in his dream means profits. Sleeping with an ugly looking old woman in a dream means the opposite. Having sexual intercourse with an unknown woman in a dream represents the type of interactions and dealings one fosters with people in general. Accordingly, and depending on the condition of the woman one is sleepingwith in a dream, one’s actions will substantiate. Sleepingwith someone’s wife in a dream means engaging in a profitable business with the husband.
If a sick person sees himselfhaving sexual intercourse with his mother in a dream, it means his death, for the mother here represent the earth.
If a woman sees herselfengaging in tribadism, or a lesbian relationship with another woman she knows in a dream, it means that she will confide her personal life to her, or divulge all her secrets, become her intimate friend or a fan, shares opinions with her and emulate her actions and look in public. Ifshe does not know that woman in the dream, it means that she will indulge in sin.
If a married woman sees herself engaging in tribadism with another woman in a dream, it means that she will separate from her husband or become a widow. Engaging in sexual intercourse with a deceased person, be it a man or a woman in a dream means one’s own death, unless if one is travelling, then it could mean visiting that country where the deceased person is buried. Any sexual intercourse in a dream that culminates in ejecting semen and necessitates a complete ritual ablution in wakefulness represents disturbed dreams, or engaging in a forbidden sexual intercourse from the anus, or it could represent wet dreams. Having sexual intercourse in a dream also signifies paying one’s debts, or it could mean relief from pressures. Having sexual intercourse with a prostitute in a dream means love for the world, or it could mean profits. Having sexual intercourse with one’s wife in a dream means success in one’s trade. Having sexual intercourse with a heavenly woman in a dream means religious and spiritual attainment. (Also see Anus; Semen; Pleasure; Sodomy; Tears; Vagina)... Islamic Dream Interpretation