I have a 10gb database, that the queries were running very fast on Oracle XE.
I exported this db with
expdp and imported on a new server Oracle 12c (hardware better than original, much more RAM and CPU) with
impdp and now the queries are being slow.
I think Oracle created some internal optimisation based on queries I frequently do, and now that the Database is imported, he lost all this optimisations. This is just my theory.
Anyone knows if Oracle optimize database while you use? If yes, how do I accelerate this process on a recently imported schema.
Edit: I monitored v$sql_monitor and there was just one problem I fixed with a new index. But queries still are slow.