Searching for growth in a tepid economy, private-equity firms are zeroing in on the U.S. oil patch.