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 -> Make Table/Index Analyse Run Faster

Make Table/Index Analyse Run Faster

From: Rob Risetto <robr_at_powerup.com.au>
Date: 2000/03/24
Message-ID: <38dabe38@grissom>#1/1 






Hi,



I'm migrating a PeopleSoft db from v7... to v8.0.6 and would like to cut
down the time for the table/index analyse. One option would be to break up
the individual analyse statements into separate files and run  them
simultaneously. Are there any gotchas with this approach - system table
locks etc. Any other tips or techniques.



thanks


Rob Risetto
Received on Fri Mar 24 2000 - 00:00:00 CST












Original text of this message













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