10 Replies Latest reply: Jul 24, 2012 9:32 AM by Jeff Smith Sqldev Pm-Oracle RSS

    SQL developer License

    937382
      Please suggest weather we need to precure the license for use oracle developer or it is free.

      Sridhara
        • 1. Re: SQL developer License
          590998
          SQL Developer is 100% free.
          • 2. Re: SQL developer License
            Jeff Smith Sqldev Pm-Oracle
            The tool is free.

            Formal support is tied to your database licensing, otherwise you can post questions here.

            There are premium database features accessible via SQL Developer. Use of those features is limited to those who have licensed the appropriate database features and packs.

            Please let me know if you have any additional questions.

            Regards,

            Jeff Smith
            SQL Developer Product Manager
            • 3. Re: SQL developer License
              John Thomas
              Yes, this is probably the single biggest thing holding back SQL Developer adoption.
              • 4. Re: SQL developer License
                Jeff Smith Sqldev Pm-Oracle
                this
                Please define 'this.'

                Have you inspected the licensing preferences? You can disable these features in SQL Developer at a database connection level.

                You do realize you run the same risk by connecting with SQL*Plus, right?
                • 5. Re: SQL developer License
                  John Thomas
                  Jeff,

                  this/T͟His/Pronoun: Used to identify a specific person or thing close at hand or being indicated or experienced: "is this your bag?".


                  Adjective: Used to identify a specific person or thing close at hand or being indicated or experienced: "don't listen to this guy".


                  Adverb: To the degree or extent indicated: "they can't handle a job this big".


                  Synonyms: pronoun. it - that - this one - these
                  adverb. thus - so - that


                  This: "There are premium database features accessible via SQL Developer..."

                  No I have not "inspected the licensing preferences". Nor am I likely to spend my time doing so when I should be performing tasks I am paid to do.

                  SQL*Plus does not put the options in front of you. To use a premium feature in SQL*Plus you have to go and make an effort to look up the API and how to use it.

                  That is quite different from Oracle Marketing getting Jeff's development team to make all these options easily available. All you need to do to use a premium feature - and set auditing flags in the database to say you have used it - is click on a menu item. This enables inexperienced DBAs - and some experienced ones probably - and developers to use options the customer has not acquired licenses for, and Oracle Sales to beat customers up at the next review.

                  Such options should be disabled by default.

                  Cheers,

                  John
                  • 6. Re: SQL developer License
                    John Thomas
                    Had a look at the licensing preferences. In Tools-> Preferences -> Database -> Licensing. Only covers EM packs. Not additional cost features like some uses of Data Modeller, Data Miner, Advanced Compression, and what else? I don't know because I'm not employed as a licensing specialist.

                    And that's my point. Sites are put off choosing SQL Developer because managers have experienced Oracle Sales practice before and do not want to be hit with large fees for features they did not know they were using, or needed.

                    Cheers,

                    John
                    • 7. Re: SQL developer License
                      Jeff Smith Sqldev Pm-Oracle
                      Data Modeler is not an additional cost feature.

                      There's no way to disable Partitioning, but you can use those same feature usage views to identity curtail usage of those features by developers who are not aware of what your license gives you access to.

                      You can remove data miner by disabling its extension in Preferences.
                      • 8. Re: SQL developer License
                        Jeff Smith Sqldev Pm-Oracle
                        Grammar lesson aside, I appreciate your feedback here.

                        It's a tough balance to maintain -

                        If we hide the features, then people will assume they are not there.

                        If we expose the features, then some may abuse or misuse them.

                        However, Oracle Marketing doesn't drive features in SQL Developer. And it's not 'my' product, it's the community's product. The community and the database updates drive features.

                        If you have invested in premium database features, the IDE should support those. But, we do warn users before launching the diagnostic and tuning pack features that they require additional licensing. We could investigate taking that a step further to include other non Std licensing features. Please submit your suggestions to the Exchange.

                        Thanks,
                        Jeff
                        • 9. Re: SQL developer License
                          John Thomas
                          OK, will do. The grammar lesson was just my warped sense of humour.

                          Cheers,

                          John
                          • 10. Re: SQL developer License
                            Jeff Smith Sqldev Pm-Oracle
                            It's ok, you made me laugh, a little :)

                            Thanks for clarifying your position. I just wanted to make sure I really understood your issue before I replied.