What does the ITT stand for and what's the correct range of values for it?

~ 0 min
2016-03-09 04:20

 ITT -- Internal Temporary Table: for sorting/ordering table in table join, select ... order by, etc.

ITT uses physical memory, not use the DCCA. DBMaker has a smart mechanism which will calculate the suitable memory usage in your physical memory, if the usage is over the ITT in the memory, it will use temp file.

Information of ITT in JDBA Tool is queried from SYSINFO as follows:

0716 MAX_ITT_SIZE: firstly, detect OS free memory, and then assign DBMaker internal formula calculating result value

0717 CURRENT_ITT_SIZE: current used ITT memory

ITT values must be positive value, showing negative value is abnormal, and it may be caused by not detecting free memory or incorrect values used in formula.

Average rating 0 (0 Votes)

You cannot comment on this entry

Tags