Skip to Main Content

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 check which object is compiling and accessing

Ram_AFeb 24 2020 — edited Feb 24 2020

Hi Experts,

A .sql file(which contains lot of procedure and packages) of out it  one procedure is altering a table and compiling invalid objects.

When run this file its  running for long time and completing.

I hope some of object is recompiling and accessing it at the same.

Could you please help me how to check it.

Thanks in advance.

Comments
Post Details
Added on Feb 24 2020
3 comments
2,354 views