gather stats standard way with concurrent enabled
Date: Thu, 16 Sep 2021 09:29:32 +0300
Message-ID: <CA+riqSVz_yJqwCyXupMq139yRjmqyu3HjxeOTRiLT40f_A_z6g_at_mail.gmail.com>
Hello,
I have a situation where in the database during a particular window stats
are gathered concurrently (thus CONCURRENT is set to true GLOBAL).
During this time there are other activities running and one is an ETL job
that gathers some stats on some GTTs before selecting from them. The
problem is that this job is failing as it doesn't have privileges to gather
stats concurrently. I`m not able to provide required privileges to this
particular user.
Is there any workaround I can do for those sessions so that the stats are
gathered normally (without concurrent) even if the CONCURENT flag is set to
true ? Or any workaround so that those jobs will not fail?
Thanks.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 16 2021 - 08:29:32 CEST