Home » Developer & Programmer » Forms » Oracle forms quey performance (Forms 11G)
Oracle forms quey performance [message #616544] Wed, 18 June 2014 02:45 Go to next message
RaShi.Raj
Messages: 25
Registered: May 2014
Location: Bangalore
Junior 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
Re: Oracle forms quey performance [message #616545 is a reply to message #616544] Wed, 18 June 2014 02:48 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
Trace the session and have a look at the tkprof output.
Re: Oracle forms quey performance [message #616554 is a reply to message #616545] Wed, 18 June 2014 04:49 Go to previous messageGo to next message
RaShi.Raj
Messages: 25
Registered: May 2014
Location: Bangalore
Junior Member
Can you please explain how can I use trace/TKRPOF with forms session?
Re: Oracle forms quey performance [message #616558 is a reply to message #616554] Wed, 18 June 2014 05:13 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't you have a DBA for jobs like this?
Re: Oracle forms quey performance [message #616561 is a reply to message #616544] Wed, 18 June 2014 05:38 Go to previous messageGo to next message
RaShi.Raj
Messages: 25
Registered: May 2014
Location: Bangalore
Junior Member
we don't have Sad
I'm trying google to understand this but yet to hit the right page. Please let me know if there is any

[Updated on: Wed, 18 June 2014 05:39]

Report message to a moderator

Re: Oracle forms quey performance [message #616562 is a reply to message #616561] Wed, 18 June 2014 05:42 Go to previous messageGo to next message
cookiemonster
Messages: 10846
Registered: September 2008
Location: Rainy Manchester
Senior Member
You need to query v$session to get the sid and serial# of the session running the form.
Then call dbms_monitor.session_trace_enable to switch tracing on.

Then spend a while reading up on tkprof.
Re: Oracle forms quey performance [message #616563 is a reply to message #616562] Wed, 18 June 2014 05:44 Go to previous message
RaShi.Raj
Messages: 25
Registered: May 2014
Location: Bangalore
Junior Member
Thanks a lot...I'll see to this Smile
Previous Topic: change back ground of mdi form
Next Topic: do not show LOV when enable of text item=false
Goto Forum:
  


Current Time: Mon Jul 28 04:58:20 CDT 2014

Total time taken to generate the page: 0.09665 seconds