We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Query execution thur oracle form 6i

Chetak-IT
Chetak-IT asked
on
Medium Priority
949 Views
Last Modified: 2012-06-27
I have a table AA and around 400 record in AA table
when i select retrive record in pl/sql with select statement it should recored within 1 or 2 second
bt when i execute query thru oracle 6i forms builder then it take around 30 to 40 second.
how can we fast query exeucution thru form builder.
Comment
Watch Question

flow01IT-specialist
CERTIFIED EXPERT

Commented:
check if  the count_query also needs 30 seconds, if not check the post-query trigger  for slow sql-statements : for each AA-record that statements will be executed once.

If you have the possibility of using the 'enterprise manager' software check what query's (an how often) are executed for the session.

Author

Commented:
after remove all post query it taking around 15 to 20 second
IT-specialist
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.