OraFAQ Forum: Forms » oracle forms and reports 11gr2 server taking too long for update data on database

Home » Developer & Programmer » Forms » oracle forms and reports 11gr2 server taking too long for update data on database (oracle forms and reports 11gr2)

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

oracle forms and reports 11gr2 server taking too long for update data on database [message #626472]

Tue, 28 October 2014 05:42

pd27
Messages: 3
Registered: April 2014

Junior Member

I have two oracle forms and reports server.

oracle forms and reports server 11gr1 (weblogic 10.3.5.0)
oracle forms and reports server 11gr2 (weblogic 10.3.6.0)

both are connected with same database but at time of update data on database new server(11gr2) taking twice or more then that time for data update compare to old one (11gr1).

I have checked deployed form and procedure inside that form they are same.

further analysis:

form has a PROCEDURE which update data in database and do some IO operation.

found that this PROCEDURE takes more time on 11gr2 compare to 11gr1.

Report message to a moderator

Re: oracle forms and reports 11gr2 server taking too long for update data on database [message #626473 is a reply to message #626472]

Tue, 28 October 2014 05:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Now that you found a culprit, tune it. I don't think that anyone can assist and/or debug code he can't see. Consider posting procedure's code. If you do that, please, format it and enclose it into [code] tags so that it is easier to read (here's how).

That would be a good start. If anyone needs additional information, you'll hear it.

Report message to a moderator

Re: oracle forms and reports 11gr2 server taking too long for update data on database [message #626478 is a reply to message #626473]

Tue, 28 October 2014 06:16

pd27
Messages: 3
Registered: April 2014

Junior Member

Thanks for the reply..
but how its possible that same thing work fine with 10g and 11gr1 but not with 11gr2?

with further troubleshooting I found that on 11gr1 and 10g server this procedure update more than 6 or 7 record per second but on 11gr2 server I found this procedure update only 1 record per second.

can you please tell me which jdbc or ojdbc driver used by form server(WLS_FORMS) or how can I find that ?

[Updated on: Tue, 28 October 2014 06:24]

Report message to a moderator

Re: oracle forms and reports 11gr2 server taking too long for update data on database [message #626584 is a reply to message #626478]

Wed, 29 October 2014 08:25

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

When is the last time you gathered stats on the tables in your 11gr2 instance? As Littlefoot stated, without seeing the code for the procedure, we don't know what the procedure is doing. You could be calling a deprecated Oracle procedure for all we know. You need to go through your code and make sure it is optimal. I would also recommending you trace the session so you can see what it is doing and see where the potential road blocks are.

Craig...

Report message to a moderator

Re: oracle forms and reports 11gr2 server taking too long for update data on database [message #626587 is a reply to message #626584]

Wed, 29 October 2014 09:13

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

Senior Member

It's different versions of the form software, not the DB.
OP says both are connected to the same DB so stats are irrelevant.

Tracing the session couldn't hurt though.

Report message to a moderator

Re: oracle forms and reports 11gr2 server taking too long for update data on database [message #626592 is a reply to message #626587]

Wed, 29 October 2014 10:02

pd27
Messages: 3
Registered: April 2014

Junior Member

how can I track session for WLS_FORMS ?

[Updated on: Wed, 29 October 2014 10:02]

Report message to a moderator

Previous Topic:	FRM 40010 - Cannot read form
Next Topic:	set Financial Year

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 19:56:11 CST 2025