1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what are the tunnig tables you used for tuning a query and
tell me some of coloumns in that tuning tables?

Question Posted / devi


what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning..

Answer / 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

Post New Answer

More SQL PLSQL Interview Questions

Difference between global and parameter variables?

0 Answers   TCS,

How do I pipe the output of one isql to another?

0 Answers  

describe transaction-safe table types in mysql : sql dba

0 Answers  

what is sql? : Sql dba

0 Answers  

What does inner join mean?

0 Answers  




Explain the update statement in sql

0 Answers  

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

What is triggering circuit?

0 Answers  

What is the use of time stamp in select statement?

1 Answers   TCS,

What is diff between bulk collect and forall

3 Answers   Metric Stream,

What is output spooling in sql*plus?

0 Answers  

What is the difference between cluster and non-cluster index?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories