In HHH-12848, the change to use the SQL2008StandardLimitHandler, i.e. fetch first and offset, with the Oracle12cDialect was reverted because it didn't work with FOR UPDATE statements. This is unfortunate since in almost all cases it is more performant than the legacy limit handler.

Due to its performance boast, hibernate should consider using SQL2008StandardLimitHandler with the Oracle12cDialect.