I analyse my database and I see process not statspack not correct
Hello,
I analyze my database by a query to retrieve the Worst Total SQL by CPU Time and I see 2 query system are bad.
The cpu time are very high 948 for the query 84828483
and 325 for the query 3471794499
What do you think about it ?
and What can I do ?
regards
JP
HASH_VALUE USERNAME CPU_TIME_SECS ELAPSED_TIME_SECS ELAP_PER_EXEC EXECUTIONS ROWS_PROCESSED LINE# SQL_TEXT
---------- ---------------- ---------------- -------------------- ------------- ------------ -------------------- ---------- -----------------------------------------------------------------
3471794499 SYS 4 325 2 157 1,476 0 insert into wri$_adv_objspace_trend_data select timepoint, spac3471794499 SYS 4 325 2 157 1,476 1 e_usage, space_alloc, quality from table(dbms_space.object_grow3471794499 SYS 4 325 2 157 1,476 2 th_trend(:1, :2,