Could it be that the app is so poorly designed (no caching, no
connection pooling, etc) that it's always accessing the DB? That's the
only reason I see for it, but it really doesn't seem to make sense;
it's easier to optimize the DB server machine if it's only running the
RDBMS, of course.
Isn't ArcSde related to an older GIS, ARGIS? I had an Argis
installation in a development group long time ago and they used an
Oracle DB locally, but only for their data - like a "Web Cache"; maybe
that's all they need, a local DB in their machine.
On Jun 4, 2004, at 8:41 AM, Fuad Arshad wrote:
We're working on an ArcSde migration from sqlserver to oracle. i believe the version is 8.2
i was wondering if anyone had any gotchas or any information that we shoudl know. mind you the consultant we have has no clue of either unix nor oracle.
Also the consultants are recommending installing app on the database server instead of an app server. This is something i dont like and if anyone has done so reason why is it necessary ?.
Thanks
Fuad Arshad
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------