Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> High mbrc in aux_stats$

High mbrc in aux_stats$

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Fri, 10 Mar 2006 16:44:25 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C4503D4038B@NT15.oneneck.corp>


Anybody seen this before?

Oracle 9.2.0.5 on AIX 5.2:

SQL> show parameter db_file_multiblock_read_count

NAME                                 TYPE        VALUE

------------------------------------ ----------- -----
db_file_multiblock_read_count integer 16

execute dbms_stats.gather_system_stats('START');

. . . run batch jobs for 8 minutes . . .

execute dbms_stats.gather_system_stats('STOP');

SQL> select * from sys.aux_stats$;

SNAME                          PNAME                               PVAL1 PVAL2

------------------------------ ------------------------------ ---------- ----------------
SYSSTATS_INFO STATUS COMPLETED SYSSTATS_INFO DSTART 03-10-2006 14:22 SYSSTATS_INFO DSTOP 03-10-2006 14:30 SYSSTATS_INFO FLAGS 1 SYSSTATS_MAIN SREADTIM 3.864 SYSSTATS_MAIN MREADTIM 10.811 SYSSTATS_MAIN CPUSPEED 546 SYSSTATS_MAIN MBRC 97 <----??? SYSSTATS_MAIN MAXTHR 2957312 SYSSTATS_MAIN SLAVETHR -1

Notice the MBRC figure of 97 even though I have db_file_multiblock_read_count=16. I searched Metalink for bugs and known issues but no luck. I guess the next step is to peform a 10046 trace and check the p3 value for all the 'db file scattered reads', but I figured I'd check to see if any of you have already seen this before I go to that trouble.

Thanks,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 10 2006 - 17:44:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US