Performance tunning of Oracle applications

learner · Post by **learner** » Tue Jan 16, 2007 2:33 am

Sir,

I am really thankful to you for your greate support.

Regards
M Asif

banerjeesaby · Post by **banerjeesaby** » Thu Jan 18, 2007 7:21 am

The enabling of events in init.ora is logging a lot of extra information and probably slowing down the database.
Consider removing the following line from your init.ora andrestarting the database.

event 10210 trace name context forever, level 2, 10211 trace name context forever, level 2, 10235 trace name context forever, level 1, 10246 trace name context forever, level 2, 7267 trace name errorstack level 4, 3106 trace name errorstack level 4, 10076 trace name context forever, level 1

Let us know if it helps.

Thanks.

Post by **admin** » Thu Jan 18, 2007 8:30 am

After installation always change initilization parameters according to your requirement which are documented in the following metalink note, as the default parameters may not be enough for your instance.

Subject: Database Initialization Parameters for Oracle Applications 11i
Doc ID: Note:216205.1 Type: WHITE PAPER
Last Revision Date: 27-NOV-2006 Status: PUBLISHED

The following document contains the database initialization parameter settings for Oracle Applications 11i including releases 11.5.1 through 11.5.10. The document consists mainly of a common section, which provides the common set of database initialization parameters for all releases of the data server. The data server release specific database initialization parameters are listed in the respective section. The common section and the release specific section formulate the complete database initialization parameter file.

For detail please visit metalink.

Thanks

learner · Post by **learner** » Mon Jan 22, 2007 12:53 am

I am thankful to all.

Regards
M Asif

learner · Post by **learner** » Mon Jan 22, 2007 3:03 am

I want to visit some company that are using Oracle financials Application for study their Environments.

Can you give me some name of companies?

Again I am thankful to all of you for given me a lot of useful information.

Regards
M. Asif

learner · Post by **learner** » Mon Jan 22, 2007 3:52 am

Companies list available here who are using Oracle financial Application in Pakistan.

http://www.pasha.org.pk/html_files/memb ... e.asp?p=92

Regards,
M. Asif

Post by **admin** » Mon Jan 22, 2007 4:34 am

Dear Asif please post relevant to the topic as this topic is not relevant to list of companies. Hope next time you will take care. thanks

learner · Post by **learner** » Mon Jan 22, 2007 5:06 am

thanks for advise.

Regards
M. Asif

learner · Post by **learner** » Tue Jan 23, 2007 11:30 am

Dear Admin,

This document is for Oracle financial application 11i (Database Initialization Parameters for Oracle Applications 11i), but we are using Oracle financial application 11 version. Kindly help us about this matter.

Regards
M. Asif

Post by **admin** » Thu Jan 25, 2007 4:59 am

Let us know exact version of your applications. thanks

learner · Post by **learner** » Thu Jan 25, 2007 9:21 am

Product Information
Oracle Applications 11.0.300
Application object library 11.0.28
Oracle Forms 4.510.15.2
RDBMS 8.0.5.0.0

Regards
M. Asif

learner · Post by **learner** » Sat Jan 27, 2007 1:34 am

can anybody give answer?

Regards
M. Asif

Post by **admin** » Sat Jan 27, 2007 4:43 am

If you will not upgrade timely to the latest version then it would be hard for anyone to reply. thanks

learner · Post by **learner** » Sat Jan 27, 2007 5:44 am

Sir,

I also observe that we need to upgrade our oracle application.

Thanks for giving me advise.

Regards,
M. Asif

ERPstuff - Oracle EBS Community

Performance tunning of Oracle applications

Who is online