<div>
check if &nbsp;the count_query also needs 30 seconds, if not check the post-query trigger &nbsp;for slow sql-statements : for each AA-record that statements will be executed once.<br />
<br />
If you have the possibility of using the 'enterprise manager' software check what query's (an how often) are executed for the session.
</div>


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.

<div>
after remove all post query it taking around 15 to 20 second
</div>


after remove all post query it taking around 15 to 20 second

<div>
<div class="content wysiwyg-content">
I have a table AA and around 400 record in AA table<br />
when i select retrive record in pl/sql with select statement it should recored within 1 or 2 second<br />
bt when i execute query thru oracle 6i forms builder then it take around 30 to 40 second.<br />
how can we fast query exeucution thru form builder.<br />

</div>
</div>


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.


Query execution thur oracle form 6i

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.