Some of my favorite theorems in analysis are those which classify the (pre-)compact subsets of a particular space. For example:
The Heine-Borel Theorem classifies the compact subsets of $\mathbb{R}^n$.
The Arzela-Ascoli Theorem classifies the compact subsets of $C(X,Y)$, where (usually) $X$ is compact and $Y$ is metric.
Montel's Theorem classifies the compact subsets of $\text{Hol}(U)$.
Can we give a similar description of the compact subsets of $L^p$?
Notes: I realize that I'm being a little vague in two senses.
First, $L^p$ of what? Frankly, I don't know. I would be very interested in seeing a theorem about $L^p[0,1]$, or more generally about $L^p(X)$ where $X$ is locally compact Hausdorff. I just want to know what's out there.
Second, what kind of "classification" am I looking for? Well, hopefully one that is similar in spirit to the above three examples, and in some sense specific to $L^p$. For instance, saying that a set is compact if and only if it is complete and totally bounded does not really count (since that is true in any metric space).