ITKeyword,专注技术干货聚合推荐

注册 | 登录

How to solve performance issue while inquiring material transaction distribution?

kevingao 分享于 2010-06-18

推荐:How To : APC - Seeing Performance Issue While Saving Item But Update Actually Saves

    APC - Seeing Performance Issue While Saving Item But Update Actually Saves [ID 758383.1]     Modified 26-DEC-2008     Type HOWTO     Status MODERA

2020阿里云最低价产品入口,含代金券(新老用户有优惠),
地址https://www.aliyun.com/minisite/goods

FORM "Find Material Transaction Distributions"
While we find transaction, query was too slow.

 

To run 'Gather Statistics'

The concurrent program can be run from the System Administrator Responsibility to generate statistics. To run this program:
1. Log on to Oracle Applications with the System Administrator responsibility.
2. Navigate to the Submit Request Window which is under the Navigation List Request > Run.
3. Submit the gather schema statistics program.
4. Enter the appropriate parameters. This can be run for specific schemas by specifying the schema name or entering 'ALL' to gather statistics for every schema in the databaGather Schema Statistics se.
5. Ensure there are no other concurrent jobs running at the time, else those jobs might complete with errors.

 

4月份以前查询1个月的数据只需几分钟,5月份以后需要1个多小时。运行并发请求“Gather Schema Statistics ”后查询1个月的数据不到1分钟。问题解决。经常运行这个并发请求可以改善EBS性能。

FORM "Find Material Transaction Distributions" While we find transaction, query was too slow.   To run 'Gather Statistics' The concurrent program can be run from the System Adminis

相关阅读排行


相关内容推荐

最新文章

×

×

请激活账号

为了能正常使用评论、编辑功能及以后陆续为用户提供的其他产品,请激活账号。

您的注册邮箱: 修改

重新发送激活邮件 进入我的邮箱

如果您没有收到激活邮件,请注意检查垃圾箱。