Re: AW: kgskupdbalance: time_used[38149107] greater than threshold[30000000] current_consumed_cpu_time[67644337] exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799]

From: Stefan Koehler <>
Date: Fri, 3 May 2019 13:51:45 +0200 (CEST)
Message-ID: <>

Hello Lothar,
true, these lines are related to DBRM and are just a consequence of long parsing (CPU usage). However depending on your Oracle release you can easily troubleshoot why it takes so long to parse :)

See page 19 here ( ) and you can use a script from Franck Pachot to parse the CBO output for better readability ( ).

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website:
Twitter: _at_OracleSK

> "" <> hat am 3. Mai 2019 um 11:34 geschrieben:
> Hi Andi,
> thanks. Good point. I thought it was resource manager related. So this might be no hint other than parsing was taking too long .
> Reagrds
> Lothar

Received on Fri May 03 2019 - 13:51:45 CEST

Original text of this message