which are the parameter to be set so get better performance for more SELECT statements.

clients are accessing thro web. There more select statements than inserts or updates. Some of the queries used to take 10-20 secs to execute. After loading a new module it is taking more time 110-120 secs to retrieve the data for a select statement.

oracle 8.1.6
O.S sun 2.7
Application : WEB application

[Edited by shashikumar on 02-20-2002 at 05:51 AM]