Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tablespace and Segment Frag.

Tablespace and Segment Frag.

From: Software Administrator <sanjeev_at_pacbell.net>
Date: Wed, 22 Jul 1998 22:37:51 -0700
Message-ID: <35B6CC2F.4AB5@pacbell.net> 





Hello all,



  What is the quick and easy way to find out fragmentation for TB and
its segments. I have been told to see two views.



For Tablespace 


   DBA_FREE_SPACE


For Segments


   DBA_SEGMENTS



What columns and values will tell if there is a fragmentation.



Any help will help....



Thanks,


Sanjeev
Received on Thu Jul 23 1998 - 00:37:51 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US