Database Tuning (MOSC)

MOSC Banner

System statistics.. any advice ?

edited Nov 10, 2009 5:31AM in Database Tuning (MOSC) 4 commentsAnswered
Hi,
I'm looking for any advices, recommandations, experience with system statisitics. I'm making a lot of test on 10g database (10.2.0.3) on RAC and stand-alone instance.

On a RAC, I get these stats with a WORKLOAD gathering type:

PNAME                                 PVAL1
------------------------------ ------------
CPUSPEEDNW                          437.129
IOSEEKTIM                                10
IOTFRSPEED                             4096
SREADTIM                              5.212
MREADTIM                             10.553
CPUSPEED                                446
MBRC                                     18
MAXTHR                               224256
SLAVETHR


And, with a NOWORKLOAD gathering type :

PNAME                                 PVAL1
------------------------------ ------------
CPUSPEEDNW                          437.133
IOSEEKTIM                             6.647
IOTFRSPEED                        26003.733
SREADTIM
MREADTIM
CPUSPEED
MBRC
MAXTHR
SLAVETHR


On each node, i have 6 processors except one node that it have 8 processors. All processors operates at 900 MHz each.

In both situation, CPU statistics are lower than I expected.


 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center