Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to calculate CPU % in consumed by Oracle process or job

InigoJun 13 2014 — edited Jun 13 2014

Hi all,

     Could any  one assist me regarding,

          How to calculate CPU % used by oracle process or oracle scheduler_jobs

select owner,job_name,session_id,running_instance,elapsed_time,cpu_used from dba_scheduler_running_jobs where job_name='EXP_HIST_YTD_SC1';

OWNER        JOB_NAME              SESSION_ID    RUNNING_INSTANCE       ELAPSED_TIME       CPU_USED

EXP         EXP_HIST_YTD_SC1        384                                1                 +00 01:23:22.390000     +00 00:58:29.590000

in Oracle 11g R2, stand alone, OLAP ,windows 2003 r2 environment......

thanks in advance...

A.George Inigo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2014
Added on Jun 13 2014
#database-security, #database-security-general
1 comment
1,238 views