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 -> Which dict. table stores the Block usage details for every segment (w/o. analyze table/index) ?

Which dict. table stores the Block usage details for every segment (w/o. analyze table/index) ?

From: Mehul Zaveri <mehulzaveri_at_hotmail.com>
Date: Tue, 21 Sep 1999 11:06:21 +0400
Message-ID: <7s7ag5$6c28@news.emirates.net.ae> 





Hai all,


Can we find out w/o. using analyze command, exact block usage of segment?
Based on output, we can make decision of reorganizing BIG tables. Any ideas?



Kind regards,


Mehul Zaveri,


Oracle DBA



Received on Tue Sep 21 1999 - 02:06:21 CDT












Original text of this message













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