2 Replies Latest reply on Nov 6, 2017 12:06 PM by Joel Acha

    Enable Usage_Tracking, only Weblogic's user data inserted

    DongxiYU

      NQSConfig.INI

      [USAGE_TRACKING]
      
      ENABLE = YES;  
      
      #==============================================================================
      # Parameters used for writing data to a flat file (i.e. DIRECT_INSERT = NO).
      #
      # Note that the directory should be relative to the instance directory.
      # In general, we prefer directo insert to flat files. If you are working in
      # a cluster, it is strongly recommended you use direct insert. If there is
      # only one Oracle BI Server instance, then you may use flat file data.
      # The directory is then assumed relative to the process instance. For
      # example, "UTData" is resolved to 
      # "$(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent/<instance_name>/UTData
      STORAGE_DIRECTORY = "<directory path>";  
      CHECKPOINT_INTERVAL_MINUTES = 5;  
      FILE_ROLLOVER_INTERVAL_MINUTES = 30;  
      CODE_PAGE = "ANSI"; # ANSI, UTF8, 1252, etc.
      #
      #==============================================================================
      
      DIRECT_INSERT = YES;  
      
      #==============================================================================
      # Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
      #
      # Init-Block Tracking Options are commented out and and as a result disabled.
      # To enable Init-Block Tracking Feature, define the two parameters for
      # Init-Block, INIT_BLOCK_TABLE_NAME and INIT_BLOCK_CONNECTION_POOL.
      #
      PHYSICAL_TABLE_NAME = "DSL_SYSTEM_DB"."Usage_tracking"."S_NQ_ACCT" ;
      CONNECTION_POOL = "DSL_SYSTEM_DB"."Ora_bidw_connpoll_log";  
      INIT_BLOCK_TABLE_NAME = "DSL_SYSTEM_DB"."Usage_tracking"."S_NQ_INITBLOCK" ;
      INIT_BLOCK_CONNECTION_POOL = "DSL_SYSTEM_DB"."Ora_bidw_connpoll_log" ;
      BUFFER_SIZE = 250 MB;  
      BUFFER_TIME_LIMIT_SECONDS = 5;  
      NUM_INSERT_THREADS = 5;  
      MAX_INSERTS_PER_TRANSACTION = 5;  
      JOBQUEUE_SIZE_PER_INSERT_THREADPOOL_THREAD = 100; # default is 100 while 0 means unlimited.
      THROW_INSERT_WHEN_JOBQUEUE_FULL = NO; # Default is no.
      #
      #==============================================================================
      

       

      Any help is appreciated!