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]

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 ( http://www.soocs.de/public/talk/160616_DOAG_Regio_NUE_Identifying_Performance_Issues_Beyond_The_Oracle_Wait_Interface_PPT.pdf ) and you can use a script from Franck Pachot to parse the CBO output for better readability ( https://blog.dbi-services.com/cbo-parse-time-match-time-with-transformation/ ).

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> "l.flatz_at_bluewin.ch" <l.flatz_at_bluewin.ch> 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

--
http://www.freelists.org/webpage/oracle-l