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: truncate partition table causes high latch free

Re: truncate partition table causes high latch free

From: Andreas Piesk <a.piesk_at_gmx.net>
Date: 11 Apr 2006 13:45:17 -0700
Message-ID: <1144788317.081567.144700@i40g2000cwc.googlegroups.com> 





we had some difficulties with 'truncate partition' too. first,


'truncate partition' seemed to lock the whole table during the

truncate. second, all parsed statements accessing the table were
invalidated.


we have circumvented the problem by implementing a rolling window using


'drop partition' and 'split partition'. works a lot better. haven't

found time to further investigate the issue, maybe it's a bug, maybe
it's by design.



regards,


-ap
Received on Tue Apr 11 2006 - 15:45:17 CDT












Original text of this message













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