Stats/optimizer on a new 19C database
Hi
I have a new 19c database into which I migrated (expdp/impdp) a 11g database (all enterprise edition) - just the application schema (rest were oracle maintained).
I did not export the stats from 11g.
On the 19C database , what do i need to do to ensure performance / optimisation is kept to peak as possible e.g. do I need to run one-off commands before allowing users on the system, so it gathers stats during off peak time etc? baseline stats ?
What should I be running (and how) regularly to keep system performance at peak or close to and when should they be run?