concurrent statistics gathering
From: Wilhelm Klotz <willyk_at_kbi-gmbh.de>
Date: Tue, 19 Mar 2024 08:42:21 +0100
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAJxRhRLvfEhBnlOLJd92a2XCgAAAEAAAAKnKWD47XF5LgJVjiq53Rq4BAAAAAA==_at_kbi-gmbh.de>
Hi,
Date: Tue, 19 Mar 2024 08:42:21 +0100
Message-ID: <!&!AAAAAAAAAAAYAAAAAAAAAJxRhRLvfEhBnlOLJd92a2XCgAAAEAAAAKnKWD47XF5LgJVjiq53Rq4BAAAAAA==_at_kbi-gmbh.de>
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-lReceived on Tue Mar 19 2024 - 08:42:21 CET