Search This Blog

2011-02-16

Finding Oracle's CPU Utilization

From time, business user would like to determine CPU hardware upgrade for their Oracle database, if the server shared Oracle with other software, one valid question will be how much of the CPU utilization is used by Oracle database. Following query will indicate that in real time

select * from v$sys_time_model;

Or uses AWR view, if there is a license paid
dba_hist_sys_time_model

No comments: