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 is an alias command? : Sql dba

1070

Can we call a function containing dml statements in a select query?

958

explain access control lists. : Sql dba

977

Why functions are used in sql?

971

How do we accept inputs from user during runtime?

1040

Which type of cursor is used to execute the dml statement?

938

Can we create a trigger on view?

876

What port does sql server use?

1041

How are functions and procedures called in PL/SQL?

1194

What are conditional predicates?

1031

what is single byte over head in oracle..?

2382

Explain polymorphism in pl/sql.

1093

what are the advantages of sql ? : Sql dba

1041

What are all the different normalization?

1022

Can we join two tables without common column?

984