Shulou(Shulou.com)05/31 Report--

This article focuses on "how to view the collection of oracle statistics". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to view the collection of oracle statistics.

View statistics collection time:

Alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

Select t.TABLENAME from dba_tables t where owner='SAPSR3' and table_name in. NUMstudents ROWSMagazine t.BLOCKSnotet.LASTRANALYZED name t ('ZWD_JDMSG_GD','ZB2C_KUCUN_LOG')

Refresh database monitoring information:

Exec dbms_stats.flush_database_monitoring_info

Check whether the statistics are out of date (stats is yes is out of date)

Select owner,table_name,object_type,stale_stats,last_analyzed from dba_tab_statistics where owner='SAPSR3' and table_name in ('ZHLES_LOG_JPD','ZJHT0005_LOG')

View the reason for expiration:

Select table_owner,table_name,inserts,updates,deletes,timestamp from all_tab_modifications where table_owner='SAPSR3' and table_name in ('ZHLES_LOG_JPD','ZJHT0005_LOG')

Statistics collection:

Exec DBMS_STATS.GATHER_TABLE_STATS (ownname = > 'SAPSR3',tabname = >' ZWD_JDMSG_GD',estimate_percent = > DBMS_STATS.AUTO_SAMPLE_SIZE, method_opt = > 'for all columns size repeat',degree = > DBMS_STATS.AUTO_DEGREE,cascade= > TRUE)

At this point, I believe you have a deeper understanding of "how to view the collection of oracle statistics". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.