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



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

What is fmtonly in sql?

0 Answers  


What does pl sql stand for?

0 Answers  


how to enter binary numbers in sql statements? : Sql dba

0 Answers  


Why do you partition data?

0 Answers  


What is coalesce in sql?

0 Answers  






how to fetch alternate records from a table? : Sql dba

0 Answers  


Why do we use function in pl sql?

0 Answers  


Is sql a programming?

0 Answers  


Explain uses of cursor.

1 Answers  


Differentiate between % rowtype and type record.

0 Answers  


What are string functions in sql?

0 Answers  


How to order siblings in oracle hierarchy queries?

0 Answers  


Categories