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

What are some emotional triggers?

982

Which is better cte or subquery?

1026

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1005

What are the methods of filing?

935

what is sql? : Sql dba

1024

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1003

How many joins in sql?

1004

What is a sql instance vs database?

1113

what are the advantages of mysql in comparison to oracle? : Sql dba

1000

What are joins in sql?

1042

What is #table in sql?

1093

Why do we use joins?

1033

Explain clause in sql?

1027

What is the difference between sql and isql*plus?

1090

What is the difference between rename and alias?

1341