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>