Sample Header Ad - 728x90

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