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