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