ITPub博客

Don't use package DBMS_STATS to do that, using FND_STATS is a good command.Also,don't use the ANALYZE command.Eg.Use the following command to gather schema statistics: exec fnd_stats.gather_schema_statistics('PO') exec fnd_stats.gather_schema_statistics('ALL')Use the following command for gathering statistics on a temporary table(ie: temporary tablename = temp1 in schema INV): exec fnd_stats.gather_table_stats('INV','temp1');[@more@]

My last blog article was posted one year ago here,it's coincidence that I logged in my blog today.It is a whole year which flied quickly,here I have to say really SORRY to the visitors who came to my blog with hope and left with nothing new.In the past one year,I spent more time enjoying my life with my family,reserching some new technologies on oracle.Some got,some lost......Tomorrow is nice and I'm ready to go,here I made a promise that I'd like to bring lots of new and valueable articles on d