select * from (select sql_id,sql_fulltext,elapsedtime from v$sql order

what are the tunnig tables you used for tuning a query and
tell me some of coloumns in that tuning tables?

Question Posted / vyshak

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

Please Help Members By Posting Answers For Below Questions

Can we insert data into materialized view?

896

What is the difference between instead of trigger and after trigger?

947

What does the hierarchical profiler does?

1002

Which is faster subquery or join?

1141

What does select * from mean in sql?

3063

What does cursor do in sql?

967

how can we find the number of rows in a table using mysql? : Sql dba

1028

how to get a list of indexes of an existing table? : Sql dba

913

how to create a new table in mysql? : Sql dba

932

What is the usage of nvl function?

981

How do I view a procedure in sql?

906

What is the difference between sql and t sql?

962

What is the difference between microsoft sql and mysql?

919

How do I add a primary key to a table?

968

What is a primary key called that is made up of more than one field?

1279