Interested to Buy Any Domain ? << Click Here >> for more details...
how to tune oracle sql queries pls tell me step by step.
urgent pls
- 1 Answers
- 3231 Views
- I also Faced
- E-Mail Answers
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 |
How to retrieve 5th highest sal from emp table?
What is not equal to in oracle?
How to convert characters to dates in oracle?
How to view the dropped tables in your recycle bin?
What is self-referential integrity constraint ?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What is a named program unit?
What is a Private Synonyms ?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What is the relationship among database, tablespace and data file?
what is the difference between table and veiw?
Compare and contrast between sql and sql server and explain its various functions?
Oracle General 
