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: HELP ! ! ! temp tablespace

Re: HELP ! ! ! temp tablespace

From: kyle hailey <oraperf_at_yahoo.com>
Date: Fri, 23 Feb 2001 23:21:06 -0800
Message-ID: <r5oe9tcq73anvnng54dpeptrm031e6hgln@4ax.com> 






To speed up the process you could try reducing your



    db_block_buffers



to as small as you can to get the database open, 100 or so. At least
in v7 this made a huge difference in dropping tons of extents because
alot of the work had to do with verifying blocks that were in the
buffer cache against the extents being dropped.  



Kyle Hailey
Received on Sat Feb 24 2001 - 01:21:06 CST












Original text of this message













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