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 the difference between simple view and complex view?
What is a trace file and how is it created in oracle?
what is the syntax of UPDATE command?
Calculate difference between 2 date / times in oracle sql?
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is index in Oracle?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
What are the uses of Rollback Segment ?
What is connection pool in oracle?
How to commit the current transaction in oracle?
What is data type in oracle?