Stargate SG-1: Season 2, Episode 22

2 - 22: Out of Mind

Awakening from cryogenic suspension, O'Neill finds himself in a futuristic version of the SGC. Doctors hook O'Neill to a device which turns his memories into holograms and then question him for information about races able to defeat the Goa'uld.