From: "Ray Porter" Newsgroups: comp.databases.oracle.misc References: <3f316caf$1_2@news.unc.edu> <3f3254c5$1_2@news.unc.edu> <3F3271DC.FEB0F4B8@remove_spam.peasland.com> <3f32a917$1_1@news.unc.edu> <3f32bddc$1_3@news.unc.edu> <3F32CE3A.2249EBC8@exxesolutions.com> Subject: Re: pushing tnsnames changes over the network Date: Fri, 8 Aug 2003 09:25:58 -0400 Lines: 46 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 152.2.202.60 Message-ID: <3f33a4e7_2@news.unc.edu> X-Trace: news.unc.edu 1060349159 152.2.202.60 (8 Aug 2003 09:25:59 -0400) Organization: University of North Carolina at Chapel Hill Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!chi1.webusenet.com!news.webusenet.com!snoopy.risq.qc.ca!elk.ncren.net!news.unc.edu!not-for-mail Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130370 "Daniel Morgan" wrote in message news:3F32CE3A.2249EBC8@exxesolutions.com... > Ray Porter wrote: > > > As one academic to another ... merge what you can and let everything else fail. > After it fails they will ask you to fix it. Tell them what you need to fix it. > You'll likely get what you need. > > Without failure ... often there are none willing to help with the solution. > -- Personally, Dan, I'd be willing to give that a shot. However, given the political facts on this campus, I doubt even our CIO (VC level) could push something like that through, particularly with some of the larger schools (business, public health, medicine, nursing) that all have large, in-house technical staffs and numerous in-house and vendor-supplied applications that central technical support know nothing about. Oh well, those of us in the trenches just have to make it all work, no matter the problems created by the environment. :( BTW, thanks for all your help with our data warehousing performance problems after migrating from Sybase. Based on your suggestions and extensive research and hard work on her own, our DBA finally got the database tweaked sufficiently that the end-users aren't howling for our blood. The primary end-user department also invested in its own AIX box with Oracle 9i, dedicated solely to our applications (one test instance, one production instance, no more dozen production and dev instances for a dozen different application groups and systems on one box). With a little more tweaking we finally have the application performing as well and usually better than Sybase except for a few types of queries. The end-users are finally (after nearly 6 months) very happy with the change, or at least they aren't complaining any more. Thanks, Ray PS I think the little utility I'm writing will solve my original problem by letting each user execute it from the application web site.