Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Performance issues on Creating oracle Publication. Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 8:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:26 AM
Points: 149, Visits: 150
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
Post #1440836
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse