Oracle
1Z0-883 · Question #39
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?
The correct answer is D. Tmp_table_size E. Max_heap_table_size. See the full explanation below for the reasoning.
Question
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing. Which two variables would likely fix this issue?
Options
- ATable_open_cache
- BTable_open_cache_instancs
- CTable_definition_cache
- DTmp_table_size
- EMax_heap_table_size
- FMax_tmp_tables
How the community answered
(29 responses)- B3% (1)
- C10% (3)
- D83% (24)
- F3% (1)
Community Discussion
No community discussion yet for this question.