I have EC2 instance with 60GB Ram, 8 CPU and over 50GB space.
Tried to create 75K empty tables with
sqlplus -s / as sysdba @script.sql and it works fine up to 48K tables (they are created fine with all proper columns) but not sure why it hangs at 48K tables since memory is not filled up (less than 50%) and space is hard drive space is not filled either.
Tried 3 times on 3 different EC2 instances and it always hangs around 47K-48K tables (but not at the same number of tables each time).
Set actions to be saved to the logs:
SPOOL /home/oracle/logs/sqlplus.log but in logs is just showing how table is created successfully but no errors at all and nothing different towards the end of logs.
How to understand why is this happening and how to fix it?