It sounds like Oracle 23c will likely be released shortly after February 2023:
…Oracle Database 23c is the new Long Term Support release (succeeding 19c) that has a beta period starting in October 2022 and ending in February 2023. Very shortly we will be able to start playing with these features and before too long we can start using them for real. Note that Oracle Database 23c will be supported for a long time (well into 2028 and with extended support already projected into 2031).
If 23c will be released soon, I’m wondering, how long does it take Esri to support new Oracle versions?
FYI: Oracle 23c (23ai) Support for ArcGIS - Esri Community