| Query with Slow Response [message #53391] |
Tue, 17 September 2002 12:47  |
Paula
Messages: 4
Registered: April 2001
|
Junior Member |
|
|
I have a query joining 5 tables that returns 200,000+ rows. I am running the query with SQL Plus on the server. The data starts displaying within seconds. However, it then slowly displays several rows, then hangs maybe 5 seconds, then displays more, then hangs, etc. When there are fewer rows, all data displays within seconds.
The fact that less data displays quickly leads me to believe it's not necessarily the query itself, but perhaps a database parameter that I need to adjust. I tried increasing sort_area_size and sort_area_retained_size from 65536 to 131072 and adjusting optimizer_index_cost_adj from 500 to 10. Neither seemed to have any impact.
Any suggestions? TIA
|
|
|
|
| Re: Query with Slow Response [message #53393 is a reply to message #53391] |
Tue, 17 September 2002 16:34  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
Check to see if your session is set to FIRST_ROWS or ALL_ROWS. FIRST_ROWS could cause the behaviour you describe. Alternately, try adding an order by clause to the query to see if you get the same behaviour.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
