Re: Re: Re: Simulate system Stats

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_at_bluewin.ch
Datum : 01/07/2019 - 14:38 (MS)
An : getsach_at_gmail.com
Cc : Oracle-L_at_freelists.org
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_at_gmail.com  

Datum : 01/07/2019 - 14:34 (MS)  

An : l.flatz_at_bluewin.ch  

Cc : Oracle-L_at_freelists.org  

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_at_bluewin.ch <
    l.flatz_at_bluewin.ch> 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                

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jul 01 2019 - 14:43:08 CEST