Disadvantages
- Plan switching occurs often, unless the application flow follows a narrow path.
- It is difficult to use protected threads, because the transactions are spread over many sets of transaction IDs, plans, and threads.
- Resource consumption can be high, due to plan switching and low thread reuse.
Note: Packages avoid these disadvantages.