Query to find Table size

Query to find Table size
Oracle apps EBS table size

  SELECT owner, table_name, TRUNC (SUM (bytes) / 1024 / 1024) MB
    FROM (SELECT segment_name table_name, owner, bytes
            FROM dba_segments
           WHERE segment_type IN ('TABLE', 'TABLE PARTITION')
          UNION ALL
          SELECT i.table_name, i.owner, s.bytes
            FROM dba_indexes i, dba_segments s
           WHERE     s.segment_name = i.index_name
                 AND s.owner = i.owner
                 AND s.segment_type IN ('INDEX', 'INDEX PARTITION')
          UNION ALL
          SELECT l.table_name, l.owner, s.bytes
            FROM dba_lobs l, dba_segments s
           WHERE     s.segment_name = l.segment_name
                 AND s.owner = l.owner
                 AND s.segment_type IN ('LOBSEGMENT', 'LOB PARTITION')
          UNION ALL
          SELECT l.table_name, l.owner, s.bytes
            FROM dba_lobs l, dba_segments s
           WHERE     s.segment_name = l.index_name
                 AND s.owner = l.owner
                 AND s.segment_type = 'LOBINDEX')
   WHERE owner IN UPPER ('ONT')                              --Table Owner Name
                              AND table_name = 'OE_ORDER_LINES_ALL' --Table Name
GROUP BY table_name, owner

Related posts:

• View java class source in oracle database
• Load Java source code in oracle database
• Query to find and remove Oracle database locks
• PL-SQL code to write a file
• PL-SQL code to read a file
• Query to find second and third highest value
• PL-SQL Procedure to send email with attachment
• Query to get the details of the lock in the database
• Query to find Table size

Upload your own post and refer it anywhere anytime: