PDA

Click to See Complete Forum and Search --> : Oracle 8i Tuning

Kaushik
04-24-2006, 12:39 AM
Hi,

My oracle database is running very slow. The database is accessed both by web based applications as well as desktop visual basic applications. The problem is it is taking time to extract 10 records only. What could be the problem and how to resolve it?

Thanks,
Kaushik.
Scorby
04-24-2006, 10:02 AM
The number of records is not necessarily the issue. It depends on the complexity of the SQL used to retrieve those records. Start by obtaining the SQL used to get the 10 records and run it locally against the database to see if it still runs slowly. This will at least tell you whether it is a network or an SQL issue.