-
Oracle 8i Tuning
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.
-
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.