Oracle forms quey performance [message #616544] |
Wed, 18 June 2014 02:45 |
|
RaShi.Raj
Messages: 84 Registered: May 2014 Location: Bangalore
|
Member |
|
|
Hi,
We have migrated our application from 6i to 11G. One of the forms returns more than 50K records. In our testing environment records are fetched in no time but at client's end they are facing performance issue, it's taking around 40 seconds to fetch records. code is just a 'Execute_Query' on a DB block. Optimizer mode is set to ALL_ROWS.
Is there any way to check/test what is causing the problem?
Thanks,
Ravi
|
|
|
|
|
|
|
|
|