×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Jan 9, 2018 3:40 PM
Views: 2
Tags: no tags
  1. SELECT
  2.   TABLE_NAME,
  3.   tablespace_name,
  4.   STATUS,
  5.   pct_free,
  6.   ini_trans,
  7.   logging,
  8.   num_rows,
  9.   blocks,
  10.   degree,
  11.   instances,
  12.   last_analyzed,
  13.   partitioned,
  14.   compression,
  15.   compress_for,
  16.   has_identity,
  17.   (avg_row_len * num_rows) / (1024 * 1024) table_size_mb
  18. FROM user_tables
  19. ORDER BY TABLE_NAME;
  20.