Database Tuning (MOSC)

MOSC Banner

the relation: DB time, DB CPU, CPU time, CPU used by this session in AWR.

edited Apr 25, 2010 8:01PM in Database Tuning (MOSC) 6 commentsAnswered
 Hi all,

when we want to check the database performance, we can caculate the CPU usage. in AWR,  what the relation between DB time, DB CPU,CPU time and CPU used by this session?

in reference, I find the prior 2 definitions.

DB time: Amount of elapsed time (in microseconds) spent performing Database user-level calls. This does not include the time spent on instance background processes such as PMON.

DB CPU:Amount of CPU time (in microseconds) spent on database user-level calls. This does not include the CPU time spent on instance background processes such as PMON.

take I submit the quesiont as an example, my understanding on these 4 metrics:

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