Wednesday, July 24, 2013

When was a schema analyzed last?


When was a schema analyzed last?

SELECT owner,
  table_name,
  TO_CHAR(last_analyzed,'dd-mon-yyyy hh24:mi:ss') last_analyzed,
  column_name,
  data_type,
  num_distinct,
  density,
  num_nulls,
  sample_size,
  avg_col_len
FROM dba_tab_columns
WHERE owner='SOE'  -- change this with the schema name you want to know about

No comments:

Post a Comment