Database Tuning (MOSC)

MOSC Banner

AWR : Operating System Statistics

edited Jul 23, 2018 3:52AM in Database Tuning (MOSC) 1 commentAnswered

Hi all

Can anybody explain me defferences

AVG_BUSY_TIME 23,987  
AVG_IDLE_TIME 339,220 
and
OS_CPU_WAIT_TIME 1,538,300

from nmon and elapsed time vs db time

Elapsed:   60.14 (mins)    
DB Time:   142.28 (mins)
core   :   7

from db_time vs elapsed time and number of core our db was used about 30%

from AVG_BUSY_TIME vs AVG_IDLE_TIME side situation is also the some , it means no cpu usage

but OS_CPU_WAIT_TIME 1,538,300, if i undestand it means run queues waiting co cpu and we can say db is cpu - bound . And where is the true ?

Thank You

Brano

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