Q
Problem solve Get help with specific problems with your technologies, process and projects.

Order of pinning packages may be causing problems

I've pinned some big sys packages such as STANDARD, DBMS_RCVMAN, DBMS_OUTPUT in a shared pool, using a trigger AFTER STARTUP ON DATABASE. After the startup, all sys and users packages were invalid. How could I correct this and what is wrong in the trigger?
I would suggest pinning just one package at a time until you find the one that is causing invalidation. It's possible that the problem is the order in which you pin them.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close