SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to monitor every query ( select , insert, update,delete, alter, create,drop, execute etc...) in

User_CSOQUJan 14 2020 — edited Jan 17 2020

My database version is Oracle 19.3 c. I have only installed database. Then create one pdb. Then create 10 schemas.

Now I want to monitor every query fire by user either front-end or back-end.

I have no cloud. I will use this in development environment.

In Sql server I can monitor such things using sql server profile.

Please help how to monitor every query ( select , insert, update,delete, alter, create,drop, execute etc...)

I am also using oracle sql developer 19.2 & Toad 13.

Thanks

Solaiman

Added on Jan 14 2020

16 comments

5,398 views