A notorious Limerick killer, has awoken from a coma after he was found last Thursday "unresponsive" in his cell at Mountjoy Prison, following a suspected drugs overdose.