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/
Partition by Expression
-
Oracle 26.1 now allows using an *Expression* in the Partitioning Clause.
In earlier releases, you could do this with a Virtual Column defined in the
ta...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu