https://forums.oracle.com/ords/apexds/post/there-is-no-way-understanding-oracle-cloud-database-and-ape-2364
I make team believe APEX is way to go for our data-centric application development. So we should use database in cloud with Autonomous Database but I cannot foresee how much it will cost for us. I wrote same question to APEX forums and been directed to here.
In cost estimator I suggested 32 ECPU with 1 TB data and it says 5000 $ monthly.
Question is in peak time my database/apex application will get 10.000 inserts/transactions per second. There will be 1000+ brokers that are going to inspect those transactions and approve or deny. So those brokers will have to run SQL queries to see those transactions. There will be partitions by day and transaction source id etc.., and some performance tuning, still questions remain.
How much ECPU do i need ? is APEX designed to handle this much request ? I have used APEX years ago for small-sized bank. It was ok for that case but I don't understand OCI cost estimator it is the most blur in giant cloud providers.
Thanks