Home » SQL & PL/SQL » SQL & PL/SQL » Performance problem
Performance problem [message #20158] Thu, 02 May 2002 10:55 Go to next message
Dave
Messages: 92
Registered: August 1999
Member
Hi there,

I have a performance problem on 7.3.4. I have a tcl program which processes approx 100,000 records at a time, and then uses expect to spit out the SQL, this takes about 5-6 secs. Then I perform an update to a table, and depending on the the month and region (both are indexed) it increments 1 of 8 other fields by 1. This takes upto 5 minutes and it's all in Oracle. Can anyone give me any idea as to why this is the case?

Thanks in advance,
Dave

Report message to a moderator

Re: Performance problem [message #20165 is a reply to message #20158] Thu, 02 May 2002 20:33 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Have you analyzed the tables and indexes... Also
you can run the explain plan to see the path
of query...

Regards,

Vikas.

Report message to a moderator

Previous Topic: What Hapens to Index When I Truncate the source Table
Next Topic: Query help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 18:06:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.