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.