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 |
How to create tables for odbc connection testing?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is a cursor in oracle?
How to use group functions in the select clause using oracle?
When do you get a .pll extension in oracle?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
How to create a new table in your schema?
What is a proxy object?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
What are named parameters?
Can a View based on another View ?
Explain oracle’s system global area (sga).