We are having an odd issue with our production Database.

From: Mike Casey <mcasey_at_rcrh.org>
Date: Mon, 4 Feb 2002 16:13:55 -0700
Message-ID: <fBE78.81$Uh3.196783_at_news.uswest.net>

We have recently exported that database to our development and can't duplicate the issue.

Deal is:
We are running oracle 8i on an IBM AIX box and in our production instance when we log in as anyone with access to any tables and execute an insert,update or delete for the 1st time it takes too much time. For updates of one field in one table with only 5 records it takes 10-15 seconds
Our deletes of one record from bigger tables takes up to 1 minute.

But, the 2nd time we run the same or similiar thing on the same table with the same user then it works right away. No slowness at all. Same thing with the 3rd, 4th, etc. time.

Thanks for any help,

Mike Casey
Senior Programmer Analyst
Rapid City, SD Received on Tue Feb 05 2002 - 00:13:55 CET

This message: [ Message body ]
Next message: Scott Hodson: "Oracel Lite vs. Oracle Server"
Previous message: Jon K: "Re: export Oracle7 - import Oracle8"
Next in thread: C. R. Soza: "Re: We are having an odd issue with our production Database."
Reply: C. R. Soza: "Re: We are having an odd issue with our production Database."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message