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/
Testing the Datadog Explain Plan Visualizer with Oracle execution plans
-
Datadog recently released a free online service explain.datadoghq.com where
you can paste in your explained SQL execution plans with metrics as JSON
text a...
Acum 2 săptămâni
Niciun comentariu:
Trimiteți un comentariu