Rebuild index error, max

    科技2025-07-10  17

    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

     

    等待试验结果

    Processed: 0.013, SQL: 8