select * from
(
select
sql_id,
elapsed_time,
executions,
sql_text
from v$sql
ORDER BY elapsed_time desc
)
where rownum < 11;
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.