Re: How to tune for "too many" users ? - solved. The cause was ...

On Wed, 07 May 2003 21:17:58 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>On Wed, 07 May 2003 19:23:02 +0200, Sybrand Bakker
><gooiditweg_at_nospam.demon.nl> wrote:
>
>
>>At least you have been able to create the indexes. I'm dealing with a
>>similar app, and I have to go through burocracy.
>>And of course any problems in the app are to blame on the database.
>>
>
>What are their arguments to delay such important changes?
>Always curious about office politics :)
>
>Thanks.
>.......
>We use Oracle 8.1.7.4 on Solaris 2.7 boxes
>remove NSPAM to email

The app is production now, without foreign key indexes, performing full table scans on almost all queries. Needless to say bind variables are unknown to the app, and we currently have only a fraction of the projected end-users, and it is running on NT.

As the app is production, it can't be changed in an 'uncontrolled' fashion anymore, and a formal change request has to be submitted and to be agreed upon. In this change procedure (which is basically an ITIL feature) we have standard and non-standard changes. A standard change means changing a password etc (so the trivial actions), and it is free of charge. For non-standard changes the customer will have to pay.
The bad thing about this all is that the customer is a department in our own firm, and the app is going to be used *globally*

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 07 2003 - 17:30:56 CDT