If some one ask you what is difference between dbms_stats and fnd_stats what you will say. If some one ask what is better to use when you are working with 11i. Don’t worry go through the following article and get it cleared.
Basically FND_STATS is specifically provided for 11i . As we will se DBMS_STATS is provided in database. Oracle recommends when you are working with 11i, you should use FND_STATS. As this is specially designed for 11i.
These are the main difference between these two:
1] FND_STATS is wrapper on the dbms_stats but if you are working with 11i it is better to use FND_STATS instead of DBMS_STATS.
2] FND_STATS can restart from the point where it stopped or failed. But in case of DBMS_STATS it is only provided on 10g.
3] FND_STATS is written for 11i application and it is not available outside. DBMS_STATS can be used in any application but it mostly used in RDBMS.
4] FND_STATS create histogram for application columns identified by Oracle. You can find information about these columns in FND_HISTTOGRAM_COLS table, but in case of dbms_stats you need to create it manually.
5] 115.10 further for FND_STATS, as it can gather stats for stale as well as empty stats. Also modification threshold can be changed from default 10% but in case of DBMS_STATS before 11g staleness threshold is fixed to 10%.
Stay tunned. I willbe comming some DMZ setups soon.
0 comments:
Post a Comment