Sign Up Login


  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

Can we use commit inside a trigger?

0 Answers  

Explain character-manipulation functions?

0 Answers  

What is pl/sql language case sensitive?

0 Answers  

What are some emotional triggers?

0 Answers  

Differentiate between pl/sql and sql?

0 Answers  




What is rownum?

0 Answers  

Is sql difficult?

0 Answers  

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

Explain what is dbms?

0 Answers  

How do I write a cron which will run a sql query and mail the results to agroup?

0 Answers  

difference between anonymous blocks and sub-programs.

0 Answers  

Why having clause is used in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories