Falha minha. Boa Ivan, esqueci da dbms restore stats! :)
Att,/Regards, Vitor Jr. Infraestrutura / Infrastructure Team Oracle 11g DBA Certified Professional - OCP Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator - OCE Oracle Database 11g Performance Tuning Certified Expert - OCE Oracle Exadata 11g Certified Implementation Specialist Oracle Certified Associate, MySQL 5 mail, gtalk e msn: vitorj...@gmail.com http://certificacaobd.com.br/ skype: vjunior1981 https://mybizcard.co/vitor.jr.385628 Em 11 de fevereiro de 2014 14:18, Ivan Ricardo Schuster <ivanr...@gmail.com>escreveu: > > > Ok, e DBMS_STATS.RESTORE_DATABASE_STATS resolveu seu problema? > > > > 2014-02-11 14:12 GMT-02:00 Wanderson Barrence <wbarre...@gmail.com>: > >> >> >> Fala Ivan!!! >> >> O banco de dados é Oracle RAC 10g (10.2.0.3). >> >> Att, >> >> Wanderson >> >> >> Em 11 de fevereiro de 2014 14:08, Ivan Ricardo Schuster < >> ivanr...@gmail.com> escreveu: >> >> >>> >>> Wanderson, >>> >>> Você não informa versão, vê se resolve: >>> >>> DBMS_STATS.RESTORE_DATABASE_STATS( >>> as_of_timestamp TIMESTAMP WITH TIME ZONE, >>> force BOOLEAN DEFAULT FALSE, >>> no_invalidate BOOLEAN DEFAULT to_no_invalidate_type >>> >>> (GET_PARAM('NO_INVALIDATE'))); >>> >>> http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_stats.htm >>> >>> >>> >>> >>> >>> >>> 2014-02-11 14:04 GMT-02:00 Vitor Junior <vitorj...@gmail.com>: >>> >>> >>>> >>>> Se não fez backup das estatísticas antes, não. >>>> A única possibilidade é deletar. >>>> >>>> >>>> >>>> Att,/Regards, >>>> >>>> >>>> Vitor Jr. >>>> Infraestrutura / Infrastructure Team >>>> Oracle 11g DBA Certified Professional - OCP >>>> Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid >>>> Infrastructure Administrator - OCE >>>> Oracle Database 11g Performance Tuning Certified Expert - OCE >>>> Oracle Exadata 11g Certified Implementation Specialist >>>> Oracle Certified Associate, MySQL 5 >>>> mail, gtalk e msn: vitorj...@gmail.com >>>> http://certificacaobd.com.br/ >>>> skype: vjunior1981 >>>> https://mybizcard.co/vitor.jr.385628 >>>> >>>> >>>> Em 11 de fevereiro de 2014 13:49, Wanderson Barrence < >>>> wbarre...@gmail.com> escreveu: >>>> >>>> >>>>> >>>>> Olá Pessoal, >>>>> >>>>> Existe alguma maneira de desfazer a coleta de estatísticas, retornando >>>>> para a data do último last analyze antes da última coleta? >>>>> >>>>> A coleta foi feita utilizando o script abaixo: >>>>> >>>>> BEGIN >>>>> dbms_stats.gather_database_stats(options=> 'GATHER AUTO'); >>>>> END; >>>>> >>>>> Att, >>>>> >>>>> Wanderson >>>>> >>>>> >>>> >>>> >>>> >>> >> >> >> > >
