SQL PLAN MANAGEMENT

Dear,

I'm in charge of SQL performances since years.
As the developers trends is to use more and more drag and drop views  creating execution plans with more than 400 steps , I got to improve the way to tune.

One SQL with SYSTEM user is lasting 33 seconds and last 10 min with Application user.

We know that it's linked most of the time to histograms or is bind sensitive, pruning and so and so ...

With simple SQL, we can find easly which tables create the issue.

With those damns new SQL  composed by views and more 400 steps ... it's a long nightmare.

So I was looking for a way to force the proper execution plan for the "faulty" user.