Disabling optimizer dynamic sampling
Dynamic sampling is a functionality that gathers statistics on the fly during query execution. When switched on, it can adversely affect performance. For that reason, you should ensure that the SYS user disables optimizer dynamic sampling in the Oracle database.