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: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

Re: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 01 Oct 2002 22:27:27 +0200
Message-ID: <b71kpu88topi56qb4p4p3uvrid1kfu85ng@4ax.com> 





On 1 Oct 2002 18:27:50 GMT, Christopher Browne <cbbrowne_at_acm.org>
wrote:



>If 500 records get deleted, spread out across 50 pages, there might

>not be a single page that gets /totally/ emptied and thereby returned

>to the DBMS for general use.





an Oracle block will end up on the freelist when the usage falls below
PCTUSED. The PCTUSED can be changed, to reduce the wastage.



Regards




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Tue Oct 01 2002 - 15:27:27 CDT












Original text of this message













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