topic Oracle Database Extension: "CPU time" metric in Extensions

Oracle Database Extension: "CPU time" metric

adminApmosys — Fri, 15 Dec 2023 10:24:50 GMT

In the database oracle exetension there is a page to find long running queries , In that there is a CPU time of the particular queries What does that CPU time refers to in that .

1. Does that refers to the total amount of time from the request sent ,

Or what is it ;

Please help

Re: Database

radek_jasinski — Thu, 23 Nov 2023 06:25:57 GMT

Hi @adminApmosys

CPU time for a particular query refers to the amount of time that the query has consumed on the CPU (Central Processing Unit) during its execution. It measures the actual time the CPU spent processing the query, not the total time from when the request was sent.

This metric is important for performance monitoring and tuning, as it helps you understand how much computational resources (CPU time) a query is using. High CPU time for a query can indicate that it's resource-intensive and may need optimization or better indexing to improve its performance.

Radek

Re: Database

adminApmosys — Thu, 23 Nov 2023 06:37:48 GMT

Thanks for the answer Radek, please can you simplify it as does it means the total CPU time = (elapse time + IO time)