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 to drop a tablespace?

575


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1833


How to use "in" parameter properly?

620


How to count duplicated values in a column in oracle?

554


How to create lov dynamically at runtime & attach to text field?

666






How to select some rows from a table in oracle?

598


What are dml statements in oracle?

623


What is an oracle?

581


What is a dynamic performance view in oracle?

608


What is a oracle database?

610


Is there any function in oracle similar like group_concat of mysql?

541


How to use like conditions in oracle?

570


What are the limitations of check constraint?

575


What are the parameters that we can pass through a stored procedure?

558


What is the quickest way to export a table to a flat file?

575