Oracle Gather Table Stats - dbms_stats
Oracle Applications 11i utilizes the Cost-Based optimizer, so it is important that the database has current statistics for all tables and indexes. Oracle provides a set of utilities to be used to gather statistics on a regular basis. These tools are:
Concurrent Programs: “Gather Schema Stats” and “Gather Table Stats”
Package: FND_STATS
The concurrent programs call the FND_STATS package to gather statistics...
Read the full article
1 comment:
I loved your article eventhough I m not a computer sciences student.
keep up wth the good work.
Post a Comment