what is tuning in oracle apps technical

Answer Posted / kutti

Tuning is nothing but checking the query performance,suppose you have a query which is taking more time to finish.in that scenario we do performance tuning for that query.

we have to check why and where query is taking more time by using Explain plan in SQL Tools.then we will fix that issue with proper tuning.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is global tempory table?

6327


do you know is it possible to run the interface without using oracle apps?

660


What is a value set? List its various types.

658


How to move the one file from one instance to another instance? And your scripts also?

619


please send me forms, xml pulisher questions,answers

1667






How can a process be deployed in soa?

712


List the various types of value set.

631


Do you know what is applysys in oracle application database schema, what is apps?

685


What do you understand by soa?

701


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1696


Do you know where we can check the status of po?

647


Explain oracle apps architecture.

782


Tell me how to debug the report?

655


What are the Standard Reports and Forms in HRMS?

1778


testing tools?

1770