what are the methods using performance tunning in sql and
pl/sql
Answer Posted / vyshak
1.tracing
2.explain plan
3.auto tracing
4.AWR reports
5.using v$views
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are all types of user defined functions?
What are the types of queries in sql?
How many types of functions are there in sql?
What is the difference between a query and a report?
How would you pass hints to the sql processor?
Why do we use set serveroutput on?
Can we use rowid as primary key?
what is the use of friend function? : Sql dba
Are stored procedures compiled?
Can you do multiple joins in sql?
How do you create an update query?
What is bind variable in pl sql?
What is a call statement? Explain with an example.
What do you understand by case manipulation functions?
What is the difference between clustered and non-clustered indexes?