what are the tunnig tables you used for tuning a query and
tell me some of coloumns in that tuning tables?
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 |
What is fmtonly in sql?
What does pl sql stand for?
how to enter binary numbers in sql statements? : Sql dba
Why do you partition data?
What is coalesce in sql?
how to fetch alternate records from a table? : Sql dba
Why do we use function in pl sql?
Is sql a programming?
Explain uses of cursor.
Differentiate between % rowtype and type record.
What are string functions in sql?
How to order siblings in oracle hierarchy queries?