On Linux machines you may encounter errors like :
kernel: Out of Memory: Killed process 18061 (oracle).
kernel: oracle: page allocation failure. order:0, mode:0xd0
The problem is that there is no more memory available on server ( you could also see the pmon or smon killed ).
Solutions:
- increase memory on the server
- decrease sga ( or pga )
- http://www.cyberciti.biz/faq/linux-page-allocation-failure-erro/
Everything Changes
-
I saw a recent tweet (on Bluesky) from SQLDaily highlighting a blog note
that Lukas Eder wrote in 2016 with the title: “Avoid using COUNT() in SQL
when you...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu