total CPU time of oracle processes

[Eileen Millen]

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.

[Alan Riggs]

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]

Hi:

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

...JRF...

[Eileen Millen]

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]

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

[Alan Riggs]

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

[Ed Ulfers]

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).