What is the oracle pattern?

A design pattern that introduces a trusted service (an oracle) to inject external-world state onto the chain so smart contracts can act on facts they otherwise cannot see.

Its benefit is connectivity; its cost is that it re-introduces a trusted third party the chain was meant to avoid. A distributed oracle (several independent oracles with M-of-N signing) spreads that trust.