Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

System stats and MBRC

487405Nov 22 2007 — edited Nov 26 2007

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2007
Added on Nov 22 2007
12 comments
1,735 views