But pending was a good point. Seems that answer is no. :(
https://blog.dbi-services.com/can-you-have-pending-system-statistics/
Regards
Lothar
----Ursprüngliche Nachricht----
Von : l.flatz@xxxxxxxxxx
Datum : 01/07/2019 - 14:38 (MS)
An : getsach@xxxxxxxxx
Cc : Oracle-L@xxxxxxxxxxxxx
Betreff : Re: Re: Simulate system Stats
Hi,
thanks, but no. I mean :
https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/optimizer-statistics-concepts.html#GUID-FE339C05-E7A4-4953-89C4-D5C69F0C08BA
Regards
Lothar
----Ursprüngliche Nachricht----
Von : getsach@xxxxxxxxx
Datum : 01/07/2019 - 14:34 (MS)
An : l.flatz@xxxxxxxxxx
Cc : Oracle-L@xxxxxxxxxxxxx
Betreff : Re: Simulate system Stats
You mean optimizer object statistics? You can use pending statistics to
test
On Mon, Jul 1, 2019 at 8:33 AM
l.flatz@xxxxxxxxxx <
l.flatz@xxxxxxxxxx> wrote:
Hi,
can we simulate system stats for one session? I want to test it but do
not want to effect other sessions on that same instance.
Regards
Lothar
--
Rgds,
Sachin Pawar
https://twitter.com/sach_pwr
