Oracle9i - Table Sizes2

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Oracle9i - Table Sizes2 as PDF for free.

More details

  • Words: 32
  • Pages: 1
sql> select segment_name,bytes/1024/1024 as mb, segment_type 2 from user_segments 3 where segment_name like 'z%' and segment_type='table' and bytes >10737418240; segment_name -------------------------------------------------------------------------------mb segment_type ---------- -----------------zilphdr 27684 table zpayhc 16381 table zarixbc35 30291 table

Related Documents