The Bayes oracle and asymptotic optimality of multiple testing procedures under sparsity