Home » Developer & Programmer » Forms » Forms Performance Tuning (merged by CM) (Forms [32 Bit] Version (Production))
Forms Performance Tuning (merged by CM) [message #440114] Thu, 21 January 2010 02:59 Go to next message
Messages: 5
Registered: December 2007
Location: Bahrain
Junior Member

I am very new to oracle performance tuning. We have a form which is associated with 3 tables having more than 45lacs of records.

table structure is like
Table A is parent for Table B and Table B is Parent for Table C.

All the block are related with each other. When we Navigate through the records in forms it takes some ms to navigate(some times if we press the down key for a while and release it, takes few seconds too).

Because of this my manager asked me to tune the forms.

Can anyone help me , to solve this problem.

Thanks in Advance
Re: Forms Performance Tuning [message #440124 is a reply to message #440114] Thu, 21 January 2010 03:31 Go to previous messageGo to next message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
As per the information provided i can give you these links...

HOw to tune forms

Results from Google

Good luck

sriram Smile
Re: Forms Performance Tuning [message #444943 is a reply to message #440124] Wed, 24 February 2010 22:06 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

Sounds like you need some indexes in the database.

Previous Topic: Forms 6i - REPORT_OBJECT_STATUS cannot be null
Next Topic: Connect SQL Server with Forms6i
Goto Forum:

Current Time: Thu Jul 27 10:01:41 CDT 2017

Total time taken to generate the page: 0.26815 seconds