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
What is a named program unit?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to connect to a remote server?
How to rename an index?
How to view the tablespaces in the current database?
What is the difference between formal parameters and actual parameters?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Explain constraining triggers.
How to unlock the sample user account in oracle?
How to run create database statement?
How to apply filtering criteria at group level in oracle?
Explain what are the uses of rollback segment?
How to call a sub procedure?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to set a transaction to be read only in oracle?