Hi,
We have sql 2005 Enterprise edition with SP3 and oracle 10.2.0.4 on Unix solaris.
The Problem we are facing is whenever we are trying to add an oracle publication earlier it used to create in 10-15 mins.But currently it is taking approx 2.5 hours.
we have not changed any thing from sql side but we had upgraded patch 10.2.0.5 and when we started to have this problem we immediately downgraded it to 10.2.0.4.
Oracle SR has no clue for the same.
Premjit