appl用户需要整理的文件夹:
$COMMON_TOP/admin/log/SID_HOST/*
$COMMON_TOP/admin/out/SID_HOST/*
$APPL_TOP/admin/SID/log
$APPL_TOP/admin/SID/out
/usr/tmp
$IAS_ORACLE_HOME/Apache/Apache/logs
$IAS_ORACLE_HOME/Apache/Jserv/logs
$OA_HTML/cabo/images/cache/us (根据安装和使用的语言)
ora用户需要整理的文件夹:
$COMMON_TOP/temp (看utl_file_dir 的定义和使用,也可能是 $ORACLE_HOME/appsutil/outbound/ SID_HOST)
$ORACLE_HOME/admin/SID_HOST/bdump
$ORACLE_HOME/admin/SID_HOST/udump
应用管理员需要清理的应用系统记录:
Purge Concurrent Request and/or Manager Data
Purge Debug Log and System Alerts
Purge Diagnostic and Log Messages
Purge FND_STATS History Records
Purge Obsolete Generic File Manager Data
Purge Obsolete Workflow Runtime Data
Purge Rule Executions
Purge Signon Audit data
Purge Workflow Runtime Data for Cloning
Purge Concurrent Processing setup data for cloning
应用系统内的各个模块也分别有需要清理的记录:
Purge Consolidation Audit Data (GL)
Purge RX Interface Data (FA)
Purge accounting tables (FA)
Purge Dimension Interface Tables (BIS)
Purge Fact Interface Tables (BIS)
Purge Request Set Generator History Tables (BIS)
Purge Report Listings (AP)
Purge Purchasing Open Interface Processed Data (PO)
Purge System Saved Requisition (PO)
本文转自ITPUB博客tolywang的博客,原文链接:EBS应用临时文件或数据的清理,如需转载请自行联系原博主。