From: "Mike Casey" Newsgroups: comp.databases.oracle Subject: Oracle Slowness on 1st Insert,Update or Delete Lines: 27 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Message-ID: <9SF68.785$PC4.76124@news.uswest.net> Date: Fri, 1 Feb 2002 16:40:16 -0700 NNTP-Posting-Host: 207.108.15.11 X-Trace: news.uswest.net 1012607493 207.108.15.11 (Fri, 01 Feb 2002 17:51:33 CST) NNTP-Posting-Date: Fri, 01 Feb 2002 17:51:33 CST We are having an odd issue with our production Database. 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