I don't think the Oracle knew the Familcide would happen. I think his power works by only answering the questions he asks of it, and unless the Dragon's question involved more forsight into future events then the location of her son's killer, neither the oracle nor the Dragon, perhaps even Tiamat, could fully know the fallout of the events they set into motion.