Hi Friends,

I am getting lot of inputs, but the exact answer what i want I am not getting.

Let me clearly tell the problem once again.

I know how to check whether particular query will select CBO and RBO based on the optimizer mode and statistics collected. Now my boss gave me a dump of v$sql view from the production server. Now I should tell him which query has choosen CBO or RBO. But for most of the records in the v$SQL is having the 'CHOOSE' in the value of OPTIMIZER_MODE. Now how can I tell whether is has choosen CBO or RBO. Now these queries I cant run on the production server manually and check for the optimizer mode.

Now what I want is , a query which is already executed thru the application(Front End), I would like to know which optimizer it has used. Is there any database views to see this.


I want to know at a particular instance, how many qeries are being selected for CBO or RBO.

If any one is not clear on my inputs, I am ready to explain once again. As this information is very important for my current task.

Thanks and Regards
V6163