Database Administration (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center