how to tune oracle sql queries pls tell me step by step.
urgent pls

Answer Posted / define

You can use pl/sql query profiler in dbForge Studio for Oracle. It helps to tune oracle sql performance very much.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of tables supported by oracle?

788


Explain oracle data types with examples?

759


Why does Oracle not permit the use of PCTUSED with indexes?

2165


Differentiate between function and procedure in oracle.

775


How to load excel data sheet to oracle database

760


How to convert raw data type into text in oracle? Explain

792


How to delete multiple rows from a table in oracle?

774


How to define a data source name (dsn) in odbc manager?

757


What is oracle open database communication (odbc)?

753


How to establish administrator authentication to the server?

772


How do I find the database name in oracle?

770


what is the dual table in oracle?

730


How to manage transaction isolation level?

747


What are the limitations oracle database 10g xe?

761


What is the fastest query method to fetch data from the table?

1091