Query Performance issues upgrading to Oracle 19c ( from Oracle 11g).

[mikkelcp1]

What steps will reproduce the problem?

Upgrade from Oracle 11g to Oracle 19c.

What is the expected result?

Performance is the same.

What do you get instead?

Major performance issues with reflective queries on ALL_CONS_COLUMNS ( and others).

Additional info

See https://github.com/yiisoft/yii2/pull/13175 for more details. " My Yii2 application had the underlining Oracle database upgraded ( 11g to 19c ) All Schema queries ( with the added HINT ) all take 20-60 seconds now. The queries ran on 11g took 0.07 seconds. I removed the "HINT" comments, where Schema queries ( on ALL_CONS_COLUMNS) take ~2 seconds. Might want to rethink this HINT for Oracle 19c. "

Q	A
Yii version	all up to 2022-02-18
PHP version	doesn't matter
Operating system	doesn't matter

[samdark]

Do you have time for a pull request?