3 Replies Latest reply: Jul 1, 2014 7:36 AM by Stevan-Oracle RSS

    SADMIN user

    MaJo

      Hello All

       

      Siebel 8.1 and Oracle 11gR2

       

      Reading the

      Performance Tuning Guidelines for Siebel CRM

      Applications on Oracle Database

       

      We can see that some parameters are hard coded for Siebel sessions

      OPTIMIZER_MODE = FIRST_ROWS_10*

      _HASH_JOIN_ENABLED = FALSE

      _OPTIMIZER_SORTMERGE_JOIN_ENABLED = FALSE

      _OPTIMIZER_JOIN_SEL_SANITY_CHECK = TRUE

       

      I can verify this for my users except for the SADMIN user, is this expected ?

       

      Appreciate your answer...

       

      Thanks

      Magnus

        • 1. Re: SADMIN user
          Stevan-Oracle

          Magnus,

           

          From a database perspective, SADMIN should just be another user (it is not, for example, normally the tableowner).  So I am not sure why it would be showing as different.  Specifically how were you verifying this?

           

          Best regards,

          Stevan - Oracle

          • 2. Re: SADMIN user
            MaJo

            Hi Stevan, thanks for your reply...

             

            I used two different methods, I checked V$SES_OPTIMIZER_ENV for SADMIN user and I also used DBMS_SQLDIAG.DUMP_TRACE

            for the sql that was performing slow by SADMIN.  We have another Siebel system and I can see it is the same here.

             

            I talked to our Siebel developers and they believe that the sql comes from a part that normally should not be executed as SADMIN.

             

            Found this is the Siebel Applications Administration Guide

             

            To begin setting up your Siebel application, you must log in with administrative responsibilities. The

            Siebel database server installation script creates a Siebel administrator account that you can use to

            perform administrative tasks. The default user ID is SADMIN.

             

            So I assume it should be used to configure Siebel and should not be used for application usage.

            So I assume having different settings from application users is expected

             

            Thanks

            Magnus

            • 3. Re: SADMIN user
              Stevan-Oracle

              Magnus,

               

              If you can, you may want to go ahead and open a service request with Oracle Technical Support.  If you look at the grantusr.sql script it really does not do anything special for the SADMIN user when creating it at the database level.  That being said as a general principal SADMIN should not be used for routine operations.

               

              Steve