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

Hi,
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
Ansari
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
ramoradba
Messages: 2454
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
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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.

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


Current Time: Sun Dec 04 10:35:32 CST 2016

Total time taken to generate the page: 0.10417 seconds