Oracle - Identifying problematic SQL statements

[danielsapbasis]

Hi Experts,

How to identify the problematic SQL statements in Oracle database 12c /19 c?

* Over memory and CPU consumption

* Usernames responsible for DB load and slowness

* Causing high disk I/O

Please share the log files and troubleshooting tools available.

Thanks in advance

[Sandra_Rossi]

It's questions about Oracle database administration. They must have been asked a lot in the Web. Why not checking the Oracle forums?

[Sriram2009]

Hi Daniel,

Check this SAP Note 1817553 for your all questions

Regards

SS