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 do I upgrade sql?

553

What is sql*loader?

576

Can we have two clustered index on a table?

568

what is 'mysqlcheck'? : Sql dba

577

Can unique keys be null?

488

How many indexes can be created on a table in sql?

499

Mention what is the plv (pl/vision) package offers?

643

How to run sql commands in sql*plus?

591

What is a schema? How is it useful in sql servers?

597

What is the use of function "module procedure" in pl/sql?

675

Differentiate between sga and pga.

676

How to change the order of columns in Oracle SQL Plus ?

616

What is the difference between partition and index?

485

How do I create a memory optimized filegroup?

533

what are different types of collation sensitivity? : Sql dba

562