| Forms Performance Tuning (merged by CM) [message #440114] |
Thu, 21 January 2010 02:59  |
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 #444943 is a reply to message #440124] |
Wed, 24 February 2010 22:06  |
 |
djmartin
Messages: 10181
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.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
