You can use the set_*_prefs procedures to set the default value for
concurrent.
https://docs.oracle.com/database/121/ARPLS/d_stats.htm#ARPLS059
On Thu, Sep 16, 2021 at 1:30 PM Laurentiu Oprea <laurentiu.oprea06@xxxxxxxxx>
wrote:
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.
