quarta-feira, 29 de maio de 2013

Limpando o cache no OBIEE11G

Clear cache in OBIEE11G

/u01/app/oracle/product/Middleware/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/bi-init.sh

/u01/app/oracle/product/Middleware/Oracle_BI1/bifoundation/server/bin/nqcmd -d AnalyticsWeb -u weblogic -p PASSWORD -s /u01/app/oracle/product/Middleware/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/purgecache.txt

purgecache.txt:

For all:
Call SAPurgeAllCache()

For especific table:
Call SAPurgeCacheByTable( 'Biminfin - Físico', '', 'BIMINFIN','TB_FAT_0_CAD_DESPESA' );

0 comentários: