甲骨文执行计划突变诊断之统计信息收集问题 - 行业资讯

<强> <强>

1。

DB version11.2.0.4

WITH SQL1 　　,(SELECT 漆, 　　,,,,,,,,, 　　,,,,,,,,TO_NUMBER (C.LONGITUDE),经度, 　　,,,,,,,,TO_NUMBER (C.LATITUDE),自由　　,才能得到MB_SYS_CELL_INFO C 　　,,WHERE C.CONTY_NAME =,“道孚县”), 　　SQL2 　　,(SELECT DISTINCT IMSI,虫胶,,CI 　　,才能得到MB_BSS_USER_LOCATION 　　,,WHERE HOUR 拷贝(16日,15日,14日,13) 　　,,,,以及TIME =, TO_TIMESTAMP(' 20170621 ', '名称')), 　　SQL3 　　,,,(SELECT C.LONGITUDE C.LATITUDE, WM_CONCAT (C.SITE_NAME),:域名　　,,,,得到(SELECT DISTINCT TO_NUMBER经度(A.LONGITUDE), 　　,,,,,,,,,,,,,,,,,,,,,,,,,TO_NUMBER (A.LATITUDE)纬度, 　　,,,,,,,,,,,,,,,,,,,,,,,,A.SITE_NAME 　　,,,,,,,,,,得到MB_SYS_CELL_INFO 　　,,,,,,,,,,WHERE A.CONTY_NAME =,“道孚县”),C 　　,,GROUP BY C.LONGITUDE, C.LATITUDE) 　　SELECT SQL1.LONGITUDELNG, 　　,,,,,,SQL1.LATITUDE 纬度, 　　,,,,,,计数(DISTINCT SQL2.IMSI),统计, 　　,,,,,,TO_CHAR (SQL3.SITE_NAME):域名　　,,得到SQL1, SQL2, SQL3 　　,WHERE SQL2.LAC =, SQL1.LAC 以及SQL2.CI =SQL1.CI 以及SQL1.LONGITUDE =, SQL3.LONGITUDE 以及SQL1.LATITUDE =, SQL3.LATITUDEGROUP BY SQL1.LONGITUDE,, SQL1.LATITUDE,, TO_CHAR (SQL3.SITE_NAME), ORDER BY COUNTDESC;

SQLSQL, SQL

V $ TEMPSEG_USAGE

SELECTsession_num,,用户名,segtype,,块,表空间　　FROMV TEMPSEG_USAGE美元;

V $ SORT_SEGMENT

选择(s.tot_used_blocks/f.total_blocks) * 100, as pctused 　　从(SELECT 和(used_blocks), tot_used_blocks 　　FROMV SORT_SEGMENT美元　　WHEREtablespace_name=傲偈薄?,, 　　(SELECTSUM(块),total_blocks 　　FROMDBA_TEMP_FILES 　　WHEREtablespace_name=傲偈薄?,f;

SQL64Gexhaust

MB_BSS_USER_LOCATIONauto维护

select client_name, statusfrom dba_autotask_client;

2。

<强> <强>

2.1

select table_name,, partition_name, last_analyzed,, STATTYPE_LOCKED fromuser_tab_statistics 　　,where table_name =,“MB_BSS_USER_LOCATION”; 　　STATTYPE_LOCKED VARCHAR2 (5), Type ofstatistics 锁: 　　■,数据　　■,缓存　　■,所有

last_analyzed STATTYPE_LOCKED

select 计数(distinct table_name), fromuser_tab_statistics where stattype_locked is not 零; 98

2.2

完成,exec dbms_stats.gather_table_stats (ownname =祝辞,GZ_SAFETY, tabname=祝辞MB_BSS_USER_LOCATION,,力=祝辞真实); 　　PL/SQL proceduresuccessfully 完成了

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 　　|,Id ,, |, Operation ,,,,,,,,,,,,,,,,,,,, |, Name ,,,,,,,,,,,,,,,, |, Rows ,,, |, Bytes ,,, |, Cost , |, Time ,,, | 　　-------------------------------------------------------------------------------------------------------- 　　|,,,,0,|,SELECT STATEMENT ,,,,,,,,,,,,, |,,,,,,,,,,,,,,,,,,,,,, |,,,,,, 16, |,,,, 32608, |, 41343, |, 00:08:17 | 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null 　　null