how to tune oracle sql queries pls tell me step by step.
urgent pls
Answer / 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 |
What is a trigger oracle?
What is the function of Redo Log ?
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
After using set unused can we enable the column again to use? Please give me some answers....
Differentiate between translate and replace?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
Can we create trigger on materialized view in oracle?
How to sort the query output in oracle?
How to make a Data Backup in oracle ? What is the procedure for creating the dump files in oracle ( any version ) ?
Explain a private synonyms?
What is background process in Oracle?
Find all employees in Dept “Marketing”.