OraFAQ Forum: Forms » Oracle forms quey performance

Home » Developer & Programmer » Forms » Oracle forms quey performance (Forms 11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Oracle forms quey performance [message #616545 is a reply to message #616544]

Wed, 18 June 2014 02:48

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

Trace the session and have a look at the tkprof output.

Report message to a moderator

Re: Oracle forms quey performance [message #616554 is a reply to message #616545]

Wed, 18 June 2014 04:49

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

Can you please explain how can I use trace/TKRPOF with forms session?

Report message to a moderator

Re: Oracle forms quey performance [message #616558 is a reply to message #616554]

Wed, 18 June 2014 05:13

cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester

Senior Member

Don't you have a DBA for jobs like this?

Report message to a moderator

Re: Oracle forms quey performance [message #616561 is a reply to message #616544]

Wed, 18 June 2014 05:38

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

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

cookiemonster
Messages: 13921
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.

Report message to a moderator

Re: Oracle forms quey performance [message #616563 is a reply to message #616562]

Wed, 18 June 2014 05:44

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

Thanks a lot...I'll see to this Smile

Report message to a moderator

Previous Topic:	change back ground of mdi form
Next Topic:	do not show LOV when enable of text item=false

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 07:36:23 CDT 2024