how to check table stats are generated properly
My database version is 10.2.0.2.
I am aborting the spool process where select is being called and then only running the following script to generate stats.
Exec dbms_stats.gather_table_stats(ownname=>'IFLICMF',tabname=>'ACCOUNTBAL',estimate_percent => 15,cascade=>true);
Exec dbms_stats.gather_table_stats(ownname=>'IFLICMF',tabname=>'ACCENT',estimate_percent => 15,cascade=>true);