OraFAQ Forum: Forms » forms 10g runtime

Home » Developer & Programmer » Forms » forms 10g runtime

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

forms 10g runtime [message #169306]

Wed, 26 April 2006 03:36

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

Hi Friends
Im New User for Oracle 10g Forms.

When ever i run by form it takes too much time ( 30 sec.) for execution. can u tell me why this is tacking do much time .
and it is same for all forms.
may be i am missing some setting with formsweb.cfg or something else.

please guide me on this.

and one more thing can i run my from with out using browser just like option available in forms 6i run on client server or run on web

Thanks in Advance.

ASHish....

Report message to a moderator

Re: forms 10g runtime [message #169314 is a reply to message #169306]

Wed, 26 April 2006 04:23

Maaher
Messages: 7065
Registered: December 2001

Senior Member

No. You cannot run Forms10g in client/server mode. 6i is the last version that offered that possibility.

MHE

Report message to a moderator

Re: forms 10g runtime [message #169316 is a reply to message #169314]

Wed, 26 April 2006 04:27

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

Hi Maaher Thanks for your Reply.

Ok Now can u tell me why my froms are taking somuch time to get executed or get open even small froms which is based on emp table .

ASHish...

Report message to a moderator

Re: forms 10g runtime [message #169326 is a reply to message #169316]

Wed, 26 April 2006 05:06

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You are working local or on a remote application server. Since Forms has moved to the web there are so many things to take into consideration: bandwith, performance of the database server, application server and client. I can't tell you why, actually. It might be a browser setting, something in the webforms.cfg. Perhaps someone else here has an idea. Have you checked metalink for this?

MHE

Report message to a moderator

Re: forms 10g runtime [message #169340 is a reply to message #169326]

Wed, 26 April 2006 06:03

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

Senior Member
Account Moderator

Among many things that might be the reason, here's one of them: if you installed Oracle database locally (on your PC), you'll suffer from performance issues if you don't have enough RAM. I'd suggest you to upgrade it to 1 GB at least. Processor won't make that much difference, but upgrading RAM from, for example, 256 MB to 768 MB (buying another 512 MB chip) makes a HUGE difference.

Report message to a moderator

Re: forms 10g runtime [message #169448 is a reply to message #169316]

Wed, 26 April 2006 21:35

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Also, do not close the browser between running each form. Most of the time is taken is running the application on your PC the FIRST time. After that it is normally fairly fast, unless, or course, you have the database on your PC and you don't have enough memory!

David

Report message to a moderator

Re: forms 10g runtime [message #169451 is a reply to message #169340]

Wed, 26 April 2006 21:47

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

Hi friends

Databse is not intalled locally. my application is on local PC but it will be running on server once the devlopment is Done. I have 512 mb Ram . i dont think this is any database or netwroking issue i think i will have to do some setting to run my forms smooth and i dont know what are they
i'm attaching my formsweb.cfg file please check it .

i'm using IE6

and i'm also not able to close browser when i use exit_form or any othere procedure to close form can u tell me how to close browser by using forms builtin .

Thanks
ASHish

Attachment: formsweb.cfg
(Size: 9.16KB, Downloaded 1220 times)

Report message to a moderator

Re: forms 10g runtime [message #169455 is a reply to message #169451]

Wed, 26 April 2006 22:12

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I don't think you can close the initial browser window via Forms. But I know many developers who were closing the initial browser window EACH time they tested a form and they were having to wait 20-30 seconds for it to open up again.

Is your OC4J session failing each time you run your form?

David

Report message to a moderator

Re: forms 10g runtime [message #169456 is a reply to message #169455]

Wed, 26 April 2006 22:21

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

hi

OC4J session is not failing

C:\Documents and Settings\am228887>d:\dev10g\jdk\bin\java -Xbootclasspath/p:d:\d
ev10g\vbroker4\lib\vbjboot.jar -Doracle.security.jazn.config=d:\dev10g\j2ee\DevS
uite\config\jazn.xml -Doracle.home=d:\dev10g -DORACLE_HOME=d:\dev10g -jar d:\dev
10g\j2ee\home\oc4j.jar -userThreads -config d:\dev10g\j2ee\DevSuite\config\serve
r.xml
06/04/27 07:10:37 Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)
initialized
06/04/27 08:07:10 FormsServlet init():
    configFileName:     d:\dev10g/forms90/server/formsweb.cfg
    testMode:           false
06/04/27 08:07:34 ListenerServlet init()

above is the output affter i run that form for several times and exit.

and what do u mean by

Quote:

initial browser window

every time i run form it opens in new browser and last braoser reman as it is with blak block

Report message to a moderator

Re: forms 10g runtime [message #169459 is a reply to message #169456]

Wed, 26 April 2006 22:46

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Concerning 'initial browser window' I suggest that you run 'separateFrame=true' and see if you get any difference.

By the way, I assume that your form is NOT doing a 'query all' of a huge table in its first block.

David

Report message to a moderator

Re: forms 10g runtime [message #169460 is a reply to message #169459]

Wed, 26 April 2006 23:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have a look at other posts concerning 'formsweb separateframe'. For example, http://www.orafaq.com/forum/m/158330/67467/?srch=formsweb+separateframe#msg_158330 and maybe http://www.orafaq.com/forum/m/164915/67467/?srch=formsweb+separateframe#msg_164915

David

Report message to a moderator

Re: forms 10g runtime [message #169461 is a reply to message #169459]

Wed, 26 April 2006 23:11

ashishmate
Messages: 90
Registered: February 2005
Location: Mumbai

Member

ok
somthing is better by 2 to 3 seconds

but browser window is new for every opend form. means if i'm opning three form then there will be 3 browsers and 3 windows
can i open all three froms usning one browser.

Quote:

By the way, I assume that your form is NOT doing a 'query all' of a huge table in its first block.

it's taking time even if there is no datablock and onlu one item

Report message to a moderator

Re: forms 10g runtime [message #169654 is a reply to message #169461]

Fri, 28 April 2006 00:10

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

Senior Member
Account Moderator

Yet another idea ... I was *shocked* when the same happened to me yesterday evening. Form, which used to open quickly, took ages to open. I didn't install new software, hardware didn't change either, database is installed locally so network traffic is out of question. I went to bed without knowing what was wrong, until today morning when form opens quickly again.

The reason was a scheduled anti-virus scan (which I was unaware of - I simply forgot that I set it to run every day (evening, actually).

Report message to a moderator

Re: forms 10g runtime [message #506913 is a reply to message #169306]

Wed, 11 May 2011 15:44

josephpremkumar
Messages: 2
Registered: October 2005
Location: usa

Junior Member

Environment Forms10g

Simple form

Running the form using runform locally, onto my machine.

Able to see the result on the browser, running many times say for example 4 to 5 times able to view the result, after sometimes if I run the Run From,
I am not able to view the result, shows blank iexp. How can I debug this type of issues? Please advice.

Report message to a moderator

Previous Topic:	webutil not working in solaries
Next Topic:	copy value from

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 15:12:53 CDT 2024