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


Responder a