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>

Related examples in the same category

1.	query table_name, tablespace_name from user_tables
2.	Query a table in user_table by table_name
3.	Query user_tables for the table just created
4.	To get a listing of all tables that you own
5.	User_tables structure
6.	Get table name and table space for a table by its name
7.	alter table emp move tablespace users and then check the result by querying user_tables
8.	Create sql statements from user_tables

Verify the creation of the statistics by running the following queries: : USER_TABLES « System Tables Views « Oracle PL / SQL

Related examples in the same category