Re: concurrent statistics gathering

Hello Wilhelm,

> Statistics gathering is not really „concurrent“, as after some time there is no really concurrent processing anymore.

What do you mean in detail?

I guess you have read the restriction like "However, to prevent possible deadlock scenarios multiple partitioned tables cannot be processed simultaneously. Hence, if there are some jobs running for a partitioned table, other partitioned tables in a schema (or database or dictionary) will be queued until the current one completes. There is no such restriction for non-partitioned tables."

... so if your remaining objects are partitioned tables only, then there is no concurrent anymore.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: www.soocs.de
Twitter: _at_OracleSK

> Wilhelm Klotz <willyk_at_kbi-gmbh.de> hat am 19.03.2024 08:42 CET geschrieben:
>
>
> Hi,
>
> anyone using concurrent statistics gathering, as described in https://blogs.oracle.com/optimizer/post/concurrent-statistics-gathering ? Any tricks / hints and tips?
>
> We are on Oracle 19.20, with large OLTP databases (many db objects, partitioned tables) on Solaris and Linux. Statistics gathering is not really „concurrent“, as after some time there is no really concurrent processing anymore. Support is not really helpful until now.
>
> Thanks and Regards
> willyk

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