Following an upgrade from 220.127.116.11 to 11gR2, an query execution takes more time.
Example, a select count(*) from TABLE which contains 2000000rows takes 20s on 18.104.22.168 and
32minutes on 11GR2. I can't do an export from the tables.
I have done a dbverify on all datafiles, all is ok.
Which occurs this problem?