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 a database transaction? : Sql dba

1108

What are the different set operators available in sql?

974

what is offset-fetch filter in tsql? : Transact sql

893

how do you know the version of your mysql server? : Sql dba

937

What is use of trigger?

875

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

909

What is coalesce sql?

943

How many commands are there in sql?

972

Is primary key a clustered index?

914

In pl/sql, what is bulk binding, and when/how would it help performance?

938

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1219

What are % type and % rowtype?

983

What is sql character function?

996

What is java sql driver?

1040

What are local and global Indexes and where they are useful.

1379