Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

total CPU time of oracle processes

Eileen Millen
Trusted Contributor

total CPU time of oracle processes

Is there a way to find out what the total CPU time taken was for an Oracle process.
The DBAs get information on the total time the process took. We do not have MWA collection setup on this server.
Puma seems to kill all processes that I try to run it on.
6 REPLIES
Alan Riggs
Honored Contributor

Re: total CPU time of oracle processes

Well, if you watch it as it runs then ps, top, and glance will all report total cpu usage. If you just want to run it and check it after its done, wrap it in time or timex.
James R. Ferguson
Acclaimed Contributor

Re: total CPU time of oracle processes

Hi:

You could use 'ps' values from the "time" column. 'grep' or 'awk' whatever you want.

...JRF...
Eileen Millen
Trusted Contributor

Re: total CPU time of oracle processes

The processes being measure take about 4 hours to run, so it is hard to watch them. The DBAs did not want to use the command line for running them. They may have to do that. Thanks for your input.
Kofi ARTHIABAH
Honored Contributor

Re: total CPU time of oracle processes

If it is a process that can be started from the command line then the command you want to use is "time" and "timex" (do a man on both)

# time your_program

real 0.0
user 0.0
sys 0.0
nothing wrong with me that a few lines of code cannot fix!
Alan Riggs
Honored Contributor

Re: total CPU time of oracle processes

You don't need to watch them all the way through -- just watch them at the end.
Ed Ulfers
Frequent Advisor

Re: total CPU time of oracle processes

Reply from senior Oracle DBA:
Tell your DBA's to use timed statistics and run a trace on that session. A "tkprof" of the Oracle trace file will even break out CPU usage, disk IO wait, etc.
A good DBA will even be able to identify which set of Oracle code is taking the most time/resources and even potentially why (if Oracle related).
Put a smile on your users face, offer them a kiss (Hershey's Kiss).