Dear bosses, do want to collect the next interface table statistics, use the syntax is analyze table tinf_accoinfo_zq compute statistics for table, oracle environment, but the collection is not successful, do not know why, who can help to solve, thank you very much

CodePudding user response:

How do you know the collection is not successful?

In addition: use dbms_stats. Gather_table_stats process, don't use analyze command,

CodePudding user response:

Listen to 1/f, with dbms_stats this package,

CodePudding user response:

reference 1st floor minsic78 response:

how do you know the collection is not successful?

Also: use dbms_stats. Gather_table_stats process, don't use the analyze command,

well, use process can be, whether user_tables can see collection of success

CodePudding user response:

Select table_name, last_analyzed from user_tables where table_name="MYTABLE '

Last collection time, if it's the time, it is to collect the success,