what are the tunnig tables you used for tuning a query and
tell me some of coloumns in that tuning tables?
Answer Posted / vyshak
select * from
(select sql_id,sql_fulltext,elapsedtime
from v$sql
order by elapsedtime desc)
where rownum<5;
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is a primary key? Explain
How do I remove duplicates in two columns?
What is varchar data type in sql?
How can you view the errors encountered in a trigger?
Why do we need view in sql?
What are the different schemas objects that can be created using pl/sql?
How do I find duplicates in the same column?
Explain the advantages and disadvantages of stored procedure?
What are aggregate and scalar functions?
Enlist the characteristics of pl/sql?
What is pl/sql language case sensitive?
What is data type in database?
What do you understand by exception handling in pl/sql?
What is difference between function and trigger?
How to pronounce postgresql?