Thank you ggnanaraj

Got your inputs, I would like to know with the current status, what is the status of sqls, whether they are using CBO or RBO. As i gave the analysis of the v$sql.

Before anayzing all the tables, i would like to know the details of current sqls.

Hope I am clear in my question.

Awaiting for your replies.