Just a quick blog post on things you might see after upgrading to 22.214.171.124. We recently upgraded database from 126.96.36.199 to 188.8.131.52 and query on some data dictionary views ran too slow.
1. Performace of query on dba_free_space degraded
2. Performance of query involving dba_segments is slow
DEV01> select ceil(sum(b.bytes)/1024/1024) b from sys.dba_free_space b; Elapsed: 01:31:45.78
Searching MOS pointed to these Doc Ids :-
Insert Statement Based Upon a Query Against DBA_SEGMENTS is Slow After Applying 184.108.40.206 Patchset (Doc ID 1915426.1)
Query Against DBA_FREE_SPACE is Slow After Applying 220.127.116.11 (Doc ID 1904677.1)
DEV01> select ceil(sum(b.bytes)/1024/1024) b from sys.dba_free_space b; Elapsed: 00:00:01.38