[OAUGNetDBA]-Re: Login Page Screen Hangs

["Apparao Kandru" <Apparao.Kandru@imminet.com>]

We are on ATG 6 and I am not seeing the issue. Check to see how many rows you have in FND_LOG_TRANSACTION_CONTEXT?
If it is big then, As sysadmin Run the Concurrent program "Purge Debug Log" and then you can safely truncate the table to bring down the HWM
and then schedule the above job periodically to keep it contained.

Here is one of my postings from before.

>>

Pl. check and see if it has been personalized too much. 

Here are a few things you should try and do. 
1. Check to see that no statement level logging/debugging(various relevant
profiles) is turned on at site/global level. 

2. Check to see if the worklists(usually in favorites)/workflow is causing
it due to size of tables.

3. Get a level 12 SQL trace and tkprof it. You can do
this @ the user level thru the "Initialization SQL Statement - Custom"
profile option.
begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET
EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||''''); end;

4. You can also look at enabling FND: Diagnostics profile at your user
level, but you this may not help you a lot as you need to login for you to
do any tracing using this.

5. Check your Apache logs to see the various codes/time stamps to see how
everything is getting loaded, and then make sure to minimize logging in
Apache/Jserv.


>>> "Syed Aleem" <syed.aleem@aarcorp.com> 6/13/2008 1:09 PM >>>
It takes about good 20 minutes to go to the next screen.

-----Original Message-----
From: OAUG Net DBA listserver [mailto:OAUGNetDBA@oaug.com] On Behalf Of
Doug Sparks
Sent: Friday, June 13, 2008 11:51 AM
To: OAUG Net DBA listserver
Subject: [OAUGNetDBA]-Re: Login Page Screen Hangs 

Syed,

What exactly do you mean by "a long time"?  45 seconds, 3 minutes, 1
hour?

Is this only happening on the first login to the system after a
shutdown/bounce?  Nothing for the client is really loaded into memory or
cached at that point, so the first login would be the longest.

Try logging in from one machine first, note the time it takes and then
move to a completely different machine and try it, again noting the
elapsed time.



Doug

-----Original Message-----
From: OAUG Net DBA listserver [mailto:OAUGNetDBA@oaug.com] On Behalf Of
Syed Aleem
Sent: Friday, June 13, 2008 9:07 AM
To: OAUG Net DBA listserver
Subject: [OAUGNetDBA]-Login Page Screen Hangs

Hello everyone:

I am facing an issue with logging into oracle applications, after
entering my logon credentials and clicking logon button, the screen
hangs for a long time and finally it lets me in.

Basically I am having this issue after installing the following latest
Family Packs HRMS, Financials, and ATG RUP6 & Business Intelligence with
recommended patches on 11.5.10.2 application.

All the patches are installed successfully and also I pretty much took
care of post installation steps for compiling invalids, generating jar
files, forms, re-creating grants and synonyms, etc.

To resolve this issue, I bounced back the application services and
database couple of times, but it doesn't make any difference.  I checked
the apache log files I don't any see any errors.

I am wondering if anyone knows about these issues and their resolution
steps.  I am working under tight schedule to resolve this issue.

I appreciate if guys shed some light on this issue and provide me the
right direction to resolve this issue.


Thanks in advance.


Syed.



#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to
<OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>



#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>


****************************Confidential****************************
This correspondence is intended solely for the person or 
entity to which it is addressed and contains confidential
information. Any review, reproduction, dissemination, or 
other use of this correspondence by persons or entities 
other than the addressee is prohibited.
**********************************************************************


#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>