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

Home -> Community -> Mailing Lists -> Oracle-L -> Required to know the Empty Blocks of a Index

Required to know the Empty Blocks of a Index

From: Dash, Saroj (CAP,CEF) <Saroj.Dash_at_gecapital.com>
Date: Wed, 20 Dec 2000 18:12:48 +0900
Message-Id: <10716.124993@fatcity.com> 





In a query I found the total no of blocks used ,total size
,minextents,maxextents ,empty blocks of  a table.



But In index i am unable to find free / Empty blocks .



but i find leaf blovks ,avg no. of leaf blocks .



Please tell me how can I found free or empty  blocks of a Index.



Regards,


Saroj.
Received on Wed Dec 20 2000 - 03:12:48 CST












Original text of this message













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