OraFAQ Forum: Forms » Builtin Logon procedure slow

Home » Developer & Programmer » Forms » Builtin Logon procedure slow

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

Builtin Logon procedure slow [message #304491]

Wed, 05 March 2008 07:03

sandeep.girdhar
Messages: 5
Registered: March 2008
Location: Delhi

Junior Member

when i am using the builtin LOGON Procedure its taking long time to connect to the destination database.

Can anybody Give me the solution Why its Taking long time?

Report message to a moderator

Re: Builtin Logon procedure slow [message #304503 is a reply to message #304491]

Wed, 05 March 2008 07:24

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

Senior Member
Account Moderator

How much time does it take when you don't use the LOGON built-in? What does the TNSPING your_database (issued at the command prompt) say? How many milliseconds?

Report message to a moderator

Re: Builtin Logon procedure slow [message #304508 is a reply to message #304503]

Wed, 05 March 2008 07:48

sandeep.girdhar
Messages: 5
Registered: March 2008
Location: Delhi

Junior Member

ping command taking the time 32ms.

if I m using the LOGON then it take approx. 40 sec.
And i m running the form through Apllication server 9i release 2.

Is there any parameter we have to set?

Report message to a moderator

Re: Builtin Logon procedure slow [message #304612 is a reply to message #304508]

Wed, 05 March 2008 17:09

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

Senior Member
Account Moderator

What work is the database doing each time you logon?

David

Report message to a moderator

Re: Builtin Logon procedure slow [message #304631 is a reply to message #304612]

Wed, 05 March 2008 23:00

sandeep.girdhar
Messages: 5
Registered: March 2008
Location: Delhi

Junior Member

In LOGON i provide the parameter like

LOGON(user_name,password,connect_string);

But i am not sure why this statement is slow,

Report message to a moderator

Re: Builtin Logon procedure slow [message #304632 is a reply to message #304631]

Wed, 05 March 2008 23:16

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

Senior Member
Account Moderator

I repeat:

What work is the database doing each time you logon?

David

Report message to a moderator

Re: Builtin Logon procedure slow [message #304737 is a reply to message #304632]

Thu, 06 March 2008 07:49

sandeep.girdhar
Messages: 5
Registered: March 2008
Location: Delhi

Junior Member

LOGON is the builtin of the forms 9i.This builtin only make the connection with the destination database schema.

Only this process(LOGON) is taking time.

After connecting to the database schema.its running smoothly.

Problem is only that,its taking time to connect the destination schema.once the connection is established its running smmoth.

Is there any parameter in application or database that we have to set?

Report message to a moderator