首页 / MYSQL / OFA计算折旧运行慢
OFA计算折旧运行慢
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了OFA计算折旧运行慢,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2960字,纯文字阅读大概需要5分钟。
内容图文
OFA计算折旧运行慢R12.1 Depreciation Program (FADEPR) Running Slow Poor Performance (文档 ID 1361909.1) Applies to: Oracle Assets - Version 12.1.1 and later Information in this document applies to any platform. FADEPR - Depreciation Program
OFA计算折旧运行慢 R12.1 Depreciation Program (FADEPR) Running Slow Poor Performance (文档 ID 1361909.1)Applies to:
Oracle Assets - Version 12.1.1 and later
Information in this document applies to any platform.
FADEPR - Depreciation Program
***Checked for relevance on 30-Oct-2012***
Symptoms
Depreciation is not completing, running for 30 hours, expected it to complete within reasonable time.
Cause
select from fa_additions_b ad ,fa_asset_history ah ,fa_methods mt ,fa_deprn_summary ds , fa_books bk resulting in over 3 billion rows queried and 1200 rows returned.
Solution
To implement the solution, please execute the following steps:
1. For R12.1.x (R12.FA.B) Customers: Apply Patch 8706842:R12.FA.B
2. Have your DBA recreate the FA_BOOKS_N1 index as follows:
create index fa_books_n1 on fa_books(asset_id,book_type_code);
3. Then, have your DBA run "GATHER SCHEMA STATISTICS" program.
The following points provide some tips and suggestions which might help to reduce the overall runtime of the Depreciation Request Set.
1. Check the following profile options making sure they are NOT checked or enabled, as these can all affect performance:
FA: Deprn Single
FA: Print Debug
FA: Print Timing Diagnostics
FND: Debug Log Enabled
2. Check that you do not have the 'Trace' option checked on any of the concurrent programs in the Depreciation request set (Generate Accounts, Calculate Gains & Losses, Depreciation, Journal Entry Reserve Ledger Report).
You can check this in the Concurrent > Program > Define form, from the System Administrator responsibility.
3. Check the following profile options which can impact the performance:
FA: Security Profile
If this profile is set, it means that security is enabled for the responsibility and this should be expected to slow down the processing slightly.
FA: Number of Parallel Requests
You may wish to consider setting this profile to improve the performance. Please see the 'Oracle Assets Profile Options' Chapter in the Oracle Assets User Guide, for more information about this profile option.
4. Consider applying more recent code for any of the programs which seem to be taking the most time in the Depreciation Request Set. In particular, it is recommended to be on the latest FA rollup patch for your patchset level.
Refer to the following note for the latest rollup patch numbers:
Note 466607.1 : R12 / 11i FA.M-P RECOMMENDED PATCH LIST
5. Are all required init_SID.ora parameters set correctly according to the script in Note 174605.1?
在系统管理员职责下运行‘统计数据收集模式’请求后解决
6. Ensure you run 'Gather Statistics' for the FA Schema on a regular basis; particularly important after any big data load.
内容总结
以上是互联网集市为您收集整理的OFA计算折旧运行慢全部内容,希望文章能够帮你解决OFA计算折旧运行慢所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。
来源:【匿名】