BIEE 设置好使用跟踪后，查询只有weblogic的数据

[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.

#

#==============================================================================