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: <l.flatz_at_bluewin.ch>
Date: Fri, 3 May 2019 11:34:24 +0200 (CEST)
Message-ID: <1989108641.14384.1556876064464_at_bluewin.ch>





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

----Urspr√ľngliche Nachricht----
Von : andreas.schloegl_at_bearingpoint.com Datum : 03/05/2019 - 11:23 (MS)
An : l.flatz_at_bluewin.ch, oracle-l_at_freelists.org, contact_at_soocs.de, frits.hoogland_at_gmail.com Betreff : AW: kgskupdbalance: time_used[38149107] greater than threshold[30000000] current_consumed_cpu_time[67644337] exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799] p.MsoNormal, li.MsoNormal, div.MsoNormal {

	margin: 0.0cm;
	margin-bottom: 1.0E-4pt;
	font-size: 11.0pt;
	font-family: Calibri , sans-serif;

}

a:link, span.MsoHyperlink {
	mso-style-priority: 99;
	color: rgb(5,99,193);
	text-decoration: underline;

}

a:visited, span.MsoHyperlinkFollowed {
	mso-style-priority: 99;
	color: rgb(149,79,114);
	text-decoration: underline;

}

p.msonormal0, li.msonormal0, div.msonormal0 {
	mso-style-name: msonormal;
	mso-margin-top-alt: auto;
	margin-right: 0.0cm;
	mso-margin-bottom-alt: auto;
	margin-left: 0.0cm;
	font-size: 11.0pt;
	font-family: Calibri , sans-serif;

}

span.E-MailFormatvorlage18 {
	mso-style-type: personal;
	font-family: Calibri , sans-serif;
	color: windowtext;

}

span.E-MailFormatvorlage19 {
	mso-style-type: personal-compose;
	font-family: Calibri , sans-serif;
	color: windowtext;

}

*.MsoChpDefault {
	mso-style-type: export-only;
	font-family: Calibri , sans-serif;
	mso-fareast-language: EN-US;

}

div.WordSection1 {

        page: WordSection1;
}
 

Hi Lothar,                      

I always look those things up here: http://orafun.info/                  

Cu     

Andi                      

Von: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] Im Auftrag von l.flatz_at_bluewin.ch Gesendet: Freitag, 03. Mai 2019 11:18
An: oracle-l_at_freelists.org; contact_at_soocs.de; frits.hoogland_at_gmail.com Betreff: kgskupdbalance: time_used[38149107] greater than threshold[30000000] current_consumed_cpu_time[67644337] exec_start_consumed_time[29495230]exec_start_elapsed_time[18137550996799]                      

Hi,                                

does anybody know what kgsk statement stands for?           

I found it in a trace where long parsing times occured.#           

The statement to parse had extremly long inlists.                                                                          

kgskupdbalance: time_used[153045464] greater than threshold[30000000] current_consumed_cpu_time[690119909] exec_start_consumed_time[537074445]exec_start_elapsed_time[18138966829946]

  • 2019-05-02 18:52:06.928 kgskupdbalance: time_used[258300603] greater than threshold[30000000] current_consumed_cpu_time[948420512] exec_start_consumed_time[690119909]exec_start_elapsed_time[18139146083208]
  • 2019-05-02 18:53:09.983 kgskupdbalance: time_used[55357911] greater than threshold[30000000] current_consumed_cpu_time[1006849200] exec_start_consumed_time[951491289]exec_start_elapsed_time[18139439551170]

This was the parsing time:                                

That s the parse time           

call count cpu elapsed disk query current rows

  • ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 498.54 565.22 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 2 0.04 0.04 0 1456 0 9
  • ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 498.58 565.26 0 1456 0 9

IN MOS I only find Doc ID 2126295.1. That does not feel like a fit.           

I suspect a bug though.                                

_at_Frits: I know you were looking for long parse times.                                

Regards                                

Lothar      

BearingPoint Software Solutions Austria GmbH  Sitz: Wien
 Firmenbuchgericht: Handelsgericht Wien
 Firmenbuchnummer: FN 496641 f
The information in this email is confidential and may be legally privileged. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 03 2019 - 11:34:24 CEST

Original text of this message