All my sys tables are very slow after my database upgrade from 10.2.0.4 to 18.104.22.168 on AIX 6.1
select * from ALL_TAB_COLUMNS; -- taking 19 seconds in 22.214.171.124 and few millisec in 10.2.0.4
I have deleted and updated fixed and dictionary table statistics , till I facing this issue
This is an EBS database - pl post EBS version. For the database upgrade, have all of the steps in this MOS Doc completed without any errors ?
Interoperability Notes EBS R12 with Database 11gR2 [ID 1058763.1]
Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0) [ID 881505.1]
Have all required init.ora parameters for 11gR2 been set (or removed) correctly ? Pl see
bde_chk_cbo.sql - EBS initialization parameters - Healthcheck [ID 174605.1]