Exadata General (MOSC)

MOSC Banner

Is an Exadata that has never had GATHER_SYSTEM_STATS('EXADATA') run on it configured correctly?

edited Jan 19, 2016 2:20PM in Exadata General (MOSC) 3 commentsAnswered

Settings from "born-on" date.

SYSSTATS_INFO    STATUS  COMPLETED
SYSSTATS_INFO    DSTART  03-21-2013 21:08
SYSSTATS_INFO    DSTOP  03-21-2013 21:08

SYSSTATS_INFO    FLAGS    1  

SYSSTATS_MAIN    CPUSPEEDNW    2938.05309734513  

SYSSTATS_MAIN    IOSEEKTIM    10  

SYSSTATS_MAIN    IOTFRSPEED    4096  

SYSSTATS_MAIN    SREADTIM 
SYSSTATS_MAIN    MREADTIM 
SYSSTATS_MAIN    CPUSPEED 
SYSSTATS_MAIN    MBRC 
SYSSTATS_MAIN    MAXTHR 
SYSSTATS_MAIN    SLAVETHR 

MBRC is null. From what I gather this means the proper GATHER_SYSTEM_STATS was never run.  Is my Exadata misconfigured?   I am hoping it will run faster (much faster?) if corrected?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center