Re: Some body know the impact in performance of unused database options installed

        I only install only the options required by the app, and have not had any issues. In many cases, the app did not require any of the options (including java), which made things even simpler.

    I've inherited databases that had many if not all options installed, when only 1 or 2 options were needed. These installations would sometimes have issues with upgrades, and patches. It's very frustrating having upgrading issues, but more so when the issue is with an option that is never used.

    More options create more objects. This will have an impact on backups/datapump.

    Keep it simple.

• Original Message ----- From: Matthew Parker To: jcdrpllist_at_gmail.com ; 'ORACLE-L' Sent: Monday, October 20, 2014 11:52 AM Subject: RE: Some body know the impact in performance of unused database options installed

  Normal installation of extra options normally it simply a larger space consumer at the OS file system for Oracle Home.

  In the past there have been some cases where an option has to be installed to fix a bug in some other option even though you were not using the option that needed to be installed.    

  Which specific option did you uninstall and saw a performance boost.        

  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Juan Carlos Reyes Pacheco   Sent: Monday, October 20, 2014 8:44 AM   To: ORACLE-L
  Subject: Some body know the impact in performance of unused database options installed    

  Hello if you know please,    

  We used to install all the options from 9i, intermedia, and all that things, thinking one time in the future we could use them, in standard edition one.    

  Now we have defined our strategy, we saw some components are useless and we decided do not install them. Because some of them are causing several problem when upgrading.

  And I had noted a real important improvement in performance.    

  That is the reason why I was wondering if someone made a test of the performance impact of installing some components without using them, or some comments about it. (other than java)    

  Thank you :)

--
http://www.freelists.org/webpage/oracle-l