Skip to Main Content

Oracle Database Discussions

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!

plsql code compilation issues

0614Oct 12 2021

Hi Oracle folks,
Application dependent on oracle DB completely and there are more highly accessed packages and procedures.
when we alter the table or object of the underlying packages gets invalid needs to recompile.
The application continuously accessing these objects so not able to compile and getting DB hung and even getting application transaction loss.
Please do the needful and suggest any other way to deploy highly accessed objects

Comments

Post Details

Added on Oct 12 2021
2 comments
57 views