For Raids and Challenge mode it’s really good, you can cut off 1999999 HP max with the skill, which is really useful to quickly end boss battles like Ignas or Challenge mode boss fights.
Even in gem feud you can destroy an enemy with less than 40% max HP with a quick cast of it.
The question is always what you want to do. There aren’t that many useful alternatives on Oracle.
Basically you’re left with about 24 points to spend on Arcane Energy, Foretell, Counter Spell, Twist of Fate, Clairvoyance, Resetting and Gender swap shop after maxing all the important skills.
From my experience when playing Oracle,
Foretell is really good at level 1, but if you plan to hunt Demon Lords, you need to max it, because a lot of AoE sweep-skills take longer than 7 seconds (mostly around 10 seconds).
Counter Spell is also nice, but it’s not that good since a lot of monsters rarely or simply don’t use magic at all.
It’s better for PVP or for hunting Demon Lords like Nuaele, Helgasercle and Mirtis.
Arcane Energy below level 10 is worth nothing. I tried level 5 and level 1 and it basically does nothing since you can’t use that many skills in only 6-10 seconds to have a significant SP recovery.
Best is don’t get it or max it to have at least 1/3 SP refunds.
Clairvoyance and Resetting are just worth nothing. I feel bad for skilling them, and will probably reset them away soon for a longer duration on Foretell (together with my level 1 Arcane Energy, as I can always use Arcane Energy Scrolls for Raids if needed).
Gender Switch is now useless and shouldn’t be skilled unless you don’t have any other shop Class on your account.
Leaving you with Twist of Fate, which is as I said a preference in regards of what you do.
I’ll keep it as it’s pretty useful in soloing Challenge Mode Stage 6 and against Ignas in his final few HP.