什么时候会产生临时文件?
展现层服务器 OBIPS (sawserver):
1、缓存
2、导出分析或者仪表盘
3、打印(比如打印pdf)
3、渲染图形(通过javahost)
4、查看报表
5、渲染HTML页面
目录位置:ORACLE_INSTANCE/tmp/OracleBIPresentationServicesComponent/coreapplication_obipsX/xxxxx
例如:
[ORACLE_INSTANCE]tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/sawcharts/saw51ef32e4_2-2.tmp
[ORACLE_INSTANCE]tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/sawcharts/saw51ef32e4_2-1.tmp
[ORACLE_INSTANCE]tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/querycache_1/saw51ef32e5_5-1.tmp
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/dxe
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/querycache_0
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/querycache_1/saw5178bdb1_5-1.tmp
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/querycache_2
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/querycache_3
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/sawrptcache
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/sawvc
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/saw51d4f1e9_1-6.tmp
[ORACLE_INSTANCE]/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/86mZXlsWfEYFmcWYBQgQpwhash.tmp
BI Server (nqsserver)
1、缓存
2、排序
3、Union /跨库查询
目录位置:ORACLE_INSTANCE/tmp/OracleBIServerComponent/coreapplication_obisn/temp
例如:
[ORACLE_INSTANCE]/tmp/OracleBIServerComponent/coreapplication_obis1/obis_temp/nQS_Xml_8821_334_50005153.TMP
[ORACLE_INSTANCE]/tmp/OracleBIServerComponent/coreapplication_obis1/obis_temp/nQS_Xml_8821_339_50005237.TMP
[ORACLE_INSTANCE]/tmp/OracleBIServerComponent/coreapplication_obis1/obis_temp/nQS_Xml_8821_343_50005628.TMP
[ORACLE_INSTANCE]/tmp/OracleBIServerComponent/coreapplication_obis1/obis_temp/nQS_Xml_8821_332_50004623.TMP
对于开户了全局缓存的集群环境来说, *.TBL是本地缓存文件,*.DES是全局缓存文件.
大家可以根据自己的需要调动临时文件的目录,比较好的建议是将它们放到读写速度较快的设备上,然后创建一个指向默认的路径的软链接即可。