-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|