query tuning
Hi Team,
We are on 19.28 oracle DB version. Is there any feasibility to reduce the CPU usage for below query:
TOP CPU consuming Programs:
SQL> SELECT * FROM (
SELECT
sql_id,
round(cpu_time / 1000000, 2) as cpu_seconds
FROM v$sql
ORDER BY cpu_time DESC
) WHERE ROWNUM <= 10;
2 3 4 5 6 7
SQL_ID CPU_SECONDS
76a325pa048q0 848640.68
8rzdmcuu7jhn0 546611.83
39ch34k4rwv09 286696.34
c681dna70zdd9 212128.82
4d5qz0s1t7tan 115775.04-------This one
1mh8dnvc9wq95 74631.77
1bg79cpypyrd3 72164.31
7rpz1g7tv2yfj 69712.75
1b2dtx6p6w9rd 60456.55
bsr7r4rjxxvg0 41411.47
PLAN_TABLE_OUTPUT
SQL_ID 4d5qz0s1t7tan, child number 0
SELECT SUPPLIERID, SUPPLIERNUMBER, SUPPLIERNAME, TAXREGISTRATIONNUMBER,