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

Home -> Community -> Mailing Lists -> Oracle-L -> maxthr system statistic

maxthr system statistic

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 18 Jan 2007 16:42:39 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45059E2877@NT15.oneneck.corp>


Does anybody have a good understanding of how the maxthr metric is computed or how it's used by the CBO? I'm just curious because I've gathered system stats 5 times in the past few days and keep getting wildly different values for this metric while the rest are relatively constant:  

STATID     STATUS     START_TIME       END_TIME           SREADTIM
MREADTIM   CPUSPEED       MBRC     MAXTHR

---------- ---------- ---------------- ---------------- ----------
---------- ---------- ---------- ----------
TEST COMPLETED 01-12-2007 13:23 01-12-2007 14:41 1.667 3.386 707 27 105472 TEST2 COMPLETED 01-15-2007 09:09 01-15-2007 12:06 1.688 3.552 823 37 21226496 TEST3 COMPLETED 01-15-2007 13:45 01-15-2007 16:11 2.389 4.138 749 31 105472 TEST4 COMPLETED 01-15-2007 16:12 01-16-2007 09:10 1.9 4.683 798 43 89126912 TEST5 COMPLETED 01-16-2007 09:11 01-16-2007 16:14 1.709 3 758 23 3595264

I already searched the docs, Metalink and Google and couldn't find a good explanation beyond "Maximum I/O throughput is the maximum throughput that the I/O subsystem can deliver."

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 Thu Jan 18 2007 - 17:42:39 CST

Original text of this message

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