How to improve Oracle Standard Edition's performance for testing?
1
vote
0
answers
217
views
There's a great post on StackOverflow about improving Postgres performance for testing.
> https://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing/9407940#9407940
However, there aren't any resources on doing the same for OracleDB. I don't have a license for Enterprise Edition, that has features like 'In-Memory' columnar storage that would almost definitely improve performance.
> https://docs.oracle.com/en/database/oracle/oracle-database/19/inmem/intro-to-in-memory-column-store.html
I'm really limited in what I can try in Standard Edition. It's running in a Docker container in a CI pipeline. I've tried putting the tablespace on a RAM disk, but that doesn't improve performance at all. I've tried fiddling with FILESYSTEMIO_OPTION, but no performance change.
Would anyone know of some more obvious things I can do in OracleDB in a CI environment?
Asked by Rol
(111 rep)
Feb 13, 2021, 07:12 PM