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 is an alias command? : Sql dba
Differentiate between % rowtype and type record.
define data blocks ? : Sql dba
What is natural join in sql?
Which table is left in left join?
Is sql a backend?
What is scalar function in sql?
What is the difference between function and procedure in pl/sql?
What are synonyms in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
what is unique key constraint? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Which are sql * plus commands?
Can procedure in package be overloaded?