Sample Header Ad - 728x90

Oracle 9i historical long queries since instance startup

0 votes
1 answer
256 views
please I would like to know any query that shows the queries or the top 10 queries that take more time to finish since the beginning of the instance with user and the sql sentence, I have seen several that show those that are currently running and active but can not find any that show a historical of these queries since the instance was started, it is usually very simple from Toad with ADDM/AWR Reports but the database in question is Oracle 9i and does not give that option. Thank you
Asked by Arnaldo Raxach (145 rep)
Dec 5, 2018, 02:23 PM
Last activity: Jul 20, 2021, 05:04 PM