We have a large number of Oracle Spatial "features" defined (900+). I cannot get Bentley Map or GeoSpatial Administrator to "connect" to the Oracle database. It just "hangs", Using the operability option to establish a "read-only" connection type for importing data works fine, just somewhat slow (due probably to the large number of features). However, trying to establish a "read/write" type of connection, it just sits, and sits, and sits. I've got the 11g client, going to a 10g database. I've tried to "spy" on the SQL being passed to Oracle to see if an Oracle error is occuring and just not being reported, but I can't seem to get a "sensible" trace (it also just "hangs" reporting on the SQL strings.)
Questions: Is there a way to "narrow" the results (ie limit the results to a schema or a set of schemas instead of everything in ALL_SDO_GEOM_METADATA table)?
Is there any way to turn on logging for the Oracle connection part, so I can figure out why the connection "hangs" and never returns any results?