what are the tunnig tables you used for tuning a query and
tell me some of coloumns in that tuning tables?
- 1 Answers
- 8833 Views
- Metric Stream, I also Faced
- E-Mail Answers
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
Why trigger is used in sql?
What is cursor in pl sql?
What is procedure function?
What is output spooling in sql*plus?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is column?
Why is sql better than hql?
Why stored procedure is faster than query?
What are keys in sql?
When is the update_statistics command used?
What are all the different normalizations?
Whis is not false in primary key?
how to rename an existing column in a table? : Sql dba
what are date and time data types? : Sql dba
How does pl sql work?
