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

How to return multiple rows from the stored procedure?

1014

What is sql analyzer?

1059

Why do we need cursors in pl sql?

1155

How do you create a db file?

1067

Can a foreign key have a different name?

995

Can we use view in stored procedure?

954

What is the location of pre_defined_functions.

1208

Why left join is used in sql?

1019

what happens if null values are involved in expressions? : Sql dba

1092

Is sqlexception checked or unchecked?

1009

What is mutating error in pl sql?

1065

Explian rowid, rownum? What are the psoducolumns we have?

1045

What is the usage of the distinct keyword?

1274

What is the purpose of the sql select top clause?

1204

how is myisam table stored? : Sql dba

1097