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/
Get Oracle Partition High Values as VARCHAR2 types instead of LONG in
Oracle 19c and earlier
-
Here’s a little PL/SQL function create_partition_high_value_func.sql that
allows you to write SQL queries against data dictionary for partition
maintenan...
Acum 2 săptămâni
Niciun comentariu:
Trimiteți un comentariu