in greek mythology , delphi was the site of the delphic oracle , the most important oracle in the classical greek world , and a major site for the worship of the god apollo after he slew the python , a dragon who lived there and protected the navel of the earth .