Re: gather stats standard way with concurrent enabled

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_at_gmail.com> 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.
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

--
http://www.freelists.org/webpage/oracle-l