Hi, I have a push transactional replication set up that pushes to a Oracle 11g db. What used to take around 9 to 10 minutes now takes around a hour. There are about 3.5 million rows in this table (well call it table1 for this purpose) on the sql server. The oracle table (well call it table2) also has about 3.5 mill rows. There are only 2 indexs on each table.
I ran a trace to try and find any long duration queries hanging, used sp_who2 to look for locks, cpu, i/o, memory and they all look fine.
We also looked at the Virtual Log Files and they were around 3500 so we shrinked them to around 400 and right now were are going to check if that helped as I type this.
Anything else I am missing your help is much appreciated?
p.s. sorry i originally posted this same topic in another section..