Hi. I’m currently working on a project that uses a large OracleDB. The DB has 100’s of sequences (too many to manually count). I’m currently attempting to debug why the startup time is so slow. One thing I have identified through logging, is that Hibernate takes ~7s “normalising” whilst it appears to scan all sequences that exist in the DB. This is evident in logs such as:
2021-03-22 16:31:19.790 TRACE 17101 --- [ main] .e.j.e.i.NormalizingIdentifierHelperImpl : Normalizing identifier quoting [SMP_LONG_ID]
Analysing each sequence in itself doesn’t take long. However, when this is multiplied for the 100’s of sequences in the DB it takes a considerable time. In my testing the first such log appears at:
2021-03-22 15:24:17.163 and ends at:
2021-03-22 15:24:23.658 with no other logs in-between.
The project I am working on only models a very small portion of the DB in question. It only references 3 sequences. My question is 1) why are all of the sequences in the DB being evaluated and 2) how I can stop this!