Hello,
I have an instance to watch at. It is up since many months and last week there were heavy load problems, probably generated by suboptimized queries of a new schema introduced.
I don't know yet if statspack and/or AWR are in place (not connected yet). The RDBMS is an enterprise edition but my question is also for standard edition, just in case:
If nothing has been set in place, is there a way to see any kind of performance data of the past, or inefficient queries executed a week ago, supposing the instance has not been restarted in the period I want to analyze?
Perhaps some system views already containing performance statistics of any sort?
Thanks in advance,
Gianluca