My rule of thumb when I wonder that sort of question is 7 years. Nearly all statute of limitations fall at or below that point. By which I would then conclude, no chance could they still be prosecuted.

There are certain violations that will be exempted from the statute of limitations, but a moderate scandal/invasion of privacy isn't going to qualify. Wikipedia lists fraud against the court, international crimes, and heinous crimes, e.g. heinous violence