Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 3544 | Permalink

Forms are Slow After upgrade database 9.2.0.6 to 10.2.0.3 in Oracle Apps

Question ID: 3544
Created By: 2009-JAN-30 22:19:16 [Sadhadba]
Updated By: 2009-JAN-31 12:57:53 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
9932
2009-JAN-30 22:19:16
User
 
 
Registered On: Jan 2009
Total Posts: 4
After upgrade database 9.2.0.6 to 10.2.0.3 in oracle apps 11.5.10.2 instance 
the below problems are occur.

Forms are running very slow and 

1. Finance module:

    oracle payables for invoices and payments while try to create the 

    accounting the system is hanging , its taking several hours for 

    creating the account.

Naviagation :
  oracle payable --> Invoices -- > Actions --> Create accounting

  Oracle paybles -- > Payments -- > Actions -- > Create accounting


2. In purchase module
   At the time of forwading PO approval it will take 10-15 minutes .


Please give the solution this is the production server 



Thanks & Regards
Sadhanand - DBA
91-09985865838
[edited by: Sadhadba at 22:28 (CST) on Jan. 30, 2009]
9937
2009-JAN-30 23:12:33
Moderator
 
 
Registered On: Mar 2006
Total Posts: 267
Did you run APPS level gather statistics?  (it's under SYSADMIN resp.)
9940
2009-JAN-30 23:16:52
User
 
 
Registered On: Jan 2009
Total Posts: 4
Hi sir

Yes I run APPS level gather statistics, still problem is not solved


Thanks for quick response.
[edited by: Sadhadba at 23:17 (CST) on Jan. 30, 2009]
9945
2009-JAN-31 12:57:53
Moderator
 
 
Registered On: Mar 2006
Total Posts: 267
> Naviagation :
>   oracle payable --> Invoices -- > Actions --> Create accounting
>   Oracle paybles -- > Payments -- > Actions -- > Create accounting
> 
> 
> 2. In purchase module
>    At the time of forwading PO approval it will take 10-15 minutes .
> 

Turn the trace ON for each of these processes and review the trace file to see 
what is going on.