OUT OF MEMORY EVEN THOUGH SERVER HAS OVER 16GB FREE RAM

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

978 stars 341 forks source link

OUT OF MEMORY EVEN THOUGH SERVER HAS OVER 16GB FREE RAM #1780

Open NobleZirwaHara opened 2 months ago

NobleZirwaHara commented 2 months ago

Trying to convert from a dump with over 800 tables.

I have tried lowered the DATA_LIMIT all the way to 10 and it still doesn't work

My server has 12 Cores, 32GB of RAM. Is it because my dump has millions of records

darold commented 1 month ago

What is your ora2pg command and the result of the following command?

grep -E "^(JOB|PARALLEL_TAB|ORACLE_COPIES|DATA_LIMIT|BLOB_LIMIT)" config/ora2pg.conf

executed commented 1 week ago

@darold even though it's not my question what do you think would be suitable parameters for this type of server based on requested parameters: JOB|PARALLEL_TAB|ORACLE_COPIES|DATA_LIMIT|BLOB_LIMIT ?