Oracle databases often prompt a solution to the 27102 out of memory problem, oracle27102

Oracle databases often prompt a solution to the 27102 out of memory problem, oracle27102

There are many solutions on the Internet, but I can't understand either of them. I don't know what the writing is, why can I solve the problem in one sentence? I have to give a long story about what the principle is, it seems awesome.

My Solutions

Vi/etc/sysctl. conf

Modify kernel. the value of shmall (total shared memory), which was originally 2097152. I gave it to 4097152 (I don't know what value to change for the moment, but it's right to increase the value, I just want to change the first 2 to 4 and solve the problem automatically.) then, sqlplus/as sysdba

Execute select status from v $ instance. The error "out of memory" is not displayed, but "open" is displayed normally.