“By the sacred anointing of the sick and the prayer of the priests the whole Church commends those who are ill to the suffering and glorified Lord, that he may raise them up and save them. and indeed she exhorts them to contribute to the good of the People of God by freely uniting themselves to the Passion and death of Christ.”
LG 11; cf. Jas 5:14-16; Rom 8:17; Col 1:24; 2 Tim 2:11-12; 1 Pet 4:13
In the Church’s Sacrament of Anointing of the Sick, through the ministry of the priest, it is Jesus who touches the sick to heal them from sin – and sometimes even from physical ailment. His cures were signs of the arrival of the Kingdom of God. The core message of his healing tells us of his plan to conquer sin and death by his dying and rising.
The Rite of Anointing tells us there is no need to wait until a person is at the point of death to receive the Sacrament. A careful judgment about the serious nature of the illness is sufficient.
When the Sacrament of Anointing of the Sick is given, the hoped-for effect is that, if it be God’s will, the person be physically healed of illness. But even if there is no physical healing, the primary effect of the Sacrament is a spiritual healing by which the sick person receives the Holy Spirit’s gift of peace and courage to deal with the difficulties that accompany serious illness or the frailty of old age.
~from the United States Catholic Catechism for Adults