Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Verify the creation of the statistics by running the following queries

SQL> SQL> SELECT table_name FROM user_tables WHERE last_analyzed IS NULL; TABLE_NAME ------------------------------ WORKING_EMPLOYEES TEMP_TABLE EMPLOYEETEMPTABLE TMP PARMS WORKING_CUSTOMERS CUST_WITH_VARRAY_TEMP_TABLE 7 rows selected. SQL> SQL> SELECT index_name FROM user_indexes WHERE last_analyzed IS NULL; INDEX_NAME ------------------------------ SYS_C004799 SYS_C008156 HD_CLUSTER_INDEX 3 rows selected. SQL>