I have an error ORA-27102: out of memory when using order by clause
Platform: AIX 7.2
oracle database 19c (19.22.0.0.0) entreprise edition
RAM: 128G
SGA_TARGET: 70G
PGA_AGGREGATE_TARGET: 20G
I have this error when I use any "order by" clause in some queries.
ulimit values:
ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimited
threads(per process) unlimited
processes(per user) 16384
error encountered:
select * from mytable order by 1;
ORA-27102: out of memory
IBM AIX RISC System/6000 Error: 12: Not enough space
Additional information: 7195
Additional information: 16777216
27102. 00000 - "out of memory"
*Cause: Out of memory
*Action: Consult the trace file for details