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 -> Re: Heavy I/O on Index File System

Re: Heavy I/O on Index File System

From: aviion <member_at_dbforums.com>
Date: 27 Nov 2001 13:12:30 -0500
Message-ID: <3c03d78e@usenetgateway.com> 





You need to check the index fragmentaion, if the height/blevel is 4 or
more than , yes it would help.But than it means



    
  
  1.   You have some indexes on columns which are involved in bunch of
   deletes and updates, check the requirement of those indexes.







--
Posted via dBforums
http://dbforums.com


Received on Tue Nov 27 2001 - 12:12:30 CST












Original text of this message













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