version : 11.2.0.4
Rebuild index met temp space error, in fact free temp sapce is much larger than the total size of rebuild index.
尝试了各种办法,始终无解。
Oracle recommended to change OS parameter vm.max_map_count=262144
了解该参数定义:
This file contains the maximum number of memory map areas a process may have. Memory map areas are used as a side-effect of calling malloc, directly by mmap and mprotect, and also when loading shared libraries.
While most applications need less than a thousand maps, certain programs, particularly malloc debuggers, may consume lots of them, e.g., up to one or two maps per allocation.
The default value is 65536
等待试验结果