![]() |
Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.
DELETE FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID, AA.JOB_HEADER_ID,AA.JOB_LINE_NUM,AA.JOB_IDN) IN (SELECT JOB_ID,JOB_HEADER_ID,JOB_LINE_NUM,JOB_IDN FROM IMPORT_REFER_S BB GROUP BY 1,2,3,4)
28 Aug 2015
| 1 comment
,
|
![]() |
Hello,
05 May 2013
| 1 comment
,
|
![]() |
Good Day Folks...
15 Dec 2012
| 2 comments
,
|
![]() |
Hello, Everyone I just want to know if it is normal that executor.exe uses 40% above of cpu.
12 Sep 2012
| 1 comment
,
|
![]() |
Hi experts, I understand that the CPU utilized by a query can be determined by adding AMPCPUTime and ParserCPUTime. If I get a value of 100 does this mean that the CPU was processing the query for 100 seconds? Or is the number represented in some other unit?
13 Sep 2011
| 4 comments
,
|
![]() |
Have you ever tried to figure out ahead of time how many CPU seconds an application would require after upgrading to a new hardware platform? I talked about one approach to solving this problem at the recent Partners Conference in San Diego, and would like to share my approach with you.
15 Nov 2010
| 17 comments
,
|
![]() |
I am creating a portlet that will be able to graph certain variables such as delta CPU by user name over a day. I know that I can pull all the session data grouped by user name, but I was wondering if there is a method or DAO that you could recommend that would give me a list of user names for a system.
01 Sep 2010
| 7 comments
,
|
![]() |
/usr/tdbms/bin/disstart is permanently using more than 60% of the cpu.
26 Aug 2010
,
|