Is it possible to automate the optimization of slow queries in Oracle?

Question

Oracle

Tell me, is it possible to automate the optimization of slow queries in Oracle? What to read on this topic and in which direction to dig?
I also want to ask how to detect slow requests? And is it possible to somehow see the query execution plan?

Answer 1

Google about AWR. cool stuff. Here you have cache usage, and I / O, and slow requests.
If query optimization were easy to automate, Oracle DBAs wouldn't be paid that kind of money.

Answer 2

1) do not write slow queries, but only fast ones with the correct indexes
2) enable logging of queries running more than n milliseconds
3) explain I think Oracle also has

Answer 3

The ASHVIEWER utility is well suited for identifying slow queries in Online mode. Here is a link to information about the utility.
habrahabr.ru/company/jetinfosystems/blog/245507
To analyze slow queries over a period, an AWR report is suitable, which is easy to get in SQL Developer (view tab - dba)
In SQL Developer, you can also get advice on query optimization
from SQL tuning advise
in the report, find the report "TOP SQL by Waits"
select session and click on "SQL tuning advise"

Answer 4

Read about "Automatic SQL Tuning": docs.oracle.com/cd/E28271_01/server.1111/e16638/sq...

Answer 5

I learned that you can use the v$sqlarea view to identify slow queries, and you can get the query execution plan from v$sql_plan