Performance - EBS (MOSC)

MOSC Banner

fnd_stats or dbms_stats

edited Mar 1, 2018 1:31PM in Performance - EBS (MOSC) 14 commentsAnswered
 Hi All,

I have one doubt.

We have oracle apps database. Usually we used to run fnd_stats on seeded oracle apps tables like (gl_ge_lines,oe_order_lines_all etc.). and dbms_stats on custom tables. Suppose, i copied seeded apps tables  via CTAS or imp/exp into custom schema.

so, what i have to run, fnd_stats or dbms_stats? if fnd_stats, then how oracle apps decide on data? If dbms_stats why?

What will be the impact if run fnd_stats on custom table which is created.

This is doubt which i want to clear.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center