Experts said shale oil production would peak soon as U.S. drilling activity ebbed and companies moved operations to less productive "tier-two" acreage.