Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center