When doing a CTAS on a “large” table (history): 2.8G , 28 ranges it causes the system to run out of memory and the node crashes. We are running on the latest version: v19.1.5
I do have dump logs available. I can see that we can create smaller tables of the same source by adding a where clause. But doing the full scan will crash the system.
Already tried by increasing the cache by 2G and sql memory by 1.5G, and still it does the same behavior.
Server has 4VCP and 8GB of RMAN and it is not sufficient to handle this CTAS.