I have a problem with ArcSDE that I have never come accross before and I was wondering if anyone could shed any light on this problem.
Problem ArcSDE 9.3.1:
Connnecting to an ArcSDE instance (Oracle Spatial) with over 20,000 datasets (raster) causes ArcGIS/ArcObjects code to connect very slowly - minutes in fact before a successful connection is made to the database. However if a native SQL connection is made, the connection is almost instant.
Has anyone else had this problem and if so what can be done to remedy this problem.