Search from 700 + Posts

Apr 26, 2013

Query to get Interesting details about tables


Query to get Interesting details about tables



  select table_name, tablespace_name, num_rows, blocks,
       round((blocks *
              (select value from v$parameter where name = 'db_block_size')
                 )/1000000,1)||'M' as SIZEB
from dba_tables
where table_name in
      ('OE_ORDER_LINES_ALL',
       'OE_ORDER_HEADERS_ALL',
       'OE_PRICE_ADJUSTMENTS',
       'OE_PROCESSING_MSGS',
       'OE_PROCESSING_MSGS_TL',
       'WSH_EXCEPTIONS',
       'WF_ITEM_ACTIVITY_STATUSES',
       'WF_PROCESS_ACTIVITIES',
       'WF_ITEMS')
order by 1;

No comments:

Post a Comment