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





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