Home » Developer & Programmer » Forms » oracle forms and reports 11gr2 server taking too long for update data on database (oracle forms and reports 11gr2)
oracle forms and reports 11gr2 server taking too long for update data on database [message #626472] Tue, 28 October 2014 05:42 Go to next message
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.
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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...
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 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
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 Go to previous message
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:
  


Current Time: Thu Mar 28 10:18:10 CDT 2024