Boa tarde Edinilson, Pelo descrito, o seu ambiente provavelmente tem uma configuração ativa ou parcialmente ativa do Oracle Streams (replicação).
Sempre começe a descrever o problema enviando o banner do banco, com select * from v$version; Verifique os seguintes links: --conferir a configuração ativa do Streams: Making Oracle Streams Fly http://www.oracle11ggotchas.com/articles/MakingOracleStreamsFly.htm Making Oracle Streams Fly http://www.oracle11ggotchas.com/articles/MakingOracleStreamsFly.htm Making Oracle Streams Fly Streams performance is largely dependent on your environment; Visualizar em www.oracle11ggotchas.com http://www.oracle11ggotchas.com/articles/MakingOracleStreamsFly.htm Visualização pelo Yahoo --"Capture local" das transações a replicar: Oracle Streams Information Capture http://docs.oracle.com/cd/B28359_01/server.111/b28321/strms_capture.htm#i1013269 http://docs.oracle.com/cd/B28359_01/server.111/b28321/strms_capture.htm#i1013269 Oracle Streams Information Capture http://docs.oracle.com/cd/B28359_01/server.111/b28321/strms_capture.htm#i1013269 Implicit Capture with an Oracle Streams Capture Process This section explains the concepts related to the Oracle Streams capture process. This section contains ... Visualizar em docs.oracle.com http://docs.oracle.com/cd/B28359_01/server.111/b28321/strms_capture.htm#i1013269 Visualização pelo Yahoo --Monitorar a replicação Streams: Administering an Oracle Streams Replication Environment http://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_adcont.htm#TDPII085 http://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_adcont.htm#TDPII085 Administering an Oracle Streams Replication Envir... http://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_adcont.htm#TDPII085 Monitoring an Oracle Streams Replication Environment Visualizar em docs.oracle.com http://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_adcont.htm#TDPII085 Visualização pelo Yahoo Ederson Elias DBA Oracle - http://br.linkedin.com/pub/ederson-elias/24/8b/8b0 ------------ Labor improbus omnia vincit
