Re: gather stats standard way with concurrent enabled

Thanks Stefan.

Actually I tried to set pref at table level for concurrent, looks like docs are wrong, concurrent is a valid pname just for global.

BTW I forgot to mention version 12.1

În joi, 16 sept. 2021 la 14:46, Stefan Knecht <knecht.stefan_at_gmail.com> a scris:

> 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