How to Gather Table Statistics in Oracle E-Business Suite
To gather Table level statistics in Oracle E-Business Suite, we can use the FND_STATS package.
exec fnd_stats.GATHER_TABLE_STATS( OWNNAME => 'INV', TABNAME=> 'MTL_ONHAND_QUANTITIES_DETAIL', PERCENT => 40, DEGREE => 4 );
To gather Table level statistics in Oracle E-Business Suite, we can use the FND_STATS package.
exec fnd_stats.GATHER_TABLE_STATS( OWNNAME => 'INV', TABNAME=> 'MTL_ONHAND_QUANTITIES_DETAIL', PERCENT => 40, DEGREE => 4 );
where , the parameter are as below:
OWNNAME --> Schema owning the table
TABNAME --> Name of the Table to be analyzed
PERCENT --> % of the data to be analyzed
DEGREE --> Degree of parallelism.
---
