title: DBMS_APPLICATION_INFO.SET_CLIENT_INFO not working
body: <p>I need to set the client_info value to differentiate between different clients.</p>
  
  <p>These are the scripts that I am running to test.</p>
  
  <p>Step 1:SYS SCHEMA</p>
  
  <pre><code>ALTER SYSTEM FLUSH SHARED_POOL;
  ALTER SYSTEM FLUSH BUFFER_CACHE;
  </code></pre>
  
  <p>Step 2:HR SCHEMA</p>
  
  <pre><code>EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO(UTL_INADDR.GET_HOST_NAME );
  EXEC DBMS_APPLICATION_INFO.SET_MODULE( 'CHECK','select' );
  
  select                                      
      a.FIRST_NAME || ' ' || LAST_NAME AS FULL_NAME
  from                                        
      HR.EMPLOYEES a                                      
  where                                       
      a.DEPARTMENT_ID = '40'
  ;
  </code></pre>
  
  <p>Step 3:SYS SCHEMA</p>
  
  <pre><code>select
      *
  from
      (
          select
             a.SQL_ID
            ,a.SQL_FULLTEXT
            ,to_char( a.LAST_ACTIVE_TIME,'DD-MON-YYYY HH24:MI:SS' )                                                                                as LAST_ACTIVE_TIME
            ,a.SERVICE
            ,b.SCHEMANAME
            ,b.CLIENT_INFO
            ,a.MODULE
            ,a.ACTION
          from
              GV$SQL a
          left outer join GV$SESSION b
          on
              (
                  b.SQL_ID = a.SQL_ID
              )
          where
              a.EXECUTIONS != 0
      )
      c
  where
      c.MODULE like '%CHECK%'
  order by
      c.LAST_ACTIVE_TIME desc ;
  </code></pre>
  
  <p>The MODULE and ACTION columns are getting the values but the CLIENT_INFO is not showing anything.</p>
  
  <p>Is there anything I am missing?</p>
  
  <p><strong>Update:</strong>
  I have also tried with no luck</p>
  
  <pre><code>EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO( SYS_CONTEXT('userenv','ip_address') );
  EXEC DBMS_APPLICATION_INFO.SET_CLIENT_INFO( '10.10.10.10' );
  </code></pre>