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

When is the update_statistics command used?

0 Answers  

What are instead of triggers?

0 Answers  

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

How do I clear the screen in sql plus?

0 Answers  

how to check myisam tables for errors? : Sql dba

0 Answers  




how would you get the current date in mysql? : Sql dba

0 Answers  

How did you export data from database to excel file.

1 Answers   TCS,

What happens when a trigger is associated to a view?

0 Answers  

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

Which version of sql do I have?

0 Answers  

What is difference between mysql and postgresql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories