i got execution error messages during execution stage in tuning lab.
but i could not find log file for this error messages.
after i finish virtual index creation, i executed this virtual index query.
then i got error messages during execution stage.
i traced this error, using toad and i found out that
all the tables in query was locked for table statitics (may be using dbms_stat.lock_table_stats)
so, after real creation of virtual index, sql optimizer tried to gather statistic for this index but sql optimizer could not gather statistic for this tables.
so i got execution error messages.
but i could not get this information from sql optimizer.
where could i find error messages in sql optimizer?