I did collect system stats with no_worload and using start and stop and it looks like my MBRC is NULL. Any reason why this could be, I guess this affecting the query performance. And db_file_multiblock_read_count=0 in my init.ora. I;m running 10.2 and I have daily partitions for a year and each day we have about 20 million or more records.
SQL> select pname, pval1 from sys.aux_stats$ where sname like '%MAIN';
PNAME PVAL1
------------------------------ ----------
CPUSPEEDNW 2116.155
IOSEEKTIM 23.946
IOTFRSPEED 4096
SREADTIM .409
MREADTIM .164
CPUSPEED 2107
MBRC
MAXTHR 24961024
SLAVETHR 110592
9 rows selected.