Home -> Mailing Lists -> Oracle-L -> 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]

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